Website Feature and Vulnerability

LifetimeDibs Level 1

March 26, 2015, 10:22 am

Write the reason you're deleting this FAQ

Website Feature and Vulnerability

Hey everyone. Yes I understand my profile says I am still a new member here but I believe I have a lot to contribute to the community. I and a few other people have had some problems with a service that is currently featured on the homepage of SEOClerks.com the service is listed by the AJLANCER - Here is a link to the service that brought this website feature and vulnerability into question.

The Falsely Advertised Service: https://www.seoclerks.com/Traffic/...-web-site-for-30
This Service is Falsely Advertised In These Ways:

100% Real Human Traffic (This is 100% False, traffic is generated by a popular traffic exchange website)
UNLIMITED Real (This is False, it is not unlimited and it is not real)
Ever Cheapest (This is obviously not the cheapest traffic service on SEOClerks)
100% Positive Rating (This is again obviously False)
Says Service is Staff Certified (This is False, Staff Member Jordan Removed Certification)

AJLANCER even blatantly lies in the listing saying that not bot or software of any kind is used to GENERATE the traffic. Even so much so to say that you should not buy the service if you want fake traffic because they only deliver real traffic.

THE RECOMMENDATION FOR FEATURES AND WEBSITE FLAWS:

As mentioned above I have been in contact with Staff Member Jordan. The certification for this listing as Staff Recommended has been removed. Staff Member Jordan commented that this was an old feature on the website and the seller might have been delivering quality traffic at one point in time.

The feature and flaw is that I and other people have cancelled their orders with AJLANCER in order to get our wasted $29 back after AJLANCER scammed and ripped us off. I can go on and on about that lack of quality and communication and late delivery and falsely advertised service but the point was that after all this I wanted to leave my feedback or review of the service received. However, once any buyer cancels and order, in order to get a refund, they are no longer entitled to leave a review the quality of services and customer service delivered to them from any seller in question, not just AJLANCER.

I expressed my concerns to Staff Member Jordan about the matter and he said that when people cancel an order, in order to get a refund, for services not delivered or any reason, that that buyer is no longer allowed to leave a reviews. He said this is to prevent sellers from getting negative reviews when they have a "Bad Experience" with a buyer. I explained how this was flawed and how it could be fixed.

Here are my thoughts:

Buyers should be able to leave a review for any service they buy regardless of if they receive a refund or not.
Sellers should handle themselves in such a way that even when they have a "bad experience" with a buyer that they should not be worried about a negative review.
Reviews are meant to be honest and unbiased. Otherwise you defeat the purpose of the review
I asked that this feature of the website be looked at and revamped
I would like to see a feature similar to Amazon where you can look at everyone's reviews, positive and negative. I find this to be extremely helpful and informative.

Staff Member Jordan advised me that I should take to the forums so I told him I would be posting this with a poll question on your thoughts. Please vote and leave your comments or feedback (I promise you're allowed to leave your review even if you disagree with me) I asked Staff Member Jordan to help out and Sticky this post so that the community as a whole could weigh in on the subject matter. Please understand this is not a personal attack on AJLANCER but rather an important subject matter, about the website, to look into.

Comments

Please login or sign up to leave a comment

Join

hardplayhosting

Hello, I get your point but, as a seller I can tell you that there is other sellers that only want to give you a bad reputation, they just buy, we complete the order and gives a bad review, but when you look at the buyers service, THEY SELL THE SAME SERVICE THEY BOUGHT, so it's kinda mesed up if you look at that way.

11 years ago

Are you sure you want to delete this post?

LifetimeDibs

Hello, I get your point but, as a seller I can tell you that there is other sellers that only want to give you a bad reputation, they just buy, we complete the order and gives a bad review, but when you look at the buyers service, THEY SELL THE SAME SERVICE THEY BOUGHT, so it's kinda mesed up if you look at that way.

Yes, and that is why the site has moderators and admins. Why continue to let shady stuff like this happen on SEOClerks?

11 years ago

Are you sure you want to delete this post?

Corzhens

Oh well, I guess this issue has been settled with the banning of selling Facebook likes and followers that I think selling traffic is also banned. But anyway, moderators of this site should be on the lookout for scammers because it can hurt the brand of the site particularly with the business side since this is like a market. Sellers should now be screened and buyers should report issues and problems.

8 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.095895	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%profilelinks%') ORDER BY total_recommendations desc LIMIT 0,40	0.095895	0.095895

SEOClerks

Website Feature and Vulnerability

Website Feature and Vulnerability

Comments

Please login or sign up to leave a comment

hardplayhosting

LifetimeDibs

Corzhens

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='12278'	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='12278'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='311317'	1	SELECT * FROM seoclerks.members WHERE USERID='311317'	/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=311317	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=311317	/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=12278 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=12278 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12278' 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='12278' 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=58016 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=58016 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=58017 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=58017 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=164319 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=164319 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='12278'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='12278'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='12278' AND status='1' AND (question like '%Website Feature Vulnerability%' OR question like '%Website%' OR question like '%Feature%' OR question like '%Vulnerability%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='12278' AND status='1' AND (question like '%Website Feature Vulnerability%' OR question like '%Website%' OR question like '%Feature%' OR question like '%Vulnerability%') -- 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='147' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='337' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='337' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='231' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='231' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2637' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2637' 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=12278%' 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=12278%' 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='131651.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='131651.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='311317.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='311317.jpg'	/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()