From 5296c0063e458e2e3371bed1ebcbec64857a52a6 Mon Sep 17 00:00:00 2001 From: Aussiewoolf Date: Sat, 23 Dec 2017 01:02:28 +0100 Subject: DB/Quest: Have You Seen Anything Weird Out There? - add missing quest_offer_reward texts - add missing quest_template_addon entries - link quest 24993 as reward from 25039 Closes #21072 --- sql/updates/world/master/2017_12_23_00_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/master/2017_12_23_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_12_23_00_world.sql b/sql/updates/world/master/2017_12_23_00_world.sql new file mode 100644 index 00000000000..d059792ac30 --- /dev/null +++ b/sql/updates/world/master/2017_12_23_00_world.sql @@ -0,0 +1,15 @@ +-- Quest 25039: Have You Seen Anything Weird Out There? +UPDATE `quest_template` SET `RewardNextQuest`=24993, WHERE `ID`=25039; + +-- add ExclusiveGroup 24992 - only one of the quests must be available +DELETE FROM `quest_template_addon` WHERE `ID` IN (24992,25039); +INSERT INTO `quest_template_addon` (`ID`,`MaxLevel`,`AllowableClasses`,`SourceSpellID`,`PrevQuestID`,`NextQuestID`,`ExclusiveGroup`,`RewardMailTemplateID`,`RewardMailDelay`,`RequiredSkillID`,`RequiredSkillPoints`,`RequiredMinRepFaction`,`RequiredMaxRepFaction`,`RequiredMinRepValue`,`RequiredMaxRepValue`,`ProvidedItemCount`,`SpecialFlags`,`ScriptName`) VALUES +(24992, 0, 0, 0, 0, 24993, 24992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(25039, 0, 0, 0, 0, 24993, 24992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +-- add missing quest_offer_reward entries for 24992/24993/25039 +DELETE FROM `quest_offer_reward` WHERE `ID` IN (24992,25039,24993); +INSERT INTO `quest_offer_reward` (`ID`,`Emote1`,`Emote2`,`Emote3`,`Emote4`,`EmoteDelay1`,`EmoteDelay2`,`EmoteDelay3`,`EmoteDelay4`,`RewardText`,`VerifiedBuild`) VALUES +(24992, 0, 0, 0, 0, 0, 0, 0, 0, 'Hmm... yes, that makes sense. Since the worgen have come streaming out of Gilneas, I knew it would only be a matter of time before they arrived here in Tirisfal.', 0), +(25039, 0, 0, 0, 0, 0, 0, 0, 0, 'Hmm... yes, that makes sense. Since the worgen have come streaming out of Gilneas, I knew it would only be a matter of time before they arrived here in Tirisfal.', 0), +(24993, 0, 0, 0, 0, 0, 0, 0, 0, "To think, they've been right under our noses! I'll put my deathguards on alert... this will NOT happen again.", 0); -- cgit v1.2.3