View Single Post
Old 17 Dec 2010, 20:52
g0dfather1984's Avatar
g0dfather1984 g0dfather1984 is offline
Join Date: May 2008
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,

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
Reply With Quote