Dead Players Broken Vehicles Database

[Backtrack]

Hello i need a script which remove dead players and Brokenvehicle from database

 

[d0t]

-- ----------------------------

-- Event structure for removeDamagedVehicles

-- ----------------------------

DROP EVENT IF EXISTS `removeDamagedVehicles`;

DELIMITER ;;

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

;;

DELIMITER ;

 

This script is also on the serverfiles in the SQL map/directory.