[kalisekj]

Hi Great Mod BTW, I am getting a DB error message when I attempt to do a recount.
Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT
COUNT(p.postid) as count_posts
FROM post as p
INNER JOIN thread AS t ON (p.threadid = t.threadid)
WHERE p.visible=1 AND p.dateline>1243951920 AND t.forumid NOT IN(164, 165, 166, 173, 172,)
GROUP BY p.userid
ORDER BY count_posts DESC
LIMIT 0,10;

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 ')
GROUP BY p.userid
ORDER BY count_posts DESC
LIMIT 0,10' at line 5
Error Number : 1064
Request Date : Tuesday, June 23rd 2009 @ 09:12:25 AM
Error Date : Tuesday, June 23rd 2009 @ 09:12:25 AM
Script : http://freeonlinemoviesforum.com/adm...nce_recount_xp
Referrer : http://freeonlinemoviesforum.com/adm...nce_recount_xp
IP Address : 189.216.118.250
Username : 2borno2b
Classname : vB_Database
MySQL Version : 5.0.81-community