SQL event for stopping items that cant be damaged from being removed

[megaz]

Hi Guys as the title I am running so sql event and have found that certain items wont take damage from th esql event like Tents, Wooden Crates StorageSheds, Sand bags , Tank Traps, Wire fence etc, Is there ans event that can update the date on these itemsdaily or a way to add these items to the sql set damage event? Found this and not quite sure if this can be used to make a list of objects that can be added to be updated daily? (the ones in red)

 

 

-- Event structure for UnlockNonKeyVehicles
-- ----------------------------
DROP EVENT IF EXISTS `UnlockNonKeyVehicles`;
DELIMITER ;;
CREATE EVENT `UnlockNonKeyVehicles` ON SCHEDULE EVERY 1 DAY 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\_%' -- added escape character so LandRover vehicles are not ignored
   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', 'DesertLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ', 'BagFenceRound_DZ')
   AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0

 

or can I just add the items that i want to maintain the the variables line  here:

DZE_maintainClasses = ["ModularItems","DZE_Housebase","LightPole_DZ","BuiltItems","Plastic_Pole_EP1_DZ","Fence_corrugated_DZ","CanvasHut_DZ","ParkBench_DZ","MetalGate_DZ","StickFence_DZ","DesertCamoNet_DZ","ForestCamoNet_DZ","DesertLargeCamoNet_DZ","ForestLargeCamoNet_DZ","DeerStand_DZ","Scaffolding_DZ","FireBarrel_DZ"];

 

Thanks

 

MegaZ

[megaz]

Update to this:
have added these to :
DZE_maintainClasses = ["ModularItems","DZE_Housebase","LightPole_DZ","BuiltItems","Plastic_Pole_EP1_DZ","Fence_corrugated_DZ","CanvasHut_DZ","ParkBench_DZ","MetalGate_DZ","StickFence_DZ","DesertCamoNet_DZ","ForestCamoNet_DZ","DesertLargeCamoNet_DZ","ForestLargeCamoNet_DZ","DeerStand_DZ","Scaffolding_DZ","FireBarrel_DZ","DZE_LockedStorage","Fortifications","TentStorageDomed","TentStorageDomed2","TentStorage","Wooden_shed_DZ","WoodCrate_DZ","StorageShed_DZ","Hedgehog_DZ","Sandbag1_DZ","BagFenceRound_DZ","FuelPump_DZ","Land_HBarrier1_DZ","Land_HBarrier3_DZ","Land_HBarrier5_DZ","WoodShack_DZ","GunRack_DZ"];

But still these items wont take damage by the Set Damage on age sql so they cant be maintained.

Wooden_shed_DZ
WoodCrate_DZ
StorageShed_DZ
Wooden_shed_DZ
TentStorage
GunRack_DZ
WoodShack_DZ
LockboxStorageLocked - this will get damage if it is a empty one
VaultStorageLocked - this will get damage if it is a empty one

Any help on this would be appreciated as Item are starting to disappear from the server.
Thanks
MegaZ

[megaz]

Ok guy got this sorted thanks to Ebay

for any one else who has this it is due to the Damage Sql I was running.

 

UPDATE `object_data` SET `Damage`=0.11 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 day) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )

 

Removed the red bit and all items now take damage

 

MegaZ