Jump to content
  • 0
Tricks

Did base maintenance do it?

Question

Hey everyone,

 

A few of our long time players had their bases wiped overnight. They insist they have been maintaining the base weekly. Which log can I check to see what deleted the bases?

 

Also I am getting this error in my HiveExt.log:

 

2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 00:01:59 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 04:05:14 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 08:09:58 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 12:07:34 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 16:01:27 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-20 20:03:17 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-20 20:03:17 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-20 20:03:17 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-20 20:03:17 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-20 20:03:17 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-20 20:03:18 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-21 00:07:14 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-21 04:02:35 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-21 08:01:45 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 28775 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 29595 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 29690 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 29699 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 29762 load because of invalid data in db
2014-10-21 12:01:40 HiveExt: [Error] Skipping ObjectID 30662 load because of invalid data in db

 

Thank you

Share this post


Link to post
Share on other sites

25 answers to this question

Recommended Posts

  • 0

I am not sure why the objects were deleted. We have had similar Hive errors from time to time. The Hive Errors tell you that objects with those ObjectIDs have corrupted data. You could make a backup, delete those objects or try to sort out where the error is in the various fields for them, and restart.

Share this post


Link to post
Share on other sites
  • 0

Best thing to do is check the database for those ID's and see if theirs any issues with their data(something looks out of place)

 

Also, as for the maintence, Idk about you but my servers maintain doesn't work, you can maintain, but when the object gets damaged(via sql) it won't reset the damage to 0, thus won't update it in the database, so the server(if you have the cleanup running) deletes it after the amount of days you set it to....I havent figured out whats wrong with it as I have even set up a test server and ran the default mission and server files and it still not work, unless its an issue with inifstar(which I highly doubt) as it was the only custom thing installed when I tested it(helps make it easier to test with the ability to spawn items in)

Share this post


Link to post
Share on other sites
  • 0

I am not sure why the objects were deleted. We have had similar Hive errors from time to time. The Hive Errors tell you that objects with those ObjectIDs have corrupted data. You could make a backup, delete those objects or try to sort out where the error is in the various fields for them, and restart.

The only times that this has happened in my database, has been due to a table character length being exceeded, always in the Worldspace table. The table is set for 128 characters and anytime the object location data in game exceeds this, the "invalid data" error appears. The item does not appear.  Easily solved by increasing the character limit  to 132. The only thing my entries needed to correct the error was a closing bracket. Placed the closing bracket at the end of each entry and the items appear in the world.

 

-CJ-

Share this post


Link to post
Share on other sites
  • 0

The only times that this has happened in my database, has been due to a table character length being exceeded, always in the Worldspace table. The table is set for 128 characters and anytime the object location data in game exceeds this, the "invalid data" error appears. The item does not appear.  Easily solved by increasing the character limit  to 132. The only thing my entries needed to correct the error was a closing bracket. Placed the closing bracket at the end of each entry and the items appear in the world.

 

-CJ-

 

CJ,

 

Thanks for your input, can you explain stpe by step how you increased your table from 128 characters to 132?

Share this post


Link to post
Share on other sites
  • 0

CJ,

 

Thanks for your input, can you explain stpe by step how you increased your table from 128 characters to 132?

I use HeidiSQL to open, log into the database. When I open up the database, I click on the object_data table and am presented with the table settings on the right. Look under the "Name" column and you will see "Worldspace". Under the "Length/Set" column, you will see a number, mine was set at 128 for "Worldspace" and the error appeared anytime the data was 129 characters or longer in length. I just changed the number from 128 to 132 and no longer receive the errors. Once you have increased the number, you may be able to add the missing info for your bad entries. All of mine took  a closing bracket to fix them and they appeared as placed by the player.

 

-CJ-

Share this post


Link to post
Share on other sites
  • 0

Thank you CJ  :)

I was scratching my head on this one for a bit. One clan member had finished his base but the very last piece placed disappeared, leaving a small hole in his roof. I had scanned the data a couple times, but never really looked at it close. Everything looked ok as his player Id was listed at the end as all the others were. After pulling a few hairs and checking various things, I noticed the last bracket was missing at the end of the data string.

With all of the mods out now that add data to the "Worldspace" category, the characters in this string had exceeded the limit of 128 characters by 1. That one missing character was the closing bracket. Problem solved but a better inspection of the data would have solved it earlier in my case.

