A2Epoch:Server Installation Instructions Extended

In your mysql config my.ini add the line: event_scheduler=ON

Next run the SQL query SET GLOBAL event_scheduler = 1; to enable the event scheduler.

Execute this add_recommended_mysql_events.sql SQL against every dayz epoch database:

DROP EVENT IF EXISTS updateStockDaily; CREATE EVENT updateStockDaily ON SCHEDULE EVERY 1 DAY COMMENT 'Updates out of stock vendors' DO     UPDATE `traders_data` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat';

DROP EVENT IF EXISTS removeDamagedVehicles; CREATE EVENT removeDamagedVehicles ON SCHEDULE EVERY 1 DAY COMMENT 'Removes damaged vehicles' DO     DELETE FROM `object_data` WHERE Damage = 1;

Cleanup of unused items 1.0.2.4+
With the addition of the "LastUpdated" column to object_data you can now see when an object was last accessed and perform cleanup based on that.

This will remove all objects with completely empty inventory and that have not updated in the past 14 days and is older than 24 days old.

This will remove all objects that are older than 42 days and that have not updated in the past 24 days regardless of inventory.

Sets minor damage to walls so the game can identify when a maintain option should be available. It it recommended to have this set to half of your CleanupPlacedAfterDays value. The default is 6 days so "INTERVAL 3 DAY" should be used as shown below.