[Complete] Pathing for Emerald Skytalon

[CODE]-- Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105773;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2829.573,position_y=77.83496,position_z=23.05415 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2834.644,66.5554,23.05415,0,0,0,100,0),
(@PATH,2,2832.327,47.98145,23.05415,0,0,0,100,0),
(@PATH,3,2824.19,33.55273,23.05415,0,0,0,100,0),
(@PATH,4,2813.263,27.89535,23.05415,0,0,0,100,0),
(@PATH,5,2799.154,28.69884,23.05415,0,0,0,100,0),
(@PATH,6,2792.593,37.23269,23.05415,0,0,0,100,0),
(@PATH,7,2787.989,49.96674,23.05415,0,0,0,100,0),
(@PATH,8,2790.986,62.9579,23.05415,0,0,0,100,0),
(@PATH,9,2799.894,77.16607,23.05415,0,0,0,100,0),
(@PATH,10,2811.617,81.51264,23.05415,0,0,0,100,0),
(@PATH,11,2829.573,77.83496,23.05415,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105776;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2768.484,position_y=170.2238,position_z=22.38341 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2795.626,178.1085,19.93896,0,0,0,100,0),
(@PATH,2,2807.406,164.8766,17.6334,0,0,0,100,0),
(@PATH,3,2802.16,140.2939,17.6334,0,0,0,100,0),
(@PATH,4,2811.732,110.9432,17.6334,0,0,0,100,0),
(@PATH,5,2820.829,97.51039,17.6334,0,0,0,100,0),
(@PATH,6,2826.558,81.62894,17.6334,0,0,0,100,0),
(@PATH,7,2809.651,77.49517,17.6334,0,0,0,100,0),
(@PATH,8,2788.568,80.96075,17.6334,0,0,0,100,0),
(@PATH,9,2774.997,95.94735,20.41118,0,0,0,100,0),
(@PATH,10,2774.55,112.1218,22.38341,0,0,0,100,0),
(@PATH,11,2760.725,140.132,22.38341,0,0,0,100,0),
(@PATH,12,2758.094,158.0518,22.38341,0,0,0,100,0),
(@PATH,13,2768.484,170.2238,22.38341,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105790;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2690.665,position_y=105.8982,position_z=21.48963 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2705.308,102.4151,21.48963,0,0,0,100,0),
(@PATH,2,2703.798,84.28983,21.67711,0,0,0,100,0),
(@PATH,3,2705.529,52.25309,4.98267,0,0,0,100,0),
(@PATH,4,2705.258,36.26714,0.510448,0,0,0,100,0),
(@PATH,5,2705.416,24.20399,4.038228,0,0,0,100,0),
(@PATH,6,2691.849,-11.67057,19.26741,0,0,0,100,0),
(@PATH,7,2695.837,-31.84223,22.57297,0,0,0,100,0),
(@PATH,8,2721.802,-37.03499,22.57297,0,0,0,100,0),
(@PATH,9,2733.044,-22.9873,20.85075,0,0,0,100,0),
(@PATH,10,2740.016,-0.903429,20.85075,0,0,0,100,0),
(@PATH,11,2720.839,32.38059,20.85075,0,0,0,100,0),
(@PATH,12,2687.212,64.41743,21.48963,0,0,0,100,0),
(@PATH,13,2690.665,105.8982,21.48963,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105751;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2818.96,position_y=19.08247,position_z=18.30093 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2825.987,33.99419,18.30093,0,0,0,100,0),
(@PATH,2,2828.41,56.17736,18.30093,0,0,0,100,0),
(@PATH,3,2822.678,71.10498,18.30093,0,0,0,100,0),
(@PATH,4,2807.275,74.22374,18.30093,0,0,0,100,0),
(@PATH,5,2796.926,65.10563,18.30093,0,0,0,100,0),
(@PATH,6,2791.43,53.62164,18.30093,0,0,0,100,0),
(@PATH,7,2789.82,40.9783,18.30093,0,0,0,100,0),
(@PATH,8,2797.13,30.63395,18.30093,0,0,0,100,0),
(@PATH,9,2806.262,18.99745,18.30093,0,0,0,100,0),
(@PATH,10,2818.96,19.08247,18.30093,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105771;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2822.304,position_y=25.58095,position_z=28.66101 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2838.793,39.95627,28.66101,0,0,0,100,0),
(@PATH,2,2836.108,57.5306,28.66101,0,0,0,100,0),
(@PATH,3,2825.485,74.04839,28.66101,0,0,0,100,0),
(@PATH,4,2805.867,74.06527,28.66101,0,0,0,100,0),
(@PATH,5,2792.58,59.60639,28.66101,0,0,0,100,0),
(@PATH,6,2792.146,41.0931,28.66101,0,0,0,100,0),
(@PATH,7,2806.482,27.81955,28.66101,0,0,0,100,0),
(@PATH,8,2822.304,25.58095,28.66101,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105793;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2885.995,position_y=86.84375,position_z=25.08892 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2877.463,71.04628,26.72781,0,0,0,100,0),
(@PATH,2,2862.192,67.89458,24.06114,0,0,0,100,0),
(@PATH,3,2846.071,81.27257,23.17225,0,0,0,100,0),
(@PATH,4,2835.402,100.0479,22.14447,0,0,0,100,0),
(@PATH,5,2844.852,113.7791,23.17225,0,0,0,100,0),
(@PATH,6,2858.143,119.3263,21.75558,0,0,0,100,0),
(@PATH,7,2876.194,105.5451,24.2278,0,0,0,100,0),
(@PATH,8,2885.995,86.84375,25.08892,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105792;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2870.061,position_y=48.39068,position_z=24.00088 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2887.51,42.04189,24.00088,0,0,0,100,0),
(@PATH,2,2890.971,26.92735,24.00088,0,0,0,100,0),
(@PATH,3,2888.869,7.343913,24.00088,0,0,0,100,0),
(@PATH,4,2875.525,-13.28494,24.00088,0,0,0,100,0),
(@PATH,5,2856.301,-22.60704,24.00088,0,0,0,100,0),
(@PATH,6,2843.07,-12.60786,24.00088,0,0,0,100,0),
(@PATH,7,2838.096,10.55545,24.00088,0,0,0,100,0),
(@PATH,8,2852.048,33.66027,24.00088,0,0,0,100,0),
(@PATH,9,2870.061,48.39068,24.00088,0,0,0,100,0);

