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

[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/sh...2929#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='mikediggy', 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]

Originally Posted by 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:

PHP Code:

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

PHP Code:

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