aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorsirikfoll <sirikfoll@hotmail.com>2019-02-25 17:50:24 -0300
committersirikfoll <sirikfoll@hotmail.com>2019-02-25 17:50:24 -0300
commita8033420299d75bbcfd6efec610ec7f34f01bf75 (patch)
tree3ccd6e28765f1f1c7fd27b58357747661115372f /sql
parentc2f2db08aa4f729fbd5b21528a215f6df0c131b6 (diff)
Scripts/Ulduar: Mimiron improvements
Closes #23043 Fix Aerial hover Some visual issues
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2019_02_25_00_world.sql7
1 files changed, 7 insertions, 0 deletions
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');