diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 23:26:52 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-16 23:28:55 +0100 |
| commit | c597bf8f70daa92914b3bef957505b8097e324dd (patch) | |
| tree | 1b9b71992e7ba8fc46d074724845f2c701eed3a9 | |
| parent | a290f49fcebc1c89afd2add289aac41b805f421c (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!
(cherry picked from commit 1d1c551e4c82399ab1cf7511a7b6992721f1bd6c)
| -rw-r--r-- | sql/updates/world/master/2021_12_16_22_world_2019_07_20_08_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_22_world_2019_07_20_08_world.sql b/sql/updates/world/master/2021_12_16_22_world_2019_07_20_08_world.sql new file mode 100644 index 00000000000..12d5eb97aa3 --- /dev/null +++ b/sql/updates/world/master/2021_12_16_22_world_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"); |