diff options
| author | Keader <keader.android@gmail.com> | 2017-10-26 23:10:00 -0300 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-21 22:30:40 +0100 |
| commit | 8a6fdb7a21d43bb61bd27ce7cd57663e957e6689 (patch) | |
| tree | 7f42cec97825abbc4ac880f831d927ac4b07416d /sql/updates | |
| parent | b17a23635d5e1d36cc4f51866e85d11d9442ccbf (diff) | |
Scripts/BlackTemple: Updates on Illidan encounter
- Fixed issues related with Parasitic Shadowfiend
- Updated script to new model
- Fixed loop of Parasitic Shadowfiend Summon
- Added a new spell (SPELL_REMOVE_PARASITIC_SHADOWFIEND)
- Fixed illidari elite attacking players
- SPELL_PARASITIC_SHADOWFIEND now is a negative aura
(cherry picked from commit 90f07bd948546595a04d7633eaa95a463f0ce6f9)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2021_01_15_01_world_2017_10_27_00_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_15_01_world_2017_10_27_00_world.sql b/sql/updates/world/master/2021_01_15_01_world_2017_10_27_00_world.sql new file mode 100644 index 00000000000..90558be747a --- /dev/null +++ b/sql/updates/world/master/2021_01_15_01_world_2017_10_27_00_world.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `ScriptName`='npc_illidari_elite' WHERE `entry`=23226; + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_illidan_remove_parasitic_shadowfiend'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(41923,'spell_illidan_remove_parasitic_shadowfiend'); + +DELETE FROM `spell_dbc` WHERE `Id`=41923; +INSERT INTO `spell_dbc` (`Id`, `Attributes`, `AttributesEx`, `AttributesEx2`, `AttributesEx3`, `AttributesEx4`, `AttributesEx5`, `AttributesEx6`, `AttributesEx7`, `AttributesEx8`, `AttributesEx9`, `AttributesEx10`, `CastingTimeIndex`, `DurationIndex`, `RangeIndex`, `SchoolMask`, `SpellAuraOptionsId`, `SpellCastingRequirementsId`, `SpellCategoriesId`, `SpellClassOptionsId`, `SpellEquippedItemsId`, `SpellLevelsId`, `SpellTargetRestrictionsId`, `SpellInterruptsId`, `Comment`) VALUES +(41923, 536871296, 268435592, 4, 256, 0, 8, 0, 0, 0, 0, 0, 1, 27, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Remove Parasitic Shadowfiends'); + +DELETE FROM `spelleffect_dbc` WHERE `Id`=155918; +INSERT INTO `spelleffect_dbc` (`Id`, `Effect`, `EffectValueMultiplier`, `EffectApplyAuraName`, `EffectAmplitude`, `EffectBasePoints`, `EffectBonusMultiplier`, `EffectDamageMultiplier`, `EffectChainTarget`, `EffectDieSides`, `EffectItemType`, `EffectMechanic`, `EffectMiscValue`, `EffectMiscValueB`, `EffectRadiusIndex`, `EffectRadiusIndexMax`, `EffectRealPointsPerLevel`, `EffectSpellClassMaskA`, `EffectSpellClassMaskB`, `EffectSpellClassMaskC`, `EffectTriggerSpell`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectSpellId`, `EffectIndex`) VALUES +(155918, 6, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 15, 41923, 0); |