aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-09-16 19:35:32 +0200
committerGitHub <noreply@github.com>2016-09-16 19:35:32 +0200
commitb90afa88574b74a9b7524aaf875ff52bcafe426b (patch)
tree4a1ed4cc1140440fd92544813fee16755e7a938d
parente07f68a032ae1f559296d99ec8b6e0982d6f8f79 (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.
-rw-r--r--sql/updates/world/3.3.5/2016_09_16_06_world.sql20
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_09_16_06_world.sql b/sql/updates/world/3.3.5/2016_09_16_06_world.sql
new file mode 100644
index 00000000000..b034f70dd2d
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);