Buy/Sell/Trade User Rating System (aka eBay Style User Feedback Hack)

[eoc_Jason]

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 (https://vborg.vbsupport.ru/showthread.php?postid=389854#post389854)) 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 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=31749) hack written by EXCHANGE.

Also I would like to give a big thanks to all the members at the Extreme Overclocking Forums (http://forums.extremeoverclocking.com) 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 (https://vborg.vbsupport.ru/misc.php?s=&action=install&threadid=52188) 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 (http://forums.extremeoverclocking.com/)
www.sportscardforum.com (http://www.sportscardforum.com/)
www.honda-acura.net (http://www.honda-acura.net/)
www.graphcal-illusions.com (http://www.graphical-illusions.com/)
www.7thgencivic.com/forums/ (http://www.7thgencivic.com/forums/)
www.vb-host.com (http://www.vb-host.com/)
www.planetwrx.com (http://www.planetwrx.com/)

[xtremeathlonxp]

A screenshot would be nice
thank you

[eoc_Jason]

Lol.. I knew I was forgetting something!

Here's a single screenshot showing the:
- threadview
- profile page
- popup window

Please note on the popup window there is a [delete] box next to everyone's name, that is only seen (and useable) by admins & supermods... ;)

Positive feedback is green
Neutral is your standard color
Negative is red

You can change them in the code, very easy to do. Oh, and the FAQ link I made myself which isn't included in the code.

[xtremeathlonxp]

wicked I like it
xtreme kicks the install button

[eoc_Jason]

Muhahaha! First Victim! Errm.. I meant, user! :)

[Koutaru]

:) nice -- I'll be installing within the near future

[bgray]

This is absolutely awesome Jason! I've added it to www.sportscardforum.com and all seems to be running perfectly!

THANKS!

[JulianD]

Pretty good. I'm installing it :)

[Erwin]

Very well done. :)

[Vile]

Looks very nice, great job :)

[Mike Gaidin]

Looks sweet! Great job. :D

[trafix]

i think i better install it then

[Dean C]

Brilliant idea as i've already stated in the other thread :). However i can see one downflaw. The font colors for postitive/negative and neutral. :)

They should be defined as a hex in the ACP options IMO :)

Other than that and the lack of pagination (;)) it looks great :D!

Regards

- miSt

[cinq]

Pardon me for going offtopic , but what exactly is pagination ?

[Fi_InCogNiTo]

Just a couple suggestions to add on to this great hack:

1. Send user an email when feedback is left for them.
2. Allow the user who received the feedback to comment on the feedback left for them.

[eoc_Jason]

Mist - I know, I'm gonna add pagination in next... ;), also about the colors I think I'm to have to create something because I would like it to be a little more user definable (thought it's just that one line of code, not hard to find), but I was thinking of having the actual number color-coded too on the threadview & profile page.

cing - pagination (as mist has told me) is where you break up the posts into pages and have the numbers at the bottom (1,2,3....) It hasn't been on the top of my priority list since the user can just scroll down and I haven't seen anyone with over 20 comments yet.

Fi_InCogNiTo - 1. I can add that in fairly simple, but most people seem to notice their number change as soon as they post something. 2. Hmmm, so you mean like a rebuttle type comment? That is definitly possible, I'll have to sit and think about that for a while. So far the few members I have that got negative comments knew they were going to get them because a deal went bad...

Now for some questions of my own. Do you think there are too many new templates to create? I think I can consolidate and reduce the number down some. Don't worry, when I release the next version I'll be sure to include upgrade steps to make the transition as painless as possible. ;)

[drumsy]

Installed successfully at www.honda-acura.net. We'd love to have our name in your original post! :)

[CJi]

Template creation only took a few minutes, didn't see it as a problem myself.

I've added a field to supply the URL to which the feedback relates, this way users can't just add feedback to their friends, and if they do, they get found out. :)

[xtremeathlonxp]

CJi Plz release that as an add-on if the author doesn't mind that would be really nice to have.

[Larry@IOG]

edit* NM I should have read

Larry

[Fi_InCogNiTo]

Today at 01:53 PM eoc_Jason said this in Post #16 (https://vborg.vbsupport.ru/showthread.php?postid=387986#post387986)
Fi_InCogNiTo - 1. I can add that in fairly simple, but most people seem to notice their number change as soon as they post something. 2. Hmmm, so you mean like a rebuttle type comment? That is definitly possible, I'll have to sit and think about that for a while. So far the few members I have that got negative comments knew they were going to get them because a deal went bad...

It would still be nice to have an email sent just to inform the person of a new entry. If possible, it would be nice to have a link back to the users feedback page/profile and the member name and comment left in the email also.

And yep, a rebuttle type comment would be nice also.

I sent you a PM ;)

[eoc_Jason]

That was actually a feature I was going to add in, and have the comment hyperlink to the thread. I just had to make the decision to stop adding and tweaking stuff and finally get some code written out so other people could implement it.

I'll add that feature in on the next release, which I should probably have posted maybe this next weekend. ;)

Today at 05:00 PM CJi said this in Post #18 (https://vborg.vbsupport.ru/showthread.php?postid=388148#post388148)
I've added a field to supply the URL to which the feedback relates, this way users can't just add feedback to their friends, and if they do, they get found out. :)

[PurpleCow]

This is an extremely useful hack for my new board to be launched. Since my board will be a marketplace, where trading/buying/selling is done...i am also considering a few custom modules to be coded. This one will be integrated along with those hacks. I'll wait for your next release, which'll have more features.

Well done ! Keep up the great work, chief !

Cheers

[LavaNoX]

This is such a great hack idea, great work ;)

[eoc_Jason]

Just a little progress update, since I couldn't sleep tonight I worked some more adding in the features that some of you suggested.

Things I have added (this will be v1.1 when I post it):
1. Pagination - It defaults to the user's / forum's default page length if you don't specify a number, otherwise it is whatever you want it to be. (This really only involved taking like 5 lines of code from showthread.php, no reason to reinvent the wheel).

2. Submitting a URL - I checked out how CJi did it on his forum, and since I really didn't want to add an extra column in the popup window, I made it if they entered a URL it would make the comment text hyperlinked, otherwise it displays as normal. However this can be changed up with minimal editing.

3. User Definable Stuff - Just set some variables at the top of the usertrade.php so that you can set various things to your liking.

4. Changed the [delete] link to just a [X] in smallfont, and also made the username in smallfont to match the rest of the displayed info in the popup box.

Things left to do - Email Notification & Rebuttle Box.

Unfortunatly I haven't upgraded to vB 2.3.0 yet, and I know they changed up the email function some from the changelog, so I need to glance over the stuff to make sure it is compatible across various versions.

I'll post the updated version (I guess we shall call it v1.1) tomorrow afternoon when I get home from work. It seems to be running all smooth on my forum but I want to glance over the code one last time when I'm actually conscience and clean it up a bit.

Most of the changes were in the usertrade.php file, I think you will have to change only 1 or 2 templates and that is all to make the upgrade.

[eoc_Jason]

Also, on a side note, I'm trying to think up a better name for the whole thing, something short and sweet... About the only thing I can think of is: "vBTrader"

Any ideas or suggestions?

[cinq]

Thanks for the explanation Jason.

I think this is a really useful hack. For almost all sites which have some form of Buying and Selling and Trading going on , this sure is good to have.

Will definitely install this once the new version rolls out :)

As for the name , how abt vBTraderRatings ?

vBTrader sounds more like an intergrated classifieds system ... of cos if you could make that too i would be eternally grateful haha ... ok ok so i digress :D

[Dean C]

Mist - I know, I'm gonna add pagination in next... , also about the colors I think I'm to have to create something because I would like it to be a little more user definable (thought it's just that one line of code, not hard to find), but I was thinking of having the actual number color-coded too on the threadview & profile page.


This could simply be done by adding an option vbulletin options to select the color for positive,neutral and negative. Then put the global variable in the templates - problem solved :)

- miSt

[eoc_Jason]

There is one in the works, it's called vBay, just do a search for it, it's still being developed by some guy, but it looks to be very promising. Auction style & regular classified style listings... If he does pull it off I think it should become standard in vBulletin! :)

Today at 06:05 AM cinq said this in Post #27 (https://vborg.vbsupport.ru/showthread.php?postid=388353#post388353)
vBTrader sounds more like an intergrated classifieds system ... of cos if you could make that too i would be eternally grateful haha ... ok ok so i digress :D

[Dean C]

Such a feature would never get in simply due to the excess coding it would require and also because it would not be used by more than 25% of the audience (and that is being optimistic) :)

- miSt

[eoc_Jason]

Okay, I just posted v1.1 and in the zip there are new user install instructions, as well as upgrade from v1.0 instructions.

If you are upgrading it should only take a couple minutes of your time. You only have to run 1 SQL query, edit 1 file, and do a little template editing.

New Features:
- You can set the colors & style for the pos/neu/neg bar on the profile page.
- Pagination (can be fixed or set to user default page length)
- Other variables can be set at the top of the usertrade.php file (like date formatting, who can delete ratings and such)
- Profile page has a URL bar added so people can enter in the URL of the deal (it's not a required field), if they do then their comment text becomes hyperlinked, also I cleaned up the formatting a bit and things lined up.
- Removed a couple of custom templates that really wern't needed. (and thus you can delete)

I think that is it for now. I haven't had time to work on the email notification yet, I need to dig up that function or find out how vB does it so that it can mesh in.

You don't have to upgrade from v1.0 if you don't want to, there are no bugs that I know of that could break anything. You are only gaining new features with this release. :)

[drumsy]

Gonna do anything with the FAQ?? I've got the link on the site but no FAQ for my members to read..

[Dean C]

Wow this is amazing - i love these features you have added and you never know if i have any time free before my exams are over you may be the first person to get an install click from me in months ;)

- miSt

[eoc_Jason]

drumsy - Oops... I just made up my own FAQ for my site explaining about how it works, I didn't think anyone would really be interested in it, I forgot to remove that link before uploading.

Well, in anycase, I just updated the code and am going to upload it now. I named it v1.11, however the only changes are step 19 & 20 (Changing Templates "faq" & "faq2").

Mist - Man.... after all that work with pagination!!! I thought you would install it just for that feature along! LOL! ;)


Has anyone had any problems upgrading from v1.0? I think I made the upgrade instructions pretty clear, but I just wanted to make sure I didn't leave a step out.

[drumsy]

No problems upgrading but I still don't see the FAQ upgrade! :)

[eoc_Jason]

It's in the new file. Look at the very bottom of the install_v1.11.txt file, #19 & #20 are the two steps required to add it into your FAQ, then the link on the profile page will work.

Ack... I tried posting the code here, but it replaced all the things with the { }'s...

[alkatraz]

KICK ASS!!!

This hack is awesome!!!

Works like a charm!!

[ExcErr]

some questions and suggestions:
1. can you tell me, if some user has the rating "0" and someone gives 2 him negative comment, then user will have "-1" rating or?
2. it will be good to set up in admin panel, how offen one user can comment another.
3. can you make the top of most positive and most negative users?
thx.

[eoc_Jason]

ExcErr -

1. Yes, a user can (and would in your scenario) have a negative rating if they go below zero.

2. I'm not really sure you would want to restrict it, because I currently have users who are filling out all their trades which include multiple deals with one person. I don't think it makes much sense to say that you could only rate a person once a week or so. If you find a person abusing the system, is that really a person you want on your forum?

I could however add in an admin option to prevent a person from rating other people... that would make more sense than limiting how often they can rate other people.

