OptimismSEO
Level 1
Write the reason you're deleting this FAQ
Last month, I got a message from a buyer saying that he has a list of forums and I just need to register on each of these forums. His rate was 1$ for 10 forum registrations. At first, I didn’t agree because it seems like a lot of work and also he said all the forums must have the username, password and mail address with Gmail recovery all in just 3 days. And during that time, I already have more than 10 orders in progress. Then again, he sent another message, and now it was 5 days from 3 and I agreed.
Deciding on the price, which I was not sure about it, I decided to check the marketplace here and no one was offering this service, it seems legit and good opportunity for me also what really caught my attention is that the buyer was able to convince me, not all buyers can convince me also he mentioned about a long term basis job after this one, overall a continual job.
So, I finished the work within 3 days, but I could only register for 86 forums out of 150 links he gave me, rest where all invalid links and some other languages that I couldn’t even translate. Also in while I was doing the work, I had mentioned that I cannot guarantee the approval of registry as it might up to weeks, so once he agreed then only I continued.
After a very long message to the buyer, regarding the problems and why I could only manage to register 80 forums, I asked him to change the links, with the valid ones, overall asked for new 20 links, so that I can complete the service on what we have both agree on, which was 100 forums. Surprisingly, he agreed for 86 forums only, I had delivered the order and asked him to change the passports with a very long disclaimer notice. And also the buyer gave me positive rating.
After completion, I didn’t get any more order from him and just yesterday when I was going through some profile, and one really caught my attention because this seller was also offering the forum register service, so now I know there is someone else offering the same service that I only had offered before.
What I felt bad about is that it was the same buyer from Pakistan who ordered me and made such promises. So, he ordered this service to the other seller, maybe he also asked him to create a service like this, as he asked me before.
In this marketplace, we the sellers we try to deliver each order as we’ve promised, but in this case, it is the buyer who couldn't keep the promise he made.
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='22263' | 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='22263' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='541270' | 1 | SELECT * FROM seoclerks.members WHERE USERID='541270' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=541270 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=541270 | /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=22263 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=22263
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22263' 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='22263' 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=116284 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=116284
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=116285 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=116285
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=170334 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=170334
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22263' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22263' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22263' AND status='1' AND (question like '%fulfil promise made%' OR question like '%fulfil%' OR question like '%promise%' OR question like '%made%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22263' AND status='1'
AND (question like '%fulfil promise made%' OR question like '%fulfil%' OR question like '%promise%' OR question like '%made%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='272' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2044' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2044' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='10228' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='10228' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='14585' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='14585' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='21811' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='21811' 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=22263%' 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=22263%'
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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='4225.gif' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4225.gif' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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 |
idealmike
It sounds like he was looking for a service he could buy but then sell for himself? Lots of people do that, they pose a the buyer of said services, they push you to do the work at a low rate and then when you do, they think, hmmm I could sell this as a service, buy it from you cheap, but then sell it for lots more. And people do do that.
But that's why I'll never provide a service for less than it's actually worth. I'll never work for peanuts when my work is guaranteed and I do a good job of it. And that's why you shouldn't either. Never devalue your work by providing it for less than the going rate. Ah the old "[b]do a good job and I'll have lots of work for you and wish to work with you for a long time[/b]" chestnut eh! :D That one's as old as the book of tricks it was taken from! I've had that one used on my many times before by people. They say yeah, I'm looking for a long term provider. Then they order or they have already ordered and then you do a good job for them, even giving them a bonus. They they go AWOL on you and don't ever order again. Or when they do order, a whole season has passed lol It sounds like he was looking for a service he could buy but then sell for himself? Lots of people do that, they pose a the buyer of said services, they push you to do the work at a low rate and then when you do, they think, hmmm I could sell this as a service, buy it from you cheap, but then sell it for lots more. And people do do that. But that's why I'll never provide a service for less than it's actually worth. I'll never work for peanuts when my work is guaranteed and I do a good job of it. And that's why you shouldn't either. Never devalue your work by providing it for less than the going rate.
Are you sure you want to delete this post?