From a295a9f10adf5e0ff70bf7c81381aa3fd9978833 Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Sat, 20 Jul 2019 21:17:04 +0200 Subject: 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. --- sql/updates/world/3.3.5/2019_07_20_02_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_07_20_02_world.sql (limited to 'sql') 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"); -- cgit v1.2.3