Epoch_SQL_Events

-- ----------------------------
-- Event structure for RemoveDamagedVehicles
-- ----------------------------
DROP EVENT IF EXISTS RemoveDamagedVehicles;
CREATE EVENT RemoveDamagedVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes damaged vehicles to cleanup the SQL database'
DO
DELETE FROM `Object_DATA` WHERE Damage = 1;

-- ----------------------------
-- Event structure for RemoveBikes
-- ----------------------------
DROP EVENT IF EXISTS RemoveBikes;
CREATE EVENT RemoveBikes
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes bikes from the database every 1 hour'
DO
DELETE FROM `Object_DATA` WHERE `classname` = "Old_bike_TK_INS_EP1" OR `classname` = "MMT_CIV";

-- ----------------------------
-- Event structure for RemoveObjectEmpty
-- ----------------------------
DROP EVENT IF EXISTS RemoveObjectEmpty;
CREATE EVENT RemoveObjectEmpty
ON SCHEDULE EVERY 1 DAY
COMMENT 'Remove abandoned storage objects after 14 days of inactivity'
DO
DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') );

-- ----------------------------
-- Event structure for RemoveObjectOld
-- ----------------------------
DROP EVENT IF EXISTS `RemoveObjectOld`;
CREATE EVENT RemoveObjectOld
ON SCHEDULE EVERY 1 DAY
COMMENT 'Remove old objects and vehicles after 14 days of inactivity'
DO
DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY);

-- ----------------------------
-- Event structure for SetDamageOnAge
-- ----------------------------
DROP EVENT IF EXISTS SetDamageOnAge;
CREATE EVENT SetDamageOnAge
ON SCHEDULE EVERY 1 DAY
COMMENT 'Building parts can be maintained every 3 days'
DO
UPDATE `Object_DATA` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') );

-- ----------------------------
-- Event structure for UpdateTraderStock
-- ----------------------------
DROP EVENT IF EXISTS UpdateTraderStock;
CREATE EVENT UpdateTraderStock
ON SCHEDULE EVERY 1 HOUR
COMMENT 'Updates vendor stock. Anything below 250 will update to 250'
DO
UPDATE `Traders_DATA` SET qty=250 WHERE qty<250;

-- ----------------------------
-- Event structure for UnlockNonKeyedVehicles
-- ----------------------------
DROP EVENT IF EXISTS `UnlockNonKeyedVehicles`;
CREATE EVENT `UnlockNonKeyedVehicles`
ON SCHEDULE EVERY 1 DAY
COMMENT 'Unlock locked vehicles that have no key to unlock on the server'
DO
UPDATE `Object_DATA`
SET `Object_DATA`.`CharacterID` = 0
WHERE `Object_DATA`.`CharacterID` <> 0
    AND `Object_DATA`.`CharacterID` <= 12500
    AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
    AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
    AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')
    AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0;

-- ----------------------------
-- Event structure for AbandonedVehiclesUnlock
-- ----------------------------
DROP EVENT IF EXISTS `AbandonedVehiclesUnlock`;
CREATE EVENT `AbandonedVehiclesUnlock`
ON SCHEDULE EVERY 1 HOUR
COMMENT 'Unlock vehicles that have been abandoned and unchanged for 4 days'
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 `Object_DATA`.`CharacterID` <> 0
    AND `Object_DATA`.`CharacterID` <= 12500
    AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
    AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
    AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ');

-- ----------------------------
-- Event structure for AbandonedVehiclesDelete
-- ----------------------------
DROP EVENT IF EXISTS `AbandonedVehiclesDelete`;
CREATE EVENT `AbandonedVehiclesDelete`
ON SCHEDULE EVERY 1 HOUR
COMMENT 'Delete vehicles that have been abandoned and unchanged for 7 days'
DO
DELETE FROM `Object_DATA`
    WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
    AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
    AND `Object_DATA`.`CharacterID` >= 0
    AND `Object_DATA`.`CharacterID` <= 12500
    AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
    AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
    AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
    AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
    AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ');