From 5d2379a413b842c9fb3823ba6605cf240d107f44 Mon Sep 17 00:00:00 2001 From: Naddley Date: Sun, 28 Jan 2024 01:23:49 +0100 Subject: DB/Boralus: Implement Quest "Ferry Pass" + chain quests up to "A Nation Divided" --- sql/updates/world/master/2024_01_28_01_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2024_01_28_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_01_28_01_world.sql b/sql/updates/world/master/2024_01_28_01_world.sql new file mode 100644 index 00000000000..7e0a83fd34a --- /dev/null +++ b/sql/updates/world/master/2024_01_28_01_world.sql @@ -0,0 +1,17 @@ +-- Quest "Ferry Pass" ID: 52128 +DELETE FROM `creature_queststarter` WHERE (`id`=122370 AND `quest`=52128) OR (`id`=121235 AND `quest`=47186) OR (`id`=121235 AND `quest`=47189); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(122370, 52128, 53040), -- Ferry Pass offered by Cyrus Crestfall +(121235, 47186, 53040), -- Sanctum of the Sages offered by Taelia +(121235, 47189, 53040); -- A Nation Divided offered by Taelia + +DELETE FROM `creature_questender` WHERE (`id`=122370 AND `quest`=52128) OR (`id`=121235 AND `quest`=47186) OR (`id`=121235 AND `quest`=47189); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(122370, 52128, 53040), -- Ferry Pass ended by Cyrus Crestfall +(121235, 47186, 53040), -- Sanctum of the Sages ended by Taelia +(121235, 47189, 53040); -- A Nation Divided ended by Taelia + +DELETE FROM `quest_template_addon` WHERE `ID` IN (52128, 47186); +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 +(52128, 0, 0, 0, 46729, 47189, -52128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(47186, 0, 0, 0, 46729, 47189, -52128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); -- cgit v1.2.3