DB/Pathing: Dragonblight - Moonrest Gardens (West) + Dragonblight (Spider Corner) + Westwind Refugee Camp + Icemist Village

1 files changed, 1000 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_17_01_world.sql b/sql/updates/world/2015_07_17_01_world.sql
new file mode 100644
index 00000000000..f3246227611
--- /dev/null
+++ b/sql/updates/world/2015_07_17_01_world.sql
@@ -0,0 +1,1000 @@
+-- Dragonblight Pathing - Moonrest Gardens (West) + Dragonblight (Spider Corner) + Westwind Refugee Camp + Icemist Village
+
+-- 1. Mage Hunter 
+SET @NPC := 111816;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3398.48,`position_y`=2385.953,`position_z`=36.96791 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3398.48,`position_y`=2385.953,`position_z`=36.96791 WHERE `guid`=101655;
+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,3398.48,2385.953,36.96791,0,0,0,0,100,0),
+(@PATH,2,3401.48,2385.953,37.46791,0,0,0,0,100,0),
+(@PATH,3,3405.23,2386.703,38.21791,0,0,0,0,100,0),
+(@PATH,4,3408.23,2387.453,38.71791,0,0,0,0,100,0),
+(@PATH,5,3411.98,2387.953,39.21791,0,0,0,0,100,0),
+(@PATH,6,3416.73,2388.703,39.96791,0,0,0,0,100,0),
+(@PATH,7,3420.111,2389.582,40.2216,0,0,0,0,100,0),
+(@PATH,8,3426.361,2397.082,40.7216,0,0,0,0,100,0),
+(@PATH,9,3420.818,2390.56,40.29766,0,0,0,0,100,0),
+(@PATH,10,3420.639,2390.315,40.28303,0,0,0,0,100,0),
+(@PATH,11,3419.639,2389.315,40.03303,0,0,0,0,100,0),
+(@PATH,12,3412.889,2388.315,39.53303,0,0,0,0,100,0),
+(@PATH,13,3409.139,2387.565,38.78303,0,0,0,0,100,0),
+(@PATH,14,3406.139,2387.065,38.53303,0,0,0,0,100,0),
+(@PATH,15,3403.389,2386.315,37.78303,0,0,0,0,100,0),
+(@PATH,16,3403.115,2386.236,37.44974,0,0,0,0,100,0),
+(@PATH,17,3401.115,2385.736,37.19974,0,0,0,0,100,0),
+(@PATH,18,3398.115,2385.736,36.69974,0,0,0,0,100,0),
+(@PATH,19,3395.115,2385.486,36.44974,0,0,0,0,100,0),
+(@PATH,20,3378.246,2384.808,35.97441,0,0,0,0,100,0),
+(@PATH,21,3367.431,2398.19,36.2583,0,0,0,0,100,0),
+(@PATH,22,3359.181,2400.69,35.7583,0,0,0,0,100,0),
+(@PATH,23,3350.305,2403.719,35.24155,0,0,0,0,100,0),
+(@PATH,24,3343.305,2403.969,34.74155,0,0,0,0,100,0),
+(@PATH,25,3332.555,2404.719,34.24155,0,0,0,0,100,0),
+(@PATH,26,3325.954,2405.085,34.04697,0,0,0,0,100,0),
+(@PATH,27,3319.204,2400.835,33.29697,0,0,0,0,100,0),
+(@PATH,28,3310.688,2395.802,32.79107,0,0,0,0,100,0),
+(@PATH,29,3308.438,2391.302,32.54107,0,0,0,0,100,0),
+(@PATH,30,3303.938,2381.552,32.79107,0,0,0,0,100,0),
+(@PATH,31,3304.935,2383.488,32.74368,0,0,0,0,100,0),
+(@PATH,32,3305.935,2385.988,32.24368,0,0,0,0,100,0),
+(@PATH,33,3308.935,2392.488,32.74368,0,0,0,0,100,0),
+(@PATH,34,3310.917,2395.979,33.09729,0,0,0,0,100,0),
+(@PATH,35,3323.417,2403.729,33.59729,0,0,0,0,100,0),
+(@PATH,36,3326.055,2404.98,34.22229,0,0,0,0,100,0),
+(@PATH,37,3335.055,2404.48,34.22229,0,0,0,0,100,0),
+(@PATH,38,3344.805,2403.98,34.97229,0,0,0,0,100,0),
+(@PATH,39,3350.72,2403.613,35.48509,0,0,0,0,100,0),
+(@PATH,40,3360.72,2400.363,35.98509,0,0,0,0,100,0),
+(@PATH,41,3367.74,2397.95,36.39144,0,0,0,0,100,0),
+(@PATH,42,3378.364,2384.864,36.23125,0,0,0,0,100,0),
+(@PATH,43,3398.114,2385.864,36.73125,0,0,0,0,100,0),
+(@PATH,44,3398.355,2385.972,36.98199,0,0,0,0,100,0),
+(@PATH,45,3401.355,2385.972,37.48199,0,0,0,0,100,0),
+(@PATH,46,3405.355,2386.722,38.23199,0,0,0,0,100,0),
+(@PATH,47,3408.355,2387.472,38.73199,0,0,0,0,100,0),
+(@PATH,48,3411.855,2387.972,39.23199,0,0,0,0,100,0),
+(@PATH,49,3416.855,2388.722,39.98199,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=111816;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(111816, 111816, 0, 0, 2, 0, 0),
+(111816, 101655, 3, 90, 2, 0, 0);
+
+-- 2. Highborne
+SET @NPC := 103778;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3445.721,`position_y`=2442.673,`position_z`=41.16454 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,3445.721,2442.673,41.16454,0,0,0,0,100,0),
+(@PATH,2,3443.471,2446.173,41.66454,0,0,0,0,100,0),
+(@PATH,3,3440.721,2450.173,42.16454,0,0,0,0,100,0),
+(@PATH,4,3440.507,2450.386,42.38283,0,0,0,0,100,0),
+(@PATH,5,3440.007,2451.386,42.38283,0,0,0,0,100,0),
+(@PATH,6,3439.007,2457.886,42.88283,0,0,0,0,100,0),
+(@PATH,7,3437.199,2467.781,43.53942,0,0,0,0,100,0),
+(@PATH,8,3437.199,2472.781,44.28942,0,0,0,0,100,0),
+(@PATH,9,3437.199,2475.531,44.53942,0,0,0,0,100,0),
+(@PATH,10,3437.199,2479.531,45.28942,0,0,0,0,100,0),
+(@PATH,11,3436.949,2482.531,45.78942,0,0,0,0,100,0),
+(@PATH,12,3436.844,2481.971,45.62006,0,0,0,0,100,0),
+(@PATH,13,3436.844,2477.971,44.87006,0,0,0,0,100,0),
+(@PATH,14,3436.844,2474.221,44.37006,0,0,0,0,100,0),
+(@PATH,15,3436.844,2469.221,43.87006,0,0,0,0,100,0),
+(@PATH,16,3437.134,2468.921,43.51585,0,0,0,0,100,0),
+(@PATH,17,3437.134,2467.671,43.26585,0,0,0,0,100,0),
+(@PATH,18,3438.884,2456.921,42.76585,0,0,0,0,100,0),
+(@PATH,19,3440.066,2451.018,42.22508,0,0,0,0,100,0),
+(@PATH,20,3442.316,2447.768,41.72508,0,0,0,0,100,0),
+(@PATH,21,3445.066,2443.518,41.22508,0,0,0,0,100,0);
+
+-- 3. Mage Hunter
+SET @NPC := 111807;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3522.275,`position_y`=2693.719,`position_z`=79.34184 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3522.275,`position_y`=2693.719,`position_z`=79.34184 WHERE `guid`=101650;
+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,3522.275,2693.719,79.34184,0,0,0,0,100,0),
+(@PATH,2,3522.775,2693.469,79.34184,0,0,0,0,100,0),
+(@PATH,3,3531.775,2681.969,79.84184,0,0,0,0,100,0),
+(@PATH,4,3537.525,2674.969,80.34184,0,0,0,0,100,0),
+(@PATH,5,3540.025,2671.969,81.09184,0,0,0,0,100,0),
+(@PATH,6,3539.886,2671.632,81.27582,0,0,0,0,100,0),
+(@PATH,7,3540.386,2671.132,81.27582,0,0,0,0,100,0),
+(@PATH,8,3539.636,2666.132,81.52582,0,0,0,0,100,0),
+(@PATH,9,3538.136,2659.382,82.27582,0,0,0,0,100,0),
+(@PATH,10,3536.136,2647.632,82.77582,0,0,0,0,100,0),
+(@PATH,11,3536.117,2647.366,83.16013,0,0,0,0,100,0),
+(@PATH,12,3535.867,2645.616,83.16013,0,0,0,0,100,0),
+(@PATH,13,3539.117,2641.866,83.91013,0,0,0,0,100,0),
+(@PATH,14,3542.367,2638.366,84.41013,0,0,0,0,100,0),
+(@PATH,15,3545.867,2633.866,84.91013,0,0,0,0,100,0),
+(@PATH,16,3549.28,2630.162,85.49553,0,0,0,0,100,0),
+(@PATH,17,3554.28,2630.662,86.24553,0,0,0,0,100,0),
+(@PATH,18,3558.28,2630.912,86.74553,0,0,0,0,100,0),
+(@PATH,19,3561.03,2631.162,87.24553,0,0,0,0,100,0),
+(@PATH,20,3564.03,2631.412,87.99553,0,0,0,0,100,0),
+(@PATH,21,3567.03,2631.662,88.49553,0,0,0,0,100,0),
+(@PATH,22,3570.119,2631.86,88.94333,0,0,0,0,100,0),
+(@PATH,23,3579.619,2634.36,89.19333,0,0,0,0,100,0),
+(@PATH,24,3584.369,2635.61,89.94333,0,0,0,0,100,0),
+(@PATH,25,3586.95,2636.361,90.40396,0,0,0,0,100,0),
+(@PATH,26,3590.95,2633.361,90.90396,0,0,0,0,100,0),
+(@PATH,27,3593.2,2631.861,91.40396,0,0,0,0,100,0),
+(@PATH,28,3596.7,2629.611,92.15396,0,0,0,0,100,0),
+(@PATH,29,3596.887,2629.292,92.26752,0,0,0,0,100,0),
+(@PATH,30,3597.137,2629.042,92.51752,0,0,0,0,100,0),
+(@PATH,31,3599.137,2622.292,93.01752,0,0,0,0,100,0),
+(@PATH,32,3601.137,2616.042,93.76752,0,0,0,0,100,0),
+(@PATH,33,3602.387,2612.042,94.51752,0,0,0,0,100,0),
+(@PATH,34,3602.23,2611.948,94.47756,0,0,0,0,100,0),
+(@PATH,35,3602.73,2610.948,94.72756,0,0,0,0,100,0),
+(@PATH,36,3598.98,2604.948,93.72756,0,0,0,0,100,0),
+(@PATH,37,3596.73,2601.948,92.72756,0,0,0,0,100,0),
+(@PATH,38,3593.73,2596.698,92.47756,0,0,0,0,100,0),
+(@PATH,39,3588.981,2589.709,91.71022,0,0,0,0,100,0),
+(@PATH,40,3585.481,2587.959,91.21022,0,0,0,0,100,0),
+(@PATH,41,3580.731,2585.959,90.46022,0,0,0,0,100,0),
+(@PATH,42,3574.731,2583.209,89.71022,0,0,0,0,100,0),
+(@PATH,43,3570.981,2581.709,89.21022,0,0,0,0,100,0),
+(@PATH,44,3566.481,2579.459,88.71022,0,0,0,0,100,0),
+(@PATH,45,3561.981,2577.459,87.96022,0,0,0,0,100,0),
+(@PATH,46,3559.718,2576.175,87.39313,0,0,0,0,100,0),
+(@PATH,47,3556.968,2575.425,86.64313,0,0,0,0,100,0),
+(@PATH,48,3554.968,2574.675,86.14313,0,0,0,0,100,0),
+(@PATH,49,3551.218,2573.425,85.64313,0,0,0,0,100,0),
+(@PATH,50,3548.468,2572.675,85.14313,0,0,0,0,100,0),
+(@PATH,51,3543.968,2570.925,84.39313,0,0,0,0,100,0),
+(@PATH,52,3538.407,2569.265,84.15322,0,0,0,0,100,0),
+(@PATH,53,3531.657,2570.765,84.65322,0,0,0,0,100,0),
+(@PATH,54,3525.907,2571.765,85.15322,0,0,0,0,100,0),
+(@PATH,55,3518.473,2573.881,85.15751,0,0,0,0,100,0),
+(@PATH,56,3514.223,2582.631,84.40751,0,0,0,0,100,0),
+(@PATH,57,3512.223,2587.131,83.90751,0,0,0,0,100,0),
+(@PATH,58,3510.885,2590.054,82.90897,0,0,0,0,100,0),
+(@PATH,59,3511.135,2594.054,82.15897,0,0,0,0,100,0),
+(@PATH,60,3511.385,2599.054,81.40897,0,0,0,0,100,0),
+(@PATH,61,3511.885,2606.804,81.15897,0,0,0,0,100,0),
+(@PATH,62,3512.135,2614.804,80.40897,0,0,0,0,100,0),
+(@PATH,63,3512.385,2620.804,79.65897,0,0,0,0,100,0),
+(@PATH,64,3512.912,2624.713,79.37867,0,0,0,0,100,0),
+(@PATH,65,3518.662,2639.213,79.87867,0,0,0,0,100,0),
+(@PATH,66,3520.162,2642.963,80.37867,0,0,0,0,100,0),
+(@PATH,67,3520.832,2644.793,80.5683,0,0,0,0,100,0),
+(@PATH,68,3513.011,2667.918,80.12206,0,0,0,0,100,0),
+(@PATH,69,3494.297,2674.96,79.83678,0,0,0,0,100,0),
+(@PATH,70,3491.047,2678.71,79.08678,0,0,0,0,100,0),
+(@PATH,71,3474.047,2697.71,78.83678,0,0,0,0,100,0),
+(@PATH,72,3465.572,2707.107,78.88591,0,0,0,0,100,0),
+(@PATH,73,3465.802,2707.374,79.16296,0,0,0,0,100,0),
+(@PATH,74,3471.302,2714.124,78.41296,0,0,0,0,100,0),
+(@PATH,75,3471.464,2714.22,78.28076,0,0,0,0,100,0),
+(@PATH,76,3472.214,2714.97,78.28076,0,0,0,0,100,0),
+(@PATH,77,3484.618,2714.327,78.0071,0,0,0,0,100,0),
+(@PATH,78,3488.118,2712.577,78.5071,0,0,0,0,100,0),
+(@PATH,79,3503.35,2705.185,78.67375,0,0,0,0,100,0),
+(@PATH,80,3505.85,2703.685,78.17375,0,0,0,0,100,0),
+(@PATH,81,3515.85,2697.685,78.67375,0,0,0,0,100,0),
+(@PATH,82,3521.85,2693.935,79.17375,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=111807;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(111807, 111807, 0, 0, 2, 0, 0),
+(111807, 101650, 3, 0, 2, 0, 0);
+
+-- 4. Mage Hunter
+SET @NPC := 111848;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3588.654,`position_y`=2458.734,`position_z`=84.83969 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3588.654,`position_y`=2458.734,`position_z`=84.83969 WHERE `guid`=101689;
+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,3588.654,2458.734,84.83969,0,0,0,0,100,0),
+(@PATH,2,3585.154,2453.984,84.33969,0,0,0,0,100,0),
+(@PATH,3,3580.904,2448.484,83.58969,0,0,0,0,100,0),
+(@PATH,4,3576.654,2443.234,83.08969,0,0,0,0,100,0),
+(@PATH,5,3573.654,2439.234,82.58969,0,0,0,0,100,0),
+(@PATH,6,3571.904,2436.984,82.08969,0,0,0,0,100,0),
+(@PATH,7,3569.833,2434.197,81.29275,0,0,0,0,100,0),
+(@PATH,8,3567.083,2432.697,80.29275,0,0,0,0,100,0),
+(@PATH,9,3565.333,2431.447,79.54275,0,0,0,0,100,0),
+(@PATH,10,3562.833,2429.947,78.79275,0,0,0,0,100,0),
+(@PATH,11,3561.083,2428.947,78.04275,0,0,0,0,100,0),
+(@PATH,12,3558.583,2427.447,77.04275,0,0,0,0,100,0),
+(@PATH,13,3556.833,2426.447,76.29275,0,0,0,0,100,0),
+(@PATH,14,3555.083,2425.447,75.79275,0,0,0,0,100,0),
+(@PATH,15,3552.833,2423.947,75.04275,0,0,0,0,100,0),
+(@PATH,16,3551.083,2422.947,74.29275,0,0,0,0,100,0),
+(@PATH,17,3548.583,2421.447,73.54275,0,0,0,0,100,0),
+(@PATH,18,3546.833,2420.447,73.04275,0,0,0,0,100,0),
+(@PATH,19,3544.333,2418.697,72.29275,0,0,0,0,100,0),
+(@PATH,20,3542.583,2417.697,71.79275,0,0,0,0,100,0),
+(@PATH,21,3540.083,2416.197,71.04275,0,0,0,0,100,0),
+(@PATH,22,3538.053,2415.215,70.16216,0,0,0,0,100,0),
+(@PATH,23,3535.303,2415.715,69.41216,0,0,0,0,100,0),
+(@PATH,24,3532.303,2416.465,68.66216,0,0,0,0,100,0),
+(@PATH,25,3528.303,2417.215,68.16216,0,0,0,0,100,0),
+(@PATH,26,3525.303,2417.965,67.41216,0,0,0,0,100,0),
+(@PATH,27,3522.553,2418.465,66.91216,0,0,0,0,100,0),
+(@PATH,28,3518.803,2419.215,66.16216,0,0,0,0,100,0),
+(@PATH,29,3514.053,2420.215,65.66216,0,0,0,0,100,0),
+(@PATH,30,3510.053,2420.965,64.91216,0,0,0,0,100,0),
+(@PATH,31,3506.053,2421.965,64.16216,0,0,0,0,100,0),
+(@PATH,32,3526.786,2419.995,67.91753,0,0,0,0,100,0),
+(@PATH,33,3528.795,2416.899,68.04163,2.928113,0,0,0,100,0),
+(@PATH,34,3525.927,2417.893,67.31365,0,0,0,0,100,0),
+(@PATH,35,3521.927,2418.643,66.81365,0,0,0,0,100,0),
+(@PATH,36,3517.927,2419.393,66.06365,0,0,0,0,100,0),
+(@PATH,37,3514.427,2420.143,65.56365,0,0,0,0,100,0),
+(@PATH,38,3510.427,2420.893,65.06365,0,0,0,0,100,0),
+(@PATH,39,3505.677,2421.893,64.31365,0,0,0,0,100,0),
+(@PATH,40,3503.506,2422.641,63.87152,0,0,0,0,100,0),
+(@PATH,41,3499.006,2431.391,63.12152,0,0,0,0,100,0),
+(@PATH,42,3495.006,2439.141,62.87152,0,0,0,0,100,0),
+(@PATH,43,3488.999,2450.088,62.3106,0,0,0,0,100,0),
+(@PATH,44,3477.999,2459.588,61.5606,0,0,0,0,100,0),
+(@PATH,45,3475.749,2461.588,60.5606,0,0,0,0,100,0),
+(@PATH,46,3473.499,2463.588,60.0606,0,0,0,0,100,0),
+(@PATH,47,3471.999,2464.838,59.3106,0,0,0,0,100,0),
+(@PATH,48,3471.753,2465.063,59.05139,0,0,0,0,100,0),
+(@PATH,49,3470.753,2466.063,59.05139,0,0,0,0,100,0),
+(@PATH,50,3469.503,2468.813,58.05139,0,0,0,0,100,0),
+(@PATH,51,3468.503,2471.563,57.05139,0,0,0,0,100,0),
+(@PATH,52,3467.753,2473.063,56.55139,0,0,0,0,100,0),
+(@PATH,53,3466.753,2475.813,56.05139,0,0,0,0,100,0),
+(@PATH,54,3464.753,2480.563,55.30139,0,0,0,0,100,0),
+(@PATH,55,3464.782,2480.739,55.26157,0,0,0,0,100,0),
+(@PATH,56,3464.282,2482.239,55.01157,0,0,0,0,100,0),
+(@PATH,57,3471.032,2500.739,55.51157,0,0,0,0,100,0),
+(@PATH,58,3473.032,2506.239,56.01157,0,0,0,0,100,0),
+(@PATH,59,3473.464,2506.485,56.20758,0,0,0,0,100,0),
+(@PATH,60,3474.214,2508.485,56.45758,0,0,0,0,100,0),
+(@PATH,61,3476.464,2510.235,56.70758,0,0,0,0,100,0),
+(@PATH,62,3479.464,2512.485,57.70758,0,0,0,0,100,0),
+(@PATH,63,3481.964,2514.235,58.20758,0,0,0,0,100,0),
+(@PATH,64,3483.714,2515.485,58.95758,0,0,0,0,100,0),
+(@PATH,65,3485.964,2517.235,59.70758,0,0,0,0,100,0),
+(@PATH,66,3486.342,2517.113,59.96626,0,0,0,0,100,0),
+(@PATH,67,3486.592,2517.613,60.21626,0,0,0,0,100,0),
+(@PATH,68,3488.592,2517.613,60.71626,0,0,0,0,100,0),
+(@PATH,69,3490.592,2517.613,61.46626,0,0,0,0,100,0),
+(@PATH,70,3492.592,2517.613,61.96626,0,0,0,0,100,0),
+(@PATH,71,3495.592,2517.613,62.96626,0,0,0,0,100,0),
+(@PATH,72,3498.592,2517.613,63.71626,0,0,0,0,100,0),
+(@PATH,73,3500.592,2517.613,63.96626,0,0,0,0,100,0),
+(@PATH,74,3502.342,2517.613,64.71626,0,0,0,0,100,0),
+(@PATH,75,3504.342,2517.613,65.21626,0,0,0,0,100,0),
+(@PATH,76,3506.342,2517.613,65.96626,0,0,0,0,100,0),
+(@PATH,77,3509.342,2517.863,66.71626,0,0,0,0,100,0),
+(@PATH,78,3513.342,2517.863,67.46626,0,0,0,0,100,0),
+(@PATH,79,3516.342,2517.863,68.21626,0,0,0,0,100,0),
+(@PATH,80,3519.124,2518.039,69.07536,0,0,0,0,100,0),
+(@PATH,81,3522.374,2520.289,69.82536,0,0,0,0,100,0),
+(@PATH,82,3524.874,2522.039,70.57536,0,0,0,0,100,0),
+(@PATH,83,3526.374,2523.039,71.07536,0,0,0,0,100,0),
+(@PATH,84,3528.124,2524.289,71.82536,0,0,0,0,100,0),
+(@PATH,85,3529.874,2525.289,72.57536,0,0,0,0,100,0),
+(@PATH,86,3532.874,2527.539,73.07536,0,0,0,0,100,0),
+(@PATH,87,3536.124,2529.539,73.82536,0,0,0,0,100,0),
+(@PATH,88,3538.624,2531.289,74.57536,0,0,0,0,100,0),
+(@PATH,89,3541.874,2533.539,75.57536,0,0,0,0,100,0),
+(@PATH,90,3544.374,2535.289,76.32536,0,0,0,0,100,0),
+(@PATH,91,3546.124,2536.289,77.07536,0,0,0,0,100,0),
+(@PATH,92,3547.888,2537.283,77.96762,0,0,0,0,100,0),
+(@PATH,93,3550.888,2537.283,78.71762,0,0,0,0,100,0),
+(@PATH,94,3553.888,2537.533,79.71762,0,0,0,0,100,0),
+(@PATH,95,3556.888,2537.783,80.46762,0,0,0,0,100,0),
+(@PATH,96,3559.638,2537.783,81.21762,0,0,0,0,100,0),
+(@PATH,97,3561.638,2537.783,82.21762,0,0,0,0,100,0),
+(@PATH,98,3563.638,2538.033,82.96762,0,0,0,0,100,0),
+(@PATH,99,3566.638,2538.033,83.71762,0,0,0,0,100,0),
+(@PATH,100,3566.925,2538.117,83.73094,0,0,0,0,100,0),
+(@PATH,101,3568.175,2538.117,84.23094,0,0,0,0,100,0),
+(@PATH,102,3570.675,2532.617,83.48094,0,0,0,0,100,0),
+(@PATH,103,3577.925,2516.617,82.73094,0,0,0,0,100,0),
+(@PATH,104,3579.479,2513.69,82.2773,0,0,0,0,100,0),
+(@PATH,105,3580.229,2510.69,82.0273,0,0,0,0,100,0),
+(@PATH,106,3581.979,2504.94,81.5273,0,0,0,0,100,0),
+(@PATH,107,3587.979,2485.19,82.0273,0,0,0,0,100,0),
+(@PATH,108,3587.835,2483.328,82.1699,0,0,0,0,100,0),
+(@PATH,109,3583.585,2479.078,81.6699,0,0,0,0,100,0),
+(@PATH,110,3583.585,2473.078,82.4199,0,0,0,0,100,0),
+(@PATH,111,3583.585,2470.578,82.6699,0,0,0,0,100,0),
+(@PATH,112,3584.085,2469.078,83.1699,0,0,0,0,100,0),
+(@PATH,113,3584.585,2466.828,83.1699,0,0,0,0,100,0),
+(@PATH,114,3584.585,2464.828,83.1699,0,0,0,0,100,0),
+(@PATH,115,3584.585,2462.828,83.4199,0,0,0,0,100,0),
+(@PATH,116,3587.085,2461.078,84.1699,0,0,0,0,100,0),
+(@PATH,117,3587.835,2460.578,84.1699,0,0,0,0,100,0),
+(@PATH,118,3587.469,2460.302,84.29404,0,0,0,0,100,0),
+(@PATH,119,3588.719,2458.802,84.79404,0,0,0,0,100,0),
+(@PATH,120,3584.969,2454.052,84.29404,0,0,0,0,100,0),
+(@PATH,121,3580.719,2448.552,83.54404,0,0,0,0,100,0),
+(@PATH,122,3576.719,2443.302,83.04404,0,0,0,0,100,0),
+(@PATH,123,3573.719,2439.302,82.54404,0,0,0,0,100,0),
+(@PATH,124,3571.969,2436.802,82.04404,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=111848;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(111848, 111848, 0, 0, 2, 0, 0),
+(111848, 101689, 3, 90, 2, 0, 0);
+
+-- 5. Anub'ar Dreadweaver
+UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=26413 AND `source_type`=0 AND `id`=0 AND `link`=0;
+SET @NPC := 100161;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3664.923,`position_y`=2730.399,`position_z`=93.21812 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,3664.923,2730.399,93.21812,0,0,0,0,100,0),
+(@PATH,2,3668.155,2753.281,93.16647,0,0,0,0,100,0),
+(@PATH,3,3666.655,2755.781,92.16647,0,0,0,0,100,0),
+(@PATH,4,3664.155,2759.031,91.41647,0,0,0,0,100,0),
+(@PATH,5,3661.905,2762.031,90.66647,0,0,0,0,100,0),
+(@PATH,6,3660.405,2764.531,90.16647,0,0,0,0,100,0),
+(@PATH,7,3658.155,2767.781,89.41647,0,0,0,0,100,0),
+(@PATH,8,3658.022,2767.969,89.28822,0,0,0,0,100,0),
+(@PATH,9,3656.022,2770.469,88.53822,0,0,0,0,100,0),
+(@PATH,10,3652.272,2770.469,87.78822,0,0,0,0,100,0),
+(@PATH,11,3650.272,2770.719,87.28822,0,0,0,0,100,0),
+(@PATH,12,3647.272,2770.719,86.53822,0,0,0,0,100,0),
+(@PATH,13,3645.522,2770.719,85.78822,0,0,0,0,100,0),
+(@PATH,14,3643.522,2770.719,85.53822,0,0,0,0,100,0),
+(@PATH,15,3641.522,2770.969,84.78822,0,0,0,0,100,0),
+(@PATH,16,3639.522,2770.969,84.28822,0,0,0,0,100,0),
+(@PATH,17,3637.522,2770.969,83.53822,0,0,0,0,100,0),
+(@PATH,18,3635.522,2771.219,83.03822,0,0,0,0,100,0),
+(@PATH,19,3635.043,2771.206,82.57953,0,0,0,0,100,0),
+(@PATH,20,3634.293,2771.206,82.57953,0,0,0,0,100,0),
+(@PATH,21,3632.543,2770.206,82.07953,0,0,0,0,100,0),
+(@PATH,22,3629.293,2768.706,81.57953,0,0,0,0,100,0),
+(@PATH,23,3625.568,2766.971,81.12723,0,0,0,0,100,0),
+(@PATH,24,3622.568,2766.471,80.37723,0,0,0,0,100,0),
+(@PATH,25,3620.568,2766.221,79.62723,0,0,0,0,100,0),
+(@PATH,26,3618.568,2765.971,78.87723,0,0,0,0,100,0),
+(@PATH,27,3616.568,2765.721,78.12723,0,0,0,0,100,0),
+(@PATH,28,3614.568,2765.721,77.12723,0,0,0,0,100,0),
+(@PATH,29,3611.568,2765.471,76.37723,0,0,0,0,100,0),
+(@PATH,30,3609.818,2765.221,75.87723,0,0,0,0,100,0),
+(@PATH,31,3607.818,2764.971,75.12723,0,0,0,0,100,0),
+(@PATH,32,3605.818,2764.721,74.62723,0,0,0,0,100,0),
+(@PATH,33,3603.818,2764.471,73.87723,0,0,0,0,100,0),
+(@PATH,34,3601.818,2764.221,73.37723,0,0,0,0,100,0),
+(@PATH,35,3599.818,2763.971,72.62723,0,0,0,0,100,0),
+(@PATH,36,3596.818,2763.471,71.87723,0,0,0,0,100,0),
+(@PATH,37,3595.068,2763.221,71.12723,0,0,0,0,100,0),
+(@PATH,38,3596.59,2763.309,71.57941,0,0,0,0,100,0),
+(@PATH,39,3594.59,2763.059,71.07941,0,0,0,0,100,0),
+(@PATH,40,3593.84,2763.059,71.07941,0,0,0,0,100,0),
+(@PATH,41,3588.108,2747.165,70.9092,0,0,0,0,100,0),
+(@PATH,42,3590.108,2744.915,71.4092,0,0,0,0,100,0),
+(@PATH,43,3592.108,2742.665,72.1592,0,0,0,0,100,0),
+(@PATH,44,3594.108,2740.415,72.9092,0,0,0,0,100,0),
+(@PATH,45,3596.608,2737.665,73.6592,0,0,0,0,100,0),
+(@PATH,46,3598.358,2735.165,74.1592,0,0,0,0,100,0),
+(@PATH,47,3600.358,2732.915,75.1592,0,0,0,0,100,0),
+(@PATH,48,3601.608,2731.415,75.6592,0,0,0,0,100,0),
+(@PATH,49,3603.608,2729.165,76.6592,0,0,0,0,100,0),
+(@PATH,50,3605.608,2726.915,77.6592,0,0,0,0,100,0),
+(@PATH,51,3605.688,2726.727,77.9077,0,0,0,0,100,0),
+(@PATH,52,3606.438,2725.727,78.1577,0,0,0,0,100,0),
+(@PATH,53,3607.438,2724.227,78.9077,0,0,0,0,100,0),
+(@PATH,54,3608.688,2722.477,79.6577,0,0,0,0,100,0),
+(@PATH,55,3609.688,2720.727,80.4077,0,0,0,0,100,0),
+(@PATH,56,3611.438,2718.227,80.9077,0,0,0,0,100,0),
+(@PATH,57,3612.438,2716.477,81.6577,0,0,0,0,100,0),
+(@PATH,58,3613.688,2714.227,82.4077,0,0,0,0,100,0),
+(@PATH,59,3614.938,2712.727,82.9077,0,0,0,0,100,0),
+(@PATH,60,3616.438,2709.977,83.6577,0,0,0,0,100,0),
+(@PATH,61,3617.438,2708.477,84.1577,0,0,0,0,100,0),
+(@PATH,62,3619.188,2705.977,85.1577,0,0,0,0,100,0),
+(@PATH,63,3620.188,2704.227,85.6577,0,0,0,0,100,0),
+(@PATH,64,3620.574,2703.95,86.05293,0,0,0,0,100,0),
+(@PATH,65,3621.574,2702.45,86.30293,0,0,0,0,100,0),
+(@PATH,66,3623.824,2700.45,87.30293,0,0,0,0,100,0),
+(@PATH,67,3625.324,2699.2,88.05293,0,0,0,0,100,0),
+(@PATH,68,3627.574,2697.45,88.80293,0,0,0,0,100,0),
+(@PATH,69,3630.074,2695.45,89.55293,0,0,0,0,100,0),
+(@PATH,70,3631.574,2694.2,90.30293,0,0,0,0,100,0),
+(@PATH,71,3633.824,2692.2,90.80293,0,0,0,0,100,0),
+(@PATH,72,3636.074,2690.7,91.30293,0,0,0,0,100,0),
+(@PATH,73,3637.574,2689.45,92.05293,0,0,0,0,100,0),
+(@PATH,74,3639.824,2687.45,92.55293,0,0,0,0,100,0),
+(@PATH,75,3642.074,2685.7,93.30293,0,0,0,0,100,0),
+(@PATH,76,3645.324,2683.2,94.05293,0,0,0,0,100,0),
+(@PATH,77,3647.574,2681.2,94.80293,0,0,0,0,100,0),
+(@PATH,78,3649.824,2679.2,95.30293,0,0,0,0,100,0),
+(@PATH,79,3652.397,2677.474,96.18909,0,0,0,0,100,0),
+(@PATH,80,3655.147,2682.974,95.43909,0,0,0,0,100,0),
+(@PATH,81,3658.147,2689.974,94.93909,0,0,0,0,100,0),
+(@PATH,82,3663.131,2700.564,94.50307,0,0,0,0,100,0),
+(@PATH,83,3663.381,2706.564,93.75307,0,0,0,0,100,0),
+(@PATH,84,3664.381,2725.314,93.50307,0,0,0,0,100,0);
+
+-- 6. Anub'ar Dreadweaver
+SET @NPC := 100253;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3821.681,`position_y`=2714.922,`position_z`=125.8894 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,3821.681,2714.922,125.8894,0,0,0,0,100,0),
+(@PATH,2,3832.681,2739.172,126.3894,0,0,0,0,100,0),
+(@PATH,3,3836.681,2748.172,126.8894,0,0,0,0,100,0),
+(@PATH,4,3839.483,2754.288,127.394,0,0,0,0,100,0),
+(@PATH,5,3841.233,2757.788,127.894,0,0,0,0,100,0),
+(@PATH,6,3842.983,2762.538,128.894,0,0,0,0,100,0),
+(@PATH,7,3844.733,2766.788,129.144,0,0,0,0,100,0),
+(@PATH,8,3845.733,2769.788,129.644,0,0,0,0,100,0),
+(@PATH,9,3846.983,2772.538,130.644,0,0,0,0,100,0),
+(@PATH,10,3847.138,2772.679,130.679,0,0,0,0,100,0),
+(@PATH,11,3847.638,2774.679,131.179,0,0,0,0,100,0),
+(@PATH,12,3847.888,2783.679,131.429,0,0,0,0,100,0),
+(@PATH,13,3848.138,2795.429,130.929,0,0,0,0,100,0),
+(@PATH,14,3848.154,2795.403,130.9103,0,0,0,0,100,0),
+(@PATH,15,3848.154,2796.653,130.6603,0,0,0,0,100,0),
+(@PATH,16,3846.154,2796.653,129.9103,0,0,0,0,100,0),
+(@PATH,17,3844.154,2796.653,128.9103,0,0,0,0,100,0),
+(@PATH,18,3842.154,2796.653,128.1603,0,0,0,0,100,0),
+(@PATH,19,3840.154,2796.653,127.1603,0,0,0,0,100,0),
+(@PATH,20,3838.404,2796.653,126.4103,0,0,0,0,100,0),
+(@PATH,21,3836.404,2796.653,125.6603,0,0,0,0,100,0),
+(@PATH,22,3834.404,2796.653,124.6603,0,0,0,0,100,0),
+(@PATH,23,3832.404,2796.653,123.9103,0,0,0,0,100,0),
+(@PATH,24,3830.404,2796.653,123.1603,0,0,0,0,100,0),
+(@PATH,25,3830.041,2796.738,122.985,0,0,0,0,100,0),
+(@PATH,26,3828.791,2796.738,122.735,0,0,0,0,100,0),
+(@PATH,27,3826.041,2795.738,121.735,0,0,0,0,100,0),
+(@PATH,28,3823.041,2794.488,121.235,0,0,0,0,100,0),
+(@PATH,29,3822.291,2794.238,120.485,0,0,0,0,100,0),
+(@PATH,30,3821.291,2793.988,119.985,0,0,0,0,100,0),
+(@PATH,31,3819.291,2793.238,119.235,0,0,0,0,100,0),
+(@PATH,32,3817.791,2792.488,118.485,0,0,0,0,100,0),
+(@PATH,33,3815.041,2791.738,117.735,0,0,0,0,100,0),
+(@PATH,34,3813.041,2790.988,117.235,0,0,0,0,100,0),
+(@PATH,35,3811.291,2790.238,116.485,0,0,0,0,100,0),
+(@PATH,36,3808.541,2788.988,115.735,0,0,0,0,100,0),
+(@PATH,37,3808.207,2788.901,115.6306,0,0,0,0,100,0),
+(@PATH,38,3806.707,2788.151,115.3806,0,0,0,0,100,0),
+(@PATH,39,3804.957,2785.651,114.8806,0,0,0,0,100,0),
+(@PATH,40,3790.957,2765.401,115.3806,0,0,0,0,100,0),
+(@PATH,41,3784.578,2756.029,115.5921,0,0,0,0,100,0),
+(@PATH,42,3783.828,2751.029,116.5921,0,0,0,0,100,0),
+(@PATH,43,3783.578,2748.279,117.0921,0,0,0,0,100,0),
+(@PATH,44,3783.578,2745.279,117.8421,0,0,0,0,100,0),
+(@PATH,45,3783.078,2741.279,118.0921,0,0,0,0,100,0),
+(@PATH,46,3782.078,2734.529,118.8421,0,0,0,0,100,0),
+(@PATH,47,3781.578,2729.529,119.5921,0,0,0,0,100,0),
+(@PATH,48,3781.078,2725.529,120.3421,0,0,0,0,100,0),
+(@PATH,49,3780.522,2721.694,120.878,0,0,0,0,100,0),
+(@PATH,50,3780.022,2717.694,121.628,0,0,0,0,100,0),
+(@PATH,51,3779.772,2715.944,122.128,0,0,0,0,100,0),
+(@PATH,52,3779.522,2713.944,122.878,0,0,0,0,100,0),
+(@PATH,53,3779.272,2711.944,123.378,0,0,0,0,100,0),
+(@PATH,54,3779.022,2708.944,124.378,0,0,0,0,100,0),
+(@PATH,55,3778.772,2706.944,124.878,0,0,0,0,100,0),
+(@PATH,56,3778.772,2705.194,125.378,0,0,0,0,100,0),
+(@PATH,57,3778.772,2703.194,125.878,0,0,0,0,100,0),
+(@PATH,58,3778.272,2700.194,126.878,0,0,0,0,100,0),
+(@PATH,59,3778.022,2697.194,127.628,0,0,0,0,100,0),
+(@PATH,60,3777.772,2695.194,128.378,0,0,0,0,100,0),
+(@PATH,61,3777.522,2693.194,129.128,0,0,0,0,100,0),
+(@PATH,62,3777.272,2691.194,129.628,0,0,0,0,100,0),
+(@PATH,63,3777.272,2689.194,130.378,0,0,0,0,100,0),
+(@PATH,64,3777.295,2691.026,129.8421,0,0,0,0,100,0),
+(@PATH,65,3777.295,2689.026,130.5921,0,0,0,0,100,0),
+(@PATH,66,3777.045,2688.276,130.8421,0,0,0,0,100,0),
+(@PATH,67,3785.545,2679.776,131.3421,0,0,0,0,100,0),
+(@PATH,68,3791.795,2673.526,132.0921,0,0,0,0,100,0),
+(@PATH,69,3798.545,2666.276,132.5921,0,0,0,0,100,0),
+(@PATH,70,3804.795,2660.026,133.0921,0,0,0,0,100,0),
+(@PATH,71,3806.708,2657.653,133.2704,0,0,0,0,100,0),
+(@PATH,72,3805.208,2648.903,133.7704,0,0,0,0,100,0),
+(@PATH,73,3803.208,2638.153,133.2704,0,0,0,0,100,0),
+(@PATH,74,3799.062,2615.07,134.0544,0,0,0,0,100,0),
+(@PATH,75,3803.062,2615.32,134.3044,0,0,0,0,100,0),
+(@PATH,76,3807.944,2615.739,134.8091,0,0,0,0,100,0),
+(@PATH,77,3808.944,2619.489,134.3091,0,0,0,0,100,0),
+(@PATH,78,3814.444,2645.739,133.8091,0,0,0,0,100,0),
+(@PATH,79,3814.543,2647.11,133.489,0,0,0,0,100,0),
+(@PATH,80,3815.043,2655.11,132.989,0,0,0,0,100,0),
+(@PATH,81,3815.293,2662.11,132.489,0,0,0,0,100,0),
+(@PATH,82,3815.543,2665.86,131.739,0,0,0,0,100,0),
+(@PATH,83,3815.543,2666.61,131.739,0,0,0,0,100,0),
+(@PATH,84,3815.543,2668.86,131.489,0,0,0,0,100,0),
+(@PATH,85,3815.543,2670.86,131.239,0,0,0,0,100,0),
+(@PATH,86,3814.793,2673.86,130.239,0,0,0,0,100,0),
+(@PATH,87,3814.543,2675.11,129.989,0,0,0,0,100,0),
+(@PATH,88,3813.252,2678.239,129.1984,0,0,0,0,100,0),
+(@PATH,89,3814.002,2681.239,128.6984,0,0,0,0,100,0),
+(@PATH,90,3815.002,2684.989,127.9484,0,0,0,0,100,0),
+(@PATH,91,3816.002,2689.989,127.4484,0,0,0,0,100,0),
+(@PATH,92,3817.502,2696.489,126.9484,0,0,0,0,100,0),
+(@PATH,93,3820.252,2709.239,126.4484,0,0,0,0,100,0);
+
+-- 7. Anub'ar Ambusher
+UPDATE `creature` SET `spawndist`=15 WHERE  `id`=26402 AND `MovementType`=1;
+
+-- 8. Anub'ar Dreadweaver
+SET @NPC := 100223;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3852.472,`position_y`=2702.682,`position_z`=137.468 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,3852.472,2702.682,137.468,0,0,0,0,100,0),
+(@PATH,2,3858.722,2712.932,137.968,0,0,0,0,100,0),
+(@PATH,3,3861.722,2717.682,138.468,0,0,0,0,100,0),
+(@PATH,4,3865.722,2724.432,138.968,0,0,0,0,100,0),
+(@PATH,5,3871.273,2733.387,139.917,0,0,0,0,100,0),
+(@PATH,6,3872.273,2747.137,140.417,0,0,0,0,100,0),
+(@PATH,7,3873.023,2756.887,140.917,0,0,0,0,100,0),
+(@PATH,8,3872.995,2757.285,141.0562,0,0,0,0,100,0),
+(@PATH,9,3872.995,2757.535,141.0562,0,0,0,0,100,0),
+(@PATH,10,3872.745,2788.285,140.5562,0,0,0,0,100,0),
+(@PATH,11,3872.824,2802.361,140.7805,0,0,0,0,100,0),
+(@PATH,12,3874.324,2803.611,141.5305,0,0,0,0,100,0),
+(@PATH,13,3876.324,2805.861,142.5305,0,0,0,0,100,0),
+(@PATH,14,3878.324,2808.111,143.2805,0,0,0,0,100,0),
+(@PATH,15,3880.574,2809.861,144.2805,0,0,0,0,100,0),
+(@PATH,16,3882.324,2812.111,144.7805,0,0,0,0,100,0),
+(@PATH,17,3884.324,2814.111,145.7805,0,0,0,0,100,0),
+(@PATH,18,3886.574,2816.361,146.5305,0,0,0,0,100,0),
+(@PATH,19,3888.574,2818.611,147.5305,0,0,0,0,100,0),
+(@PATH,20,3890.824,2820.611,148.2805,0,0,0,0,100,0),
+(@PATH,21,3890.949,2820.73,148.4617,0,0,0,0,100,0),
+(@PATH,22,3891.699,2821.48,148.7117,0,0,0,0,100,0),
+(@PATH,23,3893.199,2820.23,149.4617,0,0,0,0,100,0),
+(@PATH,24,3895.449,2818.23,150.4617,0,0,0,0,100,0),
+(@PATH,25,3897.699,2815.98,151.2117,0,0,0,0,100,0),
+(@PATH,26,3899.699,2813.98,151.9617,0,0,0,0,100,0),
+(@PATH,27,3901.199,2812.98,152.7117,0,0,0,0,100,0),
+(@PATH,28,3903.449,2810.98,153.2117,0,0,0,0,100,0),
+(@PATH,29,3906.199,2808.23,153.9617,0,0,0,0,100,0),
+(@PATH,30,3906.275,2808.106,153.9524,0,0,0,0,100,0),
+(@PATH,31,3907.525,2806.856,154.2024,0,0,0,0,100,0),
+(@PATH,32,3907.025,2803.856,153.4524,0,0,0,0,100,0),
+(@PATH,33,3906.275,2798.856,152.7024,0,0,0,0,100,0),
+(@PATH,34,3905.025,2793.106,151.7024,0,0,0,0,100,0),
+(@PATH,35,3904.275,2788.106,150.9524,0,0,0,0,100,0),
+(@PATH,36,3903.525,2785.106,150.2024,0,0,0,0,100,0),
+(@PATH,37,3903.025,2782.356,149.7024,0,0,0,0,100,0),
+(@PATH,38,3902.275,2777.606,149.2024,0,0,0,0,100,0),
+(@PATH,39,3901.775,2774.606,148.4524,0,0,0,0,100,0),
+(@PATH,40,3901.275,2771.606,147.9524,0,0,0,0,100,0),
+(@PATH,41,3900.775,2768.606,147.2024,0,0,0,0,100,0),
+(@PATH,42,3900.025,2764.856,146.7024,0,0,0,0,100,0),
+(@PATH,43,3898.84,2759.32,145.9486,0,0,0,0,100,0),
+(@PATH,44,3896.59,2748.32,145.1986,0,0,0,0,100,0),
+(@PATH,45,3895.09,2738.82,144.6986,0,0,0,0,100,0),
+(@PATH,46,3893.692,2733.074,144.8318,0,0,0,0,100,0),
+(@PATH,47,3893.692,2723.074,145.0818,0,0,0,0,100,0),
+(@PATH,48,3893.692,2717.324,145.5818,0,0,0,0,100,0),
+(@PATH,49,3893.442,2710.324,146.0818,0,0,0,0,100,0),
+(@PATH,50,3893.141,2701.308,146.6663,0,0,0,0,100,0),
+(@PATH,51,3890.641,2686.308,147.4163,0,0,0,0,100,0),
+(@PATH,52,3889.891,2679.808,147.9163,0,0,0,0,100,0),
+(@PATH,53,3888.891,2672.808,148.4163,0,0,0,0,100,0),
+(@PATH,54,3887.707,2667.164,148.6076,0,0,0,0,100,0),
+(@PATH,55,3885.707,2666.914,147.6076,0,0,0,0,100,0),
+(@PATH,56,3883.707,2666.664,146.6076,0,0,0,0,100,0),
+(@PATH,57,3881.707,2666.664,145.6076,0,0,0,0,100,0),
+(@PATH,58,3880.707,2666.414,145.1076,0,0,0,0,100,0),
+(@PATH,59,3878.707,2666.164,144.1076,0,0,0,0,100,0),
+(@PATH,60,3876.707,2666.164,143.1076,0,0,0,0,100,0),
+(@PATH,61,3874.707,2665.914,142.3576,0,0,0,0,100,0),
+(@PATH,62,3872.957,2665.664,141.6076,0,0,0,0,100,0),
+(@PATH,63,3870.957,2665.414,140.6076,0,0,0,0,100,0),
+(@PATH,64,3867.957,2665.164,139.8576,0,0,0,0,100,0),
+(@PATH,65,3865.957,2664.914,139.1076,0,0,0,0,100,0),
+(@PATH,66,3863.957,2664.664,138.3576,0,0,0,0,100,0),
+(@PATH,67,3861.957,2664.664,137.6076,0,0,0,0,100,0),
+(@PATH,68,3859.957,2664.414,136.8576,0,0,0,0,100,0),
+(@PATH,69,3861.681,2664.503,137.3304,0,0,0,0,100,0),
+(@PATH,70,3859.681,2664.253,136.5804,0,0,0,0,100,0),
+(@PATH,71,3859.181,2664.253,136.5804,0,0,0,0,100,0),
+(@PATH,72,3854.431,2666.003,135.8304,0,0,0,0,100,0),
+(@PATH,73,3851.681,2667.003,135.3304,0,0,0,0,100,0),
+(@PATH,74,3849.181,2667.753,134.8304,0,0,0,0,100,0),
+(@PATH,75,3842.431,2670.003,134.0804,0,0,0,0,100,0),
+(@PATH,76,3838.875,2671.314,133.8411,0,0,0,0,100,0),
+(@PATH,77,3842.125,2678.814,134.5911,0,0,0,0,100,0),
+(@PATH,78,3844.875,2685.064,135.0911,0,0,0,0,100,0),
+(@PATH,79,3847.125,2690.314,135.5911,0,0,0,0,100,0),
+(@PATH,80,3848.625,2694.064,136.3411,0,0,0,0,100,0),
+(@PATH,81,3850.625,2698.564,136.8411,0,0,0,0,100,0);
+
+-- 9. Emissary Brighthoof <Tauren Emissary>
+SET @NPC := 102336;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3752.59,`position_y`=2864.902,`position_z`=93.0518 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,3752.59,2864.902,93.0518,0,0,0,0,100,0),
+(@PATH,2,3759.419,2868.763,93.04378,0,0,0,0,100,0),
+(@PATH,3,3765.013,2876.713,93.03255,0,0,0,0,100,0),
+(@PATH,4,3763.871,2886.514,93.0278,0,0,0,0,100,0),
+(@PATH,5,3758.04,2890.089,93.02374,0,0,0,0,100,0),
+(@PATH,6,3748.332,2886.463,93.02374,0,0,0,0,100,0),
+(@PATH,7,3741.918,2879.134,93.02374,0,0,0,0,100,0),
+(@PATH,8,3739.117,2873.306,92.87422,0,0,0,0,100,0),
+(@PATH,9,3733.117,2876.306,92.12422,0,0,0,0,100,0),
+(@PATH,10,3729.957,2877.601,91.62366,0,0,0,0,100,0),
+(@PATH,11,3725.207,2878.851,91.12366,0,0,0,0,100,0),
+(@PATH,12,3717.707,2881.101,91.62366,0,0,0,0,100,0),
+(@PATH,13,3717.509,2881.121,91.59511,0,0,0,0,100,0),
+(@PATH,14,3717.009,2881.121,91.59511,0,0,0,0,100,0),
+(@PATH,15,3708.823,2880.849,92.06134,0,0,0,0,100,0),
+(@PATH,16,3710.323,2881.849,92.06134,0,0,0,0,100,0),
+(@PATH,17,3717.823,2880.849,91.56134,0,0,0,0,100,0),
+(@PATH,18,3724.297,2880.377,91.21579,0,0,0,0,100,0),
+(@PATH,19,3728.297,2890.377,91.71579,0,0,0,0,100,0),
+(@PATH,20,3732.05,2898.535,91.45734,0,0,0,0,100,0),
+(@PATH,21,3736.774,2905.725,91.74409,0,0,0,0,100,0),
+(@PATH,22,3744.524,2905.975,90.99409,0,0,0,0,100,0),
+(@PATH,23,3749.693,2906.113,90.64676,0,0,0,0,100,0),
+(@PATH,24,3752.489,2911.108,90.68295,0,0,0,0,100,0),
+(@PATH,25,3752.489,2911.108,90.68295,1.092321,0,0,0,100,0),
+(@PATH,26,3758.714,2911.316,90.584,0,0,0,0,100,0),
+(@PATH,27,3758.883,2911.217,90.85934,0,0,0,0,100,0),
+(@PATH,28,3769.109,2908.125,90.78024,0,0,0,0,100,0),
+(@PATH,29,3779.938,2899.947,90.53975,0,0,0,0,100,0),
+(@PATH,30,3781.945,2888.143,90.82527,0,0,0,0,100,0),
+(@PATH,31,3783.739,2876.138,90.67658,0,0,0,0,100,0),
+(@PATH,32,3782.829,2862.609,90.49554,0,0,0,0,100,0),
+(@PATH,33,3774.252,2853.663,90.33541,0,0,0,0,100,0),
+(@PATH,34,3756.171,2844.906,90.55302,0,0,0,0,100,0),
+(@PATH,35,3745.443,2843.278,90.24667,0,0,0,0,100,0),
+(@PATH,36,3729.312,2844.752,90.46081,0,0,0,0,100,0),
+(@PATH,37,3720.543,2848.604,90.06216,0,0,0,0,100,0),
+(@PATH,38,3725.404,2856.827,90.76266,0,0,0,0,100,0),
+(@PATH,39,3730.404,2859.577,91.01266,0,0,0,0,100,0),
+(@PATH,40,3733.904,2861.327,91.76266,0,0,0,0,100,0),
+(@PATH,41,3734.059,2861.549,91.9117,0,0,0,0,100,0),
+(@PATH,42,3734.809,2862.049,91.9117,0,0,0,0,100,0),
+(@PATH,43,3738.809,2864.299,92.9117,0,0,0,0,100,0),
+(@PATH,44,3740.939,2865.326,93.01389,0,0,0,0,100,0),
+(@PATH,45,3752.541,2864.87,93.05477,0,0,0,0,100,0),
+(@PATH,46,3759.434,2868.699,93.05436,0,0,0,0,100,0);
+
+-- 10. Anub'ar Slayer
+SET @NPC := 118338;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3865.937,`position_y`=2431.854,`position_z`=152.6005 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,3865.937,2431.854,152.6005,0,0,0,0,100,0),
+(@PATH,2,3870.538,2405.845,152.539,0,0,0,0,100,0),
+(@PATH,3,3870.25,2405.776,152.3522,0,0,0,0,100,0),
+(@PATH,4,3870.223,2405.917,152.5955,0,0,0,0,100,0),
+(@PATH,5,3865.791,2432.176,152.5862,0,0,0,0,100,0),
+(@PATH,6,3865.527,2457.363,152.5417,0,0,0,0,100,0),
+(@PATH,7,3861.447,2472.743,152.3061,0,0,0,0,100,0),
+(@PATH,8,3861.41,2472.45,152.2599,0,0,0,0,100,0),
+(@PATH,9,3861.678,2472.471,152.544,0,0,0,0,100,0),
+(@PATH,10,3865.587,2457.035,152.5785,0,0,0,0,100,0);
+
+-- 11. Anub'ar Slayer
+SET @NPC := 118346;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3809.24,`position_y`=2351.267,`position_z`=109.6065 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,3809.24,2351.267,109.6065,0,0,0,0,100,0),
+(@PATH,2,3808.74,2350.267,108.6065,0,0,0,0,100,0),
+(@PATH,3,3807.74,2348.267,107.1065,0,0,0,0,100,0),
+(@PATH,4,3807.24,2347.517,106.1065,0,0,0,0,100,0),
+(@PATH,5,3805.99,2344.767,104.6065,0,0,0,0,100,0),
+(@PATH,6,3804.99,2343.017,103.1065,0,0,0,0,100,0),
+(@PATH,7,3804.24,2341.517,102.1065,0,0,0,0,100,0),
+(@PATH,8,3803.24,2339.767,100.6065,0,0,0,0,100,0),
+(@PATH,9,3801.99,2337.017,99.10649,0,0,0,0,100,0),
+(@PATH,10,3800.99,2335.267,96.85649,0,0,0,0,100,0),
+(@PATH,11,3801.519,2336.212,98.17152,0,0,0,0,100,0),
+(@PATH,12,3802.519,2337.962,100.1715,0,0,0,0,100,0),
+(@PATH,13,3803.269,2339.712,100.9215,0,0,0,0,100,0),
+(@PATH,14,3804.269,2341.712,102.1715,0,0,0,0,100,0),
+(@PATH,15,3805.519,2343.962,104.1715,0,0,0,0,100,0),
+(@PATH,16,3806.269,2345.712,104.9215,0,0,0,0,100,0),
+(@PATH,17,3807.269,2347.462,106.6715,0,0,0,0,100,0),
+(@PATH,18,3808.269,2349.212,107.9215,0,0,0,0,100,0),
+(@PATH,19,3819.061,2367.925,122.5994,0,0,0,0,100,0),
+(@PATH,20,3819.561,2369.675,123.3494,0,0,0,0,100,0),
+(@PATH,21,3820.061,2371.675,124.3494,0,0,0,0,100,0),
+(@PATH,22,3820.561,2373.425,125.0994,0,0,0,0,100,0),
+(@PATH,23,3821.061,2375.175,125.8494,0,0,0,0,100,0),
+(@PATH,24,3821.561,2377.175,126.5994,0,0,0,0,100,0),
+(@PATH,25,3821.847,2377.59,126.5378,0,0,0,0,100,0),
+(@PATH,26,3821.347,2375.84,126.0378,0,0,0,0,100,0),
+(@PATH,27,3820.597,2373.84,125.0378,0,0,0,0,100,0),
+(@PATH,28,3820.097,2371.09,124.7878,0,0,0,0,100,0),
+(@PATH,29,3819.597,2369.34,123.5378,0,0,0,0,100,0),
+(@PATH,30,3819.317,2368.936,123.1801,0,0,0,0,100,0),
+(@PATH,31,3818.817,2367.686,122.4301,0,0,0,0,100,0),
+(@PATH,32,3817.817,2365.936,121.4301,0,0,0,0,100,0),
+(@PATH,33,3816.817,2364.186,119.9301,0,0,0,0,100,0),
+(@PATH,34,3815.817,2362.436,118.1801,0,0,0,0,100,0),
+(@PATH,35,3814.817,2360.686,117.1801,0,0,0,0,100,0),
+(@PATH,36,3813.567,2358.436,114.9301,0,0,0,0,100,0),
+(@PATH,37,3812.567,2356.686,113.9301,0,0,0,0,100,0),
+(@PATH,38,3811.567,2354.936,112.4301,0,0,0,0,100,0),
+(@PATH,39,3810.567,2353.186,110.9301,0,0,0,0,100,0),
+(@PATH,40,3809.567,2351.436,109.9301,0,0,0,0,100,0);
+
+-- 12. Anub'ar Slayer
+SET @NPC := 118387;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3819.309,`position_y`=2440.174,`position_z`=129.0127 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,3819.309,2440.174,129.0127,0,0,0,0,100,0),
+(@PATH,2,3820.059,2439.424,129.7627,0,0,0,0,100,0),
+(@PATH,3,3821.559,2438.174,130.5127,0,0,0,0,100,0),
+(@PATH,4,3822.309,2437.424,131.5127,0,0,0,0,100,0),
+(@PATH,5,3823.559,2436.174,132.0127,0,0,0,0,100,0),
+(@PATH,6,3824.309,2435.674,132.7627,0,0,0,0,100,0),
+(@PATH,7,3825.559,2434.174,133.5127,0,0,0,0,100,0),
+(@PATH,8,3826.309,2433.424,134.2627,0,0,0,0,100,0),
+(@PATH,9,3827.809,2432.174,135.0127,0,0,0,0,100,0),
+(@PATH,10,3828.075,2431.972,135.0589,0,0,0,0,100,0),
+(@PATH,11,3828.575,2431.222,135.5589,0,0,0,0,100,0),
+(@PATH,12,3829.325,2430.722,136.3089,0,0,0,0,100,0),
+(@PATH,13,3831.075,2429.472,137.0589,0,0,0,0,100,0),
+(@PATH,14,3831.825,2428.722,137.5589,0,0,0,0,100,0),
+(@PATH,15,3833.325,2427.472,138.3089,0,0,0,0,100,0),
+(@PATH,16,3834.075,2426.722,139.0589,0,0,0,0,100,0),
+(@PATH,17,3834.575,2426.472,139.8089,0,0,0,0,100,0),
+(@PATH,18,3836.075,2425.222,140.8089,0,0,0,0,100,0),
+(@PATH,19,3836.825,2424.472,141.3089,0,0,0,0,100,0),
+(@PATH,20,3837.575,2423.972,142.5589,0,0,0,0,100,0),
+(@PATH,21,3839.325,2422.722,143.5589,0,0,0,0,100,0),
+(@PATH,22,3840.075,2421.972,144.5589,0,0,0,0,100,0),
+(@PATH,23,3840.825,2421.472,145.3089,0,0,0,0,100,0),
+(@PATH,24,3840.169,2421.66,144.8938,0,0,0,0,100,0),
+(@PATH,25,3840.919,2421.16,145.6438,0,0,0,0,100,0),
+(@PATH,26,3841.669,2420.66,145.8938,0,0,0,0,100,0),
+(@PATH,27,3843.419,2419.91,147.1438,0,0,0,0,100,0),
+(@PATH,28,3844.419,2419.66,147.8938,0,0,0,0,100,0),
+(@PATH,29,3846.169,2418.91,148.6438,0,0,0,0,100,0),
+(@PATH,30,3847.169,2418.66,149.3938,0,0,0,0,100,0),
+(@PATH,31,3849.669,2417.66,150.1438,0,0,0,0,100,0),
+(@PATH,32,3852.669,2416.66,150.8938,0,0,0,0,100,0),
+(@PATH,33,3855.419,2415.66,151.3938,0,0,0,0,100,0),
+(@PATH,34,3852.793,2416.527,150.7145,0,0,0,0,100,0),
+(@PATH,35,3850.043,2417.777,149.9645,0,0,0,0,100,0),
+(@PATH,36,3847.293,2418.527,149.2145,0,0,0,0,100,0),
+(@PATH,37,3846.543,2418.777,148.7145,0,0,0,0,100,0),
+(@PATH,38,3844.543,2419.527,147.9645,0,0,0,0,100,0),
+(@PATH,39,3843.543,2419.777,146.9645,0,0,0,0,100,0),
+(@PATH,40,3841.596,2420.833,145.6505,0,0,0,0,100,0),
+(@PATH,41,3840.096,2422.083,144.6505,0,0,0,0,100,0),
+(@PATH,42,3839.096,2422.583,143.4005,0,0,0,0,100,0),
+(@PATH,43,3838.346,2423.333,142.4005,0,0,0,0,100,0),
+(@PATH,44,3836.846,2424.583,141.4005,0,0,0,0,100,0),
+(@PATH,45,3836.096,2425.333,140.9005,0,0,0,0,100,0),
+(@PATH,46,3835.596,2425.583,139.9005,0,0,0,0,100,0),
+(@PATH,47,3834.096,2426.833,139.1505,0,0,0,0,100,0),
+(@PATH,48,3833.346,2427.583,138.4005,0,0,0,0,100,0),
+(@PATH,49,3832.596,2428.083,137.6505,0,0,0,0,100,0),
+(@PATH,50,3830.846,2429.333,137.1505,0,0,0,0,100,0),
+(@PATH,51,3829.346,2430.583,135.9005,0,0,0,0,100,0),
+(@PATH,52,3830.758,2429.744,136.821,0,0,0,0,100,0),
+(@PATH,53,3829.258,2430.994,135.571,0,0,0,0,100,0),
+(@PATH,54,3828.508,2431.494,135.321,0,0,0,0,100,0),
+(@PATH,55,3827.008,2432.994,134.321,0,0,0,0,100,0),
+(@PATH,56,3825.508,2434.244,133.571,0,0,0,0,100,0),
+(@PATH,57,3824.758,2434.994,132.821,0,0,0,0,100,0),
+(@PATH,58,3823.508,2436.244,132.321,0,0,0,0,100,0),
+(@PATH,59,3823.008,2436.744,131.571,0,0,0,0,100,0),
+(@PATH,60,3821.508,2438.244,130.571,0,0,0,0,100,0),
+(@PATH,61,3820.758,2438.994,129.821,0,0,0,0,100,0),
+(@PATH,62,3820.008,2439.494,129.071,0,0,0,0,100,0),
+(@PATH,63,3818.508,2440.994,128.571,0,0,0,0,100,0);
+
+-- 13. Cultists
+UPDATE `smart_scripts` SET `action_param1`=1 WHERE  `entryorguid`=26319 AND `source_type`=0 AND `id`=0 AND `link`=0;
+
+-- 14. Anubar rndm
+UPDATE `creature` SET `spawndist`=12 WHERE  `id`=26606 AND `MovementType`=1;
+
+-- 15. Anub'ar Slayer
+SET @NPC := 118396;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4001.417,`position_y`=2208.701,`position_z`=152.8115 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,4001.417,2208.701,152.8115,0,0,0,0,100,0),
+(@PATH,2,3999.667,2211.201,153.0615,0,0,0,0,100,0),
+(@PATH,3,3995.667,2216.451,153.5615,0,0,0,0,100,0),
+(@PATH,4,3990.09,2223.838,153.832,0,0,0,0,100,0),
+(@PATH,5,3995.996,2229.39,154.2306,0,0,0,0,100,0),
+(@PATH,6,3991.746,2231.14,153.7306,0,0,0,0,100,0),
+(@PATH,7,3987.496,2232.39,153.7306,0,0,0,0,100,0),
+(@PATH,8,3985.496,2232.39,153.7306,0,0,0,0,100,0),
+(@PATH,9,3983.246,2232.39,153.7306,0,0,0,0,100,0),
+(@PATH,10,3979.496,2231.14,153.7306,0,0,0,0,100,0),
+(@PATH,11,3975.246,2231.14,153.7306,0,0,0,0,100,0),
+(@PATH,12,3971.038,2230.096,153.5746,0,0,0,0,100,0),
+(@PATH,13,3970.165,2222.005,153.5965,0,0,0,0,100,0),
+(@PATH,14,3978.311,2216.993,153.8155,0,0,0,0,100,0),
+(@PATH,15,3994.034,2212.065,153.7311,0,0,0,0,100,0),
+(@PATH,16,3997.034,2208.565,153.2311,0,0,0,0,100,0),
+(@PATH,17,3997.132,2208.457,152.9908,0,0,0,0,100,0),
+(@PATH,18,3997.632,2208.207,152.9908,0,0,0,0,100,0),
+(@PATH,19,4001.382,2208.457,152.7408,0,0,0,0,100,0),
+(@PATH,20,4004.382,2208.707,151.9908,0,0,0,0,100,0),
+(@PATH,21,4012.132,2209.457,151.4908,0,0,0,0,100,0),
+(@PATH,22,4023.132,2210.457,151.9908,0,0,0,0,100,0),
+(@PATH,23,4027.25,2210.666,152.2376,0,0,0,0,100,0),
+(@PATH,24,4029.75,2210.666,152.4876,0,0,0,0,100,0),
+(@PATH,25,4023.75,2210.666,151.7376,0,0,0,0,100,0),
+(@PATH,26,4019,2210.416,151.4876,0,0,0,0,100,0),
+(@PATH,27,4016.219,2210.447,151.4458,0,0,0,0,100,0),
+(@PATH,28,4005.469,2209.197,151.6958,0,0,0,0,100,0);
+
+-- 16. Anub'ar Slayer
+SET @NPC := 118335;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3970.062,`position_y`=2237.138,`position_z`=153.7731 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,3970.062,2237.138,153.7731,0,0,0,0,100,0),
+(@PATH,2,3967.577,2253.226,153.2326,0,0,0,0,100,0),
+(@PATH,3,3964.077,2260.976,152.7326,0,0,0,0,100,0),
+(@PATH,4,3963.106,2263.034,152.7173,0,0,0,0,100,0),
+(@PATH,5,3961.356,2275.784,152.9673,0,0,0,0,100,0),
+(@PATH,6,3960.891,2277.954,153.3624,0,0,0,0,100,0),
+(@PATH,7,3959.641,2284.954,153.8624,0,0,0,0,100,0),
+(@PATH,8,3957.175,2297.546,154.1199,0,0,0,0,100,0),
+(@PATH,9,3956.175,2307.296,153.3699,0,0,0,0,100,0),
+(@PATH,10,3956.242,2307.533,153.4977,0,0,0,0,100,0),
+(@PATH,11,3955.742,2309.533,152.9977,0,0,0,0,100,0),
+(@PATH,12,3955.747,2309.407,153.1538,0,0,0,0,100,0),
+(@PATH,13,3957.747,2312.157,153.1538,0,0,0,0,100,0),
+(@PATH,14,3971.592,2305.814,153.3934,0,0,0,0,100,0),
+(@PATH,15,3985.419,2296.134,153.4173,0,0,0,0,100,0),
+(@PATH,16,4009.744,2292.559,153.3901,0,0,0,0,100,0),
+(@PATH,17,4015.282,2288.613,153.3869,0,0,0,0,100,0),
+(@PATH,18,4001.299,2275.213,153.8408,0,0,0,0,100,0),
+(@PATH,19,3992.609,2261.018,153.8559,0,0,0,0,100,0),
+(@PATH,20,3987.102,2248.558,153.8537,0,0,0,0,100,0),
+(@PATH,21,3984.205,2234.281,153.8388,0,0,0,0,100,0),
+(@PATH,22,3973.837,2230.619,153.7842,0,0,0,0,100,0);
+
+-- 17. Anub'ar Slayer
+SET @NPC := 118344;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4060.756,`position_y`=2300.505,`position_z`=153.4154 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,4060.756,2300.505,153.4154,0,0,0,0,100,0),
+(@PATH,2,4071.397,2296.292,153.4246,0,0,0,0,100,0),
+(@PATH,3,4057.885,2300.982,153.4254,0,0,0,0,100,0),
+(@PATH,4,4061.49,2312.533,153.3956,0,0,0,0,100,0),
+(@PATH,5,4066.662,2320.948,153.8885,0,0,0,0,100,0),
+(@PATH,6,4068.662,2326.448,154.1385,0,0,0,0,100,0),
+(@PATH,7,4071.662,2334.698,153.6385,0,0,0,0,100,0),
+(@PATH,8,4073.662,2340.448,153.1385,0,0,0,0,100,0),
+(@PATH,9,4060.071,2311.051,153.4047,0,0,0,0,100,0),
+(@PATH,10,4057.031,2301.023,153.4251,0,0,0,0,100,0),
+(@PATH,11,4050.862,2301.405,153.4218,0,0,0,0,100,0),
+(@PATH,12,4044.272,2315.798,153.4188,0,0,0,0,100,0),
+(@PATH,13,4050.357,2301.207,153.4071,0,0,0,0,100,0),
+(@PATH,14,4060.813,2300.465,153.4154,0,0,0,0,100,0);
+
+-- 18. Anub'ar Cultist
+SET @NPC := 115441;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3917.657,`position_y`=2278.222,`position_z`=156.1354 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,3917.657,2278.222,156.1354,0,0,0,0,100,0),
+(@PATH,2,3917.407,2280.222,156.1354,0,0,0,0,100,0),
+(@PATH,3,3917.407,2280.722,156.1354,0,0,0,0,100,0),
+(@PATH,4,3915.607,2285.841,156.0321,0,0,0,0,100,0),
+(@PATH,5,3911.107,2286.091,155.7821,0,0,0,0,100,0),
+(@PATH,6,3902.198,2287.176,156.0034,0,0,0,0,100,0),
+(@PATH,7,3902.448,2288.926,155.7534,0,0,0,0,100,0),
+(@PATH,8,3903.641,2292.737,156.0834,0,0,0,0,100,0),
+(@PATH,9,3912.391,2292.987,155.8334,0,0,0,0,100,0),
+(@PATH,10,3923.641,2292.987,156.0834,0,0,0,0,100,0),
+(@PATH,11,3924.891,2292.987,156.0834,0,0,0,0,100,0),
+(@PATH,12,3926.891,2292.987,156.0834,0,0,0,0,100,0),
+(@PATH,13,3929.141,2292.987,156.0834,0,0,0,0,100,0),
+(@PATH,14,3934.63,2293.24,156.3628,0,0,0,0,100,0),
+(@PATH,15,3941.13,2293.49,156.3628,0,0,0,0,100,0),
+(@PATH,16,3943.656,2293.474,156.801,0,0,0,0,100,0),
+(@PATH,17,3944.156,2292.474,157.051,0,0,0,0,100,0),
+(@PATH,18,3945.406,2291.474,156.051,0,0,0,0,100,0),
+(@PATH,19,3943.8,2292.437,157.0001,0,0,0,0,100,0),
+(@PATH,20,3945.3,2291.437,156.5001,0,0,0,0,100,0),
+(@PATH,21,3946.8,2291.687,156.5001,0,0,0,0,100,0),
+(@PATH,22,3945.8,2291.437,156.5001,0,0,0,0,100,0),
+(@PATH,23,3943.8,2291.437,157.0001,0,0,0,0,100,0),
+(@PATH,24,3943.81,2291.189,156.8792,0,0,0,0,100,0),
+(@PATH,25,3941.81,2290.689,156.8792,0,0,0,0,100,0),
+(@PATH,26,3938.06,2289.939,156.1292,0,0,0,0,100,0),
+(@PATH,27,3937.31,2289.689,156.1292,0,0,0,0,100,0),
+(@PATH,28,3931.099,2288.141,156.2034,0,0,0,0,100,0),
+(@PATH,29,3924.599,2286.891,156.2034,0,0,0,0,100,0),
+(@PATH,30,3920.643,2285.524,156.0675,0,0,0,0,100,0),
+(@PATH,31,3920.143,2280.024,156.0675,0,0,0,0,100,0),
+(@PATH,32,3919.918,2279.734,156.1382,0,0,0,0,100,0),
+(@PATH,33,3919.668,2278.984,156.3882,0,0,0,0,100,0),
+(@PATH,34,3919.168,2274.234,155.6382,0,0,0,0,100,0),
+(@PATH,35,3918.668,2271.234,154.3882,0,0,0,0,100,0),
+(@PATH,36,3918.668,2268.984,153.8882,0,0,0,0,100,0),
+(@PATH,37,3918.418,2267.234,152.1382,0,0,0,0,100,0),
+(@PATH,38,3918.168,2264.234,152.1382,0,0,0,0,100,0),
+(@PATH,39,3917.713,2260.755,152.2809,0,0,0,0,100,0),
+(@PATH,40,3917.963,2258.005,154.2809,0,0,0,0,100,0),
+(@PATH,41,3918.213,2254.755,155.0309,0,0,0,0,100,0),
+(@PATH,42,3918.463,2252.755,156.0309,0,0,0,0,100,0),
+(@PATH,43,3918.463,2251.505,156.2809,0,0,0,0,100,0),
+(@PATH,44,3918.463,2248.755,157.2809,0,0,0,0,100,0),
+(@PATH,45,3918.713,2247.755,157.5309,0,0,0,0,100,0),
+(@PATH,46,3919.44,2242.737,157.4948,0,0,0,0,100,0),
+(@PATH,47,3919.44,2236.487,157.4948,0,0,0,0,100,0),
+(@PATH,48,3919.69,2235.237,157.4948,0,0,0,0,100,0),
+(@PATH,49,3919.94,2228.237,157.4948,0,0,0,0,100,0),
+(@PATH,50,3920.011,2227.837,157.7705,0,0,0,0,100,0),
+(@PATH,51,3920.261,2226.337,157.7705,0,0,0,0,100,0),
+(@PATH,52,3917.761,2226.087,157.7705,0,0,0,0,100,0),
+(@PATH,53,3913.511,2226.087,158.5205,0,0,0,0,100,0),
+(@PATH,54,3910.011,2225.837,158.5205,0,0,0,0,100,0),
+(@PATH,55,3906.261,2225.837,158.5205,0,0,0,0,100,0),
+(@PATH,56,3906.265,2225.49,158.5531,0,0,0,0,100,0),
+(@PATH,57,3903.765,2225.49,158.5531,0,0,0,0,100,0),
+(@PATH,58,3909.09,2222.621,158.5044,0,0,0,0,100,0),
+(@PATH,59,3912.09,2223.121,158.5044,0,0,0,0,100,0),
+(@PATH,60,3914.09,2223.371,158.5044,0,0,0,0,100,0),
+(@PATH,61,3918.09,2224.121,157.7544,0,0,0,0,100,0),
+(@PATH,62,3918.257,2223.936,157.84,0,0,0,0,100,0),
+(@PATH,63,3919.757,2224.436,157.59,0,0,0,0,100,0),
+(@PATH,64,3920.507,2228.186,157.59,0,0,0,0,100,0),
+(@PATH,65,3922.058,2234.071,157.4997,0,0,0,0,100,0),
+(@PATH,66,3922.058,2235.321,157.4997,0,0,0,0,100,0),
+(@PATH,67,3922.308,2243.071,157.4997,0,0,0,0,100,0),
+(@PATH,68,3922.683,2248.108,157.3182,0,0,0,0,100,0),
+(@PATH,69,3922.183,2250.358,156.8182,0,0,0,0,100,0),
+(@PATH,70,3921.683,2253.108,156.0682,0,0,0,0,100,0),
+(@PATH,71,3921.433,2256.358,154.5682,0,0,0,0,100,0),
+(@PATH,72,3920.933,2258.358,154.3182,0,0,0,0,100,0),
+(@PATH,73,3920.324,2260.745,152.242,0,0,0,0,100,0),
+(@PATH,74,3919.824,2264.245,152.242,0,0,0,0,100,0),
+(@PATH,75,3919.324,2267.245,152.242,0,0,0,0,100,0),
+(@PATH,76,3919.324,2268.245,153.492,0,0,0,0,100,0),
+(@PATH,77,3919.074,2271.245,154.492,0,0,0,0,100,0),
+(@PATH,78,3918.574,2274.245,155.492,0,0,0,0,100,0);
+--