SEOClerks

Clear
Sign In Join

user level query

  • neteater Level 1
    • 8

    Write the reason you're deleting this FAQ

    user level query

    hi,

    i am not if it was previously asked, as per info given on site, to become level 2 seller one must have 10/b/s/a, so what does this actually means

    1- total 30 service done in b/s/a
    1- total should be 10 of mix of services,

    in my case i have like 8 affiliate sale
    5 service sale
    and some service bought.

    am i going to be eligible for level two after my first withdrawal.

    # SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    anwebservices

    anwebservices

    b/s/a means Buyer / Seller / Affiliate. Just carefully read page about levels and all will be clear. Also be aware that you will need at list one payout at list 20 days old...

    All level upgrades are automatic, so you will not stay behind for sure user level query

    Good luck
    11 years ago

    Are you sure you want to delete this post?

    andreasjordan

    andreasjordan

    I think you can't combine them? YOu need to chose seller, buyer, or affiliate..
    Right?
    11 years ago

    Are you sure you want to delete this post?

    neteater

    neteater

    I think you can't combine them? YOu need to chose seller, buyer, or affiliate..
    Right?

    that's what i wanted to know.waiting for staff reply.
    11 years ago

    Are you sure you want to delete this post?

    Kashif4k

    Kashif4k

    When logged in, click the User Levels link at the footer of this page. This will show you not only user level details but also indicate your classification as a B/S/A and your progress.

    If you have made most sales as an affiliate then your account will be classified as A and upgrades will be based on that classification.

    For example I have made more sales as a seller i.e 10 and only made 1 unique sale as an affiliate so my account is classified as S i.e. seller account.
    11 years ago

    Are you sure you want to delete this post?

    jabed92

    jabed92

    Pls read this & you will get all things about user level... Pls https://www.seoclerk.com/userlevels/
    11 years ago

    Are you sure you want to delete this post?

    neteater

    neteater

    my problem is i am equally buying/selling/affiliating, however my classification say i am seller, and i believe user level are mainly for seller and affiliates, as these two needs to withdraw money and also need to build repo.
    When logged in, click the User Levels link at the footer of this page. This will show you not only user level details but also indicate your classification as a B/S/A and your progress.

    If you have made most sales as an affiliate then your account will be classified as A and upgrades will be based on that classification.

    For example I have made more sales as a seller i.e 10 and only made 1 unique sale as an affiliate so my account is classified as S i.e. seller account.
    11 years ago

    Are you sure you want to delete this post?

    anwebservices

    anwebservices

    If your classification says that you are seller, then your leveling up depend on number of sales and withdraw!
    I have seen Level X3 member without single sale and 0% seller feedback but he/she is very frequent buyer.

    In your case it depend mostly on sales, so good luck.

    To get more sales, search forum for some tutorials. Visit WTB section often and submit some bids where you can quickly generate more sales and get more positive feedbacks...
    11 years ago

    Are you sure you want to delete this post?

    chetaseo

    chetaseo

    anwebservices, nice response from you. you are really doing a great job here. well done bro. i feel you my brother. i have gained alot from your comments in thsi forum.
    11 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.28180885314941

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='11802'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='11802'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='98521'1SELECT * FROM seoclerks.members WHERE USERID='98521'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=985211SELECT googleplus_profile FROM seoclerks.members WHERE USERID=98521

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11802 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=11802 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11802' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='11802' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53813 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53813 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53814 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53814 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53815 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53815 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53816 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53816 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53817 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53817 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53818 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53818 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53819 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53819 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53820 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=53820 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='11802'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='11802'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='11802' AND status='1' AND (question like '%user level query%' OR question like '%user%' OR question like '%level%' OR question like '%query%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='11802' AND status='1' AND (question like '%user level query%' OR question like '%user%' OR question like '%level%' OR question like '%query%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='3250' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='2077' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='1628' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1628' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='3861' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3861' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='3764' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1

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

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=11802%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=11802%' 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='254580.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg'

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

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

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

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

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

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

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

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

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

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

    		/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
    0.6379771SELECT 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 (37) AND gtags like'%rate%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.6379770.637977