Is there some way to clean up (delete) unused locked vehicles?

[robbiedarza]

Hello there, I have a lot of locked vehicles all over my map, and I cant delete them in case they are still being used.

 

So I was wondering if there was a script or something that would auto delete vehicles that have not been used within a month.

 

 

Many thanks

 

 

Robbie

 

 

[Sukkaed]

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

[robbiedarza]

Thank you very much for the reply mate.

 

What do I do with that line please? Do I need to add it into one of the files in my server pbo?

 

 

Many thanks

 

robbie

[Picking]

Make a event in your DB and add that into it

[robbiedarza]

Ok thank you very much, I am using dayz.st does anyone know what i have to do plz?

 

Never done anything like that

 

many thanks

 

robbie

[cletus]

Ok thank you very much, I am using dayz.st does anyone know what i have to do plz?

 

Never done anything like that

 

many thanks

 

robbie

 

not sure if dayz.st allows access to the database, but you would connect to your mysql database, and depending on the app used to connect the database, click events and new event from there.  i use navicat to connect to the database.  i also had to run this query as events were turned off by default

SET GLOBAL event_scheduler = ON;

[mysticviperx]

We have done this on out server, but in a odd and roundabout way. First, we have updated our Hive.dll to change how it handles the database. It loads the Modular Building objects first, then the vehicles, just like the 1.0.4 Hive.dll will (all this was done in house before the the 1.0.3 update.) It also handles the object age updating, by doing in inside the hive.dll instead of an event in the database. We disabled the 'UPDATE CURRENT TIME' event in the database that was triggered every time a vehicle was altered.

 

Then we setup events for the database to run different cleanups:

• First it checks of the vehicle is locked, if so (and it isnt a fuel truck) and its a week old then it changes the 'character id' variable from what ever key value to '0', thus unlocking the vehicle permanently. It also updates the vehicle's time stamp to the current time.
• Next it looks for unlocked vehicles that are 6 days old and repairs them to 100%, but it does not update the vehicle's 'Last_Updated' varible.
• Finally it looks for vehicles that have not been touched in 7 days, and are fully repaired, if its true, It deletes the vehicle.

Its quite nice and helps rotate the vehicles out of my server and clean up vehicles left play inactive player, and its completely customizable.

 

If there is any one interested, i can offer a tutorial on all the steps to do this.

[cayote]

We have done this on out server, but in a odd and roundabout way. First, we have updated our Hive.dll to change how it handles the database. It loads the Modular Building objects first, then the vehicles, just like the 1.0.4 Hive.dll will (all this was done in house before the the 1.0.3 update.) It also handles the object age updating, by doing in inside the hive.dll instead of an event in the database. We disabled the 'UPDATE CURRENT TIME' event in the database that was triggered every time a vehicle was altered.

 

Then we setup events for the database to run different cleanups:

• First it checks of the vehicle is locked, if so (and it isnt a fuel truck) and its a week old then it changes the 'character id' variable from what ever key value to '0', thus unlocking the vehicle permanently. It also updates the vehicle's time stamp to the current time.
• Next it looks for unlocked vehicles that are 6 days old and repairs them to 100%, but it does not update the vehicle's 'Last_Updated' varible.
• Finally it looks for vehicles that have not been touched in 7 days, and are fully repaired, if its true, It deletes the vehicle.

Its quite nice and helps rotate the vehicles out of my server and clean up vehicles left play inactive player, and its completely customizable.

 

If there is any one interested, i can offer a tutorial on all the steps to do this.

Sounds pretty sweet....can you post info on how to do this?  I'm mostly a beginner at setting up the events...although I am learning a bit :)

[mysticviperx]

yeah, ill set one up. I wont go much into the explanation, just do this and this and this type post. And you will need my custom hive.dll, i need to make sure its ok to give that out. (for both you and me) You will need some spicific tools and access to your server, from what i have heard about gsp's, that shouldnt be a problem.

[robbiedarza]

Ok thank you for the replies and the help guys, it seems a little bit over my head but ill have a go.

 

Many thanks all

 

 

Robbie

[mysticviperx]

With the immanent release of 1.0.4 and the epoch devs doing the same with the hive.dll and other database settings, I will postpone the Tutorial until the release of 1.0.4 and i have compared their work to our own. Some things in the tutorial will be incompatible with the new hive.dll.

[Sukkaed]

Never heard of host that doesn't allow access to database :o  Lets not make this too complicated.

 

There is link to your database at Dayz.st control panel. Go there choose your epoch table and run this under SQL.

CREATE EVENT DeleteOldVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes unused vehicles'
DO
DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY) AND `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked') AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL

I would do it with shorter timeline like 10 days.

[WWKHeadhunter]

thanks for this info. anyway to edit the sql?. i added it with the 30 days and thats just to long

[Sukkaed]

Change wanted time here:

DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 30 DAY)

[Sukkaed]

To remove events that you have added use this:

drop event if exists CapS_SenSitiVe_EvenT_Name;

So in this case it would be:

drop event if exists DeleteOldVehicles;

[gopostal]

Never heard of host that doesn't allows access to database :o  Lets not make this too complicated.

Thank you for that. Added to my server just now. What a great community this is.

[wrxman2004]

will this remove base parts like walls and such? i run a server with a small player base and i set it up so you dont have to maintain the base parts and they stay forever. i just want to remove some of the random locked helis and such with out removing base parts

[Sukkaed]

No, walls and such don't have inventory. Like it is stated here:

`Inventory` <> '[]' AND `Inventory` IS NOT NULL

[DangerRuss]

Would this only delete unused vehicles if their inventory is empty? I have a lot of abandoned vehicles from players who no longer play on the server. I'd like to remove the vehicles even if their inventory is full.

[Logan]

Would this only delete unused vehicles if their inventory is empty? I have a lot of abandoned vehicles from players who no longer play on the server. I'd like to remove the vehicles even if their inventory is full.

Anyone have a trigger for this? I have so many vehicles on my Chernarus server from players who left.

[vRazgriz]

I had a hacker on my server that spawned a bunch of locked vehicles, and I tired adding an event to the database, however the database keeps rejecting the event. I have tired clearing them from the database, but they just keep spawning back in locked. 

[DangerRuss]

better to just roll back the database at that point