diff options
| -rw-r--r-- | sql/updates/world/2015_06_03_00_world.sql | 1292 |
1 files changed, 1292 insertions, 0 deletions
diff --git a/sql/updates/world/2015_06_03_00_world.sql b/sql/updates/world/2015_06_03_00_world.sql new file mode 100644 index 00000000000..31461906117 --- /dev/null +++ b/sql/updates/world/2015_06_03_00_world.sql @@ -0,0 +1,1292 @@ +-- Howling Fjord Movement + +UPDATE `creature` SET `spawndist`=10 WHERE `id`=23688; + +SET @NPC := 101946; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=927.8899,`position_y`=-3969.919,`position_z`=170.7422 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,927.8899,-3969.919,170.7422,0,0,0,0,100,0), +(@PATH,2,930.6399,-3968.669,169.9922,0,0,0,0,100,0), +(@PATH,3,934.3899,-3967.169,169.4922,0,0,0,0,100,0), +(@PATH,4,938.1399,-3965.669,168.9922,0,0,0,0,100,0), +(@PATH,5,943.3899,-3963.669,168.2422,0,0,0,0,100,0), +(@PATH,6,947.1399,-3962.169,167.7422,0,0,0,0,100,0), +(@PATH,7,950.8899,-3960.669,166.9922,0,0,0,0,100,0), +(@PATH,8,956.2105,-3958.292,166.6173,5.445427,5000,0,0,100,0), +(@PATH,9,947.8899,-3961.669,167.7422,0,0,0,0,100,0), +(@PATH,10,944.1399,-3963.169,168.2422,0,0,0,0,100,0), +(@PATH,11,941.3899,-3964.419,168.9922,0,0,0,0,100,0), +(@PATH,12,934.3899,-3967.169,169.4922,0,0,0,0,100,0), +(@PATH,13,930.6399,-3968.669,169.9922,0,0,0,0,100,0), +(@PATH,14,928.6399,-3969.419,170.7422,0,0,0,0,100,0), +(@PATH,15,925.1399,-3971.169,171.2422,0,0,0,0,100,0), +(@PATH,16,956.2105,-3958.292,166.6173,5.445427,5000,0,0,100,0); + +SET @NPC := 101951; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=979.7703,`position_y`=-3850.171,`position_z`=171.9575 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,979.7703,-3850.171,171.9575,0,0,0,0,100,0), +(@PATH,2,979.7703,-3848.671,171.9575,0,0,0,0,100,0), +(@PATH,3,978.7703,-3835.671,171.4575,0,0,0,0,100,0), +(@PATH,4,978.5203,-3824.171,171.2075,0,0,0,0,100,0), +(@PATH,5,981.0203,-3841.671,171.9575,0,0,0,0,100,0), +(@PATH,6,980.7703,-3847.421,171.9575,0,0,0,0,100,0), +(@PATH,7,982.0203,-3851.171,173.7075,0,0,0,0,100,0), +(@PATH,8,982.2703,-3851.421,173.7075,0,0,0,0,100,0), +(@PATH,9,979.7703,-3850.171,171.9575,0,0,0,0,100,0), +(@PATH,10,979.7703,-3848.671,171.9575,0,0,0,0,100,0), +(@PATH,11,978.7703,-3835.671,171.4575,0,0,0,0,100,0); + +SET @NPC := 101956; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1058.318,`position_y`=-3876.585,`position_z`=158.9284 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,1058.318,-3876.585,158.9284,0,0,0,0,100,0), +(@PATH,2,1060.318,-3871.835,159.4284,0,0,0,0,100,0), +(@PATH,3,1063.068,-3865.335,159.6784,0,0,0,0,100,0), +(@PATH,4,1070.068,-3848.085,160.1784,0,0,0,0,100,0), +(@PATH,5,1071.568,-3844.335,160.9284,0,0,0,0,100,0), +(@PATH,6,1058.318,-3876.585,158.92,0,0,0,0,100,0); + +SET @NPC := 101945; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=975.5112,`position_y`=-3966.148,`position_z`=164.4601 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,975.5112,-3966.148,164.4601,0,0,0,0,100,0), +(@PATH,2,975.5112,-3962.148,164.7101,0,0,0,0,100,0), +(@PATH,3,975.5112,-3956.398,165.4601,0,0,0,0,100,0), +(@PATH,4,975.4099,-3952.235,165.9376,0,0,0,0,100,0), +(@PATH,5,972.9099,-3949.235,166.4376,0,0,0,0,100,0), +(@PATH,6,969.6599,-3945.485,166.9376,0,0,0,0,100,0), +(@PATH,7,966.6599,-3941.735,167.6876,0,0,0,0,100,0), +(@PATH,8,964.6599,-3939.485,168.1876,0,0,0,0,100,0), +(@PATH,9,964.4403,-3939.255,168.5444,0,0,0,0,100,0), +(@PATH,10,963.9403,-3938.255,168.5444,0,0,0,0,100,0), +(@PATH,11,962.1903,-3935.755,169.0444,0,0,0,0,100,0), +(@PATH,12,959.9403,-3932.505,169.5444,0,0,0,0,100,0), +(@PATH,13,958.4403,-3930.255,170.2944,0,0,0,0,100,0), +(@PATH,14,956.4403,-3927.005,171.0444,0,0,0,0,100,0), +(@PATH,15,954.1903,-3923.755,171.7944,0,0,0,0,100,0), +(@PATH,16,954.1,-3923.376,172.0369,0,0,0,0,100,0), +(@PATH,17,953.35,-3922.126,172.0369,0,0,0,0,100,0), +(@PATH,18,958.1,-3917.376,173.0369,0,0,0,0,100,0), +(@PATH,19,960.1,-3915.376,173.5369,0,0,0,0,100,0), +(@PATH,20,961.6,-3913.876,174.0369,0,0,0,0,100,0), +(@PATH,21,963.6,-3911.876,174.7869,0,0,0,0,100,0), +(@PATH,22,966.9103,-3920.505,174.0948,0,0,0,0,100,0), +(@PATH,23,967.1603,-3922.505,173.3448,0,0,0,0,100,0), +(@PATH,24,967.6603,-3924.505,172.3448,0,0,0,0,100,0), +(@PATH,25,967.9103,-3926.505,170.8448,0,0,0,0,100,0), +(@PATH,26,968.4103,-3928.255,169.8448,0,0,0,0,100,0), +(@PATH,27,968.9103,-3931.255,168.8448,0,0,0,0,100,0), +(@PATH,28,969.1603,-3933.255,167.8448,0,0,0,0,100,0), +(@PATH,29,970.1603,-3938.255,166.8448,0,0,0,0,100,0), +(@PATH,30,972.4103,-3951.755,166.3448,0,0,0,0,100,0), +(@PATH,31,973.6603,-3958.505,165.5948,0,0,0,0,100,0), +(@PATH,32,974.4103,-3962.505,165.0948,0,0,0,0,100,0), +(@PATH,33,975.1603,-3965.505,164.3448,0,0,0,0,100,0); + +SET @NPC := 101947; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1032.128,`position_y`=-3930.062,`position_z`=158.6895 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,1032.128,-3930.062,158.6895,0,0,0,0,100,0), +(@PATH,2,1026.378,-3931.562,159.1895,0,0,0,0,100,0), +(@PATH,3,1020.378,-3933.062,159.6895,0,0,0,0,100,0), +(@PATH,4,999.4692,-3938.845,160.318,0,0,0,0,100,0), +(@PATH,5,996.7192,-3939.595,161.068,0,0,0,0,100,0), +(@PATH,6,992.7192,-3940.345,161.818,0,0,0,0,100,0), +(@PATH,7,988.9692,-3940.845,162.568,0,0,0,0,100,0), +(@PATH,8,985.9692,-3941.345,163.068,0,0,0,0,100,0), +(@PATH,9,982.9692,-3941.845,163.818,0,0,0,0,100,0), +(@PATH,10,980.2192,-3942.345,164.568,0,0,0,0,100,0), +(@PATH,11,979.8235,-3942.341,164.8509,0,0,0,0,100,0), +(@PATH,12,976.8235,-3942.841,165.6009,0,0,0,0,100,0), +(@PATH,13,973.3235,-3941.091,166.3509,0,0,0,0,100,0), +(@PATH,14,970.8235,-3939.841,166.6009,0,0,0,0,100,0), +(@PATH,15,967.3235,-3938.341,167.3509,0,0,0,0,100,0), +(@PATH,16,965.5735,-3937.341,167.8509,0,0,0,0,100,0), +(@PATH,17,962.8235,-3936.091,168.6009,0,0,0,0,100,0), +(@PATH,18,962.4893,-3935.881,168.7721,0,0,0,0,100,0), +(@PATH,19,960.9893,-3934.881,169.5221,0,0,0,0,100,0), +(@PATH,20,957.7393,-3932.631,170.2721,0,0,0,0,100,0), +(@PATH,21,956.4893,-3931.631,170.7721,0,0,0,0,100,0), +(@PATH,22,953.9893,-3929.881,171.2721,0,0,0,0,100,0), +(@PATH,23,950.7393,-3927.631,172.2721,0,0,0,0,100,0), +(@PATH,24,948.5079,-3926.027,172.644,0,0,0,0,100,0), +(@PATH,25,946.0079,-3913.527,173.394,0,0,0,0,100,0), +(@PATH,26,943.5978,-3902.703,173.2859,0,0,0,0,100,0), +(@PATH,27,946.8478,-3893.203,172.7859,0,0,0,0,100,0), +(@PATH,28,952.3478,-3876.453,173.0359,0,0,0,0,100,0), +(@PATH,29,952.748,-3876.235,173.0832,0,0,0,0,100,0), +(@PATH,30,953.248,-3874.985,173.0832,0,0,0,0,100,0), +(@PATH,31,962.498,-3857.735,172.5832,0,0,0,0,100,0), +(@PATH,32,966.998,-3849.735,172.3332,0,0,0,0,100,0), +(@PATH,33,969.6388,-3844.943,171.9659,0,0,0,0,100,0), +(@PATH,34,996.8723,-3834.379,171.2563,0,0,0,0,100,0), +(@PATH,35,1001.622,-3835.879,170.5063,0,0,0,0,100,0), +(@PATH,36,1006.372,-3837.629,170.0063,0,0,0,0,100,0), +(@PATH,37,1009.872,-3838.879,169.2563,0,0,0,0,100,0), +(@PATH,38,1013.622,-3839.879,168.7563,0,0,0,0,100,0), +(@PATH,39,1019.372,-3841.879,168.2563,0,0,0,0,100,0), +(@PATH,40,1021.935,-3842.818,167.5684,0,0,0,0,100,0), +(@PATH,41,1024.685,-3848.318,167.0684,0,0,0,0,100,0), +(@PATH,42,1026.435,-3851.818,166.3184,0,0,0,0,100,0), +(@PATH,43,1027.935,-3855.068,165.5684,0,0,0,0,100,0), +(@PATH,44,1029.185,-3857.818,165.0684,0,0,0,0,100,0), +(@PATH,45,1030.685,-3860.568,164.5684,0,0,0,0,100,0), +(@PATH,46,1032.435,-3864.068,163.5684,0,0,0,0,100,0), +(@PATH,47,1033.685,-3866.818,162.8184,0,0,0,0,100,0), +(@PATH,48,1034.036,-3867.004,162.5863,0,0,0,0,100,0), +(@PATH,49,1034.536,-3868.004,162.5863,0,0,0,0,100,0), +(@PATH,50,1035.036,-3871.004,161.8363,0,0,0,0,100,0), +(@PATH,51,1035.786,-3874.754,161.3363,0,0,0,0,100,0), +(@PATH,52,1036.786,-3878.754,160.5863,0,0,0,0,100,0), +(@PATH,53,1037.286,-3882.754,160.0863,0,0,0,0,100,0), +(@PATH,54,1037.786,-3885.254,159.3363,0,0,0,0,100,0), +(@PATH,55,1039.036,-3890.254,158.8363,0,0,0,0,100,0), +(@PATH,56,1041.24,-3901.999,158.2805,0,0,0,0,100,0); + +SET @NPC := 101952; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1009.311,`position_y`=-3977.181,`position_z`=159.2175 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,1009.311,-3977.181,159.2175,0,0,0,0,100,0), +(@PATH,2,1006.561,-3977.931,159.9675,0,0,0,0,100,0), +(@PATH,3,1004.561,-3978.681,160.4675,0,0,0,0,100,0), +(@PATH,4,999.8114,-3980.181,160.9675,0,0,0,0,100,0), +(@PATH,5,995.0614,-3981.681,160.4675,0,0,0,0,100,0), +(@PATH,6,993.0614,-3982.181,159.7175,0,0,0,0,100,0), +(@PATH,7,977.0614,-3986.931,160.7175,0,0,0,0,100,0), +(@PATH,8,975.3114,-3987.431,161.2175,0,0,0,0,100,0), +(@PATH,9,972.3114,-3988.431,162.2175,0,0,0,0,100,0), +(@PATH,10,969.5614,-3989.181,162.9675,0,0,0,0,100,0), +(@PATH,11,966.5614,-3990.181,163.4675,0,0,0,0,100,0), +(@PATH,12,966.4469,-3990.32,163.3618,0,0,0,0,100,0), +(@PATH,13,920.9092,-3981.829,168.1994,0,0,0,0,100,0), +(@PATH,14,910.6589,-3959.608,175.5765,0,0,0,0,100,0), +(@PATH,15,909.9501,-3956.44,176.6253,0,0,0,0,100,0), +(@PATH,16,908.9501,-3951.44,177.1253,0,0,0,0,100,0), +(@PATH,17,907.4501,-3942.94,177.8753,0,0,0,0,100,0), +(@PATH,18,906.4501,-3938.19,178.1253,0,0,0,0,100,0), +(@PATH,19,905.7001,-3935.19,178.8753,0,0,0,0,100,0), +(@PATH,20,905.2001,-3933.19,179.6253,0,0,0,0,100,0), +(@PATH,21,904.1555,-3929.11,180.5247,0,0,0,0,100,0), +(@PATH,22,903.9055,-3927.11,181.0247,0,0,0,0,100,0), +(@PATH,23,903.1555,-3920.11,181.5247,0,0,0,0,100,0), +(@PATH,24,900.5728,-3898.769,181.7251,0,0,0,0,100,0), +(@PATH,25,900.5728,-3892.769,181.2251,0,0,0,0,100,0), +(@PATH,26,900.5728,-3881.019,181.7251,0,0,0,0,100,0), +(@PATH,27,901.0697,-3865.9,181.5738,0,0,0,0,100,0), +(@PATH,28,903.5697,-3858.15,180.8238,0,0,0,0,100,0), +(@PATH,29,911.6938,-3832.919,180.3241,0,0,0,0,100,0), +(@PATH,30,915.1938,-3829.169,179.5741,0,0,0,0,100,0), +(@PATH,31,918.6938,-3825.419,179.0741,0,0,0,0,100,0), +(@PATH,32,922.6938,-3821.419,178.5741,0,0,0,0,100,0), +(@PATH,33,941.0022,-3801.417,177.5542,0,0,0,0,100,0), +(@PATH,34,949.5022,-3792.167,177.0542,0,0,0,0,100,0), +(@PATH,35,957.5022,-3783.417,177.5542,0,0,0,0,100,0), +(@PATH,36,961.7522,-3778.917,177.0542,0,0,0,0,100,0), +(@PATH,37,964.6654,-3775.584,176.2806,0,0,0,0,100,0), +(@PATH,38,967.4154,-3774.834,175.7806,0,0,0,0,100,0), +(@PATH,39,972.1654,-3773.334,175.0306,0,0,0,0,100,0), +(@PATH,40,977.1654,-3772.084,174.5306,0,0,0,0,100,0), +(@PATH,41,980.6654,-3771.084,173.7806,0,0,0,0,100,0), +(@PATH,42,983.4154,-3770.334,173.5306,0,0,0,0,100,0), +(@PATH,43,987.4154,-3769.084,172.7806,0,0,0,0,100,0), +(@PATH,44,991.1654,-3768.084,172.0306,0,0,0,0,100,0), +(@PATH,45,995.1654,-3766.834,171.2806,0,0,0,0,100,0), +(@PATH,46,995.1761,-3766.911,171.2581,0,0,0,0,100,0), +(@PATH,47,998.4261,-3765.911,170.7581,0,0,0,0,100,0), +(@PATH,48,1002.426,-3768.911,170.2581,0,0,0,0,100,0), +(@PATH,49,1007.926,-3773.161,169.7581,0,0,0,0,100,0), +(@PATH,50,1012.426,-3776.661,169.2581,0,0,0,0,100,0), +(@PATH,51,1021.532,-3783.58,168.6249,0,0,0,0,100,0), +(@PATH,52,1022.782,-3801.33,168.1249,0,0,0,0,100,0), +(@PATH,53,1023.032,-3805.33,167.3749,0,0,0,0,100,0), +(@PATH,54,1023.282,-3810.33,167.1249,0,0,0,0,100,0), +(@PATH,55,1023.89,-3814.808,166.4063,0,0,0,0,100,0), +(@PATH,56,1026.39,-3819.058,165.6563,0,0,0,0,100,0), +(@PATH,57,1030.64,-3826.058,164.9063,0,0,0,0,100,0), +(@PATH,58,1034.39,-3832.558,164.6563,0,0,0,0,100,0), +(@PATH,59,1037.64,-3837.558,163.9063,0,0,0,0,100,0), +(@PATH,60,1040.64,-3842.808,163.1563,0,0,0,0,100,0), +(@PATH,61,1040.951,-3842.979,162.8698,0,0,0,0,100,0), +(@PATH,62,1041.201,-3843.479,162.8698,0,0,0,0,100,0), +(@PATH,63,1043.201,-3845.979,162.3698,0,0,0,0,100,0), +(@PATH,64,1046.201,-3849.729,161.6198,0,0,0,0,100,0), +(@PATH,65,1049.451,-3853.729,161.1198,0,0,0,0,100,0), +(@PATH,66,1052.451,-3857.229,160.6198,0,0,0,0,100,0), +(@PATH,67,1058.701,-3864.979,159.8698,0,0,0,0,100,0), +(@PATH,68,1060.563,-3867.256,159.5396,0,0,0,0,100,0), +(@PATH,69,1073.106,-3885.358,159.802,0,0,0,0,100,0), +(@PATH,70,1073.606,-3892.358,159.302,0,0,0,0,100,0), +(@PATH,71,1073.606,-3897.358,158.552,0,0,0,0,100,0), +(@PATH,72,1073.856,-3900.108,158.052,0,0,0,0,100,0), +(@PATH,73,1073.856,-3903.108,157.302,0,0,0,0,100,0), +(@PATH,74,1074.106,-3906.108,156.552,0,0,0,0,100,0), +(@PATH,75,1074.356,-3912.108,156.052,0,0,0,0,100,0), +(@PATH,76,1074.392,-3912.441,155.8847,0,0,0,0,100,0), +(@PATH,77,1074.392,-3914.441,155.6347,0,0,0,0,100,0), +(@PATH,78,1072.642,-3920.191,156.6347,0,0,0,0,100,0), +(@PATH,79,1071.642,-3924.191,157.3847,0,0,0,0,100,0), +(@PATH,80,1070.142,-3929.691,156.6347,0,0,0,0,100,0), +(@PATH,81,1069.642,-3931.691,155.8847,0,0,0,0,100,0), +(@PATH,82,1069.142,-3933.441,155.6347,0,0,0,0,100,0), +(@PATH,83,1066.642,-3942.191,155.8847,0,0,0,0,100,0), +(@PATH,84,1066.515,-3942.463,156.21,0,0,0,0,100,0), +(@PATH,85,1066.015,-3943.963,155.96,0,0,0,0,100,0), +(@PATH,86,1062.765,-3946.463,155.21,0,0,0,0,100,0), +(@PATH,87,1060.515,-3948.213,154.71,0,0,0,0,100,0), +(@PATH,88,1055.015,-3952.213,155.21,0,0,0,0,100,0), +(@PATH,89,1052.015,-3954.713,155.96,0,0,0,0,100,0), +(@PATH,90,1048.015,-3957.713,156.21,0,0,0,0,100,0), +(@PATH,91,1043.265,-3961.463,156.96,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=99047; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(99047, 99047, 0, 0, 2, 0, 0), +(99047, 99046, 3, 90, 2, 0, 0); + +SET @NPC := 99047; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1352.596,`position_y`=-3317.135,`position_z`=175.7527 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,1352.596,-3317.135,175.7527,0,0,0,0,100,0), +(@PATH,2,1352.846,-3318.135,175.5027,0,0,0,0,100,0), +(@PATH,3,1355.096,-3321.385,175.0027,0,0,0,0,100,0), +(@PATH,4,1361.346,-3331.921,174.2863,0,0,0,0,100,0), +(@PATH,5,1368.772,-3335.16,174.379,0,0,0,0,100,0), +(@PATH,6,1371.772,-3332.91,173.629,0,0,0,0,100,0), +(@PATH,7,1372.086,-3332.915,173.6307,0,0,0,0,100,0), +(@PATH,8,1375.086,-3330.665,173.1307,0,0,0,0,100,0), +(@PATH,9,1376.586,-3327.165,172.6307,0,0,0,0,100,0), +(@PATH,10,1377.336,-3325.665,171.8807,0,0,0,0,100,0), +(@PATH,11,1378.336,-3323.665,171.6307,0,0,0,0,100,0), +(@PATH,12,1379.586,-3321.165,170.8807,0,0,0,0,100,0), +(@PATH,13,1380.336,-3319.165,170.1307,0,0,0,0,100,0), +(@PATH,14,1379.744,-3320.841,170.706,0,0,0,0,100,0), +(@PATH,15,1380.744,-3319.091,169.956,0,0,0,0,100,0), +(@PATH,16,1380.994,-3318.091,169.706,0,0,0,0,100,0), +(@PATH,17,1382.744,-3315.591,169.206,0,0,0,0,100,0), +(@PATH,18,1383.994,-3313.341,168.706,0,0,0,0,100,0), +(@PATH,19,1385.994,-3309.841,167.956,0,0,0,0,100,0), +(@PATH,20,1386.362,-3309.63,167.6397,0,0,0,0,100,0), +(@PATH,21,1387.362,-3307.88,166.8897,0,0,0,0,100,0), +(@PATH,22,1388.612,-3304.38,166.6397,0,0,0,0,100,0), +(@PATH,23,1390.362,-3299.63,166.1397,0,0,0,0,100,0), +(@PATH,24,1390.417,-3299.402,165.8224,0,0,0,0,100,0), +(@PATH,25,1390.917,-3297.652,165.5724,0,0,0,0,100,0), +(@PATH,26,1389.917,-3291.902,165.0724,0,0,0,0,100,0), +(@PATH,27,1389.167,-3287.152,164.8224,0,0,0,0,100,0), +(@PATH,28,1388.186,-3282.564,164.0677,0,0,0,0,100,0), +(@PATH,29,1385.936,-3277.064,163.3177,0,0,0,0,100,0), +(@PATH,30,1383.686,-3270.814,163.0677,0,0,0,0,100,0), +(@PATH,31,1382.133,-3267.18,162.5711,0,0,0,0,100,0), +(@PATH,32,1378.133,-3258.18,162.0711,0,0,0,0,100,0), +(@PATH,33,1376.566,-3255.339,161.3748,0,0,0,0,100,0), +(@PATH,34,1372.202,-3242.191,161.2437,0,0,0,0,100,0), +(@PATH,35,1374.132,-3234.525,161.0977,0,0,0,0,100,0), +(@PATH,36,1378.753,-3225.88,160.9582,0,0,0,0,100,0), +(@PATH,37,1385.115,-3220.81,160.7566,0,0,0,0,100,0), +(@PATH,38,1394.127,-3217.729,161.1154,0,0,0,0,100,0), +(@PATH,39,1403.856,-3222.575,161.4398,0,0,0,0,100,0), +(@PATH,40,1411.606,-3232.575,161.6898,0,0,0,0,100,0), +(@PATH,41,1414.666,-3236.515,162.3234,0,0,0,0,100,0), +(@PATH,42,1414.666,-3247.265,162.8234,0,0,0,0,100,0), +(@PATH,43,1414.771,-3252.424,163.2726,0,0,0,0,100,0), +(@PATH,44,1414.021,-3258.174,164.0226,0,0,0,0,100,0), +(@PATH,45,1414.021,-3262.174,164.5226,0,0,0,0,100,0), +(@PATH,46,1413.521,-3265.174,165.2726,0,0,0,0,100,0), +(@PATH,47,1413.733,-3262.417,164.6622,0,0,0,0,100,0), +(@PATH,48,1413.233,-3265.417,165.1622,0,0,0,0,100,0), +(@PATH,49,1413.233,-3265.917,165.4122,0,0,0,0,100,0), +(@PATH,50,1411.233,-3269.417,165.9122,0,0,0,0,100,0), +(@PATH,51,1405.778,-3279.358,166.6208,0,0,0,0,100,0), +(@PATH,52,1404.778,-3288.358,167.1208,0,0,0,0,100,0), +(@PATH,53,1403.408,-3298.71,167.5344,0,0,0,0,100,0), +(@PATH,54,1406.908,-3305.46,167.7844,0,0,0,0,100,0), +(@PATH,55,1408.95,-3309.012,168.17,0,0,0,0,100,0), +(@PATH,56,1408.2,-3316.762,168.67,0,0,0,0,100,0), +(@PATH,57,1408.067,-3316.934,169.0204,0,0,0,0,100,0), +(@PATH,58,1407.817,-3319.934,169.0204,0,0,0,0,100,0), +(@PATH,59,1401.817,-3329.684,169.5204,0,0,0,0,100,0), +(@PATH,60,1401.465,-3330.132,169.6485,0,0,0,0,100,0), +(@PATH,61,1400.465,-3331.882,169.8985,0,0,0,0,100,0), +(@PATH,62,1398.465,-3332.632,170.6485,0,0,0,0,100,0), +(@PATH,63,1396.715,-3333.382,171.3985,0,0,0,0,100,0), +(@PATH,64,1394.715,-3333.882,171.8985,0,0,0,0,100,0), +(@PATH,65,1392.215,-3334.882,172.6485,0,0,0,0,100,0), +(@PATH,66,1390.465,-3335.632,173.3985,0,0,0,0,100,0), +(@PATH,67,1388.465,-3336.382,174.1485,0,0,0,0,100,0), +(@PATH,68,1385.107,-3337.809,174.7894,0,0,0,0,100,0), +(@PATH,69,1364.671,-3338.77,175.1342,0,0,0,0,100,0), +(@PATH,70,1360.421,-3336.52,174.6342,0,0,0,0,100,0), +(@PATH,71,1341.321,-3326.252,174.5247,0,0,0,0,100,0), +(@PATH,72,1330.708,-3317.201,174.4075,0,0,0,0,100,0), +(@PATH,73,1327.478,-3307.686,174.2973,0,0,0,0,100,0), +(@PATH,74,1335.477,-3296.597,174.7568,0,0,0,0,100,0), +(@PATH,75,1345.069,-3297.623,175.08,0,0,0,0,100,0), +(@PATH,76,1348.569,-3303.373,175.33,0,0,0,0,100,0); + +SET @NPC := 105163; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1314.033,`position_y`=-3284.895,`position_z`=177.2863 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,1314.033,-3284.895,177.2863,0,0,0,0,100,0), +(@PATH,2,1316.033,-3285.895,177.2863,0,0,0,0,100,0), +(@PATH,3,1320.642,-3287.875,177.2982,0,0,0,0,100,0), +(@PATH,4,1320.985,-3287.746,177.2938,0,0,0,0,100,0), +(@PATH,5,1323.485,-3286.746,177.2938,0,0,0,0,100,0), +(@PATH,6,1323.367,-3286.639,177.2937,0,0,0,0,100,0), +(@PATH,7,1322.867,-3284.389,177.2937,0,0,0,0,100,0), +(@PATH,8,1322.852,-3284.283,177.303,0,0,0,0,100,0), +(@PATH,9,1320.102,-3282.033,177.303,0,0,0,0,100,0), +(@PATH,10,1320.102,-3280.283,177.303,0,0,0,0,100,0), +(@PATH,11,1319.962,-3280.097,177.1187,0,0,0,0,100,0), +(@PATH,12,1319.962,-3278.597,177.1187,0,0,0,0,100,0), +(@PATH,13,1323.462,-3275.097,177.3687,0,0,0,0,100,0), +(@PATH,14,1323.749,-3275.225,177.2502,0,0,0,0,100,0), +(@PATH,15,1325.999,-3272.975,177.2502,0,0,0,0,100,0), +(@PATH,16,1326.999,-3273.225,177.2502,0,0,0,0,100,0), +(@PATH,17,1328.249,-3273.725,178.0002,0,0,0,0,100,0), +(@PATH,18,1329.499,-3273.975,177.5002,0,0,0,0,100,0), +(@PATH,19,1331.643,-3274.349,176.4724,0,0,0,0,100,0), +(@PATH,20,1331.893,-3274.849,176.4724,0,0,0,0,100,0), +(@PATH,21,1334.272,-3278.162,175.0519,0,0,0,0,100,0), +(@PATH,22,1335.352,-3285.597,174.7435,0,0,0,0,100,0), +(@PATH,23,1332.486,-3294.855,174.5798,0,0,0,0,100,0), +(@PATH,24,1326.069,-3300.929,174.3962,0,0,0,0,100,0), +(@PATH,25,1318.966,-3298.954,174.0869,0,0,0,0,100,0), +(@PATH,26,1320.198,-3299.569,174.0601,0.9072711,5000,0,0,100,0), +(@PATH,27,1313.834,-3295.061,174.0218,0,0,0,0,100,0), +(@PATH,28,1313.781,-3294.923,174.2718,0,0,0,0,100,0), +(@PATH,29,1306.196,-3291.011,174.1353,0,0,0,0,100,0), +(@PATH,30,1301.449,-3287.75,174.3227,0,0,0,0,100,0), +(@PATH,31,1298.332,-3283.436,174.3493,0,0,0,0,100,0), +(@PATH,32,1298.582,-3281.936,174.3493,0,0,0,0,100,0), +(@PATH,33,1298.582,-3280.936,174.3493,0,0,0,0,100,0), +(@PATH,34,1298.582,-3279.186,174.3493,0,0,0,0,100,0), +(@PATH,35,1298.582,-3278.186,174.3493,0,0,0,0,100,0), +(@PATH,36,1298.582,-3277.186,174.3493,0,0,0,0,100,0), +(@PATH,37,1298.582,-3276.186,175.5993,0,0,0,0,100,0), +(@PATH,38,1299.332,-3275.436,178.0993,0,0,0,0,100,0), +(@PATH,39,1300.332,-3275.436,177.3493,0,0,0,0,100,0), +(@PATH,40,1301.082,-3275.436,177.5993,0,0,0,0,100,0), +(@PATH,41,1300.295,-3275.392,177.3847,0,0,0,0,100,0), +(@PATH,42,1301.295,-3275.392,177.6347,0,0,0,0,100,0), +(@PATH,43,1301.795,-3273.642,177.6347,0,0,0,0,100,0), +(@PATH,44,1301.795,-3272.642,177.6347,0,0,0,0,100,0), +(@PATH,45,1301.295,-3270.892,178.6347,0,0,0,0,100,0), +(@PATH,46,1301.795,-3270.142,177.8847,0,0,0,0,100,0), +(@PATH,47,1302.295,-3269.142,177.1347,0,0,0,0,100,0), +(@PATH,48,1302.547,-3268.979,177.2808,0,0,0,0,100,0), +(@PATH,49,1304.297,-3266.479,176.7808,0,0,0,0,100,0), +(@PATH,50,1305.547,-3265.479,176.5308,0,0,0,0,100,0), +(@PATH,51,1304.049,-3266.798,176.6253,5.449048,5000,0,0,100,0), +(@PATH,52,1305.677,-3265.212,176.3015,0,0,0,0,100,0), +(@PATH,53,1308.03,-3262.957,176.0556,0,0,0,0,100,0), +(@PATH,54,1314.182,-3259.36,176.238,0,0,0,0,100,0), +(@PATH,55,1318.634,-3256.955,176.1925,0,0,0,0,100,0), +(@PATH,56,1323.134,-3258.455,175.6925,0,0,0,0,100,0), +(@PATH,57,1327.647,-3259.723,175.6314,0,0,0,0,100,0), +(@PATH,58,1333.397,-3263.223,176.1314,0,0,0,0,100,0), +(@PATH,59,1333.772,-3263.517,176.2016,0,0,0,0,100,0), +(@PATH,60,1334.772,-3264.017,176.2016,0,0,0,0,100,0), +(@PATH,61,1335.772,-3266.767,175.7016,0,0,0,0,100,0), +(@PATH,62,1337.677,-3270.589,175.1142,0,0,0,0,100,0), +(@PATH,63,1335.98,-3273.271,175.1552,0,0,0,0,100,0), +(@PATH,64,1331.23,-3272.271,177.6552,0,0,0,0,100,0), +(@PATH,65,1331.09,-3271.938,177.6541,0,0,0,0,100,0), +(@PATH,66,1329.34,-3271.438,178.1541,0,0,0,0,100,0), +(@PATH,67,1328.09,-3271.188,178.1541,0,0,0,0,100,0), +(@PATH,68,1325.09,-3270.438,177.4041,0,0,0,0,100,0), +(@PATH,69,1324.764,-3270.557,177.2338,0,0,0,0,100,0), +(@PATH,70,1322.764,-3270.057,177.2338,0,0,0,0,100,0), +(@PATH,71,1317.514,-3277.307,177.2338,0,0,0,0,100,0), +(@PATH,72,1317.209,-3277.242,177.3359,0,0,0,0,100,0), +(@PATH,73,1316.709,-3277.992,177.3359,0,0,0,0,100,0), +(@PATH,74,1314.959,-3277.992,177.3359,0,0,0,0,100,0), +(@PATH,75,1313.459,-3277.992,177.3359,0,0,0,0,100,0), +(@PATH,76,1310.157,-3278.081,177.2867,0,0,0,0,100,0), +(@PATH,77,1308.601,-3281.318,177.0479,0,0,0,0,100,0), +(@PATH,78,1312.434,-3284.332,177.2719,0,0,0,0,100,0); + +SET @NPC := 99206; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1443.603,`position_y`=-3374.807,`position_z`=202.0124 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,1443.603,-3374.807,202.0124,0,0,0,0,100,0), +(@PATH,2,1431.073,-3376.094,202.083,0,0,0,0,100,0), +(@PATH,3,1428.323,-3375.844,202.083,0,0,0,0,100,0), +(@PATH,4,1425.073,-3375.844,202.083,0,0,0,0,100,0), +(@PATH,5,1417.573,-3375.844,202.083,0,0,0,0,100,0), +(@PATH,6,1417.619,-3376.065,202.0903,0,0,0,0,100,0), +(@PATH,7,1425.119,-3376.065,202.0903,0,0,0,0,100,0), +(@PATH,8,1428.119,-3376.065,202.0903,0,0,0,0,100,0), +(@PATH,9,1428.388,-3376.034,202.0217,0,0,0,0,100,0), +(@PATH,10,1431.138,-3376.034,202.0217,0,0,0,0,100,0), +(@PATH,11,1443.388,-3374.784,202.0217,0,0,0,0,100,0), +(@PATH,12,1443.603,-3374.807,202.0124,0,0,0,0,100,0); + +SET @NPC := 99211; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1327.88,`position_y`=-3352.442,`position_z`=206.6393 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,1327.88,-3352.442,206.6393,0,0,0,0,100,0), +(@PATH,2,1313.845,-3345.21,206.7096,0,0,0,0,100,0), +(@PATH,3,1312.095,-3343.71,206.7096,0,0,0,0,100,0), +(@PATH,4,1305.595,-3337.46,206.7096,0,0,0,0,100,0), +(@PATH,5,1305.601,-3337.328,206.7189,0,0,0,0,100,0), +(@PATH,6,1312.101,-3343.578,206.7189,0,0,0,0,100,0), +(@PATH,7,1313.601,-3345.078,206.4689,0,0,0,0,100,0), +(@PATH,8,1313.91,-3345.258,206.6446,0,0,0,0,100,0), +(@PATH,9,1314.16,-3345.508,206.6446,0,0,0,0,100,0), +(@PATH,10,1327.91,-3352.258,206.6446,0,0,0,0,100,0), +(@PATH,11,1327.88,-3352.442,206.6393,0,0,0,0,100,0); + +DELETE FROM `creature_addon` WHERE `guid`=23967; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(23967,0,0,0,1,28, ''); + +SET @NPC := 110877; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1532.944,`position_y`=-3279.357,`position_z`=71.67763 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,1532.944,-3279.357,71.67763,0,0,0,0,100,0), +(@PATH,2,1532.944,-3275.857,71.92763,0,0,0,0,100,0), +(@PATH,3,1533.694,-3260.607,72.92763,0,0,0,0,100,0), +(@PATH,4,1533.569,-3260.329,72.7189,0,0,0,0,100,0), +(@PATH,5,1533.819,-3259.579,72.9689,0,0,0,0,100,0), +(@PATH,6,1532.569,-3253.829,73.7189,0,0,0,0,100,0), +(@PATH,7,1530.569,-3244.579,73.4689,0,0,0,0,100,0), +(@PATH,8,1529.518,-3240.977,73.08253,0,0,0,0,100,0), +(@PATH,9,1526.518,-3238.477,73.08253,0,0,0,0,100,0), +(@PATH,10,1518.018,-3230.977,72.83253,0,0,0,0,100,0), +(@PATH,11,1516.748,-3229.776,72.58502,0,0,0,0,100,0), +(@PATH,12,1511.498,-3218.776,71.33502,0,0,0,0,100,0), +(@PATH,13,1508.998,-3214.026,71.08502,0,0,0,0,100,0), +(@PATH,14,1508.758,-3213.916,70.89909,0,0,0,0,100,0), +(@PATH,15,1507.508,-3211.166,70.39909,0,0,0,0,100,0), +(@PATH,16,1507.008,-3209.916,70.39909,0,0,0,0,100,0), +(@PATH,17,1504.008,-3199.916,70.39909,0,0,0,0,100,0), +(@PATH,18,1504.023,-3199.926,70.09482,0,0,0,0,100,0), +(@PATH,19,1507.023,-3209.926,70.09482,0,0,0,0,100,0), +(@PATH,20,1507.378,-3210.156,70.4521,0,0,0,0,100,0), +(@PATH,21,1507.878,-3211.406,70.7021,0,0,0,0,100,0), +(@PATH,22,1509.128,-3214.156,71.2021,0,0,0,0,100,0), +(@PATH,23,1511.378,-3218.906,71.4521,0,0,0,0,100,0), +(@PATH,24,1517.049,-3230.168,72.55661,0,0,0,0,100,0), +(@PATH,25,1518.049,-3230.918,72.55661,0,0,0,0,100,0), +(@PATH,26,1526.549,-3238.418,73.05661,0,0,0,0,100,0), +(@PATH,27,1529.843,-3241.093,73.03035,0,0,0,0,100,0), +(@PATH,28,1530.343,-3244.593,73.53035,0,0,0,0,100,0), +(@PATH,29,1532.343,-3253.843,73.53035,0,0,0,0,100,0), +(@PATH,30,1533.649,-3259.643,72.98861,0,0,0,0,100,0), +(@PATH,31,1533.149,-3275.893,72.23861,0,0,0,0,100,0), +(@PATH,32,1532.815,-3279.69,71.46254,0,0,0,0,100,0), +(@PATH,33,1531.565,-3281.94,71.21254,0,0,0,0,100,0), +(@PATH,34,1529.565,-3285.44,70.46254,0,0,0,0,100,0), +(@PATH,35,1526.815,-3290.19,69.71254,0,0,0,0,100,0), +(@PATH,36,1524.315,-3294.94,69.21254,0,0,0,0,100,0), +(@PATH,37,1522.168,-3298.133,67.94553,0,0,0,0,100,0), +(@PATH,38,1520.618,-3300.794,67.22211,0,0,0,0,100,0), +(@PATH,39,1524.261,-3294.749,69.24005,0,0,0,0,100,0), +(@PATH,40,1526.761,-3290.249,69.74005,0,0,0,0,100,0), +(@PATH,41,1529.511,-3285.499,70.49005,0,0,0,0,100,0), +(@PATH,42,1531.761,-3281.749,71.24005,0,0,0,0,100,0); + +SET @NPC := 110924; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1747.995,`position_y`=-3324.951,`position_z`=79.9406 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,1747.995,-3324.951,79.9406,0,0,0,0,100,0), +(@PATH,2,1750.995,-3327.201,79.9406,0,0,0,0,100,0), +(@PATH,3,1755.311,-3330.136,80.52805,0,0,0,0,100,0), +(@PATH,4,1760.811,-3331.386,80.52805,0,0,0,0,100,0), +(@PATH,5,1765.561,-3332.386,81.27805,0,0,0,0,100,0), +(@PATH,6,1765.592,-3332.358,81.09067,0,0,0,0,100,0), +(@PATH,7,1761.092,-3331.608,80.59067,0,0,0,0,100,0), +(@PATH,8,1755.189,-3329.974,80.26764,0,0,0,0,100,0), +(@PATH,9,1751.189,-3327.224,80.01764,0,0,0,0,100,0), +(@PATH,10,1747.701,-3324.876,80.04713,0,0,0,0,100,0), +(@PATH,11,1733.692,-3319.658,79.812,0,0,0,0,100,0), +(@PATH,12,1728.442,-3317.408,79.812,0,0,0,0,100,0), +(@PATH,13,1724.692,-3315.658,80.062,0,0,0,0,100,0), +(@PATH,14,1724.233,-3315.486,80.27322,0,0,0,0,100,0), +(@PATH,15,1723.483,-3315.236,80.27322,0,0,0,0,100,0), +(@PATH,16,1714.733,-3307.736,80.77322,0,0,0,0,100,0), +(@PATH,17,1711.983,-3306.986,80.77322,0,0,0,0,100,0), +(@PATH,18,1709.983,-3306.236,81.02322,0,0,0,0,100,0), +(@PATH,19,1709.764,-3305.991,80.91532,0,0,0,0,100,0), +(@PATH,20,1708.764,-3305.491,80.91532,0,0,0,0,100,0), +(@PATH,21,1708.014,-3304.741,80.91532,0,0,0,0,100,0), +(@PATH,22,1706.264,-3303.241,80.66532,0,0,0,0,100,0), +(@PATH,23,1704.514,-3302.241,80.66532,0,0,0,0,100,0), +(@PATH,24,1703.514,-3301.991,80.66532,0,0,0,0,100,0), +(@PATH,25,1702.764,-3301.491,80.66532,0,0,0,0,100,0), +(@PATH,26,1702.425,-3301.247,80.54251,0,0,0,0,100,0), +(@PATH,27,1700.675,-3300.247,80.29251,0,0,0,0,100,0), +(@PATH,28,1700.675,-3299.747,80.04251,0,0,0,0,100,0), +(@PATH,29,1697.925,-3297.997,79.79251,0,0,0,0,100,0), +(@PATH,30,1696.425,-3296.997,79.79251,0,0,0,0,100,0), +(@PATH,31,1694.175,-3299.747,79.79251,0,0,0,0,100,0), +(@PATH,32,1693.17,-3294.564,79.41473,0,0,0,0,100,0), +(@PATH,33,1685.018,-3288.416,78.21511,0,0,0,0,100,0), +(@PATH,34,1682.018,-3285.916,77.71511,0,0,0,0,100,0), +(@PATH,35,1682.137,-3285.877,77.78119,0,0,0,0,100,0), +(@PATH,36,1682.398,-3286.077,78.10577,0,0,0,0,100,0), +(@PATH,37,1685.148,-3288.577,78.35577,0,0,0,0,100,0), +(@PATH,38,1693.437,-3294.908,79.48956,0,0,0,0,100,0), +(@PATH,39,1694.187,-3299.658,79.73956,0,0,0,0,100,0), +(@PATH,40,1695.937,-3301.158,79.73956,0,0,0,0,100,0), +(@PATH,41,1699.437,-3301.158,79.98956,0,0,0,0,100,0), +(@PATH,42,1699.437,-3301.158,80.48956,0,0,0,0,100,0), +(@PATH,43,1699.633,-3301.397,80.22903,0,0,0,0,100,0), +(@PATH,44,1699.633,-3301.397,80.47903,0,0,0,0,100,0), +(@PATH,45,1701.133,-3300.397,80.22903,0,0,0,0,100,0), +(@PATH,46,1702.133,-3301.647,80.22903,0,0,0,0,100,0), +(@PATH,47,1703.633,-3302.397,80.47903,0,0,0,0,100,0), +(@PATH,48,1705.383,-3303.647,80.72903,0,0,0,0,100,0), +(@PATH,49,1707.133,-3304.897,80.72903,0,0,0,0,100,0), +(@PATH,50,1707.361,-3304.945,80.66975,0,0,0,0,100,0), +(@PATH,51,1709.111,-3305.695,80.91975,0,0,0,0,100,0), +(@PATH,52,1711.361,-3306.695,80.66975,0,0,0,0,100,0), +(@PATH,53,1723.781,-3315.333,80.1368,0,0,0,0,100,0), +(@PATH,54,1728.281,-3317.333,79.8868,0,0,0,0,100,0), +(@PATH,55,1733.924,-3319.916,80.03304,0,0,0,0,100,0); + +SET @NPC := 42567; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1764.984,`position_y`=-3311.021,`position_z`=82.75208 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,1764.984,-3311.021,82.75208,0,0,0,0,100,0), +(@PATH,2,1759.484,-3309.771,80.75208,0,0,0,0,100,0), +(@PATH,3,1753.234,-3308.021,80.00208,0,0,0,0,100,0), +(@PATH,4,1752.877,-3308.15,79.73831,0,0,0,0,100,0), +(@PATH,5,1751.877,-3307.65,79.73831,0,0,0,0,100,0), +(@PATH,6,1745.627,-3308.4,79.73831,0,0,0,0,100,0), +(@PATH,7,1737.196,-3308.978,79.92158,0,0,0,0,100,0), +(@PATH,8,1731.446,-3308.728,79.92158,0,0,0,0,100,0), +(@PATH,9,1723.946,-3308.978,80.67158,0,0,0,0,100,0), +(@PATH,10,1723.75,-3309.052,80.54651,0,0,0,0,100,0), +(@PATH,11,1723.25,-3310.302,80.29651,0,0,0,0,100,0), +(@PATH,12,1721.75,-3312.052,80.29651,0,0,0,0,100,0), +(@PATH,13,1718.432,-3313.127,80.07133,0,0,0,0,100,0), +(@PATH,14,1716.085,-3319.896,80.40611,0,0,0,0,100,0), +(@PATH,15,1718.247,-3325.298,80.40811,0,0,0,0,100,0), +(@PATH,16,1720.997,-3329.798,80.40811,0,0,0,0,100,0), +(@PATH,17,1721.247,-3330.135,80.58556,0,0,0,0,100,0), +(@PATH,18,1723.247,-3332.885,80.83556,0,0,0,0,100,0), +(@PATH,19,1729.361,-3337.677,81.0408,0,0,0,0,100,0), +(@PATH,20,1740.568,-3343.237,81.03386,0,0,0,0,100,0), +(@PATH,21,1745.818,-3344.737,80.78386,0,0,0,0,100,0), +(@PATH,22,1747.97,-3345.551,80.95126,0,0,0,0,100,0), +(@PATH,23,1757.114,-3346.23,81.44904,0,0,0,0,100,0), +(@PATH,24,1762.364,-3346.23,81.44904,0,0,0,0,100,0), +(@PATH,25,1764.114,-3346.23,81.19904,0,0,0,0,100,0), +(@PATH,26,1765.864,-3346.23,81.19904,0,0,0,0,100,0), +(@PATH,27,1766.225,-3345.948,81.37701,0,0,0,0,100,0), +(@PATH,28,1767.475,-3345.948,81.12701,0,0,0,0,100,0), +(@PATH,29,1768.725,-3345.698,81.12701,0,0,0,0,100,0), +(@PATH,30,1775.63,-3344.304,81.77198,0,0,0,0,100,0), +(@PATH,31,1776.63,-3343.304,82.02198,0,0,0,0,100,0), +(@PATH,32,1780.293,-3339.242,82.59848,0,0,0,0,100,0), +(@PATH,33,1780.793,-3337.242,82.59848,0,0,0,0,100,0), +(@PATH,34,1781.293,-3335.992,82.59848,0,0,0,0,100,0), +(@PATH,35,1781.543,-3334.992,82.84848,0,0,0,0,100,0), +(@PATH,36,1782.297,-3331.92,83.63911,0,0,0,0,100,0), +(@PATH,37,1778.345,-3324.543,84.56404,0,0,0,0,100,0), +(@PATH,38,1773.951,-3316.386,85.19916,0,0,0,0,100,0), +(@PATH,39,1767.701,-3312.886,83.69916,0,0,0,0,100,0), +(@PATH,40,1767.525,-3312.49,83.45465,0,0,0,0,100,0); + +SET @NPC := 111927; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1625.405,`position_y`=-3351.762,`position_z`=79.90934 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,1625.405,-3351.762,79.90934,0,0,0,0,100,0), +(@PATH,2,1626.155,-3341.262,79.65934,0,0,0,0,100,0), +(@PATH,3,1626.155,-3336.512,79.65934,0,0,0,0,100,0), +(@PATH,4,1626.013,-3336.39,79.50584,0,0,0,0,100,0), +(@PATH,5,1625.763,-3341.14,79.50584,0,0,0,0,100,0), +(@PATH,6,1625.278,-3352.029,80.04063,0,0,0,0,100,0), +(@PATH,7,1626.528,-3358.529,80.54063,0,0,0,0,100,0), +(@PATH,8,1627.028,-3360.779,80.29063,0,0,0,0,100,0), +(@PATH,9,1626.906,-3360.891,80.39478,0,0,0,0,100,0), +(@PATH,10,1626.656,-3358.641,80.39478,0,0,0,0,100,0), +(@PATH,11,1625.402,-3351.743,79.908,0,0,0,0,100,0); + +SET @NPC := 110915; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1576.441,`position_y`=-3394.182,`position_z`=83.59334 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,1576.441,-3394.182,83.59334,0,0,0,0,100,0), +(@PATH,2,1581.441,-3391.682,81.34334,0,0,0,0,100,0), +(@PATH,3,1585.441,-3390.182,80.09334,0,0,0,0,100,0), +(@PATH,4,1588.941,-3388.182,78.59334,0,0,0,0,100,0), +(@PATH,5,1592.691,-3386.432,77.34334,0,0,0,0,100,0), +(@PATH,6,1596.497,-3384.609,76.62447,0,0,0,0,100,0), +(@PATH,7,1600.247,-3383.359,76.62447,0,0,0,0,100,0), +(@PATH,8,1602.997,-3382.109,76.62447,0,0,0,0,100,0), +(@PATH,9,1604.497,-3381.609,76.62447,0,0,0,0,100,0), +(@PATH,10,1604.767,-3381.405,76.77443,0,0,0,0,100,0), +(@PATH,11,1606.267,-3380.655,76.77443,0,0,0,0,100,0), +(@PATH,12,1609.017,-3379.655,77.52443,0,0,0,0,100,0), +(@PATH,13,1609.145,-3379.514,77.45844,0,0,0,0,100,0), +(@PATH,14,1605.929,-3381.065,76.94609,0,0,0,0,100,0), +(@PATH,15,1604.679,-3381.565,76.69609,0,0,0,0,100,0), +(@PATH,16,1603.179,-3382.065,76.69609,0,0,0,0,100,0), +(@PATH,17,1600.929,-3382.815,76.69609,0,0,0,0,100,0), +(@PATH,18,1596.929,-3384.565,76.44609,0,0,0,0,100,0), +(@PATH,19,1596.631,-3384.638,76.41851,0,0,0,0,100,0), +(@PATH,20,1596.131,-3384.888,76.41851,0,0,0,0,100,0), +(@PATH,21,1592.881,-3386.388,77.41851,0,0,0,0,100,0), +(@PATH,22,1589.381,-3388.138,78.41851,0,0,0,0,100,0), +(@PATH,23,1586.131,-3389.638,79.91851,0,0,0,0,100,0), +(@PATH,24,1582.131,-3391.388,80.91851,0,0,0,0,100,0), +(@PATH,25,1575.993,-3394.561,84.05369,0,0,0,0,100,0), +(@PATH,26,1574.493,-3395.811,84.80369,0,0,0,0,100,0), +(@PATH,27,1571.743,-3397.811,86.55369,0,0,0,0,100,0), +(@PATH,28,1567.993,-3400.811,89.55369,0,0,0,0,100,0), +(@PATH,29,1563.929,-3404.071,92.78562,0,0,0,0,100,0), +(@PATH,30,1562.679,-3405.321,93.78562,0,0,0,0,100,0), +(@PATH,31,1559.929,-3408.071,95.78562,0,0,0,0,100,0), +(@PATH,32,1557.679,-3409.321,96.78562,0,0,0,0,100,0), +(@PATH,33,1555.679,-3410.571,97.28562,0,0,0,0,100,0), +(@PATH,34,1553.679,-3410.571,97.28562,0,0,0,0,100,0), +(@PATH,35,1557.305,-3409.208,96.69448,0,0,0,0,100,0), +(@PATH,36,1559.305,-3407.708,95.94448,0,0,0,0,100,0), +(@PATH,37,1560.805,-3406.458,94.94448,0,0,0,0,100,0), +(@PATH,38,1562.055,-3405.458,94.44448,0,0,0,0,100,0), +(@PATH,39,1562.177,-3405.297,94.26689,0,0,0,0,100,0), +(@PATH,40,1564.177,-3403.797,92.76689,0,0,0,0,100,0), +(@PATH,41,1567.427,-3401.297,90.01689,0,0,0,0,100,0), +(@PATH,42,1571.177,-3398.297,86.76689,0,0,0,0,100,0), +(@PATH,43,1574.177,-3396.047,85.01689,0,0,0,0,100,0), +(@PATH,44,1574.342,-3395.708,84.81064,0,0,0,0,100,0); + +SET @NPC := 110899; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1549.184,`position_y`=-3410.032,`position_z`=98.73938 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,1549.184,-3410.032,98.73938,0,0,0,0,100,0), +(@PATH,2,1549.934,-3411.282,98.48938,0,0,0,0,100,0), +(@PATH,3,1551.464,-3414.331,98.43894,0,0,0,0,100,0), +(@PATH,4,1551.964,-3415.831,98.43894,0,0,0,0,100,0), +(@PATH,5,1553.964,-3422.581,98.18894,0,0,0,0,100,0), +(@PATH,6,1554.464,-3423.581,98.18894,0,0,0,0,100,0), +(@PATH,7,1555.795,-3427.275,98.44226,0,0,0,0,100,0), +(@PATH,8,1556.295,-3429.775,98.44226,0,0,0,0,100,0), +(@PATH,9,1556.795,-3432.275,98.69226,0,0,0,0,100,0), +(@PATH,10,1558.295,-3441.275,99.69226,0,0,0,0,100,0), +(@PATH,11,1558.795,-3445.275,99.94226,0,0,0,0,100,0), +(@PATH,12,1559.295,-3448.025,100.1923,0,0,0,0,100,0), +(@PATH,13,1562.292,-3465.172,102.3143,0,0,0,0,100,0), +(@PATH,14,1563.292,-3471.672,102.8143,0,0,0,0,100,0), +(@PATH,15,1564.042,-3476.672,103.3143,0,0,0,0,100,0), +(@PATH,16,1565.292,-3485.922,103.8143,0,0,0,0,100,0), +(@PATH,17,1565.386,-3485.937,103.8012,0,0,0,0,100,0), +(@PATH,18,1564.136,-3476.687,103.3012,0,0,0,0,100,0), +(@PATH,19,1563.386,-3471.687,103.0512,0,0,0,0,100,0), +(@PATH,20,1562.085,-3464.858,102.1178,0,0,0,0,100,0), +(@PATH,21,1559.335,-3448.108,100.1178,0,0,0,0,100,0), +(@PATH,22,1559.085,-3445.358,99.86781,0,0,0,0,100,0), +(@PATH,23,1558.335,-3441.358,99.61781,0,0,0,0,100,0), +(@PATH,24,1556.835,-3432.358,98.61781,0,0,0,0,100,0), +(@PATH,25,1556.335,-3429.608,98.36781,0,0,0,0,100,0), +(@PATH,26,1555.558,-3427.184,98.11308,0,0,0,0,100,0), +(@PATH,27,1554.308,-3423.434,98.11308,0,0,0,0,100,0), +(@PATH,28,1554.058,-3422.434,98.36308,0,0,0,0,100,0), +(@PATH,29,1552.058,-3415.934,98.36308,0,0,0,0,100,0), +(@PATH,30,1551.558,-3414.684,98.36308,0,0,0,0,100,0), +(@PATH,31,1551.663,-3415.686,98.44431,0,0,0,0,100,0), +(@PATH,32,1551.413,-3414.436,98.44431,0,0,0,0,100,0), +(@PATH,33,1551.163,-3413.936,98.44431,0,0,0,0,100,0), +(@PATH,34,1550.163,-3411.686,98.44431,0,0,0,0,100,0), +(@PATH,35,1549.163,-3409.936,98.69431,0,0,0,0,100,0), +(@PATH,36,1547.913,-3406.686,98.94431,0,0,0,0,100,0), +(@PATH,37,1546.413,-3403.436,98.94431,0,0,0,0,100,0), +(@PATH,38,1546.323,-3403.457,98.95697,0,0,0,0,100,0), +(@PATH,39,1547.823,-3406.707,98.95697,0,0,0,0,100,0), +(@PATH,40,1549.323,-3409.957,98.70697,0,0,0,0,100,0); + +SET @NPC := 110934; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1588.477,`position_y`=-3154.809,`position_z`=1.040982 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,1588.477,-3154.809,1.040982,0,0,0,0,100,0), +(@PATH,2,1586.727,-3151.059,1.540982,0,0,0,0,100,0), +(@PATH,3,1583.977,-3145.059,2.040982,0,0,0,0,100,0), +(@PATH,4,1582.477,-3142.559,2.790982,0,0,0,0,100,0), +(@PATH,5,1583.477,-3144.371,2.203365,0,0,0,0,100,0), +(@PATH,6,1585.477,-3148.621,1.703365,0,0,0,0,100,0), +(@PATH,7,1587.727,-3153.121,1.203365,0,0,0,0,100,0), +(@PATH,8,1588.014,-3153.393,1.018376,0,0,0,0,100,0), +(@PATH,9,1588.514,-3154.893,1.018376,0,0,0,0,100,0), +(@PATH,10,1589.764,-3165.643,1.268376,0,0,0,0,100,0), +(@PATH,11,1590.353,-3170.328,1.823887,0,0,0,0,100,0), +(@PATH,12,1585.555,-3186.668,1.854707,0,0,0,0,100,0), +(@PATH,13,1584.555,-3197.418,1.354707,0,0,0,0,100,0), +(@PATH,14,1584.837,-3203.387,1.349868,0,0,0,0,100,0), +(@PATH,15,1580.337,-3217.387,-0.6501324,0,0,0,0,100,0), +(@PATH,16,1580.337,-3216.387,-0.6501324,0,0,0,0,100,0), +(@PATH,17,1581.587,-3215.387,-0.6501324,0,0,0,0,100,0), +(@PATH,18,1583.587,-3215.387,1.849868,0,0,0,0,100,0), +(@PATH,19,1590.212,-3216.132,2.20363,0,0,0,0,100,0), +(@PATH,20,1592.962,-3220.382,2.45363,0,0,0,0,100,0), +(@PATH,21,1600.439,-3232.153,3.074192,0,0,0,0,100,0), +(@PATH,22,1608.439,-3246.903,3.574192,0,0,0,0,100,0), +(@PATH,23,1607.651,-3245.534,3.11465,0,0,0,0,100,0), +(@PATH,24,1600.145,-3231.887,2.961977,0,0,0,0,100,0), +(@PATH,25,1592.395,-3219.637,2.211977,0,0,0,0,100,0), +(@PATH,26,1589.94,-3215.791,1.852561,0,0,0,0,100,0), +(@PATH,27,1584.19,-3204.541,1.352561,0,0,0,0,100,0), +(@PATH,28,1584.364,-3204.471,1.401658,0,0,0,0,100,0), +(@PATH,29,1583.864,-3203.721,1.401658,0,0,0,0,100,0), +(@PATH,30,1584.864,-3195.971,1.651658,0,0,0,0,100,0), +(@PATH,31,1585.114,-3192.971,2.401658,0,0,0,0,100,0), +(@PATH,32,1584.439,-3196.701,1.488584,0,0,0,0,100,0), +(@PATH,33,1585.011,-3193.408,2.344659,0,0,0,0,100,0), +(@PATH,34,1585.938,-3186.306,1.765427,0,0,0,0,100,0), +(@PATH,35,1590.225,-3170.116,1.798501,0,0,0,0,100,0), +(@PATH,36,1589.725,-3165.116,1.048501,0,0,0,0,100,0); + +SET @NPC := 110893; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1675.334,`position_y`=-3437.228,`position_z`=79.58514 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,1675.334,-3437.228,79.58514,0,0,0,0,100,0), +(@PATH,2,1674.584,-3436.978,79.08514,0,0,0,0,100,0), +(@PATH,3,1672.703,-3436.403,78.31236,0,0,0,0,100,0), +(@PATH,4,1669.953,-3436.153,77.56236,0,0,0,0,100,0), +(@PATH,5,1668.203,-3436.153,77.06236,0,0,0,0,100,0), +(@PATH,6,1668.12,-3435.942,77.07675,0,0,0,0,100,0), +(@PATH,7,1670.12,-3436.192,77.32675,0,0,0,0,100,0), +(@PATH,8,1670.281,-3436.421,77.67787,0,0,0,0,100,0), +(@PATH,9,1673.031,-3436.671,78.42787,0,0,0,0,100,0), +(@PATH,10,1674.531,-3437.171,78.92787,0,0,0,0,100,0), +(@PATH,11,1675.281,-3437.171,79.17787,0,0,0,0,100,0), +(@PATH,12,1687.281,-3438.421,85.92787,0,0,0,0,100,0), +(@PATH,13,1687.531,-3438.421,86.17787,0,0,0,0,100,0), +(@PATH,14,1674.401,-3436.937,78.70284,0,0,0,0,100,0), +(@PATH,15,1672.651,-3436.437,78.20284,0,0,0,0,100,0), +(@PATH,16,1670.151,-3436.187,77.70284,0,0,0,0,100,0), +(@PATH,17,1668.401,-3436.187,77.20284,0,0,0,0,100,0), +(@PATH,18,1668.12,-3435.942,77.07675,0,0,0,0,100,0), +(@PATH,19,1670.12,-3436.192,77.32675,0,0,0,0,100,0); + +SET @NPC := 110862; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1566.858,`position_y`=-3412.7,`position_z`=55.30537 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,1566.858,-3412.7,55.30537,0,0,0,0,100,0), +(@PATH,2,1566.391,-3410.429,55.70556,0,0,0,0,100,0), +(@PATH,3,1561.641,-3400.929,56.70556,0,0,0,0,100,0), +(@PATH,4,1558.141,-3393.929,58.70556,0,0,0,0,100,0), +(@PATH,5,1555.141,-3388.179,58.45556,0,0,0,0,100,0), +(@PATH,6,1545.77,-3369.756,57.64226,0,0,0,0,100,0), +(@PATH,7,1539.77,-3362.506,57.89226,0,0,0,0,100,0), +(@PATH,8,1536.27,-3358.006,57.64226,0,0,0,0,100,0), +(@PATH,9,1522.27,-3340.756,58.64226,0,0,0,0,100,0), +(@PATH,10,1519.02,-3336.506,58.89226,0,0,0,0,100,0), +(@PATH,11,1518.27,-3335.756,59.14226,0,0,0,0,100,0), +(@PATH,12,1517.604,-3335.188,59.35161,0,0,0,0,100,0), +(@PATH,13,1518.854,-3336.688,58.85161,0,0,0,0,100,0), +(@PATH,14,1522.354,-3340.688,58.60161,0,0,0,0,100,0), +(@PATH,15,1536.104,-3357.938,57.60161,0,0,0,0,100,0), +(@PATH,16,1539.854,-3362.438,57.85161,0,0,0,0,100,0), +(@PATH,17,1525.985,-3345.615,58.16137,0,0,0,0,100,0), +(@PATH,18,1536.084,-3358.031,57.73196,0,0,0,0,100,0), +(@PATH,19,1539.834,-3362.531,57.73196,0,0,0,0,100,0), +(@PATH,20,1546.023,-3370.014,57.50838,0,0,0,0,100,0), +(@PATH,21,1554.773,-3388.014,58.25838,0,0,0,0,100,0), +(@PATH,22,1558.023,-3394.014,58.50838,0,0,0,0,100,0), +(@PATH,23,1561.523,-3401.014,56.75838,0,0,0,0,100,0), +(@PATH,24,1566.746,-3410.737,55.40793,0,0,0,0,100,0); + +SET @NPC := 110876; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1618.827,`position_y`=-3366.002,`position_z`=13.78367 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,1618.827,-3366.002,13.78367,0,0,0,0,100,0), +(@PATH,2,1617.327,-3362.002,12.78367,0,0,0,0,100,0), +(@PATH,3,1615.077,-3355.252,11.03367,0,0,0,0,100,0), +(@PATH,4,1612.076,-3347.354,9.581163,0,0,0,0,100,0), +(@PATH,5,1608.38,-3336.774,8.200773,0,0,0,0,100,0), +(@PATH,6,1608.742,-3336.418,8.342894,0,0,0,0,100,0), +(@PATH,7,1608.742,-3334.668,8.092894,0,0,0,0,100,0), +(@PATH,8,1608.742,-3328.168,7.842894,0,0,0,0,100,0), +(@PATH,9,1608.992,-3320.418,8.092894,0,0,0,0,100,0), +(@PATH,10,1608.796,-3310.79,6.280064,0,0,0,0,100,0), +(@PATH,11,1608.796,-3306.04,5.280064,0,0,0,0,100,0), +(@PATH,12,1608.796,-3293.04,3.780064,0,0,0,0,100,0), +(@PATH,13,1609.15,-3288.422,3.226425,0,0,0,0,100,0), +(@PATH,14,1609.65,-3279.172,2.976425,0,0,0,0,100,0), +(@PATH,15,1609.9,-3277.422,2.976425,0,0,0,0,100,0), +(@PATH,16,1609.896,-3277.512,2.889059,0,0,0,0,100,0), +(@PATH,17,1609.646,-3278.762,2.889059,0,0,0,0,100,0), +(@PATH,18,1608.915,-3288.683,3.626873,0,0,0,0,100,0), +(@PATH,19,1608.915,-3292.183,3.626873,0,0,0,0,100,0), +(@PATH,20,1608.915,-3305.933,5.376873,0,0,0,0,100,0), +(@PATH,21,1608.915,-3310.183,6.376873,0,0,0,0,100,0), +(@PATH,22,1608.87,-3310.375,6.640759,0,0,0,0,100,0), +(@PATH,23,1608.87,-3310.875,6.640759,0,0,0,0,100,0), +(@PATH,24,1608.62,-3320.375,8.140759,0,0,0,0,100,0), +(@PATH,25,1608.62,-3328.375,7.890759,0,0,0,0,100,0), +(@PATH,26,1608.62,-3334.625,8.140759,0,0,0,0,100,0), +(@PATH,27,1608.565,-3336.654,8.539102,0,0,0,0,100,0), +(@PATH,28,1615.065,-3355.404,10.7891,0,0,0,0,100,0), +(@PATH,29,1617.315,-3361.904,12.7891,0,0,0,0,100,0), +(@PATH,30,1619.09,-3366.434,14.01098,0,0,0,0,100,0), +(@PATH,31,1620.34,-3370.434,15.01098,0,0,0,0,100,0), +(@PATH,32,1621.59,-3374.684,16.01098,0,0,0,0,100,0), +(@PATH,33,1625.84,-3388.684,19.26098,0,0,0,0,100,0), +(@PATH,34,1626.84,-3391.684,20.01098,0,0,0,0,100,0), +(@PATH,35,1628.288,-3396.142,21.0691,0,0,0,0,100,0), +(@PATH,36,1629.038,-3412.892,24.8191,0,0,0,0,100,0), +(@PATH,37,1629.538,-3418.392,26.0691,0,0,0,0,100,0), +(@PATH,38,1629.346,-3418.374,26.0432,0,0,0,0,100,0), +(@PATH,39,1629.096,-3412.874,24.7932,0,0,0,0,100,0); + +SET @NPC := 110927; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1619.016,`position_y`=-3329.799,`position_z`=78.38254 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,1619.016,-3329.799,78.38254,0,0,0,0,100,0), +(@PATH,2,1621.016,-3317.299,78.38254,0,0,0,0,100,0), +(@PATH,3,1621.766,-3314.049,78.13254,0,0,0,0,100,0), +(@PATH,4,1631.373,-3295.402,77.71893,0,0,0,0,100,0), +(@PATH,5,1639.373,-3285.152,76.71893,0,0,0,0,100,0), +(@PATH,6,1630.263,-3292.619,76.90758,0,0,0,0,100,0), +(@PATH,7,1635.763,-3284.619,76.15758,0,0,0,0,100,0), +(@PATH,8,1637.656,-3281.988,75.80133,0,0,0,0,100,0), +(@PATH,9,1639.656,-3284.738,76.55133,0,0,0,0,100,0), +(@PATH,10,1639.571,-3284.723,76.64397,0,0,0,0,100,0), +(@PATH,11,1637.43,-3282.384,76.09854,0,0,0,0,100,0), +(@PATH,12,1635.68,-3284.634,76.34854,0,0,0,0,100,0), +(@PATH,13,1629.832,-3292.752,76.97553,0,0,0,0,100,0), +(@PATH,14,1629.582,-3294.252,77.22553,0,0,0,0,100,0), +(@PATH,15,1628.582,-3299.002,77.72553,0,0,0,0,100,0), +(@PATH,16,1625.332,-3316.752,78.97553,0,0,0,0,100,0), +(@PATH,17,1623.294,-3305.816,78.05945,0,0,0,0,100,0), +(@PATH,18,1621.544,-3314.066,78.30945,0,0,0,0,100,0), +(@PATH,19,1621.294,-3317.316,78.30945,0,0,0,0,100,0), +(@PATH,20,1618.962,-3330.063,78.4706,0,0,0,0,100,0), +(@PATH,21,1619.212,-3335.563,78.7206,0,0,0,0,100,0), +(@PATH,22,1619.296,-3336.268,78.72385,0,0,0,0,100,0), +(@PATH,23,1619.016,-3329.807,78.38277,0,0,0,0,100,0); + +SET @NPC := 110893; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1670.294,`position_y`=-3436.423,`position_z`=77.68137 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,1670.294,-3436.423,77.68137,0,0,0,0,100,0), +(@PATH,2,1672.794,-3436.673,78.43137,0,0,0,0,100,0), +(@PATH,3,1674.544,-3437.173,78.93137,0,0,0,0,100,0), +(@PATH,4,1675.294,-3437.173,79.18137,0,0,0,0,100,0), +(@PATH,5,1687.294,-3438.423,85.93137,0,0,0,0,100,0), +(@PATH,6,1687.544,-3438.423,86.18137,0,0,0,0,100,0), +(@PATH,7,1680.161,-3437.809,81.70387,0,0,0,0,100,0), +(@PATH,8,1687.298,-3438.658,86.04021,0,0,0,0,100,0), +(@PATH,9,1694.645,-3439.627,90.70386,0,0,0,0,100,0), +(@PATH,10,1696.645,-3439.627,91.95386,0,0,0,0,100,0), +(@PATH,11,1709.645,-3441.377,100.2039,0,0,0,0,100,0), +(@PATH,12,1723.395,-3442.877,108.4539,0,0,0,0,100,0), +(@PATH,13,1723.612,-3443.172,108.6327,0,0,0,0,100,0), +(@PATH,14,1725.112,-3443.422,109.3827,0,0,0,0,100,0), +(@PATH,15,1732.612,-3443.422,111.8827,0,0,0,0,100,0), +(@PATH,16,1738.112,-3443.422,113.6327,0,0,0,0,100,0), +(@PATH,17,1752.563,-3443.961,119.4772,0,0,0,0,100,0), +(@PATH,18,1756.563,-3443.711,121.2272,0,0,0,0,100,0), +(@PATH,19,1758.563,-3443.711,121.9772,0,0,0,0,100,0), +(@PATH,20,1760.313,-3443.711,122.7272,0,0,0,0,100,0), +(@PATH,21,1762.313,-3443.961,123.4772,0,0,0,0,100,0), +(@PATH,22,1764.313,-3443.961,124.2272,0,0,0,0,100,0), +(@PATH,23,1766.313,-3443.961,124.9772,0,0,0,0,100,0), +(@PATH,24,1766.697,-3443.734,124.5211,0,0,0,0,100,0), +(@PATH,25,1763.697,-3443.234,123.7711,0,0,0,0,100,0), +(@PATH,26,1761.697,-3442.984,123.2711,0,0,0,0,100,0), +(@PATH,27,1759.947,-3442.734,122.2711,0,0,0,0,100,0), +(@PATH,28,1757.947,-3442.484,121.5211,0,0,0,0,100,0), +(@PATH,29,1755.947,-3442.234,121.0211,0,0,0,0,100,0), +(@PATH,30,1754.947,-3442.234,120.7711,0,0,0,0,100,0), +(@PATH,31,1752.246,-3443.656,119.3673,0,0,0,0,100,0), +(@PATH,32,1738.746,-3443.406,114.1173,0,0,0,0,100,0), +(@PATH,33,1732.496,-3443.406,112.1173,0,0,0,0,100,0), +(@PATH,34,1731.348,-3443.525,111.246,0,0,0,0,100,0), +(@PATH,35,1724.794,-3443.419,108.9501,0,0,0,0,100,0), +(@PATH,36,1724.731,-3443.243,109.0672,0,0,0,0,100,0), +(@PATH,37,1723.731,-3442.993,108.8172,0,0,0,0,100,0), +(@PATH,38,1710.481,-3441.493,100.8172,0,0,0,0,100,0), +(@PATH,39,1696.481,-3439.743,92.06723,0,0,0,0,100,0), +(@PATH,40,1696.261,-3439.524,91.66846,0,0,0,0,100,0), +(@PATH,41,1694.511,-3439.274,90.41846,0,0,0,0,100,0), +(@PATH,42,1687.761,-3438.274,86.16846,0,0,0,0,100,0), +(@PATH,43,1687.261,-3438.524,86.41846,0,0,0,0,100,0), +(@PATH,44,1687.011,-3439.024,86.16846,0,0,0,0,100,0), +(@PATH,45,1675.261,-3437.274,79.41846,0,0,0,0,100,0), +(@PATH,46,1674.511,-3437.024,78.91846,0,0,0,0,100,0), +(@PATH,47,1672.542,-3436.419,78.12367,0,0,0,0,100,0), +(@PATH,48,1670.042,-3436.169,77.62367,0,0,0,0,100,0), +(@PATH,49,1668.292,-3436.169,77.12367,0,0,0,0,100,0), +(@PATH,50,1668.12,-3435.942,77.07675,0,0,0,0,100,0), +(@PATH,51,1670.12,-3436.192,77.32675,0,0,0,0,100,0), +(@PATH,52,1670.301,-3436.423,77.68327,0,0,0,0,100,0), +(@PATH,53,1672.801,-3436.673,78.43327,0,0,0,0,100,0), +(@PATH,54,1674.551,-3437.173,78.93327,0,0,0,0,100,0), +(@PATH,55,1675.301,-3437.173,79.18327,0,0,0,0,100,0), +(@PATH,56,1687.301,-3438.423,85.93327,0,0,0,0,100,0), +(@PATH,57,1687.551,-3438.423,86.18327,0,0,0,0,100,0); + +SET @NPC := 110865; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1549.116,`position_y`=-3621.641,`position_z`=114.1717 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,1549.116,-3621.641,114.1717,0,0,0,0,100,0), +(@PATH,2,1550.616,-3624.141,114.9217,0,0,0,0,100,0), +(@PATH,3,1552.616,-3627.641,115.9217,0,0,0,0,100,0), +(@PATH,4,1553.616,-3629.391,116.6717,0,0,0,0,100,0), +(@PATH,5,1555.116,-3631.891,117.4217,0,0,0,0,100,0), +(@PATH,6,1555.366,-3632.641,117.9217,0,0,0,0,100,0), +(@PATH,7,1556.366,-3634.391,118.6717,0,0,0,0,100,0), +(@PATH,8,1557.366,-3636.141,119.4217,0,0,0,0,100,0), +(@PATH,9,1558.366,-3637.891,120.1717,0,0,0,0,100,0), +(@PATH,10,1558.866,-3638.641,120.9217,0,0,0,0,100,0), +(@PATH,11,1559.866,-3640.391,121.9217,0,0,0,0,100,0), +(@PATH,12,1561.366,-3643.141,122.9217,0,0,0,0,100,0), +(@PATH,13,1560.809,-3642.022,122.439,0,0,0,0,100,0), +(@PATH,14,1559.809,-3640.272,121.439,0,0,0,0,100,0), +(@PATH,15,1558.809,-3638.522,120.939,0,0,0,0,100,0), +(@PATH,16,1558.309,-3637.772,120.189,0,0,0,0,100,0), +(@PATH,17,1557.309,-3636.022,119.189,0,0,0,0,100,0), +(@PATH,18,1555.809,-3633.272,118.189,0,0,0,0,100,0), +(@PATH,19,1555.059,-3631.772,117.439,0,0,0,0,100,0), +(@PATH,20,1554.059,-3630.022,116.689,0,0,0,0,100,0), +(@PATH,21,1552.559,-3627.522,115.939,0,0,0,0,100,0), +(@PATH,22,1551.559,-3625.772,115.189,0,0,0,0,100,0), +(@PATH,23,1549.559,-3622.272,114.439,0,0,0,0,100,0), +(@PATH,24,1549.242,-3622.044,114.1625,0,0,0,0,100,0), +(@PATH,25,1548.992,-3621.294,113.9125,0,0,0,0,100,0), +(@PATH,26,1547.123,-3597.936,112.9313,0,0,0,0,100,0), +(@PATH,27,1551.751,-3587.696,113.621,0,0,0,0,100,0), +(@PATH,28,1560.001,-3574.946,114.621,0,0,0,0,100,0), +(@PATH,29,1562.119,-3571.924,114.2751,0,0,0,0,100,0), +(@PATH,30,1563.619,-3569.174,114.0251,0,0,0,0,100,0), +(@PATH,31,1566.869,-3562.924,113.5251,0,0,0,0,100,0), +(@PATH,32,1567.369,-3561.924,113.2751,0,0,0,0,100,0), +(@PATH,33,1569.119,-3558.674,113.2751,0,0,0,0,100,0), +(@PATH,34,1570.48,-3555.766,112.344,0,0,0,0,100,0), +(@PATH,35,1571.23,-3540.266,110.094,0,0,0,0,100,0), +(@PATH,36,1571.48,-3532.766,109.344,0,0,0,0,100,0), +(@PATH,37,1570.308,-3556.526,112.3496,0,0,0,0,100,0), +(@PATH,38,1571.144,-3540.282,110.0654,0,0,0,0,100,0), +(@PATH,39,1571.394,-3532.782,109.3154,0,0,0,0,100,0), +(@PATH,40,1571.537,-3532.766,109.4981,0,0,0,0,100,0), +(@PATH,41,1571.037,-3540.266,109.9981,0,0,0,0,100,0), +(@PATH,42,1570.541,-3556.09,112.5109,0,0,0,0,100,0), +(@PATH,43,1569.041,-3558.84,113.0109,0,0,0,0,100,0), +(@PATH,44,1567.541,-3561.84,113.2609,0,0,0,0,100,0), +(@PATH,45,1566.791,-3563.09,113.5109,0,0,0,0,100,0), +(@PATH,46,1563.791,-3569.09,114.0109,0,0,0,0,100,0), +(@PATH,47,1551.551,-3587.917,113.4886,0,0,0,0,100,0), +(@PATH,48,1547.551,-3597.167,113.2386,0,0,0,0,100,0), +(@PATH,49,1547.051,-3599.667,113.4886,0,0,0,0,100,0), +(@PATH,50,1548.915,-3621.554,113.8082,0,0,0,0,100,0); + +SET @NPC := 110894; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1652.062,`position_y`=-3643.016,`position_z`=131.1049 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,1652.062,-3643.016,131.1049,0,0,0,0,100,0), +(@PATH,2,1651.312,-3641.266,129.3549,0,0,0,0,100,0), +(@PATH,3,1651.312,-3639.266,127.8549,0,0,0,0,100,0), +(@PATH,4,1651.062,-3637.516,126.6049,0,0,0,0,100,0), +(@PATH,5,1650.562,-3634.516,125.6049,0,0,0,0,100,0), +(@PATH,6,1650.706,-3634.303,125.308,0,0,0,0,100,0), +(@PATH,7,1650.456,-3632.803,124.558,0,0,0,0,100,0), +(@PATH,8,1650.706,-3631.803,123.808,0,0,0,0,100,0), +(@PATH,9,1650.956,-3630.803,123.058,0,0,0,0,100,0), +(@PATH,10,1651.206,-3629.803,122.308,0,0,0,0,100,0), +(@PATH,11,1651.956,-3627.053,121.558,0,0,0,0,100,0), +(@PATH,12,1652.206,-3626.303,120.808,0,0,0,0,100,0), +(@PATH,13,1652.456,-3625.303,120.308,0,0,0,0,100,0), +(@PATH,14,1652.706,-3624.303,119.808,0,0,0,0,100,0), +(@PATH,15,1652.706,-3623.303,119.058,0,0,0,0,100,0), +(@PATH,16,1652.956,-3622.553,118.308,0,0,0,0,100,0), +(@PATH,17,1653.206,-3621.553,117.808,0,0,0,0,100,0), +(@PATH,18,1653.456,-3620.553,116.808,0,0,0,0,100,0), +(@PATH,19,1653.706,-3619.553,116.058,0,0,0,0,100,0), +(@PATH,20,1653.956,-3618.553,115.308,0,0,0,0,100,0), +(@PATH,21,1654.456,-3616.553,114.058,0,0,0,0,100,0), +(@PATH,22,1654.417,-3617.11,114.68,0,0,0,0,100,0), +(@PATH,23,1654.167,-3618.11,115.43,0,0,0,0,100,0), +(@PATH,24,1653.917,-3619.11,116.18,0,0,0,0,100,0), +(@PATH,25,1653.667,-3620.11,116.93,0,0,0,0,100,0), +(@PATH,26,1653.417,-3620.86,117.68,0,0,0,0,100,0), +(@PATH,27,1653.167,-3621.86,118.43,0,0,0,0,100,0), +(@PATH,28,1652.667,-3623.86,118.93,0,0,0,0,100,0), +(@PATH,29,1652.417,-3624.61,119.43,0,0,0,0,100,0), +(@PATH,30,1652.417,-3625.61,120.18,0,0,0,0,100,0), +(@PATH,31,1652.167,-3626.61,120.93,0,0,0,0,100,0), +(@PATH,32,1651.917,-3627.61,121.43,0,0,0,0,100,0), +(@PATH,33,1651.667,-3628.36,122.18,0,0,0,0,100,0), +(@PATH,34,1651.167,-3630.36,123.18,0,0,0,0,100,0), +(@PATH,35,1650.917,-3631.36,123.68,0,0,0,0,100,0), +(@PATH,36,1650.417,-3632.36,124.43,0,0,0,0,100,0), +(@PATH,37,1651.11,-3630.556,123.4477,0,0,0,0,100,0), +(@PATH,38,1650.86,-3631.556,123.9477,0,0,0,0,100,0), +(@PATH,39,1650.61,-3632.556,124.6977,0,0,0,0,100,0), +(@PATH,40,1650.36,-3633.056,124.6977,0,0,0,0,100,0), +(@PATH,41,1650.86,-3635.806,125.9477,0,0,0,0,100,0), +(@PATH,42,1651.11,-3637.806,127.1977,0,0,0,0,100,0), +(@PATH,43,1651.11,-3638.806,127.6977,0,0,0,0,100,0), +(@PATH,44,1651.11,-3639.806,128.6977,0,0,0,0,100,0), +(@PATH,45,1651.361,-3638.892,128.1586,0,0,0,0,100,0), +(@PATH,46,1651.361,-3639.892,128.9086,0,0,0,0,100,0), +(@PATH,47,1651.611,-3640.892,129.6586,0,0,0,0,100,0), +(@PATH,48,1651.861,-3641.892,130.4086,0,0,0,0,100,0), +(@PATH,49,1652.361,-3642.892,130.9086,0,0,0,0,100,0), +(@PATH,50,1652.611,-3643.392,131.9086,0,0,0,0,100,0), +(@PATH,51,1653.111,-3645.392,132.6586,0,0,0,0,100,0), +(@PATH,52,1653.611,-3646.392,133.4086,0,0,0,0,100,0), +(@PATH,53,1653.452,-3645.578,132.91,0,0,0,0,100,0), +(@PATH,54,1653.952,-3646.578,133.66,0,0,0,0,100,0), +(@PATH,55,1654.702,-3648.328,134.91,0,0,0,0,100,0), +(@PATH,56,1655.452,-3651.078,135.91,0,0,0,0,100,0), +(@PATH,57,1656.452,-3653.828,136.91,0,0,0,0,100,0), +(@PATH,58,1657.202,-3655.578,137.66,0,0,0,0,100,0), +(@PATH,59,1657.284,-3655.998,137.8962,0,0,0,0,100,0), +(@PATH,60,1658.034,-3658.248,139.1462,0,0,0,0,100,0), +(@PATH,61,1658.284,-3660.248,139.8962,0,0,0,0,100,0), +(@PATH,62,1658.284,-3661.998,140.8962,0,0,0,0,100,0), +(@PATH,63,1658.534,-3662.998,141.6462,0,0,0,0,100,0), +(@PATH,64,1658.534,-3664.998,142.6462,0,0,0,0,100,0), +(@PATH,65,1658.817,-3663.134,141.7131,0,0,0,0,100,0), +(@PATH,66,1658.817,-3665.134,142.7131,0,0,0,0,100,0), +(@PATH,67,1659.067,-3665.884,143.2131,0,0,0,0,100,0), +(@PATH,68,1660.067,-3667.634,143.7131,0,0,0,0,100,0), +(@PATH,69,1660.817,-3669.134,144.4631,0,0,0,0,100,0), +(@PATH,70,1661.817,-3670.884,145.7131,0,0,0,0,100,0), +(@PATH,71,1661.707,-3670.829,145.7333,0,0,0,0,100,0), +(@PATH,72,1660.457,-3668.579,144.2333,0,0,0,0,100,0), +(@PATH,73,1658.996,-3665.685,142.871,0,0,0,0,100,0), +(@PATH,74,1658.746,-3663.685,142.121,0,0,0,0,100,0), +(@PATH,75,1658.496,-3661.935,141.121,0,0,0,0,100,0), +(@PATH,76,1658.496,-3659.935,140.121,0,0,0,0,100,0), +(@PATH,77,1658.246,-3658.935,139.371,0,0,0,0,100,0), +(@PATH,78,1658.085,-3659.677,139.8403,0,0,0,0,100,0), +(@PATH,79,1658.085,-3658.677,139.0903,0,0,0,0,100,0), +(@PATH,80,1658.085,-3657.927,138.8403,0,0,0,0,100,0), +(@PATH,81,1657.085,-3655.177,137.5903,0,0,0,0,100,0), +(@PATH,82,1656.335,-3653.677,137.0903,0,0,0,0,100,0), +(@PATH,83,1655.835,-3651.677,136.0903,0,0,0,0,100,0), +(@PATH,84,1655.085,-3649.927,135.3403,0,0,0,0,100,0), +(@PATH,85,1655.593,-3651.333,135.922,0,0,0,0,100,0), +(@PATH,86,1654.843,-3649.583,135.172,0,0,0,0,100,0), +(@PATH,87,1654.593,-3648.333,134.422,0,0,0,0,100,0), +(@PATH,88,1654.093,-3647.333,133.922,0,0,0,0,100,0), +(@PATH,89,1653.093,-3644.833,132.672,0,0,0,0,100,0), +(@PATH,90,1652.343,-3643.083,131.422,0,0,0,0,100,0); + +SET @NPC := 110867; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1568.781,`position_y`=-3682.135,`position_z`=141.1008 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,1568.781,-3682.135,141.1008,0,0,0,0,100,0), +(@PATH,2,1568.781,-3682.885,141.6008,0,0,0,0,100,0), +(@PATH,3,1568.531,-3684.635,142.3508,0,0,0,0,100,0), +(@PATH,4,1568.405,-3687.933,142.1319,0,0,0,0,100,0), +(@PATH,5,1570.405,-3689.933,141.6319,0,0,0,0,100,0), +(@PATH,6,1571.405,-3691.433,140.8819,0,0,0,0,100,0), +(@PATH,7,1571.542,-3691.665,140.7311,0,0,0,0,100,0), +(@PATH,8,1573.042,-3693.415,139.7311,0,0,0,0,100,0), +(@PATH,9,1573.542,-3695.415,139.4811,0,0,0,0,100,0), +(@PATH,10,1574.042,-3698.415,138.7311,0,0,0,0,100,0), +(@PATH,11,1574.792,-3701.165,138.2311,0,0,0,0,100,0), +(@PATH,12,1575.292,-3702.915,137.7311,0,0,0,0,100,0), +(@PATH,13,1575.792,-3705.915,136.9811,0,0,0,0,100,0), +(@PATH,14,1576.292,-3707.915,136.2311,0,0,0,0,100,0), +(@PATH,15,1577.292,-3711.665,135.4811,0,0,0,0,100,0), +(@PATH,16,1577.371,-3712.005,135.1614,0,0,0,0,100,0), +(@PATH,17,1577.621,-3712.255,135.4114,0,0,0,0,100,0), +(@PATH,18,1578.371,-3715.255,133.9114,0,0,0,0,100,0), +(@PATH,19,1579.121,-3717.255,133.1614,0,0,0,0,100,0), +(@PATH,20,1579.371,-3719.005,132.4114,0,0,0,0,100,0), +(@PATH,21,1580.121,-3721.755,131.6614,0,0,0,0,100,0), +(@PATH,22,1581.121,-3724.505,131.1614,0,0,0,0,100,0), +(@PATH,23,1581.621,-3726.505,130.4114,0,0,0,0,100,0), +(@PATH,24,1581.503,-3726.593,130.2319,0,0,0,0,100,0), +(@PATH,25,1582.003,-3728.343,129.7319,0,0,0,0,100,0), +(@PATH,26,1581.003,-3725.343,130.7319,0,0,0,0,100,0), +(@PATH,27,1580.253,-3722.593,131.7319,0,0,0,0,100,0), +(@PATH,28,1579.003,-3719.093,132.7319,0,0,0,0,100,0), +(@PATH,29,1578.503,-3717.093,133.2319,0,0,0,0,100,0), +(@PATH,30,1577.253,-3713.343,135.2319,0,0,0,0,100,0), +(@PATH,31,1576.932,-3713.202,135.5007,0,0,0,0,100,0), +(@PATH,32,1576.682,-3712.452,135.7507,0,0,0,0,100,0), +(@PATH,33,1575.932,-3709.452,136.2507,0,0,0,0,100,0), +(@PATH,34,1575.182,-3705.702,137.0007,0,0,0,0,100,0), +(@PATH,35,1574.932,-3704.702,137.5007,0,0,0,0,100,0), +(@PATH,36,1574.432,-3701.952,138.2507,0,0,0,0,100,0), +(@PATH,37,1573.682,-3698.952,139.0007,0,0,0,0,100,0), +(@PATH,38,1573.182,-3696.202,139.5007,0,0,0,0,100,0), +(@PATH,39,1572.74,-3695.968,139.6564,0,0,0,0,100,0), +(@PATH,40,1572.49,-3694.218,140.1564,0,0,0,0,100,0), +(@PATH,41,1570.49,-3692.468,140.9064,0,0,0,0,100,0), +(@PATH,42,1568.99,-3691.218,141.6564,0,0,0,0,100,0), +(@PATH,43,1568.49,-3690.468,142.4064,0,0,0,0,100,0), +(@PATH,44,1568.145,-3690.411,142.5955,0,0,0,0,100,0), +(@PATH,45,1567.645,-3690.161,142.5955,0,0,0,0,100,0), +(@PATH,46,1565.145,-3692.411,143.0955,0,0,0,0,100,0), +(@PATH,47,1564.663,-3692.634,143.4413,0,0,0,0,100,0), +(@PATH,48,1563.913,-3693.884,143.9413,0,0,0,0,100,0), +(@PATH,49,1563.413,-3696.884,144.6913,0,0,0,0,100,0), +(@PATH,50,1563.163,-3698.884,145.1913,0,0,0,0,100,0), +(@PATH,51,1562.913,-3700.634,145.9413,0,0,0,0,100,0), +(@PATH,52,1562.413,-3703.384,146.4413,0,0,0,0,100,0), +(@PATH,53,1562.163,-3705.384,147.1913,0,0,0,0,100,0), +(@PATH,54,1562.282,-3705.127,147.1324,0,0,0,0,100,0), +(@PATH,55,1562.532,-3703.127,146.6324,0,0,0,0,100,0), +(@PATH,56,1562.532,-3700.377,145.8824,0,0,0,0,100,0), +(@PATH,57,1563.032,-3698.627,145.3824,0,0,0,0,100,0), +(@PATH,58,1563.282,-3696.627,144.6324,0,0,0,0,100,0), +(@PATH,59,1563.532,-3694.627,144.1324,0,0,0,0,100,0), +(@PATH,60,1563.753,-3694.233,143.727,0,0,0,0,100,0), +(@PATH,61,1563.753,-3693.483,143.727,0,0,0,0,100,0), +(@PATH,62,1565.253,-3692.483,143.227,0,0,0,0,100,0), +(@PATH,63,1567.878,-3689.968,142.6124,0,0,0,0,100,0), +(@PATH,64,1569.378,-3691.468,141.8624,0,0,0,0,100,0), +(@PATH,65,1569.878,-3692.218,141.1124,0,0,0,0,100,0), +(@PATH,66,1572.128,-3693.968,140.1124,0,0,0,0,100,0), +(@PATH,67,1572.214,-3694.074,139.9068,0,0,0,0,100,0), +(@PATH,68,1572.714,-3694.574,139.9068,0,0,0,0,100,0), +(@PATH,69,1573.214,-3696.574,139.1568,0,0,0,0,100,0), +(@PATH,70,1573.714,-3700.324,138.6568,0,0,0,0,100,0), +(@PATH,71,1574.214,-3702.324,137.9068,0,0,0,0,100,0), +(@PATH,72,1574.964,-3705.074,137.4068,0,0,0,0,100,0), +(@PATH,73,1575.214,-3706.074,136.9068,0,0,0,0,100,0), +(@PATH,74,1575.964,-3709.824,135.9068,0,0,0,0,100,0), +(@PATH,75,1576.406,-3710.099,135.5516,0,0,0,0,100,0), +(@PATH,76,1576.906,-3712.599,135.3016,0,0,0,0,100,0), +(@PATH,77,1577.656,-3714.599,134.8016,0,0,0,0,100,0), +(@PATH,78,1578.406,-3717.349,133.3016,0,0,0,0,100,0), +(@PATH,79,1578.906,-3719.099,132.5516,0,0,0,0,100,0), +(@PATH,80,1580.156,-3722.849,131.3016,0,0,0,0,100,0), +(@PATH,81,1581.406,-3726.599,130.3016,0,0,0,0,100,0), +(@PATH,82,1581.613,-3726.697,130.2634,0,0,0,0,100,0), +(@PATH,83,1582.113,-3728.197,129.7634,0,0,0,0,100,0), +(@PATH,84,1581.363,-3725.447,130.7634,0,0,0,0,100,0), +(@PATH,85,1580.363,-3722.447,131.5134,0,0,0,0,100,0), +(@PATH,86,1579.613,-3719.697,132.2634,0,0,0,0,100,0), +(@PATH,87,1579.113,-3717.947,132.7634,0,0,0,0,100,0), +(@PATH,88,1578.613,-3716.197,133.5134,0,0,0,0,100,0), +(@PATH,89,1578.113,-3714.197,134.7634,0,0,0,0,100,0), +(@PATH,90,1578.442,-3716.037,133.8488,0,0,0,0,100,0), +(@PATH,91,1578.192,-3714.287,134.5988,0,0,0,0,100,0), +(@PATH,92,1577.843,-3714.012,134.9969,0,0,0,0,100,0), +(@PATH,93,1577.343,-3712.012,135.4969,0,0,0,0,100,0), +(@PATH,94,1576.093,-3707.262,136.2469,0,0,0,0,100,0), +(@PATH,95,1576.093,-3706.262,136.7469,0,0,0,0,100,0), +(@PATH,96,1575.593,-3703.512,137.4969,0,0,0,0,100,0), +(@PATH,97,1575.093,-3701.762,138.2469,0,0,0,0,100,0), +(@PATH,98,1574.593,-3699.762,138.7469,0,0,0,0,100,0), +(@PATH,99,1573.843,-3695.762,139.4969,0,0,0,0,100,0), +(@PATH,100,1568.976,-3688.636,142.5653,0,0,0,0,100,0), +(@PATH,101,1568.226,-3687.636,142.3153,0,0,0,0,100,0), +(@PATH,102,1569.063,-3682.779,141.6766,0,0,0,0,100,0), +(@PATH,103,1569.063,-3680.779,140.6766,0,0,0,0,100,0), +(@PATH,104,1569.313,-3678.779,139.9266,0,0,0,0,100,0), +(@PATH,105,1569.313,-3676.779,138.9266,0,0,0,0,100,0), +(@PATH,106,1569.313,-3675.779,138.1766,0,0,0,0,100,0), +(@PATH,107,1569.563,-3675.029,137.6766,0,0,0,0,100,0), +(@PATH,108,1569.813,-3672.029,136.6766,0,0,0,0,100,0), +(@PATH,109,1569.813,-3671.029,135.6766,0,0,0,0,100,0), +(@PATH,110,1569.813,-3670.029,134.9266,0,0,0,0,100,0), +(@PATH,111,1570.063,-3669.029,134.1766,0,0,0,0,100,0), +(@PATH,112,1570.063,-3668.029,133.6766,0,0,0,0,100,0), +(@PATH,113,1570.063,-3667.029,132.9266,0,0,0,0,100,0), +(@PATH,114,1570.313,-3666.029,132.4266,0,0,0,0,100,0), +(@PATH,115,1570.069,-3667.037,132.9397,0,0,0,0,100,0), +(@PATH,116,1570.069,-3668.037,133.6897,0,0,0,0,100,0), +(@PATH,117,1570.069,-3669.037,134.1897,0,0,0,0,100,0), +(@PATH,118,1569.819,-3670.037,134.9397,0,0,0,0,100,0), +(@PATH,119,1569.819,-3671.037,135.6897,0,0,0,0,100,0), +(@PATH,120,1569.819,-3672.037,136.4397,0,0,0,0,100,0); |