aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorGacko <gacko28@gmx.de>2014-03-18 20:01:14 +0100
committerGacko <gacko28@gmx.de>2014-03-18 20:01:14 +0100
commit38611a6d19e1167730ba2661ff4749e273a44473 (patch)
tree566a77679875b5140e455ff20c79eebea7b38b29 /sql/updates
parent1a0b3e596bd9c1df9343b2e50a04b17af60b21fd (diff)
DB/Quest: Add Empowerment to Shadowmourne quest line
Thanks @Foldor. Closes #11425
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2014_03_18_00_world_quest.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/2014_03_18_00_world_quest.sql b/sql/updates/world/2014_03_18_00_world_quest.sql
new file mode 100644
index 00000000000..2ca49917a12
--- /dev/null
+++ b/sql/updates/world/2014_03_18_00_world_quest.sql
@@ -0,0 +1,20 @@
+-- The Splintered Throne
+UPDATE `quest_template` SET `NextQuestId`=24912 WHERE `Id`=24548;
+
+-- Shadowmourne...
+UPDATE `quest_template` SET `PrevQuestId`=24912 WHERE `Id`=24549;
+
+-- Empowerment
+UPDATE `quest_template` SET `PrevQuestId`=24548, `NextQuestId`=24549 WHERE `Id`=24912;
+
+DELETE FROM `creature_queststarter` WHERE `quest`=24912;
+INSERT INTO `creature_queststarter`(`id`,`quest`) VALUE
+(37120,24912);
+
+DELETE FROM `creature_questender` WHERE `quest`=24912;
+INSERT INTO `creature_questender`(`id`,`quest`) VALUE
+(37120,24912);
+
+-- Highlord Darion Mograine
+UPDATE `creature_template` SET `AIName`='' WHERE `entry`=37120;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=37120 AND `source_type`=0;