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 in case 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 maintained buildings after 7 days.

;CleanupPlacedAfterDays = 7

Is this correct ?

[AlexLawson]

Bump, Still need to know this.

[rossco5378]

Bump, Still need to know this.

There is a simpler way to do this.

 

 

My method is to put this in the init.sqf

DZE_DamageBeforeMaint = 0.00;

This means that you must maintain your base regardless of the damage to the building parts within the time limit. (In your case 7 days)

[syco]

Change

;CleanupPlacedAfterDays = 7

To

CleanupPlacedAfterDays = 7

Need to remove  ;  to enable it.

[AlexLawson]

Ok so if I put 

DZE_DamageBeforeMaint = 0.00;

in my init.sqf and then set cleanup to 7 thats 7 day maintenance. I hope this works going to try it on the test server first last I did this I removed everyone's base. 

[syco]

Wanna be sure no bases get removed instantly? If some are over that 7days old they will get removed right when the server comes up. Run this as query in database to update all bases then after the 7 days they will start to vanish.

UPDATE `Object_DATA` SET `Datestamp`=CURRENT_TIMESTAMP WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )