diff options
| author | Rynem <rynem@users.noreply.github.com> | 2019-07-01 02:17:13 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-13 00:42:19 +0100 |
| commit | ed85a1b7011f28a49708f92510f1708b5bff23df (patch) | |
| tree | b3b393de17e4738a984e820ece957a36b5b60b5e | |
| parent | ecce30a8072fd9352edae378a182f6bf6619d412 (diff) | |
DB/Quest: fix chaining for quests offered by Lantresor of the Blade.
Closes #22440.
(cherry picked from commit 72917d5036be071a7243c1faa602dd1ad17543ba)
| -rw-r--r-- | sql/updates/world/master/2021_12_12_24_world_2019_07_01_03_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_12_24_world_2019_07_01_03_world.sql b/sql/updates/world/master/2021_12_12_24_world_2019_07_01_03_world.sql new file mode 100644 index 00000000000..c511052085f --- /dev/null +++ b/sql/updates/world/master/2021_12_12_24_world_2019_07_01_03_world.sql @@ -0,0 +1,19 @@ +-- +UPDATE `quest_template_addon` SET `PrevQuestID`=0, `ExclusiveGroup`=0 WHERE `ID` IN (9927, 9928, 9931, 9932); +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=9934; +UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE `ID` IN (10107, 10108); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (9927, 9928, 9931, 9932, 9933, 9934); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 9927, 0, 0, 8, 0, 10107, 0, 0, 0, 0, 0, "", "Quest Ruthless Cunning requires quest Diplomatic Measures (Horde) rewarded OR"), +(19, 0, 9927, 0, 1, 8, 0, 10108, 0, 0, 0, 0, 0, "", "Quest Ruthless Cunning requires quest Diplomatic Measures (Alliance) rewarded"), +(19, 0, 9928, 0, 0, 8, 0, 10107, 0, 0, 0, 0, 0, "", "Quest Armaments for Deception requires quest Diplomatic Measures (Horde) rewarded OR"), +(19, 0, 9928, 0, 1, 8, 0, 10108, 0, 0, 0, 0, 0, "", "Quest Armaments for Deception requires quest Diplomatic Measures (Alliance) rewarded"), +(19, 0, 9931, 0, 0, 8, 0, 9927, 0, 0, 0, 0, 0, "", "Quest Returning the Favor requires quest Ruthless Cunning rewarded AND"), +(19, 0, 9931, 0, 0, 8, 0, 9928, 0, 0, 0, 0, 0, "", "Quest Returning the Favor requires quest Armaments for Deception rewarded"), +(19, 0, 9932, 0, 0, 8, 0, 9927, 0, 0, 0, 0, 0, "", "Quest Body of Evidence requires quest Ruthless Cunning rewarded AND"), +(19, 0, 9932, 0, 0, 8, 0, 9928, 0, 0, 0, 0, 0, "", "Quest Body of Evidence requires quest Armaments for Deception rewarded"), +(19, 0, 9933, 0, 0, 8, 0, 9931, 0, 0, 0, 0, 0, "", "Quest Message to Telaar requires quest Returning the Favor rewarded AND"), +(19, 0, 9933, 0, 0, 8, 0, 9932, 0, 0, 0, 0, 0, "", "Quest Message to Telaar requires quest Body of Evidence rewarded"), +(19, 0, 9934, 0, 0, 8, 0, 9931, 0, 0, 0, 0, 0, "", "Quest Message to Garadar requires quest Returning the Favor rewarded AND"), +(19, 0, 9934, 0, 0, 8, 0, 9932, 0, 0, 0, 0, 0, "", "Quest Message to Garadar requires quest Body of Evidence rewarded"); |