Pathing Updates

Malcrom · November 26, 2011, 9:19pm

[CODE]-- Pathing for Mennu the Betrayer Entry: 17941 “The Slave Pens”
SET @NPC := 79362;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=60.90017,position_y=-380.0289,position_z=3.06417 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,89.26869,-380.2368,15.0899,0,0,0,100,0),
(@PATH,2,121.6363,-380.3765,29.95734,0,0,0,100,0),
(@PATH,3,89.42728,-380.2369,15.12144,0,0,0,100,0),
(@PATH,4,60.90017,-380.0289,3.06417,0,0,0,100,0),
(@PATH,5,49.4763,-380.2191,3.035575,0,0,0,100,0),
(@PATH,6,60.90017,-380.0289,3.06417,0,0,0,100,0);

– Pathing for Shadowsworn Thug Entry: 6005 “Serpent’s Coil”
SET @NPC := 2845;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-11273.59,position_y=-3452.474,position_z=8.065157 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,-11275.97,-3451.538,8.740623,0,0,0,100,0),
(@PATH,2,-11273.59,-3452.474,8.065157,0,0,0,100,0),
(@PATH,3,-11262.37,-3449.76,8.240552,0,0,0,100,0),
(@PATH,4,-11254.65,-3451.186,8.328776,0,0,0,100,0),
(@PATH,5,-11248.79,-3459.045,8.572252,0,0,0,100,0),
(@PATH,6,-11250.91,-3469.094,7.589902,0,0,0,100,0),
(@PATH,7,-11256.75,-3471.674,7.631489,0,0,0,100,0),
(@PATH,8,-11266.57,-3474.707,9.016354,0,0,0,100,0),
(@PATH,9,-11269.5,-3471.517,9.212216,0,0,0,100,0),
(@PATH,10,-11273.09,-3471.978,8.948565,0,0,0,100,0),
(@PATH,11,-11269.63,-3471.534,9.234768,0,0,0,100,0),
(@PATH,12,-11266.57,-3474.707,9.016354,0,0,0,100,0),
(@PATH,13,-11256.75,-3471.674,7.631489,0,0,0,100,0),
(@PATH,14,-11250.95,-3469.267,7.564928,0,0,0,100,0),
(@PATH,15,-11248.79,-3459.045,8.572252,0,0,0,100,0),
(@PATH,16,-11254.65,-3451.186,8.328776,0,0,0,100,0),
(@PATH,17,-11262.25,-3449.731,8.25388,0,0,0,100,0),
(@PATH,18,-11273.59,-3452.474,8.065157,0,0,0,100,0);
[/sql]
[/CODE]

Malcrom · November 27, 2011, 3:42pm

