From 5a90251ea28bb9b0be376d7b6110b4e93458cbea 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 --- sql/updates/world/3.3.5/2017_10_16_03_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_10_16_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2017_10_16_03_world.sql b/sql/updates/world/3.3.5/2017_10_16_03_world.sql new file mode 100644 index 00000000000..53105c9f425 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_16_03_world.sql @@ -0,0 +1,15 @@ +-- 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 `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