Building maintenance problem

[Perkelin]

Hello!

 

I'm setting up a epoch server with a collegue and we have some troubles with the mantain function, we want to activate this function for 14 days. Our problem is that dagamed objetcs / walls can be mantained normaly but in the next server restart they are fine again ( you get no mantain option either in the objets or just the plot pole). It also seems that time doesnt affect on structures dagame.

 

We are using  Plot for Life and Plot Management on the server. This is our setup on hive:

 

 

 

;This is a comment
;Comments above a certain setting will provide it's description
 
;The format for a setting is
;Variable = Value
 
;If you see a commented line of that form, it means that the setting is optional, and the Value shows the default
;To change from the default, simply uncomment the line and change the Value
 
[Time]
Type = Custom
Offset = +1

[Database]
;Currently, only MySQL is supported
Type = MySQL
;Hostname or IP of the server to connect to
Host = xxxxxxxxxxxxxxxxxx
;Port to connect to. The default is the default listening port of a server of the selected Type
;Instead of specifying Port, you can specify Socket and set Value to the socket name
Port = xxxxxxxxxxxxxxxxxx
;Database name to connect to.
Database =
;Username to connect with
Username = xxxxxxxxxxxxxxx
;Password to authenticate with (default is blank)
Password = xxxxxxxxxxxxxxxxxxxx
 
[Characters]
;The field name that Player's IDs are stored in (unique per game license)
;IDField = PlayerUID
;The field name that Player's World Position and rotation is stored in
;Enables you to run multiple different maps (different instances) off the same character table
;WSField = Worldspace
 
[Objects]
;Flag indicating whether hiveext should detect vehicles out of map boundaries (X < 0, or Y > 15360) and reset their position to []
;Note: YOU MUST have a proper dayz_server.pbo that supports this feature, otherwise you will get script errors
;You can find that file under the SQF directory for your server version
;ResetOOBObjects = false

;EPOCH SETTINGS
;Which table should the objects be stored and fetched from  
Table = Object_DATA
CleanupPlacedAfterDays = 14
 
;Negative values will disable this feature
;0 means that ALL empty placed items will be deleted every server restart
;A positive number is how old (in days) a placed empty item must be, in order for it to be deleted
 
[ObjectDB]
;Setting this to true separates the Object fetches from the Character fetches
;That means that the Object Table must be on this other database
;Use = false
 
;The settings here have the same meaning as in [Database], and are only used if the setting above is set to true
;Type = MySQL
;Host = localhost
;Port = xxxxxxxxxxxxxx
;Database = xxxxxxxxxxx
;Username = xxxxxxxxxx
;Password = xxxxxxxxx

[Tomodan]

check that your sql events are running to add damage after so many days (xampp doesnt have these set as on my default if your on a dedicated box add event_scheduler=ON to the my.ini file for xampp)

 

This is what mine is set to:

UPDATE `Object_DATA` SET `Damage`=0.11 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

also you sql cleanup event:

mine is

 

DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY)

also set

 

CleanupPlacedAfterDays = -1 so the server itself wont delete any items, the sql events should take care of this