aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorGustavo <sirikfoll@hotmail.com>2017-03-24 08:59:04 -0300
committerfunjoker <funjoker109@gmail.com>2020-04-24 17:18:49 +0200
commit6f523b4fb65331acca28b5ac00f14551427d038d (patch)
tree3be66fb9bf76279147e1d4ba111a937a1b0e3aea /sql/updates
parent7a561ad045f7003aad6ff678c34ad4aafffea79d (diff)
Core/Scripts: minor fixes in boss_the_lich_king (#19311)
Closes #4427 Closes #7091 (cherry picked from commit 2792046dc7a229180d27dfdc4ce37ccfb84c8a27)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2020_04_16_00_world_2017_03_24_00_world.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_04_16_00_world_2017_03_24_00_world.sql b/sql/updates/world/master/2020_04_16_00_world_2017_03_24_00_world.sql
new file mode 100644
index 00000000000..84277ee86c2
--- /dev/null
+++ b/sql/updates/world/master/2020_04_16_00_world_2017_03_24_00_world.sql
@@ -0,0 +1,14 @@
+-- Correct speed for Wicked Spirits and Spirit Bombs
+UPDATE `creature_template` SET `speed_walk`=1.2, `speed_run`=0.428571 WHERE `entry` IN(39189,39190,39287,39288,39289);
+UPDATE `creature_template` SET `InhabitType`=4, `HoverHeight`=4 WHERE `entry` IN(36609,39120,39121,39122);
+
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_the_lich_king_harvest_souls_teleport';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(73655,'spell_the_lich_king_harvest_souls_teleport');
+
+DELETE FROM `spell_custom_attr` WHERE `entry` IN(69409,73797,73798,73799);
+INSERT INTO `spell_custom_attr` (`entry`,`attributes`) VALUES
+(69409,32768),
+(73797,32768),
+(73798,32768),
+(73799,32768);