Erwin, thanks for a great hack.
I'm having a problem tho. Whenever I try to access a forum, I get a MySQL error message (however, the forum home (index.php) is fine).
Code:
Database error in vBulletin 3.0.0 Release Candidate 4:
Invalid SQL:
SELECT COUNT(*) AS threads,
// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
SUM(IF(thread.lastpost>=1077102501 AND open<>10,1,0)) AS newthread
// [END HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signature/ Avatar' AUTHOR='Dr. Erwin Loh' VERSION='1.1' CHANGEID= 4 ]
FROM thread AS thread
WHERE forumid = 4
AND sticky = 0
AND visible = 1
mysql error: You have an error in your SQL syntax near '// [START HACK='Warning System, Automatic Ban, Make Posts Invisible, Edit Signat' at line 3
mysql error number: 1064
What have I done?