usmanaliakhtar
Level 3
Write the reason you're deleting this FAQ
hello, anyone can you tell me how I can increase my level ? my level still level3 how I can go up?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='28265' | 1 | SELECT 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='28265' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='23131' | 1 | SELECT * FROM seoclerks.members WHERE USERID='23131' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=23131 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=23131 | /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=28265 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=28265
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28265' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT 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='28265' 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=186567 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=186567
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=186586 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=186586
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=186587 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=186587
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28265' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28265' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28265' AND status='1' AND (question like '%how i level ?%' OR question like '%level%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28265' AND status='1'
AND (question like '%how i level ?%' OR question like '%level%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='4987' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT 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 1 | 1 | SELECT 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='337' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='337' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3524' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3524' 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=28265%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=28265%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='558687.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='558687.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='573178.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='573178.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
NiyaziSEO
Sellers/buyers/affiliates who are dedicated, provide great quality, great services, deliver on time and maintain this great quality automatically earn these level enhancements.
Note: Upgrades to user levels are automatic. Please wait at least 20 minutes before entering a ticket about user level promotions if you have not been promoted yet.
S = Seller Requirement
B = Buyer Requirement
A = Affiliate Requirement
How is response time calculated?Response time is calculated by the amount of time it takes you (as a seller) to respond to any comment or update to an order for the last 30 days. This calculation does notinclude your inbox, only the messages within orders.
What is a unique affiliate sale?A unique affiliate sale is one (1) purchase from one (1) affiliate. The same affiliate could purchase several more services or items but it would still produce only one unique sale. You need 25 affiliates to purchase at least 1 service to have 25 unique affiliate sales.
Level 1
Everyone starts out at Level 1. This is the base level and requires no effort.
Limitations
- Can't create services for less than $1
- Can't create Coupons that lower a service price more than $1
- Longer clearance period for funds
- Can't create instant downloads
- Can't create subscription services
- Withdrawals may go under review, resulting in longer waiting
- Withdrawals have a minimum of $15
Level 2Level 2 users are getting serious and earning serious money. To obtain a level two status:
Requirements
- SBA Completed/Purchased/Affiliated 10 orders on time
- SBA Have no infractions (follow the rules)
- SBA Your email must be verified
- SBA You must associate a phone number with your account
- SBA Login often (once per 14 days)
- SBA Account is at least 7 days old
- SBA First completed sale/purchase/affiliate sale is at least 30 days old
- SB Have a 90% rating or higher
- S Completed one payment withdrawal that is 20 days old
- S 72 hour or less response time
Benefits- Can create services for more than $125 (no upper limit)
- Payment 4 days after order completion
- Can create instant downloads
- Can create subscription services
- Ability to delete public comments on services
- Larger instant withdraw Limit
- Withdraw 20 times per 31 days
- Withdraw as little as $10
- Customizable public profile
Level 3Level 3 users are amazing users that command respect.
Requirements
- SBA Completed 25 orders/purchases/affiliate Sales on time
- SBA Have no infractions (follow the rules)
- SBA Login very often (once per 7 days)
- SBA First completed sale is at least 60 days old
- SBA You must verify your physical address
- SB Have a 90% rating or higher
- S 72 Hour or less response time
Benefits- Payment one day after order completion
- Can create instant downloads
- Can create subscription services
- Withdraw 30 times per 31 days
- Withdraw as little as $5
Level 4Level 4 users are above average.
Requirements
- SBA You must be an affiliate
- SBA Completed 100 Orders/Purchases
- SB Must have 50 unique affiliate sales
- SBA Have no Infractions (follow the rules)
- SBA Login Very Often (once per 7 days)
- SB Have a 95% rating or higher
- S 48 Hour or less response time
Benefits- Earn 1% extra on all sales
- Earn 1% extra on all affiliate sales
- Can send a status update with email every 3 days
- Withdraw 60 times per 31 days
Level 5Level 5 users are exceptional.
Requirements
- SBA You must be an affiliate
- SBA Completed 250 Orders/Purchases
- SB Must have 100 unique affiliate sales
- SBA Have no Infractions (follow the rules)
- SBA Login Very Often (once per 7 days)
- SB Have a 97% rating or higher
- S 24 Hour or less response time
Benefits- Earn 2% extra on all sales
- Earn 2% extra on all affiliate sales
- Can send a status update with email every 2 days
- Free highlight feature upon request
- Withdraw 100 times per 31 days
Level XX level users are the elite. This group of users is manually selected by the staff of SEOClerks.
Requirements
- Must be Level 3 or greater
- Should be an affiliate
- Should have social pages representing you here
- Must get noticed by Staff
Benefits- All benefits of level 1-3
- Cannot be demoted automatically
- Highest priority tickets and staff guidelines/restrictions that prevent your account from being restricted in any way.
- Withdraw 999 times per 31 days
- Ability to obtain X4 and X5 (Level 4 and 5 benefits)
Level UpRank up as a buyer, seller or an affiliate. A higher level has beneficial rewards such as decreased clearance time for payments, creating recurring orders, cash back and more! Sellers/buyers/affiliates who are dedicated, provide great quality, great services, deliver on time and maintain this great quality automatically earn these level enhancements. Note: Upgrades to user levels are automatic. Please wait at least 20 minutes before entering a ticket about user level promotions if you have not been promoted yet. S = Seller Requirement B = Buyer Requirement A = Affiliate Requirement How is response time calculated?Response time is calculated by the amount of time it takes you (as a seller) to respond to any comment or update to an order for the last 30 days. This calculation [i]does not[/i]include your inbox, only the messages within orders. What is a unique affiliate sale?A unique affiliate sale is one (1) purchase from one (1) affiliate. The same affiliate could purchase several more services or items but it would still produce only one unique sale. You need 25 affiliates to purchase at least 1 service to have 25 unique affiliate sales. [b]Level 1 [/b]Everyone starts out at Level 1. This is the base level and requires no effort. Limitations[list][*]Can't create services for less than $1[/*][*]Can't create Coupons that lower a service price more than $1[/*][*]Longer clearance period for funds[/*][*]Can't create instant downloads[/*][*]Can't create subscription services[/*][*]Withdrawals may go under review, resulting in longer waiting[/*][*]Withdrawals have a minimum of $15[/*][/list][b]Level 2 [/b] Level 2 users are getting serious and earning serious money. To obtain a level two status: Requirements[list][*]SBA Completed/Purchased/Affiliated 10 orders on time[/*][*]SBA Have no infractions (follow the rules)[/*][*]SBA Your email must be verified[/*][*]SBA You must [url=https://www.seoclerk.com/settings/security]associate a phone number[/url] with your account[/*][*]SBA Login often (once per 14 days)[/*][*]SBA Account is at least 7 days old[/*][*]SBA First completed sale/purchase/affiliate sale is at least 30 days old[/*][*]SB Have a 90% rating or higher[/*][*]S Completed one payment withdrawal that is 20 days old[/*][*]S 72 hour or less response time[/*][/list]Benefits[list][*]Can create services for more than $125 (no upper limit)[/*][*]Payment 4 days after order completion[/*][*]Can create instant downloads[/*][*]Can create subscription services[/*][*]Ability to delete public comments on services[/*][*]Larger instant withdraw Limit[/*][*]Withdraw 20 times per 31 days[/*][*]Withdraw as little as $10[/*][*]Customizable public profile[/*][/list][b]Level 3 [/b] Level 3 users are amazing users that command respect. Requirements[list][*]SBA Completed 25 orders/purchases/affiliate Sales on time[/*][*]SBA Have no infractions (follow the rules)[/*][*]SBA Login very often (once per 7 days)[/*][*]SBA First completed sale is at least 60 days old[/*][*]SBA You must [url=https://www.seoclerk.com/settings/security]verify your physical address[/url][/*][*]SB Have a 90% rating or higher[/*][*]S 72 Hour or less response time[/*][/list]Benefits[list][*]Payment one day after order completion[/*][*]Can create instant downloads[/*][*]Can create subscription services[/*][*]Withdraw 30 times per 31 days[/*][*]Withdraw as little as $5[/*][/list][b]Level 4 [/b] Level 4 users are above average. Requirements[list][*]SBA You must be an affiliate[/*][*]SBA Completed 100 Orders/Purchases[/*][*]SB Must have 50 unique affiliate sales[/*][*]SBA Have no Infractions (follow the rules)[/*][*]SBA Login Very Often (once per 7 days)[/*][*]SB Have a 95% rating or higher[/*][*]S 48 Hour or less response time[/*][/list]Benefits[list][*]Earn 1% extra on all sales[/*][*]Earn 1% extra on all affiliate sales[/*][*]Can send a status update with email every 3 days[/*][*]Withdraw 60 times per 31 days[/*][/list][b]Level 5 [/b] Level 5 users are exceptional. Requirements[list][*]SBA You must be an affiliate[/*][*]SBA Completed 250 Orders/Purchases[/*][*]SB Must have 100 unique affiliate sales[/*][*]SBA Have no Infractions (follow the rules)[/*][*]SBA Login Very Often (once per 7 days)[/*][*]SB Have a 97% rating or higher[/*][*]S 24 Hour or less response time[/*][/list]Benefits[list][*]Earn 2% extra on all sales[/*][*]Earn 2% extra on all affiliate sales[/*][*]Can send a status update with email every 2 days[/*][*]Free highlight feature upon request[/*][*]Withdraw 100 times per 31 days[/*][/list][b]Level X [/b] X level users are the elite. This group of users is manually selected by the staff of SEOClerks. Requirements[list][*]Must be Level 3 or greater[/*][*]Should be an affiliate[/*][*]Should have social pages representing you here[/*][*]Must get noticed by Staff[/*][/list]Benefits[list][*]All benefits of level 1-3[/*][*]Cannot be demoted automatically[/*][*]Highest priority tickets and staff guidelines/restrictions that prevent your account from being restricted in any way.[/*][*]Withdraw 999 times per 31 days[/*][*]Ability to obtain X4 and X5 (Level 4 and 5 benefits)[/*][/list]Are you sure you want to delete this post?