Jump to content

Question

Hey, guys

So I have dayz.st for host, which is terrible, because I have no access to hive.int to change the decay time.

And the default plot pole maintain isn't working ,either.

When I look at the maintain preview, it shows that 0 building parts in range

sometimes it shows a few building parts when the walls are damaged.

So is there a way to fix it, or add a SQL event to database that damage the base a little bit so players can maintain it

 

 

Thanks :D 

Share this post


Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 0
CREATE EVENT `Maintenance` ON SCHEDULE EVERY 1 DAY STARTS '2014-12-25 00:00:00' ENDS '2026-12-25 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE `object_data`
SET `Object_DATA`.`Damage`=0.3
WHERE `Object_DATA`.`ObjectUID` <> 0
AND `Object_DATA`.`CharacterID` <> 0
AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY
AND ( (`Object_DATA`.`Inventory` IS NULL) OR (`Object_DATA`.`Inventory` = '[]') )

Share this post


Link to post
Share on other sites
  • 0

 

CREATE EVENT `Maintenance` ON SCHEDULE EVERY 1 DAY STARTS '2014-12-25 00:00:00' ENDS '2026-12-25 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE `object_data`
SET `Object_DATA`.`Damage`=0.3
WHERE `Object_DATA`.`ObjectUID` <> 0
AND `Object_DATA`.`CharacterID` <> 0
AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY
AND ( (`Object_DATA`.`Inventory` IS NULL) OR (`Object_DATA`.`Inventory` = '[]') )

 

thanks, 

one more quick question:

AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY

what does this interval 3 day mean

Share this post


Link to post
Share on other sites
  • 0

 

CREATE EVENT `Maintenance` ON SCHEDULE EVERY 1 DAY STARTS '2014-12-25 00:00:00' ENDS '2026-12-25 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE `object_data`
SET `Object_DATA`.`Damage`=0.3
WHERE `Object_DATA`.`ObjectUID` <> 0
AND `Object_DATA`.`CharacterID` <> 0
AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY
AND ( (`Object_DATA`.`Inventory` IS NULL) OR (`Object_DATA`.`Inventory` = '[]') )

 

Also, whats the format of crating an event, because I wanna add in some mroe SQL event

I dont understand what does this part mean

ON COMPLETION NOT PRESERVE ENABLE

Share this post


Link to post
Share on other sites
  • 0

 

Also, whats the format of crating an event, because I wanna add in some mroe SQL event

I dont understand what does this part mean

ON COMPLETION NOT PRESERVE ENABLE

 

AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY  This makes it so you have to wait a minimum of 3 days since the last maintenance or from placing the object before maintaining will work. This value can be adjusted/removed as preferred.

ON COMPLETION NOT PRESERVE ENABLE just makes it so the sql event doesn't expire and get dropped after completing the first time and will allow it to be a repeating event.

Share this post


Link to post
Share on other sites
  • 0

AND `Object_DATA`.`Datestamp` < now() - INTERVAL 3 DAY  This makes it so you have to wait a minimum of 3 days since the last maintenance or from placing the object before maintaining will work. This value can be adjusted/removed as preferred.

ON COMPLETION NOT PRESERVE ENABLE just makes it so the sql event doesn't expire and get dropped after completing the first time and will allow it to be a repeating event.

CLOCWORK IS A NOOB :P and yes allen cloc is right :)

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 McLovin
      NOTICE: Duplicate of another question posted in the wrong section.
       
      So I've been playing this server that has a number of mods installed. I've been playing it for quite a while with the only errors I've been getting are regarding a 45 round RPK mag being missing, but other than that I've had no errors or any issues loading. Upon trying to place a plot pole, nothing happens; absolutely nothing, like no preview shows up, no prompt saying "starting construction" or anything like that, just blankness. When I try to do it again it says "building already in progress" and I can't do anything, not even lock my vehicle. Is there anything that can be done, or that can explain this phenomenon? To further the understanding of how this came to be, I bought a plot pole from the trader in Trader City Stary and tried placing it near Stary, but not too near it (near a thicket of bushes in the distance). Upon right clicking and hitting the build option, that's when I face my issue.
    • By victorks
      my first work in editin :) https://uploaddeimagens.com.br/imagens/20180307202515_1-jpg https://uploaddeimagens.com.br/imagens/20180307202245_1-jpg DOWNLOAD: https://www.dropbox.com/s/oq97j7x59362kqe/CASTLEai.sqf?dl=0 AI M2 NEED WAI: https://pastebin.com/GJMnPvZP ON THE MAP: https://pastebin.com/cyqH9rNV  
       
      https://www.dropbox.com/s/oq97j7x59362kqe/CASTLEai.sqf?dl=0
       
       
       
       
       
       
       
       
       
    • By lesvieuxcrevards
      HI,
       
      I've questions regarding decay timer :
      What is maximum value for these timers? Does it possible to turn off ? Best Regards
    • By Forrest
      I am looking for a friend or group that can be on from 7-10 am GMT. I want to build a base. My email is [email protected], Skype is Forrest Perkins, steam is forrestmikeperkinskirk. I may be on from 10- 16 am GMT on the 18th of July, 2017 but I'm always looking for friends I can trust.
    • By Kovicson
      Hi Folks!
      I was wondering if theres a way to stop players from removing plot poles that aren't theres?
      Using a toolbox, crowbar and Etool players can remove Plot poles that dont belong to them, anyway to fix and remove that option?
       
      Thanks :)
  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...