DB/Creature: Conquest Hold Legionnaire - Movement

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);