Thank you for taking my rewuest into consideration.
However, I'm getting this error when I installed it.
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid AND t.visible = 1 AND 10 > ( SELECT count(10) FROM thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid IN (0,0,0,0,0,0,0,0,0)
ORDER BY field(f.forumid,0,0,0,0,0,0,0,0,0), t.dateline desc;
MySQL Error : You have an error in your SQL syntax near 'SELECT count(10) FROM thread WHERE forumid = f.forumid AND visible = 1 AND datel' at line 4
Error Number : 1064
Date : Tuesday, August 8th 2006 @ 12:07:32 AM
Script : http://www.onelebanon.com/forum/index.php
Referrer : http://www.onelebanon.com/forum/index.php
IP Address : 82.198.0.27
Username : Golani
Classname : vb_database