diff options
| -rw-r--r-- | sql/updates/world/2015_03_25_03_world.sql | 2431 |
1 files changed, 2431 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_25_03_world.sql b/sql/updates/world/2015_03_25_03_world.sql new file mode 100644 index 00000000000..6f60c2e8090 --- /dev/null +++ b/sql/updates/world/2015_03_25_03_world.sql @@ -0,0 +1,2431 @@ +-- Pathing and emotes for feralas creatures + +UPDATE `creature` SET `spawndist`=5,`MovementType`=1 WHERE `guid` IN (369862); +UPDATE `creature` SET `spawndist`=5,`MovementType`=1 WHERE `id` IN (40224,44400,39728,5234,5236,5240,11440,11442,11443,5258,5247,5245,5246,5253,5251,5254,5255); + +UPDATE `creature` SET `spawndist`=10,`MovementType`=1 WHERE `id` IN (5366,5362,39384,39395,40194,39733,7939,5359,5462,39896,5300,40193,40059); + +UPDATE `creature` SET `spawndist`=15,`MovementType`=1 WHERE `id` IN (39677); +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=39677; + +-- corrections +DELETE FROM `creature_template_addon` WHERE `entry` IN (5236,5240,5258); +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `id` IN (7939); +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `guid` IN (369863,369404,369402,369248,369256,369257,369259,369249,369245,369424,369422,369418,368885,368887,368882,368883); +DELETE FROM `creature_addon` WHERE `guid` IN (369863,369650,369404,369402,369248,369256,369257,369259,369249,369245,369424,369422,369418,368885,368887,368882,368883); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(368883,0,0,0,1,0, '78677'), +(368882,0,0,0,1,0, '78677'), +(368887,0,0,0,1,0, '78677'), +(369418,0,0,0,1,0, '78677'), +(369422,0,0,1,1,0, ''), +(369424,0,0,1,1,0, ''), +(368885,0,0,0,1,0, '78677'), +(369259,0,0,0,1,0, '78677'), +(369245,0,0,0,1,10, ''), +(369249,0,0,1,1,0, ''), +(369257,0,0,1,1,0, ''), +(369248,0,0,1,1,0, ''), +(369402,0,0,1,1,0, ''), +(369404,0,0,1,1,0, ''), +(369650,0,0,0,1,28, ''), +(369863,0,0,8,1,0, ''), +(369256,0,0,1,1,0, ''); + +-- Cliff Giant SAI +SET @ENTRY := 39339; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=2; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,2,0,1,0,100,0,1000,1000,3000,3000,49,0,0,0,0,0,0,19,40972,10,0,0,0,0,0,"Cliff Giant - Out of Combat - Start Attacking"); + +-- Pathing for Entry: 40969 'TDB FORMAT' +SET @NPC := 370018; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3187.076,`position_y`=1920.438,`position_z`=45.87395 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,-3187.076,1920.438,45.87395,0,0,0,0,100,0), +(@PATH,2,-3181.133,1928.93,45.60934,0,0,0,0,100,0), +(@PATH,3,-3167.392,1936.229,45.57323,0,0,0,0,100,0), +(@PATH,4,-3157.642,1934.979,44.82323,0,0,0,0,100,0), +(@PATH,5,-3152.301,1934.283,44.38557,0,0,0,0,100,0), +(@PATH,6,-3151.301,1934.033,44.38557,0,0,0,0,100,0), +(@PATH,7,-3150.301,1932.783,44.38557,0,0,0,0,100,0), +(@PATH,8,-3148.551,1929.533,44.63557,0,0,0,0,100,0), +(@PATH,9,-3144.551,1926.283,44.13557,0,0,0,0,100,0), +(@PATH,10,-3144.281,1926.009,43.99139,0,0,0,0,100,0), +(@PATH,11,-3143.781,1925.509,43.74139,0,0,0,0,100,0), +(@PATH,12,-3139.531,1916.759,42.99139,0,0,0,0,100,0), +(@PATH,13,-3139.29,1916.603,42.61093,0,0,0,0,100,0), +(@PATH,14,-3138.54,1915.103,42.36093,0,0,0,0,100,0), +(@PATH,15,-3137.29,1910.603,40.61093,0,0,0,0,100,0), +(@PATH,16,-3136.313,1906.599,40.0296,0,0,0,0,100,0), +(@PATH,17,-3136.313,1898.849,40.5296,0,0,0,0,100,0), +(@PATH,18,-3136.185,1898.469,40.73271,0,0,0,0,100,0), +(@PATH,19,-3136.185,1897.219,40.98271,0,0,0,0,100,0), +(@PATH,20,-3138.685,1895.219,42.23271,0,0,0,0,100,0), +(@PATH,21,-3145.517,1889.207,42.22758,0,0,0,0,100,0), +(@PATH,22,-3155.017,1886.207,42.97758,0,0,0,0,100,0), +(@PATH,23,-3157.517,1884.957,43.72758,0,0,0,0,100,0), +(@PATH,24,-3160.267,1883.957,43.97758,0,0,0,0,100,0), +(@PATH,25,-3164.017,1882.707,44.72758,0,0,0,0,100,0), +(@PATH,26,-3167.017,1881.707,45.47758,0,0,0,0,100,0), +(@PATH,27,-3167.122,1881.75,45.83471,0,0,0,0,100,0), +(@PATH,28,-3168.872,1881,45.83471,0,0,0,0,100,0), +(@PATH,29,-3173.872,1882,46.58471,0,0,0,0,100,0), +(@PATH,30,-3176.372,1882.5,47.33471,0,0,0,0,100,0), +(@PATH,31,-3181.372,1883,47.83471,0,0,0,0,100,0), +(@PATH,32,-3181.53,1883.248,48.00553,0,0,0,0,100,0), +(@PATH,33,-3183.53,1883.748,48.25553,0,0,0,0,100,0), +(@PATH,34,-3188.78,1891.748,48.75553,0,0,0,0,100,0), +(@PATH,35,-3190.378,1894.056,49.3491,0,0,0,0,100,0), +(@PATH,36,-3193.128,1903.306,48.5991,0,0,0,0,100,0), +(@PATH,37,-3194.628,1908.056,48.0991,0,0,0,0,100,0), +(@PATH,38,-3194.55,1908.34,48.06357,0,0,0,0,100,0), +(@PATH,39,-3195.05,1909.84,47.56357,0,0,0,0,100,0), +(@PATH,40,-3193.3,1912.34,46.81357,0,0,0,0,100,0), +(@PATH,41,-3190.55,1916.09,46.31357,0,0,0,0,100,0); + +-- Pathing for Entry: 7939 'TDB FORMAT' +SET @NPC := 369861; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4388.523,`position_y`=2246.545,`position_z`=8.359505 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,-4388.523,2246.545,8.359505,0,0,0,0,100,0), +(@PATH,2,-4388.545,2246.635,8.226259,0,0,0,0,100,0), +(@PATH,3,-4388.369,2246.909,8.634624,0,0,0,0,100,0), +(@PATH,4,-4373.869,2253.909,9.134624,0,0,0,0,100,0), +(@PATH,5,-4366.119,2257.659,9.634624,0,0,0,0,100,0), +(@PATH,6,-4354.255,2263.816,9.749556,0,0,0,0,100,0), +(@PATH,7,-4326.499,2266,9.735401,0,0,0,0,100,0), +(@PATH,8,-4309.294,2249.726,9.733945,0,0,0,0,100,0), +(@PATH,9,-4294.843,2248.629,9.733945,0,0,0,0,100,0), +(@PATH,10,-4283.715,2257.516,9.733945,0,0,0,0,100,0), +(@PATH,11,-4281.513,2272.576,9.733945,0,0,0,0,100,0), +(@PATH,12,-4291.113,2284.274,9.733945,0,0,0,0,100,0), +(@PATH,13,-4291.36,2285.216,9.483945,0,0,0,0,100,0), +(@PATH,14,-4291.36,2285.216,9.483945,3.379455,0,0,0,100,0), +(@PATH,15,-4291.36,2285.216,9.483945,1.511411,0,0,0,100,0), +(@PATH,16,-4290.799,2294.649,9.483945,0,0,0,0,100,0), +(@PATH,17,-4290.878,2295.019,9.611959,0,0,0,0,100,0), +(@PATH,18,-4290.799,2294.649,9.483945,0,0,0,0,100,0), +(@PATH,19,-4290.771,2294.539,9.528823,0,0,0,0,100,0), +(@PATH,20,-4291.122,2284.153,9.733945,0,0,0,0,100,0), +(@PATH,21,-4281.591,2272.299,9.733945,0,0,0,0,100,0), +(@PATH,22,-4283.589,2257.435,9.733945,0,0,0,0,100,0), +(@PATH,23,-4294.975,2248.402,9.733945,0,0,0,0,100,0), +(@PATH,24,-4309.525,2249.986,9.733945,0,0,0,0,100,0), +(@PATH,25,-4326.792,2265.9,9.749556,0,0,0,0,100,0); + +-- Moonclaw Warrior SAI +SET @ENTRY := 40362; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,3000,3000,3000,3000,5,35,0,0,0,0,0,1,0,0,0,0,0,0,0,"Moonclaw Warrior - Out of Combat - Play Emote 35"); + +-- Feathermoon Archer SAI +SET @GUID := -369841; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=40360; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,6000,11,74279,0,0,0,0,0,19,37162,30,0,0,0,0,0,"Feathermoon Archer - Out of Combat - Cast 'Shoot'"); + +-- Feathermoon Archer SAI +SET @GUID := -369853; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=40360; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,3000,3000,6000,6000,11,74279,0,0,0,0,0,19,37162,30,0,0,0,0,0,"Feathermoon Archer - Out of Combat - Cast 'Shoot'"); + +-- Pathing for Entry: 39896 'TDB FORMAT' +SET @NPC := 369615; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5122.465,`position_y`=1907.466,`position_z`=96.35909 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,-5122.465,1907.466,96.35909,0,0,0,0,100,0), +(@PATH,2,-5124.215,1906.216,97.10909,0,0,0,0,100,0), +(@PATH,3,-5127.715,1907.216,97.60909,0,0,0,0,100,0), +(@PATH,4,-5130.215,1907.966,98.10909,0,0,0,0,100,0), +(@PATH,5,-5133.215,1908.966,99.35909,0,0,0,0,100,0), +(@PATH,6,-5137.465,1909.716,99.35909,0,0,0,0,100,0), +(@PATH,7,-5137.744,1909.734,99.53224,0,0,0,0,100,0), +(@PATH,8,-5138.744,1909.984,99.28224,0,0,0,0,100,0), +(@PATH,9,-5140.994,1909.734,99.28224,0,0,0,0,100,0), +(@PATH,10,-5145.604,1909.267,99.8338,0,0,0,0,100,0), +(@PATH,11,-5147.104,1907.017,99.5838,0,0,0,0,100,0), +(@PATH,12,-5147.604,1906.017,99.5838,0,0,0,0,100,0), +(@PATH,13,-5151.104,1899.767,100.3338,0,0,0,0,100,0), +(@PATH,14,-5150.92,1899.566,100.3627,0,0,0,0,100,0), +(@PATH,15,-5151.17,1899.066,100.6127,0,0,0,0,100,0), +(@PATH,16,-5150.92,1898.066,100.6127,0,0,0,0,100,0), +(@PATH,17,-5148.67,1893.066,99.8627,0,0,0,0,100,0), +(@PATH,18,-5147.42,1889.566,99.3627,0,0,0,0,100,0), +(@PATH,19,-5147.403,1889.357,99.49263,0,0,0,0,100,0), +(@PATH,20,-5146.903,1888.107,99.24263,0,0,0,0,100,0), +(@PATH,21,-5148.153,1884.857,98.99263,0,0,0,0,100,0), +(@PATH,22,-5150.153,1879.607,99.99263,0,0,0,0,100,0), +(@PATH,23,-5150.903,1877.857,100.7426,0,0,0,0,100,0), +(@PATH,24,-5151.653,1875.107,101.9926,0,0,0,0,100,0), +(@PATH,25,-5152.903,1872.357,103.2426,0,0,0,0,100,0), +(@PATH,26,-5154.873,1867.438,104.7775,0,0,0,0,100,0), +(@PATH,27,-5156.623,1863.438,105.5275,0,0,0,0,100,0), +(@PATH,28,-5157.123,1862.188,105.7775,0,0,0,0,100,0), +(@PATH,29,-5157.873,1859.938,106.5275,0,0,0,0,100,0), +(@PATH,30,-5158.873,1857.438,107.2775,0,0,0,0,100,0), +(@PATH,31,-5160.373,1853.188,109.5275,0,0,0,0,100,0), +(@PATH,32,-5161.623,1849.688,111.0275,0,0,0,0,100,0), +(@PATH,33,-5164.264,1843.184,112.7117,0,0,0,0,100,0), +(@PATH,34,-5168.014,1840.934,113.9617,0,0,0,0,100,0), +(@PATH,35,-5171.264,1838.934,115.4617,0,0,0,0,100,0), +(@PATH,36,-5174.014,1837.184,115.7117,0,0,0,0,100,0), +(@PATH,37,-5176.264,1835.934,115.7117,0,0,0,0,100,0), +(@PATH,38,-5177.014,1835.434,115.9617,0,0,0,0,100,0), +(@PATH,39,-5180.514,1833.184,115.9617,0,0,0,0,100,0), +(@PATH,40,-5184.514,1830.434,115.9617,0,0,0,0,100,0), +(@PATH,41,-5189.206,1827.392,115.8212,0,0,0,0,100,0), +(@PATH,42,-5190.206,1824.892,115.8212,0,0,0,0,100,0), +(@PATH,43,-5193.306,1817.655,115.9371,0,0,0,0,100,0), +(@PATH,44,-5196.806,1817.155,115.9371,0,0,0,0,100,0), +(@PATH,45,-5203.056,1816.155,115.9371,0,0,0,0,100,0), +(@PATH,46,-5207.306,1815.405,116.1871,0,0,0,0,100,0), +(@PATH,47,-5211.806,1814.655,116.1871,0,0,0,0,100,0), +(@PATH,48,-5207.385,1815.425,116.2038,0,0,0,0,100,0), +(@PATH,49,-5203.135,1815.925,115.9538,0,0,0,0,100,0), +(@PATH,50,-5196.635,1816.925,115.9538,0,0,0,0,100,0), +(@PATH,51,-5164.098,1843.438,112.4156,0,0,0,0,100,0), +(@PATH,52,-5162.098,1848.938,111.1656,0,0,0,0,100,0), +(@PATH,53,-5160.598,1853.188,109.6656,0,0,0,0,100,0), +(@PATH,54,-5158.848,1857.438,107.4156,0,0,0,0,100,0), +(@PATH,55,-5157.848,1859.938,106.6656,0,0,0,0,100,0), +(@PATH,56,-5157.098,1862.188,105.9156,0,0,0,0,100,0), +(@PATH,57,-5156.598,1863.438,105.6656,0,0,0,0,100,0), +(@PATH,58,-5155.098,1866.938,104.9156,0,0,0,0,100,0), +(@PATH,59,-5154.773,1867.115,104.7181,0,0,0,0,100,0), +(@PATH,60,-5154.773,1867.615,104.4681,0,0,0,0,100,0), +(@PATH,61,-5152.773,1872.365,103.4681,0,0,0,0,100,0), +(@PATH,62,-5151.773,1875.115,101.9681,0,0,0,0,100,0), +(@PATH,63,-5151.023,1877.615,100.7181,0,0,0,0,100,0), +(@PATH,64,-5150.273,1879.615,100.2181,0,0,0,0,100,0), +(@PATH,65,-5148.273,1884.365,98.96815,0,0,0,0,100,0), +(@PATH,66,-5146.871,1888.411,99.34065,0,0,0,0,100,0), +(@PATH,67,-5147.371,1889.411,99.59065,0,0,0,0,100,0), +(@PATH,68,-5148.871,1892.661,99.84065,0,0,0,0,100,0), +(@PATH,69,-5150.871,1898.161,100.5907,0,0,0,0,100,0), +(@PATH,70,-5127.295,1907.314,97.67659,0,0,0,0,100,0), +(@PATH,71,-5124.045,1906.314,96.67659,0,0,0,0,100,0), +(@PATH,72,-5122.545,1907.314,96.17659,0,0,0,0,100,0), +(@PATH,73,-5117.045,1911.064,93.67659,0,0,0,0,100,0), +(@PATH,74,-5113.045,1913.564,91.42659,0,0,0,0,100,0), +(@PATH,75,-5111.045,1914.814,91.17659,0,0,0,0,100,0), +(@PATH,76,-5108.545,1916.564,90.42659,0,0,0,0,100,0), +(@PATH,77,-5105.457,1918.724,89.37218,0,0,0,0,100,0), +(@PATH,78,-5104.207,1921.224,89.12218,0,0,0,0,100,0), +(@PATH,79,-5101.707,1925.474,88.87218,0,0,0,0,100,0), +(@PATH,80,-5100.457,1927.474,88.62218,0,0,0,0,100,0), +(@PATH,81,-5098.011,1931.535,88.45503,0,0,0,0,100,0), +(@PATH,82,-5096.261,1928.285,88.45503,0,0,0,0,100,0), +(@PATH,83,-5094.761,1925.285,88.45503,0,0,0,0,100,0), +(@PATH,84,-5093.511,1922.285,88.20503,0,0,0,0,100,0), +(@PATH,85,-5090.511,1917.035,88.20503,0,0,0,0,100,0), +(@PATH,86,-5089.261,1914.785,88.20503,0,0,0,0,100,0), +(@PATH,87,-5088.261,1913.035,88.20503,0,0,0,0,100,0), +(@PATH,88,-5088.111,1912.727,88.17467,0,0,0,0,100,0), +(@PATH,89,-5087.361,1911.477,88.17467,0,0,0,0,100,0), +(@PATH,90,-5083.611,1911.727,88.17467,0,0,0,0,100,0), +(@PATH,91,-5082.611,1911.727,88.17467,0,0,0,0,100,0), +(@PATH,92,-5077.361,1911.977,88.17467,0,0,0,0,100,0), +(@PATH,93,-5071.111,1912.477,88.42467,0,0,0,0,100,0), +(@PATH,94,-5070.89,1912.315,88.42027,0,0,0,0,100,0), +(@PATH,95,-5068.89,1912.315,88.42027,0,0,0,0,100,0), +(@PATH,96,-5068.39,1910.565,88.67027,0,0,0,0,100,0), +(@PATH,97,-5066.89,1905.565,88.67027,0,0,0,0,100,0), +(@PATH,98,-5063.64,1900.565,88.67027,0,0,0,0,100,0), +(@PATH,99,-5063.39,1898.815,88.67027,0,0,0,0,100,0), +(@PATH,100,-5063.39,1896.565,88.42027,0,0,0,0,100,0), +(@PATH,101,-5064.14,1895.065,88.17027,0,0,0,0,100,0), +(@PATH,102,-5063.14,1891.815,87.67027,0,0,0,0,100,0), +(@PATH,103,-5062.39,1888.815,87.17027,0,0,0,0,100,0), +(@PATH,104,-5060.89,1883.065,85.92027,0,0,0,0,100,0), +(@PATH,105,-5042.119,1841.802,79.61683,0,0,0,0,100,0), +(@PATH,106,-5043.619,1846.802,80.11683,0,0,0,0,100,0), +(@PATH,107,-5044.369,1848.802,80.36683,0,0,0,0,100,0), +(@PATH,108,-5045.619,1852.802,80.86683,0,0,0,0,100,0), +(@PATH,109,-5046.119,1855.302,81.61683,0,0,0,0,100,0), +(@PATH,110,-5047.327,1858.863,82.2243,0,0,0,0,100,0), +(@PATH,111,-5049.827,1862.613,82.9743,0,0,0,0,100,0), +(@PATH,112,-5052.827,1867.363,82.9743,0,0,0,0,100,0), +(@PATH,113,-5054.327,1870.113,82.9743,0,0,0,0,100,0), +(@PATH,114,-5055.827,1872.863,83.4743,0,0,0,0,100,0), +(@PATH,115,-5059.077,1877.863,84.4743,0,0,0,0,100,0); + +-- Pathing for Entry: 39896 'TDB FORMAT' +SET @NPC := 369590; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5001.24,`position_y`=1768.249,`position_z`=64.21053 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,-5001.24,1768.249,64.21053,0,0,0,0,100,0), +(@PATH,2,-4998.74,1766.499,63.96053,0,0,0,0,100,0), +(@PATH,3,-4992.99,1762.499,63.96053,0,0,0,0,100,0), +(@PATH,4,-4987.24,1758.249,64.21053,0,0,0,0,100,0), +(@PATH,5,-4983.24,1755.249,63.96053,0,0,0,0,100,0), +(@PATH,6,-4979.115,1752.252,64.80772,0,0,0,0,100,0), +(@PATH,7,-4976.365,1750.502,64.80772,0,0,0,0,100,0), +(@PATH,8,-4972.865,1748.002,64.80772,0,0,0,0,100,0), +(@PATH,9,-4970.865,1747.002,64.80772,0,0,0,0,100,0), +(@PATH,10,-4967.115,1744.502,64.05772,0,0,0,0,100,0), +(@PATH,11,-4964.615,1742.002,63.80772,0,0,0,0,100,0), +(@PATH,12,-4959.071,1739.508,63.72679,0,0,0,0,100,0), +(@PATH,13,-4954.821,1736.758,63.22679,0,0,0,0,100,0), +(@PATH,14,-4950.821,1734.258,62.47679,0,0,0,0,100,0), +(@PATH,15,-4945.821,1731.008,62.97679,0,0,0,0,100,0), +(@PATH,16,-4944.321,1729.758,63.72679,0,0,0,0,100,0), +(@PATH,17,-4943.981,1729.512,63.63435,0,0,0,0,100,0), +(@PATH,18,-4941.981,1728.262,64.13435,0,0,0,0,100,0), +(@PATH,19,-4943.481,1725.012,63.63435,0,0,0,0,100,0), +(@PATH,20,-4943.481,1720.762,63.38435,0,0,0,0,100,0), +(@PATH,21,-4943.481,1716.762,63.13435,0,0,0,0,100,0), +(@PATH,22,-4942.731,1708.512,63.38435,0,0,0,0,100,0), +(@PATH,23,-4943.231,1706.512,63.63435,0,0,0,0,100,0), +(@PATH,24,-4943.481,1704.262,64.13435,0,0,0,0,100,0), +(@PATH,25,-4943.231,1702.512,64.63435,0,0,0,0,100,0), +(@PATH,26,-4942.731,1701.012,64.38435,0,0,0,0,100,0), +(@PATH,27,-4942.068,1700.842,64.25357,0,0,0,0,100,0), +(@PATH,28,-4942.318,1702.592,64.25357,0,0,0,0,100,0), +(@PATH,29,-4943.068,1706.092,63.50357,0,0,0,0,100,0), +(@PATH,30,-4942.568,1708.592,63.25357,0,0,0,0,100,0), +(@PATH,31,-4941.818,1722.342,64.00357,0,0,0,0,100,0), +(@PATH,32,-4941.955,1728.461,64.07486,0,0,0,0,100,0), +(@PATH,33,-4945.205,1730.461,63.32486,0,0,0,0,100,0), +(@PATH,34,-4946.955,1731.711,62.82486,0,0,0,0,100,0), +(@PATH,35,-4955.205,1736.961,63.32486,0,0,0,0,100,0), +(@PATH,36,-4959.348,1739.75,63.77706,0,0,0,0,100,0), +(@PATH,37,-4960.348,1742,63.77706,0,0,0,0,100,0), +(@PATH,38,-4962.598,1744,64.02705,0,0,0,0,100,0), +(@PATH,39,-4966.598,1744.5,64.02705,0,0,0,0,100,0), +(@PATH,40,-4968.598,1744.75,64.27705,0,0,0,0,100,0), +(@PATH,41,-4971.098,1746.25,64.77705,0,0,0,0,100,0), +(@PATH,42,-4973.348,1748,64.77705,0,0,0,0,100,0), +(@PATH,43,-4976.598,1750.5,65.02705,0,0,0,0,100,0), +(@PATH,44,-4979.223,1752.423,64.66101,0,0,0,0,100,0), +(@PATH,45,-4982.723,1755.173,63.66101,0,0,0,0,100,0), +(@PATH,46,-4987.223,1758.423,63.91101,0,0,0,0,100,0), +(@PATH,47,-4992.973,1762.423,63.91101,0,0,0,0,100,0), +(@PATH,48,-4999.062,1766.902,64.06219,0,0,0,0,100,0), +(@PATH,49,-5000.562,1767.902,64.06219,0,0,0,0,100,0), +(@PATH,50,-5006.312,1771.652,64.81219,0,0,0,0,100,0), +(@PATH,51,-5011.562,1775.402,66.06219,0,0,0,0,100,0), +(@PATH,52,-5017.062,1778.902,67.31219,0,0,0,0,100,0), +(@PATH,53,-5019.312,1780.402,68.06219,0,0,0,0,100,0), +(@PATH,54,-5022.812,1782.652,69.56219,0,0,0,0,100,0), +(@PATH,55,-5029.129,1787.173,71.5519,0,0,0,0,100,0), +(@PATH,56,-5029.879,1787.673,71.5519,0,0,0,0,100,0), +(@PATH,57,-5034.379,1791.923,72.3019,0,0,0,0,100,0), +(@PATH,58,-5039.879,1796.923,74.0519,0,0,0,0,100,0), +(@PATH,59,-5043.629,1800.173,75.5519,0,0,0,0,100,0), +(@PATH,60,-5043.852,1800.443,75.63571,0,0,0,0,100,0), +(@PATH,61,-5045.852,1802.193,76.13571,0,0,0,0,100,0), +(@PATH,62,-5048.852,1804.943,76.63571,0,0,0,0,100,0), +(@PATH,63,-5050.102,1805.943,76.88571,0,0,0,0,100,0), +(@PATH,64,-5051.602,1807.193,76.88571,0,0,0,0,100,0), +(@PATH,65,-5055.602,1810.693,77.13571,0,0,0,0,100,0), +(@PATH,66,-5065.852,1819.443,77.63571,0,0,0,0,100,0), +(@PATH,67,-5055.949,1810.9,77.07452,0,0,0,0,100,0), +(@PATH,68,-5051.699,1807.15,76.82452,0,0,0,0,100,0), +(@PATH,69,-5049.949,1805.9,76.82452,0,0,0,0,100,0), +(@PATH,70,-5048.949,1804.9,76.57452,0,0,0,0,100,0), +(@PATH,71,-5045.414,1801.948,75.76241,0,0,0,0,100,0), +(@PATH,72,-5043.664,1800.198,75.51241,0,0,0,0,100,0), +(@PATH,73,-5039.914,1796.948,74.01241,0,0,0,0,100,0), +(@PATH,74,-5034.414,1791.948,72.26241,0,0,0,0,100,0), +(@PATH,75,-5029.914,1787.698,71.51241,0,0,0,0,100,0), +(@PATH,76,-5029.52,1787.508,71.33578,0,0,0,0,100,0), +(@PATH,77,-5029.02,1787.008,71.08578,0,0,0,0,100,0), +(@PATH,78,-5022.77,1782.758,69.58578,0,0,0,0,100,0), +(@PATH,79,-5019.27,1780.508,68.08578,0,0,0,0,100,0), +(@PATH,80,-5017.02,1778.758,67.58578,0,0,0,0,100,0), +(@PATH,81,-5011.52,1775.258,66.08578,0,0,0,0,100,0), +(@PATH,82,-5006.27,1771.758,64.83578,0,0,0,0,100,0); + +-- Pathing for Entry: 39896 'TDB FORMAT' +SET @NPC := 369600; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5047.363,`position_y`=1859.163,`position_z`=82.0366 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,-5047.363,1859.163,82.0366,0,0,0,0,100,0), +(@PATH,2,-5047.113,1858.663,82.0366,0,0,0,0,100,0), +(@PATH,3,-5046.113,1855.413,81.5366,0,0,0,0,100,0), +(@PATH,4,-5045.613,1852.663,81.0366,0,0,0,0,100,0), +(@PATH,5,-5044.363,1848.913,80.5366,0,0,0,0,100,0), +(@PATH,6,-5043.613,1846.913,80.0366,0,0,0,0,100,0), +(@PATH,7,-5042.363,1842.413,79.7866,0,0,0,0,100,0), +(@PATH,8,-5042.238,1842.199,79.49808,0,0,0,0,100,0), +(@PATH,9,-5041.988,1841.699,79.24808,0,0,0,0,100,0), +(@PATH,10,-5044.738,1837.949,78.99808,0,0,0,0,100,0), +(@PATH,11,-5045.738,1836.449,78.74808,0,0,0,0,100,0), +(@PATH,12,-5047.738,1833.949,78.99808,0,0,0,0,100,0), +(@PATH,13,-5049.488,1830.949,78.74808,0,0,0,0,100,0), +(@PATH,14,-5049.383,1831.004,78.81633,0,0,0,0,100,0), +(@PATH,15,-5047.633,1833.754,78.81633,0,0,0,0,100,0), +(@PATH,16,-5045.883,1836.254,78.81633,0,0,0,0,100,0), +(@PATH,17,-5044.633,1838.004,78.81633,0,0,0,0,100,0), +(@PATH,18,-5042.156,1841.896,79.56831,0,0,0,0,100,0), +(@PATH,19,-5043.656,1846.896,80.06831,0,0,0,0,100,0), +(@PATH,20,-5044.406,1848.646,80.31831,0,0,0,0,100,0), +(@PATH,21,-5045.656,1852.896,81.06831,0,0,0,0,100,0), +(@PATH,22,-5046.156,1855.396,81.56831,0,0,0,0,100,0); + +-- Pathing for Entry: 39896 'TDB FORMAT' +SET @NPC := 369185; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4973.422,`position_y`=1630.721,`position_z`=62.77911 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,-4973.422,1630.721,62.77911,0,0,0,0,100,0), +(@PATH,2,-4974.422,1624.971,63.27911,0,0,0,0,100,0), +(@PATH,3,-4975.172,1620.721,63.27911,0,0,0,0,100,0), +(@PATH,4,-4976.172,1615.721,64.27911,0,0,0,0,100,0), +(@PATH,5,-4977.417,1609.576,64.41733,0,0,0,0,100,0), +(@PATH,6,-4980.167,1606.576,63.91733,0,0,0,0,100,0), +(@PATH,7,-4983.667,1602.576,63.91733,0,0,0,0,100,0), +(@PATH,8,-4984.167,1600.326,63.91733,0,0,0,0,100,0), +(@PATH,9,-4987.167,1597.076,63.41733,0,0,0,0,100,0), +(@PATH,10,-4988.167,1596.076,63.16733,0,0,0,0,100,0), +(@PATH,11,-4988.167,1594.076,62.91733,0,0,0,0,100,0), +(@PATH,12,-4988.917,1591.826,63.16733,0,0,0,0,100,0), +(@PATH,13,-4988.917,1590.826,63.16733,0,0,0,0,100,0), +(@PATH,14,-4988.917,1589.826,63.16733,0,0,0,0,100,0), +(@PATH,15,-4989.033,1589.586,62.81723,0,0,0,0,100,0), +(@PATH,16,-4989.033,1588.336,62.81723,0,0,0,0,100,0), +(@PATH,17,-4989.783,1584.586,61.81723,0,0,0,0,100,0), +(@PATH,18,-4990.283,1582.586,61.31723,0,0,0,0,100,0), +(@PATH,19,-4990.533,1580.586,60.81723,0,0,0,0,100,0), +(@PATH,20,-4991.033,1578.586,60.06723,0,0,0,0,100,0), +(@PATH,21,-4993.783,1564.336,60.56723,0,0,0,0,100,0), +(@PATH,22,-4994.547,1561.715,60.72686,0,0,0,0,100,0), +(@PATH,23,-4995.547,1556.715,61.22686,0,0,0,0,100,0), +(@PATH,24,-4996.797,1549.215,60.47686,0,0,0,0,100,0), +(@PATH,25,-4997.297,1545.215,59.72686,0,0,0,0,100,0), +(@PATH,26,-4997.797,1543.215,58.97686,0,0,0,0,100,0), +(@PATH,27,-4998.547,1539.465,58.47686,0,0,0,0,100,0), +(@PATH,28,-4998.797,1537.465,57.72686,0,0,0,0,100,0), +(@PATH,29,-4998.746,1538.496,58.34804,0,0,0,0,100,0), +(@PATH,30,-4997.996,1542.496,58.84804,0,0,0,0,100,0), +(@PATH,31,-4997.496,1544.246,59.59804,0,0,0,0,100,0), +(@PATH,32,-4996.996,1547.246,60.09804,0,0,0,0,100,0), +(@PATH,33,-4996.746,1549.996,61.09804,0,0,0,0,100,0), +(@PATH,34,-4994.267,1562.094,60.8521,0,0,0,0,100,0), +(@PATH,35,-4993.017,1567.844,60.1021,0,0,0,0,100,0), +(@PATH,36,-4992.017,1573.594,59.6021,0,0,0,0,100,0), +(@PATH,37,-4990.767,1579.344,60.3521,0,0,0,0,100,0), +(@PATH,38,-4990.517,1581.344,60.8521,0,0,0,0,100,0), +(@PATH,39,-4989.767,1584.344,61.6021,0,0,0,0,100,0), +(@PATH,40,-4989.517,1586.094,62.3521,0,0,0,0,100,0), +(@PATH,41,-4989.094,1586.458,62.72576,0,0,0,0,100,0), +(@PATH,42,-4988.594,1588.708,62.97576,0,0,0,0,100,0), +(@PATH,43,-4987.344,1588.708,62.97576,0,0,0,0,100,0), +(@PATH,44,-4986.094,1590.458,63.72576,0,0,0,0,100,0), +(@PATH,45,-4985.094,1591.958,63.97576,0,0,0,0,100,0), +(@PATH,46,-4983.344,1593.958,64.22575,0,0,0,0,100,0), +(@PATH,47,-4980.094,1599.958,63.97576,0,0,0,0,100,0), +(@PATH,48,-4979.344,1602.458,63.97576,0,0,0,0,100,0), +(@PATH,49,-4979.094,1603.208,64.22575,0,0,0,0,100,0), +(@PATH,50,-4978.594,1605.458,64.47575,0,0,0,0,100,0), +(@PATH,51,-4977.145,1609.706,64.54192,0,0,0,0,100,0), +(@PATH,52,-4976.145,1615.456,64.29192,0,0,0,0,100,0), +(@PATH,53,-4975.395,1619.706,63.29192,0,0,0,0,100,0), +(@PATH,54,-4974.395,1624.956,63.29192,0,0,0,0,100,0), +(@PATH,55,-4973.047,1630.934,62.6662,0,0,0,0,100,0), +(@PATH,56,-4971.547,1633.434,62.6662,0,0,0,0,100,0), +(@PATH,57,-4970.797,1634.434,62.4162,0,0,0,0,100,0), +(@PATH,58,-4970.047,1635.684,62.4162,0,0,0,0,100,0), +(@PATH,59,-4967.797,1639.184,63.4162,0,0,0,0,100,0), +(@PATH,60,-4966.297,1641.434,63.9162,0,0,0,0,100,0), +(@PATH,61,-4965.297,1642.934,64.6662,0,0,0,0,100,0), +(@PATH,62,-4966,1641.778,63.98844,0,0,0,0,100,0), +(@PATH,63,-4965,1643.278,64.73844,0,0,0,0,100,0), +(@PATH,64,-4964,1644.778,64.48844,0,0,0,0,100,0), +(@PATH,65,-4961,1648.028,63.98844,0,0,0,0,100,0), +(@PATH,66,-4959,1650.278,63.73844,0,0,0,0,100,0), +(@PATH,67,-4954.75,1654.778,62.98844,0,0,0,0,100,0), +(@PATH,68,-4952.5,1657.278,62.98844,0,0,0,0,100,0), +(@PATH,69,-4951.25,1658.528,62.98844,0,0,0,0,100,0), +(@PATH,70,-4949.171,1660.598,63.24642,0,0,0,0,100,0), +(@PATH,71,-4948.171,1663.598,63.24642,0,0,0,0,100,0), +(@PATH,72,-4946.171,1668.598,63.99642,0,0,0,0,100,0), +(@PATH,73,-4944.715,1672.728,63.90578,0,0,0,0,100,0), +(@PATH,74,-4944.465,1678.978,63.90578,0,0,0,0,100,0), +(@PATH,75,-4944.465,1680.478,63.15578,0,0,0,0,100,0), +(@PATH,76,-4944.465,1683.728,62.90578,0,0,0,0,100,0), +(@PATH,77,-4944.215,1685.728,63.15578,0,0,0,0,100,0), +(@PATH,78,-4944.215,1689.728,64.15578,0,0,0,0,100,0), +(@PATH,79,-4943.901,1689.826,64.15288,0,0,0,0,100,0), +(@PATH,80,-4943.901,1690.326,64.15288,0,0,0,0,100,0), +(@PATH,81,-4943.651,1692.326,64.40288,0,0,0,0,100,0), +(@PATH,82,-4942.901,1696.326,64.40288,0,0,0,0,100,0), +(@PATH,83,-4942.151,1700.326,64.40288,0,0,0,0,100,0), +(@PATH,84,-4941.901,1702.576,64.15288,0,0,0,0,100,0), +(@PATH,85,-4941.377,1704.209,63.32629,0,0,0,0,100,0), +(@PATH,86,-4928.377,1706.459,63.82629,0,0,0,0,100,0), +(@PATH,87,-4924.445,1707.069,64.41909,0,0,0,0,100,0), +(@PATH,88,-4927.195,1714.819,63.91909,0,0,0,0,100,0), +(@PATH,89,-4930.695,1724.819,64.41909,0,0,0,0,100,0), +(@PATH,90,-4931.695,1727.569,64.91909,0,0,0,0,100,0), +(@PATH,91,-4931.808,1727.865,65.0726,0,0,0,0,100,0), +(@PATH,92,-4932.308,1729.115,65.0726,0,0,0,0,100,0), +(@PATH,93,-4936.558,1733.365,64.5726,0,0,0,0,100,0), +(@PATH,94,-4938.058,1734.615,64.0726,0,0,0,0,100,0), +(@PATH,95,-4940.058,1736.615,63.3226,0,0,0,0,100,0), +(@PATH,96,-4946.058,1743.115,64.0726,0,0,0,0,100,0), +(@PATH,97,-4948.308,1745.115,65.0726,0,0,0,0,100,0), +(@PATH,98,-4949.058,1745.865,65.3226,0,0,0,0,100,0), +(@PATH,99,-4949.199,1745.917,65.47873,0,0,0,0,100,0), +(@PATH,100,-4950.449,1747.167,65.97873,0,0,0,0,100,0), +(@PATH,101,-4953.699,1744.667,64.97873,0,0,0,0,100,0), +(@PATH,102,-4956.949,1742.167,64.22873,0,0,0,0,100,0), +(@PATH,103,-4966.949,1734.667,64.72873,0,0,0,0,100,0), +(@PATH,104,-4968.699,1733.667,65.47873,0,0,0,0,100,0), +(@PATH,105,-4968.259,1733.736,65.18924,0,0,0,0,100,0), +(@PATH,106,-4965.759,1735.736,64.43924,0,0,0,0,100,0), +(@PATH,107,-4962.509,1737.986,63.93924,0,0,0,0,100,0), +(@PATH,108,-4955.759,1743.236,64.43924,0,0,0,0,100,0), +(@PATH,109,-4953.259,1744.986,65.18924,0,0,0,0,100,0), +(@PATH,110,-4950.294,1747.176,65.88656,0,0,0,0,100,0), +(@PATH,111,-4949.544,1746.426,65.38656,0,0,0,0,100,0), +(@PATH,112,-4948.044,1744.926,65.13656,0,0,0,0,100,0), +(@PATH,113,-4947.294,1744.176,64.38656,0,0,0,0,100,0), +(@PATH,114,-4945.294,1742.176,63.63656,0,0,0,0,100,0), +(@PATH,115,-4937.794,1734.426,64.38656,0,0,0,0,100,0), +(@PATH,116,-4936.294,1733.176,64.88656,0,0,0,0,100,0), +(@PATH,117,-4932.794,1729.676,65.13656,0,0,0,0,100,0), +(@PATH,118,-4932.478,1729.223,65.16427,0,0,0,0,100,0), +(@PATH,119,-4931.978,1728.723,65.16427,0,0,0,0,100,0), +(@PATH,120,-4930.478,1723.973,64.41427,0,0,0,0,100,0), +(@PATH,121,-4929.728,1722.223,63.91427,0,0,0,0,100,0), +(@PATH,122,-4924.978,1708.223,64.41427,0,0,0,0,100,0), +(@PATH,123,-4929.899,1707.092,63.56551,0,0,0,0,100,0), +(@PATH,124,-4936.649,1703.842,63.06551,0,0,0,0,100,0), +(@PATH,125,-4941.625,1703.988,63.47919,0,0,0,0,100,0), +(@PATH,126,-4941.125,1704.738,63.22919,0,0,0,0,100,0), +(@PATH,127,-4941.625,1703.238,63.97919,0,0,0,0,100,0), +(@PATH,128,-4941.625,1702.488,64.22919,0,0,0,0,100,0), +(@PATH,129,-4941.875,1700.488,64.47919,0,0,0,0,100,0), +(@PATH,130,-4942.625,1696.488,64.47919,0,0,0,0,100,0), +(@PATH,131,-4943.625,1692.238,64.22919,0,0,0,0,100,0), +(@PATH,132,-4943.844,1692.135,64.19696,0,0,0,0,100,0), +(@PATH,133,-4944.094,1690.135,64.44696,0,0,0,0,100,0), +(@PATH,134,-4944.094,1685.635,62.94696,0,0,0,0,100,0), +(@PATH,135,-4944.094,1683.635,62.94696,0,0,0,0,100,0), +(@PATH,136,-4944.094,1680.885,63.19696,0,0,0,0,100,0), +(@PATH,137,-4944.344,1678.885,63.94696,0,0,0,0,100,0), +(@PATH,138,-4944.533,1672.813,63.93799,0,0,0,0,100,0), +(@PATH,139,-4946.283,1668.813,63.93799,0,0,0,0,100,0), +(@PATH,140,-4948.033,1663.563,63.18799,0,0,0,0,100,0), +(@PATH,141,-4948.37,1663.218,63.10269,0,0,0,0,100,0), +(@PATH,142,-4949.62,1660.468,63.35269,0,0,0,0,100,0), +(@PATH,143,-4951.12,1658.718,63.10269,0,0,0,0,100,0), +(@PATH,144,-4952.37,1657.218,62.85269,0,0,0,0,100,0), +(@PATH,145,-4954.87,1654.718,63.10269,0,0,0,0,100,0), +(@PATH,146,-4958.37,1650.968,63.85269,0,0,0,0,100,0), +(@PATH,147,-4960.87,1648.218,63.85269,0,0,0,0,100,0), +(@PATH,148,-4964.186,1644.522,64.42334,0,0,0,0,100,0), +(@PATH,149,-4965.436,1643.022,64.67334,0,0,0,0,100,0), +(@PATH,150,-4966.186,1641.522,63.92334,0,0,0,0,100,0), +(@PATH,151,-4967.686,1639.272,63.17334,0,0,0,0,100,0), +(@PATH,152,-4969.936,1635.522,62.42334,0,0,0,0,100,0), +(@PATH,153,-4970.686,1634.522,62.42334,0,0,0,0,100,0), +(@PATH,154,-4971.436,1633.522,62.67334,0,0,0,0,100,0), +(@PATH,155,-4971.658,1633.128,62.50164,0,0,0,0,100,0), +(@PATH,156,-4973.408,1630.628,62.75164,0,0,0,0,100,0), +(@PATH,157,-4974.408,1624.878,63.25164,0,0,0,0,100,0), +(@PATH,158,-4975.158,1620.628,63.25164,0,0,0,0,100,0), +(@PATH,159,-4976.158,1615.878,64.25164,0,0,0,0,100,0); + +-- Pathing for Entry: 5236 'TDB FORMAT' +SET @NPC := 369407; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5384.672,`position_y`=1387.404,`position_z`=25.32841 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,-5384.672,1387.404,25.32841,0,0,0,0,100,0), +(@PATH,2,-5399.672,1391.654,25.57841,0,0,0,0,100,0), +(@PATH,3,-5404.249,1393.155,25.91425,0,0,0,0,100,0), +(@PATH,4,-5423.228,1386.175,25.8961,0,0,0,0,100,0), +(@PATH,5,-5438.978,1379.925,25.3961,0,0,0,0,100,0), +(@PATH,6,-5444.228,1377.925,24.6461,0,0,0,0,100,0), +(@PATH,7,-5447.978,1376.175,24.1461,0,0,0,0,100,0), +(@PATH,8,-5453.478,1373.925,23.6461,0,0,0,0,100,0), +(@PATH,9,-5458.228,1372.175,22.8961,0,0,0,0,100,0), +(@PATH,10,-5463.728,1369.925,22.1461,0,0,0,0,100,0), +(@PATH,11,-5461.646,1370.653,22.63385,0,0,0,0,100,0), +(@PATH,12,-5457.896,1372.153,23.13385,0,0,0,0,100,0), +(@PATH,13,-5452.396,1374.403,23.63385,0,0,0,0,100,0), +(@PATH,14,-5447.646,1376.403,24.13385,0,0,0,0,100,0), +(@PATH,15,-5443.396,1377.903,24.88385,0,0,0,0,100,0), +(@PATH,16,-5437.896,1380.403,25.38385,0,0,0,0,100,0), +(@PATH,17,-5424.896,1385.653,26.13385,0,0,0,0,100,0), +(@PATH,18,-5424.693,1385.957,26.02224,0,0,0,0,100,0), +(@PATH,19,-5422.943,1386.457,26.02224,0,0,0,0,100,0), +(@PATH,20,-5403.863,1393.139,26.11966,0,0,0,0,100,0), +(@PATH,21,-5398.113,1391.389,25.36966,0,0,0,0,100,0), +(@PATH,22,-5384.617,1387.174,25.06379,0,0,0,0,100,0), +(@PATH,23,-5384.867,1373.424,24.31379,0,0,0,0,100,0), +(@PATH,24,-5385.117,1366.424,24.06379,0,0,0,0,100,0), +(@PATH,25,-5384.872,1366.115,24.1675,0,0,0,0,100,0), +(@PATH,26,-5384.872,1362.615,23.6675,0,0,0,0,100,0), +(@PATH,27,-5380.372,1358.615,24.1675,0,0,0,0,100,0), +(@PATH,28,-5377.622,1356.115,24.9175,0,0,0,0,100,0), +(@PATH,29,-5374.872,1353.365,25.4175,0,0,0,0,100,0), +(@PATH,30,-5371.122,1350.115,26.1675,0,0,0,0,100,0), +(@PATH,31,-5367.95,1347.216,26.9676,0,0,0,0,100,0), +(@PATH,32,-5364.95,1347.716,27.7176,0,0,0,0,100,0), +(@PATH,33,-5362.95,1347.966,28.2176,0,0,0,0,100,0), +(@PATH,34,-5361.2,1348.216,28.7176,0,0,0,0,100,0), +(@PATH,35,-5359.2,1348.466,29.7176,0,0,0,0,100,0), +(@PATH,36,-5360.945,1348.064,29.05567,0,0,0,0,100,0), +(@PATH,37,-5359.195,1348.314,30.05567,0,0,0,0,100,0), +(@PATH,38,-5355.445,1348.814,30.55567,0,0,0,0,100,0), +(@PATH,39,-5354.195,1345.064,31.30567,0,0,0,0,100,0), +(@PATH,40,-5353.445,1342.064,32.05566,0,0,0,0,100,0), +(@PATH,41,-5351.115,1334.797,32.65763,0,0,0,0,100,0), +(@PATH,42,-5348.615,1331.797,33.65763,0,0,0,0,100,0), +(@PATH,43,-5346.865,1329.797,34.40763,0,0,0,0,100,0), +(@PATH,44,-5345.365,1328.297,34.90763,0,0,0,0,100,0), +(@PATH,45,-5345.218,1328.136,35.16136,0,0,0,0,100,0), +(@PATH,46,-5343.968,1326.636,35.66136,0,0,0,0,100,0), +(@PATH,47,-5340.968,1326.886,36.41136,0,0,0,0,100,0), +(@PATH,48,-5338.968,1327.136,36.91136,0,0,0,0,100,0), +(@PATH,49,-5337.218,1327.136,37.41136,0,0,0,0,100,0), +(@PATH,50,-5335.218,1327.136,38.16136,0,0,0,0,100,0), +(@PATH,51,-5333.218,1327.386,38.91136,0,0,0,0,100,0), +(@PATH,52,-5331.218,1327.386,39.66136,0,0,0,0,100,0), +(@PATH,53,-5333.025,1327.134,39.23707,0,0,0,0,100,0), +(@PATH,54,-5331.025,1327.134,39.98707,0,0,0,0,100,0), +(@PATH,55,-5329.775,1327.384,40.23707,0,0,0,0,100,0), +(@PATH,56,-5326.025,1326.884,40.98707,0,0,0,0,100,0), +(@PATH,57,-5324.025,1326.634,41.73707,0,0,0,0,100,0), +(@PATH,58,-5321.025,1326.134,42.48707,0,0,0,0,100,0), +(@PATH,59,-5319.275,1325.884,42.98707,0,0,0,0,100,0), +(@PATH,60,-5317.275,1325.634,43.73707,0,0,0,0,100,0), +(@PATH,61,-5315.275,1325.634,44.48707,0,0,0,0,100,0), +(@PATH,62,-5313.275,1325.384,45.23707,0,0,0,0,100,0), +(@PATH,63,-5311.275,1325.134,45.98707,0,0,0,0,100,0), +(@PATH,64,-5309.275,1324.884,46.48707,0,0,0,0,100,0), +(@PATH,65,-5309.179,1324.586,46.75322,0,0,0,0,100,0), +(@PATH,66,-5305.429,1324.336,47.00322,0,0,0,0,100,0), +(@PATH,67,-5298.929,1321.836,46.50322,0,0,0,0,100,0), +(@PATH,68,-5292.429,1319.836,47.00322,0,0,0,0,100,0), +(@PATH,69,-5288.679,1318.586,47.75322,0,0,0,0,100,0), +(@PATH,70,-5285.624,1317.202,48.78952,0,0,0,0,100,0), +(@PATH,71,-5285.124,1315.452,49.28952,0,0,0,0,100,0), +(@PATH,72,-5284.374,1312.452,49.78952,0,0,0,0,100,0), +(@PATH,73,-5283.374,1309.702,50.28952,0,0,0,0,100,0), +(@PATH,74,-5282.124,1306.202,51.03952,0,0,0,0,100,0), +(@PATH,75,-5282.202,1305.76,51.01323,0,0,0,0,100,0), +(@PATH,76,-5280.202,1300.26,51.01323,0,0,0,0,100,0), +(@PATH,77,-5280.209,1300.244,50.96265,0,0,0,0,100,0), +(@PATH,78,-5280.11,1300.516,51.12962,0,0,0,0,100,0), +(@PATH,79,-5283.36,1309.766,50.37962,0,0,0,0,100,0), +(@PATH,80,-5284.11,1312.516,49.62962,0,0,0,0,100,0), +(@PATH,81,-5285.11,1315.516,49.37962,0,0,0,0,100,0), +(@PATH,82,-5284.322,1312.79,49.73395,0,0,0,0,100,0), +(@PATH,83,-5285.322,1315.79,48.98395,0,0,0,0,100,0), +(@PATH,84,-5285.822,1317.54,48.48395,0,0,0,0,100,0), +(@PATH,85,-5288.572,1318.29,47.98395,0,0,0,0,100,0), +(@PATH,86,-5292.322,1319.54,47.23395,0,0,0,0,100,0), +(@PATH,87,-5295.072,1320.54,46.48395,0,0,0,0,100,0), +(@PATH,88,-5304.572,1323.79,47.23395,0,0,0,0,100,0), +(@PATH,89,-5304.686,1324.22,46.91312,0,0,0,0,100,0), +(@PATH,90,-5305.686,1324.47,46.91312,0,0,0,0,100,0), +(@PATH,91,-5309.686,1324.97,46.16312,0,0,0,0,100,0), +(@PATH,92,-5312.686,1325.22,45.16312,0,0,0,0,100,0), +(@PATH,93,-5314.686,1325.22,44.41312,0,0,0,0,100,0), +(@PATH,94,-5316.436,1325.47,43.66312,0,0,0,0,100,0), +(@PATH,95,-5319.436,1325.97,43.16312,0,0,0,0,100,0), +(@PATH,96,-5321.436,1326.22,42.66312,0,0,0,0,100,0), +(@PATH,97,-5323.436,1326.47,41.91312,0,0,0,0,100,0), +(@PATH,98,-5326.436,1326.72,40.91312,0,0,0,0,100,0), +(@PATH,99,-5329.436,1327.22,40.16312,0,0,0,0,100,0), +(@PATH,100,-5326.469,1326.865,40.76016,0,0,0,0,100,0), +(@PATH,101,-5329.469,1327.115,40.01016,0,0,0,0,100,0), +(@PATH,102,-5330.219,1327.365,39.76016,0,0,0,0,100,0), +(@PATH,103,-5332.219,1327.115,39.26016,0,0,0,0,100,0), +(@PATH,104,-5334.219,1327.115,38.76016,0,0,0,0,100,0), +(@PATH,105,-5335.969,1326.865,38.01016,0,0,0,0,100,0), +(@PATH,106,-5337.969,1326.865,37.26016,0,0,0,0,100,0), +(@PATH,107,-5340.969,1326.615,36.26016,0,0,0,0,100,0), +(@PATH,108,-5342.969,1326.615,35.76016,0,0,0,0,100,0), +(@PATH,109,-5341.169,1327.001,36.05104,0,0,0,0,100,0), +(@PATH,110,-5343.169,1326.751,35.30104,0,0,0,0,100,0), +(@PATH,111,-5344.169,1326.751,35.30104,0,0,0,0,100,0), +(@PATH,112,-5345.919,1329.001,34.55104,0,0,0,0,100,0), +(@PATH,113,-5347.169,1330.501,34.05104,0,0,0,0,100,0), +(@PATH,114,-5349.169,1332.501,33.05104,0,0,0,0,100,0), +(@PATH,115,-5347.541,1330.62,33.87894,0,0,0,0,100,0), +(@PATH,116,-5349.541,1332.87,32.87894,0,0,0,0,100,0), +(@PATH,117,-5351.291,1335.12,32.37894,0,0,0,0,100,0), +(@PATH,118,-5353.541,1343.37,32.12894,0,0,0,0,100,0), +(@PATH,119,-5354.541,1346.37,31.12894,0,0,0,0,100,0), +(@PATH,120,-5353.813,1343.59,31.7054,0,0,0,0,100,0), +(@PATH,121,-5354.563,1346.34,30.9554,0,0,0,0,100,0), +(@PATH,122,-5355.313,1348.84,30.4554,0,0,0,0,100,0), +(@PATH,123,-5358.313,1348.34,29.7054,0,0,0,0,100,0), +(@PATH,124,-5360.313,1348.09,29.2054,0,0,0,0,100,0), +(@PATH,125,-5362.063,1347.84,28.7054,0,0,0,0,100,0), +(@PATH,126,-5364.063,1347.34,27.9554,0,0,0,0,100,0), +(@PATH,127,-5367.063,1347.09,27.2054,0,0,0,0,100,0), +(@PATH,128,-5364.349,1347.702,27.68379,0,0,0,0,100,0), +(@PATH,129,-5367.349,1347.202,26.93379,0,0,0,0,100,0), +(@PATH,130,-5368.099,1347.202,26.93379,0,0,0,0,100,0), +(@PATH,131,-5371.099,1349.952,25.93379,0,0,0,0,100,0), +(@PATH,132,-5374.349,1353.202,25.43379,0,0,0,0,100,0), +(@PATH,133,-5377.349,1355.702,24.68379,0,0,0,0,100,0), +(@PATH,134,-5380.349,1358.452,24.18379,0,0,0,0,100,0), +(@PATH,135,-5382.599,1360.452,23.43379,0,0,0,0,100,0), +(@PATH,136,-5382.769,1360.671,23.45341,0,0,0,0,100,0), +(@PATH,137,-5384.769,1362.921,23.45341,0,0,0,0,100,0), +(@PATH,138,-5384.769,1366.921,24.20341,0,0,0,0,100,0), +(@PATH,139,-5384.519,1374.671,24.45341,0,0,0,0,100,0); + +-- Pathing for Entry: 5236 'TDB FORMAT' +SET @NPC := 369227; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4887.564,`position_y`=1147.737,`position_z`=82.23389 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,-4887.564,1147.737,82.23389,0,0,0,0,100,0), +(@PATH,2,-4889.064,1147.737,81.73389,0,0,0,0,100,0), +(@PATH,3,-4907.814,1146.237,81.48389,0,0,0,0,100,0), +(@PATH,4,-4907.955,1146.279,81.30981,0,0,0,0,100,0), +(@PATH,5,-4909.705,1146.029,81.30981,0,0,0,0,100,0), +(@PATH,6,-4912.705,1146.279,80.80981,0,0,0,0,100,0), +(@PATH,7,-4917.705,1147.029,80.30981,0,0,0,0,100,0), +(@PATH,8,-4922.455,1147.529,79.55981,0,0,0,0,100,0), +(@PATH,9,-4926.455,1147.779,78.80981,0,0,0,0,100,0), +(@PATH,10,-4929.455,1148.029,78.30981,0,0,0,0,100,0), +(@PATH,11,-4932.455,1148.279,77.55981,0,0,0,0,100,0), +(@PATH,12,-4935.455,1148.779,77.05981,0,0,0,0,100,0), +(@PATH,13,-4935.578,1148.857,76.61978,0,0,0,0,100,0), +(@PATH,14,-4936.578,1149.107,76.61978,0,0,0,0,100,0), +(@PATH,15,-4939.328,1150.107,75.86978,0,0,0,0,100,0), +(@PATH,16,-4943.078,1151.857,75.36978,0,0,0,0,100,0), +(@PATH,17,-4947.578,1153.607,74.36978,0,0,0,0,100,0), +(@PATH,18,-4949.328,1154.357,73.61978,0,0,0,0,100,0), +(@PATH,19,-4951.078,1155.107,73.11978,0,0,0,0,100,0), +(@PATH,20,-4953.078,1155.857,72.36978,0,0,0,0,100,0), +(@PATH,21,-4955.828,1157.107,71.61978,0,0,0,0,100,0), +(@PATH,22,-4957.578,1157.857,70.86978,0,0,0,0,100,0), +(@PATH,23,-4956.024,1157.27,71.38242,0,0,0,0,100,0), +(@PATH,24,-4957.774,1158.02,70.63242,0,0,0,0,100,0), +(@PATH,25,-4958.774,1158.52,70.38242,0,0,0,0,100,0), +(@PATH,26,-4960.524,1161.02,68.88242,0,0,0,0,100,0), +(@PATH,27,-4961.524,1162.77,68.38242,0,0,0,0,100,0), +(@PATH,28,-4962.524,1164.52,67.38242,0,0,0,0,100,0), +(@PATH,29,-4963.274,1166.02,66.38242,0,0,0,0,100,0), +(@PATH,30,-4965.024,1168.52,65.38242,0,0,0,0,100,0), +(@PATH,31,-4966.024,1170.02,63.88242,0,0,0,0,100,0), +(@PATH,32,-4967.524,1172.77,62.63242,0,0,0,0,100,0), +(@PATH,33,-4967.778,1172.82,62.28553,0,0,0,0,100,0), +(@PATH,34,-4969.278,1175.57,60.53553,0,0,0,0,100,0), +(@PATH,35,-4969.528,1177.32,59.28553,0,0,0,0,100,0), +(@PATH,36,-4969.778,1179.32,58.53553,0,0,0,0,100,0), +(@PATH,37,-4970.028,1182.07,57.78553,0,0,0,0,100,0), +(@PATH,38,-4970.278,1184.07,57.03553,0,0,0,0,100,0), +(@PATH,39,-4970.528,1186.07,56.28553,0,0,0,0,100,0), +(@PATH,40,-4970.778,1188.07,55.53553,0,0,0,0,100,0), +(@PATH,41,-4970.952,1188.287,55.36691,0,0,0,0,100,0), +(@PATH,42,-4971.452,1190.787,55.36691,0,0,0,0,100,0), +(@PATH,43,-4974.952,1194.287,54.61691,0,0,0,0,100,0), +(@PATH,44,-4977.202,1196.287,54.11691,0,0,0,0,100,0), +(@PATH,45,-4983.452,1202.287,53.61691,0,0,0,0,100,0), +(@PATH,46,-4989.952,1208.537,53.11691,0,0,0,0,100,0), +(@PATH,47,-4990.21,1208.844,52.67712,0,0,0,0,100,0), +(@PATH,48,-4990.96,1209.844,52.67712,0,0,0,0,100,0), +(@PATH,49,-4999.96,1213.844,52.17712,0,0,0,0,100,0), +(@PATH,50,-5002.46,1215.094,51.42712,0,0,0,0,100,0), +(@PATH,51,-5004.21,1216.094,50.92712,0,0,0,0,100,0), +(@PATH,52,-5006.21,1216.844,50.42712,0,0,0,0,100,0), +(@PATH,53,-5009.71,1218.594,49.67712,0,0,0,0,100,0), +(@PATH,54,-5012.596,1219.835,49.03596,0,0,0,0,100,0), +(@PATH,55,-5024.346,1218.335,49.78596,0,0,0,0,100,0), +(@PATH,56,-5027.346,1217.835,50.28596,0,0,0,0,100,0), +(@PATH,57,-5034.555,1217.289,50.43246,0,0,0,0,100,0), +(@PATH,58,-5050.537,1217.095,50.51433,0,0,0,0,100,0), +(@PATH,59,-5058.741,1228.543,51.11539,0,0,0,0,100,0), +(@PATH,60,-5067.241,1233.043,51.36539,0,0,0,0,100,0), +(@PATH,61,-5067.991,1233.543,52.11539,0,0,0,0,100,0), +(@PATH,62,-5066.918,1232.79,51.47484,0,0,0,0,100,0), +(@PATH,63,-5063.668,1231.29,50.97484,0,0,0,0,100,0), +(@PATH,64,-5058.458,1228.211,50.96991,0,0,0,0,100,0), +(@PATH,65,-5050.265,1217.127,50.37694,0,0,0,0,100,0), +(@PATH,66,-5045.265,1217.127,51.12694,0,0,0,0,100,0), +(@PATH,67,-5034.326,1217.195,50.41732,0,0,0,0,100,0), +(@PATH,68,-5026.576,1218.195,50.16732,0,0,0,0,100,0), +(@PATH,69,-5023.576,1218.445,49.66732,0,0,0,0,100,0), +(@PATH,70,-5020.576,1218.945,48.91732,0,0,0,0,100,0), +(@PATH,71,-5012.36,1219.956,49.11663,0,0,0,0,100,0), +(@PATH,72,-5009.86,1218.706,49.61663,0,0,0,0,100,0), +(@PATH,73,-5007.86,1217.706,50.36663,0,0,0,0,100,0), +(@PATH,74,-5004.36,1215.956,50.86663,0,0,0,0,100,0), +(@PATH,75,-5002.86,1215.206,51.36663,0,0,0,0,100,0), +(@PATH,76,-5001.11,1214.456,52.11663,0,0,0,0,100,0), +(@PATH,77,-4996.61,1212.456,52.86663,0,0,0,0,100,0), +(@PATH,78,-4990.863,1209.482,53.12539,0,0,0,0,100,0), +(@PATH,79,-4983.613,1202.482,53.62539,0,0,0,0,100,0), +(@PATH,80,-4977.363,1196.482,53.87539,0,0,0,0,100,0), +(@PATH,81,-4975.113,1194.482,54.62539,0,0,0,0,100,0), +(@PATH,82,-4973.113,1192.482,55.12539,0,0,0,0,100,0), +(@PATH,83,-4972.637,1192.104,55.50454,0,0,0,0,100,0), +(@PATH,84,-4971.387,1190.604,55.50454,0,0,0,0,100,0), +(@PATH,85,-4970.637,1185.604,56.25454,0,0,0,0,100,0), +(@PATH,86,-4970.387,1183.854,57.00454,0,0,0,0,100,0), +(@PATH,87,-4970.137,1181.854,57.75454,0,0,0,0,100,0), +(@PATH,88,-4969.887,1179.854,58.25454,0,0,0,0,100,0), +(@PATH,89,-4969.637,1177.854,59.25454,0,0,0,0,100,0), +(@PATH,90,-4969.637,1176.104,60.50454,0,0,0,0,100,0), +(@PATH,91,-4969.441,1177.833,59.65903,0,0,0,0,100,0), +(@PATH,92,-4969.191,1175.833,60.90903,0,0,0,0,100,0), +(@PATH,93,-4969.191,1175.333,60.90903,0,0,0,0,100,0), +(@PATH,94,-4967.691,1172.583,62.65903,0,0,0,0,100,0), +(@PATH,95,-4965.941,1170.083,63.65903,0,0,0,0,100,0), +(@PATH,96,-4964.941,1168.583,64.90903,0,0,0,0,100,0), +(@PATH,97,-4963.691,1166.083,66.40903,0,0,0,0,100,0), +(@PATH,98,-4962.691,1164.333,67.40903,0,0,0,0,100,0), +(@PATH,99,-4960.941,1161.833,68.65903,0,0,0,0,100,0), +(@PATH,100,-4959.941,1160.083,69.65903,0,0,0,0,100,0), +(@PATH,101,-4959.828,1159.939,69.74927,0,0,0,0,100,0), +(@PATH,102,-4958.578,1158.189,70.99927,0,0,0,0,100,0), +(@PATH,103,-4955.828,1157.189,71.74927,0,0,0,0,100,0), +(@PATH,104,-4953.078,1155.939,72.24927,0,0,0,0,100,0), +(@PATH,105,-4951.328,1155.189,72.74927,0,0,0,0,100,0), +(@PATH,106,-4949.578,1154.689,73.49927,0,0,0,0,100,0), +(@PATH,107,-4946.078,1152.939,74.99927,0,0,0,0,100,0), +(@PATH,108,-4942.328,1151.439,75.49927,0,0,0,0,100,0), +(@PATH,109,-4936.527,1148.786,76.94524,0,0,0,0,100,0), +(@PATH,110,-4933.527,1148.536,77.44524,0,0,0,0,100,0), +(@PATH,111,-4930.527,1148.286,78.19524,0,0,0,0,100,0), +(@PATH,112,-4927.527,1148.036,78.69524,0,0,0,0,100,0), +(@PATH,113,-4925.027,1147.786,79.44524,0,0,0,0,100,0), +(@PATH,114,-4920.027,1147.286,79.94524,0,0,0,0,100,0), +(@PATH,115,-4915.027,1146.536,80.69524,0,0,0,0,100,0), +(@PATH,116,-4914.594,1146.685,80.94543,0,0,0,0,100,0), +(@PATH,117,-4909.844,1146.185,81.19543,0,0,0,0,100,0), +(@PATH,118,-4901.094,1146.935,81.94543,0,0,0,0,100,0); + +-- Pathing for Entry: 12418 'TDB FORMAT' +SET @NPC := 369480; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4037.902,`position_y`=1102.274,`position_z`=159.981 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,-4037.902,1102.274,159.981,0,0,0,0,100,0), +(@PATH,2,-4037.152,1081.024,159.981,0,0,0,0,100,0), +(@PATH,3,-4036.652,1067.024,159.981,0,0,0,0,100,0), +(@PATH,4,-4036.215,1056.252,159.9776,0,0,0,0,100,0), +(@PATH,5,-4036.465,1047.002,159.9776,0,0,0,0,100,0), +(@PATH,6,-4036.932,1028.981,159.9789,0,0,0,0,100,0), +(@PATH,7,-4036.932,1025.231,159.9789,0,0,0,0,100,0), +(@PATH,8,-4036.932,991.7311,159.9789,0,0,0,0,100,0), +(@PATH,9,-4036.725,988.6835,159.9718,0,0,0,0,100,0), +(@PATH,10,-4036.725,969.6835,159.9718,0,0,0,0,100,0), +(@PATH,11,-4036.552,947.7471,159.9732,0,0,0,0,100,0), +(@PATH,12,-4036.802,936.2471,159.9732,0,0,0,0,100,0), +(@PATH,13,-4036.879,915.6215,159.9674,0,0,0,0,100,0), +(@PATH,14,-4036.629,914.3715,159.9674,0,0,0,0,100,0), +(@PATH,15,-4036.657,914.4097,159.9679,0,0,0,0,100,0), +(@PATH,16,-4036.719,914.8599,159.9721,0,0,0,0,100,0), +(@PATH,17,-4036.719,915.8599,159.9721,0,0,0,0,100,0), +(@PATH,18,-4036.719,936.1099,159.9721,0,0,0,0,100,0), +(@PATH,19,-4036.497,948.0006,159.9749,0,0,0,0,100,0), +(@PATH,20,-4036.747,969.7506,159.9749,0,0,0,0,100,0), +(@PATH,21,-4036.981,988.8585,159.9788,0,0,0,0,100,0), +(@PATH,22,-4036.981,991.6085,159.9788,0,0,0,0,100,0), +(@PATH,23,-4036.981,1025.359,159.9788,0,0,0,0,100,0), +(@PATH,24,-4036.9,1029.317,159.9757,0,0,0,0,100,0), +(@PATH,25,-4036.4,1046.817,159.9757,0,0,0,0,100,0), +(@PATH,26,-4036.254,1056.465,159.9817,0,0,0,0,100,0), +(@PATH,27,-4036.754,1066.965,159.9817,0,0,0,0,100,0), +(@PATH,28,-4037.254,1080.965,159.9817,0,0,0,0,100,0), +(@PATH,29,-4038.05,1102.644,159.9845,0,0,0,0,100,0), +(@PATH,30,-4036.376,1136.507,159.9807,0,0,0,0,100,0), +(@PATH,31,-4035.626,1164.257,159.9807,0,0,0,0,100,0), +(@PATH,32,-4035.412,1166.532,159.9755,0,0,0,0,100,0), +(@PATH,33,-4035.162,1185.782,159.9755,0,0,0,0,100,0), +(@PATH,34,-4034.468,1201.62,159.9731,0,0,0,0,100,0), +(@PATH,35,-4033.968,1219.62,159.9731,0,0,0,0,100,0), +(@PATH,36,-4033.507,1231.293,159.9781,0,0,0,0,100,0), +(@PATH,37,-4033.257,1241.543,159.9781,0,0,0,0,100,0), +(@PATH,38,-4032.645,1271.274,159.9889,0,0,0,0,100,0), +(@PATH,39,-4033.895,1289.774,159.9889,0,0,0,0,100,0), +(@PATH,40,-4033.858,1289.792,159.9895,0,0,0,0,100,0), +(@PATH,41,-4032.854,1270.901,159.9794,0,0,0,0,100,0), +(@PATH,42,-4033.354,1241.651,159.9794,0,0,0,0,100,0), +(@PATH,43,-4033.62,1230.898,159.9729,0,0,0,0,100,0), +(@PATH,44,-4034.12,1219.648,159.9729,0,0,0,0,100,0), +(@PATH,45,-4034.587,1201.419,159.9757,0,0,0,0,100,0), +(@PATH,46,-4035.087,1185.919,159.9757,0,0,0,0,100,0), +(@PATH,47,-4035.541,1166.223,159.9801,0,0,0,0,100,0), +(@PATH,48,-4035.791,1164.223,159.9801,0,0,0,0,100,0); + +-- Pathing for Entry: 12418 'TDB FORMAT' +SET @NPC := 369506; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-3854.555,`position_y`=1055.219,`position_z`=155.0381 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,-3854.555,1055.219,155.0381,0,0,0,0,100,0), +(@PATH,2,-3842.305,1042.719,155.0381,0,0,0,0,100,0), +(@PATH,3,-3838.647,1038.834,155.0381,0,0,0,0,100,0), +(@PATH,4,-3813.897,1036.834,155.0381,0,0,0,0,100,0), +(@PATH,5,-3808.088,1036.119,155.0373,0,0,0,0,100,0), +(@PATH,6,-3788.555,1023.261,155.0324,0,0,0,0,100,0), +(@PATH,7,-3769.805,1015.511,155.0324,0,0,0,0,100,0), +(@PATH,8,-3768.305,1015.011,155.0324,0,0,0,0,100,0), +(@PATH,9,-3764.055,1013.011,155.0324,0,0,0,0,100,0), +(@PATH,10,-3762.805,1012.511,155.0324,0,0,0,0,100,0), +(@PATH,11,-3762.678,1012.704,155.0325,0,0,0,0,100,0), +(@PATH,12,-3761.178,1011.954,155.0325,0,0,0,0,100,0), +(@PATH,13,-3746.678,1012.954,155.0325,0,0,0,0,100,0), +(@PATH,14,-3733.428,1013.704,155.0325,0,0,0,0,100,0), +(@PATH,15,-3730.138,1013.97,155.0365,0,0,0,0,100,0), +(@PATH,16,-3705.501,1032.117,155.0386,0,0,0,0,100,0), +(@PATH,17,-3698.001,1035.367,155.0386,0,0,0,0,100,0), +(@PATH,18,-3694.001,1037.117,155.0386,0,0,0,0,100,0), +(@PATH,19,-3689.501,1039.117,155.0386,0,0,0,0,100,0), +(@PATH,20,-3681.784,1042.511,155.0383,0,0,0,0,100,0), +(@PATH,21,-3653.269,1050.416,155.038,0,0,0,0,100,0), +(@PATH,22,-3649.019,1047.416,155.038,0,0,0,0,100,0), +(@PATH,23,-3643.269,1043.416,155.038,0,0,0,0,100,0), +(@PATH,24,-3640.125,1041.209,155.0374,0,0,0,0,100,0), +(@PATH,25,-3639.625,1050.459,155.0374,0,0,0,0,100,0), +(@PATH,26,-3638.875,1064.209,155.0374,0,0,0,0,100,0), +(@PATH,27,-3638.699,1064.523,155.0368,0,0,0,0,100,0), +(@PATH,28,-3638.449,1065.523,155.0368,0,0,0,0,100,0), +(@PATH,29,-3638.199,1067.023,155.0368,0,0,0,0,100,0), +(@PATH,30,-3634.949,1077.023,155.0368,0,0,0,0,100,0), +(@PATH,31,-3634.699,1078.273,155.0368,0,0,0,0,100,0), +(@PATH,32,-3632.232,1085.573,155.0372,0,0,0,0,100,0), +(@PATH,33,-3623.732,1094.323,155.0372,0,0,0,0,100,0), +(@PATH,34,-3623.767,1094.724,155.0373,0,0,0,0,100,0), +(@PATH,35,-3623.517,1094.974,155.0373,0,0,0,0,100,0), +(@PATH,36,-3630.59,1112.866,155.033,0,0,0,0,100,0), +(@PATH,37,-3637.84,1124.116,155.033,0,0,0,0,100,0), +(@PATH,38,-3644.874,1135.201,155.0346,0,0,0,0,100,0), +(@PATH,39,-3656.624,1141.951,155.0346,0,0,0,0,100,0), +(@PATH,40,-3661.874,1145.201,155.0346,0,0,0,0,100,0), +(@PATH,41,-3664.508,1146.735,155.0382,0,0,0,0,100,0), +(@PATH,42,-3688.982,1147.98,155.0382,0,0,0,0,100,0), +(@PATH,43,-3691.482,1148.98,155.0382,0,0,0,0,100,0), +(@PATH,44,-3697.982,1151.73,155.0382,0,0,0,0,100,0), +(@PATH,45,-3706.982,1155.23,155.0382,0,0,0,0,100,0), +(@PATH,46,-3716.972,1159.586,155.0373,0,0,0,0,100,0), +(@PATH,47,-3732.972,1173.336,155.0373,0,0,0,0,100,0), +(@PATH,48,-3733.308,1173.481,155.0372,0,0,0,0,100,0), +(@PATH,49,-3734.308,1174.231,155.0372,0,0,0,0,100,0), +(@PATH,50,-3746.058,1173.731,155.0372,0,0,0,0,100,0), +(@PATH,51,-3755.558,1173.481,155.0372,0,0,0,0,100,0), +(@PATH,52,-3767.558,1172.981,155.0372,0,0,0,0,100,0), +(@PATH,53,-3767.847,1173.004,155.0372,0,0,0,0,100,0), +(@PATH,54,-3768.597,1173.004,155.0372,0,0,0,0,100,0), +(@PATH,55,-3792.617,1161.457,155.0381,0,0,0,0,100,0), +(@PATH,56,-3796.117,1158.457,155.0381,0,0,0,0,100,0), +(@PATH,57,-3803.36,1152.46,155.0383,0,0,0,0,100,0), +(@PATH,58,-3810.36,1151.21,155.0383,0,0,0,0,100,0), +(@PATH,59,-3814.36,1150.46,155.0383,0,0,0,0,100,0), +(@PATH,60,-3820.61,1148.96,155.0383,0,0,0,0,100,0), +(@PATH,61,-3828.742,1147.236,155.038,0,0,0,0,100,0), +(@PATH,62,-3851.992,1139.986,155.038,0,0,0,0,100,0), +(@PATH,63,-3859.302,1137.74,155.0385,0,0,0,0,100,0), +(@PATH,64,-3859.552,1136.74,155.0385,0,0,0,0,100,0), +(@PATH,65,-3872.203,1105.271,155.0409,0,0,0,0,100,0), +(@PATH,66,-3870.703,1092.771,155.0409,0,0,0,0,100,0), +(@PATH,67,-3870.203,1085.521,155.0409,0,0,0,0,100,0), +(@PATH,68,-3868.967,1078.517,155.039,0,0,0,0,100,0), +(@PATH,69,-3861.967,1067.017,155.039,0,0,0,0,100,0), +(@PATH,70,-3858.967,1062.267,155.039,0,0,0,0,100,0); + +-- Pathing for Entry: 12418 'TDB FORMAT' +SET @NPC := 369476; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4180.887,`position_y`=1191.757,`position_z`=161.464 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,-4180.887,1191.757,161.464,0,0,0,0,100,0), +(@PATH,2,-4180.648,1158.682,161.4634,0,0,0,0,100,0), +(@PATH,3,-4175.398,1143.182,161.4634,0,0,0,0,100,0), +(@PATH,4,-4172.309,1135.312,161.4634,0,0,0,0,100,0), +(@PATH,5,-4150.559,1133.312,161.4634,0,0,0,0,100,0), +(@PATH,6,-4144.322,1132.75,161.464,0,0,0,0,100,0), +(@PATH,7,-4114.667,1135.707,161.4638,0,0,0,0,100,0), +(@PATH,8,-4112.417,1135.707,161.4638,0,0,0,0,100,0), +(@PATH,9,-4096.417,1134.957,161.4638,0,0,0,0,100,0), +(@PATH,10,-4093.417,1134.957,161.4638,0,0,0,0,100,0), +(@PATH,11,-4093.535,1135.111,161.4638,0,0,0,0,100,0), +(@PATH,12,-4096.285,1135.111,161.4638,0,0,0,0,100,0), +(@PATH,13,-4112.535,1135.611,161.4638,0,0,0,0,100,0), +(@PATH,14,-4114.848,1135.816,161.464,0,0,0,0,100,0), +(@PATH,15,-4144.685,1132.695,161.4633,0,0,0,0,100,0), +(@PATH,16,-4150.435,1133.195,161.4633,0,0,0,0,100,0), +(@PATH,17,-4172.465,1135.241,161.4635,0,0,0,0,100,0), +(@PATH,18,-4175.215,1143.241,161.4635,0,0,0,0,100,0), +(@PATH,19,-4180.603,1158.887,161.4639,0,0,0,0,100,0), +(@PATH,20,-4180.926,1191.933,161.4635,0,0,0,0,100,0), +(@PATH,21,-4180.926,1222.183,161.4635,0,0,0,0,100,0), +(@PATH,22,-4180.926,1223.683,161.4635,0,0,0,0,100,0), +(@PATH,23,-4180.786,1223.718,161.4635,0,0,0,0,100,0), +(@PATH,24,-4180.786,1226.468,161.4635,0,0,0,0,100,0), +(@PATH,25,-4181.036,1232.218,161.4635,0,0,0,0,100,0), +(@PATH,26,-4181.036,1240.218,161.4635,0,0,0,0,100,0), +(@PATH,27,-4181.036,1243.218,161.4635,0,0,0,0,100,0), +(@PATH,28,-4181.004,1250.186,161.464,0,0,0,0,100,0), +(@PATH,29,-4177.504,1264.686,161.464,0,0,0,0,100,0), +(@PATH,30,-4173.303,1283.435,161.4627,0,0,0,0,100,0), +(@PATH,31,-4189.702,1299.401,161.4634,0,0,0,0,100,0), +(@PATH,32,-4189.452,1310.401,161.4634,0,0,0,0,100,0), +(@PATH,33,-4189.202,1311.651,161.4634,0,0,0,0,100,0), +(@PATH,34,-4189.195,1322.56,161.4619,0,0,0,0,100,0), +(@PATH,35,-4198.445,1327.06,161.4619,0,0,0,0,100,0), +(@PATH,36,-4204.461,1330.101,161.4643,0,0,0,0,100,0), +(@PATH,37,-4233.211,1329.851,161.4643,0,0,0,0,100,0), +(@PATH,38,-4250.282,1330.26,161.4636,0,0,0,0,100,0), +(@PATH,39,-4266.532,1330.51,161.4636,0,0,0,0,100,0), +(@PATH,40,-4270.782,1330.76,161.4636,0,0,0,0,100,0), +(@PATH,41,-4270.658,1330.754,161.4637,0,0,0,0,100,0), +(@PATH,42,-4266.408,1330.504,161.4637,0,0,0,0,100,0), +(@PATH,43,-4250.059,1330.03,161.463,0,0,0,0,100,0), +(@PATH,44,-4233.309,1330.03,161.463,0,0,0,0,100,0), +(@PATH,45,-4204.172,1330.175,161.464,0,0,0,0,100,0), +(@PATH,46,-4198.672,1327.175,161.464,0,0,0,0,100,0), +(@PATH,47,-4189.271,1322.355,161.4629,0,0,0,0,100,0), +(@PATH,48,-4189.521,1312.355,161.4629,0,0,0,0,100,0), +(@PATH,49,-4189.521,1310.605,161.4629,0,0,0,0,100,0), +(@PATH,50,-4189.569,1299.233,161.4614,0,0,0,0,100,0), +(@PATH,51,-4173.256,1283.299,161.4638,0,0,0,0,100,0), +(@PATH,52,-4177.756,1264.799,161.4638,0,0,0,0,100,0); + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369053; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5379.454,`position_y`=80.31207,`position_z`=35.72601 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,-5379.454,80.31207,35.72601,0,0,0,0,100,0), +(@PATH,2,-5378.704,80.31207,35.47601,0,0,0,0,100,0), +(@PATH,3,-5376.454,80.06207,35.47601,0,0,0,0,100,0), +(@PATH,4,-5374.954,79.81207,35.22601,0,0,0,0,100,0), +(@PATH,5,-5372.454,79.56207,34.97601,0,0,0,0,100,0), +(@PATH,6,-5370.204,79.31207,34.97601,0,0,0,0,100,0), +(@PATH,7,-5368.954,79.31207,34.72601,0,0,0,0,100,0), +(@PATH,8,-5365.204,79.06207,34.72601,0,0,0,0,100,0), +(@PATH,9,-5361.454,78.56207,34.47601,0,0,0,0,100,0), +(@PATH,10,-5359.954,78.56207,34.22601,0,0,0,0,100,0), +(@PATH,11,-5359.503,78.25957,33.91799,0,0,0,0,100,0), +(@PATH,12,-5358.253,78.00957,33.16799,0,0,0,0,100,0), +(@PATH,13,-5357.003,77.50957,32.66799,0,0,0,0,100,0), +(@PATH,14,-5356.503,76.75957,32.66799,0,0,0,0,100,0), +(@PATH,15,-5354.753,76.25957,32.16799,0,0,0,0,100,0), +(@PATH,16,-5353.253,75.50957,31.66799,0,0,0,0,100,0), +(@PATH,17,-5353.324,75.40039,31.69456,0,0,0,0,100,0), +(@PATH,18,-5352.324,74.90039,31.44456,0,0,0,0,100,0), +(@PATH,19,-5353.574,75.40039,31.69456,0,0,0,0,100,0), +(@PATH,20,-5355.074,75.90039,32.19456,0,0,0,0,100,0), +(@PATH,21,-5356.074,76.15039,32.44456,0,0,0,0,100,0), +(@PATH,22,-5358.074,76.90039,32.94456,0,0,0,0,100,0), +(@PATH,23,-5359.824,77.65039,33.44456,0,0,0,0,100,0), +(@PATH,24,-5361.324,77.90039,34.69456,0,0,0,0,100,0), +(@PATH,25,-5364.074,78.90039,34.69456,0,0,0,0,100,0), +(@PATH,26,-5365.074,79.40039,34.69456,0,0,0,0,100,0), +(@PATH,27,-5365.472,79.52196,34.72213,0,0,0,0,100,0), +(@PATH,28,-5368.222,80.52196,34.97213,0,0,0,0,100,0), +(@PATH,29,-5369.222,80.52196,34.97213,0,0,0,0,100,0), +(@PATH,30,-5372.722,80.27196,34.97213,0,0,0,0,100,0), +(@PATH,31,-5374.972,80.52196,35.22213,0,0,0,0,100,0), +(@PATH,32,-5378.222,81.52196,35.72213,0,0,0,0,100,0), +(@PATH,33,-5378.722,81.52196,35.47213,0,0,0,0,100,0), +(@PATH,34,-5379.972,82.02196,35.97213,0,0,0,0,100,0), +(@PATH,35,-5381.222,82.02196,36.22213,0,0,0,0,100,0), +(@PATH,36,-5382.972,82.52196,36.47213,0,0,0,0,100,0), +(@PATH,37,-5384.222,82.77196,35.72213,0,0,0,0,100,0), +(@PATH,38,-5384.972,83.02196,35.97213,0,0,0,0,100,0), +(@PATH,39,-5385.722,83.02196,35.97213,0,0,0,0,100,0), +(@PATH,40,-5386.222,83.02196,35.97213,0,0,0,0,100,0), +(@PATH,41,-5388.972,83.52196,35.72213,0,0,0,0,100,0), +(@PATH,42,-5393.32,85.35595,35.73944,0,0,0,0,100,0), +(@PATH,43,-5393.82,86.60595,35.98944,0,0,0,0,100,0), +(@PATH,44,-5394.07,88.35595,35.73944,0,0,0,0,100,0), +(@PATH,45,-5395.32,91.10595,34.73944,0,0,0,0,100,0), +(@PATH,46,-5396.07,93.10595,33.98944,0,0,0,0,100,0), +(@PATH,47,-5396.82,95.35595,33.23944,0,0,0,0,100,0), +(@PATH,48,-5396.954,95.63359,32.87813,0,0,0,0,100,0), +(@PATH,49,-5397.204,96.38359,32.62813,0,0,0,0,100,0), +(@PATH,50,-5398.954,97.38359,32.12813,0,0,0,0,100,0), +(@PATH,51,-5402.704,100.1336,30.62813,0,0,0,0,100,0), +(@PATH,52,-5404.954,101.8836,30.12813,0,0,0,0,100,0), +(@PATH,53,-5406.204,102.3836,29.62813,0,0,0,0,100,0), +(@PATH,54,-5408.204,103.8836,28.87813,0,0,0,0,100,0), +(@PATH,55,-5411.454,106.1336,28.37813,0,0,0,0,100,0), +(@PATH,56,-5412.954,107.1336,28.12813,0,0,0,0,100,0), +(@PATH,57,-5415.454,108.8836,27.87813,0,0,0,0,100,0), +(@PATH,58,-5416.156,109.6152,28.05183,0,0,0,0,100,0), +(@PATH,59,-5412.906,107.1152,28.05183,0,0,0,0,100,0), +(@PATH,60,-5411.406,106.1152,28.30183,0,0,0,0,100,0), +(@PATH,61,-5408.156,103.8652,28.80183,0,0,0,0,100,0), +(@PATH,62,-5406.156,102.6152,29.55183,0,0,0,0,100,0), +(@PATH,63,-5404.906,101.8652,30.05183,0,0,0,0,100,0), +(@PATH,64,-5402.656,100.1152,30.55183,0,0,0,0,100,0), +(@PATH,65,-5399.406,97.86523,31.80183,0,0,0,0,100,0), +(@PATH,66,-5399.359,97.56825,32.00935,0,0,0,0,100,0), +(@PATH,67,-5397.109,96.06825,33.00935,0,0,0,0,100,0), +(@PATH,68,-5396.359,93.31825,34.00935,0,0,0,0,100,0), +(@PATH,69,-5395.859,91.31825,34.75935,0,0,0,0,100,0), +(@PATH,70,-5394.859,88.81825,35.50935,0,0,0,0,100,0), +(@PATH,71,-5394.359,86.56825,36.00935,0,0,0,0,100,0), +(@PATH,72,-5394.137,86.42653,35.9319,0,0,0,0,100,0), +(@PATH,73,-5393.887,85.42653,35.6819,0,0,0,0,100,0), +(@PATH,74,-5393.137,85.42653,35.6819,0,0,0,0,100,0), +(@PATH,75,-5388.637,84.42653,35.9319,0,0,0,0,100,0), +(@PATH,76,-5386.637,83.42653,35.6819,0,0,0,0,100,0), +(@PATH,77,-5385.637,83.42653,36.1819,0,0,0,0,100,0), +(@PATH,78,-5384.887,83.17653,35.9319,0,0,0,0,100,0), +(@PATH,79,-5384.387,83.17653,35.9319,0,0,0,0,100,0), +(@PATH,80,-5382.887,82.92653,36.6819,0,0,0,0,100,0), +(@PATH,81,-5381.637,82.67653,36.4319,0,0,0,0,100,0), +(@PATH,82,-5380.387,82.42653,36.1819,0,0,0,0,100,0), +(@PATH,83,-5378.637,82.17653,35.4319,0,0,0,0,100,0); + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369043; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5276.474,`position_y`=85.41458,`position_z`=24.50326 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,-5276.474,85.41458,24.50326,0,0,0,0,100,0), +(@PATH,2,-5277.724,87.16458,25.00326,0,0,0,0,100,0), +(@PATH,3,-5277.974,88.91458,24.75326,0,0,0,0,100,0), +(@PATH,4,-5277.974,90.41458,24.50326,0,0,0,0,100,0), +(@PATH,5,-5278.224,91.66458,24.25326,0,0,0,0,100,0), +(@PATH,6,-5278.224,92.66458,24.50326,0,0,0,0,100,0), +(@PATH,7,-5278.474,93.91458,24.50326,0,0,0,0,100,0), +(@PATH,8,-5278.474,95.66458,24.25326,0,0,0,0,100,0), +(@PATH,9,-5278.724,96.66458,24.00326,0,0,0,0,100,0), +(@PATH,10,-5278.724,97.66458,24.00326,0,0,0,0,100,0), +(@PATH,11,-5278.724,98.91458,24.00326,0,0,0,0,100,0), +(@PATH,12,-5278.741,96.60387,24.12028,0,0,0,0,100,0), +(@PATH,13,-5278.741,97.60387,23.87028,0,0,0,0,100,0), +(@PATH,14,-5278.741,98.85387,23.87028,0,0,0,0,100,0), +(@PATH,15,-5278.741,99.35387,24.12028,0,0,0,0,100,0), +(@PATH,16,-5278.741,98.10387,23.87028,0,0,0,0,100,0), +(@PATH,17,-5278.741,96.60387,24.12028,0,0,0,0,100,0), +(@PATH,18,-5278.741,95.60387,24.37028,0,0,0,0,100,0), +(@PATH,19,-5278.491,93.85387,24.37028,0,0,0,0,100,0), +(@PATH,20,-5278.491,92.60387,24.62028,0,0,0,0,100,0), +(@PATH,21,-5278.491,91.60387,24.37028,0,0,0,0,100,0), +(@PATH,22,-5278.491,89.85387,24.62028,0,0,0,0,100,0), +(@PATH,23,-5278.491,88.60387,24.87028,0,0,0,0,100,0), +(@PATH,24,-5278.491,87.10387,24.87028,0,0,0,0,100,0), +(@PATH,25,-5278.241,85.35387,24.87028,0,0,0,0,100,0), +(@PATH,26,-5278.249,81.98409,24.9773,0,0,0,0,100,0), +(@PATH,27,-5279.749,81.23409,25.4773,0,0,0,0,100,0), +(@PATH,28,-5281.499,80.23409,26.2273,0,0,0,0,100,0), +(@PATH,29,-5284.249,78.73409,26.4773,0,0,0,0,100,0), +(@PATH,30,-5285.749,77.98409,25.9773,0,0,0,0,100,0), +(@PATH,31,-5287.249,77.48409,25.4773,0,0,0,0,100,0), +(@PATH,32,-5288.249,76.98409,25.9773,0,0,0,0,100,0), +(@PATH,33,-5288.749,76.73409,24.9773,0,0,0,0,100,0), +(@PATH,34,-5289.999,75.98409,24.2273,0,0,0,0,100,0), +(@PATH,35,-5292.249,74.73409,23.4773,0,0,0,0,100,0), +(@PATH,36,-5293.499,73.98409,22.9773,0,0,0,0,100,0), +(@PATH,37,-5296.999,72.23409,21.9773,0,0,0,0,100,0), +(@PATH,38,-5298.749,71.48409,21.7273,0,0,0,0,100,0), +(@PATH,39,-5299.663,70.88521,21.37219,0,0,0,0,100,0), +(@PATH,40,-5303.163,72.13521,20.62219,0,0,0,0,100,0), +(@PATH,41,-5307.413,73.63521,19.87219,0,0,0,0,100,0), +(@PATH,42,-5308.413,73.88521,19.87219,0,0,0,0,100,0), +(@PATH,43,-5310.163,74.38521,19.87219,0,0,0,0,100,0), +(@PATH,44,-5312.913,75.13521,20.12219,0,0,0,0,100,0), +(@PATH,45,-5317.377,76.64972,21.01211,0,0,0,0,100,0), +(@PATH,46,-5318.627,76.64972,21.26211,0,0,0,0,100,0), +(@PATH,47,-5326.377,76.64972,24.26211,0,0,0,0,100,0), +(@PATH,48,-5327.377,76.64972,24.76211,0,0,0,0,100,0), +(@PATH,49,-5330.377,76.64972,26.76211,0,0,0,0,100,0), +(@PATH,50,-5330.579,76.57631,27.03654,0,0,0,0,100,0), +(@PATH,51,-5330.829,76.57631,27.28654,0,0,0,0,100,0), +(@PATH,52,-5331.829,76.32631,27.53654,0,0,0,0,100,0), +(@PATH,53,-5333.329,75.32631,28.03654,0,0,0,0,100,0), +(@PATH,54,-5334.829,74.57631,28.28654,0,0,0,0,100,0), +(@PATH,55,-5338.079,73.07631,29.28654,0,0,0,0,100,0), +(@PATH,56,-5341.329,71.32631,29.53654,0,0,0,0,100,0), +(@PATH,57,-5342.329,70.82631,29.28654,0,0,0,0,100,0), +(@PATH,58,-5342.238,70.82764,29.47106,0,0,0,0,100,0), +(@PATH,59,-5341.238,71.32764,29.47106,0,0,0,0,100,0), +(@PATH,60,-5337.988,73.07764,29.47106,0,0,0,0,100,0), +(@PATH,61,-5335.488,74.32764,28.72106,0,0,0,0,100,0), +(@PATH,62,-5333.238,75.32764,27.97106,0,0,0,0,100,0), +(@PATH,63,-5331.738,76.32764,27.97106,0,0,0,0,100,0), +(@PATH,64,-5330.786,76.60921,27.02558,0,0,0,0,100,0), +(@PATH,65,-5327.786,76.60921,25.02558,0,0,0,0,100,0), +(@PATH,66,-5326.286,76.60921,24.27558,0,0,0,0,100,0), +(@PATH,67,-5318.536,76.60921,21.27558,0,0,0,0,100,0), +(@PATH,68,-5318.364,76.67421,21.3534,0,0,0,0,100,0), +(@PATH,69,-5317.114,76.67421,20.8534,0,0,0,0,100,0), +(@PATH,70,-5312.864,75.17421,20.1034,0,0,0,0,100,0), +(@PATH,71,-5310.364,74.17421,19.8534,0,0,0,0,100,0), +(@PATH,72,-5308.614,73.67421,19.8534,0,0,0,0,100,0), +(@PATH,73,-5307.364,73.42421,20.1034,0,0,0,0,100,0), +(@PATH,74,-5304.114,72.42421,20.3534,0,0,0,0,100,0), +(@PATH,75,-5300.614,71.17421,21.3534,0,0,0,0,100,0), +(@PATH,76,-5300.143,71.12019,21.29478,0,0,0,0,100,0), +(@PATH,77,-5299.393,70.87019,21.54478,0,0,0,0,100,0), +(@PATH,78,-5297.393,71.62019,22.04478,0,0,0,0,100,0), +(@PATH,79,-5295.143,72.37019,22.54478,0,0,0,0,100,0), +(@PATH,80,-5294.393,72.62019,22.79478,0,0,0,0,100,0), +(@PATH,81,-5291.643,73.12019,23.29478,0,0,0,0,100,0), +(@PATH,82,-5289.393,73.87019,24.29478,0,0,0,0,100,0), +(@PATH,83,-5287.893,74.12019,24.54478,0,0,0,0,100,0), +(@PATH,84,-5287.143,74.62019,24.79478,0,0,0,0,100,0), +(@PATH,85,-5286.143,74.87019,25.04478,0,0,0,0,100,0), +(@PATH,86,-5283.143,77.37019,26.04478,0,0,0,0,100,0), +(@PATH,87,-5282.893,77.62019,26.29478,0,0,0,0,100,0), +(@PATH,88,-5281.143,79.12019,26.29478,0,0,0,0,100,0), +(@PATH,89,-5279.893,80.37019,25.79478,0,0,0,0,100,0); + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369048; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5338.737,`position_y`=5.562202,`position_z`=21.35871 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,-5338.737,5.562202,21.35871,0,0,0,0,100,0), +(@PATH,2,-5338.737,6.812202,20.85871,0,0,0,0,100,0), +(@PATH,3,-5338.737,10.0622,20.60871,0,0,0,0,100,0), +(@PATH,4,-5338.487,21.0622,21.60871,0,0,0,0,100,0), +(@PATH,5,-5338.487,23.5622,21.60871,0,0,0,0,100,0), +(@PATH,6,-5338.487,26.3122,21.60871,0,0,0,0,100,0), +(@PATH,7,-5338.632,26.55485,21.59105,0,0,0,0,100,0), +(@PATH,8,-5338.632,27.55485,21.59105,0,0,0,0,100,0), +(@PATH,9,-5338.632,28.80485,21.59105,0,0,0,0,100,0), +(@PATH,10,-5339.382,32.55485,21.34105,0,0,0,0,100,0), +(@PATH,11,-5339.882,34.30485,21.59105,0,0,0,0,100,0), +(@PATH,12,-5340.132,37.30485,21.09105,0,0,0,0,100,0), +(@PATH,13,-5340.382,39.05485,21.09105,0,0,0,0,100,0), +(@PATH,14,-5340.632,41.05485,20.84105,0,0,0,0,100,0), +(@PATH,15,-5340.919,41.50228,20.83962,0,0,0,0,100,0), +(@PATH,16,-5341.169,42.75228,21.08962,0,0,0,0,100,0), +(@PATH,17,-5341.669,45.00228,21.58962,0,0,0,0,100,0), +(@PATH,18,-5341.919,49.00228,22.83962,0,0,0,0,100,0), +(@PATH,19,-5342.419,51.75228,23.83962,0,0,0,0,100,0), +(@PATH,20,-5342.193,51.78114,23.8247,0,0,0,0,100,0), +(@PATH,21,-5342.193,49.28114,22.8247,0,0,0,0,100,0), +(@PATH,22,-5341.443,45.03114,21.5747,0,0,0,0,100,0), +(@PATH,23,-5341.353,44.84298,21.34764,0,0,0,0,100,0), +(@PATH,24,-5341.103,42.59298,21.09764,0,0,0,0,100,0), +(@PATH,25,-5340.853,41.09298,20.84764,0,0,0,0,100,0), +(@PATH,26,-5340.353,39.09298,21.34764,0,0,0,0,100,0), +(@PATH,27,-5340.103,37.34298,21.34764,0,0,0,0,100,0), +(@PATH,28,-5339.853,34.59298,21.59764,0,0,0,0,100,0), +(@PATH,29,-5339.353,32.34298,21.34764,0,0,0,0,100,0), +(@PATH,30,-5338.853,29.34298,21.59764,0,0,0,0,100,0), +(@PATH,31,-5338.406,27.3795,21.48865,0,0,0,0,100,0), +(@PATH,32,-5338.406,26.3795,21.48865,0,0,0,0,100,0), +(@PATH,33,-5338.656,23.6295,21.73865,0,0,0,0,100,0), +(@PATH,34,-5338.656,21.1295,21.73865,0,0,0,0,100,0), +(@PATH,35,-5338.656,10.8795,20.98865,0,0,0,0,100,0), +(@PATH,36,-5338.656,7.629496,20.98865,0,0,0,0,100,0), +(@PATH,37,-5338.612,5.263011,21.30679,0,0,0,0,100,0), +(@PATH,38,-5339.112,4.263011,21.80679,0,0,0,0,100,0), +(@PATH,39,-5339.612,2.763011,20.80679,0,0,0,0,100,0), +(@PATH,40,-5339.612,0.01301146,20.05679,0,0,0,0,100,0), +(@PATH,41,-5339.862,-1.986989,19.80679,0,0,0,0,100,0), +(@PATH,42,-5339.862,-5.486989,19.05679,0,0,0,0,100,0), +(@PATH,43,-5340.112,-7.986989,19.05679,0,0,0,0,100,0), +(@PATH,44,-5340.112,-11.98699,18.30679,0,0,0,0,100,0), +(@PATH,45,-5340.427,-14.34284,18.43517,0,0,0,0,100,0), +(@PATH,46,-5342.427,-21.09284,18.68517,0,0,0,0,100,0), +(@PATH,47,-5343.927,-26.84284,19.18517,0,0,0,0,100,0), +(@PATH,48,-5344.998,-29.72341,20.34055,0,0,0,0,100,0), +(@PATH,49,-5347.248,-31.72341,21.34055,0,0,0,0,100,0), +(@PATH,50,-5348.998,-32.97341,21.84055,0,0,0,0,100,0), +(@PATH,51,-5351.498,-34.97341,22.84055,0,0,0,0,100,0), +(@PATH,52,-5355.248,-37.97341,23.84055,0,0,0,0,100,0), +(@PATH,53,-5356.998,-39.22341,24.59055,0,0,0,0,100,0), +(@PATH,54,-5357.182,-39.41773,24.88021,0,0,0,0,100,0), +(@PATH,55,-5358.432,-40.41773,25.13021,0,0,0,0,100,0), +(@PATH,56,-5360.182,-41.41773,25.38021,0,0,0,0,100,0), +(@PATH,57,-5364.932,-44.16773,26.13021,0,0,0,0,100,0), +(@PATH,58,-5372.182,-48.16773,26.63021,0,0,0,0,100,0), +(@PATH,59,-5372.465,-48.33434,26.7582,0,0,0,0,100,0), +(@PATH,60,-5374.715,-49.58434,27.2582,0,0,0,0,100,0), +(@PATH,61,-5377.715,-52.33434,27.2582,0,0,0,0,100,0), +(@PATH,62,-5381.465,-55.58434,27.5082,0,0,0,0,100,0), +(@PATH,63,-5386.465,-60.33434,28.5082,0,0,0,0,100,0), +(@PATH,64,-5388.465,-62.08434,28.2582,0,0,0,0,100,0), +(@PATH,65,-5390.465,-63.83434,28.7582,0,0,0,0,100,0), +(@PATH,66,-5392.465,-65.83434,29.0082,0,0,0,0,100,0), +(@PATH,67,-5393.715,-66.83434,29.0082,0,0,0,0,100,0), +(@PATH,68,-5394.465,-67.58434,29.0082,0,0,0,0,100,0), +(@PATH,69,-5395.465,-68.58434,29.0082,0,0,0,0,100,0), +(@PATH,70,-5394.441,-67.6627,28.91278,0,0,0,0,100,0), +(@PATH,71,-5393.691,-66.9127,28.91278,0,0,0,0,100,0), +(@PATH,72,-5392.691,-66.1627,28.91278,0,0,0,0,100,0), +(@PATH,73,-5390.441,-63.9127,28.66278,0,0,0,0,100,0), +(@PATH,74,-5388.441,-61.9127,28.41278,0,0,0,0,100,0), +(@PATH,75,-5386.441,-60.4127,28.41278,0,0,0,0,100,0), +(@PATH,76,-5381.941,-56.1627,27.66278,0,0,0,0,100,0), +(@PATH,77,-5377.691,-52.4127,27.41278,0,0,0,0,100,0), +(@PATH,78,-5374.279,-49.22344,26.80418,0,0,0,0,100,0), +(@PATH,79,-5372.279,-47.97344,26.80418,0,0,0,0,100,0), +(@PATH,80,-5365.029,-44.22344,26.05418,0,0,0,0,100,0), +(@PATH,81,-5360.029,-41.47344,25.80418,0,0,0,0,100,0), +(@PATH,82,-5359.029,-40.72344,25.30418,0,0,0,0,100,0), +(@PATH,83,-5359.797,-41.26441,25.39873,0,0,0,0,100,0), +(@PATH,84,-5358.547,-40.51441,25.14873,0,0,0,0,100,0), +(@PATH,85,-5358.047,-40.26441,24.89873,0,0,0,0,100,0), +(@PATH,86,-5356.797,-39.26441,24.39873,0,0,0,0,100,0), +(@PATH,87,-5356.047,-38.51441,24.14873,0,0,0,0,100,0), +(@PATH,88,-5351.797,-35.26441,22.89873,0,0,0,0,100,0), +(@PATH,89,-5349.797,-33.76441,22.39873,0,0,0,0,100,0), +(@PATH,90,-5347.297,-31.76441,21.39873,0,0,0,0,100,0), +(@PATH,91,-5344.652,-29.49636,20.07725,0,0,0,0,100,0), +(@PATH,92,-5343.902,-26.99636,19.32725,0,0,0,0,100,0), +(@PATH,93,-5342.152,-20.99636,18.57725,0,0,0,0,100,0), +(@PATH,94,-5340.272,-15.0183,18.33264,0,0,0,0,100,0), +(@PATH,95,-5340.022,-12.0183,18.33264,0,0,0,0,100,0), +(@PATH,96,-5339.272,-7.518299,19.08264,0,0,0,0,100,0), +(@PATH,97,-5339.022,-6.268299,19.08264,0,0,0,0,100,0), +(@PATH,98,-5338.272,-1.768299,19.83264,0,0,0,0,100,0), +(@PATH,99,-5339.772,-0.01829863,20.08264,0,0,0,0,100,0), +(@PATH,100,-5340.022,2.231701,20.58264,0,0,0,0,100,0), +(@PATH,101,-5339.272,4.231701,21.83264,0,0,0,0,100,0), +(@PATH,102,-5339.086,4.517818,21.64333,0,0,0,0,100,0), +(@PATH,103,-5338.586,5.517818,21.39333,0,0,0,0,100,0), +(@PATH,104,-5338.586,6.767818,20.89333,0,0,0,0,100,0), +(@PATH,105,-5338.586,10.01782,20.64333,0,0,0,0,100,0), +(@PATH,106,-5338.586,21.01782,21.64333,0,0,0,0,100,0), +(@PATH,107,-5338.586,23.76782,21.64333,0,0,0,0,100,0), +(@PATH,108,-5338.586,26.26782,21.64333,0,0,0,0,100,0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=36059 AND `SourceEntry`=68291 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=8 AND `ConditionTarget`=0 AND `ConditionValue1`=14304 AND `ConditionValue2`=0 AND `ConditionValue3`=0; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=36059 AND `SourceEntry`=68293 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=8 AND `ConditionTarget`=0 AND `ConditionValue1`=14304 AND `ConditionValue2`=0 AND `ConditionValue3`=0; + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369058; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5272.734,`position_y`=-45.34187,`position_z`=7.947533 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,-5272.734,-45.34187,7.947533,0,0,0,0,100,0), +(@PATH,2,-5275.484,-44.34187,8.197533,0,0,0,0,100,0), +(@PATH,3,-5276.734,-43.84187,8.697533,0,0,0,0,100,0), +(@PATH,4,-5278.734,-43.09187,9.447533,0,0,0,0,100,0), +(@PATH,5,-5280.734,-42.59187,9.447533,0,0,0,0,100,0), +(@PATH,6,-5283.984,-41.34187,9.697533,0,0,0,0,100,0), +(@PATH,7,-5284.984,-40.84187,9.947533,0,0,0,0,100,0), +(@PATH,8,-5287.984,-40.09187,10.44753,0,0,0,0,100,0), +(@PATH,9,-5293.234,-38.09187,11.44753,0,0,0,0,100,0), +(@PATH,10,-5296.484,-36.84187,12.19753,0,0,0,0,100,0), +(@PATH,11,-5303.984,-34.34187,13.69753,0,0,0,0,100,0), +(@PATH,12,-5304.302,-33.96802,13.85681,0,0,0,0,100,0), +(@PATH,13,-5305.302,-33.71802,14.10681,0,0,0,0,100,0), +(@PATH,14,-5307.052,-31.46802,14.60681,0,0,0,0,100,0), +(@PATH,15,-5308.302,-30.21802,14.85681,0,0,0,0,100,0), +(@PATH,16,-5310.802,-27.21802,15.85681,0,0,0,0,100,0), +(@PATH,17,-5312.802,-25.21802,16.35681,0,0,0,0,100,0), +(@PATH,18,-5314.302,-23.21802,16.35681,0,0,0,0,100,0), +(@PATH,19,-5316.802,-20.46802,16.35681,0,0,0,0,100,0), +(@PATH,20,-5317.028,-20.14684,16.66685,0,0,0,0,100,0), +(@PATH,21,-5317.778,-19.39684,16.66685,0,0,0,0,100,0), +(@PATH,22,-5318.278,-19.14684,16.66685,0,0,0,0,100,0), +(@PATH,23,-5321.028,-18.14684,16.66685,0,0,0,0,100,0), +(@PATH,24,-5326.028,-15.64684,16.91685,0,0,0,0,100,0), +(@PATH,25,-5327.028,-15.39684,16.91685,0,0,0,0,100,0), +(@PATH,26,-5333.028,-13.14684,17.41685,0,0,0,0,100,0), +(@PATH,27,-5336.528,-11.89684,17.91685,0,0,0,0,100,0), +(@PATH,28,-5339.311,-10.89297,18.50265,0,0,0,0,100,0), +(@PATH,29,-5340.311,-8.142967,18.75265,0,0,0,0,100,0), +(@PATH,30,-5341.311,-5.142967,19.00265,0,0,0,0,100,0), +(@PATH,31,-5342.311,-2.142967,19.50265,0,0,0,0,100,0), +(@PATH,32,-5343.061,0.1070328,19.75265,0,0,0,0,100,0), +(@PATH,33,-5343.292,0.2576904,19.99871,0,0,0,0,100,0), +(@PATH,34,-5344.042,2.00769,20.24871,0,0,0,0,100,0), +(@PATH,35,-5346.292,5.00769,20.24871,0,0,0,0,100,0), +(@PATH,36,-5347.792,7.00769,20.24871,0,0,0,0,100,0), +(@PATH,37,-5348.792,8.25769,20.74871,0,0,0,0,100,0), +(@PATH,38,-5350.792,11.00769,21.49871,0,0,0,0,100,0), +(@PATH,39,-5351.542,12.00769,21.74871,0,0,0,0,100,0), +(@PATH,40,-5353.292,14.50769,22.74871,0,0,0,0,100,0), +(@PATH,41,-5354.792,16.75769,22.99871,0,0,0,0,100,0), +(@PATH,42,-5356.792,19.25769,22.99871,0,0,0,0,100,0), +(@PATH,43,-5357.542,20.25769,22.99871,0,0,0,0,100,0), +(@PATH,44,-5359.875,23.35733,23.02066,0,0,0,0,100,0), +(@PATH,45,-5362.125,24.35733,23.02066,0,0,0,0,100,0), +(@PATH,46,-5363.125,24.85733,23.02066,0,0,0,0,100,0), +(@PATH,47,-5365.875,26.10733,23.02066,0,0,0,0,100,0), +(@PATH,48,-5370.625,27.85733,23.27066,0,0,0,0,100,0), +(@PATH,49,-5371.375,28.35733,23.52066,0,0,0,0,100,0), +(@PATH,50,-5373.375,29.10733,23.52066,0,0,0,0,100,0), +(@PATH,51,-5377.125,30.85733,24.27066,0,0,0,0,100,0), +(@PATH,52,-5379.375,31.85733,24.02066,0,0,0,0,100,0), +(@PATH,53,-5382.625,33.35733,24.27066,0,0,0,0,100,0), +(@PATH,54,-5382.702,33.23057,24.20939,0,0,0,0,100,0), +(@PATH,55,-5379.952,32.23057,23.95939,0,0,0,0,100,0), +(@PATH,56,-5377.702,31.23057,24.20939,0,0,0,0,100,0), +(@PATH,57,-5373.202,29.23057,23.45939,0,0,0,0,100,0), +(@PATH,58,-5371.702,28.48057,23.45939,0,0,0,0,100,0), +(@PATH,59,-5370.702,28.23057,23.45939,0,0,0,0,100,0), +(@PATH,60,-5365.702,25.98057,22.95939,0,0,0,0,100,0), +(@PATH,61,-5363.202,24.73057,22.95939,0,0,0,0,100,0), +(@PATH,62,-5362.202,24.48057,22.95939,0,0,0,0,100,0), +(@PATH,63,-5359.538,23.14645,22.86982,0,0,0,0,100,0), +(@PATH,64,-5357.538,20.14645,22.86982,0,0,0,0,100,0), +(@PATH,65,-5356.788,19.39645,22.86982,0,0,0,0,100,0), +(@PATH,66,-5354.788,16.64645,22.86982,0,0,0,0,100,0), +(@PATH,67,-5353.288,14.64645,22.61982,0,0,0,0,100,0), +(@PATH,68,-5352.038,12.89645,22.36982,0,0,0,0,100,0), +(@PATH,69,-5350.788,11.14645,21.61982,0,0,0,0,100,0), +(@PATH,70,-5349.038,8.646445,20.86982,0,0,0,0,100,0), +(@PATH,71,-5347.788,7.146445,20.36982,0,0,0,0,100,0), +(@PATH,72,-5346.788,5.646445,20.11982,0,0,0,0,100,0), +(@PATH,73,-5344.288,2.396445,20.11982,0,0,0,0,100,0), +(@PATH,74,-5344.026,2.17669,19.90427,0,0,0,0,100,0), +(@PATH,75,-5343.776,1.67669,19.90427,0,0,0,0,100,0), +(@PATH,76,-5343.276,0.1766896,19.65427,0,0,0,0,100,0), +(@PATH,77,-5342.276,-2.07331,19.40427,0,0,0,0,100,0), +(@PATH,78,-5341.526,-4.82331,18.90427,0,0,0,0,100,0), +(@PATH,79,-5340.276,-8.073311,18.90427,0,0,0,0,100,0), +(@PATH,80,-5339.073,-11.06381,18.14268,0,0,0,0,100,0), +(@PATH,81,-5336.573,-12.06381,17.89268,0,0,0,0,100,0), +(@PATH,82,-5333.073,-13.31381,17.39268,0,0,0,0,100,0), +(@PATH,83,-5326.823,-15.81381,16.89268,0,0,0,0,100,0), +(@PATH,84,-5321.073,-18.06381,16.89268,0,0,0,0,100,0), +(@PATH,85,-5318.124,-19.46979,16.32417,0,0,0,0,100,0), +(@PATH,86,-5317.374,-20.21979,16.57417,0,0,0,0,100,0), +(@PATH,87,-5317.124,-20.46979,16.32417,0,0,0,0,100,0), +(@PATH,88,-5314.874,-22.96979,16.57417,0,0,0,0,100,0), +(@PATH,89,-5314.624,-23.46979,16.32417,0,0,0,0,100,0), +(@PATH,90,-5312.874,-25.21979,16.32417,0,0,0,0,100,0), +(@PATH,91,-5311.124,-27.21979,15.82417,0,0,0,0,100,0), +(@PATH,92,-5308.374,-30.21979,15.07417,0,0,0,0,100,0), +(@PATH,93,-5307.374,-31.46979,14.82417,0,0,0,0,100,0), +(@PATH,94,-5305.037,-33.75772,13.88667,0,0,0,0,100,0), +(@PATH,95,-5304.037,-34.25772,13.63667,0,0,0,0,100,0), +(@PATH,96,-5296.537,-37.00772,12.13667,0,0,0,0,100,0), +(@PATH,97,-5293.287,-38.00772,11.38667,0,0,0,0,100,0), +(@PATH,98,-5288.287,-39.75772,10.38667,0,0,0,0,100,0), +(@PATH,99,-5285.037,-41.00772,9.886675,0,0,0,0,100,0), +(@PATH,100,-5284.037,-41.25772,9.636675,0,0,0,0,100,0), +(@PATH,101,-5280.537,-42.50772,9.386675,0,0,0,0,100,0), +(@PATH,102,-5278.787,-43.25772,9.386675,0,0,0,0,100,0), +(@PATH,103,-5276.787,-43.75772,8.636675,0,0,0,0,100,0); + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369051; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5354.638,`position_y`=-11.12783,`position_z`=19.61283 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,-5354.638,-11.12783,19.61283,0,0,0,0,100,0), +(@PATH,2,-5351.138,-14.37783,19.61283,0,0,0,0,100,0), +(@PATH,3,-5348.388,-16.37783,18.86283,0,0,0,0,100,0), +(@PATH,4,-5347.138,-17.37783,18.86283,0,0,0,0,100,0), +(@PATH,5,-5345.138,-19.12783,18.61283,0,0,0,0,100,0), +(@PATH,6,-5343.321,-20.53223,18.44159,0,0,0,0,100,0), +(@PATH,7,-5342.321,-20.78223,18.44159,0,0,0,0,100,0), +(@PATH,8,-5336.071,-22.03223,18.44159,0,0,0,0,100,0), +(@PATH,9,-5333.821,-22.53223,18.69159,0,0,0,0,100,0), +(@PATH,10,-5331.071,-23.03223,18.44159,0,0,0,0,100,0), +(@PATH,11,-5324.821,-21.53223,17.19159,0,0,0,0,100,0), +(@PATH,12,-5324.356,-21.5244,16.90408,0,0,0,0,100,0), +(@PATH,13,-5322.606,-21.0244,16.90408,0,0,0,0,100,0), +(@PATH,14,-5318.856,-17.7744,16.65408,0,0,0,0,100,0), +(@PATH,15,-5316.356,-15.5244,16.90408,0,0,0,0,100,0), +(@PATH,16,-5316.472,-15.22847,16.92553,0,0,0,0,100,0), +(@PATH,17,-5315.722,-14.47847,16.92553,0,0,0,0,100,0), +(@PATH,18,-5316.972,-11.47847,16.92553,0,0,0,0,100,0), +(@PATH,19,-5318.222,-8.22847,17.17553,0,0,0,0,100,0), +(@PATH,20,-5318.972,-6.47847,17.42553,0,0,0,0,100,0), +(@PATH,21,-5319.472,-4.97847,17.42553,0,0,0,0,100,0), +(@PATH,22,-5320.722,-1.72847,18.42553,0,0,0,0,100,0), +(@PATH,23,-5321.049,-1.38629,18.61189,0,0,0,0,100,0), +(@PATH,24,-5321.299,0.1137099,18.86189,0,0,0,0,100,0), +(@PATH,25,-5321.643,18.58168,21.1525,0,0,0,0,100,0), +(@PATH,26,-5320.143,21.08168,21.6525,0,0,0,0,100,0), +(@PATH,27,-5318.643,23.33168,21.9025,0,0,0,0,100,0), +(@PATH,28,-5317.893,24.83168,22.1525,0,0,0,0,100,0), +(@PATH,29,-5314.64,30.11044,23.29892,0,0,0,0,100,0), +(@PATH,30,-5313.64,31.36044,23.54892,0,0,0,0,100,0), +(@PATH,31,-5309.39,35.61044,24.29892,0,0,0,0,100,0), +(@PATH,32,-5305.89,39.61044,24.79892,0,0,0,0,100,0), +(@PATH,33,-5304.89,40.61044,25.29892,0,0,0,0,100,0), +(@PATH,34,-5304.14,41.61044,25.54892,0,0,0,0,100,0), +(@PATH,35,-5302.728,43.01865,26.34388,0,0,0,0,100,0), +(@PATH,36,-5301.978,43.51865,26.34388,0,0,0,0,100,0), +(@PATH,37,-5300.228,44.51865,26.34388,0,0,0,0,100,0), +(@PATH,38,-5298.978,45.26865,26.59388,0,0,0,0,100,0), +(@PATH,39,-5296.728,46.51865,27.59388,0,0,0,0,100,0), +(@PATH,40,-5294.679,47.65759,27.27321,0,0,0,0,100,0), +(@PATH,41,-5295.929,46.65759,27.02321,0,0,0,0,100,0), +(@PATH,42,-5297.929,45.15759,27.02321,0,0,0,0,100,0), +(@PATH,43,-5300.179,43.65759,26.27321,0,0,0,0,100,0), +(@PATH,44,-5300.929,42.90759,26.27321,0,0,0,0,100,0), +(@PATH,45,-5305.179,39.90759,25.27321,0,0,0,0,100,0), +(@PATH,46,-5310.179,36.15759,24.27321,0,0,0,0,100,0), +(@PATH,47,-5310.254,35.71803,24.13027,0,0,0,0,100,0), +(@PATH,48,-5310.754,35.46803,23.88027,0,0,0,0,100,0), +(@PATH,49,-5313.504,31.21803,23.38027,0,0,0,0,100,0), +(@PATH,50,-5317.504,25.21803,22.38027,0,0,0,0,100,0), +(@PATH,51,-5318.504,23.71803,22.13027,0,0,0,0,100,0), +(@PATH,52,-5320.504,20.96803,21.88027,0,0,0,0,100,0), +(@PATH,53,-5322.299,18.09931,20.92441,0,0,0,0,100,0), +(@PATH,54,-5327.549,15.59931,21.17441,0,0,0,0,100,0), +(@PATH,55,-5333.049,13.59931,20.92441,0,0,0,0,100,0), +(@PATH,56,-5336.691,10.05514,20.5447,0,0,0,0,100,0), +(@PATH,57,-5337.691,9.805142,20.5447,0,0,0,0,100,0), +(@PATH,58,-5340.691,9.305142,20.7947,0,0,0,0,100,0), +(@PATH,59,-5347.441,7.805142,20.5447,0,0,0,0,100,0), +(@PATH,60,-5353.071,6.309561,20.82915,0,0,0,0,100,0), +(@PATH,61,-5353.321,3.059561,20.32915,0,0,0,0,100,0), +(@PATH,62,-5353.571,0.05956125,20.07915,0,0,0,0,100,0), +(@PATH,63,-5354.071,-3.690439,19.82915,0,0,0,0,100,0), +(@PATH,64,-5354.646,-11.21791,19.61065,0,0,0,0,100,0); + +-- Pathing for Entry: 5244 'TDB FORMAT' +SET @NPC := 369034; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5245.786,`position_y`=30.97933,`position_z`=19.9437 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,-5245.786,30.97933,19.9437,0,0,0,0,100,0), +(@PATH,2,-5246.036,30.72933,19.6937,0,0,0,0,100,0), +(@PATH,3,-5246.786,29.97933,19.6937,0,0,0,0,100,0), +(@PATH,4,-5248.786,28.22933,19.6937,0,0,0,0,100,0), +(@PATH,5,-5251.036,25.97933,19.4437,0,0,0,0,100,0), +(@PATH,6,-5253.286,23.97933,19.6937,0,0,0,0,100,0), +(@PATH,7,-5254.286,22.97933,19.6937,0,0,0,0,100,0), +(@PATH,8,-5255.536,21.97933,19.4437,0,0,0,0,100,0), +(@PATH,9,-5257.286,20.22933,19.4437,0,0,0,0,100,0), +(@PATH,10,-5258.786,18.97933,18.9437,0,0,0,0,100,0), +(@PATH,11,-5259.536,18.22933,18.6937,0,0,0,0,100,0), +(@PATH,12,-5259.624,18.2066,18.62908,0,0,0,0,100,0), +(@PATH,13,-5258.874,18.9566,18.87908,0,0,0,0,100,0), +(@PATH,14,-5257.374,20.2066,19.37908,0,0,0,0,100,0), +(@PATH,15,-5255.624,21.9566,19.62908,0,0,0,0,100,0), +(@PATH,16,-5254.374,22.9566,19.62908,0,0,0,0,100,0), +(@PATH,17,-5253.374,23.9566,19.62908,0,0,0,0,100,0), +(@PATH,18,-5251.124,25.9566,19.37908,0,0,0,0,100,0), +(@PATH,19,-5249.624,27.4566,19.37908,0,0,0,0,100,0), +(@PATH,20,-5246.874,29.9566,19.62908,0,0,0,0,100,0), +(@PATH,21,-5246.676,30.16805,19.89828,0,0,0,0,100,0), +(@PATH,22,-5245.676,30.91805,20.14828,0,0,0,0,100,0), +(@PATH,23,-5244.176,34.41805,20.39828,0,0,0,0,100,0), +(@PATH,24,-5240.676,43.16805,22.39828,0,0,0,0,100,0), +(@PATH,25,-5238.676,47.66805,24.14828,0,0,0,0,100,0), +(@PATH,26,-5238.716,47.93534,24.30865,0,0,0,0,100,0), +(@PATH,27,-5237.716,49.68534,24.55865,0,0,0,0,100,0), +(@PATH,28,-5238.966,52.43534,25.55865,0,0,0,0,100,0), +(@PATH,29,-5240.216,54.93534,25.80865,0,0,0,0,100,0), +(@PATH,30,-5241.43,58.7362,26.04067,0,0,0,0,100,0), +(@PATH,31,-5240.93,59.7362,25.79067,0,0,0,0,100,0), +(@PATH,32,-5239.43,62.7362,25.54067,0,0,0,0,100,0), +(@PATH,33,-5239.346,62.96735,25.69452,0,0,0,0,100,0), +(@PATH,34,-5238.346,64.96735,25.69452,0,0,0,0,100,0), +(@PATH,35,-5236.596,66.46735,25.69452,0,0,0,0,100,0), +(@PATH,36,-5234.346,68.46735,26.44452,0,0,0,0,100,0), +(@PATH,37,-5232.846,69.71735,26.69452,0,0,0,0,100,0), +(@PATH,38,-5231.846,70.71735,27.19452,0,0,0,0,100,0), +(@PATH,39,-5230.846,71.21735,27.19452,0,0,0,0,100,0), +(@PATH,40,-5227.596,74.46735,28.19452,0,0,0,0,100,0), +(@PATH,41,-5225.346,76.21735,29.44452,0,0,0,0,100,0), +(@PATH,42,-5222.846,78.46735,30.19452,0,0,0,0,100,0), +(@PATH,43,-5222.462,78.78482,30.39311,0,0,0,0,100,0), +(@PATH,44,-5221.712,79.53482,30.39311,0,0,0,0,100,0), +(@PATH,45,-5221.712,80.78482,30.39311,0,0,0,0,100,0), +(@PATH,46,-5220.962,83.28482,30.89311,0,0,0,0,100,0), +(@PATH,47,-5219.712,88.03482,31.64311,0,0,0,0,100,0), +(@PATH,48,-5219.462,89.03482,31.89311,0,0,0,0,100,0), +(@PATH,49,-5219.212,90.53482,31.89311,0,0,0,0,100,0), +(@PATH,50,-5218.712,92.28482,31.64311,0,0,0,0,100,0), +(@PATH,51,-5217.863,94.4595,31.832,0,0,0,0,100,0), +(@PATH,52,-5217.363,95.9595,31.832,0,0,0,0,100,0), +(@PATH,53,-5216.613,97.7095,32.082,0,0,0,0,100,0), +(@PATH,54,-5216.363,98.9595,32.082,0,0,0,0,100,0), +(@PATH,55,-5215.613,100.7095,32.082,0,0,0,0,100,0), +(@PATH,56,-5214.613,103.2095,32.082,0,0,0,0,100,0), +(@PATH,57,-5213.113,107.4595,32.582,0,0,0,0,100,0), +(@PATH,58,-5209.41,117.1609,34.75638,0,0,0,0,100,0), +(@PATH,59,-5203.66,126.6609,34.00638,0,0,0,0,100,0), +(@PATH,60,-5203.16,128.9109,35.75638,0,0,0,0,100,0), +(@PATH,61,-5202.91,130.1609,36.50638,0,0,0,0,100,0), +(@PATH,62,-5202.66,131.1609,37.00638,0,0,0,0,100,0), +(@PATH,63,-5202.16,133.1609,38.00638,0,0,0,0,100,0), +(@PATH,64,-5200.66,134.6609,39.00638,0,0,0,0,100,0), +(@PATH,65,-5199.91,135.4109,39.00638,0,0,0,0,100,0), +(@PATH,66,-5199.823,135.7214,39.2959,0,0,0,0,100,0), +(@PATH,67,-5199.823,137.4714,40.0459,0,0,0,0,100,0), +(@PATH,68,-5199.073,139.4714,40.7959,0,0,0,0,100,0), +(@PATH,69,-5198.323,141.4714,41.2959,0,0,0,0,100,0), +(@PATH,70,-5197.823,143.2214,42.0459,0,0,0,0,100,0), +(@PATH,71,-5197.073,145.2214,42.7959,0,0,0,0,100,0), +(@PATH,72,-5196.073,147.9714,43.5459,0,0,0,0,100,0), +(@PATH,73,-5195.323,149.7214,44.2959,0,0,0,0,100,0), +(@PATH,74,-5194.823,151.7214,44.7959,0,0,0,0,100,0), +(@PATH,75,-5194.323,153.4714,45.5459,0,0,0,0,100,0), +(@PATH,76,-5193.573,155.2214,46.5459,0,0,0,0,100,0), +(@PATH,77,-5192.573,157.9714,47.2959,0,0,0,0,100,0), +(@PATH,78,-5192.073,159.9714,48.0459,0,0,0,0,100,0), +(@PATH,79,-5191.323,161.9714,48.7959,0,0,0,0,100,0), +(@PATH,80,-5190.323,164.7214,49.7959,0,0,0,0,100,0), +(@PATH,81,-5189.323,167.4714,50.5459,0,0,0,0,100,0), +(@PATH,82,-5189.589,166.6673,50.20425,0,0,0,0,100,0), +(@PATH,83,-5190.589,163.9173,49.45425,0,0,0,0,100,0), +(@PATH,84,-5191.339,161.9173,48.95425,0,0,0,0,100,0), +(@PATH,85,-5191.839,160.1673,48.20425,0,0,0,0,100,0), +(@PATH,86,-5192.589,158.1673,47.45425,0,0,0,0,100,0), +(@PATH,87,-5193.589,155.4173,46.45425,0,0,0,0,100,0), +(@PATH,88,-5194.089,153.6673,45.70425,0,0,0,0,100,0), +(@PATH,89,-5194.589,151.9173,44.95425,0,0,0,0,100,0), +(@PATH,90,-5195.339,149.9173,44.20425,0,0,0,0,100,0), +(@PATH,91,-5196.089,147.9173,43.45425,0,0,0,0,100,0), +(@PATH,92,-5197.089,145.1673,42.70425,0,0,0,0,100,0), +(@PATH,93,-5197.589,143.4173,41.95425,0,0,0,0,100,0), +(@PATH,94,-5198.339,141.4173,41.45425,0,0,0,0,100,0), +(@PATH,95,-5199.089,139.6673,40.70425,0,0,0,0,100,0), +(@PATH,96,-5199.295,139.2021,40.63976,0,0,0,0,100,0), +(@PATH,97,-5200.045,137.4521,39.88976,0,0,0,0,100,0), +(@PATH,98,-5200.045,135.4521,39.13976,0,0,0,0,100,0), +(@PATH,99,-5202.045,133.4521,38.38976,0,0,0,0,100,0), +(@PATH,100,-5202.545,131.4521,37.63976,0,0,0,0,100,0), +(@PATH,101,-5203.045,129.4521,36.38976,0,0,0,0,100,0), +(@PATH,102,-5203.545,127.4521,34.88976,0,0,0,0,100,0), +(@PATH,103,-5203.295,126.7021,33.38976,0,0,0,0,100,0), +(@PATH,104,-5209.649,116.9664,34.41718,0,0,0,0,100,0), +(@PATH,105,-5213.149,107.4664,32.41718,0,0,0,0,100,0), +(@PATH,106,-5214.649,103.2164,32.16718,0,0,0,0,100,0), +(@PATH,107,-5215.649,100.7164,32.16718,0,0,0,0,100,0), +(@PATH,108,-5216.149,98.96642,31.91718,0,0,0,0,100,0), +(@PATH,109,-5216.649,97.71642,32.16718,0,0,0,0,100,0), +(@PATH,110,-5217.399,95.96642,31.91718,0,0,0,0,100,0), +(@PATH,111,-5217.507,95.70738,31.56503,0,0,0,0,100,0), +(@PATH,112,-5218.257,94.20738,31.56503,0,0,0,0,100,0), +(@PATH,113,-5218.757,92.45738,31.56503,0,0,0,0,100,0), +(@PATH,114,-5219.257,90.45738,31.81503,0,0,0,0,100,0), +(@PATH,115,-5219.507,88.95738,31.81503,0,0,0,0,100,0), +(@PATH,116,-5219.507,88.20738,31.56503,0,0,0,0,100,0), +(@PATH,117,-5220.507,83.70738,31.06503,0,0,0,0,100,0), +(@PATH,118,-5221.257,81.20738,30.81503,0,0,0,0,100,0), +(@PATH,119,-5221.54,80.94244,30.46408,0,0,0,0,100,0), +(@PATH,120,-5222.04,79.19244,30.21408,0,0,0,0,100,0), +(@PATH,121,-5222.79,78.44244,30.21408,0,0,0,0,100,0), +(@PATH,122,-5225.04,76.44244,29.71408,0,0,0,0,100,0), +(@PATH,123,-5227.04,74.69244,28.96408,0,0,0,0,100,0), +(@PATH,124,-5230.79,71.69244,27.21408,0,0,0,0,100,0), +(@PATH,125,-5231.79,70.69244,26.96408,0,0,0,0,100,0), +(@PATH,126,-5232.79,69.69244,26.71408,0,0,0,0,100,0), +(@PATH,127,-5233.54,68.94244,26.96408,0,0,0,0,100,0), +(@PATH,128,-5236.54,66.44244,25.71408,0,0,0,0,100,0), +(@PATH,129,-5238.51,64.77956,25.59751,0,0,0,0,100,0), +(@PATH,130,-5239.26,62.77956,25.59751,0,0,0,0,100,0), +(@PATH,131,-5240.76,59.77956,25.84751,0,0,0,0,100,0), +(@PATH,132,-5240.768,59.32689,25.75733,0,0,0,0,100,0), +(@PATH,133,-5241.268,58.57689,26.00733,0,0,0,0,100,0), +(@PATH,134,-5240.268,55.57689,26.25733,0,0,0,0,100,0), +(@PATH,135,-5239.018,52.82689,25.50733,0,0,0,0,100,0), +(@PATH,136,-5239.146,52.57555,25.5286,0,0,0,0,100,0), +(@PATH,137,-5237.896,49.57555,24.7786,0,0,0,0,100,0), +(@PATH,138,-5238.646,47.57555,24.0286,0,0,0,0,100,0), +(@PATH,139,-5240.396,43.32555,22.5286,0,0,0,0,100,0), +(@PATH,140,-5243.896,35.07555,20.2786,0,0,0,0,100,0), +(@PATH,141,-5245.646,31.32555,20.0286,0,0,0,0,100,0); + +-- Pathing for Entry: 14661 'TDB FORMAT' +SET @NPC := 369029; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5191.81,`position_y`=161.842,`position_z`=49.05515 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,-5191.81,161.842,49.05515,0,0,0,0,100,0), +(@PATH,2,-5191.31,162.592,49.30515,0,0,0,0,100,0), +(@PATH,3,-5190.81,165.592,49.80515,0,0,0,0,100,0), +(@PATH,4,-5190.31,167.592,50.30515,0,0,0,0,100,0), +(@PATH,5,-5189.31,172.342,51.05515,0,0,0,0,100,0), +(@PATH,6,-5187.06,182.842,50.30515,0,0,0,0,100,0), +(@PATH,7,-5184.064,197.5968,50.94717,0,0,0,0,100,0), +(@PATH,8,-5200.314,201.0968,51.69717,0,0,0,0,100,0), +(@PATH,9,-5202.314,201.3468,52.44717,0,0,0,0,100,0), +(@PATH,10,-5204.314,201.8468,53.44717,0,0,0,0,100,0), +(@PATH,11,-5206.314,202.3468,54.19717,0,0,0,0,100,0), +(@PATH,12,-5208.064,202.5968,55.19717,0,0,0,0,100,0), +(@PATH,13,-5211.064,203.3468,55.94717,0,0,0,0,100,0), +(@PATH,14,-5214.064,203.8468,56.44717,0,0,0,0,100,0), +(@PATH,15,-5214.249,204.246,56.7878,0,0,0,0,100,0), +(@PATH,16,-5216.249,204.496,56.7878,0,0,0,0,100,0), +(@PATH,17,-5235.499,221.496,57.5378,0,0,0,0,100,0), +(@PATH,18,-5237.749,223.496,58.0378,0,0,0,0,100,0), +(@PATH,19,-5241.499,226.746,58.7878,0,0,0,0,100,0), +(@PATH,20,-5241.901,226.8805,58.74511,0,0,0,0,100,0), +(@PATH,21,-5242.901,227.8805,58.49511,0,0,0,0,100,0), +(@PATH,22,-5248.151,238.8805,57.99511,0,0,0,0,100,0), +(@PATH,23,-5250.151,243.3805,57.49511,0,0,0,0,100,0), +(@PATH,24,-5251.151,245.1305,56.74511,0,0,0,0,100,0), +(@PATH,25,-5252.401,248.3805,56.24511,0,0,0,0,100,0), +(@PATH,26,-5260.151,264.8805,56.74511,0,0,0,0,100,0), +(@PATH,27,-5265.573,269.9882,57.32353,0,0,0,0,100,0), +(@PATH,28,-5268.073,272.9882,58.07353,0,0,0,0,100,0), +(@PATH,29,-5269.573,274.4882,58.57353,0,0,0,0,100,0), +(@PATH,30,-5272.323,277.4882,59.57353,0,0,0,0,100,0), +(@PATH,31,-5275.573,280.9882,59.57353,0,0,0,0,100,0), +(@PATH,32,-5282.073,287.4882,61.57353,0,0,0,0,100,0), +(@PATH,33,-5284.323,289.7382,62.32353,0,0,0,0,100,0), +(@PATH,34,-5288.573,293.7382,63.07353,0,0,0,0,100,0), +(@PATH,35,-5289.323,294.4882,62.82353,0,0,0,0,100,0), +(@PATH,36,-5295.27,300.7717,64.01481,0,0,0,0,100,0), +(@PATH,37,-5293.27,306.5217,63.26481,0,0,0,0,100,0), +(@PATH,38,-5293.02,307.5217,63.26481,0,0,0,0,100,0), +(@PATH,39,-5291.77,310.5217,62.51481,0,0,0,0,100,0), +(@PATH,40,-5291.02,312.5217,62.26481,0,0,0,0,100,0), +(@PATH,41,-5288.77,319.7717,59.76481,0,0,0,0,100,0), +(@PATH,42,-5288.52,320.7717,59.51481,0,0,0,0,100,0), +(@PATH,43,-5288.274,321.1755,59.26124,0,0,0,0,100,0), +(@PATH,44,-5288.274,321.4255,59.26124,0,0,0,0,100,0), +(@PATH,45,-5289.024,324.1755,58.76124,0,0,0,0,100,0), +(@PATH,46,-5290.774,330.9255,58.26124,0,0,0,0,100,0), +(@PATH,47,-5291.274,333.1755,57.01124,0,0,0,0,100,0), +(@PATH,48,-5291.524,334.4255,56.26124,0,0,0,0,100,0), +(@PATH,49,-5292.774,338.9255,54.76124,0,0,0,0,100,0), +(@PATH,50,-5293.024,339.9255,54.26124,0,0,0,0,100,0), +(@PATH,51,-5293.524,341.1755,53.76124,0,0,0,0,100,0), +(@PATH,52,-5293.331,340.212,53.9526,0,0,0,0,100,0), +(@PATH,53,-5293.581,341.462,53.4526,0,0,0,0,100,0), +(@PATH,54,-5293.831,341.712,53.4526,0,0,0,0,100,0), +(@PATH,55,-5294.581,342.462,53.2026,0,0,0,0,100,0), +(@PATH,56,-5299.331,345.212,51.7026,0,0,0,0,100,0), +(@PATH,57,-5301.331,346.962,50.9526,0,0,0,0,100,0), +(@PATH,58,-5305.331,349.462,49.2026,0,0,0,0,100,0), +(@PATH,59,-5306.581,350.462,48.7026,0,0,0,0,100,0), +(@PATH,60,-5305.558,349.4338,49.03742,0,0,0,0,100,0), +(@PATH,61,-5306.808,350.4338,48.28742,0,0,0,0,100,0), +(@PATH,62,-5307.308,350.6838,48.03742,0,0,0,0,100,0), +(@PATH,63,-5310.558,350.6838,46.78742,0,0,0,0,100,0), +(@PATH,64,-5313.808,350.4338,45.78742,0,0,0,0,100,0), +(@PATH,65,-5316.308,350.4338,44.78742,0,0,0,0,100,0), +(@PATH,66,-5318.808,350.4338,43.53742,0,0,0,0,100,0), +(@PATH,67,-5318.895,350.4937,43.38284,0,0,0,0,100,0), +(@PATH,68,-5319.645,350.2437,43.13284,0,0,0,0,100,0), +(@PATH,69,-5323.145,347.9937,41.63284,0,0,0,0,100,0), +(@PATH,70,-5323.895,347.2437,40.88284,0,0,0,0,100,0), +(@PATH,71,-5325.645,346.2437,39.88284,0,0,0,0,100,0), +(@PATH,72,-5326.895,345.4937,39.13284,0,0,0,0,100,0), +(@PATH,73,-5327.219,345.1835,39.00688,0,0,0,0,100,0), +(@PATH,74,-5328.969,344.1835,38.00688,0,0,0,0,100,0), +(@PATH,75,-5329.219,342.1835,37.00688,0,0,0,0,100,0), +(@PATH,76,-5330.219,336.9335,34.50688,0,0,0,0,100,0), +(@PATH,77,-5331.469,331.9335,32.25688,0,0,0,0,100,0), +(@PATH,78,-5331.719,330.9335,32.00688,0,0,0,0,100,0), +(@PATH,79,-5332.389,327.947,31.68518,0,0,0,0,100,0), +(@PATH,80,-5330.139,324.447,30.18518,0,0,0,0,100,0), +(@PATH,81,-5328.889,322.947,29.43518,0,0,0,0,100,0), +(@PATH,82,-5328.389,321.947,28.93518,0,0,0,0,100,0), +(@PATH,83,-5326.389,318.697,27.43518,0,0,0,0,100,0), +(@PATH,84,-5325.639,317.697,26.93518,0,0,0,0,100,0), +(@PATH,85,-5320.907,311.3806,24.32392,0,0,0,0,100,0), +(@PATH,86,-5319.657,311.3806,24.07392,0,0,0,0,100,0), +(@PATH,87,-5316.657,311.6306,22.82392,0,0,0,0,100,0), +(@PATH,88,-5308.157,312.1306,20.82392,0,0,0,0,100,0), +(@PATH,89,-5303.407,312.6306,19.57392,0,0,0,0,100,0), +(@PATH,90,-5307.378,311.9717,20.43031,0,0,0,0,100,0), +(@PATH,91,-5316.878,311.7217,22.93031,0,0,0,0,100,0), +(@PATH,92,-5319.628,311.4717,24.18031,0,0,0,0,100,0), +(@PATH,93,-5320.071,311.3124,24.40537,0,0,0,0,100,0), +(@PATH,94,-5321.321,311.3124,24.65537,0,0,0,0,100,0), +(@PATH,95,-5325.321,317.3124,26.65537,0,0,0,0,100,0), +(@PATH,96,-5326.071,318.8124,27.40537,0,0,0,0,100,0), +(@PATH,97,-5327.821,321.3124,28.65537,0,0,0,0,100,0), +(@PATH,98,-5329.071,323.0624,29.40537,0,0,0,0,100,0), +(@PATH,99,-5330.071,324.5624,30.15537,0,0,0,0,100,0), +(@PATH,100,-5332.22,328.0781,32.0104,0,0,0,0,100,0), +(@PATH,101,-5331.72,330.8281,32.0104,0,0,0,0,100,0), +(@PATH,102,-5331.47,331.8281,32.5104,0,0,0,0,100,0), +(@PATH,103,-5330.47,336.0781,34.2604,0,0,0,0,100,0), +(@PATH,104,-5329.47,342.0781,36.7604,0,0,0,0,100,0), +(@PATH,105,-5328.711,344.1255,38.21865,0,0,0,0,100,0), +(@PATH,106,-5326.961,345.3755,39.21865,0,0,0,0,100,0), +(@PATH,107,-5325.711,346.3755,39.96865,0,0,0,0,100,0), +(@PATH,108,-5324.211,347.3755,40.71865,0,0,0,0,100,0), +(@PATH,109,-5323.211,347.8755,41.46865,0,0,0,0,100,0), +(@PATH,110,-5319.375,350.4587,43.56974,0,0,0,0,100,0), +(@PATH,111,-5317.125,350.4587,44.31974,0,0,0,0,100,0), +(@PATH,112,-5314.125,350.4587,45.56974,0,0,0,0,100,0), +(@PATH,113,-5311.125,350.7087,46.56974,0,0,0,0,100,0), +(@PATH,114,-5307.104,350.8619,48.4518,0,0,0,0,100,0), +(@PATH,115,-5305.354,349.6119,49.2018,0,0,0,0,100,0), +(@PATH,116,-5301.604,346.8619,50.7018,0,0,0,0,100,0), +(@PATH,117,-5299.604,345.6119,51.7018,0,0,0,0,100,0), +(@PATH,118,-5294.604,342.3619,53.2018,0,0,0,0,100,0), +(@PATH,119,-5294.463,342.0675,53.38792,0,0,0,0,100,0), +(@PATH,120,-5293.463,341.5675,53.63792,0,0,0,0,100,0), +(@PATH,121,-5293.213,340.3175,53.88792,0,0,0,0,100,0), +(@PATH,122,-5292.713,339.0675,54.63792,0,0,0,0,100,0), +(@PATH,123,-5291.963,334.5675,56.13792,0,0,0,0,100,0), +(@PATH,124,-5291.463,333.0675,57.13792,0,0,0,0,100,0), +(@PATH,125,-5290.963,331.0675,58.13792,0,0,0,0,100,0), +(@PATH,126,-5288.963,324.0675,58.63792,0,0,0,0,100,0), +(@PATH,127,-5289.009,323.8685,58.91986,0,0,0,0,100,0), +(@PATH,128,-5288.259,321.3685,59.41986,0,0,0,0,100,0), +(@PATH,129,-5288.759,319.6185,59.66986,0,0,0,0,100,0), +(@PATH,130,-5291.509,312.8685,62.16986,0,0,0,0,100,0), +(@PATH,131,-5292.259,311.1185,62.66986,0,0,0,0,100,0), +(@PATH,132,-5293.509,307.1185,63.41986,0,0,0,0,100,0), +(@PATH,133,-5294.009,305.6185,63.41986,0,0,0,0,100,0), +(@PATH,134,-5295.617,300.739,63.90447,0,0,0,0,100,0), +(@PATH,135,-5295.367,300.489,63.90447,0,0,0,0,100,0), +(@PATH,136,-5289.367,294.739,62.90447,0,0,0,0,100,0), +(@PATH,137,-5288.367,293.989,62.90447,0,0,0,0,100,0), +(@PATH,138,-5284.367,289.739,62.15447,0,0,0,0,100,0), +(@PATH,139,-5281.867,287.489,61.40447,0,0,0,0,100,0), +(@PATH,140,-5275.617,282.989,59.15447,0,0,0,0,100,0), +(@PATH,141,-5266.617,279.489,58.65447,0,0,0,0,100,0), +(@PATH,142,-5264.367,273.989,57.90447,0,0,0,0,100,0), +(@PATH,143,-5262.617,270.239,57.15447,0,0,0,0,100,0), +(@PATH,144,-5262.462,270.0662,57.16307,0,0,0,0,100,0), +(@PATH,145,-5261.712,268.0662,56.91307,0,0,0,0,100,0), +(@PATH,146,-5257.712,259.8162,56.41307,0,0,0,0,100,0), +(@PATH,147,-5254.712,253.5662,55.66307,0,0,0,0,100,0), +(@PATH,148,-5251.712,246.5662,56.66307,0,0,0,0,100,0), +(@PATH,149,-5250.462,243.8162,57.41307,0,0,0,0,100,0), +(@PATH,150,-5248.712,240.0662,57.91307,0,0,0,0,100,0), +(@PATH,151,-5245.712,233.8162,58.66307,0,0,0,0,100,0), +(@PATH,152,-5242.763,227.6998,58.69521,0,0,0,0,100,0), +(@PATH,153,-5238.263,223.6998,57.94521,0,0,0,0,100,0), +(@PATH,154,-5236.013,221.6998,57.44521,0,0,0,0,100,0), +(@PATH,155,-5233.763,219.6998,56.94521,0,0,0,0,100,0), +(@PATH,156,-5231.513,217.9498,56.44521,0,0,0,0,100,0), +(@PATH,157,-5224.013,211.4498,57.19521,0,0,0,0,100,0), +(@PATH,158,-5216.027,204.3271,56.52373,0,0,0,0,100,0), +(@PATH,159,-5211.027,203.3271,55.77373,0,0,0,0,100,0), +(@PATH,160,-5209.027,202.8271,55.02373,0,0,0,0,100,0), +(@PATH,161,-5206.277,202.3271,54.27373,0,0,0,0,100,0), +(@PATH,162,-5203.277,201.8271,53.02373,0,0,0,0,100,0), +(@PATH,163,-5201.527,201.3271,52.02373,0,0,0,0,100,0), +(@PATH,164,-5199.527,201.0771,51.27373,0,0,0,0,100,0), +(@PATH,165,-5196.777,200.3271,50.52373,0,0,0,0,100,0), +(@PATH,166,-5183.879,197.3474,50.69881,0,0,0,0,100,0), +(@PATH,167,-5190.629,166.3474,49.94881,0,0,0,0,100,0), +(@PATH,168,-5190.879,164.3474,49.69881,0,0,0,0,100,0), +(@PATH,169,-5192.037,162.4209,48.82699,0,0,0,0,100,0), +(@PATH,170,-5193.287,159.6709,48.07699,0,0,0,0,100,0), +(@PATH,171,-5194.037,157.9209,47.07699,0,0,0,0,100,0), +(@PATH,172,-5194.787,155.9209,46.32699,0,0,0,0,100,0), +(@PATH,173,-5196.037,153.1709,45.57699,0,0,0,0,100,0), +(@PATH,174,-5196.787,151.4209,44.57699,0,0,0,0,100,0), +(@PATH,175,-5197.537,149.6709,43.82699,0,0,0,0,100,0), +(@PATH,176,-5198.537,147.6709,43.07699,0,0,0,0,100,0), +(@PATH,177,-5199.537,144.9209,42.32699,0,0,0,0,100,0), +(@PATH,178,-5200.537,143.1709,41.82699,0,0,0,0,100,0), +(@PATH,179,-5201.037,141.4209,41.32699,0,0,0,0,100,0), +(@PATH,180,-5201.787,139.6709,40.82699,0,0,0,0,100,0), +(@PATH,181,-5203.037,136.9209,40.07699,0,0,0,0,100,0), +(@PATH,182,-5203.787,135.1709,39.07699,0,0,0,0,100,0), +(@PATH,183,-5204.537,133.4209,37.82699,0,0,0,0,100,0), +(@PATH,184,-5206.287,129.6709,35.82699,0,0,0,0,100,0), +(@PATH,185,-5206.537,128.6709,34.07699,0,0,0,0,100,0), +(@PATH,186,-5209.287,119.4209,34.07699,0,0,0,0,100,0), +(@PATH,187,-5209.529,119.0843,33.77484,0,0,0,0,100,0), +(@PATH,188,-5209.779,118.0843,34.02484,0,0,0,0,100,0), +(@PATH,189,-5210.279,116.8343,34.27484,0,0,0,0,100,0), +(@PATH,190,-5213.529,107.3343,32.52484,0,0,0,0,100,0), +(@PATH,191,-5214.779,103.0843,32.02484,0,0,0,0,100,0), +(@PATH,192,-5215.779,100.5843,32.02484,0,0,0,0,100,0), +(@PATH,193,-5216.279,98.83432,32.02484,0,0,0,0,100,0), +(@PATH,194,-5216.779,97.83432,32.02484,0,0,0,0,100,0), +(@PATH,195,-5217.279,95.83432,31.77484,0,0,0,0,100,0), +(@PATH,196,-5218.667,92.53807,31.43433,0,0,0,0,100,0), +(@PATH,197,-5219.167,90.28807,31.93433,0,0,0,0,100,0), +(@PATH,198,-5219.417,89.03807,31.93433,0,0,0,0,100,0), +(@PATH,199,-5219.667,88.03807,31.68433,0,0,0,0,100,0), +(@PATH,200,-5220.667,83.78807,30.93433,0,0,0,0,100,0), +(@PATH,201,-5220.916,83.39401,31.0205,0,0,0,0,100,0), +(@PATH,202,-5221.166,81.89401,30.5205,0,0,0,0,100,0), +(@PATH,203,-5222.416,80.39401,30.5205,0,0,0,0,100,0), +(@PATH,204,-5224.916,77.39401,29.7705,0,0,0,0,100,0), +(@PATH,205,-5226.666,74.64401,29.0205,0,0,0,0,100,0), +(@PATH,206,-5229.454,71.30865,27.17989,0,0,0,0,100,0), +(@PATH,207,-5231.454,69.55865,26.67989,0,0,0,0,100,0), +(@PATH,208,-5233.454,67.80865,26.42989,0,0,0,0,100,0), +(@PATH,209,-5235.954,65.30865,25.92989,0,0,0,0,100,0), +(@PATH,210,-5238.704,63.05865,25.92989,0,0,0,0,100,0), +(@PATH,211,-5238.986,62.67425,25.55547,0,0,0,0,100,0), +(@PATH,212,-5240.736,60.92425,25.55547,0,0,0,0,100,0), +(@PATH,213,-5240.736,59.42425,25.80547,0,0,0,0,100,0), +(@PATH,214,-5240.486,58.17425,26.05547,0,0,0,0,100,0), +(@PATH,215,-5240.236,55.67425,26.30547,0,0,0,0,100,0), +(@PATH,216,-5239.986,51.92425,25.30547,0,0,0,0,100,0), +(@PATH,217,-5239.736,48.17425,24.30547,0,0,0,0,100,0), +(@PATH,218,-5240.034,49.19074,24.30041,0,0,0,0,100,0), +(@PATH,219,-5239.379,51.09781,25.09744,0,0,0,0,100,0), +(@PATH,220,-5238.629,55.84781,26.34744,0,0,0,0,100,0), +(@PATH,221,-5238.129,57.84781,26.59744,0,0,0,0,100,0), +(@PATH,222,-5237.879,59.34781,26.59744,0,0,0,0,100,0), +(@PATH,223,-5237.629,60.59781,26.34744,0,0,0,0,100,0), +(@PATH,224,-5237.129,63.09781,26.09744,0,0,0,0,100,0), +(@PATH,225,-5236.629,66.59781,25.84744,0,0,0,0,100,0), +(@PATH,226,-5233.879,68.34781,26.59744,0,0,0,0,100,0), +(@PATH,227,-5232.879,68.84781,26.59744,0,0,0,0,100,0), +(@PATH,228,-5231.379,69.84781,27.09744,0,0,0,0,100,0), +(@PATH,229,-5229.129,71.34781,27.34744,0,0,0,0,100,0), +(@PATH,230,-5226.379,73.84781,28.34744,0,0,0,0,100,0), +(@PATH,231,-5225.129,76.59781,29.84744,0,0,0,0,100,0), +(@PATH,232,-5222.879,80.09781,30.34744,0,0,0,0,100,0), +(@PATH,233,-5220.879,83.34781,30.84744,0,0,0,0,100,0), +(@PATH,234,-5219.879,88.59781,31.84744,0,0,0,0,100,0), +(@PATH,235,-5221.129,88.09781,32.09744,0,0,0,0,100,0), +(@PATH,236,-5220.879,89.59781,32.34744,0,0,0,0,100,0), +(@PATH,237,-5220.629,89.84781,32.59744,0,0,0,0,100,0), +(@PATH,238,-5220.629,90.34781,32.34744,0,0,0,0,100,0), +(@PATH,239,-5220.129,91.09781,32.09744,0,0,0,0,100,0), +(@PATH,240,-5219.629,94.34781,31.59744,0,0,0,0,100,0), +(@PATH,241,-5219.129,96.59781,31.59744,0,0,0,0,100,0), +(@PATH,242,-5237.413,58.5357,26.76229,0,0,0,0,100,0), +(@PATH,243,-5236.413,60.5357,27.51229,0,0,0,0,100,0), +(@PATH,244,-5235.663,61.7857,27.51229,0,0,0,0,100,0), +(@PATH,245,-5235.663,63.0357,26.26229,0,0,0,0,100,0), +(@PATH,246,-5235.413,63.7857,26.26229,0,0,0,0,100,0), +(@PATH,247,-5233.663,66.0357,26.51229,0,0,0,0,100,0), +(@PATH,248,-5232.663,68.0357,26.51229,0,0,0,0,100,0), +(@PATH,249,-5230.913,69.0357,27.01229,0,0,0,0,100,0), +(@PATH,250,-5229.163,71.2857,27.26229,0,0,0,0,100,0), +(@PATH,251,-5226.413,74.0357,28.26229,0,0,0,0,100,0), +(@PATH,252,-5225.163,76.7857,29.76229,0,0,0,0,100,0), +(@PATH,253,-5222.913,80.2857,30.51229,0,0,0,0,100,0), +(@PATH,254,-5236.667,60.31218,27.45053,0,0,0,0,100,0), +(@PATH,255,-5235.917,61.81218,27.20053,0,0,0,0,100,0), +(@PATH,256,-5235.667,63.06218,26.20053,0,0,0,0,100,0), +(@PATH,257,-5235.417,63.81218,26.20053,0,0,0,0,100,0), +(@PATH,258,-5233.667,66.06218,26.45053,0,0,0,0,100,0), +(@PATH,259,-5232.917,68.06218,26.45053,0,0,0,0,100,0), +(@PATH,260,-5230.917,69.31218,26.95053,0,0,0,0,100,0), +(@PATH,261,-5228.917,71.56218,27.45053,0,0,0,0,100,0), +(@PATH,262,-5226.417,74.31218,28.45053,0,0,0,0,100,0), +(@PATH,263,-5225.167,76.56218,29.70053,0,0,0,0,100,0), +(@PATH,264,-5222.917,80.06218,30.45053,0,0,0,0,100,0), +(@PATH,265,-5220.917,83.31218,30.95053,0,0,0,0,100,0), +(@PATH,266,-5219.917,88.56218,31.70053,0,0,0,0,100,0), +(@PATH,267,-5221.167,88.06218,31.95053,0,0,0,0,100,0), +(@PATH,268,-5220.917,89.56218,32.45053,0,0,0,0,100,0), +(@PATH,269,-5220.667,89.81218,32.45053,0,0,0,0,100,0), +(@PATH,270,-5220.667,90.31218,32.20053,0,0,0,0,100,0), +(@PATH,271,-5220.417,91.31218,31.95053,0,0,0,0,100,0), +(@PATH,272,-5236.568,60.40508,27.28552,0,0,0,0,100,0), +(@PATH,273,-5236.068,61.90508,27.28552,0,0,0,0,100,0), +(@PATH,274,-5235.818,62.90508,26.28552,0,0,0,0,100,0), +(@PATH,275,-5235.318,63.90508,26.28552,0,0,0,0,100,0), +(@PATH,276,-5233.568,66.15508,26.28552,0,0,0,0,100,0), +(@PATH,277,-5232.818,67.90508,26.53552,0,0,0,0,100,0), +(@PATH,278,-5230.818,69.15508,27.03552,0,0,0,0,100,0), +(@PATH,279,-5228.818,71.40508,27.28552,0,0,0,0,100,0), +(@PATH,280,-5226.318,74.15508,28.53552,0,0,0,0,100,0), +(@PATH,281,-5225.318,76.65508,29.78552,0,0,0,0,100,0), +(@PATH,282,-5222.818,80.15508,30.53552,0,0,0,0,100,0), +(@PATH,283,-5220.818,83.40508,30.78552,0,0,0,0,100,0), +(@PATH,284,-5219.818,88.40508,31.78552,0,0,0,0,100,0), +(@PATH,285,-5221.318,87.90508,32.03552,0,0,0,0,100,0), +(@PATH,286,-5220.818,89.40508,32.28552,0,0,0,0,100,0), +(@PATH,287,-5220.818,89.90508,32.53552,0,0,0,0,100,0), +(@PATH,288,-5220.568,90.40508,32.28552,0,0,0,0,100,0), +(@PATH,289,-5220.318,91.15508,32.03552,0,0,0,0,100,0), +(@PATH,290,-5232.086,67.81458,26.6106,0,0,0,0,100,0), +(@PATH,291,-5230.836,69.31458,26.8606,0,0,0,0,100,0), +(@PATH,292,-5228.836,71.56458,27.3606,0,0,0,0,100,0), +(@PATH,293,-5226.086,74.31458,28.6106,0,0,0,0,100,0), +(@PATH,294,-5225.336,76.81458,29.6106,0,0,0,0,100,0), +(@PATH,295,-5222.836,80.31458,30.3606,0,0,0,0,100,0), +(@PATH,296,-5220.836,83.56458,30.8606,0,0,0,0,100,0), +(@PATH,297,-5219.836,85.56458,31.1106,0,0,0,0,100,0), +(@PATH,298,-5219.586,86.81458,31.3606,0,0,0,0,100,0), +(@PATH,299,-5219.336,88.56458,31.6106,0,0,0,0,100,0), +(@PATH,300,-5219.336,89.31458,31.8606,0,0,0,0,100,0), +(@PATH,301,-5219.336,90.06458,32.1106,0,0,0,0,100,0), +(@PATH,302,-5219.336,90.31458,31.8606,0,0,0,0,100,0), +(@PATH,303,-5219.086,93.31458,31.6106,0,0,0,0,100,0), +(@PATH,304,-5218.836,96.56458,31.6106,0,0,0,0,100,0), +(@PATH,305,-5218.836,97.31458,31.6106,0,0,0,0,100,0), +(@PATH,306,-5218.836,98.81458,31.3606,0,0,0,0,100,0), +(@PATH,307,-5218.586,101.0646,31.6106,0,0,0,0,100,0), +(@PATH,308,-5226.293,74.1495,28.43657,0,0,0,0,100,0), +(@PATH,309,-5225.043,76.8995,29.93657,0,0,0,0,100,0), +(@PATH,310,-5222.543,80.3995,30.43657,0,0,0,0,100,0), +(@PATH,311,-5220.793,83.6495,30.93657,0,0,0,0,100,0), +(@PATH,312,-5220.043,88.6495,31.68657,0,0,0,0,100,0), +(@PATH,313,-5221.293,88.1495,32.18657,0,0,0,0,100,0), +(@PATH,314,-5221.793,89.1495,32.68657,0,0,0,0,100,0), +(@PATH,315,-5221.293,90.1495,32.93657,0,0,0,0,100,0), +(@PATH,316,-5221.293,90.6495,32.43657,0,0,0,0,100,0), +(@PATH,317,-5220.793,92.3995,31.93657,0,0,0,0,100,0), +(@PATH,318,-5220.293,94.8995,31.68657,0,0,0,0,100,0), +(@PATH,319,-5219.793,96.6495,31.68657,0,0,0,0,100,0), +(@PATH,320,-5219.543,98.6495,31.43657,0,0,0,0,100,0), +(@PATH,321,-5219.043,100.8995,31.68657,0,0,0,0,100,0), +(@PATH,322,-5218.543,103.6495,31.93657,0,0,0,0,100,0), +(@PATH,323,-5218.043,105.6495,31.68657,0,0,0,0,100,0), +(@PATH,324,-5217.543,108.1495,32.43657,0,0,0,0,100,0), +(@PATH,325,-5222.236,83.09225,31.52889,0,0,0,0,100,0), +(@PATH,326,-5222.486,85.84225,32.02889,0,0,0,0,100,0), +(@PATH,327,-5222.236,87.09225,32.52889,0,0,0,0,100,0), +(@PATH,328,-5221.736,88.09225,32.77889,0,0,0,0,100,0), +(@PATH,329,-5221.736,88.59225,32.77889,0,0,0,0,100,0), +(@PATH,330,-5221.736,89.09225,32.52889,0,0,0,0,100,0), +(@PATH,331,-5220.986,90.09225,32.77889,0,0,0,0,100,0), +(@PATH,332,-5220.986,90.59225,32.52889,0,0,0,0,100,0), +(@PATH,333,-5220.486,92.09225,32.02889,0,0,0,0,100,0), +(@PATH,334,-5219.736,94.84225,32.02889,0,0,0,0,100,0), +(@PATH,335,-5219.236,96.84225,31.77889,0,0,0,0,100,0), +(@PATH,336,-5218.486,97.84225,31.77889,0,0,0,0,100,0), +(@PATH,337,-5218.236,98.84225,31.77889,0,0,0,0,100,0), +(@PATH,338,-5217.236,101.3423,31.77889,0,0,0,0,100,0), +(@PATH,339,-5215.236,106.5923,32.02889,0,0,0,0,100,0), +(@PATH,340,-5221.777,88.9509,32.42404,0,0,0,0,100,0), +(@PATH,341,-5221.277,88.2009,32.17404,0,0,0,0,100,0), +(@PATH,342,-5222.027,84.7009,31.42404,0,0,0,0,100,0), +(@PATH,343,-5222.027,83.7009,31.42404,0,0,0,0,100,0), +(@PATH,344,-5222.777,80.2009,30.42404,0,0,0,0,100,0), +(@PATH,345,-5225.027,76.4509,29.67404,0,0,0,0,100,0), +(@PATH,346,-5226.527,73.9509,28.42404,0,0,0,0,100,0), +(@PATH,347,-5228.277,70.9509,27.67404,0,0,0,0,100,0), +(@PATH,348,-5228.527,70.7009,27.42404,0,0,0,0,100,0), +(@PATH,349,-5230.027,70.2009,27.17404,0,0,0,0,100,0), +(@PATH,350,-5230.777,69.2009,26.92404,0,0,0,0,100,0), +(@PATH,351,-5233.027,67.9509,26.42404,0,0,0,0,100,0), +(@PATH,352,-5235.027,63.4509,26.17404,0,0,0,0,100,0), +(@PATH,353,-5237.527,61.4509,26.17404,0,0,0,0,100,0), +(@PATH,354,-5238.027,59.7009,26.42404,0,0,0,0,100,0), +(@PATH,355,-5238.777,57.2009,26.67404,0,0,0,0,100,0), +(@PATH,356,-5239.027,55.7009,26.42404,0,0,0,0,100,0), +(@PATH,357,-5239.777,53.7009,25.92404,0,0,0,0,100,0), +(@PATH,358,-5239.826,48.20284,24.41989,0,0,0,0,100,0), +(@PATH,359,-5239.878,47.98527,24.13947,0,0,0,0,100,0), +(@PATH,360,-5239.878,47.23527,23.88947,0,0,0,0,100,0), +(@PATH,361,-5241.378,43.73527,22.63947,0,0,0,0,100,0), +(@PATH,362,-5241.878,42.48527,22.38947,0,0,0,0,100,0), +(@PATH,363,-5244.628,35.73527,20.63947,0,0,0,0,100,0), +(@PATH,364,-5245.128,34.23527,20.38947,0,0,0,0,100,0), +(@PATH,365,-5246.628,31.23527,19.88947,0,0,0,0,100,0), +(@PATH,366,-5247.758,28.70945,19.7551,0,0,0,0,100,0), +(@PATH,367,-5248.758,27.95945,19.7551,0,0,0,0,100,0), +(@PATH,368,-5249.508,27.20945,19.5051,0,0,0,0,100,0), +(@PATH,369,-5251.008,25.95945,19.5051,0,0,0,0,100,0), +(@PATH,370,-5253.258,24.20945,19.5051,0,0,0,0,100,0), +(@PATH,371,-5254.758,22.95945,19.5051,0,0,0,0,100,0), +(@PATH,372,-5256.008,21.95945,19.5051,0,0,0,0,100,0), +(@PATH,373,-5257.758,20.45945,19.5051,0,0,0,0,100,0), +(@PATH,374,-5258.508,19.95945,19.2551,0,0,0,0,100,0), +(@PATH,375,-5260.008,18.70945,18.7551,0,0,0,0,100,0), +(@PATH,376,-5262.008,16.95945,18.2551,0,0,0,0,100,0), +(@PATH,377,-5264.008,15.20945,17.7551,0,0,0,0,100,0), +(@PATH,378,-5263.97,14.96193,17.4592,0,0,0,0,100,0), +(@PATH,379,-5265.72,13.71193,17.7092,0,0,0,0,100,0), +(@PATH,380,-5263.22,9.711926,16.7092,0,0,0,0,100,0), +(@PATH,381,-5260.72,5.961926,15.4592,0,0,0,0,100,0), +(@PATH,382,-5258.22,1.461926,14.2092,0,0,0,0,100,0), +(@PATH,383,-5257.47,0.2119265,13.9592,0,0,0,0,100,0), +(@PATH,384,-5256.22,-1.788074,13.7092,0,0,0,0,100,0), +(@PATH,385,-5254.816,-4.532428,13.49723,0,0,0,0,100,0), +(@PATH,386,-5258.066,-7.282428,13.74723,0,0,0,0,100,0), +(@PATH,387,-5262.066,-10.28243,14.49723,0,0,0,0,100,0), +(@PATH,388,-5264.566,-12.28243,14.99723,0,0,0,0,100,0), +(@PATH,389,-5265.316,-13.03243,14.99723,0,0,0,0,100,0), +(@PATH,390,-5270.066,-16.78243,16.49723,0,0,0,0,100,0), +(@PATH,391,-5270.447,-16.55567,16.68727,0,0,0,0,100,0), +(@PATH,392,-5271.697,-17.55567,17.18727,0,0,0,0,100,0), +(@PATH,393,-5274.947,-15.55567,17.93727,0,0,0,0,100,0), +(@PATH,394,-5276.697,-14.30567,18.18727,0,0,0,0,100,0), +(@PATH,395,-5282.197,-10.55567,19.43727,0,0,0,0,100,0), +(@PATH,396,-5285.447,-8.305672,19.68727,0,0,0,0,100,0), +(@PATH,397,-5288.947,-6.055672,20.18727,0,0,0,0,100,0), +(@PATH,398,-5288.929,-5.749834,20.11903,0,0,0,0,100,0), +(@PATH,399,-5290.179,-4.749834,20.36903,0,0,0,0,100,0), +(@PATH,400,-5290.179,-3.749834,20.11903,0,0,0,0,100,0), +(@PATH,401,-5289.679,-1.249834,19.86903,0,0,0,0,100,0), +(@PATH,402,-5289.429,0.2501664,19.86903,0,0,0,0,100,0), +(@PATH,403,-5288.929,2.750166,19.61903,0,0,0,0,100,0), +(@PATH,404,-5288.679,4.750166,19.86903,0,0,0,0,100,0), +(@PATH,405,-5287.679,10.75017,19.86903,0,0,0,0,100,0), +(@PATH,406,-5286.929,14.75017,19.61903,0,0,0,0,100,0), +(@PATH,407,-5287.064,14.92672,19.64984,0,0,0,0,100,0), +(@PATH,408,-5286.564,16.92672,19.64984,0,0,0,0,100,0), +(@PATH,409,-5284.814,17.42672,19.64984,0,0,0,0,100,0), +(@PATH,410,-5280.064,18.67672,19.64984,0,0,0,0,100,0), +(@PATH,411,-5277.314,19.17672,19.64984,0,0,0,0,100,0), +(@PATH,412,-5276.861,19.28388,19.63351,0,0,0,0,100,0), +(@PATH,413,-5274.861,19.78388,19.38351,0,0,0,0,100,0), +(@PATH,414,-5272.361,18.28388,18.88351,0,0,0,0,100,0), +(@PATH,415,-5271.111,17.53388,18.88351,0,0,0,0,100,0), +(@PATH,416,-5270.757,17.4675,18.74797,0,0,0,0,100,0), +(@PATH,417,-5272.257,18.2175,18.99797,0,0,0,0,100,0), +(@PATH,418,-5274.507,19.4675,19.24797,0,0,0,0,100,0), +(@PATH,419,-5274.733,19.54021,19.42813,0,0,0,0,100,0), +(@PATH,420,-5275.233,19.79021,19.42813,0,0,0,0,100,0), +(@PATH,421,-5277.233,19.29021,19.67813,0,0,0,0,100,0), +(@PATH,422,-5279.983,18.54021,19.67813,0,0,0,0,100,0), +(@PATH,423,-5284.733,17.79021,19.67813,0,0,0,0,100,0), +(@PATH,424,-5286.851,16.95185,19.92856,0,0,0,0,100,0), +(@PATH,425,-5287.101,14.70185,19.92856,0,0,0,0,100,0), +(@PATH,426,-5287.601,10.95185,19.92856,0,0,0,0,100,0), +(@PATH,427,-5288.601,4.701854,19.92856,0,0,0,0,100,0), +(@PATH,428,-5289.101,2.701854,19.92856,0,0,0,0,100,0), +(@PATH,429,-5289.351,0.2018538,19.92856,0,0,0,0,100,0), +(@PATH,430,-5289.601,-1.298146,19.92856,0,0,0,0,100,0), +(@PATH,431,-5290.101,-3.798146,20.17856,0,0,0,0,100,0), +(@PATH,432,-5290.297,-5.058611,20.49877,0,0,0,0,100,0), +(@PATH,433,-5288.797,-6.058611,20.24877,0,0,0,0,100,0), +(@PATH,434,-5286.297,-7.808611,19.74877,0,0,0,0,100,0), +(@PATH,435,-5282.797,-10.30861,19.49877,0,0,0,0,100,0), +(@PATH,436,-5276.547,-14.30861,18.24877,0,0,0,0,100,0), +(@PATH,437,-5274.797,-15.55861,17.74877,0,0,0,0,100,0), +(@PATH,438,-5271.375,-17.7897,16.85445,0,0,0,0,100,0), +(@PATH,439,-5270.125,-16.7897,16.35445,0,0,0,0,100,0), +(@PATH,440,-5265.375,-13.0397,15.10445,0,0,0,0,100,0), +(@PATH,441,-5264.625,-12.2897,14.85445,0,0,0,0,100,0), +(@PATH,442,-5262.125,-10.2897,14.35445,0,0,0,0,100,0), +(@PATH,443,-5258.125,-7.289699,13.85445,0,0,0,0,100,0), +(@PATH,444,-5254.784,-4.322564,13.65262,0,0,0,0,100,0), +(@PATH,445,-5256.034,-1.822564,13.65262,0,0,0,0,100,0), +(@PATH,446,-5257.534,0.1774359,14.15262,0,0,0,0,100,0), +(@PATH,447,-5258.034,1.177436,14.15262,0,0,0,0,100,0), +(@PATH,448,-5261.034,5.927436,15.65262,0,0,0,0,100,0), +(@PATH,449,-5263.034,9.677436,16.65262,0,0,0,0,100,0), +(@PATH,450,-5265.284,13.17744,17.65262,0,0,0,0,100,0), +(@PATH,451,-5265.303,13.53943,17.99142,0,0,0,0,100,0), +(@PATH,452,-5265.553,14.03943,17.99142,0,0,0,0,100,0), +(@PATH,453,-5264.053,15.28943,17.74142,0,0,0,0,100,0), +(@PATH,454,-5262.053,17.03943,18.24142,0,0,0,0,100,0), +(@PATH,455,-5260.053,18.53943,18.49142,0,0,0,0,100,0), +(@PATH,456,-5258.553,19.78943,19.24142,0,0,0,0,100,0), +(@PATH,457,-5257.803,20.28943,19.49142,0,0,0,0,100,0), +(@PATH,458,-5255.803,22.03943,19.74142,0,0,0,0,100,0), +(@PATH,459,-5254.803,23.03943,19.49142,0,0,0,0,100,0), +(@PATH,460,-5253.303,24.28943,19.49142,0,0,0,0,100,0), +(@PATH,461,-5251.053,26.03943,19.49142,0,0,0,0,100,0), +(@PATH,462,-5249.553,27.28943,19.49142,0,0,0,0,100,0), +(@PATH,463,-5249.163,27.65932,19.72506,0,0,0,0,100,0), +(@PATH,464,-5247.413,28.90932,19.97506,0,0,0,0,100,0), +(@PATH,465,-5246.913,30.40932,19.72506,0,0,0,0,100,0), +(@PATH,466,-5245.163,34.15932,20.47506,0,0,0,0,100,0), +(@PATH,467,-5244.913,35.90932,20.72506,0,0,0,0,100,0), +(@PATH,468,-5241.913,42.40932,22.22506,0,0,0,0,100,0), +(@PATH,469,-5241.413,43.65932,22.72506,0,0,0,0,100,0), +(@PATH,470,-5239.825,47.68528,24.02127,0,0,0,0,100,0), +(@PATH,471,-5240.325,51.68528,25.27127,0,0,0,0,100,0), +(@PATH,472,-5240.575,55.68528,26.02127,0,0,0,0,100,0), +(@PATH,473,-5240.825,58.18528,26.02127,0,0,0,0,100,0), +(@PATH,474,-5240.825,59.43528,25.77127,0,0,0,0,100,0), +(@PATH,475,-5240.422,58.26842,26.12953,0,0,0,0,100,0), +(@PATH,476,-5240.672,59.51842,26.12953,0,0,0,0,100,0), +(@PATH,477,-5240.672,61.01842,25.87953,0,0,0,0,100,0), +(@PATH,478,-5238.672,63.01842,25.87953,0,0,0,0,100,0), +(@PATH,479,-5235.922,65.01842,25.87953,0,0,0,0,100,0), +(@PATH,480,-5233.422,67.76842,26.37953,0,0,0,0,100,0), +(@PATH,481,-5231.422,69.51842,26.62953,0,0,0,0,100,0), +(@PATH,482,-5229.338,71.33797,27.34687,0,0,0,0,100,0), +(@PATH,483,-5226.838,74.58797,28.34687,0,0,0,0,100,0), +(@PATH,484,-5225.338,76.58797,29.84687,0,0,0,0,100,0), +(@PATH,485,-5222.838,79.83797,30.34687,0,0,0,0,100,0), +(@PATH,486,-5222.535,80.166,30.68865,0,0,0,0,100,0), +(@PATH,487,-5221.285,82.166,30.68865,0,0,0,0,100,0), +(@PATH,488,-5221.035,83.416,30.68865,0,0,0,0,100,0), +(@PATH,489,-5219.785,87.916,31.68865,0,0,0,0,100,0), +(@PATH,490,-5219.535,88.916,31.93865,0,0,0,0,100,0), +(@PATH,491,-5219.285,89.916,32.18865,0,0,0,0,100,0), +(@PATH,492,-5218.53,92.46011,31.85782,0,0,0,0,100,0), +(@PATH,493,-5217.28,95.96011,31.85782,0,0,0,0,100,0), +(@PATH,494,-5216.78,97.71011,32.10782,0,0,0,0,100,0), +(@PATH,495,-5216.28,98.96011,32.10782,0,0,0,0,100,0), +(@PATH,496,-5215.78,100.7101,32.10782,0,0,0,0,100,0), +(@PATH,497,-5214.78,102.9601,32.10782,0,0,0,0,100,0), +(@PATH,498,-5213.53,107.2101,32.60782,0,0,0,0,100,0), +(@PATH,499,-5210.28,116.7101,34.35782,0,0,0,0,100,0), +(@PATH,500,-5209.971,117.058,34.63634,0,0,0,0,100,0), +(@PATH,501,-5209.721,118.308,34.38634,0,0,0,0,100,0), +(@PATH,502,-5207.471,128.808,34.63634,0,0,0,0,100,0), +(@PATH,503,-5207.221,130.308,35.63634,0,0,0,0,100,0), +(@PATH,504,-5206.721,131.308,36.38634,0,0,0,0,100,0), +(@PATH,505,-5206.221,132.058,36.88634,0,0,0,0,100,0), +(@PATH,506,-5205.971,133.058,37.63634,0,0,0,0,100,0), +(@PATH,507,-5205.471,134.058,38.38634,0,0,0,0,100,0), +(@PATH,508,-5204.471,135.808,39.38634,0,0,0,0,100,0), +(@PATH,509,-5203.721,137.558,39.88634,0,0,0,0,100,0), +(@PATH,510,-5202.721,139.058,40.63634,0,0,0,0,100,0), +(@PATH,511,-5201.971,140.808,41.38634,0,0,0,0,100,0), +(@PATH,512,-5200.721,143.558,41.88634,0,0,0,0,100,0), +(@PATH,513,-5199.971,145.308,42.38634,0,0,0,0,100,0), +(@PATH,514,-5198.971,147.058,43.13634,0,0,0,0,100,0), +(@PATH,515,-5198.221,149.058,43.88634,0,0,0,0,100,0), +(@PATH,516,-5196.971,151.558,44.63634,0,0,0,0,100,0), +(@PATH,517,-5195.971,153.558,45.63634,0,0,0,0,100,0), +(@PATH,518,-5195.221,155.308,46.38634,0,0,0,0,100,0), +(@PATH,519,-5193.721,158.058,47.13634,0,0,0,0,100,0), +(@PATH,520,-5192.971,159.808,48.13634,0,0,0,0,100,0), +(@PATH,521,-5191.971,161.558,48.88634,0,0,0,0,100,0), +(@PATH,522,-5191.667,161.882,48.92622,0,0,0,0,100,0), +(@PATH,523,-5191.417,162.632,49.42622,0,0,0,0,100,0), +(@PATH,524,-5190.667,165.632,49.67622,0,0,0,0,100,0), +(@PATH,525,-5190.417,167.382,50.42622,0,0,0,0,100,0), +(@PATH,526,-5189.167,172.382,50.92622,0,0,0,0,100,0), +(@PATH,527,-5187.167,182.882,50.42622,0,0,0,0,100,0); + +-- Pathing for Entry: 5255 'TDB FORMAT' +SET @NPC := 368886; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4884.714,`position_y`=273.2483,`position_z`=38.26245 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,-4884.714,273.2483,38.26245,0,0,0,0,100,0), +(@PATH,2,-4886.714,273.2483,39.01245,0,0,0,0,100,0), +(@PATH,3,-4888.714,273.2483,39.76245,0,0,0,0,100,0), +(@PATH,4,-4890.714,273.2483,40.51245,0,0,0,0,100,0), +(@PATH,5,-4891.053,272.981,40.5994,0,0,0,0,100,0), +(@PATH,6,-4891.303,272.981,40.5994,0,0,0,0,100,0), +(@PATH,7,-4894.303,272.231,41.0994,0,0,0,0,100,0), +(@PATH,8,-4899.036,271.5039,41.68027,0,0,0,0,100,0), +(@PATH,9,-4902.605,268.7781,41.89622,0,0,0,0,100,0), +(@PATH,10,-4904.105,269.7781,41.64622,0,0,0,0,100,0), +(@PATH,11,-4906.355,269.7781,41.64622,0,0,0,0,100,0), +(@PATH,12,-4908.105,269.7781,41.64622,0,0,0,0,100,0), +(@PATH,13,-4912.14,267.2663,41.83344,0,0,0,0,100,0), +(@PATH,14,-4918.551,271.3675,41.32862,0,0,0,0,100,0), +(@PATH,15,-4925.551,267.8675,40.32862,0,0,0,0,100,0), +(@PATH,16,-4927.301,267.3675,39.82862,0,0,0,0,100,0), +(@PATH,17,-4929.051,266.3675,39.32862,0,0,0,0,100,0), +(@PATH,18,-4932.915,264.5541,38.20852,0,0,0,0,100,0), +(@PATH,19,-4935.665,263.3041,37.70852,0,0,0,0,100,0), +(@PATH,20,-4947.165,258.3041,38.45852,0,0,0,0,100,0), +(@PATH,21,-4951.524,256.5336,38.25072,0,0,0,0,100,0), +(@PATH,22,-4955.524,256.5336,37.50072,0,0,0,0,100,0), +(@PATH,23,-4964.274,256.5336,37.25072,0,0,0,0,100,0), +(@PATH,24,-4968.937,256.3702,37.17537,0,0,0,0,100,0), +(@PATH,25,-4976.264,248.8799,37.48759,0,0,0,0,100,0), +(@PATH,26,-4975.764,247.1299,37.98759,0,0,0,0,100,0), +(@PATH,27,-4975.014,245.1299,38.73759,0,0,0,0,100,0), +(@PATH,28,-4974.514,243.3799,39.23759,0,0,0,0,100,0), +(@PATH,29,-4973.764,240.6299,40.48759,0,0,0,0,100,0), +(@PATH,30,-4973.264,238.6299,40.98759,0,0,0,0,100,0), +(@PATH,31,-4973.914,240.177,40.67776,0,0,0,0,100,0), +(@PATH,32,-4973.414,238.427,41.42776,0,0,0,0,100,0), +(@PATH,33,-4973.164,237.677,41.42776,0,0,0,0,100,0), +(@PATH,34,-4974.414,234.927,42.17776,0,0,0,0,100,0), +(@PATH,35,-4975.164,233.177,42.92776,0,0,0,0,100,0), +(@PATH,36,-4976.164,231.427,43.67776,0,0,0,0,100,0), +(@PATH,37,-4976.914,229.677,44.67776,0,0,0,0,100,0), +(@PATH,38,-4977.414,228.927,44.92776,0,0,0,0,100,0), +(@PATH,39,-4977.914,227.177,46.17776,0,0,0,0,100,0), +(@PATH,40,-4978.664,225.177,47.17776,0,0,0,0,100,0), +(@PATH,41,-4979.664,223.427,47.92776,0,0,0,0,100,0), +(@PATH,42,-4979.914,222.427,48.92776,0,0,0,0,100,0), +(@PATH,43,-4980.414,221.677,49.42776,0,0,0,0,100,0), +(@PATH,44,-4980.364,221.5824,49.5107,0,0,0,0,100,0), +(@PATH,45,-4979.864,222.5824,49.0107,0,0,0,0,100,0), +(@PATH,46,-4979.614,223.3324,48.0107,0,0,0,0,100,0), +(@PATH,47,-4979.114,224.3324,47.5107,0,0,0,0,100,0), +(@PATH,48,-4978.364,226.0824,46.5107,0,0,0,0,100,0), +(@PATH,49,-4977.364,228.0824,45.5107,0,0,0,0,100,0), +(@PATH,50,-4976.864,229.5824,44.7607,0,0,0,0,100,0), +(@PATH,51,-4976.114,231.3324,43.7607,0,0,0,0,100,0), +(@PATH,52,-4975.364,233.0824,43.0107,0,0,0,0,100,0), +(@PATH,53,-4974.364,235.0824,42.2607,0,0,0,0,100,0), +(@PATH,54,-4973.614,236.8324,41.5107,0,0,0,0,100,0), +(@PATH,55,-4973.474,236.9623,41.45076,0,0,0,0,100,0), +(@PATH,56,-4973.224,237.9623,41.20076,0,0,0,0,100,0), +(@PATH,57,-4973.724,239.9623,40.45076,0,0,0,0,100,0), +(@PATH,58,-4974.224,241.7123,39.95076,0,0,0,0,100,0), +(@PATH,59,-4975.224,244.4623,38.95076,0,0,0,0,100,0), +(@PATH,60,-4975.724,247.2123,38.20076,0,0,0,0,100,0), +(@PATH,61,-4975.974,248.2123,37.45076,0,0,0,0,100,0), +(@PATH,62,-4975.712,247.6372,37.87049,0,0,0,0,100,0), +(@PATH,63,-4975.962,248.6372,37.37049,0,0,0,0,100,0), +(@PATH,64,-4976.212,249.1372,37.37049,0,0,0,0,100,0), +(@PATH,65,-4968.651,256.3456,37.31293,0,0,0,0,100,0), +(@PATH,66,-4954.901,256.0956,37.81293,0,0,0,0,100,0), +(@PATH,67,-4951.233,256.5334,38.32558,0,0,0,0,100,0), +(@PATH,68,-4943.983,259.7834,37.82558,0,0,0,0,100,0), +(@PATH,69,-4941.483,260.5334,37.32558,0,0,0,0,100,0), +(@PATH,70,-4934.233,264.0334,38.07558,0,0,0,0,100,0), +(@PATH,71,-4933.916,264.1512,38.12816,0,0,0,0,100,0), +(@PATH,72,-4932.916,264.6512,38.37816,0,0,0,0,100,0), +(@PATH,73,-4930.166,265.9012,39.12816,0,0,0,0,100,0), +(@PATH,74,-4928.416,266.9012,39.37816,0,0,0,0,100,0), +(@PATH,75,-4926.666,267.4012,40.12816,0,0,0,0,100,0), +(@PATH,76,-4924.916,268.4012,40.62816,0,0,0,0,100,0), +(@PATH,77,-4918.333,271.4006,41.24422,0,0,0,0,100,0), +(@PATH,78,-4911.939,267.221,41.85921,0,0,0,0,100,0), +(@PATH,79,-4908.439,267.971,41.85921,0,0,0,0,100,0), +(@PATH,80,-4906.189,268.471,41.85921,0,0,0,0,100,0), +(@PATH,81,-4904.189,269.721,41.60921,0,0,0,0,100,0), +(@PATH,82,-4903.885,270.0188,41.78001,0,0,0,0,100,0), +(@PATH,83,-4902.385,269.0188,41.78001,0,0,0,0,100,0), +(@PATH,84,-4898.665,271.471,41.45531,0,0,0,0,100,0), +(@PATH,85,-4892.915,272.471,40.95531,0,0,0,0,100,0), +(@PATH,86,-4892.716,272.8899,40.86599,0,0,0,0,100,0), +(@PATH,87,-4891.216,272.8899,40.61599,0,0,0,0,100,0), +(@PATH,88,-4889.216,272.8899,39.61599,0,0,0,0,100,0), +(@PATH,89,-4887.216,273.1399,39.11599,0,0,0,0,100,0), +(@PATH,90,-4884.466,273.3899,38.36599,0,0,0,0,100,0); + + +-- Pathing for Entry: 5249 'TDB FORMAT' +SET @NPC := 368876; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4873.993,`position_y`=220.5485,`position_z`=51.18479 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,-4873.993,220.5485,51.18479,0,0,0,0,100,0), +(@PATH,2,-4876.493,219.0485,51.93479,0,0,0,0,100,0), +(@PATH,3,-4878.993,217.2985,52.43479,0,0,0,0,100,0), +(@PATH,4,-4880.493,216.0485,52.93479,0,0,0,0,100,0), +(@PATH,5,-4887.743,211.2985,53.68479,0,0,0,0,100,0), +(@PATH,6,-4880.155,222.1306,52.92086,0,0,0,0,100,0), +(@PATH,7,-4876.923,221.8701,52.17288,0,0,0,0,100,0), +(@PATH,8,-4875.173,221.6201,51.42288,0,0,0,0,100,0), +(@PATH,9,-4873.173,221.6201,50.92288,0,0,0,0,100,0); + +-- Pathing for Entry: 5251 'TDB FORMAT' +SET @NPC := 368880; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4839.896,`position_y`=181.4395,`position_z`=55.46026 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,-4839.896,181.4395,55.46026,0,0,0,0,100,0), +(@PATH,2,-4838.896,181.4395,55.71026,0,0,0,0,100,0), +(@PATH,3,-4836.273,183.7054,55.85098,0,0,0,0,100,0), +(@PATH,4,-4833.817,182.3424,55.94606,0,0,0,0,100,0), +(@PATH,5,-4835.668,179.4341,55.79248,0,0,0,0,100,0), +(@PATH,6,-4839.252,180.9546,55.49023,0,0,0,0,100,0), +(@PATH,7,-4843.002,180.2046,54.99023,0,0,0,0,100,0), +(@PATH,8,-4846.362,179.6616,54.64331,0,0,0,0,100,0), +(@PATH,9,-4853.542,175.7745,55.51675,0,0,0,0,100,0), +(@PATH,10,-4855.292,174.7745,56.51675,0,0,0,0,100,0), +(@PATH,11,-4857.792,173.5245,57.01675,0,0,0,0,100,0), +(@PATH,12,-4859.542,172.7745,58.01675,0,0,0,0,100,0), +(@PATH,13,-4863.202,170.4538,58.93052,0,0,0,0,100,0), +(@PATH,14,-4865.452,168.9538,59.68052,0,0,0,0,100,0), +(@PATH,15,-4865.767,168.6437,59.74581,0,0,0,0,100,0), +(@PATH,16,-4868.017,166.8937,60.24581,0,0,0,0,100,0), +(@PATH,17,-4869.767,163.6437,60.74581,0,0,0,0,100,0), +(@PATH,18,-4871.185,160.9657,61.05135,0,0,0,0,100,0), +(@PATH,19,-4874.295,152.8751,61.54371,0,0,0,0,100,0), +(@PATH,20,-4872.201,149.5904,61.91571,0,0,0,0,100,0), +(@PATH,21,-4873.12,147.697,62.06145,0,0,0,0,100,0), +(@PATH,22,-4875.399,147.2939,62.10222,0,0,0,0,100,0), +(@PATH,23,-4877.149,149.2939,62.10222,0,0,0,0,100,0), +(@PATH,24,-4875.276,153.5923,61.53163,0,0,0,0,100,0), +(@PATH,25,-4870.975,161.0217,61.00273,0,0,0,0,100,0), +(@PATH,26,-4868.475,166.0217,60.50273,0,0,0,0,100,0), +(@PATH,27,-4868.658,166.4669,60.3413,0,0,0,0,100,0), +(@PATH,28,-4867.908,167.9669,60.0913,0,0,0,0,100,0), +(@PATH,29,-4869.062,173.0209,60.02639,0,0,0,0,100,0), +(@PATH,30,-4876.523,184.3382,60.38634,0,0,0,0,100,0), +(@PATH,31,-4878.327,185.7026,60.41282,0,0,0,0,100,0), +(@PATH,32,-4880.88,186.3597,60.42987,0,0,0,0,100,0), +(@PATH,33,-4881.38,188.8597,60.17987,0,0,0,0,100,0), +(@PATH,34,-4881.46,189.0613,60.13811,0,0,0,0,100,0), +(@PATH,35,-4879.96,190.3113,60.38811,0,0,0,0,100,0), +(@PATH,36,-4879.751,190.1422,60.42075,0,0,0,0,100,0), +(@PATH,37,-4877.501,189.1422,60.42075,0,0,0,0,100,0), +(@PATH,38,-4877.208,189.1387,60.30001,0,0,0,0,100,0), +(@PATH,39,-4876.708,186.3887,60.30001,0,0,0,0,100,0), +(@PATH,40,-4873.409,180.6844,60.06448,0,0,0,0,100,0), +(@PATH,41,-4866.044,172.2506,59.84189,0,0,0,0,100,0), +(@PATH,42,-4864.294,172.0006,59.09189,0,0,0,0,100,0), +(@PATH,43,-4862.294,172.0006,58.84189,0,0,0,0,100,0), +(@PATH,44,-4862.023,172.0326,58.4705,0,0,0,0,100,0), +(@PATH,45,-4860.523,171.7826,58.2205,0,0,0,0,100,0), +(@PATH,46,-4858.773,173.0326,57.4705,0,0,0,0,100,0), +(@PATH,47,-4856.523,174.2826,56.7205,0,0,0,0,100,0), +(@PATH,48,-4854.773,175.2826,55.7205,0,0,0,0,100,0), +(@PATH,49,-4854.53,175.533,55.68449,0,0,0,0,100,0), +(@PATH,50,-4853.78,176.033,55.43449,0,0,0,0,100,0), +(@PATH,51,-4851.78,177.783,54.93449,0,0,0,0,100,0), +(@PATH,52,-4848.261,181.0432,54.01614,0,0,0,0,100,0), +(@PATH,53,-4849.011,185.7932,53.76614,0,0,0,0,100,0), +(@PATH,54,-4849.182,185.9659,53.43543,0,0,0,0,100,0), +(@PATH,55,-4849.432,187.4659,53.43543,0,0,0,0,100,0), +(@PATH,56,-4850.651,195.2792,52.93665,0,0,0,0,100,0), +(@PATH,57,-4851.901,198.7792,52.43665,0,0,0,0,100,0), +(@PATH,58,-4852.401,200.5292,51.68665,0,0,0,0,100,0), +(@PATH,59,-4853.151,202.5292,50.93665,0,0,0,0,100,0), +(@PATH,60,-4853.484,202.7661,50.73146,0,0,0,0,100,0), +(@PATH,61,-4853.734,203.2661,50.73146,0,0,0,0,100,0), +(@PATH,62,-4854.234,206.2661,49.48146,0,0,0,0,100,0), +(@PATH,63,-4854.484,208.0161,49.23146,0,0,0,0,100,0), +(@PATH,64,-4854.734,210.0161,48.48146,0,0,0,0,100,0), +(@PATH,65,-4855.484,213.0161,47.98146,0,0,0,0,100,0), +(@PATH,66,-4855.3,213.0118,47.82726,0,0,0,0,100,0), +(@PATH,67,-4855.55,213.5118,47.82726,0,0,0,0,100,0), +(@PATH,68,-4855.05,210.7618,48.32726,0,0,0,0,100,0), +(@PATH,69,-4854.55,207.7618,49.07726,0,0,0,0,100,0), +(@PATH,70,-4854.3,206.0118,49.57726,0,0,0,0,100,0), +(@PATH,71,-4853.8,204.0118,50.32726,0,0,0,0,100,0), +(@PATH,72,-4853.994,205.7042,49.86665,0,0,0,0,100,0), +(@PATH,73,-4853.494,203.7042,50.61665,0,0,0,0,100,0), +(@PATH,74,-4853.494,203.4542,50.86665,0,0,0,0,100,0), +(@PATH,75,-4852.744,201.7042,51.36665,0,0,0,0,100,0), +(@PATH,76,-4852.244,199.9542,51.86665,0,0,0,0,100,0), +(@PATH,77,-4851.744,198.2042,52.61665,0,0,0,0,100,0), +(@PATH,78,-4851.37,197.8955,52.66642,0,0,0,0,100,0), +(@PATH,79,-4850.62,194.8955,52.91642,0,0,0,0,100,0), +(@PATH,80,-4848.896,187.8846,53.57326,0,0,0,0,100,0), +(@PATH,81,-4847.896,183.3846,54.07326,0,0,0,0,100,0), +(@PATH,82,-4847.595,183.2742,54.33974,0,0,0,0,100,0), +(@PATH,83,-4846.845,181.2742,54.58974,0,0,0,0,100,0), +(@PATH,84,-4843.845,181.2742,54.83974,0,0,0,0,100,0), +(@PATH,85,-4840.095,181.5242,55.58974,0,0,0,0,100,0), +(@PATH,86,-4839.794,181.4356,55.39791,0,0,0,0,100,0), +(@PATH,87,-4839.044,181.4356,55.64791,0,0,0,0,100,0), +(@PATH,88,-4836.313,183.6654,55.81737,0,0,0,0,100,0), +(@PATH,89,-4833.906,182.3758,55.94017,0,0,0,0,100,0), +(@PATH,90,-4835.556,179.449,55.79279,0,0,0,0,100,0), +(@PATH,91,-4839.095,180.9321,55.66021,0,0,0,0,100,0), +(@PATH,92,-4842.845,180.1821,54.91021,0,0,0,0,100,0); |