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]

Templates are not in the PHP file... They are in the AdminCP under whatever style you installed them as...

tratings_display
tratings_feedback
tratings_listbits

[the wiz]

Originally Posted by eoc_Jason

Templates are not in the PHP file... They are in the AdminCP under whatever style you installed them as...

tratings_display
tratings_feedback
tratings_listbits

I just changed the 100% to 80% on all three, and the only thing that happened was that it shrunk the table directly under the navbar, not the entire thing.

[NietzscheKid]

Hello Jason. I finally installed this great hack. First, thank you for providing this to the community.

I have modified it for my needs as we don't allow buying or selling. We only allow free trading. So, I have modified it but now have a small problem left.

I would like to remove the "From" table row from the feedback tables. It should only display the date but now the date is in the FROM table for some reason. Below I attached a screenshot. It would be great if you could point me to where I can do this. I know this is an extra wish since I deleted a few options. but I hope you don't mind. Thanks a ton!

[eoc_Jason]

Look in the tratings_display template... There is actually a pretty extensive if/else structure because of how it was handling all the various feedback views so you can probably tidey it up some since you removed the buying/selling.

However, if you remove the "from" field, how will a person know who rated them? IMO you might want to double think about removing it.

[NietzscheKid]

Originally Posted by eoc_Jason

Look in the tratings_display template... There is actually a pretty extensive if/else structure because of how it was handling all the various feedback views so you can probably tidey it up some since you removed the buying/selling.

However, if you remove the "from" field, how will a person know who rated them? IMO you might want to double think about removing it.

I would tidy it up if I knew anything about php which I don't. lol

I'd love to keep the "From" field, but I must have messed up the code that is needed to display the "from". I have no clue where to change this.

[jamesk]

THis is great,but shouldn't it be with some store or auction hack?
What are you guys using with it.

[the wiz]

My forums B/S/T section.

[Spinball]

I had version 1.0.0 of this installed with vB 3.0.1.
I upgraded to vB 3.0.3, uploaded the new traderratings.php and ran the upgrade script. Clicke a couple of 'proceed type' buttons and got

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE user_rate_trade DROP INDEX rateduser_2
mysql error: Can't DROP 'rateduser_2'. Check that column/key exists

mysql error number: 1091

Date: Sunday 08th of August 2004 12:34:27 PM
Script: http://www.avforums.com/forums/admin...derratings.php
Referer: http://www.avforums.com/forums/admin...derratings.php
Username: Spectre
IP Address: 82.47.88.131

I've tried re-running the script but it crashes out with another error.
Is my system fooked?

[Ted S]

I made a few little template additions to my site to help better promote the trade rating system, you can see them in action at www.scubaboard.com/forumdisplay.php?f=213 (view any thread). To add this to your site you need to make just two small changes.

1) modify your phpinclude_start template by adding the following code (each number is the ID of a classified forum)

PHP Code:

$classified_forumids = array(1,2,3,...); 


2) modify your postbit or postbit_legacy template by finding

PHP Code:

<!-- message --> 
<div>$post[message]</div> 
<!-- / message --> 


before this add

PHP Code:

<if condition="in_array($forum[forumid], $GLOBALS[classified_forumids])">
            
            <if condition="$post[ratetradetotal] != 0">
                
                <if condition="$post[ratetradetotal] < 0">
                    <div style="text-align:center;font-size:12px;color:red;font-weight:bold;">Negative: This user has <a href="/traderratings.php?$session[sessionurl]u=$post[userid]" style="color:red;">trader rating</a> of $post[ratetradetotal]!</div>
                <else />
                    <div style="text-align:center;font-size:12px;color:blue;font-weight:bold;">Positive: This user has <a href="/traderratings.php?$session[sessionurl]u=$post[userid]" style="color:blue;">trader rating</a> of $post[ratetradetotal]!</div>
                </if>
                
            <else />
                <div style="text-align:center;font-size:12px;color:green;font-weight:bold;">Neutral: This user has no <a href="/traderratings.php?$session[sessionurl]u=$post[userid]" style="color:green;">trader rating</a> history!</div>
            </if>
            
            <div style="text-align:center;font-size:12px;"><a href="/traderratings.php?u=$post[userid]&do=feedbacknew">Leave feedback for $post[username]</a></div><br />
            
        </if> 


This will show the user's trade rating status in the default colors with a link to leave them feedback. If you make any improvements please post them back here. Also, I did not use language phrases to keep this simple, if you want to add them yourself it's not hard but I can help if you need.

This is an amazing addon and I can't wait to see what comes of it... thank you!

[Keyser S?ze]

good hack!

one thing tho, how could i make it so if someone has a rating of 0 with no ratings for negative or positive then in the post bit the trader ratings isnt there?

i have a ton of members and not that many really trade