User Ratings

[EXCHANGE]

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

German version available in my forums.

Screenshot (http://www.vbulletin.com/forum/attachment.php?postid=180299)

[Neo]

man you are the bomb :D really nice hack thanks for putting it up

[cooldude]

yes thankx m8

[maverick1236]

Any chance you could do those Gifs with a transparent background?

i have black background on my forum :D

great hack!!

[Neo]

ohh yeah images with transparent BGs would be nice

[tweak]

Nice hack thanx

[ckevin]

EXCHANGE, it works great, but I wonder if it can told us the average score (total score/no. of votes). Also can user vote over a member again? at least the user can modify the rating of a voted members?

Thanks a lot! :)

[EXCHANGE]

Users can only vote once. In case a user has already voted, the old value is replaced by the new rating.

Well, the average score is represented by the images and the number of votes is already included.

Anyway you could do it like this in postbit_userrating:

At the Moment we have:
<br>Rating:<br><img src="images/$userrating" alt="$post[ratenum] Votes">
<br><smallfont>$wholink</smallfont><br>

Change it to:<br>Rating:<br><img src="images/$userrating" alt="$post[ratenum] Votes / $rating points average">
<br><smallfont>$wholink</smallfont><br>

do the same for getuserinfo_rating



You could also change the // User ratings....... Code in member.php and functions.php

change:$wholink="<a href=\"javascript:who($userid)\">($rateuser[ratenum] Votes)</a>";
}
else {
$wholink="($rateuser[ratenum] Votes)";

to:$wholink="<a href=\"javascript:who($userid)\">($rateuser[ratenum] Votes / $rating points average)</a>";
}
else {
$wholink="($rateuser[ratenum] Votes / $rating points average)";

[ckevin]

yup, it works :) thanks!

[Lesane]

I waited long for this hack :D, thanks for the great hack http://vecommunity.webhostuk.com/images/smilies/new/thumb.gif

[Mobile]

can't find the 'getinfo' template in admin panel, anyone no were it is.

-Thanks Mobile

[Lesane]

Originally posted by Mobile
can't find the 'getinfo' template in admin panel, anyone no were it is.


-Thanks Mobile

User Info Display Templates -> getinfo

[Mobile]

nice one m8 works a treat.

Thanks Mobile

[trilOByte]

tried the hack in vB2.2 - doesn't work. Anyone know what I need tyo change to get it working? Thanks :)

EDIT:

The hack shows up in the profiles, and seems to record the votes properly, but there is no display under the avatar. Basically, I think I have the sql query set up properly plus all the templates. I thinki it's likely a mod to one of the existing templates that is wrong somewhere. Any suggestions?

http://www.synobyte.com/images/rating.gif

[TheComputerGuy]

I Love this HACK...you could replace the bars with stars and bing a nice version of a hack..

[EXCHANGE]

Originally posted by trilOByte
tried the hack in vB2.2 - doesn't work. Anyone know what I need tyo change to get it working? Thanks :)

EDIT:

The hack shows up in the profiles, and seems to record the votes properly, but there is no display under the avatar. Basically, I think I have the sql query set up properly plus all the templates. I thinki it's likely a mod to one of the existing templates that is wrong somewhere. Any suggestions?


Well it works with 2.2 without any modification. I guess you're talking about the display in the threads. In this case check your postbit template, showthread.php and admin/functions.php

@TheComputerGuy

You can replace the images with stars or you could make the hack use the stars from the thread ratings by changing $userrating = '0points.gif'; and $userrating = $rating. 'points.gif'; to $userrating = '0stars.gif'; and $userrating = $rating. 'stars.gif'; in member.php and admin/functions.php

[TheComputerGuy]

Thanks exchange...
Love the hack nice work

[Lionhead]

Thanks for the nice hack :)

[trilOByte]

Originally posted by EXCHANGE


Well it works with 2.2 without any modification. I guess you're talking about the display in the threads. In this case check your postbit template, showthread.php and admin/functions.php



I stand corrected and thanks for the help. I had made an error in the functions.php - not much, but it doesn't take much :)

This is an awesome hack man, thanks a ton for sharing it - good work :D

I now have just what i was looking for. I tweaked it a bit, cos some of the words were still in German and i changed the color bar for dots. See...

http://www.synobyte.com/images/karma1.gif

...which suit my board better. I also renamed the visible parts "karma" :D :D

Totally cool hack - thanks again :D

[trilOByte]

here's a zip with the transparent gif's that I made (see above post) if anyone wants them....

[Lesane]

Originally posted by trilOByte
here's a zip with the transparent gif's that I made (see above post) if anyone wants them....

Thanks

[JJR512]

Originally posted by EXCHANGE
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)

How does the last one work? I can't see anywhere who has rated me.

[trilOByte]

The number of votes under your rating is an active link to a popup with usernames of those who have voted for you.

[EXCHANGE]

Originally posted by JJR512

How does the last one work? I can't see anywhere who has rated me.

Actually this function is only avalaible for user who have been rated 3 times to avoid bad blood ;)

@ trilOByte

Nice work

[trilOByte]

Originally posted by EXCHANGE


@ trilOByte

Nice work

Thank you for posting the hack - awsome stuff :)

BTW, in the user profile, if a user has not yet been rated, it says (next to the drop down box) "last rating: keine" or something like that. I'm guessing this is german or something - what do I edit to change it to "last rating: none" or whatever?

Thanks :)

[EXCHANGE]

none would be correct. Sorry for this.

[Justice]

can this be set to user group restrictions?
This seems like a great hack, but I'd only want members in certain user groups and moderators to be able to rate members, not just anyone.

[bokhalifa]

good hack :)

[JJR512]

I'm sorry to say that I've had to click the Uninstall button on this thread.

Don't get me wrong, this is a great hack. Very well written; I didn't have any problems with it, aside from a few German/English language confusions, as mentioned by others here earlier.

The reason why I've removed this hack from my board after having some time to look at it and how people were using it, it seemed that it would ultimately do more harm to my board's community than good. One thing I noticed right away was that some people who got low ratings right away just turned this feature off for themselves. But my main concern, however, was that people who got low ratings might feel as if they weren't wanted, and would stop visiting my board.

Some might say this is a good thing. Maybe it's even the point of the hack. If someone acts a certain way on a message board that the majority of the membership doesn't like, then maybe giving that member a low rating will give that person the hint that they should move on. But getting rid of the small amount of members that most people don't like will leave a message board with a community of people who are all pretty much the same. Then things get boring. I think a little bit of tension or conflict isn't necessarily a bad thing.

So I'm not knocking this hack; maybe for some communities that want to be a bit more agressive with filtering out the non-desriable people, this is a good thing. I just wanted to point out to people to really consider if they want to start something on their board that may lead to ill feelings.

[Justice]

wow, I wish my board worked like that. when people there realize that they're not wanted, that's when they become harder to get rid of.

[trilOByte]

Originally posted by Justice
wow, I wish my board worked like that. when people there realize that they're not wanted, that's when they become harder to get rid of.

LMAO ;) ya got that right.

I think it's a question of how you present it to em too. I'm still working it through on my test forum, but I'm thinking of combining it with a stats hack...

http://www.synobyte.com/images/karma2.gif

So they kinda get a package deal :)

[Nam]

Originally posted by JJR512

The reason why I've removed this hack from my board after having some time to look at it and how people were using it, it seemed that it would ultimately do more harm to my board's community than good. One thing I noticed right away was that some people who got low ratings right away just turned this feature off for themselves. But my main concern, however, was that people who got low ratings might feel as if they weren't wanted, and would stop visiting my board.


Totally agree, but I had another idea to overcome the situation, instead of using Rating, I've changed to Power. Change the scale to no power as 1 to super power at 5.

The Power word is just another word, but in my opinion, it's change the whole rating idea alot, the sound creates more fun and less seriousness, intense among members. It will encourage member to turn it on (to have power bar) but also let people know the bad guy (who has no power) and he needs to do something to get his power back. Check my site and you'll see.

Btw, I'd love to see that Admin can have more control over others, like a ability to see who but also how they rated him, as well as moderators.

Just a thought,

[Littlebit]

Is it after three votes or three votes on that it is clickable to see who voted? If its 3 votes and higher, then something isn't working right with the javascript on my install. I am unable to view who voted with three votes. Could someone help me out? :confused:

[EXCHANGE]

You got // in front of function who(userid) { in your showthread template.
Just remove it

[Littlebit]

I removed the // in the showthread template. It works within a post, just not on members profiles...I bet I have more little //'s to get rid of eh?

[Littlebit]

All better now! <!-- --> was surrounding the getAIM plus the rate stuff in the getinfo template.
::sigh::: I'm a dork.
:rolleyes:

[Dado]

great hack.

One question though.
What should I change so moderators can't be rated?

[BlaXioN]

thx 4 nice hack

[Nam]

I have a question, how can I make a hyperlink from the rating word to pop-up window that let user to rate other like UBB board.

The only way to rate is click profile, which not too many people know, so by making the hyperlink from rating , it would be very nice. The pop up window should contains rating option only, not other information like profile and such.

Please help Exchange or anybody that knows, I've been playing around with with getinfouser_rating but couldn't figure it out.

Here is my original file:
<tr>
<td

bgcolor="#13486D"><normalfont><b>Rating:</b></normalfont><br><img src="images/$userrating" alt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
<td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
<form action="userrate.php" method="get">
<tr>
<td>
<select name="userrate"
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
<option value="-1" selected>Rate this user:</option>
<option value="5">Super Power</option>
<option value="4">Strong Power</option>
<option value="3">Normal Power</option>
<option value="2">Weak Power</option>
<option value="1">No Power</option>
</select>
<input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
</td>
</tr>
</form>
</table> </td>
</tr>

I have tried to change to:


<tr>
<td
bgcolor="#13486D"><normalfont><b><a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a>:</b></normalfont><br><img src="images/$userrating" alt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
<td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
<form action="userrate.php" method="get">
<tr>
<td>
<select name="userrate"
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
<option value="-1" selected>Rate this user:</option>
<option value="5">Super Power</option>
<option value="4">Strong Power</option>
<option value="3">Normal Power</option>
<option value="2">Weak Power</option>
<option value="1">No Power</option>
</select>
<input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
</td>
</tr>
</form>
</table> </td>
</tr>


Basically I've added the line <a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a> to make the word rating become hyperlink, but that doesn't work, anybody can help?

[EXCHANGE]

For example you could add sth. like this to userrate.php:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\");");
}

This would call the template rateoption where you could place your HTML code.

Sorry I don't have time at the moment to do kind of an addon, this is just an idea how it could work.

[Nam]

I'm sorry, I'm a newbie so I don't really get what you were saying. Where can put the line:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\");");
}

you told me to? what line number, under or above what in userrate.php?

Then I will have to createa template call rateoption ? What should I put HTML code in it then :confused: .

Help me whenever you have time, I'd appreciate it.

[nafae]

Works like a charm. There were a few suggestions I had that would be cool in another version or an update...

1)Ability to specify little images, ribbons or something (im using a ribbon system) instead of just text. IE: under input field you enter the number you want,
then it automatically displayes that number of images.

2)Show the "Rating:" under the users avatar and other info. That way he can "show off" his rating to other users :)


IF this is possible or easy to add that would be purty cool to have :D

[SiXXGuNNZ]

Database error in vBulletin 2.2.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,style.title as styletitle
,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,ratetotal,ratenum,allowrat e
LEFT JOIN style on (user.styleid = style.styleid)
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 = '3019'

mysql error: Table 'forum.ratetotal' doesn't exist

mysql error number: 1146

this is what is bothering me --> mysql error: Table 'forum.ratetotal' doesn't exist

I have a "forum.user.ratetotal" tho

[Dark Blaze]

Great hack :)

Btw, trilOByte how can I make the forums look like yours for the XP, EXP, etc voting screenshot? But have it also show like your carma screenshot?

Thank you,

[212rikanmofo]

