diff options
| author | ZenoX92 <ZenoX92@users.noreply.github.com> | 2018-08-11 16:22:21 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-10-17 22:55:04 +0200 |
| commit | 80437236afeb5d56fcc1cddd5509b216b346d940 (patch) | |
| tree | 80e2ee576a9272e80ef57a986c152a605c6342fa | |
| parent | 7dd7937d6f3ce9008a462315ac99a836912d06d0 (diff) | |
DB/Quest: "Shady Rest Inn" Quest Chain (Horde)
Closes #22222
(cherry picked from commit c83c90cb5274f7a290a1157320dc972031afeb85)
| -rw-r--r-- | sql/updates/world/master/2021_10_17_22_world_2018_08_11_05_world_335.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_10_17_22_world_2018_08_11_05_world_335.sql b/sql/updates/world/master/2021_10_17_22_world_2018_08_11_05_world_335.sql new file mode 100644 index 00000000000..2288df87ca2 --- /dev/null +++ b/sql/updates/world/master/2021_10_17_22_world_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" |