From 8a6fdb7a21d43bb61bd27ce7cd57663e957e6689 Mon Sep 17 00:00:00 2001 From: Keader Date: Thu, 26 Oct 2017 23:10:00 -0300 Subject: 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) --- .../master/2021_01_15_01_world_2017_10_27_00_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2021_01_15_01_world_2017_10_27_00_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3