can someone help me install this mod please, i dont have phpmyadmin, im stuck at this part, please help me someone... =(

[trilOByte]

Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.

212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.

[trilOByte]

Sorry Dark Blaze, forgot the attachment, here ya go...

[Dark Blaze]

Originally posted by 212rikanmofo
can someone help me install this mod please, i dont have phpmyadmin, im stuck at this part, please help me someone... =(

212rikanmofo, as trilOByte specified, you would require a cpanel and most likely would have phpMyAdmin on your server provided by your webhost, since you have vBulletin installed.

Thus, having php support on your server, you will only need administrators access to your domain, and some sort of an Admin Panel, which will most likely have phpMyAdmin installed. If you have Administrator Access on your server, you will be able to upload the files and then run the appropriate scripts or do the required actions to install this modification/hack.

I hope this helps :)

[Dark Blaze]

Originally posted by trilOByte
Dark Blaze, you need to use custom bar graphics that match the stats hack in order to get the same effect. I've attached the ones I made for you to DL. Just upload them to your server and overwrite the default ones.

212rikanmofo, do you have a "cpanel" or something similar provided by your webhost? If you've got php on your server (obviously must for vB) and admin acess to your domain, you should have some sort of admin panel, which will likely have PHPMyAdmin in there as a link.

Thank you very much trilOByte, I appreciate it :)

[Dark Blaze]

Originally posted by trilOByte
Sorry Dark Blaze, forgot the attachment, here ya go...

That's ok, at least you noticed that you forgot it and attached it to your reply. Thanks once again :)

[Lionel]

The hack works fine. However I am not clear on how to use who_rated. It does not appear anywhere. Isn't that supposed to give a list of who rated a specific user?

[trilOByte]

The number of votes cast under the bar graphic, turns into an active link with a java popup, after 3 votes or more have been cast.

[SirSteve]

I would like to see this sort of thing but in a feedback style. Like in a classifieds section or a trading section... people could leave feedback about one another... know what I mean?

[philliplewisuk]

When i try and rate someone i get the error

You did not specify a valid user!

[Hoffi]

Hi,

I modified the Hack, so you can remove your rateing, if you decide not to rate any user. Till now you only can change how you rated.

And another little mod: The order in the Popup-Windows Who-rated is now by the NickName, no longer by ID.

changed files: userrate.php
changed templates: getuserinfo_rating

German version in avaible in www.exchange-board.org

[Floris]

Hi

I have a own license on vBB and I have entered my name in the customer boxes (3 input fields, and in top i entered my registration name: xiphoid > vbulletin.com) but i can't see the screenshot !

What am I missing ..

[mvigod]

Just change the url part from vbulletin.com to vbulletin.org

[mvigod]

Does anyone have a demo of this? Tried Trilobytes but don't have a test user account.

Also, does this allow one to add comments as part of feedback or just the rating only?

[Erwin]

[QUOTE]Originally posted by philliplewisuk
When i try and rate someone i get the error

You did not specify a valid user!

[Erwin]

I have removed the hack and installed it twice, with the same outcome. It might be interfering with some of my other hacks, most likely the gender hack, or the mood hack. What do you think? It's not a big problem, since the rating is counted, so I have just changed that error template to say "Vote counted, click back to return to profile" or something like that.

But it would be interesting to know if anyone else besides us two have this problem.

[Erwin]

Aha!

I figured out the problem!

You do NOT need to press the Go button to rate a member. (How stupid of me).

Just choose a rating from the drop down menu, and wait - the rating will go and you will be redirected to the correct page.

The Go button appears to be redundant (but possibly needed in older browsers).

For me, what I did was in:
getuserinfo_rating

I removed:
<input type="image" src="vbimages/go.gif" border="0" align="absbottom">

to prevent other users from clicking Go.

I manage to insert the rating bar in my postbit too, so people can be rated from the postbit.

Great hack!!! :)

[Shenlong]

NICEHACK!

great works fine, anyway

CAN SOMEONE TELL ME HOW tril0byte did that awesome karma work? plz :)

[Erwin]

How do you stop members from voting for themselves?

This is happening with my forums. Members can change their last rating by voting for themselves.

[Shenlong]

