diff options
| author | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 21:17:04 +0200 |
|---|---|---|
| committer | Wyrserth <wyrserth@protonmail.com> | 2019-07-20 21:17:04 +0200 |
| commit | a295a9f10adf5e0ff70bf7c81381aa3fd9978833 (patch) | |
| tree | 5aab4e8b966c5d23cbbc3842c92c4755b9bc292b | |
| parent | b8d86bba999684998da59f4765d7982cba30ec21 (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.
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_20_02_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_20_02_world.sql b/sql/updates/world/3.3.5/2019_07_20_02_world.sql new file mode 100644 index 00000000000..bb49309917f --- /dev/null +++ b/sql/updates/world/3.3.5/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"); |