[CODE]-- Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 599;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14453.64,position_y=434.0356,position_z=15.14518 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14437.8,449.3056,15.39442,0,0,0,100,0),
(@PATH,2,-14449.79,463.8889,15.33584,0,0,0,100,0),
(@PATH,3,-14466.63,453.0679,15.33295,0,0,0,100,0),
(@PATH,4,-14467,449.9784,15.46876,0,0,0,100,0),
(@PATH,5,-14463.08,446.7356,15.46549,0,0,0,100,0),
(@PATH,6,-14454.29,434.9057,15.1879,0,0,0,100,0),
(@PATH,7,-14442.67,415.3969,15.07384,0,0,0,100,0),
(@PATH,8,-14453.64,434.0356,15.14518,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 651;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14431.34,position_y=428.8006,position_z=15.56208 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14434.14,432.3984,15.57179,0,0,0,100,0),
(@PATH,2,-14438.81,432.0662,15.58479,0,0,0,100,0),
(@PATH,3,-14442.86,426.7321,15.55964,0,0,0,100,0),
(@PATH,4,-14440.74,422.9708,15.55944,0,0,0,100,0),
(@PATH,5,-14433.8,427.5025,20.28823,0,0,0,100,0),
(@PATH,6,-14435.42,430.0784,20.29104,0,0,0,100,0),
(@PATH,7,-14440.63,432.1958,20.35391,0,0,0,100,0),
(@PATH,8,-14441.29,438.7781,20.49186,0,0,0,100,0),
(@PATH,9,-14444.9,445.5307,20.42483,0,0,0,100,0),
(@PATH,10,-14449.3,451.2436,20.4643,0,0,0,100,0),
(@PATH,11,-14444.9,445.5307,20.42483,0,0,0,100,0),
(@PATH,12,-14441.29,438.7781,20.49186,0,0,0,100,0),
(@PATH,13,-14440.83,432.2764,20.37827,0,0,0,100,0),
(@PATH,14,-14435.42,430.0784,20.29104,0,0,0,100,0),
(@PATH,15,-14433.8,427.5025,20.28823,0,0,0,100,0),
(@PATH,16,-14440.74,422.9708,15.55944,0,0,0,100,0),
(@PATH,17,-14442.86,426.7321,15.55964,0,0,0,100,0),
(@PATH,18,-14438.81,432.0662,15.58479,0,0,0,100,0),
(@PATH,19,-14434.14,432.3984,15.57179,0,0,0,100,0),
(@PATH,20,-14431.34,428.8006,15.56208,0,0,0,100,0),
(@PATH,21,-14439.56,423.7935,9.060257,0,0,0,100,0),
(@PATH,22,-14441.39,425.5005,9.060257,0,0,0,100,0),
(@PATH,23,-14444.71,430.7572,4.181479,0,0,0,100,0),
(@PATH,24,-14438.35,434.8836,4.196236,0,0,0,100,0),
(@PATH,25,-14439.28,437.7301,4.199284,0,0,0,100,0),
(@PATH,26,-14438.35,434.8836,4.196236,0,0,0,100,0),
(@PATH,27,-14444.54,430.8693,4.181365,0,0,0,100,0),
(@PATH,28,-14441.44,425.588,9.060257,0,0,0,100,0),
(@PATH,29,-14439.56,423.7935,9.060257,0,0,0,100,0),
(@PATH,30,-14431.34,428.8006,15.56208,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 656;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14409.15,position_y=423.5735,position_z=8.685121 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14417.71,434.1657,8.938651,0,0,0,100,0),
(@PATH,2,-14424.83,444.4519,12.94364,0,0,0,100,0),
(@PATH,3,-14435.29,448.7517,15.41846,0,0,0,100,0),
(@PATH,4,-14442.6,462.9372,15.38563,0,0,0,100,0),
(@PATH,5,-14447.83,482.1382,15.07673,0,0,0,100,0),
(@PATH,6,-14439.06,495.3882,13.35921,0,0,0,100,0),
(@PATH,7,-14431.25,512.2734,5.492578,0,0,0,100,0),
(@PATH,8,-14439.06,495.3882,13.35921,0,0,0,100,0),
(@PATH,9,-14447.83,482.1382,15.07673,0,0,0,100,0),
(@PATH,10,-14442.6,462.9372,15.38563,0,0,0,100,0),
(@PATH,11,-14435.29,448.7517,15.41846,0,0,0,100,0),
(@PATH,12,-14424.83,444.4519,12.94364,0,0,0,100,0),
(@PATH,13,-14417.74,434.2074,8.965099,0,0,0,100,0),
(@PATH,14,-14409.15,423.5735,8.685121,0,0,0,100,0),
(@PATH,15,-14396.77,416.1787,7.853766,0,0,0,100,0),
(@PATH,16,-14393.11,406.3364,6.710363,0,0,0,100,0),
(@PATH,17,-14396.77,416.1787,7.853766,0,0,0,100,0),
(@PATH,18,-14409.15,423.5735,8.685121,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 686;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14360.29,position_y=433.7195,position_z=7.371306 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14373.08,430.0338,7.368858,0,0,0,100,0),
(@PATH,2,-14385.41,425.1734,7.37805,0,0,0,100,0),
(@PATH,3,-14392.07,420.4344,7.54383,0,0,0,100,0),
(@PATH,4,-14400,412.7269,7.772449,0,0,0,100,0),
(@PATH,5,-14392.07,420.4344,7.54383,0,0,0,100,0),
(@PATH,6,-14385.41,425.1734,7.37805,0,0,0,100,0),
(@PATH,7,-14373.08,430.0338,7.368858,0,0,0,100,0),
(@PATH,8,-14360.29,433.7195,7.371306,0,0,0,100,0),
(@PATH,9,-14344.8,443.0558,7.460597,0,0,0,100,0),
(@PATH,10,-14337.3,451.9785,7.674635,0,0,0,100,0),
(@PATH,11,-14327.33,466.1374,8.173669,0,0,0,100,0),
(@PATH,12,-14337.3,451.9785,7.674635,0,0,0,100,0),
(@PATH,13,-14344.8,443.0558,7.460597,0,0,0,100,0),
(@PATH,14,-14360.29,433.7195,7.371306,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 695;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14434.61,position_y=416.9645,position_z=8.786448 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14425.3,424.2649,8.995183,0,0,0,100,0),
(@PATH,2,-14423.74,428.5187,8.967438,0,0,0,100,0),
(@PATH,3,-14428.76,437.8549,6.488632,0,0,0,100,0),
(@PATH,4,-14436.36,449.4985,3.701053,0,0,0,100,0),
(@PATH,5,-14445.45,463.7165,3.830205,0,0,0,100,0),
(@PATH,6,-14436.89,448.0471,3.695304,0,0,0,100,0),
(@PATH,7,-14448.45,438.9941,3.894725,0,0,0,100,0),
(@PATH,8,-14436.89,448.0471,3.695304,0,0,0,100,0),
(@PATH,9,-14445.45,463.7165,3.830205,0,0,0,100,0),
(@PATH,10,-14436.4,449.562,3.697694,0,0,0,100,0),
(@PATH,11,-14428.76,437.8549,6.488632,0,0,0,100,0),
(@PATH,12,-14423.74,428.5187,8.967438,0,0,0,100,0),
(@PATH,13,-14425.3,424.2649,8.995183,0,0,0,100,0),
(@PATH,14,-14434.61,416.9645,8.786448,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 715;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14465.5,position_y=479.7457,position_z=26.83965 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14466.96,470.4394,30.68908,0,0,0,100,0),
(@PATH,2,-14469.48,462.6736,30.62181,0,0,0,100,0),
(@PATH,3,-14472.31,454.0807,30.45665,0,0,0,100,0),
(@PATH,4,-14470.18,446.9187,30.63921,0,0,0,100,0),
(@PATH,5,-14474.83,441.2629,30.70506,0,0,0,100,0),
(@PATH,6,-14474.48,434.8506,33.19772,0,0,0,100,0),
(@PATH,7,-14473.78,431.6465,34.33648,0,0,0,100,0),
(@PATH,8,-14478.6,428.3144,34.24902,0,0,0,100,0),
(@PATH,9,-14473.78,431.6465,34.33648,0,0,0,100,0),
(@PATH,10,-14474.48,434.8506,33.19772,0,0,0,100,0),
(@PATH,11,-14474.83,441.2629,30.70506,0,0,0,100,0),
(@PATH,12,-14470.18,446.9187,30.63921,0,0,0,100,0),
(@PATH,13,-14472.31,454.0807,30.45665,0,0,0,100,0),
(@PATH,14,-14469.48,462.6736,30.62181,0,0,0,100,0),
(@PATH,15,-14466.96,470.4394,30.68908,0,0,0,100,0),
(@PATH,16,-14465.5,479.7457,26.83965,0,0,0,100,0),
(@PATH,17,-14473.98,487.3302,26.73741,0,0,0,100,0),
(@PATH,18,-14465.5,479.7457,26.83965,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 594;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14445.9,position_y=503.115,position_z=26.38173 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14440.46,497.1877,28.13318,0,0,0,100,0),
(@PATH,2,-14441.9,495.365,28.74637,0,0,0,100,0),
(@PATH,3,-14444.7,492.446,28.74979,0,0,0,100,0),
(@PATH,4,-14447.4,492.964,28.72694,0,0,0,100,0),
(@PATH,5,-14449.4,494.84,26.59613,0,0,0,100,0),
(@PATH,6,-14451,495.175,26.27645,0,0,0,100,0),
(@PATH,7,-14451,490.708,25.89994,0,0,0,100,0),
(@PATH,8,-14445.4,487.292,23.96267,0,0,0,100,0),
(@PATH,9,-14445.2,490.403,23.84584,0,0,0,100,0),
(@PATH,10,-14446.9,491.852,21.85869,0,0,0,100,0),
(@PATH,11,-14450.5,494.891,21.57794,0,0,0,100,0),
(@PATH,12,-14453.5,492.568,21.71061,0,0,0,100,0),
(@PATH,13,-14456.05,489.5987,20.56111,0,0,0,100,0),
(@PATH,14,-14458.09,487.2658,20.08687,0,0,0,100,0),
(@PATH,15,-14460.73,484.6711,20.51448,0,0,0,100,0),
(@PATH,16,-14463.6,481.51,20.3771,0,0,0,100,0),
(@PATH,17,-14468.3,484.245,20.37894,0,0,0,100,0),
(@PATH,18,-14472.1,489.66,20.38171,0,0,0,100,0),
(@PATH,19,-14470.6,492.795,20.37951,0,0,0,100,0),
(@PATH,20,-14462.8,500.96,15.12026,0,0,0,100,0),
(@PATH,21,-14461.1,502.278,15.12133,0,0,0,100,0),
(@PATH,22,-14458.4,499.646,15.10901,0,0,0,100,0),
(@PATH,23,-14459.3,495.418,15.11157,0,0,0,100,0),
(@PATH,24,-14464,490.319,15.11024,0,0,0,100,0),
(@PATH,25,-14469.2,494.339,15.11484,0,0,0,100,0),
(@PATH,26,-14472.2,491.484,14.90418,0,0,0,100,0),
(@PATH,27,-14468.6,487.604,14.89946,0,0,0,100,0),
(@PATH,28,-14465.4,483.762,14.90514,0,0,0,100,0),
(@PATH,29,-14460.8,479.495,14.91804,0,0,0,100,0),
(@PATH,30,-14465.4,483.762,14.90514,0,0,0,100,0),
(@PATH,31,-14468.6,487.604,14.89946,0,0,0,100,0),
(@PATH,32,-14472.2,491.484,14.90418,0,0,0,100,0),
(@PATH,33,-14469.2,494.339,15.11484,0,0,0,100,0),
(@PATH,34,-14464,490.319,15.11024,0,0,0,100,0),
(@PATH,35,-14459.3,495.418,15.11157,0,0,0,100,0),
(@PATH,36,-14458.4,499.646,15.10901,0,0,0,100,0),
(@PATH,37,-14461.1,502.278,15.12133,0,0,0,100,0),
(@PATH,38,-14462.8,500.96,15.12026,0,0,0,100,0),
(@PATH,39,-14470.52,492.8773,20.3819,0,0,0,100,0),
(@PATH,40,-14472.1,489.66,20.38171,0,0,0,100,0),
(@PATH,41,-14468.3,484.245,20.37894,0,0,0,100,0),
(@PATH,42,-14463.6,481.51,20.3771,0,0,0,100,0),
(@PATH,43,-14461,484.405,20.37349,0,0,0,100,0),
(@PATH,44,-14458.5,486.917,20.06997,0,0,0,100,0),
(@PATH,45,-14456.1,489.545,20.53601,0,0,0,100,0),
(@PATH,46,-14453.5,492.568,21.71061,0,0,0,100,0),
(@PATH,47,-14450.5,494.891,21.57794,0,0,0,100,0),
(@PATH,48,-14446.93,491.8766,21.69889,0,0,0,100,0),
(@PATH,49,-14445.2,490.403,23.84584,0,0,0,100,0),
(@PATH,50,-14444.3,488.509,23.95909,0,0,0,100,0),
(@PATH,51,-14445.4,487.292,23.96267,0,0,0,100,0),
(@PATH,52,-14449.8,489.342,24.1649,0,0,0,100,0),
(@PATH,53,-14451,490.708,25.89994,0,0,0,100,0),
(@PATH,54,-14452.8,493.823,26.27625,0,0,0,100,0),
(@PATH,55,-14451,495.175,26.27645,0,0,0,100,0),
(@PATH,56,-14447.4,492.964,28.72694,0,0,0,100,0),
(@PATH,57,-14444.7,492.446,28.74979,0,0,0,100,0),
(@PATH,58,-14441.9,495.365,28.74637,0,0,0,100,0),
(@PATH,59,-14445.9,503.115,26.38173,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 654;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14361.87,position_y=436.5753,position_z=7.379512 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14376.17,431.3158,7.370392,0,0,0,100,0),
(@PATH,2,-14361.87,436.5753,7.379512,0,0,0,100,0),
(@PATH,3,-14352.61,440.7658,7.418241,0,0,0,100,0),
(@PATH,4,-14341.35,449.1431,7.56407,0,0,0,100,0),
(@PATH,5,-14333.09,460.4818,7.913579,0,0,0,100,0),
(@PATH,6,-14326.09,472.5649,8.372003,0,0,0,100,0),
(@PATH,7,-14318.57,485.7807,8.589406,0,0,0,100,0),
(@PATH,8,-14313.01,501.729,8.631771,0,0,0,100,0),
(@PATH,9,-14318.57,485.7807,8.589406,0,0,0,100,0),
(@PATH,10,-14326.09,472.5649,8.372003,0,0,0,100,0),
(@PATH,11,-14333.09,460.4818,7.913579,0,0,0,100,0),
(@PATH,12,-14341.35,449.1431,7.56407,0,0,0,100,0),
(@PATH,13,-14352.61,440.7658,7.418241,0,0,0,100,0),
(@PATH,14,-14361.87,436.5753,7.379512,0,0,0,100,0);
– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 178;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14457.42,position_y=426.8951,position_z=25.15384 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14466.65,441.3221,29.80592,0,0,0,100,0),
(@PATH,2,-14455.59,425.8282,25.13185,0,0,0,100,0),
(@PATH,3,-14443.55,432.8691,20.30691,1000,0,0,100,0),
(@PATH,4,-14455.59,425.8282,25.13185,0,0,0,100,0),
(@PATH,5,-14466.65,441.3221,29.80592,0,0,0,100,0),
(@PATH,6,-14457.42,426.8951,25.15384,0,0,0,100,0),
(@PATH,7,-14443.32,410.5656,25.0053,0,0,0,100,0),
(@PATH,8,-14437.11,398.9681,31.72538,0,0,0,100,0),
(@PATH,9,-14443.19,410.3219,25.09302,0,0,0,100,0),
(@PATH,10,-14457.42,426.8951,25.15384,0,0,0,100,0);

– Pathing for Booty Bay Bruiser Entry: 4624
SET @NPC := 598;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-14482.2,position_y=468.324,position_z=31.5383 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,4097,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,-14479.2,472.9167,31.53506,0,0,0,100,0),
(@PATH,2,-14482.2,468.324,31.5383,0,0,0,100,0),
(@PATH,3,-14481.3,465.374,31.4924,0,0,0,100,0),
(@PATH,4,-14473.1,458.175,30.5583,0,0,0,100,0),
(@PATH,5,-14467.6,443.733,30.8549,0,0,0,100,0),
(@PATH,6,-14461.1,432.115,25.23,0,0,0,100,0),
(@PATH,7,-14448.2,415.679,25.0358,0,0,0,100,0),
(@PATH,8,-14444.7,413.023,25.015,0,0,0,100,0),
(@PATH,9,-14441.9,414.575,24.9998,0,0,0,100,0),
(@PATH,10,-14434,419.133,22.3848,0,0,0,100,0),
(@PATH,11,-14424.32,424.1917,21.70334,0,0,0,100,0),
(@PATH,12,-14434,419.133,22.3848,0,0,0,100,0),
(@PATH,13,-14441.9,414.575,24.9998,0,0,0,100,0),
(@PATH,14,-14444.7,413.023,25.015,0,0,0,100,0),
(@PATH,15,-14448.2,415.679,25.0358,0,0,0,100,0),
(@PATH,16,-14461.1,432.115,25.23,0,0,0,100,0),
(@PATH,17,-14467.6,443.733,30.8549,0,0,0,100,0),
(@PATH,18,-14473.1,458.175,30.5583,0,0,0,100,0),
(@PATH,19,-14481.3,465.374,31.4924,0,0,0,100,0),
(@PATH,20,-14482.2,468.324,31.5383,0,0,0,100,0);
[/sql]
[/CODE]

Malcrom · November 27, 2011, 4:50pm

[CODE]-- Pathing for Zanzil Naga Entry: 1491
SET @NPC := 2327;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-13656,position_y=-290.47,position_z=8.300073 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,-13646.8,-274.549,8.300073,3000,0,0,100,0),
(@PATH,2,-13634.3,-280.575,8.300073,0,0,0,100,0),
(@PATH,3,-13624.5,-285.943,8.300567,0,0,0,100,0),
(@PATH,4,-13622.9,-293.137,8.425567,0,0,0,100,0),
(@PATH,5,-13635.7,-313.58,8.309404,0,0,0,100,0),
(@PATH,6,-13641.1,-314.866,8.184404,0,0,0,100,0),
(@PATH,7,-13649.3,-309.953,8.184404,0,0,0,100,0),
(@PATH,8,-13655,-302.635,8.184404,0,0,0,100,0),
(@PATH,9,-13656,-290.47,8.300073,0,0,0,100,0);

– Pathing for Deathtalon Spirit Entry: 21198
SET @NPC := 74333;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2857.774,position_y=5472.379,position_z=-1.794863 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2847.184,5470.47,-1.419863,0,0,0,0,100,0),
(@PATH,2,-2833.211,5469.691,-0.2582169,0,0,0,0,100,0),
(@PATH,3,-2815.669,5468.27,1.866783,0,0,0,0,100,0),
(@PATH,4,-2802.513,5461.43,1.930882,0,0,0,0,100,0),
(@PATH,5,-2824.984,5435.347,-1.694118,0,0,0,0,100,0),
(@PATH,6,-2836.773,5444.539,-2.710877,0,0,0,0,100,0),
(@PATH,7,-2845.352,5459.385,-2.460877,0,0,0,0,100,0),
(@PATH,8,-2857.774,5472.379,-1.794863,2.094395,5000,0,0,100,0);

– Pathing for Deathtalon Spirit Entry: 21198
SET @NPC := 74334;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2914.703,position_y=5503.145,position_z=-4.526212 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2910.897,5491.429,-5.246685,0,0,0,0,100,0),
(@PATH,2,-2903.369,5482.751,-5.246685,0,0,0,0,100,0),
(@PATH,3,-2891.863,5472.198,-4.783368,0,0,0,0,100,0),
(@PATH,4,-2885.716,5465.328,-5.181249,0,0,0,0,100,0),
(@PATH,5,-2885.944,5460.783,-5.556249,0,0,0,0,100,0),
(@PATH,6,-2895.598,5472.149,-5.283368,0,0,0,0,100,0),
(@PATH,7,-2899.592,5480.15,-4.783368,0,0,0,0,100,0),
(@PATH,8,-2899.454,5486.137,-4.408368,0,0,0,0,100,0),
(@PATH,9,-2906.984,5497.67,-4.621685,0,0,0,0,100,0),
(@PATH,10,-2914.703,5503.145,-4.526212,4.34587,5000,0,0,100,0);

– Pathing for Auchenai Death-Speaker Entry: 21242
SET @NPC := 74474;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3370.784,position_y=4440.968,position_z=-11.92054 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,-3372.059,4435.011,-11.79554,0,0,0,100,0),
(@PATH,2,-3368.859,4432.939,-11.73247,0,0,0,100,0),
(@PATH,3,-3369.577,4431.375,-11.85747,0,0,0,100,0),
(@PATH,4,-3364.986,4437.483,-11.96612,0,0,0,100,0),
(@PATH,5,-3363.632,4437.256,-12.09112,0,0,0,100,0),
(@PATH,6,-3370.784,4440.968,-11.92054,5000,0,0,100,0);

– Pathing for Auchenai Death-Speaker Entry: 21242
SET @NPC := 74473;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3411.359,position_y=4391.01,position_z=-11.06557 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3409.375,4399.479,-10.81557,0,0,0,0,100,0),
(@PATH,2,-3406.327,4400.748,-11.37565,0,0,0,0,100,0),
(@PATH,3,-3411.359,4391.01,-11.06557,4.974188,5000,0,0,100,0),
(@PATH,4,-3417.218,4395.885,-10.31557,0,0,0,0,100,0),
(@PATH,5,-3419.011,4395.252,-10.31557,0,0,0,0,100,0),
(@PATH,6,-3411.359,4391.01,-11.06557,0,0,0,0,100,0);

– Pathing for Auchenai Death-Speaker Entry: 21242
SET @NPC := 74470;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3457.832,position_y=4434.467,position_z=-10.46219 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3456.643,4433.048,-10.57614,0,0,0,0,100,0),
(@PATH,2,-3465.113,4433.752,-11.46219,3.612832,5000,0,0,100,0),
(@PATH,3,-3457.832,4434.467,-10.46219,0,0,0,0,100,0);

– Pathing for Auchenai Death-Speaker Entry: 21242
SET @NPC := 74469;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3463.137,position_y=4441.542,position_z=-11.33719 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3464.418,4443.117,-11.83719,0,0,0,0,100,0),
(@PATH,2,-3455.871,4440.527,-10.59587,0.08726646,5000,0,0,100,0),
(@PATH,3,-3463.137,4441.542,-11.33719,0,0,0,0,100,0);

– Pathing for Auchenai Death-Speaker Entry: 21242
SET @NPC := 74472;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3454.506,position_y=4376.426,position_z=-10.59604 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3450.142,4368.463,-11.34604,0,0,0,0,100,0),
(@PATH,2,-3450.232,4366.942,-11.47104,0,0,0,0,100,0),
(@PATH,3,-3444.831,4373.678,-10.84604,0,0,0,0,100,0),
(@PATH,4,-3443.523,4373.266,-10.97104,0,0,0,0,100,0),
(@PATH,5,-3444.566,4380.154,-10.47104,3.490659,5000,0,0,100,0),
(@PATH,6,-3452.802,4375.719,-10.59604,0,0,0,0,100,0),
(@PATH,7,-3454.506,4376.426,-10.59604,0,0,0,0,100,0);[/sql]
[/CODE]

Malcrom · November 27, 2011, 7:22pm

[CODE]-- Sha’tar Vindicator walkspeed fix
UPDATE creature_template SET speed_walk=1 WHERE entry=21986;
– Pathing for Sha’tar Vindicator Entry: 21858
SET @NPC := 76498;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2795.307,position_y=5133.76,position_z=-11.47196 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2784.118,5132.377,-9.597692,0,0,0,0,100,0),
(@PATH,2,-2776.667,5130.628,-8.472692,0.5759587,8000,0,0,100,0),
(@PATH,3,-2782.857,5134.285,-9.47196,0,0,0,0,100,0),
(@PATH,4,-2790.275,5135.72,-10.72196,0,0,0,0,100,0),
(@PATH,5,-2806.792,5136.258,-12.84847,0,0,0,0,100,0),
(@PATH,6,-2821.474,5135.756,-13.34847,0,0,0,0,100,0),
(@PATH,7,-2831.835,5131.865,-13.87113,2.042035,8000,0,0,100,0),
(@PATH,8,-2820.373,5137.579,-13.22347,0,0,0,0,100,0),
(@PATH,9,-2807.843,5136.018,-12.84847,0,0,0,0,100,0),
(@PATH,10,-2795.307,5133.76,-11.47196,0,0,0,0,100,0);

– Pathing for Sha’tar Vindicator Entry: 21858
SET @NPC := 76499;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2879.353,position_y=5100.35,position_z=-20.56142 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2882.563,5088.731,-20.91118,0,0,0,0,100,0),
(@PATH,2,-2882.076,5078.95,-20.66118,0,0,0,0,100,0),
(@PATH,3,-2881.167,5065.84,-20.54303,3.438299,8000,0,0,100,0),
(@PATH,4,-2884.283,5072.697,-20.78618,0,0,0,0,100,0),
(@PATH,5,-2883.823,5084.085,-20.91118,0,0,0,0,100,0),
(@PATH,6,-2879.839,5095.616,-20.66118,0,0,0,0,100,0),
(@PATH,7,-2874.395,5108.966,-20.06142,0,0,0,0,100,0),
(@PATH,8,-2872.259,5114.568,-19.69376,2.548181,8000,0,0,100,0),
(@PATH,9,-2875.119,5107.781,-20.06142,0,0,0,0,100,0),
(@PATH,10,-2879.353,5100.35,-20.56142,0,0,0,0,100,0);

– Pathing for Sha’tar Vindicator Entry: 21858
SET @NPC := 76497;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-2750.458,position_y=5081.177,position_z=-4.491896 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-2754.324,5071.202,-4.991896,0,0,0,0,100,0),
(@PATH,2,-2760.683,5062.194,-4.756813,5.707227,8000,0,0,100,0),
(@PATH,3,-2757.946,5067.352,-4.616896,0,0,0,0,100,0),
(@PATH,4,-2752.954,5074.175,-4.741896,0,0,0,0,100,0),
(@PATH,5,-2748.238,5084.569,-5.366896,0,0,0,0,100,0),
(@PATH,6,-2746.586,5094.877,-6.366896,0,0,0,0,100,0),
(@PATH,7,-2747.154,5102.254,-6.069008,0.296706,8000,0,0,100,0),
(@PATH,8,-2748.356,5094.638,-6.491896,0,0,0,0,100,0),
(@PATH,9,-2750.458,5081.177,-4.491896,0,0,0,0,100,0);

– Pathing for Altar of Sha’tar Vindicator Entry: 21986
SET @NPC := 76805;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3047.397,position_y=727.9222,position_z=-10.39042 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-3043.087,729.4319,-10.14042,0,0,0,0,100,0),
(@PATH,2,-3037.989,730.9094,-10.14042,0,0,0,0,100,0),
(@PATH,3,-3037.989,730.9094,-10.14042,3.263766,15000,0,0,100,0),
(@PATH,4,-3035.596,716.4963,-10.64042,0,0,0,0,100,0),
(@PATH,5,-3036.084,707.1282,-8.390421,0,0,0,0,100,0),
(@PATH,6,-3047.77,705.6968,-9.640421,0,0,0,0,100,0),
(@PATH,7,-3049.939,703.6014,-9.765421,0,0,0,0,100,0),
(@PATH,8,-3047.397,727.9222,-10.39042,0,0,0,0,100,0);

– Pathing for Altar of Sha’tar Vindicator Entry: 21986
SET @NPC := 76801;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3046.609,position_y=812.7592,position_z=-10.35168 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,-3048.265,820.9583,-10.47668,0,0,0,100,0),
(@PATH,2,-3044.071,825.7698,-10.47668,0,0,0,100,0),
(@PATH,3,-3037.409,826.8802,-10.35168,0,0,0,100,0),
(@PATH,4,-3023.952,843.8754,-10.37778,0,0,0,100,0),
(@PATH,5,-3004.708,861.248,-8.869285,0,0,0,100,0),
(@PATH,6,-2989.719,863.6895,-8.667874,0,0,0,100,0),
(@PATH,7,-2978.507,860.4871,-7.531721,0,0,0,100,0),
(@PATH,8,-2989.719,863.6895,-8.667874,0,0,0,100,0),
(@PATH,9,-3004.666,861.2914,-8.868134,0,0,0,100,0),
(@PATH,10,-3023.952,843.8754,-10.37778,0,0,0,100,0),
(@PATH,11,-3037.409,826.8802,-10.35168,0,0,0,100,0),
(@PATH,12,-3044.071,825.7698,-10.47668,0,0,0,100,0),
(@PATH,13,-3048.265,820.9583,-10.47668,0,0,0,100,0),
(@PATH,14,-3046.609,812.7592,-10.35168,0,0,0,100,0),
(@PATH,15,-3050.176,806.598,-10.22668,0,0,0,100,0),
(@PATH,16,-3062.194,789.2175,-10.00262,0,0,0,100,0),
(@PATH,17,-3079.5,788.5555,-8.568529,0,0,0,100,0),
(@PATH,18,-3062.194,789.2175,-10.00262,0,0,0,100,0),
(@PATH,19,-3050.176,806.598,-10.22668,0,0,0,100,0),
(@PATH,20,-3046.609,812.7592,-10.35168,0,0,0,100,0);

