diff options
| author | dr-j <dr-j@users.noreply.github.com> | 2020-04-15 14:59:35 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-01 15:52:18 +0100 |
| commit | 3704243f9b71764e4fea2f133bf73c0bd16fd5c4 (patch) | |
| tree | 8754942b234ad2222f3c25dadaee2fe12ad6635f /sql | |
| parent | 0484c0a33708c6e22edc967440f6b74ccc789763 (diff) | |
DB/Quest: Vereth the Cunning quest chaining
Closes #24452
(cherry picked from commit 80803039c2cb5f418d2563d23154140f331b9b1d)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_01_18_world_2020_04_15_01_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_18_world_2020_04_15_01_world.sql b/sql/updates/world/master/2022_01_01_18_world_2020_04_15_01_world.sql new file mode 100644 index 00000000000..e8dc4a81634 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_18_world_2020_04_15_01_world.sql @@ -0,0 +1,19 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceGroup`=0 AND `SourceEntry` IN(13147,13160,13146,13161,13162,13163,13164); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 13161, 0, 0, 8, 0, 13146, 0, 0, 0, 0, 0, '', 'Accepting The Rider of the Unholy requires Generosity Abounds to be rewarded'), +(19, 0, 13161, 0, 0, 8, 0, 13160, 0, 0, 0, 0, 0, '', 'Accepting The Rider of the Unholy requires Stunning View to be rewarded'), +(19, 0, 13161, 0, 0, 8, 0, 13147, 0, 0, 0, 0, 0, '', 'Accepting The Rider of the Unholy requires Matchmaker to be rewarded'), +(19, 0, 13162, 0, 0, 8, 0, 13146, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Frost requires Generosity Abounds to be rewarded'), +(19, 0, 13162, 0, 0, 8, 0, 13160, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Frost requires Stunning View to be rewarded'), +(19, 0, 13162, 0, 0, 8, 0, 13147, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Frost requires Matchmaker to be rewarded'), +(19, 0, 13163, 0, 0, 8, 0, 13146, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Blood requires Generosity Abounds to be rewarded'), +(19, 0, 13163, 0, 0, 8, 0, 13160, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Blood requires Stunning View to be rewarded'), +(19, 0, 13163, 0, 0, 8, 0, 13147, 0, 0, 0, 0, 0, '', 'Accepting The Rider of Blood requires Matchmaker to be rewarded'); + +UPDATE `quest_template_addon` SET `ExclusiveGroup`=-13146,`NextQuestID`=13161 WHERE `ID` IN(13146,13147,13160); +UPDATE `quest_template_addon` SET `PrevQuestID`=13146,`ExclusiveGroup`=-13161 WHERE `ID` IN(13161,13162,13163); + +DELETE FROM `quest_template_addon` WHERE `ID`=13164; +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) VALUES +(13164, 0, 0, 0, 13161, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); |