DB/Quest: More Breadcrumb Quests

Closes #23256

1 files changed, 17 insertions, 0 deletions

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);