SQL Events

[Triage]

Will this event delete walls, and player place object sin epoch?

DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') )

[Glenn]

Yes. 

 

It will look at all objects in the table and find all that has a LastUpdated day/time older than 14 days and a DatesStamp older than 24 days and has no inventory. 

As walls and doors and such things generally have no inventory - they will be removed. 

 

What maintenance do, is update the LastUpdated date/time stamp and essentially prevent this code from deleting the items. 

[Triage]

Thanks Glenn