3. That's a good idea, to expand on it a little more, how about if I make it so you can click on any heading to sort on that column in the popup window? That way you could do name, date, etc... Currently there is no sorting, it just lists them as they were entered in the DB... (So I guess you could say it is by date). But that is also why I color-coded it, so you can pick out the negative feedback easier.. ;)

[Dean C]

Jason - well i'm trying to fix some problems i'm having on my forums right now with the awards hack and editing of threads so until they are sorted and my exams are over its a negative :(

- miSt

[eoc_Jason]

lol... I just noticed Lesane's awards hack... and a while ago I wrote my own hack for badges that I give out to my members and ones that they can select... doh! (of course I am re-writing the code right now so it's not up)

[vB-Host.com]

Jason this is awesome.. I just installed it.. easy as pie.. I'm going to use this for our classifieds section so people can offer feedback on the seller/programmer/artist and also my customers can rate our service and people thinking of signing up with us for hosting can see our customer ratings in my profile :) awesome!

[vB-Host.com]

If anyone is intrested.. I made some mods here http://www.vb-host.com/vbhostrates.php?s=&action=show&rateuser=1 it includes a form to rate us on the same page of the feed back.

[:Judge:]

Super job!!

[eoc_Jason]

Just FYI, I don't know when I will be able to get the next release out with those last two features requested (and a few other little ideas I have). I've got a lot on my plate right now, I've got to upgrade my forums to 2.3.0 and reapply all my hacks. And I've been neglecting working on my folding stats (http://forums.extremeoverclocking.com/folding/) (if any of you fold I'm sure you have run across my stats page before).

But please, keep the suggestions coming, the new features that have been added since my original incarnation have been great and I think this is a worth-while hack to continually improve upon.

I was thinking of maybe somehow creating and integrating some sort of "auction / classifieds section". I am really hesitant about it though because I keep hoping vBay (https://vborg.vbsupport.ru/showthread.php?s=&threadid=44786) will be released soon... but it has been almost 2 months since the author has posted any new news so I'm thinking it could be a while, if ever...

I've got it all mentally figured out in my head, it's basically like cloning bits and pieces of eBay. A person can put an item up either for auction or for a fixed price, set a time frame the item will be up for, include a picture (or link more in their description), etc... Then other members can either bid or buy the item...

Another reservation I have about doing such a huge hack is the release of vB3... Anyone know an estimated date when it will become available (and non-beta)?

[Smoothie]

vBay looks like a dead one. I was really hoping that someday it would be released. The combination of this hack and vBay would be awesome.

[CJi]

Indeed it would :(

[ExcErr]

Today at 01:59 AM eoc_Jason said this in Post #39 (https://vborg.vbsupport.ru/showthread.php?postid=389498#post389498)
ExcErr -

2. I'm not really sure you would want to restrict it, because I currently have users who are filling out all their trades which include multiple deals with one person. I don't think it makes much sense to say that you could only rate a person once a week or so. If you find a person abusing the system, is that really a person you want on your forum?
on my forum it will be great, because many people add comments only for fun like "positive. he is a good man". and for me it's very difficult to keep it clear.
if it isn't very hard to make this addon, make it plz for me. thx in advance.
3. That's a good idea, to expand on it a little more, how about if I make it so you can click on any heading to sort on that column in the popup window? That way you could do name, date, etc... Currently there is no sorting, it just lists them as they were entered in the DB... (So I guess you could say it is by date). But that is also why I color-coded it, so you can pick out the negative feedback easier.. ;)

it would be great to have some special pages like "posusers.php" and "negusers.php". there will be displayed "user status(online or offline)", "user rating status(how many points user has)" and the link to comments. admin will set up how many negative and how many positive users will be displayed. and sorting would be nice, because many people like sorting, you know what i'm talking about.

[eoc_Jason]

Okay, okay... I'll add in a time restriction, it won't be too hard since I'm recording the date (note, date only not the full time, though I can change that if you need it to be more exact).

One question though, how do you want to limit it? For example: Would you want to limit me to rating only 1 person a day? Or only 1 rating per-person per day?

If you really want to put a fixed limit on it now before I release the next version, let me know and I can either tell you how to edit the usertrade.php file or upload a modified one.

Second, sorry I missed your 3rd question about the top people listing... yeah, that would be very easy to do. ;)

I'll update the main page with the to-do stuff later in the day (it's 5am here)... Looks like v1.2 already has some good features to add! :)

[ExcErr]

thx, that you will make this limit addon.
For example: Would you want to limit me to rating only 1 person a day? Or only 1 rating per-person per day?
example: excerr can add 1 comment to (for exampe) eoc jason 1 time per week(months, year, day, hour...)

[eoc_Jason]

Excerr -

This is just a real quick thing I threw together, it works, but I'm sure if I sat down and thought about it I could do it better (which I will in v1.2). I tried posting the code in the page but it messed up the parenthesis and stuff so I'm attaching a file... just 3 steps...

I think when I release 1.2 I'm going to have to change the date field to a full datetime field so that you can fine tune your limiting thing, but also for sorting purposes...

[ImportPassion]

what I would like to see is, u have to put a valid thread or post id for the rating of the transaction and verify that the user was part of the transaction. Maybe include something in the post for the seller that they click on a button to say this is the buyer. then ur script could verify against it.
Reason being, ppl are getting rated for stuff that never happened and putting bad remarks. Abusing it more or less.

Derek

[ExcErr]

thank you very much.
v1.2? when it will be ready? i'm waiting for it, great.

[eoc_Jason]

I can verify threadid, but actually verifying people is a whole different issue. One problem arrises, say the person selling the item never shipped it, and thus the buyer gave them bad ratings... If I made it so the seller entered a field with the persons name, the seller might choose not to do it (or even might forget to do it). Another scenario is members who deal but through PMs and not an actual formal thread...

