SEOClerks

Clear
Sign In Join

Discussions about user levels

Date Hot Date (old to new)
Unanswered Votes
Showing page: 1 of 1
Start a discussion

Must have 50 unique affiliate sales ? Answered

for level 4 SEOclerks need some rules or conditions to be fulfilled. but the condition for level 4 there is one condition is "Must have 50 unique affiliate sales" I didn't get this can anyone tell me help me. please....

  • AliTechseo
    AliTechseo Level 1
    • 3 6 years ago

    I want to reach to Level 4 but i don't know how Answered

    I want anybody to explain me in brief to level up my account to Level 4 Thank You

  • KingSangam26
    KingSangam26 Level 1
    • 2 6 years ago

    Orders for address verified Level 2 sellers Answered

    Hello all... Could you please let us know the advantages of verifying address and does address verified sellers get more orders? We have moved to level 2 and have verified our address as well. Any inputs and suggestion...

  • telugumirchy
    telugumirchy Level 1
    • 2 7 years ago

    Do i need to confirm my physical address to get to level 4? Answered

    Hi Guys, hope you are doing well. I just want to ask you something, do i need to confirm my physical address in order to get to level 4? Thanks in advance. Loretta.

  • LorettaWhitby
    LorettaWhitby Level 3
    • 6 7 years ago

    what are the benefits in level 3? Answered

    can any one say what are the benefits in the level 3?????

  • rebels
    rebels Level 1
    • 5 13 years ago

    what are the requirements to go to level X?? Answered

    what are the conditions and requirements to go to level X??and what is the use?

  • rebels
    rebels Level 1
    • 4 13 years ago

    what are the conditions to go to level 3?? Answered

    what are the conditions to go to level 3??can anybody tell me....

  • rebels
    rebels Level 1
    • 6 13 years ago

    what are the conditions to go to level 2?? Answered

    what are the conditions to go to level 2??and i want to know the use also...

  • rebels
    rebels Level 1
    • 3 13 years ago

    I dont understand 1 thing in the user level upgrade to level 2? Answered

    Requirements Completed 10 Orders on time Have a 90% rating or higher Answered or asked 20 SEO Questions in the FAQ Have no Infractions (follow the rules) Login Often (once per 14 days) Account is at least 7 days C...

  • ServiceKing
    ServiceKing Level 1
    • 2 13 years ago

    how can i increase by userlevels? Answered

    can anyone tell me how can i increase by userlevels in seoclerks...?

  • sowj
    sowj Level 1
    • 5 13 years ago

    Order Now
    Process Time: 0.11998009681702

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% user levels %' OR A.tags LIKE 'user levels %' OR A.tags LIKE '% user levels' OR A.tags='user levels') LIMIT 11SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% user levels %' OR A.tags LIKE 'user levels %' OR A.tags LIKE '% user levels' OR A.tags='user levels') LIMIT 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% user levels %' OR A.tags LIKE 'user levels %' OR A.tags LIKE '% user levels' OR A.tags='user levels') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 401SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% user levels %' OR A.tags LIKE 'user levels %' OR A.tags LIKE '% user levels' OR A.tags='user levels') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * from questions as A where A.status='1' 1SELECT count(A.quesid) as total from questions as A where A.status='1'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM answers as A where A.status='1' 1SELECT count(A.ansid) as total FROM answers as A where A.status='1'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='791622'1SELECT profilepicture FROM seoclerks.members WHERE USERID='791622'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='840555'1SELECT profilepicture FROM seoclerks.members WHERE USERID='840555'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='776842'1SELECT profilepicture FROM seoclerks.members WHERE USERID='776842'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='658119'1SELECT profilepicture FROM seoclerks.members WHERE USERID='658119'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='40009'1SELECT profilepicture FROM seoclerks.members WHERE USERID='40009'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='39006'1SELECT profilepicture FROM seoclerks.members WHERE USERID='39006'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='9299'1SELECT profilepicture FROM seoclerks.members WHERE USERID='9299'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    5.9692881SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (42,64,90) AND gtags like'%JPG%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 405.9692885.969288
    0.4716261SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (16) AND gtags like'%Websitetoexcel%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4716260.471626
    0.4001551SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (31) AND gtags like'%profiles%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4001550.400155
    0.1213761SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%LAMP%') ORDER BY total_recommendations desc LIMIT 0,400.1213760.121376
    0.1145281SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%VOICE%') ORDER BY total_recommendations desc LIMIT 0,400.1145280.114528
    0.1114161SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%55555%') ORDER BY total_recommendations desc LIMIT 0,400.1114160.111416
    0.0860001SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%55555%') 0.0860000.086000