[jGas]

hi, thanks for this great mod!

i'm using it and it works, but i have a problem when i try to open helpfulanswers.php and "Enable Most Helpful Answers" is on.

Database error in vBulletin 3.8.1:

Invalid SQL:

		SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalrank,helpfulpost.lastvote,
			thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,goodrank as avgrank
			
		FROM vb_helpfulpost as helpfulpost
		INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
		INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
		INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
		WHERE goodrank > 0
			
			
		ORDER BY avgrank desc
		LIMIT 0, 25;

MySQL Error   : Column 'goodrank' in field list is ambiguous
Error Number  : 1052
Request Date  : Sunday, December 13th 2009 @ 05:44:40 AM
Error Date    : Sunday, December 13th 2009 @ 05:44:40 AM
Script        : http://www.musicadigitale.net/forum/helpfulanswers.php?do=topanswers
Referrer      : 
IP Address    : 151.68.52.235
Username      : Mr Gas
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.87-community

what should i do to fix it?

thanks =)