diff options
| -rw-r--r-- | sql/updates/world/2015_05_11_08_world.sql | 99 |
1 files changed, 99 insertions, 0 deletions
diff --git a/sql/updates/world/2015_05_11_08_world.sql b/sql/updates/world/2015_05_11_08_world.sql new file mode 100644 index 00000000000..d6bcc834780 --- /dev/null +++ b/sql/updates/world/2015_05_11_08_world.sql @@ -0,0 +1,99 @@ +-- Conquest Hold Legionnaire +SET @NPC := 116284; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=3222.422,`position_y`=-2261.431,`position_z`=112.903 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,3222.422,-2261.431,112.903,0,0,0,0,100,0), +(@PATH,2,3223.03,-2264.1,112.1124,0,0,0,0,100,0), +(@PATH,3,3223.781,-2267.022,111.1831,0,0,0,0,100,0), +(@PATH,4,3224.569,-2267.831,111.0135,0,0,0,0,100,0), +(@PATH,5,3226.668,-2270.648,110.3546,0,0,0,0,100,0), +(@PATH,6,3229.054,-2274.084,109.3319,0,0,0,0,100,0), +(@PATH,7,3230.216,-2275.468,109.1555,0,0,0,0,100,0), +(@PATH,8,3232.466,-2278.367,108.6153,0,0,0,0,100,0), +(@PATH,9,3234.924,-2280.143,108.2696,0,0,0,0,100,0), +(@PATH,10,3237.392,-2281.926,108.2696,0,0,0,0,100,0), +(@PATH,11,3239.848,-2283.7,108.2879,0,0,0,0,100,0), +(@PATH,12,3240.568,-2283.284,108.2696,0,0,0,0,100,0), +(@PATH,13,3243.724,-2282.795,108.3946,0,0,0,0,100,0), +(@PATH,14,3246.881,-2282.306,108.3946,0,0,0,0,100,0), +(@PATH,15,3250.019,-2281.82,108.5137,0,0,0,0,100,0), +(@PATH,16,3253.206,-2281.326,108.5008,0,0,0,0,100,0), +(@PATH,17,3255.859,-2280.714,108.5196,0,0,0,0,100,0), +(@PATH,18,3258.817,-2279.989,108.4834,0,0,0,0,100,0), +(@PATH,19,3261.763,-2279.267,108.3458,0,0,0,0,100,0), +(@PATH,20,3264.564,-2278.554,108.5305,0,0,0,0,100,0), +(@PATH,21,3267.448,-2277.735,108.8179,0,0,0,0,100,0), +(@PATH,22,3269.372,-2277.215,109.3157,0,0,0,0,100,0), +(@PATH,23,3273.088,-2276.127,109.8022,0,0,0,0,100,0), +(@PATH,24,3277.416,-2276.224,109.3619,0,0,0,0,100,0), +(@PATH,25,3280.093,-2277.505,108.8861,0,0,0,0,100,0), +(@PATH,26,3282.834,-2278.816,108.7433,0,0,0,0,100,0), +(@PATH,27,3285.509,-2280.093,109.0773,0,0,0,0,100,0), +(@PATH,28,3287.798,-2280.42,109.6238,0,0,0,0,100,0), +(@PATH,29,3289.805,-2280.55,110.2963,0,0,0,0,100,0), +(@PATH,30,3291.436,-2282.21,110.212,0,0,0,0,100,0), +(@PATH,31,3293.136,-2279.585,110.3022,0,0,0,0,100,0), +(@PATH,32,3294.828,-2276.973,110.6279,0,0,0,0,100,0), +(@PATH,33,3296.068,-2275.338,110.8585,0,0,0,0,100,0), +(@PATH,34,3296.431,-2272.337,111.0591,0,0,0,0,100,0), +(@PATH,35,3296.789,-2269.371,111.363,0,0,0,0,100,0), +(@PATH,36,3297.156,-2266.315,111.6388,0,0,0,0,100,0), +(@PATH,37,3297.624,-2263.012,111.854,0,0,0,0,100,0), +(@PATH,38,3298.611,-2260.142,111.9759,0,0,0,0,100,0), +(@PATH,39,3299.594,-2257.286,112.3186,0,0,0,0,100,0), +(@PATH,40,3300.581,-2254.429,112.6177,0,0,0,0,100,0), +(@PATH,41,3300.73,-2253.996,112.6697,0,0,0,0,100,0), +(@PATH,42,3300.506,-2254.651,112.5911,0,0,0,0,100,0), +(@PATH,43,3303.751,-2259.06,112.062,0,0,0,0,100,0), +(@PATH,44,3303.142,-2262.008,111.7082,0,0,0,0,100,0), +(@PATH,45,3302.529,-2264.978,111.4768,0,0,0,0,100,0), +(@PATH,46,3301.917,-2267.939,111.3507,0,0,0,0,100,0), +(@PATH,47,3301.307,-2270.89,110.9967,0,0,0,0,100,0), +(@PATH,48,3300.701,-2273.825,110.6447,0,0,0,0,100,0), +(@PATH,49,3300.092,-2276.787,110.3161,0,0,0,0,100,0), +(@PATH,50,3297.877,-2280.104,110.3195,0,0,0,0,100,0), +(@PATH,51,3295.698,-2282.238,110.1211,0,0,0,0,100,0), +(@PATH,52,3291.665,-2283.44,110.1146,0,0,0,0,100,0), +(@PATH,53,3288.628,-2283.25,109.6978,0,0,0,0,100,0), +(@PATH,54,3286.963,-2283.097,109.5514,0,0,0,0,100,0), +(@PATH,55,3284.762,-2282.979,108.7865,0,0,0,0,100,0), +(@PATH,56,3281.819,-2282.813,107.6871,0,0,0,0,100,0), +(@PATH,57,3279.023,-2282.41,106.843,0,0,0,0,100,0), +(@PATH,58,3273.752,-2281.361,107.249,0,0,0,0,100,0), +(@PATH,59,3272.823,-2281.124,107.9806,0,0,0,0,100,0), +(@PATH,60,3269.315,-2280.155,108.8164,0,0,0,0,100,0), +(@PATH,61,3266.359,-2279.441,108.5643,0,0,0,0,100,0), +(@PATH,62,3261.786,-2278.462,108.5415,0,0,0,0,100,0), +(@PATH,63,3260.874,-2277.872,108.6126,0,0,0,0,100,0), +(@PATH,64,3258.454,-2279.771,108.5095,0,0,0,0,100,0), +(@PATH,65,3256.032,-2281.672,108.5072,0,0,0,0,100,0), +(@PATH,66,3253.73,-2283.478,108.3147,0,0,0,0,100,0), +(@PATH,67,3249.822,-2284.479,108.1946,0,0,0,0,100,0), +(@PATH,68,3246.836,-2284.902,108.1438,0,0,0,0,100,0), +(@PATH,69,3243.795,-2285.332,108.0923,0,0,0,0,100,0), +(@PATH,70,3240.329,-2284.271,108.2195,0,0,0,0,100,0), +(@PATH,71,3237.559,-2282.833,108.1446,0,0,0,0,100,0), +(@PATH,72,3234.771,-2281.385,108.2696,0,0,0,0,100,0), +(@PATH,73,3231.993,-2279.943,108.3994,0,0,0,0,100,0), +(@PATH,74,3229.22,-2278.504,108.7801,0,0,0,0,100,0), +(@PATH,75,3226.602,-2277.155,108.8858,0,0,0,0,100,0), +(@PATH,76,3224.147,-2273.925,109.3004,0,0,0,0,100,0), +(@PATH,77,3223.178,-2271.634,109.9661,0,0,0,0,100,0), +(@PATH,78,3222.1,-2269.727,110.5905,0,0,0,0,100,0), +(@PATH,79,3220.919,-2266.938,111.1347,0,0,0,0,100,0), +(@PATH,80,3219.873,-2264.861,111.7715,0,0,0,0,100,0), +(@PATH,81,3219.09,-2262.018,113.0721,0,0,0,0,100,0), +(@PATH,82,3218.371,-2259.129,113.9729,0,0,0,0,100,0), +(@PATH,83,3217.72,-2256.449,114.2141,0,0,0,0,100,0), +(@PATH,84,3217.931,-2257.32,114.1792,0,0,0,0,100,0), +(@PATH,85,3221.369,-2258.965,113.6241,0,0,0,0,100,0), +(@PATH,86,3222.448,-2261.465,112.8751,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=116284; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(116284, 116284, 0, 0, 2, 0, 0), +(116284, 116285, 3, 90, 0, 0, 0); |