Jump to content
  • 0
freakystyle

[Work] Maintain for free / SQL Event delete the Walls/Floors in x Days

Question

Hey guys my problem i want not buy for Maintain, where can I change that? Who nice if you can give me the path. :)

 

Give a Script forgotten objects are not maintained disappear after 2 weeks? (delete)

 

Info: i have [How To] [CPC] Indestructible Bases.

Share this post


Link to post
Share on other sites

16 answers to this question

Recommended Posts

  • 0

Add this to your init.qf in your default mission file:

DZE_requireplot = 0;

So your config section in your init.sqf looks like this:

// DayZ Epoch config
spawnShoremode = 1; // Default = 1 (on shore)
spawnArea= 1500; // Default = 1500
MaxHeliCrashes= 10; // Default = 5
MaxVehicleLimit = 500; // Default = 50
MaxDynamicDebris = 100; // Default = 100
dayz_MapArea = 14000; // Default = 10000
dayz_maxLocalZombies = 30; // Default = 30
DZE_requireplot = 0;

Then go to your HiveExt.ini and add this to your "Objects" section:

CleanupPlacedAfterDays = -1

So it looks like this:

[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
CleanupPlacedAfterDays = -1

Share this post


Link to post
Share on other sites
  • 0

If you want people to maintain their base for free  you can do the following:

1. Go to your @DayZ_Epoch folder, find dayz_code.pbo and extract maintain_area.sqf from the Actions folder. 

2. Add said file to your mission.pbo folder(if you have a folder called custom, scripts or something similar just drop it in one of those. 

3. You're gonna need a custom compiles.sqf and fn_selfAction.sqf. is the link on how to fix that. Once you have "installed" those two files, open your new fn_selfActions and search for this: "s_player_maintain_area = player addAction [format". Should be line 223. Once you have found it find this: \z\addons\dayz_code\actions\maintain_area.sqf and replace it with "custom\maintain_area.sqf". You have to do it two times, the second one is just below the first one.

4. Now for making the maintenance free. Open your new maintain_area.sqf and go to line 37. Replace the following code from line 37-53 with this, or download this file and it'll already be fixed.

5. Compile your mission.pbo and try it out.
 

 

Share this post


Link to post
Share on other sites
  • 0

I use 7 DaysUnusedVehicleDelete  :

DELETE FROM `object_data` WHERE

`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)

AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)

AND (Classname = 'AH6X_DZ' OR Classname = 'AN2_DZ' OR Classname = 'ArmoredSUV_PMC_DZE' OR Classname = 'ATV_CZ_EP1' OR Classname = 'ATV_US_EP1' OR Classname = 'C130J_US_EP1' OR Classname = 'car_hatchback' OR Classname = 'car_sedan' OR Classname = 'CH_47F_EP1_DZE' OR Classname = 'CSJ_GyroC' OR Classname = 'datsun1_civil_1_open' OR Classname = 'datsun1_civil_2_covered' OR Classname = 'datsun1_civil_3_open' OR Classname = 'GAZ_Vodnik_MedEvac' OR Classname = 'GLT_M300_LT' OR Classname = 'GLT_M300_ST' OR Classname = 'hilux1_civil_1_open' OR Classname = 'hilux1_civil_2_covered' OR Classname = 'hilux1_civil_3_open_EP1' OR...............

 

and indestructibel Cinder and metal after restart.

 

Isn`t this a problem? will this work with your event ?

Share this post


Link to post
Share on other sites
  • 0

freakystyle: there is a link in your screenshot "Search in Google". What does it say if you press it.

Everything I've found to this was regarding calling the event in a procedure or something.

 

When do you get this error. I guess posting the error message is not enough to find s.o. helping you to solve it. It's easier if s.o. know when it exactly shows up.

Share this post


Link to post
Share on other sites
  • 0
CREATE EVENT removeObjectOld
   ON SCHEDULE EVERY 1 DAY
   COMMENT 'Removes old objects and vehicles'
   DO
     DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY)
 
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.2 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

I give this in my Sql event and the Problem see my Pitcure^^ Jahangirl13

Share this post


Link to post
Share on other sites
  • 0

Hi All, 

I'm looking at introducing free base maintenance on to my servers due to a high rate of base abandonment

And I've got the free maintenance on the plot poles working fine. 

I'm just curios about these sql queries. 

In particular, setDamageOnAge

so this sql query, sets a damage of 0.2 on buildables so that they are able to be maintained, this i understand.

But running this query would update the last modified date would it not? 

 

And in turn, the SQL query to remove the old, unmaintained objects would be nullified. as every buildable would be showing 0.2 damage, last modified yesterday? 

 

would we need to add something that checks for damage of 0 also? or am I reading this completely wrong?

 

also using these two SQL queries, would i need to use 

 

CleanupPlacedAfterDays = -1

 

Or would I  better off setting a value of say, 14? 

Share this post


Link to post
Share on other sites
  • 0

CREATE EVENT removeObjectOld
   ON SCHEDULE EVERY 1 DAY
   COMMENT 'Removes old objects and vehicles'
   DO
     DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY)
 
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.2 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )
I give this in my Sql event and the Problem see my Pitcure^^ Jahangirl13

Is your server running when you run this? Shut down the server, and then from your SQL manager, run this script:

DELETE FROM `object_data`
WHERE `LastUpdated` <= DATE_SUB(NOW(), INTERVAL 14 DAY)
AND `Classname` REGEXP 'wall|floor|door|ladder|stair'
Hope that helps! ;)

=170= Sven2157

Share this post


Link to post
Share on other sites
  • 0

actually. i went through the sql and the maintain area scripts after having some coffee.. and it all makes sense now

disregard my previous post. 

 

