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

[Doc203]

Thanks, and yes the button will help. For now I will just add that.

[ExcErr]

what about v2/0?
"somebody" promised to make it

[eoc_Jason]

There will be a v2.0, which will contain some new features, bug fixes, and various changes... However it will probably be the last one since I'm focusing more on a "heavier-duty" solution for the whole FS/WTB thing...

[atomic fireball]

Sweet. I'm looking forward to it! Thanks, Jason!

[Ian Cunningham]

Can't wait for V2.0! What do you plan for the "heavy duty" thing?

[Stu]

Hi,
Great hack.

Could someone tell me where I can change the words "Trader Rating" in the post bit.
For the life of me I can't find it!

I know it's comming from $post_usertraderatings but can't find the text, I just want to change the wording.

cheers.

[mr.children]

hello...i am kinda dumb and new to this vbb thing...
could you please kindly explain to me what is
-----------------------------------------------------------------
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;

-----------------------------------------------------------------
// END Queries
-----------------------------------------------------------------

does that mean i have to get telnet software connected to my database and key in all the commands (or simply copy and paste?) i tried copy and paste, but endless errors show up and my database screwed...please...teach me how to get your hack installed in my site...thanx

[Stu]

run PHPMyAdmin then select your vB database then select SQL
now paste the code below but do not include the ending semi colon ; from the code above
now click go and the PHPMyAdmin will run the commands and create the table.

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)
)

now do the same with the second query

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

[mr.children]

thank you stu...
but what is phpmyadmin? a program i have to download?
seriously, i am learning everything from scratch now...
please help, thanks!

[atomic fireball]

Today at 11:54 AM mr.children said this in Post #119
thank you stu...
but what is phpmyadmin? a program i have to download?
seriously, i am learning everything from scratch now...
please help, thanks!

phpmyadmin is a "visualizer" for your MySQL database. It allows you to navigate the database in a Graphical User Interface and run queries, insert things, etc., all without having to do things in command-line format.

The ISP that hosts your forum should be able to set this up for you. There's also a hack here that allows you to run simple queries from the vBulletin ACP I think. Although, I've never used it.

Hope this info helps.