That's why I'm starting to think it might be better to just create the full blown auction / classifieds rather than keep doctoring up just the current ratings...

On my forum I really don't have a problem with members abusing it, they all are pretty honest.

Another idea would be if a member abuses it, set an option in their profile so that they can't rate (or be rated)... would that be a possible solution you think?

Jason

Today at 08:38 AM 7thgenCivic.Com said this in Post #52 (https://vborg.vbsupport.ru/showthread.php?postid=389934#post389934)
what I would like to see is, u have to put a valid thread or post id for the rating of the transaction and verify that the user was part of the transaction. Maybe include something in the post for the seller that they click on a button to say this is the buyer. then ur script could verify against it.
Reason being, ppl are getting rated for stuff that never happened and putting bad remarks. Abusing it more or less.

Derek

[atomic fireball]

Jason, this is one awesome hack.

I'm new to vBulletin, and even I was able to install this hack with ease, and it worked like a charm. Excellent work!

I do have one seriously minor suggestion in that perhaps in the popup that shows the user's feedback there could be a header or footer that has somethign generic like, "How to leave feedback" and a link to the FAQ. The only reason I suggest this is that I assume many users will only see the feedback number next to the Trader Rating, click it, and wonder how to leave feedback. Having the answer right there would answer a lot of questions.

Once again, great work on this hack!

[atomic fireball]

Jason, I made one change to my board's version of your hack by creating an "add.gif" to replace the "go.gif" which appears on the user profile. (On the profile, since the "go" is placed next to the optional URL, it may appear that this means 'go to the url'), so I just wanted people to be sure that that's the icon to click to add the feedback. [I also had to change the "go.gif" to "add.gif" in the newly created "getusertradeinfo_rating" template.]

Since I created this icon anyway, I just upped it here in case anyone else wants it.

Thanks again for the excellent hack!

[eoc_Jason]

atomic fireball:

Yeah, add would be more appropriate, but I tried to reuse as much standard vB stuff as possible to minimize the cutomization. But yes, very sweet little button. :)

As for the popup window, yes that is a good idea, I'll add something like that in v1.2, it's simple enough...

I'm actually starting to think maybe it shouldn't be a popup, but a full page, with the rating submission boxes at the bottom of the list of ratings... I dunno, I'll have to tinker with it on my own site and see how it looks...

[atomic fireball]

Jason, I hear ya. The less necessary add-on graphics the better. However, if you want to have one other small eBay like feature that would be really nice, it would be a simple star icon placed next to the user's trader level (or on his/her profile) with a different colored star for each level they reach. (Similar to eBay.)

If you are busy and need somone to make any graphics or whatever, I'll be happy to pitch in.

Thanks again for the excellent hack!

[ImportPassion]

That is possible, but with almost 8000 users, I would have to rely on users to tell me. Rather have it all automated if possible.

D


Yesterday at 09:50 AM eoc_Jason said this in Post #54 (https://vborg.vbsupport.ru/showthread.php?postid=389937#post389937)
I can verify threadid, but actually verifying people is a whole different issue. One problem arrises, say the person selling the item never shipped it, and thus the buyer gave them bad ratings... If I made it so the seller entered a field with the persons name, the seller might choose not to do it (or even might forget to do it). Another scenario is members who deal but through PMs and not an actual formal thread...

That's why I'm starting to think it might be better to just create the full blown auction / classifieds rather than keep doctoring up just the current ratings...

On my forum I really don't have a problem with members abusing it, they all are pretty honest.

Another idea would be if a member abuses it, set an option in their profile so that they can't rate (or be rated)... would that be a possible solution you think?

Jason

[eoc_Jason]

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...

However, don't give up hope. I posted in the vBay thread that I would like to take on the idea of the project and create an "eBay Lite" add-on for vB. I call it lite because it will have the same core functionality, just strip off some of the pay value-added stuff like highlight your listing, or featured auctions, etc... Creating this system will allow a user to post an item & pictures, create it either as an auction style, or a fixed price, choose a category or categories, etc... The other members can bid or choose to buy the item. Then you have fixed and tracked the buyer, seller, and actual transaction. You can then link that to allow feedback afterwards...

This system I just described I think would fit better for people who want something more that just the basic feedback hack that I have created in this thread. I'm guestimating a month or less for full development and testing before something is released. I already got a couple offers for help in the other thread for starting up this project. :)

I will continue to develope out this hack though (trader ratings), for people that want something light and simple to implement, but for some of the features that you people want I think would be better suited if you wait for "vBay" to be released... ;)

[Dean C]

May i ask when you "plan" to release vBay :)?

- miSt

[xtremeathlonxp]

Very good idea I would be interested in beta testing if need be.

[eoc_Jason]

I can give you a better time estimate once we actually get the ball rolling. I was planning on contacting the people who offered to help this weekend and start to create a project plan since I know this is a huge undertaking.

I'll make you this promise, it will be before the 4th of July, even if I have to do it all by myself... :) But more realistically I would like to get it out by the end of this month if possible.

Jason

Today at 01:47 PM Mist said this in Post #61 (https://vborg.vbsupport.ru/showthread.php?postid=390515#post390515)
May i ask when you "plan" to release vBay :)?

- miSt

[Dean C]

That's great to hear Jason :)

I look forward to the release :D

- miSt

[Fi_InCogNiTo]

U still adding a rebuttle feature?

[eoc_Jason]

Fi_InCogNiTo -

Yes, I will continue to develop out this hack for people that want something "lite" and simple to implement, but some sites I have seen that do heavy trading would benefit more from a full fledged auction/classifieds hack. :)

[PurpleCow]

Does this work on ver2.3.0 stable release ?? Anyone installed on vB230 ??

Thanks for the feedback !

Cheers

[atomic fireball]

Yup! I installed this on my virgin vB 2.3.0, and it works like a charm.

[Fi_InCogNiTo]

