The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack) Details »» | |||||||||||||||||||||||||||
Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack)
Developer Last Online: Jan 2020
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 Show Your Support
|
Comments |
#72
|
|||
|
|||
can this hack have option:
a select tool to see who has the most feedback or a list of feedback users that have been rated? this way we can see if users just play with users profiles, we are able to moderate that. |
#73
|
||||
|
||||
Well I was planning a top X page, but I think you are wanting something a little different, like who rated the most people list?
|
#74
|
|||
|
|||
no...a page that list who has been ranked....maybe threw adminCP. That way, it would be easy to know if some1 has been ranked and doesnt know it, and it might be some useless or not valid ranking....
|
#75
|
|||
|
|||
not even a page, maybe on the member list page, to have their rank count listed, and be able to sort them.
|
#76
|
|||
|
|||
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 |
#77
|
|||
|
|||
@bowhunt
Looks like u never ran: [sql]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;[/sql] |
#78
|
|||
|
|||
I ran it.
|
#79
|
|||
|
|||
PRIMARY KEY (userrateid),
KEY rateduser (userid) ); That might be my problem, but I am guessing. Keyname Type Cardinality Action Field PRIMARY PRIMARY 566 Drop Edit userrateid userrateid rateduser INDEX 94 Drop Edit userid |
#80
|
||||
|
||||
bowhunt - I've run into that probably occationally before, and I can't seem to trace down the error... it's few and far between when I see it so it's hard to determine the cause.
I've seen the same error happen with the other user ratings hack. |
#81
|
|||
|
|||
Well I guess I see it more when I have a very active website. We have on average 700 to 900 people online at any even time so yeah we have quite a few people using the program on deals they have done together.
I surely wish someone could fix it for sure. |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|