From a4a0deaab85e1738e4768ab7bfef787bb63b4a12 Mon Sep 17 00:00:00 2001 From: Naddley Date: Tue, 9 Jan 2024 01:10:45 +0100 Subject: DB/Draenor: Added some questchains for Alliance Garrison V1 --- sql/updates/world/master/2024_01_09_00_world.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/master/2024_01_09_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_01_09_00_world.sql b/sql/updates/world/master/2024_01_09_00_world.sql new file mode 100644 index 00000000000..b3b338be862 --- /dev/null +++ b/sql/updates/world/master/2024_01_09_00_world.sql @@ -0,0 +1,18 @@ +-- Quest Template Addon +DELETE FROM `quest_template_addon` WHERE `ID` IN (35176, 35174, 35166, 34646, 34692, 36624, 34778, 33075); +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 +(35176, 0, 0, 0, 34586, 34587, -35176, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Keeping it Together +(35174, 0, 0, 0, 34586, 34587, -35176, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Pale Moonlight +(35166, 0, 0, 0, 34586, 34587, -35176, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Ship Salvage +(34646, 0, 0, 0, 34587, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Qiana Moonshadow +(34692, 0, 0, 0, 34646, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Delegating on Draenor +(36624, 0, 0, 0, 34692, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Ashran Appearence +(34778, 0, 0, 0, 34692, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Migrant Workers +(33075, 0, 0, 0, 34692, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); -- A Heroes Welcome + +-- Sidequests +DELETE FROM `quest_template_addon` WHERE `ID` IN (35343, 36310, 36262); +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 +(35343, 0, 0, 0, 35342, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- The Young Alchemist +(36310, 0, 0, 0, 36308, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- The Arakkoan Enchanter +(36262, 0, 0, 0, 36236, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); -- Amekka, Master Tailor -- cgit v1.2.3