[Suggestions] Forums

Antoniojps Level 1

March 13, 2013, 8:00 pm

Write the reason you're deleting this FAQ

[Suggestions] Forums

Hello SEOClerks team, here's the thing, you guys are for sure aware that there might some scammers here...by scammers I mean, people who pro mess a certain service and either do not do as promised or do not satisfy the costumer. Anyways I know there is a feedback section for each seller and their services but I believe there should be a general discussion forum and a scammers/reports section here on the forums...this would make the forums more active + more usefull for the community so that every member could easily know who is not satisfying there costumers.

For example, a guy promisses 20,000 followers on twitter, he does the service, but after a single week this followers go down to 10,000...the costumer has already provided positive feedback...but he is for sure not satisfied.

Anyways, here's the two sections you should implement to the "SEOClerks" forum:

General Discussion

Here you can discuss anything related to SEOClerks activities

Report a seller

Have you been scammed, are you not satisfied? This is where to report that seller!

Comments

Please login or sign up to leave a comment

Join

Sean101

Both of those type of sections are available...
- The Pub - (Can Talk About Anything)
- Callout - (Can Report / Tell Others About Bad Gigs & Members)

13 years ago

Are you sure you want to delete this post?

Tommy Matalino

For example, a guy promisses 20,000 followers on twitter, he does the service, but after a single week this followers go down to 10,000...the costumer has already provided positive feedback...but he is for sure not satisfied.

On your example, it's easy to say that it's something that can't easily be done, using real accounts of course. And since there's a big burst of followers, your account will definitely raise a red flag on Twitter and may end up getting suspended.

I know it's a little bit off topic but such offers are a little bit unrealistic in my point of view. And people can easily prevent getting scammed if they stay away on similar offers.

13 years ago

Are you sure you want to delete this post?

ionicware

Both of those type of sections are available...
- The Pub - (Can Talk About Anything)
- Callout - (Can Report / Tell Others About Bad Gigs & Members)

In addition, we ban all fraudulent sellers we find on the spot so please submit them via helpdesk. The most common fraudulent seller is one that marks an order as delivered when nothing has been done and then asks the buyer to wait, "because it will be completed soon". This is simply a ploy to get buyers to wait until it auto-completes.

Reject delivered work and report ASAP if this happens.

13 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.883890	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (23,48,53,103) AND gtags like'%Xxx%' AND type !=99	0.883890	0.883890
0.110387	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Yawn%') ORDER BY total_recommendations desc LIMIT 0,40	0.110387	0.110387

SEOClerks

[Suggestions] Forums

[Suggestions] Forums

Comments

Please login or sign up to leave a comment

Sean101

Tommy Matalino

ionicware

Invalid SQL

Expensive SQL

Suspicious SQL

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='12363'	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='12363'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='34843'	1	SELECT * FROM seoclerks.members WHERE USERID='34843'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='39'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='39'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=34843	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=34843	/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=12363 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=12363 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12363' 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='12363' 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=58720 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=58720 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=58721 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=58721 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=58722 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=58722 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='12363'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='12363'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='12363' AND status='1' AND (question like '%[Suggestions] Forums%' OR question like '%[Suggestions]%' OR question like '%Forums%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12363' AND status='1' AND (question like '%[Suggestions] Forums%' OR question like '%[Suggestions]%' OR question like '%Forums%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='18151' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='18151' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
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='1323' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17847' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17847' 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=12363%' 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=12363%' 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.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='43.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='43.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='1.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png'	/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()