aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com>2024-02-26 00:37:31 +0100
committerNaddley <NaddleyTC@gmail.com>2024-02-26 00:37:35 +0100
commitd53d4fd7df54dec3bc1d329f4af3f543e3b91a6d (patch)
tree300619192f8b779769bec3dd94a2a356050381ab
parent0c76618b19a0c3cac159524779ba66bcdeef6795 (diff)
DB/ElwynnForest: Update questchain for Elwynn Forest
Closes #29675
-rw-r--r--sql/updates/world/master/2024_02_26_00_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_26_00_world.sql b/sql/updates/world/master/2024_02_26_00_world.sql
new file mode 100644
index 00000000000..aa8685a41c3
--- /dev/null
+++ b/sql/updates/world/master/2024_02_26_00_world.sql
@@ -0,0 +1,10 @@
+-- Westbrook Garrison Needs Help
+DELETE FROM `quest_template_addon` WHERE `ID`=239;
+INSERT INTO `quest_template_addon` (`ID`,`MaxLevel`,`AllowableClasses`,`SourceSpellID`,`PrevQuestID`,`NextQuestID`,`ExclusiveGroup`,`BreadcrumbForQuestId`,`RewardMailTemplateID`,`RewardMailDelay`,`RequiredSkillID`,`RequiredSkillPoints`,`RequiredMinRepFaction`,`RequiredMaxRepFaction`,`RequiredMinRepValue`,`RequiredMaxRepValue`,`ProvidedItemCount`,`SpecialFlags`,`ScriptName`) VALUES
+(239,0,0,0,0,0,0,11,0,0,0,0,0,0,0,0,0,0,'');
+-- Cloth and Leather Armor and The Jasperlode Mine
+UPDATE `quest_template_addon` SET `NextQuestID`=239 WHERE `ID` IN (59,76);
+-- Young Lovers
+UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=106;
+-- A Visit With Maybell
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=106 WHERE `ID`=26150;