DROP EVENT IF EXISTS resetVaults; CREATE EVENT resetVaults
ON SCHEDULE EVERY 1 DAY
COMMENT 'Sets safe codes to 0000 if not accessed for 14 days'
DO
UPDATE `object_data` SET `CharacterID` = 0
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`CharacterID` > 0 AND
`Classname` IN ('VaultStorageLocked') AND
`Inventory` <> '[]' AND
`Inventory` IS NOT NULL
Question
deltagi
I was wondering how I would make this mod
Is there any tutorials for SQL evnets out there?
Where do I put this bit of code?
Thanks Aurora!
Link to comment
Share on other sites
2 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