DELETE * FROM col_medals WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_china WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_france WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_germany WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_uk WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_usa WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_rating_tank_ussr WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_china WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_france WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_germany WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_uk WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_usa WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
DELETE * FROM col_tank_ussr WHERE up<(UNIX_TIMESTAMP()-30*24*60*60)
Естественно, надо будет добавить ещё префиксы кланов. И можно ли эти команды выполнить через апгрейд базы в админке модуля?
Или же можно ли как то создать php файл с данными командами и запускать его в кроне?