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

[wynode]

OK i've searched this thread but can't seem to find the solution......

Basically there have been a couple of cases where the "Submit Feedback For xxxx" link has not come up in the trader ratings screen.

For example, others have been able to rate myself, but there is at least one user who cannot rate me (the link doesn't come up).

And just now another user reported the same error when trying to rate someone else.

ANy ideas?

[eoc_Jason]

The only permissions a user must have is the "CANPOSTNEW", and also a user can not rate them self. Other than that the link should appear unless you have added custom rules to the <if> statement.

[Jimboj79]

Excellent mod thankyou

[wynode]

Originally Posted by eoc_Jason

The only permissions a user must have is the "CANPOSTNEW", and also a user can not rate them self. Other than that the link should appear unless you have added custom rules to the <if> statement.

Thanks for that!

I had setup a new group and their permissions weren't set properly. That's why some users were affected and not others.

Great work...lovin this hack!

[andrew67]

Great hack Jason, I have it working on my test board wonderfully. But on trying to install it to my functional board I got the following errors.

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE user_rate_trade (
userrateid int(10) unsigned NOT NULL auto_increment,
rateduser int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
userrating smallint NOT NULL default '0',
usercomments varchar(80) NOT NULL default '',
userdate int(10) unsigned NOT NULL default '0',
userbuysell tinyint(1) unsigned NOT NULL default '0',
userurl varchar(255) NOT NULL default '',
PRIMARY KEY (userrateid),
KEY rateduser (rateduser,userrating),
KEY rateduser_2 (rateduser,userdate,userrating),
KEY rateduser_3 (rateduser,userbuysell,userdate,userrateid),
KEY userdate (userdate)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Table 'user_rate_trade' already exists

mysql error number: 1050

Date: Sunday 03rd of October 2004 04:08:53 PM

This I attempted to fix by search replacing all "user_rate_trade"'s in the php file with "vb3_user_rate_trade".

Then attempted to install again.
And received the following.

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'tratings', 'Trader Ratings', 1)
mysql error: Duplicate entry 'tratings-0-1' for key 2

mysql error number: 1062

Which I then fixed by removing all the phrases that were added by the php file.

Then went to install a third time and received.

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ratetradetotal'

mysql error number: 1060

Any ideas?

My next approach is to change the "vb3_user_rate_trade" to something else again and change the "ratetradetotal" to something else as I can't actually remove the tables (no access).
Cheers
andrew

[Vixion]

I am thinking about using this modification on my own forum. But I need to have something clear.

The screenshots attached in the first post, are very clear, they look like eBay, but does the system work with a unique feedback score?
I.E.
Person A. makes a trade with Person B. Because of a good trade, Person A. leave a feedback for Person B.
After 2 weeks Person A. and B. trade again. And after that trade they leave a feedback again.

Now my question;
Does every feedback counts to the total (I.E. Person A. (30)) or does the feedback-score only displays the UNIQUE trades, with UNIQUE people?

[newb1e_]

Hi all,

looking at some of the previous question's I'm a little embaressed to ask this (ultra obvious I imagine but here goes)

in the templates editing area of the readme it says

- Add somewhere:

<if condition="$post['userid']"><div>Trader Rating: (<a href="traderratings.php?$session[sessionurl]u=$post[userid]">$post[ratetradetotal]</a>)</div></if>

Could someone give me a quick idea where I should place the code in postbit/postbit_legacy/MEMBERINFO? Please help a newbie

thanks in advance, be gentle :surprised:

[Lord Brar]

Gee. Thanks Dude! I really needed something like this for SellAdSpace.com! The installation was Really Easy!

Wonderful Hack. Thanks!

[Lord Brar]

Forgot to add - *Clicks Install*

[JazzleBug]

This is excellent and will save us much time. Thanks for the hard work and support! Super easy installation!

Something I'd like to see in the future if you continue to develop this is complete admincp integration where the admin can alter the numbers without having to manually create new entries. Having seen the code and the database, I don't imagine that this would be incredibly easy as the numbers come from counting individual entries, correct? I'm certainly not a programmer (though, it's fun to think I am lol), so I don't have a clue what goes into coding something like this. I do think that it might bypass the need for a full conversion script (assuming everyone is just running around with one long thread of feedback on their forum). 'K - I'll shut up.

Thanks for the script!

Steph