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

[oldfan]

Originally Posted by Polo

Will install this later on

install what?
The first version?

[eoc_Jason]

Whew... Okay, sorry for the delay. But I think I've reached a compromise on the stats page which should make everyone happy. You can view what 1.2.0 will look like on my site.

Now I just need to convert some of the text to phrases, and update the install / update scripts. So look for the next release to come out in a day or two.

As for what is new in this version:
- Overall Stats Page (of course)
- PM notification
- Defined constant in PHP file so you can "close" the TR system while working on it.
- Defined constant in PHP file to make the feedback URL optional/required.
- Re-wrote code that calculates out % positive feedback. No longer shows something like -20%
- A couple new templates, phrases, and 1 new DB index I think are all that have been added.

I was going to include checking for threadid/postid, but I haven't worked the bugs out of it yet so it's not included in this release.

[WreckRman2]

Where is the update?

[Yahhoon23]

Originally Posted by eoc_Jason

Now I just need to convert some of the text to phrases, and update the install / update scripts. So look for the next release to come out in a day or two.

This quote from his post help?

[WreckRman2]

Oh... back to the waiting line.

[the wiz]

Originally Posted by eoc_Jason

Ran what upgrade thing? You will have to be more specific. If you don't have any real data in the system, you might want to consider manually removing the templates/tables/phrases and re-installing the hack from scratch. It's really hard to diagnose these kind of problems without being able to see how everything is configured.

On another note, I was thinking about adding little stars, reflecting certain groups of positive scores (like eBay does). It really doesn't serve much of a purpose though.

Anyhow, I'm still working on the stats page, I still don't have it how I like it. That's basically the holdup for v1.2.0

I ran the update script for the Trader Ratings hack. There is data in there, but it isn't showing positive and negative feedbacks, it is listing everything as neutral.

Demo:
http://www.dsites.net/vb/traderratings.php?u=1

[eoc_Jason]

What version were you upgrading from? Did the update run completely without errors? Did you look at your data in the DB to see if the actual ratings were pos/neg or they were being stored as neutral?

Why is your first row of text smaller than the second? That's not in my template...

[the wiz]

I didn't update from any version, I ran the update when I found out that everything was being put in a neutral because I thought that because I added another style then that was the problem.

What do you mean it isn't your template? It looks like it is making the first row small, the next big, then small again.

[eoc_Jason]

Ugh... So you installed the hack, then ran one of the upgrade scripts but you were already running the latest version? I'm not really sure what would happen, but I don't think it would be good. The scripts aren't that "smart" in the sense of knowing the if any grandular changes have been made or not.

As for font size, it is probably in your CSS declerations, you probably have the size for alt1 different from alt2.

[the wiz]

I'm sorry, I didn't word that right. I never tested this when I originally installed it. Then when I sold something to another member, that was when I found out that everything was coming up as neutral. THEN I ran the update script thinking it may have been something with the style templates causing the problem.