[CODE]-- Remove movement from Bjorn Halgurdsson
UPDATE creature SET spawndist=0,MovementType=0 WHERE guid=112513;
– Pathing for Hungering Dead Entry: 27335
SET @NPC := 97722;
SET @PATH := @NPC * 10;
UPDATE creature_template SET faction_A=1975,faction_H=1975 WHERE entry=27335;
UPDATE creature SET id=27335,modelid=0,spawndist=0,MovementType=2,position_x=3721.162,position_y=-1150.444,position_z=119.7043 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,3722.571,-1154.455,119.7043,0,0,0,100,0),
(@PATH,2,3728.104,-1159.745,119.734,0,0,0,100,0),
(@PATH,3,3733.444,-1158.61,119.8249,0,0,0,100,0),
(@PATH,4,3738.681,-1154.988,119.9222,0,0,0,100,0),
(@PATH,5,3744.156,-1148.198,119.9499,0,0,0,100,0),
(@PATH,6,3747.033,-1139.943,119.8567,0,0,0,100,0),
(@PATH,7,3744.29,-1135.643,119.879,0,0,0,100,0),
(@PATH,8,3738.536,-1129.126,120.0035,0,0,0,100,0),
(@PATH,9,3731.969,-1131.176,119.8338,0,0,0,100,0),
(@PATH,10,3722.916,-1134.044,119.8925,0,0,0,100,0),
(@PATH,11,3720.009,-1142.116,119.7043,0,0,0,100,0),
(@PATH,12,3721.162,-1150.444,119.7043,0,0,0,100,0);
– Pathing for Illusia Lune Entry: 27042
SET @NPC := 66177;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3647.948,position_y=-717.1948,position_z=215.0342 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,3648.265,-715.3195,215.0314,0,0,0,100,0),
(@PATH,2,3644.507,-714.7984,214.2407,0,0,0,100,0),
(@PATH,3,3635.043,-713.5746,214.2407,0,0,0,100,0),
(@PATH,4,3644.625,-714.8554,214.2407,0,0,0,100,0),
(@PATH,5,3648.25,-715.2807,215.0314,0,0,0,100,0),
(@PATH,6,3647.977,-717.1859,215.0342,0,0,0,100,0),
(@PATH,7,3655.216,-718.0604,215.0296,0,0,0,100,0),
(@PATH,8,3647.948,-717.1948,215.0342,0,0,0,100,0);
– Pathing for Mindless Wight Entry: 27287
SET @NPC := 133509;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3765.615,position_y=-1098.793,position_z=121.8268 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,3762.084,-1109.439,121.806,0,0,0,100,0),
(@PATH,2,3752.516,-1126.449,119.7554,0,0,0,100,0),
(@PATH,3,3741.471,-1125.161,119.7554,0,0,0,100,0),
(@PATH,4,3738.396,-1108.291,120.8804,0,0,0,100,0),
(@PATH,5,3740.972,-1086.738,120.0845,0,0,0,100,0),
(@PATH,6,3738.396,-1108.291,120.8804,0,0,0,100,0),
(@PATH,7,3741.471,-1125.161,119.7554,0,0,0,100,0),
(@PATH,8,3752.516,-1126.449,119.7554,0,0,0,100,0),
(@PATH,9,3762.084,-1109.439,121.806,0,0,0,100,0),
(@PATH,10,3765.615,-1098.793,121.8268,0,0,0,100,0);
– Pathing for Mindless Wight Entry: 27287
SET @NPC := 133513;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3786.24,position_y=-1020.522,position_z=118.2757 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,3808.903,-1015.707,117.5769,0,0,0,100,0),
(@PATH,2,3786.24,-1020.522,118.2757,0,0,0,100,0),
(@PATH,3,3769.53,-1029.906,118.9007,0,0,0,100,0),
(@PATH,4,3749.827,-1045.751,119.9136,0,0,0,100,0),
(@PATH,5,3766.045,-1074.355,119.5845,0,0,0,100,0),
(@PATH,6,3749.827,-1045.751,119.9136,0,0,0,100,0),
(@PATH,7,3769.53,-1029.906,118.9007,0,0,0,100,0),
(@PATH,8,3786.24,-1020.522,118.2757,0,0,0,100,0);
– Pathing for Mindless Wight Entry: 27287
SET @NPC := 133514;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3827.871,position_y=-1008.744,position_z=116.4519 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,3843.853,-1000.803,114.3508,0,0,0,100,0),
(@PATH,2,3866.5,-975.2255,111.9066,0,0,0,100,0),
(@PATH,3,3880.219,-956.9473,113.0615,0,0,0,100,0),
(@PATH,4,3891.781,-929.4788,115.7108,0,0,0,100,0),
(@PATH,5,3896.316,-906.512,116.0858,0,0,0,100,0),
(@PATH,6,3891.781,-929.4788,115.7108,0,0,0,100,0),
(@PATH,7,3880.219,-956.9473,113.0615,0,0,0,100,0),
(@PATH,8,3866.5,-975.2255,111.9066,0,0,0,100,0),
(@PATH,9,3843.955,-1000.658,114.3508,0,0,0,100,0),
(@PATH,10,3827.871,-1008.744,116.4519,0,0,0,100,0);
– Pathing for 7th Legion Cavalier Entry: 27161
SET @NPC := 133199;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3612.651,position_y=-726.0625,position_z=213.935 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,1,14346, ‘18950’);
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,3587.445,-722.4232,213.935,0,0,0,100,0),
(@PATH,2,3555.9,-731.1179,214.44,0,0,0,100,0),
(@PATH,3,3539.474,-754.7745,215.9302,0,0,0,100,0),
(@PATH,4,3523.979,-780.5864,222.9033,0,0,0,100,0),
(@PATH,5,3539.474,-754.7745,215.9302,0,0,0,100,0),
(@PATH,6,3555.9,-731.1179,214.44,0,0,0,100,0),
(@PATH,7,3587.445,-722.4232,213.935,0,0,0,100,0),
(@PATH,8,3612.651,-726.0625,213.935,0,0,0,100,0);
– Pathing for 7th Legion Infantryman Entry: 27160
SET @NPC := 133172;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3641.115,position_y=-696.2817,position_z=213.935 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,3617.231,-699.88,213.935,0,0,0,100,0),
(@PATH,2,3600.052,-707.2169,213.935,0,0,0,100,0),
(@PATH,3,3587.962,-712.2491,213.935,0,0,0,100,0),
(@PATH,4,3557.36,-723.9453,214.94,0,0,0,100,0),
(@PATH,5,3540.534,-745.3442,214.6802,0,0,0,100,0),
(@PATH,6,3531.584,-759.6609,218.7618,0,0,0,100,0),
(@PATH,7,3540.534,-745.3442,214.6802,0,0,0,100,0),
(@PATH,8,3557.36,-723.9453,214.94,0,0,0,100,0),
(@PATH,9,3587.962,-712.2491,213.935,0,0,0,100,0),
(@PATH,10,3600.052,-707.2169,213.935,0,0,0,100,0),
(@PATH,11,3617.231,-699.88,213.935,0,0,0,100,0),
(@PATH,12,3641.115,-696.2817,213.935,0,0,0,100,0);
– Pathing for Arctic Ram Entry: 26426
SET @NPC := 133249;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=3557.356,position_y=-885.1018,position_z=213.8623 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,3555.743,-872.7176,226.2373,0,0,0,100,0),
(@PATH,2,3547.863,-855.0227,241.3424,0,0,0,100,0),
(@PATH,3,3555.743,-872.7176,226.2373,0,0,0,100,0),
(@PATH,4,3557.356,-885.1018,213.8623,0,0,0,100,0);
– Pathing for Foreman Mortuus Entry: 25280
SET @NPC := 125576;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2738.548,position_y=6141.264,position_z=77.54229 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,2740.601,6148.542,77.54229,0,0,0,100,0),
(@PATH,2,2738.548,6141.264,77.54229,0,0,0,100,0),
(@PATH,3,2738.882,6136.919,77.54229,0,0,0,100,0),
(@PATH,4,2738.548,6141.264,77.54229,0,0,0,100,0);
– Pathing for Warsong Aberration Entry: 25611
SET @NPC := 97487;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2867.919,position_y=6443.667,position_z=82.88259 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,2863.174,6439.854,83.75759,0,0,0,100,0),
(@PATH,2,2848.968,6437.575,83.50759,0,0,0,100,0),
(@PATH,3,2834.608,6443.772,81.13259,0,0,0,100,0),
(@PATH,4,2828.932,6454.542,79.6442,0,0,0,100,0),
(@PATH,5,2828.173,6467.712,78.6414,0,0,0,100,0),
(@PATH,6,2830.424,6479.771,78.0164,0,0,0,100,0),
(@PATH,7,2834.636,6490.322,78.14274,0,0,0,100,0),
(@PATH,8,2842.753,6498.431,78.26774,0,0,0,100,0),
(@PATH,9,2854.071,6499.945,77.01774,0,0,0,100,0),
(@PATH,10,2863.978,6493.317,79.14274,0,0,0,100,0),
(@PATH,11,2867.187,6478.214,79.15935,0,0,0,100,0),
(@PATH,12,2867.226,6461.002,79.25759,0,0,0,100,0),
(@PATH,13,2867.919,6443.667,82.88259,0,0,0,100,0);
– Pathing for Foreman Miles McMoody Entry: 23738
SET @NPC := 113477;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=638.4495,position_y=-4973.4,position_z=5.458665 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,638.6205,-4980.014,5.833665,0,0,0,100,0),
(@PATH,2,639.2449,-4985.371,5.708665,0,0,0,100,0),
(@PATH,3,638.6205,-4980.014,5.833665,0,0,0,100,0),
(@PATH,4,638.4495,-4973.4,5.458665,0,0,0,100,0),
(@PATH,5,643.2342,-4964.211,5.381555,0,0,0,100,0),
(@PATH,6,649.8732,-4960.353,5.881555,0,0,0,100,0),
(@PATH,7,643.2342,-4964.211,5.381555,0,0,0,100,0),
(@PATH,8,638.4495,-4973.4,5.458665,0,0,0,100,0);
– Pathing for Dragonflayer Rune-Seer Entry: 23656
SET @NPC := 105279;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=815.9536,position_y=-5480.104,position_z=212.1486 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,807.327,-5474.987,212.2354,0,0,0,100,0),
(@PATH,2,815.9536,-5480.104,212.1486,0,0,0,100,0),
(@PATH,3,820.9525,-5473.124,212.1178,0,0,0,100,0),
(@PATH,4,815.9536,-5480.104,212.1486,0,0,0,100,0);
– Pathing for Dragonflayer Rune-Seer Entry: 23656
SET @NPC := 105278;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1017.9,position_y=-5466.781,position_z=187.2601 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,1028.798,-5462.303,187.0009,0,0,0,100,0),
(@PATH,2,1025.045,-5453.278,187.0592,0,0,0,100,0),
(@PATH,3,1013.774,-5457.924,187.2601,0,0,0,100,0),
(@PATH,4,1017.9,-5466.781,187.2601,0,0,0,100,0);
– Pathing for Winterskorn Bonegrinder Entry: 23655
SET @NPC := 105184;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1535.755,position_y=-5407.994,position_z=190.2667 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,1564.637,-5388.042,189.2125,0,0,0,100,0),
(@PATH,2,1535.755,-5407.994,190.2667,0,0,0,100,0),
(@PATH,3,1502.654,-5425.741,192.4055,0,0,0,100,0),
(@PATH,4,1477.713,-5432.612,190.0745,0,0,0,100,0),
(@PATH,5,1451.592,-5422.258,188.7154,0,0,0,100,0),
(@PATH,6,1451.592,-5422.258,188.7154,0,0,0,100,0),
(@PATH,7,1477.624,-5432.594,190.0745,0,0,0,100,0),
(@PATH,8,1502.654,-5425.741,192.4055,0,0,0,100,0),
(@PATH,9,1535.755,-5407.994,190.2667,0,0,0,100,0);
– Pathing for Winterskorn Bonegrinder Entry: 23655
SET @NPC := 105187;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1530.729,position_y=-5260.938,position_z=202.2724 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,1513.021,-5237.5,207.5224,0,0,0,100,0),
(@PATH,2,1514.139,-5242.362,207.5224,0,0,0,100,0),
(@PATH,3,1528.464,-5262.211,202.7724,0,0,0,100,0),
(@PATH,4,1549.229,-5268.947,199.7077,0,0,0,100,0),
(@PATH,5,1565.182,-5272.908,202.6034,0,0,0,100,0),
(@PATH,6,1564.366,-5290.121,202.8534,0,0,0,100,0),
(@PATH,7,1554.61,-5266.971,200.4784,0,0,0,100,0),
(@PATH,8,1530.729,-5260.938,202.2724,0,0,0,100,0);
– Pathing for Winterskorn Bonegrinder Entry: 23655
SET @NPC := 105186;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1433.288,position_y=-5288.5,position_z=195.2126 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,1416.921,-5279.619,195.8376,0,0,0,100,0),
(@PATH,2,1415.622,-5254.748,190.7362,0,0,0,100,0),
(@PATH,3,1410.65,-5237.281,191.9862,0,0,0,100,0),
(@PATH,4,1422.645,-5223.072,195.145,0,0,0,100,0),
(@PATH,5,1431.248,-5201.435,190.395,0,0,0,100,0),
(@PATH,6,1422.645,-5223.072,195.145,0,0,0,100,0),
(@PATH,7,1410.65,-5237.281,191.9862,0,0,0,100,0),
(@PATH,8,1415.622,-5254.748,190.7362,0,0,0,100,0),
(@PATH,9,1416.921,-5279.619,195.8376,0,0,0,100,0),
(@PATH,10,1432.959,-5288.929,195.0876,0,0,0,100,0),
(@PATH,11,1464.944,-5300.757,195.4252,0,0,0,100,0),
(@PATH,12,1433.288,-5288.5,195.2126,0,0,0,100,0),
(@PATH,13,1406.18,-5300.791,192.9474,0,0,0,100,0),
(@PATH,14,1399.665,-5334.053,195.1207,0,0,0,100,0),
(@PATH,15,1405.759,-5369.869,193.5165,0,0,0,100,0),
(@PATH,16,1399.665,-5334.053,195.1207,0,0,0,100,0),
(@PATH,17,1406.18,-5300.791,192.9474,0,0,0,100,0),
(@PATH,18,1433.288,-5288.5,195.2126,0,0,0,100,0),
(@PATH,19,1464.944,-5300.757,195.4252,0,0,0,100,0),
(@PATH,20,1433.288,-5288.5,195.2126,0,0,0,100,0);
– Pathing for Dragonflayer Warrior Entry: 23654
SET @NPC := 105141;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1062.211,position_y=-5497.463,position_z=198.7661 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,1064.687,-5467.441,197.8911,0,0,0,100,0),
(@PATH,2,1062.211,-5497.463,198.7661,0,0,0,100,0),
(@PATH,3,1063.853,-5533.536,205.1816,0,0,0,100,0),
(@PATH,4,1058.663,-5566.771,204.7646,0,0,0,100,0),
(@PATH,5,1038.08,-5606.434,219.5592,0,0,0,100,0),
(@PATH,6,1058.663,-5566.771,204.7646,0,0,0,100,0),
(@PATH,7,1063.853,-5533.536,205.1816,0,0,0,100,0),
(@PATH,8,1062.211,-5497.463,198.7661,0,0,0,100,0);
– Pathing for Dragonflayer Warrior Entry: 23654
SET @NPC := 105149;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=846.3604,position_y=-5491.41,position_z=213.345 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,838.926,-5532.913,208.3766,0,0,0,100,0),
(@PATH,2,845.0897,-5552.385,201.9454,0,0,0,100,0),
(@PATH,3,866.5723,-5552.206,196.6954,0,0,0,100,0),
(@PATH,4,895.5579,-5541.471,193.3276,0,0,0,100,0),
(@PATH,5,925.5731,-5545.784,187.5047,0,0,0,100,0),
(@PATH,6,948.0293,-5558.479,184.8204,0,0,0,100,0),
(@PATH,7,954.0419,-5554.6,184.8204,0,0,0,100,0),
(@PATH,8,957.7758,-5533.202,185.6618,0,0,0,100,0),
(@PATH,9,954.9789,-5518.392,185.7868,0,0,0,100,0),
(@PATH,10,944.8699,-5507.618,185.8557,0,0,0,100,0),
(@PATH,11,944.6381,-5494.633,186.1347,0,0,0,100,0),
(@PATH,12,950.1157,-5482.309,185.6347,0,0,0,100,0),
(@PATH,13,933.2178,-5467.473,189.7347,0,0,0,100,0),
(@PATH,14,914.2697,-5456.049,197.4529,0,0,0,100,0),
(@PATH,15,899.4795,-5450.521,202.8457,0,0,0,100,0),
(@PATH,16,878.1829,-5448.128,206.4707,0,0,0,100,0),
(@PATH,17,866.7573,-5455.153,209.5957,0,0,0,100,0),
(@PATH,18,857.5803,-5467.02,211.97,0,0,0,100,0),
(@PATH,19,846.3604,-5491.41,213.345,0,0,0,100,0);
– Pathing for Dragonflayer Warrior Entry: 23654
SET @NPC := 105143;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=885.737,position_y=-5543.066,position_z=192.4526 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,844.7711,-5555.04,202.0704,0,0,0,100,0),
(@PATH,2,839.8002,-5532.987,208.3766,0,0,0,100,0),
(@PATH,3,838.3271,-5510.918,212.7516,0,0,0,100,0),
(@PATH,4,801.8599,-5490.351,216.0982,0,0,0,100,0),
(@PATH,5,801.8599,-5490.351,216.0982,0,0,0,100,0),
(@PATH,6,808.6978,-5479.681,212.3443,0,0,0,100,0),
(@PATH,7,820.7059,-5477.396,212.4484,0,0,0,100,0),
(@PATH,8,845.6509,-5491.736,213.345,0,0,0,100,0),
(@PATH,9,860.5975,-5457.135,210.6873,0,0,0,100,0),
(@PATH,10,886.1946,-5446.879,205.8457,0,0,0,100,0),
(@PATH,11,910.978,-5453.937,198.7072,0,0,0,100,0),
(@PATH,12,933.2483,-5466.113,189.993,0,0,0,100,0),
(@PATH,13,949.5988,-5487.087,185.7597,0,0,0,100,0),
(@PATH,14,943.2539,-5502.491,185.9165,0,0,0,100,0),
(@PATH,15,955.7552,-5521.782,185.6618,0,0,0,100,0),
(@PATH,16,959.2084,-5538.987,185.4454,0,0,0,100,0),
(@PATH,17,968.0063,-5546.821,185.5182,0,0,0,100,0),
(@PATH,18,975.9687,-5552.027,188.5839,0,0,0,100,0),
(@PATH,19,971.4639,-5549.163,187.1199,0,0,0,100,0),
(@PATH,20,958.3904,-5540.358,185.3204,0,0,0,100,0),
(@PATH,21,911.1376,-5540.936,191.2547,0,0,0,100,0),
(@PATH,22,885.737,-5543.066,192.4526,0,0,0,100,0);[/sql]
[/CODE]