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

[eoc_Jason]

Why does the script URL link have two /forums in it?

http://www.gunsnet.net/forums/forums...&postid=954692

I think I've got some bits of code I need to track down, the problem seems to occur when there is action=showpost in the query string...

Yesterday at 12:52 PM bowhunt said this in Post #75
mysql error: Table 'gunsnet.ratetradetotal' doesn't exist

mysql error number: 1146

Date: Tuesday 06th of May 2003 11:48:08 AM
Script: http://www.gunsnet.net/forums/forums...&postid=954692
Referer: http://www.gunsnet.net/forums/showth...692#post954692


eoc Jason, I want to first thank you for an awesome program and second you think we may be able to fix this?

I did personally change the USER table to reflect the change --> ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;


Thanks

[lifesourcerec]

05-02-03 at 07:30 PM eoc_Jason said this in Post #60
7thgenCivic.Com - I would like to have it automated too, however any time you rely on a user having to input something, you run the risk of false info... There is just not any way I can see reliably to link a buyer and seller from a normal thread...

Well, if there was a way to make "URL" mandatory, that would be nice. To have a forum to post the agreement, then when the transaction is completed, make them post the URL to that thread or it won't go through. If you use the "check database for dupe IPs" and screen your users, then this may be perfect.

[lifesourcerec]

Yes, a top x (feedback) page would be nice. That would get people moving (buying, selling, trading).

[Imprezer]

Great hack!

I have one question. Is there any way to limit the possibility to leave the feedback to a specific usergroup?

On my site, I have registered vendors that sell their products and I want only them to be rated.

Thanks!

- Alex
www.i-club.com

[lifesourcerec]

1. option to make URL mandatory
2. A limit to how many times an URL and be entered (one for seller, one for buyer).
3. Ability to add (Positive, Neutral, Negative) on Postbits.

[Odysseus]

Hi eoc_Jason!

I'd love to install this hack because we recently had some problems with "black sheeps" in out marketplace forum.

But I actually think, that this hack cannot work without some kind of verification system that determines, whether two users are allowed to vote for each other, or not.


My suggestion to easily achieve this is:
Two users have agreed to do some trading in a thread. Now, they can open a "rating ticket". Only if both users accept this voting ticket, they know that the other person is seriously interested in this trade! (So, if one doesn't answer yout ticket request, you don't send the item, or you don't pay until he accepted the ticket).
A ticket can be opened by every user ... but only if a ticket has been accepted by two users, these two users can actually vote for each other.
If there's no ticket, no (fun-)voting can be done.

Technically, we woult require another mysql-table with 4 fields: 'user1', 'user2', 'confirmed', 'finished'. When opening a ticket, user 1 writes his username and the name of the other user into a form, which eventually creates a new line in the mysql-table, containing the id's of both users.
Now, user 2 has to accept this ticket by pressing some button and thus setting 'confirmed' to yes.
If users want to rate each other, a query needs to be performed in order to check if there is a valid (i.e. 'confirmed') ticket available.
After the voting is done, 'finished' is set to 'yes' and the ticket is invalid now.



Something like that.
How do you think about this? :bunny:

[lifesourcerec]

This will definately be Hack of the Year

[eoc_Jason]

Hmm... So many new features, and so many changes, I think I might have to re-write this one from the ground up (but make it backwards compatible with existing data), to allow for all the new features you guys want and allow all the options to be user-set in the AdminCP (since I know some people will want certain ones whereas others wont).

Sorry it took me a while to reply, I was unable to access vB.org for a couple days (anyone else have that problem?). Also I've been very ill lately so I've mostly just been resting.

Once I recover to a state where I'm semi-aware of whats going on around me and I can sit down and take a look at all the feature requests and what will be necessary to meet these requests I will post with more info.

[GunsNetwork]

IF you want to use my website as a testing basis your more then welcome. The website is quite large and if it works on a site this big then it will work anywhere. I saw your name registered, glad to have yeah on board eoc Jason.

Let me know

[Odysseus]

Today at 03:50 AM eoc_Jason said this in Post #88

Once I recover to a state where I'm semi-aware of whats going on around me and I can sit down and take a look at all the feature requests and what will be necessary to meet these requests I will post with more info. [/B]

I'm already looking forward to this!
Hope you'll find my "voting-ticket-system" worth to be applied.
I think this would in fact solve the missing security issues in this absolutely gread hack. :bandit: