View difference between Paste ID: nJpnYDsF and errNuZD0

--- ----------------------------
+DROP EVENT IF EXISTS updateStockDaily;
--- Event structure for RemoveDamagedVehicles
+CREATE EVENT updateStockDaily
--- ----------------------------
+
-DROP EVENT IF EXISTS RemoveDamagedVehicles;
+COMMENT 'Updates out of stock vendors'
-CREATE EVENT RemoveDamagedVehicles
+
 UPDATE `traders_data` SET qty=250 WHERE qty<50 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat';;
-COMMENT 'Removes damaged vehicles to cleanup the SQL database'
+
 DROP EVENT IF EXISTS removeDamagedVehicles;
-DELETE FROM `Object_DATA` WHERE Damage = 1;
+CREATE EVENT removeDamagedVehicles
 ON SCHEDULE EVERY 1 DAY
--- ----------------------------
+COMMENT 'Removes destroyed vehicles from the database'
--- Event structure for RemoveBikes
+
--- ----------------------------
+DELETE FROM `object_data` WHERE Damage = 1;;
-DROP EVENT IF EXISTS RemoveBikes;
+
-CREATE EVENT RemoveBikes
+DROP EVENT IF EXISTS removeObjectOld;
 CREATE EVENT removeObjectOld
-COMMENT 'Removes bikes from the database every 1 hour'
+
 COMMENT 'Removes old objects and vehicles'
-DELETE FROM `Object_DATA` WHERE `classname` = "Old_bike_TK_INS_EP1" OR `classname` = "MMT_CIV";
+
 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 RemoveObjectEmpty
+DROP EVENT IF EXISTS setDamageOnAge;
--- ----------------------------
+CREATE EVENT setDamageOnAge
-DROP EVENT IF EXISTS RemoveObjectEmpty;
+
-CREATE EVENT RemoveObjectEmpty
+COMMENT 'This sets damage on a wall so that it can be maintained'
 DO
-COMMENT 'Remove abandoned storage objects after 14 days of inactivity'
+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` = '[]') );
 
-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` = '[[[],[]],[[],[]],[[],[]]]') );
+DROP EVENT IF EXISTS removeDamagedBikes;
 CREATE EVENT removeDamagedBikes
--- ----------------------------
+
--- Event structure for RemoveObjectOld
+COMMENT 'Removes bikes with damaged tires'
--- ----------------------------
+
-DROP EVENT IF EXISTS `RemoveObjectOld`;
+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]%");
-CREATE EVENT RemoveObjectOld
+
 DROP EVENT IF EXISTS unlockAbandonedVehicles;
-COMMENT 'Remove old objects and vehicles after 14 days of inactivity'
+CREATE EVENT unlockAbandonedVehicles
-DO
+
-DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 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;
--- Event structure for SetDamageOnAge
+
--- ----------------------------
+DROP EVENT IF EXISTS removeAbandonedVehicles;
-DROP EVENT IF EXISTS SetDamageOnAge;
+CREATE EVENT removeAbandonedVehicles
-CREATE EVENT SetDamageOnAge
+
 COMMENT 'Removes vehicles that have been abandoned'
-COMMENT 'Building parts can be maintained every 3 days'
+
 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));