Hi, Previously there was a option called "Mark as soldout". So I was able to pause any particular service. But in new theme it gone. Is there any option in new theme to stop any particalur service. Regards, Ka...
Recently I received 2 Affilite sale from my one Affiliate member. In my user level section it's showing Affiliate Sales: 2 but Unique Affiliate Sales: 0 My question is. How do I get Unique Affiliate Sales? Also ...
Can a buyer modify his feedback? I mean suppose after the order complete, the buyer posted positive review. After few days the buyer somehow intended to change that order to negative review. Is that possible?
If I send too many mutual cancellation requests to my buyers, will it be any negative effect in my rating.
One of my buyer was no issue with the order, but he gave me thumbs down saying only "thank you" I think he was full satisfy with my job but clicked mistakenly thumbs down. I contacted him but I am worried if he never co...
I will go for vacation after few days. So I will be unavailable at that time. Is there any option I can pause my services?
I am unable to send my buyer multiple files. I don't want to send in .rar or .zip format. Is there any option to send multiple files without .rar or .zip?
Recently one of my buyer misunderstood my Gig description so he sent me mutual cancellation request. I am curious that this may effect in my Gig rating & will stop coming new orders...
I am providing organic SEO service since 2008 (6 years). I just joined SEOClerks 2 months ago & became Level 3 seller today. It's a big achievement for me. Feeling Happy . I am just trying to give my best & quali...
Yipee!! I got a good news today..I became "Junior Member" from "new member"...Feeling Happy seoclerks rocks!! ;)
One of my buyer recently asked me for sample report of my Gig. But I don't understand how do I send him the sample report privately. I don't find any option to send him private message.. Please advice!!!
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='kash2u' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='kash2u' 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=226993 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=226993 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=226993 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=226993
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='226993' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='226993' | /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 |