Ok... it's not so good...
I keep getting either errors with the NEWS or LATEST THREADS.
vbindex will work, then it won't work, work, and then it won't.
This is an example of the current error it gives me.
In about 30 minutes it will be giving me a NEWS error.
Database error in vBulletin 3.0.0 Release Candidate 4:
Invalid SQL:
## GET LATEST THREADS ##
SELECT thread.*,thread.iconid AS threadiconid , post.pagetext AS preview
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE open = '1'
AND thread.open <> 10
AND forumid NOT IN (22,0)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
AND thread.postuserid NOT IN (,20)
ORDER BY lastpost
DESC LIMIT 7
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 '20)
ORDER BY lastpost
DESC LIMIT 7' at line 14
mysql error number: 1064
Date: Tuesday 09th of March 2004 09:54:52 PM
Script:
http://www.surmunity.com/vbindex.php
Referer: