Previous owner had it set for 9000 starting 5/31/14 when the database was created and server was launched, we want it set to maintain every 21 days. Messing with hive I have tried 21, 60, 80 and 100 days and of course after the 1st test of 21 days was set my base was gone so trying to get my base to come back so I can figure out a number to allow the players 3 days to maintain so we can get this squared away.
Current attempt
CleanupPlacedAfterDays = 8990
SQL event is setup for
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` = '[]') )
I do have an complete sql backup with the correct object_data on my test server, so how do I get this setup correctly for it to decay during that 21 days to maintain? I have a fairly good idea of just trying to set random numbers until my base comes back and work back from there but was hoping someone has an idea or suggestion.
Question
1Man
Previous owner had it set for 9000 starting 5/31/14 when the database was created and server was launched, we want it set to maintain every 21 days. Messing with hive I have tried 21, 60, 80 and 100 days and of course after the 1st test of 21 days was set my base was gone so trying to get my base to come back so I can figure out a number to allow the players 3 days to maintain so we can get this squared away.
Current attempt
CleanupPlacedAfterDays = 8990
SQL event is setup for
per http://epochmod.gamepedia.com/Server_Installation_Instructions_Extended.
I do have an complete sql backup with the correct object_data on my test server, so how do I get this setup correctly for it to decay during that 21 days to maintain? I have a fairly good idea of just trying to set random numbers until my base comes back and work back from there but was hoping someone has an idea or suggestion.
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now