nevermind, when i run the schedule, error:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT user.*,userfield.*,usertextfield.*
FROM unique_user AS user
LEFT JOIN unique_honorable AS honorable on (user.userid=honorable.userid)
LEFT JOIN unique_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN unique_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE
usergroupid NOT in ()
AND user.posts >= 0
AND lastactivity >= 1138229114
AND lastpost >= 1138229114
AND user.reputation >= 0
AND (honorable.dateline < 1137624314 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 >= 0
AND lastactivity >= 1138229114
Error Number : 1064
|