DB/Waypoints:

Path for Gnarl Leafbrother in Feralas Closes #8528
Path for Antilus the Soarer in Feralas Closes #8525
Guards and Path for Achellios the Banished Closes #8524
Path for Galak Messenger Closes #8523
Path for XT-9 in Stonetalon Mountains Closes #8512
Path for Uruson in Teldrassil Closes #8502
Path for Snake vendor in Orgrimmar Closes #8501
Pathing for Threggil in Teldrassil Closes #8497
Formation for Steelsnap Closes #8496

1 files changed, 461 insertions, 0 deletions

diff --git a/sql/updates/world/2012_12_02_02_world_waypoint_data.sql b/sql/updates/world/2012_12_02_02_world_waypoint_data.sql
new file mode 100644
index 00000000000..6413ad00b62
--- /dev/null
+++ b/sql/updates/world/2012_12_02_02_world_waypoint_data.sql
@@ -0,0 +1,461 @@
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8528: Path for Gnarl Leafbrother in Feralas
+UPDATE `creature` SET `MovementType`=2,`position_x`=-5022.191895,`position_y`=629.696777,`position_z`=33.835888,`currentwaypoint`=1 WHERE `guid`=51842;
+DELETE FROM `creature_addon` WHERE `guid`=51842;
+INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (51842,518420);
+DELETE FROM `waypoint_data` WHERE `id`=518420;
+-- waypoint data
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(518420,1,-5022.191895,629.696777,33.835888,0,0,0,0,100,0),
+(518420,2,-5043.059082,619.917847,31.750885,0,0,0,0,100,0),
+(518420,3,-5054.034668,613.626709,30.798603,0,0,0,0,100,0),
+(518420,4,-5071.428223,601.871948,32.057613,0,0,0,0,100,0),
+(518420,5,-5089.617676,591.378662,28.951130,0,0,0,0,100,0),
+(518420,6,-5105.091309,579.887695,30.504873,0,0,0,0,100,0),
+(518420,7,-5116.354980,576.741211,32.764660,0,0,0,0,100,0),
+(518420,8,-5136.212891,566.893005,31.577913,0,0,0,0,100,0),
+(518420,9,-5150.280273,553.107849,30.944555,0,0,0,0,100,0),
+(518420,10,-5158.920410,542.095581,35.801292,0,0,0,0,100,0),
+(518420,11,-5167.158203,522.274170,38.600380,0,0,0,0,100,0),
+(518420,12,-5166.315430,510.923157,38.586903,0,0,0,0,100,0),
+(518420,13,-5158.101074,492.401123,33.991638,0,0,0,0,100,0),
+(518420,14,-5147.333984,474.398682,30.235893,0,0,0,0,100,0),
+(518420,15,-5134.918945,457.462006,26.081539,0,0,0,0,100,0),
+(518420,16,-5122.419434,440.587341,21.583317,0,0,0,0,100,0),
+(518420,17,-5109.219727,424.297028,16.553629,0,0,0,0,100,0),
+(518420,18,-5094.229004,409.595154,11.296940,0,0,0,0,100,0),
+(518420,19,-5080.246582,393.952423,10.345637,0,0,0,0,100,0),
+(518420,20,-5070.758789,379.525574,13.711313,0,0,0,0,100,0),
+(518420,21,-5063.307617,359.270874,18.122873,0,0,0,0,100,0),
+(518420,22,-5063.429688,338.487732,24.411358,0,0,0,0,100,0),
+(518420,23,-5059.106445,312.620605,24.147429,0,0,0,0,100,0),
+(518420,24,-5054.877441,292.802917,29.383863,0,0,0,0,100,0),
+(518420,25,-5054.420898,273.845673,34.572777,0,0,0,0,100,0),
+(518420,26,-5070.981445,257.048950,38.070614,0,0,0,0,100,0),
+(518420,27,-5087.886230,264.231934,40.363678,0,0,0,0,100,0),
+(518420,28,-5090.106934,281.698639,35.716690,0,0,0,0,100,0),
+(518420,29,-5081.804688,296.339905,31.364048,0,0,0,0,100,0),
+(518420,30,-5068.381836,313.534424,24.323677,0,0,0,0,100,0),
+(518420,31,-5063.646484,332.752380,25.158432,0,0,0,0,100,0),
+(518420,32,-5060.014648,353.435455,20.394775,0,0,0,0,100,0),
+(518420,33,-5056.827148,373.164917,13.297603,0,0,0,0,100,0),
+(518420,34,-5051.156250,389.049103,12.191339,0,0,0,0,100,0),
+(518420,35,-5053.750977,410.560486,11.438949,0,0,0,0,100,0),
+(518420,36,-5053.371582,435.000610,12.668456,0,0,0,0,100,0),
+(518420,37,-5047.556152,449.830597,12.962356,0,0,0,0,100,0),
+(518420,38,-5041.587891,465.987549,9.927107,0,0,0,0,100,0),
+(518420,39,-5031.068848,492.358582,14.380741,0,0,0,0,100,0),
+(518420,40,-5017.889648,502.309723,13.949232,0,0,0,0,100,0),
+(518420,41,-5016.621094,521.594666,14.870961,0,0,0,0,100,0),
+(518420,42,-5014.022949,548.411804,22.151962,0,0,0,0,100,0),
+(518420,43,-5006.894043,566.593445,27.215111,0,0,0,0,100,0),
+(518420,44,-5005.978516,584.286316,27.214222,0,0,0,0,100,0),
+(518420,45,-5006.477539,605.231934,30.056322,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8525: Path for Antilus the Soarer in Feralas
+UPDATE `creature_template` SET `InhabitType`=5 WHERE `entry`=5347;
+UPDATE `creature` SET `MovementType`=2,`position_x`=-5750.381348,`position_y`=1687.031372,`position_z`=102.642807,`currentwaypoint`=1 WHERE `guid`=51840;
+DELETE FROM `creature_addon` WHERE `guid`=51840;
+INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (51840,518400);
+-- waypoint data
+DELETE FROM `waypoint_data` WHERE `id`=518400;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(518400,1,-5750.381348,1687.031372,102.642807,0,0,0,0,100,0),
+(518400,2,-5763.852539,1659.998779,100.206543,0,0,0,0,100,0),
+(518400,3,-5769.635742,1631.257935,97.278107,0,0,0,0,100,0),
+(518400,4,-5769.966797,1586.222778,95.639244,0,0,0,0,100,0),
+(518400,5,-5747.220215,1555.375977,91.316254,0,0,0,0,100,0),
+(518400,6,-5711.871582,1560.672729,92.667946,0,0,0,0,100,0),
+(518400,7,-5683.442871,1576.397583,93.477570,0,0,0,0,100,0),
+(518400,8,-5661.568359,1610.616699,95.784607,0,0,0,0,100,0),
+(518400,9,-5667.140137,1638.335815,99.210922,0,0,0,0,100,0),
+(518400,10,-5687.900879,1671.338013,102.927925,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8524: GUARDS and PATH for Achellios the Banished
+-- he paths around 1K Needles with 3 Hyena guards. All the guids exist on the TDB,but are not moving or joined in a formation
+DELETE FROM `creature_formations` where `memberGUID` in (21388,21677,21678,21679);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES 
+(21388,21388,0,0,2),
+(21388,21677,3,90,2),
+(21388,21678,6,0,2),
+(21388,21679,3,270,2);
+-- initial position for achellious and guards
+UPDATE `creature` SET `MovementType`=2,`position_x`=-5065.414551,`position_y`=-1433.431885,`position_z`=-52.054058,`currentwaypoint`=1 WHERE `guid`=21388;
+UPDATE `creature` SET `MovementType`=0,`position_x`=-5065.414551,`position_y`=-1433.431885,`position_z`=-52.054058  WHERE `guid` IN (21677,21678,21679);
+UPDATE `creature_addon` SET `path_id`=213880 WHERE `guid`=21388;
+-- waypoint data
+DELETE FROM `waypoint_data` WHERE `id`=213880;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(213880,1,-5065.414551,-1433.431885,-52.054058,0,0,0,0,100,0),
+(213880,2,-5080.285156,-1409.718994,-52.203053,0,0,0,0,100,0),
+(213880,3,-5096.495605,-1378.726807,-51.724346,0,0,0,0,100,0),
+(213880,4,-5104.196289,-1358.002808,-50.824722,0,0,0,0,100,0),
+(213880,5,-5112.802734,-1324.146851,-50.094719,0,0,0,0,100,0),
+(213880,6,-5111.580078,-1301.388672,-49.267933,0,0,0,0,100,0),
+(213880,7,-5107.584473,-1280.802734,-48.943916,0,0,0,0,100,0),
+(213880,8,-5096.659180,-1257.089233,-48.471100,0,0,0,0,100,0),
+(213880,9,-5082.086914,-1233.186279,-50.992100,0,0,0,0,100,0),
+(213880,10,-5065.160156,-1214.561768,-54.094868,0,0,0,0,100,0),
+(213880,11,-5048.077148,-1208.920410,-54.393391,0,0,0,0,100,0),
+(213880,12,-5025.265625,-1212.702515,-53.574635,0,0,0,0,100,0),
+(213880,13,-5007.475098,-1223.781250,-50.797726,0,0,0,0,100,0),
+(213880,14,-4988.770508,-1237.379517,-47.942184,0,0,0,0,100,0),
+(213880,15,-4965.532227,-1252.931885,-46.213470,0,0,0,0,100,0),
+(213880,16,-4945.341309,-1262.725708,-48.321907,0,0,0,0,100,0),
+(213880,17,-4957.100098,-1257.528564,-47.172382,0,0,0,0,100,0),
+(213880,18,-4974.348145,-1245.551147,-46.548256,0,0,0,0,100,0),
+(213880,19,-4997.272949,-1229.474365,-49.777657,0,0,0,0,100,0),
+(213880,20,-5014.469727,-1217.421753,-52.319622,0,0,0,0,100,0),
+(213880,21,-5032.637695,-1209.560913,-54.186928,0,0,0,0,100,0),
+(213880,22,-5056.286133,-1214.395996,-54.073860,0,0,0,0,100,0),
+(213880,23,-5073.804199,-1225.945801,-52.395935,0,0,0,0,100,0),
+(213880,24,-5089.777344,-1243.745728,-49.314560,0,0,0,0,100,0),
+(213880,25,-5098.031250,-1259.230591,-48.500839,0,0,0,0,100,0),
+(213880,26,-5106.213379,-1282.815308,-48.529831,0,0,0,0,100,0),
+(213880,27,-5109.097656,-1303.605347,-48.834938,0,0,0,0,100,0),
+(213880,28,-5108.130859,-1322.882935,-49.570202,0,0,0,0,100,0),
+(213880,29,-5104.601074,-1343.582642,-50.142941,0,0,0,0,100,0),
+(213880,30,-5101.294922,-1364.320801,-50.986908,0,0,0,0,100,0),
+(213880,31,-5092.989258,-1385.642334,-52.071144,0,0,0,0,100,0),
+(213880,32,-5081.424316,-1403.168579,-52.366920,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8513: PATH for Galak Messenger
+UPDATE `creature` SET `MovementType`=2,`position_x`=-5128.149902,`position_y`=-2080.696045,`position_z`=-37.428406,`currentwaypoint`=1 WHERE `guid`=21580;
+UPDATE `creature_addon` SET `path_id`=215800 WHERE `guid`=21580;
+DELETE FROM `waypoint_data` WHERE `id`=215800;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(215800,1,-5128.149902,-2080.696045,-37.428406,0,0,1,0,100,0),
+(215800,2,-5144.749512,-2055.663330,-46.166458,0,0,1,0,100,0),
+(215800,3,-5160.793457,-2041.713501,-54.724445,0,0,1,0,100,0),
+(215800,4,-5184.251465,-2033.325317,-58.405655,0,0,1,0,100,0),
+(215800,5,-5201.125488,-2008.868042,-59.341610,0,0,1,0,100,0),
+(215800,6,-5213.592285,-1976.838135,-62.579338,0,0,1,0,100,0),
+(215800,7,-5217.537598,-1953.069336,-63.412289,0,0,1,0,100,0),
+(215800,8,-5222.407227,-1918.432617,-64.084473,0,0,1,0,100,0),
+(215800,9,-5227.438965,-1890.931396,-64.298187,0,0,1,0,100,0),
+(215800,10,-5237.295410,-1857.382202,-63.312351,0,0,1,0,100,0),
+(215800,11,-5240.198242,-1831.000977,-62.605770,0,0,1,0,100,0),
+(215800,12,-5232.751953,-1803.313843,-61.801113,0,0,1,0,100,0),
+(215800,13,-5220.500488,-1781.184692,-61.136387,0,0,1,0,100,0),
+(215800,14,-5207.737793,-1765.522705,-61.406212,0,0,1,0,100,0),
+(215800,15,-5183.208984,-1749.964600,-63.147694,0,0,1,0,100,0),
+(215800,16,-5155.251465,-1748.128174,-64.991013,0,0,1,0,100,0),
+(215800,17,-5127.433105,-1751.266235,-66.970360,0,0,1,0,100,0),
+(215800,18,-5099.635254,-1754.598633,-66.299957,0,0,1,0,100,0),
+(215800,19,-5077.771973,-1756.719604,-66.374535,0,0,1,0,100,0),
+(215800,20,-5035.874023,-1759.257813,-65.924889,0,0,1,0,100,0),
+(215800,21,-5003.504395,-1755.737061,-64.941254,0,0,1,0,100,0),
+(215800,22,-4983.328613,-1736.512451,-63.698681,0,0,1,0,100,0),
+(215800,23,-4964.090820,-1716.174316,-61.579193,0,0,1,0,100,0),
+(215800,24,-4951.019043,-1689.857910,-57.429195,0,0,1,0,100,0),
+(215800,25,-4951.841797,-1666.268433,-51.589535,0,0,1,0,100,0),
+(215800,26,-4960.942871,-1639.823608,-46.855881,0,0,1,0,100,0),
+(215800,27,-4966.779297,-1612.737427,-43.381424,0,0,1,0,100,0),
+(215800,28,-4969.742676,-1589.195190,-43.398708,0,0,1,0,100,0),
+(215800,29,-4970.269043,-1554.236694,-46.741776,0,0,1,0,100,0),
+(215800,30,-4965.645996,-1536.527954,-47.020432,0,0,1,0,100,0),
+(215800,31,-4947.948242,-1518.798950,-48.846462,0,0,1,0,100,0),
+(215800,32,-4921.585938,-1495.780884,-48.689701,0,0,1,0,100,0),
+(215800,33,-4903.989746,-1476.149902,-49.428204,0,0,1,0,100,0),
+(215800,34,-4890.350098,-1454.333618,-51.238930,0,0,1,0,100,0),
+(215800,35,-4879.882324,-1428.382568,-50.201576,0,0,1,0,100,0),
+(215800,36,-4861.081055,-1406.409302,-52.779129,0,0,1,0,100,0),
+(215800,37,-4840.355957,-1387.582764,-53.201244,0,0,1,0,100,0),
+(215800,38,-4816.097168,-1368.694336,-54.406181,0,0,1,0,100,0),
+(215800,39,-4803.630371,-1359.654663,-54.182922,0,0,1,0,100,0),
+(215800,40,-4785.889648,-1338.234375,-52.060898,0,0,1,0,100,0),
+(215800,41,-4773.799316,-1313.738037,-49.219383,0,0,1,0,100,0),
+(215800,42,-4758.390137,-1290.399536,-48.736355,0,0,1,0,100,0),
+(215800,43,-4737.998047,-1266.390625,-53.017822,0,0,1,0,100,0),
+(215800,44,-4711.256836,-1256.681030,-52.615559,0,0,1,0,100,0),
+(215800,45,-4679.181152,-1252.814209,-51.463142,0,0,1,0,100,0),
+(215800,46,-4651.669922,-1247.886230,-52.659782,0,0,1,0,100,0),
+(215800,47,-4623.778320,-1245.656006,-52.973877,0,0,0,0,100,0),
+(215800,48,-4607.115234,-1243.643433,-53.064377,0,0,0,0,100,0),
+(215800,49,-4587.437500,-1247.870361,-53.855892,0,0,0,0,100,0),
+(215800,50,-4585.422852,-1249.448975,-53.857651,0,0,0,0,100,0),
+(215800,51,-4598.802246,-1245.325928,-53.565094,0,0,0,0,100,0),
+(215800,52,-4614.470703,-1243.162109,-52.968750,0,0,1,0,100,0),
+(215800,53,-4628.971680,-1251.457642,-52.753529,0,0,1,0,100,0),
+(215800,54,-4645.428223,-1247.659546,-52.638180,0,0,1,0,100,0),
+(215800,55,-4661.278320,-1248.203979,-52.803345,0,0,1,0,100,0),
+(215800,56,-4681.649902,-1253.290405,-51.342243,0,0,1,0,100,0),
+(215800,57,-4715.111816,-1257.436401,-52.791569,0,0,1,0,100,0),
+(215800,58,-4747.491211,-1264.123169,-53.191650,0,0,1,0,100,0),
+(215800,59,-4759.030273,-1286.646851,-49.020157,0,0,1,0,100,0),
+(215800,60,-4774.152344,-1310.650635,-48.968861,0,0,1,0,100,0),
+(215800,61,-4784.423340,-1342.359375,-53.125374,0,0,1,0,100,0),
+(215800,62,-4809.395508,-1362.980469,-54.185860,0,0,1,0,100,0),
+(215800,63,-4837.885254,-1383.289795,-53.668198,0,0,1,0,100,0),
+(215800,64,-4867.006836,-1404.410400,-53.336357,0,0,1,0,100,0),
+(215800,65,-4887.808105,-1414.729858,-52.435139,0,0,1,0,100,0),
+(215800,66,-4895.424316,-1429.204102,-50.844917,0,0,1,0,100,0),
+(215800,67,-4896.184570,-1457.176392,-50.691010,0,0,1,0,100,0),
+(215800,68,-4904.700684,-1480.074097,-49.529816,0,0,1,0,100,0),
+(215800,69,-4919.068359,-1495.049683,-48.906162,0,0,1,0,100,0),
+(215800,70,-4966.222168,-1533.183350,-47.460865,0,0,1,0,100,0),
+(215800,71,-4976.059570,-1543.898804,-47.982384,0,0,1,0,100,0),
+(215800,72,-4977.478027,-1556.967163,-47.390457,0,0,1,0,100,0),
+(215800,73,-4969.218262,-1596.886963,-42.604176,0,0,1,0,100,0),
+(215800,74,-4965.557617,-1625.019775,-44.356102,0,0,1,0,100,0),
+(215800,75,-4960.265137,-1644.879883,-47.910450,0,0,1,0,100,0),
+(215800,76,-4949.774902,-1671.032593,-52.508038,0,0,1,0,100,0),
+(215800,77,-4947.920410,-1689.247437,-57.222298,0,0,1,0,100,0),
+(215800,78,-4956.675293,-1709.576660,-60.879921,0,0,1,0,100,0),
+(215800,79,-4963.580078,-1727.992676,-61.527287,0,0,1,0,100,0),
+(215800,80,-4951.212891,-1744.922241,-58.623901,0,0,1,0,100,0),
+(215800,81,-4937.354492,-1760.683716,-54.702461,0,0,1,0,100,0),
+(215800,82,-4914.461426,-1782.888306,-39.879925,0,0,1,0,100,0),
+(215800,83,-4896.937500,-1794.455566,-35.221378,0,0,1,0,100,0),
+(215800,84,-4880.451172,-1807.454590,-40.863453,0,0,1,0,100,0),
+(215800,85,-4863.387207,-1822.359985,-50.164097,0,0,1,0,100,0),
+(215800,86,-4862.391113,-1836.323608,-50.317734,0,0,1,0,100,0),
+(215800,87,-4861.693848,-1862.064575,-52.851486,0,0,1,0,100,0),
+(215800,88,-4872.836426,-1883.313110,-52.659794,0,0,1,0,100,0),
+(215800,89,-4870.795898,-1892.231201,-52.494869,0,0,1,0,100,0),
+(215800,90,-4849.780762,-1918.967407,-48.753052,0,0,1,0,100,0),
+(215800,91,-4830.531738,-1939.242310,-45.041187,0,0,1,0,100,0),
+(215800,92,-4811.462402,-1962.676147,-50.805752,0,0,1,0,100,0),
+(215800,93,-4803.708984,-1987.761475,-57.812279,0,0,1,0,100,0),
+(215800,94,-4807.741211,-2007.688599,-56.595051,0,0,1,0,100,0),
+(215800,95,-4818.894531,-2033.343628,-46.855431,0,0,1,0,100,0),
+(215800,96,-4830.502930,-2059.523926,-39.165230,0,0,1,0,100,0),
+(215800,97,-4830.697754,-2073.522705,-35.956047,0,0,1,0,100,0),
+(215800,98,-4836.328613,-2090.582764,-31.344126,0,0,1,0,100,0),
+(215800,99,-4849.243652,-2105.089600,-32.308865,0,0,1,0,100,0),
+(215800,100,-4860.978516,-2112.724609,-36.231457,0,0,1,0,100,0),
+(215800,101,-4887.553711,-2130.225098,-46.567883,0,0,1,0,100,0),
+(215800,102,-4903.914551,-2142.859863,-52.826328,0,0,1,0,100,0),
+(215800,103,-4925.906250,-2157.612549,-56.605095,0,0,1,0,100,0),
+(215800,104,-4951.915527,-2172.731934,-54.968418,0,0,1,0,100,0),
+(215800,105,-4968.645996,-2184.287109,-53.815079,0,0,1,0,100,0),
+(215800,106,-4986.170898,-2202.175049,-53.769779,0,0,1,0,100,0),
+(215800,107,-5006.877441,-2230.390625,-53.176605,0,0,1,0,100,0),
+(215800,108,-5027.830566,-2247.915283,-52.767597,0,0,1,0,100,0),
+(215800,109,-5042.617676,-2243.480469,-53.246635,0,0,1,0,100,0),
+(215800,110,-5049.044434,-2230.145020,-53.927814,0,0,0,0,100,0),
+(215800,111,-5047.357910,-2223.671631,-54.098183,0,0,0,0,100,0),
+(215800,112,-5039.557129,-2203.820313,-54.500809,0,0,0,0,100,0),
+(215800,113,-5042.728027,-2213.820068,-54.411404,0,0,0,0,100,0),
+(215800,114,-5049.869629,-2229.956055,-53.964584,0,0,0,0,100,0),
+(215800,115,-5062.334961,-2216.283447,-54.635983,0,0,1,0,100,0),
+(215800,116,-5065.966309,-2193.272949,-55.662319,0,0,1,0,100,0),
+(215800,117,-5068.202148,-2158.396240,-53.611042,0,0,1,0,100,0),
+(215800,118,-5074.131836,-2135.689697,-47.028843,0,0,1,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8512: PATH for XT-9 in Stonetalon Mountains
+UPDATE `creature` SET `MovementType`=2,`position_x`=1222.276978,`position_y`=199.114410,`position_z`=5.525987,`currentwaypoint`=1 WHERE `guid`=32296;
+UPDATE `creature_addon` SET `path_id`=322960 WHERE `guid`=32296;
+DELETE FROM `waypoint_data` WHERE `id`=322960;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(322960,1,1222.276978,199.114410,5.525987,0,0,0,0,100,0),
+(322960,2,1209.336914,203.459274,5.948678,0,0,0,0,100,0),
+(322960,3,1192.071899,209.217392,5.244399,0,0,0,0,100,0),
+(322960,4,1179.189941,213.726425,5.674247,0,0,0,0,100,0),
+(322960,5,1164.158936,220.785812,4.382747,0,0,0,0,100,0),
+(322960,6,1147.991821,229.042755,3.532074,0,0,0,0,100,0),
+(322960,7,1132.148071,231.524780,7.357968,0,0,0,0,100,0),
+(322960,8,1118.510132,231.104340,9.255224,0,0,0,0,100,0),
+(322960,9,1100.385498,229.453033,11.308514,0,0,0,0,100,0),
+(322960,10,1087.943970,226.725204,10.917646,0,0,0,0,100,0),
+(322960,11,1080.088501,214.416534,10.396996,0,0,0,0,100,0),
+(322960,12,1080.622314,198.052307,9.542740,0,0,0,0,100,0),
+(322960,13,1084.607544,185.012192,8.583089,0,0,0,0,100,0),
+(322960,14,1093.251343,171.689758,4.980580,0,0,0,0,100,0),
+(322960,15,1092.938721,164.037949,4.320332,0,0,0,0,100,0),
+(322960,16,1088.528442,156.011032,4.629877,0,0,0,0,100,0),
+(322960,17,1080.081177,140.358978,4.004388,0,0,0,0,100,0),
+(322960,18,1085.399170,127.790977,1.792864,0,0,0,0,100,0),
+(322960,19,1096.183960,118.597023,0.878709,0,0,0,0,100,0),
+(322960,20,1099.510010,109.012466,0.827630,0,0,0,0,100,0),
+(322960,21,1098.441162,95.011284,-0.082417,0,0,0,0,100,0),
+(322960,22,1098.891724,82.300453,-1.118887,0,0,0,0,100,0),
+(322960,23,1102.501099,69.463821,-2.654820,0,0,0,0,100,0),
+(322960,24,1096.981812,57.157135,-0.905613,0,0,0,0,100,0),
+(322960,25,1091.626831,44.614517,1.431422,0,0,0,0,100,0),
+(322960,26,1086.331299,32.963169,3.482675,0,0,0,0,100,0),
+(322960,27,1085.050171,20.679634,4.132904,0,0,0,0,100,0),
+(322960,28,1092.919678,7.784930,3.964831,0,0,0,0,100,0),
+(322960,29,1103.300659,1.748433,3.811355,0,0,0,0,100,0),
+(322960,30,1108.904541,6.663838,1.965487,0,0,0,0,100,0),
+(322960,31,1119.753784,17.255640,2.577073,0,0,0,0,100,0),
+(322960,32,1126.567993,33.555817,4.283827,0,0,0,0,100,0),
+(322960,33,1125.516357,48.321960,2.388851,0,0,0,0,100,0),
+(322960,34,1129.901855,61.247665,0.658247,0,0,0,0,100,0),
+(322960,35,1132.704956,73.019661,-0.850287,0,0,0,0,100,0),
+(322960,36,1136.619019,88.970215,-5.982680,0,0,0,0,100,0),
+(322960,37,1137.549072,99.014374,-5.729230,0,0,0,0,100,0),
+(322960,38,1134.350220,114.686874,-1.268749,0,0,0,0,100,0),
+(322960,39,1130.803467,132.522125,0.171318,0,0,0,0,100,0),
+(322960,40,1128.713135,146.011124,1.776255,0,0,0,0,100,0),
+(322960,41,1126.625732,159.500565,-0.202374,0,0,0,0,100,0),
+(322960,42,1128.083984,177.528091,1.144017,0,0,0,0,100,0),
+(322960,43,1132.362427,188.766861,2.936989,0,0,0,0,100,0),
+(322960,44,1141.536377,204.471161,2.415991,0,0,0,0,100,0),
+(322960,45,1149.883301,215.242752,2.582333,0,0,0,0,100,0),
+(322960,46,1161.778809,225.302536,3.651462,0,0,0,0,100,0),
+(322960,47,1172.943726,233.153442,5.679798,0,0,0,0,100,0),
+(322960,48,1189.031982,229.718399,8.996441,0,0,0,0,100,0),
+(322960,49,1196.270386,219.675781,6.686813,0,0,0,0,100,0),
+(322960,50,1207.258911,211.584717,6.367443,0,0,0,0,100,0),
+(322960,51,1218.403931,203.703522,6.202962,0,0,0,0,100,0),
+(322960,52,1229.438110,193.180573,4.627266,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8502: PATHING FOR URUSON
+UPDATE `creature` SET `MovementType`=2,`position_x`=9816.841797,`position_y`=355.442474,`position_z`=1308.459351,`currentwaypoint`=1 WHERE `guid`=46350;
+UPDATE `creature_addon` SET `path_id`=463500 WHERE `guid`=46350;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(463500,1,9816.841797,355.442474,1308.459351,0,0,0,0,100,0),
+(463500,2,9812.415039,362.828094,1308.752197,0,0,0,0,100,0),
+(463500,3,9813.471680,371.201080,1307.603882,0,0,0,0,100,0),
+(463500,4,9817.410156,378.589417,1307.885742,0,0,0,0,100,0),
+(463500,5,9825.732422,384.063232,1307.750610,0,0,0,0,100,0),
+(463500,6,9834.477539,389.443268,1307.568115,0,0,0,0,100,0),
+(463500,7,9841.236328,395.250305,1307.572998,0,0,0,0,100,0),
+(463500,8,9848.033203,401.213165,1306.638672,0,0,0,0,100,0),
+(463500,9,9859.214844,406.416229,1305.993896,0,0,0,0,100,0),
+(463500,10,9869.071289,406.038055,1306.539917,0,0,0,0,100,0),
+(463500,11,9878.757813,405.102966,1307.240845,0,0,0,0,100,0),
+(463500,12,9885.528320,403.787720,1307.657715,0,0,0,0,100,0),
+(463500,13,9889.619141,397.835724,1308.962280,0,0,0,0,100,0),
+(463500,14,9893.748047,390.061859,1309.997925,0,0,0,0,100,0),
+(463500,15,9896.480469,384.763855,1309.682861,0,0,0,0,100,0),
+(463500,16,9893.901367,389.335175,1309.996948,0,0,0,0,100,0),
+(463500,17,9891.625977,394.618530,1309.802979,0,0,0,0,100,0),
+(463500,18,9889.411133,401.266754,1308.383423,0,0,0,0,100,0),
+(463500,19,9889.074219,410.169098,1306.578735,0,0,0,0,100,0),
+(463500,20,9889.352539,418.270325,1305.849609,0,0,0,0,100,0),
+(463500,21,9889.537109,426.961700,1305.150146,0,0,0,0,100,0),
+(463500,22,9886.551758,436.957245,1304.242920,0,0,0,0,100,0),
+(463500,23,9880.396484,443.821472,1303.310303,0,0,0,0,100,0),
+(463500,24,9870.833008,446.340790,1303.197144,0,0,0,0,100,0),
+(463500,25,9862.344727,445.663116,1305.028198,0,0,0,0,100,0),
+(463500,26,9853.178711,443.624847,1306.194458,0,0,0,0,100,0),
+(463500,27,9846.104492,441.481476,1307.793701,0,0,0,0,100,0),
+(463500,28,9837.686523,438.918671,1307.793701,0,0,0,0,100,0),
+(463500,29,9844.111328,440.791779,1307.793701,0,0,0,0,100,0),
+(463500,30,9851.247070,442.721130,1306.898926,0,0,0,0,100,0),
+(463500,31,9859.722656,444.624786,1305.261841,0,0,0,0,100,0),
+(463500,32,9868.759766,446.034027,1303.592163,0,0,0,0,100,0),
+(463500,33,9876.381836,446.370392,1302.643555,0,0,0,0,100,0),
+(463500,34,9882.995117,443.218323,1303.420654,0,0,0,0,100,0),
+(463500,35,9886.392578,436.599731,1304.326904,0,0,0,0,100,0),
+(463500,36,9888.699219,427.984589,1305.102173,0,0,0,0,100,0),
+(463500,37,9888.677734,420.184723,1305.806763,0,0,0,0,100,0),
+(463500,38,9886.924805,411.696075,1306.650635,0,0,0,0,100,0),
+(463500,39,9881.045898,406.513794,1307.236572,0,0,0,0,100,0),
+(463500,40,9872.117188,405.889221,1306.774536,0,0,0,0,100,0),
+(463500,41,9863.948242,407.544800,1306.226685,0,0,0,0,100,0),
+(463500,42,9857.266602,406.285339,1306.106934,0,0,0,0,100,0),
+(463500,43,9850.121094,401.789185,1306.542236,0,0,0,0,100,0),
+(463500,44,9843.356445,396.552856,1307.546021,0,0,0,0,100,0),
+(463500,45,9836.401367,390.980865,1307.567749,0,0,0,0,100,0),
+(463500,46,9828.750977,386.198456,1307.593384,0,0,0,0,100,0),
+(463500,47,9820.420898,380.808014,1307.936279,0,0,0,0,100,0),
+(463500,48,9814.184570,374.616272,1307.687866,0,0,0,0,100,0),
+(463500,49,9812.975586,367.559235,1307.733276,0,0,0,0,100,0),
+(463500,50,9812.920898,362.307007,1308.749512,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8501: SET up path and formation for snake pet vendor
+DELETE FROM `creature_formations` WHERE `leaderGUID`=3476;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(3476,3476,0,0,2),
+(3476,3477,3,45,0),
+(3476,3560,3,0,0),
+(3476,3571,3,315,0);
+UPDATE `creature` SET `MovementType`=2,`position_x`=1527.534058,`position_y`=-4154.753418,`position_z`=40.633469,`currentwaypoint`=1 WHERE `guid` IN (3476,3477,3560,3571);
+-- point to new waypoint
+UPDATE `creature_addon` SET `path_id`=34760 WHERE `guid` IN(3476,3477,3560,3571);
+-- create waypoint data
+DELETE FROM `waypoint_data` WHERE `id`=34760;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(34760,1,1527.534058,-4154.753418,40.633469,0,0,0,0,100,0),
+(34760,1,1538.660889,-4155.732910,40.592560,0,0,0,0,100,0),
+(34760,1,1544.449585,-4165.091797,40.235329,0,0,0,0,100,0),
+(34760,1,1549.555054,-4182.306152,40.612457,0,0,0,0,100,0),
+(34760,1,1546.198364,-4195.886719,41.639046,0,0,0,0,100,0),
+(34760,1,1546.507202,-4208.074219,42.972824,0,0,0,0,100,0),
+(34760,1,1563.277588,-4208.397949,43.588390,0,0,0,0,100,0),
+(34760,1,1580.304932,-4204.166992,42.040199,0,0,0,0,100,0),
+(34760,1,1579.333008,-4190.097656,40.364456,0,0,0,0,100,0),
+(34760,1,1578.215454,-4169.156250,36.905151,0,0,0,0,100,0),
+(34760,1,1583.998901,-4151.174316,34.014111,0,0,0,0,100,0),
+(34760,1,1598.492920,-4127.300293,30.541750,0,0,0,0,100,0),
+(34760,1,1617.180908,-4113.645508,29.638874,0,0,0,0,100,0),
+(34760,1,1636.737183,-4106.015625,30.359407,0,0,0,0,100,0),
+(34760,1,1656.451660,-4098.783691,33.361252,0,0,0,0,100,0),
+(34760,1,1682.917603,-4089.642822,37.421402,0,0,0,0,100,0),
+(34760,1,1703.152954,-4084.039551,40.476315,0,0,0,0,100,0),
+(34760,1,1726.875488,-4072.490234,43.763309,0,0,0,0,100,0),
+(34760,1,1731.973511,-4067.927002,44.831135,0,0,0,0,100,0),
+(34760,1,1741.482544,-4049.207031,44.283241,0,0,0,0,100,0),
+(34760,1,1745.628418,-4030.451172,45.169521,0,0,0,0,100,0),
+(34760,1,1745.231323,-4016.597412,45.969612,0,0,0,0,100,0),
+(34760,1,1740.649658,-3996.140625,46.610088,0,0,0,0,100,0),
+(34760,1,1729.449951,-3971.255615,48.347816,0,0,0,0,100,0),
+(34760,1,1723.011841,-3958.823730,49.068924,0,0,0,0,100,0),
+(34760,1,1708.968994,-3932.853760,50.349556,0,0,0,0,100,0),
+(34760,1,1721.805054,-3957.727295,49.226501,0,0,0,0,100,0),
+(34760,1,1734.530396,-3982.660156,47.613869,0,0,0,0,100,0),
+(34760,1,1740.518555,-4002.613770,46.854977,0,0,0,0,100,0),
+(34760,1,1743.422241,-4023.412109,46.146847,0,0,0,0,100,0),
+(34760,1,1742.478638,-4043.433350,44.345577,0,0,0,0,100,0),
+(34760,1,1735.912354,-4059.685303,44.504650,0,0,0,0,100,0),
+(34760,1,1729.070313,-4071.194092,44.119446,0,0,0,0,100,0),
+(34760,1,1714.267700,-4082.427490,40.937172,0,0,0,0,100,0),
+(34760,1,1696.915161,-4087.865967,38.582226,0,0,0,0,100,0),
+(34760,1,1676.688477,-4093.507080,36.173759,0,0,0,0,100,0),
+(34760,1,1656.776611,-4100.146484,33.436935,0,0,0,0,100,0),
+(34760,1,1637.123169,-4107.544922,30.447823,0,0,0,0,100,0),
+(34760,1,1617.755859,-4115.625000,29.678862,0,0,0,0,100,0),
+(34760,1,1597.177124,-4130.714844,31.122652,0,0,0,0,100,0),
+(34760,1,1590.612183,-4140.921875,32.565376,0,0,0,0,100,0),
+(34760,1,1578.348389,-4166.501953,36.404202,0,0,0,0,100,0),
+(34760,1,1578.059326,-4183.750488,39.244587,0,0,0,0,100,0),
+(34760,1,1578.675171,-4204.605957,42.405655,0,0,0,0,100,0),
+(34760,1,1569.681030,-4206.293457,43.517696,0,0,0,0,100,0),
+(34760,1,1548.253662,-4208.393555,43.110550,0,0,0,0,100,0),
+(34760,1,1544.526123,-4201.686035,42.132000,0,0,0,0,100,0),
+(34760,1,1549.644531,-4176.722656,40.245403,0,0,0,0,100,0),
+(34760,1,1547.767822,-4167.392578,39.779228,0,0,0,0,100,0),
+(34760,1,1541.973145,-4159.893555,40.252274,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Issue 8497: Proper pathing for Threggil (rare in Teldrassil - Fel Rock)
+UPDATE `creature` SET `MovementType`=2,`position_x`=10115.946289,`position_y`=1167.518799,`position_z`=1314.169800,`currentwaypoint`=1 WHERE `guid`=46354;
+UPDATE `creature_addon` SET `path_id`=463540 WHERE `guid`=46354;
+DELETE FROM `waypoint_data` WHERE `id`=463540;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) values
+(463540,1,10115.946289,1167.518799,1314.169800,0,0,0,0,100,0),
+(463540,2,10116.369141,1180.527344,1314.797729,0,0,0,0,100,0),
+(463540,3,10115.022461,1189.806763,1313.652832,0,0,0,0,100,0),
+(463540,4,10110.606445,1199.469116,1311.572510,0,0,0,0,100,0),
+(463540,5,10103.337891,1203.544067,1311.799561,0,0,0,0,100,0),
+(463540,6,10096.462891,1201.196289,1312.748047,0,0,0,0,100,0),
+(463540,7,10088.860352,1196.343018,1315.411377,0,0,0,0,100,0),
+(463540,8,10082.796875,1189.643555,1316.328369,0,0,0,0,100,0),
+(463540,9,10076.649414,1182.240234,1316.167480,0,0,0,0,100,0),
+(463540,10,10072.209961,1176.473511,1316.686768,0,0,0,0,100,0),
+(463540,11,10068.778320,1169.667603,1318.986328,0,0,0,0,100,0),
+(463540,12,10063.398438,1163.494019,1319.416260,0,0,0,0,100,0),
+(463540,13,10057.836914,1157.816895,1319.428955,0,0,0,0,100,0),
+(463540,14,10055.192383,1151.090576,1320.125732,0,0,0,0,100,0),
+(463540,15,10057.836914,1157.816895,1319.428955,0,0,0,0,100,0),
+(463540,16,10063.398438,1163.494019,1319.416260,0,0,0,0,100,0),
+(463540,17,10068.778320,1169.667603,1318.986328,0,0,0,0,100,0),
+(463540,18,10072.209961,1176.473511,1316.686768,0,0,0,0,100,0),
+(463540,19,10076.649414,1182.240234,1316.167480,0,0,0,0,100,0),
+(463540,20,10082.796875,1189.643555,1316.328369,0,0,0,0,100,0),
+(463540,21,10088.860352,1196.343018,1315.411377,0,0,0,0,100,0),
+(463540,22,10096.462891,1201.196289,1312.748047,0,0,0,0,100,0),
+(463540,23,10103.337891,1203.544067,1311.799561,0,0,0,0,100,0),
+(463540,24,10110.606445,1199.469116,1311.572510,0,0,0,0,100,0),
+(463540,25,10115.022461,1189.806763,1313.652832,0,0,0,0,100,0),
+(463540,26,10116.369141,1180.527344,1314.797729,0,0,0,0,100,0);
+-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------
+-- Steelsnap's (guid 21698) guards (guids 21660,21661) should be in formation rather than set up with identical waypoints. This corrects pathing problems
+UPDATE `creature` SET `MovementType`=0 WHERE guid IN (21661, 21660);
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (21698,21661,21660);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES 
+(21698,21698,0,0,2),
+(21698,21661,6,0,2),
+(21698,21660,12,0,2);