aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com>2024-02-22 01:19:37 +0100
committerNaddley <NaddleyTC@gmail.com>2024-02-22 01:19:40 +0100
commit1e0a51e13173c6d65216532caf71604b515cd292 (patch)
tree2c7ce838425fa829a48b0882713b2660878162e9
parent1db940bc174d4feb95f19c8de52cb2b08057e021 (diff)
DB/Tirisfal: Update questchains for Deathknell
Closes #29686
-rw-r--r--sql/updates/world/master/2024_02_22_01_world.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_22_01_world.sql b/sql/updates/world/master/2024_02_22_01_world.sql
new file mode 100644
index 00000000000..c7db9b51b26
--- /dev/null
+++ b/sql/updates/world/master/2024_02_22_01_world.sql
@@ -0,0 +1,13 @@
+-- Unneeded Condition for Caretaker Caice (Handled by BreadcrumbForQuestId)
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry`=28652;
+-- Delete Unneeded Rows
+DELETE FROM `quest_template_addon` WHERE `ID`=26801;
+-- Caretaker Caice
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=24960 WHERE `ID`=28652;
+-- Shadow Priest Sarvis
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=26801 WHERE `ID`=28653;
+-- Novice Elreth
+UPDATE `quest_template_addon` SET `PrevQuestID`=26801 WHERE `ID`=28651;
+UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE `ID`=28651;
+-- The Truth of the Grave
+UPDATE `quest_template_addon` SET `PrevQuestID`=28651 WHERE `ID`=24961;