From b90afa88574b74a9b7524aaf875ff52bcafe426b Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Fri, 16 Sep 2016 19:35:32 +0200 Subject: 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. --- sql/updates/world/3.3.5/2016_09_16_06_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_09_16_06_world.sql (limited to 'sql') 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); -- cgit v1.2.3