From a8033420299d75bbcfd6efec610ec7f34f01bf75 Mon Sep 17 00:00:00 2001
From: sirikfoll <sirikfoll@hotmail.com>
Date: Mon, 25 Feb 2019 17:50:24 -0300
Subject: Scripts/Ulduar: Mimiron improvements

Closes #23043

Fix Aerial hover
Some visual issues
---
 sql/updates/world/3.3.5/2019_02_25_00_world.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2019_02_25_00_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/3.3.5/2019_02_25_00_world.sql b/sql/updates/world/3.3.5/2019_02_25_00_world.sql
new file mode 100644
index 00000000000..b1c64ba3247
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_02_25_00_world.sql
@@ -0,0 +1,7 @@
+UPDATE creature_template SET `flags_extra`=512 WHERE entry IN(33670,34109);
+UPDATE `creature_template` SET `AIName`='PassiveAI' WHERE `entry`=34071;
+UPDATE `creature_template` SET `unit_flags`=33555200, `ScriptName`='npc_mimiron_magnetic_core' WHERE `entry`=34068;
+
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_mimiron_magnetic_core_summon';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(64444,'spell_mimiron_magnetic_core_summon');
-- 
cgit v1.2.3