I hope you can fix you missing items as easily.

-CJ-

Share this post


Link to post
Share on other sites
  • 0

Hey CJ, it didn't fix it. Players doors and garage doors are still being deleted.... I have added the doors to my variables.sqf to ensure they are updated when maintained:

 

DZE_DoorsLocked = ["Land_DZE_GarageWoodDoorLocked","Land_DZE_LargeWoodDoorLocked","Land_DZE_WoodDoorLocked","CinderWallDoorLocked_DZ","CinderWallDoorSmallLocked_DZ"];
DZE_safeVehicle = ["ParachuteWest","ParachuteC","MMT_Civ","TT650_Civ","CSJ_GyroC"];
DZE_Garage = ["Land_MBG_Garage_Single_D","Land_MBG_Garage_Single_A","Land_MBG_Garage_Single_B","Land_MBG_Garage_Single_C"];
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","Land_MBG_Garage_Single_D","Land_MBG_Garage_Single_A","Land_MBG_Garage_Single_B","Land_MBG_Garage_Single_C","HeliH","CinderWallHalf_DZ","CinderWall_DZ","CinderWallSmallDoorway_DZ","CinderWallDoorSmall_DZ","CinderWallDoorSmallLocked_DZ","CinderWallDoorway_DZ","CinderWallDoor_DZ","CinderWallDoorLocked_DZ"]; 

 

This is killing me! What can be the issue??

 

Plot poles too now....

Edited by Tricks

Share this post


Link to post
Share on other sites
  • 0

Hey CJ, it didn't fix it. Players doors and garage doors are still being deleted.... I have added the doors to my variables.sqf to ensure they are updated when maintained:

 

DZE_DoorsLocked = ["Land_DZE_GarageWoodDoorLocked","Land_DZE_LargeWoodDoorLocked","Land_DZE_WoodDoorLocked","CinderWallDoorLocked_DZ","CinderWallDoorSmallLocked_DZ"];
DZE_safeVehicle = ["ParachuteWest","ParachuteC","MMT_Civ","TT650_Civ","CSJ_GyroC"];
DZE_Garage = ["Land_MBG_Garage_Single_D","Land_MBG_Garage_Single_A","Land_MBG_Garage_Single_B","Land_MBG_Garage_Single_C"];
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","Land_MBG_Garage_Single_D","Land_MBG_Garage_Single_A","Land_MBG_Garage_Single_B","Land_MBG_Garage_Single_C","HeliH","CinderWallHalf_DZ","CinderWall_DZ","CinderWallSmallDoorway_DZ","CinderWallDoorSmall_DZ","CinderWallDoorSmallLocked_DZ","CinderWallDoorway_DZ","CinderWallDoor_DZ","CinderWallDoorLocked_DZ"]; 

 

This is killing me! What can be the issue??

 

Plot poles too now....

My post was about the "invalid data" errors that you were receiving. I don't use decay on my server but you may want to check your SQL events and see what is being run and what they are cleaning up. Also, what do you have in the HiveExt  config file in this section:

 

;Negative values will disable this feature

;0 means that ALL empty placed items will be deleted every server restart

;A positive number is how old (in days) a placed empty item must be, in order for it to be deleted

CleanupPlacedAfterDays = ????

 

-CJ-

Share this post


Link to post
Share on other sites
  • 0

My post was about the "invalid data" errors that you were receiving. I don't use decay on my server but you may want to check your SQL events and see what is being run and what they are cleaning up. Also, what do you have in the HiveExt  config file in this section:

 

;Negative values will disable this feature

;0 means that ALL empty placed items will be deleted every server restart

;A positive number is how old (in days) a placed empty item must be, in order for it to be deleted

CleanupPlacedAfterDays = ????

 

-CJ-

 

Hey CJ,

 

Maybe you can shed some light? Or anyone? I think I have been looking at it for too long and need some fresh eyes.

 

I will post my SQL events:

 

Delete Unused Vehicles

DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 DAY) AND `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked') AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL 

Remove Damaged Vehicles

DELETE FROM `object_data` WHERE Damage = 1 

Remove Empty Objects

DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') ) 

Remove Old Logins

DELETE FROM `player_login` WHERE `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) 

