Ok everytime I try to post a newthread I get this error and it has to do with this hack that I installed. Posting a reply to thread is no problem but starting a newthread I get the same erro everytime........
Database error in vBulletin 2.2.8:
Invalid SQL: SELECT * FROM nowplaying WHERE userid = '1' AND dateline > ORDER BY dateline DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY dateline DESC LIMIT 1' at line 1
mysql error number: 1064
Date: Saturday 23rd of November 2002 11:15:55 PM
Script:
http://www.jitway.com/forums/forums/newthread.php
Referer:
http://www.jitway.com/forums/newthre...read&forumid=5
......and this would be that line of code in the newthread.php....
$npdateline=time()-600;
$currentsong=$DB_site->query_first("SELECT * FROM nowplaying WHERE userid = '".$bbuserinfo[userid]."' AND dateline > $npdateline ORDER BY dateline DESC LIMIT 1");
Any suggestions?