– Pathing for Emerald Skytalon Entry: 27244
SET @NPC := 105743;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2791.267,position_y=-5.982639,position_z=23.38554 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2800.101,-11.76535,19.27443,0,0,0,100,0),
(@PATH,2,2804.809,-27.09413,19.27443,0,0,0,100,0),
(@PATH,3,2795.457,-39.61523,19.27443,0,0,0,100,0),
(@PATH,4,2772.509,-53.71186,24.91332,0,0,0,100,0),
(@PATH,5,2752.826,-48.53326,19.27443,0,0,0,100,0),
(@PATH,6,2744.481,-35.89621,23.6911,0,0,0,100,0),
(@PATH,7,2750.413,-22.42415,19.27443,0,0,0,100,0),
(@PATH,8,2762.693,-11.72667,24.38554,0,0,0,100,0),
(@PATH,9,2778.425,-5.4662,19.27443,0,0,0,100,0),
(@PATH,10,2791.267,-5.982639,23.38554,0,0,0,100,0);

– Fix Inhabittype for Emerald Skytalon
UPDATE creature_template SET InhabitType=5 WHERE entry=27244;
– Some Emerald Skytalons should not be moving (Should be landed but…well you know…)
UPDATE creature SET spawndist=0,MovementType=0 WHERE id=27244 AND MovementType=1;[/sql]
[/CODE]

Sorry malcrom, you are patching faster than my +rep counter daily count allows.

lool