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

[integra99]

Originally Posted by Spinball

Jason - thanks. A definite bug for you. You need to update the upgrade script to put the correct version number in there. It's still says 1.1.0.

Just modify the phrase, quick fix. I had no trouble upgrading 1.1 to 1.2

[eoc_Jason]

How do I uninstall the hack? I want to completely uninstall it and then I'll run the new install thing and see if it works right.

There currently isn't any automatic process (haven't gotten around to it yet). however the steps are fairly easy...

1. Remove the tratings_* templates. (You "revert" them and they will dissapear).
2. Remove the tratings_* phrases.
3. Remove (drop) the user_rate_trade table
4. Remove the ratetradetotal column in the user table, and the ratetradetotal index (if it exists).
5. Delete the traderratings.php file

That should remove it completely.

-----------------------------------------------------

You see I have 5 feedbacks left.

You have 3 fields, 1 month, 6 month, & 12 month...

That was how it was originally, however it was decided that the numbers would be "cumulative" to mimic how eBay displays it. You can change it to however you want, it's not hard to modify the way you want it to look.

-----------------------------------------------------

ok might got a bug for ya...

it reports as closed to the regular members, I tried everything I could think of but since im not much of a php programmer I ended up having to just take the whole maitenance code out...

Ack! The phrase is set to 1.1.0... it should be set to '1.2.0'... I'll upload a new file asap!

FYI, it will report closed in either of these 2 instances...

1. The constant "TRATING_CLOSED" is set to 1.
2. The phrase "tratings_version" doesn't match the variable version in the PHP file. (This is to prevent code/file mismatch).

-----------------------------------------------------

cause if someone hasn't been on in a long time and there are a bunch of ppl with all the same like 20 -1's, it goes by username b4 activity, so I just made that change

I'm still debating on a better "wall of shame" because I think it is important to list all the negative traders so that they can be avoided on other forums. But yeah, you can sort them any way you like... won't hurt my feelings...

[eoc_Jason]

Okay, I just re-uploaded 1.2.0 with the phrase version fix in the upgrade...

IF YOU DOWNLOADED THE FILE BEFORE THIS POST WAS MADE PLEASE READ BELOW!

If your users are experiencing a "trader ratings closed" message:

1. Go to your adminCP
2. Search for the phrase: tratings_version
3. Change it to: 1.2.0 (no "v" or anything, just the numbers)

That's it! The system should work now. Just sent an email out to everyone.

[Yahhoon23]

Installed perfectly. Thanks for the upgrade Jason.

[the wiz]

I completely uninstalled the hack, and re-installed it with the new version and it looks like it is working now.

[eoc_Jason]

Just a note to a lot of admins... Check to make sure your Trader Ratings system isn't closed, the easiest way is to check your main TR page when you are logged out...

In the next version I'll probably put a little note when the TR page is closed so admin/mods know..

[Yahhoon23]

Jason, glad you let us know.

One minor issue I just realized now because of that.

The traderratings.php is set to 0 for open.

But when I am logged out and go to the Trader Ratings Stats page it gives me the closed page. Any ideas what could be the issue?

[eoc_Jason]

Please read post #303 above... That is the issue...

IF YOU DOWNLOADED THE FILE BEFORE THIS POST WAS MADE PLEASE READ BELOW!

If your users are experiencing a "trader ratings closed" message:

1. Go to your adminCP
2. Search for the phrase: tratings_version
3. Change it to: 1.2.0 (no "v" or anything, just the numbers)

[Yahhoon23]

DOH! I need reading full posts was actually worthwhile sometime.

When I first read it and saw the big letters, I assumed we had to re-download from Post #1. So I just did that without reading I actually had to do anything.

Thanks

[Rick Sample]

I just installed it on my site, however, how do I leave feedback for another person???