I got a question though, I still dont understand how to incorporate the image, I dont understand what he said on the 1st page, can someone make the walkthrough a little more thorough, i DLed tril0bytes imagepack and just dont know how to make it work

[trilOByte]

Originally posted by Shenlong
I got a question though, I still dont understand how to incorporate the image, I dont understand what he said on the 1st page, can someone make the walkthrough a little more thorough, i DLed tril0bytes imagepack and just dont know how to make it work

You ftp'd the original images to the specified folder right? Well, providing the original hack works, the new images (with the same file names) are just ftp'd to the same location, to overwrite the originals - they then show up on your BB in place of the originals.

Or, are you having dificulty getting the hack to work in the first place? In that case, post what you've done and how far you'ce got. I'll see if I can help ;)

Have you...

1. executed the new SQL query?

2. Hacked

showthread.php
admin/functions.php
member.php

...then re-uploaded to the propper directoreies ins ascII?

3. Added the following new templates...

error_invaliduserrating
error_norate
error_notallowed
error_nousertorate
getuserinfo_rating
redirect_userrate_add
postbit_userrating
whorateduser
whorateduserbit
Note: In the instructions, it shows all the above templates with colons after the name - do not add the colon to the template name.

4. Did you edit the following templates...

find
modifyoptions
showthread
postbit


My advice, restore your original files and then go through the hack again, methodically, use a pen and paper to cross of a printed copy of the instructions if necessary.

[Lionel]

I installed that hack anf it worked fine. However I also installed the hidden post hack. While trying to hide a post, I got a mysql error in showthread.php

mysql error: Table 'databasename.ratetotal' doesn't exist

while investigating, I found the problem was at

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,ratetotal,ratenum,allowrat e
---------------------------------------------------------------------------------
I reverted it back by removing that line:
,ratetotal,ratenum,allowrate
and hidepost worked.
Looks like that rate user is still working. My question is: what is the importance of that line?
Notice that the error did not say databasename.user.ratetotal (which exists in table user as per installed but the error is seeinf ratetotal as a table, not a field).

How can I correct this? I am on 2.21

Thanks

[Lionel]

Originally posted by SiXXGuNNZ


this is what is bothering me --> mysql error: Table 'forum.ratetotal' doesn't exist

I have a "forum.user.ratetotal" tho

I have exactly the same problem. See one post above.

[Shenlong]

i dont got phpmyADMIN and dont wanna install it, not good with mySQL stuff, is there anyway u can make an install file or sumtin?

[squawell]

i have one problem?

why am i only can rate user in profile page can't rate in post

am i miss something in postbit or.....

hope somebody help me~~

[neal]

Works like a charm, thank you

[Bat-Man]

Originally posted by EXCHANGE
For example you could add sth. like this to userrate.php:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\");");
}

This would call the template rateoption where you could place your HTML code.

Sorry I don't have time at the moment to do kind of an addon, this is just an idea how it could work.




Originally posted by Nam
I'm sorry, I'm a newbie so I don't really get what you were saying. Where can put the line:

elseif ($action==rate){
eval("dooutput(\"".gettemplate('rateoption')."\");");
}

you told me to? what line number, under or above what in userrate.php?

Then I will have to createa template call rateoption ? What should I put HTML code in it then :confused: .

Help me whenever you have time, I'd appreciate it.


I too would really like to know where to add this line to the userrate.php

Thanks in advance.

[lowlight]

Just a small issue to note... When using the /forum/online.php, if someone is rating someone else, it reports "UNKNOWN LOCATION" and the URL... You could update this hack to display the correct location, that would be great :)

[Gamingforce]

People on my message board were suggesting that those who have ratings disabled for themselves shouldn't be able to vote for anyone else. Does anyone want to work on this modification? =)

[Gamingforce]

Lol, you can't rely on others to do the work for you. Gotta do it yourself :(.

Here it is guys. Use the attached userrate.php file.

Make sure you create a new template "error_notallowedtorate" and put "You are not allowed to rate this user if others cannot rate you" or something like that. Enjoy.

[freehtml]

I had installed it and somehow the hyperlink to open the javascript window does not occur and on eof my member somehow does not display the Rating under his post