– Pathing for Dragonmaw Shaman Entry: 21720
SET @NPC := 75806;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-4179.198,position_y=491.0758,position_z=29.58786 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,-4200.414,484.9251,30.40376,0,0,0,100,0),
(@PATH,2,-4227.371,466.5221,41.99168,0,0,0,100,0),
(@PATH,3,-4214.186,432.5292,48.53146,0,0,0,100,0),
(@PATH,4,-4228.9809,412.685,54.29403,0,0,0,100,0),
(@PATH,5,-4239.339,400.8127,64.83000,0,0,0,100,0),
(@PATH,6,-4247.307,388.1220,74.97658,0,0,0,100,0),
(@PATH,7,-4257.934,374.9093,79.07921,0,0,0,100,0),
(@PATH,8,-4247.307,388.1220,74.97658,0,0,0,100,0),
(@PATH,9,-4239.339,400.8127,64.83000,0,0,0,100,0),
(@PATH,10,-4228.9809,412.685,54.29403,0,0,0,100,0),
(@PATH,11,-4214.186,432.5292,48.53146,0,0,0,100,0),
(@PATH,12,-4227.371,466.5221,41.99168,0,0,0,100,0),
(@PATH,13,-4200.414,484.9251,30.40376,0,0,0,100,0),
(@PATH,14,-4179.198,491.0758,29.58786,0,0,0,100,0),
(@PATH,15,-4167.807,465.8482,30.64153,0,0,0,100,0),
(@PATH,16,-4148.617,443.9492,33.79691,0,0,0,100,0),
(@PATH,17,-4135.9844,437.8144,40.09638,0,0,0,100,0),
(@PATH,18,-4111.709,423.0407,34.42397,0,0,0,100,0),
(@PATH,19,-4135.9844,437.8144,40.09638,0,0,0,100,0),
(@PATH,20,-4148.439,444.2695,33.78185,0,0,0,100,0),
(@PATH,21,-4167.807,465.8482,30.64153,0,0,0,100,0),
(@PATH,22,-4179.198,491.0758,29.58786,0,0,0,100,0);

– Pathing for Dragonmaw Shaman Entry: 21720
SET @NPC := 75801;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-4273.486,position_y=365.9965,position_z=83.73019 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,-4267.697,377.625,79.3354,0,0,0,100,0),
(@PATH,2,-4278.636,386.1796,79.89697,0,0,0,100,0),
(@PATH,3,-4266.146,410.416,79.58,0,0,0,100,0),
(@PATH,4,-4278.636,386.1796,79.89697,0,0,0,100,0),
(@PATH,5,-4267.649,377.7209,79.3354,0,0,0,100,0),
(@PATH,6,-4273.486,365.9965,83.73019,0,0,0,100,0),
(@PATH,7,-4291.2519,344.63424,105.43157,0,0,0,100,0),
(@PATH,8,-4300.013,332.401,109.8876,0,0,0,100,0),
(@PATH,9,-4291.364,297.4996,121.6719,0,0,0,100,0),
(@PATH,10,-4266.207,286.0257,122.476,0,0,0,100,0),
(@PATH,11,-4243.615,272.7415,122.851,0,0,0,100,0),
(@PATH,12,-4221.826,271.2171,122.3309,0,0,0,100,0),
(@PATH,13,-4209.659,292.3933,122.8309,0,0,0,100,0),
(@PATH,14,-4221.826,271.2171,122.3309,0,0,0,100,0),
(@PATH,15,-4243.615,272.7415,122.851,0,0,0,100,0),
(@PATH,16,-4266.207,286.0257,122.476,0,0,0,100,0),
(@PATH,17,-4291.364,297.4996,121.6719,0,0,0,100,0),
(@PATH,18,-4300.013,332.401,109.8876,0,0,0,100,0),
(@PATH,19,-4291.2519,344.63424,105.43157,0,0,0,100,0),
(@PATH,20,-4273.486,365.9965,83.73019,0,0,0,100,0);

– Pathing for Dragonmaw Subjugator Entry: 21718
SET @NPC := 75780;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-4188.431,position_y=467.3629,position_z=30.58786 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,-4204.05,452.0077,30.74168,0,0,0,100,0),
(@PATH,2,-4188.431,467.3629,30.58786,0,0,0,100,0);

– Pathing for Ashtongue Shaman Entry: 21453
SET @NPC := 75211;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-3218.011,position_y=952.3089,position_z=54.06242 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,-3195.849,927.2684,56.39053,0,0,0,100,0),
(@PATH,2,-3218.011,952.3089,54.06242,0,0,0,100,0),
(@PATH,3,-3227.022,990.1649,57.11141,0,0,0,100,0),
(@PATH,4,-3232.969,994.8768,57.86141,0,0,0,100,0),
(@PATH,5,-3239.535,991.7921,54.51921,0,0,0,100,0),
(@PATH,6,-3255.163,986.6113,49.14421,0,0,0,100,0),
(@PATH,7,-3267.486,987.5417,45.93507,0,0,0,100,0),
(@PATH,8,-3255.163,986.6113,49.14421,0,0,0,100,0),
(@PATH,9,-3239.535,991.7921,54.51921,0,0,0,100,0),
(@PATH,10,-3232.996,994.8643,57.86141,0,0,0,100,0),
(@PATH,11,-3227.022,990.1649,57.11141,0,0,0,100,0),
(@PATH,12,-3218.011,952.3089,54.06242,0,0,0,100,0);
[/sql]
[/CODE]

Malcrom · November 27, 2011, 9:11pm

