[Joe Pimms]

Originally Posted by n_i_t_r_o_u_s

this is a great hack, is it possible to port it to 3.0.6?

here's the error i get when calling it up:

Database error in vBulletin 3.0.6:

Invalid SQL: 
		SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
			thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
			user.username, thread.open, attachment.userid
		FROM wwwtoke_attachment AS attachment
		LEFT JOIN wwwtoke_post AS post ON (post.postid = attachment.postid)
		LEFT JOIN wwwtoke_thread AS thread ON (post.threadid = thread.threadid)
		LEFT JOIN wwwtoke_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
		LEFT JOIN wwwtoke_user AS user ON (attachment.userid = user.userid)
		WHERE attachment.userid = 1
			AND ((forumid IN (,3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,14,15,21,22,23,24,25,26,27,28) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
		ORDER BY attachment.attachmentid DESC
		LIMIT 0, 10
	
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 '3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1,2,19,20,34,13,

mysql error number: 1064

i get the same type of error to here is my error :

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: 
        SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
            thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
            user.username, thread.open, attachment.userid
        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')
        LEFT JOIN user AS user ON (attachment.userid = user.userid)
        WHERE attachment.userid = 1
            AND ((forumid IN (,1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
        ORDER BY attachment.attachmentid DESC
        LIMIT 0, 10
    
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,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlo

mysql error number: 1064