DB/Creature: Ironforge pathing

By Malcrom
Cherry pick of https://gitlab.com/trinitycore/TrinityCore_434/commit/e4efcbdf47d7c42dbb3946ee9b690c9513f27552

1 files changed, 1029 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_03_17_00_world.sql b/sql/updates/world/master/2017_03_17_00_world.sql
new file mode 100644
index 00000000000..63d2c50c752
--- /dev/null
+++ b/sql/updates/world/master/2017_03_17_00_world.sql
@@ -0,0 +1,1029 @@
+-- Pathing for Myra Tyrngaarde Entry: 5109
+SET @NPC := 307950;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4956.591,`position_y`=-978.85,`position_z`=501.6299 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,-4956.591,-978.85,501.6299,0,0,0,0,100,0),
+(@PATH,2,-4966.608,-974.9324,502.7797,0,0,0,0,100,0),
+(@PATH,3,-4977.69,-967.0145,501.6595,0,0,0,0,100,0),
+(@PATH,4,-4978.871,-957.095,501.6595,0,0,0,0,100,0),
+(@PATH,5,-4966.549,-946.7832,501.6594,0,0,0,0,100,0),
+(@PATH,6,-4946.386,-929.8782,501.6594,0,0,0,0,100,0),
+(@PATH,7,-4924.84,-913.5948,501.6594,0,0,0,0,100,0),
+(@PATH,8,-4904.366,-898.4344,501.6595,0,0,0,0,100,0),
+(@PATH,9,-4898.426,-902.3857,501.6594,0,0,0,0,100,0),
+(@PATH,10,-4891.908,-916.8919,501.6276,0,0,0,0,100,0),
+(@PATH,11,-4902.026,-933.6296,501.531,0,0,0,0,100,0),
+(@PATH,12,-4925.541,-947.7893,501.5807,0,0,0,0,100,0),
+(@PATH,13,-4940.067,-966.5563,501.5865,0,0,0,0,100,0);
+
+-- Pathing for Sognar Cliffbeard Entry: 5124
+SET @NPC := 307657;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4947.642,`position_y`=-1205.356,`position_z`=501.6595 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,-4947.642,-1205.356,501.6595,0,0,0,0,100,0),
+(@PATH,2,-4957.721,-1193.183,501.6595,0,0,0,0,100,0),
+(@PATH,3,-4974.97,-1183.974,501.6515,0,0,0,0,100,0),
+(@PATH,4,-4983.421,-1169.044,501.6553,0,0,0,0,100,0),
+(@PATH,5,-5002.725,-1160.774,501.6596,0,0,0,0,100,0),
+(@PATH,6,-5014.963,-1164.362,501.6578,0,0,0,0,100,0),
+(@PATH,7,-5017.351,-1177.44,501.6396,0,0,0,0,100,0),
+(@PATH,8,-5006.694,-1195.861,501.6599,0,0,0,0,100,0),
+(@PATH,9,-4991.032,-1215.022,501.678,0,0,0,0,100,0),
+(@PATH,10,-4976.49,-1233.438,501.679,0,0,0,0,100,0),
+(@PATH,11,-4963.135,-1249.538,501.6716,0,0,0,0,100,0),
+(@PATH,12,-4950.89,-1261.213,501.6673,0,0,0,0,100,0),
+(@PATH,13,-4932.905,-1258.331,501.663,0,0,0,0,100,0),
+(@PATH,14,-4925.248,-1245.357,501.6605,0,0,0,0,100,0),
+(@PATH,15,-4926.883,-1234.475,501.6543,0,0,0,0,100,0),
+(@PATH,16,-4941.878,-1220.393,501.6517,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307944;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4958.948,`position_y`=-997.8889,`position_z`=501.4812 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,257,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,-4958.948,-997.8889,501.4812,0,0,0,0,100,0),
+(@PATH,2,-4958.948,-997.8889,501.4812,0.9773844,30000,0,0,100,0),
+(@PATH,3,-4942.368,-973.0673,501.5731,0,0,0,0,100,0),
+(@PATH,4,-4922.72,-954.7523,501.5366,0,0,0,0,100,0),
+(@PATH,5,-4896.282,-936.7808,501.4758,0,0,0,0,100,0),
+(@PATH,6,-4872.001,-926.028,501.4518,0,0,0,0,100,0),
+(@PATH,7,-4872.001,-926.028,501.4518,3.595378,30000,0,0,100,0),
+(@PATH,8,-4905.076,-941.8298,501.505,0,0,0,0,100,0),
+(@PATH,9,-4929.299,-961.5024,501.5463,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307481;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4785.496,`position_y`=-1120.533,`position_z`=498.8071 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,257,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,-4785.496,-1120.533,498.8071,0,0,0,0,100,0),
+(@PATH,2,-4792.42,-1112.879,498.8072,0,0,0,0,100,0),
+(@PATH,3,-4792.646,-1105.183,498.8073,0,0,0,0,100,0),
+(@PATH,4,-4803.73,-1091.774,499.4383,0,0,0,0,100,0),
+(@PATH,5,-4813.405,-1078.999,502.2066,0,0,0,0,100,0),
+(@PATH,6,-4812.579,-1064.783,502.1976,0,0,0,0,100,0),
+(@PATH,7,-4810.207,-1046.023,502.1962,0,0,0,0,100,0),
+(@PATH,8,-4809.493,-1036.15,502.2005,0,0,0,0,100,0),
+(@PATH,9,-4800.306,-1026.912,502.2052,0,0,0,0,100,0),
+(@PATH,10,-4783.109,-1030.221,502.211,0,0,0,0,100,0),
+(@PATH,11,-4764.898,-1039.782,502.2114,0,0,0,0,100,0),
+(@PATH,12,-4746.893,-1056.765,502.1846,0,0,0,0,100,0),
+(@PATH,13,-4734.417,-1080.378,502.2124,0,0,0,0,100,0),
+(@PATH,14,-4732.405,-1105.068,502.2155,0,0,0,0,100,0),
+(@PATH,15,-4738.651,-1131.427,502.1987,0,0,0,0,100,0),
+(@PATH,16,-4747.607,-1146.229,502.2083,0,0,0,0,100,0),
+(@PATH,17,-4760.845,-1144.421,502.2124,0,0,0,0,100,0),
+(@PATH,18,-4770.223,-1134.051,500.0258,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307965;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4979.974,`position_y`=-889.4788,`position_z`=501.6221 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,257,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,-4979.974,-889.4788,501.6221,0,0,0,0,100,0),
+(@PATH,2,-4979.974,-889.4788,501.6221,2.303835,15000,0,0,100,0),
+(@PATH,3,-4981.966,-898.9245,501.597,0,0,0,0,100,0),
+(@PATH,4,-5007.113,-919.845,501.6595,0,0,0,0,100,0),
+(@PATH,5,-5013.242,-937.7985,501.6596,0,0,0,0,100,0),
+(@PATH,6,-5000.367,-953.1014,501.6598,0,0,0,0,100,0),
+(@PATH,7,-4986.6,-963.4806,501.6595,0,24000,0,0,100,0),
+(@PATH,8,-4997.777,-956.2134,501.6596,0,0,0,0,100,0),
+(@PATH,9,-5011.686,-939.2016,501.6595,0,0,0,0,100,0),
+(@PATH,10,-5011.28,-923.054,501.6595,0,0,0,0,100,0),
+(@PATH,11,-4982.625,-898.723,501.5998,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307968;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4973.356,`position_y`=-884.493,`position_z`=501.618 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,257,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,-4973.356,-884.493,501.618,0,0,0,0,100,0),
+(@PATH,2,-4973.356,-884.493,501.618,2.199115,15000,0,0,100,0),
+(@PATH,3,-4964.546,-881.7691,501.6155,0,0,0,0,100,0),
+(@PATH,4,-4940.618,-860.9469,501.6524,0,0,0,0,100,0),
+(@PATH,5,-4923.315,-864.1235,501.6607,0,0,0,0,100,0),
+(@PATH,6,-4908.667,-880.6354,501.6602,0,0,0,0,100,0),
+(@PATH,7,-4902.17,-895.577,501.6595,0,24000,0,0,100,0),
+(@PATH,8,-4908.303,-879.5649,501.6602,0,0,0,0,100,0),
+(@PATH,9,-4921.32,-862.3778,501.6608,0,0,0,0,100,0),
+(@PATH,10,-4932.795,-858.5505,501.662,0,0,0,0,100,0),
+(@PATH,11,-4963.47,-883.8062,501.6109,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307694;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4806.244,`position_y`=-973.1392,`position_z`=399.0644 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,257,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,-4806.244,-973.1392,399.0644,0,0,0,0,100,0),
+(@PATH,2,-4800.596,-974.1511,399.0323,0,0,0,0,100,0),
+(@PATH,3,-4791.679,-971.691,399.0349,0,0,0,0,100,0),
+(@PATH,4,-4781.835,-968.9149,399.0302,0,0,0,0,100,0),
+(@PATH,5,-4774.474,-965.816,399.0424,0,0,0,0,100,0),
+(@PATH,6,-4801.674,-974.8021,399.0738,0,0,0,0,100,0),
+(@PATH,7,-4809.103,-985.1215,398.9658,0,0,0,0,100,0),
+(@PATH,8,-4811.094,-983.4913,398.9092,0,0,0,0,100,0),
+(@PATH,9,-4809.745,-978.5764,399.0128,0,0,0,0,100,0),
+(@PATH,10,-4809.847,-972.7587,399.0157,0,0,0,0,100,0),
+(@PATH,11,-4809.691,-966.7743,398.9712,0,0,0,0,100,0),
+(@PATH,12,-4813.496,-955.5854,399.0424,0,0,0,0,100,0),
+(@PATH,13,-4819.182,-940.9827,399.0594,0,0,0,0,100,0),
+(@PATH,14,-4822.122,-932.5625,399.0425,0,0,0,0,100,0),
+(@PATH,15,-4809.2,-966.434,398.9767,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307478;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4746.498,`position_y`=-986.7278,`position_z`=501.5681 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,257,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,-4746.498,-986.7278,501.5681,0,0,0,0,100,0),
+(@PATH,2,-4727.496,-986.3409,501.4679,0,0,0,0,100,0),
+(@PATH,3,-4709.644,-986.935,501.6479,0,0,0,0,100,0),
+(@PATH,4,-4696.713,-982.79,501.7064,0,0,0,0,100,0),
+(@PATH,5,-4686.291,-974.548,501.6554,0,25000,0,0,100,0),
+(@PATH,6,-4701.526,-986.745,501.6779,0,0,0,0,100,0),
+(@PATH,7,-4718.943,-986.9548,501.5069,0,0,0,0,100,0),
+(@PATH,8,-4743.44,-985.0746,501.4614,0,0,0,0,100,0),
+(@PATH,9,-4759.754,-995.0007,501.6978,0,0,0,0,100,0),
+(@PATH,10,-4765.604,-1007.7,501.6978,0,0,0,0,100,0),
+(@PATH,11,-4771.829,-1021.206,502.2123,0,20000,0,0,100,0),
+(@PATH,12,-4767.071,-1009.134,501.6978,0,0,0,0,100,0),
+(@PATH,13,-4759.091,-994.4371,501.6978,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307946;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5017.297,`position_y`=-1096.132,`position_z`=501.6788 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,257,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,-5017.297,-1096.132,501.6788,0,0,0,0,100,0),
+(@PATH,2,-5014.159,-1111.454,501.6727,0,0,0,0,100,0),
+(@PATH,3,-5004.407,-1115.416,501.6724,0,0,0,0,100,0),
+(@PATH,4,-4997.035,-1111.26,501.6414,0,0,0,0,100,0),
+(@PATH,5,-4994.561,-1083.678,498.8403,0,0,0,0,100,0),
+(@PATH,6,-4991.824,-1055.735,497.9205,0,0,0,0,100,0),
+(@PATH,7,-4986.59,-1034.179,501.653,0,0,0,0,100,0),
+(@PATH,8,-4972.985,-994.6423,501.6577,0,0,0,0,100,0),
+(@PATH,9,-4954.183,-966.5741,501.6661,0,0,0,0,100,0),
+(@PATH,10,-4930.894,-943.2073,501.6295,0,0,0,0,100,0),
+(@PATH,11,-4896.667,-918.9849,501.6324,0,0,0,0,100,0),
+(@PATH,12,-4859.071,-906.0353,501.6595,0,0,0,0,100,0),
+(@PATH,13,-4827.863,-903.4857,501.6594,0,0,0,0,100,0),
+(@PATH,14,-4805.999,-905.0009,497.9541,0,0,0,0,100,0),
+(@PATH,15,-4778.714,-906.3766,500.0283,0,0,0,0,100,0),
+(@PATH,16,-4766.738,-906.0627,501.6291,0,0,0,0,100,0),
+(@PATH,17,-4753.256,-910.0827,501.6595,0,0,0,0,100,0),
+(@PATH,18,-4747.038,-905.0212,501.6595,0,0,0,0,100,0),
+(@PATH,19,-4748.268,-895.6587,501.6595,0,0,0,0,100,0),
+(@PATH,20,-4773.682,-886.5223,501.6593,0,0,0,0,100,0),
+(@PATH,21,-4799.893,-879.7461,501.67,0,0,0,0,100,0),
+(@PATH,22,-4830.926,-880.5823,501.6594,0,0,0,0,100,0),
+(@PATH,23,-4859.255,-884.3049,501.6594,0,0,0,0,100,0),
+(@PATH,24,-4900.4,-897.6807,501.6594,0,0,0,0,100,0),
+(@PATH,25,-4928.519,-913.5782,501.6594,0,0,0,0,100,0),
+(@PATH,26,-4964.312,-943.6036,501.6594,0,0,0,0,100,0),
+(@PATH,27,-4982.343,-966.8148,501.6595,0,0,0,0,100,0),
+(@PATH,28,-5006.113,-1016.344,501.6579,0,0,0,0,100,0),
+(@PATH,29,-5010.339,-1035.028,501.6559,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307474;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4703.024,`position_y`=-913.8218,`position_z`=501.6594 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,257,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,-4703.024,-913.8218,501.6594,0,0,0,0,100,0),
+(@PATH,2,-4707.872,-930.5532,501.6659,0,0,0,0,100,0),
+(@PATH,3,-4697.937,-943.9158,501.6697,0,0,0,0,100,0),
+(@PATH,4,-4687.489,-966.483,501.6523,0,0,0,0,100,0),
+(@PATH,5,-4672.077,-983.1148,501.6571,0,0,0,0,100,0),
+(@PATH,6,-4654.317,-995.6335,501.6435,0,0,0,0,100,0),
+(@PATH,7,-4635.397,-998.0302,501.6594,0,0,0,0,100,0),
+(@PATH,8,-4621.842,-979.9805,501.6577,0,0,0,0,100,0),
+(@PATH,9,-4632.92,-958.1653,501.6586,0,0,0,0,100,0),
+(@PATH,10,-4645.341,-941.041,501.6579,0,0,0,0,100,0),
+(@PATH,11,-4660.012,-925.5549,501.6577,0,0,0,0,100,0),
+(@PATH,12,-4687.626,-903.888,501.6609,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307595;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4667.163,`position_y`=-1192.648,`position_z`=501.6577 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,257,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,-4667.163,-1192.648,501.6577,0,0,0,0,100,0),
+(@PATH,2,-4679.893,-1193.849,501.6591,0,0,0,0,100,0),
+(@PATH,3,-4695.925,-1199.87,501.6592,0,0,0,0,100,0),
+(@PATH,4,-4712.359,-1205.442,501.6594,0,0,0,0,100,0),
+(@PATH,5,-4720.557,-1213.526,501.6594,0,0,0,0,100,0),
+(@PATH,6,-4733.086,-1230.501,501.656,0,0,0,0,100,0),
+(@PATH,7,-4738.724,-1248.325,501.6595,0,0,0,0,100,0),
+(@PATH,8,-4732.381,-1261.152,501.6594,0,0,0,0,100,0),
+(@PATH,9,-4721.185,-1265.525,501.6595,0,0,0,0,100,0),
+(@PATH,10,-4708.459,-1253.656,501.6595,0,0,0,0,100,0),
+(@PATH,11,-4698.779,-1235.551,501.6595,0,0,0,0,100,0),
+(@PATH,12,-4685.847,-1223.876,501.6594,0,0,0,0,100,0),
+(@PATH,13,-4669.44,-1218.946,501.6594,0,0,0,0,100,0),
+(@PATH,14,-4655.979,-1205.697,501.6581,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307513;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4839.658,`position_y`=-997.7726,`position_z`=446.5723 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,257,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,-4839.658,-997.7726,446.5723,0,0,0,0,100,0),
+(@PATH,2,-4845.686,-990.304,445.5293,0,0,0,0,100,0),
+(@PATH,3,-4847.957,-985.1996,444.7513,0,0,0,0,100,0),
+(@PATH,4,-4844.427,-980.1545,443.324,0,0,0,0,100,0),
+(@PATH,5,-4837.764,-981.1893,442.9455,0,0,0,0,100,0),
+(@PATH,6,-4831.863,-987.7621,442.3008,0,0,0,0,100,0),
+(@PATH,7,-4826.55,-993.8663,441.9338,0,0,0,0,100,0),
+(@PATH,8,-4831.863,-987.7621,442.3008,0,0,0,0,100,0),
+(@PATH,9,-4837.764,-981.1893,442.9455,0,0,0,0,100,0),
+(@PATH,10,-4844.427,-980.1545,443.324,0,0,0,0,100,0),
+(@PATH,11,-4847.957,-985.1996,444.7513,0,0,0,0,100,0),
+(@PATH,12,-4845.721,-990.2604,445.5447,0,0,0,0,100,0),
+(@PATH,13,-4839.658,-997.7726,446.5723,0,0,0,0,100,0),
+(@PATH,14,-4837.418,-1006.346,446.1633,0,0,0,0,100,0),
+(@PATH,15,-4834.143,-1013.528,446.8293,0,0,0,0,100,0),
+(@PATH,16,-4834.37,-1020.259,447.4241,0,0,0,0,100,0),
+(@PATH,17,-4834.094,-1013.635,446.8517,0,0,0,0,100,0),
+(@PATH,18,-4837.254,-1006.754,446.0832,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307459;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4826.372,`position_y`=-998.5434,`position_z`=406.8829 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,257,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,-4826.372,-998.5434,406.8829,0,0,0,0,100,0),
+(@PATH,2,-4834.088,-1004.547,411.4482,0,0,0,0,100,0),
+(@PATH,3,-4842.106,-1006.429,413.2979,0,0,0,0,100,0),
+(@PATH,4,-4847.382,-1005.137,414.9077,0,0,0,0,100,0),
+(@PATH,5,-4851.651,-997.9271,418.4489,0,0,0,0,100,0),
+(@PATH,6,-4853.25,-992.7222,420.2177,0,0,0,0,100,0),
+(@PATH,7,-4853.989,-986.4845,421.5829,0,0,0,0,100,0),
+(@PATH,8,-4853.272,-980.9688,422.5124,0,0,0,0,100,0),
+(@PATH,9,-4846.594,-975.9879,423.6776,0,0,0,0,100,0),
+(@PATH,10,-4837.863,-967.5712,425.9264,0,0,0,0,100,0),
+(@PATH,11,-4827.484,-959.3646,428.8574,0,0,0,0,100,0),
+(@PATH,12,-4816.047,-958.0695,430.4024,0,0,0,0,100,0),
+(@PATH,13,-4807.725,-968.0563,429.8795,0,0,0,0,100,0),
+(@PATH,14,-4802.672,-976.7952,433.7307,0,0,0,0,100,0),
+(@PATH,15,-4805.495,-984.7847,437.952,0,0,0,0,100,0),
+(@PATH,16,-4816.187,-992.1509,440.1398,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307653;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4941.089,`position_y`=-1251.62,`position_z`=501.6635 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,257,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,-4941.089,-1251.62,501.6635,0,0,0,0,100,0),
+(@PATH,2,-4927.949,-1242.192,501.6606,0,0,0,0,100,0),
+(@PATH,3,-4928.527,-1229.495,501.649,0,0,0,0,100,0),
+(@PATH,4,-4943.524,-1216.123,501.6521,0,0,0,0,100,0),
+(@PATH,5,-4952.011,-1195.801,501.6595,0,0,0,0,100,0),
+(@PATH,6,-4965.607,-1189.141,501.66,0,0,0,0,100,0),
+(@PATH,7,-4981.276,-1171.385,501.6538,0,0,0,0,100,0),
+(@PATH,8,-4992.6,-1155.349,501.6567,0,0,0,0,100,0),
+(@PATH,9,-5007.487,-1171.793,501.6597,0,0,0,0,100,0),
+(@PATH,10,-5008.707,-1185.934,501.658,0,0,0,0,100,0),
+(@PATH,11,-4998.198,-1206.62,501.6738,0,0,0,0,100,0),
+(@PATH,12,-4984.833,-1224.77,501.6791,0,0,0,0,100,0),
+(@PATH,13,-4963.304,-1244.974,501.6721,0,0,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307673;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4894.075,`position_y`=-1115.882,`position_z`=501.7928 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,257,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,-4894.075,-1115.882,501.7928,0,0,0,0,100,0),
+(@PATH,2,-4906.619,-1118.982,501.6978,0,0,0,0,100,0),
+(@PATH,3,-4917.98,-1125.181,501.6978,0,0,0,0,100,0),
+(@PATH,4,-4921.549,-1132.518,501.5946,0,0,0,0,100,0),
+(@PATH,5,-4923.342,-1144.431,501.4448,0,0,0,0,100,0),
+(@PATH,6,-4928.308,-1159.001,501.5356,0,0,0,0,100,0),
+(@PATH,7,-4932.61,-1173.346,501.6599,0,0,0,0,100,0),
+(@PATH,8,-4938.115,-1183.525,501.6974,0,0,0,0,100,0),
+(@PATH,9,-4948.813,-1191.509,501.6596,0,30000,0,0,100,0),
+(@PATH,10,-4938.763,-1183.054,501.7006,0,0,0,0,100,0),
+(@PATH,11,-4932.521,-1170.771,501.6389,0,0,0,0,100,0),
+(@PATH,12,-4928.323,-1153.058,501.4995,0,0,0,0,100,0),
+(@PATH,13,-4925.346,-1140.755,501.4374,0,0,0,0,100,0),
+(@PATH,14,-4922.706,-1131.441,501.6088,0,0,0,0,100,0),
+(@PATH,15,-4913.503,-1121.099,501.6978,0,0,0,0,100,0),
+(@PATH,16,-4900.859,-1117.31,501.6978,0,0,0,0,100,0),
+(@PATH,17,-4883.246,-1115.64,502.2066,0,30000,0,0,100,0);
+
+-- Pathing for Ironforge Guard Entry: 5595
+SET @NPC := 307494;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4807.448,`position_y`=-1107.699,`position_z`=498.8071 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,257,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,-4807.448,-1107.699,498.8071,0,0,0,0,100,0),
+(@PATH,2,-4808.916,-1101.871,498.8071,0,0,0,0,100,0),
+(@PATH,3,-4822.939,-1086.675,502.2037,0,0,0,0,100,0),
+(@PATH,4,-4833.822,-1085.089,502.192,0,0,0,0,100,0),
+(@PATH,5,-4856.7,-1084.208,502.191,0,0,0,0,100,0),
+(@PATH,6,-4866.897,-1084.164,502.2032,0,0,0,0,100,0),
+(@PATH,7,-4874.189,-1090.363,502.2141,0,0,0,0,100,0),
+(@PATH,8,-4873.168,-1107.078,502.2109,0,0,0,0,100,0),
+(@PATH,9,-4866.706,-1125.399,502.1993,0,0,0,0,100,0),
+(@PATH,10,-4855.071,-1143.802,502.1941,0,0,0,0,100,0),
+(@PATH,11,-4836.417,-1159.578,502.1925,0,0,0,0,100,0),
+(@PATH,12,-4814.893,-1167.751,502.2058,0,0,0,0,100,0),
+(@PATH,13,-4790.182,-1167.795,502.2094,0,0,0,0,100,0),
+(@PATH,14,-4765.064,-1160.057,502.2098,0,0,0,0,100,0),
+(@PATH,15,-4763.539,-1152.728,502.2124,0,0,0,0,100,0),
+(@PATH,16,-4778.483,-1131.886,498.8021,0,0,0,0,100,0),
+(@PATH,17,-4795.002,-1115.885,498.8072,0,0,0,0,100,0),
+(@PATH,18,-4804.095,-1112.749,498.8071,0,0,0,0,100,0);
+
+-- Pathing for Roetten Stonehammer Entry: 5637
+SET @NPC := 307747;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4681.147,`position_y`=-1244.796,`position_z`=501.9927 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,257,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,-4681.147,-1244.796,501.9927,0,0,0,0,100,0),
+(@PATH,2,-4686.531,-1252.014,501.9927,0,0,0,0,100,0),
+(@PATH,3,-4685.416,-1262.677,501.9927,0,0,0,0,100,0),
+(@PATH,4,-4681.394,-1266.606,503.3816,0,0,0,0,100,0),
+(@PATH,5,-4681.394,-1266.606,503.3816,1.605703,60000,0,0,100,0),
+(@PATH,6,-4686.149,-1255.14,501.9927,0,0,0,0,100,0),
+(@PATH,7,-4675.921,-1244.38,501.9927,0,0,0,0,100,0),
+(@PATH,8,-4667.503,-1245.781,501.9927,0,0,0,0,100,0),
+(@PATH,9,-4661.595,-1250.517,503.3816,0,0,0,0,100,0),
+(@PATH,10,-4661.595,-1250.517,503.3816,2.356194,60000,0,0,100,0),
+(@PATH,11,-4670.109,-1243.077,501.9927,0,0,0,0,100,0);
+
+-- Pathing for Bimble Longberry Entry: 7978
+SET @NPC := 307714;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4707.845,`position_y`=-907.012,`position_z`=501.6605 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,257,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,-4707.845,-907.012,501.6605,0,0,0,0,100,0),
+(@PATH,2,-4688.098,-902.9882,501.6618,0,0,0,0,100,0),
+(@PATH,3,-4671.588,-914.5618,501.6519,0,0,0,0,100,0),
+(@PATH,4,-4655.948,-931.1495,501.6581,0,0,0,0,100,0),
+(@PATH,5,-4636.642,-954.9941,501.6592,0,0,0,0,100,0),
+(@PATH,6,-4621.53,-981.5043,501.6579,0,0,0,0,100,0),
+(@PATH,7,-4617.623,-1000.404,501.6588,0,0,0,0,100,0),
+(@PATH,8,-4626.838,-1012.12,501.6545,0,0,0,0,100,0),
+(@PATH,9,-4641.676,-1014.932,501.6477,0,0,0,0,100,0),
+(@PATH,10,-4657.655,-997.7007,501.6383,0,0,0,0,100,0),
+(@PATH,11,-4667.463,-983.3502,501.658,0,0,0,0,100,0),
+(@PATH,12,-4681.746,-969.3637,501.6649,0,0,0,0,100,0),
+(@PATH,13,-4689.473,-949.484,501.6679,0,0,0,0,100,0),
+(@PATH,14,-4699.37,-937.9786,501.6726,0,0,0,0,100,0),
+(@PATH,15,-4711.072,-923.4749,501.6632,0,0,0,0,100,0);
+
+-- Pathing for Curator Thorius Entry: 8256
+SET @NPC := 307745;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4702.81,`position_y`=-1325.272,`position_z`=503.3816 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,257,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,-4702.81,-1325.272,503.3816,0,0,0,0,100,0),
+(@PATH,2,-4696.066,-1325.834,503.3816,0,0,0,0,100,0),
+(@PATH,3,-4689.635,-1325.204,503.3816,0,0,0,0,100,0),
+(@PATH,4,-4686.072,-1319.199,503.3816,0,0,0,0,100,0),
+(@PATH,5,-4683.053,-1314.015,503.3815,0,0,0,0,100,0),
+(@PATH,6,-4675,-1312.604,503.3809,0,0,0,0,100,0),
+(@PATH,7,-4664.885,-1306.134,503.3816,0,0,0,0,100,0),
+(@PATH,8,-4662.038,-1298.117,503.3816,0,0,0,0,100,0),
+(@PATH,9,-4659.361,-1288.6,503.3815,0,0,0,0,100,0),
+(@PATH,10,-4654.313,-1281.536,503.3816,0,60000,0,0,100,0),
+(@PATH,11,-4646.738,-1273.377,503.3816,0,0,0,0,100,0),
+(@PATH,12,-4643.056,-1269.847,503.3816,0,0,0,0,100,0),
+(@PATH,13,-4638.852,-1265.486,503.3816,0,0,0,0,100,0),
+(@PATH,14,-4633.741,-1261.104,503.3805,0,0,0,0,100,0),
+(@PATH,15,-4629.312,-1256.385,503.3805,0,0,0,0,100,0),
+(@PATH,16,-4626.09,-1255.278,503.3807,0,0,0,0,100,0),
+(@PATH,17,-4623.375,-1256.475,503.3811,0,0,0,0,100,0),
+(@PATH,18,-4622.471,-1258.746,503.3813,0,0,0,0,100,0),
+(@PATH,19,-4622.471,-1258.746,503.3813,4.066617,5000,0,0,100,0),
+(@PATH,20,-4615.686,-1255.442,503.3816,0,0,0,0,100,0),
+(@PATH,21,-4608.177,-1249.271,503.3816,0,0,0,0,100,0),
+(@PATH,22,-4603.862,-1251.563,503.3816,0,0,0,0,100,0),
+(@PATH,23,-4603.862,-1251.563,503.3816,0.3316126,5000,0,0,100,0),
+(@PATH,24,-4598.436,-1240.892,503.3816,0,0,0,0,100,0),
+(@PATH,25,-4592.519,-1232.317,503.3816,0,0,0,0,100,0),
+(@PATH,26,-4588.735,-1222.179,503.3815,0,0,0,0,100,0),
+(@PATH,27,-4588.735,-1222.179,503.3815,5.742133,5000,0,0,100,0),
+(@PATH,28,-4593.644,-1214.16,503.3815,0,0,0,0,100,0),
+(@PATH,29,-4598.711,-1219.354,503.3815,0,0,0,0,100,0),
+(@PATH,30,-4604.79,-1227.24,503.3816,0,0,0,0,100,0),
+(@PATH,31,-4610.729,-1236.657,503.3816,0,0,0,0,100,0),
+(@PATH,32,-4613.158,-1252.017,503.3816,0,0,0,0,100,0),
+(@PATH,33,-4618.215,-1264.094,503.3822,0,0,0,0,100,0),
+(@PATH,34,-4633.393,-1276.797,503.3816,0,0,0,0,100,0),
+(@PATH,35,-4652.419,-1285.877,503.3816,0,0,0,0,100,0),
+(@PATH,36,-4667.36,-1293.999,503.3815,0,0,0,0,100,0),
+(@PATH,37,-4678.205,-1296.404,503.3816,0,0,0,0,100,0),
+(@PATH,38,-4689.225,-1301.691,503.3815,0,0,0,0,100,0),
+(@PATH,39,-4699.487,-1307.61,503.3816,0,0,0,0,100,0),
+(@PATH,40,-4709.615,-1317.365,503.3816,0,0,0,0,100,0);
+
+-- Pathing for Sraaz Entry: 9099
+SET @NPC := 307583;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4836.729,`position_y`=-1156.898,`position_z`=502.1668 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,257,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,-4836.729,-1156.898,502.1668,0,0,0,0,100,0),
+(@PATH,2,-4854.076,-1143.53,502.1888,0,0,0,0,100,0),
+(@PATH,3,-4867.312,-1122.644,502.201,0,0,0,0,100,0),
+(@PATH,4,-4873.944,-1090.731,502.214,0,0,0,0,100,0),
+(@PATH,5,-4868.064,-1085.277,502.205,0,0,0,0,100,0),
+(@PATH,6,-4829.619,-1085.275,502.1962,0,0,0,0,100,0),
+(@PATH,7,-4812.885,-1065.878,502.1967,0,0,0,0,100,0),
+(@PATH,8,-4810.18,-1032.05,502.2026,0,0,0,0,100,0),
+(@PATH,9,-4797.529,-1025.646,502.2057,0,0,0,0,100,0),
+(@PATH,10,-4764.07,-1041.113,502.2114,0,0,0,0,100,0),
+(@PATH,11,-4737.233,-1073.919,502.1932,0,0,0,0,100,0),
+(@PATH,12,-4732.991,-1106.314,502.2159,0,0,0,0,100,0),
+(@PATH,13,-4741.397,-1139.081,502.1905,0,0,0,0,100,0),
+(@PATH,14,-4756.994,-1154.734,502.2124,0,0,0,0,100,0),
+(@PATH,15,-4774.401,-1165.634,502.1953,0,0,0,0,100,0),
+(@PATH,16,-4790.139,-1168.66,502.2086,0,0,0,0,100,0),
+(@PATH,17,-4815.048,-1167.4,502.2061,0,0,0,0,100,0);
+
+-- Pathing for Courier Hammerfall Entry: 10877
+SET @NPC := 307503;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4741.54,`position_y`=-982.8923,`position_z`=501.4272 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,-4741.54,-982.8923,501.4272,0,0,0,0,100,0),
+(@PATH,2,-4721.269,-982.9841,501.5123,0,0,0,0,100,0),
+(@PATH,3,-4699.589,-980.7731,501.7036,0,0,0,0,100,0),
+(@PATH,4,-4691.07,-971.5341,501.6118,0,0,0,0,100,0),
+(@PATH,5,-4685.888,-958.0817,501.6594,0,0,0,0,100,0),
+(@PATH,6,-4684.749,-941.1815,501.6613,0,0,0,0,100,0),
+(@PATH,7,-4698.139,-928.971,501.6681,0,0,0,0,100,0),
+(@PATH,8,-4718.819,-915.6346,501.6589,0,0,0,0,100,0),
+(@PATH,9,-4741.744,-897.5691,501.6595,0,0,0,0,100,0),
+(@PATH,10,-4761.023,-888.8571,501.6594,0,0,0,0,100,0),
+(@PATH,11,-4788.193,-883.1321,501.6594,0,0,0,0,100,0),
+(@PATH,12,-4808.107,-881.9349,501.6664,0,0,0,0,100,0),
+(@PATH,13,-4825.98,-882.9207,501.6594,0,0,0,0,100,0),
+(@PATH,14,-4849.643,-885.566,501.6594,0,0,0,0,100,0),
+(@PATH,15,-4864.499,-888.3546,501.6594,0,0,0,0,100,0),
+(@PATH,16,-4880.607,-892.3723,501.6594,0,0,0,0,100,0),
+(@PATH,17,-4900.112,-898.7839,501.6594,0,0,0,0,100,0),
+(@PATH,18,-4891.083,-924.0314,501.5615,0,0,0,0,100,0),
+(@PATH,19,-4897.992,-941.2864,501.4694,0,0,0,0,100,0),
+(@PATH,20,-4913.26,-956.5576,501.5141,0,0,0,0,100,0),
+(@PATH,21,-4928.577,-969.6737,501.4976,0,0,0,0,100,0),
+(@PATH,22,-4953.305,-986.0883,501.582,0,0,0,0,100,0),
+(@PATH,23,-4972.186,-998.5833,501.6567,0,0,0,0,100,0),
+(@PATH,24,-4983.468,-1018.774,501.6529,0,0,0,0,100,0),
+(@PATH,25,-4989.578,-1039.417,501.6567,0,0,0,0,100,0),
+(@PATH,26,-4992.354,-1055.787,497.9273,0,0,0,0,100,0),
+(@PATH,27,-4993.711,-1079.769,497.9636,0,0,0,0,100,0),
+(@PATH,28,-4995.998,-1099.485,501.6707,0,0,0,0,100,0),
+(@PATH,29,-4998.46,-1118.148,501.6261,0,0,0,0,100,0),
+(@PATH,30,-4999.842,-1138.114,501.6595,0,0,0,0,100,0),
+(@PATH,31,-4997.895,-1167.707,501.6596,0,0,0,0,100,0),
+(@PATH,32,-4992.477,-1192.574,501.663,0,0,0,0,100,0),
+(@PATH,33,-4983.901,-1219.534,501.6754,0,0,0,0,100,0),
+(@PATH,34,-4962.542,-1240.518,501.6719,0,0,0,0,100,0),
+(@PATH,35,-4943.077,-1240.707,501.661,0,0,0,0,100,0),
+(@PATH,36,-4923.675,-1242.276,501.6599,0,0,0,0,100,0),
+(@PATH,37,-4903.556,-1250.913,501.868,0,0,0,0,100,0),
+(@PATH,38,-4888.17,-1257.831,501.868,0,0,0,0,100,0),
+(@PATH,39,-4859.845,-1267.34,501.868,0,0,0,0,100,0),
+(@PATH,40,-4842.627,-1270.102,501.868,0,0,0,0,100,0),
+(@PATH,41,-4826.807,-1272.91,501.868,0,0,0,0,100,0),
+(@PATH,42,-4803.76,-1276.408,501.868,0,0,0,0,100,0),
+(@PATH,43,-4791.794,-1277.296,501.868,0,0,0,0,100,0),
+(@PATH,44,-4772.483,-1276.05,501.868,0,0,0,0,100,0),
+(@PATH,45,-4737.104,-1267.686,501.6595,0,0,0,0,100,0),
+(@PATH,46,-4720.914,-1262.369,501.6595,0,0,0,0,100,0),
+(@PATH,47,-4709.342,-1250.809,501.6594,0,0,0,0,100,0),
+(@PATH,48,-4692.119,-1230.823,501.6594,0,0,0,0,100,0),
+(@PATH,49,-4673.995,-1216.168,501.6565,0,0,0,0,100,0),
+(@PATH,50,-4654.725,-1198.158,501.6566,0,0,0,0,100,0),
+(@PATH,51,-4635.058,-1165.77,500.9265,0,0,0,0,100,0),
+(@PATH,52,-4626.007,-1145.362,501.3273,0,0,0,0,100,0),
+(@PATH,53,-4624.884,-1124.012,501.3274,0,0,0,0,100,0),
+(@PATH,54,-4626.816,-1084.38,501.1842,0,0,0,0,100,0),
+(@PATH,55,-4628.158,-1049.815,500.8539,0,0,0,0,100,0),
+(@PATH,56,-4635.014,-1021.107,501.6432,0,0,0,0,100,0),
+(@PATH,57,-4642.997,-1002.939,501.6512,0,0,0,0,100,0),
+(@PATH,58,-4653.922,-990.487,501.647,0,0,0,0,100,0),
+(@PATH,59,-4666.999,-980.1961,501.6566,0,0,0,0,100,0),
+(@PATH,60,-4683.523,-973.1091,501.6252,0,0,0,0,100,0),
+(@PATH,61,-4697.313,-983.9152,501.7007,0,0,0,0,100,0),
+(@PATH,62,-4707.98,-985.7939,501.66,0,0,0,0,100,0),
+(@PATH,63,-4719.224,-986.1957,501.508,0,0,0,0,100,0),
+(@PATH,64,-4739.734,-986.053,501.4248,0,0,0,0,100,0),
+(@PATH,65,-4753.699,-994.2927,501.6978,0,0,0,0,100,0),
+(@PATH,66,-4769.607,-1012.358,501.7933,0,0,0,0,100,0),
+(@PATH,67,-4774.94,-1023.246,502.2104,0,0,0,0,100,0),
+(@PATH,68,-4786.156,-1029.954,502.2102,0,0,0,0,100,0),
+(@PATH,69,-4803.588,-1030.377,502.2076,0,0,0,0,100,0),
+(@PATH,70,-4808.936,-1040.633,502.2016,0,0,0,0,100,0),
+(@PATH,71,-4811.057,-1055.461,502.1986,0,0,0,0,100,0),
+(@PATH,72,-4813.264,-1069.014,502.1987,0,0,0,0,100,0),
+(@PATH,73,-4819.234,-1078.317,502.2005,0,0,0,0,100,0),
+(@PATH,74,-4833.979,-1085.935,502.1926,0,0,0,0,100,0),
+(@PATH,75,-4854.328,-1087.02,502.1945,0,0,0,0,100,0),
+(@PATH,76,-4871.877,-1085.636,502.2098,0,0,0,0,100,0),
+(@PATH,77,-4877.277,-1100.42,502.2152,0,0,0,0,100,0),
+(@PATH,78,-4876.213,-1114.922,502.2065,0,0,0,0,100,0),
+(@PATH,79,-4868.428,-1125.957,502.1992,0,0,0,0,100,0),
+(@PATH,80,-4855.959,-1140.152,502.1878,0,0,0,0,100,0),
+(@PATH,81,-4842.979,-1153.668,502.2022,0,0,0,0,100,0),
+(@PATH,82,-4834.478,-1159.935,502.2047,0,0,0,0,100,0),
+(@PATH,83,-4821.786,-1165.978,502.2044,0,0,0,0,100,0),
+(@PATH,84,-4801.959,-1169.534,502.2066,0,0,0,0,100,0),
+(@PATH,85,-4788.642,-1168.569,502.2072,0,0,0,0,100,0),
+(@PATH,86,-4774.875,-1163.962,502.1971,0,0,0,0,100,0),
+(@PATH,87,-4762.897,-1156.676,502.2124,0,0,0,0,100,0),
+(@PATH,88,-4744.838,-1140.254,502.1979,0,0,0,0,100,0),
+(@PATH,89,-4734.269,-1117.11,502.2155,0,0,0,0,100,0),
+(@PATH,90,-4732.794,-1098.118,502.2102,0,0,0,0,100,0),
+(@PATH,91,-4736.686,-1074.541,502.2046,0,0,0,0,100,0),
+(@PATH,92,-4750.417,-1053.168,502.2119,0,0,0,0,100,0),
+(@PATH,93,-4766.11,-1040.711,502.2115,0,0,0,0,100,0),
+(@PATH,94,-4773.514,-1025.076,502.2114,0,0,0,0,100,0),
+(@PATH,95,-4765.043,-1008.141,501.6978,0,0,0,0,100,0),
+(@PATH,96,-4757.175,-990.6771,501.6978,0,0,0,0,100,0);
+
+-- Pathing for Thief Catcher Shadowdelve Entry: 14363
+SET @NPC := 307713;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4886.973,`position_y`=-891.7634,`position_z`=501.6594 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,257,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,-4886.973,-891.7634,501.6594,0,0,0,0,100,0),
+(@PATH,2,-4906.807,-884.8439,501.6597,0,0,0,0,100,0),
+(@PATH,3,-4929.052,-856.4695,501.6613,0,0,0,0,100,0),
+(@PATH,4,-4952.721,-869.076,501.6388,0,0,0,0,100,0),
+(@PATH,5,-4988.777,-898.9862,501.6478,0,0,0,0,100,0),
+(@PATH,6,-5017.839,-932.5099,501.6595,0,0,0,0,100,0),
+(@PATH,7,-4985.217,-957.6404,501.6595,0,0,0,0,100,0),
+(@PATH,8,-4958.795,-941.6141,501.6594,0,0,0,0,100,0),
+(@PATH,9,-4947.842,-930.124,501.6594,0,0,0,0,100,0),
+(@PATH,10,-4950.354,-921.7192,504.2635,0,0,0,0,100,0),
+(@PATH,11,-4961.114,-913.8481,503.8371,0,0,0,0,100,0),
+(@PATH,12,-4956.323,-904.1819,503.8388,0,0,0,0,100,0),
+(@PATH,13,-4960.761,-914.1066,503.8729,0,0,0,0,100,0),
+(@PATH,14,-4956.323,-904.1819,503.8388,0,0,0,0,100,0),
+(@PATH,15,-4950.286,-908.22,503.8387,0,0,0,0,100,0),
+(@PATH,16,-4950.209,-918.2828,504.2622,0,0,0,0,100,0),
+(@PATH,17,-4942.204,-927.994,501.6594,0,0,0,0,100,0),
+(@PATH,18,-4935.647,-936.2831,503.0424,0,0,0,0,100,0),
+(@PATH,19,-4931.629,-949.3468,501.6088,0,0,0,0,100,0),
+(@PATH,20,-4915.165,-957.8141,501.5093,0,0,0,0,100,0),
+(@PATH,21,-4906.877,-973.0106,501.4471,0,0,0,0,100,0),
+(@PATH,22,-4898.353,-983.7513,503.9404,0,0,0,0,100,0),
+(@PATH,23,-4891.35,-992.1207,503.9404,0,0,0,0,100,0),
+(@PATH,24,-4885.096,-986.4387,503.9404,0,0,0,0,100,0),
+(@PATH,25,-4888.364,-983.6744,503.9405,0,0,0,0,100,0),
+(@PATH,26,-4895.435,-985.1922,503.9404,0,0,0,0,100,0),
+(@PATH,27,-4904.652,-975.4191,501.4371,0,0,0,0,100,0),
+(@PATH,28,-4908.016,-960.3723,501.498,0,0,0,0,100,0),
+(@PATH,29,-4880.324,-920.6398,501.5612,0,0,0,0,100,0),
+(@PATH,30,-4833.688,-904.1839,501.6595,0,0,0,0,100,0),
+(@PATH,31,-4797.364,-906.421,497.9235,0,0,0,0,100,0),
+(@PATH,32,-4780.092,-905.9431,499.2294,0,0,0,0,100,0),
+(@PATH,33,-4763.683,-907.0504,501.6269,0,0,0,0,100,0),
+(@PATH,34,-4721.881,-922.5632,501.6595,0,0,0,0,100,0),
+(@PATH,35,-4691.694,-946.5085,501.6678,0,0,0,0,100,0),
+(@PATH,36,-4679.948,-969.9567,501.6698,0,0,0,0,100,0),
+(@PATH,37,-4650.121,-982.7744,501.66,0,0,0,0,100,0),
+(@PATH,38,-4635.554,-960.3665,501.6609,0,0,0,0,100,0),
+(@PATH,39,-4651.672,-935.2123,501.6588,0,0,0,0,100,0),
+(@PATH,40,-4687.276,-922.145,501.6616,0,0,0,0,100,0),
+(@PATH,41,-4721.487,-905.8834,501.6594,0,0,0,0,100,0),
+(@PATH,42,-4757.437,-890.9809,501.6594,0,0,0,0,100,0),
+(@PATH,43,-4785.496,-884.3284,501.6594,0,0,0,0,100,0),
+(@PATH,44,-4815.042,-883.2499,501.6631,0,0,0,0,100,0),
+(@PATH,45,-4846.717,-886.1057,501.6594,0,0,0,0,100,0);
+
+-- Pathing for Thief Catcher Farmountain Entry: 14365
+SET @NPC := 307690;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5007.002,`position_y`=-1116.343,`position_z`=501.6801 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,257,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,-5007.002,-1116.343,501.6801,0,0,0,0,100,0),
+(@PATH,2,-5003.024,-1142.076,501.6595,0,0,0,0,100,0),
+(@PATH,3,-4998.46,-1179.694,501.6592,0,0,0,0,100,0),
+(@PATH,4,-4982.609,-1226.394,501.6786,0,0,0,0,100,0),
+(@PATH,5,-4944.211,-1255.974,501.6631,0,0,0,0,100,0),
+(@PATH,6,-4925.567,-1250.108,501.661,0,0,0,0,100,0),
+(@PATH,7,-4923.098,-1236.333,501.6555,0,0,0,0,100,0),
+(@PATH,8,-4945.754,-1214.15,501.6616,0,0,0,0,100,0),
+(@PATH,9,-4969.667,-1187.341,501.6602,0,0,0,0,100,0),
+(@PATH,10,-4991.06,-1151.823,501.6544,0,0,0,0,100,0),
+(@PATH,11,-4997.53,-1115.96,501.6225,0,0,0,0,100,0),
+(@PATH,12,-4994.735,-1091.497,501.6595,0,0,0,0,100,0),
+(@PATH,13,-4992.421,-1058.819,497.9393,0,0,0,0,100,0),
+(@PATH,14,-4989.006,-1039.414,501.6562,0,0,0,0,100,0),
+(@PATH,15,-4983.643,-1019.235,501.6528,0,0,0,0,100,0),
+(@PATH,16,-4962.486,-981.2289,501.6595,0,0,0,0,100,0),
+(@PATH,17,-4929.968,-957.3575,501.5669,0,0,0,0,100,0),
+(@PATH,18,-4915.203,-960.3139,501.4992,0,0,0,0,100,0),
+(@PATH,19,-4904.061,-976.8671,501.4312,0,0,0,0,100,0),
+(@PATH,20,-4896.077,-987.4464,503.9404,0,0,0,0,100,0),
+(@PATH,21,-4896.048,-992.9202,503.9404,0,0,0,0,100,0),
+(@PATH,22,-4889.553,-993.4305,503.9404,0,0,0,0,100,0),
+(@PATH,23,-4884.642,-985.4946,503.9404,0,0,0,0,100,0),
+(@PATH,24,-4888.783,-984.3502,503.9405,0,0,0,0,100,0),
+(@PATH,25,-4894.861,-986.5887,503.9404,0,0,0,0,100,0),
+(@PATH,26,-4899.702,-980.8641,503.9404,0,0,0,0,100,0),
+(@PATH,27,-4904.338,-974.595,501.4404,0,0,0,0,100,0),
+(@PATH,28,-4914.213,-959.8905,501.5008,0,0,0,0,100,0),
+(@PATH,29,-4935.674,-935.8187,503.0679,0,0,0,0,100,0),
+(@PATH,30,-4948.829,-920.2165,504.2639,0,0,0,0,100,0),
+(@PATH,31,-4959.338,-908.134,503.838,0,0,0,0,100,0),
+(@PATH,32,-4963.365,-912.5651,503.8371,0,0,0,0,100,0),
+(@PATH,33,-4955.276,-916.4485,504.2608,0,0,0,0,100,0),
+(@PATH,34,-4944.974,-929.275,501.6594,0,0,0,0,100,0),
+(@PATH,35,-4973.284,-956.8936,501.6595,0,0,0,0,100,0),
+(@PATH,36,-4992.383,-979.8217,501.6595,0,0,0,0,100,0),
+(@PATH,37,-4994.909,-996.2097,501.6608,0,0,0,0,100,0),
+(@PATH,38,-5007.273,-1025.464,501.6562,0,0,0,0,100,0),
+(@PATH,39,-5014.62,-1054.751,501.7368,0,0,0,0,100,0),
+(@PATH,40,-5016.097,-1099.324,501.6755,0,0,0,0,100,0),
+(@PATH,41,-5011.856,-1112.884,501.6688,0,0,0,0,100,0);
+
+-- Pathing for Thief Catcher Thunderbrew Entry: 14367
+SET @NPC := 307535;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4951.307,`position_y`=-916.9957,`position_z`=504.2643 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,257,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,-4951.307,-916.9957,504.2643,0,0,0,0,100,0),
+(@PATH,2,-4951.812,-906.4191,503.8389,0,0,0,0,100,0),
+(@PATH,3,-4960.936,-907.5775,503.838,0,0,0,0,100,0),
+(@PATH,4,-4962.912,-915.0382,503.8368,0,0,0,0,100,0),
+(@PATH,5,-4952.596,-917.6653,504.2631,0,0,0,0,100,0),
+(@PATH,6,-4938.362,-936.4061,503.1531,0,0,0,0,100,0),
+(@PATH,7,-4927.755,-951.2063,501.5794,0,0,0,0,100,0),
+(@PATH,8,-4937.9,-980.2713,501.4826,0,0,0,0,100,0),
+(@PATH,9,-4933.834,-968.6218,501.5321,0,0,0,0,100,0),
+(@PATH,10,-4937.9,-980.2713,501.4826,0,0,0,0,100,0),
+(@PATH,11,-4943.053,-998.155,501.4404,0,0,0,0,100,0),
+(@PATH,12,-4943.612,-1014.518,501.4404,0,0,0,0,100,0),
+(@PATH,13,-4948.514,-1023.706,501.4677,0,0,0,0,100,0),
+(@PATH,14,-4924.298,-1036.785,501.7312,0,0,0,0,100,0),
+(@PATH,15,-4885.191,-1057.844,502.1562,0,0,0,0,100,0),
+(@PATH,16,-4873.42,-1069.638,502.2043,0,0,0,0,100,0),
+(@PATH,17,-4872.613,-1106.75,502.2111,0,0,0,0,100,0),
+(@PATH,18,-4858.562,-1134.951,502.1896,0,0,0,0,100,0),
+(@PATH,19,-4842.917,-1155.271,502.2007,0,0,0,0,100,0),
+(@PATH,20,-4820.896,-1169.298,502.2016,0,0,0,0,100,0),
+(@PATH,21,-4789.093,-1166.535,502.2093,0,0,0,0,100,0),
+(@PATH,22,-4758.693,-1159.635,502.2124,0,0,0,0,100,0),
+(@PATH,23,-4730.106,-1194.248,501.6978,0,0,0,0,100,0),
+(@PATH,24,-4719.517,-1218.354,501.6594,0,0,0,0,100,0),
+(@PATH,25,-4740.718,-1244.534,501.6593,0,0,0,0,100,0),
+(@PATH,26,-4724.864,-1277.61,501.6594,0,0,0,0,100,0),
+(@PATH,27,-4694.163,-1265.887,501.9927,0,0,0,0,100,0),
+(@PATH,28,-4682.361,-1259.108,501.9927,0,0,0,0,100,0),
+(@PATH,29,-4664.03,-1243.118,501.9926,0,0,0,0,100,0),
+(@PATH,30,-4674.294,-1252.072,501.9927,0,0,0,0,100,0),
+(@PATH,31,-4664.03,-1243.118,501.9926,0,0,0,0,100,0),
+(@PATH,32,-4643.821,-1214.237,501.6594,0,0,0,0,100,0),
+(@PATH,33,-4647.422,-1189.826,501.6573,0,0,0,0,100,0),
+(@PATH,34,-4683.809,-1195.801,501.659,0,0,0,0,100,0),
+(@PATH,35,-4708.729,-1200.767,501.6594,0,0,0,0,100,0),
+(@PATH,36,-4732.161,-1176.456,501.6978,0,0,0,0,100,0),
+(@PATH,37,-4747.495,-1152.993,502.2123,0,0,0,0,100,0),
+(@PATH,38,-4734.04,-1106.04,502.2149,0,0,0,0,100,0),
+(@PATH,39,-4738.371,-1074.073,502.1891,0,0,0,0,100,0),
+(@PATH,40,-4762.797,-1042.368,502.2115,0,0,0,0,100,0),
+(@PATH,41,-4788.038,-1030.893,502.2101,0,0,0,0,100,0),
+(@PATH,42,-4816.683,-1027.28,502.1976,0,0,0,0,100,0),
+(@PATH,43,-4826.917,-1014.339,502.2123,0,0,0,0,100,0),
+(@PATH,44,-4838.749,-977.6658,501.8224,0,0,0,0,100,0),
+(@PATH,45,-4850.542,-941.909,501.4804,0,0,0,0,100,0),
+(@PATH,46,-4866.628,-946.1914,501.4404,0,0,0,0,100,0),
+(@PATH,47,-4883.959,-942.7081,501.4606,0,0,0,0,100,0),
+(@PATH,48,-4908.408,-967.712,501.4686,0,0,0,0,100,0),
+(@PATH,49,-4901.27,-979.6158,503.0478,0,0,0,0,100,0),
+(@PATH,50,-4894.48,-986.556,503.9404,0,0,0,0,100,0),
+(@PATH,51,-4886.826,-988.1808,503.9404,0,0,0,0,100,0),
+(@PATH,52,-4894.627,-994.6276,503.9404,0,0,0,0,100,0),
+(@PATH,53,-4895.386,-986.9103,503.9404,0,0,0,0,100,0),
+(@PATH,54,-4905.212,-975.2935,501.4377,0,0,0,0,100,0),
+(@PATH,55,-4915.479,-959.2137,501.5037,0,0,0,0,100,0),
+(@PATH,56,-4936.558,-935.2461,503.136,0,0,0,0,100,0);
+
+-- Fix inhabittype for Ironforge Gryphon Rider
+UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (51383);
+
+-- Remove Overspawn
+DELETE FROM `creature` WHERE `guid`=307693;
+DELETE FROM `creature_addon` WHERE `guid`=307693;
+
+-- Pathing for Ironforge Gryphon Rider Entry: 51383 aura 131700 missing from core
+SET @NPC := 307470;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4656.788,`position_y`=-933.1268,`position_z`=517.9826 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4656.788,`position_y`=-933.1268,`position_z`=517.9826 WHERE `guid`=307491;
+DELETE FROM `creature_addon` WHERE `guid`IN (@NPC,307491);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,24688,50331648,257,0, ''),(307491,0,24688,50331648,257,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,-4656.788,-933.1268,517.9826,0,0,1,0,100,0),
+(@PATH,2,-4648.686,-944.1129,517.9826,0,0,1,0,100,0),
+(@PATH,3,-4627.005,-972.3924,517.9826,0,0,1,0,100,0),
+(@PATH,4,-4621.019,-989.4323,517.9826,0,0,1,0,100,0),
+(@PATH,5,-4630.057,-1006.156,517.9826,0,0,1,0,100,0),
+(@PATH,6,-4649.427,-1006.474,517.9826,0,0,1,0,100,0),
+(@PATH,7,-4658.894,-992.0052,517.9826,0,0,1,0,100,0),
+(@PATH,8,-4668.901,-977.4271,516.3707,0,0,1,0,100,0),
+(@PATH,9,-4682.519,-974.9705,516.1705,0,0,1,0,100,0),
+(@PATH,10,-4696.694,-981.2413,517.9826,0,0,1,0,100,0),
+(@PATH,11,-4718.229,-987.0538,517.9826,0,0,1,0,100,0),
+(@PATH,12,-4741.753,-984.7257,517.9826,0,0,1,0,100,0),
+(@PATH,13,-4756.302,-993.9879,517.9826,0,0,1,0,100,0),
+(@PATH,14,-4770.139,-1014.453,517.9826,0,0,1,0,100,0),
+(@PATH,15,-4777.715,-1024.356,517.9826,0,0,1,0,100,0),
+(@PATH,16,-4793.891,-1041.129,515.9854,0,0,1,0,100,0),
+(@PATH,17,-4811.965,-1066.321,512.9799,0,0,1,0,100,0),
+(@PATH,18,-4814.793,-1081.523,511.8857,0,0,1,0,100,0),
+(@PATH,19,-4803.537,-1103.142,511.9943,0,0,1,0,100,0),
+(@PATH,20,-4784.899,-1130.797,510.4152,0,0,1,0,100,0),
+(@PATH,21,-4766.059,-1139.073,510.5892,0,0,1,0,100,0),
+(@PATH,22,-4749.55,-1129.97,512.226,0,0,1,0,100,0),
+(@PATH,23,-4738.897,-1103.372,515.3846,0,0,1,0,100,0),
+(@PATH,24,-4745.62,-1073.766,517.9826,0,0,1,0,100,0),
+(@PATH,25,-4763.078,-1054.38,517.9826,0,0,1,0,100,0),
+(@PATH,26,-4770.394,-1035.554,517.9826,0,0,1,0,100,0),
+(@PATH,27,-4772.682,-1022.568,517.9826,0,0,1,0,100,0),
+(@PATH,28,-4770.213,-1012.955,517.9826,0,0,1,0,100,0),
+(@PATH,29,-4755.266,-990.8073,517.9826,0,0,1,0,100,0),
+(@PATH,30,-4740.859,-984.1996,517.9826,0,0,1,0,100,0),
+(@PATH,31,-4714.827,-986.2518,517.9826,0,0,1,0,100,0),
+(@PATH,32,-4694.321,-981.2708,517.9826,0,0,1,0,100,0),
+(@PATH,33,-4683.519,-972.1962,516.3256,0,0,1,0,100,0),
+(@PATH,34,-4683.8,-957.8577,516.4511,0,0,1,0,100,0),
+(@PATH,35,-4698.646,-939.8177,517.9826,0,0,1,0,100,0),
+(@PATH,36,-4707.662,-927.2864,517.9826,0,0,1,0,100,0),
+(@PATH,37,-4702.153,-909.4896,517.9826,0,0,1,0,100,0),
+(@PATH,38,-4682.417,-904.1945,517.9826,0,0,1,0,100,0),
+(@PATH,39,-4668.556,-917.9549,517.9826,0,0,1,0,100,0);
+-- Set Formation/Group Combat Assistance
+DELETE FROM `creature_formations` WHERE `leaderGUID`=307470;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(307470,307470,0,0,2),
+(307470,307491,20,360,2);
+
+-- Pathing for Ironforge Gryphon Rider Entry: 51383 aura 131700 missing from core
+SET @NPC := 307956;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4909.578,`position_y`=-876.0729,`position_z`=510.079 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,24688,50331648,257,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,-4909.578,-876.0729,510.079,0,0,1,0,100,0),
+(@PATH,2,-4903.858,-893.3958,508.2063,0,0,1,0,100,0),
+(@PATH,3,-4920.448,-916.7136,511.526,0,0,1,0,100,0),
+(@PATH,4,-4937.476,-935.9305,514.1577,0,0,1,0,100,0),
+(@PATH,5,-4958.811,-966.1962,516.3503,0,0,1,0,100,0),
+(@PATH,6,-4961.632,-985.559,517.1049,0,0,1,0,100,0),
+(@PATH,7,-4948.224,-995.1545,517.1049,0,0,1,0,100,0),
+(@PATH,8,-4938.427,-978.8559,517.1049,0,0,1,0,100,0),
+(@PATH,9,-4919.226,-972.7344,517.1049,0,0,1,0,100,0),
+(@PATH,10,-4905.594,-961.4358,517.1049,0,0,1,0,100,0),
+(@PATH,11,-4893.134,-942.8611,517.1049,0,0,1,0,100,0),
+(@PATH,12,-4881.521,-934.467,517.1049,0,0,1,0,100,0),
+(@PATH,13,-4887.769,-920.658,517.1049,0,0,1,0,100,0),
+(@PATH,14,-4905.135,-921.8489,515.672,0,0,1,0,100,0),
+(@PATH,15,-4936.984,-935.7136,514.175,0,0,1,0,100,0),
+(@PATH,16,-4961.83,-950.1528,511.3546,0,0,1,0,100,0),
+(@PATH,17,-4985.467,-960.3854,509.8075,0,0,1,0,100,0),
+(@PATH,18,-5004.415,-949.8368,509.2013,0,0,1,0,100,0),
+(@PATH,19,-5014.249,-937.9271,510.8414,0,0,1,0,100,0),
+(@PATH,20,-5016.611,-925.1371,513.3546,0,0,1,0,100,0),
+(@PATH,21,-5003.375,-911.0313,517.7399,0,0,1,0,100,0),
+(@PATH,22,-4983.387,-893.0712,526.079,0,0,1,0,100,0),
+(@PATH,23,-4970.194,-881.7847,526.0088,0,0,1,0,100,0),
+(@PATH,24,-4951.868,-867.0955,519.6282,0,0,1,0,100,0),
+(@PATH,25,-4937.075,-857.5295,514.6605,0,0,1,0,100,0),
+(@PATH,26,-4925.262,-857.757,511.0107,0,0,1,0,100,0);
+
+-- Pathing for Ironforge Gryphon Rider Entry: 51383 aura 131700 missing from core
+SET @NPC := 307606;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4693.774,`position_y`=-1196.641,`position_z`=520.8726 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,24688,50331648,257,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,-4693.774,-1196.641,520.8726,0,0,1,0,100,0),
+(@PATH,2,-4704.641,-1203.278,520.2697,0,0,1,0,100,0),
+(@PATH,3,-4719.483,-1216.061,520.5136,0,0,1,0,100,0),
+(@PATH,4,-4734.302,-1229.505,521.4822,0,0,1,0,100,0),
+(@PATH,5,-4741.995,-1247.021,522.367,0,0,1,0,100,0),
+(@PATH,6,-4736.851,-1267.321,523.668,0,0,1,0,100,0),
+(@PATH,7,-4719.147,-1277.611,527.2007,0,0,1,0,100,0),
+(@PATH,8,-4707.54,-1250.122,532.3543,0,0,1,0,100,0),
+(@PATH,9,-4694.186,-1229.408,536.1665,0,0,1,0,100,0),
+(@PATH,10,-4674.268,-1222.995,532.2911,0,0,1,0,100,0),
+(@PATH,11,-4641.533,-1213.908,528.0612,0,0,1,0,100,0),
+(@PATH,12,-4644.469,-1194.054,524.7205,0,0,1,0,100,0),
+(@PATH,13,-4663.172,-1187.111,523.3699,0,0,1,0,100,0),
+(@PATH,14,-4676.446,-1187.922,522.6842,0,0,1,0,100,0);
+
+-- Pathing for Ironforge Gryphon Rider Entry: 51383 aura 131700 missing from core
+SET @NPC := 307649;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4975.226,`position_y`=-1237.778,`position_z`=518.5372 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-4975.226,`position_y`=-1237.778,`position_z`=518.5372 WHERE `guid`=307654;
+DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,307654);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,24688,50331648,257,0, ''),(307654,0,24688,50331648,257,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,-4975.226,-1237.778,518.5372,0,0,1,0,100,0),
+(@PATH,2,-4986.518,-1224.807,518.5372,0,0,1,0,100,0),
+(@PATH,3,-5000.472,-1210.543,518.5372,0,0,1,0,100,0),
+(@PATH,4,-5018.698,-1190.444,518.5372,0,0,1,0,100,0),
+(@PATH,5,-5016.92,-1168.219,518.5372,0,0,1,0,100,0),
+(@PATH,6,-5000.096,-1160.955,518.5372,0,0,1,0,100,0),
+(@PATH,7,-4982.547,-1170.441,518.5372,0,0,1,0,100,0),
+(@PATH,8,-4966.918,-1186.434,518.5372,0,0,1,0,100,0),
+(@PATH,9,-4954.882,-1192.115,518.5372,0,0,1,0,100,0),
+(@PATH,10,-4941.474,-1184.632,518.5372,0,0,1,0,100,0),
+(@PATH,11,-4931.833,-1168.212,518.5372,0,0,1,0,100,0),
+(@PATH,12,-4926.116,-1146.262,518.5372,0,0,1,0,100,0),
+(@PATH,13,-4921.962,-1132.712,518.5372,0,0,1,0,100,0),
+(@PATH,14,-4913.53,-1123.191,518.5372,0,0,1,0,100,0),
+(@PATH,15,-4891.198,-1115.434,517.3032,0,0,1,0,100,0),
+(@PATH,16,-4876.922,-1115.392,517.3371,0,0,1,0,100,0),
+(@PATH,17,-4857.978,-1125.967,518.5372,0,0,1,0,100,0),
+(@PATH,18,-4840.377,-1148.28,518.5372,0,0,1,0,100,0),
+(@PATH,19,-4826.927,-1158.556,518.5372,0,0,1,0,100,0),
+(@PATH,20,-4809.682,-1161.948,521.3034,0,0,1,0,100,0),
+(@PATH,21,-4797.313,-1158.009,523.4744,0,0,1,0,100,0),
+(@PATH,22,-4788.668,-1142.533,525.5253,0,0,1,0,100,0),
+(@PATH,23,-4791.962,-1120.405,526.8151,0,0,1,0,100,0),
+(@PATH,24,-4806.747,-1101.373,526.7133,0,0,1,0,100,0),
+(@PATH,25,-4822.484,-1094.524,525.1048,0,0,1,0,100,0),
+(@PATH,26,-4844.344,-1093.806,522.5946,0,0,1,0,100,0),
+(@PATH,27,-4862.285,-1100.215,518.5372,0,0,1,0,100,0),
+(@PATH,28,-4875.401,-1107.936,517.3416,0,0,1,0,100,0),
+(@PATH,29,-4891.443,-1114.363,517.157,0,0,1,0,100,0),
+(@PATH,30,-4914.05,-1121.936,518.5372,0,0,1,0,100,0),
+(@PATH,31,-4922.698,-1132.023,518.5372,0,0,1,0,100,0),
+(@PATH,32,-4926.785,-1146.066,518.5372,0,0,1,0,100,0),
+(@PATH,33,-4931.59,-1168.043,518.5372,0,0,1,0,100,0),
+(@PATH,34,-4941.452,-1184.267,518.5372,0,0,1,0,100,0),
+(@PATH,35,-4951.413,-1195.674,518.5372,0,0,1,0,100,0),
+(@PATH,36,-4947.297,-1208.754,518.5372,0,0,1,0,100,0),
+(@PATH,37,-4930.128,-1224.477,518.5372,0,0,1,0,100,0),
+(@PATH,38,-4922.878,-1243.274,518.5372,0,0,1,0,100,0),
+(@PATH,39,-4933.707,-1260.944,518.5372,0,0,1,0,100,0),
+(@PATH,40,-4952.526,-1259.865,518.5372,0,0,1,0,100,0);
+-- Set Formation/Group Combat Assistance
+DELETE FROM `creature_formations` WHERE `leaderGUID`=307649;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(307649,307649,0,0,2),
+(307649,307654,20,360,2);
+
+-- Pathing for Ironforge Gryphon Rider Entry: 51383 aura 131700 missing from core
+SET @NPC := 307691;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4916.66,`position_y`=-965.7604,`position_z`=533.9771 WHERE `guid`=@NPC;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-4916.66,`position_y`=-965.7604,`position_z`=533.9771 WHERE `guid`=307692;
+DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,307692);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,24688,50331648,257,0, ''),(307692,0,24688,50331648,257,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,-4916.66,-965.7604,533.9771,0,0,1,0,100,0),
+(@PATH,2,-4910.347,-960.4167,533.9771,0,0,1,0,100,0),
+(@PATH,3,-4898.452,-953.5695,533.9771,0,0,1,0,100,0),
+(@PATH,4,-4887.934,-948.5018,533.9771,0,0,1,0,100,0),
+(@PATH,5,-4879.453,-939.0903,533.9771,0,0,1,0,100,0),
+(@PATH,6,-4884.168,-924.6441,533.9771,0,0,1,0,100,0),
+(@PATH,7,-4877.941,-908.8299,533.9771,0,0,1,0,100,0),
+(@PATH,8,-4856.287,-901.5121,533.9771,0,0,1,0,100,0),
+(@PATH,9,-4830.338,-898.3871,533.9771,0,0,1,0,100,0),
+(@PATH,10,-4805.953,-897.0972,531.1616,0,0,1,0,100,0),
+(@PATH,11,-4773.712,-899.1424,526.3719,0,0,1,0,100,0),
+(@PATH,12,-4731.849,-913.2899,525.5359,0,0,1,0,100,0),
+(@PATH,13,-4710.226,-924.9809,528.5975,0,0,1,0,100,0),
+(@PATH,14,-4690.318,-951.0504,532.226,0,0,1,0,100,0),
+(@PATH,15,-4669.264,-979.2518,533.9771,0,0,1,0,100,0),
+(@PATH,16,-4651.351,-1004.573,533.9771,0,0,1,0,100,0),
+(@PATH,17,-4627.151,-1011.408,533.9771,0,0,1,0,100,0),
+(@PATH,18,-4611.387,-988.8195,533.9771,0,0,1,0,100,0),
+(@PATH,19,-4632.438,-967.7778,533.9771,0,0,1,0,100,0),
+(@PATH,20,-4653.198,-948.4636,533.9771,0,0,1,0,100,0),
+(@PATH,21,-4669.061,-926.9427,533.609,0,0,1,0,100,0),
+(@PATH,22,-4684.304,-900.6962,530.2642,0,0,1,0,100,0),
+(@PATH,23,-4706.351,-914.5035,528.7224,0,0,1,0,100,0),
+(@PATH,24,-4731.677,-912.6528,525.7537,0,0,1,0,100,0),
+(@PATH,25,-4773.259,-895.8733,527.4689,0,0,1,0,100,0),
+(@PATH,26,-4806.58,-891.3924,530.2522,0,0,1,0,100,0),
+(@PATH,27,-4831.689,-892.3542,533.9771,0,0,1,0,100,0),
+(@PATH,28,-4859.887,-896.1198,534.3198,0,0,1,0,100,0),
+(@PATH,29,-4882.17,-901.7587,533.9771,0,0,1,0,100,0),
+(@PATH,30,-4909.325,-914.4896,533.9771,0,0,1,0,100,0),
+(@PATH,31,-4935.804,-931.3489,533.9771,0,0,1,0,100,0),
+(@PATH,32,-4959.233,-953.9722,533.9771,0,0,1,0,100,0),
+(@PATH,33,-4977.344,-980.9305,533.9771,0,0,1,0,100,0),
+(@PATH,34,-4990.651,-1006.661,533.9771,0,0,1,0,100,0),
+(@PATH,35,-5000.106,-1030.326,533.9771,0,0,1,0,100,0),
+(@PATH,36,-5005.588,-1053.406,533.9771,0,0,1,0,100,0),
+(@PATH,37,-5008.738,-1085.462,530.0939,0,0,1,0,100,0),
+(@PATH,38,-5003.042,-1112.712,528.7307,0,0,1,0,100,0),
+(@PATH,39,-4999.156,-1141.523,526.0404,0,0,1,0,100,0),
+(@PATH,40,-5003.677,-1158.026,527.0526,0,0,1,0,100,0),
+(@PATH,41,-5021.292,-1170.601,528.0728,0,0,1,0,100,0),
+(@PATH,42,-5022.948,-1189.568,529.7715,0,0,1,0,100,0),
+(@PATH,43,-5004.412,-1206.453,533.9771,0,0,1,0,100,0),
+(@PATH,44,-4990.332,-1220.243,533.9771,0,0,1,0,100,0),
+(@PATH,45,-4967.349,-1246.097,533.9771,0,0,1,0,100,0),
+(@PATH,46,-4947.792,-1265.377,533.9771,0,0,1,0,100,0),
+(@PATH,47,-4930.965,-1260.177,533.9771,0,0,1,0,100,0),
+(@PATH,48,-4919.764,-1238.974,533.9771,0,0,1,0,100,0),
+(@PATH,49,-4929.823,-1222.325,533.9771,0,0,1,0,100,0),
+(@PATH,50,-4948.554,-1206.03,533.9771,0,0,1,0,100,0),
+(@PATH,51,-4975.132,-1176.396,530.016,0,0,1,0,100,0),
+(@PATH,52,-4997.778,-1141.269,526.1173,0,0,1,0,100,0),
+(@PATH,53,-4999.583,-1111.821,528.9969,0,0,1,0,100,0),
+(@PATH,54,-5001.667,-1083.896,529.8127,0,0,1,0,100,0),
+(@PATH,55,-4999.054,-1053.639,533.9771,0,0,1,0,100,0),
+(@PATH,56,-4994.42,-1031.533,533.9771,0,0,1,0,100,0),
+(@PATH,57,-4984.413,-1008.882,533.9771,0,0,1,0,100,0),
+(@PATH,58,-4973.124,-992.8854,533.9771,0,0,1,0,100,0),
+(@PATH,59,-4960.238,-986.7448,533.9771,0,0,1,0,100,0),
+(@PATH,60,-4943.624,-988.816,533.9771,0,0,1,0,100,0),
+(@PATH,61,-4928.372,-982.118,533.9771,0,0,1,0,100,0);
+-- Set Formation/Group Combat Assistance
+DELETE FROM `creature_formations` WHERE `leaderGUID`=307691;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(307691,307691,0,0,2),
+(307691,307692,20,360,2);