thanks guys 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Similar Content

    • By NoxSicarius
      NOTICE For those who want to use this in 1.0.6
      Instead of using this one, I suggest visiting the following thread for game version 1.0.6 and up
       
      The tools are partially updated for the new release. Most features are working so far and it can be downloaded from here (follow the readme for install): https://github.com/noxsicarius/Epoch-Admin-Tools/tree/TestBranch

       
       
      IMPORTANT:
      Under NO circumstances should you download this tool from a different source. I have been notified of numerous virus downloads listed as my work (usually second page of google and farther). I have petitioned to have all of the ones I know of blacklisted and have sent virus profiles to all major antivirus companies. If you find a .exe in any work claiming to be mine, it is a virus and should be shredded. 
      Please only download from MY github link or the links in this post.
      My github repo will NEVER be removed and if I leave the project and someone wishes to take over, they will be given rights to the repo.
       
      Features:
       
      For help with Administration:
      Multiple Admin levels Spectate players "Display code" for locked vaults/doors "Create key" for vehicles with lost keys Force lock and unlock vehicles without keys Base Destruction - Destroy all buildables/vehicles within a customizable radius Spawnable crates with weapons, items, and supplies Spawn locked or temporary vehicles via the menu or a custom-made graphical vehicle menu (screenshot) Other features:
      Godmode Teleport self (or others to you) Flying Invisibility Delete and repair/refuel vehicle on crosshairs ESP - display players, zombies, safes, tents, vehicles, and AI on the map ...and more! Installation, changes, additional information, FAQ, credits, issues and everything else can be found at the project page on Github:

      Epoch Admin Tools on GitHub
      Click here for an install tutorial video for the tool
      I have been informed that some places block GitHub, so here are direct links hosted by me:
      Newest full release: https://www.dropbox.com/s/pjvj07u5yemo7we/Epoch-Admin-Tools-master.zip?dl=0
      Beta build: https://www.dropbox.com/s/xm6t1k3gvp3t8ex/Epoch-Admin-Tools-TestBranch.zip?dl=0


      If you have an improvement you would like to add, make a pull request and make these tools even better!


      Error Reporting:
       
      BEFORE posting an issue on Github or on this forum:
      If you think you might have installed it incorrectly, follow the YouTube Video Install Tutorial Try reinstalling the tool. You more than likely missed something important. Do a quick search on this forum for a fix to your problem. Check your server's RPT log for errors. This will identify 99% of problems with the menu. Be ready to copy/paste the RPT log into Pastebin or Gist in an issue or in the discussion forum for help with troubleshooting. If your problem persists after doing the above:
      Open your arma2oaserver.rpt file in a text editor and copy/paste the RPT log into Pastebin and post your issue in this forum with the rpt log. If you post something like "It doesn't work" I will not acknowledge you. Not giving all possible details in the first post simply makes it take longer to resolve and will waste everyone's time. I am hard pressed for time these days so if you won't take the initiative to provide information, I won't ask for it either. I am not trying to be mean, but I am quite tired of getting 5 or less word posts that provide no information other than this person has some kind of problem somewhere on their server that may or may not be related to this mod. If the problem you are posting is a bug and not a general install problem then post it to this forum AND to the github issues page.  
      I have been asked by someone if they can donate to the project so I am adding the link here.
       
       
      I have invested a good deal of time into this so if you find it useful please give a little donation.
      (DONATE)
      I also accept Crypto Currency: 
      Bitcoin: 1GkzMzwnVwVpnUCVFaAyLDsgD9cqSfigdm
      Litecoin: LbUrUxXzA557VeTWXM8jP7hNf3uZHEqW5b
       
      A sincere thanks to those who made a monetary contribution to this project: calamity, CRHASH, BMovieQueen, zixxel, 8BitSigdom, Anarior, f3cuk, Caveman1, Nathan, [member=WootyWoop], [member=Terrance Smith]
      A huge thanks to those who make the community a better place by answering questions on this project: @juandayz, @EditedSnowHD
      Please leave your name in a note if you donate so that I can list you above.
    • By Dank Professor
      Connection Info: 199.60.101.242:2302
      Addons: @EPOCH
      Steam Group Page: http://steamcommunity.com/groups/ApricotCrew
      Discord: https://discord.gg/tHVsxqU
      Team Speak Server: 216.105.171.14:10158
      Web (under construction): http://apricotcrew.com/

      Group Description:  Apricot Crew—a gaming community built on mutual respect
      Are you tired of TS servers full of dictators, crazy rules, and painful disruptions to your gaming experience? Look no further, you finally found a place to call "home." Apricot Crew is a community of like minded gamers. If you respect us, we'll respect you.
      For the love of the game, have fun!
       
      P.S.  We started this server as a bunch of friends who wanted a dedicated place to play Epoch.  Come try it so we can have more people on at once...
    • By harcosgoogle
      Hi!
       
      plotpole bug. Base maintanied ,The base has disappeared. Why?
       
      He was paid in vain
       
      Thanks!
    • By RC_Robio
      Epoch Discord is open.
      https://discord.gg/0k4ynDDCsnMzkxk7
      Always a work in progress. Channels will be added as needed. 
      Check pinned messages in the channel for latest updates!
      Rules that apply here also apply there. DO NOT PM the dev's if they happen to be there! You may PM me or one of the other moderators.
      Download the app at: https://discordapp.com/apps
    • By Gabriel12237
      Hello Community i need help .

      Sorry for my bad english. Im from germany and i need help.

      I Have Advanced trading and Single currency 3.0 (without global banking) from zupa, and when i sell or buy in the normal trading menu , the trader dont use coins from me. With advanced trading menu the trader use coins for the item.

      Pls help me.

      Thx
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...