So I have a server and there are quite a few locked vehicles just sitting around taking up space, I want to put in an event like:
DELETE FROM `object_data` WHERE `LastUpdated`< DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) AND `CharacterID`>0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked') AND `Inventory`<>'[]' AND `Inventory` IS NOT NULL
But instead of deleting them, I want to teleport them to the volcano on the tavi map, as like a storage area, just incase someone wants their vehicle back. I would like to teleport them after about 60 days of inactivity, but i'm not too keen on deleting.
Question
SheepishShaun
So I have a server and there are quite a few locked vehicles just sitting around taking up space, I want to put in an event like:
But instead of deleting them, I want to teleport them to the volcano on the tavi map, as like a storage area, just incase someone wants their vehicle back. I would like to teleport them after about 60 days of inactivity, but i'm not too keen on deleting.
Can this be done?
Link to comment
Share on other sites
4 answers 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