[iogames]

Originally Posted by yoyoyoyo

thanks for the update - looks like it is time for an update for X TV

I concur...

Well I think everything is Ok, but just for security reasons :P
I installed, imported, try 'Clean Up' & Ooops!

Invalid SQL:
SELECT *, s.name, u.username, !(BIT_OR(ug.radiotvpermissions) & 64) as candomagic
FROM radiostation_rating AS r
LEFT JOIN user AS u ON (u.userid = r.userid)
LEFT JOIN usergroup AS ug ON (find_in_set(ug.usergroupid, u.membergroupids) OR (ug.usergroupid = u.usergroupid))
LEFT JOIN radiostation AS s ON (s.stationid = r.stationid)
WHERE r.userid IN ()
GROUP BY r.ratingid
HAVING candomagic > 0;

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 ')
GROUP BY r.ratingid
HAVING candomagic > 0' at line 6
Error Number : 1064
Date : Monday, November 5th 2007 @ 05:03:40 PM
Script : http://www.chat.iogames.com/admincp/...o=cleanratings
Referrer : http://www.chat.iogames.com/admincp/...php?do=cleanup

It's because I have not ratings?