[freehtml]

Originally posted by squawell
i have one problem?

why am i only can rate user in profile page can't rate in post

am i miss something in postbit or.....

hope somebody help me~~

I seems to have this problem too. I am using vb 2.2.4

[Erwin]

Originally posted by Gamingforce
Lol, you can't rely on others to do the work for you. Gotta do it yourself :(.

Here it is guys. Use the attached userrate.php file.

Make sure you create a new template "error_notallowedtorate" and put "You are not allowed to rate this user if others cannot rate you" or something like that. Enjoy.

Thanks! Nice addition! :)

[mewgood]

does this work for 2.2.2?

[Erwin]

Originally posted by mewgood
does this work for 2.2.2?

Yes.

[mvigod]

There are still no user comments from other users like ebay on this hack, right? Only votes?

[mewgood]

ar... why when I try to click who rate me it appears an error..

example: http://www.mewgood.com/~vbb/showthread.php?s=&threadid=818
try to click the number of votes and you will get an error...
Can anyone help me out?

[Rapdis]

I really want this hack! but im a novice at configuring....

Please help.... with a much simpler install guide.... or if u can help.... add me on msn... search aj@tupacfans.net...

my forum is at www.rapdis.com/forum

[Neo]

Hmmm... well finallt after soooo long I am going to be using this hack on my site... got to get those spammer ;)

[Crazy Mofo]

is there a way too put in the postbit template under above the actull image


"Rate This User" ?

Also any1 got any good stars i want some gold stars foe it :D thx..

Mofo

[Beams]

Just noticed when clicking on the link to see who voted for you any smiles in the thread will stop animating, i don't recall this happening on 2.2.4 but is on 2.2.5 is there anyway around this plz

Beams :D

[EXCHANGE]

That's because the thread is not your active browser window anymore, when you click on "who rated".

@Crazy Mofo

Some Stars

[212rikanmofo]

another idea for this hack would be when you click Who rated, it popups a window and lists the name of all the people who rated you. But besides there name can you show like what they rated you as? like how many points they gave to you 1-5? that would be much better.

and also has anyone tried figuring out how to incorporate this hack into your postbit template so users can click and rate you in there as well? thanks...

great hack!

[Roxie]

Hi, does this work with 2.2.5?
Thanks!

[EXCHANGE]

Originally posted by Roxie
Hi, does this work with 2.2.5?
Thanks!

yes it does :)

[asweetdeal]

Originally posted by Erwin

I manage to insert the rating bar in my postbit too, so people can be rated from the postbit.

Great hack!!! :) [/B]

How did you put it in the postbit?

Also... I would like the rating to show under the user's avitar, what changes do I need to do in order to do this? Right now it appears above the post.



Thanks!
ASweetDeal

[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 Rating:(no 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/board/admin/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.

[Mystislav]

Is anyone gonna help us???????????

[BigJohnson]

HELP PLEASE. I would like to no how you can change this hack so you cannot rate your self please.

[FrankR310]

anyone know how many additional queries this adds?

[ULTIMATESSJ]

Does this hack work with 2.2.6

[EXCHANGE]

yes

[Erwin]

Originally posted by BigJohnson
HELP PLEASE. I would like to no how you can change this hack so you cannot rate your self please.

Easy. :)

In userrate.php, find:


} elseif ($rateduser[allowrate]==0) {
eval("standarderror(\"".gettemplate("error_norate")."\");");
exit;


Underneath, add:


} elseif ($bbuserinfo['userid'] == $rateduser[userid]) {
eval("standarderror(\"".gettemplate("error_samerate")."\");");
exit;


Then, add a new template called:

error_samerate

with this contents:


You are not allowed to rate yourself! Press the back button to return to where you were.


Done!

[Kars10]

This Hack is great!! Works like a charm on 2.2.6 and install without any Problems!!
* Minifreunde klicks install!! :)

[LordB]

Has any one tryed this with 2.2.8?

Also how easy is it to reaply the patch after an upgrade.

B

[Erwin]

Works 100% with vB 2.2.8.

I upgrade using Araxis Merge, so no need to reapply.

