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

[WoodiE]

I've noticed the install readme for 1.2.0 says the upgrade is for 1.1.0 to 1.2.0, however I'm running version 1.0.0 - how can I upgrade my version to the most recent?

-Michael

[eoc_Jason]

andrew67 - I'll have to check the install script... I might of forgotten to add the table_prefix stuff to a couple things... However it sounds like you are trying to do a duplicate install on top of the same locations. If you have a test board, are you using the same database name, just different table names, or the same database but different tables? The last error is in reference to the added column in the user table. Also you should pay attention to the extra indexes it creates, that might throw up an error when you try to install too...

Vixion - Same rating style as ebay (you can read their help docs). Your "feedback score" (which is displayed in the postbits) is based on unique members. However the "all positive feedback" number is not uniques, it is the total number. If you want it different it's not too hard to change it your self.

JazzleBug - You can't just alter numbers on a whim. They are recalculated based on actual ratings every time a rating is added/deleted. You would have to add "fake" ratings into the DB to make them permanate.

WoodiE - No, you can't. I need to put up some other files in a bit, I'll throw up all the upgrade files too (and be sure to include them in future versions). You will have to run the scripts to upgrade from one version to the next.


Also, yes I plan on continuing development. I've just been extremely busy... Overworked and underpaid...

[oldfan]

Also, yes I plan on continuing development. I've just been extremely busy... Overworked and underpaid...

I can't wait to see what you come up with next!

[the3jams]

Originally Posted by eoc_Jason

...I'll throw up all the upgrade files too (and be sure to include them in future versions). You will have to run the scripts to upgrade from one version to the next.

Will these files you mentioned have a vb2 upgrade script for your old hack? I know you've been busy so I've just been quietly waiting for one

[andrew67]

I'll have to check the install script... I might of forgotten to add the table_prefix stuff to a couple things... However it sounds like you are trying to do a duplicate install on top of the same locations. If you have a test board, are you using the same database name, just different table names, or the same database but different tables? The last error is in reference to the added column in the user table. Also you should pay attention to the extra indexes it creates, that might throw up an error when you try to install too...

Nope different databases however I just got access to drop the tables and am about to try and install it again.
Will let you know.
Thanks
andrew

[andrew67]

Deleted old table ( no idea how it got there ) and installed fine. Thanks Jason , excellent hack.

[andrew67]

Just out of curiosity is there any plans or does anybody know how to limit either the amount of feedback a person can give another person per day? Or to stop duplicate entries (happens if people double click the button etc.)
Would be good to somehow do an "if andrew67 has already rated eocJason on 07-10-04 then go to an error page saying (you have already rated this person once today)"

[eoc_Jason]

I suppose I can add in code to make sure they don't rate the same person twice in one day. However they can always edit & delete the duplicate entry (within the first 5 min). I haven't had any problems with my users leaving dupe feedback.

[mholtum]

My install went smoothly and it seems to have installed correctly. But, being the n00b I am I have no Idea as to how to work it.. Any pointers for the retard?

[mholtum]

I figured it out.. Works great