Hux Posted June 14, 2020 Report Share Posted June 14, 2020 I'm not getting any damage on building parts so that maintain option shows up in plot pole. I am forced to use Force maintain. My database shows that events are Off so I'm going to ask my host to enable, but I also see no events listed. Am I supposed to add the event to create damage to building parts? How would I do this? Thank you. Link to comment Share on other sites More sharing options...
Hux Posted June 18, 2020 Author Report Share Posted June 18, 2020 Anyone know how I add db event for causing damage to building parts? Link to comment Share on other sites More sharing options...
lwbuk Posted June 20, 2020 Report Share Posted June 20, 2020 UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') ) AND ( (`Classname` NOT LIKE '%Vault%') AND (`Classname` NOT LIKE '%Lockbox%') ) Link to comment Share on other sites More sharing options...
Hux Posted June 23, 2020 Author Report Share Posted June 23, 2020 On 6/20/2020 at 12:36 PM, lwbuk said: UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') ) AND ( (`Classname` NOT LIKE '%Vault%') AND (`Classname` NOT LIKE '%Lockbox%') ) Thank you. Link to comment Share on other sites More sharing options...
Hux Posted July 21, 2020 Author Report Share Posted July 21, 2020 My server host setup the event for me. I was wondering about how often the damage Interval should be set in relation to decay setting? I have decay in HiveExt.ini set to 14 days. Here is event: 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` = '[]') OR (`Classname` IN ('Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_WoodDoorLocked','CinderWallDoorLocked_DZ','CinderWallDoorSmallLocked_DZ','Plastic_Pole_EP1_DZ')) ) Interval is 3 days. Should it be a higher number? Thank you. Link to comment Share on other sites More sharing options...
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