Would it be possible to put up some sort of a flag if there's any negative feedbacks? Maybe show a percentage of positive/negative (Kinda like eBay does now) Just a thought.

[eoc_Jason]

Well, it tells you totals on their profile page, you could do a little hacking to display it on the postbit. I tried to avoid doing that becuase it would create a more of a load than it is worth imo.

Also, I just upgraded my forum to 2.3.0 and it ran without any problems, I'll add it to the first post.

[GoTTi]

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.

[eoc_Jason]

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?

[GoTTi]

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....

[GoTTi]

not even a page, maybe on the member list page, to have their rank count listed, and be able to sort them.

[GunsNetwork]

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/showthread.php?s=&action=showpost&postid=954692
Referer: http://www.gunsnet.net/forums/showthread.php?s=&postid=954692#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

[Fi_InCogNiTo]

@bowhunt

Looks like u never ran:

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;

[GunsNetwork]

I ran it.

[GunsNetwork]

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

[eoc_Jason]

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. :(

[GunsNetwork]

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.

[eoc_Jason]

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


http://www.gunsnet.net/forums/forums/showthread.php?s=&action=showpost&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 (https://vborg.vbsupport.ru/showthread.php?postid=392332#post392332)
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/showthread.php?s=&action=showpost&postid=954692
Referer: http://www.gunsnet.net/forums/showthread.php?s=&postid=954692#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 (https://vborg.vbsupport.ru/showthread.php?postid=390503#post390503)
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 (https://vborg.vbsupport.ru/showthread.php?postid=393504#post393504)

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:

[lifesourcerec]

That ticket idea would be good, but it is going to confuse a lot of people.

[lifesourcerec]

05-04-03 at 05:33 PM Fi_InCogNiTo said this in Post #69 (https://vborg.vbsupport.ru/showthread.php?postid=391235#post391235)
Would it be possible to put up some sort of a flag if there's any negative feedbacks? Maybe show a percentage of positive/negative (Kinda like eBay does now) Just a thought.

Yeah, I was thinking that or a way to list the positive, negative, neutral in postbit.

[lifesourcerec]

05-01-03 at 01:45 AM vB-Host.com said this in Post #43 (https://vborg.vbsupport.ru/showthread.php?postid=389710#post389710)
If anyone is intrested.. I made some mods here http://www.vb-host.com/vbhostrates.php?s=&action=show&rateuser=1 it includes a form to rate us on the same page of the feed back.

Can you give me the code for that? Instead of being in profile, I want to just have a separate page where I can make a "Leave Feedback" button.

[eoc_Jason]

1. In the next version there will be post/neu/neg feedback totals available on the postbits page with no added queries.

2. The "ticket" idea might be doable... I think more of a "make an offer" button would be better, opening up a window that would be sort of like a PM to the thread creater (seller) which the person can fill out info like the item they want to buy and the price. Then the seller can either accept the offer or reject it, and optionally close the thread (sometimes people post multiple items, so it's not always feasable to close a thread).

However, something like this would require some hacking with the PM code, adminCP (possibly), threadview, and who knows what else... I'm up to the task, but it is starting to stray from the simple hack that I intended it to be.

Anyhow, I've been swamped at work this week and when I come home I've been having to do a lot with my own website, and this weekend I will be going out of town. So it looks like v1.2 will be at least a couple weeks (if not more) down the road. I am going to try and incorporate as many features as possible that everyone has suggested (without over complicating the whole thing).

I will try to work on that bug asap with the random DB errors, I'm sorry I haven't had a chance to look at it sooner.

[atomic fireball]

I really like the idea of a separate page where one can view feedbck and leave feedback as well. Nice.

Stealing from ebay, another easy addition would be possibly adding the "member since: XX/XX/XXXX" line to the feedback view, just so it would raise eyebrows easier if you see a guy with lots of positives, and he just joined. This info is located elsewhere in the forum, but just makes it easier to view in one spot with the feedback.

Or, stealing yet again, a small icon next to the trader rating in the postbit to show the levels of positive feedback without even clicking it. White star under 10 positives, blue star over 10 positives, Gold star after 100+, etc.

All should be fairly easy to impliment.

If you need any graphics, let me know, that's my thang. :)

[bandersen]

Thank you for the hack!

I followed the instructions for version 1.11 and username in postbit is not there anymore. I do have the Lesanes hack in there. There is more stuff missing I guess.... ??

[eoc_Jason]

Atomic Fireball - I've been considering making the whole feedback page & feedback submission into one custom page instead of the popup window & profile page. I think this would eliminate confusion and also reduce code hacking on other files. I suppose it really wouldn't be that hard to allow for either choice, I'll be sure to include that in the next release.

Speaking of which, as for the next release guys, I can't give you any ETA since I've been so tied up with other things, perhaps since I have a 3 day weekend coming up I can sit down and work on it some. :)

[atomic fireball]

Sweet, thanks for the update jason.

I'm looking forward to the next release.

[Odysseus]

05-15-03 at 07:44 AM eoc_Jason said this in Post #94 (https://vborg.vbsupport.ru/showthread.php?postid=395338#post395338)

2. The "ticket" idea might be doable... I think more of a "make an offer" button would be better, opening up a window that would be sort of like a PM to the thread creater (seller) which the person can fill out info like the item they want to buy and the price. Then the seller can either accept the offer or reject it, and optionally close the thread (sometimes people post multiple items, so it's not always feasable to close a thread). [/B]

Also a possibility, but I think it's even more complicated then my version. :)

You basically need one new table, some new templates and one IF-ELSE-clause in order to check if there's a record in the table. :)
(OK, a few more things, but that's just the basis).

[gmarik]

Has it an itegration with PayPal? What would be great, like the hack Mist is working on...

[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 (https://vborg.vbsupport.ru/showthread.php?postid=399811#post399811)
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 (https://vborg.vbsupport.ru/showthread.php?postid=392332#post392332)
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/showthread.php?s=&action=showpost&postid=954692
Referer: http://www.gunsnet.net/forums/showthread.php?s=&postid=954692#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 (https://vborg.vbsupport.ru/showthread.php?postid=403514#post403514)
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.

[Doc203]

Thanks, and yes the button will help. For now I will just add that.

[ExcErr]

what about v2/0?
"somebody" promised to make it:)

[eoc_Jason]

There will be a v2.0, which will contain some new features, bug fixes, and various changes... However it will probably be the last one since I'm focusing more on a "heavier-duty" solution for the whole FS/WTB thing...

[atomic fireball]

Sweet. I'm looking forward to it! Thanks, Jason!

[Ian Cunningham]

Can't wait for V2.0! What do you plan for the "heavy duty" thing?

[Stu]

Hi,
Great hack.

Could someone tell me where I can change the words "Trader Rating" in the post bit.
For the life of me I can't find it!

I know it's comming from $post_usertraderatings but can't find the text, I just want to change the wording.

cheers.

[mr.children]

hello...i am kinda dumb and new to this vbb thing...
could you please kindly explain to me what is
-----------------------------------------------------------------
2. Execute the following SQL Queries (Can be done in PHPMyAdmin):
-----------------------------------------------------------------

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;

-----------------------------------------------------------------
// END Queries
-----------------------------------------------------------------

does that mean i have to get telnet software connected to my database and key in all the commands (or simply copy and paste?) i tried copy and paste, but endless errors show up and my database screwed...please...teach me how to get your hack installed in my site...thanx

[Stu]

run PHPMyAdmin then select your vB database then select SQL
now paste the code below but do not include the ending semi colon ; from the code above
now click go and the PHPMyAdmin will run the commands and create the table.
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)
)

now do the same with the second query

ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL

[mr.children]

thank you stu...
but what is phpmyadmin? a program i have to download?
seriously, i am learning everything from scratch now...
please help, thanks!

[atomic fireball]

Today at 11:54 AM mr.children said this in Post #119 (https://vborg.vbsupport.ru/showthread.php?postid=411387#post411387)
thank you stu...
but what is phpmyadmin? a program i have to download?
seriously, i am learning everything from scratch now...
please help, thanks!

phpmyadmin is a "visualizer" for your MySQL database. It allows you to navigate the database in a Graphical User Interface and run queries, insert things, etc., all without having to do things in command-line format.

The ISP that hosts your forum should be able to set this up for you. There's also a hack here that allows you to run simple queries from the vBulletin ACP I think. Although, I've never used it.

Hope this info helps.

[mr.children]

thank you...but where to find the phpmyadmin thing?
should i look it up in download.com?

[Fi_InCogNiTo]

<a href="https://www.phpmyadmin.net" target="_blank">www.phpmyadmin.net</a>

[Logician]

Why is this step needed?


-----------------------------------------------------------------
3. Find in showthread.php (around line 58):
-----------------------------------------------------------------

LEFT JOIN user ON user.userid=post.userid

REPLACE with:

LEFT JOIN user ON user.userid=post.userid,ratetradetotal

-----------------------------------------------------------------
//END showthread.php
-----------------------------------------------------------------


As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;) and all user table fields are already received in the query in part:

user.*


So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showthread.php?s=&action=showpost&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI. :)

[Les Shaw]

Hack works well but when I click the trader rating in the thread I get a java script error ?
But no error if I click on it in the profile?

Any one have a fix for me :)

http://www.thecomputermechanics.com/forums/

[8ballstudios]

Jason,

Sorry if someone has already asked this question, I've tried to read all the messages in this thread.

Can this hack work similar to heatware.com? It looks like you have all the same features, the only difference that heatware.com allows users of several different websites to be rated (some of which are not vbulletin forums).

I plan on having a rating system for my forums (vbulletin 2.3.0 hosted), but want to make the rating system available to 4 additional sites as well (some vbulletin hosted, some not). I would do this on a seperate domain (a la heatware), not the same domain as my forums.

Is this possible?

Thanks!

Kevin

[PurpleCow]

Hello,

I am getting this error when i run the alter table query.

When i run this query
ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;

I get the following error :


SQL Error 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0

I am running on the latest version of mysql, that is almost.

Kindly help me with the right syntax.

Thank you

[PurpleCow]

Okay, sorry, I did a mistake.

I was supposed to run the ALTER Table query seperately, i suppose. I did that now and everything went fine and infact the hack is working fine on my boards now.

Thank you

/me clicks on install now

[Imprezer]

Great hack!

Installed on www.i-club.com

Feel free to use my site as a sample!

[The Realist]

Nice hack M8, well done.

[ImportPassion]

06-27-03 at 03:32 AM Logician said this in Post #123 (https://vborg.vbsupport.ru/showthread.php?postid=413271#post413271)
Why is this step needed?



As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL;) and all user table fields are already received in the query in part:

