CREATE DEFINER=`1****_mysql_db`@`%` EVENT `removeDamagedVehicles` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Removes damaged vehicles' DO DELETE FROM `Object_DATA` WHERE Damage = 1$$
CREATE DEFINER=`1****_mysql_db`@`%` EVENT `removeObjectEmpty` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Removes abandoned storage objects and vehicles' DO DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') )$$
CREATE DEFINER=`1****_mysql_db`@`%` EVENT `removeObjectOld` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Removes old objects and vehicles' DO DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY)$$
CREATE DEFINER=`1*****_mysql_db`@`%` EVENT `setDamageOnAge` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE 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 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )$$
CREATE DEFINER=`1*****_mysql_db`@`%` EVENT `updateStockDaily` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Updates out of stock vendors' DO UPDATE `Traders_DATA` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat'$$
CREATE DEFINER=`1*****_mysql_db`@`%` EVENT `UnlockNonKeyVehicles` ON SCHEDULE EVERY 1 DAY STARTS '2014-11-18 19:05:42' ON COMPLETION NOT PRESERVE ENABLE 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$$