[CODE]-- Pathing for Feralfen Hunter Entry: 18113
SET @NPC := 64078;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-211.168,position_y=7326.624,position_z=44.42298 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-211.5782,7335.716,44.42309,0,0,0,0,100,0),
(@PATH,2,-204.296,7341.524,44.42319,0,0,0,0,100,0),
(@PATH,3,-196.4764,7338.283,44.42313,0,0,0,0,100,0),
(@PATH,4,-194.9693,7329.362,44.423,0,0,0,0,100,0),
(@PATH,5,-199.8639,7324.584,44.42307,0,0,0,0,100,0),
(@PATH,6,-203.4182,7322.745,44.42299,0,0,0,0,100,0),
(@PATH,7,-211.168,7326.624,44.42298,0,0,0,0,100,0);
– Pathing for Telredor Guard Entry: 18922
SET @NPC := 67945;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=253.8419,position_y=6011.672,position_z=44.36974 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,262.2152,6008.984,44.35209,0,0,0,0,100,0),
(@PATH,2,269.7768,6010.406,44.27035,0,0,0,0,100,0),
(@PATH,3,278.9399,6013.72,44.4976,0,0,0,0,100,0),
(@PATH,4,269.7768,6010.406,44.27035,0,0,0,0,100,0),
(@PATH,5,262.2152,6008.984,44.35209,0,0,0,0,100,0),
(@PATH,6,253.8419,6011.672,44.36974,0,0,0,0,100,0),
(@PATH,7,248.778,6019.71,44.34705,0,0,0,0,100,0),
(@PATH,8,249.4216,6029.512,44.32862,0,0,0,0,100,0),
(@PATH,9,256.2965,6039.321,44.33158,0,0,0,0,100,0),
(@PATH,10,249.4216,6029.512,44.32862,0,0,0,0,100,0),
(@PATH,11,248.778,6019.71,44.34705,0,0,0,0,100,0),
(@PATH,12,253.8419,6011.672,44.36974,0,0,0,0,100,0);
– Pathing for Telredor Guard Entry: 18922
SET @NPC := 67947;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=291.3727,position_y=6046.563,position_z=130.2975 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,283.6862,6042.44,130.228,0,0,0,0,100,0),
(@PATH,2,275.3527,6043.295,130.2636,0,0,0,0,100,0),
(@PATH,3,269.446,6050.111,130.1034,0,0,0,0,100,0),
(@PATH,4,270.1293,6058.713,130.3029,0,0,0,0,100,0),
(@PATH,5,271.001,6061.835,130.2923,0,0,0,0,100,0),
(@PATH,6,267.5365,6067.776,130.2844,0,0,0,0,100,0),
(@PATH,7,271.2364,6071.55,130.2316,0,0,0,0,100,0),
(@PATH,8,281.5999,6070.678,130.2613,0,0,0,0,100,0),
(@PATH,9,293.5639,6072.057,130.2317,0,0,0,0,100,0),
(@PATH,10,295.8771,6062.652,130.2814,0,0,0,0,100,0),
(@PATH,11,295.8447,6053.531,130.2873,0,0,0,0,100,0),
(@PATH,12,291.3727,6046.563,130.2975,0,0,0,0,100,0);
– Pathing for Bloodscale Overseer Entry: 20088
SET @NPC := 71547;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=617.2986,position_y=6152.999,position_z=21.50766 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,606.8119,6161.558,21.64084,0,0,0,0,100,0),
(@PATH,2,597.5352,6157.808,20.24909,0,0,0,0,100,0),
(@PATH,3,583.4203,6150.343,17.62409,0,0,0,0,100,0),
(@PATH,4,571.2615,6145.358,20.65742,0,0,0,0,100,0),
(@PATH,5,557.417,6142.033,22.73241,0,0,0,0,100,0),
(@PATH,6,545.2721,6146.418,22.51439,0,0,0,0,100,0),
(@PATH,7,557.417,6142.033,22.73241,0,0,0,0,100,0),
(@PATH,8,571.2615,6145.358,20.65742,0,0,0,0,100,0),
(@PATH,9,583.4203,6150.343,17.62409,0,0,0,0,100,0),
(@PATH,10,597.439,6157.769,20.26997,0,0,0,0,100,0),
(@PATH,11,606.8119,6161.558,21.64084,0,0,0,0,100,0),
(@PATH,12,617.2986,6152.999,21.50766,0,0,0,0,100,0);
– Pathing for Bloodscale Overseer Entry: 20088
SET @NPC := 71548;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=545.1616,position_y=6171.823,position_z=23.55802 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,546.0745,6162.425,23.40025,0,0,0,0,100,0),
(@PATH,2,555.4805,6150.89,22.66637,0,0,0,0,100,0),
(@PATH,3,559.7512,6140.578,23.0797,0,0,0,0,100,0),
(@PATH,4,557.3001,6129.771,22.1076,0,0,0,0,100,0),
(@PATH,5,559.7512,6140.578,23.0797,0,0,0,0,100,0),
(@PATH,6,555.4805,6150.89,22.66637,0,0,0,0,100,0),
(@PATH,7,546.0745,6162.425,23.40025,0,0,0,0,100,0),
(@PATH,8,545.1616,6171.823,23.55802,0,0,0,0,100,0);
– Pathing for Bloodscale Overseer Entry: 20088
SET @NPC := 71538;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=479.8319,position_y=6251.278,position_z=18.58979 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,514.136,6241.509,22.88652,0,0,0,0,100,0),
(@PATH,2,544.3127,6242.375,23.055,0,0,0,0,100,0),
(@PATH,3,556.026,6226.934,21.83558,0,1000,0,0,100,0),
(@PATH,4,544.3127,6242.375,23.055,0,0,0,0,100,0),
(@PATH,5,514.136,6241.509,22.88652,0,0,0,0,100,0),
(@PATH,6,479.8319,6251.278,18.58979,0,20000,0,0,100,0);
– Pathing for Bloodscale Wavecaller Entry: 20089
SET @NPC := 71576;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=575.4572,position_y=6420.611,position_z=4.838851 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,548.5828,6427.008,4.747003,0,0,0,0,100,0),
(@PATH,2,575.4572,6420.611,4.838851,0,0,0,0,100,0),
(@PATH,3,597.7462,6440.784,7.326898,0,0,0,0,100,0),
(@PATH,4,619.0306,6452.505,14.88498,0,0,0,0,100,0),
(@PATH,5,643.6764,6466.764,19.17756,0,0,0,0,100,0),
(@PATH,6,665.8555,6472.397,20.49226,0,0,0,0,100,0),
(@PATH,7,643.6764,6466.764,19.17756,0,0,0,0,100,0),
(@PATH,8,619.0306,6452.505,14.88498,0,0,0,0,100,0),
(@PATH,9,597.7462,6440.784,7.326898,0,0,0,0,100,0),
(@PATH,10,575.4572,6420.611,4.838851,0,0,0,0,100,0);
– Pathing for Bloodscale Overseer Entry: 20088
SET @NPC := 71560;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=471.6645,position_y=6425.619,position_z=17.45345 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,439.0181,6426.05,18.74197,0,0,0,0,100,0),
(@PATH,2,410.4155,6437.846,21.70324,0,0,0,0,100,0),
(@PATH,3,403.8959,6444.344,21.81408,0,0,0,0,100,0),
(@PATH,4,410.4155,6437.846,21.70324,0,0,0,0,100,0),
(@PATH,5,439.0181,6426.05,18.74197,0,0,0,0,100,0),
(@PATH,6,471.6645,6425.619,17.45345,0,0,0,0,100,0);
– Pathing for Bloodscale Sentry Entry: 20090
SET @NPC := 86737;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=647.6324,position_y=6179.767,position_z=17.45327 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,664.4583,6155.981,17.4254,0,0,0,0,100,0),
(@PATH,2,642.8787,6127.678,17.49909,0,0,0,0,100,0),
(@PATH,3,627.8912,6116.608,17.4991,0,0,0,0,100,0),
(@PATH,4,604.5994,6116.76,17.4991,0,0,0,0,100,0),
(@PATH,5,588.7063,6121.675,17.49909,0,0,0,0,100,0),
(@PATH,6,583.2789,6151.631,17.56806,0,0,0,0,100,0),
(@PATH,7,588.7063,6121.675,17.49909,0,0,0,0,100,0),
(@PATH,8,604.5994,6116.76,17.4991,0,0,0,0,100,0),
(@PATH,9,627.8912,6116.608,17.4991,0,0,0,0,100,0),
(@PATH,10,642.8787,6127.678,17.49909,0,0,0,0,100,0),
(@PATH,11,664.4583,6155.981,17.4254,0,0,0,0,100,0),
(@PATH,12,647.6324,6179.767,17.45327,0,0,0,0,100,0);
– Pathing for Bloodscale Sentry Entry: 20090
SET @NPC := 71590;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=536.714,position_y=6381.334,position_z=19.3341 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,512.5249,6386.269,20.09841,0,0,0,0,100,0),
(@PATH,2,536.714,6381.334,19.3341,0,0,0,0,100,0),
(@PATH,3,549.4913,6380.258,16.99608,0,0,0,0,100,0),
(@PATH,4,576.1758,6381.048,19.19262,0,0,0,0,100,0),
(@PATH,5,590.502,6385.516,19.35204,0,0,0,0,100,0),
(@PATH,6,603.5302,6383.618,19.05107,0,0,0,0,100,0),
(@PATH,7,618.3229,6384.962,19.48649,0,0,0,0,100,0),
(@PATH,8,629.5106,6391.457,18.35343,0,0,0,0,100,0),
(@PATH,9,618.3229,6384.962,19.48649,0,0,0,0,100,0),
(@PATH,10,603.5302,6383.618,19.05107,0,0,0,0,100,0),
(@PATH,11,590.5538,6385.54,19.41796,0,0,0,0,100,0),
(@PATH,12,576.1758,6381.048,19.19262,0,0,0,0,100,0),
(@PATH,13,549.4913,6380.258,16.99608,0,0,0,0,100,0),
(@PATH,14,536.714,6381.334,19.3341,0,0,0,0,100,0);
– Pathing for Bloodscale Sentry Entry: 20090
SET @NPC := 71583;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=562.1443,position_y=6106.827,position_z=17.66119 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,543.109,6101.563,17.53619,0,0,0,0,100,0),
(@PATH,2,529.306,6106.489,17.57525,0,0,0,0,100,0),
(@PATH,3,508.6398,6118.515,17.57525,0,0,0,0,100,0),
(@PATH,4,497.8846,6127.964,17.62593,0,0,0,0,100,0),
(@PATH,5,484.8557,6147.238,17.39692,0,0,0,0,100,0),
(@PATH,6,479.6094,6168.237,17.3991,0,0,0,0,100,0),
(@PATH,7,497.7457,6180.41,17.3991,0,0,0,0,100,0),
(@PATH,8,520.0167,6193.519,17.50527,0,0,0,0,100,0),
(@PATH,9,497.7457,6180.41,17.3991,0,0,0,0,100,0),
(@PATH,10,479.6094,6168.237,17.3991,0,0,0,0,100,0),
(@PATH,11,484.8557,6147.238,17.39692,0,0,0,0,100,0),
(@PATH,12,497.8846,6127.964,17.62593,0,0,0,0,100,0),
(@PATH,13,508.6398,6118.515,17.57525,0,0,0,0,100,0),
(@PATH,14,529.306,6106.489,17.57525,0,0,0,0,100,0),
(@PATH,15,543.109,6101.563,17.53619,0,0,0,0,100,0),
(@PATH,16,562.1443,6106.827,17.66119,0,0,0,0,100,0);
– Pathing for Bloodscale Sentry Entry: 20090
SET @NPC := 71583;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=446.207,position_y=6326.609,position_z=17.93723 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,454.0548,6347.622,17.85618,0,0,0,0,100,0),
(@PATH,2,456.8788,6370.086,17.94312,0,0,0,0,100,0),
(@PATH,3,452.2714,6389.746,17.81812,0,0,0,0,100,0),
(@PATH,4,467.8412,6407.655,17.79832,0,0,0,0,100,0),
(@PATH,5,491.2019,6411.824,15.48412,0,0,0,0,100,0),
(@PATH,6,467.8412,6407.655,17.79832,0,0,0,0,100,0),
(@PATH,7,452.2714,6389.746,17.81812,0,0,0,0,100,0),
(@PATH,8,456.8788,6370.086,17.94312,0,0,0,0,100,0),
(@PATH,9,454.0548,6347.622,17.85618,0,0,0,0,100,0),
(@PATH,10,446.207,6326.609,17.93723,0,0,0,0,100,0),
(@PATH,11,441.623,6303.469,17.93723,0,0,0,0,100,0),
(@PATH,12,446.207,6326.609,17.93723,0,0,0,0,100,0);
– Pathing for Fahssn Entry: 17923
SET @NPC := 63617;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=-205.36,position_y=8516.552,position_z=22.80708 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,-229.8864,8510.464,22.71419,0,0,0,0,100,0),
(@PATH,2,-205.36,8516.552,22.80708,0,0,0,0,100,0),
(@PATH,3,-188.9206,8519.879,21.83179,0,0,0,0,100,0),
(@PATH,4,-174.6535,8519.595,22.021,0,0,0,0,100,0),
(@PATH,5,-160.3699,8517.994,22.33789,0,0,0,0,100,0),
(@PATH,6,-155.0136,8518.195,21.33496,0,0,0,0,100,0),
(@PATH,7,-160.3699,8517.994,22.33789,0,0,0,0,100,0),
(@PATH,8,-174.6535,8519.595,22.021,0,0,0,0,100,0),
(@PATH,9,-188.9206,8519.879,21.83179,0,0,0,0,100,0),
(@PATH,10,-205.36,8516.552,22.80708,0,0,0,0,100,0);

