diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-03-11 01:34:50 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2024-03-25 20:15:42 +0100 |
| commit | 6d16f5a1ec4138e30925765f283e598ff47c68a5 (patch) | |
| tree | 7d69ee6f298ab42e4a57ab4341eaecb279adcdb8 /sql | |
| parent | 97df861c52c21d032ba65a1702b71eb3bdd975f7 (diff) | |
DB/Tirisfal: Update questchains for Tirisfal Glades
Closes #29758
(cherry picked from commit f317baf4f443f9deb7363ae499c2e2eab12d0353)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2024_03_25_00_world_2024_03_11_00_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_03_25_00_world_2024_03_11_00_world.sql b/sql/updates/world/cata_classic/2024_03_25_00_world_2024_03_11_00_world.sql new file mode 100644 index 00000000000..4bc2c67c3fa --- /dev/null +++ b/sql/updates/world/cata_classic/2024_03_25_00_world_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; |