Format Gaming Network :: Главная

Привет, гость

Персональное Меню

UPDATE users SET `group` = '3' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND (SELECT SUM(good) - SUM(bad) FROM simpaty WHERE simpaty.touserid = users.id) >= 150 AND uploaded < 26843545600
UPDATE users SET `group` = '19' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND uploaded >= 26843545600 AND uploaded < 53687091200
UPDATE users SET `group` = '18' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND uploaded >= 53687091200 AND uploaded < 107374182400
UPDATE users SET `group` = '21' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND uploaded >= 107374182400 AND (SELECT COUNT(*) FROM torrents WHERE torrents.owner = users.id) < 30
UPDATE users SET `group` = '22' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND (SELECT COUNT(*) FROM torrents WHERE torrents.owner = users.id) >= 30 AND (SELECT COUNT(*) FROM torrents WHERE torrents.owner = users.id) < 50
UPDATE users SET `group` = '23' WHERE `group` IN(7, 3, 19, 18, 21, 22, 23) AND (SELECT COUNT(*) FROM torrents WHERE torrents.owner = users.id) >= 50