– Pathing for Ango’rosh Mauler Entry: 18120
SET @NPC := 64228;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1699.805,position_y=8628.589,position_z=12.01016 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1717.921,8632.591,8.065008,0,0,0,0,100,0),
(@PATH,2,1699.805,8628.589,12.01016,0,0,0,0,100,0),
(@PATH,3,1689.124,8621.329,12.50693,0,0,0,0,100,0),
(@PATH,4,1681.696,8611.765,12.6384,0,0,0,0,100,0),
(@PATH,5,1675.004,8605.295,12.36166,0,0,0,0,100,0),
(@PATH,6,1664.974,8601.517,10.78405,0,0,0,0,100,0),
(@PATH,7,1655.826,8594.225,8.950456,0,0,0,0,100,0),
(@PATH,8,1649.307,8586.103,8.346086,0,0,0,0,100,0),
(@PATH,9,1655.826,8594.225,8.950456,0,0,0,0,100,0),
(@PATH,10,1664.974,8601.517,10.78405,0,0,0,0,100,0),
(@PATH,11,1675.004,8605.295,12.36166,0,0,0,0,100,0),
(@PATH,12,1681.696,8611.765,12.6384,0,0,0,0,100,0),
(@PATH,13,1689.124,8621.329,12.50693,0,0,0,0,100,0),
(@PATH,14,1699.805,8628.589,12.01016,0,0,0,0,100,0);

– Pathing for Ango’rosh Shadowmage Entry: 20444
SET @NPC := 72426;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1668.375,position_y=8473.033,position_z=-58.77278 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1682.668,8469.868,-61.03103,0,0,0,0,100,0),
(@PATH,2,1668.375,8473.033,-58.77278,0,0,0,0,100,0),
(@PATH,3,1656.672,8485.056,-55.70977,0,0,0,0,100,0),
(@PATH,4,1648.938,8498.171,-53.83168,0,0,0,0,100,0),
(@PATH,5,1649.625,8510.094,-54.21131,0,0,0,0,100,0),
(@PATH,6,1654.654,8521.531,-53.58351,0,0,0,0,100,0),
(@PATH,7,1664.266,8535.215,-51.28564,0,0,0,0,100,0),
(@PATH,8,1673.347,8538.975,-49.83964,0,0,0,0,100,0),
(@PATH,9,1687.687,8539.301,-49.18303,0,0,0,0,100,0),
(@PATH,10,1698.444,8539.608,-48.25351,0,0,0,0,100,0),
(@PATH,11,1687.687,8539.301,-49.18303,0,0,0,0,100,0),
(@PATH,12,1673.364,8538.981,-49.88883,0,0,0,0,100,0),
(@PATH,13,1664.266,8535.215,-51.28564,0,0,0,0,100,0),
(@PATH,14,1654.654,8521.531,-53.58351,0,0,0,0,100,0),
(@PATH,15,1649.625,8510.094,-54.21131,0,0,0,0,100,0),
(@PATH,16,1648.938,8498.171,-53.83168,0,0,0,0,100,0),
(@PATH,17,1656.672,8485.056,-55.70977,0,0,0,0,100,0),
(@PATH,18,1668.375,8473.033,-58.77278,0,0,0,0,100,0);