Remove Old Object

DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 21 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY) 

Remove Old Characters

DELETE FROM `character_data` WHERE `LastLogin` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 22 DAY) 

Set Damage on Age

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

 

Clean-up in my HiveExt is set to: CleanupPlacedAfterDays = 21

Share this post


Link to post
Share on other sites
  • 0

Question... do I require the "Remove Old Object" SQL Event if I already if I have CleanupPlacedAfterDays = 21 in place?

I was going to ask if they are the same.... Perhaps you can do away with the "remove old objects" SQL event...

Here is something else you might wish to try

-CJ-

Share this post


Link to post
Share on other sites
  • 0

I used the delete unused vehicle code once, just straight up ran it in SQL, deleted about 1100 items!

Chuffed I was to get rid of all them unused cars.

3......2.......1 all the complaints of walls and doors going missing came rolling in

Share this post


Link to post
Share on other sites
  • 0

havnt tried it yet but was plannign on running this in about a weeks timeor so, adjusting days to suit

Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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 `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

Share this post


Link to post
Share on other sites
  • 0

 

havnt tried it yet but was plannign on running this in about a weeks timeor so, adjusting days to suit

Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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 `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

 

Can we add cinder doors and garage doors to your "NOT IN" list to be assured they are not deleted?

Share this post


Link to post
Share on other sites
  • 0

they should fall under the %locked and cinder% calls but i suppose you could also add the built classname to the NOT IN section too

 

EDIT

 

just checked and yes they all fall under the %cinder %locked sections

 

just changed it up abit for origins buildings as im on overpochins

Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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', 'Uroven1DrevenaBudka', 'Uroven2KladaDomek', 'Uroven3DrevenyDomek', 'Uroven1VelkaBudka', 'Uroven2MalyDomek', 'Uroven3VelkyDomek', 'kingramida', 'velkaGaraz', 'malaGaraz', 'krepost')
AND `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

Share this post


Link to post
Share on other sites
  • 0

 

they should fall under the %locked and cinder% calls but i suppose you could also add the built classname to the NOT IN section too

 

EDIT

 

just checked and yes they all fall under the %cinder %locked sections

 

just changed it up abit for origins buildings as im on overpochins

Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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', 'Uroven1DrevenaBudka', 'Uroven2KladaDomek', 'Uroven3DrevenyDomek', 'Uroven1VelkaBudka', 'Uroven2MalyDomek', 'Uroven3VelkyDomek', 'kingramida', 'velkaGaraz', 'malaGaraz', 'krepost')
AND `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

 

Hey Carl, I want to enter this in as a normal event like my others so I dont have to do it manually. Do you know how to create the "INSERT INTO" part and all that jazz?  :P

Share this post


Link to post
Share on other sites
  • 0

probably this

DROP EVENT IF EXISTS DeleteOldVehicles;
CREATE EVENT DeleteOldVehicles

    ON SCHEDULE EVERY 1 DAY

    COMMENT 'Delete Old Vehicles'

    DO
Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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', 'Uroven1DrevenaBudka', 'Uroven2KladaDomek', 'Uroven3DrevenyDomek', 'Uroven1VelkaBudka', 'Uroven2MalyDomek', 'Uroven3VelkyDomek', 'kingramida', 'velkaGaraz', 'malaGaraz', 'krepost')
AND `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

Share this post


Link to post
Share on other sites
  • 0

 

probably this

DROP EVENT IF EXISTS DeleteOldVehicles;
CREATE EVENT DeleteOldVehicles

    ON SCHEDULE EVERY 1 DAY

    COMMENT 'Delete Old Vehicles'

    DO
Delete From `Object_DATA`
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY)
AND `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', 'Uroven1DrevenaBudka', 'Uroven2KladaDomek', 'Uroven3DrevenyDomek', 'Uroven1VelkaBudka', 'Uroven2MalyDomek', 'Uroven3VelkyDomek', 'kingramida', 'velkaGaraz', 'malaGaraz', 'krepost')
AND `Object_DATA`.`Inventory` NOT LIKE '%Gold%'

 

Hey carl, one thing I am noticing in your event. You have Character ID set to ,+12500, I have character IDs as high as 38607. What issues will that cause?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Advertisement
  • Advertisement
  • Supporters
  • Advertisement
  • Discord

×