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

[mr.children]

thank you...but where to find the phpmyadmin thing?
should i look it up in download.com?

[Fi_InCogNiTo]

<a href="https://www.phpmyadmin.net" target="_blank">www.phpmyadmin.net</a>

[Logician]

Why is this step needed?

-----------------------------------------------------------------
3. Find in showthread.php (around line 58):
-----------------------------------------------------------------

LEFT JOIN user ON user.userid=post.userid

REPLACE with:

LEFT JOIN user ON user.userid=post.userid,ratetradetotal

-----------------------------------------------------------------
//END showthread.php
-----------------------------------------------------------------

As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL and all user table fields are already received in the query in part:

PHP Code:

 user.* 


So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI.

[Les Shaw]

Hack works well but when I click the trader rating in the thread I get a java script error ?
But no error if I click on it in the profile?

Any one have a fix for me

http://www.thecomputermechanics.com/forums/

[8ballstudios]

Jason,

Sorry if someone has already asked this question, I've tried to read all the messages in this thread.

Can this hack work similar to heatware.com? It looks like you have all the same features, the only difference that heatware.com allows users of several different websites to be rated (some of which are not vbulletin forums).

I plan on having a rating system for my forums (vbulletin 2.3.0 hosted), but want to make the rating system available to 4 additional sites as well (some vbulletin hosted, some not). I would do this on a seperate domain (a la heatware), not the same domain as my forums.

Is this possible?

Thanks!

Kevin

[PurpleCow]

Hello,

I am getting this error when i run the alter table query.

When i run this query

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

I get the following error :

SQL Error 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0

I am running on the latest version of mysql, that is almost.

Kindly help me with the right syntax.

Thank you

[PurpleCow]

Okay, sorry, I did a mistake.

I was supposed to run the ALTER Table query seperately, i suppose. I did that now and everything went fine and infact the hack is working fine on my boards now.

Thank you

/me clicks on install now

[Imprezer]

Great hack!

Installed on www.i-club.com

Feel free to use my site as a sample!

[The Realist]

Nice hack M8, well done.

[ImportPassion]

06-27-03 at 03:32 AM Logician said this in Post #123
Why is this step needed?



As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL and all user table fields are already received in the query in part:

PHP Code:

 user.* 


So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI.

ya, i saw that too, i just ignored it. mine has been working fine.


D