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

[eoc_Jason]

1. Edit your templates that you modified with TR Info
2. Delete the traderratings.php file
3. Delete all tratings_* templates
4. Delete all tratings_* phrases
5. Drop the user_rate_trade table
6. Remove the ratetradetotal column from the user table

Your issue with skin/template is probably an inheritence issue. I.E. the TR templates are at a lower level than the skin you are using.

[icecube0045]

Originally Posted by eoc_Jason

1. Edit your templates that you modified with TR Info

so you mean to "revert" them, back to normal?

[icecube0045]

How can I change the style ID?

[jlaine]

Originally Posted by 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.

That's understandable - and I for one appreciate the time you've invested into this system - as it's a great addition to any site that has regular sales taking place.

I completely forgot to check to see if this supported 3.5 yet and just finished the conversion - had I checked this and seen your response, I wouldn't have upgraded since this is probably the most useful modification I have in place. I kept the SQL information saved so hopefully it'll work into the new system.

[Chedy]

I've only read through half the pages here, so please forgive me if this has already been covered but I haven't seen it. I am running TR 1.2.0. I have a handful of people reporting that all the TR pages are blank in IE. They can be seen in Mozilla, but not IE. 99% of my users can see it just fine in all browsers. It's just a handful that can't see it in IE.
Has anyone encountered this before? I've already commented out the "$phrasegroups = array();" line. That fixed it for many who had problems, but not all.
Any suggestions?
Thanks!

[eoc_Jason]

As mentioned numerous times before, it is probably an inheritence issue with your style sets. If you use multiple styles then you need the templates to obviously be at the highest level so that they can be inherited by all other styles below it.

[RealDN]

Hey Jason or anyone. I have a little problem. I'm not sure whether this is supposed to look like this or not, but it does. On my forum RealDN.com when you take a look at the members list, you see that the layout is all messed up. I'm not sure where the ratings, and user titles are supposed to go, but it looks a little weird.

Any advice would be greatly appreciated.

Thanks,

Jason F.

[Dennis B]

Thanks Jason for this hack.

[high]* Dennis B installs. [/high]

[zlos]

I just want to inform, that it works under 3.0.8 perfectly

[Shepski]

installed and working fine but one problem is you try and goto the traderratings.php file directly, it comes up with a mysql error rather than display the stats page:

Database error in vBulletin 3.0.8:

Invalid SQL: SELECT user_rate_trade.userid, rateduser, userrating, userbuysell, a.username, a.ratetradetotal, b.username AS ratedusername, b.ratetradetotal AS ratedtradetotal FROM user_rate_trade LEFT JOIN user AS a ON a.userid = user_rate_trade.userid LEFT JOIN user AS b ON b.userid = user_rate_trade.rateduser ORDER BY userdate DESC LIMIT 15
mysql error: Column: 'userrating' in field list is ambiguous

mysql error number: 1052

Date: Friday 12th of August 2005 10:39:36 AM
Script: http://forums.dvd-swaps.com/traderratings.php

Any ideas on this one?