diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-08-11 16:22:21 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-08-11 16:22:21 +0200 |
| commit | c83c90cb5274f7a290a1157320dc972031afeb85 (patch) | |
| tree | 551245de34c15ff8706a34bf64aa5472e0d0d3fd | |
| parent | b8fba664fcdae874206fef557a015648e1b97d8a (diff) | |
DB/Quest: "Shady Rest Inn" Quest Chain (Horde)
Closes #22222
| -rw-r--r-- | sql/updates/world/3.3.5/2018_08_11_05_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_08_11_05_world_335.sql b/sql/updates/world/3.3.5/2018_08_11_05_world_335.sql new file mode 100644 index 00000000000..2288df87ca2 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_08_11_05_world_335.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `quest_template_addon` WHERE `ID`=1268; +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES +(1268,0,0,0,0,1276,-1323,0,0,0,0,0,0,0,0,0,0); -- Quest "Suspicious Hoofprints" + +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-1323, `NextQuestID`=1276 WHERE `ID` IN (1323,1273); -- Quests "The Black Shield (Part 4)" / "Questioning Reethe" +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=1276; -- Quest "The Black Shield (Part 5)" +UPDATE `quest_template_addon` SET `PrevQuestID`=1276 WHERE `ID`=11204; -- Quest "Return to Krog" +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-11201, `NextQuestID`=11203 WHERE `ID` IN (11201,11200); -- Quests "The Grimtotem Plot" / "More than Coincidence" +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=11203; -- Quest "Seek Out Tabetha" |