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

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

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:
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/showth...t&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. :)

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/

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

Hello,

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

When i run this query
I get the following error :

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

Kindly help me with the right syntax.

Thank you

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

Great hack!

Installed on www.i-club.com

Feel free to use my site as a sample!

Nice hack M8, well done.

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


D

BTW, how is V2 coming along?

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

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

Has anyone tested this with vB3?

yeah this should be a nice addition to 3.0 :)

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.

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

why no new posts?

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?

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.

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!

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

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?

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

sweeeet.... drool.....

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

www.i-club.com

Thanks for a great hack!

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

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

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/

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!

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:

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

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

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.

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

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

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.

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>