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

[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