diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-03-11 01:34:50 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-03-11 01:34:55 +0100 |
| commit | f317baf4f443f9deb7363ae499c2e2eab12d0353 (patch) | |
| tree | de7a05a4ef90f45624ad66756f35e822a9bc4dd4 | |
| parent | fa30ea397e8e50f29ee6782ae8101c17cf28a82d (diff) | |
DB/Tirisfal: Update questchains for Tirisfal Glades
Closes #29758
| -rw-r--r-- | sql/updates/world/master/2024_03_11_00_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_11_00_world.sql b/sql/updates/world/master/2024_03_11_00_world.sql new file mode 100644 index 00000000000..4bc2c67c3fa --- /dev/null +++ b/sql/updates/world/master/2024_03_11_00_world.sql @@ -0,0 +1,18 @@ +-- Tirisfal Glade Quests +DELETE FROM `quest_template_addon` WHERE `ID` IN (24982,24983,24988,24989,24990,24991,24993,24999,25003,25004,25029,25031,25038); +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 +(24982,0,0,0,0,0,0,24983,0,0,0,0,0,0,0,0,0,0,''), -- The New Forsaken +(24988,0,0,0,24983,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- The Chill of Death +(24989,0,0,0,24988,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Return to the Magistrate +(24990,0,0,0,24976,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Darkhound Pounding +(24991,0,0,0,24996,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Garren's Haunt +(24999,0,0,0,24994,25031,-24995,0,0,0,0,0,0,0,0,0,0,0,''), -- Planting the Seed of Fear +(25004,0,0,0,25003,25005,-25004,0,0,0,0,0,0,0,0,0,0,0,''), -- The Mills Overrun +(25029,0,0,0,25003,25005,-25004,0,0,0,0,0,0,0,0,0,0,0,''), -- Deaths in the Family +(25031,0,0,0,0,0,0,25003,0,0,0,0,0,0,0,0,0,0,''), -- Head for the Mills +(25038,0,0,0,24976,0,0,0,0,0,0,0,0,0,0,0,0,0,''); -- Gordo's Task +-- Have You Seen Anything Weird Out There? +UPDATE `quest_template_addon` SET `PrevQuestID`=25040 WHERE `ID`=25039; +-- Off the Scales ExclusiveGroup (Includes Planting the Seed of Fear) +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-24995 WHERE `ID`=24995; +UPDATE `quest_template_addon` SET `NextQuestID`=25031 WHERE `ID`=24995; |