aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZenoX92 <ZenoX92@users.noreply.github.com>2019-05-09 19:41:54 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-05 13:34:14 +0100
commit84d8ec252f126f1edb3a0d99e3b512a67ac56fd8 (patch)
tree0d57a12d1238f0c152a7db6f7c52aa3f09ad4e9f
parent3a5f87ccb8c7b3750fa0a97b6fbc41b791e0004b (diff)
DB/Quest: More Breadcrumb Quests
Closes #23256 (cherry picked from commit ab67c93a386d5e5c55ec647a18a31f8d8b391aed)
-rw-r--r--sql/updates/world/master/2021_12_05_00_world_2019_05_09_02_world_335.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_05_00_world_2019_05_09_02_world_335.sql b/sql/updates/world/master/2021_12_05_00_world_2019_05_09_02_world_335.sql
new file mode 100644
index 00000000000..3301c18b162
--- /dev/null
+++ b/sql/updates/world/master/2021_12_05_00_world_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);