[lifesourcerec]

Have a question. this may be a totally different hack. A user rating system (such as feedback) where it is only +1 and -1 (somewhat like Ebay feedback). Is there a hack like that?

[Crazy Pete]

Originally posted by Erwin


Easy. :)

In userrate.php, find:


} elseif ($rateduser[allowrate]==0) {
eval("standarderror(\"".gettemplate("error_norate")."\");");
exit;


Underneath, add:


} elseif ($bbuserinfo['userid'] == $rateduser[userid]) {
eval("standarderror(\"".gettemplate("error_samerate")."\");");
exit;


Then, add a new template called:

error_samerate

with this contents:


You are not allowed to rate yourself! Press the back button to return to where you were.


Done!

I tried this, Erwin, but I'm getting a parse error with this line, and I'm not sure why...

} elseif ($bbuserinfo['userid'] == $rateduser[userid]) {

? That looks ok to me?

[Erwin]

Make sure there is a } underneath. You must have deleted the } by accident.

[Crazy Pete]

Eh, I thought it was still in there. In any case, I appreciate the help but as I thought about it more, I realized that the person who said before that some users might take it the wrong way and seem like they aren't wanted had a point. I wouldn't want to alienate anyone, so I removed it, at least for now.

[BrAinZ]

Has anyone worked out how to ONLY allow Mods or Admins (or other user groups) to rate users.

I would like to add this system to our board, where existing Mods can start rating users who could potentialy become future mods after being rated well by a few others.

Can anyone help?

[zefman]

Originally posted by BrAinZ
Has anyone worked out how to ONLY allow Mods or Admins (or other user groups) to rate users.

I would like to add this system to our board, where existing Mods can start rating users who could potentialy become future mods after being rated well by a few others.

Can anyone help?
Hello BrAinZ,
i had the same problem

but very easy to resolve :

just confine the code of the modified files (4 locations to edit) in such conditionnal :

if ($bbuserinfo[usergroupid] == 7 or $bbuserinfo[usergroupid] == 6) {
...
...the code in the instructions..
...
}

and this system will be invisible to all except your mods and you, the admin.

sorry crappy english :p

[BrAinZ]

Nice one.. thanks, I'll give it a go then.

[Colon33]

Hello.

I am looking to see what we can do to get teh top 5 user rated members on the forum home or on the main page of the site. How can we call this type of information? This would be a great addition. Having the top 5 members rated on the forum homepage. I like it alot. Top 5 or Top 3 or Top 2 or whatever.. you know?

[PiotrasG]

hey works great with 2.29 one question how can i get the rating form to work in postbit.

[Yuber]

Thanks for the hack

[Xyphen]

Works Perfectly fine on vB2.3.0, thank you very much for the great hack!!

[sabret00the]

would it be possible to rate the user specific things from like a selection of 20 options?

[maestrosdelweb]

Any update to the hack where I could see a list of the top rated users?

[RetroDreams]

Works great... would also like a page that has like the Top 25 rated users too...

[wolfgang2]

i installed this hack on version 2.3.0

works great.
but one problem and a suggestion:

how can i stop a specific user from voting ?
i have one user that only votes bad for all others...

i appriciate your help!

[wolfgang2]

please help!!!!!!!!!

[wolfgang2]

why is nobody responding?

[WEForums]

Ban them.

I don't know because I don't have the hack installed, but people will probably ignore you if you keep triple posting.

[wolfgang2]

they ignored me from the beginning...

[eoc_Jason]

There is no provision for that in this hack (last time I checked)... you would have to custom code it yourself... adding like a field with 0/1, then do a check for it when a person tries to vote, then add in your adminCP a set of radio buttons to allow / deny a person the ability to rate other people.

05-29-03 at 11:28 AM wolfgang2 said this in Post #124 (https://vborg.vbsupport.ru/showthread.php?postid=401574#post401574)

how can i stop a specific user from voting ?
i have one user that only votes bad for all others...

[wolfgang2]

thank you very much for your response!
i will try my best and will post results here the next days:)

[GsxrTony]

