From ab67c93a386d5e5c55ec647a18a31f8d8b391aed Mon Sep 17 00:00:00 2001 From: ZenoX92 Date: Thu, 9 May 2019 19:41:54 +0200 Subject: DB/Quest: More Breadcrumb Quests Closes #23256 --- sql/updates/world/3.3.5/2019_05_09_02_world_335.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_05_09_02_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_05_09_02_world_335.sql b/sql/updates/world/3.3.5/2019_05_09_02_world_335.sql new file mode 100644 index 00000000000..3301c18b162 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_05_09_02_world_335.sql @@ -0,0 +1,17 @@ +-- BreadCrumb Quest "Ragnar Thunderbrew" +DELETE FROM `quest_template_addon` WHERE `ID` IN (4126,4128); +INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES (4128,4126); + +-- BreadCrumb Quest "Call of Fire" +UPDATE `quest_template_addon` SET `ExclusiveGroup`=0, `BreadcrumbForQuestId`=1524 WHERE `ID` IN (1522,1523,2983,2984); + +-- BreadCrumb Quest "Call of Water" +UPDATE `quest_template_addon` SET `ExclusiveGroup`=0, `BreadcrumbForQuestId`=1530 WHERE `ID` IN (1528,1529,2985,2986); + +-- BreadCrumb Quest "The Barrens Oases" +DELETE FROM `quest_template_addon` WHERE `ID` IN (886); +INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES (886,870); + +-- BreadCrumb Quest "A Threat in Feralas" +DELETE FROM `quest_template_addon` WHERE `ID` IN (2981); +INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES (2981,2975); -- cgit v1.2.3