DB/Pathing: Dragonblight - Scarlet Point

1 files changed, 881 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_19_04_world.sql b/sql/updates/world/2015_07_19_04_world.sql
new file mode 100644
index 00000000000..562515459ba
--- /dev/null
+++ b/sql/updates/world/2015_07_19_04_world.sql
@@ -0,0 +1,881 @@
+-- Dragonblight - Scarlet Point
+
+-- 1. Onslaught Infantry
+SET @NPC := 114254;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4572.629,`position_y`=-514.3341,`position_z`=155.2067 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,4572.629,-514.3341,155.2067,0,0,0,0,100,0),
+(@PATH,2,4577.129,-522.0841,155.2067,0,0,0,0,100,0),
+(@PATH,3,4577.187,-522.428,155.2298,0,0,0,0,100,0),
+(@PATH,4,4577.687,-522.928,155.2298,0,0,0,0,100,0),
+(@PATH,5,4577.687,-526.928,155.2298,0,0,0,0,100,0),
+(@PATH,6,4578.187,-531.678,155.2298,0,0,0,0,100,0),
+(@PATH,7,4577.187,-532.928,155.2298,0,0,0,0,100,0),
+(@PATH,8,4578.359,-535.9939,155.2575,0,0,0,0,100,0),
+(@PATH,9,4576.859,-539.7439,155.2575,0,0,0,0,100,0),
+(@PATH,10,4576.359,-541.2439,155.2575,0,0,0,0,100,0),
+(@PATH,11,4575.859,-542.4939,155.2575,0,0,0,0,100,0),
+(@PATH,12,4574.067,-547.567,155.2375,0,0,0,0,100,0),
+(@PATH,13,4572.817,-547.817,155.2375,0,0,0,0,100,0),
+(@PATH,14,4570.817,-548.567,155.2375,0,0,0,0,100,0),
+(@PATH,15,4566.067,-550.067,155.2375,0,0,0,0,100,0),
+(@PATH,16,4560.803,-551.7219,155.0219,0,0,0,0,100,0),
+(@PATH,17,4555.803,-548.9719,155.0219,0,0,0,0,100,0),
+(@PATH,18,4548.898,-545.5068,155.2439,0,0,0,0,100,0),
+(@PATH,19,4548.148,-544.0068,155.2439,0,0,0,0,100,0),
+(@PATH,20,4545.398,-539.5068,154.9939,0,0,0,0,100,0),
+(@PATH,21,4545.385,-539.1914,154.97,0,0,0,0,100,0),
+(@PATH,22,4544.385,-537.1914,155.22,0,0,0,0,100,0),
+(@PATH,23,4544.885,-533.4414,155.22,0,0,0,0,100,0),
+(@PATH,24,4545.635,-527.1914,155.22,0,0,0,0,100,0),
+(@PATH,25,4545.818,-526.8594,155.2668,0,0,0,0,100,0),
+(@PATH,26,4545.818,-526.3594,155.2668,0,0,0,0,100,0),
+(@PATH,27,4549.318,-521.8594,155.0168,0,0,0,0,100,0),
+(@PATH,28,4551.818,-518.1094,155.0168,0,0,0,0,100,0),
+(@PATH,29,4552.098,-517.9098,155.1916,0,0,0,0,100,0),
+(@PATH,30,4553.848,-515.9098,155.1916,0,0,0,0,100,0),
+(@PATH,31,4556.598,-515.6598,155.1916,0,0,0,0,100,0),
+(@PATH,32,4558.098,-515.6598,155.1916,0,0,0,0,100,0),
+(@PATH,33,4562.348,-515.1598,155.1916,0,0,0,0,100,0),
+(@PATH,34,4566.348,-514.9098,155.1916,0,0,0,0,100,0);
+
+-- 2. Workemotes
+-- Onslaught Mason SAI
+SET @ENTRY := 27333;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(@ENTRY,0,2,0,1,0,100,0,2000,2000,2000,2000,5,28,0,0,0,0,0,1,0,0,0,0,0,0,0,"Onslaught Mason - Out of Combat - Play Emote 28");
+
+-- 3. Onslaught Raven Archon 
+UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=27357 AND `source_type`=0 AND `id`=0 AND `link`=0;
+SET @NPC := 117141;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4602.237,`position_y`=-548.184,`position_z`=157.1292 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,4602.237,-548.184,157.1292,0,0,0,0,100,0),
+(@PATH,2,4599.987,-549.934,156.3792,0,0,0,0,100,0),
+(@PATH,3,4596.987,-552.184,155.8792,0,0,0,0,100,0),
+(@PATH,4,4593.737,-554.434,155.3792,0,0,0,0,100,0),
+(@PATH,5,4594.211,-554.0303,155.7048,0,0,0,0,100,0),
+(@PATH,6,4597.211,-552.0303,155.9548,0,0,0,0,100,0),
+(@PATH,7,4600.461,-549.5303,156.7048,0,0,0,0,100,0),
+(@PATH,8,4600.543,-549.354,156.9763,0,0,0,0,100,0),
+(@PATH,9,4602.543,-547.854,157.2263,0,0,0,0,100,0),
+(@PATH,10,4607.293,-546.604,158.2263,0,0,0,0,100,0),
+(@PATH,11,4610.293,-546.104,158.7263,0,0,0,0,100,0),
+(@PATH,12,4613.043,-545.354,159.2263,0,0,0,0,100,0),
+(@PATH,13,4614.793,-544.854,159.9763,0,0,0,0,100,0),
+(@PATH,14,4617.793,-543.854,160.7263,0,0,0,0,100,0),
+(@PATH,15,4620.543,-543.104,161.4763,0,0,0,0,100,0),
+(@PATH,16,4622.543,-542.604,162.2263,0,0,0,0,100,0),
+(@PATH,17,4622.75,-542.4305,162.4348,0,0,0,0,100,0),
+(@PATH,18,4623.5,-542.1805,162.6848,0,0,0,0,100,0),
+(@PATH,19,4626,-540.1805,163.6848,0,0,0,0,100,0),
+(@PATH,20,4627.5,-538.9305,164.1848,0,0,0,0,100,0),
+(@PATH,21,4629.5,-537.4305,165.1848,0,0,0,0,100,0),
+(@PATH,22,4631.75,-535.4305,165.9348,0,0,0,0,100,0),
+(@PATH,23,4634.75,-532.9305,166.4348,0,0,0,0,100,0),
+(@PATH,24,4635.075,-532.534,166.5515,0,0,0,0,100,0),
+(@PATH,25,4635.825,-532.034,166.8015,0,0,0,0,100,0),
+(@PATH,26,4641.044,-524.0594,167.1748,0,0,0,0,100,0),
+(@PATH,27,4640.689,-524.028,167.0105,0,0,0,0,100,0),
+(@PATH,28,4640.771,-523.9791,167.2765,0,0,0,0,100,0),
+(@PATH,29,4635.734,-532.2753,166.7173,0,0,0,0,100,0),
+(@PATH,30,4633.234,-534.2753,166.2173,0,0,0,0,100,0),
+(@PATH,31,4630.984,-536.0253,165.7173,0,0,0,0,100,0),
+(@PATH,32,4628.984,-537.7753,164.7173,0,0,0,0,100,0),
+(@PATH,33,4626.734,-539.7753,163.9673,0,0,0,0,100,0),
+(@PATH,34,4624.984,-541.0253,163.2173,0,0,0,0,100,0),
+(@PATH,35,4624.819,-541.2441,162.7961,0,0,0,0,100,0),
+(@PATH,36,4623.319,-542.4941,162.5461,0,0,0,0,100,0),
+(@PATH,37,4621.319,-542.9941,161.7961,0,0,0,0,100,0),
+(@PATH,38,4619.569,-543.4941,161.0461,0,0,0,0,100,0),
+(@PATH,39,4617.569,-543.9941,160.2961,0,0,0,0,100,0),
+(@PATH,40,4613.819,-544.7441,159.7961,0,0,0,0,100,0),
+(@PATH,41,4612.069,-545.2441,159.0461,0,0,0,0,100,0),
+(@PATH,42,4609.069,-545.9941,158.5461,0,0,0,0,100,0),
+(@PATH,43,4606.069,-546.9941,157.7961,0,0,0,0,100,0),
+(@PATH,44,4602.238,-548.0697,157.0609,0,0,0,0,100,0),
+(@PATH,45,4599.988,-549.8197,156.5609,0,0,0,0,100,0),
+(@PATH,46,4596.738,-552.3197,155.8109,0,0,0,0,100,0),
+(@PATH,47,4593.738,-554.3197,155.5609,0,0,0,0,100,0),
+(@PATH,48,4594.211,-554.0303,155.7048,0,0,0,0,100,0),
+(@PATH,49,4597.211,-552.0303,155.9548,0,0,0,0,100,0),
+(@PATH,50,4600.461,-549.5303,156.7048,0,0,0,0,100,0);
+
+-- 4. Onslaught Raven Archon 
+SET @NPC := 117137;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4644.006,`position_y`=-489.4915,`position_z`=168.7654 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,4644.006,-489.4915,168.7654,0,0,0,0,100,0),
+(@PATH,2,4643.756,-493.4915,168.2654,0,0,0,0,100,0),
+(@PATH,3,4643.256,-496.4915,167.7654,0,0,0,0,100,0),
+(@PATH,4,4643.006,-498.4915,167.2654,0,0,0,0,100,0),
+(@PATH,5,4643.311,-495.9854,167.7208,0,0,0,0,100,0),
+(@PATH,6,4643.561,-492.9854,168.2208,0,0,0,0,100,0),
+(@PATH,7,4643.817,-492.9625,168.5086,0,0,0,0,100,0),
+(@PATH,8,4644.317,-489.2125,168.7586,0,0,0,0,100,0);
+
+-- 5. Onslaught Raven Archon 
+SET @NPC := 117142;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4568.026,`position_y`=-587.3014,`position_z`=151.4318 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,4568.026,-587.3014,151.4318,0,0,0,0,100,0),
+(@PATH,2,4564.026,-587.5514,150.6818,0,0,0,0,100,0),
+(@PATH,3,4560.276,-587.8014,150.1818,0,0,0,0,100,0),
+(@PATH,4,4557.276,-588.0514,149.6818,0,0,0,0,100,0),
+(@PATH,5,4554.276,-588.3014,149.1818,0,0,0,0,100,0),
+(@PATH,6,4553.841,-588.2387,148.9315,0,0,0,0,100,0),
+(@PATH,7,4553.341,-588.4887,148.9315,0,0,0,0,100,0),
+(@PATH,8,4549.591,-587.4887,148.1815,0,0,0,0,100,0),
+(@PATH,9,4546.591,-586.7387,147.4315,0,0,0,0,100,0),
+(@PATH,10,4543.841,-586.4887,147.1815,0,0,0,0,100,0),
+(@PATH,11,4540.091,-585.4887,146.4315,0,0,0,0,100,0),
+(@PATH,12,4537.091,-584.9887,145.6815,0,0,0,0,100,0),
+(@PATH,13,4536.776,-584.8312,145.5589,0,0,0,0,100,0),
+(@PATH,14,4535.276,-584.5812,145.3089,0,0,0,0,100,0),
+(@PATH,15,4532.526,-585.5812,144.5589,0,0,0,0,100,0),
+(@PATH,16,4530.776,-586.0812,143.8089,0,0,0,0,100,0),
+(@PATH,17,4529.026,-586.8312,143.5589,0,0,0,0,100,0),
+(@PATH,18,4527.026,-587.0812,142.8089,0,0,0,0,100,0),
+(@PATH,19,4525.026,-587.8312,142.0589,0,0,0,0,100,0),
+(@PATH,20,4524.905,-587.9237,142.0388,0,0,0,0,100,0),
+(@PATH,21,4526.655,-587.1737,142.7888,0,0,0,0,100,0),
+(@PATH,22,4528.655,-586.6737,143.2888,0,0,0,0,100,0),
+(@PATH,23,4530.405,-586.1737,143.7888,0,0,0,0,100,0),
+(@PATH,24,4533.155,-585.1737,144.5388,0,0,0,0,100,0),
+(@PATH,25,4533.413,-585.1615,144.8716,0,0,0,0,100,0),
+(@PATH,26,4535.413,-584.6615,145.3716,0,0,0,0,100,0),
+(@PATH,27,4538.163,-585.4115,146.1216,0,0,0,0,100,0),
+(@PATH,28,4541.163,-585.9115,146.3716,0,0,0,0,100,0),
+(@PATH,29,4543.913,-586.6615,147.1216,0,0,0,0,100,0),
+(@PATH,30,4547.913,-587.1615,147.8716,0,0,0,0,100,0),
+(@PATH,31,4550.663,-587.9115,148.3716,0,0,0,0,100,0),
+(@PATH,32,4551.041,-587.8854,148.5696,0,0,0,0,100,0),
+(@PATH,33,4553.541,-588.3854,149.0696,0,0,0,0,100,0),
+(@PATH,34,4556.541,-588.1354,149.5696,0,0,0,0,100,0),
+(@PATH,35,4560.291,-587.8854,150.0696,0,0,0,0,100,0),
+(@PATH,36,4564.291,-587.6354,150.8196,0,0,0,0,100,0),
+(@PATH,37,4564.641,-587.5833,151.1127,0,0,0,0,100,0),
+(@PATH,38,4568.141,-587.3333,151.6127,0,0,0,0,100,0),
+(@PATH,39,4571.141,-583.3333,152.3627,0,0,0,0,100,0),
+(@PATH,40,4575.641,-576.8333,152.6127,0,0,0,0,100,0),
+(@PATH,41,4580.891,-569.8333,153.3627,0,0,0,0,100,0),
+(@PATH,42,4584.391,-564.8333,153.8627,0,0,0,0,100,0),
+(@PATH,43,4583.907,-565.6901,153.7024,0,0,0,0,100,0),
+(@PATH,44,4580.407,-570.4401,153.2024,0,0,0,0,100,0),
+(@PATH,45,4574.657,-578.4401,152.7024,0,0,0,0,100,0),
+(@PATH,46,4570.657,-583.9401,152.2024,0,0,0,0,100,0);
+
+-- 6. Onslaught Death Knight
+SET @NPC := 117875;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4570.128,`position_y`=-631.7788,`position_z`=159.2071 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,10719,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,4570.128,-631.7788,159.2071,0,0,0,0,100,0),
+(@PATH,2,4570.628,-632.5288,159.7071,0,0,0,0,100,0),
+(@PATH,3,4572.128,-631.0288,160.2071,0,0,0,0,100,0),
+(@PATH,4,4574.378,-629.0288,160.2071,0,0,0,0,100,0),
+(@PATH,5,4584.378,-619.7788,160.9571,0,0,0,0,100,0),
+(@PATH,6,4591.824,-612.4489,160.821,0,0,0,0,100,0),
+(@PATH,7,4591.324,-611.6989,160.321,0,0,0,0,100,0),
+(@PATH,8,4590.324,-609.9489,159.571,0,0,0,0,100,0),
+(@PATH,9,4586.074,-603.6989,159.321,0,0,0,0,100,0),
+(@PATH,10,4585.984,-603.7021,159.1084,0,0,0,0,100,0),
+(@PATH,11,4584.984,-601.9521,158.8584,0,0,0,0,100,0),
+(@PATH,12,4582.984,-602.9521,157.8584,0,0,0,0,100,0),
+(@PATH,13,4580.484,-604.2021,156.8584,0,0,0,0,100,0),
+(@PATH,14,4577.734,-605.4521,155.1084,0,0,0,0,100,0),
+(@PATH,15,4575.734,-606.2021,154.1084,0,0,0,0,100,0),
+(@PATH,16,4573.234,-607.4521,153.3584,0,0,0,0,100,0),
+(@PATH,17,4571.484,-608.4521,152.8584,0,0,0,0,100,0),
+(@PATH,18,4568.984,-609.7021,152.1084,0,0,0,0,100,0),
+(@PATH,19,4565.234,-611.2021,151.3584,0,0,0,0,100,0),
+(@PATH,20,4562.484,-612.4521,150.6084,0,0,0,0,100,0),
+(@PATH,21,4557.984,-614.7021,149.8584,0,0,0,0,100,0),
+(@PATH,22,4558.026,-614.7653,149.9136,0,0,0,0,100,0),
+(@PATH,23,4557.526,-615.2653,149.6636,0,0,0,0,100,0),
+(@PATH,24,4558.526,-616.7653,150.1636,0,0,0,0,100,0),
+(@PATH,25,4561.026,-620.0153,151.1636,0,0,0,0,100,0),
+(@PATH,26,4562.776,-622.2653,152.4136,0,0,0,0,100,0),
+(@PATH,27,4564.026,-623.7653,153.1636,0,0,0,0,100,0),
+(@PATH,28,4565.276,-625.2653,153.9136,0,0,0,0,100,0),
+(@PATH,29,4566.276,-627.0153,154.9136,0,0,0,0,100,0),
+(@PATH,30,4567.526,-628.5153,155.9136,0,0,0,0,100,0);
+
+-- 7. Onslaught Death Knight
+SET @NPC := 117876;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4644.598,`position_y`=-554.0845,`position_z`=168.3518 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,10719,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,4644.598,-554.0845,168.3518,0,0,0,0,100,0),
+(@PATH,2,4643.098,-556.5845,167.8518,0,0,0,0,100,0),
+(@PATH,3,4641.598,-558.8345,167.1018,0,0,0,0,100,0),
+(@PATH,4,4639.598,-562.0845,166.3518,0,0,0,0,100,0),
+(@PATH,5,4638.045,-564.3422,165.4118,0,0,0,0,100,0),
+(@PATH,6,4637.045,-564.0922,164.9118,0,0,0,0,100,0),
+(@PATH,7,4636.045,-563.8422,164.1618,0,0,0,0,100,0),
+(@PATH,8,4634.045,-563.3422,163.6618,0,0,0,0,100,0),
+(@PATH,9,4633.045,-563.0922,163.4118,0,0,0,0,100,0),
+(@PATH,10,4631.545,-562.3422,162.4118,0,0,0,0,100,0),
+(@PATH,11,4627.545,-561.5922,161.6618,0,0,0,0,100,0),
+(@PATH,12,4624.713,-560.8789,161.1454,0,0,0,0,100,0),
+(@PATH,13,4622.713,-560.8789,160.3954,0,0,0,0,100,0),
+(@PATH,14,4620.713,-560.6289,159.6454,0,0,0,0,100,0),
+(@PATH,15,4617.713,-560.6289,159.1454,0,0,0,0,100,0),
+(@PATH,16,4613.963,-560.3789,158.6454,0,0,0,0,100,0),
+(@PATH,17,4608.963,-560.3789,157.8954,0,0,0,0,100,0),
+(@PATH,18,4611.391,-560.3311,158.5312,0,0,0,0,100,0),
+(@PATH,19,4617.141,-560.5811,159.0312,0,0,0,0,100,0),
+(@PATH,20,4620.141,-560.5811,159.7812,0,0,0,0,100,0),
+(@PATH,21,4622.141,-560.5811,160.2812,0,0,0,0,100,0),
+(@PATH,22,4624.141,-560.5811,161.0312,0,0,0,0,100,0),
+(@PATH,23,4624.396,-560.9586,161.3495,0,0,0,0,100,0),
+(@PATH,24,4624.896,-560.9586,161.3495,0,0,0,0,100,0),
+(@PATH,25,4626.896,-561.4586,161.8495,0,0,0,0,100,0),
+(@PATH,26,4631.396,-562.7086,162.8495,0,0,0,0,100,0),
+(@PATH,27,4633.396,-562.9586,163.5995,0,0,0,0,100,0),
+(@PATH,28,4636.146,-563.9586,164.3495,0,0,0,0,100,0),
+(@PATH,29,4637.146,-564.2086,164.8495,0,0,0,0,100,0),
+(@PATH,30,4636.412,-563.797,164.5076,0,0,0,0,100,0),
+(@PATH,31,4637.412,-564.047,165.0076,0,0,0,0,100,0),
+(@PATH,32,4638.162,-564.297,165.7576,0,0,0,0,100,0),
+(@PATH,33,4640.412,-561.047,166.5076,0,0,0,0,100,0),
+(@PATH,34,4641.662,-558.297,167.2576,0,0,0,0,100,0),
+(@PATH,35,4643.912,-555.297,168.2576,0,0,0,0,100,0),
+(@PATH,36,4645.912,-551.797,169.0076,0,0,0,0,100,0),
+(@PATH,37,4644.598,-554.0845,168.3518,0,0,0,0,100,0);
+
+-- 8. Onslaught Raven Archon 
+SET @NPC := 117139;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4672.427,`position_y`=-432.248,`position_z`=173.8428 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,4672.427,-432.248,173.8428,0,0,0,0,100,0),
+(@PATH,2,4675.927,-430.498,174.3428,0,0,0,0,100,0),
+(@PATH,3,4679.177,-428.998,175.0928,0,0,0,0,100,0),
+(@PATH,4,4685.926,-425.7451,175.791,0,0,0,0,100,0),
+(@PATH,5,4688.676,-423.2451,176.291,0,0,0,0,100,0),
+(@PATH,6,4691.676,-420.7451,177.041,0,0,0,0,100,0),
+(@PATH,7,4693.746,-418.9523,177.5551,0,0,0,0,100,0),
+(@PATH,8,4695.496,-416.4523,178.0551,0,0,0,0,100,0),
+(@PATH,9,4699.661,-409.5062,178.1642,0,0,0,0,100,0),
+(@PATH,10,4697.22,-391.7566,178.4175,0,0,0,0,100,0),
+(@PATH,11,4697.272,-392.0195,178.3085,0,0,0,0,100,0),
+(@PATH,12,4697.517,-391.9886,178.4114,0,0,0,0,100,0),
+(@PATH,13,4699.727,-409.6594,178.2528,0,0,0,0,100,0),
+(@PATH,14,4693.497,-419.0012,177.537,0,0,0,0,100,0),
+(@PATH,15,4691.247,-420.7512,176.787,0,0,0,0,100,0),
+(@PATH,16,4688.497,-423.5012,176.537,0,0,0,0,100,0),
+(@PATH,17,4686.247,-425.5012,175.787,0,0,0,0,100,0),
+(@PATH,18,4686.04,-425.7852,175.5942,0,0,0,0,100,0),
+(@PATH,19,4685.54,-426.0352,175.5942,0,0,0,0,100,0),
+(@PATH,20,4681.04,-428.2852,175.0942,0,0,0,0,100,0),
+(@PATH,21,4676.04,-430.5352,174.3442,0,0,0,0,100,0),
+(@PATH,22,4672.29,-432.2852,173.8442,0,0,0,0,100,0);
+
+-- 9. Onslaught Death Knight
+SET @NPC := 117857;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4633.917,`position_y`=-476.0173,`position_z`=168.7754 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,10719,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,4633.917,-476.0173,168.7754,0,0,0,0,100,0),
+(@PATH,2,4634.167,-475.5173,168.7754,0,0,0,0,100,0),
+(@PATH,3,4635.772,-458.6652,168.1609,0,0,0,0,100,0),
+(@PATH,4,4633.772,-456.4152,167.4109,0,0,0,0,100,0),
+(@PATH,5,4633.272,-455.9152,166.9109,0,0,0,0,100,0),
+(@PATH,6,4632.272,-454.4152,166.4109,0,0,0,0,100,0),
+(@PATH,7,4630.772,-452.9152,165.6609,0,0,0,0,100,0),
+(@PATH,8,4630.631,-452.4373,165.6382,0,0,0,0,100,0),
+(@PATH,9,4631.881,-453.9373,166.3882,0,0,0,0,100,0),
+(@PATH,10,4632.881,-455.1873,166.8882,0,0,0,0,100,0),
+(@PATH,11,4633.381,-455.9373,167.3882,0,0,0,0,100,0),
+(@PATH,12,4635.381,-458.4373,168.1382,0,0,0,0,100,0),
+(@PATH,13,4635.367,-458.5712,168.2003,0,0,0,0,100,0),
+(@PATH,14,4635.617,-459.0712,168.2003,0,0,0,0,100,0),
+(@PATH,15,4633.764,-475.9621,168.6973,0,0,0,0,100,0),
+(@PATH,16,4632.514,-478.7121,169.1973,0,0,0,0,100,0),
+(@PATH,17,4631.264,-481.2121,169.6973,0,0,0,0,100,0),
+(@PATH,18,4627.014,-490.9621,169.1973,0,0,0,0,100,0),
+(@PATH,19,4625.764,-493.7121,168.4473,0,0,0,0,100,0),
+(@PATH,20,4624.014,-497.4621,167.9473,0,0,0,0,100,0),
+(@PATH,21,4621.019,-503.5197,167.5489,0,0,0,0,100,0),
+(@PATH,22,4618.269,-509.5197,167.0489,0,0,0,0,100,0),
+(@PATH,23,4618.476,-508.4322,167.2701,0,0,0,0,100,0),
+(@PATH,24,4621.087,-503.366,167.9358,0,0,0,0,100,0),
+(@PATH,25,4625.337,-494.116,168.4358,0,0,0,0,100,0),
+(@PATH,26,4627.087,-490.616,169.1858,0,0,0,0,100,0),
+(@PATH,27,4628.087,-488.116,170.1858,0,0,0,0,100,0),
+(@PATH,28,4631.837,-479.866,169.4358,0,0,0,0,100,0),
+(@PATH,29,4633.587,-476.366,168.6858,0,0,0,0,100,0);
+
+-- 10. Onslaught Death Knight
+SET @NPC := 117836;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4663.659,`position_y`=-378.53,`position_z`=178.9522 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,10719,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,4663.659,-378.53,178.9522,0,0,0,0,100,0),
+(@PATH,2,4661.159,-374.28,178.9522,0,0,0,0,100,0),
+(@PATH,3,4656.159,-367.03,178.9522,0,0,0,0,100,0),
+(@PATH,4,4656.221,-366.9449,178.9369,0,0,0,0,100,0),
+(@PATH,5,4655.721,-366.1949,178.9369,0,0,0,0,100,0),
+(@PATH,6,4656.221,-362.1949,178.9369,0,0,0,0,100,0),
+(@PATH,7,4688.97,-376.0598,179.0081,0,0,0,0,100,0),
+(@PATH,8,4688.47,-377.3098,179.0081,0,0,0,0,100,0),
+(@PATH,9,4686.72,-377.8098,179.0081,0,0,0,0,100,0),
+(@PATH,10,4683.47,-378.8098,179.0081,0,0,0,0,100,0),
+(@PATH,11,4681.97,-379.3098,179.0081,0,0,0,0,100,0),
+(@PATH,12,4675.504,-381.5966,179.0296,0,0,0,0,100,0),
+(@PATH,13,4672.254,-380.5966,178.7796,0,0,0,0,100,0),
+(@PATH,14,4668.004,-379.5966,178.7796,0,0,0,0,100,0),
+(@PATH,15,4663.438,-378.4114,178.941,0,0,0,0,100,0);
+
+-- 11. Onslaught Death Knight
+SET @NPC := 117835;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4646.254,`position_y`=-412.3115,`position_z`=168.0308 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,10719,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,4646.254,-412.3115,168.0308,0,0,0,0,100,0),
+(@PATH,2,4650.254,-411.8115,169.0308,0,0,0,0,100,0),
+(@PATH,3,4652.004,-411.5615,169.5308,0,0,0,0,100,0),
+(@PATH,4,4654.004,-411.0615,170.2808,0,0,0,0,100,0),
+(@PATH,5,4656.004,-410.8115,170.7808,0,0,0,0,100,0),
+(@PATH,6,4658.004,-410.5615,171.5308,0,0,0,0,100,0),
+(@PATH,7,4660.004,-410.3115,172.2808,0,0,0,0,100,0),
+(@PATH,8,4661.754,-410.0615,172.7808,0,0,0,0,100,0),
+(@PATH,9,4663.754,-409.8115,173.2808,0,0,0,0,100,0),
+(@PATH,10,4665.754,-409.3115,174.0308,0,0,0,0,100,0),
+(@PATH,11,4668.754,-408.8115,174.7808,0,0,0,0,100,0),
+(@PATH,12,4670.504,-408.5615,175.5308,0,0,0,0,100,0),
+(@PATH,13,4672.504,-408.3115,176.5308,0,0,0,0,100,0),
+(@PATH,14,4674.504,-408.0615,177.5308,0,0,0,0,100,0),
+(@PATH,15,4674.718,-407.6685,177.7038,0,0,0,0,100,0),
+(@PATH,16,4676.718,-407.4185,178.2038,0,0,0,0,100,0),
+(@PATH,17,4678.718,-406.6685,178.7038,0,0,0,0,100,0),
+(@PATH,18,4683.218,-405.4185,179.4538,0,0,0,0,100,0),
+(@PATH,19,4687.403,-403.8835,179.7482,0,0,0,0,100,0),
+(@PATH,20,4685.523,-395.8652,179.424,0,0,0,0,100,0),
+(@PATH,21,4682.773,-395.6152,178.924,0,0,0,0,100,0),
+(@PATH,22,4677.773,-395.1152,178.174,0,0,0,0,100,0),
+(@PATH,23,4674.023,-394.6152,177.924,0,0,0,0,100,0),
+(@PATH,24,4671.023,-394.3652,177.174,0,0,0,0,100,0),
+(@PATH,25,4671.405,-394.4984,177.5945,0,0,0,0,100,0),
+(@PATH,26,4674.405,-394.7484,177.8445,0,0,0,0,100,0),
+(@PATH,27,4680.155,-395.2484,178.5945,0,0,0,0,100,0),
+(@PATH,28,4685.155,-395.7484,179.3445,0,0,0,0,100,0),
+(@PATH,29,4685.285,-395.9227,179.333,0,0,0,0,100,0),
+(@PATH,30,4685.785,-395.9227,179.333,0,0,0,0,100,0),
+(@PATH,31,4687.56,-403.8329,179.7082,0,0,0,0,100,0),
+(@PATH,32,4681.06,-406.0829,179.2082,0,0,0,0,100,0),
+(@PATH,33,4678.31,-406.8329,178.7082,0,0,0,0,100,0),
+(@PATH,34,4677.956,-407.2584,178.4327,0,0,0,0,100,0),
+(@PATH,35,4676.456,-407.7584,178.1827,0,0,0,0,100,0),
+(@PATH,36,4674.706,-408.0084,177.4327,0,0,0,0,100,0),
+(@PATH,37,4672.706,-408.2584,176.4327,0,0,0,0,100,0),
+(@PATH,38,4670.706,-408.5084,175.4327,0,0,0,0,100,0),
+(@PATH,39,4668.706,-409.0084,174.6827,0,0,0,0,100,0),
+(@PATH,40,4665.706,-409.5084,174.1827,0,0,0,0,100,0),
+(@PATH,41,4663.706,-409.7584,173.4327,0,0,0,0,100,0),
+(@PATH,42,4661.956,-409.7584,172.9327,0,0,0,0,100,0),
+(@PATH,43,4659.956,-410.2584,172.1827,0,0,0,0,100,0),
+(@PATH,44,4657.956,-410.5084,171.6827,0,0,0,0,100,0),
+(@PATH,45,4655.956,-410.7584,170.9327,0,0,0,0,100,0),
+(@PATH,46,4654.206,-411.0084,170.1827,0,0,0,0,100,0),
+(@PATH,47,4652.206,-411.5084,169.6827,0,0,0,0,100,0),
+(@PATH,48,4650.206,-411.7584,168.9327,0,0,0,0,100,0),
+(@PATH,49,4646.206,-412.5084,168.1827,0,0,0,0,100,0);
+
+-- 12. Onslaught Death Knight
+SET @NPC := 117853;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4673.927,`position_y`=-465.8671,`position_z`=175.9483 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,10719,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,4673.927,-465.8671,175.9483,0,0,0,0,100,0),
+(@PATH,2,4674.057,-465.5458,176.4839,0,0,0,0,100,0),
+(@PATH,3,4675.307,-462.7958,176.7339,0,0,0,0,100,0),
+(@PATH,4,4679.307,-453.0458,177.2339,0,0,0,0,100,0),
+(@PATH,5,4682.046,-446.772,178.1347,0,0,0,0,100,0),
+(@PATH,6,4684.296,-444.772,178.3847,0,0,0,0,100,0),
+(@PATH,7,4687.046,-442.272,179.1347,0,0,0,0,100,0),
+(@PATH,8,4690.046,-439.772,179.8847,0,0,0,0,100,0),
+(@PATH,9,4687.49,-442.0988,179.0242,0,0,0,0,100,0),
+(@PATH,10,4683.99,-445.0988,178.5242,0,0,0,0,100,0),
+(@PATH,11,4682.49,-446.3488,178.0242,0,0,0,0,100,0),
+(@PATH,12,4682.049,-446.586,177.8403,0,0,0,0,100,0),
+(@PATH,13,4681.799,-446.836,177.8403,0,0,0,0,100,0),
+(@PATH,14,4679.049,-453.336,177.0903,0,0,0,0,100,0),
+(@PATH,15,4675.049,-463.336,176.5903,0,0,0,0,100,0),
+(@PATH,16,4674.158,-465.8684,176.1417,0,0,0,0,100,0);
+
+-- 13. Onslaught Death Knight
+SET @NPC := 117837;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4562.605,`position_y`=-482.3372,`position_z`=130.0714 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,10719,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,4562.605,-482.3372,130.0714,0,0,0,0,100,0),
+(@PATH,2,4563.605,-482.5872,131.0714,0,0,0,0,100,0),
+(@PATH,3,4565.605,-483.0872,132.3214,0,0,0,0,100,0),
+(@PATH,4,4567.355,-483.5872,133.8214,0,0,0,0,100,0),
+(@PATH,5,4569.355,-484.0872,135.5714,0,0,0,0,100,0),
+(@PATH,6,4571.355,-484.5872,137.0714,0,0,0,0,100,0),
+(@PATH,7,4572.855,-485.0872,138.5714,0,0,0,0,100,0),
+(@PATH,8,4574.855,-485.3372,139.5714,0,0,0,0,100,0),
+(@PATH,9,4576.855,-486.0872,141.0714,0,0,0,0,100,0),
+(@PATH,10,4578.855,-486.5872,142.5714,0,0,0,0,100,0),
+(@PATH,11,4580.605,-487.0872,143.8214,0,0,0,0,100,0),
+(@PATH,12,4580.711,-487.1699,143.7785,0,0,0,0,100,0),
+(@PATH,13,4578.711,-486.4199,142.5285,0,0,0,0,100,0),
+(@PATH,14,4576.711,-485.9199,141.0285,0,0,0,0,100,0),
+(@PATH,15,4574.961,-485.4199,139.5285,0,0,0,0,100,0),
+(@PATH,16,4572.211,-484.9199,138.0285,0,0,0,0,100,0),
+(@PATH,17,4570.211,-484.4199,136.7785,0,0,0,0,100,0),
+(@PATH,18,4568.461,-483.9199,134.7785,0,0,0,0,100,0),
+(@PATH,19,4566.461,-483.1699,133.0285,0,0,0,0,100,0),
+(@PATH,20,4564.461,-482.6699,131.5285,0,0,0,0,100,0),
+(@PATH,21,4566.122,-483.1504,132.8683,0,0,0,0,100,0),
+(@PATH,22,4564.372,-482.4004,131.3683,0,0,0,0,100,0),
+(@PATH,23,4563.372,-482.1504,130.8683,0,0,0,0,100,0),
+(@PATH,24,4562.372,-482.1504,129.8683,0,0,0,0,100,0),
+(@PATH,25,4561.372,-482.1504,129.1183,0,0,0,0,100,0),
+(@PATH,26,4560.372,-482.1504,128.1183,0,0,0,0,100,0),
+(@PATH,27,4559.372,-482.1504,127.6183,0,0,0,0,100,0),
+(@PATH,28,4557.372,-482.1504,126.8683,0,0,0,0,100,0),
+(@PATH,29,4556.372,-481.9004,126.1183,0,0,0,0,100,0),
+(@PATH,30,4555.372,-481.9004,125.3683,0,0,0,0,100,0),
+(@PATH,31,4554.372,-481.9004,124.8683,0,0,0,0,100,0),
+(@PATH,32,4553.372,-481.9004,124.3683,0,0,0,0,100,0),
+(@PATH,33,4552.622,-481.6504,123.6183,0,0,0,0,100,0),
+(@PATH,34,4550.622,-481.6504,122.6183,0,0,0,0,100,0),
+(@PATH,35,4549.622,-481.6504,122.1183,0,0,0,0,100,0),
+(@PATH,36,4548.622,-481.4004,121.3683,0,0,0,0,100,0),
+(@PATH,37,4546.622,-481.4004,120.6183,0,0,0,0,100,0),
+(@PATH,38,4544.622,-481.1504,119.6183,0,0,0,0,100,0),
+(@PATH,39,4543.622,-481.1504,118.3683,0,0,0,0,100,0),
+(@PATH,40,4540.622,-480.9004,117.3683,0,0,0,0,100,0),
+(@PATH,55,4561.372,-482.1504,129.1183,0,0,0,0,100,0),
+(@PATH,54,4560.372,-482.1504,128.1183,0,0,0,0,100,0),
+(@PATH,53,4559.372,-482.1504,127.6183,0,0,0,0,100,0),
+(@PATH,52,4557.372,-482.1504,126.8683,0,0,0,0,100,0),
+(@PATH,51,4556.372,-481.9004,126.1183,0,0,0,0,100,0),
+(@PATH,50,4555.372,-481.9004,125.3683,0,0,0,0,100,0),
+(@PATH,49,4554.372,-481.9004,124.8683,0,0,0,0,100,0),
+(@PATH,48,4553.372,-481.9004,124.3683,0,0,0,0,100,0),
+(@PATH,47,4552.622,-481.6504,123.6183,0,0,0,0,100,0),
+(@PATH,46,4550.622,-481.6504,122.6183,0,0,0,0,100,0),
+(@PATH,45,4549.622,-481.6504,122.1183,0,0,0,0,100,0),
+(@PATH,44,4548.622,-481.4004,121.3683,0,0,0,0,100,0),
+(@PATH,43,4546.622,-481.4004,120.6183,0,0,0,0,100,0),
+(@PATH,42,4544.622,-481.1504,119.6183,0,0,0,0,100,0),
+(@PATH,41,4543.622,-481.1504,118.3683,0,0,0,0,100,0);
+
+-- 14. Onslaught Death Knight
+SET @NPC := 117855;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4591.347,`position_y`=-453.3334,`position_z`=146.8176 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,10719,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,4591.347,-453.3334,146.8176,0,0,0,0,100,0),
+(@PATH,2,4593.286,-447.2549,146.5961,0,0,0,0,100,0),
+(@PATH,3,4593.286,-443.2549,145.8461,0,0,0,0,100,0),
+(@PATH,4,4593.286,-438.5049,145.3461,0,0,0,0,100,0),
+(@PATH,5,4593.036,-431.5049,145.0961,0,0,0,0,100,0),
+(@PATH,6,4593.392,-428.4322,144.6565,0,0,0,0,100,0),
+(@PATH,7,4595.142,-426.1822,145.6565,0,0,0,0,100,0),
+(@PATH,8,4597.142,-423.6822,146.6565,0,0,0,0,100,0),
+(@PATH,9,4599.642,-420.6822,147.4065,0,0,0,0,100,0),
+(@PATH,10,4602.142,-417.9322,148.1565,0,0,0,0,100,0),
+(@PATH,11,4604.642,-414.9322,148.9065,0,0,0,0,100,0),
+(@PATH,12,4606.642,-412.6822,149.9065,0,0,0,0,100,0),
+(@PATH,13,4608.392,-410.1822,150.9065,0,0,0,0,100,0),
+(@PATH,14,4608.691,-409.937,151.0649,0,0,0,0,100,0),
+(@PATH,15,4609.941,-408.687,151.3149,0,0,0,0,100,0),
+(@PATH,16,4613.441,-406.437,152.5649,0,0,0,0,100,0),
+(@PATH,17,4615.691,-405.187,153.8149,0,0,0,0,100,0),
+(@PATH,18,4618.191,-403.687,154.5649,0,0,0,0,100,0),
+(@PATH,19,4621.691,-401.687,156.0649,0,0,0,0,100,0),
+(@PATH,20,4620.293,-402.3251,155.5382,0,0,0,0,100,0),
+(@PATH,21,4617.043,-404.3251,154.0382,0,0,0,0,100,0),
+(@PATH,22,4614.543,-405.8251,152.7882,0,0,0,0,100,0),
+(@PATH,23,4611.293,-407.8251,151.7882,0,0,0,0,100,0),
+(@PATH,24,4609.751,-408.8759,151.0355,0,0,0,0,100,0),
+(@PATH,25,4607.751,-411.1259,150.2855,0,0,0,0,100,0),
+(@PATH,26,4605.751,-413.3759,149.0355,0,0,0,0,100,0),
+(@PATH,27,4604.001,-415.8759,148.2855,0,0,0,0,100,0),
+(@PATH,28,4602.001,-418.1259,147.7855,0,0,0,0,100,0),
+(@PATH,29,4599.001,-421.6259,146.7855,0,0,0,0,100,0),
+(@PATH,30,4597.001,-423.8759,146.0355,0,0,0,0,100,0),
+(@PATH,31,4594.501,-427.1259,145.2855,0,0,0,0,100,0),
+(@PATH,32,4594.465,-427.3057,145.1041,0,0,0,0,100,0),
+(@PATH,33,4593.215,-428.5557,144.6041,0,0,0,0,100,0),
+(@PATH,34,4593.465,-434.5557,145.3541,0,0,0,0,100,0),
+(@PATH,35,4593.465,-440.3057,145.8541,0,0,0,0,100,0),
+(@PATH,36,4593.465,-445.3057,146.3541,0,0,0,0,100,0);
+
+-- 15. Onslaught Raven Archon
+SET @NPC := 117138;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4724.406,`position_y`=-356.798,`position_z`=181.8883 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,4724.406,-356.798,181.8883,0,0,0,0,100,0),
+(@PATH,2,4717.824,-372.1068,181.2777,0,0,0,0,100,0),
+(@PATH,3,4712.074,-377.1068,180.7777,0,0,0,0,100,0),
+(@PATH,4,4709.574,-379.1068,180.2777,0,0,0,0,100,0),
+(@PATH,5,4710.34,-378.5876,180.2192,0,0,0,0,100,0),
+(@PATH,6,4713.34,-376.0876,180.9692,0,0,0,0,100,0),
+(@PATH,7,4718.058,-372.0478,181.2572,0,0,0,0,100,0),
+(@PATH,8,4721.808,-363.0478,182.0072,0,0,0,0,100,0),
+(@PATH,9,4724.464,-356.5519,181.7701,0,0,0,0,100,0),
+(@PATH,10,4722.449,-346.1371,182.0739,0,0,0,0,100,0),
+(@PATH,11,4728.199,-335.8871,182.5739,0,0,0,0,100,0),
+(@PATH,12,4722.129,-346.2792,181.8653,0,0,0,0,100,0),
+(@PATH,13,4722.348,-346.2967,182.047,0,0,0,0,100,0),
+(@PATH,14,4724.397,-356.7561,181.8892,0,0,0,0,100,0);
+
+-- 16. Onslaught Death Knight
+SET @NPC := 117832;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4775.135,`position_y`=-303.4818,`position_z`=196.1635 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,10719,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,4775.135,-303.4818,196.1635,0,0,0,0,100,0),
+(@PATH,2,4774.385,-303.9818,195.6635,0,0,0,0,100,0),
+(@PATH,3,4773.885,-303.9818,195.1635,0,0,0,0,100,0),
+(@PATH,4,4773.885,-305.9818,194.9135,0,0,0,0,100,0),
+(@PATH,5,4773.885,-309.9818,194.1635,0,0,0,0,100,0),
+(@PATH,6,4773.885,-311.9818,193.4135,0,0,0,0,100,0),
+(@PATH,7,4773.885,-314.9818,192.6635,0,0,0,0,100,0),
+(@PATH,8,4774.135,-323.9818,193.4135,0,0,0,0,100,0),
+(@PATH,9,4774.135,-332.7318,192.6635,0,0,0,0,100,0),
+(@PATH,10,4774.135,-333.7318,193.6635,0,0,0,0,100,0),
+(@PATH,11,4774.325,-344.7158,193.9453,0,0,0,0,100,0),
+(@PATH,12,4775.325,-344.7158,194.9453,0,0,0,0,100,0),
+(@PATH,13,4776.325,-344.7158,195.4453,0,0,0,0,100,0),
+(@PATH,14,4777.325,-344.7158,196.1953,0,0,0,0,100,0),
+(@PATH,15,4779.075,-344.7158,196.6953,0,0,0,0,100,0),
+(@PATH,16,4780.075,-344.7158,197.1953,0,0,0,0,100,0),
+(@PATH,17,4781.075,-344.7158,198.1953,0,0,0,0,100,0),
+(@PATH,18,4782.075,-344.7158,198.9453,0,0,0,0,100,0),
+(@PATH,19,4783.075,-344.7158,199.6953,0,0,0,0,100,0),
+(@PATH,20,4783.273,-344.7045,200.0436,0,0,0,0,100,0),
+(@PATH,21,4784.023,-344.7045,200.7936,0,0,0,0,100,0),
+(@PATH,22,4784.273,-341.7045,201.5436,0,0,0,0,100,0),
+(@PATH,23,4784.273,-338.7045,202.0436,0,0,0,0,100,0),
+(@PATH,24,4784.273,-336.7045,203.0436,0,0,0,0,100,0),
+(@PATH,25,4784.523,-334.7045,203.7936,0,0,0,0,100,0),
+(@PATH,26,4784.523,-331.7045,204.2936,0,0,0,0,100,0),
+(@PATH,27,4784.773,-323.7045,203.7936,0,0,0,0,100,0),
+(@PATH,28,4785.273,-312.9545,204.2936,0,0,0,0,100,0),
+(@PATH,29,4785.523,-308.9545,205.5436,0,0,0,0,100,0),
+(@PATH,30,4785.523,-302.9545,206.0436,0,0,0,0,100,0),
+(@PATH,31,4785.646,-300.5979,206.2332,0,0,0,0,100,0),
+(@PATH,32,4784.646,-300.8479,205.4832,0,0,0,0,100,0),
+(@PATH,33,4783.896,-301.0979,204.4832,0,0,0,0,100,0),
+(@PATH,34,4782.896,-301.3479,203.4832,0,0,0,0,100,0),
+(@PATH,35,4781.896,-301.5979,202.7332,0,0,0,0,100,0),
+(@PATH,36,4780.896,-301.8479,201.7332,0,0,0,0,100,0),
+(@PATH,37,4779.896,-302.0979,200.4832,0,0,0,0,100,0),
+(@PATH,38,4779.146,-302.3479,199.7332,0,0,0,0,100,0),
+(@PATH,39,4778.396,-302.8479,198.4832,0,0,0,0,100,0),
+(@PATH,40,4777.396,-303.0979,197.7332,0,0,0,0,100,0),
+(@PATH,41,4775.396,-303.3479,196.4832,0,0,0,0,100,0);
+
+-- 17. Onslaught Death Knight
+SET @NPC := 117839;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4716.436,`position_y`=-400.944,`position_z`=185.0362 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,10719,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,4716.436,-400.944,185.0362,0,0,0,0,100,0),
+(@PATH,2,4717.936,-397.444,185.5362,0,0,0,0,100,0),
+(@PATH,3,4721.186,-389.194,186.0362,0,0,0,0,100,0),
+(@PATH,4,4723.422,-384.276,186.1633,0,0,0,0,100,0),
+(@PATH,5,4735.376,-367.9473,186.7946,0,0,0,0,100,0),
+(@PATH,6,4737.126,-365.4473,187.5446,0,0,0,0,100,0),
+(@PATH,7,4739.126,-362.1973,188.0446,0,0,0,0,100,0),
+(@PATH,8,4740.876,-359.9473,188.5446,0,0,0,0,100,0),
+(@PATH,9,4742.458,-357.7573,189.1335,0,0,0,0,100,0),
+(@PATH,10,4744.458,-358.0073,189.8835,0,0,0,0,100,0),
+(@PATH,11,4746.458,-358.2573,190.6335,0,0,0,0,100,0),
+(@PATH,12,4748.458,-358.2573,190.8835,0,0,0,0,100,0),
+(@PATH,13,4750.208,-358.5073,191.6335,0,0,0,0,100,0),
+(@PATH,14,4752.208,-358.7573,192.1335,0,0,0,0,100,0),
+(@PATH,15,4755.208,-359.0073,192.8835,0,0,0,0,100,0),
+(@PATH,16,4755.139,-358.7617,192.7538,0,0,0,0,100,0),
+(@PATH,17,4752.139,-358.5117,192.2538,0,0,0,0,100,0),
+(@PATH,18,4750.139,-358.5117,191.5038,0,0,0,0,100,0),
+(@PATH,19,4748.389,-358.2617,191.0038,0,0,0,0,100,0),
+(@PATH,20,4746.389,-358.2617,190.5038,0,0,0,0,100,0),
+(@PATH,21,4744.389,-358.0117,189.7538,0,0,0,0,100,0),
+(@PATH,22,4744.068,-358.0636,189.5123,0,0,0,0,100,0),
+(@PATH,23,4742.068,-357.8136,188.7623,0,0,0,0,100,0),
+(@PATH,24,4740.568,-360.3136,188.2623,0,0,0,0,100,0),
+(@PATH,25,4738.568,-363.3136,187.7623,0,0,0,0,100,0),
+(@PATH,26,4736.318,-366.5636,187.2623,0,0,0,0,100,0),
+(@PATH,27,4736.031,-366.8282,186.9275,0,0,0,0,100,0),
+(@PATH,28,4735.031,-368.0782,186.6775,0,0,0,0,100,0),
+(@PATH,29,4732.281,-372.0782,186.1775,0,0,0,0,100,0),
+(@PATH,30,4723.25,-384.6306,186.0191,0,0,0,0,100,0),
+(@PATH,31,4718.75,-395.3806,185.5191,0,0,0,0,100,0),
+(@PATH,32,4716.201,-400.9923,185.1606,0,0,0,0,100,0),
+(@PATH,33,4718.451,-402.9923,185.6606,0,0,0,0,100,0),
+(@PATH,34,4722.451,-405.9923,186.6606,0,0,0,0,100,0),
+(@PATH,35,4734.701,-415.7423,187.4106,0,0,0,0,100,0),
+(@PATH,36,4735.451,-416.4923,188.4106,0,0,0,0,100,0),
+(@PATH,37,4735.871,-416.6113,188.0563,0,0,0,0,100,0),
+(@PATH,38,4734.871,-415.8613,187.3063,0,0,0,0,100,0),
+(@PATH,39,4734.121,-415.3613,186.8063,0,0,0,0,100,0),
+(@PATH,40,4731.871,-413.3613,185.8063,0,0,0,0,100,0),
+(@PATH,41,4730.371,-412.1113,186.5563,0,0,0,0,100,0),
+(@PATH,42,4718.871,-403.1113,185.8063,0,0,0,0,100,0),
+(@PATH,43,4716.524,-401.1166,185.1767,0,0,0,0,100,0);
+
+-- 18. Onslaught Death Knight
+SET @NPC := 117851;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4705.714,`position_y`=-320.1843,`position_z`=176.6997 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,10719,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,4705.714,-320.1843,176.6997,0,0,0,0,100,0),
+(@PATH,2,4706.964,-320.9343,177.1997,0,0,0,0,100,0),
+(@PATH,3,4707.714,-323.6843,177.6997,0,0,0,0,100,0),
+(@PATH,4,4708.464,-325.4343,178.4497,0,0,0,0,100,0),
+(@PATH,5,4709.69,-328.5651,179.3957,0,0,0,0,100,0),
+(@PATH,6,4703.855,-338.3154,179.2477,0,0,0,0,100,0),
+(@PATH,7,4702.105,-337.5654,178.4977,0,0,0,0,100,0),
+(@PATH,8,4699.355,-336.3154,177.7477,0,0,0,0,100,0),
+(@PATH,9,4696.605,-335.0654,177.2477,0,0,0,0,100,0),
+(@PATH,10,4679.237,-327.8691,176.4677,0,0,0,0,100,0),
+(@PATH,11,4679.204,-327.8438,176.4087,0,0,0,0,100,0),
+(@PATH,12,4679.519,-327.856,176.9473,0,0,0,0,100,0),
+(@PATH,13,4696.519,-335.106,177.4473,0,0,0,0,100,0),
+(@PATH,14,4699.269,-336.356,177.6973,0,0,0,0,100,0),
+(@PATH,15,4701.269,-337.106,178.1973,0,0,0,0,100,0),
+(@PATH,16,4701.459,-337.2228,178.4309,0,0,0,0,100,0),
+(@PATH,17,4704.209,-338.4728,179.1809,0,0,0,0,100,0),
+(@PATH,18,4709.626,-328.3861,179.4376,0,0,0,0,100,0),
+(@PATH,19,4708.876,-326.6361,178.6876,0,0,0,0,100,0),
+(@PATH,20,4708.126,-324.8861,177.9376,0,0,0,0,100,0),
+(@PATH,21,4707.126,-322.1361,177.4376,0,0,0,0,100,0),
+(@PATH,22,4707.211,-321.6881,177.3876,0,0,0,0,100,0),
+(@PATH,23,4706.711,-320.6881,176.8876,0,0,0,0,100,0),
+(@PATH,24,4704.961,-319.6881,176.3876,0,0,0,0,100,0),
+(@PATH,25,4702.461,-318.1881,175.3876,0,0,0,0,100,0),
+(@PATH,26,4700.711,-317.1881,174.6376,0,0,0,0,100,0),
+(@PATH,27,4698.961,-316.1881,173.8876,0,0,0,0,100,0),
+(@PATH,28,4696.211,-315.1881,173.1376,0,0,0,0,100,0),
+(@PATH,29,4694.711,-314.1881,172.3876,0,0,0,0,100,0),
+(@PATH,30,4692.211,-312.6881,171.8876,0,0,0,0,100,0),
+(@PATH,31,4690.461,-311.6881,171.1376,0,0,0,0,100,0),
+(@PATH,32,4688.711,-310.6881,170.1376,0,0,0,0,100,0),
+(@PATH,33,4686.961,-309.6881,169.6376,0,0,0,0,100,0),
+(@PATH,34,4684.461,-308.1881,167.8876,0,0,0,0,100,0),
+(@PATH,35,4682.711,-307.1881,167.3876,0,0,0,0,100,0),
+(@PATH,36,4684.099,-307.9991,167.579,0,0,0,0,100,0),
+(@PATH,37,4682.349,-306.9991,167.079,0,0,0,0,100,0),
+(@PATH,38,4681.849,-306.7491,166.829,0,0,0,0,100,0),
+(@PATH,39,4679.849,-306.4991,165.829,0,0,0,0,100,0),
+(@PATH,40,4677.849,-306.2491,165.079,0,0,0,0,100,0),
+(@PATH,41,4675.099,-305.7491,163.829,0,0,0,0,100,0),
+(@PATH,42,4672.349,-305.2491,162.829,0,0,0,0,100,0),
+(@PATH,43,4670.349,-304.7491,162.079,0,0,0,0,100,0),
+(@PATH,44,4668.349,-304.4991,161.579,0,0,0,0,100,0),
+(@PATH,45,4666.349,-303.9991,160.579,0,0,0,0,100,0),
+(@PATH,46,4666.279,-304.1193,160.5885,0,0,0,0,100,0),
+(@PATH,47,4669.279,-304.6193,161.8385,0,0,0,0,100,0),
+(@PATH,48,4671.279,-305.1193,162.5885,0,0,0,0,100,0),
+(@PATH,49,4673.029,-305.3693,163.3385,0,0,0,0,100,0),
+(@PATH,50,4676.029,-305.6193,164.0885,0,0,0,0,100,0),
+(@PATH,51,4678.029,-306.1193,165.0885,0,0,0,0,100,0),
+(@PATH,52,4680.029,-306.3693,165.8385,0,0,0,0,100,0),
+(@PATH,53,4680.176,-306.6355,166.1882,0,0,0,0,100,0),
+(@PATH,54,4682.176,-306.8855,166.9382,0,0,0,0,100,0),
+(@PATH,55,4684.676,-308.3855,168.6882,0,0,0,0,100,0),
+(@PATH,56,4686.426,-309.3855,169.4382,0,0,0,0,100,0),
+(@PATH,57,4688.176,-310.3855,170.1882,0,0,0,0,100,0),
+(@PATH,58,4689.926,-311.3855,170.9382,0,0,0,0,100,0),
+(@PATH,59,4691.676,-312.3855,171.1882,0,0,0,0,100,0),
+(@PATH,60,4693.176,-313.3855,171.9382,0,0,0,0,100,0),
+(@PATH,61,4694.926,-314.1355,172.9382,0,0,0,0,100,0),
+(@PATH,62,4697.676,-315.6355,173.6882,0,0,0,0,100,0),
+(@PATH,63,4699.426,-316.6355,174.4382,0,0,0,0,100,0),
+(@PATH,64,4700.926,-317.6355,174.9382,0,0,0,0,100,0),
+(@PATH,65,4703.676,-318.8855,175.6882,0,0,0,0,100,0),
+(@PATH,66,4705.426,-319.8855,176.4382,0,0,0,0,100,0),
+(@PATH,67,4703.938,-319.2475,176.1418,0,0,0,0,100,0);
+
+-- 19. Onslaught Death Knight
+SET @NPC := 117838;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4738.398,`position_y`=-268.4922,`position_z`=170.6809 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,10719,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,4738.398,-268.4922,170.6809,0,0,0,0,100,0),
+(@PATH,2,4738.148,-270.2422,171.6809,0,0,0,0,100,0),
+(@PATH,3,4738.648,-271.2422,172.1809,0,0,0,0,100,0),
+(@PATH,4,4739.148,-271.9922,172.9309,0,0,0,0,100,0),
+(@PATH,5,4740.148,-273.7422,173.6809,0,0,0,0,100,0),
+(@PATH,6,4741.148,-275.4922,174.9309,0,0,0,0,100,0),
+(@PATH,7,4742.148,-277.2422,175.6809,0,0,0,0,100,0),
+(@PATH,8,4743.148,-278.7422,176.4309,0,0,0,0,100,0),
+(@PATH,9,4744.148,-280.4922,177.6809,0,0,0,0,100,0),
+(@PATH,10,4745.148,-282.2422,179.1809,0,0,0,0,100,0),
+(@PATH,11,4746.148,-283.9922,179.9309,0,0,0,0,100,0),
+(@PATH,12,4747.148,-285.4922,180.9309,0,0,0,0,100,0),
+(@PATH,13,4747.233,-285.5703,180.9717,0,0,0,0,100,0),
+(@PATH,14,4747.733,-286.3203,181.4717,0,0,0,0,100,0),
+(@PATH,15,4748.483,-283.3203,180.2217,0,0,0,0,100,0),
+(@PATH,16,4748.733,-281.3203,179.2217,0,0,0,0,100,0),
+(@PATH,17,4749.483,-279.5703,178.4717,0,0,0,0,100,0),
+(@PATH,18,4749.983,-277.8203,177.7217,0,0,0,0,100,0),
+(@PATH,19,4750.483,-275.8203,176.9717,0,0,0,0,100,0),
+(@PATH,20,4751.545,-272.9406,176.0473,0,0,0,0,100,0),
+(@PATH,21,4760.295,-268.6906,175.2973,0,0,0,0,100,0),
+(@PATH,22,4768.045,-264.6906,176.0473,0,0,0,0,100,0),
+(@PATH,23,4768.183,-264.4334,175.7711,0,0,0,0,100,0),
+(@PATH,24,4770.933,-262.9334,176.2711,0,0,0,0,100,0),
+(@PATH,25,4769.183,-260.4334,174.7711,0,0,0,0,100,0),
+(@PATH,26,4768.683,-259.6834,174.2711,0,0,0,0,100,0),
+(@PATH,27,4767.433,-258.1834,173.2711,0,0,0,0,100,0),
+(@PATH,28,4766.183,-256.4334,172.7711,0,0,0,0,100,0),
+(@PATH,29,4765.183,-255.1834,172.0211,0,0,0,0,100,0),
+(@PATH,30,4763.433,-252.6834,171.2711,0,0,0,0,100,0),
+(@PATH,31,4761.683,-250.1834,170.5211,0,0,0,0,100,0),
+(@PATH,32,4760.683,-248.6834,169.5211,0,0,0,0,100,0),
+(@PATH,33,4758.657,-246.4807,168.7377,0,0,0,0,100,0),
+(@PATH,34,4755.907,-247.2307,167.9877,0,0,0,0,100,0),
+(@PATH,35,4753.907,-247.4807,167.2377,0,0,0,0,100,0),
+(@PATH,36,4750.907,-248.2307,166.4877,0,0,0,0,100,0),
+(@PATH,37,4748.407,-248.9807,166.2377,0,0,0,0,100,0),
+(@PATH,38,4745.407,-249.4807,165.4877,0,0,0,0,100,0),
+(@PATH,39,4742.407,-249.9807,164.7377,0,0,0,0,100,0),
+(@PATH,40,4742.154,-250.1919,164.6562,0,0,0,0,100,0),
+(@PATH,41,4740.904,-250.6919,164.4062,0,0,0,0,100,0),
+(@PATH,42,4740.654,-252.4419,165.1562,0,0,0,0,100,0),
+(@PATH,43,4740.404,-255.4419,165.9062,0,0,0,0,100,0),
+(@PATH,44,4740.154,-257.4419,166.6562,0,0,0,0,100,0),
+(@PATH,45,4739.904,-259.4419,167.6562,0,0,0,0,100,0),
+(@PATH,46,4739.654,-261.1919,167.9062,0,0,0,0,100,0),
+(@PATH,47,4739.154,-264.1919,168.9062,0,0,0,0,100,0),
+(@PATH,48,4738.904,-266.1919,169.6562,0,0,0,0,100,0);
+
+-- 20. Onslaught Death Knight
+SET @NPC := 117860;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4696.873,`position_y`=-283.3671,`position_z`=163.6956 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,10719,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,4696.873,-283.3671,163.6956,0,0,0,0,100,0),
+(@PATH,2,4695.873,-281.6171,162.9456,0,0,0,0,100,0),
+(@PATH,3,4695.373,-280.6171,162.4456,0,0,0,0,100,0),
+(@PATH,4,4694.623,-278.8671,161.4456,0,0,0,0,100,0),
+(@PATH,5,4693.373,-276.1171,160.9456,0,0,0,0,100,0),
+(@PATH,6,4692.373,-274.3671,160.1956,0,0,0,0,100,0),
+(@PATH,7,4691.623,-272.6171,159.4456,0,0,0,0,100,0),
+(@PATH,8,4690.123,-270.1171,158.9456,0,0,0,0,100,0),
+(@PATH,9,4689.373,-268.3671,158.4456,0,0,0,0,100,0),
+(@PATH,10,4688.623,-266.6171,157.6956,0,0,0,0,100,0),
+(@PATH,11,4687.373,-263.8671,156.9456,0,0,0,0,100,0),
+(@PATH,12,4686.623,-262.1171,156.1956,0,0,0,0,100,0),
+(@PATH,13,4685.623,-260.1171,155.4456,0,0,0,0,100,0),
+(@PATH,14,4684.373,-257.6171,154.6956,0,0,0,0,100,0),
+(@PATH,15,4684.381,-257.5009,154.6773,0,0,0,0,100,0),
+(@PATH,16,4684.131,-257.0009,154.4273,0,0,0,0,100,0),
+(@PATH,17,4686.131,-256.7509,155.1773,0,0,0,0,100,0),
+(@PATH,18,4688.131,-256.5009,155.9273,0,0,0,0,100,0),
+(@PATH,19,4690.131,-256.5009,156.4273,0,0,0,0,100,0),
+(@PATH,20,4692.631,-256.2509,156.9273,0,0,0,0,100,0),
+(@PATH,21,4696.631,-255.7509,157.6773,0,0,0,0,100,0),
+(@PATH,22,4696.935,-255.8058,157.7687,0,0,0,0,100,0),
+(@PATH,23,4699.935,-255.5558,158.5187,0,0,0,0,100,0),
+(@PATH,24,4701.935,-256.0558,159.0187,0,0,0,0,100,0),
+(@PATH,25,4703.435,-256.8058,159.5187,0,0,0,0,100,0),
+(@PATH,26,4705.435,-257.3058,160.0187,0,0,0,0,100,0),
+(@PATH,27,4708.185,-258.0558,160.7687,0,0,0,0,100,0),
+(@PATH,28,4708.102,-258.0999,160.4381,0,0,0,0,100,0),
+(@PATH,29,4705.352,-257.3499,159.9381,0,0,0,0,100,0),
+(@PATH,30,4702.602,-256.3499,159.4381,0,0,0,0,100,0),
+(@PATH,31,4700.602,-255.5999,158.6881,0,0,0,0,100,0),
+(@PATH,32,4700.52,-255.7942,158.4137,0,0,0,0,100,0),
+(@PATH,33,4699.77,-255.5442,158.1637,0,0,0,0,100,0),
+(@PATH,34,4696.77,-255.7942,157.6637,0,0,0,0,100,0),
+(@PATH,35,4692.77,-256.0442,156.9137,0,0,0,0,100,0),
+(@PATH,36,4690.02,-256.5442,156.4137,0,0,0,0,100,0),
+(@PATH,37,4688.02,-256.5442,155.9137,0,0,0,0,100,0),
+(@PATH,38,4686.02,-256.5442,155.1637,0,0,0,0,100,0),
+(@PATH,39,4686.198,-256.8826,155.1549,0,0,0,0,100,0),
+(@PATH,40,4684.198,-256.8826,154.4049,0,0,0,0,100,0),
+(@PATH,41,4684.948,-258.8826,155.1549,0,0,0,0,100,0),
+(@PATH,42,4685.948,-260.6326,155.9049,0,0,0,0,100,0),
+(@PATH,43,4687.198,-263.3826,156.6549,0,0,0,0,100,0),
+(@PATH,44,4688.198,-265.1326,157.4049,0,0,0,0,100,0),
+(@PATH,45,4688.948,-266.8826,158.1549,0,0,0,0,100,0),
+(@PATH,46,4690.198,-269.6326,158.9049,0,0,0,0,100,0),
+(@PATH,47,4691.198,-271.1326,159.4049,0,0,0,0,100,0),
+(@PATH,48,4691.948,-272.8826,159.9049,0,0,0,0,100,0),
+(@PATH,49,4692.948,-275.6326,160.6549,0,0,0,0,100,0),
+(@PATH,50,4693.948,-277.3826,161.4049,0,0,0,0,100,0),
+(@PATH,51,4694.698,-279.3826,162.1549,0,0,0,0,100,0),
+(@PATH,52,4696.198,-281.8826,162.9049,0,0,0,0,100,0),
+(@PATH,53,4696.171,-282.1349,163.015,0,0,0,0,100,0),
+(@PATH,54,4696.921,-283.6349,163.765,0,0,0,0,100,0),
+(@PATH,55,4692.171,-284.8849,162.765,0,0,0,0,100,0),
+(@PATH,56,4686.671,-286.8849,162.015,0,0,0,0,100,0),
+(@PATH,57,4682.792,-288.4092,162.0146,0,0,0,0,100,0),
+(@PATH,58,4688.542,-286.4092,162.5146,0,0,0,0,100,0),
+(@PATH,59,4693.042,-284.9092,163.0146,0,0,0,0,100,0),
+(@PATH,60,4696.851,-283.3021,163.8536,0,0,0,0,100,0);