diff options
| author | SnapperRy <snapperryen@gmail.com> | 2016-10-11 11:14:11 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-09-05 19:27:21 +0200 |
| commit | 013067edef43d3d098a6957a2a94334744522ee4 (patch) | |
| tree | 2cf57e7ac2b54a41b8e0e16b3b827442e306a7be | |
| parent | 63b25518705697b6e0cc5a02752edc365dcde801 (diff) | |
DB/Conditions: spells Plagued Blood Explosion and Arcane Charges can only hit certain mobs.
(cherry picked from commit 407983f3a372697c497c29b47029c1e9ae3af090)
| -rw-r--r-- | sql/updates/world/master/2017_09_05_14_world_2016_10_11_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_09_05_14_world_2016_10_11_00_world.sql b/sql/updates/world/master/2017_09_05_14_world_2016_10_11_00_world.sql new file mode 100644 index 00000000000..1804b59eb7d --- /dev/null +++ b/sql/updates/world/master/2017_09_05_14_world_2016_10_11_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (42166, 45072); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 42166, 0, 0, 31, 0, 3, 24198, 0, 0, 0, 0, "", "Spell 'Plagued Blood Explosion' EFFECT_0 can only hit 'Plagued Dragonflayer Runecaster' OR"), +(13, 1, 42166, 0, 1, 31, 0, 3, 24199, 0, 0, 0, 0, "", "Spell 'Plagued Blood Explosion' EFFECT_0 can only hit 'Plagued Dragonflayer Handler' OR"), +(13, 1, 42166, 0, 2, 31, 0, 3, 23564, 0, 0, 0, 0, "", "Spell 'Plagued Blood Explosion' EFFECT_0 can only hit 'Plagued Dragonflayer Tribesman'"), +(13, 1, 45072, 0, 0, 31, 0, 3, 25031, 0, 0, 0, 0, "", "Spell 'Arcane Charges' EFFECT_0 can only hit 'Pit Overlord' OR"), +(13, 1, 45072, 0, 1, 31, 0, 3, 25033, 0, 0, 0, 0, "", "Spell 'Arcane Charges' EFFECT_0 can only hit 'Eredar Sorcerer' OR"), +(13, 1, 45072, 0, 2, 31, 0, 3, 25158, 0, 0, 0, 0, "", "Spell 'Arcane Charges' EFFECT_0 can only hit 'Brutallus' OR"), +(13, 1, 45072, 0, 3, 31, 0, 3, 25030, 0, 0, 0, 0, "", "Spell 'Arcane Charges' EFFECT_0 can only hit 'Wrath Enforcer'"); |