A piece of code that only allows you to have voting access after say 150 posts would be nice. This way you dont have trolls coming on and screwing with people.

[GsxrTony]

I keep trying to run the query in the txt file but I keep getting an error.

Error
SQL-query :

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

MySQL said:


create command denied to user: '*********@***.******.' for table 'user_rate'


Any ideas guys

[MoneyTec.Com]

Can some post a screen shot of this users ratings? I'm looking for the one http://www.trade2win.co.uk/boards/showthread.php?s=&postid=42929#post42929 uses, Is this it?

[corsacrazy]

IM THE ADMIN BUT I CANT EVEN CHOOSE WHO I WANT TO BE RATED FROM ACP i want to disable for certain users via check box !!

[datainternet]

Is it possible to see who has votet??? I saw this on a Board. When you click on the Vote-Count-Link you see who has votet.

[Gio Takahashi]

Installed th is works without a flaw, was afraid seeing how long its been since updated.

[Rampag33]

*** installed on vb232 works perfectly

How do you display the number instead of the stars?
like say you rating avarage is 4.23243 how do you display that?

Also can someone make a top 10 page for for this hacc?

[BlackxRam]

I instaled this hack now i get this error whenever i try to UPDATE my Threads

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=1064683357,replycount=10,postusername='mi kediggy', postuserid='1570', lastposter='julez',attach= WHERE threadid=9587
mysql error: 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 'WHERE threadid=9587' at line 1

mysql error number: 1064

Date: Monday 24th of November 2003 02:14:44 PM
Script: http://forums.mogusland.com/admin/misc.php
Referer: http://forums.mogusland.com/admin/misc.php?s=

[SgtSling]

how can I make a hyperlink from postbit to pop-up window that let user to rate others like UBB board.

[SgtSling]

I have a question, how can I make a hyperlink from the rating word to pop-up window that let user to rate other like UBB board.

The only way to rate is click profile, which not too many people know, so by making the hyperlink from rating , it would be very nice. The pop up window should contains rating option only, not other information like profile and such.

Please help Exchange or anybody that knows, I've been playing around with with getinfouser_rating but couldn't figure it out.

Here is my original file:
<tr>
<td

bgcolor="#13486D"><normalfont><b>Rating:</b></normalfont><br><img src="images/$userrating" alt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
<td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
<form action="userrate.php" method="get">
<tr>
<td>
<select name="userrate"
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
<option value="-1" selected>Rate this user:</option>
<option value="5">Super Power</option>
<option value="4">Strong Power</option>
<option value="3">Normal Power</option>
<option value="2">Weak Power</option>
<option value="1">No Power</option>
</select>
<input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
</td>
</tr>
</form>
</table> </td>
</tr>

I have tried to change to:


<tr>
<td
bgcolor="#13486D"><normalfont><b><a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a>:</b></normalfont><br><img src="images/$userrating" alt="$rateuser[ratenum] Votes"><br><smallfont>$wholink</smallfont></td>
<td bgcolor="#13486D"> <table cellspacing="0" border="0" nowrap>
<form action="userrate.php" method="get">
<tr>
<td>
<select name="userrate"
onchange="window.location=('userrate.php?s=$session[sessionhash]&rateuser=$userid&userrate='+this.options[this.selectedIndex].value)">
<option value="-1" selected>Rate this user:</option>
<option value="5">Super Power</option>
<option value="4">Strong Power</option>
<option value="3">Normal Power</option>
<option value="2">Weak Power</option>
<option value="1">No Power</option>
</select>
<input type="image" src="images/go.gif" border="0" align="absbottom"><smallfont>&nbsp;(Last Power Rating: <b>$oldrating[old]</b>)</smallfont>
</td>
</tr>
</form>
</table> </td>
</tr>


Basically I've added the line <a href="userrate.php?s=$session[sessionhash]&action=show&rateuser">Rating</a> to make the word rating become hyperlink, but that doesn't work, anybody can help?

Did anyone ever figure that out?

[Rampag33]

Is there any way to let a person rate you ever X number of hours? Notchanging you there previous rating

[SgtSling]

Bizzump!

[SgtSling]

bueller?