– Pathing for Ango’rosh Mauler Entry: 18120
SET @NPC := 64232;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1665.907,position_y=8502.825,position_z=-6.924901 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1654.69,8501.367,-6.633519,0,0,0,0,100,0),
(@PATH,2,1644.64,8504.219,-7.020604,0,0,0,0,100,0),
(@PATH,3,1631.158,8510.858,-6.801638,0,0,0,0,100,0),
(@PATH,4,1622.581,8518.366,-5.849367,0,0,0,0,100,0),
(@PATH,5,1615.581,8524.725,-6.334841,0,0,0,0,100,0),
(@PATH,6,1611.307,8535.476,-8.693747,0,0,0,0,100,0),
(@PATH,7,1609.289,8548.758,-14.15615,0,0,0,0,100,0),
(@PATH,8,1608.688,8551.909,-15.61611,0,0,0,0,100,0),
(@PATH,9,1606.189,8568.754,-21.79966,0,0,0,0,100,0),
(@PATH,10,1608.48,8584.462,-29.34727,0,0,0,0,100,0),
(@PATH,11,1606.189,8568.754,-21.79966,0,0,0,0,100,0),
(@PATH,12,1608.679,8551.937,-15.42959,0,0,0,0,100,0),
(@PATH,13,1609.289,8548.758,-14.15615,0,0,0,0,100,0),
(@PATH,14,1611.307,8535.476,-8.693747,0,0,0,0,100,0),
(@PATH,15,1615.581,8524.725,-6.334841,0,0,0,0,100,0),
(@PATH,16,1622.581,8518.366,-5.849367,0,0,0,0,100,0),
(@PATH,17,1631.158,8510.858,-6.801638,0,0,0,0,100,0),
(@PATH,18,1644.64,8504.219,-7.020604,0,0,0,0,100,0),
(@PATH,19,1654.69,8501.367,-6.633519,0,0,0,0,100,0),
(@PATH,20,1665.907,8502.825,-6.924901,0,0,0,0,100,0),
(@PATH,21,1672.206,8501.249,-7.81,0,0,0,0,100,0),
(@PATH,22,1665.907,8502.825,-6.924901,0,0,0,0,100,0);
[/sql]
[/CODE]

Malcrom · November 28, 2011, 12:30am

[CODE]-- Halls of Lightning
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126933;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1352.31,position_y=4.197591,position_z=42.5066 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1365.236,17.10211,48.15386,2.321288,10000,0,0,100,0),
(@PATH,2,1352.31,4.197591,42.5066,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126919;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1254.525,position_y=15.89421,position_z=33.50527 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1254.664,57.27192,33.50556,3.141593,9000,0,0,100,0),
(@PATH,2,1254.525,15.89421,33.50527,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126940;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1269.877,position_y=39.53092,position_z=33.50552 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1269.926,69.15126,33.50548,0.0001,8000,0,0,100,0),
(@PATH,2,1269.877,39.53092,33.50552,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126926;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1377.999,position_y=64.51378,position_z=49.05543 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1359.833,82.54373,41.04519,0.7504916,9000,0,0,100,0),
(@PATH,2,1377.999,64.51378,49.05543,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126925;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1438.074,position_y=30.96126,position_z=58.7663 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1406.36,33.16645,50.03824,3.874631,9000,0,477,100,0),
(@PATH,2,1435.185,32.61599,58.76621,0,0,0,0,100,0),
(@PATH,3,1438.074,30.96126,58.7663,5.497787,12000,0,477,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126917;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1269.767,position_y=3.9426,position_z=33.50558 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1269.868,33.59418,33.50554,0.0001,8000,0,0,100,0),
(@PATH,2,1269.767,3.9426,33.50558,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126918;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1260.999,position_y=111.9844,position_z=33.50547 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1252.053,106.0862,33.50548,0,0,0,0,100,0),
(@PATH,2,1249.99,102.1417,33.50549,0,0,0,0,100,0),
(@PATH,3,1251.811,101.3819,33.50548,1.064651,6000,0,477,100,0),
(@PATH,4,1255.887,110.4616,33.50547,0,0,0,0,100,0),
(@PATH,5,1262.899,112.1962,33.50547,0,0,0,0,100,0),
(@PATH,6,1272.864,106.65,33.50546,0,0,0,0,100,0),
(@PATH,7,1274.312,101.4808,33.50546,0,0,0,0,100,0),
(@PATH,8,1271.201,101.2063,33.50546,1.151917,7000,0,477,100,0),
(@PATH,9,1264.614,111.4701,33.50547,3.944444,8000,0,477,100,0),
(@PATH,10,1260.999,111.9844,33.50547,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126942;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1327.195,position_y=101.496,position_z=40.1804 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1329.334,97.29807,40.1804,2.408554,10000,0,477,100,0),
(@PATH,2,1339.068,97.24534,40.1804,0,0,0,0,100,0),
(@PATH,3,1339.391,101.921,40.1804,0,0,0,0,100,0),
(@PATH,4,1337.122,102.2657,40.1804,4.677482,7000,0,477,100,0),
(@PATH,5,1327.195,101.496,40.1804,4.660029,6000,0,477,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126924;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1377.864,position_y=8.267796,position_z=48.99335 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1359.885,-9.615234,41.10306,5.602507,7000,0,0,100,0),
(@PATH,2,1377.864,8.267796,48.99335,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126941;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1259.138,position_y=-34.31152,position_z=33.50571 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1262.923,-39.22483,33.50573,0,0,0,0,100,0),
(@PATH,2,1267.745,-35.60221,33.50572,1.082104,10000,0,477,100,0),
(@PATH,3,1259.138,-34.31152,33.50571,0,0,0,0,100,0),
(@PATH,4,1253.777,-28.32698,33.50572,2.426008,9000,0,477,100,0),
(@PATH,5,1259.138,-34.31152,33.50571,0,0,0,0,100,0);
– Pathing for Stormforged Mender Entry: 28582
SET @NPC := 126915;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1329.092,position_y=138.6539,position_z=47.72641 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1334.124,126.4251,42.7474,2.070083,8000,0,0,100,0), – turn to 2.070083
(@PATH,2,1329.092,138.6539,47.72641,0,0,0,0,100,0);

– Pathing for Blistering Steamrager Entry: 28583
SET @NPC := 126954;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1354.028,position_y=-157.3944,position_z=52.02459 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1347.132,-145.6849,52.02804,0,0,0,0,100,0),
(@PATH,2,1332.241,-141.7957,52.52262,0,0,0,0,100,0),
(@PATH,3,1315.993,-147.3745,52.0387,0,0,0,0,100,0),
(@PATH,4,1308.699,-164.3708,52.02926,0,0,0,0,100,0),
(@PATH,5,1313.867,-179.6888,52.02301,0,0,0,0,100,0),
(@PATH,6,1330.744,-187.854,52.02337,0,0,0,0,100,0),
(@PATH,7,1345.286,-183.8249,52.02341,0,0,0,0,100,0),
(@PATH,8,1354.788,-172.8455,52.0245,0,0,0,0,100,0),
(@PATH,9,1354.028,-157.3944,52.02459,0,0,0,0,100,0);
– F1306FA71D8CF300 .go 1347.132 -145.6849 52.02804

– Pathing for Blistering Steamrager Entry: 28583
SET @NPC := 126955;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=1354.028,position_y=-157.3944,position_z=52.02459 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,orientation,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,1347.132,-145.6849,52.02804,0,0,0,0,100,0),
(@PATH,2,1332.241,-141.7957,52.52262,0,0,0,0,100,0),
(@PATH,3,1315.993,-147.3745,52.0387,0,0,0,0,100,0),
(@PATH,4,1308.699,-164.3708,52.02926,0,0,0,0,100,0),
(@PATH,5,1313.867,-179.6888,52.02301,0,0,0,0,100,0),
(@PATH,6,1330.744,-187.854,52.02337,0,0,0,0,100,0),
(@PATH,7,1345.286,-183.8249,52.02341,0,0,0,0,100,0),
(@PATH,8,1354.788,-172.8455,52.0245,0,0,0,0,100,0),
(@PATH,9,1354.028,-157.3944,52.02459,0,0,0,0,100,0);
– F1306FA71D8CF300 .go 1347.132 -145.6849 52.02804

DELETE FROM creature_formations WHERE leaderGUID=126955;
INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI) VALUES
(126955,126955,0,0,2),
(126955,126954,2,45,2);
[/sql]
[/CODE]