I tried to implement it in 3.0.7 on
http://www.lairnoc.com but i get this error as well
Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 11
AND ((forumid IN (,1,11,10,17,9,8,21,19,20,13) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) )
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 '1,11,10,17,9,8,21,19,20,13) AND thread.visible = 1 AND post.visi
mysql error number: 1064
Date: Thursday 31st of March 2005 07:41:40 PM
Script: http://www.lairnoc.com/gallery.php?userid=11&pp=10&showthumbs=1
Referer: http://www.lairnoc.com/showthread.php?t=73
Username: lairnoc
IP Address: 83.118.3.72
If anyone could help me fix it i would love it...