Cleaning up owned vehicles where no keys exist.

[xsnipuhx]

How do I do this, can someone point me in the right direction?

[vbawol]

You can use this mysql event to unlock vehicles that do not have keys in the hive.

 

https://github.com/vbawol/DayZ-Epoch/blob/master/Server%20Files/SQL/add_recommended_mysql_events.sql#L107-L129

[xsnipuhx]

Perfect. Thank you sir!

[MassAsster]

#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

[Sukkaed]

How does the delete keyless vehicles work then? As it is a function, not an event.

[vbawol]

Should be able to simply run this via sql

SELECT DeleteNonKeyVehicles();

[Sukkaed]

Would this work?

...\bin\mysql.exe --user=root --password= --host=localhost --port=3306 --database=epoch --execute="call DeleteNonKeyVehicles()"

[vbawol]

No as that is a function and CALL is used with procedures. This should work when looking to use CALL

-- ----------------------------
-- PROCEDURE structure for DeleteNonKeyVehicles
-- Example usage: CALL DeleteNonKeyVehicles();
-- ----------------------------
DROP PROCEDURE IF EXISTS `DeleteNonKeyVehicles`;
DELIMITER ;;
CREATE PROCEDURE `DeleteNonKeyVehicles`()
BEGIN
	DELETE FROM
		`Object_DATA`
	WHERE
		`Object_DATA`.`CharacterID` <> 0
		AND `Object_DATA`.`CharacterID` <= 12500
		AND `Object_DATA`.`Classname` NOT LIKE 'Tent%'
		AND `Object_DATA`.`Classname` NOT LIKE '%Locked'
		AND `Object_DATA`.`Classname` NOT LIKE 'Land%'
		AND `Object_DATA`.`Classname` NOT LIKE 'Cinder%'
		AND `Object_DATA`.`Classname` NOT LIKE 'Wood%'
		AND `Object_DATA`.`Classname` NOT LIKE 'Metal%'
		AND `Object_DATA`.`Classname` NOT LIKE '%Storage%'
		AND `Object_DATA`.`Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ', 'DesertCamoNet_DZ', 'StickFence_DZ', 'LightPole_DZ', 'DeerStand_DZ', 'ForestLargeCamoNet_DZ', 'Plastic_Pole_EP1_DZ', 'Hedgehog_DZ', 'FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ')
		AND FindVehicleKeysCount(Object_DATA.CharacterID) = 0;

END
;;
DELIMITER ; 

[WEB11]

Thanks I'll give this a try.