diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 23:26:52 +0200 |
|---|---|---|
| committer | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 23:26:52 +0200 |
| commit | 1d1c551e4c82399ab1cf7511a7b6992721f1bd6c (patch) | |
| tree | 49fbc229be1a26a8beca411d8ac3f9b96b7be4d5 | |
| parent | 94c936844c76a28ad928b108f9b15ed455d4aef6 (diff) | |
DB/Conditions: players can re-obtain the item Torch of Retribution from the questgiver only if they haven't already turned in the quest Set Them Ablaze!
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_20_08_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_20_08_world.sql b/sql/updates/world/3.3.5/2019_07_20_08_world.sql new file mode 100644 index 00000000000..12d5eb97aa3 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_20_08_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=1323 AND `SourceEntry`=2; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 1323, 2, 0, 0, 8, 0, 3454, 0, 0, 0, 0, 0, "", "Show gossip option if player has quest 3454 rewarded AND"), +(15, 1323, 2, 0, 0, 8, 0, 3463, 0, 0, 1, 0, 0, "", "Show gossip option if player has quest 3463 NOT rewarded AND"), +(15, 1323, 2, 0, 0, 2, 0, 10515, 1, 1, 1, 0, 0, "", "Show gossip option if player does not have item 10515"); |