diff options
| author | Aussiewoolf <Aussiewoolf@users.noreply.github.com> | 2017-12-23 01:02:28 +0100 |
|---|---|---|
| committer | tkrokli <tkrokli@gmail.com> | 2017-12-23 01:06:56 +0100 |
| commit | 5296c0063e458e2e3371bed1ebcbec64857a52a6 (patch) | |
| tree | d47ee00d2993cc5e7a80feae0ee3cab333d0a48a | |
| parent | 45d3ecc15feb33d9d8562c22d2185346d90d96e9 (diff) | |
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
| -rw-r--r-- | sql/updates/world/master/2017_12_23_00_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
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); |