diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-07-16 00:00:47 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-16 00:00:47 +0200 |
| commit | c8e9184a4b1404c38e38b1734fc91afd6d9cbd0c (patch) | |
| tree | 166c65ad66533a6996cef88f616ecd78ee59e0cb | |
| parent | 23e89b8aef1999bbbd52248c40d7b76c0a67cafb (diff) | |
DB/Conditions: fix cast conditions for two more spells
| -rw-r--r-- | sql/updates/world/3.3.5/2016_07_16_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_16_00_world.sql b/sql/updates/world/3.3.5/2016_07_16_00_world.sql new file mode 100644 index 00000000000..0dd86f346e9 --- /dev/null +++ b/sql/updates/world/3.3.5/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'"); |