Heya, so I have this database event that puts safes to 0000, and lockboxes to red 00 after 15 days.
But are there any good other database event to delete them after a certain amount of days with these codes?
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!
So Im not sure where I went wrong. I have Soul's coin system installed using this
I also used this
With some modifications.
Then I went on to add plot management, Zupas indestructible locked vehicles near plot pole, build vectors and snap pro.
Somewhere along the line, although I dont know where, players and I are unable to access safes. You go up to the safe, you get the option to unlock it, type in code, nothing happens. I can't even unlock them with the admin tool. No errors in the RPT... Im stumped.. Please help this is a major server killer.
Here is my fn_selfactions.sqf