DB/Pathing/Emotes: Northern Barrens - Part 1

* updates 15181

1 files changed, 885 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_31_03_world.sql b/sql/updates/world/2015_07_31_03_world.sql
new file mode 100644
index 00000000000..060ee888745
--- /dev/null
+++ b/sql/updates/world/2015_07_31_03_world.sql
@@ -0,0 +1,885 @@
+-- DB/Pathing: Northern Barrens
+UPDATE `creature` SET `spawndist`=15, `MovementType`=1 WHERE  `id` IN (3255,3416,3245,3415,3242,3246,3425,3248,3244,34640,44166);
+UPDATE `creature` SET `spawndist`=6, `MovementType`=1 WHERE  `id` IN (3271,34545,3269,3267,3265);
+UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE  `id` IN (3268,3266);
+UPDATE `creature` SET `spawndist`=10, `MovementType`=1 WHERE  `id` IN (44164,3256,34503);
+UPDATE `creature_template` SET `InhabitType`=4 WHERE  `entry` IN (34640,44057);
+UPDATE `creature_template` SET `flags_extra`=128 WHERE  `entry` IN (34641,34641);
+UPDATE `creature` SET `spawndist`=10, `MovementType`=01 WHERE  `guid`=303973;
+
+-- cook
+-- Lokarbo SAI
+SET @ENTRY := 43956;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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,0,0,1,0,100,0,1000,1000,30000,30000,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Lokarbo - Out of Combat - Run Script");
+-- Actionlist SAI
+SET @ENTRY := 4395600;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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,9,0,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,5.511383,"On Script - Set Orientation 5,511383"),
+(@ENTRY,9,1,0,0,0,100,0,0,0,0,0,17,233,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Emote State 28"),
+(@ENTRY,9,2,0,0,0,100,0,8000,8000,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,3.327976,"On Script - Set Orientation 3,327976"),
+(@ENTRY,9,3,0,0,0,100,0,0,0,0,0,17,69,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Emote State 69"),
+(@ENTRY,9,4,0,0,0,100,0,10000,10000,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Set Emote State 0");
+
+-- Dorak SAI
+SET @ENTRY := 34284;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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,0,0,25,0,100,0,0,0,0,0,53,1,34284,1,0,0,0,1,0,0,0,0,0,0,0,"Dorak - On Reset - Start Waypoint"),
+(@ENTRY,0,1,0,40,0,100,0,2,34284,0,0,54,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dorak - On Waypoint 2 Reached - Pause Waypoint"),
+(@ENTRY,0,2,3,40,0,100,0,4,34284,0,0,5,15,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dorak - On Waypoint 4 Reached - Play Emote 15"),
+(@ENTRY,0,3,0,61,0,100,0,4,34284,0,0,54,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Dorak - On Waypoint 4 Reached - Pause Waypoint");
+
+DELETE FROM `waypoints` WHERE `entry`=34284;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
+(34284, 1, 68.3908, -3655.05, 27.2275, 'Dorak'),
+(34284, 2, 65.6666, -3654.42, 27.2899, 'Dorak'),
+(34284, 3, 70.9096, -3618.55, 28.506, 'Dorak'),
+(34284, 4, 68.826, -3618.87, 28.6913, 'Dorak');
+
+-- sleep
+DELETE FROM `creature_addon` WHERE `guid` IN (303735, 303733);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(303735,0,0,3,1,0, ''),
+(303733,0,0,3,1,0, '');
+
+DELETE FROM `creature_addon` WHERE `guid` IN (302190);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(302190,0,0,1,1,0, '');
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=303909;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(303909, 303909, 0, 0, 2, 0, 0),
+(303909, 303907, 3, 45, 2, 0, 0),
+(303909, 303908, 3, 315, 2, 0, 0);
+
+-- griaffe
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=302229;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(302229, 302229, 0, 0, 2, 0, 0),
+(302229, 302225, 4, 0, 2, 0, 0),
+(302229, 302227, 10, 0, 2, 0, 0),
+(302229, 302230, 6, 60, 2, 0, 0),
+(302229, 302231, 6, 300, 2, 0, 0),
+(302229, 302228, 8, 60, 2, 0, 0),
+(302229, 302232, 8, 300, 2, 0, 0);
+
+SET @NPC := 302229;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-591.0389,`position_y`=-3562.209,`position_z`=91.78902 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-591.0389,`position_y`=-3562.209,`position_z`=91.78902 WHERE `guid` IN (302225,302227,302230,302231,302228,302232);
+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,-591.0389,-3562.209,91.78902,0,0,0,0,100,0),
+(@PATH,2,-588.0886,-3562.99,91.78535,0,0,0,0,100,0),
+(@PATH,3,-585.0549,-3564.003,91.90669,0,0,0,0,100,0),
+(@PATH,4,-582.8528,-3564.795,91.9189,0,0,0,0,100,0),
+(@PATH,5,-579.9396,-3565.619,91.78902,0,0,0,0,100,0),
+(@PATH,6,-577.1524,-3566.757,91.789,0,0,0,0,100,0),
+(@PATH,7,-575.1255,-3568.542,91.82635,0,0,0,0,100,0),
+(@PATH,8,-573.8477,-3570.814,91.92499,0,0,0,0,100,0),
+(@PATH,9,-572.8024,-3573.548,92.12836,0,0,0,0,100,0),
+(@PATH,10,-571.886,-3576.283,92.44159,0,0,0,0,100,0),
+(@PATH,11,-572.1017,-3578.838,92.68695,0,0,0,0,100,0),
+(@PATH,12,-573.5018,-3578.973,92.87691,0,0,0,0,100,0),
+(@PATH,13,-574.4412,-3581.29,93.31703,0,0,0,0,100,0),
+(@PATH,14,-577.8175,-3585.935,92.88861,0,0,0,0,100,0),
+(@PATH,15,-580.2591,-3587.313,92.7204,0,0,0,0,100,0),
+(@PATH,16,-581.8243,-3588.061,92.62587,0,0,0,0,100,0),
+(@PATH,17,-582.5677,-3588.407,92.44985,0,0,0,0,100,0),
+(@PATH,18,-586.3956,-3591.548,92.27977,0,0,0,0,100,0),
+(@PATH,19,-590.0269,-3594.148,91.80365,0,0,0,0,100,0),
+(@PATH,20,-592.6264,-3595.693,91.74335,0,0,0,0,100,0),
+(@PATH,21,-591.7633,-3594.55,91.914,0,0,0,0,100,0),
+(@PATH,22,-594.2666,-3595.932,91.789,0,0,0,0,100,0),
+(@PATH,23,-596.7737,-3597.263,91.789,0,0,0,0,100,0),
+(@PATH,24,-599.3653,-3598.417,91.789,0,0,0,0,100,0),
+(@PATH,25,-602.0683,-3599.218,91.789,0,0,0,0,100,0),
+(@PATH,26,-608.798,-3601.819,91.789,0,0,0,0,100,0),
+(@PATH,27,-611.4841,-3602.583,91.789,0,0,0,0,100,0),
+(@PATH,28,-614.0052,-3602.638,91.789,0,0,0,0,100,0),
+(@PATH,29,-616.5444,-3603.393,91.789,0,0,0,0,100,0),
+(@PATH,30,-619.3514,-3604.509,91.789,0,0,0,0,100,0),
+(@PATH,31,-621.8402,-3604.911,91.789,0,0,0,0,100,0),
+(@PATH,32,-625.0182,-3605.715,91.789,0,0,0,0,100,0),
+(@PATH,33,-627.6204,-3606.449,91.789,0,0,0,0,100,0),
+(@PATH,34,-630.657,-3606.701,91.789,0,0,0,0,100,0),
+(@PATH,35,-633.3206,-3606.75,91.789,0,0,0,0,100,0),
+(@PATH,36,-636.3915,-3606.781,91.789,0,0,0,0,100,0),
+(@PATH,37,-639.5804,-3606.751,91.789,0,0,0,0,100,0),
+(@PATH,38,-642.2101,-3606.655,91.789,0,0,0,0,100,0),
+(@PATH,39,-645.3203,-3606.528,92.03998,0,0,0,0,100,0),
+(@PATH,40,-646.5802,-3606.649,92.82047,0,0,0,0,100,0),
+(@PATH,41,-646.8903,-3606.391,92.65396,0,0,0,0,100,0),
+(@PATH,42,-649.4845,-3606.254,93.11131,0,0,0,0,100,0),
+(@PATH,43,-657.1104,-3605.572,93.414,0,0,0,0,100,0),
+(@PATH,44,-660.3222,-3605.726,93.48773,0,0,0,0,100,0),
+(@PATH,45,-662.9648,-3605.028,93.42059,0,0,0,0,100,0),
+(@PATH,46,-665.6725,-3604.86,93.289,0,0,0,0,100,0),
+(@PATH,47,-668.2249,-3604.24,93.08726,0,0,0,0,100,0),
+(@PATH,48,-670.7357,-3603.466,92.76475,0,0,0,0,100,0),
+(@PATH,49,-671.9227,-3603.059,92.78248,0,0,0,0,100,0),
+(@PATH,50,-675.7313,-3602.044,92.52003,0,0,0,0,100,0),
+(@PATH,51,-677.6043,-3601.047,92.2177,0,0,0,0,100,0),
+(@PATH,52,-681.8926,-3599.867,91.96063,0,0,0,0,100,0),
+(@PATH,53,-684.6117,-3598.757,91.87982,0,0,0,0,100,0),
+(@PATH,54,-687.5937,-3597.957,92.11273,0,0,0,0,100,0),
+(@PATH,55,-690.8465,-3596.58,92.50311,0,0,0,0,100,0),
+(@PATH,56,-692.3484,-3596.191,92.81978,0,0,0,0,100,0),
+(@PATH,57,-694.0055,-3595.339,93.0874,0,0,0,0,100,0),
+(@PATH,58,-695.764,-3594.879,93.66331,0,0,0,0,100,0),
+(@PATH,59,-701.9249,-3592.232,93.66936,0,0,0,0,100,0),
+(@PATH,60,-704.3012,-3590.704,93.48577,0,0,0,0,100,0),
+(@PATH,61,-706.813,-3589.036,93.29095,0,0,0,0,100,0),
+(@PATH,62,-708.6758,-3587.299,92.91399,0,0,0,0,100,0),
+(@PATH,63,-710.1832,-3586.387,93.01859,0,0,0,0,100,0),
+(@PATH,64,-713.3809,-3583.783,92.53899,0,0,0,0,100,0),
+(@PATH,65,-715.8456,-3581.733,92.28436,0,0,0,0,100,0),
+(@PATH,66,-718.649,-3580.066,92.16399,0,0,0,0,100,0),
+(@PATH,67,-720.6063,-3577.95,92.0805,0,0,0,0,100,0),
+(@PATH,68,-723.4074,-3576.25,92.0014,0,0,0,0,100,0),
+(@PATH,69,-725.6078,-3573.994,92.03899,0,0,0,0,100,0),
+(@PATH,70,-727.5848,-3571.5,92.03899,0,0,0,0,100,0),
+(@PATH,71,-729.4189,-3569.032,92.28899,0,0,0,0,100,0),
+(@PATH,72,-730.7903,-3566.254,92.53338,0,0,0,0,100,0),
+(@PATH,73,-731.6673,-3564.373,93.06799,0,0,0,0,100,0),
+(@PATH,74,-732.3871,-3562.424,93.09393,0,0,0,0,100,0),
+(@PATH,75,-733.1938,-3560.417,93.48034,0,0,0,0,100,0),
+(@PATH,76,-734.6166,-3557.735,93.83107,0,0,0,0,100,0),
+(@PATH,77,-735.9352,-3554.624,94.33328,0,0,0,0,100,0),
+(@PATH,78,-737.334,-3551.588,94.92009,0,0,0,0,100,0),
+(@PATH,79,-739.1,-3547.732,95.28485,0,0,0,0,100,0),
+(@PATH,80,-741.614,-3542.833,95.14137,0,0,0,0,100,0),
+(@PATH,81,-742.9312,-3539.958,95.12404,0,0,0,0,100,0),
+(@PATH,82,-744.3644,-3537.052,95.1526,0,0,0,0,100,0),
+(@PATH,83,-745.7712,-3534.205,95.19655,0,0,0,0,100,0),
+(@PATH,84,-747.1898,-3531.362,94.88484,0,0,0,0,100,0),
+(@PATH,85,-748.1395,-3528.405,94.65486,0,0,0,0,100,0),
+(@PATH,86,-748.5651,-3525.977,94.7002,0,0,0,0,100,0),
+(@PATH,87,-749.6279,-3522.432,94.45174,0,0,0,0,100,0),
+(@PATH,88,-750.2421,-3519.614,94.27547,0,0,0,0,100,0),
+(@PATH,89,-750.8396,-3516.76,94.25764,0,0,0,0,100,0),
+(@PATH,90,-751.4366,-3513.932,94.43391,0,0,0,0,100,0),
+(@PATH,91,-751.9617,-3511.058,94.43391,0,0,0,0,100,0),
+(@PATH,92,-752.6078,-3508.198,94.30891,0,0,0,0,100,0),
+(@PATH,93,-753.1934,-3505.341,94.30891,0,0,0,0,100,0),
+(@PATH,94,-753.7323,-3502.419,94.18391,0,0,0,0,100,0),
+(@PATH,95,-754.5886,-3499.677,94.03899,0,0,0,0,100,0),
+(@PATH,96,-755.6948,-3497.097,94.00726,0,0,0,0,100,0),
+(@PATH,97,-756.7603,-3494.525,93.69573,0,0,0,0,100,0),
+(@PATH,98,-758.2226,-3492.105,93.78899,0,0,0,0,100,0),
+(@PATH,99,-759.3184,-3489.649,93.42864,0,0,0,0,100,0),
+(@PATH,100,-760.5809,-3487.283,93.24358,0,0,0,0,100,0),
+(@PATH,101,-761.8428,-3485.018,92.945,0,0,0,0,100,0),
+(@PATH,102,-762.8008,-3483.016,92.78899,0,0,0,0,100,0),
+(@PATH,103,-763.4695,-3481.628,92.80417,0,0,0,0,100,0),
+(@PATH,104,-764.3606,-3480.023,92.53007,0,0,0,0,100,0),
+(@PATH,105,-766.5647,-3476.683,92.25404,0,0,0,0,100,0),
+(@PATH,106,-769.0477,-3472.472,91.78899,0,0,0,0,100,0),
+(@PATH,107,-770.8193,-3469.862,91.78899,0,0,0,0,100,0),
+(@PATH,108,-772.8027,-3467.112,91.78899,0,0,0,0,100,0),
+(@PATH,109,-773.9666,-3464.927,91.78899,0,0,0,0,100,0),
+(@PATH,110,-775.5773,-3462.215,91.76067,0,0,0,0,100,0),
+(@PATH,111,-779.5476,-3455.479,92.90218,0,0,0,0,100,0),
+(@PATH,112,-782.7976,-3450.229,93.15218,0,0,0,0,100,0),
+(@PATH,113,-786.5476,-3443.729,93.90218,0,0,0,0,100,0),
+(@PATH,114,-793.527,-3432.37,94.1869,0,0,0,0,100,0),
+(@PATH,115,-782.027,-3407.12,93.6869,0,0,0,0,100,0),
+(@PATH,116,-781.7552,-3406.848,93.47012,0,0,0,0,100,0),
+(@PATH,117,-781.5052,-3406.098,93.47012,0,0,0,0,100,0),
+(@PATH,118,-776.7552,-3404.848,93.22012,0,0,0,0,100,0),
+(@PATH,119,-769.7552,-3403.098,92.47012,0,0,0,0,100,0),
+(@PATH,120,-745.0052,-3396.848,93.22012,0,0,0,0,100,0),
+(@PATH,121,-738.2552,-3395.098,93.72012,0,0,0,0,100,0),
+(@PATH,122,-732.7543,-3393.786,93.64067,0,0,0,0,100,0),
+(@PATH,123,-726.0043,-3395.536,92.89067,0,0,0,0,100,0),
+(@PATH,124,-721.5043,-3397.036,92.64067,0,0,0,0,100,0),
+(@PATH,125,-709.2111,-3400.296,92.15369,0,0,0,0,100,0),
+(@PATH,126,-685.7111,-3424.296,92.65369,0,0,0,0,100,0),
+(@PATH,127,-682.2111,-3428.046,93.15369,0,0,0,0,100,0),
+(@PATH,128,-678.9978,-3431.148,93.69975,0,0,0,0,100,0),
+(@PATH,129,-673.4978,-3437.148,94.19975,0,0,0,0,100,0),
+(@PATH,130,-662.4978,-3449.398,94.69975,0,0,0,0,100,0),
+(@PATH,131,-655.7478,-3456.898,95.19975,0,0,0,0,100,0),
+(@PATH,132,-655.4231,-3457.169,95.37837,0,0,0,0,100,0),
+(@PATH,133,-654.9231,-3457.669,95.37837,0,0,0,0,100,0),
+(@PATH,134,-653.1731,-3469.419,94.62837,0,0,0,0,100,0),
+(@PATH,135,-652.1731,-3475.169,94.12837,0,0,0,0,100,0),
+(@PATH,136,-651.1731,-3480.169,93.37837,0,0,0,0,100,0),
+(@PATH,137,-650.4231,-3484.919,93.12837,0,0,0,0,100,0),
+(@PATH,138,-649.6731,-3489.919,92.37837,0,0,0,0,100,0),
+(@PATH,139,-648.5933,-3494.768,92.15804,0,0,0,0,100,0),
+(@PATH,140,-639.0933,-3508.518,92.65804,0,0,0,0,100,0),
+(@PATH,141,-634.0231,-3515.702,92.99541,0,0,0,0,100,0),
+(@PATH,142,-633.7731,-3541.452,92.49541,0,0,0,0,100,0),
+(@PATH,143,-633.5231,-3546.452,92.24541,0,0,0,0,100,0),
+(@PATH,144,-633.3118,-3555.671,92.03901,0,0,0,0,100,0),
+(@PATH,145,-604.2021,-3557.557,91.94941,0,0,0,0,100,0);
+
+-- king reaperclaw
+SET @NPC := 303909;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-566.8538,`position_y`=-3476.528,`position_z`=92.06723 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-566.8538,`position_y`=-3476.528,`position_z`=92.06723 WHERE `guid` IN (303907,303908);
+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,-566.8538,-3476.528,92.06723,0,0,0,0,100,0),
+(@PATH,2,-550.5098,-3505.429,92.03902,0,0,0,0,100,0),
+(@PATH,3,-548.5079,-3530.607,92.31209,0,0,0,0,100,0),
+(@PATH,4,-553.7579,-3554.857,92.81209,0,0,0,0,100,0),
+(@PATH,5,-554.7579,-3558.607,93.31209,0,0,0,0,100,0),
+(@PATH,6,-556.0079,-3564.607,93.81209,0,0,0,0,100,0),
+(@PATH,7,-540.9332,-3572.965,93.56209,0,0,0,0,100,0),
+(@PATH,8,-529.1832,-3577.715,93.06209,0,0,0,0,100,0),
+(@PATH,9,-556.561,-3565.557,93.83516,0,0,0,0,100,0),
+(@PATH,10,-556.7917,-3566.53,93.83516,0,0,0,0,100,0),
+(@PATH,11,-541.0859,-3573.07,93.28434,0,0,0,0,100,0),
+(@PATH,12,-529.0762,-3578.072,92.66402,0,0,0,0,100,0),
+(@PATH,13,-503.0746,-3588.901,93.28902,0,0,0,0,100,0),
+(@PATH,14,-503.0746,-3588.901,93.28902,0,0,0,0,100,0),
+(@PATH,15,-502.7176,-3588.561,93.52411,0,0,0,0,100,0),
+(@PATH,16,-490.4676,-3578.311,92.77411,0,0,0,0,100,0),
+(@PATH,17,-486.2176,-3574.811,92.52411,0,0,0,0,100,0),
+(@PATH,18,-471.9316,-3562.915,92.14691,0,0,0,0,100,0),
+(@PATH,19,-452.4316,-3546.415,92.64691,0,0,0,0,100,0),
+(@PATH,20,-447.6816,-3542.415,93.14691,0,0,0,0,100,0),
+(@PATH,21,-438.3602,-3535.648,94.10231,0,0,0,0,100,0),
+(@PATH,22,-420.6102,-3524.398,93.85231,0,0,0,0,100,0),
+(@PATH,23,-406.3602,-3515.648,94.35231,0,0,0,0,100,0),
+(@PATH,24,-399.6102,-3511.398,94.85231,0,0,0,0,100,0),
+(@PATH,25,-395.988,-3508.799,94.98924,0,0,0,0,100,0),
+(@PATH,26,-381.988,-3504.799,94.23924,0,0,0,0,100,0),
+(@PATH,27,-375.238,-3502.799,93.98924,0,0,0,0,100,0),
+(@PATH,28,-375.0091,-3502.714,93.67376,0,0,0,0,100,0),
+(@PATH,29,-373.7591,-3502.464,93.42376,0,0,0,0,100,0),
+(@PATH,30,-369.0091,-3500.964,93.17376,0,0,0,0,100,0),
+(@PATH,31,-343.8214,-3492.741,93.43587,0,0,0,0,100,0),
+(@PATH,32,-331.3214,-3485.241,92.93587,0,0,0,0,100,0),
+(@PATH,33,-331.7682,-3487.515,92.85645,0,0,0,0,100,0),
+(@PATH,34,-351.7682,-3505.765,92.60645,0,0,0,0,100,0),
+(@PATH,35,-370.7682,-3523.265,93.10645,0,0,0,0,100,0),
+(@PATH,36,-379.5182,-3531.265,93.60645,0,0,0,0,100,0),
+(@PATH,37,-398.6083,-3548.753,93.68606,0,0,0,0,100,0),
+(@PATH,38,-408.6083,-3549.253,93.43606,0,0,0,0,100,0),
+(@PATH,39,-435.6406,-3548.522,93.08662,0,0,0,0,100,0),
+(@PATH,40,-469.6406,-3538.022,92.58662,0,0,0,0,100,0),
+(@PATH,41,-485.8906,-3532.772,93.08662,0,0,0,0,100,0),
+(@PATH,42,-487.4649,-3532.506,93.03902,0,0,0,0,100,0),
+(@PATH,43,-495.7149,-3536.256,92.28902,0,0,0,0,100,0),
+(@PATH,44,-583.8541,-3541.175,92.61128,0,0,0,0,100,0),
+(@PATH,45,-588.9537,-3538.207,93.17204,0,0,0,0,100,0),
+(@PATH,46,-600.6988,-3516.983,93.60151,0,0,0,0,100,0),
+(@PATH,47,-589.9488,-3503.733,93.10151,0,0,0,0,100,0),
+(@PATH,48,-586.1988,-3499.483,92.35151,0,0,0,0,100,0),
+(@PATH,49,-566.9017,-3476.687,92.04884,0,0,0,0,100,0);
+
+-- frenzy
+SET @NPC := 303882;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-201.8419,`position_y`=-3295.316,`position_z`=91.79166 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,-201.8419,-3295.316,91.79166,0,0,0,0,100,0),
+(@PATH,2,-201.9289,-3296.312,91.79166,0,0,0,0,100,0),
+(@PATH,3,-203.8269,-3309.191,91.79166,0,0,0,0,100,0),
+(@PATH,4,-203.8269,-3309.191,91.79166,0,0,0,0,100,0),
+(@PATH,5,-203.7439,-3309.169,92.04166,0,0,0,0,100,0),
+(@PATH,6,-216.8094,-3314.094,92.04166,0,0,0,0,100,0),
+(@PATH,7,-224.0224,-3330.115,92.04166,0,0,0,0,100,0),
+(@PATH,8,-217.293,-3338.208,92.04166,0,0,0,0,100,0),
+(@PATH,9,-207.4327,-3345.059,92.04166,0,0,0,0,100,0),
+(@PATH,10,-197.7908,-3355.164,92.23478,0,0,0,0,100,0),
+(@PATH,11,-188.0408,-3359.414,92.48478,0,0,0,0,100,0),
+(@PATH,12,-182.4595,-3361.769,93.52293,0,0,0,0,100,0),
+(@PATH,13,-180.9595,-3359.269,94.02293,0,0,0,0,100,0),
+(@PATH,14,-178.9595,-3355.769,94.77293,0,0,0,0,100,0),
+(@PATH,15,-176.7095,-3352.769,95.27293,0,0,0,0,100,0),
+(@PATH,16,-171.6927,-3345.522,95.63161,0,0,0,0,100,0),
+(@PATH,17,-167.9427,-3339.522,94.88161,0,0,0,0,100,0),
+(@PATH,18,-166.1927,-3336.272,94.13161,0,0,0,0,100,0),
+(@PATH,19,-163.4427,-3332.022,93.88161,0,0,0,0,100,0),
+(@PATH,20,-159.5975,-3325.357,93.19179,0,0,0,0,100,0),
+(@PATH,21,-159.0975,-3318.357,92.44179,0,0,0,0,100,0),
+(@PATH,22,-158.4869,-3308.573,91.88663,0,0,0,0,100,0),
+(@PATH,23,-168.7532,-3291.879,92.04166,0,0,0,0,100,0),
+(@PATH,24,-182.9655,-3279.95,92.04166,0,0,0,0,100,0),
+(@PATH,25,-200.6937,-3286.16,92.04166,0,0,0,0,100,0),
+(@PATH,26,-202.0485,-3296.343,92.04166,0,0,0,0,100,0);
+
+-- hunter
+SET @NPC := 303878;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-208.3682,`position_y`=-3342.525,`position_z`=92.05386 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,-208.3682,-3342.525,92.05386,0,0,0,0,100,0),
+(@PATH,2,-221.1996,-3329.735,92.04166,0,0,0,0,100,0),
+(@PATH,3,-211.2382,-3320.357,92.04166,0,0,0,0,100,0),
+(@PATH,4,-194.4217,-3312.745,92.04166,0,0,0,0,100,0),
+(@PATH,5,-172.8744,-3303.235,91.95402,0,0,0,0,100,0),
+(@PATH,6,-159.1244,-3318.485,92.70402,0,0,0,0,100,0),
+(@PATH,7,-151.8711,-3326.484,92.28525,0,0,0,0,100,0),
+(@PATH,8,-135.2233,-3342.244,92.7538,0,0,0,0,100,0),
+(@PATH,9,-125.2233,-3347.994,93.0038,0,0,0,0,100,0),
+(@PATH,10,-121.2599,-3350.426,93.52101,0,0,0,0,100,0),
+(@PATH,11,-110.2599,-3360.426,94.02101,0,0,0,0,100,0),
+(@PATH,12,-97.79968,-3371.532,94.08496,0,0,0,0,100,0),
+(@PATH,13,-101.0497,-3379.532,93.58496,0,0,0,0,100,0),
+(@PATH,14,-102.8393,-3383.885,93.25633,0,0,0,0,100,0),
+(@PATH,15,-107.0893,-3387.635,92.75633,0,0,0,0,100,0),
+(@PATH,16,-107.2332,-3388.044,92.6341,0,0,0,0,100,0),
+(@PATH,17,-108.9832,-3389.544,92.3841,0,0,0,0,100,0),
+(@PATH,18,-120.9832,-3395.794,91.8841,0,0,0,0,100,0),
+(@PATH,19,-125.4994,-3398.227,91.87676,0,0,0,0,100,0),
+(@PATH,20,-142.2212,-3402.677,91.72403,0,0,0,0,100,0),
+(@PATH,21,-151.8671,-3387.656,92.12762,0,0,0,0,100,0),
+(@PATH,22,-161.6171,-3382.906,92.62762,0,0,0,0,100,0),
+(@PATH,23,-166.6171,-3380.156,93.12762,0,0,0,0,100,0),
+(@PATH,24,-174.808,-3375.611,93.24947,0,0,0,0,100,0),
+(@PATH,25,-182.308,-3367.861,92.74947,0,0,0,0,100,0),
+(@PATH,26,-191.808,-3357.861,92.24947,0,0,0,0,100,0),
+(@PATH,27,-192.6488,-3356.861,92.10658,0,0,0,0,100,0);
+
+-- Una wolfclaw
+SET @NPC := 303734;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=238.0208,`position_y`=-2899.691,`position_z`=98.10114 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,238.0208,-2899.691,98.10114,0,6000,0,0,100,0),
+(@PATH,2,237.9513,-2899.784,98.36108,0,0,0,0,100,0),
+(@PATH,3,234.7764,-2901.858,98.42511,0,0,0,0,100,0),
+(@PATH,4,233.7764,-2902.108,98.42511,0,0,0,0,100,0),
+(@PATH,5,233.5138,-2902.135,98.39661,0,0,0,0,100,0),
+(@PATH,6,231.7638,-2902.635,98.39661,0,6000,0,0,100,0);
+
+-- grunt
+SET @NPC := 303766;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=205.2726,`position_y`=-3050.228,`position_z`=91.95189 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,205.2726,-3050.228,91.95189,0,0,0,0,100,0),
+(@PATH,2,202.4913,-3040.96,91.79173,0,0,0,0,100,0);
+
+-- grunt
+SET @NPC := 303772;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=164.1702,`position_y`=-3050.721,`position_z`=91.88634 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,164.1702,-3050.721,91.88634,0,0,0,0,100,0),
+(@PATH,2,164.1702,-3051.721,91.88634,0,0,0,0,100,0),
+(@PATH,3,164.1702,-3052.971,91.88634,0,0,0,0,100,0),
+(@PATH,4,162.4202,-3053.471,91.88634,0,0,0,0,100,0),
+(@PATH,5,161.4202,-3053.471,91.88634,0,0,0,0,100,0),
+(@PATH,6,160.4202,-3053.471,91.88634,0,0,0,0,100,0),
+(@PATH,7,159.4202,-3051.721,91.88634,0,0,0,0,100,0),
+(@PATH,8,159.4202,-3049.721,91.88634,0,0,0,0,100,0),
+(@PATH,9,158.6702,-3048.721,91.88634,0,0,0,0,100,0),
+(@PATH,10,156.4202,-3045.471,91.88634,0,0,0,0,100,0),
+(@PATH,11,154.1702,-3041.721,92.63634,0,0,0,0,100,0),
+(@PATH,12,153.9202,-3040.221,91.88634,0,0,0,0,100,0),
+(@PATH,13,153.4202,-3037.471,91.88634,0,0,0,0,100,0),
+(@PATH,14,155.1495,-3043.822,92.08198,0,0,0,0,100,0),
+(@PATH,15,155.1495,-3043.822,92.08198,1.499299,5000,0,0,100,0),
+(@PATH,16,156.4431,-3045.951,91.93686,0,0,0,0,100,0),
+(@PATH,17,158.6931,-3048.701,91.93686,0,0,0,0,100,0),
+(@PATH,18,159.6931,-3049.701,91.93686,0,0,0,0,100,0),
+(@PATH,19,159.6931,-3051.951,91.93686,0,0,0,0,100,0),
+(@PATH,20,160.4431,-3053.451,91.93686,0,0,0,0,100,0),
+(@PATH,21,161.4431,-3053.451,91.93686,0,0,0,0,100,0),
+(@PATH,22,162.4431,-3053.451,91.93686,0,0,0,0,100,0),
+(@PATH,23,163.4431,-3053.451,91.93686,0,0,0,0,100,0),
+(@PATH,24,163.9431,-3051.951,91.93686,0,0,0,0,100,0),
+(@PATH,25,163.9431,-3050.701,91.93686,0,0,0,0,100,0),
+(@PATH,26,163.9431,-3049.701,91.93686,0,0,0,0,100,0),
+(@PATH,27,165.7295,-3057.622,92.71378,0,0,0,0,100,0),
+(@PATH,28,165.9795,-3059.622,93.21378,0,0,0,0,100,0),
+(@PATH,29,165.9795,-3058.872,92.71378,0,0,0,0,100,0),
+(@PATH,30,165.4795,-3055.872,92.46378,0,0,0,0,100,0),
+(@PATH,31,165.6809,-3047.897,92.04174,0,0,0,0,100,0),
+(@PATH,32,164.9309,-3049.147,92.04174,0,0,0,0,100,0),
+(@PATH,33,167.2897,-3047.926,91.79174,0,0,0,0,100,0),
+(@PATH,34,169.482,-3054.177,91.93901,0,0,0,0,100,0),
+(@PATH,35,164.2368,-3049.081,91.79174,2.726045,5000,0,0,100,0);
+
+-- guard
+SET @NPC := 303760;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=266.9732,`position_y`=-3068.487,`position_z`=97.38151 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,266.9732,-3068.487,97.38151,0,0,0,0,100,0),
+(@PATH,2,267.3316,-3069.42,97.38151,0,0,0,0,100,0),
+(@PATH,3,254.4805,-3063.842,96.66673,0,0,0,0,100,0),
+(@PATH,4,249.5504,-3061.705,96.17528,0,0,0,0,100,0),
+(@PATH,5,249.5504,-3061.705,96.17528,0,0,0,0,100,0),
+(@PATH,6,249.5054,-3061.354,96.40649,0,0,0,0,100,0),
+(@PATH,7,239.1577,-3049.697,96.35353,0,0,0,0,100,0),
+(@PATH,8,235.9471,-3044.409,97.26952,0,0,0,0,100,0),
+(@PATH,9,239.7158,-3042.681,97.22945,0,0,0,0,100,0),
+(@PATH,10,242.7158,-3047.681,96.47945,0,0,0,0,100,0),
+(@PATH,11,246.0697,-3052.966,96.40887,0,0,0,0,100,0),
+(@PATH,12,253.3197,-3063.466,96.65887,0,0,0,0,100,0),
+(@PATH,13,253.4949,-3063.718,96.79263,0,0,0,0,100,0),
+(@PATH,14,254.4949,-3065.468,96.79263,0,0,0,0,100,0),
+(@PATH,15,262.6323,-3071.087,97.20951,0,0,0,0,100,0),
+(@PATH,16,267.3316,-3069.42,97.38151,5.078908,5000,0,0,100,0);
+
+-- guard
+SET @NPC := 303757;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=173.9595,`position_y`=-3037.782,`position_z`=92.41533 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,173.9595,-3037.782,92.41533,0,0,0,0,100,0),
+(@PATH,2,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,3,173.9381,-3037.589,92.6256,0,0,0,0,100,0),
+(@PATH,4,173.4381,-3031.839,93.1256,0,0,0,0,100,0),
+(@PATH,5,173.2796,-3027.479,93.3085,0,0,0,0,100,0),
+(@PATH,6,167.9664,-3019.916,93.28297,0,0,0,0,100,0),
+(@PATH,7,165.4426,-3014.446,93.12948,0,0,0,0,100,0),
+(@PATH,8,167.0085,-3018.051,93.16674,0,0,0,0,100,0),
+(@PATH,9,162.3928,-3018.519,93.11629,0,0,0,0,100,0),
+(@PATH,10,158.3928,-3017.519,93.11629,0,0,0,0,100,0),
+(@PATH,11,156.3928,-3018.019,93.11629,0,0,0,0,100,0),
+(@PATH,12,155.3928,-3018.019,93.11629,0,0,0,0,100,0),
+(@PATH,13,154.3928,-3018.019,93.11629,0,0,0,0,100,0),
+(@PATH,14,152.8928,-3016.769,93.11629,0,0,0,0,100,0),
+(@PATH,15,151.3928,-3016.269,93.36629,0,0,0,0,100,0),
+(@PATH,16,150.1428,-3016.269,93.36629,0,0,0,0,100,0),
+(@PATH,17,149.1428,-3016.269,93.36629,0,0,0,0,100,0),
+(@PATH,18,148.1428,-3016.269,93.11629,0,0,0,0,100,0),
+(@PATH,19,156.8112,-3020.83,93.02756,0,0,0,0,100,0),
+(@PATH,20,155.3112,-3022.83,93.02756,0,0,0,0,100,0),
+(@PATH,21,155.3112,-3024.83,92.77756,0,0,0,0,100,0),
+(@PATH,22,155.3112,-3026.83,92.52756,0,0,0,0,100,0),
+(@PATH,23,154.0612,-3028.33,92.52756,0,0,0,0,100,0),
+(@PATH,24,150.3112,-3031.08,92.52756,0,0,0,0,100,0),
+(@PATH,25,155.1344,-3024.783,92.82811,0,0,0,0,100,0),
+(@PATH,26,154.1344,-3023.283,93.07811,0,0,0,0,100,0),
+(@PATH,27,153.1344,-3020.783,93.07811,0,0,0,0,100,0),
+(@PATH,28,150.1344,-3017.783,93.32811,0,0,0,0,100,0),
+(@PATH,29,149.9651,-3017.72,93.24736,0,0,0,0,100,0),
+(@PATH,30,148.7151,-3016.72,93.24736,0,0,0,0,100,0),
+(@PATH,31,145.9651,-3015.72,93.24736,0,0,0,0,100,0),
+(@PATH,32,150.9655,-3018.719,93.06583,0,0,0,0,100,0),
+(@PATH,33,149.889,-3017.419,93.293,0,0,0,0,100,0),
+(@PATH,34,148.389,-3016.419,93.293,0,0,0,0,100,0),
+(@PATH,35,146.139,-3015.419,93.293,0,0,0,0,100,0),
+(@PATH,36,145.639,-3012.419,93.293,0,0,0,0,100,0),
+(@PATH,37,145.3474,-3010.09,93.06033,0,0,0,0,100,0),
+(@PATH,38,144.8474,-3008.34,92.81033,0,0,0,0,100,0),
+(@PATH,39,142.9454,-3008.306,92.83431,0,0,0,0,100,0),
+(@PATH,40,142.4454,-3010.306,93.08431,0,0,0,0,100,0),
+(@PATH,41,142.4454,-3011.556,93.08431,0,0,0,0,100,0),
+(@PATH,42,142.4454,-3012.556,93.08431,0,0,0,0,100,0),
+(@PATH,43,146.1954,-3013.306,93.33431,0,0,0,0,100,0),
+(@PATH,44,147.1954,-3014.306,93.33431,0,0,0,0,100,0),
+(@PATH,45,148.1954,-3015.806,93.33431,0,0,0,0,100,0),
+(@PATH,46,150.1954,-3017.556,93.33431,0,0,0,0,100,0),
+(@PATH,47,154.4454,-3018.056,93.33431,0,0,0,0,100,0),
+(@PATH,48,155.1954,-3018.056,93.33431,0,0,0,0,100,0),
+(@PATH,49,156.1954,-3018.056,93.33431,0,0,0,0,100,0),
+(@PATH,50,158.4454,-3017.556,93.08431,0,0,0,0,100,0),
+(@PATH,51,162.4454,-3018.556,93.08431,0,0,0,0,100,0),
+(@PATH,52,166.6954,-3018.556,93.33431,0,0,0,0,100,0),
+(@PATH,53,162.6088,-3018.712,93.0483,0,0,0,0,100,0),
+(@PATH,54,158.6088,-3019.712,93.0483,0,0,0,0,100,0),
+(@PATH,55,157.1088,-3020.712,93.0483,0,0,0,0,100,0),
+(@PATH,56,155.3588,-3022.712,93.0483,0,0,0,0,100,0),
+(@PATH,57,155.3588,-3024.712,92.7983,0,0,0,0,100,0),
+(@PATH,58,156.8329,-3020.735,93.09354,0,0,0,0,100,0),
+(@PATH,59,155.5829,-3022.985,93.09354,0,0,0,0,100,0),
+(@PATH,60,155.5829,-3024.985,92.84354,0,0,0,0,100,0),
+(@PATH,61,155.5829,-3026.735,92.59354,0,0,0,0,100,0),
+(@PATH,62,154.3329,-3028.485,92.59354,0,0,0,0,100,0),
+(@PATH,63,154.3188,-3028.417,92.34318,0,0,0,0,100,0),
+(@PATH,64,154.3188,-3028.417,92.34318,0.5663568,0,0,0,100,0),
+(@PATH,65,155.4137,-3026.734,92.70565,0,0,0,0,100,0),
+(@PATH,66,155.4137,-3024.734,92.95565,0,0,0,0,100,0),
+(@PATH,67,156.4137,-3023.234,92.95565,0,0,0,0,100,0),
+(@PATH,68,156.9137,-3021.984,92.95565,0,0,0,0,100,0),
+(@PATH,69,158.6637,-3021.234,93.20565,0,0,0,0,100,0),
+(@PATH,70,162.4137,-3018.734,93.20565,0,0,0,0,100,0),
+(@PATH,71,166.6637,-3018.734,93.20565,0,0,0,0,100,0),
+(@PATH,72,164.8767,-3008.842,92.69083,0,0,0,0,100,0),
+(@PATH,73,165.3038,-3014.622,92.90702,0,0,0,0,100,0),
+(@PATH,74,165.5395,-3014.512,92.9668,0,0,0,0,100,0),
+(@PATH,75,168.2978,-3020.257,93.32513,0,0,0,0,100,0),
+(@PATH,76,173.2038,-3027.914,93.26228,0,0,0,0,100,0),
+(@PATH,77,173.7038,-3034.664,92.76228,0,0,0,0,100,0),
+(@PATH,78,173.9929,-3037.776,92.63618,0,0,0,0,100,0),
+(@PATH,79,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,80,174.0091,-3037.583,92.68045,0,0,0,0,100,0),
+(@PATH,81,173.5091,-3031.833,93.18045,0,0,0,0,100,0),
+(@PATH,82,173.2478,-3027.505,93.33543,0,0,0,0,100,0),
+(@PATH,83,167.9609,-3019.79,93.28394,0,0,0,0,100,0),
+(@PATH,84,165.4959,-3014.301,93.11089,0,0,0,0,100,0),
+(@PATH,85,165.2301,-3013.624,92.90702,0,0,0,0,100,0),
+(@PATH,86,165.3038,-3014.622,92.90702,0,0,0,0,100,0),
+(@PATH,87,168.0521,-3020.149,93.16674,0,0,0,0,100,0),
+(@PATH,88,168.0521,-3020.149,93.16674,0,0,0,0,100,0),
+(@PATH,89,173.2743,-3027.845,93.14709,0,0,0,0,100,0),
+(@PATH,90,173.1658,-3027.72,93.26052,0,0,0,0,100,0),
+(@PATH,91,173.6658,-3034.47,92.76052,0,0,0,0,100,0),
+(@PATH,92,173.6686,-3034.915,92.71877,0,0,0,0,100,0),
+(@PATH,93,173.9186,-3037.915,92.46877,0,0,0,0,100,0),
+(@PATH,94,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,95,173.8694,-3037.58,92.57248,0,0,0,0,100,0),
+(@PATH,96,173.6194,-3031.83,93.07248,0,0,0,0,100,0),
+(@PATH,97,171.5352,-3025.283,93.15152,0,0,0,0,100,0),
+(@PATH,98,172.0967,-3026.11,93.15152,0,0,0,0,100,0),
+(@PATH,99,173.2743,-3027.845,93.14709,0,0,0,0,100,0),
+(@PATH,100,173.7383,-3034.832,92.54174,0,0,0,0,100,0),
+(@PATH,101,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,102,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,103,173.9608,-3037.801,92.41367,0,0,0,0,100,0),
+(@PATH,104,173.9444,-3037.887,92.36877,0,0,0,0,100,0),
+(@PATH,105,173.9387,-3037.585,92.62599,0,0,0,0,100,0),
+(@PATH,106,173.4387,-3031.835,93.12599,0,0,0,0,100,0),
+(@PATH,107,173.2794,-3027.475,93.30872,0,0,0,0,100,0);
+
+-- guard
+SET @NPC := 303773;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=162.5903,`position_y`=-3053.296,`position_z`=91.89172 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,162.5903,-3053.296,91.89172,0,0,0,0,100,0),
+(@PATH,2,161.3403,-3053.296,91.89172,0,0,0,0,100,0),
+(@PATH,3,160.3403,-3053.296,91.89172,0,0,0,0,100,0),
+(@PATH,4,159.3403,-3051.796,91.89172,0,0,0,0,100,0),
+(@PATH,5,159.3403,-3049.796,91.89172,0,0,0,0,100,0),
+(@PATH,6,158.3403,-3048.796,91.89172,0,0,0,0,100,0),
+(@PATH,7,156.5903,-3045.546,91.89172,0,0,0,0,100,0),
+(@PATH,8,154.3403,-3041.796,92.64172,0,0,0,0,100,0),
+(@PATH,9,153.8403,-3040.046,91.89172,0,0,0,0,100,0),
+(@PATH,10,153.3403,-3037.546,91.89172,0,0,0,0,100,0),
+(@PATH,11,152.3732,-3033.185,92.01853,0,0,0,0,100,0),
+(@PATH,12,154.3598,-3032.87,92.1793,0,0,0,0,100,0),
+(@PATH,13,155.3598,-3035.37,91.9293,0,0,0,0,100,0),
+(@PATH,14,155.3598,-3037.62,91.9293,0,0,0,0,100,0),
+(@PATH,15,155.8598,-3039.62,91.9293,0,0,0,0,100,0),
+(@PATH,16,155.8598,-3040.62,91.9293,0,0,0,0,100,0),
+(@PATH,17,155.8598,-3041.62,91.9293,0,0,0,0,100,0),
+(@PATH,18,158.3598,-3042.62,91.9293,0,0,0,0,100,0),
+(@PATH,19,159.3598,-3043.62,91.9293,0,0,0,0,100,0),
+(@PATH,20,159.3598,-3045.62,91.9293,0,0,0,0,100,0),
+(@PATH,21,159.3598,-3047.62,91.9293,0,0,0,0,100,0),
+(@PATH,22,159.3598,-3049.87,91.9293,0,0,0,0,100,0),
+(@PATH,23,159.3598,-3051.87,91.9293,0,0,0,0,100,0),
+(@PATH,24,160.3598,-3053.37,91.9293,0,0,0,0,100,0),
+(@PATH,25,161.3598,-3053.37,91.9293,0,0,0,0,100,0),
+(@PATH,26,162.6098,-3053.37,91.9293,0,0,0,0,100,0),
+(@PATH,27,164.2502,-3057.343,92.77245,0,0,0,0,100,0),
+(@PATH,28,165.5002,-3059.843,93.27245,0,0,0,0,100,0),
+(@PATH,29,166.5002,-3061.593,94.02245,0,0,0,0,100,0),
+(@PATH,30,167.1096,-3062.889,94.2788,0,0,0,0,100,0),
+(@PATH,31,167.1096,-3062.889,94.2788,4.520196,5000,0,0,100,0),
+(@PATH,32,166.0933,-3060.81,93.79064,0,0,0,0,100,0),
+(@PATH,33,164.8433,-3058.56,93.04064,0,0,0,0,100,0),
+(@PATH,34,163.5933,-3055.81,92.54064,0,0,0,0,100,0),
+(@PATH,35,164.101,-3053.822,92.04711,0,0,0,0,100,0),
+(@PATH,36,165.601,-3051.822,92.04711,0,0,0,0,100,0),
+(@PATH,37,165.601,-3049.822,92.04711,0,0,0,0,100,0),
+(@PATH,38,165.601,-3047.822,92.04711,0,0,0,0,100,0),
+(@PATH,39,165.601,-3045.822,92.04711,0,0,0,0,100,0),
+(@PATH,40,165.601,-3043.822,92.04711,0,0,0,0,100,0),
+(@PATH,41,164.101,-3053.822,92.04711,0,0,0,0,100,0),
+(@PATH,42,165.601,-3051.822,92.04711,0,0,0,0,100,0),
+(@PATH,43,165.601,-3049.822,92.04711,0,0,0,0,100,0),
+(@PATH,44,165.601,-3047.822,92.04711,0,0,0,0,100,0),
+(@PATH,45,165.601,-3045.822,92.04711,0,0,0,0,100,0),
+(@PATH,46,165.601,-3043.822,92.04711,0,0,0,0,100,0),
+(@PATH,47,165.625,-3046.715,91.79174,0,0,0,0,100,0),
+(@PATH,48,165.601,-3047.973,92.04711,0,0,0,0,100,0),
+(@PATH,49,165.601,-3049.973,92.04711,0,0,0,0,100,0),
+(@PATH,50,165.601,-3051.723,92.04711,0,0,0,0,100,0),
+(@PATH,51,165.601,-3053.973,92.04711,0,0,0,0,100,0),
+(@PATH,52,165.4761,-3047.602,91.79174,0,0,0,0,100,0),
+(@PATH,53,165.625,-3046.613,91.79174,0,0,0,0,100,0),
+(@PATH,54,167.6027,-3050.176,91.79174,0,0,0,0,100,0),
+(@PATH,55,167.6027,-3050.176,91.79174,0,0,0,0,100,0),
+(@PATH,56,169.2921,-3054.25,91.91667,0,0,0,0,100,0),
+(@PATH,57,162.577,-3054.732,91.80248,2.642978,5000,0,0,100,0);
+
+-- hunter
+SET @NPC := 303898;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-258.5695,`position_y`=-3523.104,`position_z`=53.49051 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,-258.5695,-3523.104,53.49051,0,0,0,0,100,0),
+(@PATH,2,-258.8195,-3525.854,53.74051,0,0,0,0,100,0),
+(@PATH,3,-259.3195,-3532.354,54.24051,0,0,0,0,100,0),
+(@PATH,4,-259.3195,-3534.354,54.74051,0,0,0,0,100,0),
+(@PATH,5,-259.8195,-3540.604,56.24051,0,0,0,0,100,0),
+(@PATH,6,-260.1964,-3543.483,56.51688,0,0,0,0,100,0),
+(@PATH,7,-263.6964,-3544.983,56.51688,0,0,0,0,100,0),
+(@PATH,8,-270.7443,-3548.873,55.52689,0,0,0,0,100,0),
+(@PATH,9,-275.2443,-3547.123,55.02689,0,0,0,0,100,0),
+(@PATH,10,-276.2443,-3546.623,54.77689,0,0,0,0,100,0),
+(@PATH,11,-282.0537,-3543.991,53.59756,0,0,0,0,100,0),
+(@PATH,12,-283.5537,-3542.741,53.09756,0,0,0,0,100,0),
+(@PATH,13,-285.5537,-3540.741,53.09756,0,0,0,0,100,0),
+(@PATH,14,-286.5537,-3539.991,52.59756,0,0,0,0,100,0),
+(@PATH,15,-289.3037,-3537.241,51.09756,0,0,0,0,100,0),
+(@PATH,16,-292.0537,-3534.741,50.84756,0,0,0,0,100,0),
+(@PATH,17,-289.5139,-3537.355,51.02432,0,0,0,0,100,0),
+(@PATH,18,-286.5139,-3540.105,52.52432,0,0,0,0,100,0),
+(@PATH,19,-285.7639,-3540.855,53.02432,0,0,0,0,100,0),
+(@PATH,20,-283.7639,-3542.855,53.02432,0,0,0,0,100,0),
+(@PATH,21,-279.9232,-3545.968,54.25237,0,0,0,0,100,0),
+(@PATH,22,-275.4232,-3546.468,55.00237,0,0,0,0,100,0),
+(@PATH,23,-268.5771,-3547.186,55.93196,0,0,0,0,100,0),
+(@PATH,24,-264.5771,-3544.436,56.18196,0,0,0,0,100,0),
+(@PATH,25,-260.3271,-3541.936,56.43196,0,0,0,0,100,0),
+(@PATH,26,-259.0771,-3540.936,56.43196,0,0,0,0,100,0),
+(@PATH,27,-255.8112,-3538.334,56.12782,0,0,0,0,100,0),
+(@PATH,28,-255.5612,-3535.334,55.12782,0,0,0,0,100,0),
+(@PATH,29,-255.5612,-3531.084,54.37782,0,0,0,0,100,0),
+(@PATH,30,-255.5612,-3526.834,54.12782,0,0,0,0,100,0),
+(@PATH,31,-255.4542,-3526.465,53.77671,0,0,0,0,100,0),
+(@PATH,32,-255.4542,-3525.215,53.77671,0,0,0,0,100,0),
+(@PATH,33,-256.9542,-3522.465,53.52671,0,0,0,0,100,0),
+(@PATH,34,-257.7042,-3520.715,53.27671,0,0,0,0,100,0),
+(@PATH,35,-259.3177,-3518.179,52.60952,4.939282,5000,0,0,100,0);
+
+-- hunter
+SET @NPC := 304027;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-264.0234,`position_y`=-3544.681,`position_z`=22.75331 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,-264.0234,-3544.681,22.75331,0,0,0,0,100,0),
+(@PATH,2,-262.5234,-3544.181,22.25331,0,0,0,0,100,0),
+(@PATH,3,-258.5067,-3542.316,21.94831,0,0,0,0,100,0),
+(@PATH,4,-254.0067,-3538.316,21.69831,0,0,0,0,100,0),
+(@PATH,5,-254.0425,-3538.355,21.6328,0,0,0,0,100,0),
+(@PATH,6,-258.7375,-3542.503,21.97903,0,0,0,0,100,0),
+(@PATH,7,-261.9875,-3543.753,22.22903,0,0,0,0,100,0),
+(@PATH,8,-263.7375,-3544.503,22.72903,0,0,0,0,100,0),
+(@PATH,9,-268.7375,-3546.503,24.22903,0,0,0,0,100,0),
+(@PATH,10,-264.0234,-3544.681,22.75331,0,0,0,0,100,0);
+
+SET @NPC := 308126;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-358.5499,`position_y`=-3813.287,`position_z`=28.22426 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,-358.5499,-3813.287,28.22426,0,0,0,0,100,0),
+(@PATH,2,-362.0912,-3829.833,28.01439,0,0,0,0,100,0),
+(@PATH,3,-360.8412,-3841.583,27.51439,0,0,0,0,100,0),
+(@PATH,4,-360.8792,-3841.747,27.36276,0,0,0,0,100,0),
+(@PATH,5,-360.6292,-3842.747,27.36276,0,0,0,0,100,0),
+(@PATH,6,-366.1292,-3847.247,26.61276,0,0,0,0,100,0),
+(@PATH,7,-376.1292,-3854.997,26.36276,0,0,0,0,100,0),
+(@PATH,8,-376.145,-3855.167,26.39338,0,0,0,0,100,0),
+(@PATH,9,-378.895,-3857.167,26.39338,0,0,0,0,100,0),
+(@PATH,10,-381.645,-3855.917,26.89338,0,0,0,0,100,0),
+(@PATH,11,-394.1936,-3850.461,27.79027,0,0,0,0,100,0),
+(@PATH,12,-394.6936,-3843.711,28.04027,0,0,0,0,100,0),
+(@PATH,13,-395.143,-3838.756,28.90712,0,0,0,0,100,0),
+(@PATH,14,-400.643,-3837.506,29.15712,0,0,0,0,100,0),
+(@PATH,15,-406.473,-3836.28,29.99613,0,0,0,0,100,0),
+(@PATH,16,-421.473,-3843.53,29.24613,0,0,0,0,100,0),
+(@PATH,17,-421.6653,-3843.403,29.58047,0,0,0,0,100,0),
+(@PATH,18,-422.4153,-3843.903,29.58047,0,0,0,0,100,0),
+(@PATH,19,-429.1653,-3840.153,29.83047,0,0,0,0,100,0),
+(@PATH,20,-433.6597,-3837.489,30.45175,0,0,0,0,100,0),
+(@PATH,21,-433.9097,-3833.489,30.70175,0,0,0,0,100,0),
+(@PATH,22,-433.9097,-3825.489,31.20175,0,0,0,0,100,0),
+(@PATH,23,-434.1931,-3809.231,31.2517,0,0,0,0,100,0),
+(@PATH,24,-422.7949,-3775.78,30.71181,0,0,0,0,100,0),
+(@PATH,25,-416.7949,-3774.53,29.96181,0,0,0,0,100,0),
+(@PATH,26,-410.7949,-3773.78,29.46181,0,0,0,0,100,0),
+(@PATH,27,-403.2949,-3772.28,28.96181,0,0,0,0,100,0),
+(@PATH,28,-391.0279,-3770.035,28.7414,0,0,0,0,100,0),
+(@PATH,29,-386.7779,-3775.785,29.2414,0,0,0,0,100,0),
+(@PATH,30,-376.5255,-3789.156,29.31096,0,0,0,0,100,0),
+(@PATH,31,-366.5255,-3802.406,28.81096,0,0,0,0,100,0);
+
+-- razormane
+SET @NPC := 304021;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-203.2383,`position_y`=-3752.949,`position_z`=28.4771 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,-203.2383,-3752.949,28.4771,0,0,0,0,100,0),
+(@PATH,2,-202.4883,-3752.699,28.4771,0,0,0,0,100,0),
+(@PATH,3,-200.2383,-3745.199,28.9771,0,0,0,0,100,0),
+(@PATH,4,-197.7708,-3736.953,29.36144,0,0,0,0,100,0),
+(@PATH,5,-198.0208,-3732.953,29.86144,0,0,0,0,100,0),
+(@PATH,6,-198.7708,-3724.953,30.36144,0,0,0,0,100,0),
+(@PATH,7,-199.2708,-3718.203,31.11144,0,0,0,0,100,0),
+(@PATH,8,-200.4796,-3702.494,31.0158,0,0,0,0,100,0),
+(@PATH,9,-205.7296,-3696.494,30.5158,0,0,0,0,100,0),
+(@PATH,10,-209.7296,-3691.994,29.7658,0,0,0,0,100,0),
+(@PATH,11,-212.9796,-3688.244,29.2658,0,0,0,0,100,0),
+(@PATH,12,-215.4796,-3685.244,28.7658,0,0,0,0,100,0),
+(@PATH,13,-218.7296,-3681.494,28.0158,0,0,0,0,100,0),
+(@PATH,14,-230.4659,-3668.353,27.76447,0,0,0,0,100,0),
+(@PATH,15,-253.5655,-3691.246,27.97902,0,0,0,0,100,0),
+(@PATH,16,-253.5655,-3700.246,28.47902,0,0,0,0,100,0),
+(@PATH,17,-253.8155,-3724.996,27.97902,0,0,0,0,100,0),
+(@PATH,18,-253.8846,-3726.521,27.93848,0,0,0,0,100,0),
+(@PATH,19,-244.6346,-3732.021,28.43848,0,0,0,0,100,0),
+(@PATH,20,-240.0611,-3735.191,28.20564,0,0,0,0,100,0),
+(@PATH,21,-243.0611,-3737.941,27.70564,0,0,0,0,100,0),
+(@PATH,22,-250.6241,-3745.825,27.33429,0,0,0,0,100,0),
+(@PATH,23,-238.8741,-3760.575,26.83429,0,0,0,0,100,0),
+(@PATH,24,-236.5609,-3762.99,26.81933,0,0,0,0,100,0),
+(@PATH,25,-223.3109,-3758.99,27.31933,0,0,0,0,100,0),
+(@PATH,26,-210.0609,-3755.24,27.56933,0,0,0,0,100,0);
+
+-- razormane
+SET @NPC := 304038;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-61.39247,`position_y`=-3634.46,`position_z`=30.74987 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,-61.39247,-3634.46,30.74987,0,0,0,0,100,0),
+(@PATH,2,-74.89247,-3619.96,29.99987,0,0,0,0,100,0),
+(@PATH,3,-82.14247,-3611.71,29.49987,0,0,0,0,100,0),
+(@PATH,4,-86.14247,-3607.46,28.99987,0,0,0,0,100,0),
+(@PATH,5,-90.77446,-3602.838,28.1987,0,0,0,0,100,0),
+(@PATH,6,-102.0245,-3616.338,27.6987,0,0,0,0,100,0),
+(@PATH,7,-114.4264,-3630.485,27.40917,0,0,0,0,100,0),
+(@PATH,8,-139.6764,-3658.485,27.65917,0,0,0,0,100,0),
+(@PATH,9,-144.4264,-3663.735,28.40917,0,0,0,0,100,0),
+(@PATH,10,-144.4538,-3663.949,28.32541,0,0,0,0,100,0),
+(@PATH,11,-144.7038,-3664.449,28.32541,0,0,0,0,100,0),
+(@PATH,12,-138.4538,-3685.199,27.82541,0,0,0,0,100,0),
+(@PATH,13,-133.7238,-3700.801,27.49711,0,0,0,0,100,0),
+(@PATH,14,-116.9304,-3718.824,27.38062,0,0,0,0,100,0),
+(@PATH,15,-109.6804,-3713.574,26.88062,0,0,0,0,100,0),
+(@PATH,16,-94.77512,-3703.506,27.5852,0,0,0,0,100,0),
+(@PATH,17,-80.52512,-3700.256,27.8352,0,0,0,0,100,0),
+(@PATH,18,-76.56852,-3699.008,28.39589,0,0,0,0,100,0),
+(@PATH,19,-62.31852,-3674.258,28.89589,0,0,0,0,100,0),
+(@PATH,20,-57.5658,-3666.098,29.52995,0,0,0,0,100,0),
+(@PATH,21,-59.5658,-3651.348,29.77995,0,0,0,0,100,0),
+(@PATH,22,-60.3158,-3642.598,30.27995,0,0,0,0,100,0);
+
+-- Peonstuff - Borderzone
+SET @NPC := 304091;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=333.7413,`position_y`=-3686.676,`position_z`=27.86447 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,333.7413,-3686.676,27.86447,0,0,0,0,100,0),
+(@PATH,2,331.4913,-3682.926,27.61447,0,0,0,0,100,0),
+(@PATH,3,328.2413,-3682.676,27.61447,0,0,0,0,100,0),
+(@PATH,4,327.4913,-3682.676,27.61447,0,0,0,0,100,0),
+(@PATH,5,330.7413,-3682.676,27.61447,0,0,0,0,100,0),
+(@PATH,6,333.4913,-3686.426,27.86447,0,0,0,0,100,0),
+(@PATH,7,333.7413,-3686.676,27.86447,0,0,0,0,100,0);
+
+SET @NPC := 304090;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=309.3087,`position_y`=-3672.01,`position_z`=27.21739 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,309.3087,-3672.01,27.21739,0,0,0,0,100,0),
+(@PATH,2,309.4936,-3671.948,27.41766,0,0,0,0,100,0),
+(@PATH,3,313.8301,-3689.508,27.35551,0,0,0,0,100,0),
+(@PATH,4,320.6342,-3693.457,27.15489,0,0,0,0,100,0),
+(@PATH,5,325.6618,-3689.65,27.21739,1.570796,5000,0,0,100,0),
+(@PATH,6,316.928,-3693.633,27.09239,0,0,0,0,100,0),
+(@PATH,7,316.9654,-3693.443,27.29672,0,0,0,0,100,0),
+(@PATH,8,308.7818,-3688.939,27.17718,0,0,0,0,100,0),
+(@PATH,9,301.5027,-3679.994,27.38743,0,0,0,0,100,0),
+(@PATH,10,294.9082,-3671.141,27.72398,0,0,0,0,100,0),
+(@PATH,11,288.9224,-3670.656,27.44807,1.937315,5000,0,0,100,0),
+(@PATH,12,301.9308,-3683.951,27.21739,0,0,0,0,100,0),
+(@PATH,13,302.1828,-3684.004,27.37862,0,0,0,0,100,0),
+(@PATH,14,314.7279,-3695.032,27.21811,0,0,0,0,100,0),
+(@PATH,15,326.2723,-3696.133,27.76481,0,0,0,0,100,0),
+(@PATH,16,330.7723,-3694.633,28.26481,0,0,0,0,100,0),
+(@PATH,17,327.3414,-3693.541,27.56175,0,0,0,0,100,0),
+(@PATH,18,316.9224,-3691.291,27.12896,0,0,0,0,100,0),
+(@PATH,19,308.7729,-3681.836,27.43475,0,0,0,0,100,0);
+
+SET @NPC := 304085;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=327.0269,`position_y`=-3702.834,`position_z`=27.56776 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,327.0269,-3702.834,27.56776,0,0,0,0,100,0),
+(@PATH,2,317.7341,-3704.953,26.94114,0,0,0,0,100,0),
+(@PATH,3,301.2341,-3702.703,26.44114,0,0,0,0,100,0),
+(@PATH,4,295.3854,-3701.735,26.46143,0,0,0,0,100,0),
+(@PATH,5,286.3854,-3694.735,26.96143,0,0,0,0,100,0),
+(@PATH,6,282.3854,-3691.485,27.46143,0,0,0,0,100,0),
+(@PATH,7,281.2959,-3688.978,28.09551,0,0,0,0,100,0),
+(@PATH,8,279.7959,-3685.228,28.59551,0,0,0,0,100,0),
+(@PATH,9,275.7959,-3675.478,28.59551,0,0,0,0,100,0),
+(@PATH,10,275.0459,-3673.478,29.59551,0,0,0,0,100,0),
+(@PATH,11,274.6982,-3673.373,29.58753,0,0,0,0,100,0),
+(@PATH,12,274.1982,-3671.373,29.58753,0,0,0,0,100,0),
+(@PATH,13,273.9482,-3664.623,27.58753,0,0,0,0,100,0),
+(@PATH,14,273.6982,-3660.873,27.58753,0,0,0,0,100,0),
+(@PATH,15,273.5458,-3658.68,27.43373,0,0,0,0,100,0),
+(@PATH,16,272.7958,-3657.68,27.43373,0,0,0,0,100,0),
+(@PATH,17,272.7528,-3659.224,27.60741,0,0,0,0,100,0),
+(@PATH,18,272.7528,-3660.224,27.60741,0,0,0,0,100,0),
+(@PATH,19,272.7528,-3660.724,27.60741,0,0,0,0,100,0),
+(@PATH,20,273.2528,-3663.974,27.60741,0,0,0,0,100,0),
+(@PATH,21,273.5028,-3664.474,27.60741,0,0,0,0,100,0),
+(@PATH,22,274.2276,-3668.445,28.75386,0,0,0,0,100,0),
+(@PATH,23,274.9776,-3671.195,29.50386,0,0,0,0,100,0),
+(@PATH,24,275.7276,-3673.445,29.50386,0,0,0,0,100,0),
+(@PATH,25,276.9776,-3676.945,28.75386,0,0,0,0,100,0),
+(@PATH,26,276.9776,-3678.945,29.00386,0,0,0,0,100,0),
+(@PATH,27,277.3337,-3679.286,28.88524,0,0,0,0,100,0),
+(@PATH,28,275.3337,-3680.036,28.88524,0,0,0,0,100,0),
+(@PATH,29,282.3337,-3685.786,28.38524,0,0,0,0,100,0),
+(@PATH,30,285.8337,-3688.786,27.63524,0,0,0,0,100,0),
+(@PATH,31,289.8337,-3691.786,27.13524,0,0,0,0,100,0),
+(@PATH,32,289.9146,-3692.086,27.04403,0,0,0,0,100,0),
+(@PATH,33,291.9146,-3693.586,26.79403,0,0,0,0,100,0),
+(@PATH,34,311.5242,-3704.626,26.84253,0,0,0,0,100,0),
+(@PATH,35,318.5932,-3715.422,26.73446,0,0,0,0,100,0);