Hiveext.ini - CleanupPlacedAfterDays

[ToejaM]

What exactly is removed with this function?

 

What column is it checked against?

 

I've had this disabled ever since we started an Epoch server so havent needed it but my understanding is that it only deletes Epoch buildings? Or is it everything?

 

I have a "last_updated" column but if its this column, is it "LastUpdated" it checks for instead or is it the datestamp column?

Cheers.

[RAMBO]

From my understanding the function will remove anything listed in the "object_data" section after X amount of days (whatever you set the cleanup period to be). It is checked against the datestamp.

[ToejaM]

That would remove vaults in this case and tents that have been used?

 

As I have a vault placed: 2013-04-19 20:14:19 - last_updated: 2013-10-14 12:18:26

 

A tent placed: 2013-04-19 22:45:11 - last_updated: 2013-10-27 15:19:12

Surely it can't be everything in the object_data, some things must be excluded?

 

Guess I'll use the script I've been using to only delete objects with a 'bad' last_updated time :-)

[ToejaM]

Anyone with any solid info on this?

[BetterDeadThanZed]

In regards to the SetDamageOnAge query, wouldn't this be a better SQL format?

DROP EVENT IF EXISTS setDamageOnAge;
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.11 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 21 DAY)
  AND (Classname LIKE '%ItemWood%'
OR Classname LIKE '%Cinder%'
OR Classname LIKE '%Metal%'
OR Classname LIKE '%Generator%');

 

This will set the damage to 0.11 on buildables with the classnames as shown. With the recommended query included with Epoch, it seems it would set damage to EVERY owned objects, including vehicles, if the inventory is empty.

 

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.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

 

[hambeast]

x