From f34ee9b737323762ab9d9165f52f032ef4a2cebf Mon Sep 17 00:00:00 2001 From: Gustavo Date: Mon, 16 Oct 2017 23:32:30 -0200 Subject: Core/Scripts: Update boss Toravon the Ice Watcher (#20395) * Core/Scripts: Update boss Toravon the Ice Watcher Frozen Orbs: Fixed summon delay, removed old hack, aggro behavior implemented(every 10sec they reset threat and change target) Remove no longer needed script for the orb stalker All timers adjusted Update instance model Update script register model Fix Frostbite proc (cherry picked from commit 5a90251ea28bb9b0be376d7b6110b4e93458cbea) --- .../2021_01_05_03_world_2017_10_16_03_world.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/master/2021_01_05_03_world_2017_10_16_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2021_01_05_03_world_2017_10_16_03_world.sql b/sql/updates/world/master/2021_01_05_03_world_2017_10_16_03_world.sql new file mode 100644 index 00000000000..fd11549221e --- /dev/null +++ b/sql/updates/world/master/2021_01_05_03_world_2017_10_16_03_world.sql @@ -0,0 +1,19 @@ +-- Update boss Toravon the Ice Watcher +UPDATE `creature_template` SET `InhabitType`=11, `ScriptName`='' WHERE `entry`=38461; +-- UPDATE `spell_dbc` SET `Effect1`=3, `EffectImplicitTargetA1`=22, `EffectImplicitTargetB1`=15, `EffectRadiusIndex1`=28, `MaxAffectedTargets`=1 WHERE `Id`=46523; +DELETE FROM `spelleffect_dbc` WHERE `Id`=155917; +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 +(155917, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, 0, 0, 0, 0, 22, 15, 46523, 0); +UPDATE `spell_dbc` SET `SpellTargetRestrictionsId`=872 WHERE `Id`=46523; + +DELETE FROM `creature_template_addon` WHERE `entry`=38461; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(38461,0,0,0,1,0,72094); + +DELETE FROM `spell_proc` WHERE `SpellId`=71993; +INSERT INTO `spell_proc` (`SpellId`,`ProcFlags`,`HitMask`,`Cooldown`) VALUES +(71993,4,12287,4000); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_toravon_random_aggro'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(46523,'spell_toravon_random_aggro'); -- cgit v1.2.3