DB/Pathing: Azuremyst Isle Updates

* by @Grz3s

1 files changed, 394 insertions, 0 deletions

diff --git a/sql/updates/world/2015_10_23_02_world.sql b/sql/updates/world/2015_10_23_02_world.sql
new file mode 100644
index 00000000000..3227d9b2096
--- /dev/null
+++ b/sql/updates/world/2015_10_23_02_world.sql
@@ -0,0 +1,394 @@
+-- Azuremyst Isle
+
+-- Duplicates
+DELETE FROM creature WHERE guid IN (57365,57401,57367,57392);
+DELETE FROM creature_addon WHERE guid IN (57365,57401,57367,57392);
+-- Vale Moth
+UPDATE creature SET position_x = -4056.166748, position_y = -13679.827148, position_z = 70.195099, orientation = 2.894147 WHERE guid = 57400;
+UPDATE creature SET position_x = -4009.254883, position_y = -13751.575195, position_z = 69.994392, orientation = 1.271510 WHERE guid = 57362;
+UPDATE creature SET position_x = -4002.972168, position_y = -13721.668945, position_z = 66.997993, orientation = 5.467894 WHERE guid = 57364;
+
+-- Mutated Root Lasher
+DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id = 16517);
+UPDATE creature SET position_x = -4072.798828, position_y = -13457.387695, position_z = 53.739014, orientation = 0.767300 WHERE guid = 57304;
+
+-- Megelon
+-- should kneel
+DELETE FROM `creature_template_addon` WHERE `entry`=16475;
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(16475,0,0,8,1,0, '');
+
+-- Red Crystal Bunny
+UPDATE creature_template SET inhabittype = 4 WHERE entry = 17947;
+
+UPDATE creature SET spawndist = 0, MovementType = 0 WHERE guid IN (57429,57418,57435,57419,57417,57425,57431);
+UPDATE creature SET position_x = -4494.916016, position_y = -13426.375977, position_z = 50.020802, orientation = 0.199758 WHERE guid = 57424;
+UPDATE creature SET position_x = -4493.666016, position_y = -13412.100586, position_z = 49.711666, orientation = 5.910391 WHERE guid = 57426;
+UPDATE creature SET position_x = -4489.001953, position_y = -13347.736328, position_z = 55.123600, spawndist = 5 WHERE guid = 57433;
+UPDATE creature SET position_x = -4558.07, position_y = -13383, position_z = 84.0283, orientation = 0.980421, spawndist = 0, MovementType = 0 WHERE guid = 57415;
+UPDATE creature SET position_x = -4561.61, position_y = -13332, position_z = 78.297, orientation = 4.36313, spawndist = 0, MovementType = 0 WHERE guid = 57438;
+UPDATE creature SET position_x = -4495.072754, position_y = -13341.267578, position_z = 54.948174, orientation = 0.872046, spawndist = 0, MovementType = 2 WHERE guid = 57432;
+UPDATE creature SET spawndist = 0, MovementType = 2 WHERE guid IN (57436,57420);
+
+SET @NPC := 57420;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4570.33, -13342, 79.7079),
+(@PATH,  2, -4572.42, -13338.7, 81.9836),
+(@PATH,  3, -4573.8, -13332.1, 85.5403),
+(@PATH,  4, -4573.62, -13325.4, 88.0573),
+(@PATH,  5, -4571.77, -13319.3, 88.317),
+(@PATH,  6, -4558.65, -13302.6, 85.9795),
+(@PATH,  7, -4550.41, -13299, 82.8511),
+(@PATH,  8, -4542.54, -13296.4, 79.706),
+(@PATH,  9, -4551.81, -13299.4, 83.4887),
+(@PATH,  10, -4558, -13302.1, 85.7307),
+(@PATH,  11, -4569.98, -13314.4, 87.7967),
+(@PATH,  12, -4574.35, -13325.8, 87.9575),
+(@PATH,  13, -4574.1, -13333.5, 84.9354),
+(@PATH,  14, -4572.79, -13338.5, 82.1879),
+(@PATH,  15, -4570.21, -13342.1, 79.6678),
+(@PATH,  16, -4565.7, -13343.3, 78.4452);
+
+SET @NPC := 57436;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4537.6, -13317.9, 77.7301),
+(@PATH,  2, -4531.29, -13317.2, 77.917),
+(@PATH,  3, -4538.35, -13312.8, 77.9808),
+(@PATH,  4, -4538.11, -13320.2, 77.6869),
+(@PATH,  5, -4536.77, -13324.9, 77.5682),
+(@PATH,  6, -4537, -13320.7, 77.6223),
+(@PATH,  7, -4533.12, -13307.4, 77.7173),
+(@PATH,  8, -4525.5, -13301.3, 77.8192),
+(@PATH,  9, -4516, -13301.1, 76.9484),
+(@PATH,  10, -4508.35, -13305, 74.2754),
+(@PATH,  11, -4503.76, -13309.2, 70.6749),
+(@PATH,  12, -4502.26, -13315, 68.1374),
+(@PATH,  13, -4500.93, -13322.2, 64.4202),
+(@PATH,  14, -4502.32, -13314.8, 68.1939),
+(@PATH,  15, -4505.17, -13307.9, 71.7238),
+(@PATH,  16, -4511.36, -13302.8, 75.8496),
+(@PATH,  17, -4521.51, -13300.4, 77.5693),
+(@PATH,  18, -4529.88, -13303.2, 77.7191),
+(@PATH,  19, -4536.49, -13312.7, 77.9282),
+(@PATH,  20, -4542.37, -13324.8, 77.5282),
+(@PATH,  21, -4550.38, -13333.2, 77.7908),
+(@PATH,  22, -4550.78, -13344.5, 78.0558),
+(@PATH,  23, -4548.2, -13347.2, 77.6171),
+(@PATH,  24, -4544.49, -13348.3, 76.6312),
+(@PATH,  25, -4550.57, -13355.2, 78.4657),
+(@PATH,  26, -4541.91, -13366.4, 75.7633),
+(@PATH,  27, -4537.09, -13379.5, 72.2425),
+(@PATH,  28, -4526.18, -13391.8, 63.0653),
+(@PATH,  29, -4535.68, -13382.6, 70.6931),
+(@PATH,  30, -4540.1, -13371.5, 74.4121),
+(@PATH,  31, -4543.29, -13364.2, 76.4836),
+(@PATH,  32, -4549.18, -13357.4, 78.4678),
+(@PATH,  33, -4553.56, -13358.2, 78.9982),
+(@PATH,  34, -4556.42, -13365.6, 82.0062),
+(@PATH,  35, -4557.25, -13379.6, 84.2324),
+(@PATH,  36, -4556.48, -13368.8, 83.0642),
+(@PATH,  37, -4554.17, -13357.4, 78.9413),
+(@PATH,  38, -4550.83, -13348.5, 78.0941),
+(@PATH,  39, -4551.95, -13326, 78.1122),
+(@PATH,  40, -4552.54, -13331.4, 77.8854),
+(@PATH,  41, -4555.86, -13336.1, 77.8128),
+(@PATH,  42, -4560.8, -13337.2, 77.8925),
+(@PATH,  43, -4561.78, -13335, 78.0228),
+(@PATH,  44, -4560.34, -13337.7, 77.8832),
+(@PATH,  45, -4551.95, -13333.7, 77.7376),
+(@PATH,  46, -4543.65, -13322.2, 77.7184);
+
+SET @NPC := 57432;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4503.06, -13357.7, 54.1247),
+(@PATH,  2, -4506.78, -13373.2, 53.7056),
+(@PATH,  3, -4507.36, -13387, 53.8641),
+(@PATH,  4, -4506.39, -13372.9, 53.7694),
+(@PATH,  5, -4502.84, -13357.5, 54.1533),
+(@PATH,  6, -4495.22, -13341.5, 54.8385);
+
+UPDATE creature SET spawndist = 0, MovementType = 0 WHERE guid IN (57473,57466,57319,57321,57468,57467,57320,57470,57472,57474,57471,57316,57457,57458,57450,57462,57318,57463,57465,57464,57461);
+UPDATE creature SET position_x = -4471.007813, position_y = -14096.670898, position_z = 109.848373, orientation = 2.725909 WHERE guid = 57464;
+UPDATE creature SET position_x = -4643.638672, position_y = -13940.991211, position_z = 85.342995, orientation = 5.246780 WHERE guid = 57474;
+-- missing added - -- UDB free guid used
+
+DELETE FROM creature WHERE guid IN (
+75958,
+75959,
+75960,
+75961,
+75962,
+75963,
+75964,
+75965,
+75966,
+75967);
+
+INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, curhealth, curmana, MovementType) VALUES 
+(75958,16537,530,1,1,0,0,-4434.66,-13759.4,56.6934,6.16494,300,0,71,0,2),
+(75959,16537,530,1,1,0,0,-4447.7,-13871.1,100.039,0.550673,300,0,71,0,2),
+(75960,16537,530,1,1,0,0,-4589.24,-13965.9,82.7032,3.97444,300,0,71,0,2),
+(75961,16537,530,1,1,0,0,-4594.7,-14003.5,86.0174,1.36692,300,0,71,0,2),
+(75962,16537,530,1,1,0,0,-4654.6,-13981.2,85.2454,0.550101,300,5,71,0,1),
+ -- Nestlewwod Owlkin
+(75963,16518,530,1,1,0,0,-4523.47,-14045.3,108.254,1.15354,300,0,86,0,2),
+(75964,16518,530,1,1,0,0,-4622.08,-13980.5,83.0399,5.28298,300,0,86,0,0),
+(75965,16518,530,1,1,0,0,-4637.72,-13935.3,86.0136,5.21538,300,0,71,0,0),
+(75966,16518,530,1,1,0,0,-4667.34,-13966,87.076,5.68662,300,0,86,0,0),
+(75967,16518,530,1,1,0,0,-4646.43,-14010,88.6244,2.11305,300,0,71,0,0);
+
+SET @NPC := 75961;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4592.98, -13982.5, 84.4159),
+(@PATH,  2, -4586.16, -13971.4, 82.9927),
+(@PATH,  3, -4580.24, -13956.1, 83.3117),
+(@PATH,  4, -4572.24, -13945.5, 83.977),
+(@PATH,  5, -4553.06, -13927.5, 84.9424),
+(@PATH,  6, -4540.27, -13916, 87.0233),
+(@PATH,  7, -4533.76, -13907.4, 89.6782),
+(@PATH,  8, -4526.08, -13901.9, 91.075),
+(@PATH,  9, -4511.39, -13896.2, 93.3214),
+(@PATH,  10, -4501.98, -13896, 95.7497),
+(@PATH,  11, -4513.02, -13896.4, 92.8177),
+(@PATH,  12, -4524.08, -13900.5, 91.1834),
+(@PATH,  13, -4533.81, -13907.2, 89.7356),
+(@PATH,  14, -4537.63, -13911.7, 87.7131),
+(@PATH,  15, -4543.6, -13919.2, 87.4545),
+(@PATH,  16, -4552.8, -13927.3, 84.9588),
+(@PATH,  17, -4576.24, -13949, 83.6602),
+(@PATH,  18, -4589.23, -13952, 83.2427),
+(@PATH,  19, -4604.19, -13952, 83.5327),
+(@PATH,  20, -4616.22, -13947.2, 83.8974),
+(@PATH,  21, -4627.14, -13943.9, 84.4674),
+(@PATH,  22, -4637.3, -13944.4, 85.009),
+(@PATH,  23, -4649.9, -13949.8, 85.5586),
+(@PATH,  24, -4657.77, -13959.4, 86.2783),
+(@PATH,  25, -4664.29, -13969.3, 86.5976),
+(@PATH,  26, -4662.94, -13981.2, 86.5135),
+(@PATH,  27, -4659.69, -13991.1, 87.4205),
+(@PATH,  28, -4659.05, -14002.6, 88.7217),
+(@PATH,  29, -4658.11, -13991.3, 87.3414),
+(@PATH,  30, -4652.72, -13982.8, 85.1681),
+(@PATH,  31, -4644.96, -13980.1, 83.6062),
+(@PATH,  32, -4629.25, -13979.6, 82.8775),
+(@PATH,  33, -4612.33, -13973.1, 83.1243),
+(@PATH,  34, -4597.79, -13975.3, 83.3084),
+(@PATH,  35, -4592.27, -13985.8, 84.9837),
+(@PATH,  36, -4594.39, -14003.7, 86.0171);
+
+SET @NPC := 75960;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4592.27, -13969.7, 82.8063),
+(@PATH,  2, -4598.27, -13970.8, 82.8528),
+(@PATH,  3, -4602.71, -13969, 82.9031),
+(@PATH,  4, -4605.37, -13963.2, 82.86),
+(@PATH,  5, -4604.43, -13957.7, 82.9402),
+(@PATH,  6, -4599.52, -13953.3, 83.2446),
+(@PATH,  7, -4593.36, -13953.8, 83.11),
+(@PATH,  8, -4588.46, -13958.5, 82.7968),
+(@PATH,  9, -4588.68, -13965.4, 82.7122);
+
+SET @NPC := 75963;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4517.82, -14036.6, 109.638),
+(@PATH,  2, -4512.34, -14031.9, 111.705),
+(@PATH,  3, -4504.76, -14032, 115.22),
+(@PATH,  4, -4495.7, -14035, 120.769),
+(@PATH,  5, -4485.96, -14035.7, 125.867),
+(@PATH,  6, -4477.07, -14034.1, 130.216),
+(@PATH,  7, -4468.08, -14026.7, 135.697),
+(@PATH,  8, -4463.56, -14019.2, 139.389),
+(@PATH,  9, -4462.25, -14008.6, 144.543),
+(@PATH,  10, -4462.15, -13995.7, 151.398),
+(@PATH,  11, -4459.33, -13989.3, 155.012),
+(@PATH,  12, -4453.88, -13984, 158.884),
+(@PATH,  13, -4442.96, -13977.9, 162.913),
+(@PATH,  14, -4437.08, -13973.9, 163.54),
+(@PATH,  15, -4442.83, -13978.1, 162.882),
+(@PATH,  16, -4447.89, -13981.6, 160.698),
+(@PATH,  17, -4454.41, -13984.3, 158.621),
+(@PATH,  18, -4459.15, -13988.9, 155.249),
+(@PATH,  19, -4462.06, -13995.7, 151.433),
+(@PATH,  20, -4463.62, -14005.8, 145.88),
+(@PATH,  21, -4464.5, -14015.9, 140.278),
+(@PATH,  22, -4465.92, -14022.3, 137.806),
+(@PATH,  23, -4473.41, -14032, 132.139),
+(@PATH,  24, -4480.65, -14035.1, 128.564),
+(@PATH,  25, -4489.53, -14035.6, 123.745),
+(@PATH,  26, -4499.66, -14033.4, 118.385),
+(@PATH,  27, -4509.38, -14031.3, 113.055),
+(@PATH,  28, -4516.56, -14033.5, 110.339),
+(@PATH,  29, -4522.55, -14042.1, 108.413),
+(@PATH,  30, -4522.58, -14049.5, 108.513),
+(@PATH,  31, -4511.73, -14069.1, 108.323),
+(@PATH,  32, -4494.98, -14092.5, 108.716),
+(@PATH,  33, -4480.21, -14106.9, 109.008),
+(@PATH,  34, -4476.78, -14106.6, 109.331),
+(@PATH,  35, -4480.54, -14107, 109.074),
+(@PATH,  36, -4501.89, -14085, 108.471),
+(@PATH,  37, -4513.44, -14066.2, 108.282),
+(@PATH,  38, -4523.29, -14045.9, 108.31),
+(@PATH,  39, -4531.47, -14045.2, 107.159),
+(@PATH,  40, -4540.48, -14042.7, 104.373),
+(@PATH,  41, -4545.76, -14038.1, 101.742),
+(@PATH,  42, -4549.34, -14028.7, 97.4769),
+(@PATH,  43, -4550.8, -14014.1, 91.238),
+(@PATH,  44, -4549.57, -14028.6, 97.381),
+(@PATH,  45, -4545.99, -14038.1, 101.736),
+(@PATH,  46, -4540.46, -14042.4, 104.306),
+(@PATH,  47, -4531.34, -14045, 107.178),
+(@PATH,  48, -4522.13, -14050.4, 108.592),
+(@PATH,  49, -4503.35, -14075.6, 108.32),
+(@PATH,  50, -4475.96, -14095.1, 109.774),
+(@PATH,  51, -4473.36, -14101.2, 109.944),
+(@PATH,  52, -4474.57, -14105.7, 109.152),
+(@PATH,  53, -4480.68, -14108, 109.006),
+(@PATH,  54, -4502.26, -14085.2, 108.472),
+(@PATH,  55, -4522.41, -14050.8, 108.626),
+(@PATH,  56, -4522.98, -14042.5, 108.354);
+
+SET @NPC := 75959;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4438.31, -13862.6, 91.776),
+(@PATH,  2, -4431.32, -13855.8, 84.8948),
+(@PATH,  3, -4426.89, -13851, 80.9621),
+(@PATH,  4, -4425.11, -13841, 79.7135),
+(@PATH,  5, -4425.27, -13831.5, 80.3198),
+(@PATH,  6, -4428.9, -13821.8, 80.8588),
+(@PATH,  7, -4431.14, -13808.6, 82.159),
+(@PATH,  8, -4428.98, -13822, 80.8303),
+(@PATH,  9, -4425.5, -13831.3, 80.3171),
+(@PATH,  10, -4425.99, -13848.9, 80.3403),
+(@PATH,  11, -4422.94, -13853.1, 79.9921),
+(@PATH,  12, -4405.51, -13848.8, 71.1473),
+(@PATH,  13, -4394.64, -13843.8, 69.9378),
+(@PATH,  14, -4373.31, -13829.4, 69.2241),
+(@PATH,  15, -4367.44, -13827.8, 69.2241),
+(@PATH,  16, -4374.24, -13829.8, 69.2241),
+(@PATH,  17, -4395.14, -13844.2, 69.9654),
+(@PATH,  18, -4401.71, -13847.1, 70.3372),
+(@PATH,  19, -4408.22, -13846.1, 70.6981),
+(@PATH,  20, -4410.12, -13840.5, 68.5303),
+(@PATH,  21, -4407.06, -13825, 62.3528),
+(@PATH,  22, -4406.01, -13816.6, 60.4572),
+(@PATH,  23, -4401.2, -13811.8, 58.4539),
+(@PATH,  24, -4395.99, -13804.2, 55.897),
+(@PATH,  25, -4401.33, -13812.3, 58.5553),
+(@PATH,  26, -4405.57, -13815.9, 60.3377),
+(@PATH,  27, -4407.42, -13829.5, 63.9209),
+(@PATH,  28, -4409.96, -13840.7, 68.609),
+(@PATH,  29, -4407.79, -13845.8, 70.5699),
+(@PATH,  30, -4401.1, -13847.4, 70.3476),
+(@PATH,  31, -4393.45, -13843.7, 69.9347),
+(@PATH,  32, -4373.67, -13829.4, 69.2235),
+(@PATH,  33, -4366.85, -13827.6, 69.2235),
+(@PATH,  34, -4374.52, -13829.8, 69.228),
+(@PATH,  35, -4397.51, -13845.3, 70.0348),
+(@PATH,  36, -4405.96, -13849.2, 71.4118),
+(@PATH,  37, -4420.98, -13853.4, 79.1551),
+(@PATH,  38, -4425.01, -13851.3, 80.4895),
+(@PATH,  39, -4426.2, -13842.6, 79.8567),
+(@PATH,  40, -4425.92, -13830.4, 80.3672),
+(@PATH,  41, -4429.15, -13820.9, 80.9154),
+(@PATH,  42, -4431.09, -13808.4, 82.1788),
+(@PATH,  43, -4429.49, -13822.1, 80.7973),
+(@PATH,  44, -4425.68, -13831.3, 80.2927),
+(@PATH,  45, -4425.49, -13843.3, 79.8208),
+(@PATH,  46, -4426.59, -13851.3, 80.9487),
+(@PATH,  47, -4431.98, -13856.3, 85.4742),
+(@PATH,  48, -4438.4, -13862.8, 91.9377),
+(@PATH,  49, -4446.83, -13869.7, 99.5607),
+(@PATH,  50, -4450.92, -13879.3, 102.427),
+(@PATH,  51, -4447.55, -13889, 107.062),
+(@PATH,  52, -4439.39, -13901.1, 116.042),
+(@PATH,  53, -4435.46, -13912.5, 124.001),
+(@PATH,  54, -4434.29, -13919.4, 128.474),
+(@PATH,  55, -4429.09, -13933.4, 138.171),
+(@PATH,  56, -4429.81, -13941.6, 143.975),
+(@PATH,  57, -4426.58, -13948.8, 149.331),
+(@PATH,  58, -4424.46, -13957.5, 154.731),
+(@PATH,  59, -4424.99, -13971.4, 161.606),
+(@PATH,  60, -4425, -13966.8, 160.317),
+(@PATH,  61, -4424.71, -13954.9, 153.1),
+(@PATH,  62, -4426.49, -13948.2, 149.01),
+(@PATH,  63, -4429.64, -13942, 144.229),
+(@PATH,  64, -4429.46, -13931.9, 137.163),
+(@PATH,  65, -4433.91, -13920.2, 129.02),
+(@PATH,  66, -4436.84, -13906.8, 119.518),
+(@PATH,  67, -4439.42, -13900.3, 115.63),
+(@PATH,  68, -4445.36, -13893.5, 110.394),
+(@PATH,  69, -4449.88, -13882.6, 103.797),
+(@PATH,  70, -4450.84, -13875.1, 101.276),
+(@PATH,  71, -4448.44, -13870.8, 100.18);
+
+SET @NPC := 75958;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`) VALUES
+(@PATH,  1, -4397.45, -13759, 52.5403),
+(@PATH,  2, -4387.6, -13750.7, 51.187),
+(@PATH,  3, -4384.44, -13738.6, 50.5713),
+(@PATH,  4, -4385.32, -13731.1, 50.4359),
+(@PATH,  5, -4391.07, -13724.8, 50.5065),
+(@PATH,  6, -4426.98, -13722.3, 51.7162),
+(@PATH,  7, -4437.56, -13719.7, 51.5869),
+(@PATH,  8, -4446.66, -13713.5, 49.9453),
+(@PATH,  9, -4450.02, -13707.3, 48.3929),
+(@PATH,  10, -4448.54, -13698.3, 47.5457),
+(@PATH,  11, -4440.44, -13690.5, 45.7925),
+(@PATH,  12, -4434.76, -13689.6, 45.5794),
+(@PATH,  13, -4430.11, -13694, 46.9106),
+(@PATH,  14, -4423.66, -13715.8, 51.0542),
+(@PATH,  15, -4418.28, -13721.3, 51.1114),
+(@PATH,  16, -4391.7, -13722.8, 50.4426),
+(@PATH,  17, -4381.61, -13727.8, 50.2699),
+(@PATH,  18, -4380.06, -13739.4, 50.4521),
+(@PATH,  19, -4383.25, -13752.4, 50.4515),
+(@PATH,  20, -4392.68, -13769.2, 52.2511),
+(@PATH,  21, -4390.35, -13775.7, 52.1454),
+(@PATH,  22, -4370.44, -13787.6, 52.2808),
+(@PATH,  23, -4368.16, -13791.2, 52.3032),
+(@PATH,  24, -4369.71, -13795.9, 52.4165),
+(@PATH,  25, -4379.54, -13798.8, 52.1976),
+(@PATH,  26, -4391, -13795.6, 53.3708),
+(@PATH,  27, -4392.48, -13786.4, 52.7211),
+(@PATH,  28, -4409.88, -13759.7, 53.5569),
+(@PATH,  29, -4434.79, -13759.4, 56.6967);