hwerw

-- Fix some text and next quest in chain for quest 27726 - Hero's Call: Deepholm!

UPDATE `quest_template` SET `NextQuestId` = 27203, `OfferRewardText` = "Our world is in danger, <name>! We need the help of great heroes, like you, to save it!" WHERE `entry` = 27727;

-- The MaelsTrom quest

-- add chain quest id and text at reward
UPDATE `quest_template` SET `NextQuestId` = 27123, `OfferRewardText` = "<Thrall's muscles strain as primal energy flows through him. His eyes shift your way, acknowledging your arrival.> It is good to see you, $N.",`StartScript` = 27203 WHERE `entry` = 27203;

-- quest start script (will cast spell 84463 - summoning portal to maelstrom);
DELETE FROM `quest_start_scripts` WHERE `id` = 27203;
INSERT INTO `quest_start_scripts` VALUES
(27203,1,15,84463,0,0,0,0,0,0);

-- fix script for portal
UPDATE `gameobject_template` SET `AIName` = '', `ScriptName` = "go_portal_to_maelstrom" WHERE `entry` = 205268;

-- fix script for spell which summons portal (gameobject);
DELETE FROM `spell_script_names` WHERE `spell_id` = 84463;
INSERT INTO `spell_script_names` VALUES
(84463,"spell_portal_to_maelstrom");