![]() |
|
|
Mod Options |
Trader Ratings v1.2.0 Details »»
|
|||||||||
|
This modification is in the archives.
Trader Ratings - A user feedback hack
Copyright İ2004 Jason Rabel, All Rights Reserved. __________________________________ Latest TR Verson: 1.2.0 vB Versions: 3.0.0 - 3.0.9 Author: Jason Rabel Contact: PM me here, I'll respond. Site: EXTREME Overclocking ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ Updates: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ 1.2.0 - September 4, 2004 - Added Trader Ratings Stats Page (finally!) - Added PM notification when someone receives feedback - Changed how positive feedback percentage score is calculated (bugfix) - Ability to "close" the Trader Ratings pages (for maintainence or whatever) - TRATING_CLOSED - Ability to set the URL field when submitting feedback to required or optional - TRATING_REQ_URL 1.1.0 - June 7, 2004 - Added time-based user edit/delete abilities, set via TRATING_UEDIT constant in traderratings.php file - Userdate field is now an int field to be consistent with vBulletin - Userrating field changed to tinyint to save space - Fixed timeframes for showing historical ratings - Made some various code consolidation - Added missing ".TABLE_PREFIX." statement - Templates.txt file shows code for postbit & MEMBERINFO, with conditional examples - All 3 templates changed heavily - Added some more phrases & fixed missing phrases 1.0.1 - June 2, 2004 - Fixed a "divide by zero" display error - Postbit template fixed so guests do not have a trader rating 1.0.0 - June 1, 2004 - Initial Public Release Description: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ Trader Ratings has evolved from my vB2 Buy/Sell/Trade User Rating System. This is a rating system for when members buy / sell / trade items from each other (presumably on a FS section of your forum). It is based on the honor system since there is no way to truly tell if they did engage in a transaction. (But I'm working on a way to fix that.) Trader Ratings came about because it was a pain to try and maintain a single thread listing good / bad traders and so far has worked out quite well. Features: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ Rate another 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 Display ratings over time Filter based on Buyer/Seller/Trade/or feedback they left for others Users can edit/delete ratings left for others (time based limitation) Admins & Mods can edit/delete anyone's ratings (just incase) Stats page showing best & worst rated members, and recent ratings PM notification when a person is rated Basic Info: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ I haven't written a FAQ or any real documentation yet, but the way the system works is very simple. The only part that might confuse someone is that the Feedback Score is based only on UNIQUE members. Also, there are simple checks in place to make sure they actually do select proper info and enter a comment. A user is not able to rate themself (obviously). Permissions for viewing / rating are similar to standard forum viewing / posting permissions. Also it checks to make sure users exist and all that good stuff. Installation Info: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ This hack is very simply to implement requiring only: 1 new file 5 new templates / 2-3 template changes (navbar, posbit/postbit_legacy, MEMBERINFO, memberlist_resultsbit) 52 new phrases 1 new DB table / 1 table DB change & index An install/upgrade PHP file is included to do all the template/phrase/DB stuff, so basically you run that, upload the file, and edit your postbit template. BAM! Screen Shots / Demos: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ See Screenshots below, or you can view them on my forums: My Trader Rating Page Standard Disclaimer: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ BACKUP YOUR DATABASE & FILES BEFORE IMPLEMENTING THIS HACK!!! Forums Using This Hack: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ EXTREME Overclocking Forums i-Club -- Forums Accord Tuner NSX Prime Honda-Acura.net Guns Network PimpRig (PM me your forum if you want me to add you to the list) Donations: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you. ![]() ![]() Plans For Future Releases: ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ rebuttal / followup comments item description (possibly instead of thread url) button on thread that buyer/seller clicks to tie the transaction to two people Download Now Only licensed members can download files, Click Here for more information. Screenshots Show Your Support
No members have liked this post.
|
|||||||||
|
#76
|
|||
|
|||
|
__________________
skylineSAUstralia No members have liked this post.
|
|
#77
|
||||
|
||||
|
Phew... a ton of posts while I was asleep! Okay to answer a few questions...
1. The next release v1.02 will have a few changes of the changes you guys have been describing. (I'm not going to go into details cuz I don't want to make promises I can't deliver.) 2. *Probably* in 1.03 will be an option that will tie a buyer & seller together with a thread (via a button on the thread which the buyer must click, then they will have the option to rate each other). However I don't want to get rid of rating people where there isn't a threadid, as some sites & people do deal via PM or other means. So there will probably be a split into "Verified" and "Unverified" deals, where the verified has a link to the thread and all that jazz. As for admin stuff, I know there needs to be something done to make it easier, but I'm having a hard time visualizing what the interface needs to look like exactly. If one person was giving a lot of people negative feedback, you can always go to his trader ratings and click the link to see who he left feedback for. I'll keep thinking about it, but the more input you guys can give me, the better. Also I was thinking of making a stats page showing the higest & most rated people, and also the lowest. Possibly the last few ratings. How many ratings per day, avg per day, etc... Lastly, I'm just curious, if I put up a paypal donate button on the first post, do you think any of you guys would dontate anything? I know this brings a lot of commerce to your sites, and also long-term member loyalty. I usually wouldn't do something like this, however I'm currently unemployed and in what little free time I have I've been spending all of it working on coding this, and helping people get it installed (and tweaked a couple servers too... hehe).
__________________
My Site: EXTREME Overclocking Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it. No members have liked this post.
Last edited by eoc_Jason : 03 Jun 2004 at 15:55. |
|
#78
|
|||
|
|||
|
One little error that I'm sure can be fixed easily I hope.
When I click Feedback Left for Others I get this message. Database error in vBulletin 3.0.0: Invalid SQL: SELECT * FROM wireless_user_rate_trade LEFT JOIN wireless_user ON wireless_user.userid = wireless_user_rate_trade.rateduser WHERE user_rate_trade.userid = 9 ORDER BY userdate DESC, userrateid DESC LIMIT 0, 30 mysql error: Unknown table 'user_rate_trade' in where clause mysql error number: 1109 Date: Thursday 03rd of June 2004 11:52:17 AM Script: http://www.wirelessmatt.com/forum/tr...u=9&viewtype=4 Referer: http://www.wirelessmatt.com/forum/traderratings.php?u=9 The user I selected positively left feedback for another, so at first I thought it was because the person didn't leave feedback for anyone, but that's not the case. No members have liked this post.
|
|
#79
|
||||
|
||||
|
Yahoon23 - that's a bug in the file, I forgot to add the ".TABLE_PREFIX." to the part after the WHERE clause...
Find line ~200 under the -> //Various View Types For Feedback Display under the switch case 4: -> //Feedback Left for Others WHERE user_rate_trade.userid to WHERE ".TABLE_PREFIX."user_rate_trade.userid I thought I got all the SQL table prefixes, but I guess I missed one... ![]()
__________________
My Site: EXTREME Overclocking Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it. No members have liked this post.
|
|
#80
|
|||
|
|||
|
Beautiful. Works like a charm.
Thanks alot. Also, for those of you wanting a quick-fix until an updated version releases with the Trader Rating in the member profile. I just went and edited the memberinfo template and added the same postbit conditional. It's not pretty, but for the time being, it's doing the trick. No members have liked this post.
|
|
#81
|
|||
|
|||
|
Wow! Looks great. Now only if someone would pick up where vbTrader has left off this would be excellent.
No members have liked this post.
|
|
#82
|
||||
|
||||
|
I love you
lolIt would be awsome to have the star system too... after 10 feedbacks it changes to yellow star, after 20, blue, etc. etc. etc. Maybe an About ME page too to let people create their own info page Heck, why not go all out and actually do an entire auction system to work for vbulletin. I'd pay ![]()
__________________
pbMessage.com No members have liked this post.
|
|
#83
|
|||
|
|||
|
I am still running into the same problem with it not showing up in the postbit, check out this thred http://www.gpfanatix.com/forums/showthread.php?t=2.
The following is the code in my postbit_legacy. By looking at the code, it should show up under join date correct??
No members have liked this post.
|
|
#84
|
||||
|
||||
|
Originally Posted by eoc_Jason
Put it up! :thumbup:
No members have liked this post.
|
|
#85
|
|||
|
|||
|
Do a complete classifieds/buy/sell/auction + your rating system.... :drool: I'd be all over that nad even pay a pretty penny.
No members have liked this post.
|
|
#86
|
||||
|
||||
|
Yeah, the stat page would be great.
No members have liked this post.
|
|
#87
|
||||
|
||||
|
You need to edit your 'postbit' template and add it there for your current style.
postbit = userinfo above the post (new vB3 style) postbit_legacy = userinfo to the left of the post (vB2 style) That's why it's not showing up... ![]()
Originally Posted by r6xual
__________________
My Site: EXTREME Overclocking Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it. No members have liked this post.
|
|
#88
|
|||
|
|||
|
Pimp!!. Thanks a ton, got it working now!!
*clicky install* No members have liked this post.
|
|
#89
|
||||
|
||||
|
Well, my long-term goal is to create a classifieds and auction add-in, and it will definitly integrate with these ratings. But that's a lot of code, and I'm still learning all the in's-and-out's of vB3, so this is a great primer. (Yes, it will be free too when I make it.)
In the mean time that's why I wanted to get a simple "transaction" button up that can be displayed on a per-forum basis. This will give some form of knowing who the buyer & seller are, and also tie it to a thread, then allow users to rate that "transaction". The shift from a thread to a classified/auction listing shouldn't be too difficult. I got a paypal button up on the first page, thanks again guys for all your support. I try to keep the first post updated with stuff that I'm fixing/adding. I'm hoping to have 1.02 posted this weekend. Upgrading should be fairly quick and simply, it's really just changes in the PHP file, a DB modification, and maybe some phrases (so the upgrade should all be automated). Thanks for the tip Yahhoon23, I wasn't sure if it could be a direct drop-in the members template or not, I'll have to check it out for myself. PaintballM - lol, eBay is going to sue my poor arse! But stars should be easy enough to implement, and also an "about me" page. Also maybe grouping users based on their stars would be good for the stats page? ![]() Another big thing I wanted to have was a selection for user location, in the same style that eBay does where it's just general-areas. I know a lot of my users just type random things like "in your closet" for the defailt location field. Maybe that can tie in with the "about me" page?
__________________
My Site: EXTREME Overclocking Do not PM me with your iTrader problems or asking for the code. I will just delete your PM without reading it. No members have liked this post.
|
|
#90
|
||||
|
||||
|
For those who do not have full size layouts, and only using something around 750-755 pixels, the leave feedback page distorts the layout. I will write a fix for those of us who have smaller layouts in a little bit.
__________________
pbMessage.com No members have liked this post.
|
![]() |
«
Previous Mod
|
Next Mod
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
| Mod Options | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 09:31.







