DB/Instance: Black Temple

- Add missing aura's and Ashtongue Stalker's spawns.
- Add paths for Illidari Nightlord's and formations

(cherry picked from commit 0bb9da30d50b0a69bddded8f77b4e3efe89d78ad)

1 files changed, 103 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_02_26_00_world_2016_09_04_02_world.sql b/sql/updates/world/master/2017_02_26_00_world_2016_09_04_02_world.sql
new file mode 100644
index 00000000000..b24829f50b2
--- /dev/null
+++ b/sql/updates/world/master/2017_02_26_00_world_2016_09_04_02_world.sql
@@ -0,0 +1,103 @@
+UPDATE `creature_template_addon` SET `auras`='39839' WHERE `entry`=22853;
+UPDATE `creature_template_addon` SET `auras`='41191 34189' WHERE `entry`=23374;
+
+-- Add Ashtongue Stalker's
+SET @CGUID := 86283;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+8;
+INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES 
+(@CGUID+0, 23374, 564, 656.2982, 387.9902, 112.7728, 2.478368, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191) (possible waypoints or random movement)
+(@CGUID+1, 23374, 564, 707.5325, 352.4765, 125.2653, 1.32645, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+2, 23374, 564, 769.7925, 370.5881, 112.8415, 0.6128875, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+3, 23374, 564, 702.7503, 352.3887, 125.2664, 1.972222, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+4, 23374, 564, 666.9014, 290.3525, 125.2559, 3.176499, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+5, 23374, 564, 740.3699, 286.297, 125.2686, 5.113815, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+6, 23374, 564, 669.1512, 286.5623, 125.2573, 4.24115, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191) (possible waypoints or random movement)
+(@CGUID+7, 23374, 564, 742.5994, 290.4014, 125.2681, 0.05235988, 7200, 0), -- 23374 (Area: 4009) (Auras: 41191 - 41191)
+(@CGUID+8, 23374, 564, 631.986, 251.5276, 112.749, 2.80998, 7200, 0); -- 23374 (Area: 0) (Auras: 41191 - 41191, 34189 - 34189)
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=12827;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(12827, 12827, 0, 0, 2),
+(12827, 12840, 10, 90, 2),
+(12827, 12824, 10, 270, 2);
+
+-- Pathing for Illidari Nightlord Entry: 22855 'TDB FORMAT' 
+SET @NPC := 12827;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=797.9049,`position_y`=255.5211,`position_z`=113.0057 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,797.9049,255.5211,113.0057,0,0,0,0,100,0), -- 21:33:21
+(@PATH,2,799.5116,265.5505,112.9946,0,0,0,0,100,0), -- 21:34:44
+(@PATH,3,799.6346,277.1103,112.9948,0,0,0,0,100,0), -- 21:33:26
+(@PATH,4,799.4362,303.9547,113.0016,0,0,0,0,100,0), -- 21:33:31
+(@PATH,5,799.0039,333.6956,113.0056,0,0,0,0,100,0), -- 21:34:33
+(@PATH,6,799.1071,339.8928,113.0009,0,0,0,0,100,0), -- 21:33:37
+(@PATH,7,798.9255,345.5464,113.0027,0,0,0,0,100,0), -- 21:33:42
+(@PATH,8,798.3091,375.1995,112.9979,0,0,0,0,100,0), -- 21:33:47
+(@PATH,9,796.5051,380.055,112.9991,0,0,0,0,100,0), -- 21:34:21
+(@PATH,10,790.2986,393.373,113.0041,0,0,0,0,100,0), -- 21:33:49
+(@PATH,11,788.781,396.0202,112.9945,0,0,0,0,100,0), -- 21:33:53
+(@PATH,12,776.2429,410.9937,112.9996,0,0,0,0,100,0), -- 21:34:17
+(@PATH,13,769.3853,414.8633,112.9868,0,0,0,0,100,0), -- 21:34:12
+(@PATH,14,759.0627,420.3231,112.9865,0,0,0,0,100,0), -- 21:33:58
+(@PATH,15,755.8228,421.9212,112.7266,0,0,0,0,100,0), -- 21:34:08
+(@PATH,16,730.3083,422.5441,112.9883,0,0,0,0,100,0), -- 21:34:02
+(@PATH,17,755.8228,421.9212,112.7266,0,0,0,0,100,0), -- 21:34:08
+(@PATH,18,759.0627,420.3231,112.9865,0,0,0,0,100,0), -- 21:33:58
+(@PATH,19,769.3853,414.8633,112.9868,0,0,0,0,100,0), -- 21:34:12
+(@PATH,20,776.2429,410.9937,112.9996,0,0,0,0,100,0), -- 21:34:17
+(@PATH,21,788.781,396.0202,112.9945,0,0,0,0,100,0), -- 21:33:53
+(@PATH,22,790.2986,393.373,113.0041,0,0,0,0,100,0), -- 21:33:49
+(@PATH,23,796.5051,380.055,112.9991,0,0,0,0,100,0), -- 21:34:21
+(@PATH,24,798.2438,374.1577,112.9994,0,0,0,0,100,0), -- 21:34:25
+(@PATH,25,798.8231,345.4242,112.9964,0,0,0,0,100,0), -- 21:34:28
+(@PATH,26,799.1071,339.8928,113.0009,0,0,0,0,100,0), -- 21:33:37
+(@PATH,27,799.0039,333.6956,113.0056,0,0,0,0,100,0), -- 21:34:33
+(@PATH,28,799.4362,303.9547,113.0016,0,0,0,0,100,0), -- 21:33:31
+(@PATH,29,799.7034,286.332,113.0002,0,0,0,0,100,0), -- 21:34:38
+(@PATH,30,799.6346,277.1103,112.9948,0,0,0,0,100,0), -- 21:33:26
+(@PATH,31,799.5116,265.5505,112.9946,0,0,0,0,100,0); -- 21:34:44
+-- 0x1C16F446801651C0006A5B00009D4B4E .go 797.9049 255.5211 113.0057
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=12826;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(12826, 12826, 0, 0, 2),
+(12826, 12835, 10, 90, 2),
+(12826, 12821, 10, 270, 2);
+
+-- Pathing for Illidari Nightlord Entry: 22855 'TDB FORMAT' 
+SET @NPC := 12826;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=671.0103,`position_y`=418.0573,`position_z`=112.9719 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,671.0103,418.0573,112.9719,0,0,0,0,100,0), -- 21:30:49
+(@PATH,2,664.3151,418.1411,112.9714,0,0,0,0,100,0), -- 21:30:58
+(@PATH,3,643.6459,416.9381,112.9693,0,0,0,0,100,0), -- 21:32:19
+(@PATH,4,633.8777,410.9504,112.9694,0,0,0,0,100,0), -- 21:31:04
+(@PATH,5,625.0879,404.1424,112.968,0,0,0,0,100,0), -- 21:31:09
+(@PATH,6,616.4854,383.6906,112.9617,0,0,0,0,100,0), -- 21:32:08
+(@PATH,7,609.0042,357.2156,112.9686,0,0,0,0,100,0), -- 21:31:12
+(@PATH,8,608.3771,346.3979,112.973,0,0,0,0,100,0), -- 21:32:05
+(@PATH,9,608.604,340.5182,112.9734,0,0,0,0,100,0), -- 21:31:20
+(@PATH,10,608.3019,334.7826,112.9586,0,0,0,0,100,0), -- 21:31:23
+(@PATH,11,608.424,297.6053,112.9599,0,0,0,0,100,0), -- 21:31:49
+(@PATH,12,607.9512,258.337,112.967,0,0,0,0,100,0), -- 21:31:29
+(@PATH,13,614.2401,245.8512,112.9672,0,0,0,0,100,0), -- 21:31:39
+(@PATH,14,608.4531,256.4178,112.9667,0,0,0,0,100,0), -- 21:31:45
+(@PATH,15,608.424,297.6053,112.9599,0,0,0,0,100,0), -- 21:31:49
+(@PATH,16,608.3019,334.7826,112.9586,0,0,0,0,100,0), -- 21:31:23
+(@PATH,17,608.604,340.5182,112.9734,0,0,0,0,100,0), -- 21:31:20
+(@PATH,18,608.3771,346.3979,112.973,0,0,0,0,100,0), -- 21:32:05
+(@PATH,19,609.0042,357.2156,112.9686,0,0,0,0,100,0), -- 21:31:12
+(@PATH,20,616.4854,383.6906,112.9617,0,0,0,0,100,0), -- 21:32:08
+(@PATH,21,625.0543,404.2943,112.965,0,0,0,0,100,0), -- 21:32:16
+(@PATH,22,633.8777,410.9504,112.9694,0,0,0,0,100,0), -- 21:31:04
+(@PATH,23,643.6459,416.9381,112.9693,0,0,0,0,100,0), -- 21:32:19
+(@PATH,24,664.3151,418.1411,112.9714,0,0,0,0,100,0); -- 21:30:58
+-- 0x1C16F446801651C0006A5B00001D4B4E .go 671.0103 418.0573 112.9719