Advertisement
corbuhh

Untitled

Apr 27th, 2014
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.49 KB | None | 0 0
  1. 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]%");
  2. 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` = '[]') );
  3. UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 10 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 10 DAY) AND `CharacterID` > 0 AND `Classname` = "VaultStorageLocked"  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL;
  4. DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 10 DAY) AND classname NOT IN ('Land_DZE_GarageWoodDoor', 'Land_DZE_GarageWoodDoorLocked', 'Land_DZE_GarageWoodDoorLocked', 'Land_DZE_LargeWoodDoor', 'Land_DZE_LargeWoodDoorLocked', 'Land_DZE_WoodDoor', 'Land_DZE_WoodDoorLocked', 'CanvasHut_DZ', 'LightPole_DZ', 'CinderWallDoorLocked_DZ', 'CinderWallDoorSmallLocked_DZ', 'CinderWallDoorSmall_DZ', 'CinderWallDoorway_DZ', 'CinderWallDoor_DZ', 'CinderWallHalf_DZ', 'CinderWallSmallDoorway_DZ', 'CinderWall_DZ', 'DeerStand_DZ', 'DesertCamoNet_DZ', 'DesertLargeCamoNet_DZ', 'Fence_corrugated_DZ', 'ForestCamoNet_DZ', 'ForestLargeCamoNet_DZ', 'Fort_RazorWire' ,'Generator_DZ' ,'Hedgehog_DZ' ,'Land_DZE_GarageWoodDoor' ,'Land_DZE_GarageWoodDoorLocked', 'Land_DZE_LargeWoodDoor', 'Land_DZE_LargeWoodDoorLocked', 'Land_DZE_WoodDoor', 'Land_DZE_WoodDoorLocked', 'Land_HBarrier1_DZ', 'Land_HBarrier3_DZ', 'LockboxStorageLocked', 'MetalFloor_DZ', 'MetalGate_DZ', 'MetalPanel_DZ', 'OutHouse_DZ', 'ParkBench_DZ', 'TentStorageDomed2', 'TentStorageDomed', 'TentStorage', 'StorageShed_DZ', 'StickFence_DZ', 'SandNest_DZ', 'Sandbag1_DZ', 'Plastic_Pole_EP1_DZ', 'VaultStorageLocked', 'Wooden_shed_DZ', 'WoodLargeWallDoor_DZ', 'WoodLadder_DZ', 'WoodFloor_DZ', 'WoodFloorQuarter_DZ', 'WoodFloorHalf_DZ', 'WoodSmallWall_DZ', 'WoodSmallWallWin_DZ', 'WoodSmallWallThird_DZ', 'WoodSmallWallDoor_DZ', 'WoodShack_DZ', 'WoodRamp_DZ', 'WoodLargeWall_DZ', 'WoodLargeWallWin_DZ', 'WoodStairsSans_DZ', 'WoodStairs_DZ', 'BagFenceRound_DZ', 'FireBarrel_DZ', 'WorkBench_DZ', 'FuelPump_DZ', 'GunRack_DZ', 'Land_HBarrier5_DZ', 'Scaffolding_DZ', 'WoodCrate_DZ');
  5. DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 10 DAY) AND classname LIKE '%tent%' AND inventory LIKE '[[[],[]],[[],[]],[[],[]]]';
  6. DELETE FROM `object_data` WHERE Damage = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement