Epoch SQL Events

DROP EVENT IF EXISTS updateStockDaily;
CREATE EVENT updateStockDaily
ON SCHEDULE EVERY 1 DAY
COMMENT 'Updates out of stock vendors'
DO
UPDATE `traders_data` SET qty=250 WHERE qty<50 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat';;

DROP EVENT IF EXISTS removeDamagedVehicles;
CREATE EVENT removeDamagedVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes destroyed vehicles from the database'
DO
DELETE FROM `object_data` WHERE Damage = 1;;

DROP EVENT IF EXISTS removeObjectOld;
CREATE EVENT removeObjectOld
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes old objects and vehicles'
DO
DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY);

DROP EVENT IF EXISTS setDamageOnAge;
CREATE EVENT setDamageOnAge
ON SCHEDULE EVERY 1 DAY
COMMENT 'This sets damage on a wall so that it can be maintained'
DO
UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') );

DROP EVENT IF EXISTS removeDamagedBikes;
CREATE EVENT removeDamagedBikes
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes bikes with damaged tires'
DO
DELETE FROM object_data WHERE (classname = "Old_bike_TK_INS_EP1" OR classname = "MMT_CIV") AND (hitpoints LIKE "%[\"wheel_1_damper\",1]%" AND hitpoints LIKE "%[\"wheel_2_damper\",1]%");

DROP EVENT IF EXISTS unlockAbandonedVehicles;
CREATE EVENT unlockAbandonedVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Unlocks vehicles that have been abandoned'
DO
UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 DAY) AND `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked','WoodShack_DZ','StorageShed_DZ','TentStorageDomed','TentStorageDomed2','TentStorage')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL;

DROP EVENT IF EXISTS removeAbandonedVehicles;
CREATE EVENT removeAbandonedVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes vehicles that have been abandoned'
DO
DELETE FROM object_data WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 8 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND ((classname = "Old_bike_TK_INS_EP1" OR classname = "MMT_CIV") OR (fuel <> 0.0000));