aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com>2024-02-18 01:40:33 +0100
committerNaddley <NaddleyTC@gmail.com>2024-02-18 01:40:37 +0100
commit206a03e59ecad31d7aa66f40d8ee554d404a48a7 (patch)
treef6930317bb20172f13e25c19dcf386767ce3f37c
parentc5a4cd2133ef1a4c082473a0e131856b159e77c3 (diff)
DB/Durotar: Update questchains for Valley of Trials
Closes #29659
-rw-r--r--sql/updates/world/master/2024_02_18_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_18_00_world.sql b/sql/updates/world/master/2024_02_18_00_world.sql
new file mode 100644
index 00000000000..150748c330d
--- /dev/null
+++ b/sql/updates/world/master/2024_02_18_00_world.sql
@@ -0,0 +1,9 @@
+-- Delete Empty Rows
+DELETE FROM `quest_template_addon` WHERE `ID` IN (25129,25152);
+-- Unnecessary NextQuestIDs
+UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE `ID` IN (25131,25132,25133,25136);
+-- Hana'zua
+UPDATE `quest_template_addon` SET `PrevQuestID`=25127 WHERE `ID`=25128;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=25129 WHERE `ID`=25128;
+-- Lazy Peons
+UPDATE `quest_template_addon` SET `PrevQuestID`=25172 WHERE `ID`=37446;