MSQL Event

[Tanita-Corp]

Hello guys)

Tell me please how to make 

spawned veh. unused 4 day deleted

with key veh. unused 14 day deleted

 

I broke my head

[Schalldampfer]

use this in WHERE clause

regarding to time,
un-updated for 4 days   : LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 4 DAY)
un-updated for 14 days : LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)

regarding to key,
without key : `CharacterID` = 0
with key       : `CharacterID` <> 0

(If you can't understand how to use them, read textbooks about SQL)

[Tanita-Corp]

can tell example pls)

[Schalldampfer]

read text book first

 

and, you already have examples in DayZ Epoch server pack
https://github.com/EpochModTeam/DayZ-Epoch/tree/master/Server Files/SQL
especially
https://github.com/EpochModTeam/DayZ-Epoch/blob/master/Server Files/SQL/add_recommended_mysql_events.sql