Logan Posted October 15, 2014 Report Share Posted October 15, 2014 Tried this BEGINDELETE FROM dayz_epoch.object_data WHERE Classname LIKE '%Storage",1%'AND object_data.LastUpdated < NOW() - INTERVAL 35 DAY;END Doesn't seem to work, tried editing it around a bit and still can't get it. Currently running the safe unlock after 25 days. Just looking for a way to delete safes and other storage after a certain amount of time. Link to comment Share on other sites More sharing options...
0 cen Posted October 15, 2014 Report Share Posted October 15, 2014 /* Delete unused storage objects */ DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 35 DAY) AND `Classname` IN ('Wooden_shed_DZ','WoodShack_DZ', 'TentStorage', 'TentStorageDomed', 'TentStorageDomed2', 'WoodCrate_DZ', 'GunRack_DZ', 'OutHouse_DZ', 'StorageShed_DZ', 'VaultStorageLocked', 'LockboxStorageLocked'); Link to comment Share on other sites More sharing options...
Question
Logan
Tried this
BEGIN
DELETE FROM dayz_epoch.object_data
WHERE Classname LIKE '%Storage",1%'
AND object_data.LastUpdated < NOW() - INTERVAL 35 DAY;
END
Doesn't seem to work, tried editing it around a bit and still can't get it.
Currently running the safe unlock after 25 days.
Just looking for a way to delete safes and other storage after a certain amount of time.
Link to comment
Share on other sites
1 answer to this question
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