1 files changed, 19 insertions, 0 deletions
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');