[Jacko]

anyone got this to work in 3.0.7 its fresh install and first hack..?!

summit do with functions.php i think.

get the following error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
		  , thread.iconid AS threadiconid
			,thread.forumid, forum.title AS forumtitle
			, post.pagetext AS preview
			, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
			FROM thread as thread
			LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
			LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
			LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
			 LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
			WHERE open <> '10' AND thread.forumid NOT IN(2,) AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 
			LIMIT 5
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 ') AND deletionlog.primaryid IS NULL 
			ORDER BY lastpost DESC 

mysql error number: 1064