Write the reason you're deleting this FAQ
Hello admin, I have been a keen Visitor of the freelancer section. All the time when I see, there are lot of Sellers who have response time more than a day are ranked in the top. I guess, based on the recommendations he earned the ranking is done. One thing I want to tell about it -
The Seller may get a lot of Positive Feedback for what he is doing if it is upto the mark or the Buyer is not frustrated with it. It is not uncommon to get lot of recommendations if the seller is earning a lot of feedbacks, what I'm saying is a lot of reputations will make them[buyers] do so. My Question is: "What's the point in it when the Seller is good at something and earned a Rank and not responding to the messages/orders in time ?? In that case the Buyer has to wait a lot of time to open the conversation, so he will feel that the Seller is a normal like others, doesn't matter even he is Top Rated.
So, my opinion is that all the ranking should be done keeping in mind the Response time and the feedback as well. Final thing, based on the performance of the Level X Sellers, at the end of the week he/she can be awarded with some 3 categories viz "Rising Star, Sparkling Star, All Stars" [Im not good at naming
] like that. It may be helpful for Buyers to identify the active ones and will boost up the efficiency of the Level X Sellers.
Thanks for Reading, if you find this appropriate and practically applicable - field test it and implement it !
- SEOfreak
sorry..Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Hello admin, I have been a keen Visitor of the freelancer section. All the time when I see, there are lot of Sellers who have response time more than a day are ranked in the top. I guess, based on the recommendations he earned the ranking is done. One thing I want to tell about it -
The Seller may get a lot of Positive Feedback for what he is doing if it is upto the mark or the Buyer is not frustrated with it. It is not uncommon to get lot of recommendations if the seller is earning a lot of feedbacks, what I'm saying is a lot of reputations will make them[buyers] do so. My Question is: "What's the point in it when the Seller is good at something and earned a Rank and not responding to the messages/orders in time ?? In that case the Buyer has to wait a lot of time to open the conversation, so he will feel that the Seller is a normal like others, doesn't matter even he is Top Rated.
So, my opinion is that all the ranking should be done keeping in mind the Response time and the feedback as well. Final thing, based on the performance of the Level X Sellers, at the end of the week he/she can be awarded with some 3 categories viz "Rising Star, Sparkling Star, All Stars" [Im not good at naming] like that. It may be helpful for Buyers to identify the active ones and will boost up the efficiency of the Level X Sellers.
Thanks for Reading, if you find this appropriate and practically applicable - field test it and implement it !
- SEOfreak
[quote]Hello admin, I have been a keen Visitor of the freelancer section. All the time when I see, there are lot of Sellers who have response time more than a day are ranked in the top. I guess, based on the recommendations he earned the ranking is done. One thing I want to tell about it -
The Seller may get a lot of Positive Feedback for what he is doing if it is upto the mark or the Buyer is not frustrated with it. It is not uncommon to get lot of recommendations if the seller is earning a lot of feedbacks, what I'm saying is a lot of reputations will make them[buyers] do so. My Question is: "What's the point in it when the Seller is good at something and earned a Rank and not responding to the messages/orders in time ?? In that case the Buyer has to wait a lot of time to open the conversation, so he will feel that the Seller is a normal like others, doesn't matter even he is Top Rated.
So, my opinion is that all the ranking should be done keeping in mind the Response time and the feedback as well. Final thing, based on the performance of the Level X Sellers, at the end of the week he/she can be awarded with some 3 categories viz "Rising Star, Sparkling Star, All Stars" [Im not good at naming:(] like that. It may be helpful for Buyers to identify the active ones and will boost up the efficiency of the Level X Sellers.
Thanks for Reading, if you find this appropriate and practically applicable - field test it and implement it !
[B]- SEOfreak[/B][/quote]
I like the idea of the star system, but it would be pointless for Level X Sellers. They're level X for a very good reason. They're reliable, and trustworthy sellers, which in turn means that they would probably end up getting the stars anyways just because of their skill and experience. :P
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| 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='12468' | 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='12468' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='48593' | 1 | SELECT * FROM seoclerks.members WHERE USERID='48593' | /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=48593 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=48593 | /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=12468 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=12468
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12468' 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='12468' 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=59261 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=59261
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=59262 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=59262
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=59263 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=59263
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=59264 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=59264
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=59265 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=59265
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=59266 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=59266
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=59267 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=59267
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=59268 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=59268
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=59269 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=59269
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12468' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='12468' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='12468' AND status='1' AND (question like '%Rank Freelancers Response time Feedback%' OR question like '%Rank%' OR question like '%Freelancers%' OR question like '%Response%' OR question like '%time%' OR question like '%Feedback%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='12468' AND status='1'
AND (question like '%Rank Freelancers Response time Feedback%' OR question like '%Rank%' OR question like '%Freelancers%' OR question like '%Response%' OR question like '%time%' OR question like '%Feedback%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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=12468%' 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=12468%'
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='23112.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='23112.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='40054.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='40054.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='48593.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='48593.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| 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='4022.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4022.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='1593.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1593.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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
sunil0021
- Sunil Bishnoi Good idea :) [B]- [U]Sunil Bishnoi[/U][/B]
Are you sure you want to delete this post?