How to Cleanup database of Unused Storage with items

[seeker619]

How do i go about cleaning up storage items with items in it, that have been unused for X amount of day?

[Sandbird]

First do a :

Select * FROM `object_data` WHERE 
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND 
`Classname` LIKE '%storage%'

to make sure you get the right data....then:

DELETE FROM `object_data` WHERE 
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND 
`Classname` LIKE '%storage%'

if you are sure its the right data...

This will delete objects not updated 24 days ago and back.

 

ex, from this SQL, the first of my objects has LastUpdated time:  2014-03-10 15:54:44 and last: 2013-12-21 14:01:07,

so if i ran this sql it would delete all objects from 21-Dec till 10-March.

 

Edit:

WOW: sorry, did you mean 'empty' ? Or delete ?..... and when you say unused for X amount, do you mean...any day ? like uh..whenever something is not used for 7 days, clear its inventory and keep the object ?

Cause what you are asking is a bit weird if i get this right....You know, that would erase player's vaults as well.  Everything would be on temporary state then...Every vault, tent etc would just keep items in them for X days....then wiped......thats what you want ?

[Alcsaar]

I think he wants to remove containers that aren't used after X amount of days, *shrug*

[Sandbird]

thats what i thought..but he said cleaning...maybe he doesnt want to remove them.

[seeker619]

Never realized anyone responded to me sorry.. im used to seeing an alert on the top right of the screen when a thread i have posts in, has new responses..

 

What i wanted was to DELETE out of my database anything that has not been used in atleast 45 days.  just items that have a storage capacity.  Sheds, Vaults, Tents, Vehicles, Anything that has not been used.