search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

Caster NPC's pathfinding / Line of Sight issue #689

Open Xadras opened 8 years ago

Xadras commented 8 years ago

Originally reported by: Jawohl (Bitbucket: Jawohl, GitHub: Jawohl)

All caster mobs i have encountered so far can be " dodged " behind Objects without them coming after you, they are going to be stuck still unable to find path.

This is a game breaking bug, if this occurs all around the world + dungeons / raids, because you can tank Key monsters like this.

Caster not following behind Objects <--- This bug occur with ALL caster mobs i have encountered so far, no matter the area, object you hide behind, landscape or environment in any way.

Unyelding Sorcerers not using abilities or following <--- Aggroing these monsters, they dont path find you, follow or use abilities even if you stand infront of them.

Xadras commented 8 years ago

Original comment by Anon X (Bitbucket: Anonx, GitHub: Anonx):

#!sql

-- Searscale Drake 7046
UPDATE `creature_template` SET `Inhabittype`='3' WHERE `entry` IN ('7046'); -- 5
-- Scalding Drake 7045
UPDATE `creature_template` SET `Inhabittype`='3' WHERE `entry` IN ('7045'); -- 5

-- Thaurissan Agent 7038
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('7038');
INSERT INTO `creature_ai_scripts` VALUES
('703800','7038','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Thaurissan Agent - Start Movement and Set Melee Weapon Model'),
('703801','7038','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Thaurissan Agent - Set Phase 1 and Start Movement OOC'),
('703802','7038','9','1','100','1','5','30','2200','3000','11','6660','1','0','40','2','0','0','21','0','0','0','Thaurissan Agent - Cast Shoot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('703803','7038','9','1','100','1','5','30','36300','50000','11','6685','1','0','40','2','0','0','21','0','0','0','Thaurissan Agent - Cast Piercing Shot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('703804','7038','9','0','100','1','0','5','13300','24100','11','12540','4','0','0','0','0','0','0','0','0','0','Thaurissan Agent - Cast Gouge'),
('703805','7038','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Thaurissan Agent - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('703806','7038','7','0','100','0','0','0','0','0','22','0','0','0','40','1','0','0','21','1','0','0','Thaurissan Agent - Set Phase 0 and Set Melee Weapon Model and Start Movement on Evade'),
('703807','7038','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Thaurissan Agent - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');
--
-- Dark Iron Lookout 8566
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('8566');
INSERT INTO `creature_ai_scripts` VALUES
('856600','8566','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Dark Iron Lookout - Start Movement and Set Melee Weapon Model'),
('856601','8566','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Dark Iron Lookout - Set Phase 1 on Aggro'),
('856602','8566','4','0','15','0','0','0','0','0','1','-5','-6','0','0','0','0','0','0','0','0','0','Dark Iron Lookout - Say on Aggro'),
('856603','8566','9','5','100','1','5','30','1200','2400','11','6660','1','0','40','2','0','0','21','0','0','0','Dark Iron Lookout - Cast Shoot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('856604','8566','2','0','100','0','15','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Dark Iron Lookout - Set Phase 2 at 15% HP'),
('856605','8566','2','3','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Dark Iron Lookout - Start Combat Movement and Flee at 15% HP (Phase 2)'),
('856606','8566','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Dark Iron Lookout - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('856607','8566','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Dark Iron Lookout - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('856608','8566','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Dark Iron Lookout - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('702801','702806');

-- Dustbelcher Wyrmhunter 2716
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('2716');
INSERT INTO `creature_ai_scripts` VALUES
('271600','2716','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Dustbelcher Wyrmhunter - Start Movement and Set Melee Weapon Model'),
('271601','2716','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Dustbelcher Wyrmhunter - Set Phase 1 on Aggro'),
('271602','2716','4','0','10','0','0','0','0','0','1','-359','-360','-361','0','0','0','0','0','0','0','0','Dustbelcher Wyrmhunter - Random Say on Aggro'),
('271603','2716','9','1','100','1','5','30','2300','5900','11','9483','1','0','21','0','0','0','0','0','0','0','Dustbelcher Wyrmhunter - Cast Boulder and Stop Movement (Phase 1)'),
('271604','2716','0','0','100','1','18600','24700','21100','30400','11','6533','1','1','21','0','0','0','0','0','0','0','Dustbelcher Wyrmhunter - Cast Net and Stop Movement'),
('271605','2716','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Dustbelcher Wyrmhunter - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('271606','2716','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Dustbelcher Wyrmhunter - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('271607','2716','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Dustbelcher Wyrmhunter - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('271801','271807');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('290701','290706');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('484401','484407');

-- Haren Swifthoof 2478 & Gradok 2477 & Thragomm 7170
UPDATE `creature_template` SET `speed`='1.49' WHERE `entry` IN ('2478');
UPDATE `creature_template` SET `speed`='1.49' WHERE `entry` IN ('2477');
UPDATE `creature_template` SET `speed`='1.49' WHERE `entry` IN ('7170');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('105401','105407');

DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('2103');
INSERT INTO `creature_ai_scripts` VALUES
('210300','2103','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Dragonmaw Scout - Start Movement and Set Melee Weapon Model'),
('210301','2103','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Dragonmaw Scout - Set Phase 1 on Aggro'),
('210302','2103','4','0','15','0','0','0','0','0','1','-101','-102','-105','0','0','0','0','0','0','0','0','Dragonmaw Scout - Random Say on Aggro'),
('210303','2103','9','5','100','1','5','30','2400','3600','11','6660','1','0','40','2','0','0','21','0','0','0','Dragonmaw Scout - Cast Shoot and Set Ranged Weapon Model (Phase 1)'),
('210304','2103','2','0','100','0','15','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Dragonmaw Scout - Set Phase 2 at 15% HP'),
('210305','2103','2','3','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Dragonmaw Scout - Start Combat Movement and Flee at 15% HP (Phase 2)'),
('210306','2103','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Dragonmaw Scout - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('210307','2103','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Dragonmaw Scout - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('210308','2103','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Dragonmaw Scout - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('257001','257008');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('257301','257308');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('257701','257707');

DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('2587');
INSERT INTO `creature_ai_scripts` VALUES
('258700','2587','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Syndicate Pathstalker - Start Movement and Set Melee Weapon Model'),
('258701','2587','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Syndicate Pathstalker - Set Phase 1 on Aggro'),
('258702','2587','4','0','15','0','0','0','0','0','1','-5','-6','0','0','0','0','0','0','0','0','0','Syndicate Pathstalker - Random Aggro Say'),
('258703','2587','9','5','100','1','5','30','2200','3800','11','6660','1','0','40','2','0','0','21','0','0','0','Syndicate Pathstalker - Cast Shoot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('258704','2587','2','0','100','0','15','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Syndicate Pathstalker - Set Phase 2 at 15% HP'),
('258705','2587','2','3','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Syndicate Pathstalker - Start Combat Movement and Flee at 15% HP (Phase 2)'),
('258706','2587','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Syndicate Pathstalker - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('258707','2587','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Syndicate Pathstalker - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('258708','2587','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Syndicate Pathstalker - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('2554');
INSERT INTO `creature_ai_scripts` VALUES
('255400','2554','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Witherbark Axe Thrower - Start Movement and Set Melee Weapon Model'),
('255401','2554','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Witherbark Axe Thrower - Set Phase 1 on Aggro'),
('255402','2554','9','5','100','1','5','30','2100','4800','11','10277','1','0','40','2','0','0','21','0','0','0','Witherbark Axe Thrower - Cast Throw and Set Ranged Weapon Model (Phase 1)'),
('255403','2554','0','0','100','1','10200','26000','2500','6700','11','4974','1','32','0','0','0','0','0','0','0','0','Witherbark Axe Thrower - Cast Wither Touch'),
('255404','2554','2','0','100','0','15','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Witherbark Axe Thrower - Set Phase 2 at 15% HP'),
('255405','2554','2','3','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Witherbark Axe Thrower - Start Combat Movement and Flee at 15% HP (Phase 2)'),
('255406','2554','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Witherbark Axe Thrower - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('255407','2554','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Witherbark Axe Thrower - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('255408','2554','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Witherbark Axe Thrower - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('3377');
INSERT INTO `creature_ai_scripts` VALUES
('337700','3377','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Bael\'dun Rifleman - Start Movement and Set Melee Weapon Model'),
('337701','3377','4','0','100','0','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Bael\'dun Rifleman - Set Phase 1 on Aggro'),
('337702','3377','9','5','100','1','5','30','2300','3900','11','6660','1','0','40','2','0','0','21','0','0','0','Bael\'dun Rifleman - Cast Shoot and Set Ranged Weapon Model and Stop Movement(Phase 1)'),
('337703','3377','2','0','100','0','15','0','0','0','23','1','0','0','0','0','0','0','0','0','0','0','Bael\'dun Rifleman - Set Phase 2 at 15% HP'),
('337704','3377','2','3','100','0','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Bael\'dun Rifleman - Start Movement and Flee at 15% HP (Phase 2)'),
('337705','3377','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Bael\'dun Rifleman - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('337706','3377','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Bael\'dun Rifleman - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('337707','3377','9','0','100','7','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Bael\'dun Rifleman - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('259101','259108');

UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('707501','707506');

SET @GUID := '2413';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(2413,1,-5086.54,462.919,405.449,40000,0,0,0,0),
(2413,2,-5092.69,453.24,406.074,20000,0,0,0,0);

SET @GUID := '5015';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(5015,1,-10567.5,-1497.46,92.024,0,0,0,0,0),
(5015,2,-10573.5,-1498.21,91.4401,90000,0,0,0,0),
(5015,3,-10597.9,-1502.32,92.5709,0,0,0,0,0),
(5015,4,-10614.2,-1506.79,91.0415,0,0,0,0,0),
(5015,5,-10632.5,-1493.29,90.5234,10000,0,0,0,0),
(5015,6,-10640,-1514.55,90.5081,6000,0,0,0,0),
(5015,7,-10628.2,-1522.73,90.5088,0,0,0,0,0),
(5015,8,-10614,-1504.09,91.0183,0,0,0,0,0);
--
SET @GUID := '5459';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(5459,1,-8089.87,-1402.15,136.793,0,0,0,0,0),
(5459,2,-8092.88,-1407.84,136.793,0,0,0,0,0),
(5459,3,-8097.2,-1409.08,136.793,0,0,0,0,0),
(5459,4,-8101.18,-1403.68,136.793,0,0,0,0,0),
(5459,5,-8094.62,-1396.8,136.793,0,0,0,0,0);
--
SET @GUID := '5461';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(5461,1,-7697.92,-2156.57,132.324,0,0,0,0,0),
(5461,2,-7696.98,-2148.79,132.348,0,0,0,0,0),
(5461,3,-7701.5,-2129.17,132.201,0,0,0,0,0),
(5461,4,-7698.04,-2157.14,132.354,0,0,0,0,0),
(5461,5,-7705.54,-2170.28,131.958,0,0,0,0,0),
(5461,6,-7710.74,-2183.09,131.896,0,0,0,0,0),
(5461,7,-7714.31,-2190.44,133.439,0,0,0,0,0),
(5461,8,-7720.88,-2213.8,133.529,0,0,0,0,0),
(5461,9,-7728.9,-2197.38,133.439,0,0,0,0,0),
(5461,10,-7718.11,-2185.99,133.417,0,0,0,0,0),
(5461,11,-7715.4,-2182.95,131.897,0,0,0,0,0),
(5461,12,-7705.49,-2169.84,132.167,0,0,0,0,0),
(5461,13,-7698.4,-2158.45,132.638,0,0,0,0,0);
--
SET @GUID := '5511';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(5511,1,-7721.51,-1491.34,137.714,0,0,0,0,0),
(5511,2,-7718.98,-1485.55,139.623,0,0,0,0,0),
(5511,3,-7717.78,-1482.81,140.451,0,0,0,0,0),
(5511,4,-7712.62,-1472.28,140.805,0,0,0,0,0),
(5511,5,-7717.95,-1482.62,140.499,0,0,0,0,0),
(5511,6,-7719.96,-1486.63,139.132,0,0,0,0,0),
(5511,7,-7723.1,-1493.41,136.652,0,0,0,0,0),
(5511,8,-7726.65,-1500.79,132.914,0,0,0,0,0),
(5511,9,-7723.79,-1496.01,135.386,0,0,0,0,0),
(5511,10,-7721.98,-1491.91,137.482,0,0,0,0,0);
--
SET @GUID := '5525';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(5525,1,-7668.71,-1453.94,140.743,0,0,0,0,0),
(5525,2,-7670.9,-1458.24,140.745,0,0,0,0,0),
(5525,3,-7686.5,-1450.27,140.84,0,0,0,0,0),
(5525,4,-7690.77,-1437.52,140.936,0,0,0,0,0),
(5525,5,-7699.09,-1433.36,140.936,0,0,0,0,0),
(5525,6,-7711.54,-1437.74,140.875,0,0,0,0,0),
(5525,7,-7727.87,-1430.31,140.75,0,0,0,0,0),
(5525,8,-7712.6,-1438.2,140.841,0,0,0,0,0),
(5525,9,-7705.05,-1454.45,140.937,0,0,0,0,0),
(5525,10,-7686.49,-1450.24,140.842,0,0,0,0,0),
(5525,11,-7673.08,-1456.71,140.757,0,0,0,0,0);
--
SET @GUID := '6218';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(6218,1,-7189.78,-1703.28,242.022,0,0,0,0,0),
(6218,2,-7189.11,-1688.74,240.686,0,0,0,0,0),
(6218,3,-7185.06,-1662.91,241.097,0,0,0,0,0),
(6218,4,-7176.01,-1649.45,241.665,0,0,0,0,0),
(6218,5,-7152.52,-1646.87,240.573,0,0,0,0,0),
(6218,6,-7120.01,-1661.24,240.515,0,0,0,0,0),
(6218,7,-7116.35,-1664.98,241.667,0,0,0,0,0),
(6218,8,-7094.93,-1691.71,241.661,0,0,0,0,0),
(6218,9,-7094.97,-1696.36,240.304,0,0,0,0,0),
(6218,10,-7110.31,-1702.4,240.626,0,0,0,0,0),
(6218,11,-7124.61,-1706.56,240.08,0,0,0,0,0),
(6218,12,-7138.68,-1724.57,240.802,0,0,0,0,0),
(6218,13,-7154.09,-1739.43,242.742,0,0,0,0,0),
(6218,14,-7177.27,-1751.42,243.498,0,0,0,0,0),
(6218,15,-7191.14,-1739.76,244.375,0,0,0,0,0),
(6218,16,-7199.08,-1721.11,244.429,0,0,0,0,0),
(6218,17,-7200.48,-1716.67,242.274,0,0,0,0,0),
(6218,18,-7197.34,-1702.22,241.667,0,0,0,0,0);
--
SET @GUID := '6229';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(6229,1,-7028.82,-981.872,249.932,0,0,0,0,0),
(6229,2,-7021.71,-994.254,243.201,0,0,0,0,0),
(6229,3,-7013.19,-1017.25,241.733,0,0,0,0,0),
(6229,4,-7004.28,-1031.1,242.688,0,0,0,0,0),
(6229,5,-6979.77,-1038.06,241.667,0,0,0,0,0),
(6229,6,-6961.96,-1039.52,240.744,0,0,0,0,0),
(6229,7,-6947.23,-1040.72,242.336,0,0,0,0,0),
(6229,8,-6933.2,-1033.85,242.985,0,0,0,0,0),
(6229,9,-6921.71,-1023.85,241.926,0,0,0,0,0),
(6229,10,-6911.01,-1024.09,241.274,0,0,0,0,0),
(6229,11,-6899.92,-1032.91,240.508,0,0,0,0,0),
(6229,12,-6893.78,-1041.25,242.491,0,0,0,0,0),
(6229,13,-6884.61,-1040.16,243.154,0,0,0,0,0),
(6229,14,-6872.59,-1033.3,245.145,0,0,0,0,0),
(6229,15,-6867.87,-1040.18,245.581,0,0,0,0,0),
(6229,16,-6863.77,-1040.38,243.23,0,0,0,0,0),
(6229,17,-6849.21,-1043.47,240.019,0,0,0,0,0),
(6229,18,-6827.73,-1058.17,240.096,0,0,0,0,0),
(6229,19,-6803.46,-1066.51,241.503,0,0,0,0,0),
(6229,20,-6785.82,-1072.8,241.265,0,0,0,0,0),
(6229,21,-6780.1,-1076.27,241.11,0,0,0,0,0),
(6229,22,-6771.55,-1087.72,241.495,0,0,0,0,0),
(6229,23,-6783.55,-1103.93,243.151,0,0,0,0,0),
(6229,24,-6792.14,-1115.54,243.431,0,0,0,0,0),
(6229,25,-6790,-1126.9,242.069,0,0,0,0,0),
(6229,26,-6787.79,-1138.63,240.392,0,0,0,0,0),
(6229,27,-6780.99,-1146.24,241.892,0,0,0,0,0),
(6229,28,-6774.16,-1153.88,243.583,0,0,0,0,0),
(6229,29,-6765.99,-1163.02,242.487,0,0,0,0,0),
(6229,30,-6761.29,-1172.02,241.799,0,0,0,0,0),
(6229,31,-6754.11,-1185.75,241.532,0,0,0,0,0),
(6229,32,-6743.5,-1194.69,240.264,0,0,0,0,0),
(6229,33,-6733.48,-1198.94,241.456,0,0,0,0,0),
(6229,34,-6725.4,-1208.1,240.662,0,0,0,0,0),
(6229,35,-6718.54,-1215.86,240.383,0,0,0,0,0),
(6229,36,-6715.86,-1207.48,240.345,0,0,0,0,0),
(6229,37,-6716.89,-1194.43,240.348,0,0,0,0,0),
(6229,38,-6720.05,-1188.1,240.345,0,0,0,0,0),
(6229,39,-6715.13,-1181.78,240.746,0,0,0,0,0),
(6229,40,-6712.55,-1173.73,242.146,0,0,0,0,0),
(6229,41,-6701.66,-1163.68,240.804,0,0,0,0,0),
(6229,42,-6697.33,-1155.29,241.618,0,0,0,0,0),
(6229,43,-6687.92,-1148.54,241.228,0,0,0,0,0),
(6229,44,-6674.24,-1146.93,241.44,0,0,0,0,0),
(6229,45,-6669.87,-1157.1,242.058,0,0,0,0,0),
(6229,46,-6661.99,-1168.15,243.184,0,0,0,0,0),
(6229,47,-6656.84,-1182.15,243.829,0,0,0,0,0),
(6229,48,-6658.51,-1188.95,243.76,0,0,0,0,0),
(6229,49,-6657.24,-1204.04,244.418,0,0,0,0,0),
(6229,50,-6659.63,-1217.32,244.179,0,0,0,0,0),
(6229,51,-6655.85,-1225.45,244.769,0,0,0,0,0),
(6229,52,-6648.68,-1228.11,246.403,0,0,0,0,0),
(6229,53,-6642.15,-1223.93,248.828,0,0,0,0,0),
(6229,54,-6637.74,-1222.16,251.758,0,0,0,0,0),
(6229,55,-6635.21,-1219.74,253.536,0,0,0,0,0),
(6229,56,-6628.15,-1214.73,255.24,0,0,0,0,0),
(6229,57,-6621.66,-1214.57,258.725,0,0,0,0,0),
(6229,58,-6617.52,-1216.07,261.268,0,0,0,0,0),
(6229,59,-6616.01,-1214.57,262.722,0,0,0,0,0),
(6229,60,-6612.48,-1213.46,265.518,0,0,0,0,0),
(6229,61,-6608.14,-1214.09,268.499,0,0,0,0,0),
(6229,62,-6603.45,-1215.91,269.899,0,0,0,0,0),
(6229,63,-6604.91,-1222.76,270.517,0,0,0,0,0),
(6229,64,-6603.87,-1229.52,271.222,0,0,0,0,0),
(6229,65,-6604.28,-1239.73,270.674,0,0,0,0,0),
(6229,66,-6604.68,-1249.69,268.801,0,0,0,0,0),
(6229,67,-6605.17,-1261.97,266.251,0,0,0,0,0),
(6229,68,-6605.42,-1268.24,265.202,0,0,0,0,0),
(6229,69,-6605.69,-1274.85,264.155,0,0,0,0,0),
(6229,70,-6604.49,-1281,264.155,0,0,0,0,0),
(6229,71,-6605.99,-1289.45,264.155,0,0,0,0,0),
(6229,72,-6604.51,-1297.72,264.154,0,0,0,0,0),
(6229,73,-6606.4,-1304.94,264.154,0,0,0,0,0),
(6229,74,-6612.03,-1307.38,264.154,0,0,0,0,0),
(6229,75,-6614.87,-1302.34,264.416,0,0,0,0,0),
(6229,76,-6612.42,-1295.98,264.155,0,0,0,0,0),
(6229,77,-6612.84,-1290.78,264.549,0,0,0,0,0),
(6229,78,-6615.3,-1285.68,265.784,0,0,0,0,0),
(6229,79,-6618.61,-1278.83,263.965,0,0,0,0,0),
(6229,80,-6622.66,-1270.44,261.689,0,0,0,0,0),
(6229,81,-6625.77,-1267.37,261.387,0,0,0,0,0),
(6229,82,-6632,-1270.67,259.748,0,0,0,0,0),
(6229,83,-6633.19,-1275.52,259.348,0,0,0,0,0),
(6229,84,-6636.32,-1279.98,260.261,0,0,0,0,0),
(6229,85,-6638.11,-1286.3,258.026,0,0,0,0,0),
(6229,86,-6640.39,-1294.36,255.501,0,0,0,0,0),
(6229,87,-6645.55,-1301.06,251.64,0,0,0,0,0),
(6229,88,-6649.99,-1304.79,249.522,0,0,0,0,0),
(6229,89,-6657.58,-1303,245.891,0,0,0,0,0),
(6229,90,-6668.35,-1300.45,242.749,0,0,0,0,0),
(6229,91,-6677.73,-1298.24,241.983,0,0,0,0,0),
(6229,92,-6680.62,-1288.86,241.977,0,0,0,0,0),
(6229,93,-6685.22,-1277.78,242.037,0,0,0,0,0),
(6229,94,-6691.48,-1262.7,241.65,0,0,0,0,0),
(6229,95,-6695.92,-1251.98,241.178,0,0,0,0,0),
(6229,96,-6700.33,-1241.36,240.624,0,0,0,0,0),
(6229,97,-6697.59,-1230.23,240.546,0,0,0,0,0),
(6229,98,-6700.94,-1215.73,241.018,0,0,0,0,0),
(6229,99,-6705.66,-1204.35,241.763,0,0,0,0,0),
(6229,100,-6709.5,-1195.09,240.576,0,0,0,0,0),
(6229,101,-6708.34,-1183.09,240.346,0,0,0,0,0),
(6229,102,-6706.99,-1169.22,240.99,0,0,0,0,0),
(6229,103,-6702.49,-1157.61,241.585,0,0,0,0,0),
(6229,104,-6696.63,-1142.51,242.877,0,0,0,0,0),
(6229,105,-6690.93,-1127.81,241.691,0,0,0,0,0),
(6229,106,-6688.69,-1114.43,240.955,0,0,0,0,0),
(6229,107,-6686.7,-1102.52,241.014,0,0,0,0,0),
(6229,108,-6693.35,-1089.78,241.057,0,0,0,0,0),
(6229,109,-6699.44,-1078.13,240.818,0,0,0,0,0),
(6229,110,-6705.98,-1065.6,240.511,0,0,0,0,0),
(6229,111,-6714.79,-1048.73,240.1,0,0,0,0,0),
(6229,112,-6728.14,-1042.91,240.014,0,0,0,0,0),
(6229,113,-6744.86,-1035.63,240.798,0,0,0,0,0),
(6229,114,-6763.52,-1032.39,239.991,0,0,0,0,0),
(6229,115,-6781.49,-1029.26,242.539,0,0,0,0,0),
(6229,116,-6794.47,-1029.8,244.85,0,0,0,0,0),
(6229,117,-6804.94,-1030.24,245.38,0,0,0,0,0),
(6229,118,-6818.33,-1030.8,244.228,0,0,0,0,0),
(6229,119,-6830.51,-1026.89,242.788,0,0,0,0,0),
(6229,120,-6838.35,-1012.21,242.415,0,0,0,0,0),
(6229,121,-6851.43,-1002.28,240.377,0,0,0,0,0),
(6229,122,-6864.3,-1001.15,240.864,0,0,0,0,0),
(6229,123,-6869.12,-1001.11,242.397,0,0,0,0,0),
(6229,124,-6875.23,-1001.06,243.357,0,0,0,0,0),
(6229,125,-6884.04,-998.447,243.034,0,0,0,0,0),
(6229,126,-6892.29,-995.999,243.247,0,0,0,0,0),
(6229,127,-6900.25,-993.639,243.579,0,0,0,0,0),
(6229,128,-6906.32,-985.46,243.49,0,0,0,0,0),
(6229,129,-6911.84,-978.018,242.571,0,0,0,0,0),
(6229,130,-6919.03,-978.748,243.073,0,0,0,0,0),
(6229,131,-6929.18,-981.877,240.744,0,0,0,0,0),
(6229,132,-6940.15,-990.569,240.744,0,0,0,0,0),
(6229,133,-6947.35,-1011.1,240.744,0,0,0,0,0),
(6229,134,-6954.31,-1019.36,240.782,0,0,0,0,0),
(6229,135,-6968.68,-1021.37,241.845,0,0,0,0,0),
(6229,136,-6988.91,-1033.87,241.668,0,0,0,0,0),
(6229,137,-7006.02,-1048.6,241.579,0,0,0,0,0),
(6229,138,-7020.5,-1048.74,240.751,0,0,0,0,0),
(6229,139,-7037.62,-1034.87,240.303,0,0,0,0,0),
(6229,140,-7071.2,-1030.01,240.612,0,0,0,0,0),
(6229,141,-7098.69,-1036.08,240.308,0,0,0,0,0),
(6229,142,-7118.73,-1033.37,240.517,0,0,0,0,0),
(6229,143,-7142.01,-1018.82,240.777,0,0,0,0,0),
(6229,144,-7137.84,-1010.51,240.602,0,0,0,0,0),
(6229,145,-7136.23,-996.618,242.692,0,0,0,0,0),
(6229,146,-7122.5,-991.448,244.452,0,0,0,0,0),
(6229,147,-7101.88,-1001.13,242.835,0,0,0,0,0),
(6229,148,-7086.45,-1000.98,242.081,0,0,0,0,0),
(6229,149,-7079.3,-1012.88,242.508,0,0,0,0,0),
(6229,150,-7072.52,-1025.51,241.234,0,0,0,0,0),
(6229,151,-7055.69,-1019.93,241.458,0,0,0,0,0),
(6229,152,-7041.51,-1015.22,241.666,0,0,0,0,0),
(6229,153,-7033.41,-1004.15,242.201,0,0,0,0,0),
(6229,154,-7031.75,-996.247,244.108,0,0,0,0,0),
(6229,155,-7030.49,-987.949,247.32,0,0,0,0,0);
--
SET @GUID := '6747';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(6747,1,-1747.49,5126.32,-35.8634,15000,0,0,0,0),
(6747,2,-1752.1,5142.16,-36.2611,269000,0,0,0,0),
(6747,3,-1747.49,5126.32,-35.8634,60000,0,0,0,0);
--
SET @GUID := '6974';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(6974,1,-7135.3,-2398.71,241.667,0,0,0,0,0),
(6974,2,-7145.97,-2405.74,240.515,0,0,0,0,0),
(6974,3,-7159.72,-2413.28,241.352,0,0,0,0,0),
(6974,4,-7172.35,-2428.99,241.532,0,0,0,0,0),
(6974,5,-7182.12,-2447.56,242.669,0,0,0,0,0),
(6974,6,-7184.62,-2460.03,244.235,0,0,0,0,0),
(6974,7,-7190.2,-2500.89,248.676,0,0,0,0,0),
(6974,8,-7193.24,-2526.41,248.254,0,0,0,0,0),
(6974,9,-7189.33,-2540.52,246.938,0,0,0,0,0),
(6974,10,-7192.18,-2585.98,245.712,0,0,0,0,0),
(6974,11,-7186.92,-2609.43,246.791,0,0,0,0,0),
(6974,12,-7182.4,-2629.94,245.232,0,0,0,0,0),
(6974,13,-7160.17,-2655.04,243.609,0,0,0,0,0),
(6974,14,-7151.66,-2661.19,242.684,0,0,0,0,0),
(6974,15,-7126.01,-2679.47,241.68,0,0,0,0,0),
(6974,16,-7105.29,-2703.18,241.667,0,0,0,0,0),
(6974,17,-7100.8,-2717.73,241.671,0,0,0,0,0),
(6974,18,-7101.81,-2754.36,242.088,0,0,0,0,0),
(6974,19,-7107.84,-2774.47,241.835,0,0,0,0,0),
(6974,20,-7107.82,-2812.45,241.669,0,0,0,0,0),
(6974,21,-7111.11,-2834.46,241.724,0,0,0,0,0),
(6974,22,-7119.35,-2864.85,241.664,0,0,0,0,0),
(6974,23,-7112.3,-2883.04,241.866,0,0,0,0,0),
(6974,24,-7098.89,-2908.38,241.728,0,0,0,0,0),
(6974,25,-7092.95,-2937.12,242.37,0,0,0,0,0),
(6974,26,-7086.37,-2967.92,241.861,0,0,0,0,0),
(6974,27,-7080.65,-2998.88,241.73,0,0,0,0,0),
(6974,28,-7079.19,-3040.82,241.667,0,0,0,0,0),
(6974,29,-7082.07,-3072.18,241.685,0,0,0,0,0),
(6974,30,-7086.67,-3112.91,241.883,0,0,0,0,0),
(6974,31,-7087.67,-3154.85,241.667,0,0,0,0,0),
(6974,32,-7091.08,-3178.08,241.947,0,0,0,0,0),
(6974,33,-7095.66,-3209.24,241.667,0,0,0,0,0),
(6974,34,-7088.9,-3242.6,242.215,0,0,0,0,0),
(6974,35,-7091.34,-3286.01,242.171,0,0,0,0,0),
(6974,36,-7096.97,-3306.23,242.896,0,0,0,0,0),
(6974,37,-7099.57,-3316.4,242.469,0,0,0,0,0),
(6974,38,-7105.14,-3347.39,242.625,0,0,0,0,0),
(6974,39,-7105.68,-3373.95,243.344,0,0,0,0,0),
(6974,40,-7097.72,-3421.09,242.211,0,0,0,0,0),
(6974,41,-7089.09,-3466.46,241.836,0,0,0,0,0),
(6974,42,-7087.26,-3497.91,241.672,0,0,0,0,0),
(6974,43,-7083.49,-3539.72,241.721,0,0,0,0,0),
(6974,44,-7076.15,-3567.77,241.672,0,0,0,0,0),
(6974,45,-7046.26,-3608.03,241.667,0,0,0,0,0),
(6974,46,-7030.38,-3602.45,241.933,0,0,0,0,0),
(6974,47,-6998.77,-3574.86,241.867,0,0,0,0,0),
(6974,48,-6967.53,-3546.81,241.813,0,0,0,0,0),
(6974,49,-6943.25,-3526.74,241.727,0,0,0,0,0),
(6974,50,-6915.92,-3497.98,241.755,0,0,0,0,0),
(6974,51,-6890.41,-3468.74,244.033,0,0,0,0,0),
(6974,52,-6875.95,-3453.52,244.256,0,0,0,0,0),
(6974,53,-6860.05,-3439.81,242.728,0,0,0,0,0),
(6974,54,-6835.49,-3420.12,242.694,0,0,0,0,0),
(6974,55,-6812.98,-3399.22,241.667,0,0,0,0,0),
(6974,56,-6798.12,-3381.07,241.667,0,0,0,0,0),
(6974,57,-6773.84,-3386.66,241.667,0,0,0,0,0),
(6974,58,-6744.94,-3384.88,241.915,0,0,0,0,0),
(6974,59,-6715.98,-3354.98,241.468,0,0,0,0,0),
(6974,60,-6698.15,-3321.56,241.493,0,0,0,0,0),
(6974,61,-6696.84,-3311.15,241.133,0,0,0,0,0),
(6974,62,-6702.21,-3261.83,240.782,0,0,0,0,0),
(6974,63,-6723.66,-3235.23,240.745,0,0,0,0,0),
(6974,64,-6750.24,-3205.89,240.743,0,0,0,0,0),
(6974,65,-6771.24,-3157.78,240.743,0,0,0,0,0),
(6974,66,-6787.52,-3132.62,240.698,0,0,0,0,0),
(6974,67,-6803.62,-3094.67,240.757,0,0,0,0,0),
(6974,68,-6816.13,-3054.58,241.666,0,0,0,0,0),
(6974,69,-6839.64,-3007.66,241.82,0,0,0,0,0),
(6974,70,-6851.75,-2990.51,243.81,0,0,0,0,0),
(6974,71,-6872.35,-2964.19,241.942,0,0,0,0,0),
(6974,72,-6882.66,-2937.73,243.878,0,0,0,0,0),
(6974,73,-6872.06,-2915.87,243.185,0,0,0,0,0),
(6974,74,-6866.96,-2898.98,242.357,0,0,0,0,0),
(6974,75,-6865.04,-2888.66,243.315,0,0,0,0,0),
(6974,76,-6863.04,-2848.09,243.284,0,0,0,0,0),
(6974,77,-6858.07,-2831.39,241.912,0,0,0,0,0),
(6974,78,-6848.42,-2809.52,241.667,0,0,0,0,0),
(6974,79,-6841.62,-2778.77,241.713,0,0,0,0,0),
(6974,80,-6837.84,-2758.12,241.694,0,0,0,0,0),
(6974,81,-6834.42,-2726.83,241.918,0,0,0,0,0),
(6974,82,-6839.91,-2698.44,242.04,0,0,0,0,0),
(6974,83,-6842.14,-2679.61,240.868,0,0,0,0,0),
(6974,84,-6838.77,-2660.76,241.096,0,0,0,0,0),
(6974,85,-6846.81,-2631.97,240.815,0,0,0,0,0),
(6974,86,-6854,-2611.99,240.744,0,0,0,0,0),
(6974,87,-6851.04,-2561.43,240.744,0,0,0,0,0),
(6974,88,-6866.81,-2552.64,240.744,0,0,0,0,0),
(6974,89,-6882.49,-2544.65,240.744,0,0,0,0,0),
(6974,90,-6905.9,-2523.6,240.744,0,0,0,0,0),
(6974,91,-6925.06,-2507.54,240.744,0,0,0,0,0),
(6974,92,-6941.59,-2479.67,240.744,0,0,0,0,0),
(6974,93,-6958.66,-2455.83,240.744,0,0,0,0,0),
(6974,94,-6969.83,-2434.38,240.744,0,0,0,0,0),
(6974,95,-6970.25,-2407.8,240.744,0,0,0,0,0),
(6974,96,-6992.63,-2400.84,240.744,0,0,0,0,0),
(6974,97,-7009.34,-2386.8,240.75,0,0,0,0,0),
(6974,98,-7039.79,-2366.47,240.304,0,0,0,0,0),
(6974,99,-7059.23,-2365.95,240.304,0,0,0,0,0),
(6974,100,-7093.28,-2367.99,240.303,0,0,0,0,0),
(6974,101,-7114.13,-2374.54,241.599,0,0,0,0,0),
(6974,102,-7116.35,-2388.29,241.666,0,0,0,0,0);
--
SET @GUID := '8742';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(8742,1,-5367.19,-2936.94,327.368,0,0,0,0,0),
(8742,2,-5378.17,-2925.83,331.671,0,0,0,0,0),
(8742,3,-5396.18,-2905.99,338.893,0,0,0,0,0),
(8742,4,-5405.21,-2891.45,342.355,0,0,0,0,0),
(8742,5,-5397.65,-2903.89,339.434,0,0,0,0,0),
(8742,6,-5389.32,-2913.93,336.257,0,0,0,0,0),
(8742,7,-5370.99,-2933.09,328.984,0,0,0,0,0),
(8742,8,-5357.74,-2947.28,324.143,0,0,0,0,0),
(8742,9,-5352.05,-2945.49,323.469,0,0,0,0,0),
(8742,10,-5347.44,-2937.83,323.164,0,0,0,0,0),
(8742,11,-5350.51,-2946.23,323.517,0,0,0,0,0),
(8742,12,-5359.93,-2951.5,324.043,0,0,0,0,0),
(8742,13,-5369.64,-2951.62,323.784,0,0,0,0,0),
(8742,14,-5355.88,-2952.06,323.909,0,0,0,0,0),
(8742,15,-5351.84,-2965.23,324.015,0,0,0,0,0),
(8742,16,-5348.78,-2976.38,324.3,0,0,0,0,0),
(8742,17,-5358.76,-2984.13,324.552,0,0,0,0,0),
(8742,18,-5371.16,-2994.94,328.932,0,0,0,0,0),
(8742,19,-5361.08,-2986.07,325.003,0,0,0,0,0),
(8742,20,-5346.79,-2982.49,323.927,0,0,0,0,0),
(8742,21,-5338.73,-2987.41,323.931,0,0,0,0,0),
(8742,22,-5340.02,-2994,323.655,0,0,0,0,0),
(8742,23,-5340.75,-3010.79,324.108,0,0,0,0,0),
(8742,24,-5343.91,-3011.72,324.257,0,0,0,0,0),
(8742,25,-5348.24,-3012.78,326.232,0,0,0,0,0),
(8742,26,-5343.15,-3012.38,324.056,0,0,0,0,0),
(8742,27,-5340.65,-3007.47,324.071,0,0,0,0,0),
(8742,28,-5339.2,-2988.51,323.821,0,0,0,0,0),
(8742,29,-5349.9,-2965.89,324.026,0,0,0,0,0),
(8742,30,-5344.21,-2962.33,323.909,0,0,0,0,0),
(8742,31,-5335.43,-2960.58,325.959,0,0,0,0,0),
(8742,32,-5323.14,-2959.65,331.089,0,0,0,0,0),
(8742,33,-5313.22,-2956.49,333.68,0,0,0,0,0),
(8742,34,-5306.52,-2953.33,334.127,0,0,0,0,0),
(8742,35,-5317.66,-2952.92,332.948,0,0,0,0,0),
(8742,36,-5331.26,-2955.29,327.422,0,0,0,0,0),
(8742,37,-5341.59,-2956.78,324.044,0,0,0,0,0),
(8742,38,-5350.97,-2952.2,323.754,0,0,0,0,0),
(8742,39,-5359.27,-2942.62,324.853,0,0,0,0,0);
--
SET @GUID := '9192';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(9192,1,-4989.21,-2957.65,315.659,0,0,0,0,0),
(9192,2,-4999.45,-2967.17,314.308,0,0,0,0,0),
(9192,3,-5000.8,-2976.72,314.155,0,0,0,0,0),
(9192,4,-4992.67,-2984.08,314.509,0,0,0,0,0),
(9192,5,-4981.01,-2992.5,315.858,0,0,0,0,0),
(9192,6,-4991.95,-2983.3,314.48,0,0,0,0,0),
(9192,7,-4999.98,-2971,314.095,0,0,0,0,0),
(9192,8,-4991.52,-2959.57,315.653,0,0,0,0,0),
(9192,9,-4984.22,-2943.51,316.163,0,0,0,0,0),
(9192,10,-4980.57,-2940.93,316.074,0,0,0,0,0),
(9192,11,-4975.9,-2944.49,316.464,0,0,0,0,0),
(9192,12,-4982.96,-2945.72,315.893,0,0,0,0,0);
--
SET @GUID := '9296';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(9296,1,-4949.16,-2998.01,344.444,0,0,0,0,0),
(9296,2,-4943.57,-2997.72,342.574,0,0,0,0,0),
(9296,3,-4936.51,-2997.12,338.424,0,0,0,0,0),
(9296,4,-4932.05,-2996.77,336.772,0,0,0,0,0),
(9296,5,-4925.72,-2997.35,333.616,0,0,0,0,0),
(9296,6,-4922.83,-3002.15,330.406,0,0,0,0,0),
(9296,7,-4927.37,-3006.6,328.894,0,0,0,0,0),
(9296,8,-4923.84,-3003.84,329.685,0,0,0,0,0),
(9296,9,-4920.83,-2996.81,331.624,0,0,0,0,0),
(9296,10,-4926.62,-2995.36,334.889,0,0,0,0,0),
(9296,11,-4934.09,-2997.24,337.454,0,0,0,0,0),
(9296,12,-4940.4,-2997.71,340.403,0,0,0,0,0),
(9296,13,-4949.81,-2997.58,345.003,0,0,0,0,0),
(9296,14,-4957.51,-2996.39,347.401,0,0,0,0,0),
(9296,15,-4963.75,-2993.9,347.431,0,0,0,0,0),
(9296,16,-4968.34,-2989.5,347.083,0,0,0,0,0),
(9296,17,-4962.86,-2992.67,347,0,0,0,0,0),
(9296,18,-4957.82,-2996.76,347.257,0,0,0,0,0),
(9296,19,-4951.73,-2998.51,345.413,0,0,0,0,0);
--
SET @GUID := '10593';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(10593,1,-2605.98,-2294.53,90.1834,0,0,0,0,0),
(10593,2,-2599.3,-2294.19,90.1834,0,0,0,0,0),
(10593,3,-2593.9,-2290.89,88.216,0,0,0,0,0),
(10593,4,-2593.32,-2285.17,86.0468,0,0,0,0,0),
(10593,5,-2595.42,-2277.21,86.0165,0,0,0,0,0),
(10593,6,-2607.02,-2274.33,86.0165,0,0,0,0,0),
(10593,7,-2613.51,-2284.33,86.0163,0,0,0,0,0),
(10593,8,-2612.99,-2289.62,88.1459,0,0,0,0,0),
(10593,9,-2608.98,-2293.16,90.1093,0,0,0,0,0);
--
SET @GUID := '11254';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(11254,1,-873.09,-3517.63,72.1898,0,0,0,0,0),
(11254,2,-865.22,-3511.38,72.4706,0,0,0,0,0),
(11254,3,-854.217,-3511.59,73.2518,0,0,0,0,0),
(11254,4,-850.781,-3511.56,72.7482,0,0,0,0,0),
(11254,5,-840.888,-3518.84,72.7927,0,0,0,0,0),
(11254,6,-831.8,-3518.26,72.4915,0,0,0,0,0),
(11254,7,-826.154,-3515.26,72.9619,0,0,0,0,0),
(11254,8,-836.481,-3522.67,72.6493,0,0,0,0,0),
(11254,9,-839.255,-3528.73,72.5095,0,0,0,0,0),
(11254,10,-839.621,-3539.07,72.492,0,0,0,0,0),
(11254,11,-838.855,-3542.25,72.7692,0,0,0,0,0),
(11254,12,-835.844,-3545.32,72.8465,0,0,0,0,0),
(11254,13,-825.881,-3547.29,73.2116,3000,0,0,0,0),
(11254,14,-835.602,-3545.19,72.8155,0,0,0,0,0),
(11254,15,-838.219,-3543.42,72.8309,0,0,0,0,0),
(11254,16,-840.276,-3536.58,72.6483,0,0,0,0,0),
(11254,17,-838.175,-3523.91,72.7408,0,0,0,0,0),
(11254,18,-825.855,-3515.48,73.0081,0,0,0,0,0),
(11254,19,-839.3,-3518.75,72.7678,0,0,0,0,0),
(11254,20,-846.086,-3516.92,73.0208,0,0,0,0,0),
(11254,21,-850.335,-3511.42,72.7738,0,0,0,0,0),
(11254,22,-853.208,-3510.04,73.2402,0,0,0,0,0),
(11254,23,-868.882,-3511.94,72.3214,0,0,0,0,0),
(11254,24,-874.617,-3515.49,72.0399,0,0,0,0,0),
(11254,25,-876.442,-3520.03,72.039,0,0,0,0,0),
(11254,26,-877.459,-3555.01,71.2988,0,0,0,0,0),
(11254,27,-881.288,-3540.24,70.7428,0,0,0,0,0),
(11254,28,-886.085,-3521.28,71.0581,0,0,0,0,0),
(11254,29,-888.066,-3517.1,71.3156,0,0,0,0,0),
(11254,30,-893.214,-3514.06,71.0349,0,0,0,0,0),
(11254,31,-926.399,-3513.57,70.4809,5000,0,0,0,0),
(11254,32,-904.593,-3512.17,70.8522,0,0,0,0,0),
(11254,33,-893.01,-3513.63,71.0772,0,0,0,0,0),
(11254,34,-889.026,-3516.7,71.2871,0,0,0,0,0),
(11254,35,-883.299,-3527.78,70.9055,0,0,0,0,0),
(11254,36,-878.349,-3552.12,71.418,0,0,0,0,0),
(11254,37,-876.301,-3527.34,71.8396,0,0,0,0,0);
--
SET @GUID := '11295';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(11295,1,-1013.16,-3563.17,56.8228,0,0,0,0,0),
(11295,2,-1010.6,-3541.78,56.4415,0,0,0,0,0),
(11295,3,-999.428,-3533.67,56.8186,0,0,0,0,0),
(11295,4,-987.176,-3518.17,57.0499,0,0,0,0,0),
(11295,5,-974.772,-3502.29,56.1873,0,0,0,0,0),
(11295,6,-955.17,-3511.88,56.9688,5000,0,0,0,0),
(11295,7,-974.051,-3501.21,56.0345,0,0,0,0,0),
(11295,8,-987.236,-3515.39,57.0223,0,0,0,0,0),
(11295,9,-995.164,-3531.3,56.741,0,0,0,0,0),
(11295,10,-1005.49,-3537.64,56.8777,0,0,0,0,0),
(11295,11,-1012.83,-3562.73,56.8218,0,0,0,0,0),
(11295,12,-1012.83,-3562.73,56.8218,2000,0,0,0,0);
--
SET @GUID := '11354';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(11354,1,-1372.74,-2449.62,53.8113,10000,0,0,0,0),
(11354,2,-1372.74,-2449.62,53.8113,10000,0,0,0,0),
(11354,3,-1384.66,-2480.76,60.3599,10000,0,0,0,0),
(11354,4,-1376.83,-2486.03,60.8417,10000,0,0,0,0),
(11354,5,-1376.83,-2486.03,60.8417,10000,0,0,0,0),
(11354,6,-1368.43,-2478.92,59.6478,10000,0,0,0,0),
(11354,7,-1373.23,-2475.02,59.1017,10000,0,0,0,0);
--
SET @GUID := '11985';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(11985,1,-1348.07,-2425.51,59.3361,10000,0,0,0,0),
(11985,2,-1343.42,-2422.35,59.459,10000,0,0,0,0),
(11985,3,-1350.28,-2415.92,60.7792,10000,0,0,0,0),
(11985,4,-1350.28,-2415.92,60.7792,10000,0,0,0,0),
(11985,5,-1369.03,-2426.29,60.5038,10000,0,0,0,0),
(11985,6,-1365.37,-2429.07,60.0273,10000,0,0,0,0);
--
SET @GUID := '13988';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(13988,1,23.4224,-1715.12,101.473,0,0,0,0,0),
(13988,2,25.6736,-1720.65,104.32,0,0,0,0,0),
(13988,3,26.3315,-1730.7,108.755,0,0,0,0,0),
(13988,4,25.8771,-1721.01,104.408,0,0,0,0,0),
(13988,5,24.5645,-1715.97,102.2,0,0,0,0,0),
(13988,6,19.0326,-1708.92,97.4096,0,0,0,0,0),
(13988,7,9.16129,-1699.81,93.8904,0,0,0,0,0),
(13988,8,-12.5573,-1683.36,93.997,0,0,0,0,0),
(13988,9,-2.0205,-1692.62,93.2765,0,0,0,0,0),
(13988,10,6.91721,-1699.36,93.6531,0,0,0,0,0),
(13988,11,17.6506,-1707.35,96.6117,0,0,0,0,0),
(13988,12,24.8482,-1713.81,101.266,0,0,0,0,0);
--
SET @GUID := '14386';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(14386,1,-218.01,-3332.16,91.6676,0,0,0,0,0),
(14386,2,-225.482,-3341.16,91.6676,0,0,0,0,0),
(14386,3,-237.319,-3343.2,91.7107,0,0,0,0,0),
(14386,4,-245.034,-3333.29,92.3149,0,0,0,0,0),
(14386,5,-244.485,-3324.63,92.7759,0,0,0,0,0),
(14386,6,-235.332,-3302.28,92.9443,0,0,0,0,0),
(14386,7,-221.838,-3302.11,91.668,0,0,0,0,0),
(14386,8,-221.838,-3302.11,91.668,0,0,0,0,0);
--
SET @GUID := '14442';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(14442,1,-3790.44,-1979.55,93.9736,0,0,0,0,0),
(14442,2,-3780.87,-1986.06,93.9832,0,0,0,0,0),
(14442,3,-3761.96,-1993.53,95.0956,0,0,0,0,0),
(14442,4,-3751.41,-1991.31,95.3568,0,0,0,0,0),
(14442,5,-3738.35,-1984.88,95.4844,0,0,0,0,0),
(14442,6,-3730.98,-1973.79,95.4964,0,0,0,0,0),
(14442,7,-3727.98,-1960.77,94.8635,0,0,0,0,0),
(14442,8,-3727.68,-1948.11,94.033,0,0,0,0,0),
(14442,9,-3733.08,-1930.73,92.0848,0,0,0,0,0),
(14442,10,-3740.76,-1921.66,92.6135,0,0,0,0,0),
(14442,11,-3754.57,-1913.64,92.8797,0,0,0,0,0),
(14442,12,-3768.65,-1914.6,92.627,0,0,0,0,0),
(14442,13,-3777.7,-1922.01,93.4925,0,0,0,0,0),
(14442,14,-3784.08,-1935.86,94.5736,0,0,0,0,0),
(14442,15,-3784.92,-1942.13,95.0424,0,0,0,0,0),
(14442,16,-3785.47,-1956.08,95.4779,0,0,0,0,0);
--
SET @GUID := '14446';
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(14446,1,-4074.93,-1970.15,91.6669,0,0,0,0,0),
(14446,2,-4062.78,-1981.01,91.6865,0,0,0,0,0),
(14446,3,-4062.91,-1992.04,92.108,0,0,0,0,0),
(14446,4,-4072.42,-2000.78,92.044,0,0,0,0,0),
(14446,5,-4091.6,-1995.37,91.6852,0,0,0,0,0),
(14446,6,-4109.4,-1981.85,91.6677,0,0,0,0,0),
(14446,7,-4111.83,-1978.6,91.6677,0,0,0,0,0),
(14446,8,-4118.62,-1951.21,92.7795,0,0,0,0,0),
(14446,9,-4115.76,-1932.84,93.9919,0,0,0,0,0),
(14446,10,-4106.77,-1917.13,94.5655,0,0,0,0,0),
(14446,11,-4094.82,-1907.83,94.7338,0,0,0,0,0),
(14446,12,-4080,-1907.95,93.6741,0,0,0,0,0),
(14446,13,-4070.34,-1913.84,91.8198,0,0,0,0,0),
(14446,14,-4064.97,-1929.98,91.6991,0,0,0,0,0),
(14446,15,-4065.4,-1943.79,91.6684,0,0,0,0,0);

DELETE FROM `creature_formations` WHERE `leaderguid` IN ('6251');
INSERT INTO `creature_formations` VALUES 
(6251,6251,100,360,2),
(6251,6690,3,1.1,2),
(6251,6691,3,5.1,2);
Xadras commented 8 years ago

Original comment by Anon X (Bitbucket: Anonx, GitHub: Anonx):

#!sql

SELECT * FROM `creature_template` WHERE `entry` IN (4805);
SELECT * FROM `creature_ai_scripts` WHERE `entryOrGuid` IN (4805);

-- Ragefire Shaman 11319
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('11319');
INSERT INTO `creature_ai_scripts` VALUES
('1131901','11319','1','0','100','2','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Prevent Combat Movement on Spawn'),
('1131902','11319','4','0','100','2','0','0','0','0','11','9532','1','0','23','1','0','0','0','0','0','0','Ragefire Shaman - Cast Lightning Bolt and Set Phase 1 on Aggro'),
('1131903','11319','9','5','100','3','0','40','4200','5800','11','9532','1','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Cast Lightning Bolt (Phase 1)'),
('1131904','11319','3','5','100','2','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Ragefire Shaman - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('1131905','11319','9','5','100','2','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Start Combat Movement at 35 Yards (Phase 1)'),
('1131906','11319','9','5','100','2','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Prevent Combat Movement at 15 Yards (Phase 1)'),
('1131907','11319','9','5','100','2','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Start Combat Movement Below 5 Yards'),
('1131908','11319','3','3','100','3','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1131909','11319','14','0','100','2','330','40','18800','23800','11','11986','6','1','0','0','0','0','0','0','0','0','Ragefire Shaman - Cast Healing Wave on Friendlies'),
('1131910','11319','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Ragefire Shaman - Set Phase to 0 on Evade');
--
-- Molten Elemental 11319
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('11321');
INSERT INTO `creature_ai_scripts` VALUES
('1132101','11321','11','0','100','2','0','0','0','0','11','18968','0','1','0','0','0','0','0','0','0','0','Molten Elemental - Cast Fire Shield on Spawn'),
('1132102','11321','27','0','100','3','18968','1','2000','5000','11','18968','0','1','0','0','0','0','0','0','0','0','Molten Elemental - Cast Fire Shield on Missing Fire Shield Aura');
--
-- Searing Blade Cultist 11322
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('11322');
INSERT INTO `creature_ai_scripts` VALUES
('1132201','11322','9','0','100','3','0','30','10100','19300','11','18266','4','32','0','0','0','0','0','0','0','0','Searing Blade Cultist - Cast Curse of Agony');
--
-- Defias Squallshaper 1732
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('1732');
INSERT INTO `creature_ai_scripts` VALUES
('173201','1732','1','0','100','3','1000','1000','1800000','1800000','11','12544','0','32','0','0','0','0','0','0','0','0','Defias Squallshaper - Cast Frost Armor OOC'),
('173202','1732','9','0','100','3','0','8','23500','33500','11','122','0','1','0','0','0','0','0','0','0','0','Defias Squallshaper - Cast Frost Nova'),
('173203','1732','0','0','100','3','0','3200','8000','33000','11','2138','1','0','0','0','0','0','0','0','0','0','Defias Squallshaper - Cast Fire Blast'),
('173204','1732','27','0','100','3','12544','1','15000','30000','11','12544','0','1','0','0','0','0','0','0','0','0','Defias Squallshaper - Cast Frost Armor on Missing Buff'),
('173205','1732','2','0','100','2','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Defias Squallshaper - Flee at 15% HP');
--
-- Druid of the Fang 3840
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('3840');
INSERT INTO `creature_ai_scripts` VALUES
('384001','3840','1','0','100','2','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Prevent Combat Movement on Spawn'),
('384002','3840','4','0','100','2','0','0','0','0','11','9532','1','0','23','1','0','0','0','0','0','0','Druid of the Fang - Cast Lightning Bolt and Set Phase 1 on Aggro'),
('384003','3840','9','13','100','3','0','40','3000','3800','11','9532','1','0','0','0','0','0','0','0','0','0','Druid of the Fang - Cast Lightning Bolt (Phase 1)'),
('384004','3840','3','13','100','2','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Druid of the Fang - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('384005','3840','9','13','100','2','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Start Combat Movement at 35 Yards (Phase 1)'),
('384006','3840','9','13','100','2','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Prevent Combat Movement at 15 Yards (Phase 1)'),
('384007','3840','9','13','100','2','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Start Combat Movement Below 5 Yards (Phase 1)'),
('384008','3840','0','13','100','3','8000','11000','10000','20000','11','8040','5','33','0','0','0','0','0','0','0','0','Druid of the Fang - Cast Druid Slumber'),
('384009','3840','14','13','100','3','800','40','12000','18000','11','5187','6','1','0','0','0','0','0','0','0','0','Druid of the Fang - Cast Healing Touch on Friendlies (Phase 1)'),
('384010','3840','3','11','100','3','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Set Phase 1 when Mana is above 30% (Phase 2)'),
('384011','3840','2','0','100','3','50','0','20000','25000','11','8041','0','1','21','1','0','0','22','3','0','0','Druid of the Fang - Cast Serpent Form and Start Combat Movement and Set Phase 3 at 50% HP'),
('384012','3840','16','0','100','2','8041','5','0','0','21','1','0','0','22','1','0','0','0','0','0','0','Druid of the Fang - Prevent Combat Movement and Set Phase 1 When No Longer Serpant Form'),
('384013','3840','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Druid of the Fang - Set Phase to 0 on Evade');
--
-- Blackfathom Sea Witch 4805
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('4805');
INSERT INTO `creature_ai_scripts` VALUES
('480501','4805','1','0','100','3','1000','1000','1800000','1800000','11','12544','0','32','0','0','0','0','0','0','0','0','Blackfathom Sea Witch - Cast Frost Armor on Spawn'),
('480502','4805','9','0','100','3','0','8','16000','20000','11','122','0','1','0','0','0','0','0','0','0','0','Blackfathom Sea Witch - Cast Frost Nova'),
('480503','4805','0','0','100','2','3000','6000','0','0','11','6143','0','1','0','0','0','0','0','0','0','0','Blackfathom Sea Witch - Cast Frost Ward'),
('480504','4805','27','0','100','3','12544','1','15000','30000','11','12544','0','1','0','0','0','0','0','0','0','0','Blackfathom Sea Witch - Cast Frost Armor on Missing Buff'),
('480505','4805','2','0','100','2','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Blackfathom Sea Witch - Flee at 15% HP');
-- 4799
-- 4820 Blindlight Oracle
-- 4811 Twilight Aquamancer
-- Riverpaw Shaman
-- Leprous Defender 6223
-- Leprous Technician 6222
-- Leprous Machinesmith 6224
-- Scarlet Scryer 4293
-- Scarlet Adept 4296
-- Scarlet Diviner 4291
-- Scarlet Conjuror 4297
-- Scarlet Evoker 4289
-- Scarlet Sorcerer 4294
-- Poison Sprite 12216
-- Razorfen Geomancer 4520
-- Razorfen Handler 4530
-- Death's Head Adept 4516
-- Death Speaker Jargba <Death's Head Captain> 4428
-- Charlga Razorflank <The Crone> 4421
-- Death's Head Priest 4517
-- Death's Head Geomancer 7335
-- Withered Spearhide 7332
-- Death's Head Necromancer 7337
-- Skeletal Frostweaver 7341
-- Skeletal Summoner 7342
-- Skeletal Shadowcaster 7340
-- Revelosh 6910
-- Shadowforge Sharpshooter 7290
-- Stonevault Geomancer 4853
-- Grimlok <Stonevault Chieftain> 4854
-- Scholomance Neophyte 10470
-- Scholomance Dark Summoner 11582
-- Scholomance Necrolyte 10476
-- Scholomance Adept 10469
-- Scholomance Necromancer 10477
-- Eldreth Apparition 11471
-- Magister Kalendris 11487
-- Illyanna Ravenoak 11488
-- Fel Lash 13197
-- Wildspawn Felsworn 11455
-- Wildspawn Betrayer 11454
-- Wildspawn Hellcaller 11457
-- Pimgib 14349
-- Gordok Mage-Lord 11444
-- Gordok Warlock 11448
-- Cho'Rush the Observer 14324
-- Sandfury Shadowcaster 5648
-- Witch Doctor Zum'rah 7271
-- Sandfury Shadowhunter 7246
-- Shadowpriest Sezz'ziz 7275
-- Sandfury Acolyte 8876
-- Hydromancer Velratha 7795
-- Zerillis 10082
-- Atal'ai High Priest 5273
-- Ogom the Wretched 5711
-- Skeletal Guardian 10390
-- Risen Conjuror 10419
-- Risen Priest 10423
-- Risen Sorcerer 10422
-- Shrieking Banshee 10463
-- Thuzadin Shadowcaster 10398
-- Fireguard 8909
-- Warbringer Construct 8905
-- Shadowforge Peasant 8896
-- Doomforge Dragoon 8899
-- Weapon Technician 8920
-- Doomforge Arcanasmith 8900
-- Guzzling Patron 9547
-- Seeth'rel 9038
-- Hate'rel 9034
-- Anvilrage Reservist 8901
-- Shadowforge Flame Keeper 9956
-- Shadowforge Senator 8904
-- Scarshield Spellbinder <Scarshield Legion> 9098
-- Scarshield Warlock <Scarshield Legion> 9257
-- Spirestone Ogre Magus 9201  
-- Spirestone Lord Magus 9217
-- Smolderthorn Mystic 9239
-- Smolderthorn Seer 9269
-- Smolderthorn Headhunter 9241
-- Smolderthorn Axe Thrower 9267
-- Firebrand Invoker <Firebrand Legion> 9262
-- Firebrand Darkweaver <Firebrand Legion> 9261
-- Urok Ogre Magus 10602
-- Bloodaxe Summoner <Bloodaxe Legion> 9717
-- Bloodaxe Evoker <Bloodaxe Legion> 9693
-- Chromatic Whelp 10442
-- Blackhand Summoner <Blackhand Legion> 9818
-- Summoned Blackhand Dreadweaver <Blackhand Legion> 10680
-- Gyth <Rend Blackhand's Mount> 10339
Xadras commented 8 years ago 
#!sql
-- Bleeding Hollow Necrolyte
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1942201','1942206');
UPDATE `creature_ai_scripts` SET `event_param3`='3000' WHERE `id` IN ('1942203');

-- Bleeding Hollow Dark Shaman
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1687301','1687308');
UPDATE `creature_ai_scripts` SET `event_param3`='3000' WHERE `id` IN ('1687305');

-- Grillok "Darkeye"
UPDATE `creature_ai_scripts` SET `action1_param3`='7' WHERE `id` IN ('1945701','1945703','1945704','1945705');

-- Bonechewer Evoker
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1970101','1970106');
UPDATE `creature_ai_scripts` SET `event_param3`='3000' WHERE `id` IN ('1970103');

-- Shattered Hand Acolyte
-- still 2 quest credit
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='20',`event_chance`='100',`event_param3`='3000',`event_param4`='5000' WHERE `id` IN ('1941502');
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('1941501');
INSERT INTO `creature_ai_scripts` VALUES
('1941501','19415','1','0','100','1','2500','2500','1800000','1800000','11','13864','0','0','0','0','0','0','0','0','0','0','Shattered Hand Acolyte - Cast Power Word: Fortitude OCC');

-- Shattered Hand Mage
-- recheck quest credit
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1941301','1941306');
UPDATE `creature_ai_scripts` SET `event_param3`='3000' WHERE `id` IN ('1941303');
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('1941313');
INSERT INTO `creature_ai_scripts` VALUES
('1941313','19413','6','0','100','0','0','0','0','0','33','22334','6','0','0','0','0','0','0','0','0','0','Shattered Hand Mage - Quest Kill Credit');

-- Shattered Hand Warlock 
-- recheck quest credit
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1941101','1941107');
UPDATE `creature_ai_scripts` SET `event_param3`='3000' WHERE `id` IN ('1941104');
DELETE FROM `creature_ai_scripts` WHERE `id` IN (1941115,1941116);
INSERT INTO `creature_ai_scripts` VALUES
('1941115','19411','0','0','100','1','5000','10000','15000','30000','11','13787','0','32','0','0','0','0','0','0','0','0','Shattered Hand Warlock - Cast Demon Armor on Missing Buff'),
('1941116','19411','6','0','100','0','0','0','0','0','33','22334','6','0','0','0','0','0','0','0','0','0','Shattered Hand Warlock - Quest Kill Credit');
Xadras commented 8 years ago

Original comment by Jawohl (Bitbucket: Jawohl, GitHub: Jawohl):

Bleeding Hollow Necrolyte -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast interruption does not cause 6sec spell school block --> Causing mobs not to follow obviously, since they start to re-cast. ( Zeth'Gor )

Bleeding Hollow Dark Shaman -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast interruption does not cause 6sec spell school block --> Causing mobs not to follow obviously, since they start to re-cast. ( Zeth'Gor )

Grillok " Darkeye " -- Not casting, unable to pathfind properly ( Zeth'Gor)

Unyielding Sorcerer ( Expedition Armory )

Bonechewer Evoker -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast Interruption does not cause 6sec spell lock --> Causing mobs not to follow obviously, since they start to re-cast. ( Hellfire Peninsula - Path of Glory )

Shattered Hand Acolyte -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast Interruption does not cause 6sec spell lock --> Causing mobs not to follow obviously, since they start to re-cast. ( Hellfire Peninsula - Southern / Northern Rampart )

Shattered Hand Mage -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast Interruption does not cause 6sec spell lock --> Causing mobs not to follow obviously, since they start to re-cast. ( Hellfire Peninsula - Southern / Northern Rampart )

Shattered Hand Warlock -- Broken Pathfinding, Hiding behind Corner causes monster to stay still doing nothing, Cast Interruption does not cause 6sec spell lock --> Causing mobs not to follow obviously, since they start to re-cast. ( Hellfire Peninsula - Path of Glory )

.... These are the Casters i have MET SO FAR in Hellfire Peninsula that follow the same bug pattern, basically its every Caster / ranger mob in Hellfire Peninsula including the Worms hiding under ground but theres very rare occasion for player to find object to hide behind for the bug to occur.

Xadras commented 8 years ago

Original comment by Anon X (Bitbucket: Anonx, GitHub: Anonx):

Yea thats because of the standard AI which someone set up, simple report the NPCs and all will get fixed. " Key Monsters " are working pretty well. :)

AdmCrunch commented 7 years ago

Other mobs with this issue

(Zone): Westfall (Mobs): Defias Magician 1726, Marisa du'Paige 599,

(Zone): The Deadmines (Mobs): Defias Taskmaster 4417

AnonXS commented 7 years ago 
-- Defias Magician 1726
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (172601,172607);
UPDATE `creature_ai_scripts` SET `event_param3`='3600',`event_param4`='4800' WHERE `id` = 172604;

-- Marisa du'Paige 599
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (59901,59906);

-- Defias Taskmaster 4417
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (441701,441706);

-- Defias Taskmaster 4417
-- They sometimes run some yards away quickly and start shooting you with their rifles in the middle of the fight.
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 4417;
INSERT INTO `creature_ai_scripts` VALUES
('441701','4417','4','0','100','2','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Defias Taskmaster - Set Phase 1 on Aggro'),
('441702','4417','0','0','100','3','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Defias Taskmaster - Start Movement and Set Melee Weapon Model'),
('441703','4417','9','0','100','3','5','30','2200','3800','11','6660','1','0','40','2','0','0','21','0','0','0','Defias Taskmaster - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
('441704','4417','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Defias Taskmaster - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 6 Yards (Phase 1)'),
('441705','4417','7','0','100','0','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Defias Taskmaster - Set Phase 1 and Set Melee Weapon Model and Start Movement on Evade'),
('441706','4417','9','0','100','3','6','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Defias Taskmaster - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)'),
('441707','4417','0','0','100','3','15000','30000','15000','30000','29','8','3.14','0','40','2','0','0','22','1','0','0','Defias Taskmaster - Start Ranged Combat Movement and Set Ranged Weapon Model and Set Phase 1'),
('441708','4417','0','1','100','3','13700','17100','32500','43500','11','6685','1','1','40','2','0','0','21','0','0','0','Defias Taskmaster - Cast Piercing Shot and Set Ranged Weapon Model and Stop Movement (Phase 1)');
Kridx commented 7 years ago

Unyielding sorcerer is still not casting any spells at all. Acting like a melee mob when it's a caster mob

https://i.gyazo.com/9e7f3dffbb47ce441ed5e3ac09aec2b9.jpg

http://www.wowhead.com/npc=16905/unyielding-sorcerer#abilities