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]

I don't understand the need / requirement for this... Some of these suggestions are getting way beyond the simple scope of my original hack (which read the first post to understand why I created it). If you are looking for something with a much more powerful system, I suggest you look into either vBay, or vBTrader.

Today at 08:16 AM gmarik said this in Post #100
Has it an itegration with PayPal? What would be great, like the hack Mist is working on...

[lifesourcerec]

Yeah, it does have a lot of possibilities. My only suggestion is to make it more secure (making like to post mandatory, making it to a way that that link can be only used twice, etc.). It does seem a lot of people trying to re-create Ebay.

[eoc_Jason]

I think I found the solution to the random errors that were popping up saying user.ratetradetotal doesn't exist. If you change the SQL query in the showthread.php (step 3 in the install.txt file), instead of tacking on ",ratetradetotal" to one of the left joins, add the ",ratetradetotal" to the end of the SELECT line, and you *shouldn't* get any more errors...

This info will be corrected in the next version when I ge a chance to release it.

05-06-03 at 12:52 PM bowhunt said this in Post #75
I have installed this on vB 2.3 and everything works great except for this morning I have received 3 Errors. I have looked and I think there might be a problem as it is addressing there is no ratetradetotal....

Here is the error...

Database error in vBulletin 2.3.0:

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 = '954692'

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

[groovesalad]

I'm getting this:

Fatal error: Call to undefined function: phperror_reporting() in /www/g/groove_salad/htdocs/forum/admin/functions.php on line 1

[eoc_Jason]

You are going to have to be more specific on what you doing... All I get out of that is functions.php gives an error on line 1, which doesn't tell diddley....

Today at 03:17 PM groovesalad said this in Post #104
I'm getting this:
Fatal error: Call to undefined function: phperror_reporting() in /www/g/groove_salad/htdocs/forum/admin/functions.php on line 1

[groovesalad]

For some reason I cant get $post_usertraderatings to show up in the postbit. I have a skin I'm using....anyone know what I might try?

[JDMCivic.com]

excellent hack...much thanks! i implemented it on my site at
http://www.jdmcivic.com/forums

thanks again! i've been looking for a hack just like this.

jay

[Patrick]

Do you have any way for me to view all feedback ever left for all users? I don't mind a raw .php file by itself but just to browse while I'm perfecting how I want to use this? Thanks.

[Doc203]

This is fantastic! Nice work, and a very easy install.

Most of my users are not very internet savvy and I would like to add a button to the bottom of each post by the pm, e-mail, www etc buttons for something like "leave feedback" then when they click that I would like it to take them to the users profile with the url of that thread already inserted into the url section of the feedback submittal.

If anyone could help me do that let me know. I just don't know how to get it to put the previous url in the feedback box, maybe it is not possible.

Never-the-less great hack!

[atomic fireball]

If anyone could help me do that let me know. I just don't know how to get it to put the previous url in the feedback box, maybe it is not possible.

Never-the-less great hack!

Did you just want a "feedback" button? If so, will this one I'm attaching work for you?

I'm willing to help out on the graphics end of things if anyone needs it. Since this hack is still part of the user profile, it will essentially just go to the Profile page.

I heard Jason is going to rework this hack to make it a separate feedback page (not a pop-up style). So we may just want to wait for the new version.

In any event, I hope this graphic helps. Enjoy.