diff options
| -rw-r--r-- | sql/updates/world/2015_07_15_04_world_2015_07_15_00.sql | 568 |
1 files changed, 568 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_15_04_world_2015_07_15_00.sql b/sql/updates/world/2015_07_15_04_world_2015_07_15_00.sql new file mode 100644 index 00000000000..fb7a0799f86 --- /dev/null +++ b/sql/updates/world/2015_07_15_04_world_2015_07_15_00.sql @@ -0,0 +1,568 @@ +-- Dragonblight - New Hearthglen + Dragon Wastes + +UPDATE `smart_scripts` SET `action_param1`=1 WHERE `entryorguid`=27202 AND `source_type`=0 AND `id`=0 AND `link`=0; + +-- 1. +SET @NPC := 111051; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3097.314,`position_y`=201.7772,`position_z`=82.8672 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,3097.314,201.7772,82.8672,0,0,0,0,100,0), +(@PATH,2,3095.814,201.7772,83.1172,0,0,0,0,100,0), +(@PATH,3,3083.064,201.5272,83.6172,0,0,0,0,100,0), +(@PATH,4,3079.064,201.5272,84.3672,0,0,0,0,100,0), +(@PATH,5,3078.733,201.5618,84.32298,0,0,0,0,100,0), +(@PATH,6,3076.983,201.5618,84.57298,0,0,0,0,100,0), +(@PATH,7,3067.483,200.8118,83.82298,0,0,0,0,100,0), +(@PATH,8,3061.504,200.19,83.48076,0,0,0,0,100,0), +(@PATH,9,3051.754,199.44,82.98076,0,0,0,0,100,0), +(@PATH,10,3045.92,198.7205,82.55244,0,0,0,0,100,0), +(@PATH,11,3037.92,198.7205,82.05244,0,0,0,0,100,0), +(@PATH,12,3032.92,198.7205,81.55244,0,0,0,0,100,0), +(@PATH,13,3015.99,198.9897,81.57481,0,0,0,0,100,0), +(@PATH,14,3009.99,199.9897,81.07481,0,0,0,0,100,0), +(@PATH,15,3004.99,200.9897,80.57481,0,0,0,0,100,0), +(@PATH,16,3008.823,200.244,80.83981,0,0,0,0,100,0), +(@PATH,17,3013.823,199.244,81.58981,0,0,0,0,100,0), +(@PATH,18,3015.993,198.7468,81.95679,0,0,0,0,100,0), +(@PATH,19,3039.743,198.7468,82.20679,0,0,0,0,100,0), +(@PATH,20,3046.347,198.8345,82.82155,0,0,0,0,100,0), +(@PATH,21,3057.847,199.8345,83.32155,0,0,0,0,100,0), +(@PATH,22,3061.647,200.3903,83.72079,0,0,0,0,100,0), +(@PATH,23,3068.397,200.6403,83.97079,0,0,0,0,100,0), +(@PATH,24,3072.397,201.1403,84.72079,0,0,0,0,100,0), +(@PATH,25,3077.279,201.5229,84.55926,0,0,0,0,100,0), +(@PATH,26,3081.279,201.5229,83.80926,0,0,0,0,100,0), +(@PATH,27,3085.279,201.5229,83.55926,0,0,0,0,100,0), +(@PATH,28,3095.985,201.9144,82.76643,0,0,0,0,100,0), +(@PATH,29,3100.985,201.4144,82.26643,0,0,0,0,100,0), +(@PATH,30,3104.985,200.9144,81.51643,0,0,0,0,100,0), +(@PATH,31,3111.985,200.1644,81.01643,0,0,0,0,100,0), +(@PATH,32,3117.735,199.9144,80.51643,0,0,0,0,100,0), +(@PATH,33,3121.735,199.4144,80.01643,0,0,0,0,100,0), +(@PATH,34,3126.735,198.9144,79.26643,0,0,0,0,100,0), +(@PATH,35,3134.341,198.3681,78.92584,0,0,0,0,100,0), +(@PATH,36,3152.091,199.6181,78.17584,0,0,0,0,100,0), +(@PATH,37,3156.091,199.8681,77.92584,0,0,0,0,100,0), +(@PATH,38,3161.091,200.3681,77.42584,0,0,0,0,100,0), +(@PATH,39,3161.268,200.6497,77.01109,0,0,0,0,100,0), +(@PATH,40,3163.768,200.8997,77.26109,0,0,0,0,100,0), +(@PATH,41,3168.268,202.8997,77.76109,0,0,0,0,100,0), +(@PATH,42,3186.018,211.3997,77.01109,0,0,0,0,100,0), +(@PATH,43,3188.542,212.8027,76.7966,0,0,0,0,100,0), +(@PATH,44,3192.042,216.3027,76.2966,0,0,0,0,100,0), +(@PATH,45,3212.792,238.761,75.90543,0,0,0,0,100,0), +(@PATH,46,3219.042,250.011,75.40543,0,0,0,0,100,0), +(@PATH,47,3225.542,262.011,74.65543,0,0,0,0,100,0), +(@PATH,48,3226.542,264.011,74.15543,0,0,0,0,100,0), +(@PATH,49,3228.292,267.511,73.40543,0,0,0,0,100,0), +(@PATH,50,3230.292,271.011,72.40543,0,0,0,0,100,0), +(@PATH,51,3232.792,275.261,71.65543,0,0,0,0,100,0), +(@PATH,52,3234.073,277.7794,71.81288,0,0,0,0,100,0), +(@PATH,53,3237.073,281.7794,72.56288,0,0,0,0,100,0), +(@PATH,54,3239.823,285.7794,73.56288,0,0,0,0,100,0), +(@PATH,55,3242.323,289.0294,74.31288,0,0,0,0,100,0), +(@PATH,56,3257.073,310.0294,74.81288,0,0,0,0,100,0), +(@PATH,57,3258.073,311.5294,75.56288,0,0,0,0,100,0), +(@PATH,58,3259.153,313.129,75.61668,0,0,0,0,100,0), +(@PATH,59,3264.903,320.129,76.11668,0,0,0,0,100,0), +(@PATH,60,3268.653,324.879,75.61668,0,0,0,0,100,0), +(@PATH,61,3270.403,327.379,74.86668,0,0,0,0,100,0), +(@PATH,62,3271.903,329.379,74.11668,0,0,0,0,100,0), +(@PATH,63,3277.653,336.379,73.61668,0,0,0,0,100,0), +(@PATH,64,3281.153,341.129,72.86668,0,0,0,0,100,0), +(@PATH,65,3285.607,346.5189,72.45518,0,0,0,0,100,0), +(@PATH,66,3303.357,363.5189,72.70518,0,0,0,0,100,0), +(@PATH,67,3305.602,365.6404,72.97585,0,0,0,0,100,0), +(@PATH,68,3325.852,373.3904,72.47585,0,0,0,0,100,0), +(@PATH,69,3330.694,375.6069,71.93503,0,0,0,0,100,0), +(@PATH,70,3334.444,376.3569,71.18503,0,0,0,0,100,0), +(@PATH,71,3336.444,376.8569,70.68503,0,0,0,0,100,0), +(@PATH,72,3338.444,377.1069,69.93503,0,0,0,0,100,0), +(@PATH,73,3350.944,379.6069,69.18503,0,0,0,0,100,0), +(@PATH,74,3352.944,380.1069,68.93503,0,0,0,0,100,0), +(@PATH,75,3355.694,380.6069,68.18503,0,0,0,0,100,0), +(@PATH,76,3361.694,381.8569,67.43503,0,0,0,0,100,0), +(@PATH,77,3363.702,382.506,67.33813,0,0,0,0,100,0), +(@PATH,78,3356.702,381.006,68.08813,0,0,0,0,100,0), +(@PATH,79,3353.952,380.256,68.58813,0,0,0,0,100,0), +(@PATH,80,3350.952,379.756,69.33813,0,0,0,0,100,0), +(@PATH,81,3346.202,378.756,69.83813,0,0,0,0,100,0), +(@PATH,82,3336.452,376.756,70.58813,0,0,0,0,100,0), +(@PATH,83,3334.452,376.256,71.33813,0,0,0,0,100,0), +(@PATH,84,3330.367,375.3779,72.00482,0,0,0,0,100,0), +(@PATH,85,3324.867,373.1279,72.50482,0,0,0,0,100,0), +(@PATH,86,3318.617,370.6279,73.25482,0,0,0,0,100,0), +(@PATH,87,3305.183,365.389,72.8768,0,0,0,0,100,0), +(@PATH,88,3298.683,359.139,72.3768,0,0,0,0,100,0), +(@PATH,89,3285.406,346.3057,72.51546,0,0,0,0,100,0), +(@PATH,90,3280.406,340.0557,73.01546,0,0,0,0,100,0), +(@PATH,91,3277.156,336.0557,73.76546,0,0,0,0,100,0), +(@PATH,92,3272.656,330.0557,74.01546,0,0,0,0,100,0), +(@PATH,93,3270.656,327.8057,74.76546,0,0,0,0,100,0), +(@PATH,94,3268.906,325.3057,75.51546,0,0,0,0,100,0), +(@PATH,95,3266.406,322.3057,76.01546,0,0,0,0,100,0), +(@PATH,96,3258.985,312.77,75.75705,0,0,0,0,100,0), +(@PATH,97,3257.235,310.52,74.75705,0,0,0,0,100,0), +(@PATH,98,3254.985,307.27,74.25705,0,0,0,0,100,0), +(@PATH,99,3240.235,286.27,73.50705,0,0,0,0,100,0), +(@PATH,100,3238.985,284.52,73.00705,0,0,0,0,100,0), +(@PATH,101,3236.735,281.27,72.25705,0,0,0,0,100,0), +(@PATH,102,3233.873,277.4071,72.02361,0,0,0,0,100,0), +(@PATH,103,3232.373,274.9071,71.27361,0,0,0,0,100,0), +(@PATH,104,3230.123,270.4071,73.02361,0,0,0,0,100,0), +(@PATH,105,3228.123,266.9071,73.77361,0,0,0,0,100,0), +(@PATH,106,3226.123,263.4071,74.27361,0,0,0,0,100,0), +(@PATH,107,3224.623,260.6571,75.02361,0,0,0,0,100,0), +(@PATH,108,3216.873,246.1571,75.77361,0,0,0,0,100,0), +(@PATH,109,3212.646,238.5428,76.13255,0,0,0,0,100,0), +(@PATH,110,3190.146,214.5428,76.63255,0,0,0,0,100,0), +(@PATH,111,3188.266,212.4306,76.7549,0,0,0,0,100,0), +(@PATH,112,3183.766,210.4306,77.5049,0,0,0,0,100,0), +(@PATH,113,3179.266,208.1806,78.0049,0,0,0,0,100,0), +(@PATH,114,3166.016,201.9306,77.2549,0,0,0,0,100,0), +(@PATH,115,3163.59,200.5424,77.43803,0,0,0,0,100,0), +(@PATH,116,3155.59,199.7924,77.93803,0,0,0,0,100,0), +(@PATH,117,3152.59,199.5424,78.18803,0,0,0,0,100,0), +(@PATH,118,3149.59,199.5424,78.93803,0,0,0,0,100,0), +(@PATH,119,3134.203,198.276,79.24261,0,0,0,0,100,0), +(@PATH,120,3122.203,199.526,79.74261,0,0,0,0,100,0), +(@PATH,121,3118.203,199.776,80.49261,0,0,0,0,100,0), +(@PATH,122,3113.453,200.026,80.99261,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=111051; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(111051, 111051, 0, 0, 2, 0, 0), +(111051, 111169, 7, 0, 2, 0, 0), +(111051, 111170, 14, 0, 2, 0, 0); +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid` IN (111169, 111170); + +-- 2. +SET @NPC := 110954; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3304.004,`position_y`=-122.7727,`position_z`=73.01753 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,3304.004,-122.7727,73.01753,0,0,0,0,100,0), +(@PATH,2,3319.027,-148.6648,72.38235,0,0,0,0,100,0), +(@PATH,3,3323.527,-152.6648,72.13235,0,0,0,0,100,0), +(@PATH,4,3335.219,-163.2354,72.44555,0,0,0,0,100,0), +(@PATH,5,3336.969,-165.7354,73.19555,0,0,0,0,100,0), +(@PATH,6,3340.719,-171.4854,73.44555,0,0,0,0,100,0), +(@PATH,7,3347.469,-181.2354,73.94555,0,0,0,0,100,0), +(@PATH,8,3349.921,-184.613,74.75533,0,0,0,0,100,0), +(@PATH,9,3362.921,-206.863,75.50533,0,0,0,0,100,0), +(@PATH,10,3364.921,-210.113,76.00533,0,0,0,0,100,0), +(@PATH,11,3366.921,-213.613,76.75533,0,0,0,0,100,0), +(@PATH,12,3366.664,-213.1822,76.19576,0,0,0,0,100,0), +(@PATH,13,3364.664,-209.9322,75.69576,0,0,0,0,100,0), +(@PATH,14,3361.664,-204.6822,75.19576,0,0,0,0,100,0), +(@PATH,15,3357.414,-197.1822,74.44576,0,0,0,0,100,0), +(@PATH,16,3352.664,-189.4322,75.19576,0,0,0,0,100,0), +(@PATH,17,3349.638,-184.3163,74.51703,0,0,0,0,100,0), +(@PATH,18,3347.888,-181.8163,74.01703,0,0,0,0,100,0), +(@PATH,19,3345.138,-177.8163,73.51703,0,0,0,0,100,0), +(@PATH,20,3337.388,-166.5663,73.01703,0,0,0,0,100,0), +(@PATH,21,3334.927,-162.9315,72.23009,0,0,0,0,100,0), +(@PATH,22,3331.177,-159.6815,71.98009,0,0,0,0,100,0), +(@PATH,23,3319.677,-149.1815,72.23009,0,0,0,0,100,0), +(@PATH,24,3319.346,-149.0192,72.46732,0,0,0,0,100,0), +(@PATH,25,3318.846,-148.2692,72.46732,0,0,0,0,100,0), +(@PATH,26,3305.346,-125.2692,72.96732,0,0,0,0,100,0), +(@PATH,27,3303.776,-122.4284,73.08718,0,0,0,0,100,0), +(@PATH,28,3289.361,-101.321,73.01395,0,0,0,0,100,0), +(@PATH,29,3281.611,-92.07098,72.26395,0,0,0,0,100,0), +(@PATH,30,3278.611,-88.07098,72.01395,0,0,0,0,100,0), +(@PATH,31,3264.892,-71.45324,71.77171,0,0,0,0,100,0), +(@PATH,32,3257.642,-67.95324,71.52171,0,0,0,0,100,0), +(@PATH,33,3235.607,-56.83378,71.66665,0,0,0,0,100,0), +(@PATH,34,3231.857,-58.08378,72.41665,0,0,0,0,100,0), +(@PATH,35,3227.857,-59.33378,72.91665,0,0,0,0,100,0), +(@PATH,36,3223.107,-60.58378,73.41665,0,0,0,0,100,0), +(@PATH,37,3218.607,-61.83378,74.16665,0,0,0,0,100,0), +(@PATH,38,3211.857,-63.83378,74.66665,0,0,0,0,100,0), +(@PATH,39,3206.546,-65.78079,75.45023,0,0,0,0,100,0), +(@PATH,40,3199.546,-69.78079,75.95023,0,0,0,0,100,0), +(@PATH,41,3196.296,-71.78079,76.70023,0,0,0,0,100,0), +(@PATH,42,3193.796,-73.03079,76.95023,0,0,0,0,100,0), +(@PATH,43,3188.796,-76.28079,77.70023,0,0,0,0,100,0), +(@PATH,44,3185.296,-78.28079,78.20023,0,0,0,0,100,0), +(@PATH,45,3181.796,-80.28079,78.95023,0,0,0,0,100,0), +(@PATH,46,3181.48,-80.20216,79.14981,0,0,0,0,100,0), +(@PATH,47,3181.23,-80.45216,79.14981,0,0,0,0,100,0), +(@PATH,48,3146.48,-77.95216,78.64981,0,0,0,0,100,0), +(@PATH,49,3144.093,-77.49599,78.68388,0,0,0,0,100,0), +(@PATH,50,3133.843,-69.49599,79.43388,0,0,0,0,100,0), +(@PATH,51,3120.843,-58.99599,78.68388,0,0,0,0,100,0), +(@PATH,52,3117.372,-56.24393,78.32555,0,0,0,0,100,0), +(@PATH,53,3107.122,-51.99393,77.57555,0,0,0,0,100,0), +(@PATH,54,3101.622,-49.74393,77.07555,0,0,0,0,100,0), +(@PATH,55,3099.122,-48.99393,76.57555,0,0,0,0,100,0), +(@PATH,56,3095.372,-47.49393,76.07555,0,0,0,0,100,0), +(@PATH,57,3091.622,-45.99393,75.32555,0,0,0,0,100,0), +(@PATH,58,3080.474,-41.3601,75.43945,0,0,0,0,100,0), +(@PATH,59,3067.474,-42.6101,74.68945,0,0,0,0,100,0), +(@PATH,60,3052.724,-44.1101,74.43945,0,0,0,0,100,0), +(@PATH,61,3045.986,-45.10185,73.82922,0,0,0,0,100,0), +(@PATH,62,3037.736,-53.35185,73.32922,0,0,0,0,100,0), +(@PATH,63,3029.236,-61.60185,73.82922,0,0,0,0,100,0), +(@PATH,64,3029.299,-61.83793,73.84348,0,0,0,0,100,0), +(@PATH,65,3027.799,-63.58793,73.84348,0,0,0,0,100,0), +(@PATH,66,3029.799,-70.08793,73.34348,0,0,0,0,100,0), +(@PATH,67,3032.049,-76.83793,72.84348,0,0,0,0,100,0), +(@PATH,68,3033.299,-81.33793,72.34348,0,0,0,0,100,0), +(@PATH,69,3035.799,-88.83793,71.84348,0,0,0,0,100,0), +(@PATH,70,3037.615,-93.84658,71.53387,0,0,0,0,100,0), +(@PATH,71,3042.365,-97.59658,72.03387,0,0,0,0,100,0), +(@PATH,72,3063.115,-112.8466,72.53387,0,0,0,0,100,0), +(@PATH,73,3069.688,-117.9348,72.68712,0,0,0,0,100,0), +(@PATH,74,3078.188,-125.1848,73.68712,0,0,0,0,100,0), +(@PATH,75,3079.688,-126.4348,74.18712,0,0,0,0,100,0), +(@PATH,76,3081.938,-128.4348,75.18712,0,0,0,0,100,0), +(@PATH,77,3084.188,-130.4348,75.68712,0,0,0,0,100,0), +(@PATH,78,3086.438,-132.4348,76.43712,0,0,0,0,100,0), +(@PATH,79,3089.938,-135.4348,76.93712,0,0,0,0,100,0), +(@PATH,80,3093.688,-138.6848,77.68712,0,0,0,0,100,0), +(@PATH,81,3100.438,-144.4348,78.43712,0,0,0,0,100,0), +(@PATH,82,3094.992,-139.7807,77.4295,0,0,0,0,100,0), +(@PATH,83,3089.492,-135.0307,76.6795,0,0,0,0,100,0), +(@PATH,84,3086.742,-132.7807,76.1795,0,0,0,0,100,0), +(@PATH,85,3083.742,-130.0307,75.4295,0,0,0,0,100,0), +(@PATH,86,3080.742,-127.5307,74.6795,0,0,0,0,100,0), +(@PATH,87,3079.242,-126.2807,74.1795,0,0,0,0,100,0), +(@PATH,88,3077.742,-124.7807,73.1795,0,0,0,0,100,0), +(@PATH,89,3075.492,-123.0307,72.6795,0,0,0,0,100,0), +(@PATH,90,3069.613,-117.7452,72.45045,0,0,0,0,100,0), +(@PATH,91,3042.613,-97.49518,71.95045,0,0,0,0,100,0), +(@PATH,92,3038.613,-94.49518,71.70045,0,0,0,0,100,0), +(@PATH,93,3038.275,-94.41074,71.51865,0,0,0,0,100,0), +(@PATH,94,3037.275,-93.66074,71.51865,0,0,0,0,100,0), +(@PATH,95,3034.525,-85.16074,72.26865,0,0,0,0,100,0), +(@PATH,96,3033.025,-79.41074,72.51865,0,0,0,0,100,0), +(@PATH,97,3031.525,-74.91074,73.01865,0,0,0,0,100,0), +(@PATH,98,3029.025,-67.41074,73.76865,0,0,0,0,100,0), +(@PATH,99,3027.747,-63.19135,73.97582,0,0,0,0,100,0), +(@PATH,100,3032.747,-58.19135,73.72582,0,0,0,0,100,0), +(@PATH,101,3046.227,-44.84958,74.18223,0,0,0,0,100,0), +(@PATH,102,3056.227,-43.84958,74.43223,0,0,0,0,100,0), +(@PATH,103,3070.727,-42.34958,74.93223,0,0,0,0,100,0), +(@PATH,104,3080.749,-41.29838,75.66859,0,0,0,0,100,0), +(@PATH,105,3097.249,-48.29838,76.41859,0,0,0,0,100,0), +(@PATH,106,3100.749,-49.54838,76.91859,0,0,0,0,100,0), +(@PATH,107,3103.499,-50.54838,77.41859,0,0,0,0,100,0), +(@PATH,108,3108.999,-52.79838,78.16859,0,0,0,0,100,0), +(@PATH,109,3117.556,-56.57686,78.39417,0,0,0,0,100,0), +(@PATH,110,3121.556,-59.57686,79.14417,0,0,0,0,100,0), +(@PATH,111,3124.556,-62.07686,79.64417,0,0,0,0,100,0), +(@PATH,112,3136.056,-71.32686,79.14417,0,0,0,0,100,0), +(@PATH,113,3144.39,-77.77893,78.85022,0,0,0,0,100,0), +(@PATH,114,3159.14,-78.77893,79.35022,0,0,0,0,100,0), +(@PATH,115,3181.306,-80.64502,79.26598,0,0,0,0,100,0), +(@PATH,116,3184.056,-78.89502,78.51598,0,0,0,0,100,0), +(@PATH,117,3187.306,-76.89502,78.01598,0,0,0,0,100,0), +(@PATH,118,3191.806,-74.39502,77.26598,0,0,0,0,100,0), +(@PATH,119,3196.556,-71.64502,76.76598,0,0,0,0,100,0), +(@PATH,120,3199.056,-70.14502,76.01598,0,0,0,0,100,0), +(@PATH,121,3202.556,-67.89502,75.26598,0,0,0,0,100,0), +(@PATH,122,3206.884,-65.36325,75.14902,0,0,0,0,100,0), +(@PATH,123,3216.384,-62.61325,74.14902,0,0,0,0,100,0), +(@PATH,124,3222.884,-60.86325,73.39902,0,0,0,0,100,0), +(@PATH,125,3226.634,-59.61325,73.14902,0,0,0,0,100,0), +(@PATH,126,3230.384,-58.36325,72.39902,0,0,0,0,100,0), +(@PATH,127,3235.92,-57.03172,71.59767,0,0,0,0,100,0), +(@PATH,128,3265.016,-71.74498,72.00586,0,0,0,0,100,0), +(@PATH,129,3282.766,-93.24498,72.50586,0,0,0,0,100,0), +(@PATH,130,3289.59,-101.6345,73.0332,0,0,0,0,100,0), +(@PATH,131,3304.02,-122.7957,73.0175,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=110954; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(110954, 110954, 0, 0, 2, 0, 0), +(110954, 111173, 8, 0, 2, 0, 0); +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `guid`=111173; + +-- 3. +SET @NPC := 111049; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3204.118,`position_y`=9.464139,`position_z`=75.35005 WHERE `guid`=@NPC; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3204.118,`position_y`=9.464139,`position_z`=75.35005 WHERE `guid`=111176; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3204.118,`position_y`=9.464139,`position_z`=75.35005 WHERE `guid`=111177; +UPDATE `creature` SET `spawndist`=0,`MovementType`=0,`position_x`=3204.118,`position_y`=9.464139,`position_z`=75.35005 WHERE `guid`=111175; +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,3204.118,9.464139,75.35005,0,0,0,0,100,0), +(@PATH,2,3205.47,15.98113,76.06122,0,0,0,0,100,0), +(@PATH,3,3207.97,27.73113,76.31122,0,0,0,0,100,0), +(@PATH,4,3211.72,45.23113,77.06122,0,0,0,0,100,0), +(@PATH,5,3213.318,49.37894,77.8667,0,0,0,0,100,0), +(@PATH,6,3214.818,54.12894,78.3667,0,0,0,0,100,0), +(@PATH,7,3215.568,57.12894,79.1167,0,0,0,0,100,0), +(@PATH,8,3217.068,61.62894,79.3667,0,0,0,0,100,0), +(@PATH,9,3218.818,67.12894,80.3667,0,0,0,0,100,0), +(@PATH,10,3219.818,70.12894,81.1167,0,0,0,0,100,0), +(@PATH,11,3220.568,72.87894,81.8667,0,0,0,0,100,0), +(@PATH,12,3221.643,75.57011,82.44968,0,0,0,0,100,0), +(@PATH,13,3224.393,78.57011,82.69968,0,0,0,0,100,0), +(@PATH,14,3241.643,97.57011,83.44968,0,0,0,0,100,0), +(@PATH,15,3246.592,103.0302,83.87857,0,0,0,0,100,0), +(@PATH,16,3252.592,104.2802,83.12857,0,0,0,0,100,0), +(@PATH,17,3256.342,105.2802,82.62857,0,0,0,0,100,0), +(@PATH,18,3259.342,105.7802,81.87857,0,0,0,0,100,0), +(@PATH,19,3263.342,106.5302,81.37857,0,0,0,0,100,0), +(@PATH,20,3267.842,107.5302,80.62857,0,0,0,0,100,0), +(@PATH,21,3271.842,108.5302,80.12857,0,0,0,0,100,0), +(@PATH,22,3274.592,109.0302,79.62857,0,0,0,0,100,0), +(@PATH,23,3277.592,109.7802,78.87857,0,0,0,0,100,0), +(@PATH,24,3280.592,110.2802,78.12857,0,0,0,0,100,0), +(@PATH,25,3283.592,111.0302,77.62857,0,0,0,0,100,0), +(@PATH,26,3286.352,111.8738,76.87943,0,0,0,0,100,0), +(@PATH,27,3290.352,111.8738,76.12943,0,0,0,0,100,0), +(@PATH,28,3294.352,112.1238,75.62943,0,0,0,0,100,0), +(@PATH,29,3298.352,112.3738,74.87943,0,0,0,0,100,0), +(@PATH,30,3302.102,112.3738,74.37943,0,0,0,0,100,0), +(@PATH,31,3305.102,112.3738,73.87943,0,0,0,0,100,0), +(@PATH,32,3307.102,112.3738,73.12943,0,0,0,0,100,0), +(@PATH,33,3309.852,112.3738,72.87943,0,0,0,0,100,0), +(@PATH,34,3312.852,112.6238,72.12943,0,0,0,0,100,0), +(@PATH,35,3316.852,112.8738,71.62943,0,0,0,0,100,0), +(@PATH,36,3318.852,112.8738,70.87943,0,0,0,0,100,0), +(@PATH,37,3320.852,112.8738,70.37943,0,0,0,0,100,0), +(@PATH,38,3324.852,113.1238,69.37943,0,0,0,0,100,0), +(@PATH,39,3334.725,113.7286,69.50629,0,0,0,0,100,0), +(@PATH,40,3349.225,120.2286,69.00629,0,0,0,0,100,0), +(@PATH,41,3353.475,122.2286,68.25629,0,0,0,0,100,0), +(@PATH,42,3363.475,126.7286,68.00629,0,0,0,0,100,0), +(@PATH,43,3369.216,129.3355,67.4007,0,0,0,0,100,0), +(@PATH,44,3382.966,135.0855,66.9007,0,0,0,0,100,0), +(@PATH,45,3387.466,137.0855,66.4007,0,0,0,0,100,0), +(@PATH,46,3389.966,138.0855,65.6507,0,0,0,0,100,0), +(@PATH,47,3391.966,138.8355,64.9007,0,0,0,0,100,0), +(@PATH,48,3394.716,140.0855,64.4007,0,0,0,0,100,0), +(@PATH,49,3397.466,141.0855,63.90069,0,0,0,0,100,0), +(@PATH,50,3400.216,142.3355,63.15069,0,0,0,0,100,0), +(@PATH,51,3403.966,143.8355,62.65069,0,0,0,0,100,0), +(@PATH,52,3406.716,145.0855,61.90069,0,0,0,0,100,0), +(@PATH,53,3410.216,146.5855,61.15069,0,0,0,0,100,0), +(@PATH,54,3410.457,146.9182,60.77554,0,0,0,0,100,0), +(@PATH,55,3410.957,147.1682,60.52554,0,0,0,0,100,0), +(@PATH,56,3413.957,147.1682,59.52554,0,0,0,0,100,0), +(@PATH,57,3417.957,147.6682,58.77554,0,0,0,0,100,0), +(@PATH,58,3420.957,147.6682,58.02554,0,0,0,0,100,0), +(@PATH,59,3422.957,147.6682,57.27554,0,0,0,0,100,0), +(@PATH,60,3425.957,147.9182,57.02554,0,0,0,0,100,0), +(@PATH,61,3428.707,148.1682,56.27554,0,0,0,0,100,0), +(@PATH,62,3435.707,148.6682,55.77554,0,0,0,0,100,0), +(@PATH,63,3439.707,148.9182,55.02554,0,0,0,0,100,0), +(@PATH,64,3442.707,149.1682,54.52554,0,0,0,0,100,0), +(@PATH,65,3445.457,149.4182,53.77554,0,0,0,0,100,0), +(@PATH,66,3447.674,149.3518,53.08506,0,0,0,0,100,0), +(@PATH,67,3459.174,139.8518,52.58506,0,0,0,0,100,0), +(@PATH,68,3461.424,137.8518,51.83506,0,0,0,0,100,0), +(@PATH,69,3462.924,136.6018,51.08506,0,0,0,0,100,0), +(@PATH,70,3464.924,134.8518,50.08506,0,0,0,0,100,0), +(@PATH,71,3466.424,133.6018,49.83506,0,0,0,0,100,0), +(@PATH,72,3467.924,132.3518,48.83506,0,0,0,0,100,0), +(@PATH,73,3470.174,130.3518,48.08506,0,0,0,0,100,0), +(@PATH,74,3473.424,127.8518,47.33506,0,0,0,0,100,0), +(@PATH,75,3480.498,121.4224,47.18571,0,0,0,0,100,0), +(@PATH,76,3479.248,114.4224,47.93571,0,0,0,0,100,0), +(@PATH,77,3478.248,110.6724,48.68571,0,0,0,0,100,0), +(@PATH,78,3477.998,108.6724,49.18571,0,0,0,0,100,0), +(@PATH,79,3477.248,105.9224,49.68571,0,0,0,0,100,0), +(@PATH,80,3476.498,101.1724,50.43571,0,0,0,0,100,0), +(@PATH,81,3474.998,94.17238,50.93571,0,0,0,0,100,0), +(@PATH,82,3474.048,90.14128,52.04639,0,0,0,0,100,0), +(@PATH,83,3473.548,88.14128,52.54639,0,0,0,0,100,0), +(@PATH,84,3473.048,85.14128,53.29639,0,0,0,0,100,0), +(@PATH,85,3472.548,82.14128,53.79639,0,0,0,0,100,0), +(@PATH,86,3471.798,79.14128,54.54639,0,0,0,0,100,0), +(@PATH,87,3471.298,76.39128,54.79639,0,0,0,0,100,0), +(@PATH,88,3470.798,73.64128,55.79639,0,0,0,0,100,0), +(@PATH,89,3470.048,69.64128,56.54639,0,0,0,0,100,0), +(@PATH,90,3469.548,66.64128,57.04639,0,0,0,0,100,0), +(@PATH,91,3467.798,58.89128,57.79639,0,0,0,0,100,0), +(@PATH,92,3469.408,81.3713,54.02486,0,0,0,0,100,0), +(@PATH,93,3466.544,80.8951,54.98119,0,0,0,0,100,0), +(@PATH,94,3465.019,80.68309,55.57894,0,0,0,0,100,0), +(@PATH,95,3462.21,80.21594,56.55909,0,0,0,0,100,0), +(@PATH,96,3458.183,79.50483,56.74107,0,0,0,0,100,0), +(@PATH,97,3455.251,79.01736,57.25414,0,0,0,0,100,0), +(@PATH,98,3452.344,78.53384,57.54979,0,0,0,0,100,0), +(@PATH,99,3449.389,78.04266,57.88622,0,0,0,0,100,0), +(@PATH,100,3446.469,77.55716,58.35838,0,0,0,0,100,0), +(@PATH,101,3443.532,77.06879,58.68077,0,0,0,0,100,0), +(@PATH,102,3440.594,76.58042,58.86436,0,0,0,0,100,0), +(@PATH,103,3437.662,76.09289,59.09081,0,0,0,0,100,0), +(@PATH,104,3434.707,75.60166,59.2318,0,0,0,0,100,0), +(@PATH,105,3431.76,75.11166,59.56713,0,0,0,0,100,0), +(@PATH,106,3428.82,74.62287,59.87059,0,0,0,0,100,0), +(@PATH,107,3425.868,74.13203,60.09984,0,0,0,0,100,0), +(@PATH,108,3422.948,73.64647,60.20043,0,0,0,0,100,0), +(@PATH,109,3419.998,73.15604,60.26659,0,0,0,0,100,0), +(@PATH,110,3417.046,72.66521,60.40856,0,0,0,0,100,0), +(@PATH,111,3414.094,72.17438,60.39159,0,0,0,0,100,0), +(@PATH,112,3411.139,71.68315,60.49242,0,0,0,0,100,0), +(@PATH,113,3408.184,71.19193,60.64159,0,0,0,0,100,0), +(@PATH,114,3409.099,68.8335,60.64159,0,0,0,0,100,0), +(@PATH,115,3411.684,66.93849,60.64159,0,0,0,0,100,0), +(@PATH,116,3412.484,65.64385,60.57561,0,0,0,0,100,0), +(@PATH,117,3413.367,64.55799,60.44646,0,0,0,0,100,0), +(@PATH,118,3414.696,63.14472,60.37041,0,0,0,0,100,0), +(@PATH,119,3415.821,61.74331,60.32146,0,0,0,0,100,0), +(@PATH,120,3416.772,60.17775,60.19646,0,0,0,0,100,0), +(@PATH,121,3417.788,58.71508,60.19646,0,0,0,0,100,0), +(@PATH,122,3418.686,57.17812,60.19646,0,0,0,0,100,0), +(@PATH,123,3419.607,55.69309,60.32146,0,0,0,0,100,0), +(@PATH,124,3420.03,54.76865,60.32146,0,0,0,0,100,0), +(@PATH,125,3420.979,53.13712,60.52642,0,0,0,0,100,0), +(@PATH,126,3420.976,52.08463,60.52617,0,0,0,0,100,0), +(@PATH,127,3421.843,50.63347,60.63018,0,0,0,0,100,0), +(@PATH,128,3422.437,49.25807,60.82146,0,0,0,0,100,0), +(@PATH,129,3422.029,48.15757,60.77752,0,0,0,0,100,0), +(@PATH,130,3422.841,46.16269,60.82146,0,0,0,0,100,0), +(@PATH,131,3422.26,45.06837,60.82146,0,0,0,0,100,0), +(@PATH,132,3423.068,42.39875,60.87688,0,0,0,0,100,0), +(@PATH,133,3422.673,41.40164,60.85466,0,0,0,0,100,0), +(@PATH,134,3423.321,39.57,60.94646,0,0,0,0,100,0), +(@PATH,135,3423.199,38.42225,60.94646,0,0,0,0,100,0), +(@PATH,136,3423.498,36.50599,60.95378,0,0,0,0,100,0), +(@PATH,137,3423.645,34.83721,60.84649,0,0,0,0,100,0), +(@PATH,138,3423.755,32.66412,60.86862,0,0,0,0,100,0), +(@PATH,139,3423.835,30.63097,60.86862,0,0,0,0,100,0), +(@PATH,140,3423.879,28.63033,60.94064,0,0,0,0,100,0), +(@PATH,141,3423.888,26.64286,61.10897,0,0,0,0,100,0), +(@PATH,142,3423.864,24.66538,61.24362,0,0,0,0,100,0), +(@PATH,143,3424.006,1.27307,61.94939,0,0,0,0,100,0), +(@PATH,144,3424.006,-20.47693,62.44939,0,0,0,0,100,0), +(@PATH,145,3424.256,-24.47693,62.94939,0,0,0,0,100,0), +(@PATH,146,3424.389,-36.41846,63.03847,0,0,0,0,100,0), +(@PATH,147,3424.889,-41.41846,62.53847,0,0,0,0,100,0), +(@PATH,148,3424.889,-46.16846,62.03847,0,0,0,0,100,0), +(@PATH,149,3425.941,-58.71535,61.96366,0,0,0,0,100,0), +(@PATH,150,3429.691,-61.71535,62.46366,0,0,0,0,100,0), +(@PATH,151,3435.191,-65.71535,61.71366,0,0,0,0,100,0), +(@PATH,152,3437.441,-67.71535,61.21366,0,0,0,0,100,0), +(@PATH,153,3439.191,-68.96535,60.71366,0,0,0,0,100,0), +(@PATH,154,3437.223,-67.2487,61.21352,0,0,0,0,100,0), +(@PATH,155,3433.973,-64.9987,61.96352,0,0,0,0,100,0), +(@PATH,156,3425.861,-58.53635,62.06436,0,0,0,0,100,0), +(@PATH,157,3424.611,-40.78635,62.56436,0,0,0,0,100,0), +(@PATH,158,3424.388,-36.07053,63.0836,0,0,0,0,100,0), +(@PATH,159,3427.138,-31.82054,63.5836,0,0,0,0,100,0), +(@PATH,160,3445.592,-3.802267,63.72139,0,0,0,0,100,0), +(@PATH,161,3448.342,3.697733,63.22139,0,0,0,0,100,0), +(@PATH,162,3449.342,6.697733,62.47139,0,0,0,0,100,0), +(@PATH,163,3450.592,10.44773,62.22139,0,0,0,0,100,0), +(@PATH,164,3451.592,13.94773,61.47139,0,0,0,0,100,0), +(@PATH,165,3454.842,23.44773,62.22139,0,0,0,0,100,0), +(@PATH,166,3458.153,32.557,61.3678,0,0,0,0,100,0), +(@PATH,167,3459.903,37.307,60.8678,0,0,0,0,100,0), +(@PATH,168,3462.653,44.557,60.1178,0,0,0,0,100,0), +(@PATH,169,3463.903,48.307,59.6178,0,0,0,0,100,0), +(@PATH,170,3465.403,51.807,59.1178,0,0,0,0,100,0), +(@PATH,171,3466.403,54.807,58.3678,0,0,0,0,100,0), +(@PATH,172,3467.404,56.96931,58.01789,0,0,0,0,100,0), +(@PATH,173,3468.904,63.96931,57.26789,0,0,0,0,100,0), +(@PATH,174,3470.154,69.71931,56.51789,0,0,0,0,100,0), +(@PATH,175,3470.654,73.46931,55.76789,0,0,0,0,100,0), +(@PATH,176,3471.154,75.46931,55.01789,0,0,0,0,100,0), +(@PATH,177,3471.654,78.21931,54.51789,0,0,0,0,100,0), +(@PATH,178,3472.154,81.21931,53.76789,0,0,0,0,100,0), +(@PATH,179,3473.154,85.21931,53.26789,0,0,0,0,100,0), +(@PATH,180,3473.654,88.21931,52.51789,0,0,0,0,100,0), +(@PATH,181,3474.163,89.99994,51.65433,0,0,0,0,100,0), +(@PATH,182,3474.913,93.99994,51.15433,0,0,0,0,100,0), +(@PATH,183,3476.163,98.74994,50.40433,0,0,0,0,100,0), +(@PATH,184,3477.163,104.7499,49.65433,0,0,0,0,100,0), +(@PATH,185,3477.913,108.2499,49.15433,0,0,0,0,100,0), +(@PATH,186,3478.413,111.2499,48.65433,0,0,0,0,100,0), +(@PATH,187,3479.163,114.2499,47.90433,0,0,0,0,100,0), +(@PATH,189,3480.413,119.9999,47.15433,0,0,0,0,100,0), +(@PATH,190,3480.561,121.6387,47.18623,0,0,0,0,100,0), +(@PATH,191,3471.311,129.3887,47.93623,0,0,0,0,100,0), +(@PATH,192,3469.061,131.3887,48.43623,0,0,0,0,100,0), +(@PATH,193,3467.561,132.6387,49.43623,0,0,0,0,100,0), +(@PATH,194,3465.311,134.3887,49.93623,0,0,0,0,100,0), +(@PATH,195,3463.311,136.1387,50.93623,0,0,0,0,100,0), +(@PATH,196,3461.061,138.1387,51.93623,0,0,0,0,100,0), +(@PATH,197,3459.561,139.3887,52.68623,0,0,0,0,100,0), +(@PATH,198,3456.311,141.8887,53.18623,0,0,0,0,100,0), +(@PATH,199,3447.302,149.4205,53.46371,0,0,0,0,100,0), +(@PATH,200,3444.302,149.1705,53.96371,0,0,0,0,100,0), +(@PATH,201,3441.302,148.9205,54.71371,0,0,0,0,100,0), +(@PATH,202,3439.302,148.9205,55.21371,0,0,0,0,100,0), +(@PATH,203,3435.302,148.6705,55.96371,0,0,0,0,100,0), +(@PATH,204,3427.552,147.9205,56.46371,0,0,0,0,100,0), +(@PATH,205,3424.552,147.6705,56.96371,0,0,0,0,100,0), +(@PATH,206,3421.802,147.6705,57.71371,0,0,0,0,100,0), +(@PATH,207,3419.802,147.6705,58.21371,0,0,0,0,100,0), +(@PATH,208,3416.802,147.4205,59.21371,0,0,0,0,100,0), +(@PATH,209,3413.802,147.1705,59.96371,0,0,0,0,100,0), +(@PATH,210,3410.573,146.7634,60.80497,0,0,0,0,100,0), +(@PATH,211,3408.823,146.0134,61.30497,0,0,0,0,100,0), +(@PATH,212,3406.073,144.7634,62.05497,0,0,0,0,100,0), +(@PATH,213,3402.323,143.2634,62.80497,0,0,0,0,100,0), +(@PATH,214,3399.573,142.0134,63.30497,0,0,0,0,100,0), +(@PATH,215,3396.823,141.0134,63.80497,0,0,0,0,100,0), +(@PATH,216,3393.073,139.2634,64.55497,0,0,0,0,100,0), +(@PATH,217,3391.323,138.5134,65.30497,0,0,0,0,100,0), +(@PATH,218,3387.823,137.2634,66.05497,0,0,0,0,100,0), +(@PATH,219,3383.323,135.2634,66.80497,0,0,0,0,100,0), +(@PATH,220,3368.959,128.9598,67.73827,0,0,0,0,100,0), +(@PATH,221,3359.709,124.9598,68.23827,0,0,0,0,100,0), +(@PATH,222,3350.959,120.9598,68.98827,0,0,0,0,100,0), +(@PATH,223,3345.459,118.7098,69.48827,0,0,0,0,100,0), +(@PATH,224,3334.299,113.3885,69.7776,0,0,0,0,100,0), +(@PATH,225,3326.549,113.1385,69.2776,0,0,0,0,100,0), +(@PATH,226,3322.549,112.8885,70.0276,0,0,0,0,100,0), +(@PATH,227,3320.549,112.8885,70.7776,0,0,0,0,100,0), +(@PATH,228,3318.549,112.8885,71.2776,0,0,0,0,100,0), +(@PATH,229,3315.549,112.8885,72.0276,0,0,0,0,100,0), +(@PATH,230,3311.549,112.8885,72.5276,0,0,0,0,100,0), +(@PATH,231,3307.799,112.6385,73.0276,0,0,0,0,100,0), +(@PATH,232,3305.799,112.6385,73.5276,0,0,0,0,100,0), +(@PATH,233,3302.799,112.3885,74.2776,0,0,0,0,100,0), +(@PATH,234,3299.799,112.3885,74.7776,0,0,0,0,100,0), +(@PATH,235,3295.799,112.1385,75.5276,0,0,0,0,100,0), +(@PATH,236,3291.799,112.1385,76.0276,0,0,0,0,100,0), +(@PATH,237,3287.799,111.8885,76.7776,0,0,0,0,100,0), +(@PATH,238,3287.523,111.5087,77.03613,0,0,0,0,100,0), +(@PATH,239,3286.023,111.5087,77.03613,0,0,0,0,100,0), +(@PATH,240,3283.023,111.0087,77.78613,0,0,0,0,100,0), +(@PATH,241,3280.023,110.2587,78.53613,0,0,0,0,100,0), +(@PATH,242,3276.273,109.5087,79.28613,0,0,0,0,100,0), +(@PATH,243,3273.273,108.7587,79.78613,0,0,0,0,100,0), +(@PATH,244,3270.273,108.0087,80.28613,0,0,0,0,100,0), +(@PATH,245,3266.773,107.2587,81.03613,0,0,0,0,100,0), +(@PATH,246,3260.773,106.2587,81.53613,0,0,0,0,100,0), +(@PATH,247,3257.023,105.2587,82.28613,0,0,0,0,100,0), +(@PATH,248,3254.023,104.7587,83.03613,0,0,0,0,100,0), +(@PATH,249,3250.023,103.7587,83.53613,0,0,0,0,100,0), +(@PATH,250,3246.363,102.7875,83.76866,0,0,0,0,100,0), +(@PATH,251,3240.363,96.28754,83.01866,0,0,0,0,100,0), +(@PATH,252,3223.113,77.28754,82.51866,0,0,0,0,100,0), +(@PATH,253,3221.356,75.51231,82.20918,0,0,0,0,100,0), +(@PATH,254,3220.606,72.51231,81.45918,0,0,0,0,100,0), +(@PATH,255,3219.606,69.76231,80.70918,0,0,0,0,100,0), +(@PATH,256,3218.606,66.76231,80.20918,0,0,0,0,100,0), +(@PATH,257,3217.356,63.01231,79.45918,0,0,0,0,100,0), +(@PATH,258,3215.856,57.51231,79.20918,0,0,0,0,100,0), +(@PATH,259,3214.606,53.76231,78.45918,0,0,0,0,100,0), +(@PATH,260,3213.356,50.01231,77.70918,0,0,0,0,100,0), +(@PATH,261,3211.878,45.40641,76.98198,0,0,0,0,100,0), +(@PATH,262,3210.378,38.65641,76.23198,0,0,0,0,100,0), +(@PATH,263,3205.146,15.76002,75.59174,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=111049; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(111049, 111049, 0, 0, 2, 0, 0), +(111049, 111176, 8, 0, 2, 0, 0), +(111049, 111177, 8, 70, 2, 0, 0), +(111049, 111175, 8, 290, 2, 0, 0); |