gwew

-- Quest Defending The Wyrmrest Temple
SET @Wyrm   = 27629;
SET @Spell1 = 49161;    -- Flame Breath
SET @Spell2 = 49243;    -- Immolation
SET @Spell3 = 49263;    -- Renew
SET @Spell4 = 49264;    -- Blazing Speed
SET @Spell5 = 49367;    -- Destabilize Azure Dragonshrine

UPDATE `creature_template` SET `AIName`='', `ScriptName` = "npc_wyrmrest_defender",`npcflag`=`npcflag`|1,`unit_flags`=134217728,`gossip_menu_id`= 0,`InhabitType`=4,`spell1`=@Spell1,`spell2`=@Spell2,`spell3`=@Spell3,`spell4`=@Spell4,`spell5`=@Spell5 WHERE `entry`=@Wyrm;

DELETE FROM `gossip_menu_option` WHERE `menu_id`=@Gossip;

DELETE FROM `spell_script_names` WHERE `spell_id` = 49367;
INSERT INTO `spell_script_names` VALUES (49367,"spell_destabilize_dragonshire");

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=27629;