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]

I just finished coding up the edit/del feature. You can customize the time to whatever you want (or disable it to prevent regular user editing). Mods/admins have the right to edit/delete all feedback.

I made all the necessary changes to the DB & code, there was a lot of re-write to support the editing & permissions and such, I'm not sure if I will consolidate it before this next release or not. (I try to write functions whenever feasable.)

Sunday I'll probably code in the usergoup permission stuff, convert some new text to phrases, and write the upgrade/install scripts. If nobody reports any bugs to me on my forum then I'll release v1.10 on Monday morning.

I think user based editing/deletion will really help out a lot and reduce those PMs from members saying "hey, I made a mistake rating this person..."

One thing I *might* change in the future is a soft/hard delete option, kinda like what you can do with threads. But I'm not really sure it's worth the effort...

[BamaStangGuy]

How do I make it where it only shows the Trader Rating (0) in postbit for certain forums?

I only want that to show in the For Sale sections of my forum.

[eoc_Jason]

Well, depending on if you have only 1 FS section or multiple, there's a couple ways you can do it, but both require editing your postbit template and using some conditionals. Also someone asked about specific user groups so I'll include those too:

Here's some examples (note, this code will be included with 1.1.0):

For specific member group (or sub-group):

PHP Code:

<if condition="is_member_of($post, 11)">
(trader ratings row)
</if> 


For specific forum section:

PHP Code:

<if condition="$thread[forumid] == 200">
(trader ratings row)
</if> 


For multiple forum sections:

PHP Code:

<if condition="in_array($thread[forumid],array(200,201))">
(trader ratings row)
</if> 


Combining the two together:

PHP Code:

<if condition="is_member_of($post, 11) && in_array($thread[forumid],array(200,201))">
(trader ratings row)
</if> 


Hope that helps out... FYI, I'm still coding the upgrade script for 1.1.0. Should be up soon though.

[eoc_Jason]

Okay, version 1.1.0 has been officially released. I tested out the upgrade and install scripts, however please post your upgrade/install results (good & bad) so I know if it is working or not.

There are some pretty big code & template changes in 1.1.0, be sure to backup your user_rate_trade table and 3 trating_xxx templates!!! (I can't stress this enough!) The update makes several changes to the DB table, and will overwrite the trating templates!

I'll be posting updated screenshots in a few. Read the CHANGELOG.txt & README.txt file more more info.

[NexVision]

upgrade script worked beautifully

[EyeCrave]

Works like a charm. Thanks again.

[Yahhoon23]

Worked Perfect on mine as well using a table prefix.

Great Job.

[lifesourcerec]

I went ahead and re-added the code to make the link mandatory.

[sketch42]

everything works like a charm

just one question but where do i add this code? am i replacing the existing code on the postbit? im not to clear on that

<if condition="in_array($thread[forumid],array(49,52,53,54,55))">
(trader ratings row) 
</if>

[eoc_Jason]

Right, so the part where you have <div>Trader Ratings....</div>

Put the <if...> before that row, and the </if> after that row in the postbit/postbit_legacy.