Need some guidance on base maintenance

[alexlawson]

So I have never needed to use base maintenance but with the amount of players on my server I need to do something to decay bases. So I think I know how it works but before I add this to my server I would like someone to double check it incase I mess something up and my test server is down for a few days.

So if I set this event in the DB

DROP EVENT IF EXISTS `setDamageOnAge`;
DELIMITER ;;
CREATE EVENT `setDamageOnAge` ON SCHEDULE EVERY 1 DAY COMMENT 'This sets damage on a wall so that it can be maintained' DO UPDATE `Object_DATA` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )
;;
DELIMITER ;

This will enable players to maintain and then I set this setting in HiveExt.ini to remove non maintaned buildings after 7 days.

;CleanupPlacedAfterDays = 7

Is this correct ?

 

[alexlawson]

Might be best to move this over to epochmod forums.

 

[ShootingBlanks]

the semicolon is commenting put that value, remove it and set the value to what you want

 

[alexlawson]

The semicolons not normally their, I copy and pasted this post fast . But I fixed it using this in my init.sqf because the database event didn't work.

DZE_DamageBeforeMaint = 0.00;