ajlancer
Level X3
Write the reason you're deleting this FAQ
Hi I have suggestion about rating as buyer. Now we can see only rating percentage as buyer. But I think it will more better if in public profile show how many positive or negative rating has as buyer as like seller rating.
For example:
Now show as like below:
Seller Rating of 99.8%
100.0% Buyer Rating
Thumbs up 2,569 and thumbs down 1 (it is now only for seller)
>But my suggestion is just add another stat for buyer
Seller Rating of 99.9%
98.0% Buyer Rating
Thumbs up 2,400 and thumbs down 1 (it is now only for seller)
Thumbs up 50 and thumbs down 2 (it is have to have for buyer)
And user flag now only show in profile section. But my suggestion, if this flag will show in order section beside user name in small droop menu. It will look more convenient to identity for user where he from?
I think above both suggestions Admin will consider.
Hello ajlancer,
I like the idea personally. You can see how many positive reviews and negative reviews that we get as sellers, but what about those who are buyers? We don't know their reputation except for a number. I mean, if a buyer has 1 UP and 1 DOWN, they will be at a 50% which will turn sellers away because they will be worried. Now if we can see that they only have 2 ratings, then we might be more lenient about providing a service to them. Somebody who has a 1 UP / 1 DOWN rating is more likely to get a service done prior to a user who has 50 UP / 50 DOWN. But I do agree with your idea!
Regards,
Jadster
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='12563' | 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='12563' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='4987' | 1 | SELECT * FROM seoclerks.members WHERE USERID='4987' | /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=4987 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4987 | /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=12563 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=12563
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12563' 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='12563' 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=59778 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=59778
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=59779 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=59779
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12563' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='12563' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='12563' AND status='1' AND (question like '%positive negative rating buyer user flag small droop menu have%' OR question like '%positive%' OR question like '%negative%' OR question like '%rating%' OR question like '%buyer%' OR question like '%user%' OR question like '%flag%' OR question like '%small%' OR question like '%droop%' OR question like '%menu%' OR question like '%have%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='12563' AND status='1'
AND (question like '%positive negative rating buyer user flag small droop menu have%' OR question like '%positive%' OR question like '%negative%' OR question like '%rating%' OR question like '%buyer%' OR question like '%user%' OR question like '%flag%' OR question like '%small%' OR question like '%droop%' OR question like '%menu%' OR question like '%have%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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='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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=12563%' 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=12563%'
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='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.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 |
Jadster
I like the idea personally. You can see how many positive reviews and negative reviews that we get as sellers, but what about those who are buyers? We don't know their reputation except for a number. I mean, if a buyer has 1 UP and 1 DOWN, they will be at a 50% which will turn sellers away because they will be worried. Now if we can see that they only have 2 ratings, then we might be more lenient about providing a service to them. Somebody who has a 1 UP / 1 DOWN rating is more likely to get a service done prior to a user who has 50 UP / 50 DOWN. But I do agree with your idea!
Regards,
Jadster Hello ajlancer, I like the idea personally. You can see how many positive reviews and negative reviews that we get as sellers, but what about those who are buyers? We don't know their reputation except for a number. I mean, if a buyer has 1 UP and 1 DOWN, they will be at a 50% which will turn sellers away because they will be worried. Now if we can see that they only have 2 ratings, then we might be more lenient about providing a service to them. Somebody who has a 1 UP / 1 DOWN rating is more likely to get a service done prior to a user who has 50 UP / 50 DOWN. But I do agree with your idea! Regards, Jadster
Are you sure you want to delete this post?