From 61ac98fce21120eee650feca94fa67066a5584ae Mon Sep 17 00:00:00 2001 From: SnapperRy Date: Sat, 16 Jul 2016 00:00:47 +0200 Subject: DB/Conditions: fix cast conditions for two more spells (cherry picked from commit c8e9184a4b1404c38e38b1734fc91afd6d9cbd0c) --- .../world/master/2017_02_05_26_world_2016_07_16_00_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2017_02_05_26_world_2016_07_16_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_02_05_26_world_2016_07_16_00_world.sql b/sql/updates/world/master/2017_02_05_26_world_2016_07_16_00_world.sql new file mode 100644 index 00000000000..0dd86f346e9 --- /dev/null +++ b/sql/updates/world/master/2017_02_05_26_world_2016_07_16_00_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (12699, 31225); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 31225, 0, 0, 29, 0, 17768, 10, 0, 0, 0, 0, "", "Spell 'Shimmering Vessel' (used for quest 'Redeeming the Dead') requires NPC 'Blood Knight Stillblade' to be within 10 yards"), +(17, 0, 12699, 0, 0, 36, 1, 0, 0, 0, 1, 0, 0, "", "Spell 'Summon Screecher Spirit' (used for quest 'Screecher Spirits') can only be used if target is dead AND"), +(17, 0, 12699, 0, 0, 31, 1, 3, 5307, 0, 0, 0, 0, "", "Spell 'Summon Screecher Spirit' (used for quest 'Screecher Spirits') can only be used if target is NPC 'Vale Screecher'"), +(17, 0, 12699, 0, 1, 36, 1, 0, 0, 0, 1, 0, 0, "", "Spell 'Summon Screecher Spirit' (used for quest 'Screecher Spirits') can only be used if target is dead AND"), +(17, 0, 12699, 0, 1, 31, 1, 3, 5308, 0, 0, 0, 0, "", "Spell 'Summon Screecher Spirit' (used for quest 'Screecher Spirits') can only be used if target is NPC 'Rogue Vale Screecher'"); -- cgit v1.2.3