diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-09-16 19:35:32 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-28 20:38:41 +0100 |
| commit | 4ea38046b108fa685f412ed685ecb481dc2feaed (patch) | |
| tree | 2282a0a0524edadd97225e0b68e8dfaf8c524118 | |
| parent | a893855e07ac1ddf98ab91e86f31a32a389a7d69 (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.sql | 20 |
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); |