user.*


So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showthread.php?s=&action=showpost&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI. :)

ya, i saw that too, i just ignored it. mine has been working fine.


D

[ImportPassion]

BTW, how is V2 coming along?

[EVO VIII Chris]

-----------------------------------------------------------------
2. Execute the following SQL Queries (Can be done in PHPMyAdmin):
-----------------------------------------------------------------

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;

I am not familiar with PHP and I am still learning it. I am wondering where I put this? Do I put it in my php.ini file somewhere. If so could you show me exactly where? I have got everything completed except for this.

Thanks this is an awesome hack
Chris

[devrykid]

I am trying to install this hack on my website devrykids.com which is located on ipowerweb.com and is running phpMyAdmin 2.4.0 and was wanting to know if anyone could help me set up i'm stuck on number 2 in the installation file..

THanks
Matt

[CJi]

Has anyone tested this with vB3?

[FastAttack]

Has anyone tested this with vB3?

yeah this should be a nice addition to 3.0 :)

[RS25com]

One more suggestion, if you don't mind, and it might even be a simple one.

Instead of a single number rating like (10) I think a dual number system would be MUCH better, such as (12/2) Clicking the appropriate colored number will display JUST the positive or JUST the negative feedback.

In case this isn't completely obvious, this actually shows how many positive and negative votes a person has. I personally think the eBay system is flawed because of the easy ability to see positives versus negatives. Someone with a lot of transactions can hide some pretty serious negatives off the first page of their feedback.

