diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 21:17:04 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-16 23:10:07 +0100 |
| commit | 094165dc9570e0bfd0287270c6de8c6cb3394ae0 (patch) | |
| tree | 695cd7c6e9f5f5a135f9c5910553ad11959149fd | |
| parent | 3efc2caf96af46d73dc042e3e9c2a29ecb35dd84 (diff) | |
DB/Loot: add conditions for items Draconic for Dummies (Chapter II) and Draconic for Dummies (Chapter III).
Those items aren't marked as "quest item" but are still tied to the quest The Only Prescription.
(cherry picked from commit a295a9f10adf5e0ff70bf7c81381aa3fd9978833)
| -rw-r--r-- | sql/updates/world/master/2021_12_16_19_world_2019_07_20_02_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_19_world_2019_07_20_02_world.sql b/sql/updates/world/master/2021_12_16_19_world_2019_07_20_02_world.sql new file mode 100644 index 00000000000..bb49309917f --- /dev/null +++ b/sql/updates/world/master/2021_12_16_19_world_2019_07_20_02_world.sql @@ -0,0 +1,7 @@ +DELETE FROM `conditions` WHERE `SourceEntry` IN (21104, 21105) AND `SourceTypeOrReferenceId`=1; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(1, 8716, 21104, 0, 0, 9, 0, 8620, 0, 0, 0, 0, 0, "", "Item Draconic for Dummies (Chapter II) can be looted if quest 'The Only Prescription' is taken"), +(1, 8717, 21104, 0, 0, 9, 0, 8620, 0, 0, 0, 0, 0, "", "Item Draconic for Dummies (Chapter II) can be looted if quest 'The Only Prescription' is taken"), +(1, 12396, 21104, 0, 0, 9, 0, 8620, 0, 0, 0, 0, 0, "", "Item Draconic for Dummies (Chapter II) can be looted if quest 'The Only Prescription' is taken"), +(1, 7461, 21105, 0, 0, 9, 0, 8620, 0, 0, 0, 0, 0, "", "Item Draconic for Dummies (Chapter III) can be looted if quest 'The Only Prescription' is taken"), +(1, 7463, 21105, 0, 0, 9, 0, 8620, 0, 0, 0, 0, 0, "", "Item Draconic for Dummies (Chapter III) can be looted if quest 'The Only Prescription' is taken"); |