Wiping player items after x days

[wangtangnoodle]

Hi, still fairly new to all of this.

Does anyone know how I could set up an event in Navicat to wipe all the items a player has put into the database, if for example they haven't logged in for 14 days?

Got server cleanup methods in place already but the number of items is still rocketing, so this method seems to be the best bet seeing as all of the players are on every day, or every two.

Thanks in advance.

[Lobo]

What exactly are you looking to wipe? Player placed items like base parts?

[wangtangnoodle]

Yes, built base parts, also safes and owned vehicles.

On a side note, it'd be great to have a similar code to use to make owned cars unlocked after x days of them not being manually unlocked by the owner(s). But this isn't needed half as much as the above. Thanks.

[Lobo]

This doesn't encompass everything but,

 

Check out section 4

 

http://dayzepoch.com/wiki/index.php?title=Server_Configuration_Instructions#Server_Maintenance

 

You may need to query SET GLOBAL event_scheduler = 1; to enable the scheduler in your DB

[wangtangnoodle]

Thanks. I knew about the scheduler but even by looking at the server maintenance page, I'm still no further along in terms of knowing how to write an event for what I asked.

[Lobo]

If you are using Heidi SQL

 

I use this syntax

 

CREATE EVENT removeDamagedVehicles
ON SCHEDULE EVERY 1 DAY
COMMENT 'Removes damaged vehicles'
DO
DELETE FROM `object_data` WHERE Damage = 1;

 

Add this by right clicking your epoch DB and choosing Create New and then event.