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

[yoyoyoyo]

Originally Posted by eoc_Jason

Why would you want a star rating instead of numbers? I don't see how the two would correlate, unless you made the # of stars relevant to the % of positive feedback.

ebay uses both and it works fine. they give you a specific star icon for the level of feedback, and also list the number.

[eoc_Jason]

My mistake, I thought he said stars instead of numbers, but he said numbers and then "something like 5 stars"... (Which I'm assuming he means the vBulletin scale of 1-5 stars). The easiest way to do it without having to even edit the PHP file would be to just do some if conditionals in the postbit template to base your stars on the TR score.

As for the eBay stars that yoyoyoyo mentioned... don't even get me started with how pointless those things are... They are eyecandy and nothing more... and that's all I will say about that.

[bigcurt]

I think the hack works great, the stars are cool but there just for looks, My site could not live without this hack..and there are a few things I would LOVE to see done with this hack jason but stars arent really one of them :P. If you ever get time I might give you some money to modify this hack for a few things jason, when you get time . I love this hack, and thank you a TON for doing it.

~Big Curt

[Q-v-n-s-Q]

when i install ( tarder system automatic add top rated trader )
http://www.efz-tm.net/forums/traderratings.php?

[totenmaske]

Thanks for a brilliant mod!!!

[RS25com]

I am still hoping for a percentage mod for this. Right now I am having problems because people assume ANY positive number means the seller is okay, and buy from them without looking at the details. But as it turns out, a seller with 10+ and 4- = 6+. It should really equal 60%.

My members are trying to work on this. I am not above doing on the fly calculations on my site, as it's pretty small. Alternately, I can add another DB column and run some SQL to populate it, and then I just need to code to display it.

Anyone wanna take this on? Here is where we stand on this:

http://www.rs25.com/forums/showthread.php?p=578034

[Kihon Kata]

I'm still hoping for an upgrade to 3.5 for this hack.

any idea when?

Originally Posted by RS25com

I am still hoping for a percentage mod for this. Right now I am having problems because people assume ANY positive number means the seller is okay, and buy from them without looking at the details. But as it turns out, a seller with 10+ and 4- = 6+. It should really equal 60%.

My members are trying to work on this. I am not above doing on the fly calculations on my site, as it's pretty small. Alternately, I can add another DB column and run some SQL to populate it, and then I just need to code to display it.

Anyone wanna take this on? Here is where we stand on this:

http://www.rs25.com/forums/showthread.php?p=578034

[eoc_Jason]

1. I said this before and I will say it again. There will NOT be an update for vB 3.5.x until they have a final release. (So much code changes during the beta/RC versions, I really don't feel like having to do a bunch of needless re-work). It is currently a RC1, typically two more RC's come out, then the final release.

2. If you want to know how to make a % display, look at the function that does the calculations, and also the main TR page (since it calcs %'s for that page). The easiest cource of action would be to add another column to your user table to store the % value (if you don't want to do it on the fly). Then under the function that calculates out the TR score, add the code to calculate the % and update the user table with that info too.

You will have to run a mass-update to re-calc all users. I'm not sure if I posted any code for that, but the concept is not that complex to write your own little routine.

[icecube0045]

Is there a way that i can remove the trader ratings from my forum?

[icecube0045]

When i go to "apply phrases" i get this error"
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'tratings', 'Trader Ratings', 1)
mysql error: Duplicate entry 'tratings-0-1' for key 2

mysql error number: 1062

Date: Wednesday 03rd of August 2005 12:52:12 PM"

I already have it installed on my forum but i tried to do it again becasue it dosent work with the new skins that ive added, it only works with the 1st one.