how to apply this patch ?FYI, here is the trigger I use to block "bad" house updates. Don't blame me if it breaks your custom Stored Procs or scripts. It should work without issue for the vanilla package.
Change the definer to a user with permissions on the table.
Code:DELIMITER $$ DROP TRIGGER IF EXISTS tr_updateHouseInv$$ CREATE DEFINER = 'dayz'@'localhost' TRIGGER tr_updateHouseInv BEFORE UPDATE ON object_data FOR EACH ROW BEGIN IF (NEW.CharacterID IS NOT NULL AND (NEW.inventory LIKE '[[[],[]],[[],[]],[[],[]]]' OR New.Inventory LIKE '[[[],[]],[["ItemLimestone","ItemRWood"],[%,%]],[[],[]]]')) THEN SIGNAL SQLSTATE '45000'; END IF; END $$ DELIMITER ;