SQL events

[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?

 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

Thanks Aurora!

[jahangir13]

You execute it as database statement in your mysql management tool.

[SASR Ryan]

open Mysql or whatever database program you use. select a new query, paste the code in & execute it. The event will then be inside the database.