Need Help On Vehicle clean up with Navicat or HeidiSQL

[Motosuwa]

Hey all.

I'm having difficulty with vehicle clean up on my server. What I'm after is for the server to delete any vehicle that is not locked every Friday or 7 days. Regardless if the vehicle is empty or not.

I know I need to use HeidiSQL or Navicat, but I'm still a total novice using it.

Could anyone help me on this? A real simple guide or a real simple guy =P

Many thanks in advance.

[Motosuwa]

Found this, 

 

CREATE EVENT unlockAbandonedVehicles

ON SCHEDULE EVERY 1 DAY
DO
UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `CharacterID` > 0 AND `Classname` NOT IN ('VaultStorage','LockboxStorage','VaultStorageLocked','LockboxStorageLocked','WoodShack_DZ','StorageShed_DZ','TentStorageDomed','TentStorageDomed2','TentStorage')  AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL
;

 

No idea how to add it. Post I found this on, people seem to know how to add it so not telling their secrets!

 

Any help you be really appreciated!

[Motosuwa]

bump