aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorGustavo <sirikfoll@hotmail.com>2017-02-10 00:01:39 -0200
committerShauren <shauren.trinity@gmail.com>2019-06-15 18:41:09 +0200
commit7fbae7530dd97294821fb2ac58589b49b0040db4 (patch)
tree904894920545b8e0f7b2d194646cea694a05f30e /sql/updates
parent77a73a737c8aefb6f48bbcc47f26b1f9967fc1be (diff)
Core/Scripts Rework boss Terestian Illhoof (Karazhan) (#19057)
(cherrypicked from 87f2cb04cada92590e163d60c729c9e6c1c270f5)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/master/2019_06_15_11_world_2017_02_09_01_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_06_15_11_world_2017_02_09_01_world.sql b/sql/updates/world/master/2019_06_15_11_world_2017_02_09_01_world.sql
new file mode 100644
index 00000000000..5be733fb530
--- /dev/null
+++ b/sql/updates/world/master/2019_06_15_11_world_2017_02_09_01_world.sql
@@ -0,0 +1,7 @@
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERe `entry`=17265;
+UPDATE `spell_target_position` SET `PositionX`=-11240.5, `PositionY`=-1717.25, `PositionZ`=179.238 WHERE `ID`=30171 AND `EffectIndex`=0; -- `Orientation`=1.32986
+UPDATE `spell_target_position` SET `PositionX`=-11251.6, `PositionY`=-1703.42, `PositionZ`=179.238 WHERE `ID`=30179 and`EffectIndex`=0; -- `Orientation`=6.1522
+
+DELETE FROM `spell_target_position` WHERE `ID`=30120;
+INSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`VerifiedBuild`)VALUES
+(30120, 0, 532, -11234.2, -1698.46, 179.24, 0); -- `Orientation`=0.67621