Player Safe Reset Mission

[khalcifer]

What i need add to SQF in 1.0.6.1

UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `CharacterID` > 0 AND `Classname` = ('VaultStorageLocked')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL

not work

[juandayz]

Just now, khalcifer said:

What i need add to SQF in 1.0.6.1

UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `CharacterID` > 0 AND `Classname` = ('VaultStorageLocked')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL

not work

the one who comes by default with the epoch server files works well for me..

UPDATE `object_data`
SET `CharacterID` = 0
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
AND `CharacterID` > 0
AND `Classname` = "VaultStorageLocked"
AND `Inventory` <> '[]'
AND `Inventory` IS NOT NULL;