Thanks for the help. Was curious about this myself a while back. One small problem. I receive a database error when trying to give an infraction after doing so:
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,
threadread.readtime AS threadread, forumread.readtime AS forumread,
post.pagetext AS description,
thread.*
FROM thread AS thread
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = User Name)
LEFT JOIN forumread AS forumread ON (forumread.forumid = thread.forumid AND forumread.userid = User Name)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 13035;
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 'Bot)
LEFT JOIN forumread AS forumread ON (forumread.forumid = thread.forumid' at line 14
Error Number : 1064
Request Date : Friday, December 17th 2010 @ 02:46:40 PM
|