Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack)

Buy / Sell / Trade User Rating System (aka eBay Style User Feedback Hack)

Standard Disclaimer:
BACKUP YOUR DATABASE & FILES BEFORE IMPLEMENTING THIS HACK!!!

Description:
This is a rating system for when members buy / sell /trade items from each other. It is based on the honor system since there is no way to truly tell if they did engage in a transaction. However I created this system because it was a pain to try and maintain a single thread listing good / bad traders and so far has worked out quite well.

Key Features:
- Rate 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
- Admins & Super Mods can delete ratings (just incase)
- Pagination (Just for Mist )

Current Version: v1.11
There are instructions in the zip for upgrading from 1.0 -> 1.1
*Note*, I forgot the change of templates "faq" & "faq2" (added as steps 19 & 20), thats why I uploaded v1.11, otherwise everything is the same as v1.1 (If you don't want the little FAQ part, just remove the FAQ link in the getinfo template below the rating stuff)

Tested On vBulletin Version: 2.2.9, 2.3.0
(should be compatible with all versions, very simple stuff)

To Do List: (Last Edited: 05/01/03)
- Send user an email when feedback is left for them
- Allow the user who received the feedback to comment on the feedback left for them. (For Neutral/Negative Feeback Only)
- Allow optional time limits for how often you can rate someone
- Allow all columns to be sortable ASC/DSC
- create a sort of wall of fame / shame (check this thread) for more info
- have a link so you can find out all the people you rated (and how you rated them)

Additions & Changes:
1 File Uploaded
1 Table Added
1 Table Changed
3 Files Changed
10 Templates Added
5 Templates Changed

Credits:
I can't take the entire credit for this hack, while I did have the idea in my head for a while, I took bits and pieces of code off of the User Ratings hack written by EXCHANGE.

Also I would like to give a big thanks to all the members at the Extreme Overclocking Forums that helped me test out this hack as well as give me suggestions for additions and improvements.

Like My Hack?:
If you like this hack and are currently using it, please click the INSTALL button. You will receive updates in your e-mail, whenever I add new features (or fix bugs). Also any comments / suggestions are welcome. Your opinions help make it a better hack!

Sites Currenly Using This Hack:
(If you would like your site listed, please let me know so I can add it to the list!)
forums.extremeoverclocking.com
www.sportscardforum.com
www.honda-acura.net
www.graphcal-illusions.com
www.7thgencivic.com/forums/
www.vb-host.com
www.planetwrx.com

[ImportPassion]

BTW, how is V2 coming along?

[EVO VIII Chris]

-----------------------------------------------------------------
2. Execute the following SQL Queries (Can be done in PHPMyAdmin):
-----------------------------------------------------------------

CREATE TABLE user_rate_trade (
userrateid INT(10) unsigned NOT NULL auto_increment,
rateduser INT(10) unsigned DEFAULT '0' NOT NULL,
userid INT(10) unsigned DEFAULT '0' NOT NULL,
userrating SMALLINT(6) DEFAULT '0' NOT NULL,
userbuysell TINYINT(1) DEFAULT '0' NOT NULL,
userdate DATE DEFAULT '0000-00-00' NOT NULL,
usercomments VARCHAR(80) NOT NULL,
userurl VARCHAR(255) NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;

I am not familiar with PHP and I am still learning it. I am wondering where I put this? Do I put it in my php.ini file somewhere. If so could you show me exactly where? I have got everything completed except for this.

Thanks this is an awesome hack
Chris

[devrykid]

I am trying to install this hack on my website devrykids.com which is located on ipowerweb.com and is running phpMyAdmin 2.4.0 and was wanting to know if anyone could help me set up i'm stuck on number 2 in the installation file..

THanks
Matt

[CJi]

Has anyone tested this with vB3?

[FastAttack]

Originally Posted by CJi

Has anyone tested this with vB3?

yeah this should be a nice addition to 3.0

[RS25com]

One more suggestion, if you don't mind, and it might even be a simple one.

Instead of a single number rating like (10) I think a dual number system would be MUCH better, such as (12/2) Clicking the appropriate colored number will display JUST the positive or JUST the negative feedback.

In case this isn't completely obvious, this actually shows how many positive and negative votes a person has. I personally think the eBay system is flawed because of the easy ability to see positives versus negatives. Someone with a lot of transactions can hide some pretty serious negatives off the first page of their feedback.

I'm going to use it anyway, but that would clearly make this hack better, and (without knowing how you do the queries/output) you can probably remove some calculations which get your total figure.

[asiago]

installed really easily, and just love it! thanks for the cool mod

[pdatoon]

why no new posts?

[pdatoon]

Hello,

Just 2 questions.

Is it possible to make the URL thread field MANDATORY (must insert)

Is it possible to make the feedback in the postbit appears only when there is at least 1 feedback?

[ludachris]

Suggestions for V2

1. Make a new feature that allows you to see all comments left by the user whose profile you're viewing. This way, you can see trends in how they rate other users. This would be mainly for admins, but it can also help others determine how much "weight" to give this person's feedback. As it stands now, you can see all comments "given" to the user, but not all comments made "by" the user on the profile page.

2. Rebuttal comments are very necessary.

3. Email notification to each user when new ratings are added to their profile.

4. Suspension from using the feature on a member-to-member basis. Disallowing certain members from using the tool if they've abused it.

5. Prevention of allowing certain usergroups to be rated. I have a vendor usergroup who I don't want to be rated. I want this to be a trader rating system, not necessarily a vendor rating system.

6. Making the different rating counts clickable - right now, there are 3 numbers to display how many ratings are positive, neutral and negative. I'd like to make those numbers hyperlinked so that users can read only the negative, instead of having the option to only read ALL ratings.

Great hack by the way....

Can't wait for someone to finally come up with a vBClassifieds system. I've been asking for that for years. Glad you're taking it on.