installed, click on RUN in scheduled
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT user.*,userfield.*,usertextfield.*
FROM uniqueuser AS user
LEFT JOIN uniquehonorable AS honorable ON(user.userid=honorable.userid)
LEFT JOIN uniqueuserfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN uniqueusertextfield AS usertextfield ON(usertextfield.userid = user.userid)
WHERE
usergroupid NOT in ()
AND user.posts >= 50
AND lastactivity >= 1130772942
AND lastpost >= 1135956942
AND user.reputation >= 0
AND (honorable.dateline < 1137944142 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 >= 50
AND lastactivity >= 1130772942
Error Number : 1064
Date : Sunday, January 29th 2006 @ 10:35:42 AM
Script :
http://www.ds-ent.net/custom/admincp...cron&cronid=17