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

[Polo]

Yeah, I got it thanks...

for those looking for it for version 3.0.3..... here is the link:

https://vborg.vbsupport.ru/showthread.php?t=65730

[sunrunner_pei]

If you're still doing support for this great hack, I could use some help...

I installed your hack last week, and now I'm getting some Database errors in my inbox. The hack appears to be working, so I'm not sure what the problem is. Here's the error I get:

Database error in vBulletin 2.2.9:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid,ratetradetotal
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '372305'

mysql error: Table 'gaowners_vb.ratetradetotal' doesn't exist

mysql error number: 1146

Date: Friday 17th of September 2004 07:39:14 PM
Script: http://www.gaownersclub.com/forum/forum/showthread.php?s=&action=showpost&postid=372305&
Referer:

I checked phpMyAdmin, and the table seems to be there (See attachment).

I've run repair.php?html=1&check=1, and I'm still getting the error in my mailbox. As well, note the URL listed in the error: forum/forum/showthread.php Not sure if that means anything or now, but it isn't a valid link.

Thanks for any help you can provide!!

[luke2kz71]

does this work with 3.0.3 ?

[Tilmanitou]

Originally Posted by luke2kz71

does this work with 3.0.3 ?

No, but Jason built a newer version for vB3:

https://vborg.vbsupport.ru/showthread.php?t=65730

[BiReL41r]

Very good hack, I'll be installing it shortly!

[rollinjunk]

does this work with 3.6.2?

[alkatraz]

^ doubt it...

will there be a new version of vb trader released for vb3.6x? my members are whining for it.

[lifesourcerec]

I upgraded to v3.6.2 and mine still works.