Thanks to Aokromes for the sniff.
[CODE]-- Pathing for Forgotten Footman Entry: 27229
SET @NPC := 116656;
SET @PATH := @NPC * 10;
UPDATE creature SET id=27229,modelid=0,spawndist=0,MovementType=2,position_x=2717.958,position_y=-852.0486,position_z=-17.81084 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,2698.013,-840.5762,-18.87237,0,0,0,100,0),
(@PATH,2,2717.958,-852.0486,-17.81084,0,0,0,100,0),
(@PATH,3,2747.685,-835.9616,-18.52517,0,0,0,100,0),
(@PATH,4,2736.963,-824.5544,-18.11758,0,0,0,100,0),
(@PATH,5,2747.685,-835.9616,-18.52517,0,0,0,100,0),
(@PATH,6,2717.958,-852.0486,-17.81084,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104255;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2804.868,position_y=-1251.195,position_z=1.766804 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,2791.833,-1244.833,1.159086,0,0,0,100,0),
(@PATH,2,2776.921,-1251.052,1.034086,0,0,0,100,0),
(@PATH,3,2750.998,-1267.749,1.621623,0,0,0,100,0),
(@PATH,4,2747.293,-1287.059,3.621623,0,0,0,100,0),
(@PATH,5,2776.598,-1286.028,2.856715,0,0,0,100,0),
(@PATH,6,2790.336,-1281.491,2.856715,0,0,0,100,0),
(@PATH,7,2806.178,-1269.708,1.748952,0,0,0,100,0),
(@PATH,8,2810.145,-1259.655,1.391804,0,0,0,100,0),
(@PATH,9,2804.868,-1251.195,1.766804,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104300;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2905.596,position_y=-951.8702,position_z=3.332973 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,2899.221,-961.7573,0.6871157,0,0,0,100,0),
(@PATH,2,2905.652,-975.7508,0.5727639,0,0,0,100,0),
(@PATH,3,2911.825,-995.7515,0.5727639,0,0,0,100,0),
(@PATH,4,2919.04,-996.2648,2.072764,0,0,0,100,0),
(@PATH,5,2936.101,-978.8578,5.70028,0,0,0,100,0),
(@PATH,6,2935.195,-972.1996,5.70028,0,0,0,100,0),
(@PATH,7,2937.132,-963.5467,6.505372,0,0,0,100,0),
(@PATH,8,2942.209,-959.0795,7.380372,0,0,0,100,0),
(@PATH,9,2936.745,-951.6036,7.255372,0,0,0,100,0),
(@PATH,10,2925.32,-946.2381,5.957973,0,0,0,100,0),
(@PATH,11,2914.287,-943.9521,4.832973,0,0,0,100,0),
(@PATH,12,2905.596,-951.8702,3.332973,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104302;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2821.752,position_y=-874.8417,position_z=-14.74422 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,2847.016,-880.9863,-1.761606,0,0,0,100,0),
(@PATH,2,2859.862,-879.0374,3.863394,0,0,0,100,0),
(@PATH,3,2872.061,-881.687,7.820289,0,0,0,100,0),
(@PATH,4,2859.862,-879.0374,3.863394,0,0,0,100,0),
(@PATH,5,2847.285,-881.0474,-1.761606,0,0,0,100,0),
(@PATH,6,2821.752,-874.8417,-14.74422,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104312;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2943.969,position_y=-1048.965,position_z=5.101302 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,2941.843,-1039.475,5.726302,0,0,0,100,0),
(@PATH,2,2949.843,-1030.536,7.24691,0,0,0,100,0),
(@PATH,3,2956.156,-1021.9,6.74691,0,0,0,100,0),
(@PATH,4,2953.461,-1003.218,5.12191,0,0,0,100,0),
(@PATH,5,2948.249,-991.8906,6.32528,0,0,0,100,0),
(@PATH,6,2938.315,-992.0608,5.45028,0,0,0,100,0),
(@PATH,7,2923.623,-998.5035,2.697764,0,0,0,100,0),
(@PATH,8,2917.823,-1008.725,1.368839,0,0,0,100,0),
(@PATH,9,2924.897,-1030.634,1.368839,0,0,0,100,0),
(@PATH,10,2927.607,-1053.356,1.400305,0,0,0,100,0),
(@PATH,11,2932.153,-1063.109,2.775305,0,0,0,100,0),
(@PATH,12,2947.777,-1060.567,5.476302,0,0,0,100,0),
(@PATH,13,2943.969,-1048.965,5.101302,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104299;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2878.691,position_y=-918.3934,position_z=3.037135 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,2881.817,-906.0959,6.162135,0,0,0,100,0),
(@PATH,2,2877.402,-902.8173,6.162135,0,0,0,100,0),
(@PATH,3,2869.271,-905.7285,3.787135,0,0,0,100,0),
(@PATH,4,2860.845,-913.6956,0.9171581,0,0,0,100,0),
(@PATH,5,2855.832,-904.1615,1.042158,0,0,0,100,0),
(@PATH,6,2855.849,-900.3548,1.167158,0,0,0,100,0),
(@PATH,7,2866.709,-902.1387,3.787135,0,0,0,100,0),
(@PATH,8,2874.706,-897.7801,6.570289,0,0,0,100,0),
(@PATH,9,2882.54,-901.2561,7.287135,0,0,0,100,0),
(@PATH,10,2886.823,-908.6275,6.412135,0,0,0,100,0),
(@PATH,11,2892.139,-921.2299,4.412135,0,0,0,100,0),
(@PATH,12,2894.74,-929.5193,3.412135,0,0,0,100,0),
(@PATH,13,2889.814,-938.6491,1.062116,0,0,0,100,0),
(@PATH,14,2883.413,-931.7945,0.9121351,0,0,0,100,0),
(@PATH,15,2874.375,-924.762,0.7871351,0,0,0,100,0),
(@PATH,16,2878.691,-918.3934,3.037135,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104303;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2862.517,position_y=-849.3773,position_z=16.0366 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,2850.917,-839.008,16.6616,0,0,0,100,0),
(@PATH,2,2834.721,-821.3724,16.35888,0,0,0,100,0),
(@PATH,3,2829.143,-812.616,16.75702,0,0,0,100,0),
(@PATH,4,2833.205,-809.7637,16.75702,0,0,0,100,0),
(@PATH,5,2849.156,-826.3764,17.10888,0,0,0,100,0),
(@PATH,6,2867.899,-845.172,13.44489,0,0,0,100,0),
(@PATH,7,2874.827,-850.2648,8.319893,0,0,0,100,0),
(@PATH,8,2881.642,-855.6507,7.069893,0,0,0,100,0),
(@PATH,9,2876.659,-862.6102,6.069893,0,0,0,100,0),
(@PATH,10,2870.918,-857.8684,8.819893,0,0,0,100,0),
(@PATH,11,2862.517,-849.3773,16.0366,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104289;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2859.201,position_y=-1110.844,position_z=-7.820363 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.448,-1100.916,-10.32036,0,0,0,100,0),
(@PATH,2,2821.981,-1100.407,-10.52881,0,0,0,100,0),
(@PATH,3,2859.201,-1110.844,-7.820363,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104288;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2961.971,position_y=-1206.705,position_z=5.116786 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,2960.254,-1191.745,5.178555,0,0,0,100,0),
(@PATH,2,2944.208,-1185.239,6.678555,0,0,0,100,0),
(@PATH,3,2936.293,-1195.067,7.053555,0,0,0,100,0),
(@PATH,4,2914.819,-1193.023,6.254488,0,0,0,100,0),
(@PATH,5,2904.133,-1179.803,4.629488,0,0,0,100,0),
(@PATH,6,2895.289,-1198.563,4.908248,0,0,0,100,0),
(@PATH,7,2895.378,-1223.209,3.29712,0,0,0,100,0),
(@PATH,8,2910.218,-1232.834,1.698269,0,0,0,100,0),
(@PATH,9,2923.046,-1223.271,1.823269,0,0,0,100,0),
(@PATH,10,2935.214,-1209.845,3.866786,0,0,0,100,0),
(@PATH,11,2940.961,-1203.404,5.241786,0,0,0,100,0),
(@PATH,12,2961.971,-1206.705,5.116786,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104282;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2873.173,position_y=-1172.022,position_z=1.283248 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,2855.471,-1183.277,0.8133984,0,0,0,100,0),
(@PATH,2,2840.394,-1190.353,0.5633984,0,0,0,100,0),
(@PATH,3,2828.198,-1197.965,0.545311,0,0,0,100,0),
(@PATH,4,2823.18,-1207.752,0.5932741,0,0,0,100,0),
(@PATH,5,2826.128,-1215.542,0.5932741,0,0,0,100,0),
(@PATH,6,2850.605,-1227.658,1.475805,0,0,0,100,0),
(@PATH,7,2885.619,-1237.069,1.082685,0,0,0,100,0),
(@PATH,8,2896.538,-1218.785,3.92212,0,0,0,100,0),
(@PATH,9,2894.448,-1191.228,4.408248,0,0,0,100,0),
(@PATH,10,2881.56,-1176.025,2.783248,0,0,0,100,0),
(@PATH,11,2873.173,-1172.022,1.283248,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104313;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2866.15,position_y=-1042.753,position_z=-4.842813 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,2892.274,-1021.913,-4.426641,0,0,0,100,0),
(@PATH,2,2908.712,-1010.955,-0.7561612,0,0,0,100,0),
(@PATH,3,2916.6,-1006.593,0.9938388,0,0,0,100,0),
(@PATH,4,2931.316,-999.233,3.697764,0,0,0,100,0),
(@PATH,5,2916.6,-1006.593,0.9938388,0,0,0,100,0),
(@PATH,6,2908.712,-1010.955,-0.7561612,0,0,0,100,0),
(@PATH,7,2892.274,-1021.913,-4.426641,0,0,0,100,0),
(@PATH,8,2866.15,-1042.753,-4.842813,0,0,0,100,0),
(@PATH,9,2843.705,-1044.362,-10.84281,0,0,0,100,0),
(@PATH,10,2866.15,-1042.753,-4.842813,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104285;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2826.858,position_y=-1187.9,position_z=-0.829689 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,2807.957,-1196.852,-0.829689,0,0,0,100,0),
(@PATH,2,2790.929,-1196.677,-4.436954,0,0,0,100,0),
(@PATH,3,2859.056,-1191.648,4.188398,0,0,0,100,0),
(@PATH,4,2826.858,-1187.9,-0.829689,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104294;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2837.888,position_y=-1022.804,position_z=-15.48377 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.521,-1027.604,-17.81549,0,0,0,100,0),
(@PATH,2,2822.49,-1036.64,-14.97614,0,0,0,100,0),
(@PATH,3,2842.205,-1029.125,-10.13129,0,0,0,100,0),
(@PATH,4,2849.388,-1021.512,-4.991766,0,0,0,100,0),
(@PATH,5,2842.463,-1029.043,-9.916177,0,0,0,100,0),
(@PATH,6,2834.086,-1032.984,-12.02614,0,0,0,100,0),
(@PATH,7,2822.49,-1036.64,-14.97614,0,0,0,100,0),
(@PATH,8,2850.019,-1019.803,-5.240389,0,0,0,100,0),
(@PATH,9,2837.888,-1022.804,-15.48377,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104291;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2912.86,position_y=-1084.628,position_z=1.902801 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,2919.425,-1075.065,2.277801,0,0,0,100,0),
(@PATH,2,2945.871,-1074.501,6.231542,0,0,0,100,0),
(@PATH,3,2962.812,-1101.852,5.404822,0,0,0,100,0),
(@PATH,4,2971.769,-1111.746,5.353806,0,0,0,100,0),
(@PATH,5,2958.454,-1131.615,6.279822,0,0,0,100,0),
(@PATH,6,2923.928,-1129.304,3.166746,0,0,0,100,0),
(@PATH,7,2905.813,-1109.318,1.916746,0,0,0,100,0),
(@PATH,8,2911.473,-1096.334,2.527801,0,0,0,100,0),
(@PATH,9,2912.86,-1084.628,1.902801,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104292;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2962.194,position_y=-904.453,position_z=8.116007 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,2956.887,-874.8527,7.38236,0,0,0,100,0),
(@PATH,2,2935.122,-866.2645,8.769132,0,0,0,100,0),
(@PATH,3,2914.541,-880.2153,10.14801,0,0,0,100,0),
(@PATH,4,2925.265,-901.0575,10.33249,0,0,0,100,0),
(@PATH,5,2922.499,-912.9219,9.332486,0,0,0,100,0),
(@PATH,6,2924.213,-921.9735,8.207486,0,0,0,100,0),
(@PATH,7,2929.018,-929.4181,7.832486,0,0,0,100,0),
(@PATH,8,2957.894,-937.6589,8.130371,0,0,0,100,0),
(@PATH,9,2962.194,-904.453,8.116007,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104293;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2895.921,position_y=-1134.2,position_z=1.798322 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,2930.059,-1134.693,3.973824,0,0,0,100,0),
(@PATH,2,2951.594,-1140.05,5.859762,0,0,0,100,0),
(@PATH,3,2961.647,-1161.825,5.359762,0,0,0,100,0),
(@PATH,4,2927.842,-1163.731,4.348824,0,0,0,100,0),
(@PATH,5,2914.999,-1156.421,3.098824,0,0,0,100,0),
(@PATH,6,2907.036,-1165.437,3.848824,0,0,0,100,0),
(@PATH,7,2896.543,-1157.753,2.423322,0,0,0,100,0),
(@PATH,8,2892.274,-1152.018,1.798322,0,0,0,100,0),
(@PATH,9,2898.064,-1144.837,2.673322,0,0,0,100,0),
(@PATH,10,2895.921,-1134.2,1.798322,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104298;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2805.589,position_y=-1081.377,position_z=-17.2577 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,2855.113,-1079.183,-10.86029,0,0,0,100,0),
(@PATH,2,2843.607,-1076.875,-12.48529,0,0,0,100,0),
(@PATH,3,2825.508,-1075.496,-12.2577,0,0,0,100,0),
(@PATH,4,2805.589,-1081.377,-17.2577,0,0,0,100,0),
(@PATH,5,2825.508,-1075.496,-12.2577,0,0,0,100,0),
(@PATH,6,2843.607,-1076.875,-12.48529,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104315;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3110.401,position_y=-1253.015,position_z=13.46371 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,3113.668,-1263.064,16.11616,0,0,0,100,0),
(@PATH,2,3110.401,-1253.015,13.46371,0,0,0,100,0),
(@PATH,3,3111.429,-1236.31,11.58871,0,0,0,100,0),
(@PATH,4,3122.498,-1227.572,15.46371,0,0,0,100,0),
(@PATH,5,3133.695,-1219.953,19.40269,0,0,0,100,0),
(@PATH,6,3144.987,-1217.686,21.77769,0,0,0,100,0),
(@PATH,7,3156.936,-1210.385,25.65269,0,0,0,100,0),
(@PATH,8,3144.987,-1217.686,21.77769,0,0,0,100,0),
(@PATH,9,3133.695,-1219.953,19.40269,0,0,0,100,0),
(@PATH,10,3122.498,-1227.572,15.46371,0,0,0,100,0),
(@PATH,11,3111.429,-1236.31,11.58871,0,0,0,100,0),
(@PATH,12,3110.401,-1253.015,13.46371,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104315;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3113.668,position_y=-1263.064,position_z=16.11616 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,3110.401,-1253.015,13.46371,0,0,0,100,0),
(@PATH,2,3111.429,-1236.31,11.58871,0,0,0,100,0),
(@PATH,3,3122.498,-1227.572,15.46371,0,0,0,100,0),
(@PATH,4,3133.695,-1219.953,19.40269,0,0,0,100,0),
(@PATH,5,3144.987,-1217.686,21.77769,0,0,0,100,0),
(@PATH,6,3156.936,-1210.385,25.65269,0,0,0,100,0),
(@PATH,7,3144.987,-1217.686,21.77769,0,0,0,100,0),
(@PATH,8,3133.695,-1219.953,19.40269,0,0,0,100,0),
(@PATH,9,3122.498,-1227.572,15.46371,0,0,0,100,0),
(@PATH,10,3111.429,-1236.31,11.58871,0,0,0,100,0),
(@PATH,11,3110.401,-1253.015,13.46371,0,0,0,100,0),
(@PATH,12,3113.668,-1263.064,16.11616,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104286;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3088.583,position_y=-1156.126,position_z=17.39679 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,3083.364,-1145.739,19.27179,0,0,0,100,0),
(@PATH,2,3082.374,-1140.374,20.52179,0,0,0,100,0),
(@PATH,3,3076.677,-1139.317,20.14679,0,0,0,100,0),
(@PATH,4,3077.877,-1133.612,21.02179,0,0,0,100,0),
(@PATH,5,3088.356,-1118.187,23.05031,0,0,0,100,0),
(@PATH,6,3072.231,-1108.131,21.80031,0,0,0,100,0),
(@PATH,7,3076.281,-1100.623,21.92531,0,0,0,100,0),
(@PATH,8,3086.297,-1103.101,25.05031,0,0,0,100,0),
(@PATH,9,3094.429,-1104.709,24.55031,0,0,0,100,0),
(@PATH,10,3106.847,-1117.23,23.42531,0,0,0,100,0),
(@PATH,11,3115.25,-1125.531,23.92531,0,0,0,100,0),
(@PATH,12,3100.21,-1153.944,20.14997,0,0,0,100,0),
(@PATH,13,3087.017,-1178.354,13.93423,0,0,0,100,0),
(@PATH,14,3082.906,-1175.015,14.30923,0,0,0,100,0),
(@PATH,15,3088.583,-1156.126,17.39679,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104290;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2989.215,position_y=-1127.607,position_z=6.228806 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,3004.259,-1106.531,3.603805,0,0,0,100,0),
(@PATH,2,3033.57,-1102.447,4.356295,0,0,0,100,0),
(@PATH,3,3037.122,-1119.411,5.481295,0,0,0,100,0),
(@PATH,4,3033.48,-1148.527,6.284178,0,0,0,100,0),
(@PATH,5,3009.911,-1156.986,7.97834,0,0,0,100,0),
(@PATH,6,2993.419,-1149.693,7.562151,0,0,0,100,0),
(@PATH,7,2989.215,-1127.607,6.228806,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104287;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3024.798,position_y=-1230.706,position_z=4.43573 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,3025.203,-1243.132,6.22729,0,0,0,100,0),
(@PATH,2,3005.912,-1240.063,2.10229,0,0,0,100,0),
(@PATH,3,2993.987,-1228.242,1.67068,0,0,0,100,0),
(@PATH,4,2985.902,-1209.867,5.42068,0,0,0,100,0),
(@PATH,5,3001.862,-1184.164,6.22842,0,0,0,100,0),
(@PATH,6,3014.546,-1170.865,6.85342,0,0,0,100,0),
(@PATH,7,3032.88,-1172.902,4.72842,0,0,0,100,0),
(@PATH,8,3029.85,-1187.033,4.10342,0,0,0,100,0),
(@PATH,9,3018.071,-1205.466,4.68573,0,0,0,100,0),
(@PATH,10,3024.798,-1230.706,4.43573,0,0,0,100,0);
– Pathing for Forgotten Footman Entry: 27229
SET @NPC := 104295;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3071.868,position_y=-1268.397,position_z=12.20938 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,3069.674,-1259.386,10.85567,0,0,0,100,0),
(@PATH,2,3068.374,-1255.473,10.73067,0,0,0,100,0),
(@PATH,3,3066.066,-1244.444,11.2446,0,0,0,100,0),
(@PATH,4,3058.969,-1244.361,11.6196,0,0,0,100,0),
(@PATH,5,3052.487,-1247.199,11.4946,0,0,0,100,0),
(@PATH,6,3052.536,-1241.779,11.2446,0,0,0,100,0),
(@PATH,7,3061.56,-1234.533,12.3696,0,0,0,100,0),
(@PATH,8,3083.357,-1235.259,11.98067,0,0,0,100,0),
(@PATH,9,3075.396,-1236.323,12.60567,0,0,0,100,0),
(@PATH,10,3072.659,-1248.836,10.35567,0,0,0,100,0),
(@PATH,11,3077.105,-1272.881,13.58438,0,0,0,100,0),
(@PATH,12,3073.281,-1273.411,13.95938,0,0,0,100,0),
(@PATH,13,3071.868,-1268.397,12.20938,0,0,0,100,0);
[/sql]
[/CODE]