I'm going to use it anyway, but that would clearly make this hack better, and (without knowing how you do the queries/output) you can probably remove some calculations which get your total figure.

[asiago]

installed really easily, and just love it! thanks for the cool mod

[pdatoon]

why no new posts?

[pdatoon]

Hello,

Just 2 questions.

Is it possible to make the URL thread field MANDATORY (must insert)

Is it possible to make the feedback in the postbit appears only when there is at least 1 feedback?

[ludachris]

Suggestions for V2

1. Make a new feature that allows you to see all comments left by the user whose profile you're viewing. This way, you can see trends in how they rate other users. This would be mainly for admins, but it can also help others determine how much "weight" to give this person's feedback. As it stands now, you can see all comments "given" to the user, but not all comments made "by" the user on the profile page.

2. Rebuttal comments are very necessary.

3. Email notification to each user when new ratings are added to their profile.

4. Suspension from using the feature on a member-to-member basis. Disallowing certain members from using the tool if they've abused it.

5. Prevention of allowing certain usergroups to be rated. I have a vendor usergroup who I don't want to be rated. I want this to be a trader rating system, not necessarily a vendor rating system.

6. Making the different rating counts clickable - right now, there are 3 numbers to display how many ratings are positive, neutral and negative. I'd like to make those numbers hyperlinked so that users can read only the negative, instead of having the option to only read ALL ratings.

Great hack by the way....

Can't wait for someone to finally come up with a vBClassifieds system. I've been asking for that for years. Glad you're taking it on.

[atomic fireball]

Excellent suggestions!

I'd really like to eventually see this hack evolve into a v2. it's an excellent hack, and with a few of those suggestions added, it would be even better. I love this hack!

[atomic fireball]

...another suggestion would be the addition of a feedback percentage under the overall rating a la eBay. Like:

Trader Rating (34)
Positive Feedback: 98.9%

etc.

[pdatoon]

Hi guys,

Does anyone know how to increase the text allowed in the comment field? When people enter long comments, it is truncated.

Any ideas where the limit variable is located?

[eoc_Jason]

Sorry you guys for kinda leaving you all hanging...

With the imminent release of vB3 I'm not developing this script any more...

HOWEVER, there will be a much more elaborate system that I am working on to make a functional FS/WTB section that has auctions, classifieds, and whatnot, and it will be free.

Please, just be patient. :)

[ImportPassion]

sweeeet.... drool.....

[Imprezer]

You can add my site to the list of sites using this hack.

www.i-club.com

Thanks for a great hack!

[FastAttack]

add http://www.srtforums.com to the list as well.

Although I hope to see the 3.0 version pretty soon since we are upgrading ;)

[Imprezer]

SRT's are slow. j/k. ;)

[FastAttack]

SRT's are slow. j/k. ;)
don't get me started on that lol

the suburu that I want in my hands is the STI ;) hehe

[cyzoonic]

We have been using the trader ratings too but not since we upgraded to v3. Hope to see a new version for 3 soon as everyone wants it back :)

-Stefan
http://www.3si.org/

[Spinball]

It's considered an important feature of our board at
www.avforums.com
And I don't think I can upgrade to Vb3 until there is a version of this hack working for it!

[eoc_Jason]

Just FYI, I'm not going to be releasing anything until vB3 goes gold, simply because I'm still learning the vB3 system, and also I don't want to deal with possible issues of code changes between RC4 and whatever is down the road.

In the mean time, if you are running vB3 and would like to display your users current ratings you can add something like this into your postbits template:


<if condition="$post[ratetradetotal]"><div>Trader Rating: ($post[ratetradetotal])</div></if>


The SQL already pulls all the users data from the post table, so you can add the total in without having to modify and PHP files.

[hasan2k]

Just FYI, I'm not going to be releasing anything until vB3 goes gold, simply because I'm still learning the vB3 system, and also I don't want to deal with possible issues of code changes between RC4 and whatever is down the road.

In the mean time, if you are running vB3 and would like to display your users current ratings you can add something like this into your postbits template:


<if condition="$post[ratetradetotal]"><div>Trader Rating: ($post[ratetradetotal])</div></if>


The SQL already pulls all the users data from the post table, so you can add the total in without having to modify and PHP files.

Now that VB 3 Gold is released, would you please let us know if you have any plans to update the hack? I will be waiting for your reply.

Your hack is by far the most useful hack I have seen on VB

[Hurricane]

I too look forward to seeing this as a VB3 hack. :)

[Ian Cunningham]

Me too - it was really useful for VB2

[hasan2k]

Me too - it was really useful for VB2

Lets all butter "eoc jason" up. May be only then he would know what a hot this hack. I come here once a day to check if he has updated the hack.

[drumsy]

Just FYI, I'm not going to be releasing anything until vB3 goes gold, simply because I'm still learning the vB3 system, and also I don't want to deal with possible issues of code changes between RC4 and whatever is down the road.


Jason,

Just wanted to also state that I am looking forward to the release of the vB 3.0.0 version of this hack. It's something sorely needed on my website! :)

[Soul2k]

ya i want to see this on vb3 too such an awesome hack ^^

[ludachris]

Man, I was so bummed after I upgraded to VB3 to learn that this hack wasn't available yet.... everyone on my site is waiting for it to be turned back on.

[eoc_Jason]

Maybe I'll get to it this weekend, I've just had so much to do lately and not enough time to do it...

