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)

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!

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

Super job!!

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 (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 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)?

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.

Indeed it would :(

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.

Quote:

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.

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! :)

thx, that you will make this limit addon.
example: excerr can add 1 comment to (for exampe) eoc jason 1 time per week(months, year, day, hour...)

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

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

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

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

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!

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!

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

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!

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

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

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

- miSt

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

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

That's great to hear Jason :)

I look forward to the release :D

- miSt

U still adding a rebuttle feature?

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

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

Thanks for the feedback !

Cheers

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

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.

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.

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.

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?

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

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

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

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

I ran it.

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

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

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.