Jump to content

Plot pole maintain


Hux

Recommended Posts

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

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

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

  • 4 weeks later...

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...