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

[cnczone]

I'm using phpclassifieds insteand of the forums any hack that I can use in that situation? http://cnczone.com/classifieds/index.php

[Keyser S?ze]

think it would be possible to have a option in user options to "receive PM notification when u receive feedback"

[eoc_Jason]

I just use it with my regular FS/WTB forum sections. However I am working on a classifieds / auction hack for vBulletin (which will be free, and very easy to implement).

Originally Posted by jamesk

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

[eoc_Jason]

Edit the upgrade script to comment out the line that wants to DROP the rateduser_2 index.

I'm sure all your data is there, I'm not sure what all has been changed / updated without taking a look at it all firsthand.

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


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

[eoc_Jason]

If they are at zero, how would you initially ever leave feedback (besides having to go to their profile page)...

There really isn't an easy way to check to see if they have left feedback but because of negative it is now at zero. You would have to modify a couple of the vB php files to join the other tables and test to see if any feedback has been left. Which is why I did the alternate by having a calculated field in the user table.

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

[eoc_Jason]

I don't use PhotoPost Classifieds, nor do I care to pay for such a hack. You will have to contact the author of that hack for more info.

However I am developing my own classifieds / auction hack which will extend the usage of Trader Ratings.

This version of trader ratings was meant to be simple... As a replacement to having no ratings system in place, or the "massive trading list thread"... There could be an endless amount of features that I could put into this hack, however it's probably not going to happen as I have bigger plans for the Trader Ratings concept. In the long run there will probably be (at least) two versions. The simple / easy to implement version (this one), and the more complicated cross forum / auction-classifieds version.

EDIT - sorry for the several posts in a row. I didn't realize it has been so long since I have checked this thread and I wanted to make sure I answered each question individually.

Jason

Originally Posted by cnczone

I'm using phpclassifieds insteand of the forums any hack that I can use in that situation? http://cnczone.com/classifieds/index.php

[Skaterscafe.com]

Great idea for a hack!

I installed it last night, but now I get several errors. The PM system does not work, when I try I get this:

There seems to have been a slight problem with the Skateboard forums - message board for skateboarders - main forum database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience



Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=2 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Monday 09th of August 2004 12:57:48 PM
Script: http://www.skaterscafe.com/private.php?
Referer: http://www.skaterscafe.com/
Username: *********
IP Address: **********

It also appears PhotoPost quit working. PhotPost gave errors, I uploaded the upgarde hack and the error went away but now it will not upload photos.

Any ideas before I upload my backup?

[Keyser S?ze]

Originally Posted by eoc_Jason

If they are at zero, how would you initially ever leave feedback (besides having to go to their profile page)...

There really isn't an easy way to check to see if they have left feedback but because of negative it is now at zero. You would have to modify a couple of the vB php files to join the other tables and test to see if any feedback has been left. Which is why I did the alternate by having a calculated field in the user table.

yea i noticed that after using this a few times, dont mind me while i hang my head in shame ;p


what about the "receive PM notification on new feedback"

also can i set so certain mods can edit feedback? maybe by user id

[eoc_Jason]

Most users pay very close attention to their rating once they have a couple, however I might implement an option PM notification with a reminder they need to rate that person if they haven't already.

As for allowing only certain mods to edit feedback, you will have to edit one of the tratings templates to change who sees the "edit" links, and also the traderratings.php file for who has permissions.

Originally Posted by Keyser S?ze

what about the "receive PM notification on new feedback"

also can i set so certain mods can edit feedback? maybe by user id

[oldfan]

GREAT Add-on !!
I love to see a top 10/master feedback page.
I'm willing to throw some cash your way for it and I'm sure many others would too