diff options
| author | Kelpiesklubhouse <151824209+Kelpiesklubhouse@users.noreply.github.com> | 2024-02-17 21:43:50 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2024-02-17 21:43:54 +0100 |
| commit | c5a4cd2133ef1a4c082473a0e131856b159e77c3 (patch) | |
| tree | 7916371c607f1e2b05a0f4015ad1a11f5c3f4059 | |
| parent | 3b3acf70d18f26f12edb50268cb63a4907efd0b6 (diff) | |
DB/Teldrassil: Update questchains for Teldrassil
Closes #29658
| -rw-r--r-- | sql/updates/world/master/2024_02_17_01_world.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_17_01_world.sql b/sql/updates/world/master/2024_02_17_01_world.sql new file mode 100644 index 00000000000..2aff2b2383d --- /dev/null +++ b/sql/updates/world/master/2024_02_17_01_world.sql @@ -0,0 +1,21 @@ +-- Teldrassil Quests +DELETE FROM `quest_template_addon` WHERE `ID` IN (487, 932, 937, 938, 2438, 2499, 13945); +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 +(487,0,0,0,483,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- The Road to Darnassus +(932,0,0,0,489,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Twisted Hatred +(2499,0,0,0,923,0,0,0,0,0,0,0,0,0,0,0,0,0,''), -- Oakenscowl +(13945,0,0,0,476,0,0,0,0,0,0,0,0,0,0,0,0,0,''); -- Resident Danger +-- Ursal the Mauler +UPDATE `quest_template_addon` SET `PrevQuestID`=483 WHERE `ID`=486; +-- Timberling Seeds +UPDATE `quest_template_addon` SET `PrevQuestID`=997 WHERE `ID`=918; +-- Teldrassil: The Refusal of the Aspects +UPDATE `quest_template_addon` SET `PrevQuestID`=28731 WHERE `ID`=929; +-- Denalan's Earth +UPDATE `quest_template_addon` SET `PrevQuestID`=486 WHERE `ID`=997; +-- Dolanaar Delivery +UPDATE `quest_template_addon` SET `SpecialFlags`=0 WHERE `ID`=2159; +-- Teldrassil: The Burden of the Kaldorei +UPDATE `quest_template_addon` SET `PrevQuestID`=918 WHERE `ID`=7383; +-- Nature's Reprisal +UPDATE `quest_template_addon` SET `PrevQuestID`=489 WHERE `ID`=13946; |