diff options
| -rw-r--r-- | sql/updates/world/2014_07_30_04_world_waypoints.sql5 | 235 | ||||
| -rw-r--r-- | sql/updates/world/2014_07_30_05_world_waypoints.sql | 410 | ||||
| -rw-r--r-- | sql/updates/world/2014_07_30_06_world_waypoints.sql | 319 | ||||
| -rw-r--r-- | sql/updates/world/2014_07_30_07_world_waypoints.sql | 68 |
4 files changed, 516 insertions, 516 deletions
diff --git a/sql/updates/world/2014_07_30_04_world_waypoints.sql5 b/sql/updates/world/2014_07_30_04_world_waypoints.sql5 deleted file mode 100644 index 96a2ac74603..00000000000 --- a/sql/updates/world/2014_07_30_04_world_waypoints.sql5 +++ /dev/null @@ -1,235 +0,0 @@ --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71525; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-811.9146,`position_y`=5769.104,`position_z`=17.18619 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-811.9146,5769.104,17.18619,0,0,0,0,100,0), -(@PATH,2,-823.9103,5769.617,18.49771,0,0,0,0,100,0), -(@PATH,3,-837.1352,5761.915,13.98373,0,0,0,0,100,0), -(@PATH,4,-845.346,5746.582,15.9177,0,0,0,0,100,0), -(@PATH,5,-856.5806,5737.951,17.44125,0,0,0,0,100,0), -(@PATH,6,-870.8132,5739.455,18.25524,0,0,0,0,100,0), -(@PATH,7,-876.6976,5766.97,17.9558,0,0,0,0,100,0), -(@PATH,8,-879.2238,5786.183,17.97192,0,0,0,0,100,0), -(@PATH,9,-877.8231,5799.473,18.22192,0,0,0,0,100,0), -(@PATH,10,-875.8525,5816.587,18.1166,0,0,0,0,100,0), -(@PATH,11,-870.438,5833.134,17.8666,0,0,0,0,100,0), -(@PATH,12,-875.8525,5816.587,18.1166,0,0,0,0,100,0), -(@PATH,13,-877.8231,5799.473,18.22192,0,0,0,0,100,0), -(@PATH,14,-879.2238,5786.183,17.97192,0,0,0,0,100,0), -(@PATH,15,-876.6976,5766.97,17.9558,0,0,0,0,100,0), -(@PATH,16,-870.8132,5739.455,18.25524,0,0,0,0,100,0), -(@PATH,17,-856.5806,5737.951,17.44125,0,0,0,0,100,0), -(@PATH,18,-845.346,5746.582,15.9177,0,0,0,0,100,0), -(@PATH,19,-837.1352,5761.915,13.98373,0,0,0,0,100,0), -(@PATH,20,-823.9103,5769.617,18.49771,0,0,0,0,100,0), -(@PATH,21,-811.9146,5769.104,17.18619,0,0,0,0,100,0), -(@PATH,22,-803.7941,5777.138,19.5491,0,0,0,0,100,0), -(@PATH,23,-805.7983,5789.479,19.2897,0,0,0,0,100,0), -(@PATH,24,-813.3177,5798.603,18.38748,0,0,0,0,100,0), -(@PATH,25,-825.4734,5800.777,17.13269,0,0,0,0,100,0), -(@PATH,26,-841.5132,5803.947,14.80724,0,0,0,0,100,0), -(@PATH,27,-853.8585,5824.338,14.71092,0,0,0,0,100,0), -(@PATH,28,-864.2906,5832.222,17.76622,0,0,0,0,100,0), -(@PATH,29,-853.9316,5824.39,14.72874,0,0,0,0,100,0), -(@PATH,30,-841.5132,5803.947,14.80724,0,0,0,0,100,0), -(@PATH,31,-825.4734,5800.777,17.13269,0,0,0,0,100,0), -(@PATH,32,-813.3177,5798.603,18.38748,0,0,0,0,100,0), -(@PATH,33,-805.7983,5789.479,19.2897,0,0,0,0,100,0), -(@PATH,34,-803.7941,5777.138,19.5491,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71526; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-410.8705,`position_y`=6309.836,`position_z`=17.62405 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-410.8705,6309.836,17.62405,0,0,0,0,100,0), -(@PATH,2,-397.7162,6294.659,17.62408,0,0,0,0,100,0), -(@PATH,3,-386.2312,6282.547,17.49908,0,0,0,0,100,0), -(@PATH,4,-397.7162,6294.659,17.62408,0,0,0,0,100,0), -(@PATH,5,-410.8705,6309.836,17.62405,0,0,0,0,100,0), -(@PATH,6,-412.0008,6326.139,17.70071,0,0,0,0,100,0), -(@PATH,7,-427.5412,6351.002,17.63304,0,0,0,0,100,0), -(@PATH,8,-442.1701,6376.702,17.97111,0,0,0,0,100,0), -(@PATH,9,-440.1516,6410.867,17.4473,0,0,0,0,100,0), -(@PATH,10,-436.8709,6453.745,17.55275,0,0,0,0,100,0), -(@PATH,11,-406.3064,6458.811,17.25673,0,0,0,0,100,0), -(@PATH,12,-390.183,6444.14,17.39387,0,0,0,0,100,0), -(@PATH,13,-406.3064,6458.811,17.25673,0,0,0,0,100,0), -(@PATH,14,-436.8709,6453.745,17.55275,0,0,0,0,100,0), -(@PATH,15,-440.1516,6410.867,17.4473,0,0,0,0,100,0), -(@PATH,16,-442.1701,6376.702,17.97111,0,0,0,0,100,0), -(@PATH,17,-427.5412,6351.002,17.63304,0,0,0,0,100,0), -(@PATH,18,-412.0008,6326.139,17.70071,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71527; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-355.7398,`position_y`=6439.344,`position_z`=17.67068 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-355.7398,6439.344,17.67068,0,0,0,0,100,0), -(@PATH,2,-337.6484,6458.52,16.78129,0,0,0,0,100,0), -(@PATH,3,-355.7398,6439.344,17.67068,0,0,0,0,100,0), -(@PATH,4,-375.4502,6416.951,17.63828,0,0,0,0,100,0), -(@PATH,5,-352.3055,6382.163,17.44267,0,0,0,0,100,0), -(@PATH,6,-339.4132,6371.913,18.95378,0,0,0,0,100,0), -(@PATH,7,-320.4037,6349.353,17.49905,0,0,0,0,100,0), -(@PATH,8,-339.4132,6371.913,18.95378,0,0,0,0,100,0), -(@PATH,9,-352.3055,6382.163,17.44267,0,0,0,0,100,0), -(@PATH,10,-375.4502,6416.951,17.63828,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71528; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-320.0476,`position_y`=6163.984,`position_z`=17.62409 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-320.0476,6163.984,17.62409,0,0,0,0,100,0), -(@PATH,2,-331.2123,6150.911,17.87409,0,0,0,0,100,0), -(@PATH,3,-345.0256,6140.545,18.02436,0,0,0,0,100,0), -(@PATH,4,-360.5103,6137.307,17.89936,0,0,0,0,100,0), -(@PATH,5,-381.054,6139.517,18.19844,0,0,0,0,100,0), -(@PATH,6,-360.5103,6137.307,17.89936,0,0,0,0,100,0), -(@PATH,7,-345.0256,6140.545,18.02436,0,0,0,0,100,0), -(@PATH,8,-331.2123,6150.911,17.87409,0,0,0,0,100,0), -(@PATH,9,-320.0476,6163.984,17.62409,0,0,0,0,100,0), -(@PATH,10,-314.4604,6181.93,17.56598,0,0,0,0,100,0), -(@PATH,11,-319.6298,6200.069,17.49909,0,0,0,0,100,0), -(@PATH,12,-316.2941,6219.737,17.49909,0,0,0,0,100,0), -(@PATH,13,-316.1273,6237.474,17.49908,0,0,0,0,100,0), -(@PATH,14,-316.2941,6219.737,17.49909,0,0,0,0,100,0), -(@PATH,15,-319.6298,6200.069,17.49909,0,0,0,0,100,0), -(@PATH,16,-314.4604,6181.93,17.56598,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71529; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-410.5085,`position_y`=6255.543,`position_z`=17.44794 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-410.5085,6255.543,17.44794,0,0,0,0,100,0), -(@PATH,2,-386.918,6282.233,17.49908,0,0,0,0,100,0), -(@PATH,3,-410.5085,6255.543,17.44794,0,0,0,0,100,0), -(@PATH,4,-421.0254,6231.694,17.49909,0,0,0,0,100,0), -(@PATH,5,-453.1329,6217.985,17.48819,0,0,0,0,100,0), -(@PATH,6,-473.6789,6245.981,17.65528,0,0,0,0,100,0), -(@PATH,7,-481.439,6255.942,17.70008,0,0,0,0,100,0), -(@PATH,8,-482.8473,6271.657,17.61994,0,0,0,0,100,0), -(@PATH,9,-471.7555,6293.839,17.87409,0,0,0,0,100,0), -(@PATH,10,-456.8588,6315.148,17.00413,0,0,0,0,100,0), -(@PATH,11,-445.0121,6331.941,17.53489,0,0,0,0,100,0), -(@PATH,12,-456.8588,6315.148,17.00413,0,0,0,0,100,0), -(@PATH,13,-471.7555,6293.839,17.87409,0,0,0,0,100,0), -(@PATH,14,-482.8473,6271.657,17.61994,0,0,0,0,100,0), -(@PATH,15,-481.439,6255.942,17.70008,0,0,0,0,100,0), -(@PATH,16,-473.6789,6245.981,17.65528,0,0,0,0,100,0), -(@PATH,17,-453.1329,6217.985,17.48819,0,0,0,0,100,0), -(@PATH,18,-421.0254,6231.694,17.49909,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71530; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-523.4554,`position_y`=5876.645,`position_z`=17.92353 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-523.4554,5876.645,17.92353,0,0,0,0,100,0), -(@PATH,2,-540.7239,5876.821,17.94059,0,0,0,0,100,0), -(@PATH,3,-546.246,5885.771,17.86613,0,0,0,0,100,0), -(@PATH,4,-558.3109,5907.695,17.4421,0,0,0,0,100,0), -(@PATH,5,-570.5005,5919.63,17.4075,0,0,0,0,100,0), -(@PATH,6,-583.1713,5918.977,17.5325,0,0,0,0,100,0), -(@PATH,7,-596.1543,5918.109,17.6575,0,0,0,0,100,0), -(@PATH,8,-583.1713,5918.977,17.5325,0,0,0,0,100,0), -(@PATH,9,-570.5005,5919.63,17.4075,0,0,0,0,100,0), -(@PATH,10,-558.3109,5907.695,17.4421,0,0,0,0,100,0), -(@PATH,11,-546.246,5885.771,17.86613,0,0,0,0,100,0), -(@PATH,12,-540.7239,5876.821,17.94059,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71531; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-685.4247,`position_y`=5744.201,`position_z`=14.45076 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-685.4247,5744.201,14.45076,0,0,0,0,100,0), -(@PATH,2,-689.3704,5733.29,15.48919,0,0,0,0,100,0), -(@PATH,3,-694.3406,5721.417,15.68475,0,0,0,0,100,0), -(@PATH,4,-693.628,5710.063,17.0241,0,0,0,0,100,0), -(@PATH,5,-685.0911,5693.25,17.02255,0,0,0,0,100,0), -(@PATH,6,-664.6328,5678.895,16.09896,0,0,0,0,100,0), -(@PATH,7,-634.0374,5672.613,14.96591,0,0,0,0,100,0), -(@PATH,8,-620.5831,5687.272,16.39875,0,0,0,0,100,0), -(@PATH,9,-613.4608,5698.938,17.93769,0,0,0,0,100,0), -(@PATH,10,-616.0839,5713.076,16.13629,0,0,0,0,100,0), -(@PATH,11,-618.7032,5726.208,14.38177,0,0,0,0,100,0), -(@PATH,12,-634.3477,5740.746,9.167722,0,0,0,0,100,0), -(@PATH,13,-644.801,5754.851,13.55782,0,0,0,0,100,0), -(@PATH,14,-664.2159,5766.098,11.48791,0,0,0,0,100,0), -(@PATH,15,-676.3831,5758.203,15.53962,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71532; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-636.8377,`position_y`=5918.188,`position_z`=17.91747 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-636.8377,5918.188,17.91747,0,0,0,0,100,0), -(@PATH,2,-650.0894,5912.31,17.40759,0,0,0,0,100,0), -(@PATH,3,-649.3865,5895.695,18.2393,0,0,0,0,100,0), -(@PATH,4,-649.5691,5884.616,15.62773,0,0,0,0,100,0), -(@PATH,5,-649.3865,5895.695,18.2393,0,0,0,0,100,0), -(@PATH,6,-650.0894,5912.31,17.40759,0,0,0,0,100,0), -(@PATH,7,-636.8377,5918.188,17.91747,0,0,0,0,100,0), -(@PATH,8,-619.8817,5917.089,17.98915,0,0,0,0,100,0), -(@PATH,9,-605.9981,5915.45,17.85243,0,0,0,0,100,0), -(@PATH,10,-592.5848,5917.771,17.47745,0,0,0,0,100,0), -(@PATH,11,-605.9981,5915.45,17.85243,0,0,0,0,100,0), -(@PATH,12,-619.8817,5917.089,17.98915,0,0,0,0,100,0); - --- Pathing for Darkcrest Sentry Entry: 20079 -SET @NPC := 71533; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-745.6512,`position_y`=5946.403,`position_z`=17.49909 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,-745.6512,5946.403,17.49909,0,0,0,0,100,0), -(@PATH,2,-733.8559,5949.237,17.62409,0,0,0,0,100,0), -(@PATH,3,-715.53,5953.377,17.4991,0,0,0,0,100,0), -(@PATH,4,-694.0532,5951.034,17.4991,0,0,0,0,100,0), -(@PATH,5,-684.2486,5942.766,17.77119,0,0,0,0,100,0), -(@PATH,6,-674.2134,5928.139,17.84693,0,0,0,0,100,0), -(@PATH,7,-684.2486,5942.766,17.77119,0,0,0,0,100,0), -(@PATH,8,-694.0532,5951.034,17.4991,0,0,0,0,100,0), -(@PATH,9,-715.53,5953.377,17.4991,0,0,0,0,100,0), -(@PATH,10,-733.8559,5949.237,17.62409,0,0,0,0,100,0), -(@PATH,11,-745.6512,5946.403,17.49909,0,0,0,0,100,0), -(@PATH,12,-763.0795,5961.114,18.29157,0,0,0,0,100,0), -(@PATH,13,-790.5579,5959.934,17.61956,0,0,0,0,100,0), -(@PATH,14,-816.7445,5948.383,17.49907,0,0,0,0,100,0), -(@PATH,15,-839.172,5933.668,17.74907,0,0,0,0,100,0), -(@PATH,16,-846.7526,5922.306,17.63042,0,0,0,0,100,0), -(@PATH,17,-839.172,5933.668,17.74907,0,0,0,0,100,0), -(@PATH,18,-816.7445,5948.383,17.49907,0,0,0,0,100,0), -(@PATH,19,-790.5579,5959.934,17.61956,0,0,0,0,100,0), -(@PATH,20,-763.0795,5961.114,18.29157,0,0,0,0,100,0); diff --git a/sql/updates/world/2014_07_30_05_world_waypoints.sql b/sql/updates/world/2014_07_30_05_world_waypoints.sql index bf6b238de11..96a2ac74603 100644 --- a/sql/updates/world/2014_07_30_05_world_waypoints.sql +++ b/sql/updates/world/2014_07_30_05_world_waypoints.sql @@ -1,281 +1,235 @@ --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71581; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71525; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=759.4943,`position_y`=6306.357,`position_z`=17.4089 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-811.9146,`position_y`=5769.104,`position_z`=17.18619 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,759.4943,6306.357,17.4089,0,0,0,0,100,0), -(@PATH,2,743.9999,6305.703,17.4089,0,0,0,0,100,0), -(@PATH,3,759.4943,6306.357,17.4089,0,0,0,0,100,0), -(@PATH,4,777.3499,6314.912,17.43856,0,0,0,0,100,0), -(@PATH,5,794.5563,6329.634,17.56356,0,0,0,0,100,0), -(@PATH,6,808.5778,6354.748,17.60061,0,0,0,0,100,0), -(@PATH,7,810.1545,6398.271,17.51148,0,0,0,0,100,0), -(@PATH,8,809.5649,6422.784,17.63817,0,0,0,0,100,0), -(@PATH,9,808.3696,6436.6,17.43865,0,0,0,0,100,0), -(@PATH,10,792.6043,6452.208,17.50587,0,0,0,0,100,0), -(@PATH,11,795.5001,6464.677,17.50587,0,0,0,0,100,0), -(@PATH,12,802.4607,6493.509,17.52557,0,0,0,0,100,0), -(@PATH,13,791.0586,6509.359,17.21747,0,0,0,0,100,0), -(@PATH,14,779.1663,6519.042,17.46943,0,0,0,0,100,0), -(@PATH,15,778.7495,6533.446,17.41533,0,0,0,0,100,0), -(@PATH,16,779.1663,6519.042,17.46943,0,0,0,0,100,0), -(@PATH,17,791.0586,6509.359,17.21747,0,0,0,0,100,0), -(@PATH,18,802.4607,6493.509,17.52557,0,0,0,0,100,0), -(@PATH,19,795.5001,6464.677,17.50587,0,0,0,0,100,0), -(@PATH,20,792.6043,6452.208,17.50587,0,0,0,0,100,0), -(@PATH,21,808.3696,6436.6,17.43865,0,0,0,0,100,0), -(@PATH,22,809.5649,6422.784,17.63817,0,0,0,0,100,0), -(@PATH,23,810.1545,6398.271,17.51148,0,0,0,0,100,0), -(@PATH,24,808.5778,6354.748,17.60061,0,0,0,0,100,0), -(@PATH,25,794.5563,6329.634,17.56356,0,0,0,0,100,0), -(@PATH,26,777.3499,6314.912,17.43856,0,0,0,0,100,0); +(@PATH,1,-811.9146,5769.104,17.18619,0,0,0,0,100,0), +(@PATH,2,-823.9103,5769.617,18.49771,0,0,0,0,100,0), +(@PATH,3,-837.1352,5761.915,13.98373,0,0,0,0,100,0), +(@PATH,4,-845.346,5746.582,15.9177,0,0,0,0,100,0), +(@PATH,5,-856.5806,5737.951,17.44125,0,0,0,0,100,0), +(@PATH,6,-870.8132,5739.455,18.25524,0,0,0,0,100,0), +(@PATH,7,-876.6976,5766.97,17.9558,0,0,0,0,100,0), +(@PATH,8,-879.2238,5786.183,17.97192,0,0,0,0,100,0), +(@PATH,9,-877.8231,5799.473,18.22192,0,0,0,0,100,0), +(@PATH,10,-875.8525,5816.587,18.1166,0,0,0,0,100,0), +(@PATH,11,-870.438,5833.134,17.8666,0,0,0,0,100,0), +(@PATH,12,-875.8525,5816.587,18.1166,0,0,0,0,100,0), +(@PATH,13,-877.8231,5799.473,18.22192,0,0,0,0,100,0), +(@PATH,14,-879.2238,5786.183,17.97192,0,0,0,0,100,0), +(@PATH,15,-876.6976,5766.97,17.9558,0,0,0,0,100,0), +(@PATH,16,-870.8132,5739.455,18.25524,0,0,0,0,100,0), +(@PATH,17,-856.5806,5737.951,17.44125,0,0,0,0,100,0), +(@PATH,18,-845.346,5746.582,15.9177,0,0,0,0,100,0), +(@PATH,19,-837.1352,5761.915,13.98373,0,0,0,0,100,0), +(@PATH,20,-823.9103,5769.617,18.49771,0,0,0,0,100,0), +(@PATH,21,-811.9146,5769.104,17.18619,0,0,0,0,100,0), +(@PATH,22,-803.7941,5777.138,19.5491,0,0,0,0,100,0), +(@PATH,23,-805.7983,5789.479,19.2897,0,0,0,0,100,0), +(@PATH,24,-813.3177,5798.603,18.38748,0,0,0,0,100,0), +(@PATH,25,-825.4734,5800.777,17.13269,0,0,0,0,100,0), +(@PATH,26,-841.5132,5803.947,14.80724,0,0,0,0,100,0), +(@PATH,27,-853.8585,5824.338,14.71092,0,0,0,0,100,0), +(@PATH,28,-864.2906,5832.222,17.76622,0,0,0,0,100,0), +(@PATH,29,-853.9316,5824.39,14.72874,0,0,0,0,100,0), +(@PATH,30,-841.5132,5803.947,14.80724,0,0,0,0,100,0), +(@PATH,31,-825.4734,5800.777,17.13269,0,0,0,0,100,0), +(@PATH,32,-813.3177,5798.603,18.38748,0,0,0,0,100,0), +(@PATH,33,-805.7983,5789.479,19.2897,0,0,0,0,100,0), +(@PATH,34,-803.7941,5777.138,19.5491,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71582; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71526; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=598.7636,`position_y`=8083.793,`position_z`=17.6241 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-410.8705,`position_y`=6309.836,`position_z`=17.62405 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,598.7636,8083.793,17.6241,0,0,0,0,100,0), -(@PATH,2,599.6365,8065.933,17.75457,0,0,0,0,100,0), -(@PATH,3,596.1388,8050.151,18.00457,0,0,0,0,100,0), -(@PATH,4,596.8356,8025.449,17.44117,0,0,0,0,100,0), -(@PATH,5,621.4521,8017.487,17.50146,0,0,0,0,100,0), -(@PATH,6,644.4905,8017.622,17.50067,0,0,0,0,100,0), -(@PATH,7,662.3524,8008.327,17.5639,0,0,0,0,100,0), -(@PATH,8,693.9063,7983.882,17.44135,0,0,0,0,100,0), -(@PATH,9,714.2939,7989.167,17.52692,0,0,0,0,100,0), -(@PATH,10,693.9063,7983.882,17.44135,0,0,0,0,100,0), -(@PATH,11,662.3524,8008.327,17.5639,0,0,0,0,100,0), -(@PATH,12,644.4905,8017.622,17.50067,0,0,0,0,100,0), -(@PATH,13,621.4521,8017.487,17.50146,0,0,0,0,100,0), -(@PATH,14,596.8356,8025.449,17.44117,0,0,0,0,100,0), -(@PATH,15,596.1388,8050.151,18.00457,0,0,0,0,100,0), -(@PATH,16,599.6365,8065.933,17.75457,0,0,0,0,100,0), -(@PATH,17,598.7636,8083.793,17.6241,0,0,0,0,100,0), -(@PATH,18,588.2853,8104.152,17.4111,0,0,0,0,100,0), -(@PATH,19,568.5647,8114.293,17.2861,0,0,0,0,100,0), -(@PATH,20,596.414,8115.547,17.4111,0,0,0,0,100,0), -(@PATH,21,600.2018,8135.068,17.58697,0,0,0,0,100,0), -(@PATH,22,597.5128,8154.914,18.0076,0,0,0,0,100,0), -(@PATH,23,596.1393,8167.66,15.3831,0,0,0,0,100,0), -(@PATH,24,597.5128,8154.914,18.0076,0,0,0,0,100,0), -(@PATH,25,600.2018,8135.068,17.58697,0,0,0,0,100,0), -(@PATH,26,596.414,8115.547,17.4111,0,0,0,0,100,0), -(@PATH,27,568.5647,8114.293,17.2861,0,0,0,0,100,0), -(@PATH,28,588.2853,8104.152,17.4111,0,0,0,0,100,0); +(@PATH,1,-410.8705,6309.836,17.62405,0,0,0,0,100,0), +(@PATH,2,-397.7162,6294.659,17.62408,0,0,0,0,100,0), +(@PATH,3,-386.2312,6282.547,17.49908,0,0,0,0,100,0), +(@PATH,4,-397.7162,6294.659,17.62408,0,0,0,0,100,0), +(@PATH,5,-410.8705,6309.836,17.62405,0,0,0,0,100,0), +(@PATH,6,-412.0008,6326.139,17.70071,0,0,0,0,100,0), +(@PATH,7,-427.5412,6351.002,17.63304,0,0,0,0,100,0), +(@PATH,8,-442.1701,6376.702,17.97111,0,0,0,0,100,0), +(@PATH,9,-440.1516,6410.867,17.4473,0,0,0,0,100,0), +(@PATH,10,-436.8709,6453.745,17.55275,0,0,0,0,100,0), +(@PATH,11,-406.3064,6458.811,17.25673,0,0,0,0,100,0), +(@PATH,12,-390.183,6444.14,17.39387,0,0,0,0,100,0), +(@PATH,13,-406.3064,6458.811,17.25673,0,0,0,0,100,0), +(@PATH,14,-436.8709,6453.745,17.55275,0,0,0,0,100,0), +(@PATH,15,-440.1516,6410.867,17.4473,0,0,0,0,100,0), +(@PATH,16,-442.1701,6376.702,17.97111,0,0,0,0,100,0), +(@PATH,17,-427.5412,6351.002,17.63304,0,0,0,0,100,0), +(@PATH,18,-412.0008,6326.139,17.70071,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71583; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71527; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=583.2789,`position_y`=6151.631,`position_z`=17.56806 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-355.7398,`position_y`=6439.344,`position_z`=17.67068 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,583.2789,6151.631,17.56806,0,0,0,0,100,0), -(@PATH,2,588.7063,6121.675,17.49909,0,0,0,0,100,0), -(@PATH,3,604.5994,6116.76,17.4991,0,0,0,0,100,0), -(@PATH,4,627.8912,6116.608,17.4991,0,0,0,0,100,0), -(@PATH,5,642.8787,6127.678,17.49909,0,0,0,0,100,0), -(@PATH,6,664.4583,6155.981,17.4254,0,0,0,0,100,0), -(@PATH,7,647.6324,6179.767,17.45327,0,0,0,0,100,0), -(@PATH,8,640.0746,6202.314,17.48018,0,0,0,0,100,0), -(@PATH,9,621.8489,6238.127,17.64701,0,0,0,0,100,0), -(@PATH,10,600.6134,6251.576,17.77201,0,0,0,0,100,0), -(@PATH,11,621.8489,6238.127,17.64701,0,0,0,0,100,0), -(@PATH,12,640.0746,6202.314,17.48018,0,0,0,0,100,0), -(@PATH,13,647.6324,6179.767,17.45327,0,0,0,0,100,0), -(@PATH,14,664.4583,6155.981,17.4254,0,0,0,0,100,0), -(@PATH,15,642.8787,6127.678,17.49909,0,0,0,0,100,0), -(@PATH,16,627.8912,6116.608,17.4991,0,0,0,0,100,0), -(@PATH,17,604.5994,6116.76,17.4991,0,0,0,0,100,0), -(@PATH,18,588.7063,6121.675,17.49909,0,0,0,0,100,0); +(@PATH,1,-355.7398,6439.344,17.67068,0,0,0,0,100,0), +(@PATH,2,-337.6484,6458.52,16.78129,0,0,0,0,100,0), +(@PATH,3,-355.7398,6439.344,17.67068,0,0,0,0,100,0), +(@PATH,4,-375.4502,6416.951,17.63828,0,0,0,0,100,0), +(@PATH,5,-352.3055,6382.163,17.44267,0,0,0,0,100,0), +(@PATH,6,-339.4132,6371.913,18.95378,0,0,0,0,100,0), +(@PATH,7,-320.4037,6349.353,17.49905,0,0,0,0,100,0), +(@PATH,8,-339.4132,6371.913,18.95378,0,0,0,0,100,0), +(@PATH,9,-352.3055,6382.163,17.44267,0,0,0,0,100,0), +(@PATH,10,-375.4502,6416.951,17.63828,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71584; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71528; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=484.8557,`position_y`=6147.238,`position_z`=17.39692 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-320.0476,`position_y`=6163.984,`position_z`=17.62409 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,484.8557,6147.238,17.39692,0,0,0,0,100,0), -(@PATH,2,497.8846,6127.964,17.62593,0,0,0,0,100,0), -(@PATH,3,508.6398,6118.515,17.57525,0,0,0,0,100,0), -(@PATH,4,529.306,6106.489,17.57525,0,0,0,0,100,0), -(@PATH,5,543.109,6101.563,17.53619,0,0,0,0,100,0), -(@PATH,6,562.1443,6106.827,17.66119,0,0,0,0,100,0), -(@PATH,7,543.109,6101.563,17.53619,0,0,0,0,100,0), -(@PATH,8,529.306,6106.489,17.57525,0,0,0,0,100,0), -(@PATH,9,508.6398,6118.515,17.57525,0,0,0,0,100,0), -(@PATH,10,497.8846,6127.964,17.62593,0,0,0,0,100,0), -(@PATH,11,484.8557,6147.238,17.39692,0,0,0,0,100,0), -(@PATH,12,479.6094,6168.237,17.3991,0,0,0,0,100,0), -(@PATH,13,497.7457,6180.41,17.3991,0,0,0,0,100,0), -(@PATH,14,520.0167,6193.519,17.50527,0,0,0,0,100,0), -(@PATH,15,497.7457,6180.41,17.3991,0,0,0,0,100,0), -(@PATH,16,479.6094,6168.237,17.3991,0,0,0,0,100,0); +(@PATH,1,-320.0476,6163.984,17.62409,0,0,0,0,100,0), +(@PATH,2,-331.2123,6150.911,17.87409,0,0,0,0,100,0), +(@PATH,3,-345.0256,6140.545,18.02436,0,0,0,0,100,0), +(@PATH,4,-360.5103,6137.307,17.89936,0,0,0,0,100,0), +(@PATH,5,-381.054,6139.517,18.19844,0,0,0,0,100,0), +(@PATH,6,-360.5103,6137.307,17.89936,0,0,0,0,100,0), +(@PATH,7,-345.0256,6140.545,18.02436,0,0,0,0,100,0), +(@PATH,8,-331.2123,6150.911,17.87409,0,0,0,0,100,0), +(@PATH,9,-320.0476,6163.984,17.62409,0,0,0,0,100,0), +(@PATH,10,-314.4604,6181.93,17.56598,0,0,0,0,100,0), +(@PATH,11,-319.6298,6200.069,17.49909,0,0,0,0,100,0), +(@PATH,12,-316.2941,6219.737,17.49909,0,0,0,0,100,0), +(@PATH,13,-316.1273,6237.474,17.49908,0,0,0,0,100,0), +(@PATH,14,-316.2941,6219.737,17.49909,0,0,0,0,100,0), +(@PATH,15,-319.6298,6200.069,17.49909,0,0,0,0,100,0), +(@PATH,16,-314.4604,6181.93,17.56598,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71585; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71529; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=714.0928,`position_y`=6330.395,`position_z`=17.28641 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-410.5085,`position_y`=6255.543,`position_z`=17.44794 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,714.0928,6330.395,17.28641,0,0,0,0,100,0), -(@PATH,2,711.8986,6368.565,17.3039,0,0,0,0,100,0), -(@PATH,3,714.0928,6330.395,17.28641,0,0,0,0,100,0), -(@PATH,4,707.5536,6305.207,17.44607,0,0,0,0,100,0), -(@PATH,5,688.4388,6290.488,17.43558,0,0,0,0,100,0), -(@PATH,6,686.5964,6275.249,17.68558,0,0,0,0,100,0), -(@PATH,7,675.7322,6259.213,17.66298,0,0,0,0,100,0), -(@PATH,8,660.7868,6235.378,17.60566,0,0,0,0,100,0), -(@PATH,9,637.1617,6227.35,17.69966,0,0,0,0,100,0), -(@PATH,10,615.4294,6239.798,17.64701,0,0,0,0,100,0), -(@PATH,11,601.6331,6250.868,17.77201,0,0,0,0,100,0), -(@PATH,12,615.4294,6239.798,17.64701,0,0,0,0,100,0), -(@PATH,13,637.1617,6227.35,17.69966,0,0,0,0,100,0), -(@PATH,14,660.7868,6235.378,17.60566,0,0,0,0,100,0), -(@PATH,15,675.7322,6259.213,17.66298,0,0,0,0,100,0), -(@PATH,16,686.5964,6275.249,17.68558,0,0,0,0,100,0), -(@PATH,17,688.4388,6290.488,17.43558,0,0,0,0,100,0), -(@PATH,18,707.5536,6305.207,17.44607,0,0,0,0,100,0); +(@PATH,1,-410.5085,6255.543,17.44794,0,0,0,0,100,0), +(@PATH,2,-386.918,6282.233,17.49908,0,0,0,0,100,0), +(@PATH,3,-410.5085,6255.543,17.44794,0,0,0,0,100,0), +(@PATH,4,-421.0254,6231.694,17.49909,0,0,0,0,100,0), +(@PATH,5,-453.1329,6217.985,17.48819,0,0,0,0,100,0), +(@PATH,6,-473.6789,6245.981,17.65528,0,0,0,0,100,0), +(@PATH,7,-481.439,6255.942,17.70008,0,0,0,0,100,0), +(@PATH,8,-482.8473,6271.657,17.61994,0,0,0,0,100,0), +(@PATH,9,-471.7555,6293.839,17.87409,0,0,0,0,100,0), +(@PATH,10,-456.8588,6315.148,17.00413,0,0,0,0,100,0), +(@PATH,11,-445.0121,6331.941,17.53489,0,0,0,0,100,0), +(@PATH,12,-456.8588,6315.148,17.00413,0,0,0,0,100,0), +(@PATH,13,-471.7555,6293.839,17.87409,0,0,0,0,100,0), +(@PATH,14,-482.8473,6271.657,17.61994,0,0,0,0,100,0), +(@PATH,15,-481.439,6255.942,17.70008,0,0,0,0,100,0), +(@PATH,16,-473.6789,6245.981,17.65528,0,0,0,0,100,0), +(@PATH,17,-453.1329,6217.985,17.48819,0,0,0,0,100,0), +(@PATH,18,-421.0254,6231.694,17.49909,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71586; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71530; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=456.8788,`position_y`=6370.086,`position_z`=17.94312 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-523.4554,`position_y`=5876.645,`position_z`=17.92353 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,456.8788,6370.086,17.94312,0,0,0,0,100,0), -(@PATH,2,452.2714,6389.746,17.81812,0,0,0,0,100,0), -(@PATH,3,467.8412,6407.655,17.79832,0,0,0,0,100,0), -(@PATH,4,491.2019,6411.824,15.48412,0,0,0,0,100,0), -(@PATH,5,467.8412,6407.655,17.79832,0,0,0,0,100,0), -(@PATH,6,452.2714,6389.746,17.81812,0,0,0,0,100,0), -(@PATH,7,456.8788,6370.086,17.94312,0,0,0,0,100,0), -(@PATH,8,454.0548,6347.622,17.85618,0,0,0,0,100,0), -(@PATH,9,446.207,6326.609,17.93723,0,0,0,0,100,0), -(@PATH,10,441.623,6303.469,17.93723,0,0,0,0,100,0), -(@PATH,11,446.207,6326.609,17.93723,0,0,0,0,100,0), -(@PATH,12,454.0548,6347.622,17.85618,0,0,0,0,100,0); +(@PATH,1,-523.4554,5876.645,17.92353,0,0,0,0,100,0), +(@PATH,2,-540.7239,5876.821,17.94059,0,0,0,0,100,0), +(@PATH,3,-546.246,5885.771,17.86613,0,0,0,0,100,0), +(@PATH,4,-558.3109,5907.695,17.4421,0,0,0,0,100,0), +(@PATH,5,-570.5005,5919.63,17.4075,0,0,0,0,100,0), +(@PATH,6,-583.1713,5918.977,17.5325,0,0,0,0,100,0), +(@PATH,7,-596.1543,5918.109,17.6575,0,0,0,0,100,0), +(@PATH,8,-583.1713,5918.977,17.5325,0,0,0,0,100,0), +(@PATH,9,-570.5005,5919.63,17.4075,0,0,0,0,100,0), +(@PATH,10,-558.3109,5907.695,17.4421,0,0,0,0,100,0), +(@PATH,11,-546.246,5885.771,17.86613,0,0,0,0,100,0), +(@PATH,12,-540.7239,5876.821,17.94059,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71587; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71531; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=473.7206,`position_y`=8024.335,`position_z`=17.56001 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-685.4247,`position_y`=5744.201,`position_z`=14.45076 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,473.7206,8024.335,17.56001,0,0,0,0,100,0), -(@PATH,2,496.147,8008.202,17.40107,0,0,0,0,100,0), -(@PATH,3,517.5805,8011.069,17.49237,0,0,0,0,100,0), -(@PATH,4,538.4409,8009.085,17.53157,0,0,0,0,100,0), -(@PATH,5,560.729,8010.077,17.4316,0,0,0,0,100,0), -(@PATH,6,589.2994,8011.602,17.44117,0,0,0,0,100,0), -(@PATH,7,560.729,8010.077,17.4316,0,0,0,0,100,0), -(@PATH,8,538.4409,8009.085,17.53157,0,0,0,0,100,0), -(@PATH,9,517.5805,8011.069,17.49237,0,0,0,0,100,0), -(@PATH,10,496.147,8008.202,17.40107,0,0,0,0,100,0), -(@PATH,11,473.7206,8024.335,17.56001,0,0,0,0,100,0), -(@PATH,12,458.5915,8058.235,17.49908,0,0,0,0,100,0), -(@PATH,13,454.0531,8072.585,17.49909,0,0,0,0,100,0), -(@PATH,14,440.1596,8088.723,17.49909,0,0,0,0,100,0), -(@PATH,15,433.4708,8105.307,17.77139,0,0,0,0,100,0), -(@PATH,16,440.1596,8088.723,17.49909,0,0,0,0,100,0), -(@PATH,17,454.0531,8072.585,17.49909,0,0,0,0,100,0), -(@PATH,18,458.5915,8058.235,17.49908,0,0,0,0,100,0); +(@PATH,1,-685.4247,5744.201,14.45076,0,0,0,0,100,0), +(@PATH,2,-689.3704,5733.29,15.48919,0,0,0,0,100,0), +(@PATH,3,-694.3406,5721.417,15.68475,0,0,0,0,100,0), +(@PATH,4,-693.628,5710.063,17.0241,0,0,0,0,100,0), +(@PATH,5,-685.0911,5693.25,17.02255,0,0,0,0,100,0), +(@PATH,6,-664.6328,5678.895,16.09896,0,0,0,0,100,0), +(@PATH,7,-634.0374,5672.613,14.96591,0,0,0,0,100,0), +(@PATH,8,-620.5831,5687.272,16.39875,0,0,0,0,100,0), +(@PATH,9,-613.4608,5698.938,17.93769,0,0,0,0,100,0), +(@PATH,10,-616.0839,5713.076,16.13629,0,0,0,0,100,0), +(@PATH,11,-618.7032,5726.208,14.38177,0,0,0,0,100,0), +(@PATH,12,-634.3477,5740.746,9.167722,0,0,0,0,100,0), +(@PATH,13,-644.801,5754.851,13.55782,0,0,0,0,100,0), +(@PATH,14,-664.2159,5766.098,11.48791,0,0,0,0,100,0), +(@PATH,15,-676.3831,5758.203,15.53962,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71588; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71532; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=763.2474,`position_y`=8077.369,`position_z`=17.49908 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-636.8377,`position_y`=5918.188,`position_z`=17.91747 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,763.2474,8077.369,17.49908,0,0,0,0,100,0), -(@PATH,2,764.3576,8096.227,17.49908,0,0,0,0,100,0), -(@PATH,3,763.1123,8113.93,17.49908,0,0,0,0,100,0), -(@PATH,4,754.1951,8129.958,17.565,0,0,0,0,100,0), -(@PATH,5,746.9005,8144.393,16.9609,0,0,0,0,100,0), -(@PATH,6,754.1951,8129.958,17.565,0,0,0,0,100,0), -(@PATH,7,763.1123,8113.93,17.49908,0,0,0,0,100,0), -(@PATH,8,764.3576,8096.227,17.49908,0,0,0,0,100,0), -(@PATH,9,763.2474,8077.369,17.49908,0,0,0,0,100,0), -(@PATH,10,753.71,8050.239,17.49907,0,0,0,0,100,0), -(@PATH,11,736.1158,8032.819,17.50464,0,0,0,0,100,0), -(@PATH,12,727.4476,8005.954,17.80172,0,0,0,0,100,0), -(@PATH,13,736.1158,8032.819,17.50464,0,0,0,0,100,0), -(@PATH,14,753.71,8050.239,17.49907,0,0,0,0,100,0); +(@PATH,1,-636.8377,5918.188,17.91747,0,0,0,0,100,0), +(@PATH,2,-650.0894,5912.31,17.40759,0,0,0,0,100,0), +(@PATH,3,-649.3865,5895.695,18.2393,0,0,0,0,100,0), +(@PATH,4,-649.5691,5884.616,15.62773,0,0,0,0,100,0), +(@PATH,5,-649.3865,5895.695,18.2393,0,0,0,0,100,0), +(@PATH,6,-650.0894,5912.31,17.40759,0,0,0,0,100,0), +(@PATH,7,-636.8377,5918.188,17.91747,0,0,0,0,100,0), +(@PATH,8,-619.8817,5917.089,17.98915,0,0,0,0,100,0), +(@PATH,9,-605.9981,5915.45,17.85243,0,0,0,0,100,0), +(@PATH,10,-592.5848,5917.771,17.47745,0,0,0,0,100,0), +(@PATH,11,-605.9981,5915.45,17.85243,0,0,0,0,100,0), +(@PATH,12,-619.8817,5917.089,17.98915,0,0,0,0,100,0); --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71589; +-- Pathing for Darkcrest Sentry Entry: 20079 +SET @NPC := 71533; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=590.5538,`position_y`=6385.54,`position_z`=19.41796 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-745.6512,`position_y`=5946.403,`position_z`=17.49909 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,590.5538,6385.54,19.41796,0,0,0,0,100,0), -(@PATH,2,576.1758,6381.048,19.19262,0,0,0,0,100,0), -(@PATH,3,549.4913,6380.258,16.99608,0,0,0,0,100,0), -(@PATH,4,536.714,6381.334,19.3341,0,0,0,0,100,0), -(@PATH,5,512.5249,6386.269,20.09841,0,0,0,0,100,0), -(@PATH,6,536.714,6381.334,19.3341,0,0,0,0,100,0), -(@PATH,7,549.4913,6380.258,16.99608,0,0,0,0,100,0), -(@PATH,8,576.1758,6381.048,19.19262,0,0,0,0,100,0), -(@PATH,9,590.502,6385.516,19.35204,0,0,0,0,100,0), -(@PATH,10,603.5302,6383.618,19.05107,0,0,0,0,100,0), -(@PATH,11,618.3229,6384.962,19.48649,0,0,0,0,100,0), -(@PATH,12,629.5106,6391.457,18.35343,0,0,0,0,100,0), -(@PATH,13,618.3229,6384.962,19.48649,0,0,0,0,100,0), -(@PATH,14,603.5302,6383.618,19.05107,0,0,0,0,100,0); - --- Pathing for Bloodscale Sentry Entry: 20090 -SET @NPC := 71590; -SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=384.1659,`position_y`=8112.826,`position_z`=17.53038 WHERE `guid`=@NPC; -DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,384.1659,8112.826,17.53038,0,0,0,0,100,0), -(@PATH,2,403.2718,8119.023,17.60357,0,0,0,0,100,0), -(@PATH,3,421.5509,8121.888,17.61883,0,0,0,0,100,0), -(@PATH,4,422.268,8135.977,17.62646,0,0,0,0,100,0), -(@PATH,5,421.0201,8147.833,17.5863,0,0,0,0,100,0), -(@PATH,6,410.0742,8161.833,17.12646,0,0,0,0,100,0), -(@PATH,7,405.593,8175.743,17.44895,0,0,0,0,100,0), -(@PATH,8,404.0476,8192.669,17.69895,0,0,0,0,100,0), -(@PATH,9,405.593,8175.743,17.44895,0,0,0,0,100,0), -(@PATH,10,410.0742,8161.833,17.12646,0,0,0,0,100,0), -(@PATH,11,421.0201,8147.833,17.5863,0,0,0,0,100,0), -(@PATH,12,422.268,8135.977,17.62646,0,0,0,0,100,0), -(@PATH,13,421.5509,8121.888,17.61883,0,0,0,0,100,0), -(@PATH,14,403.2718,8119.023,17.60357,0,0,0,0,100,0), -(@PATH,15,384.1659,8112.826,17.53038,0,0,0,0,100,0), -(@PATH,16,366.2072,8100.374,17.74176,0,0,0,0,100,0), -(@PATH,17,338.3154,8112.941,17.49909,0,0,0,0,100,0), -(@PATH,18,330.1254,8143.837,17.49909,0,0,0,0,100,0), -(@PATH,19,324.209,8171.819,17.64763,0,0,0,0,100,0), -(@PATH,20,312.2263,8170.651,17.40044,0,0,0,0,100,0), -(@PATH,21,292.32,8159.853,17.61897,0,0,0,0,100,0), -(@PATH,22,277.5932,8158.432,17.57466,0,0,0,0,100,0), -(@PATH,23,292.32,8159.853,17.61897,0,0,0,0,100,0), -(@PATH,24,312.2263,8170.651,17.40044,0,0,0,0,100,0), -(@PATH,25,324.209,8171.819,17.64763,0,0,0,0,100,0), -(@PATH,26,330.1254,8143.837,17.49909,0,0,0,0,100,0), -(@PATH,27,338.3154,8112.941,17.49909,0,0,0,0,100,0), -(@PATH,28,366.2072,8100.374,17.74176,0,0,0,0,100,0); +(@PATH,1,-745.6512,5946.403,17.49909,0,0,0,0,100,0), +(@PATH,2,-733.8559,5949.237,17.62409,0,0,0,0,100,0), +(@PATH,3,-715.53,5953.377,17.4991,0,0,0,0,100,0), +(@PATH,4,-694.0532,5951.034,17.4991,0,0,0,0,100,0), +(@PATH,5,-684.2486,5942.766,17.77119,0,0,0,0,100,0), +(@PATH,6,-674.2134,5928.139,17.84693,0,0,0,0,100,0), +(@PATH,7,-684.2486,5942.766,17.77119,0,0,0,0,100,0), +(@PATH,8,-694.0532,5951.034,17.4991,0,0,0,0,100,0), +(@PATH,9,-715.53,5953.377,17.4991,0,0,0,0,100,0), +(@PATH,10,-733.8559,5949.237,17.62409,0,0,0,0,100,0), +(@PATH,11,-745.6512,5946.403,17.49909,0,0,0,0,100,0), +(@PATH,12,-763.0795,5961.114,18.29157,0,0,0,0,100,0), +(@PATH,13,-790.5579,5959.934,17.61956,0,0,0,0,100,0), +(@PATH,14,-816.7445,5948.383,17.49907,0,0,0,0,100,0), +(@PATH,15,-839.172,5933.668,17.74907,0,0,0,0,100,0), +(@PATH,16,-846.7526,5922.306,17.63042,0,0,0,0,100,0), +(@PATH,17,-839.172,5933.668,17.74907,0,0,0,0,100,0), +(@PATH,18,-816.7445,5948.383,17.49907,0,0,0,0,100,0), +(@PATH,19,-790.5579,5959.934,17.61956,0,0,0,0,100,0), +(@PATH,20,-763.0795,5961.114,18.29157,0,0,0,0,100,0); diff --git a/sql/updates/world/2014_07_30_06_world_waypoints.sql b/sql/updates/world/2014_07_30_06_world_waypoints.sql index c0a8a2ee413..bf6b238de11 100644 --- a/sql/updates/world/2014_07_30_06_world_waypoints.sql +++ b/sql/updates/world/2014_07_30_06_world_waypoints.sql @@ -1,68 +1,281 @@ --- Pathing for Swamprat Guard Entry: 18910 -SET @NPC := 67906; +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71581; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=75.29373,`position_y`=5261.419,`position_z`=23.08392 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=759.4943,`position_y`=6306.357,`position_z`=17.4089 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,75.29373,5261.419,23.08392,0,0,0,0,100,0), -(@PATH,2,75.29796,5274.807,23.04233,0,0,0,0,100,0), -(@PATH,3,82.62872,5302.216,22.98195,0,0,0,0,100,0), -(@PATH,4,83.02105,5314.273,22.13724,0,0,0,0,100,0), -(@PATH,5,82.34508,5302.751,22.97913,0,0,0,0,100,0), -(@PATH,6,75.29796,5274.807,23.04233,0,0,0,0,100,0), -(@PATH,7,75.29373,5261.419,23.08392,0,0,0,0,100,0), -(@PATH,8,75.86388,5247.502,23.12924,0,0,0,0,100,0), -(@PATH,9,79.21181,5240.832,23.16174,0,0,0,0,100,0), -(@PATH,10,87.85194,5229.543,22.38807,0,0,0,0,100,0), -(@PATH,11,79.21181,5240.832,23.16174,0,0,0,0,100,0), -(@PATH,12,75.86388,5247.502,23.12924,0,0,0,0,100,0); +(@PATH,1,759.4943,6306.357,17.4089,0,0,0,0,100,0), +(@PATH,2,743.9999,6305.703,17.4089,0,0,0,0,100,0), +(@PATH,3,759.4943,6306.357,17.4089,0,0,0,0,100,0), +(@PATH,4,777.3499,6314.912,17.43856,0,0,0,0,100,0), +(@PATH,5,794.5563,6329.634,17.56356,0,0,0,0,100,0), +(@PATH,6,808.5778,6354.748,17.60061,0,0,0,0,100,0), +(@PATH,7,810.1545,6398.271,17.51148,0,0,0,0,100,0), +(@PATH,8,809.5649,6422.784,17.63817,0,0,0,0,100,0), +(@PATH,9,808.3696,6436.6,17.43865,0,0,0,0,100,0), +(@PATH,10,792.6043,6452.208,17.50587,0,0,0,0,100,0), +(@PATH,11,795.5001,6464.677,17.50587,0,0,0,0,100,0), +(@PATH,12,802.4607,6493.509,17.52557,0,0,0,0,100,0), +(@PATH,13,791.0586,6509.359,17.21747,0,0,0,0,100,0), +(@PATH,14,779.1663,6519.042,17.46943,0,0,0,0,100,0), +(@PATH,15,778.7495,6533.446,17.41533,0,0,0,0,100,0), +(@PATH,16,779.1663,6519.042,17.46943,0,0,0,0,100,0), +(@PATH,17,791.0586,6509.359,17.21747,0,0,0,0,100,0), +(@PATH,18,802.4607,6493.509,17.52557,0,0,0,0,100,0), +(@PATH,19,795.5001,6464.677,17.50587,0,0,0,0,100,0), +(@PATH,20,792.6043,6452.208,17.50587,0,0,0,0,100,0), +(@PATH,21,808.3696,6436.6,17.43865,0,0,0,0,100,0), +(@PATH,22,809.5649,6422.784,17.63817,0,0,0,0,100,0), +(@PATH,23,810.1545,6398.271,17.51148,0,0,0,0,100,0), +(@PATH,24,808.5778,6354.748,17.60061,0,0,0,0,100,0), +(@PATH,25,794.5563,6329.634,17.56356,0,0,0,0,100,0), +(@PATH,26,777.3499,6314.912,17.43856,0,0,0,0,100,0); --- Pathing for Swamprat Guard Entry: 18910 -SET @NPC := 67907; +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71582; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=75.29373,`position_y`=5261.419,`position_z`=23.08392 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=598.7636,`position_y`=8083.793,`position_z`=17.6241 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,75.29373,5261.419,23.08392,0,0,0,0,100,0), -(@PATH,2,75.29796,5274.807,23.04233,0,0,0,0,100,0), -(@PATH,3,82.62872,5302.216,22.98195,0,0,0,0,100,0), -(@PATH,4,83.02105,5314.273,22.13724,0,0,0,0,100,0), -(@PATH,5,82.34508,5302.751,22.97913,0,0,0,0,100,0), -(@PATH,6,75.29796,5274.807,23.04233,0,0,0,0,100,0), -(@PATH,7,75.29373,5261.419,23.08392,0,0,0,0,100,0), -(@PATH,8,75.86388,5247.502,23.12924,0,0,0,0,100,0), -(@PATH,9,79.21181,5240.832,23.16174,0,0,0,0,100,0), -(@PATH,10,87.85194,5229.543,22.38807,0,0,0,0,100,0), -(@PATH,11,79.21181,5240.832,23.16174,0,0,0,0,100,0), -(@PATH,12,75.86388,5247.502,23.12924,0,0,0,0,100,0); +(@PATH,1,598.7636,8083.793,17.6241,0,0,0,0,100,0), +(@PATH,2,599.6365,8065.933,17.75457,0,0,0,0,100,0), +(@PATH,3,596.1388,8050.151,18.00457,0,0,0,0,100,0), +(@PATH,4,596.8356,8025.449,17.44117,0,0,0,0,100,0), +(@PATH,5,621.4521,8017.487,17.50146,0,0,0,0,100,0), +(@PATH,6,644.4905,8017.622,17.50067,0,0,0,0,100,0), +(@PATH,7,662.3524,8008.327,17.5639,0,0,0,0,100,0), +(@PATH,8,693.9063,7983.882,17.44135,0,0,0,0,100,0), +(@PATH,9,714.2939,7989.167,17.52692,0,0,0,0,100,0), +(@PATH,10,693.9063,7983.882,17.44135,0,0,0,0,100,0), +(@PATH,11,662.3524,8008.327,17.5639,0,0,0,0,100,0), +(@PATH,12,644.4905,8017.622,17.50067,0,0,0,0,100,0), +(@PATH,13,621.4521,8017.487,17.50146,0,0,0,0,100,0), +(@PATH,14,596.8356,8025.449,17.44117,0,0,0,0,100,0), +(@PATH,15,596.1388,8050.151,18.00457,0,0,0,0,100,0), +(@PATH,16,599.6365,8065.933,17.75457,0,0,0,0,100,0), +(@PATH,17,598.7636,8083.793,17.6241,0,0,0,0,100,0), +(@PATH,18,588.2853,8104.152,17.4111,0,0,0,0,100,0), +(@PATH,19,568.5647,8114.293,17.2861,0,0,0,0,100,0), +(@PATH,20,596.414,8115.547,17.4111,0,0,0,0,100,0), +(@PATH,21,600.2018,8135.068,17.58697,0,0,0,0,100,0), +(@PATH,22,597.5128,8154.914,18.0076,0,0,0,0,100,0), +(@PATH,23,596.1393,8167.66,15.3831,0,0,0,0,100,0), +(@PATH,24,597.5128,8154.914,18.0076,0,0,0,0,100,0), +(@PATH,25,600.2018,8135.068,17.58697,0,0,0,0,100,0), +(@PATH,26,596.414,8115.547,17.4111,0,0,0,0,100,0), +(@PATH,27,568.5647,8114.293,17.2861,0,0,0,0,100,0), +(@PATH,28,588.2853,8104.152,17.4111,0,0,0,0,100,0); --- Add Swamprat Guard formation -DELETE FROM `creature_formations` WHERE `leaderGUID`=67907; -INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES -(67907,67907,0,0,2),(67907,67906,3,0,2); +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71583; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=583.2789,`position_y`=6151.631,`position_z`=17.56806 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,583.2789,6151.631,17.56806,0,0,0,0,100,0), +(@PATH,2,588.7063,6121.675,17.49909,0,0,0,0,100,0), +(@PATH,3,604.5994,6116.76,17.4991,0,0,0,0,100,0), +(@PATH,4,627.8912,6116.608,17.4991,0,0,0,0,100,0), +(@PATH,5,642.8787,6127.678,17.49909,0,0,0,0,100,0), +(@PATH,6,664.4583,6155.981,17.4254,0,0,0,0,100,0), +(@PATH,7,647.6324,6179.767,17.45327,0,0,0,0,100,0), +(@PATH,8,640.0746,6202.314,17.48018,0,0,0,0,100,0), +(@PATH,9,621.8489,6238.127,17.64701,0,0,0,0,100,0), +(@PATH,10,600.6134,6251.576,17.77201,0,0,0,0,100,0), +(@PATH,11,621.8489,6238.127,17.64701,0,0,0,0,100,0), +(@PATH,12,640.0746,6202.314,17.48018,0,0,0,0,100,0), +(@PATH,13,647.6324,6179.767,17.45327,0,0,0,0,100,0), +(@PATH,14,664.4583,6155.981,17.4254,0,0,0,0,100,0), +(@PATH,15,642.8787,6127.678,17.49909,0,0,0,0,100,0), +(@PATH,16,627.8912,6116.608,17.4991,0,0,0,0,100,0), +(@PATH,17,604.5994,6116.76,17.4991,0,0,0,0,100,0), +(@PATH,18,588.7063,6121.675,17.49909,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71584; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=484.8557,`position_y`=6147.238,`position_z`=17.39692 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,484.8557,6147.238,17.39692,0,0,0,0,100,0), +(@PATH,2,497.8846,6127.964,17.62593,0,0,0,0,100,0), +(@PATH,3,508.6398,6118.515,17.57525,0,0,0,0,100,0), +(@PATH,4,529.306,6106.489,17.57525,0,0,0,0,100,0), +(@PATH,5,543.109,6101.563,17.53619,0,0,0,0,100,0), +(@PATH,6,562.1443,6106.827,17.66119,0,0,0,0,100,0), +(@PATH,7,543.109,6101.563,17.53619,0,0,0,0,100,0), +(@PATH,8,529.306,6106.489,17.57525,0,0,0,0,100,0), +(@PATH,9,508.6398,6118.515,17.57525,0,0,0,0,100,0), +(@PATH,10,497.8846,6127.964,17.62593,0,0,0,0,100,0), +(@PATH,11,484.8557,6147.238,17.39692,0,0,0,0,100,0), +(@PATH,12,479.6094,6168.237,17.3991,0,0,0,0,100,0), +(@PATH,13,497.7457,6180.41,17.3991,0,0,0,0,100,0), +(@PATH,14,520.0167,6193.519,17.50527,0,0,0,0,100,0), +(@PATH,15,497.7457,6180.41,17.3991,0,0,0,0,100,0), +(@PATH,16,479.6094,6168.237,17.3991,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71585; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=714.0928,`position_y`=6330.395,`position_z`=17.28641 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,714.0928,6330.395,17.28641,0,0,0,0,100,0), +(@PATH,2,711.8986,6368.565,17.3039,0,0,0,0,100,0), +(@PATH,3,714.0928,6330.395,17.28641,0,0,0,0,100,0), +(@PATH,4,707.5536,6305.207,17.44607,0,0,0,0,100,0), +(@PATH,5,688.4388,6290.488,17.43558,0,0,0,0,100,0), +(@PATH,6,686.5964,6275.249,17.68558,0,0,0,0,100,0), +(@PATH,7,675.7322,6259.213,17.66298,0,0,0,0,100,0), +(@PATH,8,660.7868,6235.378,17.60566,0,0,0,0,100,0), +(@PATH,9,637.1617,6227.35,17.69966,0,0,0,0,100,0), +(@PATH,10,615.4294,6239.798,17.64701,0,0,0,0,100,0), +(@PATH,11,601.6331,6250.868,17.77201,0,0,0,0,100,0), +(@PATH,12,615.4294,6239.798,17.64701,0,0,0,0,100,0), +(@PATH,13,637.1617,6227.35,17.69966,0,0,0,0,100,0), +(@PATH,14,660.7868,6235.378,17.60566,0,0,0,0,100,0), +(@PATH,15,675.7322,6259.213,17.66298,0,0,0,0,100,0), +(@PATH,16,686.5964,6275.249,17.68558,0,0,0,0,100,0), +(@PATH,17,688.4388,6290.488,17.43558,0,0,0,0,100,0), +(@PATH,18,707.5536,6305.207,17.44607,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71586; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=456.8788,`position_y`=6370.086,`position_z`=17.94312 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,456.8788,6370.086,17.94312,0,0,0,0,100,0), +(@PATH,2,452.2714,6389.746,17.81812,0,0,0,0,100,0), +(@PATH,3,467.8412,6407.655,17.79832,0,0,0,0,100,0), +(@PATH,4,491.2019,6411.824,15.48412,0,0,0,0,100,0), +(@PATH,5,467.8412,6407.655,17.79832,0,0,0,0,100,0), +(@PATH,6,452.2714,6389.746,17.81812,0,0,0,0,100,0), +(@PATH,7,456.8788,6370.086,17.94312,0,0,0,0,100,0), +(@PATH,8,454.0548,6347.622,17.85618,0,0,0,0,100,0), +(@PATH,9,446.207,6326.609,17.93723,0,0,0,0,100,0), +(@PATH,10,441.623,6303.469,17.93723,0,0,0,0,100,0), +(@PATH,11,446.207,6326.609,17.93723,0,0,0,0,100,0), +(@PATH,12,454.0548,6347.622,17.85618,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71587; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=473.7206,`position_y`=8024.335,`position_z`=17.56001 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,473.7206,8024.335,17.56001,0,0,0,0,100,0), +(@PATH,2,496.147,8008.202,17.40107,0,0,0,0,100,0), +(@PATH,3,517.5805,8011.069,17.49237,0,0,0,0,100,0), +(@PATH,4,538.4409,8009.085,17.53157,0,0,0,0,100,0), +(@PATH,5,560.729,8010.077,17.4316,0,0,0,0,100,0), +(@PATH,6,589.2994,8011.602,17.44117,0,0,0,0,100,0), +(@PATH,7,560.729,8010.077,17.4316,0,0,0,0,100,0), +(@PATH,8,538.4409,8009.085,17.53157,0,0,0,0,100,0), +(@PATH,9,517.5805,8011.069,17.49237,0,0,0,0,100,0), +(@PATH,10,496.147,8008.202,17.40107,0,0,0,0,100,0), +(@PATH,11,473.7206,8024.335,17.56001,0,0,0,0,100,0), +(@PATH,12,458.5915,8058.235,17.49908,0,0,0,0,100,0), +(@PATH,13,454.0531,8072.585,17.49909,0,0,0,0,100,0), +(@PATH,14,440.1596,8088.723,17.49909,0,0,0,0,100,0), +(@PATH,15,433.4708,8105.307,17.77139,0,0,0,0,100,0), +(@PATH,16,440.1596,8088.723,17.49909,0,0,0,0,100,0), +(@PATH,17,454.0531,8072.585,17.49909,0,0,0,0,100,0), +(@PATH,18,458.5915,8058.235,17.49908,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71588; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=763.2474,`position_y`=8077.369,`position_z`=17.49908 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,763.2474,8077.369,17.49908,0,0,0,0,100,0), +(@PATH,2,764.3576,8096.227,17.49908,0,0,0,0,100,0), +(@PATH,3,763.1123,8113.93,17.49908,0,0,0,0,100,0), +(@PATH,4,754.1951,8129.958,17.565,0,0,0,0,100,0), +(@PATH,5,746.9005,8144.393,16.9609,0,0,0,0,100,0), +(@PATH,6,754.1951,8129.958,17.565,0,0,0,0,100,0), +(@PATH,7,763.1123,8113.93,17.49908,0,0,0,0,100,0), +(@PATH,8,764.3576,8096.227,17.49908,0,0,0,0,100,0), +(@PATH,9,763.2474,8077.369,17.49908,0,0,0,0,100,0), +(@PATH,10,753.71,8050.239,17.49907,0,0,0,0,100,0), +(@PATH,11,736.1158,8032.819,17.50464,0,0,0,0,100,0), +(@PATH,12,727.4476,8005.954,17.80172,0,0,0,0,100,0), +(@PATH,13,736.1158,8032.819,17.50464,0,0,0,0,100,0), +(@PATH,14,753.71,8050.239,17.49907,0,0,0,0,100,0); + +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71589; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=590.5538,`position_y`=6385.54,`position_z`=19.41796 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,590.5538,6385.54,19.41796,0,0,0,0,100,0), +(@PATH,2,576.1758,6381.048,19.19262,0,0,0,0,100,0), +(@PATH,3,549.4913,6380.258,16.99608,0,0,0,0,100,0), +(@PATH,4,536.714,6381.334,19.3341,0,0,0,0,100,0), +(@PATH,5,512.5249,6386.269,20.09841,0,0,0,0,100,0), +(@PATH,6,536.714,6381.334,19.3341,0,0,0,0,100,0), +(@PATH,7,549.4913,6380.258,16.99608,0,0,0,0,100,0), +(@PATH,8,576.1758,6381.048,19.19262,0,0,0,0,100,0), +(@PATH,9,590.502,6385.516,19.35204,0,0,0,0,100,0), +(@PATH,10,603.5302,6383.618,19.05107,0,0,0,0,100,0), +(@PATH,11,618.3229,6384.962,19.48649,0,0,0,0,100,0), +(@PATH,12,629.5106,6391.457,18.35343,0,0,0,0,100,0), +(@PATH,13,618.3229,6384.962,19.48649,0,0,0,0,100,0), +(@PATH,14,603.5302,6383.618,19.05107,0,0,0,0,100,0); --- Pathing for Swamprat Guard Entry: 18910 -SET @NPC := 67910; +-- Pathing for Bloodscale Sentry Entry: 20090 +SET @NPC := 71590; SET @PATH := @NPC * 10; -UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=104.3016,`position_y`=5221.673,`position_z`=22.33099 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=384.1659,`position_y`=8112.826,`position_z`=17.53038 WHERE `guid`=@NPC; DELETE FROM `creature_addon` WHERE `guid`=@NPC; -INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,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,104.3016,5221.673,22.33099,0,0,0,0,100,0), -(@PATH,2,98.48994,5217.889,22.21583,0,0,0,0,100,0), -(@PATH,3,97.17163,5209.297,21.69117,0,0,0,0,100,0), -(@PATH,4,82.73155,5204.081,22.44019,0,0,0,0,100,0), -(@PATH,5,80.67603,5193.767,21.65778,0,0,0,0,100,0), -(@PATH,6,90.1913,5186.492,21.33686,0,0,0,0,100,0), -(@PATH,7,92.36255,5170.327,22.81916,0,0,0,0,100,0), -(@PATH,8,104.2373,5163.936,22.91181,0,0,0,0,100,0), -(@PATH,9,108.7816,5178.44,22.09893,0,0,0,0,100,0), -(@PATH,10,121.7926,5183.15,24.04241,0,0,0,0,100,0), -(@PATH,11,117.1341,5191.477,23.33294,0,0,0,0,100,0), -(@PATH,12,118.593,5209.887,22.58294,0,0,0,0,100,0), -(@PATH,13,114.1548,5216.103,23.23504,0,0,0,0,100,0); +(@PATH,1,384.1659,8112.826,17.53038,0,0,0,0,100,0), +(@PATH,2,403.2718,8119.023,17.60357,0,0,0,0,100,0), +(@PATH,3,421.5509,8121.888,17.61883,0,0,0,0,100,0), +(@PATH,4,422.268,8135.977,17.62646,0,0,0,0,100,0), +(@PATH,5,421.0201,8147.833,17.5863,0,0,0,0,100,0), +(@PATH,6,410.0742,8161.833,17.12646,0,0,0,0,100,0), +(@PATH,7,405.593,8175.743,17.44895,0,0,0,0,100,0), +(@PATH,8,404.0476,8192.669,17.69895,0,0,0,0,100,0), +(@PATH,9,405.593,8175.743,17.44895,0,0,0,0,100,0), +(@PATH,10,410.0742,8161.833,17.12646,0,0,0,0,100,0), +(@PATH,11,421.0201,8147.833,17.5863,0,0,0,0,100,0), +(@PATH,12,422.268,8135.977,17.62646,0,0,0,0,100,0), +(@PATH,13,421.5509,8121.888,17.61883,0,0,0,0,100,0), +(@PATH,14,403.2718,8119.023,17.60357,0,0,0,0,100,0), +(@PATH,15,384.1659,8112.826,17.53038,0,0,0,0,100,0), +(@PATH,16,366.2072,8100.374,17.74176,0,0,0,0,100,0), +(@PATH,17,338.3154,8112.941,17.49909,0,0,0,0,100,0), +(@PATH,18,330.1254,8143.837,17.49909,0,0,0,0,100,0), +(@PATH,19,324.209,8171.819,17.64763,0,0,0,0,100,0), +(@PATH,20,312.2263,8170.651,17.40044,0,0,0,0,100,0), +(@PATH,21,292.32,8159.853,17.61897,0,0,0,0,100,0), +(@PATH,22,277.5932,8158.432,17.57466,0,0,0,0,100,0), +(@PATH,23,292.32,8159.853,17.61897,0,0,0,0,100,0), +(@PATH,24,312.2263,8170.651,17.40044,0,0,0,0,100,0), +(@PATH,25,324.209,8171.819,17.64763,0,0,0,0,100,0), +(@PATH,26,330.1254,8143.837,17.49909,0,0,0,0,100,0), +(@PATH,27,338.3154,8112.941,17.49909,0,0,0,0,100,0), +(@PATH,28,366.2072,8100.374,17.74176,0,0,0,0,100,0); diff --git a/sql/updates/world/2014_07_30_07_world_waypoints.sql b/sql/updates/world/2014_07_30_07_world_waypoints.sql new file mode 100644 index 00000000000..c0a8a2ee413 --- /dev/null +++ b/sql/updates/world/2014_07_30_07_world_waypoints.sql @@ -0,0 +1,68 @@ +-- Pathing for Swamprat Guard Entry: 18910 +SET @NPC := 67906; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=75.29373,`position_y`=5261.419,`position_z`=23.08392 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +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,75.29373,5261.419,23.08392,0,0,0,0,100,0), +(@PATH,2,75.29796,5274.807,23.04233,0,0,0,0,100,0), +(@PATH,3,82.62872,5302.216,22.98195,0,0,0,0,100,0), +(@PATH,4,83.02105,5314.273,22.13724,0,0,0,0,100,0), +(@PATH,5,82.34508,5302.751,22.97913,0,0,0,0,100,0), +(@PATH,6,75.29796,5274.807,23.04233,0,0,0,0,100,0), +(@PATH,7,75.29373,5261.419,23.08392,0,0,0,0,100,0), +(@PATH,8,75.86388,5247.502,23.12924,0,0,0,0,100,0), +(@PATH,9,79.21181,5240.832,23.16174,0,0,0,0,100,0), +(@PATH,10,87.85194,5229.543,22.38807,0,0,0,0,100,0), +(@PATH,11,79.21181,5240.832,23.16174,0,0,0,0,100,0), +(@PATH,12,75.86388,5247.502,23.12924,0,0,0,0,100,0); + +-- Pathing for Swamprat Guard Entry: 18910 +SET @NPC := 67907; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=75.29373,`position_y`=5261.419,`position_z`=23.08392 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +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,75.29373,5261.419,23.08392,0,0,0,0,100,0), +(@PATH,2,75.29796,5274.807,23.04233,0,0,0,0,100,0), +(@PATH,3,82.62872,5302.216,22.98195,0,0,0,0,100,0), +(@PATH,4,83.02105,5314.273,22.13724,0,0,0,0,100,0), +(@PATH,5,82.34508,5302.751,22.97913,0,0,0,0,100,0), +(@PATH,6,75.29796,5274.807,23.04233,0,0,0,0,100,0), +(@PATH,7,75.29373,5261.419,23.08392,0,0,0,0,100,0), +(@PATH,8,75.86388,5247.502,23.12924,0,0,0,0,100,0), +(@PATH,9,79.21181,5240.832,23.16174,0,0,0,0,100,0), +(@PATH,10,87.85194,5229.543,22.38807,0,0,0,0,100,0), +(@PATH,11,79.21181,5240.832,23.16174,0,0,0,0,100,0), +(@PATH,12,75.86388,5247.502,23.12924,0,0,0,0,100,0); + +-- Add Swamprat Guard formation +DELETE FROM `creature_formations` WHERE `leaderGUID`=67907; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`)VALUES +(67907,67907,0,0,2),(67907,67906,3,0,2); + +-- Pathing for Swamprat Guard Entry: 18910 +SET @NPC := 67910; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=104.3016,`position_y`=5221.673,`position_z`=22.33099 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,257,0, '5301'); +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,104.3016,5221.673,22.33099,0,0,0,0,100,0), +(@PATH,2,98.48994,5217.889,22.21583,0,0,0,0,100,0), +(@PATH,3,97.17163,5209.297,21.69117,0,0,0,0,100,0), +(@PATH,4,82.73155,5204.081,22.44019,0,0,0,0,100,0), +(@PATH,5,80.67603,5193.767,21.65778,0,0,0,0,100,0), +(@PATH,6,90.1913,5186.492,21.33686,0,0,0,0,100,0), +(@PATH,7,92.36255,5170.327,22.81916,0,0,0,0,100,0), +(@PATH,8,104.2373,5163.936,22.91181,0,0,0,0,100,0), +(@PATH,9,108.7816,5178.44,22.09893,0,0,0,0,100,0), +(@PATH,10,121.7926,5183.15,24.04241,0,0,0,0,100,0), +(@PATH,11,117.1341,5191.477,23.33294,0,0,0,0,100,0), +(@PATH,12,118.593,5209.887,22.58294,0,0,0,0,100,0), +(@PATH,13,114.1548,5216.103,23.23504,0,0,0,0,100,0); |