[Noctavia]

Originally Posted by Ted S

Looks like I gave you bad guidance... You need to leave 2="$post[totalrank]"

Cool, thanks, got it working now. :up:

Another question. When I try to find all ratings given to a single thread, I get the following error:

Database error in vBulletin 3.8.2:

Invalid SQL:

		SELECT COUNT(helpfulanswerid) AS count
		FROM helpfulanswer AS helpfulanswer
		INNER JOIN user AS user ON(helpfulanswer.userid = user.userid)
		WHERE helpfulanswer.helpfulanswerid <> 0
			 AND helpfulanswer.postid =  
			 AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 1247725500
		GROUP BY helpfulanswer.userid;

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 'AND helpfulanswer.dateline >= 1245047100 AND helpfulanswer.dateline <= 124772550' at line 6
Error Number  : 1064
Request Date  : Thursday, July 16th 2009 @ 02:26:25 AM
Error Date    : Thursday, July 16th 2009 @ 02:26:25 AM
Script        : http://xxxxxx/forums/admincp/helpfulanswers.php?do=show_helpfulanswers
Referrer      : http://xxxxxxx/forums/admincp/helpfulanswers.php
IP Address    : xxxxxxxxx
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.81-community

Any idea on how to fix that? I can use all the other reporting features fine. This only happens when I use the Post ID section.