Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Delete Damaged Bikes Every 3 Hours
- DELETE FROM object_data WHERE (classname = "MMT_CIV" OR classname = "ATV_CZ_EP1" OR classname = "ATV_US_EP1")
- AND (hitpoints LIKE "%[\"wheel_1_damper\",1]%"
- AND hitpoints LIKE "%[\"wheel_2_damper\",1]%")
- Delete Old Bikes Every 3 Hours
- DELETE FROM object_data WHERE (classname = "Old_bike_TK_INS_EP1" OR classname = "Old_bike_TK_CIV_EP1")
- Remove Damage Vehicles Every 3 Hours
- DELETE FROM `object_data` WHERE Damage = 1
- Remove Empty Objects Once a day
- DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') )
- Remove old Objects Once a day
- DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY)
- Remove Old Character Data Every 2 days
- DELETE FROM character_data WHERE Alive = 0
- Old Player Logins Once a day
- DELETE FROM player_login WHERE Datestamp < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
- Safe Reset (Cant seem to get it to work) Once a day
- UPDATE `object_data` SET `CharacterID` = 0
- WHERE
- `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND
- `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND
- `CharacterID` > 0 AND
- `Classname` IN ('VaultStorageLocked') AND
- `Inventory` <> '[]' AND
- `Inventory` IS NOT NULL
- Set Damage on old Objects Once a day
- UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 2 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )
- UnlockNonKeyVehicles Every 20 days
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement