Hello! As I'm sure you all know, there is a new feature to email all your followers. This is a very useful feature, because you can let your followers know of a sale, or a new service, or something they might be interest...
Hello everyone! I know I've been inactive for a while, I've just been busy with some personal stuff, but I'm back! I will not be releasing as many tutorials as before and I may not even do any video tutorials because the...
Hey guys! This tutorial is going to be on creating an instant download service. Have you ever wanted to sell your customers digital items without all the hassle that comes with it? Well, with the SEOClerks Instant Downlo...
Hello SEOClerks users! Today's tutorial is going to be on Subscriptions and how they work. Are you a level 2 user or over? Have you been wondering what that little Subscriptions option is on your services? This tutorial ...
This is a tutorial on how to reject an order. This tutorial is for sellers. The text and video tutorials are posted below. Text + Pictures: First thing you must do is wait until your buyer responds to your instructi...
Hi! This tutorial is going to be on what coupons are and how to use them. This applies to both sellers and buyers, so be sure to read my instructions carefully so as not to get confused. Coupons are used for giving your ...
Hey guys! This is the main thread for the Tutorials section. It will contain a list of all the tutorials to date, all updates that you might want to know about, and much more. I'm Kutzki, and I run the Tutorials sectio...
Hello! This is a tutorial on how to reject a guaranteed services. Guaranteed services are services in which the sellers make a guarantee. For example: a guarantee that they will complete the order within 24 hours, a guar...
Hello! This is a tutorial on how to reject an order. This tutorial is for buyers. The text and video tutorials are posted below. Text + Pictures: First thing you must do after you have ordered the service is respond...
I was looking at the user levels, and to get to level 2 you have to have "Completed 10 Orders on time". What exactly does this mean? Does the money have to be cleared of the account, or as soon as I complete 10 orders , ...
It says that Instant Downloads are disabled for level 1 members, but why is there still an option to upload files? I don't understand?
| 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='kutzki' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='kutzki' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| 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.userid=4022 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.userid=4022 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.userid=4022 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 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.userid=4022
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' | 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='4022' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4022' | /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 |
