Hi thanks for modding this.. I ran into a problem though while installing it...
----------------------
Database error in vBulletin 4.0.0 Beta 3:
Invalid SQL:
SELECT
userban.userid, adminid, bandate, liftdate, reason,
user.username as username,
admin.username as adminname, admin.displaygroupid as admindisplaygroupid, admin.usergroupid as adminusergroupid
FROM userban as userban
LEFT JOIN user as user ON(user.userid = userban.userid)
LEFT JOIN user as admin ON(admin.userid = userban.adminid)
WHERE user.usergroupid IN ()
ORDER BY bandate DESC;
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 ')
ORDER BY bandate DESC' at line 8
Error Number : 1064
Request Date : Thursday, November 19th 2009 @ 01:59:38 AM
Error Date : Thursday, November 19th 2009 @ 01:59:38 AM
Script :
http://forum.**************.org/banlist.php
Referrer :
IP Address : **.**.**.**
Username : Garret
Classname : vB_Database
MySQL Version : 5.0.81-community
--------------------------
Any help you can provide would be really appreciated..
Regards
Garret