SQL Trigger to delete all unused(havent been touched for 7 Days) Vehicles

[Mitscher]

Hey guys,

 

I'm looking for a SQL-Trigger that is deleting all "Old" Vehicles that havent been touched for 7 Days.

 

Cuz I got a lot of vehicles up in the north which noone is using but just a very small amout of vehicles near the Coast.

 

 

Would be very nice if someone could help me!

 

 

 

Greetings

[cen]

/* Delete all vehicles not touched in 7 days */
DELETE FROM `object_data`
WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY)
AND `Classname`
NOT REGEXP 'barrier|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold|nest';

[Mitscher]

Nice,

 

thanks u! So I just need to run this every 7 Days right?

 

 

Greetings

[cen]

You can run it every 5 minutes if you want :)