User Ratings

This is a simple User Rating System, I hope you guys like it.

Features:

• Rate another User 1 to 5 points.
• Users can see how they rated a user before
• Votes are updated to avoid cheating
• Users can see who rated them but not how (works like the whoposted stuff)

Anyway
BACKUP YOUR DATABASE and ENJOY

German version available in my forums.

Screenshot

[Bro_Joey_Gowdy]

Nice hack

[X-Fan]

I'd like to know how to add the option to rate a user from their posts as well.

It would also be good to prevent people from voting for themselves, just to keep things fair.

Any suiggestions as to how to do the above?

[fasthu]

maybe I'm retarded but all mine says is Ratingno Votes)
and under user options the radio buttons for user rating or unchecked.

and how do I vote?!

Awesome mod...
thanks in advance

[EXCHANGE]

You can vote in the members profiles.
If not you'll have to check your installation again. If you did everything right the hack has to work.
Also works in 2.2.6

[Mystislav]

Well I guess I'll be installing again.. When I modifeid the Members.php lots of ++++ed up ++++ happened, like you couldnt change ur avatar, and when u clicked "yes i wanna be rated" it would be a error, and when u clicked someones profile it'd ++++ up.

[BigJohnson]

How can you make it so u cannot rate your self. I think rating your self is pretty dumb. Please help. Thanks.

[Mystislav]

Someone please answer my question...

[Mystislav]

When I run the Queries this is the error message I get..

----

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE user_rate (
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,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD ratetotal SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD allowrate SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL;
mysql error: You have an error in your SQL syntax near ';
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALT' at line 8

mysql error number: 1064

Date: Monday 15th of July 2002 02:20:09 PM
Script: http://66.192.45.86/~sjmadho/board/b...dmin/query.php
Referer: http://www.sjmadhouse.net/board/admin/query.php

------

Can someone help me out

[Mystislav]

^BUMP^

[BigJohnson]

same here bump. I would like y question answered to please.