DB/Creature: Supremus (BT) trash mobs, waypoints & spawns

Dragonmaw Sky Stalker (ID 23030) &
Dragonmaw Wind Reaver (ID 23330)

- added 9 missing spawns (23030 / 54254-54262)
- reinserted correct waypoints based on sniffs

Closes #18232

(cherry picked from commit b333c92d0cfb81dfa51c40d39a181fbff462130c)

1 files changed, 899 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_02_11_02_world_2016_11_20_02_world.sql b/sql/updates/world/master/2018_02_11_02_world_2016_11_20_02_world.sql
new file mode 100644
index 00000000000..3ffff8aaedf
--- /dev/null
+++ b/sql/updates/world/master/2018_02_11_02_world_2016_11_20_02_world.sql
@@ -0,0 +1,899 @@
+-- Dragonmaw Sky Stalker (NPC ID 23030) GUID 53827-53916 + 54254-54262
+-- Dragonmaw Wind Reaver (NPC ID 23330) GUID 12737-12740
+
+-- recycling GUIDs for current creatures:
+SET @CGUID := 53827;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=748.5817,`position_y`=926.8765,`position_z`=169.7075 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,748.5817,926.8765,169.7075,0,0,0,0,100,0), 
+(@PATH,2,754.8384,949.9673,169.7075,0,0,0,0,100,0), 
+(@PATH,3,743.052,964.9089,169.7075,0,0,0,0,100,0),
+(@PATH,4,709.5197,973.5267,169.7075,0,0,0,0,100,0),
+(@PATH,5,687.2907,969.5494,169.7075,0,0,0,0,100,0), 
+(@PATH,6,653.5486,953.9686,169.7075,0,0,0,0,100,0), 
+(@PATH,7,641.8157,913.1547,169.7075,0,0,0,0,100,0), 
+(@PATH,8,636.5085,871.3954,169.7075,0,0,0,0,100,0), 
+(@PATH,9,630.541,836.1695,169.7075,0,0,0,0,100,0),
+(@PATH,10,627.7165,804.2263,169.7075,0,0,0,0,100,0),
+(@PATH,11,625.0752,770.7723,169.7075,0,0,0,0,100,0),
+(@PATH,12,624.6312,725.1182,169.7075,0,0,0,0,100,0),
+(@PATH,13,643.8918,687.4643,169.7075,0,0,0,0,100,0),
+(@PATH,14,675.7663,683.7708,169.7075,0,0,0,0,100,0),
+(@PATH,15,712.8825,695.7303,169.7075,0,0,0,0,100,0),
+(@PATH,16,747.5607,704.7095,169.7075,0,0,0,0,100,0),
+(@PATH,17,762.9872,733.2521,169.7075,0,0,0,0,100,0),
+(@PATH,18,768.9691,762.2154,169.7075,0,0,0,0,100,0),
+(@PATH,19,763.5071,809.0665,169.7075,0,0,0,0,100,0),
+(@PATH,20,760.3749,843.4251,169.7075,0,0,0,0,100,0),
+(@PATH,21,751.462,892.9752,169.7075,0,0,0,0,100,0),
+(@PATH,22,748.5466,920.3238,169.7075,0,0,0,0,100,0),
+(@PATH,23,748.5817,926.8765,169.7075,0,0,0,0,100,0),
+(@PATH,24,754.8384,949.9673,169.7075,0,0,0,0,100,0);
+
+SET @CGUID := 53828;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=721.9486,`position_y`=665.284,`position_z`=171.9325 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,721.9486,665.284,171.9325,0,0,0,0,100,0),
+(@PATH,2,764.4177,663.7574,171.9325,0,0,0,0,100,0),
+(@PATH,3,791.3472,677.6638,171.9325,0,0,0,0,100,0),
+(@PATH,4,797.7083,699.2236,171.9325,0,0,0,0,100,0),
+(@PATH,5,792.8513,723.0785,171.9325,0,0,0,0,100,0),
+(@PATH,6,776.4136,740.0793,171.9325,0,0,0,0,100,0),
+(@PATH,7,766.1145,768.3846,171.9325,0,0,0,0,100,0),
+(@PATH,8,782.2069,796.3889,171.9325,0,0,0,0,100,0),
+(@PATH,9,787.843,820.4999,171.9325,0,0,0,0,100,0),
+(@PATH,10,797.8959,851.5565,171.9325,0,0,0,0,100,0),
+(@PATH,11,777.1003,864.2474,171.9325,0,0,0,0,100,0),
+(@PATH,12,748.3235,868.2767,171.9325,0,0,0,0,100,0),
+(@PATH,13,727.6926,872.5922,171.9325,0,0,0,0,100,0),
+(@PATH,14,692.7877,878.8469,171.9325,0,0,0,0,100,0),
+(@PATH,15,676.4932,879.4951,171.9325,0,0,0,0,100,0),
+(@PATH,16,656.9288,879.4467,171.9325,0,0,0,0,100,0),
+(@PATH,17,643.9807,862.0121,171.9325,0,0,0,0,100,0),
+(@PATH,18,642.1204,827.2074,171.9325,0,0,0,0,100,0),
+(@PATH,19,634.3268,781.412,171.9325,0,0,0,0,100,0),
+(@PATH,20,637.8225,745.1819,171.9325,0,0,0,0,100,0),
+(@PATH,21,661.7581,705.3063,171.9325,0,0,0,0,100,0),
+(@PATH,22,684.738,681.9153,171.9325,0,0,0,0,100,0),
+(@PATH,23,716.7581,667.9764,171.9325,0,0,0,0,100,0);
+
+SET @CGUID := 53829;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=639.2408,`position_y`=817.2838,`position_z`=96.00954 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,639.2408,817.2838,96.00954,0,0,0,0,100,0),
+(@PATH,2,637.0174,831.9658,94.81514,0,0,0,0,100,0),
+(@PATH,3,630.5756,845.7454,91.42623,0,0,0,0,100,0),
+(@PATH,4,617.9464,853.2907,88.20402,0,0,0,0,100,0),
+(@PATH,5,598.8134,854.8987,92.45403,0,0,0,0,100,0),
+(@PATH,6,586.3024,847.9394,90.48181,0,0,0,0,100,0),
+(@PATH,7,581.6896,830.243,90.87068,0,0,0,0,100,0),
+(@PATH,8,582.2021,803.4702,93.59291,0,0,0,0,100,0),
+(@PATH,9,582.4189,778.6371,92.33733,0,0,0,0,100,0),
+(@PATH,10,588.5067,762.3616,95.83994,0,0,0,0,100,0),
+(@PATH,11,591.8719,745.3989,101.1524,0,0,0,0,100,0),
+(@PATH,12,592.076,730.4387,102.1415,0,0,0,0,100,0),
+(@PATH,13,604.0575,721.923,106.0203,0,0,0,0,100,0),
+(@PATH,14,619.384,726.6072,103.7703,0,0,0,0,100,0),
+(@PATH,15,631.0529,741.9111,101.1036,0,0,0,0,100,0),
+(@PATH,16,633.0304,762.1757,96.46471,0,0,0,0,100,0),
+(@PATH,17,630.8676,783.9254,95.29805,0,0,0,0,100,0),
+(@PATH,18,635.1721,806.4858,96.52027,0,0,0,0,100,0),
+(@PATH,19,639.1043,815.7457,96.02027,0,0,0,0,100,0);
+
+SET @CGUID := 53830;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=648.7271,`position_y`=732.1752,`position_z`=170.7075 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,648.7271,732.1752,170.7075,0,0,0,0,100,0),
+(@PATH,2,652.2249,720.286,170.7075,0,0,0,0,100,0),
+(@PATH,3,652.2249,720.286,170.7075,0,0,0,0,100,0),
+(@PATH,4,657.8307,709.1823,170.7075,0,0,0,0,100,0),
+(@PATH,5,658.5453,707.557,170.7075,0,0,0,0,100,0),
+(@PATH,6,663.7322,707.6018,170.7075,0,0,0,0,100,0),
+(@PATH,7,676.2772,709.3177,170.7075,0,0,0,0,100,0),
+(@PATH,8,690.5971,714.3631,170.7075,0,0,0,0,100,0),
+(@PATH,9,710.9605,721.0316,170.7075,0,0,0,0,100,0),
+(@PATH,10,729.6195,724.2315,170.7075,0,0,0,0,100,0),
+(@PATH,11,732.2808,724.4777,170.7075,0,0,0,0,100,0),
+(@PATH,12,735.2756,730.3159,170.7075,0,0,0,0,100,0),
+(@PATH,13,740.9436,745.7593,170.7075,0,0,0,0,100,0),
+(@PATH,14,743.6251,756.2307,170.7075,0,0,0,0,100,0),
+(@PATH,15,743.6556,768.592,170.7075,0,0,0,0,100,0),
+(@PATH,16,741.5312,785.4241,170.7075,0,0,0,0,100,0),
+(@PATH,17,738.9528,803.7255,170.7075,0,0,0,0,100,0),
+(@PATH,18,737.3602,822.2095,170.7075,0,0,0,0,100,0),
+(@PATH,19,735.9527,837.5167,170.7075,0,0,0,0,100,0),
+(@PATH,20,733.3319,853.4462,170.7075,0,0,0,0,100,0),
+(@PATH,21,729.8102,871.9895,170.7075,0,0,0,0,100,0),
+(@PATH,22,730.9515,865.6296,170.7075,0,0,0,0,100,0),
+(@PATH,23,734.9578,869.7712,170.5201,0,0,0,0,100,0),
+(@PATH,24,739.7133,883.8173,170.246,0,0,0,0,100,0),
+(@PATH,25,742.371,898.1652,170.0699,0,0,0,0,100,0),
+(@PATH,26,730.4334,945.2024,170.7075,0,0,0,0,100,0),
+(@PATH,27,731.9338,942.5042,170.7075,0,0,0,0,100,0),
+(@PATH,28,724.611,945.1463,170.7075,0,0,0,0,100,0),
+(@PATH,29,712.3275,947.9523,170.7075,0,0,0,0,100,0),
+(@PATH,30,704.4079,948.7064,170.7075,0,0,0,0,100,0),
+(@PATH,31,698.0605,946.8328,170.7075,0,0,0,0,100,0),
+(@PATH,32,683.9213,942.4026,170.7075,0,0,0,0,100,0),
+(@PATH,33,674.265,938.8467,170.7075,0,0,0,0,100,0),
+(@PATH,34,673.0928,938.3848,170.7075,0,0,0,0,100,0),
+(@PATH,35,671.2271,933.4547,170.7075,0,0,0,0,100,0),
+(@PATH,36,668.699,921.3985,170.7075,0,0,0,0,100,0),
+(@PATH,37,666.0173,906.6799,170.7075,0,0,0,0,100,0),
+(@PATH,38,664.2043,894.2822,170.7075,0,0,0,0,100,0),
+(@PATH,39,662.7593,880.3667,170.7075,0,0,0,0,100,0),
+(@PATH,40,663.3392,885.2729,170.7075,0,0,0,0,100,0),
+(@PATH,41,659.9514,883.8571,170.5794,0,0,0,0,100,0),
+(@PATH,42,655.9943,837.4919,170.7075,0,0,0,0,100,0),
+(@PATH,43,654.4485,825.1205,170.7075,0,0,0,0,100,0),
+(@PATH,44,653.3726,811.8262,170.7075,0,0,0,0,100,0),
+(@PATH,45,652.2186,797.4872,170.7075,0,0,0,0,100,0),
+(@PATH,46,650.9856,784.2934,170.7075,0,0,0,0,100,0),
+(@PATH,47,650.086,770.5377,170.7075,0,0,0,0,100,0),
+(@PATH,48,649.1042,756.0231,170.7075,0,0,0,0,100,0),
+(@PATH,49,648.2772,742.78,170.7075,0,0,0,0,100,0);
+
+SET @CGUID := 53831;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=728.1078,`position_y`=846.9943,`position_z`=172.9326 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,728.1078,846.9943,172.9326,0,0,0,0,100,0),
+(@PATH,2,710.9005,850.3428,172.9325,0,0,0,0,100,0),
+(@PATH,3,693.0854,853.5267,172.9326,0,0,0,0,100,0),
+(@PATH,4,680.7529,854.5162,172.9326,0,0,0,0,100,0),
+(@PATH,5,663.3484,855.7787,172.9326,0,0,0,0,100,0),
+(@PATH,6,669.0896,857.5624,172.9326,0,0,0,0,100,0),
+(@PATH,7,667.8973,854.1387,172.9325,0,0,0,0,100,0),
+(@PATH,8,667.7648,838.8507,172.9325,0,0,0,0,100,0),
+(@PATH,9,665.7653,816.3873,172.9326,0,0,0,0,100,0),
+(@PATH,10,662.0288,797.6625,172.9325,0,0,0,0,100,0),
+(@PATH,11,659.4796,782.4767,172.9325,0,0,0,0,100,0),
+(@PATH,12,658.9075,767.8063,172.9325,0,0,0,0,100,0),
+(@PATH,13,660.2582,757.0905,172.9325,0,0,0,0,100,0),
+(@PATH,14,664.7323,746.3156,172.9325,0,0,0,0,100,0),
+(@PATH,15,673.1578,732.4761,172.9325,0,0,0,0,100,0),
+(@PATH,16,682.3874,719.4611,172.9326,0,0,0,0,100,0),
+(@PATH,17,691.6407,708.4307,172.9326,0,0,0,0,100,0),
+(@PATH,18,699.9095,701.9017,172.9325,0,0,0,0,100,0),
+(@PATH,19,714.087,695.7488,172.9325,0,0,0,0,100,0),
+(@PATH,20,731.1124,644.1501,172.9325,0,0,0,0,100,0),
+(@PATH,21,718.0795,676.7922,172.9325,0,0,0,0,100,0),
+(@PATH,22,745.0221,688.3293,172.9325,0,0,0,0,100,0),
+(@PATH,23,756.8813,688.0884,172.9325,0,0,0,0,100,0),
+(@PATH,24,763.3431,689.1867,172.9325,0,0,0,0,100,0),
+(@PATH,25,769.7626,692.1405,172.9326,0,0,0,0,100,0),
+(@PATH,26,772.9557,694.5918,172.9325,0,0,0,0,100,0),
+(@PATH,27,772.2848,694.0916,172.9325,0,0,0,0,100,0),
+(@PATH,28,772.718,701.7488,172.9325,0,0,0,0,100,0),
+(@PATH,29,771.6613,708.838,172.9325,0,0,0,0,100,0),
+(@PATH,30,771.9302,709.6787,172.9325,0,0,0,0,100,0),
+(@PATH,31,763.6402,716.6005,172.9325,0,0,0,0,100,0),
+(@PATH,32,751.5613,733.0993,172.9325,0,0,0,0,100,0),
+(@PATH,33,743.9901,749.5864,172.9326,0,0,0,0,100,0),
+(@PATH,34,741.8796,774.9808,172.9325,0,0,0,0,100,0),
+(@PATH,35,751.6147,795.4948,172.9325,0,0,0,0,100,0),
+(@PATH,36,758.7626,805.4193,172.9325,0,0,0,0,100,0),
+(@PATH,37,760.1722,809.3333,172.9325,0,0,0,0,100,0),
+(@PATH,38,762.2374,820.9478,172.9325,0,0,0,0,100,0),
+(@PATH,39,767.947,838.4155,172.9325,0,0,0,0,100,0),
+(@PATH,40,772.8404,849.8958,172.9326,0,0,0,0,100,0),
+(@PATH,41,774.2027,843.7081,172.9326,0,0,0,0,100,0),
+(@PATH,42,778.589,837.2932,172.9326,0,0,0,0,100,0),
+(@PATH,43,768.8502,840.6385,172.9325,0,0,0,0,100,0),
+(@PATH,44,760.4444,841.8875,172.9325,0,0,0,0,100,0),
+(@PATH,45,746.5559,843.2591,172.9326,0,0,0,0,100,0),
+(@PATH,46,732.4482,846.0096,172.9325,0,0,0,0,100,0);
+
+SET @CGUID := 53841;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=666.3989,`position_y`=973.1008,`position_z`=170.7075 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,666.3989,973.1008,170.7075,0,0,0,0,100,0),
+(@PATH,2,652.1188,961.1961,170.7075,0,0,0,0,100,0),
+(@PATH,3,647.2161,943.3284,170.7076,0,0,0,0,100,0),
+(@PATH,4,643.0891,926.0452,170.7075,0,0,0,0,100,0),
+(@PATH,5,640.5149,908.6226,170.7075,0,0,0,0,100,0),
+(@PATH,6,639.8064,891.3257,170.7075,0,0,0,0,100,0),
+(@PATH,7,637.1084,873.8254,170.7075,0,0,0,0,100,0),
+(@PATH,8,632.9307,857.2454,170.7075,0,0,0,0,100,0),
+(@PATH,9,630.3768,840.064,170.7075,0,0,0,0,100,0),
+(@PATH,10,629.5081,822.9091,170.7075,0,0,0,0,100,0),
+(@PATH,11,627.5027,806.3528,170.7075,0,0,0,0,100,0),
+(@PATH,12,626.5479,788.7383,170.7075,0,0,0,0,100,0),
+(@PATH,13,624.4636,771.0414,170.7075,0,0,0,0,100,0),
+(@PATH,14,620.2076,753.0712,170.7075,0,0,0,0,100,0),
+(@PATH,15,619.8459,734.4846,170.7075,0,0,0,0,100,0),
+(@PATH,16,623.0982,715.7894,170.7075,0,0,0,0,100,0),
+(@PATH,17,625.6698,694.5493,170.7075,0,0,0,0,100,0),
+(@PATH,18,640.6373,680.832,170.7075,0,0,0,0,100,0),
+(@PATH,19,658.5715,678.7152,170.7075,0,0,0,0,100,0),
+(@PATH,20,676.2325,682.0574,170.7075,0,0,0,0,100,0),
+(@PATH,21,692.0359,691.1675,170.7075,0,0,0,0,100,0),
+(@PATH,22,709.9055,694.8826,170.7075,0,0,0,0,100,0),
+(@PATH,23,730.8896,689.1498,170.7075,0,0,0,0,100,0),
+(@PATH,24,748.9811,697.7251,170.7075,0,0,0,0,100,0),
+(@PATH,25,756.1241,713.8288,170.7075,0,0,0,0,100,0),
+(@PATH,26,765.5197,728.4705,170.7075,0,0,0,0,100,0),
+(@PATH,27,770.7372,745.8633,170.7075,0,0,0,0,100,0),
+(@PATH,28,769.8888,764.3091,170.7075,0,0,0,0,100,0),
+(@PATH,29,766.7514,781.8798,170.7075,0,0,0,0,100,0),
+(@PATH,30,763.96,798.9189,170.7075,0,0,0,0,100,0),
+(@PATH,31,763.9962,815.9862,170.7075,0,0,0,0,100,0),
+(@PATH,32,762.4482,833.3903,170.7075,0,0,0,0,100,0),
+(@PATH,33,759.0405,852.1,170.7075,0,0,0,0,100,0),
+(@PATH,34,755.2859,868.189,170.7075,0,0,0,0,100,0), 
+(@PATH,35,756.4008,863.0829,170.6751,0,0,0,0,100,0),
+(@PATH,36,753.4927,882.025,170.2552,0,0,0,0,100,0),
+(@PATH,37,751.556,897.6622,170.067,0,0,0,0,100,0),
+(@PATH,38,762.7798,930.9296,170.7075,0,0,0,0,100,0),
+(@PATH,39,765.9858,952.0153,170.7075,0,0,0,0,100,0),
+(@PATH,40,755.5459,962.2645,170.7075,0,0,0,0,100,0),
+(@PATH,41,741.1741,968.3941,170.7075,0,0,0,0,100,0),
+(@PATH,42,727.6735,975.328,170.7075,0,0,0,0,100,0),
+(@PATH,43,713.403,978.6857,170.7075,0,0,0,0,100,0),
+(@PATH,44,700.6663,973.5411,170.7075,0,0,0,0,100,0),
+(@PATH,45,685.0948,972.5025,170.7075,0,0,0,0,100,0);
+
+SET @CGUID := 53842;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=821.8317,`position_y`=858.8041,`position_z`=172.9325 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,821.8317,858.8041,172.9325,0,0,0,0,100,0),
+(@PATH,2,770.4988,891.0805,172.9325,0,0,0,0,100,0),
+(@PATH,3,770.4988,891.0805,172.9325,0,0,0,0,100,0),
+(@PATH,4,753.2192,892.814,172.9325,0,0,0,0,100,0),
+(@PATH,5,738.7772,895.8427,172.9326,0,0,0,0,100,0),
+(@PATH,6,720.1701,899.476,172.9325,0,0,0,0,100,0),
+(@PATH,7,700.9869,902.8984,172.9326,0,0,0,0,100,0),
+(@PATH,8,679.7096,904.5053,172.9326,0,0,0,0,100,0),
+(@PATH,9,661.8425,905.756,172.9326,0,0,0,0,100,0),
+(@PATH,10,629.1461,887.6377,172.9326,0,0,0,0,100,0),
+(@PATH,11,618.1265,858.9202,172.9325,0,0,0,0,100,0),
+(@PATH,12,617.7658,839.1631,172.9325,0,0,0,0,100,0),
+(@PATH,13,616.5134,825.0038,172.9326,0,0,0,0,100,0),
+(@PATH,14,613.0281,807.6089,172.9325,0,0,0,0,100,0),
+(@PATH,15,609.7328,787.5037,172.9325,0,0,0,0,100,0),
+(@PATH,16,608.9132,767.0515,172.9325,0,0,0,0,100,0),
+(@PATH,17,611.9686,744.125,172.9325,0,0,0,0,100,0),
+(@PATH,18,620.601,722.812,172.9325,0,0,0,0,100,0),
+(@PATH,19,631.5937,704.6835,172.9325,0,0,0,0,100,0),
+(@PATH,20,642.3316,689.5355,172.9326,0,0,0,0,100,0),
+(@PATH,21,656.503,672.859,172.9326,0,0,0,0,100,0),
+(@PATH,22,674.9702,658.5654,172.9325,0,0,0,0,100,0),
+(@PATH,23,696.5784,648.9145,172.9325,0,0,0,0,100,0),
+(@PATH,24,706.4659,687.6536,172.9325,0,0,0,0,100,0),
+(@PATH,25,699.3428,673.4842,172.9325,0,0,0,0,100,0),
+(@PATH,26,741.9863,638.4216,172.9325,0,0,0,0,100,0),
+(@PATH,27,759.079,638.1368,172.9325,0,0,0,0,100,0),
+(@PATH,28,778.3642,641.4964,172.9325,0,0,0,0,100,0),
+(@PATH,29,796.3674,649.8063,172.9326,0,0,0,0,100,0),
+(@PATH,30,810.8141,661.9307,172.9325,0,0,0,0,100,0),
+(@PATH,31,821.5836,685.7474,172.9325,0,0,0,0,100,0),
+(@PATH,32,822.6885,703.4628,172.9325,0,0,0,0,100,0),
+(@PATH,33,819.8553,722.1548,172.9325,0,0,0,0,100,0),
+(@PATH,34,808.7045,743.5558,172.9325,0,0,0,0,100,0),
+(@PATH,35,797.7748,753.1358,172.9325,0,0,0,0,100,0),
+(@PATH,36,795.1656,757.567,172.9325,0,0,0,0,100,0),
+(@PATH,37,791.3923,765.4935,172.9326,0,0,0,0,100,0),
+(@PATH,38,790.8031,764.6614,172.9325,0,0,0,0,100,0),
+(@PATH,39,792.4973,766.709,172.9325,0,0,0,0,100,0),
+(@PATH,40,801.1123,778.8392,172.9325,0,0,0,0,100,0),
+(@PATH,41,808.95,798.3457,172.9325,0,0,0,0,100,0),
+(@PATH,42,811.208,810.8542,172.9325,0,0,0,0,100,0),
+(@PATH,43,813.7809,818.4341,172.9325,0,0,0,0,100,0),
+(@PATH,44,820.0312,833.3722,172.9326,0,0,0,0,100,0);
+
+SET @CGUID := 53843;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=706.2591,`position_y`=879.9013,`position_z`=85.68813 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,706.2591,879.9013,85.68813,0,0,0,0,100,0),
+(@PATH,2,687.0418,872.5399,81.68005,0,0,0,0,100,0),
+(@PATH,3,672.4034,852.6266,80.60835,0,0,0,0,100,0),
+(@PATH,4,664.3254,823.0761,90.13865,0,0,0,0,100,0),
+(@PATH,5,675.2798,803.8729,91.80936,0,0,0,0,100,0),
+(@PATH,6,683.4824,782.0359,90.15625,0,0,0,0,100,0),
+(@PATH,7,680.5452,754.212,91.47352,0,0,0,0,100,0),
+(@PATH,8,687.6937,739.1242,94.63132,0,0,0,0,100,0),
+(@PATH,9,709.887,737.9406,97.90912,0,0,0,0,100,0),
+(@PATH,10,722.275,749.9312,99.65911,0,0,0,0,100,0),
+(@PATH,11,720.2606,768.6862,92.71466,0,0,0,0,100,0),
+(@PATH,12,720.647,783.9854,88.32578,0,0,0,0,100,0),
+(@PATH,13,720.858,796.5645,87.04801,0,0,0,0,100,0),
+(@PATH,14,731.3468,814.0711,81.68689,0,0,0,0,100,0),
+(@PATH,15,731.7731,831.5212,90.96468,0,0,0,0,100,0),
+(@PATH,16,734.43,855.3979,87.65915,0,0,0,0,100,0),
+(@PATH,17,717.5137,875.2517,88.3258,0,0,0,0,100,0),
+(@PATH,18,708.2299,879.131,86.40916,0,0,0,0,100,0);
+
+SET @CGUID := 53907;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=714.4265,`position_y`=888.9312,`position_z`=84.42062 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,714.4265,888.9312,84.42062,0,0,0,0,100,0),
+(@PATH,2,694.9776,884.7676,81.40375,0,0,0,0,100,0),
+(@PATH,3,680.8666,872.6392,82.26455,0,0,0,0,100,0),
+(@PATH,4,671.0353,857.2063,88.03369,0,0,0,0,100,0),
+(@PATH,5,654.3708,839.1426,92.26675,0,0,0,0,100,0),
+(@PATH,6,665.0302,825.1126,92.79195,0,0,0,0,100,0),
+(@PATH,7,676.2831,811.0319,91.35089,0,0,0,0,100,0),
+(@PATH,8,686.8073,793.7155,91.44858,0,0,0,0,100,0),
+(@PATH,9,677.3999,776.6302,92.74747,0,0,0,0,100,0),
+(@PATH,10,665.7012,748.0738,95.86366,0,0,0,0,100,0),
+(@PATH,11,681.8578,733.5118,98.44994,0,0,0,0,100,0),
+(@PATH,12,707.1171,725.1872,100.8751,0,0,0,0,100,0),
+(@PATH,13,726.8154,737.6722,96.31778,0,0,0,0,100,0),
+(@PATH,14,719.0989,754.0613,90.51482,0,0,0,0,100,0),
+(@PATH,15,713.662,771.6096,88.23598,0,0,0,0,100,0),
+(@PATH,16,716.9744,788.59,82.94994,0,0,0,0,100,0),
+(@PATH,17,733.7443,799.838,88.94534,0,0,0,0,100,0),
+(@PATH,18,727.9385,816.7637,91.30215,0,0,0,0,100,0),
+(@PATH,19,745.0323,835.8409,88.57227,0,0,0,0,100,0),
+(@PATH,20,739.6656,855.0559,89.27127,0,0,0,0,100,0),
+(@PATH,21,704.845,854.928,87.21674,0,0,0,0,100,0),
+(@PATH,22,684.8253,829.2227,61.5013,0,0,0,0,100,0),
+(@PATH,23,698.3776,886.3561,81.77051,0,0,0,0,100,0),
+(@PATH,24,684.1354,876.6398,81.37528,0,0,0,0,100,0),
+(@PATH,25,675.1725,863.7006,85.42295,0,0,0,0,100,0),
+(@PATH,26,665.3327,850.2184,90.57676,0,0,0,0,100,0),
+(@PATH,27,654.0191,831.2237,92.7365,0,0,0,0,100,0),
+(@PATH,28,666.6762,821.2208,92.56613,0,0,0,0,100,0),
+(@PATH,29,678.6386,808.9705,91.21234,0,0,0,0,100,0),
+(@PATH,30,686.7315,792.9811,91.48143,0,0,0,0,100,0),
+(@PATH,31,677.869,778.1553,92.57193,0,0,0,0,100,0),
+(@PATH,32,666.2241,754.3832,95.36311,0,0,0,0,100,0),
+(@PATH,33,676.5839,736.2492,97.78069,0,0,0,0,100,0),
+(@PATH,34,696.7589,725.5475,100.1104,0,0,0,0,100,0),
+(@PATH,35,723.6034,728.8466,99.61018,0,0,0,0,100,0),
+(@PATH,36,721.4728,743.7043,93.71843,0,0,0,0,100,0),
+(@PATH,37,720.0228,758.7482,89.37604,0,0,0,0,100,0),
+(@PATH,38,709.994,776.279,87.52052,0,0,0,0,100,0),
+(@PATH,39,718.8264,789.2113,82.73032,0,0,0,0,100,0),
+(@PATH,40,733.8046,799.5186,88.7188,0,0,0,0,100,0),
+(@PATH,41,727.3571,814.8444,91.64865,0,0,0,0,100,0),
+(@PATH,42,740.9789,830.5164,88.71099,0,0,0,0,100,0),
+(@PATH,43,743.0773,850.1363,88.99787,0,0,0,0,100,0),
+(@PATH,44,736.563,869.9094,88.69666,0,0,0,0,100,0),
+(@PATH,45,730.1244,887.3021,86.68524,0,0,0,0,100,0);
+
+SET @CGUID := 53908;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=803.3759,`position_y`=932.4915,`position_z`=184.5064 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,803.3759,932.4915,184.5064,0,0,0,0,100,0),
+(@PATH,2,811.2745,897.108,184.5064,0,0,0,0,100,0),
+(@PATH,3,791.5839,875.892,184.5064,0,0,0,0,100,0),
+(@PATH,4,752.4867,868.6232,184.5064,0,0,0,0,100,0),
+(@PATH,5,705.05,866.4859,184.5064,0,0,0,0,100,0),
+(@PATH,6,678.0823,863.4022,184.5064,0,0,0,0,100,0),
+(@PATH,7,647.4654,864.0757,184.5064,0,0,0,0,100,0),
+(@PATH,8,602.3146,860.2814,184.5064,0,0,0,0,100,0),
+(@PATH,9,586.8052,872.5957,184.5064,0,0,0,0,100,0),
+(@PATH,10,591.912,911.7775,184.5064,0,0,0,0,100,0),
+(@PATH,11,596.0889,931.6774,184.5064,0,0,0,0,100,0),
+(@PATH,12,598.1668,951.7502,184.5064,0,0,0,0,100,0),
+(@PATH,13,615.1454,963.025,184.5064,0,0,0,0,100,0),
+(@PATH,14,644.2123,963.4846,184.5064,0,0,0,0,100,0),
+(@PATH,15,685.0579,963.9983,184.5064,0,0,0,0,100,0),
+(@PATH,16,729.4773,963.7037,184.5064,0,0,0,0,100,0),
+(@PATH,17,768.8865,959.6003,184.5064,0,0,0,0,100,0),
+(@PATH,18,796.7049,938.6107,184.5064,0,0,0,0,100,0);
+
+SET @CGUID := 53909;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=770.2032,`position_y`=872.5198,`position_z`=181.6921 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,770.2032,872.5198,181.6921,0,0,0,0,100,0),
+(@PATH,2,682.4137,853.6569,185.5064,0,0,0,0,100,0),
+(@PATH,3,682.4137,853.6569,185.5064,0,0,0,0,100,0),
+(@PATH,4,664.475,853.7332,185.5064,0,0,0,0,100,0),
+(@PATH,5,647.0729,854.0455,185.5064,0,0,0,0,100,0),
+(@PATH,6,629.7476,852.1154,185.5064,0,0,0,0,100,0),
+(@PATH,7,610.3143,850.0992,185.5064,0,0,0,0,100,0),
+(@PATH,8,588.9752,853.5811,185.5064,0,0,0,0,100,0),
+(@PATH,9,576.4883,875.2385,185.5064,0,0,0,0,100,0),
+(@PATH,10,578.6465,895.5093,185.5064,0,0,0,0,100,0),
+(@PATH,11,594.9009,880.1083,185.1333,0,0,0,0,100,0),
+(@PATH,12,585.7604,930.7364,185.5064,0,0,0,0,100,0),
+(@PATH,13,586.5743,947.4635,185.5064,0,0,0,0,100,0),
+(@PATH,14,600.4178,967.5743,185.5064,0,0,0,0,100,0),
+(@PATH,15,621.386,973.9167,185.5064,0,0,0,0,100,0),
+(@PATH,16,640.011,973.4988,185.5064,0,0,0,0,100,0),
+(@PATH,17,656.649,973.6802,185.5064,0,0,0,0,100,0),
+(@PATH,18,674.64,973.9294,185.5064,0,0,0,0,100,0),
+(@PATH,19,692.6371,974.0429,185.5064,0,0,0,0,100,0),
+(@PATH,20,710.7041,974.1387,185.5064,0,0,0,0,100,0),
+(@PATH,21,728.5746,973.7606,185.5064,0,0,0,0,100,0),
+(@PATH,22,746.7885,973.1296,185.5064,0,0,0,0,100,0),
+(@PATH,23,765.8525,970.9223,185.5064,0,0,0,0,100,0),
+(@PATH,24,785.5649,961.4802,185.5064,0,0,0,0,100,0),
+(@PATH,25,800.0919,948.899,185.5064,0,0,0,0,100,0),
+(@PATH,26,794.3766,952.9479,185.5064,0,0,0,0,100,0),
+(@PATH,27,797.5428,945.5775,185.0609,0,0,0,0,100,0),
+(@PATH,28,821.4426,904.1882,185.5064,0,0,0,0,100,0),
+(@PATH,29,817.6825,885.9722,185.5064,0,0,0,0,100,0),
+(@PATH,30,805.4868,872.5649,185.5064,0,0,0,0,100,0),
+(@PATH,31,808.1692,885.2568,185.473,0,0,0,0,100,0),
+(@PATH,32,800.1074,880.7119,185.0081,0,0,0,0,100,0),
+(@PATH,33,788.5491,876.0101,184.7572,0,0,0,0,100,0);
+
+SET @CGUID := 53912;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=567.1851,`position_y`=905.5403,`position_z`=92.5407 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,567.1851,905.5403,92.5407,0,0,0,0,100,0),
+(@PATH,2,569.4642,936.606,94.2935,0,0,0,0,100,0),
+(@PATH,3,588.3549,952.4572,96.14284,0,0,0,0,100,0),
+(@PATH,4,608.7227,957.9083,95.80928,0,0,0,0,100,0),
+(@PATH,5,629.7247,959.9195,89.01039,0,0,0,0,100,0),
+(@PATH,6,656.1213,954.9207,91.62944,0,0,0,0,100,0),
+(@PATH,7,676.3627,937.7902,92.79279,0,0,0,0,100,0),
+(@PATH,8,681.174,916.6946,94.05388,0,0,0,0,100,0),
+(@PATH,9,681.3068,894.736,95.48655,0,0,0,0,100,0),
+(@PATH,10,679.3223,866.0062,97.40996,0,0,0,0,100,0),
+(@PATH,11,679.02,882.4532,96.32095,0,0,0,0,100,0),
+(@PATH,12,637.7219,843.2443,99.51648,0,0,0,0,100,0),
+(@PATH,13,580.8655,859.8029,65.21204,0,0,0,0,100,0),
+(@PATH,14,575.8312,854.2884,97.52151,0,0,0,0,100,0),
+(@PATH,15,566.8652,874.942,94.03391,0,0,0,0,100,0),
+(@PATH,16,568.5764,889.6505,91.69823,0,0,0,0,100,0);
+
+SET @CGUID := 53913;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=691.5392,`position_y`=864.4608,`position_z`=185.5064 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,691.5392,864.4608,185.5064,0,0,0,0,100,0),
+(@PATH,2,675.0435,863.1305,185.5064,0,0,0,0,100,0),
+(@PATH,3,656.5109,864.5776,185.5064,0,0,0,0,100,0),
+(@PATH,4,638.3679,863.3265,185.5064,0,0,0,0,100,0),
+(@PATH,5,619.8484,860.5443,185.5064,0,0,0,0,100,0),
+(@PATH,6,602.3466,858.1862,185.5064,0,0,0,0,100,0),
+(@PATH,7,586.8511,865.615,185.5064,0,0,0,0,100,0),
+(@PATH,8,586.6971,883.8823,185.5064,0,0,0,0,100,0),
+(@PATH,9,593.5745,878.8385,185.3436,0,0,0,0,100,0),
+(@PATH,10,593.557,918.9376,185.5064,0,0,0,0,100,0),
+(@PATH,11,595.3918,936.4067,185.5064,0,0,0,0,100,0),
+(@PATH,12,597.2048,953.8021,185.5064,0,0,0,0,100,0),
+(@PATH,13,611.8467,963.4763,185.5064,0,0,0,0,100,0),
+(@PATH,14,629.8196,963.694,185.5064,0,0,0,0,100,0),
+(@PATH,15,646.8113,963.5204,185.5064,0,0,0,0,100,0),
+(@PATH,16,664.7418,963.8286,185.5064,0,0,0,0,100,0),
+(@PATH,17,682.7177,963.963,185.5064,0,0,0,0,100,0),
+(@PATH,18,700.6793,964.1635,185.5064,0,0,0,0,100,0),
+(@PATH,19,718.1179,964.2392,185.5064,0,0,0,0,100,0),
+(@PATH,20,736.3901,963.5446,185.5064,0,0,0,0,100,0),
+(@PATH,21,753.8398,963.4592,185.5064,0,0,0,0,100,0),
+(@PATH,22,771.5734,959.4213,185.5064,0,0,0,0,100,0),
+(@PATH,23,785.9648,948.2468,185.5064,0,0,0,0,100,0),
+(@PATH,24,780.8196,951.2471,185.4631,0,0,0,0,100,0),
+(@PATH,25,793.3677,942.2335,184.8822,0,0,0,0,100,0),
+(@PATH,26,810.6142,913.2847,185.5064,0,0,0,0,100,0),
+(@PATH,27,813.7405,899.5538,185.5064,0,0,0,0,100,0),
+(@PATH,28,807.6729,886.5371,185.5064,0,0,0,0,100,0),
+(@PATH,29,808.4722,891.8398,185.4929,0,0,0,0,100,0),
+(@PATH,30,798.6889,882.6483,184.9273,0,0,0,0,100,0),
+(@PATH,31,787.9625,877.1612,184.7302,0,0,0,0,100,0),
+(@PATH,32,774.4854,873.2689,184.6191,0,0,0,0,100,0),
+(@PATH,33,740.3132,867.6484,185.5064,0,0,0,0,100,0),
+(@PATH,34,725.5665,867.2691,185.5064,0,0,0,0,100,0),
+(@PATH,35,711.9835,867.1437,185.5064,0,0,0,0,100,0);
+
+SET @CGUID := 53914;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=772.7885,`position_y`=654.1609,`position_z`=181.0927 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,772.7885,654.1609,181.0927,0,0,0,0,100,0),
+(@PATH,2,741.7479,664.2408,181.0927,0,0,0,0,100,0),
+(@PATH,3,706.3735,660.1111,181.0927,0,0,0,0,100,0),
+(@PATH,4,687.1923,657.1448,181.0927,0,0,0,0,100,0),
+(@PATH,5,664.6516,660.413,181.0927,0,0,0,0,100,0),
+(@PATH,6,645.1816,670.5711,181.0927,0,0,0,0,100,0),
+(@PATH,7,622.322,689.5355,181.0927,0,0,0,0,100,0),
+(@PATH,8,610.5265,710.7983,181.0927,0,0,0,0,100,0),
+(@PATH,9,618.5477,735.175,181.0927,0,0,0,0,100,0),
+(@PATH,10,638.978,750.4484,181.0927,0,0,0,0,100,0),
+(@PATH,11,662.0802,750.7849,181.0927,0,0,0,0,100,0),
+(@PATH,12,686.8675,756.3293,181.0927,0,0,0,0,100,0),
+(@PATH,13,717.1716,755.1641,181.0927,0,0,0,0,100,0),
+(@PATH,14,751.1226,745.5831,181.0927,0,0,0,0,100,0),
+(@PATH,15,793.9115,741.4536,181.0927,0,0,0,0,100,0),
+(@PATH,16,808.7234,721.0219,181.0927,0,0,0,0,100,0),
+(@PATH,17,813.506,690.8309,181.0927,0,0,0,0,100,0),
+(@PATH,18,807.697,660.5173,181.0927,0,0,0,0,100,0),
+(@PATH,19,795.8221,652.5587,181.0927,0,0,0,0,100,0),
+(@PATH,20,778.0756,652.9412,181.0927,0,0,0,0,100,0);
+
+SET @CGUID := 53915;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=611.2323,`position_y`=772.1125,`position_z`=100.3375 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,611.2323,772.1125,100.3375,0,0,0,0,100,0),
+(@PATH,2,610.3099,773.2811,101.0543,0,0,0,0,100,0),
+(@PATH,3,593.9789,761.1765,100.2642,0,0,0,0,100,0),
+(@PATH,4,596.4754,741.2283,102.9648,0,0,0,0,100,0),
+(@PATH,5,602.8006,723.6838,102.6062,0,0,0,0,100,0),
+(@PATH,6,597.0957,699.6459,103.9118,0,0,0,0,100,0),
+(@PATH,7,610.3877,682.6296,101.8653,0,0,0,0,100,0),
+(@PATH,8,633.4901,681.085,98.25417,0,0,0,0,100,0),
+(@PATH,9,645.6487,698.6017,100.1986,0,0,0,0,100,0),
+(@PATH,10,647.328,728.833,103.0319,0,0,0,0,100,0),
+(@PATH,11,642.2083,757.2476,103.1986,0,0,0,0,100,0),
+(@PATH,12,624.1133,771.72,100.3653,0,0,0,0,100,0);
+
+SET @CGUID := 53916;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=720.1983,`position_y`=773.6754,`position_z`=182.0927 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,720.1983,773.6754,182.0927,0,0,0,0,100,0),
+(@PATH,2,734.9511,767.1181,182.0927,0,0,0,0,100,0),
+(@PATH,3,749.4861,762.5421,182.0927,0,0,0,0,100,0),
+(@PATH,4,770.0009,763.1467,182.0927,0,0,0,0,100,0),
+(@PATH,5,800.0214,762.2766,182.0927,0,0,0,0,100,0),
+(@PATH,6,818.5339,745.1193,182.0927,0,0,0,0,100,0),
+(@PATH,7,827.5038,725.6721,182.0927,0,0,0,0,100,0),
+(@PATH,8,832.0837,704.4107,182.0927,0,0,0,0,100,0),
+(@PATH,9,831.9136,681.903,182.0927,0,0,0,0,100,0),
+(@PATH,10,826.7904,647.8798,182.0927,0,0,0,0,100,0),
+(@PATH,11,801.674,633.2579,182.0927,0,0,0,0,100,0),
+(@PATH,12,814.5579,649.2947,182.0923,0,0,0,0,100,0),
+(@PATH,13,801.0446,650.5958,181.7404,0,0,0,0,100,0),
+(@PATH,14,760.7453,641.9697,182.0927,0,0,0,0,100,0),
+(@PATH,15,753.7795,647.4783,182.0927,0,0,0,0,100,0),
+(@PATH,16,742.7457,648.2622,182.0927,0,0,0,0,100,0),
+(@PATH,17,730.8102,646.2585,182.0927,0,0,0,0,100,0),
+(@PATH,18,719.2238,645.16,182.0927,0,0,0,0,100,0),
+(@PATH,19,704.7307,639.3378,182.0927,0,0,0,0,100,0),
+(@PATH,20,690.13,638.024,182.0927,0,0,0,0,100,0),
+(@PATH,21,674.1525,638.3937,182.0927,0,0,0,0,100,0),
+(@PATH,22,659.0974,641.6127,182.0927,0,0,0,0,100,0),
+(@PATH,23,646.5961,647.8795,182.0927,0,0,0,0,100,0),
+(@PATH,24,634.9307,655.1992,182.0927,0,0,0,0,100,0),
+(@PATH,25,622.3271,663.3989,182.0927,0,0,0,0,100,0),
+(@PATH,26,610.6317,673.7043,182.0927,0,0,0,0,100,0),
+(@PATH,27,596.7717,688.1019,182.0927,0,0,0,0,100,0),
+(@PATH,28,589.9683,707.7562,182.0927,0,0,0,0,100,0),
+(@PATH,29,592.2947,725.6345,182.0927,0,0,0,0,100,0),
+(@PATH,30,599.0037,742.375,182.0927,0,0,0,0,100,0),
+(@PATH,31,610.2929,755.7358,182.0927,0,0,0,0,100,0),
+(@PATH,32,627.2651,768.8852,182.0927,0,0,0,0,100,0),
+(@PATH,33,640.3808,768.9335,182.0927,0,0,0,0,100,0),
+(@PATH,34,647.518,764.7024,182.0927,0,0,0,0,100,0),
+(@PATH,35,659.9943,769.0815,182.0927,0,0,0,0,100,0),
+(@PATH,36,674.6238,773.7285,182.0927,0,0,0,0,100,0),
+(@PATH,37,688.2984,775.2261,182.0927,0,0,0,0,100,0),
+(@PATH,38,703.0669,775.5544,182.0927,0,0,0,0,100,0),
+(@PATH,39,717.2137,774.4837,182.0927,0,0,0,0,100,0);
+
+SET @CGUID := 12740;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=618.1697,`position_y`=757.3074,`position_z`=102.0629 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21548,0,4097,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,618.1697,757.3074,102.0629,0,0,0,0,100,0),
+(@PATH,2,620.636,747.589,104.0602,0,0,0,0,100,0),
+(@PATH,3,627.2382,717.0773,103.6958,0,0,0,0,100,0),
+(@PATH,4,621.8175,699.6788,104.8484,0,0,0,0,100,0),
+(@PATH,5,621.6443,705.135,104.0194,0,0,0,0,100,0),
+(@PATH,6,622.424,704.8251,101.5694,0,0,0,0,100,0),
+(@PATH,7,622.1757,703.3439,99.21982,0,0,0,0,100,0),
+(@PATH,8,621.1312,703.9969,100.855,0,0,0,0,100,0),
+(@PATH,9,622.5646,713.457,102.6567,0,0,0,0,100,0),
+(@PATH,10,622.2819,728.8792,104.1066,0,0,0,0,100,0),
+(@PATH,11,620.7601,743.2843,104.4669,0,0,0,0,100,0),
+(@PATH,12,620.4224,744.8631,103.4185,0,0,0,0,100,0),
+(@PATH,13,615.5464,748.3319,101.2297,0,0,0,0,100,0),
+(@PATH,14,634.5025,757.4967,72.38888,0,0,0,0,100,0),
+(@PATH,15,634.5104,757.5007,72.37598,0,0,0,0,100,0),
+(@PATH,16,618.5453,755.4985,102.9158,0,0,0,0,100,0),
+(@PATH,17,621.3293,746.1893,103.9798,0,0,0,0,100,0),
+(@PATH,18,626.788,714.7961,103.75,0,0,0,0,100,0),
+(@PATH,19,621.7899,699.5308,104.8121,0,0,0,0,100,0),
+(@PATH,20,621.3626,705.4813,104.3223,0,0,0,0,100,0),
+(@PATH,21,621.3121,705.1012,102.4415,0,0,0,0,100,0),
+(@PATH,22,625.4631,704.6119,99.74145,0,0,0,0,100,0),
+(@PATH,23,620.0256,701.603,99.70113,0,0,0,0,100,0),
+(@PATH,24,621.8276,706.3629,101.4815,0,0,0,0,100,0),
+(@PATH,25,622.6558,717.0432,103.1024,0,0,0,0,100,0),
+(@PATH,26,622.1406,731.1638,104.2091,0,0,0,0,100,0),
+(@PATH,27,620.7473,743.3433,104.4659,0,0,0,0,100,0),
+(@PATH,28,620.6885,744.6069,103.6851,0,0,0,0,100,0),
+(@PATH,29,614.7051,748.4863,101.5833,0,0,0,0,100,0),
+(@PATH,30,609.936,747.1412,101.3292,0,0,0,0,100,0),
+(@PATH,31,623.5999,752.106,102.0542,0,0,0,0,100,0),
+(@PATH,32,618.179,757.1844,101.909,0,0,0,0,100,0);
+
+SET @CGUID := 12739;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=607.7617,`position_y`=829.9091,`position_z`=90.44696 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21548,0,4097,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,607.7617,829.9091,90.44696,0,0,0,0,100,0),
+(@PATH,2,602.4633,830.1422,93.41113,0,0,0,0,100,0),
+(@PATH,3,607.6243,835.0496,91.36709,0,0,0,0,100,0),
+(@PATH,4,606.5493,827.5132,91.94758,0,0,0,0,100,0),
+(@PATH,5,606.7817,814.8796,93.77133,0,0,0,0,100,0),
+(@PATH,6,607.1453,796.8506,94.47835,0,0,0,0,100,0),
+(@PATH,7,607.0215,783.4634,93.29945,0,0,0,0,100,0),
+(@PATH,8,609.2629,777.7833,95.4697,0,0,0,0,100,0),
+(@PATH,9,615.3491,757.2604,100.0487,0,0,0,0,100,0),
+(@PATH,10,616.2725,734.5289,102.7384,0,0,0,0,100,0),
+(@PATH,11,611.5767,745.3478,105.5129,0,0,0,0,100,0),
+(@PATH,12,604.3624,746.663,106.2547,0,0,0,0,100,0),
+(@PATH,13,605.7682,747.9605,103.8478,0,0,0,0,100,0),
+(@PATH,14,607.6742,750.7892,101.3251,0,0,0,0,100,0),
+(@PATH,15,608.0389,760.6672,97.6655,0,0,0,0,100,0),
+(@PATH,16,606.491,773.1877,96.38459,0,0,0,0,100,0),
+(@PATH,17,607.378,797.1143,96.63741,0,0,0,0,100,0),
+(@PATH,18,611.7768,815.5746,97.53774,0,0,0,0,100,0),
+(@PATH,19,614.4452,814.0935,97.00954,0,0,0,0,100,0),
+(@PATH,20,614.4432,814.1082,97.00902,0,0,0,0,100,0),
+(@PATH,21,612.2132,828.8321,90.99244,0,0,0,0,100,0),
+(@PATH,22,608.5633,829.7872,90.09452,0,0,0,0,100,0);
+
+SET @CGUID := 12738;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=808.744,`position_y`=752.8126,`position_z`=93.69208 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21548,0,4097,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,808.744,752.8126,93.69208,0,0,0,0,100,0),
+(@PATH,2,810.0982,728.1007,95.92642,0,0,0,0,100,0),
+(@PATH,3,809.3226,709.2455,101.5179,0,0,0,0,100,0),
+(@PATH,4,804.869,691.9334,103.6763,0,0,0,0,100,0),
+(@PATH,5,789.4135,679.9703,102.1762,0,0,0,0,100,0),
+(@PATH,6,772.5522,683.7802,99.09293,0,0,0,0,100,0),
+(@PATH,7,759.5066,697.9881,100.3707,0,0,0,0,100,0),
+(@PATH,8,752.4968,727.6615,106.1207,0,0,0,0,100,0),
+(@PATH,9,747.4766,760.6776,114.7874,0,0,0,0,100,0),
+(@PATH,10,751.5941,805.2043,104.7318,0,0,0,0,100,0),
+(@PATH,11,751.1071,831.5707,90.48182,0,0,0,0,100,0),
+(@PATH,12,768.2726,846.9728,96.42626,0,0,0,0,100,0),
+(@PATH,13,795.4689,850.97,102.3151,0,0,0,0,100,0),
+(@PATH,14,815.1022,836.6889,95.98182,0,0,0,0,100,0),
+(@PATH,15,812.1649,811.0369,99.09293,0,0,0,0,100,0),
+(@PATH,16,810.7905,781.4119,100.1485,0,0,0,0,100,0);
+
+SET @CGUID := 12737;
+SET @PATH := @CGUID * 10;
+
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=790.1919,`position_y`=890.4173,`position_z`=96.21225 WHERE `guid`=@CGUID;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21548,0,4097,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,790.1919,890.4173,96.21225,0,0,0,0,100,0),
+(@PATH,2,803.1602,893.1978,90.55112,0,0,0,0,100,0),
+(@PATH,3,799.688,889.9006,90.20824,0,0,0,0,100,0),
+(@PATH,4,802.6058,890.4018,89.90356,0,0,0,0,100,0),
+(@PATH,5,802.9925,926.767,88.62688,0,0,0,0,100,0),
+(@PATH,6,797.1304,940.8237,89.18675,0,0,0,0,100,0),
+(@PATH,7,798.6385,941.869,88.60009,0,0,0,0,100,0),
+(@PATH,8,789.894,942.1028,87.77906,0,0,0,0,100,0),
+(@PATH,9,773.556,943.2788,89.22779,0,0,0,0,100,0),
+(@PATH,10,765.2734,942.9044,91.67089,0,0,0,0,100,0),
+(@PATH,11,764.4266,941.9615,96.66107,0,0,0,0,100,0),
+(@PATH,12,762.1209,936.9633,102.0497,0,0,0,0,100,0),
+(@PATH,13,761.3636,923.9997,107.3103,0,0,0,0,100,0),
+(@PATH,14,761.5854,908.6809,109.3919,0,0,0,0,100,0),
+(@PATH,15,763.943,900.4043,106.9297,0,0,0,0,100,0),
+(@PATH,16,766.2017,896.2592,100.4964,0,0,0,0,100,0),
+(@PATH,17,772.8622,893.9176,97.49315,0,0,0,0,100,0),
+(@PATH,18,790.2458,889.8303,96.01199,0,0,0,0,100,0);
+
+-- **************************************** MISSING SPAWNS ****************************************
+SET @CGUID := 54254;
+SET @PATH := @CGUID * 10;
+
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES
+(@CGUID, 23030, 564, 0, 0, 8589950976, 0, 21544, 1, 695.0379, 740.5878, 740.5878, 0, 3600, 0, 0, 140728, 32310, 2, 0, 0, 0, 0);
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21545,0,4097,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,695.0379,740.5878,182.0927,0,0,0,0,100,0),
+(@PATH,2,708.8729,740.1831,182.0927,0,0,0,0,100,0),
+(@PATH,3,727.4776,732.5617,182.0927,0,0,0,0,100,0),
+(@PATH,4,748.5054,727.2003,182.0927,0,0,0,0,100,0),
+(@PATH,5,765.7083,728.0529,182.0927,0,0,0,0,100,0),
+(@PATH,6,775.2858,737.015,182.0927,0,0,0,0,100,0),
+(@PATH,7,785.4459,732.6622,182.0927,0,0,0,0,100,0),
+(@PATH,8,792.5123,720.6128,182.0927,0,0,0,0,100,0),
+(@PATH,9,796.7908,706.5093,182.0927,0,0,0,0,100,0),
+(@PATH,10,797.6062,690.4472,182.0927,0,0,0,0,100,0),
+(@PATH,11,809.627,678.7896,182.0927,0,0,0,0,100,0),
+(@PATH,12,804.4231,668.5062,182.0927,0,0,0,0,100,0),
+(@PATH,13,804.934,672.4259,182.0927,0,0,0,0,100,0),
+(@PATH,14,796.8747,666.9809,181.8125,0,0,0,0,100,0),
+(@PATH,15,768.8938,676.3732,182.0927,0,0,0,0,100,0),
+(@PATH,16,752.1782,682.7973,182.0927,0,0,0,0,100,0),
+(@PATH,17,737.0302,683.1525,182.0927,0,0,0,0,100,0),
+(@PATH,18,724.8998,681.1164,182.0927,0,0,0,0,100,0),
+(@PATH,19,711.6598,679.6968,182.0927,0,0,0,0,100,0),
+(@PATH,20,704.9904,674.6921,182.0927,0,0,0,0,100,0),
+(@PATH,21,695.2261,673.0101,182.0927,0,0,0,0,100,0),
+(@PATH,22,685.7263,671.801,182.0927,0,0,0,0,100,0),
+(@PATH,23,676.828,672.2006,182.0927,0,0,0,0,100,0),
+(@PATH,24,667.0285,676.7328,182.0927,0,0,0,0,100,0),
+(@PATH,25,657.2637,682.6079,182.0927,0,0,0,0,100,0),
+(@PATH,26,648.3331,687.3507,182.0927,0,0,0,0,100,0),
+(@PATH,27,640.038,693.3326,182.0927,0,0,0,0,100,0),
+(@PATH,28,631.494,694.7631,182.0927,0,0,0,0,100,0),
+(@PATH,29,624.1406,698.6867,182.0927,0,0,0,0,100,0),
+(@PATH,30,622.8167,707.7905,182.0927,0,0,0,0,100,0),
+(@PATH,31,622.7652,716.195,182.0927,0,0,0,0,100,0),
+(@PATH,32,626.7378,724.4378,182.0927,0,0,0,0,100,0),
+(@PATH,33,627.8054,733.534,182.0927,0,0,0,0,100,0),
+(@PATH,34,639.0854,733.6019,182.0927,0,0,0,0,100,0),
+(@PATH,35,656.7821,730.5823,182.0927,0,0,0,0,100,0),
+(@PATH,36,667.3138,734.4921,182.0927,0,0,0,0,100,0),
+(@PATH,37,675.8494,738.3944,182.0927,0,0,0,0,100,0),
+(@PATH,38,686.2126,739.9324,182.0927,0,0,0,0,100,0);
+
+-- 7 static
+SET @CGUID := 54255;
+
+DELETE FROM `creature` WHERE `guid` IN(@CGUID+0,@CGUID+1,@CGUID+2,@CGUID+3,@CGUID+4,@CGUID+5,@CGUID+6);
+INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES
+(@CGUID+0, 23030, 564, 0,0,8589950976,0, 21544, 1, 679.4788, 739.0269, 182.0927, 3.597085, 3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+1, 23030, 564, 0,0,8589950976,0, 21544, 1, 746.1173, 843.321,  172.9325, 2.720434, 3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+2, 23030, 564, 0,0,8589950976,0, 21544, 1, 655.0826, 730.4282, 182.0927, 6.161078, 3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+3, 23030, 564, 0,0,8589950976,0, 21544, 1, 727.1025, 735.5541, 97.19754, 5.598838, 3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+4, 23030, 564, 0,0,8589950976,0, 21544, 1, 809.3963, 660.3644, 172.9325, 0.4250514,3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+5, 23030, 564, 0,0,8589950976,0, 21544, 1, 773.0972, 694.7501, 172.9325, 0.5313485,3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0),
+(@CGUID+6, 23030, 564, 0,0,8589950976,0, 21544, 1, 700.8214, 725.056,  100.516,  3.203588, 3600, 0, 0, 140728, 32310, 0, 0, 0, 0, 0);
+
+-- single spawn
+SET @CGUID := 54262;
+SET @PATH := @CGUID * 10;
+
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`PhaseId`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES
+(@CGUID, 23030, 564, 0, 0, 8589950976, 0, 21544, 1, 810.1124, 748.2065, 98.09019, 0, 3600, 0, 0, 140728, 32310, 2, 0, 0, 0, 0);
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@CGUID,@PATH,21548,0,4097,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,810.1124,748.2065,98.09019,0,0,0,0,100,0),
+(@PATH,2,812.1799,731.7729,102.9764,0,0,0,0,100,0),
+(@PATH,3,819.2544,710.6747,104.6852,0,0,0,0,100,0),
+(@PATH,4,814.0609,688.1116,103.3055,0,0,0,0,100,0),
+(@PATH,5,796.0499,671.1177,100.224,0,0,0,0,100,0),
+(@PATH,6,775.2276,672.8571,100.746,0,0,0,0,100,0),
+(@PATH,7,761.4761,684.9821,103.3551,0,0,0,0,100,0),
+(@PATH,8,757.2691,702.5233,106.9886,0,0,0,0,100,0),
+(@PATH,9,754.0154,718.1474,112.2537,0,0,0,0,100,0),
+(@PATH,10,747.9337,735.1084,115.7933,0,0,0,0,100,0),
+(@PATH,11,745.829,752.0821,113.6542,0,0,0,0,100,0),
+(@PATH,12,747.8068,770.1235,109.0152,0,0,0,0,100,0),
+(@PATH,13,753.1844,786.4976,103.0236,0,0,0,0,100,0),
+(@PATH,14,749.2501,801.4901,93.55122,0,0,0,0,100,0),
+(@PATH,15,738.5554,821.9026,92.52246,0,0,0,0,100,0),
+(@PATH,16,747.3125,839.3755,98.11914,0,0,0,0,100,0),
+(@PATH,17,763.0296,850.4688,102.5345,0,0,0,0,100,0),
+(@PATH,18,781.9125,859.7533,101.6105,0,0,0,0,100,0),
+(@PATH,19,806.5648,859.7701,96.95612,0,0,0,0,100,0),
+(@PATH,20,819.6655,844.2811,98.91273,0,0,0,0,100,0),
+(@PATH,21,812.7062,827.3618,100.7621,0,0,0,0,100,0),
+(@PATH,22,812.3382,809.6904,101.333,0,0,0,0,100,0);
+-- ************************************************************************************************