diff options
| -rw-r--r-- | sql/updates/world/2015_07_26_06_world.sql | 808 |
1 files changed, 808 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_26_06_world.sql b/sql/updates/world/2015_07_26_06_world.sql new file mode 100644 index 00000000000..cb0b17c4634 --- /dev/null +++ b/sql/updates/world/2015_07_26_06_world.sql @@ -0,0 +1,808 @@ +-- Dragonblight Pathing - Completed +-- 1. +SET @NPC := 101926; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4576.081,`position_y`=-1397.422,`position_z`=159.3001 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,4576.081,-1397.422,159.3001,0,0,0,0,100,0), +(@PATH,2,4575.831,-1395.422,158.3001,0,0,0,0,100,0), +(@PATH,3,4575.831,-1392.422,157.8001,0,0,0,0,100,0), +(@PATH,4,4575.581,-1388.672,157.3001,0,0,0,0,100,0), +(@PATH,5,4574.875,-1383.615,157.1232,0,0,0,0,100,0), +(@PATH,6,4568.852,-1375.817,156.8941,0,0,0,0,100,0), +(@PATH,7,4591.876,-1383.339,157.1368,0,0,0,0,100,0), +(@PATH,8,4590.626,-1386.339,157.3868,0,0,0,0,100,0), +(@PATH,9,4590.626,-1387.589,157.3868,0,0,0,0,100,0), +(@PATH,10,4590.376,-1394.339,157.8868,0,0,0,0,100,0), +(@PATH,11,4590.376,-1397.339,158.3868,0,0,0,0,100,0), +(@PATH,12,4590.351,-1397.315,158.5053,0,0,0,0,100,0), +(@PATH,13,4590.351,-1399.065,159.0053,0,0,0,0,100,0), +(@PATH,14,4586.351,-1398.565,158.2553,0,0,0,0,100,0), +(@PATH,15,4580.601,-1398.065,158.7553,0,0,0,0,100,0); + +-- 2. +SET @NPC := 101928; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4556.794,`position_y`=-1387.165,`position_z`=156.6313 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,4556.794,-1387.165,156.6313,0,0,0,0,100,0), +(@PATH,2,4551.391,-1394,157.15,0,0,0,0,100,0), +(@PATH,3,4555.141,-1399.5,157.65,0,0,0,0,100,0), +(@PATH,4,4556.891,-1402,158.15,0,0,0,0,100,0), +(@PATH,5,4556.708,-1402.021,158.1755,0,0,0,0,100,0), +(@PATH,6,4557.458,-1402.771,158.1755,0,0,0,0,100,0), +(@PATH,7,4551.458,-1402.021,157.6755,0,0,0,0,100,0), +(@PATH,8,4549.958,-1401.771,157.4255,0,0,0,0,100,0), +(@PATH,9,4545.958,-1400.771,157.1755,0,0,0,0,100,0), +(@PATH,10,4544.208,-1400.271,157.1755,0,0,0,0,100,0), +(@PATH,11,4542.458,-1400.021,156.9255,0,0,0,0,100,0), +(@PATH,12,4542.208,-1399.271,156.6755,0,0,0,0,100,0), +(@PATH,13,4533.708,-1398.021,157.1755,0,0,0,0,100,0), +(@PATH,14,4529.458,-1398.771,157.1755,0,0,0,0,100,0), +(@PATH,15,4527.458,-1398.771,157.1755,0,0,0,0,100,0), +(@PATH,16,4525.208,-1398.771,157.1755,0,0,0,0,100,0), +(@PATH,17,4516.958,-1398.021,157.4255,0,0,0,0,100,0), +(@PATH,18,4516.909,-1397.576,157.4565,0,0,0,0,100,0), +(@PATH,19,4513.659,-1396.076,157.4565,0,0,0,0,100,0), +(@PATH,20,4516.909,-1397.576,157.4565,0,0,0,0,100,0), +(@PATH,21,4525.159,-1398.826,156.9565,0,0,0,0,100,0), +(@PATH,22,4527.409,-1398.826,156.9565,0,0,0,0,100,0), +(@PATH,23,4529.409,-1398.826,156.7065,0,0,0,0,100,0), +(@PATH,24,4533.409,-1397.576,156.7065,0,0,0,0,100,0), +(@PATH,25,4541.659,-1393.826,156.7065,0,0,0,0,100,0), +(@PATH,26,4541.558,-1393.465,156.4956,0,0,0,0,100,0), +(@PATH,27,4541.808,-1392.465,156.4956,0,0,0,0,100,0), +(@PATH,28,4542.008,-1375.528,156.7479,0,0,0,0,100,0), +(@PATH,29,4556.725,-1387.308,156.63,0,0,0,0,100,0); + +-- 3. +SET @NPC := 101927; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4518.842,`position_y`=-1322.926,`position_z`=156.9736 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,4518.842,-1322.926,156.9736,0,0,0,0,100,0), +(@PATH,2,4518.085,-1341.365,156.9764,0,0,0,0,100,0), +(@PATH,3,4533.335,-1343.615,156.9764,0,0,0,0,100,0), +(@PATH,4,4537.585,-1342.365,156.9764,0,0,0,0,100,0), +(@PATH,5,4539.585,-1342.365,156.9764,0,0,0,0,100,0), +(@PATH,6,4541.585,-1342.365,156.9764,0,0,0,0,100,0), +(@PATH,7,4541.619,-1342.559,156.794,0,0,0,0,100,0), +(@PATH,8,4542.119,-1343.809,156.794,0,0,0,0,100,0), +(@PATH,9,4542.091,-1322.502,157.0335,0,0,0,0,100,0), +(@PATH,10,4518.961,-1322.933,156.9721,0,0,0,0,100,0); + +-- 4. +SET @NPC := 102074; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4621.444,`position_y`=-1430.324,`position_z`=160.3961 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,4621.444,-1430.324,160.3961,0,0,0,0,100,0), +(@PATH,2,4621.194,-1433.324,159.6461,0,0,0,0,100,0), +(@PATH,3,4620.944,-1435.074,159.3961,0,0,0,0,100,0), +(@PATH,4,4620.944,-1437.074,158.6461,0,0,0,0,100,0), +(@PATH,5,4620.694,-1439.074,158.1461,0,0,0,0,100,0), +(@PATH,6,4621.444,-1430.324,160.3961,0,0,0,0,100,0), +(@PATH,7,4621.194,-1433.324,159.6461,0,0,0,0,100,0), +(@PATH,8,4620.944,-1435.074,159.3961,0,0,0,0,100,0), +(@PATH,9,4620.944,-1437.074,158.6461,0,0,0,0,100,0), +(@PATH,10,4620.694,-1439.074,158.1461,0,0,0,0,100,0); + +-- 5. +SET @NPC := 102282; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4567.123,`position_y`=-1370.781,`position_z`=157.047 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,4567.123,-1370.781,157.047,0,0,0,0,100,0), +(@PATH,2,4567.127,-1370.906,156.8476,0,0,0,0,100,0), +(@PATH,3,4567.394,-1370.792,157.0626,0,0,0,0,100,0), +(@PATH,4,4584.014,-1389.469,157.0952,0,0,0,0,100,0), +(@PATH,5,4584.514,-1398.469,158.0952,0,0,0,0,100,0), +(@PATH,6,4584.764,-1400.219,158.5952,0,0,0,0,100,0), +(@PATH,7,4584.764,-1402.219,159.3452,0,0,0,0,100,0), +(@PATH,8,4584.764,-1404.219,160.0952,0,0,0,0,100,0), +(@PATH,9,4585.014,-1407.219,160.8452,0,0,0,0,100,0), +(@PATH,10,4585.539,-1410.874,160.9313,0,0,0,0,100,0), +(@PATH,11,4585.222,-1410.88,160.8818,0,0,0,0,100,0), +(@PATH,12,4585.258,-1410.552,161.0389,0,0,0,0,100,0), +(@PATH,13,4585.008,-1405.552,160.5389,0,0,0,0,100,0), +(@PATH,14,4584.758,-1402.552,159.5389,0,0,0,0,100,0), +(@PATH,15,4584.758,-1400.802,158.7889,0,0,0,0,100,0), +(@PATH,16,4584.758,-1398.802,158.0389,0,0,0,0,100,0), +(@PATH,17,4584.508,-1394.802,157.2889,0,0,0,0,100,0), +(@PATH,18,4583.947,-1389.219,156.8961,0,0,0,0,100,0), +(@PATH,19,4575.038,-1379.639,156.8476,0,0,0,0,100,0), +(@PATH,20,4567.127,-1370.906,156.8476,0,0,0,0,100,0); + +-- 6. +SET @NPC := 102266; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4554.247,`position_y`=-1408.335,`position_z`=159.2896 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,4554.247,-1408.335,159.2896,0,0,0,0,100,0), +(@PATH,2,4558.247,-1409.335,159.2896,0,0,0,0,100,0), +(@PATH,3,4562.747,-1410.335,160.0396,0,0,0,0,100,0), +(@PATH,4,4558.252,-1409.355,159.2309,0,0,0,0,100,0), +(@PATH,5,4563.082,-1410.503,159.8952,0,0,0,0,100,0), +(@PATH,6,4567.231,-1411.292,160.2069,0,0,0,0,100,0), +(@PATH,7,4578.286,-1408.012,160.8312,0,0,0,0,100,0), +(@PATH,8,4581.786,-1403.262,159.8312,0,0,0,0,100,0), +(@PATH,9,4584.286,-1400.512,158.3312,0,0,0,0,100,0), +(@PATH,10,4584.507,-1400.38,158.6359,0,0,0,0,100,0), +(@PATH,11,4582.757,-1402.38,159.3859,0,0,0,0,100,0), +(@PATH,12,4579.507,-1406.38,160.6359,0,0,0,0,100,0), +(@PATH,13,4579.197,-1406.689,160.5844,0,0,0,0,100,0), +(@PATH,14,4577.947,-1408.189,160.8344,0,0,0,0,100,0), +(@PATH,15,4566.793,-1411.292,160.2511,0,0,0,0,100,0), +(@PATH,16,4562.043,-1410.042,159.7511,0,0,0,0,100,0), +(@PATH,17,4555.543,-1408.542,159.2511,0,0,0,0,100,0), +(@PATH,18,4551.963,-1408.205,158.5985,0,0,0,0,100,0), +(@PATH,19,4545.213,-1407.205,157.8485,0,0,0,0,100,0), +(@PATH,20,4539.713,-1406.205,157.8485,0,0,0,0,100,0), +(@PATH,21,4537.463,-1405.955,157.8485,0,0,0,0,100,0), +(@PATH,22,4534.213,-1406.705,157.8485,0,0,0,0,100,0), +(@PATH,23,4533.04,-1406.693,158.1809,0,0,0,0,100,0), +(@PATH,24,4534.29,-1406.693,158.1809,0,0,0,0,100,0), +(@PATH,25,4536.54,-1406.193,157.9309,0,0,0,0,100,0), +(@PATH,26,4539.29,-1405.693,157.6809,0,0,0,0,100,0), +(@PATH,27,4542.04,-1405.193,157.6809,0,0,0,0,100,0), +(@PATH,28,4545.79,-1406.193,157.9309,0,0,0,0,100,0), +(@PATH,29,4550.04,-1406.193,158.4309,0,0,0,0,100,0), +(@PATH,30,4552.79,-1407.693,158.6809,0,0,0,0,100,0); + +-- 7. +SET @NPC := 102284; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4556.007,`position_y`=-1344.133,`position_z`=157.016 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,4556.007,-1344.133,157.016,0,0,0,0,100,0), +(@PATH,2,4555.333,-1360.686,157.1821,0,0,0,0,100,0), +(@PATH,3,4519.583,-1360.936,157.4321,0,0,0,0,100,0), +(@PATH,4,4515.625,-1360.805,157.78,0,0,0,0,100,0), +(@PATH,5,4515.625,-1354.805,157.03,0,0,0,0,100,0), +(@PATH,6,4515.625,-1349.055,156.78,0,0,0,0,100,0), +(@PATH,7,4515.746,-1348.907,156.6323,0,0,0,0,100,0), +(@PATH,8,4515.746,-1346.407,156.6323,0,0,0,0,100,0), +(@PATH,9,4522.746,-1346.157,156.8823,0,0,0,0,100,0), +(@PATH,10,4547.496,-1344.657,156.6323,0,0,0,0,100,0), +(@PATH,11,4553.496,-1344.407,156.8823,0,0,0,0,100,0), +(@PATH,12,4555.922,-1344.138,157.0128,0,0,0,0,100,0); + +-- 8. +SET @NPC := 102283; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4582.663,`position_y`=-1348.6,`position_z`=156.8326 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,4582.663,-1348.6,156.8326,0,0,0,0,100,0), +(@PATH,2,4582.684,-1348.707,156.9411,0,0,0,0,100,0), +(@PATH,3,4582.663,-1348.6,156.8326,0,0,0,0,100,0), +(@PATH,4,4582.585,-1348.307,157.0723,0,0,0,0,100,0), +(@PATH,5,4577.265,-1333.34,157.0359,0,0,0,0,100,0), +(@PATH,6,4570.083,-1308.282,157.7191,0,0,0,0,100,0), +(@PATH,7,4563.083,-1309.282,157.9691,0,0,0,0,100,0), +(@PATH,8,4565.76,-1309.035,157.767,0,0,0,0,100,0), +(@PATH,9,4570.377,-1308.299,157.5928,0,0,0,0,100,0), +(@PATH,10,4576.127,-1329.299,157.0928,0,0,0,0,100,0), +(@PATH,11,4577.52,-1333.673,156.7682,0,0,0,0,100,0), +(@PATH,12,4582.619,-1348.573,156.9356,0,0,0,0,100,0); + +-- 9. +SET @NPC := 110191; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3619.812,`position_y`=-1360.78,`position_z`=108.5742 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,3619.812,-1360.78,108.5742,0,0,0,0,100,0), +(@PATH,2,3623.062,-1357.03,109.3242,0,0,0,0,100,0), +(@PATH,3,3627.312,-1351.78,109.5742,0,0,0,0,100,0), +(@PATH,4,3631.562,-1346.28,110.3242,0,0,0,0,100,0), +(@PATH,5,3634.562,-1342.53,110.8242,0,0,0,0,100,0), +(@PATH,6,3637.575,-1339.039,111.5461,0,0,0,0,100,0), +(@PATH,7,3640.575,-1333.789,112.0461,0,0,0,0,100,0), +(@PATH,8,3645.075,-1326.539,112.5461,0,0,0,0,100,0), +(@PATH,9,3647.82,-1322.192,112.8992,0,0,0,0,100,0), +(@PATH,10,3667.128,-1311.668,113.362,0,0,0,0,100,0), +(@PATH,11,3670.378,-1299.418,112.862,0,0,0,0,100,0), +(@PATH,12,3668.588,-1306.111,113.1842,0,0,0,0,100,0), +(@PATH,13,3666.995,-1311.864,113.3777,0,0,0,0,100,0), +(@PATH,14,3649.495,-1321.114,112.8777,0,0,0,0,100,0), +(@PATH,15,3647.688,-1322.27,112.6617,0,0,0,0,100,0), +(@PATH,16,3641.688,-1332.27,112.1617,0,0,0,0,100,0), +(@PATH,17,3638.438,-1337.52,111.6617,0,0,0,0,100,0), +(@PATH,18,3638.165,-1337.673,111.6126,0,0,0,0,100,0), +(@PATH,19,3637.165,-1339.173,111.3626,0,0,0,0,100,0), +(@PATH,20,3634.165,-1343.173,110.8626,0,0,0,0,100,0), +(@PATH,21,3630.915,-1346.923,110.1126,0,0,0,0,100,0), +(@PATH,22,3626.915,-1352.173,109.8626,0,0,0,0,100,0), +(@PATH,23,3622.415,-1357.673,109.1126,0,0,0,0,100,0), +(@PATH,24,3619.473,-1361.15,108.3352,0,0,0,0,100,0), +(@PATH,25,3616.223,-1366.15,107.8352,0,0,0,0,100,0), +(@PATH,26,3612.973,-1371.15,107.3352,0,0,0,0,100,0), +(@PATH,27,3609.723,-1375.9,106.8352,0,0,0,0,100,0), +(@PATH,28,3606.973,-1379.9,106.3352,0,0,0,0,100,0), +(@PATH,29,3603.423,-1385.286,105.4844,0,0,0,0,100,0), +(@PATH,30,3586.173,-1389.286,105.2344,0,0,0,0,100,0), +(@PATH,31,3603.453,-1385.211,105.4207,0,0,0,0,100,0), +(@PATH,32,3603.797,-1384.914,105.7833,0,0,0,0,100,0), +(@PATH,33,3608.047,-1378.414,106.5333,0,0,0,0,100,0), +(@PATH,34,3610.797,-1374.164,106.7833,0,0,0,0,100,0), +(@PATH,35,3614.047,-1369.414,107.5333,0,0,0,0,100,0), +(@PATH,36,3617.297,-1364.414,108.0333,0,0,0,0,100,0); + +-- 10. +SET @NPC := 133511; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3807.781,`position_y`=-1124.511,`position_z`=120.2903 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,3807.781,-1124.511,120.2903,0,0,0,0,100,0), +(@PATH,2,3827.938,-1129.032,120.5069,0,0,0,0,100,0), +(@PATH,3,3837.688,-1131.032,121.0069,0,0,0,0,100,0), +(@PATH,4,3841.688,-1131.782,121.5069,0,0,0,0,100,0), +(@PATH,5,3846.188,-1132.532,122.2569,0,0,0,0,100,0), +(@PATH,6,3849.188,-1133.032,122.5069,0,0,0,0,100,0), +(@PATH,7,3852.188,-1133.782,123.0069,0,0,0,0,100,0), +(@PATH,8,3855.938,-1134.532,123.7569,0,0,0,0,100,0), +(@PATH,9,3858.938,-1135.032,124.5069,0,0,0,0,100,0), +(@PATH,10,3861.292,-1135.939,125.4275,0,0,0,0,100,0), +(@PATH,11,3864.292,-1135.939,126.1775,0,0,0,0,100,0), +(@PATH,12,3866.292,-1135.939,126.6775,0,0,0,0,100,0), +(@PATH,13,3869.292,-1136.189,127.4275,0,0,0,0,100,0), +(@PATH,14,3872.292,-1136.189,128.4275,0,0,0,0,100,0), +(@PATH,15,3874.292,-1136.189,128.9275,0,0,0,0,100,0), +(@PATH,16,3876.292,-1136.189,129.4275,0,0,0,0,100,0), +(@PATH,17,3879.042,-1136.189,129.9275,0,0,0,0,100,0), +(@PATH,18,3881.042,-1136.189,130.6775,0,0,0,0,100,0), +(@PATH,19,3883.042,-1136.189,131.1775,0,0,0,0,100,0), +(@PATH,20,3885.042,-1136.439,131.9275,0,0,0,0,100,0), +(@PATH,21,3887.042,-1136.439,132.4275,0,0,0,0,100,0), +(@PATH,22,3890.042,-1136.439,133.1775,0,0,0,0,100,0), +(@PATH,23,3894.042,-1136.689,133.6775,0,0,0,0,100,0), +(@PATH,24,3863.418,-1135.747,125.5911,0,0,0,0,100,0), +(@PATH,25,3861.168,-1135.497,125.0911,0,0,0,0,100,0), +(@PATH,26,3858.168,-1134.997,124.3411,0,0,0,0,100,0), +(@PATH,27,3854.168,-1134.247,123.5911,0,0,0,0,100,0), +(@PATH,28,3851.418,-1133.497,122.8411,0,0,0,0,100,0), +(@PATH,29,3848.418,-1132.997,122.3411,0,0,0,0,100,0), +(@PATH,30,3843.668,-1132.247,121.5911,0,0,0,0,100,0), +(@PATH,31,3837.918,-1130.997,121.0911,0,0,0,0,100,0), +(@PATH,32,3832.918,-1129.997,120.5911,0,0,0,0,100,0), +(@PATH,33,3827.494,-1128.906,120.3076,0,0,0,0,100,0); + +-- 11. +SET @NPC := 110185; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3810.394,`position_y`=-1252.74,`position_z`=132.7603 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,3810.394,-1252.74,132.7603,0,0,0,0,100,0), +(@PATH,2,3807.894,-1248.49,131.7603,0,0,0,0,100,0), +(@PATH,3,3805.894,-1244.99,131.2603,0,0,0,0,100,0), +(@PATH,4,3803.644,-1240.99,130.7603,0,0,0,0,100,0), +(@PATH,5,3800.144,-1234.74,130.2603,0,0,0,0,100,0), +(@PATH,6,3798.381,-1231.831,129.8273,0,0,0,0,100,0), +(@PATH,7,3787.381,-1225.081,129.0773,0,0,0,0,100,0), +(@PATH,8,3783.381,-1222.331,128.5773,0,0,0,0,100,0), +(@PATH,9,3777.631,-1218.331,128.0773,0,0,0,0,100,0), +(@PATH,10,3777.286,-1218.278,127.8302,0,0,0,0,100,0), +(@PATH,11,3774.536,-1216.278,127.5802,0,0,0,0,100,0), +(@PATH,12,3770.786,-1214.778,126.8302,0,0,0,0,100,0), +(@PATH,13,3764.286,-1212.528,126.3302,0,0,0,0,100,0), +(@PATH,14,3758.036,-1209.778,125.8302,0,0,0,0,100,0), +(@PATH,15,3760.559,-1210.657,125.8885,0,0,0,0,100,0), +(@PATH,16,3764.809,-1212.407,126.3885,0,0,0,0,100,0), +(@PATH,17,3771.309,-1215.157,126.8885,0,0,0,0,100,0), +(@PATH,18,3774.619,-1216.655,127.7802,0,0,0,0,100,0), +(@PATH,19,3779.869,-1219.905,128.2802,0,0,0,0,100,0), +(@PATH,20,3784.869,-1223.155,128.7802,0,0,0,0,100,0), +(@PATH,21,3788.869,-1225.655,129.2802,0,0,0,0,100,0), +(@PATH,22,3798.656,-1232.089,130.057,0,0,0,0,100,0), +(@PATH,23,3801.656,-1237.339,130.557,0,0,0,0,100,0), +(@PATH,24,3804.906,-1243.089,131.057,0,0,0,0,100,0), +(@PATH,25,3807.406,-1247.339,131.807,0,0,0,0,100,0), +(@PATH,26,3808.656,-1250.089,132.307,0,0,0,0,100,0), +(@PATH,27,3809.065,-1250.31,132.5905,0,0,0,0,100,0), +(@PATH,28,3810.565,-1253.06,133.0905,0,0,0,0,100,0), +(@PATH,29,3812.565,-1257.56,133.5905,0,0,0,0,100,0), +(@PATH,30,3815.065,-1263.06,134.0905,0,0,0,0,100,0), +(@PATH,31,3817.315,-1268.31,134.5905,0,0,0,0,100,0), +(@PATH,32,3820.315,-1274.56,135.0905,0,0,0,0,100,0), +(@PATH,33,3820.467,-1275.375,135.1237,0,0,0,0,100,0), +(@PATH,34,3817.717,-1269.375,134.6237,0,0,0,0,100,0), +(@PATH,35,3815.467,-1263.875,134.1237,0,0,0,0,100,0), +(@PATH,36,3812.717,-1257.375,133.6237,0,0,0,0,100,0), +(@PATH,37,3810.32,-1252.881,132.8059,0,0,0,0,100,0); + +-- 12. +SET @NPC := 133523; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3727.581,`position_y`=-1233.259,`position_z`=120.7148 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,3727.581,-1233.259,120.7148,0,0,0,0,100,0), +(@PATH,2,3729.331,-1236.259,121.4648,0,0,0,0,100,0), +(@PATH,3,3729.581,-1237.259,120.7148,0,0,0,0,100,0), +(@PATH,4,3728.581,-1241.009,120.4648,0,0,0,0,100,0), +(@PATH,5,3726.092,-1247.747,119.9045,0,0,0,0,100,0), +(@PATH,6,3724.592,-1248.997,119.4045,0,0,0,0,100,0), +(@PATH,7,3721.342,-1251.497,118.4045,0,0,0,0,100,0), +(@PATH,8,3718.842,-1252.997,117.9045,0,0,0,0,100,0), +(@PATH,9,3716.842,-1254.997,117.4045,0,0,0,0,100,0), +(@PATH,10,3714.342,-1256.747,116.6545,0,0,0,0,100,0), +(@PATH,11,3712.092,-1258.747,115.9045,0,0,0,0,100,0), +(@PATH,12,3708.842,-1260.997,115.1545,0,0,0,0,100,0), +(@PATH,13,3708.721,-1261.456,114.9097,0,0,0,0,100,0), +(@PATH,14,3707.971,-1261.706,114.9097,0,0,0,0,100,0), +(@PATH,15,3703.221,-1263.706,114.1597,0,0,0,0,100,0), +(@PATH,16,3697.971,-1265.456,113.9097,0,0,0,0,100,0), +(@PATH,17,3690.471,-1268.206,113.1597,0,0,0,0,100,0), +(@PATH,18,3694.284,-1266.812,113.6081,0,0,0,0,100,0), +(@PATH,19,3700.534,-1264.562,113.8581,0,0,0,0,100,0), +(@PATH,20,3707.034,-1262.062,114.6081,0,0,0,0,100,0), +(@PATH,21,3707.283,-1261.988,114.898,0,0,0,0,100,0), +(@PATH,22,3708.283,-1261.488,115.148,0,0,0,0,100,0), +(@PATH,23,3711.533,-1259.238,115.898,0,0,0,0,100,0), +(@PATH,24,3713.783,-1257.238,116.648,0,0,0,0,100,0), +(@PATH,25,3716.033,-1255.488,117.148,0,0,0,0,100,0), +(@PATH,26,3719.033,-1253.238,117.898,0,0,0,0,100,0), +(@PATH,27,3721.533,-1251.488,118.398,0,0,0,0,100,0), +(@PATH,28,3723.033,-1250.238,119.148,0,0,0,0,100,0), +(@PATH,29,3725.965,-1247.691,119.8526,0,0,0,0,100,0), +(@PATH,30,3725.965,-1241.441,120.1026,0,0,0,0,100,0), +(@PATH,31,3725.715,-1239.691,120.1026,0,0,0,0,100,0), +(@PATH,32,3725.715,-1238.441,120.1026,0,0,0,0,100,0), +(@PATH,33,3725.715,-1237.441,120.1026,0,0,0,0,100,0), +(@PATH,34,3725.965,-1235.441,120.3526,0,0,0,0,100,0), +(@PATH,35,3725.965,-1233.441,120.3526,0,0,0,0,100,0), +(@PATH,36,3726.212,-1233.165,120.5575,0,0,0,0,100,0), +(@PATH,37,3727.712,-1232.915,120.8075,0,0,0,0,100,0), +(@PATH,38,3727.462,-1223.165,121.3075,0,0,0,0,100,0), +(@PATH,39,3727.554,-1226.452,121.0746,0,0,0,0,100,0), +(@PATH,40,3729.078,-1211.919,121.6324,0,0,0,0,100,0), +(@PATH,41,3727.512,-1220.648,121.285,0,0,0,0,100,0); + +-- 13. +SET @NPC := 133524; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3632.88,`position_y`=-1239.063,`position_z`=112.6134 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,3632.88,-1239.063,112.6134,0,0,0,0,100,0), +(@PATH,2,3632.922,-1238.892,112.8432,0,0,0,0,100,0), +(@PATH,3,3632.88,-1239.063,112.6134,0,0,0,0,100,0), +(@PATH,4,3632.99,-1238.771,112.8454,0,0,0,0,100,0), +(@PATH,5,3623.843,-1228.324,112.9198,0,0,0,0,100,0), +(@PATH,6,3623.843,-1219.324,113.4198,0,0,0,0,100,0), +(@PATH,7,3624.126,-1204.698,113.9558,0,0,0,0,100,0), +(@PATH,8,3623.845,-1204.983,113.7489,0,0,0,0,100,0), +(@PATH,9,3624.069,-1204.993,113.9181,0,0,0,0,100,0), +(@PATH,10,3623.819,-1217.743,113.4181,0,0,0,0,100,0), +(@PATH,11,3623.819,-1227.743,112.9181,0,0,0,0,100,0), +(@PATH,12,3632.88,-1239.063,112.6134,0,0,0,0,100,0); + +-- 14. + +SET @NPC := 101157; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3391.605,`position_y`=-1031.161,`position_z`=162.1003 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,3391.605,-1031.161,162.1003,0,0,0,0,100,0), +(@PATH,2,3390.605,-1029.161,163.1003,0,0,0,0,100,0), +(@PATH,3,3390.105,-1027.661,163.3503,0,0,0,0,100,0), +(@PATH,4,3389.355,-1025.911,164.3503,0,0,0,0,100,0), +(@PATH,5,3388.855,-1024.911,165.3503,0,0,0,0,100,0), +(@PATH,6,3388.605,-1024.161,164.1003,0,0,0,0,100,0), +(@PATH,7,3388.105,-1023.161,165.1003,0,0,0,0,100,0), +(@PATH,8,3387.798,-1022.825,165.2049,0,0,0,0,100,0), +(@PATH,9,3387.048,-1021.075,166.4549,0,0,0,0,100,0), +(@PATH,10,3386.798,-1020.075,167.7049,0,0,0,0,100,0), +(@PATH,11,3386.548,-1018.075,169.2049,0,0,0,0,100,0), +(@PATH,12,3386.298,-1016.325,170.4549,0,0,0,0,100,0), +(@PATH,13,3386.048,-1014.325,171.7049,0,0,0,0,100,0), +(@PATH,14,3385.548,-1012.575,173.4549,0,0,0,0,100,0), +(@PATH,15,3385.298,-1010.575,173.9549,0,0,0,0,100,0), +(@PATH,16,3385.424,-1012.189,173.5721,0,0,0,0,100,0), +(@PATH,17,3385.174,-1010.189,174.3221,0,0,0,0,100,0), +(@PATH,18,3385.174,-1009.439,175.3221,0,0,0,0,100,0), +(@PATH,19,3385.174,-1007.439,177.0721,0,0,0,0,100,0), +(@PATH,20,3385.174,-1006.689,177.3221,0,0,0,0,100,0), +(@PATH,21,3385.174,-1005.689,178.3221,0,0,0,0,100,0), +(@PATH,22,3385.174,-1004.689,179.3221,0,0,0,0,100,0), +(@PATH,23,3385.174,-1003.689,180.3221,0,0,0,0,100,0), +(@PATH,24,3385.174,-1002.689,181.0721,0,0,0,0,100,0), +(@PATH,25,3384.978,-1002.341,181.2513,0,0,0,0,100,0), +(@PATH,26,3384.978,-1001.341,182.0013,0,0,0,0,100,0), +(@PATH,27,3384.728,-1000.341,183.2513,0,0,0,0,100,0), +(@PATH,28,3384.478,-997.5915,185.2513,0,0,0,0,100,0), +(@PATH,29,3384.279,-997.4329,185.5698,0,0,0,0,100,0), +(@PATH,30,3384.029,-996.1829,186.5698,0,0,0,0,100,0), +(@PATH,31,3383.779,-995.1829,187.5698,0,0,0,0,100,0), +(@PATH,32,3383.529,-993.4329,189.3198,0,0,0,0,100,0), +(@PATH,33,3383.279,-991.4329,190.8198,0,0,0,0,100,0), +(@PATH,34,3383.029,-990.4329,192.0698,0,0,0,0,100,0), +(@PATH,35,3383.029,-989.4329,193.3198,0,0,0,0,100,0), +(@PATH,36,3382.615,-989.1885,193.6794,0,0,0,0,100,0), +(@PATH,37,3382.615,-988.4385,193.9294,0,0,0,0,100,0), +(@PATH,38,3382.365,-987.6885,194.9294,0,0,0,0,100,0), +(@PATH,39,3382.365,-986.9385,195.9294,0,0,0,0,100,0), +(@PATH,40,3382.365,-985.9385,197.1794,0,0,0,0,100,0), +(@PATH,41,3382.365,-984.9385,198.6794,0,0,0,0,100,0), +(@PATH,42,3382.226,-985.2476,198.7599,0,0,0,0,100,0), +(@PATH,43,3382.226,-986.2476,197.2599,0,0,0,0,100,0), +(@PATH,44,3382.226,-986.9976,196.2599,0,0,0,0,100,0), +(@PATH,45,3382.476,-987.9976,194.7599,0,0,0,0,100,0), +(@PATH,46,3382.696,-988.048,194.4933,0,0,0,0,100,0), +(@PATH,47,3382.696,-988.798,193.4933,0,0,0,0,100,0), +(@PATH,48,3382.946,-989.798,191.9933,0,0,0,0,100,0), +(@PATH,49,3383.196,-990.798,190.9933,0,0,0,0,100,0), +(@PATH,50,3383.196,-991.798,189.9933,0,0,0,0,100,0), +(@PATH,51,3383.696,-994.548,188.4933,0,0,0,0,100,0), +(@PATH,52,3383.881,-994.6021,188.3413,0,0,0,0,100,0), +(@PATH,53,3384.131,-996.3521,186.3413,0,0,0,0,100,0), +(@PATH,54,3384.131,-997.1021,185.3413,0,0,0,0,100,0), +(@PATH,55,3384.381,-998.1021,184.8413,0,0,0,0,100,0), +(@PATH,56,3384.631,-1000.102,183.5913,0,0,0,0,100,0), +(@PATH,57,3384.742,-1000.227,183.3849,0,0,0,0,100,0), +(@PATH,58,3384.992,-1001.227,181.8849,0,0,0,0,100,0), +(@PATH,59,3384.992,-1002.227,180.8849,0,0,0,0,100,0), +(@PATH,60,3384.992,-1003.227,180.1349,0,0,0,0,100,0), +(@PATH,61,3384.742,-1004.227,179.3849,0,0,0,0,100,0), +(@PATH,62,3384.742,-1004.977,178.3849,0,0,0,0,100,0), +(@PATH,63,3384.742,-1006.977,177.6349,0,0,0,0,100,0), +(@PATH,64,3384.742,-1007.977,176.8849,0,0,0,0,100,0), +(@PATH,65,3384.742,-1008.977,176.1349,0,0,0,0,100,0), +(@PATH,66,3385.162,-1007.279,177.4227,0,0,0,0,100,0), +(@PATH,67,3385.162,-1008.279,176.6727,0,0,0,0,100,0), +(@PATH,68,3385.162,-1009.279,175.9227,0,0,0,0,100,0), +(@PATH,69,3385.162,-1009.529,174.9227,0,0,0,0,100,0), +(@PATH,70,3385.162,-1010.529,173.9227,0,0,0,0,100,0), +(@PATH,71,3385.412,-1011.529,173.4227,0,0,0,0,100,0), +(@PATH,72,3385.662,-1012.529,172.6727,0,0,0,0,100,0), +(@PATH,73,3385.912,-1013.529,171.9227,0,0,0,0,100,0), +(@PATH,74,3385.912,-1015.279,171.4227,0,0,0,0,100,0), +(@PATH,75,3386.162,-1016.279,170.6727,0,0,0,0,100,0), +(@PATH,76,3386.412,-1017.279,169.9227,0,0,0,0,100,0), +(@PATH,77,3386.662,-1019.279,168.6727,0,0,0,0,100,0), +(@PATH,78,3386.912,-1020.279,167.6727,0,0,0,0,100,0), +(@PATH,79,3386.802,-1019.386,168.2894,0,0,0,0,100,0), +(@PATH,80,3387.052,-1020.386,167.5394,0,0,0,0,100,0), +(@PATH,81,3387.302,-1021.136,166.5394,0,0,0,0,100,0), +(@PATH,82,3387.552,-1022.136,165.2894,0,0,0,0,100,0), +(@PATH,83,3389.302,-1025.636,164.2894,0,0,0,0,100,0), +(@PATH,84,3389.552,-1026.636,162.7894,0,0,0,0,100,0), +(@PATH,85,3390.302,-1028.136,162.0394,0,0,0,0,100,0), +(@PATH,86,3391.605,-1031.161,162.1003,0,0,0,0,100,0); + +-- 15. +SET @NPC := 101138; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3349.938,`position_y`=-963.9735,`position_z`=175.869 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,3349.938,-963.9735,175.869,0,0,0,0,100,0), +(@PATH,2,3349.688,-964.9735,174.619,0,0,0,0,100,0), +(@PATH,3,3349.688,-965.9735,173.619,0,0,0,0,100,0), +(@PATH,4,3350.188,-966.7235,172.619,0,0,0,0,100,0), +(@PATH,5,3351.438,-968.4735,171.869,0,0,0,0,100,0), +(@PATH,6,3351.938,-969.2235,170.619,0,0,0,0,100,0), +(@PATH,7,3352.438,-969.9735,170.119,0,0,0,0,100,0), +(@PATH,8,3352.688,-970.7235,168.869,0,0,0,0,100,0), +(@PATH,9,3353.688,-972.4735,168.369,0,0,0,0,100,0), +(@PATH,10,3354.188,-973.2235,167.619,0,0,0,0,100,0), +(@PATH,11,3354.688,-974.2235,166.369,0,0,0,0,100,0), +(@PATH,12,3355.188,-974.9735,165.869,0,0,0,0,100,0), +(@PATH,13,3354.963,-974.3353,166.1092,0,0,0,0,100,0), +(@PATH,14,3355.463,-975.3353,165.6092,0,0,0,0,100,0), +(@PATH,15,3355.713,-976.0853,164.8592,0,0,0,0,100,0), +(@PATH,16,3355.963,-978.0853,163.3592,0,0,0,0,100,0), +(@PATH,17,3355.963,-979.0853,162.3592,0,0,0,0,100,0), +(@PATH,18,3355.963,-980.0853,161.3592,0,0,0,0,100,0), +(@PATH,19,3356.213,-981.0853,160.3592,0,0,0,0,100,0), +(@PATH,20,3356.213,-982.0853,159.3592,0,0,0,0,100,0), +(@PATH,21,3356.213,-983.8353,158.3592,0,0,0,0,100,0), +(@PATH,22,3356.463,-984.8353,157.6092,0,0,0,0,100,0), +(@PATH,23,3356.463,-985.8353,157.1092,0,0,0,0,100,0), +(@PATH,24,3356.463,-986.8353,156.3592,0,0,0,0,100,0), +(@PATH,25,3356.713,-987.8353,155.6092,0,0,0,0,100,0), +(@PATH,26,3356.713,-988.8353,154.8592,0,0,0,0,100,0), +(@PATH,27,3356.713,-989.8353,154.1092,0,0,0,0,100,0), +(@PATH,28,3356.713,-990.8353,153.3592,0,0,0,0,100,0), +(@PATH,29,3356.963,-991.8353,152.6092,0,0,0,0,100,0), +(@PATH,30,3356.963,-992.8353,151.6092,0,0,0,0,100,0), +(@PATH,31,3356.888,-992.4373,151.6062,0,0,0,0,100,0), +(@PATH,32,3356.888,-991.4373,152.6062,0,0,0,0,100,0), +(@PATH,33,3356.888,-990.4373,153.3562,0,0,0,0,100,0), +(@PATH,34,3356.638,-989.4373,154.1062,0,0,0,0,100,0), +(@PATH,35,3356.638,-988.4373,154.8562,0,0,0,0,100,0), +(@PATH,36,3356.638,-987.4373,155.6062,0,0,0,0,100,0), +(@PATH,37,3356.638,-986.4373,156.3562,0,0,0,0,100,0), +(@PATH,38,3356.388,-985.4373,157.1062,0,0,0,0,100,0), +(@PATH,39,3356.388,-984.9373,157.6062,0,0,0,0,100,0), +(@PATH,40,3356.388,-983.9373,158.1062,0,0,0,0,100,0), +(@PATH,41,3356.388,-981.9373,159.3562,0,0,0,0,100,0), +(@PATH,42,3356.388,-980.9373,160.3562,0,0,0,0,100,0), +(@PATH,43,3356.388,-979.9373,161.3562,0,0,0,0,100,0), +(@PATH,44,3356.138,-978.9373,162.3562,0,0,0,0,100,0), +(@PATH,45,3356.138,-977.9373,163.3562,0,0,0,0,100,0), +(@PATH,46,3356.138,-976.9373,164.3562,0,0,0,0,100,0), +(@PATH,47,3355.976,-977.483,163.6183,0,0,0,0,100,0), +(@PATH,48,3355.726,-976.483,164.6183,0,0,0,0,100,0), +(@PATH,49,3355.726,-975.733,165.1183,0,0,0,0,100,0), +(@PATH,50,3355.226,-974.983,165.8683,0,0,0,0,100,0), +(@PATH,51,3354.726,-974.233,166.3683,0,0,0,0,100,0), +(@PATH,52,3354.226,-973.233,167.6183,0,0,0,0,100,0), +(@PATH,53,3353.726,-972.483,168.1183,0,0,0,0,100,0), +(@PATH,54,3353.226,-971.733,169.1183,0,0,0,0,100,0), +(@PATH,55,3352.476,-969.983,169.8683,0,0,0,0,100,0), +(@PATH,56,3351.726,-969.233,170.6183,0,0,0,0,100,0), +(@PATH,57,3351.226,-968.483,171.8683,0,0,0,0,100,0), +(@PATH,58,3350.726,-967.483,172.6183,0,0,0,0,100,0), +(@PATH,59,3350.483,-967.2317,172.972,0,0,0,0,100,0), +(@PATH,60,3349.733,-965.7317,173.722,0,0,0,0,100,0), +(@PATH,61,3349.733,-964.7317,174.722,0,0,0,0,100,0), +(@PATH,62,3349.983,-963.7317,176.222,0,0,0,0,100,0), +(@PATH,63,3349.983,-962.7317,177.472,0,0,0,0,100,0), +(@PATH,64,3349.983,-961.9817,178.472,0,0,0,0,100,0), +(@PATH,65,3349.983,-959.9817,180.472,0,0,0,0,100,0), +(@PATH,66,3350.233,-957.9817,182.472,0,0,0,0,100,0), +(@PATH,67,3350.145,-957.7706,182.9037,0,0,0,0,100,0), +(@PATH,68,3350.145,-956.7706,183.6537,0,0,0,0,100,0), +(@PATH,69,3350.645,-956.0206,185.6537,0,0,0,0,100,0), +(@PATH,70,3351.645,-954.2706,187.6537,0,0,0,0,100,0), +(@PATH,71,3352.395,-952.7706,189.4037,0,0,0,0,100,0), +(@PATH,72,3353.145,-950.7706,191.6537,0,0,0,0,100,0), +(@PATH,73,3354.395,-948.2706,194.4037,0,0,0,0,100,0), +(@PATH,74,3354.421,-948.2466,194.2321,0,0,0,0,100,0), +(@PATH,75,3353.921,-949.2466,192.7321,0,0,0,0,100,0), +(@PATH,76,3352.671,-951.7466,189.9821,0,0,0,0,100,0), +(@PATH,77,3351.921,-953.2466,188.4821,0,0,0,0,100,0), +(@PATH,78,3351.171,-955.2466,185.4821,0,0,0,0,100,0), +(@PATH,79,3350.671,-955.9966,184.4821,0,0,0,0,100,0), +(@PATH,80,3350.855,-955.5132,185.3472,0,0,0,0,100,0), +(@PATH,81,3350.355,-956.2632,184.0972,0,0,0,0,100,0), +(@PATH,82,3350.105,-957.0132,183.3472,0,0,0,0,100,0), +(@PATH,83,3350.105,-959.0132,181.5972,0,0,0,0,100,0), +(@PATH,84,3350.105,-960.7632,179.8472,0,0,0,0,100,0), +(@PATH,85,3349.855,-962.7632,177.3472,0,0,0,0,100,0); + +-- 16. +SET @NPC := 101171; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3415.2,`position_y`=-1056.29,`position_z`=176.2218 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,3415.2,-1056.29,176.2218,0,0,0,0,100,0), +(@PATH,2,3416.7,-1057.29,176.9718,0,0,0,0,100,0), +(@PATH,3,3411.95,-1042.29,177.7218,0,0,0,0,100,0), +(@PATH,4,3410.95,-1039.54,178.4718,0,0,0,0,100,0), +(@PATH,5,3409.95,-1036.79,179.4718,0,0,0,0,100,0), +(@PATH,6,3410.236,-1036.772,179.4327,0,0,0,0,100,0), +(@PATH,7,3410.986,-1039.772,178.1827,0,0,0,0,100,0), +(@PATH,8,3413.236,-1047.022,176.6827,0,0,0,0,100,0), +(@PATH,9,3416.635,-1057.305,176.8312,0,0,0,0,100,0), +(@PATH,10,3415.135,-1056.305,176.0812,0,0,0,0,100,0), +(@PATH,11,3413.385,-1055.055,174.8312,0,0,0,0,100,0), +(@PATH,12,3410.885,-1053.305,173.5812,0,0,0,0,100,0), +(@PATH,13,3409.635,-1052.055,172.3312,0,0,0,0,100,0), +(@PATH,14,3407.885,-1051.305,171.5812,0,0,0,0,100,0), +(@PATH,15,3407.135,-1050.805,170.8312,0,0,0,0,100,0), +(@PATH,16,3406.385,-1050.055,169.5812,0,0,0,0,100,0), +(@PATH,17,3403.885,-1048.305,167.8312,0,0,0,0,100,0), +(@PATH,18,3403.61,-1048.19,167.4718,0,0,0,0,100,0), +(@PATH,19,3403.11,-1047.69,166.7218,0,0,0,0,100,0), +(@PATH,20,3401.61,-1046.44,166.4718,0,0,0,0,100,0), +(@PATH,21,3400.86,-1045.69,165.4718,0,0,0,0,100,0), +(@PATH,22,3397.61,-1043.19,164.9718,0,0,0,0,100,0), +(@PATH,23,3396.36,-1041.94,164.2218,0,0,0,0,100,0), +(@PATH,24,3394.86,-1040.69,162.7218,0,0,0,0,100,0), +(@PATH,25,3393.36,-1039.44,162.7218,0,0,0,0,100,0), +(@PATH,26,3392.61,-1038.69,161.2218,0,0,0,0,100,0), +(@PATH,27,3391.11,-1037.44,161.2218,0,0,0,0,100,0), +(@PATH,28,3389.61,-1036.19,159.4718,0,0,0,0,100,0), +(@PATH,29,3389.505,-1035.928,159.0951,0,0,0,0,100,0), +(@PATH,30,3388.505,-1035.178,158.5951,0,0,0,0,100,0), +(@PATH,31,3387.755,-1034.678,158.0951,0,0,0,0,100,0), +(@PATH,32,3386.755,-1034.428,157.3451,0,0,0,0,100,0), +(@PATH,33,3385.755,-1033.928,156.3451,0,0,0,0,100,0), +(@PATH,34,3385.005,-1033.678,155.3451,0,0,0,0,100,0), +(@PATH,35,3384.005,-1033.428,154.5951,0,0,0,0,100,0), +(@PATH,36,3383.255,-1032.928,153.3451,0,0,0,0,100,0), +(@PATH,37,3382.505,-1032.678,152.3451,0,0,0,0,100,0), +(@PATH,38,3380.755,-1031.678,151.0951,0,0,0,0,100,0), +(@PATH,39,3379.755,-1031.428,150.0951,0,0,0,0,100,0), +(@PATH,40,3378.755,-1030.928,149.0951,0,0,0,0,100,0), +(@PATH,41,3378.005,-1030.678,147.5951,0,0,0,0,100,0), +(@PATH,42,3377.005,-1030.178,147.0951,0,0,0,0,100,0), +(@PATH,43,3378.059,-1030.643,147.4961,0,0,0,0,100,0), +(@PATH,44,3379.059,-1031.143,148.9961,0,0,0,0,100,0), +(@PATH,45,3379.809,-1031.393,149.9961,0,0,0,0,100,0), +(@PATH,46,3380.809,-1031.893,150.9961,0,0,0,0,100,0), +(@PATH,47,3381.809,-1032.393,152.2461,0,0,0,0,100,0), +(@PATH,48,3382.309,-1032.643,153.2461,0,0,0,0,100,0), +(@PATH,49,3384.309,-1033.143,154.4961,0,0,0,0,100,0), +(@PATH,50,3385.059,-1033.643,155.2461,0,0,0,0,100,0), +(@PATH,51,3386.059,-1034.143,156.2461,0,0,0,0,100,0), +(@PATH,52,3387.059,-1034.393,157.2461,0,0,0,0,100,0), +(@PATH,53,3387.809,-1034.893,157.9961,0,0,0,0,100,0), +(@PATH,54,3387.125,-1034.778,157.4853,0,0,0,0,100,0), +(@PATH,55,3388.125,-1035.028,158.4853,0,0,0,0,100,0), +(@PATH,56,3388.875,-1035.528,158.9853,0,0,0,0,100,0), +(@PATH,57,3390.375,-1036.778,160.2353,0,0,0,0,100,0), +(@PATH,58,3393.375,-1039.278,162.4853,0,0,0,0,100,0), +(@PATH,59,3394.875,-1040.778,162.4853,0,0,0,0,100,0), +(@PATH,60,3395.375,-1041.278,163.7353,0,0,0,0,100,0), +(@PATH,61,3396.875,-1042.528,165.2353,0,0,0,0,100,0), +(@PATH,62,3399.125,-1044.278,165.9853,0,0,0,0,100,0), +(@PATH,63,3401.375,-1046.278,166.4853,0,0,0,0,100,0), +(@PATH,64,3401.772,-1046.569,166.873,0,0,0,0,100,0), +(@PATH,65,3403.272,-1047.819,167.123,0,0,0,0,100,0), +(@PATH,66,3404.022,-1048.569,167.873,0,0,0,0,100,0), +(@PATH,67,3405.022,-1049.069,168.873,0,0,0,0,100,0), +(@PATH,68,3405.772,-1049.569,170.123,0,0,0,0,100,0), +(@PATH,69,3406.522,-1050.319,170.873,0,0,0,0,100,0), +(@PATH,70,3408.272,-1051.319,171.373,0,0,0,0,100,0), +(@PATH,71,3408.772,-1051.819,172.623,0,0,0,0,100,0), +(@PATH,72,3409.522,-1052.319,173.123,0,0,0,0,100,0), +(@PATH,73,3412.022,-1054.069,174.373,0,0,0,0,100,0), +(@PATH,74,3412.772,-1054.569,175.123,0,0,0,0,100,0); + +-- 17. +SET @NPC := 101142; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3298.083,`position_y`=-841.7509,`position_z`=195.9927 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,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,3298.083,-841.7509,195.9927,0,0,0,0,100,0), +(@PATH,2,3298.083,-841.2509,195.2427,0,0,0,0,100,0), +(@PATH,3,3297.833,-840.2509,194.4927,0,0,0,0,100,0), +(@PATH,4,3297.083,-837.5009,193.7427,0,0,0,0,100,0), +(@PATH,5,3296.583,-835.5009,192.4927,0,0,0,0,100,0), +(@PATH,6,3296.083,-832.5009,191.9927,0,0,0,0,100,0), +(@PATH,7,3295.583,-830.7509,190.7427,0,0,0,0,100,0), +(@PATH,8,3295.333,-828.0009,190.2427,0,0,0,0,100,0), +(@PATH,9,3294.583,-825.0009,188.7427,0,0,0,0,100,0), +(@PATH,10,3294.083,-822.0009,187.4927,0,0,0,0,100,0), +(@PATH,11,3293.583,-820.0009,186.7427,0,0,0,0,100,0), +(@PATH,12,3293.083,-818.2509,185.9927,0,0,0,0,100,0), +(@PATH,13,3293.562,-820.1373,186.7285,0,0,0,0,100,0), +(@PATH,14,3294.062,-822.1373,187.4785,0,0,0,0,100,0), +(@PATH,15,3294.562,-825.1373,188.9785,0,0,0,0,100,0), +(@PATH,16,3295.312,-827.8873,189.9785,0,0,0,0,100,0), +(@PATH,17,3295.562,-830.6373,190.7285,0,0,0,0,100,0), +(@PATH,18,3296.312,-833.6373,192.2285,0,0,0,0,100,0), +(@PATH,19,3296.812,-836.3873,193.4785,0,0,0,0,100,0), +(@PATH,20,3297.312,-838.3873,194.2285,0,0,0,0,100,0), +(@PATH,21,3297.543,-838.7784,194.4357,0,0,0,0,100,0), +(@PATH,22,3298.293,-841.5284,195.4357,0,0,0,0,100,0), +(@PATH,23,3298.543,-843.5284,196.4357,0,0,0,0,100,0), +(@PATH,24,3299.043,-845.5284,197.1857,0,0,0,0,100,0), +(@PATH,25,3299.293,-847.5284,198.9357,0,0,0,0,100,0), +(@PATH,26,3299.793,-849.5284,199.6857,0,0,0,0,100,0), +(@PATH,27,3300.293,-852.2784,201.1857,0,0,0,0,100,0), +(@PATH,28,3300.793,-855.0284,201.9357,0,0,0,0,100,0), +(@PATH,29,3301.043,-857.0284,202.9357,0,0,0,0,100,0), +(@PATH,30,3301.543,-859.0284,203.6857,0,0,0,0,100,0), +(@PATH,31,3301.793,-861.0284,204.1857,0,0,0,0,100,0), +(@PATH,32,3302.043,-862.0284,205.4357,0,0,0,0,100,0), +(@PATH,33,3302.793,-864.7784,206.1857,0,0,0,0,100,0), +(@PATH,34,3303.043,-866.7784,206.6857,0,0,0,0,100,0), +(@PATH,35,3303.293,-867.7784,207.9357,0,0,0,0,100,0), +(@PATH,36,3303.468,-866.9954,207.0422,0,0,0,0,100,0), +(@PATH,37,3303.468,-867.9954,208.0422,0,0,0,0,100,0), +(@PATH,38,3303.718,-868.4954,208.0422,0,0,0,0,100,0), +(@PATH,39,3304.468,-868.9954,209.2922,0,0,0,0,100,0), +(@PATH,40,3305.968,-870.2454,210.2922,0,0,0,0,100,0), +(@PATH,41,3307.468,-871.4954,212.0422,0,0,0,0,100,0), +(@PATH,42,3309.218,-872.7454,213.2922,0,0,0,0,100,0), +(@PATH,43,3309.968,-873.4954,214.2922,0,0,0,0,100,0), +(@PATH,44,3310.718,-873.9954,215.5422,0,0,0,0,100,0), +(@PATH,45,3312.218,-875.2454,216.5422,0,0,0,0,100,0), +(@PATH,46,3313.968,-876.2454,218.0422,0,0,0,0,100,0), +(@PATH,47,3315.218,-877.4954,219.0422,0,0,0,0,100,0), +(@PATH,48,3316.718,-878.7454,220.7922,0,0,0,0,100,0), +(@PATH,49,3318.218,-879.9954,221.7922,0,0,0,0,100,0), +(@PATH,50,3319.968,-881.2454,223.2922,0,0,0,0,100,0), +(@PATH,51,3321.468,-882.4954,224.0422,0,0,0,0,100,0), +(@PATH,52,3322.968,-883.7454,225.2922,0,0,0,0,100,0), +(@PATH,53,3324.718,-884.9954,225.7922,0,0,0,0,100,0), +(@PATH,54,3326.218,-886.2454,227.2922,0,0,0,0,100,0), +(@PATH,55,3326.493,-886.0625,227.5658,0,0,0,0,100,0), +(@PATH,56,3327.993,-887.3125,228.0658,0,0,0,0,100,0), +(@PATH,57,3328.493,-885.5625,228.8158,0,0,0,0,100,0), +(@PATH,58,3329.743,-881.5625,229.3158,0,0,0,0,100,0), +(@PATH,59,3330.493,-877.8125,230.0658,0,0,0,0,100,0), +(@PATH,60,3331.243,-875.0625,230.8158,0,0,0,0,100,0), +(@PATH,61,3332.243,-871.3125,232.0658,0,0,0,0,100,0), +(@PATH,62,3333.493,-867.3125,232.8158,0,0,0,0,100,0), +(@PATH,63,3332.181,-871.8014,231.0136,0,0,0,0,100,0), +(@PATH,64,3331.181,-875.5514,230.0136,0,0,0,0,100,0), +(@PATH,65,3330.431,-879.3014,229.2636,0,0,0,0,100,0), +(@PATH,66,3329.181,-883.0514,228.7636,0,0,0,0,100,0), +(@PATH,67,3328.181,-887.0514,228.0136,0,0,0,0,100,0), +(@PATH,68,3327.83,-887.0072,227.7905,0,0,0,0,100,0), +(@PATH,69,3327.83,-887.5072,227.7905,0,0,0,0,100,0), +(@PATH,70,3325.33,-885.5072,226.5405,0,0,0,0,100,0), +(@PATH,71,3323.83,-884.2572,225.2905,0,0,0,0,100,0), +(@PATH,72,3322.33,-883.0072,224.5405,0,0,0,0,100,0), +(@PATH,73,3320.83,-881.7572,223.2905,0,0,0,0,100,0), +(@PATH,74,3319.08,-880.5072,222.5405,0,0,0,0,100,0), +(@PATH,75,3317.58,-879.2572,221.0405,0,0,0,0,100,0), +(@PATH,76,3316.08,-878.2572,220.0405,0,0,0,0,100,0), +(@PATH,77,3314.58,-877.2572,218.5405,0,0,0,0,100,0), +(@PATH,78,3313.08,-876.0072,217.2905,0,0,0,0,100,0), +(@PATH,79,3311.58,-874.7572,215.5405,0,0,0,0,100,0), +(@PATH,80,3309.83,-873.5072,214.2905,0,0,0,0,100,0), +(@PATH,81,3309.08,-872.7572,213.2905,0,0,0,0,100,0), +(@PATH,82,3306.83,-871.0072,211.2905,0,0,0,0,100,0), +(@PATH,83,3305.33,-869.7572,209.2905,0,0,0,0,100,0), +(@PATH,84,3305.1,-869.5022,208.8683,0,0,0,0,100,0), +(@PATH,85,3303.35,-868.2522,207.8683,0,0,0,0,100,0), +(@PATH,86,3303.1,-866.2522,206.3683,0,0,0,0,100,0), +(@PATH,87,3302.1,-862.5022,205.6183,0,0,0,0,100,0), +(@PATH,88,3302.1,-861.5022,204.3683,0,0,0,0,100,0), +(@PATH,89,3301.6,-859.5022,203.8683,0,0,0,0,100,0), +(@PATH,90,3301.35,-856.5022,202.1183,0,0,0,0,100,0), +(@PATH,91,3300.85,-854.7522,201.8683,0,0,0,0,100,0), +(@PATH,92,3300.35,-851.7522,201.1183,0,0,0,0,100,0), +(@PATH,93,3300.1,-850.7522,199.8683,0,0,0,0,100,0), +(@PATH,94,3299.6,-849.0022,199.3683,0,0,0,0,100,0), +(@PATH,95,3299.1,-846.0022,197.6183,0,0,0,0,100,0), +(@PATH,96,3298.6,-844.0022,196.8683,0,0,0,0,100,0), +(@PATH,97,3298.35,-842.0022,196.1183,0,0,0,0,100,0), +(@PATH,98,3298.344,-843.8044,196.7632,0,0,0,0,100,0), +(@PATH,99,3298.094,-841.8044,196.0132,0,0,0,0,100,0), +(@PATH,100,3298.094,-841.3044,195.2632,0,0,0,0,100,0), +(@PATH,101,3297.844,-840.3044,194.5132,0,0,0,0,100,0), +(@PATH,102,3297.094,-837.3044,193.7632,0,0,0,0,100,0), +(@PATH,103,3296.594,-835.5544,192.5132,0,0,0,0,100,0), +(@PATH,104,3296.094,-832.5544,191.7632,0,0,0,0,100,0), +(@PATH,105,3295.594,-830.8044,190.7632,0,0,0,0,100,0), +(@PATH,106,3295.344,-827.8044,190.2632,0,0,0,0,100,0), +(@PATH,107,3294.594,-825.0544,188.7632,0,0,0,0,100,0), +(@PATH,108,3293.844,-822.0544,187.2632,0,0,0,0,100,0), +(@PATH,109,3293.594,-820.0544,186.5132,0,0,0,0,100,0), +(@PATH,110,3293.094,-818.0544,186.0132,0,0,0,0,100,0), +(@PATH,111,3299.079,-842.8573,196.5311,0,0,0,0,100,0), +(@PATH,112,3298.536,-844.3997,196.6539,0,0,0,0,100,0); |