Execute SQL ?

[Tai]

can some one show me how to execute some sql every hour or before a restart ? I have a few sql queries that I would love the server to run over time.

thanks.

 

[HopHead]

Without getting to detailed you could add an event to you sql server to handle that.

 

[Tai]

dayzst does not allow event access as far as I know.

 

[HopHead]

That is a bummer.
Well try it anyway I use HeidiSQL handle my stuff.

 

[Sarge]

use the 999 method from hiveext.dll, and run a scheduler written in sqf on your server,

 

[Marcel]

I run a dayz.st server too. And I also thought that the MySQL scheduler was not enabled, and I didn't have the privileges to enable it.
But just now, I have discovered that I am allowed to create events, and they are really fired regularly according to their schedule.

Example:
CREATE EVENT removeDamagedVehicles
ON SCHEDULE EVERY 3 HOUR
COMMENT 'Removal of destroyed vehicles'
DO
begin
DELETE FROM instance_vehicle WHERE damage = 1;
end;