diff options
| author | Kitzunu <Kitzunu@users.noreply.github.com> | 2020-03-07 15:31:30 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-03-07 15:31:30 +0100 |
| commit | 974ede899c40391d5101cf3dd67ba9dc8adebcc3 (patch) | |
| tree | f36391d26810ce31cb800bb382abdf2bbd9fefa4 | |
| parent | b4bb3f9b8bdf00485388de0485a7d9658869f448 (diff) | |
DB/Quest: Teron Gorefiend quest chaining
Closes #23852
| -rw-r--r-- | sql/updates/world/3.3.5/2020_03_07_02_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_03_07_02_world.sql b/sql/updates/world/3.3.5/2020_03_07_02_world.sql new file mode 100644 index 00000000000..3a843688b24 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_03_07_02_world.sql @@ -0,0 +1,19 @@ +-- +UPDATE `quest_template_addon` SET `NextQuestID` = 0 WHERE `id` IN (10644,10633); +UPDATE `quest_template_addon` SET `PrevQuestID` = 0 WHERE `id` IN (10639,10645); +UPDATE `quest_template_addon` SET `PrevQuestID` = 0, `ExclusiveGroup` = 0 WHERE `id` IN (10634,10635,10636); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 19 AND `SourceEntry` IN (10634, 10635, 10636, 10645, 10639); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 10634, 0, 0, 8, 0, 10644, 0, 0, 0, 0, 0, '', 'Quest 10634 available if Quest 10644 OR'), +(19, 0, 10634, 0, 1, 8, 0, 10633, 0, 0, 0, 0, 0, '', 'Quest 10634 available if Quest 10633 Rewarded'), +(19, 0, 10635, 0, 0, 8, 0, 10644, 0, 0, 0, 0, 0, '', 'Quest 10635 available if Quest 10644 OR'), +(19, 0, 10635, 0, 1, 8, 0, 10633, 0, 0, 0, 0, 0, '', 'Quest 10635 available if Quest 10633 Rewarded'), +(19, 0, 10636, 0, 0, 8, 0, 10644, 0, 0, 0, 0, 0, '', 'Quest 10636 available if Quest 10644 OR'), +(19, 0, 10636, 0, 1, 8, 0, 10633, 0, 0, 0, 0, 0, '', 'Quest 10636 available if Quest 10633 Rewarded'), +(19, 0, 10645, 0, 1, 8, 0, 10634, 0, 0, 0, 0, 0, '', 'Quest 10645 available if Quest 10634 AND'), +(19, 0, 10645, 0, 1, 8, 0, 10635, 0, 0, 0, 0, 0, '', 'Quest 10645 available if Quest 10633 AND'), +(19, 0, 10645, 0, 1, 8, 0, 10636, 0, 0, 0, 0, 0, '', 'Quest 10645 available if Quest 10636 Rewarded'), +(19, 0, 10639, 0, 1, 8, 0, 10634, 0, 0, 0, 0, 0, '', 'Quest 10639 available if Quest 10634 AND'), +(19, 0, 10639, 0, 1, 8, 0, 10635, 0, 0, 0, 0, 0, '', 'Quest 10639 available if Quest 10633 AND'), +(19, 0, 10639, 0, 1, 8, 0, 10636, 0, 0, 0, 0, 0, '', 'Quest 10639 available if Quest 10636 Rewarded'); |