diff options
| -rw-r--r-- | sql/updates/world/master/2017_03_15_00_world.sql | 908 |
1 files changed, 908 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_15_00_world.sql b/sql/updates/world/master/2017_03_15_00_world.sql new file mode 100644 index 00000000000..06c9943f495 --- /dev/null +++ b/sql/updates/world/master/2017_03_15_00_world.sql @@ -0,0 +1,908 @@ +-- Pathing for Honor Guard Entry: 3083 "aura 131700 not recognized by core, removed" +SET @NPC := 294089; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1201.75,`position_y`=6.201009,`position_z`=165.2908 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,-1201.75,6.201009,165.2908,0,0,0,0,100,0), +(@PATH,2,-1203.136,-2.44949,165.5753,0,0,0,0,100,0), +(@PATH,3,-1206.141,-19.69922,165.1488,0,0,0,0,100,0), +(@PATH,4,-1204.272,-33.55349,162.6203,0,0,0,0,100,0), +(@PATH,5,-1194.974,-41.1951,162.1591,0,0,0,0,100,0), +(@PATH,6,-1187.794,-52.977,161.7958,0,0,0,0,100,0), +(@PATH,7,-1185.099,-67.29302,161.7958,0,0,0,0,100,0), +(@PATH,8,-1187.387,-83.45068,162.6708,0,0,0,0,100,0), +(@PATH,9,-1194.023,-94.20335,162.7958,0,0,0,0,100,0), +(@PATH,10,-1202.38,-100.8003,162.8914,0,0,0,0,100,0), +(@PATH,11,-1209.124,-100.686,162.7862,0,0,0,0,100,0), +(@PATH,12,-1215.599,-99.39193,162.6986,0,0,0,0,100,0), +(@PATH,13,-1226.149,-90.12636,162.9123,0,0,0,0,100,0), +(@PATH,14,-1229.038,-82.05936,162.631,0,0,0,0,100,0), +(@PATH,15,-1228.136,-53.07568,162.9665,0,0,0,0,100,0), +(@PATH,16,-1223.143,-46.62646,162.9237,0,0,0,0,100,0), +(@PATH,17,-1209.656,-33.6059,162.9601,0,0,0,0,100,0), +(@PATH,18,-1203.914,-3.019911,165.5753,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 294112; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1168.788,`position_y`=33.45985,`position_z`=145.8474 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,-1168.788,33.45985,145.8474,0,0,0,0,100,0), +(@PATH,2,-1143.101,31.69889,144.4693,0,0,0,0,100,0), +(@PATH,3,-1129.679,27.77528,143.1757,0,0,0,0,100,0), +(@PATH,4,-1118.848,20.68262,141.9269,0,0,0,0,100,0), +(@PATH,5,-1110.312,11.87543,141.4769,0,0,0,0,100,0), +(@PATH,6,-1108.038,2.633735,141.8561,0,0,0,0,100,0), +(@PATH,7,-1108.295,-8.439453,142.5848,0,0,0,0,100,0), +(@PATH,8,-1106.892,1.775987,141.5812,0,0,0,0,100,0), +(@PATH,9,-1099.383,2.072103,140.9216,0,0,0,0,100,0), +(@PATH,10,-1080.539,-10.889,140.0936,0,0,0,0,100,0), +(@PATH,11,-1070.363,-14.81733,140.3375,0,0,0,0,100,0), +(@PATH,12,-1064.345,-7.990506,140.7598,0,0,0,0,100,0), +(@PATH,13,-1061.785,9.221463,141.0749,0,0,0,0,100,0), +(@PATH,14,-1061.932,30.94906,141.5573,0,0,0,0,100,0), +(@PATH,15,-1066.953,43.71555,140.9477,0,0,0,0,100,0), +(@PATH,16,-1078.355,54.53261,139.9196,0,0,0,0,100,0), +(@PATH,17,-1087.839,69.60281,139.9995,0,0,0,0,100,0), +(@PATH,18,-1094.657,73.76747,140.6462,0,0,0,0,100,0), +(@PATH,19,-1106.718,61.19081,140.764,0,0,0,0,100,0), +(@PATH,20,-1124.568,55.52512,142.5355,0,0,0,0,100,0), +(@PATH,21,-1131.095,46.38525,143.0579,0,0,0,0,100,0), +(@PATH,22,-1143.504,32.68093,144.2988,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 296261; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1258.606,`position_y`=53.81896,`position_z`=127.1327 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,-1258.606,53.81896,127.1327,0,0,0,0,100,0), +(@PATH,2,-1243.916,68.45963,127.8781,0,0,0,0,100,0), +(@PATH,3,-1227.24,85.19437,131.0852,0,0,0,0,100,0), +(@PATH,4,-1215.417,97.94102,133.5996,0,0,0,0,100,0), +(@PATH,5,-1205.688,111.7493,134.4291,0,0,0,0,100,0), +(@PATH,6,-1205.333,120.7279,134.7717,0,0,0,0,100,0), +(@PATH,7,-1216.366,133.2639,133.8978,0,0,0,0,100,0), +(@PATH,8,-1228.062,137.3362,133.2216,0,0,0,0,100,0), +(@PATH,9,-1243.349,134.2608,132.5933,0,0,0,0,100,0), +(@PATH,10,-1259.448,129.3288,131.9277,0,0,0,0,100,0), +(@PATH,11,-1276.366,125.9758,131.3434,0,0,0,0,100,0), +(@PATH,12,-1288.774,108.905,131.0648,0,0,0,0,100,0), +(@PATH,13,-1286.075,96.88734,130.167,0,0,0,0,100,0), +(@PATH,14,-1275.446,90.51749,128.9082,0,0,0,0,100,0), +(@PATH,15,-1265.206,73.23226,127.7833,0,0,0,0,100,0), +(@PATH,16,-1267.417,59.39589,127.0626,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 293972; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-967.7294,`position_y`=239.1658,`position_z`=134.9225 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,-967.7294,239.1658,134.9225,0,0,0,0,100,0), +(@PATH,2,-981.1287,224.814,135.1811,0,0,0,0,100,0), +(@PATH,3,-995.8068,219.3985,134.9311,0,0,0,0,100,0), +(@PATH,4,-1009.368,223.3298,134.6811,0,0,0,0,100,0), +(@PATH,5,-1021.302,231.2146,134.6811,0,0,0,0,100,0), +(@PATH,6,-1031.48,239.738,134.6811,0,0,0,0,100,0), +(@PATH,7,-1042.19,238.838,134.6718,0,0,0,0,100,0), +(@PATH,8,-1031.48,239.738,134.6811,0,0,0,0,100,0), +(@PATH,9,-1021.302,231.2146,134.6811,0,0,0,0,100,0), +(@PATH,10,-1009.368,223.3298,134.6811,0,0,0,0,100,0), +(@PATH,11,-995.8068,219.3985,134.9311,0,0,0,0,100,0), +(@PATH,12,-981.1287,224.814,135.1811,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 294056; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1026.345,`position_y`=-253.2422,`position_z`=159.1158 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,-1026.345,-253.2422,159.1158,0,0,0,0,100,0), +(@PATH,2,-1036.859,-242.3199,159.1553,0,0,0,0,100,0), +(@PATH,3,-1045.037,-236.4134,159.1903,0,0,0,0,100,0), +(@PATH,4,-1060.129,-235.3343,159.1553,0,0,0,0,100,0), +(@PATH,5,-1069.537,-238.5527,159.1553,0,0,0,0,100,0), +(@PATH,6,-1081.75,-251.6721,159.1553,0,0,0,0,100,0), +(@PATH,7,-1086.723,-267.0825,159.1553,0,0,0,0,100,0), +(@PATH,8,-1087.089,-283.2024,159.1553,0,0,0,0,100,0), +(@PATH,9,-1085.533,-297.0219,159.1553,0,0,0,0,100,0), +(@PATH,10,-1081.044,-309.9766,159.3124,0,0,0,0,100,0), +(@PATH,11,-1066.679,-325.857,159.1777,0,0,0,0,100,0), +(@PATH,12,-1054.704,-332.2506,159.1553,0,0,0,0,100,0), +(@PATH,13,-1042.908,-333.3994,159.1093,0,0,0,0,100,0), +(@PATH,14,-1034.894,-329.8777,159.1553,0,0,0,0,100,0), +(@PATH,15,-1023.885,-318.9573,159.1714,0,0,0,0,100,0), +(@PATH,16,-1016.116,-307.2137,159.1001,0,0,0,0,100,0), +(@PATH,17,-1014.837,-289.7074,159.1553,0,0,0,0,100,0), +(@PATH,18,-1019.827,-266.8278,159.1553,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 294008; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1425.81,`position_y`=-55.83138,`position_z`=156.9624 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,-1425.81,-55.83138,156.9624,0,0,0,0,100,0), +(@PATH,2,-1415.162,-60.96566,156.9624,0,0,0,0,100,0), +(@PATH,3,-1400.184,-62.66531,157.8775,0,0,0,0,100,0), +(@PATH,4,-1392.677,-75.85276,159.0717,0,0,0,0,100,0), +(@PATH,5,-1392.914,-86.97846,158.9467,0,0,0,0,100,0), +(@PATH,6,-1396.527,-99.89052,158.9467,0,0,0,0,100,0), +(@PATH,7,-1400.503,-115.6658,159.0598,0,0,0,0,100,0), +(@PATH,8,-1396.962,-122.9275,158.9394,0,0,0,0,100,0), +(@PATH,9,-1386.234,-129.9867,156.7785,0,0,0,0,100,0), +(@PATH,10,-1396.962,-122.9275,158.9394,0,0,0,0,100,0), +(@PATH,11,-1400.503,-115.6658,159.0598,0,0,0,0,100,0), +(@PATH,12,-1396.527,-99.89052,158.9467,0,0,0,0,100,0), +(@PATH,13,-1392.914,-86.97846,158.9467,0,0,0,0,100,0), +(@PATH,14,-1392.677,-75.85276,159.0717,0,0,0,0,100,0), +(@PATH,15,-1400.184,-62.66531,157.8775,0,0,0,0,100,0), +(@PATH,16,-1415.162,-60.96566,156.9624,0,0,0,0,100,0); + +-- Pathing for Bluffwatcher Entry: 3084 "aura 131700 not recognized by core, removed" +SET @NPC := 296214; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1185.628,`position_y`=-78.60406,`position_z`=162.3331 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,-1185.628,-78.60406,162.3331,0,0,0,0,100,0), +(@PATH,2,-1185.547,-64.1517,161.7177,0,0,0,0,100,0), +(@PATH,3,-1188.276,-52.77669,161.7958,0,0,0,0,100,0), +(@PATH,4,-1198.999,-36.81728,162.2675,0,0,0,0,100,0), +(@PATH,5,-1210.357,-34.28141,162.9633,0,0,0,0,100,0), +(@PATH,6,-1219.807,-42.42144,162.9672,0,0,0,0,100,0), +(@PATH,7,-1228.321,-53.6894,162.829,0,0,0,0,100,0), +(@PATH,8,-1230.28,-69.77241,162.2802,0,0,0,0,100,0), +(@PATH,9,-1247.185,-75.29324,162.9968,0,0,0,0,100,0), +(@PATH,10,-1264.571,-79.84066,162.829,0,0,0,0,100,0), +(@PATH,11,-1275.965,-77.91054,160.7791,0,0,0,0,100,0), +(@PATH,12,-1283.044,-72.13564,158.1336,0,0,0,0,100,0), +(@PATH,13,-1281.836,-54.01357,153.9577,0,0,0,0,100,0), +(@PATH,14,-1281.32,-32.01367,146.6115,0,0,0,0,100,0), +(@PATH,15,-1279.946,-15.92725,140.101,0,0,0,0,100,0), +(@PATH,16,-1285.694,-3.737033,134.4972,0,0,0,0,100,0), +(@PATH,17,-1295.824,-0.315918,133.4005,0,0,0,0,100,0), +(@PATH,18,-1306.38,0.171821,133.2014,0,0,0,0,100,0), +(@PATH,19,-1317.538,7.705783,131.9224,0,0,0,0,100,0), +(@PATH,20,-1325.885,23.51709,129.4514,0,0,0,0,100,0), +(@PATH,21,-1332.464,36.99897,129.2079,0,0,0,0,100,0), +(@PATH,22,-1331.844,46.2882,129.3914,0,0,0,0,100,0), +(@PATH,23,-1318.842,57.64214,129.1248,0,0,0,0,100,0), +(@PATH,24,-1305.294,60.12218,128.6521,0,0,0,0,100,0), +(@PATH,25,-1289.067,63.74284,128.5353,0,0,0,0,100,0), +(@PATH,26,-1272.446,64.96034,127.6661,0,0,0,0,100,0), +(@PATH,27,-1263.725,71.92529,127.6266,0,0,0,0,100,0), +(@PATH,28,-1268.442,78.7768,128.3077,0,0,0,0,100,0), +(@PATH,29,-1278.69,88.71143,128.9997,0,0,0,0,100,0), +(@PATH,30,-1286.639,97.72035,130.292,0,0,0,0,100,0), +(@PATH,31,-1289.981,107.4337,131.0934,0,0,0,0,100,0), +(@PATH,32,-1284.555,113.2345,131.0934,0,0,0,0,100,0), +(@PATH,33,-1278.548,112.8293,131.0588,0,0,0,0,100,0), +(@PATH,34,-1278.688,125.9278,131.2673,0,0,0,0,100,0), +(@PATH,35,-1271.06,127.3074,131.4327,0,0,0,0,100,0), +(@PATH,36,-1253.572,132.1614,132.3928,0,0,0,0,100,0), +(@PATH,37,-1239.447,136.0198,132.6792,0,0,0,0,100,0), +(@PATH,38,-1225.849,137.1184,133.2216,0,0,0,0,100,0), +(@PATH,39,-1218.776,134.7869,133.781,0,0,0,0,100,0), +(@PATH,40,-1208.793,127.5007,134.5441,0,0,0,0,100,0), +(@PATH,41,-1203.738,119.5949,134.9242,0,0,0,0,100,0), +(@PATH,42,-1194.231,121.4845,135.2329,0,0,0,0,100,0), +(@PATH,43,-1174.164,119.4869,135.2329,0,0,0,0,100,0), +(@PATH,44,-1150.027,117.9231,135.059,0,0,0,0,100,0), +(@PATH,45,-1122.884,119.7552,139.5448,0,0,0,0,100,0), +(@PATH,46,-1105.848,115.9938,141.0952,0,0,0,0,100,0), +(@PATH,47,-1096.921,112.9548,141.7805,0,0,0,0,100,0), +(@PATH,48,-1090.429,98.76625,141.1853,0,0,0,0,100,0), +(@PATH,49,-1093.283,78.07303,140.584,0,0,0,0,100,0), +(@PATH,50,-1084.34,62.64904,139.9779,0,0,0,0,100,0), +(@PATH,51,-1074.493,48.70725,140.0429,0,0,0,0,100,0), +(@PATH,52,-1062.467,33.47879,141.4671,0,0,0,0,100,0), +(@PATH,53,-1061.867,9.643609,141.0652,0,0,0,0,100,0), +(@PATH,54,-1064.904,-5.986166,140.93,0,0,0,0,100,0), +(@PATH,55,-1071.998,-15.97407,140.2186,0,0,0,0,100,0), +(@PATH,56,-1093.158,-3.01709,140.7186,0,0,0,0,100,0), +(@PATH,57,-1107.373,6.741537,141.3776,0,0,0,0,100,0), +(@PATH,58,-1124.039,24.71511,142.6525,0,0,0,0,100,0), +(@PATH,59,-1139.364,31.68294,143.7862,0,0,0,0,100,0), +(@PATH,60,-1140.156,38.62158,143.817,0,0,0,0,100,0), +(@PATH,61,-1127.634,52.20085,142.848,0,0,0,0,100,0), +(@PATH,62,-1119.944,56.76785,141.7198,0,0,0,0,100,0), +(@PATH,63,-1110.276,60.70291,140.764,0,0,0,0,100,0), +(@PATH,64,-1103.677,64.0734,140.764,0,0,0,0,100,0), +(@PATH,65,-1094.007,77.37207,140.587,0,0,0,0,100,0), +(@PATH,66,-1090.396,98.9177,141.1814,0,0,0,0,100,0), +(@PATH,67,-1096.957,112.9301,141.7763,0,0,0,0,100,0), +(@PATH,68,-1119.066,119.7013,140.1658,0,0,0,0,100,0), +(@PATH,69,-1150.59,118.0519,135.059,0,0,0,0,100,0), +(@PATH,70,-1185.004,120.206,135.2329,0,0,0,0,100,0), +(@PATH,71,-1203.841,119.3472,134.9242,0,0,0,0,100,0), +(@PATH,72,-1207.402,107.5982,134.2235,0,0,0,0,100,0), +(@PATH,73,-1218.438,95.42806,132.8741,0,0,0,0,100,0), +(@PATH,74,-1232.013,80.82764,130.3112,0,0,0,0,100,0), +(@PATH,75,-1244.933,67.53049,127.6447,0,0,0,0,100,0), +(@PATH,76,-1252.141,58.31424,127.0077,0,0,0,0,100,0), +(@PATH,77,-1261.545,55.68945,127.0077,0,0,0,0,100,0), +(@PATH,78,-1272.011,64.7219,127.6141,0,0,0,0,100,0), +(@PATH,79,-1291.922,63.30989,128.5353,0,0,0,0,100,0), +(@PATH,80,-1318.241,56.93245,129.1248,0,0,0,0,100,0), +(@PATH,81,-1329.899,48.84261,129.1248,0,0,0,0,100,0), +(@PATH,82,-1332.802,38.08089,129.1248,0,0,0,0,100,0), +(@PATH,83,-1321.059,13.96219,130.4754,0,0,0,0,100,0), +(@PATH,84,-1311.695,2.738281,132.7193,0,0,0,0,100,0), +(@PATH,85,-1301.055,0.26964,133.2316,0,0,0,0,100,0), +(@PATH,86,-1289.728,-1.129612,134.0075,0,0,0,0,100,0), +(@PATH,87,-1282.801,-5.987033,135.361,0,0,0,0,100,0), +(@PATH,88,-1279.863,-21.3087,142.5744,0,0,0,0,100,0), +(@PATH,89,-1282.238,-40.16016,149.6115,0,0,0,0,100,0), +(@PATH,90,-1281.685,-60.63921,155.8,0,0,0,0,100,0), +(@PATH,91,-1283.639,-72.72543,158.303,0,0,0,0,100,0), +(@PATH,92,-1290.43,-91.37088,161.462,0,0,0,0,100,0), +(@PATH,93,-1291.593,-102.5372,161.9867,0,0,0,0,100,0), +(@PATH,94,-1288.042,-110.2194,161.8593,0,0,0,0,100,0), +(@PATH,95,-1280.818,-124.7894,162.101,0,0,0,0,100,0), +(@PATH,96,-1273.865,-135.4564,163.0797,0,0,0,0,100,0), +(@PATH,97,-1259.593,-145.1641,162.9032,0,0,0,0,100,0), +(@PATH,98,-1242.883,-150.7009,162.9176,0,0,0,0,100,0), +(@PATH,99,-1216.288,-152.7911,163.045,0,0,0,0,100,0), +(@PATH,100,-1178.039,-148.194,162.9117,0,0,0,0,100,0), +(@PATH,101,-1150.392,-138.5583,162.6323,0,0,0,0,100,0), +(@PATH,102,-1138.441,-129.9952,161.4278,0,0,0,0,100,0), +(@PATH,103,-1129.539,-116.9426,160.6178,0,0,0,0,100,0), +(@PATH,104,-1127.122,-105.2795,160.2721,0,0,0,0,100,0), +(@PATH,105,-1135.831,-91.8616,160.9636,0,0,0,0,100,0), +(@PATH,106,-1146.353,-84.9285,162.0886,0,0,0,0,100,0), +(@PATH,107,-1162.39,-80.52567,162.5886,0,0,0,0,100,0); + +-- Pathing for Clarice Foster Entry: 5543 +SET @NPC := 293978; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1030.367,`position_y`=215.6695,`position_z`=110.0713 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,-1030.367,215.6695,110.0713,0,0,0,0,100,0), +(@PATH,2,-1022.247,230.3345,107.5097,0,0,0,0,100,0), +(@PATH,3,-1023.68,233.0425,107.2576,0,0,0,0,100,0), +(@PATH,4,-1030.367,215.6695,110.0713,0,0,0,0,100,0), +(@PATH,5,-1035.114,215.1814,111.2967,0,0,0,0,100,0), +(@PATH,6,-1036.172,216.7637,111.2399,0,0,0,0,100,0); + +-- Pathing for Chepi Entry: 8361 +SET @NPC := 296245; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1217.676,`position_y`=95.91406,`position_z`=133.1743 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,-1217.676,95.91406,133.1743,0,0,0,0,100,0), +(@PATH,2,-1211.168,103.7428,133.9824,0,0,0,0,100,0), +(@PATH,3,-1205.49,114.4286,134.5778,0,0,0,0,100,0), +(@PATH,4,-1205.906,121.3248,134.653,0,0,0,0,100,0), +(@PATH,5,-1210.145,128.8426,134.3944,0,0,0,0,100,0), +(@PATH,6,-1218.423,134.9026,133.8232,0,0,0,0,100,0), +(@PATH,7,-1226.806,137.4804,133.2216,0,0,0,0,100,0), +(@PATH,8,-1236.754,136.6828,132.9733,0,0,0,0,100,0), +(@PATH,9,-1248.581,132.5166,132.4354,0,0,0,0,100,0), +(@PATH,10,-1264.228,128.3987,131.7008,0,0,0,0,100,0), +(@PATH,11,-1275.01,123.9798,131.3434,0,0,0,0,100,0), +(@PATH,12,-1282.07,117.7234,131.2184,0,0,0,0,100,0), +(@PATH,13,-1288.728,108.9998,131.0709,0,0,0,0,100,0), +(@PATH,14,-1288.53,103.1829,130.9684,0,0,0,0,100,0), +(@PATH,15,-1285.434,96.51299,130.167,0,0,0,0,100,0), +(@PATH,16,-1278.985,90.5309,129.2182,0,0,0,0,100,0), +(@PATH,17,-1270.05,78.55938,128.2815,0,0,0,0,100,0), +(@PATH,18,-1265.084,73.1907,127.7784,0,0,0,0,100,0), +(@PATH,19,-1254.915,70.93072,127.5073,0,0,0,0,100,0), +(@PATH,20,-1245.976,67.87017,127.597,0,0,0,0,100,0), +(@PATH,21,-1240.546,71.20866,128.4701,0,0,0,0,100,0), +(@PATH,22,-1226.207,86.08829,131.2351,0,0,0,0,100,0); + +-- Pathing for Bluff Runner Windstrider Entry: 10881 +SET @NPC := 296158; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1258.878,`position_y`=53.96257,`position_z`=126.9696 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,-1258.878,53.96257,126.9696,0,0,0,0,100,0), +(@PATH,2,-1246.921,65.49854,127.3146,0,0,0,0,100,0), +(@PATH,3,-1224.922,87.38759,131.4201,0,0,0,0,100,0), +(@PATH,4,-1210.1,106.4502,134.0248,0,0,0,0,100,0), +(@PATH,5,-1205.42,118.9444,134.6234,0,0,0,0,100,0), +(@PATH,6,-1210.484,129.9778,134.4786,0,0,0,0,100,0), +(@PATH,7,-1224.14,138.96,133.5122,0,0,0,0,100,0), +(@PATH,8,-1242.753,133.135,132.3845,0,0,0,0,100,0), +(@PATH,9,-1263.65,129.1337,131.7704,0,0,0,0,100,0), +(@PATH,10,-1278.468,122.2129,131.3434,0,0,0,0,100,0), +(@PATH,11,-1292.002,108.5197,131.2184,0,0,0,0,100,0), +(@PATH,12,-1279.579,89.99417,129.1538,0,0,0,0,100,0), +(@PATH,13,-1265.147,72.79845,127.7313,0,0,0,0,100,0), +(@PATH,14,-1246.938,66.75249,127.5057,0,0,0,0,100,0), +(@PATH,15,-1225.265,87.69873,131.4549,0,0,0,0,100,0), +(@PATH,16,-1209.452,106.0079,134.1027,0,0,0,0,100,0), +(@PATH,17,-1204.626,118.8887,134.8138,0,0,0,0,100,0), +(@PATH,18,-1209.993,130.2919,134.5377,0,0,0,0,100,0), +(@PATH,19,-1224.461,137.1348,133.3466,0,0,0,0,100,0), +(@PATH,20,-1242.8,133.8639,132.5454,0,0,0,0,100,0), +(@PATH,21,-1264.648,129.5942,131.8346,0,0,0,0,100,0), +(@PATH,22,-1278.468,122.2129,131.3434,0,0,0,0,100,0), +(@PATH,23,-1291.852,107.387,131.2923,0,0,0,0,100,0), +(@PATH,24,-1279.579,89.99417,129.1538,0,0,0,0,100,0), +(@PATH,25,-1263.634,73.05393,127.683,0,0,0,0,100,0), +(@PATH,26,-1271.103,62.49056,127.4139,0,0,0,0,100,0), +(@PATH,27,-1297.422,60.88097,128.7816,0,0,0,0,100,0), +(@PATH,28,-1323.323,55.73557,129.1248,0,0,0,0,100,0), +(@PATH,29,-1331.505,43.56836,129.2498,0,0,0,0,100,0), +(@PATH,30,-1328.77,28.18235,129.3264,0,0,0,0,100,0), +(@PATH,31,-1321.595,15.01074,130.2241,0,0,0,0,100,0), +(@PATH,32,-1313.24,5.006782,132.5119,0,0,0,0,100,0), +(@PATH,33,-1298.285,0.096191,133.1652,0,0,0,0,100,0), +(@PATH,34,-1285.081,-2.094455,134.2389,0,0,0,0,100,0), +(@PATH,35,-1278.891,-16.22803,140.6322,0,0,0,0,100,0), +(@PATH,36,-1280.531,-31.14063,146.1115,0,0,0,0,100,0), +(@PATH,37,-1281.378,-47.74099,152.1469,0,0,0,0,100,0), +(@PATH,38,-1282.284,-70.57406,157.7889,0,0,0,0,100,0), +(@PATH,39,-1267.707,-79.30664,162.5989,0,0,0,0,100,0), +(@PATH,40,-1254.81,-78.07655,162.9968,0,0,0,0,100,0), +(@PATH,41,-1230.344,-67.61344,162.362,0,0,0,0,100,0), +(@PATH,42,-1228.411,-82.74897,162.6732,0,0,0,0,100,0), +(@PATH,43,-1219.814,-97.4598,162.8417,0,0,0,0,100,0), +(@PATH,44,-1201.539,-100.0939,162.8914,0,0,0,0,100,0), +(@PATH,45,-1192.119,-91.5574,162.7201,0,0,0,0,100,0), +(@PATH,46,-1185.505,-81.63634,162.5458,0,0,0,0,100,0), +(@PATH,47,-1184.035,-66.65267,161.8991,0,0,0,0,100,0), +(@PATH,48,-1188.654,-50.85748,161.8851,0,0,0,0,100,0), +(@PATH,49,-1200.205,-36.68023,162.4079,0,0,0,0,100,0), +(@PATH,50,-1212.299,-33.86388,163.0832,0,0,0,0,100,0), +(@PATH,51,-1222.895,-45.21756,162.9652,0,0,0,0,100,0), +(@PATH,52,-1229.676,-59.19889,162.7106,0,0,0,0,100,0), +(@PATH,53,-1232.164,-69.4713,162.5063,0,0,0,0,100,0), +(@PATH,54,-1253.008,-78.41298,162.9968,0,0,0,0,100,0), +(@PATH,55,-1267.761,-80.29845,162.6551,0,0,0,0,100,0), +(@PATH,56,-1282.326,-71.69173,158.1978,0,0,0,0,100,0), +(@PATH,57,-1282.328,-48.19157,152.4648,0,0,0,0,100,0), +(@PATH,58,-1281.453,-32.22266,146.6115,0,0,0,0,100,0), +(@PATH,59,-1279.59,-15.62592,140.1349,0,0,0,0,100,0), +(@PATH,60,-1286.704,-1.506185,134.0978,0,0,0,0,100,0), +(@PATH,61,-1300.445,0.512207,133.0764,0,0,0,0,100,0), +(@PATH,62,-1314.503,5.982368,132.296,0,0,0,0,100,0), +(@PATH,63,-1328.363,27.15554,129.3264,0,0,0,0,100,0), +(@PATH,64,-1332.204,43.45123,129.2498,0,0,0,0,100,0), +(@PATH,65,-1323.845,55.51096,129.1248,0,0,0,0,100,0), +(@PATH,66,-1297.552,61.62397,128.6603,0,0,0,0,100,0), +(@PATH,67,-1271.48,63.26665,127.5504,0,0,0,0,100,0); + +-- Pathing for Hunter Sagewind Entry: 14440 "aura 131700 not recognized by core, removed" +SET @NPC := 294096; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1375.489,`position_y`=-132.5398,`position_z`=157.9604 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, '18950'); +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,-1375.489,-132.5398,157.9604,0,0,0,0,100,0), +(@PATH,2,-1352.115,-129.1833,158.4093,0,0,0,0,100,0), +(@PATH,3,-1311.418,-123.4469,164.9034,0,0,0,0,100,0), +(@PATH,4,-1286.086,-119.7434,172.3869,0,0,0,0,100,0), +(@PATH,5,-1285.33,-115.9608,172.3128,0,0,0,0,100,0), +(@PATH,6,-1283.061,-111.8655,172.1938,0,0,0,0,100,0), +(@PATH,7,-1279.357,-109.6837,171.7287,0,0,0,0,100,0), +(@PATH,8,-1269.326,-112.9033,171.2784,0,0,0,0,100,0), +(@PATH,9,-1264.503,-111.6969,169.2098,0,0,0,0,100,0), +(@PATH,10,-1255.992,-106.5524,163.0514,0,0,0,0,100,0), +(@PATH,11,-1253.595,-101.1909,163.0514,0,0,0,0,100,0), +(@PATH,12,-1243.678,-93.58719,163.0514,0,0,0,0,100,0), +(@PATH,13,-1238.071,-90.71854,163.3146,0,0,0,0,100,0), +(@PATH,14,-1231.119,-85.39822,163.131,0,0,0,0,100,0), +(@PATH,15,-1229.797,-80.15337,162.7223,0,0,0,0,100,0), +(@PATH,16,-1230.803,-74.38846,162.4679,0,0,0,0,100,0), +(@PATH,17,-1233.884,-71.2646,162.736,0,0,0,0,100,0), +(@PATH,18,-1246.168,-75.74072,162.9968,0,0,0,0,100,0), +(@PATH,19,-1265.824,-79.57894,162.6472,0,0,0,0,100,0), +(@PATH,20,-1270.792,-78.16954,162.0413,0,0,0,0,100,0), +(@PATH,21,-1279.267,-72.93354,158.9534,0,0,0,0,100,0), +(@PATH,22,-1281.973,-67.92285,157.389,0,0,0,0,100,0), +(@PATH,23,-1281.865,-51.9873,153.4743,0,0,0,0,100,0), +(@PATH,24,-1281.236,-38.01367,148.9865,0,0,0,0,100,0), +(@PATH,25,-1280.233,-19.07042,141.6994,0,0,0,0,100,0), +(@PATH,26,-1281.533,-9.700141,137.319,0,0,0,0,100,0), +(@PATH,27,-1284.889,-2.161513,134.2555,0,0,0,0,100,0), +(@PATH,28,-1290.272,-0.314182,133.8122,0,0,0,0,100,0), +(@PATH,29,-1306.318,0.503798,133.2014,0,0,0,0,100,0), +(@PATH,30,-1312.652,2.977376,132.7009,0,0,0,0,100,0), +(@PATH,31,-1318.555,9.27832,131.4863,0,0,0,0,100,0), +(@PATH,32,-1322.317,15.70774,130.129,0,0,0,0,100,0), +(@PATH,33,-1331.561,33.08008,129.2014,0,0,0,0,100,0), +(@PATH,34,-1332.377,40.97087,129.1976,0,0,0,0,100,0), +(@PATH,35,-1330.13,48.34863,129.1248,0,0,0,0,100,0), +(@PATH,36,-1326.043,53.01514,129.1248,0,0,0,0,100,0), +(@PATH,37,-1320.051,56.51899,129.1248,0,0,0,0,100,0), +(@PATH,38,-1294.111,61.94119,128.5353,0,0,0,0,100,0), +(@PATH,39,-1280.305,63.5906,128.6093,0,0,0,0,100,0), +(@PATH,40,-1272.958,62.58458,127.7955,0,0,0,0,100,0), +(@PATH,41,-1264.597,57.01161,127.0077,0,0,0,0,100,0), +(@PATH,42,-1262.197,53.84033,127.1327,0,0,0,0,100,0), +(@PATH,43,-1259.856,41.54655,128.69,0,0,0,0,100,0), +(@PATH,44,-1259.313,29.37592,128.1867,0,0,0,0,100,0), +(@PATH,45,-1259.219,41.55219,128.6997,0,0,0,0,100,0), +(@PATH,46,-1258.856,52.80089,127.1327,0,0,0,0,100,0), +(@PATH,47,-1254.1,55.04579,127.0077,0,0,0,0,100,0), +(@PATH,48,-1249.109,59.78532,127.0077,0,0,0,0,100,0), +(@PATH,49,-1240.831,71.07861,128.4047,0,0,0,0,100,0), +(@PATH,50,-1227.747,83.32438,130.7184,0,0,0,0,100,0), +(@PATH,51,-1219.242,93.15039,132.6743,0,0,0,0,100,0), +(@PATH,52,-1210.484,102.547,134.2899,0,0,0,0,100,0), +(@PATH,53,-1205.315,112.3989,134.474,0,0,0,0,100,0), +(@PATH,54,-1205.015,121.0895,134.7599,0,0,0,0,100,0), +(@PATH,55,-1208.755,130.1042,134.761,0,0,0,0,100,0), +(@PATH,56,-1222.167,137.1916,133.4716,0,0,0,0,100,0), +(@PATH,57,-1232.732,137.4404,132.8562,0,0,0,0,100,0), +(@PATH,58,-1248.789,133.9221,132.5525,0,0,0,0,100,0), +(@PATH,59,-1268.939,128.0604,131.5082,0,0,0,0,100,0), +(@PATH,60,-1282.543,119.6118,131.2184,0,0,0,0,100,0), +(@PATH,61,-1290.175,110.5285,131.2184,0,0,0,0,100,0), +(@PATH,62,-1291.106,102.4149,130.9456,0,0,0,0,100,0), +(@PATH,63,-1287.146,95.84003,130.167,0,0,0,0,100,0), +(@PATH,64,-1280.598,88.9515,129.0287,0,0,0,0,100,0), +(@PATH,65,-1274.162,81.09858,128.4612,0,0,0,0,100,0), +(@PATH,66,-1269.387,71.75049,127.8059,0,0,0,0,100,0), +(@PATH,67,-1271.207,54.94119,128.1844,0,0,0,0,100,0), +(@PATH,68,-1276.225,51.25407,129.1603,0,0,0,0,100,0), +(@PATH,69,-1283.727,46.40356,129.2086,0,0,0,0,100,0), +(@PATH,70,-1292.718,40.68869,129.2086,0,0,0,0,100,0), +(@PATH,71,-1297.672,33.29639,129.2086,0,0,0,0,100,0), +(@PATH,72,-1309.76,26.98738,137.4356,0,0,0,0,100,0), +(@PATH,73,-1319.586,30.66168,137.4361,0,0,0,0,100,0), +(@PATH,74,-1325.355,27.73991,138.3821,0,0,0,0,100,0), +(@PATH,75,-1327.171,20.55952,138.5337,0,0,0,0,100,0), +(@PATH,76,-1352.524,-8.205566,141.3372,0,0,0,0,100,0), +(@PATH,77,-1371.899,-30.60791,149.9383,0,0,0,0,100,0), +(@PATH,78,-1388.581,-48.84945,160.4556,0,0,0,0,100,0), +(@PATH,79,-1397.396,-61.97852,158.2617,0,0,0,0,100,0), +(@PATH,80,-1396.854,-67.23329,158.9467,0,0,0,0,100,0), +(@PATH,81,-1393.429,-73.18484,159.0717,0,0,0,0,100,0), +(@PATH,82,-1393.084,-85.30995,158.9641,0,0,0,0,100,0), +(@PATH,83,-1395.922,-100.5414,158.9394,0,0,0,0,100,0), +(@PATH,84,-1398.038,-109.7275,158.9394,0,0,0,0,100,0), +(@PATH,85,-1399.135,-117.3146,158.9394,0,0,0,0,100,0), +(@PATH,86,-1395.972,-122.7384,158.9394,0,0,0,0,100,0), +(@PATH,87,-1389.042,-129.3561,157.1846,0,0,0,0,100,0), +(@PATH,88,-1381.5,-133.2744,157.201,0,0,0,0,100,0); + +-- Pathing for Hunter Ragetotem Entry: 14441 "aura 131700 not recognized by core, removed" +SET @NPC := 296151; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1167.841,`position_y`=161.6249,`position_z`=143.4065 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, '18950'); +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,-1167.841,161.6249,143.4065,0,0,0,0,100,0), +(@PATH,2,-1178.765,162.6763,142.9561,0,0,0,0,100,0), +(@PATH,3,-1190.215,153.6681,134.7292,0,0,0,0,100,0), +(@PATH,4,-1191.735,146.347,134.7292,0,0,0,0,100,0), +(@PATH,5,-1199.341,138.694,134.7292,0,0,0,0,100,0), +(@PATH,6,-1205.376,134.4514,134.7216,0,0,0,0,100,0), +(@PATH,7,-1209.814,126.2418,134.309,0,0,0,0,100,0), +(@PATH,8,-1208.046,118.7831,134.2711,0,0,0,0,100,0), +(@PATH,9,-1212.059,105.7136,133.7916,0,0,0,0,100,0), +(@PATH,10,-1216.344,98.72794,133.377,0,0,0,0,100,0), +(@PATH,11,-1234.09,81.05469,130.308,0,0,0,0,100,0), +(@PATH,12,-1241.854,72.30013,128.5867,0,0,0,0,100,0), +(@PATH,13,-1253.151,60.75087,127.1759,0,0,0,0,100,0), +(@PATH,14,-1258.839,51.54568,127.1327,0,0,0,0,100,0), +(@PATH,15,-1259.932,41.33154,128.7636,0,0,0,0,100,0), +(@PATH,16,-1259.208,34.97738,128.1867,0,0,0,0,100,0), +(@PATH,17,-1260.225,27.58393,128.1867,0,0,0,0,100,0), +(@PATH,18,-1258.589,23.34179,128.1867,0,0,0,0,100,0), +(@PATH,19,-1256.339,27.28451,128.1867,0,0,0,0,100,0), +(@PATH,20,-1258.648,34.91889,128.1867,0,0,0,0,100,0), +(@PATH,21,-1259.524,40.34256,128.9547,0,0,0,0,100,0), +(@PATH,22,-1260.083,51.44347,127.1327,0,0,0,0,100,0), +(@PATH,23,-1255.362,56.66602,127.0077,0,0,0,0,100,0), +(@PATH,24,-1247.315,61.93338,127.1272,0,0,0,0,100,0), +(@PATH,25,-1241.214,61.31386,127.303,0,0,0,0,100,0), +(@PATH,26,-1221.129,47.44298,129.2766,0,0,0,0,100,0), +(@PATH,27,-1208.297,38.08008,132.1388,0,0,0,0,100,0), +(@PATH,28,-1206.364,32.85845,132.4149,0,0,0,0,100,0), +(@PATH,29,-1205.495,26.73899,135.103,0,0,0,0,100,0), +(@PATH,30,-1201.628,23.81632,138.4122,0,0,0,0,100,0), +(@PATH,31,-1197.447,23.4534,141.5278,0,0,0,0,100,0), +(@PATH,32,-1193.806,23.91244,144.2954,0,0,0,0,100,0), +(@PATH,33,-1191.07,26.95779,146.7465,0,0,0,0,100,0), +(@PATH,34,-1193.707,24.02181,144.3624,0,0,0,0,100,0), +(@PATH,35,-1191.07,26.95779,146.7465,0,0,0,0,100,0), +(@PATH,36,-1189.09,29.62592,147.6621,0,0,0,0,100,0), +(@PATH,37,-1183.189,30.96446,147.7551,0,0,0,0,100,0), +(@PATH,38,-1161.798,33.28754,145.7501,0,0,0,0,100,0), +(@PATH,39,-1148.865,29.92654,145.4776,0,0,0,0,100,0), +(@PATH,40,-1140.956,29.2034,144.3297,0,0,0,0,100,0), +(@PATH,41,-1133.411,27.82357,143.4471,0,0,0,0,100,0), +(@PATH,42,-1127.305,24.2053,142.8582,0,0,0,0,100,0), +(@PATH,43,-1120.222,17.69086,142.1165,0,0,0,0,100,0), +(@PATH,44,-1113.677,11.56999,141.8019,0,0,0,0,100,0), +(@PATH,45,-1111.42,5.87576,141.9673,0,0,0,0,100,0), +(@PATH,46,-1112.057,1.321343,142.465,0,0,0,0,100,0), +(@PATH,47,-1110.251,-2.610569,142.3773,0,0,0,0,100,0), +(@PATH,48,-1106.939,-0.784614,141.7618,0,0,0,0,100,0), +(@PATH,49,-1104.623,7.139323,140.9999,0,0,0,0,100,0), +(@PATH,50,-1110.352,15.91493,141.3566,0,0,0,0,100,0), +(@PATH,51,-1107.553,11.62776,141.2706,0,0,0,0,100,0), +(@PATH,52,-1110.352,15.91493,141.3566,0,0,0,0,100,0), +(@PATH,53,-1116.466,20.93989,141.8405,0,0,0,0,100,0), +(@PATH,54,-1121.467,32.77984,142.4403,0,0,0,0,100,0), +(@PATH,55,-1124.971,47.58681,142.5072,0,0,0,0,100,0), +(@PATH,56,-1123.432,64.49262,142.1375,0,0,0,0,100,0), +(@PATH,57,-1122.345,71.42583,143.4737,0,0,0,0,100,0), +(@PATH,58,-1119.743,78.72266,143.4737,0,0,0,0,100,0), +(@PATH,59,-1121.472,87.91599,143.4737,0,0,0,0,100,0), +(@PATH,60,-1117.786,103.8126,151.7006,0,0,0,0,100,0), +(@PATH,61,-1108.453,108.3363,151.7011,0,0,0,0,100,0), +(@PATH,62,-1106.692,113.7536,152.628,0,0,0,0,100,0), +(@PATH,63,-1110.269,120.5043,152.7929,0,0,0,0,100,0), +(@PATH,64,-1100.422,130.8757,147.3352,0,0,0,0,100,0), +(@PATH,65,-1075.436,153.9533,139.7017,0,0,0,0,100,0), +(@PATH,66,-1051.596,175.9229,137.0877,0,0,0,0,100,0), +(@PATH,67,-1014.593,211.108,135.0765,0,0,0,0,100,0), +(@PATH,68,-1008.401,216.6724,134.9311,0,0,0,0,100,0), +(@PATH,69,-988.5367,216.2324,135.4837,0,0,0,0,100,0), +(@PATH,70,-982.7355,217.5418,135.5046,0,0,0,0,100,0), +(@PATH,71,-975.3752,224.543,135.316,0,0,0,0,100,0), +(@PATH,72,-974.1374,230.8015,135.1811,0,0,0,0,100,0), +(@PATH,73,-984.9152,228.8126,135.1811,0,0,0,0,100,0), +(@PATH,74,-995.3485,224.103,134.8061,0,0,0,0,100,0), +(@PATH,75,-1001.282,223.7431,134.6811,0,0,0,0,100,0), +(@PATH,76,-1019.577,235.4714,134.6811,0,0,0,0,100,0), +(@PATH,77,-1039.268,243.8603,134.7968,0,0,0,0,100,0), +(@PATH,78,-1048.538,248.8276,133.0136,0,0,0,0,100,0), +(@PATH,79,-1051.564,252.7377,129.3718,0,0,0,0,100,0), +(@PATH,80,-1057.529,253.4063,123.6718,0,0,0,0,100,0), +(@PATH,81,-1066.415,250.3656,120.1294,0,0,0,0,100,0), +(@PATH,82,-1068.113,240.502,116.4099,0,0,0,0,100,0), +(@PATH,83,-1069.73,228.6191,112.7323,0,0,0,0,100,0), +(@PATH,84,-1077.42,223.9896,111.7814,0,0,0,0,100,0), +(@PATH,85,-1101.324,209.8367,113.8393,0,0,0,0,100,0), +(@PATH,86,-1127.783,193.9779,121.8197,0,0,0,0,100,0), +(@PATH,87,-1152.073,179.6105,135.0552,0,0,0,0,100,0), +(@PATH,88,-1162.57,172.9139,144.0772,0,0,0,0,100,0), +(@PATH,89,-1163.698,169.4588,143.9842,0,0,0,0,100,0), +(@PATH,90,-1164.306,164.5095,143.8734,0,0,0,0,100,0); + +-- Pathing for Hunter Thunderhorn Entry: 14442 "aura 131700 not recognized by core, removed" +SET @NPC := 294078; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1259.486,`position_y`=51.38151,`position_z`=127.1327 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, '18950'); +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,-1259.486,51.38151,127.1327,0,0,0,0,100,0), +(@PATH,2,-1243.07,70.7277,128.252,0,0,0,0,100,0), +(@PATH,3,-1231.286,83.68558,130.6075,0,0,0,0,100,0), +(@PATH,4,-1216.419,99.29867,133.3589,0,0,0,0,100,0), +(@PATH,5,-1203.995,115.2392,134.7574,0,0,0,0,100,0), +(@PATH,6,-1197.238,119.8963,135.2329,0,0,0,0,100,0), +(@PATH,7,-1186.136,120.3802,135.2329,0,0,0,0,100,0), +(@PATH,8,-1170.124,116.7778,135.1079,0,0,0,0,100,0), +(@PATH,9,-1155.805,116.0076,135.0756,0,0,0,0,100,0), +(@PATH,10,-1136.634,116.1646,136.1415,0,0,0,0,100,0), +(@PATH,11,-1120.771,119.8341,139.9724,0,0,0,0,100,0), +(@PATH,12,-1108.172,117.1498,140.9315,0,0,0,0,100,0), +(@PATH,13,-1096.78,112.9994,141.7975,0,0,0,0,100,0), +(@PATH,14,-1093.707,105.1408,141.5309,0,0,0,0,100,0), +(@PATH,15,-1092.476,96.03616,141.3059,0,0,0,0,100,0), +(@PATH,16,-1096.028,84.47914,141.1926,0,0,0,0,100,0), +(@PATH,17,-1096.377,75.61024,140.8962,0,0,0,0,100,0), +(@PATH,18,-1091.635,67.16249,140.4548,0,0,0,0,100,0), +(@PATH,19,-1081.035,51.89074,139.9196,0,0,0,0,100,0), +(@PATH,20,-1072.204,42.72542,140.5675,0,0,0,0,100,0), +(@PATH,21,-1067.31,34.48416,140.9047,0,0,0,0,100,0), +(@PATH,22,-1064.471,18.85959,140.7527,0,0,0,0,100,0), +(@PATH,23,-1068.285,-2.218696,141.0147,0,0,0,0,100,0), +(@PATH,24,-1072.427,-8.725261,140.3592,0,0,0,0,100,0), +(@PATH,25,-1082.086,-7.882921,140.2101,0,0,0,0,100,0), +(@PATH,26,-1092.959,-3.528212,140.7186,0,0,0,0,100,0), +(@PATH,27,-1101.286,2.018175,141.0187,0,0,0,0,100,0), +(@PATH,28,-1106.644,3.601454,141.5367,0,0,0,0,100,0), +(@PATH,29,-1109.278,2.166504,141.9053,0,0,0,0,100,0), +(@PATH,30,-1107.439,-13.06809,142.3292,0,0,0,0,100,0), +(@PATH,31,-1104.005,-25.66287,142.6365,0,0,0,0,100,0), +(@PATH,32,-1096.249,-32.88281,142.6365,0,0,0,0,100,0), +(@PATH,33,-1093.047,-46.64057,150.8634,0,0,0,0,100,0), +(@PATH,34,-1098.783,-55.25911,150.864,0,0,0,0,100,0), +(@PATH,35,-1097.167,-61.27892,151.8013,0,0,0,0,100,0), +(@PATH,36,-1090.76,-64.85281,151.9581,0,0,0,0,100,0), +(@PATH,37,-1082.068,-89.77338,150.3313,0,0,0,0,100,0), +(@PATH,38,-1069.597,-125.5501,152.1198,0,0,0,0,100,0), +(@PATH,39,-1053.913,-172.2744,157.4472,0,0,0,0,100,0), +(@PATH,40,-1047.34,-192.9697,161.0418,0,0,0,0,100,0), +(@PATH,41,-1044.949,-203.2544,159.3935,0,0,0,0,100,0), +(@PATH,42,-1046.567,-211.7357,159.0621,0,0,0,0,100,0), +(@PATH,43,-1045.135,-203.644,159.3581,0,0,0,0,100,0), +(@PATH,44,-1046.567,-211.7357,159.0621,0,0,0,0,100,0), +(@PATH,45,-1051.755,-221.9485,159.1639,0,0,0,0,100,0), +(@PATH,46,-1057.963,-231.8425,159.0621,0,0,0,0,100,0), +(@PATH,47,-1061.391,-236.4969,159.1553,0,0,0,0,100,0), +(@PATH,48,-1065.879,-235.2124,159.1553,0,0,0,0,100,0), +(@PATH,49,-1078.782,-219.1967,159.0481,0,0,0,0,100,0), +(@PATH,50,-1087.905,-207.1613,160.8583,0,0,0,0,100,0), +(@PATH,51,-1102.25,-178.054,160.4023,0,0,0,0,100,0), +(@PATH,52,-1115.324,-153.0123,163.4372,0,0,0,0,100,0), +(@PATH,53,-1129.203,-125.7353,170.9185,0,0,0,0,100,0), +(@PATH,54,-1131.364,-122.7924,171.8494,0,0,0,0,100,0), +(@PATH,55,-1138.936,-123.7988,171.6762,0,0,0,0,100,0), +(@PATH,56,-1144.008,-121.24,170.7483,0,0,0,0,100,0), +(@PATH,57,-1145.081,-110.9961,170.7479,0,0,0,0,100,0), +(@PATH,58,-1156.763,-101.9834,162.5208,0,0,0,0,100,0), +(@PATH,59,-1165.729,-101.8523,162.5208,0,0,0,0,100,0), +(@PATH,60,-1173.937,-97.32438,162.5208,0,0,0,0,100,0), +(@PATH,61,-1182.401,-90.93783,162.8964,0,0,0,0,100,0), +(@PATH,62,-1183.829,-87.30686,162.924,0,0,0,0,100,0), +(@PATH,63,-1183.009,-83.80659,162.7724,0,0,0,0,100,0), +(@PATH,64,-1181.353,-74.15723,162.5072,0,0,0,0,100,0), +(@PATH,65,-1183.95,-61.94233,161.6708,0,0,0,0,100,0), +(@PATH,66,-1189.567,-45.25846,162.0524,0,0,0,0,100,0), +(@PATH,67,-1193.762,-40.22396,162.392,0,0,0,0,100,0), +(@PATH,68,-1204.755,-33.12527,162.9127,0,0,0,0,100,0), +(@PATH,69,-1206.559,-29.40256,163.4845,0,0,0,0,100,0), +(@PATH,70,-1204.628,-11.35889,165.5753,0,0,0,0,100,0), +(@PATH,71,-1200.17,6.31174,165.2775,0,0,0,0,100,0), +(@PATH,72,-1197.892,17.1601,164.5298,0,0,0,0,100,0), +(@PATH,73,-1196.825,21.97195,164.8516,0,0,0,0,100,0), +(@PATH,74,-1193.397,25.11268,165.1991,0,0,0,0,100,0), +(@PATH,75,-1190.754,28.38341,167.6798,0,0,0,0,100,0), +(@PATH,76,-1189.99,32.12538,170.1974,0,0,0,0,100,0), +(@PATH,77,-1192.071,35.70432,172.6337,0,0,0,0,100,0), +(@PATH,78,-1194.509,38.04579,174.2306,0,0,0,0,100,0), +(@PATH,79,-1199.057,38.35183,176.1871,0,0,0,0,100,0), +(@PATH,80,-1202.954,35.31521,176.9488,0,0,0,0,100,0), +(@PATH,81,-1204.153,29.59147,176.9488,0,0,0,0,100,0), +(@PATH,82,-1200.22,26.68316,176.9488,0,0,0,0,100,0), +(@PATH,83,-1198.514,28.61214,176.9488,0,0,0,0,100,0), +(@PATH,84,-1202.456,30.02794,176.9488,0,0,0,0,100,0), +(@PATH,85,-1203.889,33.63704,176.9488,0,0,0,0,100,0), +(@PATH,86,-1200.685,37.83465,176.9488,0,0,0,0,100,0), +(@PATH,87,-1196.425,39.04297,174.9841,0,0,0,0,100,0), +(@PATH,88,-1192.549,37.25575,173.1237,0,0,0,0,100,0), +(@PATH,89,-1190.065,34.2188,171.2341,0,0,0,0,100,0), +(@PATH,90,-1189.341,29.86925,168.6213,0,0,0,0,100,0), +(@PATH,91,-1191.092,26.71832,166.6984,0,0,0,0,100,0), +(@PATH,92,-1195.344,23.7895,164.8516,0,0,0,0,100,0), +(@PATH,93,-1199.182,24.22323,164.8516,0,0,0,0,100,0), +(@PATH,94,-1202.597,25.58078,162.9543,0,0,0,0,100,0), +(@PATH,95,-1204.215,29.72776,161.0335,0,0,0,0,100,0), +(@PATH,96,-1203.709,33.97407,158.3441,0,0,0,0,100,0), +(@PATH,97,-1200.798,37.89762,154.6641,0,0,0,0,100,0), +(@PATH,98,-1196.374,38.65115,152.1037,0,0,0,0,100,0), +(@PATH,99,-1191.988,36.301,149.5629,0,0,0,0,100,0), +(@PATH,100,-1189.595,31.73269,147.7582,0,0,0,0,100,0), +(@PATH,101,-1190.462,27.47298,147.1214,0,0,0,0,100,0), +(@PATH,102,-1193.779,24.13601,144.3455,0,0,0,0,100,0), +(@PATH,103,-1198.37,23.36914,140.6536,0,0,0,0,100,0), +(@PATH,104,-1203.384,24.72283,136.6647,0,0,0,0,100,0), +(@PATH,105,-1206.116,28.38157,134.0847,0,0,0,0,100,0), +(@PATH,106,-1205.772,34.68528,132.1388,0,0,0,0,100,0), +(@PATH,107,-1210.074,39.35759,132.1387,0,0,0,0,100,0), +(@PATH,108,-1227.809,51.19651,127.9477,0,0,0,0,100,0), +(@PATH,109,-1239.222,58.67437,127.1111,0,0,0,0,100,0), +(@PATH,110,-1245.954,59.99989,127.1808,0,0,0,0,100,0), +(@PATH,111,-1249.308,58.57867,127.0077,0,0,0,0,100,0), +(@PATH,112,-1257.922,52.69971,127.1459,0,0,0,0,100,0), +(@PATH,113,-1259.854,49.25141,127.1327,0,0,0,0,100,0), +(@PATH,114,-1259.666,41.8788,128.5775,0,0,0,0,100,0), +(@PATH,115,-1259.127,36.24279,128.6582,0,0,0,0,100,0), +(@PATH,116,-1256.275,30.82943,128.1867,0,0,0,0,100,0), +(@PATH,117,-1256.488,25.99566,128.1867,0,0,0,0,100,0), +(@PATH,118,-1259.284,25.65365,128.1867,0,0,0,0,100,0), +(@PATH,119,-1260.783,30.70188,128.1867,0,0,0,0,100,0), +(@PATH,120,-1259.215,35.09592,128.1867,0,0,0,0,100,0), +(@PATH,121,-1259.715,40.28527,128.9636,0,0,0,0,100,0); + +-- Fix inhabittype for Thunder Bluff Wind Rider +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (51372); + +-- Pathing for Thunder Bluff Wind Rider Entry: 51372 "aura 131700 not recognized by core, removed" +SET @NPC := 296146; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1417.078,`position_y`=-18.11111,`position_z`=184.4353 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,17722,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,-1417.078,-18.11111,184.4353,0,0,1,0,100,0), +(@PATH,2,-1436.609,-14.96701,186.4338,0,0,1,0,100,0), +(@PATH,3,-1468.274,-25.95486,185.8369,0,0,1,0,100,0), +(@PATH,4,-1489.781,-52.39236,188.5078,0,0,1,0,100,0), +(@PATH,5,-1497.965,-87.47049,191.7911,0,0,1,0,100,0), +(@PATH,6,-1477.455,-118.5972,195.0898,0,0,1,0,100,0), +(@PATH,7,-1442.842,-141.3438,193.962,0,0,1,0,100,0), +(@PATH,8,-1403.743,-156.1944,197.7758,0,0,1,0,100,0), +(@PATH,9,-1375.972,-142.7674,194.7504,0,0,1,0,100,0), +(@PATH,10,-1357.45,-111.5069,192.5731,0,0,1,0,100,0), +(@PATH,11,-1353.234,-81.35416,187.5975,0,0,1,0,100,0), +(@PATH,12,-1344.752,-41.75347,173.9982,0,0,1,0,100,0), +(@PATH,13,-1318.665,7.222222,159.4861,0,0,1,0,100,0), +(@PATH,14,-1287.045,26.0625,161.7571,0,0,1,0,100,0), +(@PATH,15,-1249.658,38.51042,163.2084,0,0,1,0,100,0), +(@PATH,16,-1207.972,69.44791,167.305,0,0,1,0,100,0), +(@PATH,17,-1182.484,100.2188,175.308,0,0,1,0,100,0), +(@PATH,18,-1167.328,127.9479,179.7405,0,0,1,0,100,0), +(@PATH,19,-1174.524,167.9931,181.2497,0,0,1,0,100,0), +(@PATH,20,-1198.266,196.0885,179.153,0,0,1,0,100,0), +(@PATH,21,-1236.556,201.5382,172.436,0,0,1,0,100,0), +(@PATH,22,-1274.465,182.1059,172.3115,0,0,1,0,100,0), +(@PATH,23,-1304.231,136.151,172.9154,0,0,1,0,100,0), +(@PATH,24,-1329.96,85.82986,169.302,0,0,1,0,100,0), +(@PATH,25,-1339.682,41.7934,173.7802,0,0,1,0,100,0), +(@PATH,26,-1366,-1.618056,178.4018,0,0,1,0,100,0), +(@PATH,27,-1391.354,-19.05556,182.3401,0,0,1,0,100,0); + +-- Pathing for Thunder Bluff Wind Rider Entry: 51372 "aura 131700 not recognized by core, removed" +SET @NPC := 294079; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1031.21,`position_y`=317.0573,`position_z`=171.1705 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,17722,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,-1031.21,317.0573,171.1705,0,0,1,0,100,0), +(@PATH,2,-1048.405,300.1736,171.112,0,0,1,0,100,0), +(@PATH,3,-1079.53,264.9774,167.6202,0,0,1,0,100,0), +(@PATH,4,-1090.651,223.9201,168.5811,0,0,1,0,100,0), +(@PATH,5,-1107.998,186.7986,173.2897,0,0,1,0,100,0), +(@PATH,6,-1131.382,155.9271,178.1583,0,0,1,0,100,0), +(@PATH,7,-1156.747,108.7049,187.258,0,0,1,0,100,0), +(@PATH,8,-1157.385,79.94271,191.4664,0,0,1,0,100,0), +(@PATH,9,-1156.021,44.90104,199.9593,0,0,1,0,100,0), +(@PATH,10,-1145.019,14.60417,200.7749,0,0,1,0,100,0), +(@PATH,11,-1131.575,-15.08854,197.5964,0,0,1,0,100,0), +(@PATH,12,-1100.957,-49.31424,177.8867,0,0,1,0,100,0), +(@PATH,13,-1064.847,-66.5434,168.118,0,0,1,0,100,0), +(@PATH,14,-1033.754,-61.82465,160.7301,0,0,1,0,100,0), +(@PATH,15,-1015.139,-28.8941,159.5357,0,0,1,0,100,0), +(@PATH,16,-1030.493,1.427083,167.0528,0,0,1,0,100,0), +(@PATH,17,-1059.783,25.27083,172.8458,0,0,1,0,100,0), +(@PATH,18,-1082.262,56.83333,177.7353,0,0,1,0,100,0), +(@PATH,19,-1089.927,94.21528,179.2594,0,0,1,0,100,0), +(@PATH,20,-1074.252,131.0469,176.131,0,0,1,0,100,0), +(@PATH,21,-1030.398,167.3872,174.0305,0,0,1,0,100,0), +(@PATH,22,-995.5886,165.7257,175.3455,0,0,1,0,100,0), +(@PATH,23,-962.9792,177.5903,172.3385,0,0,1,0,100,0), +(@PATH,24,-925.0538,206.6111,173.7793,0,0,1,0,100,0), +(@PATH,25,-910.5052,259.0121,170.6645,0,0,1,0,100,0), +(@PATH,26,-927.132,300.3681,173.0399,0,0,1,0,100,0), +(@PATH,27,-957.9219,325.2465,173.1504,0,0,1,0,100,0), +(@PATH,28,-997.0087,331.1649,171.705,0,0,1,0,100,0); + +-- Pathing for Thunder Bluff Wind Rider Entry: 51372 "aura 131700 not recognized by core, removed" +SET @NPC := 294088; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1123.807,`position_y`=-269.5642,`position_z`=191.6082 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,17722,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,-1123.807,-269.5642,191.6082,0,0,1,0,100,0), +(@PATH,2,-1116.502,-296.8229,195.1985,0,0,1,0,100,0), +(@PATH,3,-1104.59,-331.0226,200.0352,0,0,1,0,100,0), +(@PATH,4,-1082.51,-356.6476,200.981,0,0,1,0,100,0), +(@PATH,5,-1039.986,-350.4653,202.4225,0,0,1,0,100,0), +(@PATH,6,-1022.295,-322.8594,205.6428,0,0,1,0,100,0), +(@PATH,7,-1013.385,-279.2639,208.4327,0,0,1,0,100,0), +(@PATH,8,-1025.509,-230.276,211.0327,0,0,1,0,100,0), +(@PATH,9,-1046.434,-205.7535,207.125,0,0,1,0,100,0), +(@PATH,10,-1085.05,-170.0017,191.2937,0,0,1,0,100,0), +(@PATH,11,-1114.507,-106.8698,183.8562,0,0,1,0,100,0), +(@PATH,12,-1125.021,-61.37847,184.6177,0,0,1,0,100,0), +(@PATH,13,-1141.194,-23.80729,190.0884,0,0,1,0,100,0), +(@PATH,14,-1174.042,-2.710069,194.8735,0,0,1,0,100,0), +(@PATH,15,-1210.813,10.04688,201.3769,0,0,1,0,100,0), +(@PATH,16,-1260.837,7.354167,203.9013,0,0,1,0,100,0), +(@PATH,17,-1278.115,-27.91146,202.9475,0,0,1,0,100,0), +(@PATH,18,-1288.186,-59.77431,197.0889,0,0,1,0,100,0), +(@PATH,19,-1297.116,-95.37847,191.9555,0,0,1,0,100,0), +(@PATH,20,-1294.352,-121.4931,188.484,0,0,1,0,100,0), +(@PATH,21,-1279.861,-153.1858,184.9046,0,0,1,0,100,0), +(@PATH,22,-1253.339,-165.3351,186.0327,0,0,1,0,100,0), +(@PATH,23,-1206.472,-162.2708,188.6352,0,0,1,0,100,0), +(@PATH,24,-1174.734,-151.9774,190.9774,0,0,1,0,100,0), +(@PATH,25,-1137.872,-143.1354,201.0835,0,0,1,0,100,0), +(@PATH,26,-1119.828,-174.0417,189.8213,0,0,1,0,100,0), +(@PATH,27,-1125.851,-223.0087,185.4579,0,0,1,0,100,0); + +-- Pathing for Thunder Bluff Wind Rider Entry: 51372 "aura 131700 not recognized by core, removed" +SET @NPC := 294048; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1099.75,`position_y`=-155.7135,`position_z`=173.3801 WHERE `guid`=@NPC; +UPDATE `creature` SET `position_x`=-1099.75,`position_y`=-155.7135,`position_z`=173.3801 WHERE `guid`=294049; +UPDATE `creature` SET `position_x`=-1099.75,`position_y`=-155.7135,`position_z`=173.3801 WHERE `guid`=294050; +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,294049,294050); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,17722,50331648,257,0, ''),(294049,0,17722,50331648,257,0, ''),(294050,0,17722,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,-1099.75,-155.7135,173.3801,0,0,1,0,100,0), +(@PATH,2,-1068.837,-125.3941,173.3801,0,0,1,0,100,0), +(@PATH,3,-1042.913,-97.09722,162.3508,0,0,1,0,100,0), +(@PATH,4,-1012.832,-68.86111,157.5533,0,0,1,0,100,0), +(@PATH,5,-994.1024,-12.62847,158.4198,0,0,1,0,100,0), +(@PATH,6,-998.2952,40.09549,159.0415,0,0,1,0,100,0), +(@PATH,7,-1013.101,96.52778,160.7092,0,0,1,0,100,0), +(@PATH,8,-1039.629,130.1424,159.0218,0,0,1,0,100,0), +(@PATH,9,-1083.538,173.9983,153.7438,0,0,1,0,100,0), +(@PATH,10,-1134.936,209.8819,145.4356,0,0,1,0,100,0), +(@PATH,11,-1189.507,220.3177,143.0779,0,0,1,0,100,0), +(@PATH,12,-1237.073,217.0799,143.2438,0,0,1,0,100,0), +(@PATH,13,-1287.155,215.9601,146.3297,0,0,1,0,100,0), +(@PATH,14,-1341.92,185.6771,154.3212,0,0,1,0,100,0), +(@PATH,15,-1386.392,109.0486,173.3801,0,0,1,0,100,0), +(@PATH,16,-1381.66,52.37847,167.1563,0,0,1,0,100,0), +(@PATH,17,-1362.241,-9.026042,162.1116,0,0,1,0,100,0), +(@PATH,18,-1343.759,-58.1632,165.8197,0,0,1,0,100,0), +(@PATH,19,-1340.538,-113.0191,177.6952,0,0,1,0,100,0), +(@PATH,20,-1320.969,-164.0313,184.2877,0,0,1,0,100,0), +(@PATH,21,-1267.528,-204.2986,172.2366,0,0,1,0,100,0), +(@PATH,22,-1227.717,-218.7222,170.3509,0,0,1,0,100,0), +(@PATH,23,-1177.925,-216.4583,173.3801,0,0,1,0,100,0), +(@PATH,24,-1132.208,-186.8559,173.3801,0,0,1,0,100,0); +-- Set Formation/Group Combat Assistance +DELETE FROM `creature_formations` WHERE `leaderGUID`=294048; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES +(294048,294048,0,0,2), +(294048,294049,6,90,2), +(294048,294050,6,270,2); + +-- Pathing for Thunder Bluff Wind Rider Entry: 51372 "aura 131700 not recognized by core, removed" +SET @NPC := 294093; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1223.196,`position_y`=-73.2066,`position_z`=195.7438 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-1223.196,`position_y`=-73.2066,`position_z`=195.7438 WHERE `guid`=294114; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=-1223.196,`position_y`=-73.2066,`position_z`=195.7438 WHERE `guid`=294115; +DELETE FROM `creature_addon` WHERE `guid` IN (@NPC,294114,294115); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(@NPC,@PATH,17722,50331648,257,0, ''),(294114,0,17722,50331648,257,0, ''),(294115,0,17722,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,-1223.196,-73.2066,195.7438,0,0,1,0,100,0), +(@PATH,2,-1202.531,-80.63021,185.0626,0,0,1,0,100,0), +(@PATH,3,-1175.901,-70.31944,190.7694,0,0,1,0,100,0), +(@PATH,4,-1148.941,-54.10243,195.5614,0,0,1,0,100,0), +(@PATH,5,-1135.793,-20.85417,183.8645,0,0,1,0,100,0), +(@PATH,6,-1119.25,13.47743,167.6844,0,0,1,0,100,0), +(@PATH,7,-1129.97,47.89063,171.0626,0,0,1,0,100,0), +(@PATH,8,-1140.729,72.10416,182.831,0,0,1,0,100,0), +(@PATH,9,-1156.026,103.816,195.5614,0,0,1,0,100,0), +(@PATH,10,-1193.05,117.224,179.086,0,0,1,0,100,0), +(@PATH,11,-1226.144,100.5903,161.68,0,0,1,0,100,0), +(@PATH,12,-1263.892,92.24306,160.3628,0,0,1,0,100,0), +(@PATH,13,-1274.292,64.37153,169.613,0,0,1,0,100,0), +(@PATH,14,-1270.033,26.55382,175.9639,0,0,1,0,100,0), +(@PATH,15,-1269.523,-14.7934,183.9901,0,0,1,0,100,0), +(@PATH,16,-1257.847,-35.54514,196.072,0,0,1,0,100,0), +(@PATH,17,-1239.849,-54.03299,202.0167,0,0,1,0,100,0); +-- Set Formation/Group Combat Assistance +DELETE FROM `creature_formations` WHERE `leaderGUID`=294093; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES +(294093,294093,0,0,2), +(294093,294114,6,90,2), +(294093,294115,6,270,2); |