CREATE PROCEDURE `Delete Character`(IN charname varchar(100))
BEGIN
DECLARE id int(11);
SELECT obj_Id INTO id FROM characters WHERE char_name=charname;
DELETE FROM character_friends WHERE char_id=@id OR friend_id=@id;
DELETE FROM character_hennas WHERE char_obj_id=@id;
DELETE FROM character_macroses WHERE char_obj_id=@id;
DELETE FROM character_quests WHERE char_id=@id;
DELETE FROM character_recipebook WHERE char_id=@id;
DELETE FROM character_shortcuts WHERE char_obj_id=@id;
DELETE FROM character_skills WHERE char_obj_id=@id;
DELETE FROM character_skills_save WHERE char_obj_id=@id;
DELETE FROM character_subclasses WHERE char_obj_id=@id;
DELETE FROM heroes WHERE char_id=@id;
DELETE FROM olympiad_nobles WHERE char_id=@id;
DELETE FROM seven_signs WHERE char_obj_id=@id;
DELETE FROM pets WHERE item_obj_id IN (SELECT object_id FROM items WHERE items.owner_id=@id);
DELETE FROM items WHERE owner_id=@id;
DELETE FROM merchant_lease WHERE player_id=@id;
DELETE FROM characters WHERE obj_Id=@id;
END;