[Complete] Pathing Niffelem Forefathers

Proper movement for Niffelem Forefathers, Frostborn Ghost, & Frostborn Warriors from Sniff (ty Aokromes)

[CODE]-- Pathing for Niffelem Forefather Entry: 29974
SET @NPC := 203040;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=7709.27,position_y=-3164.7,position_z=868.8315 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,7693.262,-3168.185,868.2753,0,0,0,100,0),
(@PATH,2,7709.27,-3164.7,868.8315,0,0,0,100,0),
(@PATH,3,7727.441,-3152.349,867.8315,0,0,0,100,0),
(@PATH,4,7757.799,-3144.588,868.1001,0,0,0,100,0),
(@PATH,5,7783.903,-3146.267,868.2236,0,0,0,100,0),
(@PATH,6,7757.799,-3144.588,868.1001,0,0,0,100,0),
(@PATH,7,7727.441,-3152.349,867.8315,0,0,0,100,0),
(@PATH,8,7709.27,-3164.7,868.8315,0,0,0,100,0);

– Pathing for Niffelem Forefather Entry: 29974
SET @NPC := 203041;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=7742.933,position_y=-3233.286,position_z=862.2076 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,7727.288,-3235.9,861.9932,0,0,0,100,0),
(@PATH,2,7713.503,-3235.01,863.4932,0,0,0,100,0),
(@PATH,3,7727.288,-3235.9,861.9932,0,0,0,100,0),
(@PATH,4,7742.933,-3233.286,862.2076,0,0,0,100,0),
(@PATH,5,7752.816,-3221.191,862.9576,0,0,0,100,0),
(@PATH,6,7762.07,-3204.258,863.3326,0,0,0,100,0),
(@PATH,7,7764.636,-3193.307,863.6109,0,0,0,100,0),
(@PATH,8,7762.07,-3204.258,863.3326,0,0,0,100,0),
(@PATH,9,7752.816,-3221.191,862.9576,0,0,0,100,0),
(@PATH,10,7742.933,-3233.286,862.2076,0,0,0,100,0);

– Pathing for Niffelem Forefather Entry: 29974
SET @NPC := 203042;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=7785.011,position_y=-3298.777,position_z=864.6912 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,7802.621,-3290.984,860.9608,0,0,0,100,0),
(@PATH,2,7823.592,-3295.113,860.8358,0,0,0,100,0),
(@PATH,3,7838.511,-3308.602,860.8699,0,0,0,100,0),
(@PATH,4,7850.641,-3319.998,859.9949,0,0,0,100,0),
(@PATH,5,7838.511,-3308.602,860.8699,0,0,0,100,0),
(@PATH,6,7823.592,-3295.113,860.8358,0,0,0,100,0),
(@PATH,7,7802.621,-3290.984,860.9608,0,0,0,100,0),
(@PATH,8,7785.011,-3298.777,864.6912,0,0,0,100,0);

– Pathing for Niffelem Forefather Entry: 29974
SET @NPC := 203043;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=7812.378,position_y=-3226.627,position_z=858.0397 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,7824.979,-3215.046,858.6647,0,0,0,100,0),
(@PATH,2,7831.885,-3203.466,858.1647,0,0,0,100,0),
(@PATH,3,7824.135,-3194.195,859.362,0,0,0,100,0),
(@PATH,4,7814.883,-3180.783,861.112,0,0,0,100,0),
(@PATH,5,7824.135,-3194.195,859.362,0,0,0,100,0),
(@PATH,6,7831.885,-3203.466,858.1647,0,0,0,100,0),
(@PATH,7,7824.979,-3215.046,858.6647,0,0,0,100,0),
(@PATH,8,7812.378,-3226.627,858.0397,0,0,0,100,0),
(@PATH,9,7800.624,-3238.984,859.4147,0,0,0,100,0),
(@PATH,10,7804.482,-3266.558,859.9147,0,0,0,100,0),
(@PATH,11,7800.624,-3238.984,859.4147,0,0,0,100,0),
(@PATH,12,7812.378,-3226.627,858.0397,0,0,0,100,0);

– Pathing for Niffelem Forefather Entry: 29974
SET @NPC := 203045;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=7751.154,position_y=-3282.728,position_z=864.8948 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,7753.893,-3290.935,865.2698,0,0,0,100,0),
(@PATH,2,7753.763,-3301.661,864.6334,0,0,0,100,0),
(@PATH,3,7749.471,-3308.78,865.0084,0,0,0,100,0),
(@PATH,4,7733.761,-3302.855,864.6334,0,0,0,100,0),
(@PATH,5,7724.081,-3302.346,865.238,0,0,0,100,0),
(@PATH,6,7733.761,-3302.855,864.6334,0,0,0,100,0),
(@PATH,7,7749.471,-3308.78,865.0084,0,0,0,100,0),
(@PATH,8,7753.763,-3301.661,864.6334,0,0,0,100,0),
(@PATH,9,7753.893,-3290.935,865.2698,0,0,0,100,0),
(@PATH,10,7751.154,-3282.728,864.8948,0,0,0,100,0),
(@PATH,11,7740.746,-3275.625,863.0198,0,0,0,100,0),
(@PATH,12,7751.154,-3282.728,864.8948,0,0,0,100,0);

– Add random movement to other 6 Niffelem Forefathers
UPDATE creature SET spawndist=25,MovementType=1 WHERE id=29974 AND MovementType=0;

– Add random movement to Frostborn Ghost & Frostborn Warriors
UPDATE creature SET spawndist=25,MovementType=1 WHERE id IN (30144,30135);[/sql]
[/CODE]