[CODE]-- Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202972;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7066.043,position_y
=-1968.466,position_z
=824.2749 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7126.909,-2006.859,838.8026,0,0,0,100,0),
(@PATH,2,7128.004,-2079.435,824.9972,0,0,0,100,0),
(@PATH,3,7123.410,-2161.681,837.6913,0,0,0,100,0),
(@PATH,4,7032.643,-2110.862,816.2751,0,0,0,100,0),
(@PATH,5,7066.043,-1968.466,824.2749,0,0,0,100,0);
– Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202973;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7115.650,position_y
=-2059.480,position_z
=818.3268 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7033.949,-2100.414,836.1047,0,0,0,100,0),
(@PATH,2,7059.351,-2161.099,826.7712,0,0,0,100,0),
(@PATH,3,7092.921,-2188.170,811.4102,0,0,0,100,0),
(@PATH,4,7133.742,-2166.362,794.6603,0,0,0,100,0),
(@PATH,5,7151.966,-2105.456,792.9937,0,0,0,100,0),
(@PATH,6,7115.650,-2059.480,818.3268,0,0,0,100,0);
– Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202974;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7213.711,position_y
=-2226.125,position_z
=806.5094 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7167.105,-2184.223,820.4260,0,0,0,100,0),
(@PATH,2,7125.120,-2255.990,806.5094,0,0,0,100,0),
(@PATH,3,7173.554,-2300.135,806.5094,0,0,0,100,0),
(@PATH,4,7251.454,-2287.427,789.5095,0,0,0,100,0),
(@PATH,5,7213.711,-2226.125,806.5094,0,0,0,100,0);
– Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202975;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7109.281,position_y
=-2100.445,position_z
=817.4706 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7072.179,-2111.299,817.4706,0,0,0,100,0),
(@PATH,2,7064.227,-2116.913,817.4706,0,0,0,100,0),
(@PATH,3,7050.559,-2152.228,817.4706,0,0,0,100,0),
(@PATH,4,7062.942,-2203.969,813.1094,0,0,0,100,0),
(@PATH,5,7103.487,-2255.553,806.3886,0,0,0,100,0),
(@PATH,6,7177.481,-2288.611,796.1102,0,0,0,100,0),
(@PATH,7,7275.345,-2308.585,793.6097,0,0,0,100,0),
(@PATH,8,7372.846,-2327.065,798.7206,0,0,0,100,0),
(@PATH,9,7427.968,-2391.033,804.1375,0,0,0,100,0),
(@PATH,10,7423.436,-2447.741,807.2206,0,0,0,100,0),
(@PATH,11,7355.370,-2486.082,804.4431,0,0,0,100,0),
(@PATH,12,7304.908,-2475.450,803.7766,0,0,0,100,0),
(@PATH,13,7279.233,-2422.631,808.0823,0,0,0,100,0),
(@PATH,14,7257.583,-2362.908,817.4706,0,0,0,100,0),
(@PATH,15,7227.192,-2262.001,817.4706,0,0,0,100,0),
(@PATH,16,7168.813,-2158.760,817.4706,0,0,0,100,0),
(@PATH,17,7143.784,-2112.828,817.4706,0,0,0,100,0),
(@PATH,18,7109.281,-2100.445,817.4706,0,0,0,100,0);
– Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202976;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7327.672,position_y
=-2396.082,position_z
=794.1380 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7369.227,-2353.661,800.3325,0,0,0,100,0),
(@PATH,2,7356.053,-2268.009,817.5546,0,0,0,100,0),
(@PATH,3,7278.459,-2252.020,801.5268,0,0,0,100,0),
(@PATH,4,7239.885,-2275.736,811.6657,0,0,0,100,0),
(@PATH,5,7239.562,-2376.111,797.7770,0,0,0,100,0),
(@PATH,6,7327.672,-2396.082,794.1380,0,0,0,100,0);
– Pathing for Wild Wyrm Entry: 30275
SET @NPC := 202977;
SET @PATH := @NPC * 10;
UPDATE creature
SET spawndist
=0,MovementType
=2,position_x
=7424.327,position_y
=-2393.728,position_z
=797.1465 WHERE guid
[email protected];
DELETE FROM creature_addon
WHERE guid
[email protected];
INSERT INTO creature_addon
(guid
,path_id
,bytes2
,mount
,auras
) VALUES (@NPC,@PATH,1,0, ‘’);
DELETE FROM waypoint_data
WHERE id
[email protected];
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,delay
,move_flag
,action
,action_chance
,wpguid
) VALUES
(@PATH,1,7334.587,-2389.095,818.5355,0,0,0,100,0),
(@PATH,2,7282.970,-2459.180,819.0909,0,0,0,100,0),
(@PATH,3,7309.571,-2509.064,792.0912,0,0,0,100,0),
(@PATH,4,7420.728,-2505.169,815.1464,0,0,0,100,0),
(@PATH,5,7424.327,-2393.728,797.1465,0,0,0,100,0);
UPDATE creature_template
SET speed_run
=3.571429,speed_walk
=3.6,InhabitType
=5 WHERE entry
=30275;[/sql]
[/CODE]