eziscript
Level 1
Write the reason you're deleting this FAQ
Hi Everyone!
I have open a WTB on Seoclerk, the problem is seller want 100% upfront this project takes around 45 days? and i can see in SEOCLERK once someone deliver something even its not final product in 5 days order mark as complete!
So i am curious how to stop this happen? because i want this project to done and than bidder take their money?
Thanks,
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='20438' | 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='20438' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='23245' | 1 | SELECT * FROM seoclerks.members WHERE USERID='23245' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=23245 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=23245 | /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=20438 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=20438
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20438' 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='20438' 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=111352 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=111352
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=111353 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=111353
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=111375 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=111375
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20438' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20438' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20438' AND status='1' AND (question like '%How WTB Bid & Order Work?%' OR question like '%&%' OR question like '%Order%' OR question like '%Work?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20438' AND status='1'
AND (question like '%How WTB Bid & Order Work?%' OR question like '%&%' OR question like '%Order%' OR question like '%Work?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2800' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2800' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3290' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3290' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4206' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4206' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3881' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3881' 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=20438%' 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=20438%'
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='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /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 |
hitmeasap
All payments should be made through SEOClerks and upfront payments to the seller is not allowed. When you order a service you'll always have to pay the amount for the service, however, that doesn't mean that the seller gets the money. - SEOClerks will hold the money until the service has been delivered and upon completion of the service, SEOClerks will release the money to the seller. - That basically means that the buyer always pay whatever the cost is, but the seller won't receive the money until the order is finished.
All that being said, you might be talking about a service that has a delivery of let's say 5 days but it won't be delivered in full until 30 days for instance. Traffic services for instance are usually like that. In these scenarios you'll have to go with "your guts" and find a reliable seller. Recommendations and previous ratings are a good indicator. Even response time might be worth to take a look at.
In case something should go wrong, and you as a buyer paid for the service, marked the service as complete and you DON'T get the full delivery after 30 days. Then you'll have 3 options. Either talk to the seller and notify them about this. Invoke the guarantee in case the seller offers one or you can contact SEOClerks support about this issue and they'll work with you to solve this.
Best Regards,
hitmeasap Hello eziscript, All payments should be made through SEOClerks and upfront payments to the seller is not allowed. When you order a service you'll always have to pay the amount for the service, however, that doesn't mean that the seller gets the money. - SEOClerks will hold the money until the service has been delivered and upon completion of the service, SEOClerks will release the money to the seller. - That basically means that the buyer always pay whatever the cost is, but the seller won't receive the money until the order is finished. All that being said, you might be talking about a service that has a delivery of let's say 5 days but it won't be delivered in full until 30 days for instance. Traffic services for instance are usually like that. In these scenarios you'll have to go with "your guts" and find a reliable seller. Recommendations and previous ratings are a good indicator. Even response time might be worth to take a look at. In case something should go wrong, and you as a buyer paid for the service, marked the service as complete and you DON'T get the full delivery after 30 days. Then you'll have 3 options. Either talk to the seller and notify them about this. Invoke the guarantee in case the seller offers one or you can contact SEOClerks support about this issue and they'll work with you to solve this. Best Regards, hitmeasap
Are you sure you want to delete this post?