diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-12-26 13:36:52 +0000 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2016-01-17 13:54:11 +0100 |
| commit | c5d4ea006b099a7af15ccdb6e372d59f936571ed (patch) | |
| tree | 659d9f7194d64f934d686c6a73d18c7cba87a20f | |
| parent | 80ffb62c488545392d57dfac8434073cd41b0b2b (diff) | |
DB/Conditions: Judgment Day Comes!
This optional breadcrumb quest should not be takable if player has already started quest chain it leads to.
(cherry picked from commit 315123f8738e837ef98e22db83438396c638e251)
| -rw-r--r-- | sql/updates/world/2016_01_17_01_world_2015_12_26_00.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2016_01_17_01_world_2015_12_26_00.sql b/sql/updates/world/2016_01_17_01_world_2015_12_26_00.sql new file mode 100644 index 00000000000..02c0acbedae --- /dev/null +++ b/sql/updates/world/2016_01_17_01_world_2015_12_26_00.sql @@ -0,0 +1,16 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN(19,20) AND `SourceEntry` IN(13226,13227); + +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(19, 0, 13226, 0, 0, 8, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not rewarded'), +(19, 0, 13226, 0, 0, 9, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not taken'), +(19, 0, 13226, 0, 0, 28, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not completed'), +(20, 0, 13226, 0, 0, 8, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not rewarded'), +(20, 0, 13226, 0, 0, 9, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not taken'), +(20, 0, 13226, 0, 0, 28, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (A) Can only be taken if Honor Above All Else is not completed'), + +(19, 0, 13227, 0, 0, 8, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not rewarded'), +(19, 0, 13227, 0, 0, 9, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not taken'), +(19, 0, 13227, 0, 0, 28, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not completed'), +(20, 0, 13227, 0, 0, 8, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not rewarded'), +(20, 0, 13227, 0, 0, 9, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not taken'), +(20, 0, 13227, 0, 0, 28, 0, 13036, 0, 0, 1, 0, 0, '', 'Judgment Day Comes! (H) Can only be taken if Honor Above All Else is not completed'); |