Hot zones not changing

tigurius · #3 05-04-2016, 10:06 AM

I made a couple SQL scripts to change the hotzones up and have cron tasks on my server that switches it on schedule. Took 5 minutes to set up.

Clear current hotzones and set new ones..

Code:

UPDATE zone SET hotzone = 0;
UPDATE zone SET hotzone = 1 WHERE short_name = 'oasis';
UPDATE zone SET hotzone = 1 WHERE short_name = 'soldungb';
...

Verify your hotzones

Code:

SELECT short_name FROM zone WHERE hotzone = 1;

Then use crontab (linux) or some third party variant on windows to schedule these scripts to be ran at midnight or something.