aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorsirikfoll <sirikfoll@hotmail.com>2019-02-25 17:50:24 -0300
committerShauren <shauren.trinity@gmail.com>2021-11-24 00:02:13 +0100
commit402e63427e5ab005d148bec9d04b91f66fa7f285 (patch)
treee2ea420de460eb8081df227216b17fbf0bce7d13 /sql
parentb3f75852c284e730756a7f007b96bbae0ac3c158 (diff)
Scripts/Ulduar: Mimiron improvements
Closes #23043 Fix Aerial hover Some visual issues (cherry picked from commit a8033420299d75bbcfd6efec610ec7f34f01bf75)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_11_23_27_world_2019_02_25_00_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_23_27_world_2019_02_25_00_world.sql b/sql/updates/world/master/2021_11_23_27_world_2019_02_25_00_world.sql
new file mode 100644
index 00000000000..b1c64ba3247
--- /dev/null
+++ b/sql/updates/world/master/2021_11_23_27_world_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');