Advertisement
MyNameIsPowell

Untitled

Sep 3rd, 2014
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.70 KB | None | 0 0
  1. Delete Damaged Bikes Every 3 Hours
  2.  
  3. DELETE FROM object_data WHERE (classname = "MMT_CIV" OR classname = "ATV_CZ_EP1" OR classname = "ATV_US_EP1")
  4. AND (hitpoints LIKE "%[\"wheel_1_damper\",1]%"
  5. AND hitpoints LIKE "%[\"wheel_2_damper\",1]%")
  6.  
  7. Delete Old Bikes Every 3 Hours
  8. DELETE FROM object_data WHERE (classname = "Old_bike_TK_INS_EP1" OR classname = "Old_bike_TK_CIV_EP1")
  9.  
  10. Remove Damage Vehicles Every 3 Hours
  11. DELETE FROM `object_data` WHERE Damage = 1
  12.  
  13. Remove Empty Objects Once a day
  14. 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` = '[[[],[]],[[],[]],[[],[]]]') )
  15.  
  16. Remove old Objects Once a day
  17. DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY)
  18.  
  19. Remove Old Character Data Every 2 days
  20. DELETE FROM character_data WHERE Alive = 0
  21.  
  22. Old Player Logins Once a day
  23. DELETE FROM player_login WHERE Datestamp < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
  24.  
  25. Safe Reset (Cant seem to get it to work) Once a day
  26.  
  27. UPDATE `object_data` SET `CharacterID` = 0
  28. WHERE
  29. `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND
  30. `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 20 DAY) AND
  31. `CharacterID` > 0 AND
  32. `Classname` IN ('VaultStorageLocked') AND
  33. `Inventory` <> '[]' AND
  34. `Inventory` IS NOT NULL
  35.  
  36. Set Damage on old Objects Once a day
  37. 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` = '[]') )
  38.  
  39. UnlockNonKeyVehicles Every 20 days
  40. UPDATE
  41. `object_data`
  42. SET
  43. `object_data`.`CharacterID` = 0
  44. WHERE
  45. `object_data`.`CharacterID` <> 0
  46. AND `object_data`.`CharacterID` <= 12500
  47. AND `object_data`.`Classname` NOT LIKE 'Tent%'
  48. AND `object_data`.`Classname` NOT LIKE '%Locked'
  49. AND `object_data`.`Classname` NOT LIKE 'Land%'
  50. AND `object_data`.`Classname` NOT LIKE 'Cinder%'
  51. AND `object_data`.`Classname` NOT LIKE 'Wood%'
  52. AND `object_data`.`Classname` NOT LIKE 'Metal%'
  53. AND `object_data`.`Classname` NOT LIKE '%Storage%'
  54. 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')
  55. AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement