aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-05-19 00:29:08 +0300
committeroffl <offl@users.noreply.github.com>2021-05-19 00:29:08 +0300
commit1004a173a18c80628d6b0f566145091171f87961 (patch)
treea906f8012aa9d4c4cb9016d552ecfb6627b0fe80
parent80711f5ea110ab9f401662c2363127ef4d27a42f (diff)
DB/Quest: Prevent learning both Gnomish & Goblin Engineering
Closes #25855
-rw-r--r--sql/updates/world/3.3.5/2021_05_18_03_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_05_18_03_world_335.sql b/sql/updates/world/3.3.5/2021_05_18_03_world_335.sql
new file mode 100644
index 00000000000..2f75babd821
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_05_18_03_world_335.sql
@@ -0,0 +1,6 @@
+--
+UPDATE `quest_template_addon` SET `NextQuestID` = 3641 WHERE `ID` = 3640; -- Was 3639
+UPDATE `quest_template_addon` SET `NextQuestID` = 3643 WHERE `ID` = 3642; -- Was 3639
+UPDATE `quest_template_addon` SET `PrevQuestID` = 3638 WHERE `ID` = 3639; -- Was 0
+
+UPDATE `quest_template_addon` SET `ExclusiveGroup` = 0 WHERE `ID` IN (3638,3640,3642); -- Was 3638