diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-02-26 01:44:20 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-02-26 01:44:22 +0100 |
| commit | 91939f343eafec9112c9b798e256dbc0386deddf (patch) | |
| tree | 949bf5a47d170424e81cc7b59f98fcdb82ab52d9 | |
| parent | 3c466f4ce7dc9a74387a2834446150bb7f9a9c69 (diff) | |
DB/Mulgore: Update questchains for Mulgore
Closes #29742
| -rw-r--r-- | sql/updates/world/master/2024_02_26_09_world.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_26_09_world.sql b/sql/updates/world/master/2024_02_26_09_world.sql new file mode 100644 index 00000000000..56933045279 --- /dev/null +++ b/sql/updates/world/master/2024_02_26_09_world.sql @@ -0,0 +1,18 @@ +-- Mulgore Quests +DELETE FROM `quest_template_addon` WHERE `ID` IN (749,773,14438,26179,26180); +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 +(773,0,0,0,20441,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Rite of Wisdom +(26179,0,0,0,751,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- The Venture Company +(26180,0,0,0,751,0,0,0,0,0,0,0,0,0,0,0,0,0,''); -- Supervisor Fizsprocket +-- Unneeded NextQuestIDs +UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE `ID` IN (6361,6362,6363,20441,24440,24441,24456,24457,24459,24523,24524,24550); +-- Winterhoof Cleansing +UPDATE `quest_template_addon` SET `PrevQuestID`=20440 WHERE `ID`=24440; +-- Morin Cloudstalker +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=749 WHERE `ID`=24459; +-- Wildmane Totem +UPDATE `quest_template_addon` SET `PrevQuestID`=24456 WHERE `ID`=24523; +-- Journey Into Thunder Bluff +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=24540 WHERE `ID`=24550; +-- War Dance +UPDATE `quest_template_addon` SET `PrevQuestID`=24524 WHERE `ID`=24540; |