Jump to content
  • 0

Maintain bug?


daryl922

Question

Hello

 

keeps writing 0 days and 0 objects

 

Hivext.ini

Quote

;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
;Leaving CleanupPlacedAfterDays below commented (with a ; in front) will NOT disable the cleanup, but will make the objects get cleaned up after the default 6 days.
CleanupPlacedAfterDays = 7

;Flag indicating whether hiveext should detect vehicles out of map boundaries (X < 0, or Y > 15360) and reset their position to []
;Note: YOU MUST have a proper dayz_server.pbo that supports this feature, otherwise you will get script errors
;You can find that file under the SQF directory for your server version
;ResetOOBVehicles = false

;A string of comma separated object class names that are to be cleaned up, after the CleanupPlacedAfterDays period, regardless of inventory
;This variable was implemented to compensate for door/plot management storing information in the inventory field
;custom buildables which use the inventory field should be added to this variable
;If you wish to cleaup locked storage objects, instead of letting them zero out, you can add them to the variable
;Do not use double quotation marks, only use single quotation marks [']
MaintenanceObjects = 'Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_WoodDoorLocked','CinderWallDoorLocked_DZ','CinderWallDoorSmallLocked_DZ','Plastic_Pole_EP1_DZ'Insert other media

 

32.png

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

You need to enable your events in your sql database. make sure they are adding in the database, things like RemoveBases ect . Check your database scheduler is on. In your database my.ini file, look for this and make sure it is turned on. If it doesn't exist, add it, save the file and restart your mysql service.

 

 

GLOBAL event_scheduler=ON

 

Link to comment
Share on other sites

  • 0


event_scheduler=ON 
event_scheduler=1

MYsql:

Quote

DELETE from Character_data
USING Character_data, Character_data as tempchartable
WHERE (Character_data.PlayerUID = tempchartable.PlayerUID)
AND (NOT Character_data.alive = tempchartable.alive)
AND (Character_data.alive = 0)
;

 

 

Quote

DELETE FROM Character_DATA 
WHERE LastLogin < NOW() - INTERVAL 30 DAY
;

 

Quote

UPDATE `object_data`
SET `CharacterID` = 10000
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
AND `CharacterID` > 0
AND `Classname` = "LockboxStorageLocked"
AND `Inventory` <> '[]'
AND `Inventory` IS NOT NULL
;

 

 

Quote

DELETE FROM `player_login`
;

 

 

Quote

DELETE FROM `object_data`
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
AND `Classname` IN ('Plastic_Pole_EP1_DZ','CinderWallDoorSmallLocked_DZ','CinderWallDoorLocked_DZ','CinderWallSmallDoorway_DZ','CinderWallDoorway_DZ','Land_DZE_WoodDoorLocked','CinderWallDoor_DZ','CinderWallDoorSmall_DZ','Land_DZE_WoodDoor','Land_DZE_GarageWoodDoor','Land_DZE_GarageWoodDoorLocked','Land_DZE_LargeWoodDoorLocked','Land_DZE_LargeWoodDoor','WoodLargeWallDoor_DZ')
;

 

 

Quote

UPDATE `object_data` SET `CharacterID` = 0
WHERE
`LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND
`CharacterID` > 0 AND
`Classname` IN ('VaultStorageLocked') AND
`Inventory` <> '[]' AND
`Inventory` IS NOT NULL
;

 

 

 

Quote

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` = '[]') )

 

 

Quote

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
;

 

 

 

you can do everything on the base as well.
It only says 0 object maintain

Link to comment
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
  • Discord

×
×
  • Create New...