<Jason's Famous Quote>I've only got two hands!!!</Jason's Famous Quote>

[bgray]

Jason,

I'm adding my name to those that would be in debt to you for this update. I've had this hack since day one and consider it one of the best. In fact, I'm not going to vb3 until it is available because it is such an important part of my forum.

Thanks for making it in the first place! ;)

[Spinball]

Maybe I'll get to it this weekend, I've just had so much to do lately and not enough time to do it...

<Jason's Famous Quote>I've only got two hands!!!</Jason's Famous Quote>
Yeah go - on PLEASE !!! :D :D :D

[Godzilla MR2]

Please. I have 6000+ users that will want my head if they dont get their trader ratings back.

I like my head.

[adusei]

YUP - definitely we need the version for vB3+; would be great to see it soon!!!!!
Very fine Hack - super!

adusei

[LancerForums]

I'd love to have this hack for vb3 as well. All the members miss this one. I think it's THE most useful hack we've ever had.

Mark

[Sports.N.Cards]

I too am waiting for this too be released for vB3. It's a great hack, and my site centers around it. I upgraded to vB3 without thinking, and it isn't made yet.

So add me to the list of sites in great need for this hack.

- Phil

[Tilmanitou]

Thanks a lot to eoc_jason for porting this very important hack to vB3!
I'm very glad to hear that he will do it, because without this hack i cannot upgrade to vB3. can't wait for it! hope you get it to work soon!

[eoc_Jason]

It's coming along slowly... There's going to be more features and a different layout than the version for vB2. My biggest enemy right now is just free time... :(

[Spinball]

Aye well you've seen the amount of interest there is in your hack. You'll be earning yourself a whole bunch of good karma points when you finish it :)

[Francis96se]

sounds awesome! good luck with it! i have lots of users who always ask me about it!

[Sports.N.Cards]

It's coming along slowly... There's going to be more features and a different layout than the version for vB2. My biggest enemy right now is just free time... :(


Great :) I'm looking forward to seeing it out. I'll be the first to install. Time, what is that? I seem to have too much of it.

[GamerJunk.net]

Damn I need this for VB3

[Sports.N.Cards]

Damn I need this for VB3


Just get in line. :nervous:

[drumsy]

Still very interested in the vB3 version for this. I turned down an offer to utilize a third-party system because I wanted to remain in-house with this system. Looking forward to its release date! :)

[eoc_Jason]

Still working on it, there's been other issues affecting my life that has caused me to put some of these side projects on the back burner and take care of the important stuff first.

I'll probably do a quick beta test with a couple sites before posting rev 1, to get the kinks worked out and some feedback incase there are last minute changes that need to be done.

[Watson]

nice 1 mate, cant wait for this hack on v3 :D

[eoc_Jason]

Okay, I'm just about ready to wrap this thing up for the first release on vB3, however, I would like to do a little beta testing first, just to make sure everything is okay.

Can a couple people PM me who meet the following requirements:
1. Ran this hack on vB2 and have signifant trade data.
2. Have upgraded to vB3 (and still plan to continue use of this hack)
3. Would be willing to implement a pre-release version to make sure there are no bugs / issues.

If nobody PMs me by wednesday, I'll just go ahead and post it as v1 for vB3...

[RonH.]

Okay, I'm just about ready to wrap this thing up for the first release on vB3.........If nobody PMs me by wednesday, I'll just go ahead and post it as v1 for vB3...That's good news!

[djroketboy]

hey i'm willing to beta test it for you.. we have ~4k members...

hpoa.org :)

(there was no reply email address)

[Spinball]

PM sent. 1305 users with a trade rating already.

[Imprezer]

I can do some testing.

27,000+ members.
Lots of Trader data

Let me know.

- Alex
www.i-club.com

[eoc_Jason]

Okay thanks for all the PMs guys. I think I have enough testers now. I'm going to get back to coding to finish up the hack... Don't feel offended if I didn't reply to your PM, I'm just pressed for time and would like to get this hack posted asap. ;)

[Spinball]

I'd like to make one point in anticipation of the forthcoming hack.
Before I installed this hack for vB2, we ran a manual rating system. And after installing the hack I set the user trade ratings to have the number of points brought forward from previous trades.
So if you recalculate the total number of rating points and overwrite this value based on the number of points in the user_rate_trade table, we'll have a problem.
Can you confirm that you do or preferably don't do this?

[eoc_Jason]

Spinball - I thought I sent you a PM about this...

Anyhow, to answer your question, you don't have to update the column in the user table, however the rating being displayed on the thread view will not be in sync with the rating on the Trader Ratings display page.

The actual Trader Rating is now based on unique member feedback, however the full TR page breaks it down into all feedback (and over time) so that people can see the bigger picture.

The column in the user table was meant as a means of bypassing TR calculations when users view threads. It is not used for any calculations of the TR page itself.

I'm not sure why, but I can't post any attachments in this thread, otherwise I would show you what the new TR looks like.

[eoc_Jason]

Okay everyone, you can find Trader Ratings for vB3 here:

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

[Limpkinw]

I can give you a better time estimate once we actually get the ball rolling. I was planning on contacting the people who offered to help this weekend and start to create a project plan since I know this is a huge undertaking.

I'll make you this promise, it will be before the 4th of July, even if I have to do it all by myself... :) But more realistically I would like to get it out by the end of this month if possible.

Jason
I know projects tend to get held up but is this still in the works?

[Polo]

has anyone installed this hack in version 3.0.3?

[Spinball]

Yes, it works fine at www.avforums.com

[Polo]

Wow, thanks for the link...

The site is really nice and the system seems to work nicely...

regards,

[lifesourcerec]

Wow, thanks for the link...

The site is really nice and the system seems to work nicely...

regards,

The new name is Trader Rating. Look for it in the VB3 forums.

[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]

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.