Trader Ratings v1.2.0

Trader Ratings - A user feedback hack
Copyright ?2004 Jason Rabel, All Rights Reserved.
__________________________________
Latest TR Verson: 1.2.0
vB Versions: 3.0.0 - 3.0.9
Author: Jason Rabel
Contact: PM me here, I'll respond.
Site: EXTREME Overclocking
??????????????????????????????????

Updates:
??????????????????????????????????
1.2.0 - September 4, 2004
- Added Trader Ratings Stats Page (finally!)
- Added PM notification when someone receives feedback
- Changed how positive feedback percentage score is calculated (bugfix)
- Ability to "close" the Trader Ratings pages (for maintainence or whatever) - TRATING_CLOSED
- Ability to set the URL field when submitting feedback to required or optional - TRATING_REQ_URL

1.1.0 - June 7, 2004
- Added time-based user edit/delete abilities, set via TRATING_UEDIT constant in traderratings.php file
- Userdate field is now an int field to be consistent with vBulletin
- Userrating field changed to tinyint to save space
- Fixed timeframes for showing historical ratings
- Made some various code consolidation
- Added missing ".TABLE_PREFIX." statement
- Templates.txt file shows code for postbit & MEMBERINFO, with conditional examples
- All 3 templates changed heavily
- Added some more phrases & fixed missing phrases

1.0.1 - June 2, 2004
- Fixed a "divide by zero" display error
- Postbit template fixed so guests do not have a trader rating

1.0.0 - June 1, 2004
- Initial Public Release

