Maintenance Question

[DavemanDingo]

I'm kinda of newbie when it comes to scripting.

 

I've been trying to search the forums, but I don't see how to turn maintenance off. I saw a couple of scripts that tried to fool the server, but nothing to turn it off.

 

Can I turn it off?

 

And if it's a script I must use, what is it and where do I add it?

 

Thank you!

[Turtle]

hiveext.ini file

look for line:

CleanupPlacedAfterDays = 14

 

and change it to

CleanupPlacedAfterDays = -1

 

and this will make it so none of the stuff place will despawn after a certain amount of days.

 

you can also try turning on indestructible bases by looking for your //EpochConfig section and add this to it

 

DZE_GodModeBase = true;

 

which will make bases indestructable.

 

or you can add this to the same section 

DZE_requireplot = 0;

 

and you wont need plot poles to build.

 

This is everything I could think of that could probably help you.

[DavemanDingo]

yeah, I have the CleanupPlacedAfterDays = -1 set like that and they still disappear.

 

If I make the bases indestructible, will it stop them from disappearing?

[Turtle]

do you have any queries you run for your database?

[DavemanDingo]

This is where the newbie part comes in. I don't know. Unless it was configured in the Epoch files, then no.

[Turtle]

Queries are things that you run to do stuff like database clean-ups.

I asked because even though you have the cleanupplacedafterdays = -1  the database clean up could still be deleting the old built items

[DavemanDingo]

I didn't install anything like that

[Turtle]

you don't have to, if you run with a host provider they could do it automatically

[Sukkaed]

You probably have uncommented CleanupPlacedAfterDays. Check that there is no ; mark on front of that line.

[DavemanDingo]

I double checked. In the configfiles folder. It does NOT have the semi colon in front of it.

Is there another place that the file night be?

[Dactyl]

I double checked. In the configfiles folder. It does NOT have the semi colon in front of it.

Is there another place that the file night be?

 or it would be // to comment stuff out

[Dactyl]

CleanupPlacedAfterDays = 6

 is located in your HiveExt.ini can be opened with notepad or just a word file. if you dont know where then follow this handy guide:

 

• Go to wherever you have server installed,  we'll call it Day z server
• Day z Server\instance_11_chernarus\HiveExt.ini
• Open with note pad find the section that reads:

  [Objects]
  ;Which table should the objects be stored and fetched from ?
  ;Table = Object_DATA
  
  ;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
  CleanupPlacedAfterDays = -1
  
  ;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
  ;ResetOOBVehicles = false
  
  ;If using OFFICIAL hive, the settings in this section have no effect, it will manage objects on its own
  

• Edit "CleanupPlacedAfterDays= "to what ever youd like

 

Now I'm actually pretty sure it will be commented out like @Sukkaed mentioned so be sure to delete that when you want it available. 

[DavemanDingo]

Yeah, mine looks just like that, and stuff is still disappearing. 

[Dactyl]

Yeah, mine looks just like that, and stuff is still disappearing. 

[Turtle]

wow read that wrong lol, yeah ive heard that it still happens, look deeper, i have it set to -1 but havent tested it. 

you sorta just rewrote everything at the top brother. 

[Dactyl]

you sorta just rewrote everything at the top brother. 

 

said he couldnt find the file, i just said it in detail. something that is certainly lacking in forums. 

[Turtle]

said he couldnt find the file, i just said it in detail. something that is certainly lacking in forums. 

[DavemanDingo]

Yeah, I have  set it to -1 and even changed it to 365.
It doesn't go much longer then 2 weeks and the walls, floors, etc disappears.
We are using HFB servers, & their control panel has a section with the HiveExt.ini
Just getting REAL old building something and having it disappear.

[Sukkaed]

Create this event to your database. It updates the timestamp to current every day. Should prevent decay.

CREATE EVENT preventCleanup
ON SCHEDULE EVERY 1 DAY
COMMENT 'prevents all cleanup by setting datestamp to current'
DO
UPDATE `Object_DATA` SET `Datestamp`=CURRENT_TIMESTAMP WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

[Dactyl]

 

Create this event to your database. It updates the timestamp to current every day. Should prevent decay.

CREATE EVENT preventCleanup
ON SCHEDULE EVERY 1 DAY
COMMENT 'prevents all cleanup by setting datestamp to current'
DO
UPDATE `Object_DATA` SET `Datestamp`=CURRENT_TIMESTAMP WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

 

How does one create an event in the database?

[Turtle]

How does one create an event in the database?

Open up something like navicat and create a new query. Paste that in there and then hit run. (usually looks like a little play button.)

[Dactyl]

can you explain to me how to create a query and what it does 

[Turtle]

I don't know much about them. I just know they are used to keep databases in order. For example. 

 

lets say you ran this:

UPDATE `Traders_DATA` SET qty=75 WHERE qty=0;

It will restock anything that is out of stock in traders.

 

There are tons of things to do also like

DELETE FROM `object_data` WHERE Damage = 1;

Where it deletes destroyed vehicles that are no longer on your server but still in your db. There are tons of things you can do to keep your DB nice and tidy.

 

Check this out

https://github.com/vbawol/DayZ-Epoch/blob/master/Server%20Files/SQL/add_recommended_mysql_events.sql