aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-16 19:35:32 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-28 20:38:41 +0100
commit4ea38046b108fa685f412ed685ecb481dc2feaed (patch)
tree2282a0a0524edadd97225e0b68e8dfaf8c524118
parenta893855e07ac1ddf98ab91e86f31a32a389a7d69 (diff)
DB/Quest: Dragonblight part 2:
- To Dragon's Fall requires completion of Wanted: Magister Keldonus, Wanted: Gigantaur and Wanted: Dreadtalon. - Black Blood of Yogg-Saron, Marked for Death: High Cultist Zangus and Containing the Rot require completion of Agmar's Hammer. - Strengthen the Ancients requires completion of The Focus on the Beach. - Message from the West requires completion of Hellscream's Champion. - Only one between A Tauren Among Taunka and The Taunka and the Tauren can be completed. (cherry picked from commit b90afa88574b74a9b7524aaf875ff52bcafe426b)
-rw-r--r--sql/updates/world/master/2017_02_28_09_world_2016_09_16_06_world.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_28_09_world_2016_09_16_06_world.sql b/sql/updates/world/master/2017_02_28_09_world_2016_09_16_06_world.sql
new file mode 100644
index 00000000000..b034f70dd2d
--- /dev/null
+++ b/sql/updates/world/master/2017_02_28_09_world_2016_09_16_06_world.sql
@@ -0,0 +1,20 @@
+--
+DELETE FROM `quest_template_addon` WHERE `ID` IN (12089, 12090, 12091);
+INSERT INTO `quest_template_addon` (`ID`, `NextQuestID`, `ExclusiveGroup`) VALUES
+(12089, 12095, -12089),
+(12090, 12095, -12089),
+(12091, 12095, -12089);
+
+UPDATE `quest_template_addon` SET `PrevQuestID`=12008 WHERE `ID`=12039;
+DELETE FROM `quest_template_addon` WHERE `ID` IN (12056, 12100);
+INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`) VALUES
+(12056, 12008),
+(12100, 12008);
+
+UPDATE `quest_template_addon` SET `PrevQuestID`=12066 WHERE `ID`=12096;
+UPDATE `quest_template_addon` SET `PrevQuestID`=11916 WHERE `ID`=12033;
+
+UPDATE `quest_template_addon` SET `ExclusiveGroup`=11977 WHERE `ID`=11977;
+DELETE FROM `quest_template_addon` WHERE `ID`=11979;
+INSERT INTO `quest_template_addon` (`ID`, `ExclusiveGroup`) VALUES
+(11979, 11977);