Description:
??????????????????????????????????
Trader Ratings has evolved from my vB2 Buy/Sell/Trade User Rating System. This is a rating system for when members buy / sell / trade items from each other (presumably on a FS section of your forum). It is based on the honor system since there is no way to truly tell if they did engage in a transaction. (But I'm working on a way to fix that.) Trader Ratings came about because it was a pain to try and maintain a single thread listing good / bad traders and so far has worked out quite well.

Features:
??????????????????????????????????
? Rate another member: Positive / Negative / Neutral
? Specify Buyer, Seller, or Trade
? Leave comments about the deal
? Records date when rating created
? Specify a URL to the deal
? Display ratings over time
? Filter based on Buyer/Seller/Trade/or feedback they left for others
? Users can edit/delete ratings left for others (time based limitation)
? Admins & Mods can edit/delete anyone's ratings (just incase)
? Stats page showing best & worst rated members, and recent ratings
? PM notification when a person is rated

Basic Info:
??????????????????????????????????
I haven't written a FAQ or any real documentation yet, but the way the system works is very simple. The only part that might confuse someone is that the Feedback Score is based only on UNIQUE members. Also, there are simple checks in place to make sure they actually do select proper info and enter a comment. A user is not able to rate themself (obviously). Permissions for viewing / rating are similar to standard forum viewing / posting permissions. Also it checks to make sure users exist and all that good stuff.

Installation Info:
??????????????????????????????????
This hack is very simply to implement requiring only:
? 1 new file
? 5 new templates / 2-3 template changes (navbar, posbit/postbit_legacy, MEMBERINFO, memberlist_resultsbit)
? 52 new phrases
? 1 new DB table / 1 table DB change & index

An install/upgrade PHP file is included to do all the template/phrase/DB stuff, so basically you run that, upload the file, and edit your postbit template. BAM!

Screen Shots / Demos:
??????????????????????????????????
See Screenshots below, or you can view them on my forums: My Trader Rating Page

Standard Disclaimer:
??????????????????????????????????
BACKUP YOUR DATABASE & FILES BEFORE IMPLEMENTING THIS HACK!!!

Forums Using This Hack:
??????????????????????????????????
EXTREME Overclocking Forums
i-Club -- Forums
Accord Tuner
NSX Prime
Honda-Acura.net
Guns Network
PimpRig

(PM me your forum if you want me to add you to the list)

Donations:
??????????????????????????????????
This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you.


Plans For Future Releases:
??????????????????????????????????
? rebuttal / followup comments
? item description (possibly instead of thread url)
? button on thread that buyer/seller clicks to tie the transaction to two people

[sketch42]

Originally Posted by Spinball

Jason I have a feature request which would be useful for us. If there were an option available within the trade rating screen to moderator/supermod/admin folks which allows all negative feedback to be listed then it would be easy to see whether some users have been 'spoiling' others' reputation without good cause.

why only negative... i can see ppl make up fake accnts and give themselves positive feedback... which is why i still hold that the showthread should be mandatory..

o and thank you spinball i edited the install file and everything worked great!!

[lifesourcerec]

If you want the thread URL to be mandatory,

In traderratings.php, find:

PHP Code:

if ($userbuysell == 255 || $userrate == 255 || $usercomments == '') { 


Replace with:

PHP Code:

if ($userbuysell == 255 || $userrate == 255 || $usercomments == '' || $userurl == "") { 


Then modify the phrase tratings_thread_url and removed the "(optional)" text.

--- Thanks to Jason for the code.

[sketch42]

Originally Posted by lifesourcerec

If you want the thread URL to be mandatory,

In traderratings.php, find:

PHP Code:

if ($userbuysell == 255 || $userrate == 255 || $usercomments == '') { 


Replace with:

PHP Code:

if ($userbuysell == 255 || $userrate == 255 || $usercomments == '' || $userurl == "") { 


Then modify the phrase tratings_thread_url and removed the "(optional)" text.

--- Thanks to Jason for the code.

thank you thank you thank you!!!

[Spinball]

Originally Posted by lifesourcerec

Dunno if this is already a feature or not, but how can you make:

Specific URL mandatory and somehow make it where that a link a\can only be used twice (one time for each involved).

I think this is a very good idea. You could even go one step further and make it so that the link to leave feedback is only available on trading threads and automatically refers to that thread.
On our forums it is against the rules to negotiate via PM since the mods can't see what's going on and then can't adjudicate should a problem occur. Only private details are passed via PM.
Forcing people to refer to a thread when leaving feedback would mean that unless they cheat and put in an unrelated thread (risking a ban) they must refer to a thread and therefore can't use PMs to trade.

[sketch42]

Originally Posted by Spinball

I think this is a very good idea. You could even go one step further and make it so that the link to leave feedback is only available on trading threads and automatically refers to that thread.
On our forums it is against the rules to negotiate via PM since the mods can't see what's going on and then can't adjudicate should a problem occur. Only private details are passed via PM.
Forcing people to refer to a thread when leaving feedback would mean that unless they cheat and put in an unrelated thread (risking a ban) they must refer to a thread and therefore can't use PMs to trade.

i agreeif u can control wat forum(s) the url is located tht would be even better but i think that this is somewhat in the works already

Plans For Future Releases:
??????????????????????????????????
? rebuttal / followup comments
? limited editing / deleting by users
? stats page (maybe - show like top rated, most recent, etc)
? item description (possibly instead of thread url)[not too fond of the instead myself]
? email/PM notification when a user has been rated
? button on thread that buyer/seller clicks to tie the transaction to two people

possible to see trader rating on view profile page? and/or memberlist page?

[PranK]

love ya work.

i'll be installing tonight.

btw - site is www.skylinesaustralia.com

[eoc_Jason]

Phew... a ton of posts while I was asleep! Okay to answer a few questions...

1. The next release v1.02 will have a few changes of the changes you guys have been describing. (I'm not going to go into details cuz I don't want to make promises I can't deliver.)

2. *Probably* in 1.03 will be an option that will tie a buyer & seller together with a thread (via a button on the thread which the buyer must click, then they will have the option to rate each other). However I don't want to get rid of rating people where there isn't a threadid, as some sites & people do deal via PM or other means. So there will probably be a split into "Verified" and "Unverified" deals, where the verified has a link to the thread and all that jazz.

As for admin stuff, I know there needs to be something done to make it easier, but I'm having a hard time visualizing what the interface needs to look like exactly. If one person was giving a lot of people negative feedback, you can always go to his trader ratings and click the link to see who he left feedback for. I'll keep thinking about it, but the more input you guys can give me, the better.

Also I was thinking of making a stats page showing the higest & most rated people, and also the lowest. Possibly the last few ratings. How many ratings per day, avg per day, etc...

Lastly, I'm just curious, if I put up a paypal donate button on the first post, do you think any of you guys would dontate anything? I know this brings a lot of commerce to your sites, and also long-term member loyalty. I usually wouldn't do something like this, however I'm currently unemployed and in what little free time I have I've been spending all of it working on coding this, and helping people get it installed (and tweaked a couple servers too... hehe).

[Yahhoon23]

One little error that I'm sure can be fixed easily I hope.

When I click Feedback Left for Others I get this message.

Database error in vBulletin 3.0.0:
Invalid SQL: SELECT * FROM wireless_user_rate_trade LEFT JOIN wireless_user ON wireless_user.userid = wireless_user_rate_trade.rateduser WHERE user_rate_trade.userid = 9 ORDER BY userdate DESC, userrateid DESC LIMIT 0, 30
mysql error: Unknown table 'user_rate_trade' in where clause
mysql error number: 1109
Date: Thursday 03rd of June 2004 11:52:17 AM
Script: http://www.wirelessmatt.com/forum/tr...u=9&viewtype=4
Referer: http://www.wirelessmatt.com/forum/traderratings.php?u=9




The user I selected positively left feedback for another, so at first I thought it was because the person didn't leave feedback for anyone, but that's not the case.

[eoc_Jason]

Yahoon23 - that's a bug in the file, I forgot to add the ".TABLE_PREFIX." to the part after the WHERE clause...

Find line ~200 under the -> //Various View Types For Feedback Display
under the switch case 4: -> //Feedback Left for Others

WHERE user_rate_trade.userid

to

WHERE ".TABLE_PREFIX."user_rate_trade.userid

I thought I got all the SQL table prefixes, but I guess I missed one...

[Yahhoon23]

Beautiful. Works like a charm.

Thanks alot.

Also, for those of you wanting a quick-fix until an updated version releases with the Trader Rating in the member profile. I just went and edited the memberinfo template and added the same postbit conditional.

It's not pretty, but for the time being, it's doing the trick.