View Single Post
  #3  
Old 05-04-2016, 10:06 AM
tigurius
Fire Beetle
 
Join Date: Sep 2004
Posts: 24
Default

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.
Reply With Quote