Hi, had this hack working for ages. Now started getting this error message:
Quote:
Database error in vBulletin 3.6.0:
Invalid SQL:
SELECT user.*,userfield.*,usertextfield.*
FROM user AS user
LEFT JOIN honorable AS honorable ON(user.userid=honorable.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE
usergroupid NOT in ()
AND user.posts >= 1
AND lastactivity >= 1165076691
AND lastpost >= 1165076691
AND user.reputation >= 0
AND (honorable.dateline < 1167063891 OR honorable.dateline IS NULL)
ORDER BY RAND()
LIMIT 1;
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 user.posts >= 1
AND lastactivity >= 1165076691
|
Any suggestions?