Hey.. When someone buys one of my gigs, does this then bump my gig to the top of the list in that category? I know that editing my gig after a while can bump it, but does a purchase bump it too?
How can I incraese my earning on seoclerks?
Yesterday I saw a gig that was spam but had no way of reporting it. What do I do when I find one?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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 seoclerks.members WHERE username='backlinker11' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='backlinker11' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| SELECT * FROM answers WHERE userid=3831 | 1 | SELECT distinct quesid FROM answers WHERE userid=3831 | /opt/clerks-staging/docroot/faq.php 258 () () |
| 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.quesid IN (609,601,595,608,651,639,643,737,726,725,719,718,710,727,689,661,690,677,675,630,765,766,764,763,750,747,767,762,756,753,769,758,752,664,703,712,707,653,592,683,559,650,558,768,553,555,709,546,640,589,542,772,775,998,982,1818) LIMIT 1 | 1 | SELECT 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.quesid IN (609,601,595,608,651,639,643,737,726,725,719,718,710,727,689,661,690,677,675,630,765,766,764,763,750,747,767,762,756,753,769,758,752,664,703,712,707,653,592,683,559,650,558,768,553,555,709,546,640,589,542,772,775,998,982,1818) 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.quesid IN (609,601,595,608,651,639,643,737,726,725,719,718,710,727,689,661,690,677,675,630,765,766,764,763,750,747,767,762,756,753,769,758,752,664,703,712,707,653,592,683,559,650,558,768,553,555,709,546,640,589,542,772,775,998,982,1818) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 40 | 1 | SELECT 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.quesid IN (609,601,595,608,651,639,643,737,726,725,719,718,710,727,689,661,690,677,675,630,765,766,764,763,750,747,767,762,756,753,769,758,752,664,703,712,707,653,592,683,559,650,558,768,553,555,709,546,640,589,542,772,775,998,982,1818)
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' | 1 | SELECT 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' | 1 | SELECT 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 | 1 | SELECT 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 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='1856' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1856' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='5628' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5628' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='30' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='30' | /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 |
