diff options
| -rw-r--r-- | sql/updates/world/2015_05_31_04_world.sql | 1179 |
1 files changed, 1179 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_31_04_world.sql b/sql/updates/world/2015_05_31_04_world.sql new file mode 100644 index 00000000000..94785d6d356 --- /dev/null +++ b/sql/updates/world/2015_05_31_04_world.sql @@ -0,0 +1,1179 @@ +-- Howling Fjord - Part VI +SET @NPC := 105137; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=816.3098,`position_y`=-5566.948,`position_z`=220.0096 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,816.3098,-5566.948,220.0096,0,0,0,0,100,0), +(@PATH,2,815.8098,-5563.948,219.5096,0,0,0,0,100,0), +(@PATH,3,815.5598,-5560.948,218.7596,0,0,0,0,100,0), +(@PATH,4,815.3098,-5557.948,218.2596,0,0,0,0,100,0), +(@PATH,5,815.0598,-5554.948,217.2596,0,0,0,0,100,0), +(@PATH,6,814.8098,-5551.948,216.5096,0,0,0,0,100,0), +(@PATH,7,814.8098,-5549.948,215.2596,0,0,0,0,100,0), +(@PATH,8,814.5598,-5546.948,214.5096,0,0,0,0,100,0), +(@PATH,9,814.3098,-5542.198,214.0096,0,0,0,0,100,0), +(@PATH,10,812.1687,-5520.625,213.7769,0,0,0,0,100,0), +(@PATH,11,803.1687,-5520.125,214.5269,0,0,0,0,100,0), +(@PATH,12,801.1687,-5519.875,215.2769,0,0,0,0,100,0), +(@PATH,13,799.1687,-5519.875,216.0269,0,0,0,0,100,0), +(@PATH,14,798.1687,-5519.875,216.5269,0,0,0,0,100,0), +(@PATH,15,796.4187,-5519.625,217.5269,0,0,0,0,100,0), +(@PATH,16,794.4187,-5519.625,218.2769,0,0,0,0,100,0), +(@PATH,17,782.4187,-5518.625,217.5269,0,0,0,0,100,0), +(@PATH,18,781.7379,-5518.72,218.0693,0,0,0,0,100,0), +(@PATH,19,769.2379,-5520.97,218.8193,0,0,0,0,100,0), +(@PATH,20,767.2379,-5520.97,219.8193,0,0,0,0,100,0), +(@PATH,21,765.2379,-5521.47,220.3193,0,0,0,0,100,0), +(@PATH,22,763.4879,-5521.72,221.3193,0,0,0,0,100,0), +(@PATH,23,757.4879,-5522.72,222.3193,0,0,0,0,100,0), +(@PATH,24,758.4562,-5522.488,221.754,0,0,0,0,100,0), +(@PATH,25,764.2062,-5521.488,220.754,0,0,0,0,100,0), +(@PATH,26,766.2062,-5521.238,220.004,0,0,0,0,100,0), +(@PATH,27,768.2062,-5520.988,219.504,0,0,0,0,100,0), +(@PATH,28,769.9562,-5520.738,218.254,0,0,0,0,100,0), +(@PATH,29,774.9562,-5519.988,217.754,0,0,0,0,100,0), +(@PATH,30,781.9653,-5518.806,217.9444,0,0,0,0,100,0), +(@PATH,31,785.9653,-5519.056,218.6944,0,0,0,0,100,0), +(@PATH,32,795.7153,-5519.806,217.9444,0,0,0,0,100,0), +(@PATH,33,797.7153,-5519.806,217.1944,0,0,0,0,100,0), +(@PATH,34,798.7153,-5519.806,216.6944,0,0,0,0,100,0), +(@PATH,35,799.7153,-5520.056,215.9444,0,0,0,0,100,0), +(@PATH,36,801.7153,-5520.056,215.4444,0,0,0,0,100,0), +(@PATH,37,803.7153,-5520.056,214.6944,0,0,0,0,100,0), +(@PATH,38,806.7153,-5520.056,213.9444,0,0,0,0,100,0), +(@PATH,39,812.3559,-5520.624,213.6841,0,0,0,0,100,0), +(@PATH,40,814.3559,-5546.374,214.4341,0,0,0,0,100,0), +(@PATH,41,814.8559,-5550.374,215.1841,0,0,0,0,100,0), +(@PATH,42,815.1059,-5553.374,216.6841,0,0,0,0,100,0), +(@PATH,43,815.1059,-5555.374,217.6841,0,0,0,0,100,0), +(@PATH,44,815.3559,-5558.374,218.4341,0,0,0,0,100,0), +(@PATH,45,815.6059,-5561.374,219.1841,0,0,0,0,100,0), +(@PATH,46,816.1059,-5565.374,219.6841,0,0,0,0,100,0), +(@PATH,47,816.2936,-5565.591,219.9167,0,0,0,0,100,0), +(@PATH,48,816.5436,-5567.091,220.4167,0,0,0,0,100,0), +(@PATH,49,819.0436,-5572.591,221.1667,0,0,0,0,100,0), +(@PATH,50,820.7936,-5576.091,221.6667,0,0,0,0,100,0), +(@PATH,51,823.0436,-5580.591,222.1667,0,0,0,0,100,0), +(@PATH,52,825.5436,-5585.591,222.9167,0,0,0,0,100,0), +(@PATH,53,826.7936,-5588.341,223.6667,0,0,0,0,100,0), +(@PATH,54,828.7936,-5591.841,224.4167,0,0,0,0,100,0), +(@PATH,55,832.8285,-5600.151,224.2254,0,0,0,0,100,0), +(@PATH,56,835.0785,-5602.401,223.4754,0,0,0,0,100,0), +(@PATH,57,837.8285,-5605.151,222.9754,0,0,0,0,100,0), +(@PATH,58,842.0785,-5609.401,222.2254,0,0,0,0,100,0), +(@PATH,59,845.5785,-5613.151,221.7254,0,0,0,0,100,0), +(@PATH,60,847.8285,-5615.151,221.2254,0,0,0,0,100,0), +(@PATH,61,850.3285,-5617.651,220.4754,0,0,0,0,100,0), +(@PATH,62,852.3285,-5619.901,219.7254,0,0,0,0,100,0), +(@PATH,63,855.3285,-5622.651,219.2254,0,0,0,0,100,0), +(@PATH,64,858.8285,-5626.401,218.4754,0,0,0,0,100,0), +(@PATH,65,865.0785,-5632.651,219.2254,0,0,0,0,100,0), +(@PATH,66,865.2173,-5632.964,219.2449,0,0,0,0,100,0), +(@PATH,67,865.9673,-5633.464,219.2449,0,0,0,0,100,0), +(@PATH,68,870.4673,-5635.464,219.9949,0,0,0,0,100,0), +(@PATH,69,892.4673,-5644.714,220.7449,0,0,0,0,100,0), +(@PATH,70,897.9673,-5646.964,221.4949,0,0,0,0,100,0), +(@PATH,71,894.5841,-5645.571,221.1267,0,0,0,0,100,0), +(@PATH,72,890.8341,-5644.071,220.3767,0,0,0,0,100,0), +(@PATH,73,887.0841,-5642.321,219.8767,0,0,0,0,100,0), +(@PATH,74,880.8341,-5639.821,220.1267,0,0,0,0,100,0), +(@PATH,75,867.0841,-5634.071,219.3767,0,0,0,0,100,0), +(@PATH,76,866.8998,-5633.889,219.3101,0,0,0,0,100,0), +(@PATH,77,865.6498,-5633.139,219.3101,0,0,0,0,100,0), +(@PATH,78,862.8998,-5630.389,218.8101,0,0,0,0,100,0), +(@PATH,79,855.1498,-5622.639,219.3101,0,0,0,0,100,0), +(@PATH,80,851.6498,-5619.139,220.0601,0,0,0,0,100,0), +(@PATH,81,849.6498,-5617.139,220.8101,0,0,0,0,100,0), +(@PATH,82,846.8998,-5614.389,221.5601,0,0,0,0,100,0), +(@PATH,83,844.8998,-5612.139,221.8101,0,0,0,0,100,0), +(@PATH,84,840.6498,-5607.889,222.5601,0,0,0,0,100,0), +(@PATH,85,836.3998,-5603.639,223.3101,0,0,0,0,100,0), +(@PATH,86,834.1498,-5601.389,223.8101,0,0,0,0,100,0), +(@PATH,87,832.7264,-5599.951,224.1247,0,0,0,0,100,0), +(@PATH,88,830.9764,-5596.451,224.8747,0,0,0,0,100,0), +(@PATH,89,828.2264,-5590.951,224.1247,0,0,0,0,100,0), +(@PATH,90,825.9764,-5586.451,223.3747,0,0,0,0,100,0), +(@PATH,91,825.2264,-5584.701,222.6247,0,0,0,0,100,0), +(@PATH,92,822.7264,-5579.701,221.8747,0,0,0,0,100,0), +(@PATH,93,819.9764,-5574.201,221.6247,0,0,0,0,100,0), +(@PATH,94,818.2264,-5570.701,220.8747,0,0,0,0,100,0); + +SET @NPC := 105145; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=944.9855,`position_y`=-5700.701,`position_z`=225.9025 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,944.9855,-5700.701,225.9025,0,0,0,0,100,0), +(@PATH,2,949.9855,-5699.701,225.6525,0,0,0,0,100,0), +(@PATH,3,955.4855,-5698.701,226.1525,0,0,0,0,100,0), +(@PATH,4,965.2653,-5696.642,225.4637,0,0,0,0,100,0), +(@PATH,5,973.7653,-5693.142,224.9637,0,0,0,0,100,0), +(@PATH,6,976.5153,-5692.142,224.2137,0,0,0,0,100,0), +(@PATH,7,980.2653,-5690.642,223.4637,0,0,0,0,100,0), +(@PATH,8,984.0153,-5689.142,222.7137,0,0,0,0,100,0), +(@PATH,9,1000.515,-5682.892,222.2137,0,0,0,0,100,0), +(@PATH,10,1005.265,-5681.142,221.4637,0,0,0,0,100,0), +(@PATH,11,1008.859,-5679.514,221.7022,0,0,0,0,100,0), +(@PATH,12,1012.109,-5677.514,222.4522,0,0,0,0,100,0), +(@PATH,13,1016.359,-5674.764,223.2022,0,0,0,0,100,0), +(@PATH,14,1024.859,-5669.514,222.4522,0,0,0,0,100,0), +(@PATH,15,1033.859,-5664.014,222.9522,0,0,0,0,100,0), +(@PATH,16,1039.109,-5660.764,223.7022,0,0,0,0,100,0), +(@PATH,17,1046.609,-5656.014,222.9522,0,0,0,0,100,0), +(@PATH,18,1047.552,-5655.633,223.0285,0,0,0,0,100,0), +(@PATH,19,1044.052,-5657.633,223.5285,0,0,0,0,100,0), +(@PATH,20,1034.052,-5663.883,223.0285,0,0,0,0,100,0), +(@PATH,21,1030.552,-5666.133,222.5285,0,0,0,0,100,0), +(@PATH,22,1023.302,-5670.633,223.0285,0,0,0,0,100,0), +(@PATH,23,1011.302,-5677.883,222.2785,0,0,0,0,100,0), +(@PATH,24,1011.139,-5678.294,222.4689,0,0,0,0,100,0), +(@PATH,25,1008.389,-5679.794,221.7189,0,0,0,0,100,0), +(@PATH,26,999.139,-5683.544,222.7189,0,0,0,0,100,0), +(@PATH,27,983.639,-5689.294,223.2189,0,0,0,0,100,0), +(@PATH,28,978.889,-5691.294,223.7189,0,0,0,0,100,0), +(@PATH,29,976.139,-5692.294,224.4689,0,0,0,0,100,0), +(@PATH,30,972.389,-5693.794,225.2189,0,0,0,0,100,0), +(@PATH,31,964.9979,-5696.799,225.8529,0,0,0,0,100,0), +(@PATH,32,961.2479,-5697.549,226.1029,0,0,0,0,100,0), +(@PATH,33,949.7479,-5699.799,225.6029,0,0,0,0,100,0), +(@PATH,34,945.7479,-5700.549,226.1029,0,0,0,0,100,0), +(@PATH,35,942.7479,-5701.049,226.6029,0,0,0,0,100,0); + +SET @NPC := 115426; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=239.7068,`position_y`=-5681.223,`position_z`=129.7739 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,239.7068,-5681.223,129.7739,0,0,0,0,100,0), +(@PATH,2,247.9568,-5683.223,127.5239,0,0,0,0,100,0), +(@PATH,3,252.2291,-5684.197,125.1225,0,0,0,0,100,0), +(@PATH,4,256.2291,-5689.697,120.1225,0,0,0,0,100,0), +(@PATH,5,262.9791,-5699.697,114.1225,0,0,0,0,100,0), +(@PATH,6,264.9791,-5702.447,113.6225,0,0,0,0,100,0), +(@PATH,7,265.1768,-5702.77,113.3388,0,0,0,0,100,0), +(@PATH,8,266.9268,-5705.27,113.3388,0,0,0,0,100,0), +(@PATH,9,268.1768,-5706.52,112.5888,0,0,0,0,100,0), +(@PATH,10,269.1768,-5707.27,111.8388,0,0,0,0,100,0), +(@PATH,11,269.6768,-5708.02,111.3388,0,0,0,0,100,0), +(@PATH,12,274.2107,-5711.711,111.0118,0,0,0,0,100,0), +(@PATH,13,283.9607,-5709.711,109.5118,0,0,0,0,100,0), +(@PATH,14,290.4607,-5707.961,107.7618,0,0,0,0,100,0), +(@PATH,15,293.2107,-5707.711,106.7618,0,0,0,0,100,0), +(@PATH,16,297.7107,-5706.711,105.5118,0,0,0,0,100,0), +(@PATH,17,302.9607,-5705.461,103.2618,0,0,0,0,100,0), +(@PATH,18,305.0286,-5705.116,102.8382,0,0,0,0,100,0), +(@PATH,19,305.5286,-5706.366,102.5882,0,0,0,0,100,0), +(@PATH,20,306.0286,-5707.866,102.5882,0,0,0,0,100,0), +(@PATH,21,306.5286,-5709.366,102.3382,0,0,0,0,100,0), +(@PATH,22,308.2786,-5713.116,99.83823,0,0,0,0,100,0), +(@PATH,23,309.0747,-5715.212,98.81648,0,0,0,0,100,0), +(@PATH,24,307.3247,-5716.712,98.31648,0,0,0,0,100,0), +(@PATH,25,303.3247,-5720.212,96.81648,0,0,0,0,100,0), +(@PATH,26,298.3247,-5724.212,96.56648,0,0,0,0,100,0), +(@PATH,27,292.8247,-5728.962,97.06648,0,0,0,0,100,0), +(@PATH,28,290.8247,-5730.462,97.06648,0,0,0,0,100,0), +(@PATH,29,288.426,-5732.716,96.61787,0,0,0,0,100,0), +(@PATH,30,287.926,-5740.216,95.11787,0,0,0,0,100,0), +(@PATH,31,287.926,-5742.216,95.11787,0,0,0,0,100,0), +(@PATH,32,287.926,-5744.216,94.11787,0,0,0,0,100,0), +(@PATH,33,287.676,-5746.216,93.11787,0,0,0,0,100,0), +(@PATH,34,287.2972,-5755.464,89.91927,0,0,0,0,100,0), +(@PATH,35,288.2972,-5758.714,88.66927,0,0,0,0,100,0), +(@PATH,36,291.5472,-5767.964,86.41927,0,0,0,0,100,0), +(@PATH,37,297.7972,-5786.214,82.41927,0,0,0,0,100,0), +(@PATH,38,300.7485,-5793.833,82.27162,0,0,0,0,100,0), +(@PATH,39,301.2485,-5794.833,82.27162,0,0,0,0,100,0), +(@PATH,40,309.7736,-5808.727,82.54448,0,0,0,0,100,0), +(@PATH,41,309.5236,-5809.977,82.54448,0,0,0,0,100,0), +(@PATH,42,308.0236,-5815.977,82.54448,0,0,0,0,100,0), +(@PATH,43,305.2736,-5827.477,83.04448,0,0,0,0,100,0), +(@PATH,44,305.0289,-5827.861,83.46511,0,0,0,0,100,0), +(@PATH,45,304.7789,-5828.861,83.46511,0,0,0,0,100,0), +(@PATH,46,296.7789,-5831.861,83.71511,0,0,0,0,100,0), +(@PATH,47,291.7789,-5833.361,83.71511,0,0,0,0,100,0), +(@PATH,48,284.5289,-5836.111,83.96511,0,0,0,0,100,0), +(@PATH,49,281.5289,-5837.111,84.46511,0,0,0,0,100,0), +(@PATH,50,281.3865,-5837.156,84.54872,0,0,0,0,100,0), +(@PATH,51,283.8865,-5836.406,84.04872,0,0,0,0,100,0), +(@PATH,52,291.1365,-5833.656,83.79872,0,0,0,0,100,0), +(@PATH,53,296.8865,-5831.906,83.79872,0,0,0,0,100,0), +(@PATH,54,309.6002,-5809.838,82.32693,0,0,0,0,100,0), +(@PATH,55,309.8502,-5808.588,82.32693,0,0,0,0,100,0), +(@PATH,56,301.3502,-5794.588,82.07693,0,0,0,0,100,0), +(@PATH,57,287.1544,-5755.315,89.9707,0,0,0,0,100,0), +(@PATH,58,287.6544,-5746.315,92.9707,0,0,0,0,100,0), +(@PATH,59,287.6544,-5745.315,93.4707,0,0,0,0,100,0), +(@PATH,60,287.9044,-5742.065,95.2207,0,0,0,0,100,0), +(@PATH,61,287.9044,-5740.315,94.9707,0,0,0,0,100,0), +(@PATH,62,288.3708,-5732.422,96.87263,0,0,0,0,100,0), +(@PATH,63,290.8708,-5730.672,97.12263,0,0,0,0,100,0), +(@PATH,64,292.1208,-5729.422,97.12263,0,0,0,0,100,0), +(@PATH,65,298.3708,-5724.422,96.62263,0,0,0,0,100,0), +(@PATH,66,303.3708,-5720.172,96.87263,0,0,0,0,100,0), +(@PATH,67,307.3708,-5716.672,98.37263,0,0,0,0,100,0), +(@PATH,68,309.1218,-5715.098,99.18263,0,0,0,0,100,0), +(@PATH,69,308.3718,-5713.098,99.68263,0,0,0,0,100,0), +(@PATH,70,306.6218,-5709.348,102.1826,0,0,0,0,100,0), +(@PATH,71,306.1218,-5707.848,102.6826,0,0,0,0,100,0), +(@PATH,72,305.6218,-5706.348,102.6826,0,0,0,0,100,0), +(@PATH,73,305.2986,-5706.288,102.8929,0,0,0,0,100,0), +(@PATH,74,304.7986,-5705.038,103.1429,0,0,0,0,100,0), +(@PATH,75,303.0486,-5705.538,103.3929,0,0,0,0,100,0), +(@PATH,76,297.5486,-5706.788,105.3929,0,0,0,0,100,0), +(@PATH,77,293.2986,-5707.538,106.6429,0,0,0,0,100,0), +(@PATH,78,290.5486,-5708.288,107.8929,0,0,0,0,100,0), +(@PATH,79,284.0486,-5709.538,109.6429,0,0,0,0,100,0), +(@PATH,80,275.2986,-5711.538,110.8929,0,0,0,0,100,0), +(@PATH,81,274.9447,-5711.463,111.1453,0,0,0,0,100,0), +(@PATH,82,273.9447,-5711.713,111.1453,0,0,0,0,100,0), +(@PATH,83,269.9447,-5708.213,111.3953,0,0,0,0,100,0), +(@PATH,84,269.1947,-5707.463,111.8953,0,0,0,0,100,0), +(@PATH,85,268.1947,-5706.463,112.6453,0,0,0,0,100,0), +(@PATH,86,267.1947,-5705.463,113.3953,0,0,0,0,100,0), +(@PATH,87,268.0941,-5706.162,112.8736,0,0,0,0,100,0), +(@PATH,88,267.0941,-5705.412,113.6236,0,0,0,0,100,0), +(@PATH,89,266.5941,-5704.912,113.6236,0,0,0,0,100,0), +(@PATH,90,264.8441,-5702.412,113.6236,0,0,0,0,100,0), +(@PATH,91,262.8441,-5699.662,114.1236,0,0,0,0,100,0), +(@PATH,92,256.0941,-5689.662,120.1236,0,0,0,0,100,0); + +SET @NPC := 115450; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=140.9981,`position_y`=-5773.847,`position_z`=19.01464 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,140.9981,-5773.847,19.01464,0,0,0,0,100,0), +(@PATH,2,149.7481,-5767.347,26.26464,0,0,0,0,100,0), +(@PATH,3,152.0051,-5765.768,26.5225,0,0,0,0,100,0), +(@PATH,4,155.5753,-5770.291,26.51275,0,0,0,0,100,0), +(@PATH,5,153.3253,-5772.041,26.51275,0,0,0,0,100,0), +(@PATH,6,171.1161,-5783.031,37.94518,0,0,0,0,100,0), +(@PATH,7,172.1161,-5782.281,38.19518,0,0,0,0,100,0), +(@PATH,8,173.3661,-5784.281,38.19518,0,0,0,0,100,0), +(@PATH,9,174.3661,-5785.781,38.19518,0,0,0,0,100,0), +(@PATH,10,178.1161,-5791.031,38.19518,0,0,0,0,100,0), +(@PATH,11,178.3661,-5791.281,38.44518,0,0,0,0,100,0), +(@PATH,12,179.1161,-5792.281,38.44518,0,0,0,0,100,0), +(@PATH,13,179.6161,-5793.031,38.69518,0,0,0,0,100,0), +(@PATH,14,183.2137,-5797.427,38.54925,0,0,0,0,100,0), +(@PATH,15,188.9637,-5794.427,38.79925,0,0,0,0,100,0), +(@PATH,16,194.2137,-5791.427,38.79925,0,0,0,0,100,0), +(@PATH,17,197.9637,-5789.927,38.79925,0,0,0,0,100,0), +(@PATH,18,201.9637,-5787.677,38.79925,0,0,0,0,100,0), +(@PATH,19,203.2137,-5787.177,38.79925,0,0,0,0,100,0), +(@PATH,20,203.3189,-5787.2,38.92299,0,0,0,0,100,0), +(@PATH,21,205.5689,-5785.95,38.92299,0,0,0,0,100,0), +(@PATH,22,209.3189,-5789.2,38.92299,0,0,0,0,100,0), +(@PATH,23,210.2086,-5789.723,38.42034,0,0,0,0,100,0), +(@PATH,24,205.3679,-5786.115,38.86655,0,0,0,0,100,0), +(@PATH,25,203.1179,-5787.115,38.86655,0,0,0,0,100,0), +(@PATH,26,202.1179,-5787.615,38.86655,0,0,0,0,100,0), +(@PATH,27,198.1179,-5789.865,38.86655,0,0,0,0,100,0), +(@PATH,28,194.3679,-5791.865,38.61655,0,0,0,0,100,0), +(@PATH,29,188.8679,-5794.365,38.61655,0,0,0,0,100,0), +(@PATH,30,183.0873,-5797.504,38.70325,0,0,0,0,100,0), +(@PATH,31,179.8373,-5793.004,38.70325,0,0,0,0,100,0), +(@PATH,32,178.5873,-5791.504,38.70325,0,0,0,0,100,0), +(@PATH,33,174.5873,-5786.004,38.20325,0,0,0,0,100,0), +(@PATH,34,171.8038,-5782.26,38.09947,0,0,0,0,100,0), +(@PATH,35,170.8038,-5783.01,38.09947,0,0,0,0,100,0), +(@PATH,36,164.439,-5786.881,32.69273,0,0,0,0,100,0), +(@PATH,37,163.439,-5786.631,32.69273,0,0,0,0,100,0), +(@PATH,38,159.4063,-5785.582,32.43161,0,0,0,0,100,0), +(@PATH,39,153.9063,-5777.832,26.43161,0,0,0,0,100,0), +(@PATH,40,151.3135,-5774.021,26.20842,0,0,0,0,100,0), +(@PATH,41,153.5635,-5772.271,26.45842,0,0,0,0,100,0), +(@PATH,42,155.4806,-5770.13,26.60295,0,0,0,0,100,0), +(@PATH,43,151.7648,-5765.865,26.50707,0,0,0,0,100,0), +(@PATH,44,149.7648,-5767.365,26.50707,0,0,0,0,100,0), +(@PATH,45,140.7411,-5774.141,19.1757,0,0,0,0,100,0), +(@PATH,46,137.4911,-5776.641,19.1757,0,0,0,0,100,0), +(@PATH,47,132.9596,-5779.951,18.79716,0,0,0,0,100,0), +(@PATH,48,129.4596,-5782.451,15.79716,0,0,0,0,100,0), +(@PATH,49,126.1635,-5784.941,13.47462,0,0,0,0,100,0), +(@PATH,50,124.4135,-5786.191,13.47462,0,0,0,0,100,0), +(@PATH,51,124.4538,-5786.278,13.20907,0,0,0,0,100,0); + +SET @NPC := 115446; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=334.0038,`position_y`=-5775.901,`position_z`=267.0645 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,334.0038,-5775.901,267.0645,0,0,0,0,100,0), +(@PATH,2,312.5038,-5755.151,267.5645,0,0,0,0,100,0), +(@PATH,3,309.0038,-5751.901,268.0645,0,0,0,0,100,0), +(@PATH,4,306.2538,-5748.901,268.5645,0,0,0,0,100,0), +(@PATH,5,286.969,-5721.298,280.3217,0,0,0,0,100,0), +(@PATH,6,283.219,-5720.548,280.0717,0,0,0,0,100,0), +(@PATH,7,274.969,-5718.548,280.5717,0,0,0,0,100,0), +(@PATH,8,272.969,-5716.298,281.0717,0,0,0,0,100,0), +(@PATH,9,266.969,-5712.798,281.3217,0,0,0,0,100,0), +(@PATH,10,266.719,-5712.548,281.5717,0,0,0,0,100,0), +(@PATH,11,261.219,-5710.298,282.0717,0,0,0,0,100,0), +(@PATH,12,258.469,-5709.298,282.0717,0,0,0,0,100,0), +(@PATH,13,256.219,-5708.548,281.8217,0,0,0,0,100,0), +(@PATH,14,244.2268,-5703.188,283.5253,0,0,0,0,100,0), +(@PATH,15,211.0123,-5688.659,286.9947,0,0,0,0,100,0), +(@PATH,16,209.2623,-5690.159,287.2447,0,0,0,0,100,0), +(@PATH,17,206.7623,-5692.909,286.7447,0,0,0,0,100,0), +(@PATH,18,203.5123,-5696.159,286.7447,0,0,0,0,100,0), +(@PATH,19,198.4904,-5700.964,286.617,0,0,0,0,100,0), +(@PATH,20,192.7404,-5701.464,286.617,0,0,0,0,100,0), +(@PATH,21,190.7404,-5701.464,286.617,0,0,0,0,100,0), +(@PATH,22,180.7404,-5702.214,286.617,0,0,0,0,100,0), +(@PATH,23,178.9904,-5702.214,286.367,0,0,0,0,100,0), +(@PATH,24,150.003,-5703.872,285.9841,0,0,0,0,100,0), +(@PATH,25,153.253,-5703.872,285.9841,0,0,0,0,100,0), +(@PATH,26,156.503,-5703.622,285.7341,0,0,0,0,100,0), +(@PATH,27,164.503,-5703.372,285.7341,0,0,0,0,100,0), +(@PATH,28,166.003,-5703.122,285.7341,0,0,0,0,100,0), +(@PATH,29,173.2124,-5702.439,286.3379,0,0,0,0,100,0), +(@PATH,30,178.9624,-5702.189,286.3379,0,0,0,0,100,0), +(@PATH,31,180.4624,-5702.189,286.5879,0,0,0,0,100,0), +(@PATH,32,190.7124,-5701.689,286.5879,0,0,0,0,100,0), +(@PATH,33,192.7124,-5701.689,286.5879,0,0,0,0,100,0), +(@PATH,34,198.4325,-5701.038,286.6688,0,0,0,0,100,0), +(@PATH,35,203.4325,-5696.288,286.6688,0,0,0,0,100,0), +(@PATH,36,206.6825,-5692.788,286.6688,0,0,0,0,100,0), +(@PATH,37,209.1825,-5690.288,286.6688,0,0,0,0,100,0), +(@PATH,38,211.0664,-5688.54,287.0768,0,0,0,0,100,0), +(@PATH,39,244.3347,-5703.374,283.1249,0,0,0,0,100,0), +(@PATH,40,257.0847,-5707.874,281.6249,0,0,0,0,100,0), +(@PATH,41,258.5847,-5709.374,282.1249,0,0,0,0,100,0), +(@PATH,42,266.5847,-5712.374,281.6249,0,0,0,0,100,0), +(@PATH,43,272.5847,-5716.124,281.1249,0,0,0,0,100,0), +(@PATH,44,272.8347,-5716.374,281.1249,0,0,0,0,100,0), +(@PATH,45,275.0847,-5718.624,280.6249,0,0,0,0,100,0), +(@PATH,46,283.3347,-5720.624,280.1249,0,0,0,0,100,0), +(@PATH,47,283.5627,-5720.765,279.8456,0,0,0,0,100,0), +(@PATH,48,287.0627,-5721.265,280.0956,0,0,0,0,100,0), +(@PATH,49,289.3127,-5724.765,279.3456,0,0,0,0,100,0), +(@PATH,50,290.3127,-5726.265,278.5956,0,0,0,0,100,0), +(@PATH,51,291.3127,-5728.015,277.8456,0,0,0,0,100,0), +(@PATH,52,292.8127,-5730.515,275.8456,0,0,0,0,100,0), +(@PATH,53,293.8127,-5732.265,274.8456,0,0,0,0,100,0), +(@PATH,54,294.8127,-5733.765,273.3456,0,0,0,0,100,0), +(@PATH,55,296.0627,-5735.265,272.0956,0,0,0,0,100,0), +(@PATH,56,297.0627,-5737.015,271.3456,0,0,0,0,100,0), +(@PATH,57,298.0627,-5738.765,270.3456,0,0,0,0,100,0), +(@PATH,58,299.3127,-5740.515,269.8456,0,0,0,0,100,0), +(@PATH,59,301.3127,-5743.765,269.3456,0,0,0,0,100,0), +(@PATH,60,301.7428,-5743.971,269.0061,0,0,0,0,100,0), +(@PATH,61,302.7428,-5745.971,269.0061,0,0,0,0,100,0), +(@PATH,62,307.2428,-5749.971,268.5061,0,0,0,0,100,0), +(@PATH,63,309.9928,-5752.721,267.7561,0,0,0,0,100,0), +(@PATH,64,312.9928,-5755.721,267.5061,0,0,0,0,100,0), +(@PATH,65,328.4928,-5770.721,266.7561,0,0,0,0,100,0); + +SET @NPC := 115450; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=137.8599,`position_y`=-5750.369,`position_z`=36.78536 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,137.8599,-5750.369,36.78536,0,0,0,0,100,0), +(@PATH,2,140.1099,-5752.369,34.53536,0,0,0,0,100,0), +(@PATH,3,141.3599,-5753.869,33.28536,0,0,0,0,100,0), +(@PATH,4,142.1099,-5754.619,32.03536,0,0,0,0,100,0), +(@PATH,5,143.8599,-5756.619,30.03536,0,0,0,0,100,0), +(@PATH,6,146.1099,-5758.619,27.78536,0,0,0,0,100,0), +(@PATH,7,145.8599,-5758.369,27.78536,0,0,0,0,100,0), +(@PATH,8,144.3599,-5757.119,30.03536,0,0,0,0,100,0), +(@PATH,9,143.1099,-5755.619,31.03536,0,0,0,0,100,0), +(@PATH,10,142.3599,-5754.869,32.03536,0,0,0,0,100,0), +(@PATH,11,141.1099,-5753.619,33.28536,0,0,0,0,100,0), +(@PATH,12,140.6099,-5752.869,34.53536,0,0,0,0,100,0), +(@PATH,13,139.1099,-5751.619,35.78536,0,0,0,0,100,0), +(@PATH,14,138.3599,-5750.869,36.78536,0,0,0,0,100,0), +(@PATH,15,130.5795,-5750.106,38.92016,0,0,0,0,100,0), +(@PATH,16,129.3295,-5749.106,39.92016,0,0,0,0,100,0), +(@PATH,17,133.3295,-5749.356,38.92016,0,0,0,0,100,0), +(@PATH,18,135.0795,-5749.606,38.42016,0,0,0,0,100,0), +(@PATH,19,135.321,-5749.533,38.50644,0,0,0,0,100,0), +(@PATH,20,137.321,-5749.533,38.00644,0,0,0,0,100,0); + +SET @NPC := 115458; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=219.9613,`position_y`=-5839.253,`position_z`=17.05329 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,219.9613,-5839.253,17.05329,0,0,0,0,100,0), +(@PATH,2,219.2113,-5837.503,17.05329,0,0,0,0,100,0), +(@PATH,3,216.7113,-5831.753,17.05329,0,0,0,0,100,0), +(@PATH,4,215.9613,-5830.003,17.05329,0,0,0,0,100,0), +(@PATH,5,214.2113,-5826.253,19.55329,0,0,0,0,100,0), +(@PATH,6,212.4613,-5822.503,22.55329,0,0,0,0,100,0), +(@PATH,7,212.3707,-5822.154,22.7486,0,0,0,0,100,0), +(@PATH,8,212.1207,-5821.654,22.7486,0,0,0,0,100,0), +(@PATH,9,210.8707,-5817.904,22.7486,0,0,0,0,100,0), +(@PATH,10,209.1207,-5812.904,22.7486,0,0,0,0,100,0), +(@PATH,11,205.6207,-5802.404,29.9986,0,0,0,0,100,0), +(@PATH,12,205.7854,-5802.209,29.86267,0,0,0,0,100,0), +(@PATH,13,205.5354,-5801.709,30.11267,0,0,0,0,100,0), +(@PATH,14,206.2854,-5800.709,30.11267,0,0,0,0,100,0), +(@PATH,15,206.2,-5800.744,30.20782,0,0,0,0,100,0), +(@PATH,16,207.95,-5798.744,30.20782,0,0,0,0,100,0), +(@PATH,17,210.7,-5800.494,30.20782,0,0,0,0,100,0), +(@PATH,18,218.0537,-5805.39,29.74542,0,0,0,0,100,0), +(@PATH,19,221.8037,-5803.89,29.74542,0,0,0,0,100,0), +(@PATH,20,223.3037,-5803.39,29.74542,0,0,0,0,100,0), +(@PATH,21,228.5537,-5801.64,29.74542,0,0,0,0,100,0), +(@PATH,22,230.657,-5803.202,30.17958,0,0,0,0,100,0), +(@PATH,23,231.657,-5804.202,30.67958,0,0,0,0,100,0), +(@PATH,24,231.907,-5804.952,30.42958,0,0,0,0,100,0), +(@PATH,25,232.157,-5806.202,30.92958,0,0,0,0,100,0), +(@PATH,26,233.907,-5811.952,33.92958,0,0,0,0,100,0), +(@PATH,27,234.8766,-5814.844,35.80687,0,0,0,0,100,0), +(@PATH,28,239.3766,-5825.844,42.30687,0,0,0,0,100,0), +(@PATH,29,239.6192,-5826.252,41.11646,0,0,0,0,100,0), +(@PATH,30,243.3692,-5830.752,41.11646,0,0,0,0,100,0), +(@PATH,31,244.1192,-5831.502,41.11646,0,0,0,0,100,0), +(@PATH,32,246.6192,-5834.252,40.36646,0,0,0,0,100,0), +(@PATH,33,248.8373,-5836.398,40.56731,0,0,0,0,100,0), +(@PATH,34,247.5873,-5837.898,39.31731,0,0,0,0,100,0), +(@PATH,35,246.3373,-5839.648,38.31731,0,0,0,0,100,0), +(@PATH,36,244.5873,-5841.898,36.06731,0,0,0,0,100,0), +(@PATH,37,243.3373,-5843.398,35.31731,0,0,0,0,100,0), +(@PATH,38,242.0873,-5845.148,33.81731,0,0,0,0,100,0), +(@PATH,39,240.3373,-5847.148,32.31731,0,0,0,0,100,0), +(@PATH,40,239.3373,-5848.898,31.06731,0,0,0,0,100,0), +(@PATH,41,238.0873,-5850.398,30.06731,0,0,0,0,100,0), +(@PATH,42,236.3373,-5852.648,28.06731,0,0,0,0,100,0), +(@PATH,43,234.3373,-5855.148,26.06731,0,0,0,0,100,0), +(@PATH,44,234.0734,-5855.38,25.81997,0,0,0,0,100,0), +(@PATH,45,233.3234,-5856.38,25.31997,0,0,0,0,100,0), +(@PATH,46,231.5734,-5857.13,24.56997,0,0,0,0,100,0), +(@PATH,47,230.5734,-5857.38,23.31997,0,0,0,0,100,0), +(@PATH,48,228.8234,-5858.13,21.81997,0,0,0,0,100,0), +(@PATH,49,227.8234,-5858.38,21.06997,0,0,0,0,100,0), +(@PATH,50,226.8234,-5858.63,20.31997,0,0,0,0,100,0), +(@PATH,51,226.3234,-5858.88,19.31997,0,0,0,0,100,0), +(@PATH,52,224.3234,-5859.63,18.56997,0,0,0,0,100,0), +(@PATH,53,222.5734,-5860.38,17.81997,0,0,0,0,100,0), +(@PATH,54,221.5734,-5860.88,16.81997,0,0,0,0,100,0), +(@PATH,55,219.2016,-5861.626,16.09444,0,0,0,0,100,0), +(@PATH,56,218.4516,-5859.876,15.59444,0,0,0,0,100,0), +(@PATH,57,218.2016,-5858.876,14.84444,0,0,0,0,100,0), +(@PATH,58,217.7016,-5858.126,14.59444,0,0,0,0,100,0), +(@PATH,59,215.8016,-5853.367,13.55474,0,0,0,0,100,0), +(@PATH,60,217.8016,-5851.367,13.05474,0,0,0,0,100,0), +(@PATH,61,222.3978,-5845.064,13.14539,0,0,0,0,100,0), +(@PATH,62,219.8978,-5839.564,16.89539,0,0,0,0,100,0), +(@PATH,63,219.2414,-5837.49,16.91089,0,0,0,0,100,0), +(@PATH,64,216.7414,-5831.99,16.91089,0,0,0,0,100,0), +(@PATH,65,215.9914,-5829.99,16.91089,0,0,0,0,100,0), +(@PATH,66,214.2414,-5826.24,19.66089,0,0,0,0,100,0), +(@PATH,67,212.4914,-5822.49,22.66089,0,0,0,0,100,0), +(@PATH,68,212.165,-5822.061,22.73844,0,0,0,0,100,0), +(@PATH,69,211.915,-5821.561,22.73844,0,0,0,0,100,0), +(@PATH,70,210.665,-5817.811,22.73844,0,0,0,0,100,0), +(@PATH,71,209.165,-5813.061,22.73844,0,0,0,0,100,0), +(@PATH,72,205.665,-5802.561,29.98844,0,0,0,0,100,0), +(@PATH,73,205.6079,-5802.187,29.98102,0,0,0,0,100,0), +(@PATH,74,205.6079,-5801.687,30.23102,0,0,0,0,100,0), +(@PATH,75,206.3579,-5800.687,30.23102,0,0,0,0,100,0), +(@PATH,76,207.8428,-5798.708,30.2033,0,0,0,0,100,0), +(@PATH,77,210.5928,-5800.458,30.2033,0,0,0,0,100,0), +(@PATH,78,218.1125,-5805.275,29.70859,0,0,0,0,100,0), +(@PATH,79,221.8625,-5803.775,29.70859,0,0,0,0,100,0), +(@PATH,80,223.3625,-5803.525,29.70859,0,0,0,0,100,0), +(@PATH,81,228.6125,-5801.525,29.70859,0,0,0,0,100,0), +(@PATH,82,228.865,-5801.494,29.91413,0,0,0,0,100,0), +(@PATH,83,230.615,-5803.244,30.16413,0,0,0,0,100,0), +(@PATH,84,231.865,-5804.244,30.66413,0,0,0,0,100,0), +(@PATH,85,231.865,-5804.994,30.41413,0,0,0,0,100,0), +(@PATH,86,232.365,-5806.244,30.91413,0,0,0,0,100,0), +(@PATH,87,233.865,-5811.994,33.91413,0,0,0,0,100,0), +(@PATH,88,234.9124,-5814.839,35.62654,0,0,0,0,100,0), +(@PATH,89,239.4124,-5825.839,42.37654,0,0,0,0,100,0), +(@PATH,90,239.6938,-5826.081,42.31701,0,0,0,0,100,0), +(@PATH,91,239.6938,-5826.081,41.31701,0,0,0,0,100,0), +(@PATH,92,243.4438,-5830.831,41.06701,0,0,0,0,100,0), +(@PATH,93,243.9438,-5831.581,41.06701,0,0,0,0,100,0), +(@PATH,94,246.6938,-5834.331,40.56701,0,0,0,0,100,0), +(@PATH,95,246.8183,-5834.425,40.1871,0,0,0,0,100,0), +(@PATH,96,248.8183,-5836.425,40.6871,0,0,0,0,100,0), +(@PATH,97,247.5683,-5837.925,39.1871,0,0,0,0,100,0), +(@PATH,98,246.3183,-5839.675,38.4371,0,0,0,0,100,0), +(@PATH,99,244.5683,-5841.925,36.1871,0,0,0,0,100,0), +(@PATH,100,243.3183,-5843.425,35.1871,0,0,0,0,100,0), +(@PATH,101,242.0683,-5844.925,33.6871,0,0,0,0,100,0), +(@PATH,102,240.3183,-5847.175,32.4371,0,0,0,0,100,0), +(@PATH,103,239.3183,-5848.675,30.9371,0,0,0,0,100,0), +(@PATH,104,238.0683,-5850.425,30.1871,0,0,0,0,100,0), +(@PATH,105,236.3183,-5852.675,28.1871,0,0,0,0,100,0), +(@PATH,106,234.3183,-5855.175,26.1871,0,0,0,0,100,0), +(@PATH,107,234.1656,-5855.439,25.94194,0,0,0,0,100,0), +(@PATH,108,233.4156,-5856.189,25.19194,0,0,0,0,100,0), +(@PATH,109,231.6656,-5856.939,24.44194,0,0,0,0,100,0), +(@PATH,110,230.6656,-5857.439,23.19194,0,0,0,0,100,0), +(@PATH,111,228.6656,-5857.939,21.69194,0,0,0,0,100,0), +(@PATH,112,227.9156,-5858.189,21.19194,0,0,0,0,100,0), +(@PATH,113,227.1656,-5858.689,20.19194,0,0,0,0,100,0), +(@PATH,114,226.1656,-5858.939,19.19194,0,0,0,0,100,0), +(@PATH,115,224.4156,-5859.689,18.44194,0,0,0,0,100,0), +(@PATH,116,222.4156,-5860.439,17.69194,0,0,0,0,100,0), +(@PATH,117,221.6656,-5860.939,16.69194,0,0,0,0,100,0), +(@PATH,118,215.7691,-5853.435,13.38423,0,0,0,0,100,0), +(@PATH,119,217.7691,-5851.185,12.88423,0,0,0,0,100,0), +(@PATH,120,222.4627,-5845.12,13.12806,0,0,0,0,100,0); + +SET @NPC := 115460; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=287.6321,`position_y`=-5792.932,`position_z`=192.3525 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,287.6321,-5792.932,192.3525,0,0,0,0,100,0), +(@PATH,2,283.6321,-5790.682,189.6025,0,0,0,0,100,0), +(@PATH,3,280.1321,-5788.182,187.6025,0,0,0,0,100,0), +(@PATH,4,279.8365,-5787.79,187.2883,0,0,0,0,100,0), +(@PATH,5,278.3365,-5786.79,187.2883,0,0,0,0,100,0), +(@PATH,6,272.3365,-5780.29,187.2883,0,0,0,0,100,0), +(@PATH,7,272.1464,-5780.064,187.2455,0,0,0,0,100,0), +(@PATH,8,271.3964,-5779.564,187.2455,0,0,0,0,100,0), +(@PATH,9,263.6809,-5772.33,178.6529,0,0,0,0,100,0), +(@PATH,10,257.4781,-5765.213,178.404,0,0,0,0,100,0), +(@PATH,11,250.4781,-5758.963,170.404,0,0,0,0,100,0), +(@PATH,12,250.2842,-5758.825,170.3794,0,0,0,0,100,0), +(@PATH,13,250.0342,-5758.575,170.3794,0,0,0,0,100,0), +(@PATH,14,247.7842,-5753.825,170.3794,0,0,0,0,100,0), +(@PATH,15,246.5342,-5750.825,170.3794,0,0,0,0,100,0), +(@PATH,16,246.2589,-5750.45,170.0569,0,0,0,0,100,0), +(@PATH,17,245.7589,-5749.45,170.0569,0,0,0,0,100,0), +(@PATH,18,238.3877,-5742.882,162.0108,0,0,0,0,100,0), +(@PATH,19,235.8877,-5737.632,162.0108,0,0,0,0,100,0), +(@PATH,20,233.6377,-5733.382,162.0108,0,0,0,0,100,0), +(@PATH,21,233.5163,-5733.064,161.9026,0,0,0,0,100,0), +(@PATH,22,233.0163,-5732.314,161.9026,0,0,0,0,100,0), +(@PATH,23,228.2663,-5730.564,157.4026,0,0,0,0,100,0), +(@PATH,24,224.0644,-5728.735,153.6271,0,0,0,0,100,0), +(@PATH,25,213.6219,-5730.93,153.2694,0,0,0,0,100,0), +(@PATH,26,205.8719,-5726.68,146.0194,0,0,0,0,100,0), +(@PATH,27,203.8987,-5729.321,145.1488,0,0,0,0,100,0), +(@PATH,28,198.1487,-5726.071,145.1488,0,0,0,0,100,0), +(@PATH,29,196.8987,-5725.321,145.1488,0,0,0,0,100,0), +(@PATH,30,195.3987,-5724.571,145.1488,0,0,0,0,100,0), +(@PATH,31,194.1487,-5723.821,145.1488,0,0,0,0,100,0), +(@PATH,32,189.3987,-5721.571,144.8988,0,0,0,0,100,0), +(@PATH,33,187.6487,-5720.571,145.1488,0,0,0,0,100,0), +(@PATH,34,187.5118,-5720.427,144.7354,0,0,0,0,100,0), +(@PATH,35,189.5118,-5721.427,144.7354,0,0,0,0,100,0), +(@PATH,36,194.0118,-5723.927,144.7354,0,0,0,0,100,0), +(@PATH,37,195.0118,-5724.677,144.7354,0,0,0,0,100,0), +(@PATH,38,196.7618,-5725.427,144.9854,0,0,0,0,100,0), +(@PATH,39,198.0118,-5726.177,144.9854,0,0,0,0,100,0), +(@PATH,40,204.2883,-5729.523,145.2611,0,0,0,0,100,0), +(@PATH,41,205.0383,-5726.523,145.2611,0,0,0,0,100,0), +(@PATH,42,213.2883,-5730.523,153.5111,0,0,0,0,100,0), +(@PATH,43,213.5177,-5730.529,153.4881,0,0,0,0,100,0), +(@PATH,44,213.7677,-5730.779,153.2381,0,0,0,0,100,0), +(@PATH,45,224.3058,-5728.705,153.5377,0,0,0,0,100,0), +(@PATH,46,228.0558,-5730.455,157.5377,0,0,0,0,100,0), +(@PATH,47,232.9431,-5732.264,162.164,0,0,0,0,100,0), +(@PATH,48,235.4431,-5737.514,161.664,0,0,0,0,100,0), +(@PATH,49,238.584,-5743.291,162.0569,0,0,0,0,100,0), +(@PATH,50,245.334,-5749.291,170.5569,0,0,0,0,100,0), +(@PATH,51,245.717,-5749.404,170.5867,0,0,0,0,100,0), +(@PATH,52,245.967,-5749.654,170.0867,0,0,0,0,100,0), +(@PATH,53,246.467,-5750.904,170.0867,0,0,0,0,100,0), +(@PATH,54,247.717,-5753.654,170.0867,0,0,0,0,100,0), +(@PATH,55,250.1091,-5758.736,170.404,0,0,0,0,100,0), +(@PATH,56,256.8591,-5764.736,178.654,0,0,0,0,100,0), +(@PATH,57,257.8777,-5765.598,178.4319,0,0,0,0,100,0), +(@PATH,58,263.9311,-5772.561,178.7455,0,0,0,0,100,0), +(@PATH,59,270.9311,-5778.811,187.2455,0,0,0,0,100,0), +(@PATH,60,271.1609,-5779.249,187.4395,0,0,0,0,100,0), +(@PATH,61,271.6609,-5779.749,187.4395,0,0,0,0,100,0), +(@PATH,62,278.5372,-5787.154,187.7173,0,0,0,0,100,0), +(@PATH,63,280.0372,-5788.154,187.7173,0,0,0,0,100,0), +(@PATH,64,283.5372,-5790.404,189.7173,0,0,0,0,100,0), +(@PATH,65,287.506,-5793.222,192.441,0,0,0,0,100,0), +(@PATH,66,288.506,-5794.722,192.191,0,0,0,0,100,0), +(@PATH,67,288.506,-5795.722,192.441,0,0,0,0,100,0), +(@PATH,68,289.8208,-5807.587,192.2882,0,0,0,0,100,0), +(@PATH,69,294.3208,-5813.837,191.5382,0,0,0,0,100,0), +(@PATH,70,307.8186,-5829.16,195.0113,0,0,0,0,100,0), +(@PATH,71,305.8186,-5827.16,193.7613,0,0,0,0,100,0), +(@PATH,72,303.0686,-5824.41,192.2613,0,0,0,0,100,0), +(@PATH,73,287.7153,-5793.064,192.3696,0,0,0,0,100,0); + +SET @NPC := 115405; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=255.1411,`position_y`=-5819.032,`position_z`=69.82065 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,255.1411,-5819.032,69.82065,0,0,0,0,100,0), +(@PATH,2,228.1411,-5817.532,69.82065,0,0,0,0,100,0), +(@PATH,3,211.7659,-5816.324,69.97295,0,0,0,0,100,0), +(@PATH,4,211.5159,-5811.324,69.97295,0,0,0,0,100,0), +(@PATH,5,211.5159,-5806.074,70.47295,0,0,0,0,100,0), +(@PATH,6,211.2615,-5802.206,70.32089,0,0,0,0,100,0), +(@PATH,7,212.0115,-5797.456,67.57089,0,0,0,0,100,0), +(@PATH,8,212.2615,-5793.706,64.82089,0,0,0,0,100,0), +(@PATH,9,213.0389,-5789.515,64.62675,0,0,0,0,100,0), +(@PATH,10,227.0389,-5790.765,64.62675,0,0,0,0,100,0), +(@PATH,11,236.0606,-5791.326,64.78189,0,0,0,0,100,0), +(@PATH,12,239.8106,-5793.826,66.03189,0,0,0,0,100,0), +(@PATH,13,244.5606,-5796.326,67.28189,0,0,0,0,100,0), +(@PATH,14,244.8253,-5796.592,67.53802,0,0,0,0,100,0), +(@PATH,15,245.8253,-5797.092,67.53802,0,0,0,0,100,0), +(@PATH,16,246.8253,-5801.092,69.53802,0,0,0,0,100,0), +(@PATH,17,250.3253,-5811.092,74.28802,0,0,0,0,100,0), +(@PATH,18,250.7232,-5811.383,74.58054,0,0,0,0,100,0), +(@PATH,19,250.9732,-5812.633,75.33054,0,0,0,0,100,0), +(@PATH,20,251.2232,-5812.633,76.08054,0,0,0,0,100,0), +(@PATH,21,255.7232,-5817.633,79.33054,0,0,0,0,100,0), +(@PATH,22,260.4732,-5822.383,84.33054,0,0,0,0,100,0), +(@PATH,23,260.4797,-5822.664,84.30443,0,0,0,0,100,0), +(@PATH,24,261.4797,-5823.664,84.30443,0,0,0,0,100,0), +(@PATH,25,257.9797,-5834.414,84.30443,0,0,0,0,100,0), +(@PATH,26,254.2297,-5845.164,83.55443,0,0,0,0,100,0), +(@PATH,27,253.9797,-5845.914,83.55443,0,0,0,0,100,0), +(@PATH,28,257.9939,-5846.658,83.14531,0,0,0,0,100,0), +(@PATH,29,258.2439,-5850.158,83.14531,0,0,0,0,100,0), +(@PATH,30,258.4939,-5857.408,83.14531,0,0,0,0,100,0), +(@PATH,31,259.2439,-5866.408,83.14531,0,0,0,0,100,0), +(@PATH,32,254.65,-5852.131,56.96819,0,0,0,0,100,0), +(@PATH,33,254.9,-5850.131,56.21819,0,0,0,0,100,0), +(@PATH,34,252.9344,-5835.348,62.48116,0,0,0,0,100,0), +(@PATH,35,253.9344,-5828.098,65.73116,0,0,0,0,100,0), +(@PATH,36,255.207,-5819.25,69.76926,0,0,0,0,100,0); + +SET @NPC := 115406; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=227.7014,`position_y`=-5716.306,`position_z`=194.7286 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,227.7014,-5716.306,194.7286,0,0,0,0,100,0), +(@PATH,2,228.2014,-5716.556,193.4786,0,0,0,0,100,0), +(@PATH,3,222.9313,-5728.676,193.7948,0,0,0,0,100,0), +(@PATH,4,224.6813,-5729.676,193.7948,0,0,0,0,100,0), +(@PATH,5,232.1813,-5734.176,193.7948,0,0,0,0,100,0), +(@PATH,6,233.4313,-5734.926,194.2948,0,0,0,0,100,0), +(@PATH,7,232.3829,-5734.333,194.1157,0,0,0,0,100,0), +(@PATH,8,233.6329,-5735.083,194.3657,0,0,0,0,100,0), +(@PATH,9,234.1329,-5735.583,194.3657,0,0,0,0,100,0), +(@PATH,10,236.6329,-5737.833,194.3657,0,0,0,0,100,0), +(@PATH,11,243.1329,-5743.833,194.6157,0,0,0,0,100,0), +(@PATH,12,250.3829,-5750.583,194.6157,0,0,0,0,100,0), +(@PATH,13,250.6692,-5750.867,194.634,0,0,0,0,100,0), +(@PATH,14,251.6692,-5751.617,194.884,0,0,0,0,100,0), +(@PATH,15,257.9192,-5755.617,192.134,0,0,0,0,100,0), +(@PATH,16,263.6692,-5759.117,191.884,0,0,0,0,100,0), +(@PATH,17,271.5138,-5764.185,191.8001,0,0,0,0,100,0), +(@PATH,18,272.7638,-5767.185,191.3001,0,0,0,0,100,0), +(@PATH,19,275.2638,-5767.435,191.3001,0,0,0,0,100,0), +(@PATH,20,279.5138,-5769.435,192.0501,0,0,0,0,100,0), +(@PATH,21,281.5138,-5770.185,192.5501,0,0,0,0,100,0), +(@PATH,22,283.2638,-5770.935,193.3001,0,0,0,0,100,0), +(@PATH,23,281.6401,-5770.392,192.9582,0,0,0,0,100,0), +(@PATH,24,283.6401,-5771.142,193.4582,0,0,0,0,100,0), +(@PATH,25,284.6401,-5771.392,193.4582,0,0,0,0,100,0), +(@PATH,26,286.1401,-5772.642,193.9582,0,0,0,0,100,0), +(@PATH,27,289.6401,-5775.642,194.7082,0,0,0,0,100,0), +(@PATH,28,295.3911,-5780.221,195.1046,0,0,0,0,100,0), +(@PATH,29,298.3911,-5780.471,195.8546,0,0,0,0,100,0), +(@PATH,30,300.1411,-5780.471,196.1046,0,0,0,0,100,0), +(@PATH,31,304.1411,-5780.721,197.1046,0,0,0,0,100,0), +(@PATH,32,306.2016,-5781.156,197.6729,0,0,0,0,100,0), +(@PATH,33,305.2016,-5782.406,197.1729,0,0,0,0,100,0), +(@PATH,34,301.7016,-5790.156,204.6729,0,0,0,0,100,0), +(@PATH,35,301.4777,-5790.491,204.8195,0,0,0,0,100,0), +(@PATH,36,301.2277,-5790.741,204.5695,0,0,0,0,100,0), +(@PATH,37,300.2277,-5793.991,204.5695,0,0,0,0,100,0), +(@PATH,38,300.0298,-5793.949,204.6514,0,0,0,0,100,0), +(@PATH,39,300.2668,-5793.704,204.6047,0,0,0,0,100,0), +(@PATH,40,301.0168,-5791.204,204.6047,0,0,0,0,100,0), +(@PATH,41,301.5168,-5790.204,204.8547,0,0,0,0,100,0), +(@PATH,42,305.8412,-5781.836,197.0411,0,0,0,0,100,0), +(@PATH,43,302.8412,-5781.336,196.2911,0,0,0,0,100,0), +(@PATH,44,299.0912,-5781.086,195.7911,0,0,0,0,100,0), +(@PATH,45,296.0912,-5780.586,195.0411,0,0,0,0,100,0), +(@PATH,46,295.7578,-5780.462,194.7891,0,0,0,0,100,0), +(@PATH,47,295.0078,-5780.462,194.7891,0,0,0,0,100,0), +(@PATH,48,287.7578,-5774.212,194.2891,0,0,0,0,100,0), +(@PATH,49,284.1918,-5771.301,193.2889,0,0,0,0,100,0), +(@PATH,50,283.4418,-5771.551,193.0389,0,0,0,0,100,0), +(@PATH,51,282.1918,-5770.551,192.5389,0,0,0,0,100,0), +(@PATH,52,279.6918,-5768.801,192.0389,0,0,0,0,100,0), +(@PATH,53,279.1918,-5768.801,191.7889,0,0,0,0,100,0), +(@PATH,54,275.1918,-5767.801,191.2889,0,0,0,0,100,0), +(@PATH,55,271.9418,-5766.551,191.5389,0,0,0,0,100,0), +(@PATH,56,271.8291,-5766.23,191.5772,0,0,0,0,100,0), +(@PATH,57,271.3291,-5763.98,191.8272,0,0,0,0,100,0), +(@PATH,58,263.5791,-5759.48,192.3272,0,0,0,0,100,0), +(@PATH,59,258.0791,-5755.73,191.8272,0,0,0,0,100,0), +(@PATH,60,251.2296,-5751.457,194.8659,0,0,0,0,100,0), +(@PATH,61,250.4796,-5750.707,194.6159,0,0,0,0,100,0), +(@PATH,62,243.2296,-5743.957,194.6159,0,0,0,0,100,0), +(@PATH,63,236.9796,-5737.957,194.3659,0,0,0,0,100,0), +(@PATH,64,234.7296,-5735.957,194.3659,0,0,0,0,100,0), +(@PATH,65,234.5474,-5735.734,194.361,0,0,0,0,100,0), +(@PATH,66,234.0474,-5735.234,194.361,0,0,0,0,100,0), +(@PATH,67,232.5474,-5734.234,194.111,0,0,0,0,100,0), +(@PATH,68,224.5474,-5729.734,193.861,0,0,0,0,100,0), +(@PATH,69,223.7974,-5729.234,193.861,0,0,0,0,100,0), +(@PATH,70,223.618,-5728.915,193.8579,0,0,0,0,100,0), +(@PATH,71,222.868,-5728.415,193.8579,0,0,0,0,100,0), +(@PATH,72,223.118,-5727.665,193.8579,0,0,0,0,100,0), +(@PATH,73,223.368,-5725.165,193.6079,0,0,0,0,100,0), +(@PATH,74,224.618,-5717.165,193.8579,0,0,0,0,100,0), +(@PATH,75,224.3923,-5716.984,193.7416,0,0,0,0,100,0), +(@PATH,76,224.6423,-5715.234,194.2416,0,0,0,0,100,0), +(@PATH,77,215.0278,-5704.665,193.6219,0,0,0,0,100,0), +(@PATH,78,213.0278,-5704.415,193.3719,0,0,0,0,100,0), +(@PATH,79,200.1468,-5699.838,193.414,0,0,0,0,100,0), +(@PATH,80,194.8968,-5701.338,193.414,0,0,0,0,100,0), +(@PATH,81,193.6468,-5701.588,193.414,0,0,0,0,100,0), +(@PATH,82,183.2275,-5704.542,193.2986,0,0,0,0,100,0), +(@PATH,83,181.7275,-5704.792,193.2986,0,0,0,0,100,0), +(@PATH,84,173.7432,-5705.778,188.6798,0,0,0,0,100,0), +(@PATH,85,173.9932,-5707.278,188.9298,0,0,0,0,100,0), +(@PATH,86,173.4932,-5709.028,188.1798,0,0,0,0,100,0), +(@PATH,87,174.2432,-5710.278,188.4298,0,0,0,0,100,0), +(@PATH,88,171.5702,-5712.814,187.953,0,0,0,0,100,0), +(@PATH,89,170.3202,-5712.814,187.953,0,0,0,0,100,0), +(@PATH,90,168.8202,-5712.814,188.453,0,0,0,0,100,0), +(@PATH,91,165.8202,-5712.564,188.953,0,0,0,0,100,0), +(@PATH,92,159.0702,-5711.814,189.703,0,0,0,0,100,0), +(@PATH,93,152.0702,-5711.314,188.953,0,0,0,0,100,0), +(@PATH,94,148.0702,-5710.814,188.203,0,0,0,0,100,0), +(@PATH,95,150.4417,-5711.151,188.5248,0,0,0,0,100,0), +(@PATH,96,150.4417,-5711.151,188.5248,0.1987633,0,0,0,100,0), +(@PATH,97,152.4488,-5711.305,189.4782,0,0,0,0,100,0), +(@PATH,98,153.4488,-5711.305,189.4782,0,0,0,0,100,0), +(@PATH,99,151.4731,-5711.154,188.9846,0,0,0,0,100,0), +(@PATH,100,150.5885,-5711.407,188.7902,0,0,0,0,100,0), +(@PATH,101,153.5885,-5711.907,189.5402,0,0,0,0,100,0), +(@PATH,102,164.3385,-5713.407,188.7902,0,0,0,0,100,0), +(@PATH,103,166.3385,-5713.907,187.2902,0,0,0,0,100,0), +(@PATH,104,171.7018,-5712.837,187.8679,0,0,0,0,100,0), +(@PATH,105,173.9518,-5710.837,188.1179,0,0,0,0,100,0), +(@PATH,106,172.4518,-5707.337,187.8679,0,0,0,0,100,0), +(@PATH,107,174.1519,-5705.721,188.97,0,0,0,0,100,0), +(@PATH,108,181.6519,-5704.721,193.22,0,0,0,0,100,0), +(@PATH,109,181.9405,-5704.654,193.3114,0,0,0,0,100,0), +(@PATH,110,183.6905,-5704.404,193.3114,0,0,0,0,100,0), +(@PATH,111,193.6905,-5701.654,193.3114,0,0,0,0,100,0), +(@PATH,112,194.9405,-5701.404,193.3114,0,0,0,0,100,0), +(@PATH,113,200.2739,-5699.83,193.3035,0,0,0,0,100,0), +(@PATH,114,214.5239,-5706.08,193.8035,0,0,0,0,100,0), +(@PATH,115,215.4275,-5705.061,193.8293,0,0,0,0,100,0), +(@PATH,116,223.1775,-5713.561,194.0793,0,0,0,0,100,0), +(@PATH,117,227.4703,-5716.03,194.9438,0,0,0,0,100,0); + +UPDATE `creature` SET `spawndist`=10 WHERE `id`=24871 AND `MovementType`=1; + +-- Assistant Apothecary SAI +SET @GUID := -97863; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24081; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,2000,2000,2000,2000,10,1,273,274,18,5,11,1,0,0,0,0,0,0,0,"Assistant Apothecary - Out of Combat - Play Random Emote (1, 273, 274, 18, 5, 11)"); + +-- Assistant Apothecary SAI +SET @GUID := -97872; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24081; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,2000,2000,2000,2000,10,1,273,274,18,5,11,1,0,0,0,0,0,0,0,"Assistant Apothecary - Out of Combat - Play Random Emote (1, 273, 274, 18, 5, 11)"); + +-- Assistant Apothecary SAI +SET @GUID := -97862; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24081; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,2000,2000,2000,2000,10,1,273,274,18,5,11,1,0,0,0,0,0,0,0,"Assistant Apothecary - Out of Combat - Play Random Emote (1, 273, 274, 18, 5, 11)"); + +-- Assistant Apothecary SAI +SET @GUID := -97869; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24081; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@GUID,0,0,0,1,0,100,0,2000,2000,2000,2000,10,1,273,274,18,5,11,1,0,0,0,0,0,0,0,"Assistant Apothecary - Out of Combat - Play Random Emote (1, 273, 274, 18, 5, 11)"); + +SET @NPC := 97519; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1015.248,`position_y`=-4453.979,`position_z`=167.7645 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,1015.248,-4453.979,167.7645,0,0,0,0,100,0), +(@PATH,2,1015.998,-4453.729,167.7645,0,0,0,0,100,0), +(@PATH,3,1018.248,-4451.479,168.2645,0,0,0,0,100,0), +(@PATH,4,1025.511,-4443.714,168.6004,0,0,0,0,100,0), +(@PATH,5,1039.257,-4432.38,168.4421,0,0,0,0,100,0), +(@PATH,6,1040.007,-4433.13,168.9421,0,0,0,0,100,0), +(@PATH,7,1040.257,-4433.88,168.9421,0,0,0,0,100,0), +(@PATH,8,1041.257,-4433.38,168.6921,0,0,0,0,100,0), +(@PATH,9,1044.757,-4432.13,168.4421,0,0,0,0,100,0), +(@PATH,10,1045.757,-4432.13,168.4421,0,0,0,0,100,0), +(@PATH,11,1050.007,-4431.13,168.4421,0,0,0,0,100,0), +(@PATH,12,1049.977,-4431.141,168.4401,0,0,0,0,100,0), +(@PATH,13,1045.727,-4433.391,168.6901,0,0,0,0,100,0), +(@PATH,14,1042.227,-4432.641,168.6901,0,0,0,0,100,0), +(@PATH,15,1040.477,-4431.641,168.4401,0,0,0,0,100,0), +(@PATH,16,1040.09,-4431.696,168.4902,0,0,0,0,100,0), +(@PATH,17,1039.09,-4432.446,168.4902,0,0,0,0,100,0), +(@PATH,18,1025.124,-4443.842,168.6566,0,0,0,0,100,0), +(@PATH,19,1016.624,-4453.342,167.9066,0,0,0,0,100,0), +(@PATH,20,1016.256,-4453.507,167.7006,0,0,0,0,100,0), +(@PATH,21,1015.756,-4454.007,167.7006,0,0,0,0,100,0), +(@PATH,22,1014.506,-4455.257,167.2006,0,0,0,0,100,0), +(@PATH,23,1012.506,-4455.257,166.9506,0,0,0,0,100,0), +(@PATH,24,1008.006,-4456.507,166.2006,0,0,0,0,100,0), +(@PATH,25,1003.674,-4461.948,167.2136,0,0,0,0,100,0), +(@PATH,26,1002.424,-4462.698,167.2136,0,0,0,0,100,0), +(@PATH,27,1000.924,-4463.448,167.2136,0,0,0,0,100,0), +(@PATH,28,999.9244,-4463.448,167.2136,0,0,0,0,100,0), +(@PATH,29,999.1744,-4466.448,167.7136,0,0,0,0,100,0), +(@PATH,30,997.4244,-4468.948,168.2136,0,0,0,0,100,0), +(@PATH,31,990.4841,-4474.846,167.9575,0,0,0,0,100,0), +(@PATH,32,989.9841,-4476.596,167.9575,0,0,0,0,100,0), +(@PATH,33,990.7341,-4479.096,167.4575,0,0,0,0,100,0), +(@PATH,34,990.7341,-4483.096,167.2075,0,0,0,0,100,0), +(@PATH,35,989.7341,-4484.846,167.4575,0,0,0,0,100,0), +(@PATH,36,981.9841,-4489.846,164.7075,0,0,0,0,100,0), +(@PATH,37,981.9841,-4491.346,164.9575,0,0,0,0,100,0), +(@PATH,38,979.9841,-4491.846,164.2075,0,0,0,0,100,0), +(@PATH,39,979.7715,-4491.001,163.8022,0,0,0,0,100,0), +(@PATH,40,977.7715,-4491.251,163.0522,0,0,0,0,100,0), +(@PATH,41,975.7715,-4491.501,162.5522,0,0,0,0,100,0), +(@PATH,42,974.2715,-4491.501,162.5522,0,0,0,0,100,0), +(@PATH,43,971.5215,-4491.751,161.8022,0,0,0,0,100,0), +(@PATH,44,971.3606,-4491.792,161.514,0,0,0,0,100,0), +(@PATH,45,969.3606,-4492.042,160.764,0,0,0,0,100,0), +(@PATH,46,964.1106,-4490.792,159.014,0,0,0,0,100,0), +(@PATH,47,962.8606,-4490.792,158.264,0,0,0,0,100,0), +(@PATH,48,960.6106,-4490.292,157.764,0,0,0,0,100,0), +(@PATH,49,958.6106,-4490.292,157.264,0,0,0,0,100,0), +(@PATH,50,957.3606,-4488.792,156.514,0,0,0,0,100,0), +(@PATH,51,955.3606,-4485.542,155.514,0,0,0,0,100,0), +(@PATH,52,954.9963,-4485.461,155.3227,0,0,0,0,100,0), +(@PATH,53,953.9963,-4483.961,154.8227,0,0,0,0,100,0), +(@PATH,54,952.4963,-4481.461,154.3227,0,0,0,0,100,0), +(@PATH,55,950.7463,-4478.961,153.5727,0,0,0,0,100,0), +(@PATH,56,948.9963,-4475.961,153.0727,0,0,0,0,100,0), +(@PATH,57,946.2463,-4471.711,152.5727,0,0,0,0,100,0), +(@PATH,58,943.9454,-4468.581,151.9754,0,0,0,0,100,0), +(@PATH,59,940.1954,-4469.581,151.2254,0,0,0,0,100,0), +(@PATH,60,937.1954,-4470.331,150.4754,0,0,0,0,100,0), +(@PATH,61,934.6954,-4470.831,149.7254,0,0,0,0,100,0), +(@PATH,62,931.6954,-4471.581,149.2254,0,0,0,0,100,0), +(@PATH,63,928.6954,-4472.081,148.4754,0,0,0,0,100,0), +(@PATH,64,928.8876,-4472.062,148.61,0,0,0,0,100,0), +(@PATH,65,930.8876,-4471.562,149.11,0,0,0,0,100,0), +(@PATH,66,933.6376,-4470.812,149.61,0,0,0,0,100,0), +(@PATH,67,935.3876,-4470.562,150.11,0,0,0,0,100,0), +(@PATH,68,939.3876,-4469.812,150.86,0,0,0,0,100,0), +(@PATH,69,942.1376,-4469.062,151.61,0,0,0,0,100,0), +(@PATH,70,942.5215,-4469.056,151.9583,0,0,0,0,100,0), +(@PATH,71,944.2715,-4468.556,152.2083,0,0,0,0,100,0), +(@PATH,72,947.7715,-4474.556,152.9583,0,0,0,0,100,0), +(@PATH,73,950.0215,-4477.556,153.2083,0,0,0,0,100,0), +(@PATH,74,951.5215,-4480.056,153.9583,0,0,0,0,100,0), +(@PATH,75,953.2715,-4482.556,154.7083,0,0,0,0,100,0), +(@PATH,76,953.3368,-4482.845,154.7652,0,0,0,0,100,0), +(@PATH,77,954.3368,-4484.345,155.0152,0,0,0,0,100,0), +(@PATH,78,956.0868,-4485.095,155.7652,0,0,0,0,100,0), +(@PATH,79,958.0868,-4485.595,156.2652,0,0,0,0,100,0), +(@PATH,80,958.5868,-4485.845,156.2652,0,0,0,0,100,0), +(@PATH,81,960.0868,-4486.345,157.0152,0,0,0,0,100,0), +(@PATH,82,967.9517,-4492.584,160.9392,0,0,0,0,100,0), +(@PATH,83,968.9517,-4493.084,160.9392,0,0,0,0,100,0), +(@PATH,84,971.2017,-4494.584,161.4392,0,0,0,0,100,0), +(@PATH,85,972.9517,-4494.584,162.1892,0,0,0,0,100,0), +(@PATH,86,974.9517,-4494.584,162.6892,0,0,0,0,100,0), +(@PATH,87,977.4517,-4493.084,163.4392,0,0,0,0,100,0), +(@PATH,88,977.9188,-4493.006,163.5088,0,0,0,0,100,0), +(@PATH,89,979.1688,-4492.006,164.0088,0,0,0,0,100,0), +(@PATH,90,980.4188,-4491.506,164.5088,0,0,0,0,100,0), +(@PATH,91,982.4188,-4488.756,165.2588,0,0,0,0,100,0), +(@PATH,92,989.1688,-4483.756,167.0088,0,0,0,0,100,0), +(@PATH,93,990.6688,-4479.256,167.5088,0,0,0,0,100,0), +(@PATH,94,990.1688,-4477.006,167.7588,0,0,0,0,100,0), +(@PATH,95,990.2711,-4476.904,167.666,0,0,0,0,100,0), +(@PATH,96,990.0211,-4475.404,168.166,0,0,0,0,100,0), +(@PATH,97,990.7711,-4475.154,168.166,0,0,0,0,100,0), +(@PATH,98,999.0211,-4469.904,167.916,0,0,0,0,100,0), +(@PATH,99,1000.021,-4469.904,167.916,0,0,0,0,100,0), +(@PATH,100,1003.021,-4466.654,167.916,0,0,0,0,100,0), +(@PATH,101,1003.021,-4464.154,167.666,0,0,0,0,100,0), +(@PATH,102,1003.911,-4461.639,167.1876,0,0,0,0,100,0), +(@PATH,103,1008.161,-4456.889,166.1876,0,0,0,0,100,0), +(@PATH,104,1012.161,-4455.389,166.9376,0,0,0,0,100,0); + +SET @NPC := 108040; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=956.1494,`position_y`=-4457.604,`position_z`=152.5576 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,956.1494,-4457.604,152.5576,0,0,0,0,100,0), +(@PATH,2,961.1494,-4449.354,152.3076,0,0,0,0,100,0), +(@PATH,3,961.1494,-4447.854,152.3076,0,0,0,0,100,0), +(@PATH,4,966.193,-4442.853,152.4677,0,0,0,0,100,0), +(@PATH,5,966.0477,-4443.138,152.2393,0,0,0,0,100,0), +(@PATH,6,966.0169,-4443.054,152.3164,0,0,0,0,100,0), +(@PATH,7,965.0169,-4445.804,152.3164,0,0,0,0,100,0), +(@PATH,8,965.7669,-4447.054,152.8164,0,0,0,0,100,0), +(@PATH,9,955.7,-4457.94,152.5095,0,0,0,0,100,0), +(@PATH,10,956.2,-4460.44,152.5095,0,0,0,0,100,0), +(@PATH,11,954.7,-4461.94,152.5095,0,0,0,0,100,0), +(@PATH,12,953.2,-4466.44,152.5095,0,0,0,0,100,0), +(@PATH,13,950.7,-4471.19,152.5095,0,0,0,0,100,0), +(@PATH,14,950.7,-4472.69,152.7595,0,0,0,0,100,0), +(@PATH,15,950.4084,-4472.972,152.9393,0,0,0,0,100,0), +(@PATH,16,950.1584,-4474.222,152.9393,0,0,0,0,100,0), +(@PATH,17,947.4084,-4479.472,153.6893,0,0,0,0,100,0), +(@PATH,18,945.9084,-4482.972,154.1893,0,0,0,0,100,0), +(@PATH,19,944.9084,-4484.722,155.1893,0,0,0,0,100,0), +(@PATH,20,942.6257,-4489.089,156.3307,0,0,0,0,100,0), +(@PATH,21,940.3757,-4493.089,156.8307,0,0,0,0,100,0), +(@PATH,22,938.3757,-4497.089,156.8307,0,0,0,0,100,0), +(@PATH,23,937.9882,-4497.383,157.1975,0,0,0,0,100,0), +(@PATH,24,936.7382,-4499.133,157.6975,0,0,0,0,100,0), +(@PATH,25,936.4882,-4499.883,158.1975,0,0,0,0,100,0), +(@PATH,26,935.9882,-4501.883,158.4475,0,0,0,0,100,0), +(@PATH,27,935.4882,-4502.883,158.1975,0,0,0,0,100,0), +(@PATH,28,934.4882,-4506.133,158.1975,0,0,0,0,100,0), +(@PATH,29,934.2382,-4506.883,158.1975,0,0,0,0,100,0), +(@PATH,30,932.9882,-4510.883,158.1975,0,0,0,0,100,0), +(@PATH,31,933.5935,-4508.443,158.2741,0,0,0,0,100,0), +(@PATH,32,933.8435,-4507.193,158.2741,0,0,0,0,100,0), +(@PATH,33,934.3435,-4506.193,158.2741,0,0,0,0,100,0), +(@PATH,34,935.3435,-4502.693,158.2741,0,0,0,0,100,0), +(@PATH,35,935.8435,-4501.943,158.5241,0,0,0,0,100,0), +(@PATH,36,936.3435,-4499.943,158.2741,0,0,0,0,100,0), +(@PATH,37,936.5914,-4499.837,158.0711,0,0,0,0,100,0), +(@PATH,38,936.5914,-4499.337,158.0711,0,0,0,0,100,0), +(@PATH,39,937.0914,-4498.837,157.5711,0,0,0,0,100,0), +(@PATH,40,938.8414,-4496.587,157.0711,0,0,0,0,100,0), +(@PATH,41,939.8414,-4496.087,157.0711,0,0,0,0,100,0), +(@PATH,42,942.0914,-4490.837,156.5711,0,0,0,0,100,0), +(@PATH,43,943.5914,-4487.337,156.0711,0,0,0,0,100,0), +(@PATH,44,943.7902,-4486.907,155.6844,0,0,0,0,100,0), +(@PATH,45,944.0402,-4486.657,155.6844,0,0,0,0,100,0), +(@PATH,46,945.2902,-4483.907,154.6844,0,0,0,0,100,0), +(@PATH,47,946.5402,-4481.407,154.1844,0,0,0,0,100,0), +(@PATH,48,947.7902,-4478.657,153.4344,0,0,0,0,100,0), +(@PATH,49,950.2281,-4473.951,152.6897,0,0,0,0,100,0), +(@PATH,50,950.7281,-4472.701,152.6897,0,0,0,0,100,0), +(@PATH,51,951.7281,-4470.951,152.6897,0,0,0,0,100,0), +(@PATH,52,957.2281,-4465.701,152.6897,0,0,0,0,100,0), +(@PATH,53,957.2281,-4464.701,152.6897,0,0,0,0,100,0), +(@PATH,54,957.2281,-4462.451,152.6897,0,0,0,0,100,0), +(@PATH,55,957.7281,-4458.951,152.6897,0,0,0,0,100,0); + +SET @NPC := 97530; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1024.085,`position_y`=-4388.786,`position_z`=155.0886 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,1024.085,-4388.786,155.0886,0,0,0,0,100,0), +(@PATH,2,1026.585,-4388.786,155.8386,0,0,0,0,100,0), +(@PATH,3,1029.085,-4390.286,156.5886,0,0,0,0,100,0), +(@PATH,4,1030.585,-4391.286,157.0886,0,0,0,0,100,0), +(@PATH,5,1032.335,-4392.036,157.8386,0,0,0,0,100,0), +(@PATH,6,1035.085,-4393.286,158.5886,0,0,0,0,100,0), +(@PATH,7,1036.835,-4394.286,159.5886,0,0,0,0,100,0), +(@PATH,8,1034.852,-4393.112,158.7381,0,0,0,0,100,0), +(@PATH,9,1033.102,-4392.362,157.9881,0,0,0,0,100,0), +(@PATH,10,1031.602,-4391.612,157.4881,0,0,0,0,100,0), +(@PATH,11,1028.852,-4390.112,156.7381,0,0,0,0,100,0), +(@PATH,12,1027.102,-4389.112,155.9881,0,0,0,0,100,0), +(@PATH,13,1028.578,-4389.915,156.3259,0,0,0,0,100,0), +(@PATH,14,1026.828,-4389.165,155.5759,0,0,0,0,100,0), +(@PATH,15,1026.328,-4388.915,155.5759,0,0,0,0,100,0), +(@PATH,16,1025.078,-4389.415,155.0759,0,0,0,0,100,0), +(@PATH,17,1021.078,-4388.665,154.5759,0,0,0,0,100,0), +(@PATH,18,1019.078,-4387.915,154.0759,0,0,0,0,100,0), +(@PATH,19,1013.2,-4388.109,152.8829,0,0,0,0,100,0), +(@PATH,20,1000.7,-4388.859,151.1329,0,0,0,0,100,0), +(@PATH,21,1000.494,-4388.744,150.9521,0,0,0,0,100,0), +(@PATH,22,999.2443,-4387.994,150.7021,0,0,0,0,100,0), +(@PATH,23,997.4943,-4387.244,150.7021,0,0,0,0,100,0), +(@PATH,24,997.2443,-4386.744,150.7021,0,0,0,0,100,0), +(@PATH,25,991.3024,-4383.845,150.0998,0,0,0,0,100,0), +(@PATH,26,988.0524,-4382.595,149.0998,0,0,0,0,100,0), +(@PATH,27,983.3024,-4381.345,148.8498,0,0,0,0,100,0), +(@PATH,28,975.5524,-4377.345,148.3498,0,0,0,0,100,0), +(@PATH,29,970.8024,-4375.845,147.5998,0,0,0,0,100,0), +(@PATH,30,970.5043,-4375.663,147.2383,0,0,0,0,100,0), +(@PATH,31,970.7543,-4376.913,147.2383,0,0,0,0,100,0), +(@PATH,32,968.0043,-4377.163,146.7383,0,0,0,0,100,0), +(@PATH,33,961.2543,-4377.663,145.7383,0,0,0,0,100,0), +(@PATH,34,958.5043,-4377.913,145.4883,0,0,0,0,100,0), +(@PATH,35,951.996,-4379.422,144.7583,0,0,0,0,100,0), +(@PATH,36,947.996,-4382.172,144.0083,0,0,0,0,100,0), +(@PATH,37,944.496,-4383.922,143.7583,0,0,0,0,100,0), +(@PATH,38,939.0083,-4386.466,142.6643,0,0,0,0,100,0), +(@PATH,39,935.2583,-4387.716,141.6643,0,0,0,0,100,0), +(@PATH,40,929.7583,-4389.466,141.4143,0,0,0,0,100,0), +(@PATH,41,925.7583,-4390.966,140.6643,0,0,0,0,100,0), +(@PATH,42,921.2232,-4390.457,140.385,0,0,0,0,100,0), +(@PATH,43,906.9732,-4402.207,139.635,0,0,0,0,100,0), +(@PATH,44,904.4732,-4404.457,139.635,0,0,0,0,100,0), +(@PATH,45,902.9732,-4406.457,139.385,0,0,0,0,100,0), +(@PATH,46,902.9732,-4408.207,139.135,0,0,0,0,100,0), +(@PATH,47,903.6403,-4404.299,139.124,0,0,0,0,100,0), +(@PATH,48,905.1403,-4403.299,139.624,0,0,0,0,100,0), +(@PATH,49,921.5125,-4390.136,140.6507,0,0,0,0,100,0), +(@PATH,50,924.7625,-4389.886,140.9007,0,0,0,0,100,0), +(@PATH,51,930.0125,-4388.636,141.4007,0,0,0,0,100,0), +(@PATH,52,933.2625,-4387.386,141.6507,0,0,0,0,100,0), +(@PATH,53,938.2625,-4386.636,142.1507,0,0,0,0,100,0), +(@PATH,54,941.0632,-4386.008,143.1118,0,0,0,0,100,0), +(@PATH,55,944.5632,-4384.008,143.3618,0,0,0,0,100,0), +(@PATH,56,947.5632,-4382.008,144.1118,0,0,0,0,100,0), +(@PATH,57,951.0632,-4380.008,144.6118,0,0,0,0,100,0), +(@PATH,58,954.3835,-4378.908,145.3604,0,0,0,0,100,0), +(@PATH,59,960.1335,-4376.908,145.6104,0,0,0,0,100,0), +(@PATH,60,961.6335,-4377.158,145.8604,0,0,0,0,100,0), +(@PATH,61,966.3835,-4376.908,146.6104,0,0,0,0,100,0), +(@PATH,62,970.936,-4376.978,147.3131,0,0,0,0,100,0), +(@PATH,63,973.186,-4376.978,147.5631,0,0,0,0,100,0), +(@PATH,64,975.186,-4376.978,148.0631,0,0,0,0,100,0), +(@PATH,65,978.936,-4378.978,148.5631,0,0,0,0,100,0), +(@PATH,66,983.436,-4380.978,148.8131,0,0,0,0,100,0), +(@PATH,67,987.436,-4382.478,149.0631,0,0,0,0,100,0), +(@PATH,68,989.436,-4383.228,149.8131,0,0,0,0,100,0), +(@PATH,69,991.3464,-4384.043,150.0937,0,0,0,0,100,0), +(@PATH,70,997.3464,-4386.793,150.5937,0,0,0,0,100,0), +(@PATH,71,999.5955,-4388.054,151.1195,0,0,0,0,100,0), +(@PATH,72,1000.845,-4387.554,151.1195,0,0,0,0,100,0), +(@PATH,73,1001.095,-4387.054,151.3695,0,0,0,0,100,0), +(@PATH,74,1013.391,-4387.978,153.2294,0,0,0,0,100,0), +(@PATH,75,1019.891,-4388.228,153.9794,0,0,0,0,100,0); + +SET @NPC := 118191; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=792.4111,`position_y`=-4165.132,`position_z`=190.8517 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, 100, 446.786, -4277.12, 233.767, 0, 0, 0, 0, 100, 0), +(@PATH, 99, 425.608, -4298.79, 234.072, 0, 0, 0, 0, 100, 0), +(@PATH, 98, 410.285, -4311.46, 232.44, 0, 0, 0, 0, 100, 0), +(@PATH, 97, 389.314, -4324.13, 235.243, 0, 0, 0, 0, 100, 0), +(@PATH, 96, 369.394, -4333.78, 235.957, 0, 0, 0, 0, 100, 0), +(@PATH, 95, 349.923, -4341.65, 239.105, 0, 0, 0, 0, 100, 0), +(@PATH, 94, 334.75, -4354.5, 238.383, 0, 0, 0, 0, 100, 0), +(@PATH, 93, 317.898, -4368.94, 237.277, 0, 0, 0, 0, 100, 0), +(@PATH, 92, 302.318, -4387.75, 238.375, 0, 0, 0, 0, 100, 0), +(@PATH, 91, 290.249, -4410.43, 240.571, 0, 0, 0, 0, 100, 0), +(@PATH, 90, 279.331, -4432.36, 243.73, 0, 0, 0, 0, 100, 0), +(@PATH, 89, 268.961, -4458.37, 243.58, 0, 0, 0, 0, 100, 0), +(@PATH, 88, 260.301, -4482.54, 244.505, 0, 0, 0, 0, 100, 0), +(@PATH, 87, 252.56, -4505.86, 246.941, 0, 0, 0, 0, 100, 0), +(@PATH, 86, 243.717, -4532.5, 249.368, 0, 0, 0, 0, 100, 0), +(@PATH, 85, 237.602, -4557.37, 247.954, 0, 0, 0, 0, 100, 0), +(@PATH, 84, 231.692, -4582.37, 245.274, 0, 0, 0, 0, 100, 0), +(@PATH, 83, 224.597, -4610.57, 242.436, 0, 0, 0, 0, 100, 0), +(@PATH, 82, 223.749, -4639.73, 241.363, 0, 0, 0, 0, 100, 0), +(@PATH, 81, 226.857, -4665.24, 243.623, 0, 0, 0, 0, 100, 0), +(@PATH, 80, 234.426, -4692.12, 247.553, 0, 0, 0, 0, 100, 0), +(@PATH, 79, 240.367, -4715.88, 245.166, 0, 0, 0, 0, 100, 0), +(@PATH, 78, 243.871, -4731.88, 247.359, 0, 0, 0, 0, 100, 0), +(@PATH, 77, 249.727, -4747.01, 246.8, 0, 0, 0, 0, 100, 0), +(@PATH, 76, 239.906, -4721.99, 247.035, 0, 0, 0, 0, 100, 0), +(@PATH, 75, 236.078, -4695.39, 247.607, 0, 0, 0, 0, 100, 0), +(@PATH, 74, 226.232, -4654.71, 242.514, 0, 0, 0, 0, 100, 0), +(@PATH, 73, 226.232, -4654.71, 242.514, 0, 0, 0, 0, 100, 0), +(@PATH, 72, 227.986, -4631.4, 240.001, 0, 0, 0, 0, 100, 0), +(@PATH, 71, 229.821, -4606.99, 240.997, 0, 0, 0, 0, 100, 0), +(@PATH, 70, 234.019, -4584.06, 244.052, 0, 0, 0, 0, 100, 0), +(@PATH, 69, 239.693, -4561.45, 246.739, 0, 0, 0, 0, 100, 0), +(@PATH, 68, 246.252, -4541.43, 247.69, 0, 0, 0, 0, 100, 0), +(@PATH, 67, 253.509, -4519.28, 247.936, 0, 0, 0, 0, 100, 0), +(@PATH, 66, 261.137, -4496, 246.019, 0, 0, 0, 0, 100, 0), +(@PATH, 65, 270.152, -4469.53, 243.519, 0, 0, 0, 0, 100, 0), +(@PATH, 64, 278.597, -4445.37, 243.805, 0, 0, 0, 0, 100, 0), +(@PATH, 63, 293.459, -4423.06, 240.422, 0, 0, 0, 0, 100, 0), +(@PATH, 62, 308.571, -4405.31, 237.038, 0, 0, 0, 0, 100, 0), +(@PATH, 61, 324.587, -4395.68, 236.46, 0, 0, 0, 0, 100, 0), +(@PATH, 60, 348.262, -4383.1, 233.491, 0, 0, 0, 0, 100, 0), +(@PATH, 59, 370.478, -4372.92, 230.56, 0, 0, 0, 0, 100, 0), +(@PATH, 58, 396.919, -4363.71, 226.727, 0, 0, 0, 0, 100, 0), +(@PATH, 57, 421.592, -4356.55, 224.012, 0, 0, 0, 0, 100, 0), +(@PATH, 56, 444.866, -4348.9, 218.926, 0, 0, 0, 0, 100, 0), +(@PATH, 55, 467.093, -4328.29, 219.978, 0, 0, 0, 0, 100, 0), +(@PATH, 54, 487.728, -4320.13, 216.692, 0, 0, 0, 0, 100, 0), +(@PATH, 53, 513.045, -4311.31, 213.394, 0, 0, 0, 0, 100, 0), +(@PATH, 52, 539.473, -4302.27, 210.214, 0, 0, 0, 0, 100, 0), +(@PATH, 51, 569.566, -4292.96, 208.345, 0, 0, 0, 0, 100, 0), +(@PATH, 50, 599.151, -4286.06, 211.228, 0, 0, 0, 0, 100, 0), +(@PATH, 49, 626.333, -4279.72, 207.41, 0, 0, 0, 0, 100, 0), +(@PATH, 48, 639.441, -4274.8, 204.5, 0, 0, 0, 0, 100, 0), +(@PATH, 47, 669.414, -4265.14, 201.057, 0, 0, 0, 0, 100, 0), +(@PATH, 46, 694.932, -4256.92, 197.339, 0, 0, 0, 0, 100, 0), +(@PATH, 45, 719.042, -4252.18, 194.113, 0, 0, 0, 0, 100, 0), +(@PATH, 44, 746.517, -4246.78, 190.165, 0, 0, 0, 0, 100, 0), +(@PATH, 43, 773.652, -4239.6, 185.035, 0, 0, 0, 0, 100, 0), +(@PATH, 42, 788.697, -4238.1, 183.884, 0, 0, 0, 0, 100, 0), +(@PATH, 41, 809.617, -4235.62, 178.696, 0, 0, 0, 0, 100, 0), +(@PATH, 40, 830.245, -4239.16, 176.606, 0, 0, 0, 0, 100, 0), +(@PATH, 39, 856.9, -4240.27, 173.761, 0, 0, 0, 0, 100, 0), +(@PATH, 38, 887.184, -4241.53, 172.174, 0, 0, 0, 0, 100, 0), +(@PATH, 37, 915.043, -4244.34, 169.077, 0, 0, 0, 0, 100, 0), +(@PATH, 36, 945.863, -4237.87, 164.815, 0, 0, 0, 0, 100, 0), +(@PATH, 35, 975.129, -4230.22, 161.842, 0, 0, 0, 0, 100, 0), +(@PATH, 34, 1002.35, -4223.36, 161.401, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 1034.18, -4230.82, 163.087, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 1062.48, -4241.65, 161.884, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 1089.17, -4253.36, 157.158, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 1111.77, -4265.56, 158.432, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 1145.89, -4285.82, 159.868, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 1121.21, -4266.25, 158.309, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 1102.14, -4254.96, 156.27, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 1073.58, -4236.91, 160.029, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 1056.73, -4222.6, 161.806, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 1039.45, -4200.56, 163.18, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 1031.87, -4176.05, 162.161, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 1016.34, -4163.74, 159.168, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 987.273, -4161.04, 159.711, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 961.659, -4160.48, 161.33, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 933.212, -4166.9, 163.671, 0, 0, 0, 0, 100, 0), +(@PATH, 1, 475.035, -4278.07, 228.181, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 502.505, -4287.72, 218.585, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 526.723, -4296.29, 213.177, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 555.716, -4299.68, 208.203, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 588.967, -4306.18, 209.301, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 612.82, -4293.98, 208.841, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 635.626, -4282.17, 205.791, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 662.86, -4275.82, 200.324, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 683.811, -4263.12, 199.173, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 707.863, -4246.58, 196.467, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 726.315, -4239.22, 193.225, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 753.136, -4237.44, 189.323, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 773.723, -4233.31, 183.506, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 793.134, -4216.48, 181.369, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 815.803, -4200.09, 179.988, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 841.911, -4190.02, 174.219, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 879.845, -4183.46, 169.019, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 907.268, -4173.66, 166.74, 0, 0, 0, 0, 100, 0); |