The Mechanar - Githubissues

Xadras commented 8 years ago
Complete Dungeon Overhaul for Mechanar with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.
ToDo:
Gauntlet: 19168(4x), 19220(1x), 19510(1x), 19735(2x), 20059(1x), 20988(4x), 20990(4x)
The Mechanar (nonHc) Issues (all minor)
Final boss event: First wave spawns before you step on the bridge and you can outrange it. Additionally the third wave can be outranged as well which should not be the case. Proof: http://imgur.com/a/vw5ud
https://bitbucket.org/looking4group_b2tbc/looking4groug/src/b3a52d85414a0c5d3ea5ee74c4f10a15e74ac476/src/scripts/scripts/zone/tempest_keep/the_mechanar/boss_pathaleon_the_calculator.cpp?at=master&fileviewer=file-view-default
Core: Activate: #define SPELL_SUMMON_NETHER_WRAITH_1 35285 //Spells work, but not implemented for 4th add
Pathaleon will spawn after last wave add is killed and give the group a short time to rest before engaging. -> Auto Engaging, no reset if boss leaves boss room.
Der Channeled Spell 36348 38919 wirkt keine Heilung, scheint 0 eingetragen zu sein. der mob schlägt währenddessen weiter und läuft auch channelnd durch die gegend.
[ ] Creatures in Tempest Keep:Botanica, Tempest Keep: Mechanar, and Tempest Keep:Arcatraz no longer respawn as rapidly.
[ ] Gatewatcher Iron-Hand now wields a Jackhammer.
[ ] Gatewatcher Iron-Hand is now more vocal when performing his Jackhammer attack.
[ ] Mechanar Drillers, Wrecker, and Crushers in Tempest Keep: The Mechanar may no longer be enslaved when in Heroic mode.
http://wowwiki.wikia.com/wiki/Patch_2.0.10
[ ] Creatures in Tempest Keep: The Eye, The Arcatraz, The Mechanar, The Botanica all have a chance at dropping health and mana potions that will only function inside the Tempest Keep raid and dungeon instances.
[ ] Bloodwarder Physicians now have more mana.
[ ] Nethermancer Sepethrea will no longer break nearby players' stealth when engaged.
http://wowwiki.wikia.com/wiki/Patch_2.1.0
[ ] Tempest-Forge Destroyer are immune to Curse of Tongues, Siphon Life and Drain Life.
[ ] Nethermancer Sepethrea encounter resets if she is pulled out of her room, and can no longer be kited to Pathaleons room.
http://wowwiki.wikia.com/wiki/Patch_2.1.0_(undocumented_changes)
[ ] Nethermancer Sepethrea's Raging Flames should now periodically change their targets in Heroic mode.
http://wowwiki.wikia.com/wiki/Patch_2.1.2
[ ] Raging Flames in the Nethermancer Sepethrea encounter have had their movement speed reduced slightly in heroic mode.
[ ] The Arcane Servants summoned by Sunseeker Netherbinders are now properly classified as Arcane Elementals, deal less melee damage and have fewer hit points.
http://wowwiki.wikia.com/wiki/Patch_2.2.0
[ ] Chests in Tempest Keep: Mechanar have had their spawn locations change slightly making it very difficult to solo.
http://wowwiki.wikia.com/wiki/Patch_2.2.0_(undocumented_changes)
[ ] Nethermancer Sepethrea's Frost Attack now reduces movement speed by 25% rather than 50%.
[ ] The Cache of the Legion can now only be looted by players who are present during some portion of a successful attempt of the Gatewatcher Gyro-Kill and Gatewatcher Iron-Hand encounters.
[ ] In addition, on Heroic difficulty Gatewatcher Gyro-Kill and Gatewatcher Iron-Hand no longer drop [Badges of Justice]. Instead, the Cache of the Legion contains a Badge of Justice for each player present.
http://wowwiki.wikia.com/wiki/Patch_2.3.0
[ ] Mobs no longer reset after moving down the elevator. They can get lodged in the wall or stand at the top, making them very hard to kill and almost always impossible to loot.
http://wowwiki.wikia.com/wiki/Patch_2.3.0_(undocumented_changes)
[ ] The Mechanar: It is no longer possible to gain an additional [Badge of Justice] by bringing [Cache of the Legion keys] obtained in other copies of the instance.
http://wowwiki.wikia.com/wiki/Patch_2.4.0
Xadras commented 8 years ago
Sources:
https://github.com/Schaka/TBC-research/issues/17
http://www.wowhead.com/zone=3849/the-mechanar , http://wowwiki.wikia.com/wiki/Mechanar , http://wow.gamepedia.com/Mechanar
http://wowwiki.wikia.com/wiki/Nethermancer_Sepethrea?oldid=1555440
https://www.youtube.com/watch?v=6B518EQiyiI - Nethermancer Sepethrea - Mechanar Heroic https://www.youtube.com/watch?v=YTv9ngC5rsk - Nethermancer Sepethrea Boss Fight https://www.youtube.com/watch?v=Pxvz_Vpm5GU - Nethermancer Sepethrea
https://www.youtube.com/watch?v=hza2s52I2zs - The Mechanar dungeon guide https://www.youtube.com/watch?v=UnYVPbEHcM4 - The Mechanar part 1 https://www.youtube.com/watch?v=glGwXYYB55g&list=PLE996CCF3CB8824EE&index=90 - The Mechanar part 2
Xadras commented 8 years ago
#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/1540
-- The Mechanar 

-- ============
-- Texts & Scripts
-- ============

DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9899 AND -9897;
INSERT INTO `creature_ai_texts` VALUES
(-9899,'Any intruders must be eliminated!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-143 Tempest Keep'),
(-9898,'Protect the Mechanar at all costs!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'-145 19166'),
(-9897,'You hear a faint unlocking sound...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'-146 Mechanar Chest?');
-- (-9896,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'MechanarPlatzhalter'),

UPDATE creature_ai_texts SET content_loc3='Los, zeigt mir, was Ihr drauf habt! Ich kann was einstecken!' WHERE entry=-90;

-- =========
-- NPC Research
-- =========

-- Tempest-Forge Patroller 19166,21543
-- Calls for help. Charged Arcane Missile (causes a knockback on the target and any targets near it). Susceptible to bleed effects and Drain Life. 
UPDATE `creature_template` SET `armor`='5800',`minlevel`='69',`maxlevel`='70',`speed`='1.71',`mindmg`='2000',`maxdmg`='3000',`baseattacktime`='1400',`mechanic_immune_mask`='1' WHERE `entry` = 19166;
UPDATE `creature_template` SET `armor`='7100',`minlevel`='70',`maxlevel`='71',`speed`='1.71',`mindmg`='5845',`maxdmg`='6520',`mechanic_immune_mask`='1' WHERE `entry` = 21543; -- 
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='15' WHERE `creature_id` = 21543;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19166;
INSERT INTO `creature_ai_scripts` VALUES
('1916601','19166','1','0','25','7','30000','120000','120000','240000','1','-9899','-9898','0','0','0','0','0','0','0','0','0','Tempest-Forge Patroller - Random Say OOC'),
('1916602','19166','0','0','100','3','2000','2000','6800','9000','11','35012','1','0','0','0','0','0','0','0','0','0','Tempest-Forge Patroller (Normal) - Cast Charged Arcane Missle'),
('1916603','19166','0','0','100','5','2000','2000','6800','9000','11','38941','1','0','0','0','0','0','0','0','0','0','Tempest-Forge Patroller (Heroic) - Cast Charged Arcane Missle'),
('1916604','19166','9','0','100','7','0','5','5000','16000','11','35011','1','0','0','0','0','0','0','0','0','0','Tempest-Forge Patroller - Cast Knockdown'),
('1916605','19166','2','0','100','6','50','0','0','0','1','-551','0','0','39','25','0','0','0','0','0','0','Tempest-Forge Patroller - Emote and Call for Help at 50% HP');
UPDATE `creature` SET `position_x`='25.9286', `position_y`='1.2643', `position_z`='0.0000', `orientation`='3.1564',`spawndist`='0',`movementtype`='0' WHERE `guid` = 83198;  
UPDATE `creature` SET `movementtype`='2',`spawndist`='0' WHERE `guid` IN ('83195','83197','83189','83229');

-- Bloodwarder Physician 20990,21523
UPDATE `creature_template` SET `mindmg`='1088',`maxdmg`='1430',`equipment_id`='8001',`modelid_H`='19968',`modelid_A2`='19968',`modelid_H2`='19970' WHERE `entry` = 20990;
UPDATE `creature_template` SET `minlevel`='70',`minmana`='15400',`armor`='5450',`speed`='1.48',`pickpocketloot`='20990',`mindmg`='1843',`maxdmg`='2186',`equipment_id`='8001',`modelid_A2`='19968',`modelid_H2`='19970',`mechanic_immune_mask`='1' WHERE `entry` = 21523;
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='15' WHERE `creature_id` = 21523;
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 8001;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8001,33299,0,0,50268674,0,0,529,0,0);
-- Bandage funtzt noch nicht wenns geht erweitern
-- try spell_script_target!
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20990;
INSERT INTO `creature_ai_scripts` VALUES
('2099001','20990','0','0','100','3','4000','8400','7200','10000','11','36340','1','0','0','0','0','0','0','0','0','0','Bloodwarder Physician (Normal) - Cast Holy Shock'),
('2099002','20990','0','0','100','5','4000','8400','7200','10000','11','38921','1','0','0','0','0','0','0','0','0','0','Bloodwarder Physician (Heroic) - Cast Holy Shock'),
('2099003','20990','14','0','100','3','6300','15','10000','20000','11','36348','6','0','0','0','0','0','0','0','0','0','Bloodwarder Physician (Normal) - Cast Bandage on Friendlies'),
('2099004','20990','14','0','100','5','7100','15','10000','20000','11','38919','6','0','0','0','0','0','0','0','0','0','Bloodwarder Physician (Heroic) - Cast Bandage on Friendlies'),
('2099005','20990','9','0','100','7','0','25','5000','6000','11','36333','5','1','0','0','0','0','0','0','0','0','Bloodwarder Physician - Cast Anesthetic');

-- Bloodwarder Centurion 19510,21522
UPDATE `creature_template` SET `modelid_A`='17773',`modelid_A2`='17775',`modelid_H`='17773',`modelid_H2`='17775',`equipment_id`='8002',`mindmg`='1532',`maxdmg`='2019' WHERE `entry` = 19510; -- 467 954
UPDATE `creature_template` SET `modelid_A`='17773',`modelid_A2`='17775',`modelid_H`='17773',`modelid_H2`='17775',`speed`='1.48',`pickpocketloot`='19510',`equipment_id`='8002',`mindmg`='2397',`maxdmg`='2709' WHERE `entry` = 21522; -- 965 1589
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 8002;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8002,33236,38728,0,218171138,33490436,0,3,1038,0); -- sword shield

-- Bloodwarder Slayer 19167,21524
UPDATE `creature_template` SET `modelid_A`='17773',`modelid_A2`='17775',`modelid_H`='17773',`modelid_H2`='17775',`mindmg`='1532',`maxdmg`='2019',`equipment_id`='8003' WHERE `entry` = 19167; -- 467 954
UPDATE `creature_template` SET `modelid_A`='17773',`modelid_A2`='17775',`modelid_H`='17773',`modelid_H2`='17775',`speed`='1.48',`mindmg`='2307',`maxdmg`='2678',`equipment_id`='8003',`pickpocketloot`='19167' WHERE `entry` = 21524; -- 875 1617
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 8003;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8003,15467,0,0,33490946,0,0,256,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19167;
INSERT INTO `creature_ai_scripts` VALUES
('1916701','19167','1','0','100','6','1000','1000','10000','10000','30','1','2','3','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Random Phase on OCC'),
('1916702','19167','9','13','100','7','0','5','10900','11200','11','15708','1','0','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Mortal Strike (Phase 1)'),
('1916703','19167','4','11','100','6','0','0','0','0','11','35192','0','1','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Melt Armor Proc on Aggro (Phase 2)'),
('1916704','19167','9','11','100','7','0','5','11900','12100','11','35189','1','0','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Solar Strike (Phase 2)'),
('1916705','19167','4','7','100','6','0','0','0','0','11','35188','0','1','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Chilling Touch on Aggro (Phase 3)'),
('1916706','19167','9','7','100','7','0','5','11900','12100','11','35189','1','0','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Solar Strike (Phase 3)'),
('1916707','19167','9','0','100','7','0','5','10900','13500','11','13736','0','0','0','0','0','0','0','0','0','0','Bloodwarder Slayer - Cast Whirlwind');

-- Sunseeker Netherbinder 20059,21541
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`armor`='5450',`mindmg`='1310',`maxdmg`='1724',`equipment_id`='8004' WHERE `entry` = 20059; -- 400 814
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`armor`='5450',`speed`='1.48',`pickpocketloot`='20059',`mindmg`='1609',`maxdmg`='1900',`equipment_id`='8004' WHERE `entry` = 21541; -- 586 1168 spell1 38936 spell2 17201
DELETE FROM `creature_template_addon` WHERE `entry` IN (20059,21541);
INSERT INTO `creature_template_addon` VALUES
(20059,0,0,16908544,0,4097,0,0,''),
(21541,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20059;
INSERT INTO `creature_ai_scripts` VALUES
('2005901','20059','11','0','100','6','0','0','0','0','11','34427','0','1','0','0','0','0','0','0','0','0','Sunseeker Netherbinder - Cast Ethereal Teleport on Spawn'),
('2005902','20059','9','0','100','3','0','5','10800','13000','11','35261','0','0','0','0','0','0','0','0','0','0','Sunseeker Netherbinder (Normal) - Cast Arcane Nova'),
('2005903','20059','9','0','100','5','0','5','10800','13000','11','38936','0','0','0','0','0','0','0','0','0','0','Sunseeker Netherbinder (Heroic) - Cast Arcane Nova'),
('2005904','20059','9','0','100','3','0','25','11500','12100','11','35243','1','0','0','0','0','0','0','0','0','0','Sunseeker Netherbinder (Normal) - Cast Starfire'),
('2005905','20059','9','0','100','5','0','25','11500','12100','11','38935','1','0','0','0','0','0','0','0','0','0','Sunseeker Netherbinder (Heroic) - Cast Starfire'),
('2005906','20059','0','0','100','7','6000','12000','12000','17000','11','17201','0','0','0','0','0','0','0','0','0','0','Sunseeker Netherbinder - Cast Dispel Magic'),
-- 2 spellsummoned minios doesnt work atm therefore half timer and 1 add only
('2005907','20059','0','0','100','7','3500','4500','10000','15000','11','35251','0','33','0','0','0','0','39','15','0','0','Sunseeker Netherbinder - Summon 2 Arcane Servants and Aggro Pulse'); -- 11 35260 0 1 12 20478 0 300

-- https://bitbucket.org/Caboon/playcore-official/commits/c38a5ba2f6cc68fd83d7d0ea77f7f88d24454fbe
-- Spells
-- +    SPELL_DISPEL_MAGIC                    =   17201,
-- +    SPELL_SUMMON_ARCANE_SERVANT_NORMAL    =   35251,
-- +    SPELL_SUMMON_ARCANE_SERVANT_HEROIC    =   35260,
-- +    SPELL_ARCANE_NOVA_NORMAL              =   35261,
-- +    SPELL_ARCANE_NOVA_HEROIC              =   38936
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 8004;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(8004,35363,0,0,50268674,0,0,529,0,0);

-- Arcane Servant 20478,21521
UPDATE `creature_template` SET `minlevel`='68',`maxlevel`='69',`armor`='4200',`speed`='1.20',`mindmg`='457',`maxdmg`='603',`AIName`='EventAI' WHERE `entry` = 20478; -- 139 285
UPDATE `creature_template` SET `armor`='4450',`mindmg`='742',`maxdmg`='997' WHERE `entry` = 21521; -- 180 689
DELETE FROM `creature_template_addon` WHERE `entry` IN (20478,21521);
INSERT INTO `creature_template_addon` VALUES
(20478,0,0,16908544,0,4097,0,0,'35187 0'),
(21521,0,0,16908544,0,4097,0,0,'35191 0');
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='5' WHERE `creature_id` = 20478;
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 21521;
INSERT INTO `creature_onkill_reputation` VALUES
(21521,935,0,5,0,12,0,0,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20478;
INSERT INTO `creature_ai_scripts` VALUES
('2047801','20478','11','0','100','6','0','0','0','0','11','35259','0','1','0','0','0','0','0','0','0','0','Arcane Servant - Cast Spotlight on Spawn'),
('2047802','20478','0','0','100','7','3600','10800','4900','6500','11','35255','1','0','0','0','0','0','0','0','0','0','Arcane Servant - Cast Arcane Volley'),
('2047803','20478','6','0','100','2','0','0','0','0','11','22271','0','7','0','0','0','0','0','0','0','0','Arcane Servant - Cast Arcane Explosion on Death'),
('2047804','20478','6','0','100','4','0','0','0','0','11','22271','0','7','0','0','0','0','0','0','0','0','Arcane Servant - Cast Arcane Explosion on Death'),
('2047805','20478','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Arcane Servant - Despawn on Evade');

-- 20478 mob_arcane_servant
-- https://bitbucket.org/Caboon/playcore-official/commits/c38a5ba2f6cc68fd83d7d0ea77f7f88d24454fbe
-- +#define AURA_ARCANE_EXPLOSION_PROC_NORMAL   35187
-- +#define AURA_ARCANE_EXPLOSION_PROC_HEROIC    35191

-- Mechanar Tinkerer 19716 21531
UPDATE `creature_template` SET `maxhealth`='10500',`armor`='5500',`speed`='1.20',`mindmg`='472',`maxdmg`='622' WHERE `entry` = 19716; -- 144 294
UPDATE `creature_template` SET `armor`='5800',`speed`='1.20',`mindmg`='799',`maxdmg`='949',`pickpocketloot`='19716' WHERE `entry` = 21531; -- 144 294
DELETE FROM `creature_template_addon` WHERE `entry` IN (19716,21531);
INSERT INTO `creature_template_addon` VALUES
(19716,0,0,16908544,0,4097,0,0,''),
(21531,0,0,16908544,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='6' WHERE `creature_id` = 19716;
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='8' WHERE `creature_id` = 21531;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19716;
INSERT INTO `creature_ai_scripts` VALUES
('1971601','19716','9','0','100','3','0','20','1200','1500','11','35057','1','0','0','0','0','0','0','0','0','0','Mechanar Tinkerer (Normal) - Cast Netherbomb and Set Ranged Weapon Model'),
('1971602','19716','9','0','100','5','0','20','1200','1500','11','38925','1','0','0','0','0','0','0','0','0','0','Mechanar Tinkerer (Heroic) - Cast Netherbomb and Set Ranged Weapon Model'),
('1971603','19716','2','0','100','6','30','0','0','0','11','35062','1','7','0','0','0','0','0','0','0','0','Mechanar Tinkerer - Enable Combat Movement and Cast Maniacal Charge at 30% HP'),
('1971604','19716','2','0','100','7','15','0','1000','1000','11','35058','0','39','37','0','0','0','0','0','0','0','Mechanar Tinkerer - Cast Nether Explosion and Die at 15% HP');

-- Mechanar Crusher 19231,21527
UPDATE `creature_template` SET `mindmg`='1898',`maxdmg`='2502' WHERE `entry` = 19231; -- 578 1182
UPDATE `creature_template` SET `mindmg`='2090',`maxdmg`='2379',`speed`='1.71',`armor`='7100',`lootid`='19231',`pickpocketloot`='19231',`mechanic_immune_mask`='1' WHERE `entry` = 21527; -- 828 1406
DELETE FROM `creature_template_addon` WHERE `entry` IN (19231,21527);
INSERT INTO `creature_template_addon` VALUES
(19231,0,0,512,0,4097,0,0,''),
(21527,0,0,512,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='6',`RewOnKillRepValue1`='12' WHERE `creature_id` = 19231;
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7',`RewOnKillRepValue1`='15' WHERE `creature_id` = 21527;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19231;
INSERT INTO `creature_ai_scripts` VALUES
('1923101','19231','9','0','100','7','0','5','10000','13300','11','35055','1','0','0','0','0','0','0','0','0','0','Mechanar Crusher - Cast The Claw'),
('1923102','19231','0','0','100','3','11100','13900','11900','14900','11','35056','1','0','0','0','0','0','0','0','0','0','Mechanar Crusher (Normal) - Cast Glob of Machine Fluid'),
('1923103','19231','0','0','100','5','11100','13900','11900','14900','11','38923','1','0','0','0','0','0','0','0','0','0','Mechanar Crusher (Heroic) - Cast Glob of Machine Fluid');

-- Mechanar Driller 19712,21528
UPDATE `creature_template` SET `mindmg`='1898',`maxdmg`='2502' WHERE `entry` = 19712; -- 578 1182
UPDATE `creature_template` SET `speed`='1.71',`armor`='7100',`mindmg`='2923',`maxdmg`='3255',`lootid`='19712',`pickpocketloot`='19712',`mechanic_immune_mask`='1' WHERE `entry` = 21528; -- 1212 1877
DELETE FROM `creature_template_addon` WHERE `entry` IN (19712,21528);
INSERT INTO `creature_template_addon` VALUES
(19712,0,0,512,0,4097,0,0,''),
(21528,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19712;
INSERT INTO `creature_ai_scripts` VALUES
('1971201','19712','9','0','100','7','0','5','7200','13300','11','35047','1','0','0','0','0','0','0','0','0','0','Mechanar Driller - Cast Drill Armor'),
('1971202','19712','0','0','100','3','11100','13900','11900','14900','11','35056','1','0','0','0','0','0','0','0','0','0','Mechanar Driller (Normal) - Cast Glob of Machine Fluid'),
('1971203','19712','0','0','100','5','11100','13900','11900','14900','11','38923','1','0','0','0','0','0','0','0','0','0','Mechanar Driller (Heroic) - Cast Glob of Machine Fluid');

-- Mechanar Wrecker 19713,21532
UPDATE `creature_template` SET `mindmg`='1902',`maxdmg`='2536' WHERE `entry` = 19713; -- 571 1205
UPDATE `creature_template` SET `modelid_A`='18647',`modelid_H`='18647',`armor`='7100',`speed`='1.71',`mindmg`='2402',`maxdmg`='2777',`pickpocketloot`='19713' WHERE `entry` = 21532; -- 919 1670
DELETE FROM `creature_template_addon` WHERE `entry` IN (19713,21532);
INSERT INTO `creature_template_addon` VALUES
(19713,0,0,512,0,4097,0,0,''),
(21532,0,0,512,0,4097,0,0,'');
-- UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7',`RewOnKillRepValue1`='15' WHERE `creature_id` = 21532;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19713;
INSERT INTO `creature_ai_scripts` VALUES
('1971301','19713','9','0','100','7','0','5','10000','13300','11','35049','1','0','0','0','0','0','0','0','0','0','Mechanar Wrecker - Cast Pound'),
('1971302','19713','0','0','100','3','11100','13900','11900','14900','11','35056','1','0','0','0','0','0','0','0','0','0','Mechanar Wrecker (Normal) - Cast Glob of Machine Fluid'),
('1971303','19713','0','0','100','5','11100','13900','11900','14900','11','38923','1','0','0','0','0','0','0','0','0','0','Mechanar Wrecker (Heroic) - Cast Glob of Machine Fluid');

-- Sunseeker Astromage 19168,21539
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`speed`='1.48',`mindmg`='1360',`maxdmg`='1788' WHERE `entry` = 19168; -- 416 844
UPDATE `creature_template` SET `modelid_A`='17916',`modelid_A2`='17918',`modelid_H`='17916',`modelid_H2`='17918',`armor`='5700',`speed`='1.48',`mindmg`='1567',`maxdmg`='1784',`pickpocketloot`='19168' WHERE `entry` = 21539; -- 620 1055 spell1 38933 spell2 17195 spell3 38930
DELETE FROM `creature_template_addon` WHERE `entry` IN (19168,21539);
INSERT INTO `creature_template_addon` VALUES
(19168,0,0,16908544,0,4097,0,0,'35265 0'),
(21539,0,0,16908544,0,4097,0,0,'38933 0');
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7',`RewOnKillRepValue1`='15' WHERE `creature_id` = 21539;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19168;
INSERT INTO `creature_ai_scripts` VALUES
('1916801','19168','0','0','100','3','4800','8100','5000','8000','11','35265','0','32','0','0','0','0','0','0','0','0','Sunseeker Astromage (Normal) - Cast Fire Shield'),
('1916802','19168','0','0','100','5','4800','8100','5000','8000','11','38933','0','32','0','0','0','0','0','0','0','0','Sunseeker Astromage (Heroic) - Cast Fire Shield'),
('1916803','19168','0','0','100','3','5100','7600','6100','9500','11','17195','1','0','0','0','0','0','0','0','0','0','Sunseeker Astromage (Normal) - Cast Scorch'),
('1916804','19168','0','0','100','5','5100','7600','6100','9500','11','36807','1','0','0','0','0','0','0','0','0','0','Sunseeker Astromage (Heroic) - Cast Scorch'),
('1916805','19168','9','0','100','3','0','30','10200','14200','11','35267','1','1','0','0','0','0','0','0','0','0','Sunseeker Astromage (Normal) - Cast Solar Burn'),
('1916806','19168','9','0','100','5','0','30','10200','14200','11','38930','1','1','0','0','0','0','0','0','0','0','Sunseeker Astromage (Heroic) - Cast Solar Burn');

-- Sunseeker Engineer 20988,21540
UPDATE `creature_template` SET `modelid_A`='19966',`modelid_A2`='19968',`modelid_H`='19966',`modelid_H2`='19968',`speed`='1.48',`mindmg`='1360',`maxdmg`='1788' WHERE `entry` = 20988; -- 416 844
UPDATE `creature_template` SET `modelid_A`='19966',`modelid_A2`='19968',`modelid_H`='19966',`modelid_H2`='19968',`armor`='5450',`speed`='1.48',`pickpocketloot`='20988',`mindmg`='2125',`maxdmg`='2406' WHERE `entry` = 21540; -- 851 1414 spell1 39196 spell2 36346 spell3 36341
DELETE FROM `creature_template_addon` WHERE `entry` IN (20988,21540);
INSERT INTO `creature_template_addon` VALUES
(20988,0,0,16908544,0,4097,0,0,''),
(21540,0,0,16908544,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7',`RewOnKillRepValue1`='15' WHERE `creature_id` = 21540;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20988;
INSERT INTO `creature_ai_scripts` VALUES
('2098801','20988','9','0','100','7','0','30','10000','12000','11','36341','1','0','0','0','0','0','0','0','0','0','Sunseeker Engineer - Cast Super Shrink Ray'),
('2098802','20988','9','0','100','3','0','20','8000','10000','11','36345','1','0','0','0','0','0','0','0','0','0','Sunseeker Engineer (Normal) - Cast Death Ray'),
('2098803','20988','9','0','100','5','0','20','5000','8000','11','39196','1','0','0','0','0','0','0','0','0','0','Sunseeker Engineer (Heroic) - Cast Death Ray'),
('2098804','20988','16','0','100','7','36346','30','14000','16000','11','36346','6','32','0','0','0','0','0','0','0','0','Sunseeker Engineer - Cast Growth Ray on Friendlies');

-- Tempest-Forge Destroyer 19735,21542
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`armor`='6800',`mindmg`='3000',`maxdmg`='4000',`mechanic_immune_mask`='1' WHERE `entry` = 19735; -- 209 209
UPDATE `creature_template` SET `armor`='7100',`speed`='1.71',`mindmg`='6765',`maxdmg`='7303',`lootid`='19735',`mechanic_immune_mask`='1'  WHERE `entry` = 21542; -- 1490 2028
DELETE FROM `creature_template_addon` WHERE `entry` IN (19735,21542);
INSERT INTO `creature_template_addon` VALUES
(19735,0,0,512,0,4097,0,0,''),
(21542,0,0,512,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='7',`RewOnKillRepValue1`='15' WHERE `creature_id` = 21542;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19735;
INSERT INTO `creature_ai_scripts` VALUES
('1973501','19735','9','0','100','7','0','5','10000','10900','11','35783','1','0','0','0','0','0','0','0','0','0','Tempest-Forge Destroyer - Cast Knockdown'),
('1973502','19735','0','0','100','7','4400','10000','9600','10400','11','36582','0','0','0','0','0','0','0','0','0','0','Tempest-Forge Destroyer - Cast Charged Fist');

-- ====================
-- Bosses
-- ====================

-- bosse eig 70 auf nh

-- Gatewatcher Gyro-Kill 19218,21525
UPDATE `creature_template` SET `mindmg`='1500',`maxdmg`='2500',`flags_extra`='1',`mechanic_immune_mask`='1072644095' WHERE `entry` = 19218; -- 829 1695
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2500',`maxdmg`='3000',`pickpocketloot`='19218',`flags_extra`='1',`mechanic_immune_mask`='1072644095' WHERE `entry` = 21525; -- 1054 1754 -- 

-- Gatewatcher Iron-Hand 19710,21526
UPDATE `creature_template` SET `mindmg`='2722',`maxdmg`='3588',`mechanic_immune_mask`='1072644095' WHERE `entry` = 19710; -- 829 1695
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2500',`maxdmg`='3000',`pickpocketloot`='19710',`flags_extra`='1',`mechanic_immune_mask`='1072644095' WHERE `entry` = 21526; -- 1054 1754 -- 

--

-- Mechano-Lord Capacitus 19219,21533
UPDATE `creature_template` SET `flags_extra`='1',`mindmg`='2722',`maxdmg`='3588',`mechanic_immune_mask`='787431423' WHERE `entry` = 19219; -- 
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='4148',`maxdmg`='4800',`pickpocketloot`='19219',`mechanic_immune_mask`='787431423' WHERE `entry` = 21533;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19219;
INSERT INTO `creature_ai_scripts` VALUES
('1921901','19219','4','0','100','6','0','0','0','0','1','-87','0','0','34','5','1','0','0','0','0','0','Mechano-Lord Capacitus - Yell on Aggro and Set INST_DATA'),
('1921902','19219','9','0','100','7','0','5','10000','15000','11','35161','1','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus - Cast Head Crack'),
('1921903','19219','0','0','100','3','2000','4000','2500','7500','12','20405','4','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus (Normal) - Summon Nether Charge'),
('1921904','19219','0','0','100','5','5000','10000','5000','10000','12','20405','4','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus (Heroic) - Summon Nether Charge'),
('1921905','19219','0','0','100','3','15000','15000','40000','40000','11','35159','0','1','1','-90','-91','0','0','0','0','0','Mechano-Lord Capacitus (Normal) - Cast Reflective Damage Shield and Random Yell'),
('1921906','19219','0','0','100','3','30000','30000','40000','40000','11','35158','0','1','1','-90','-91','0','0','0','0','0','Mechano-Lord Capacitus (Normal) - Cast Reflective Magic Shield and Random Yell'),
('1921907','19219','0','0','100','5','24500','29700','25000','30000','11','39096','0','1','1','-90','-91','0','0','0','0','0','Mechano-Lord Capacitus (Heroic) - Cast Polarity Shift and Random Yell'),
('1921908','19219','0','0','100','5','180000','180000','1200','1200','11','26662','0','1','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus (Heroic) - Cast Berserk after 3 Minutes'),
('1921909','19219','5','0','100','7','0','0','0','0','1','-88','-92','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus - Random Yell on Player Kill'),
('1921910','19219','6','0','100','6','0','0','0','0','1','-89','0','0','34','5','3','0','0','0','0','0','Mechano-Lord Capacitus - Yell on Death and Set INST_DATA'),
('1921911','19219','7','0','100','6','0','0','0','0','34','5','0','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus - Set INST_DATA on Evade'),
('1921912','19219','0','0','100','7','0','0','0','0','39','10','0','0','0','0','0','0','0','0','0','0','Mechano-Lord Capacitus - Aggro Pulse');

-- Nether Charge 20405,21534 
UPDATE `creature_template` SET `heroic_entry`='21534',`minlevel`='72',`maxlevel`='72',`minhealth`='10000',`maxhealth`='10000',`armor`='7400',`speed`='0.70',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='33554688',`mechanic_immune_mask`='787431423' WHERE `entry` = 20405;
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`minhealth`='10000',`maxhealth`='10000',`armor`='7400',`speed`='0.70',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='33554688',`mechanic_immune_mask`='787431423' WHERE `entry` = 21534;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20405;
INSERT INTO `creature_ai_scripts` VALUES
('2040501','20405','11','0','100','6','0','0','0','0','11','35150','0','0','11','37670','0','0','41','18000','0','0','Nether Charge - Cast Nether Charge Passive and Cast Nether Charge Timer on Spawn'),
('2040502','20405','0','0','100','7','11000','11000','1000','1000','21','0','0','0','11','35151','0','1','20','0','0','0','Nether Charge - Prevent Combat Movement and Prevent Melee and Cast Nether Charge Pulse'),
('2040503','20405','0','0','100','6','13000','13000','0','0','11','35151','0','1','0','0','0','0','0','0','0','0','Nether Charge - Cast Nether Charge Pulse'),
('2040504','20405','0','0','100','6','15000','15000','0','0','11','35151','0','1','0','0','0','0','0','0','0','0','Nether Charge - Cast Nether Charge Pulse'),
('2040505','20405','0','0','100','6','17000','17000','0','0','11','35152','0','1','0','0','0','0','0','0','0','0','Nether Charge - Cast Unknown Spell (From Sniff Data)');
-- ('2040506','20405','0','0','100','6','18000','18000','0','0','11','7','0','1','0','0','0','0','0','0','0','0','Nether Charge - Kill Self');
DELETE FROM `creature_template_addon` WHERE `entry` = 21534;
INSERT INTO `creature_template_addon` VALUES
(21534,0,0,0,0,0,0,0,'35150 0');

-- Nethermancer Sepethrea  19221,21536
-- Basic Melee: ~1500 on plate. 
UPDATE `creature_template` SET `minhealth`='124650',`maxhealth`='124650',`mindmg`='800',`maxdmg`='1200',`mechanic_immune_mask`='787431423' WHERE `entry` = 19221; -- 97400!/124650? -- 174650 hg
UPDATE `creature_template` SET `minhealth`='200920',`maxhealth`='200920',`speed`='1.71',`mindmg`='1982',`maxdmg`='2345',`pickpocketloot`='19221',`mechanic_immune_mask`='787431423' WHERE `entry` = 21536; -- 131489!/200920? -- 250920 

-- Raging Flames 20481,21538- mob_ragin_flames
-- Not only is there a third add but they move a ton faster and were hitting on cloth for about 1500.
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`speed`='0.50',`mindmg`='500',`maxdmg`='750',`dmgschool`='2', `resistance1` = -1, `resistance2` = -1, `resistance3` = -1, `resistance4` = -1, `resistance5` = -1, `resistance6` = -1, `AIName` = '', `ScriptName` = 'mob_ragin_flames' WHERE `entry` = 20481; -- 70 70 1.71 212 212
UPDATE `creature_template` SET `speed`='0.80',`mindmg`='1250',`maxdmg`='1500',`dmgschool`='2', `resistance1` = -1, `resistance2` = -1, `resistance3` = -1, `resistance4` = -1, `resistance5` = -1, `resistance6` = -1 WHERE `entry` = 21538; -- 1.2 520 800
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20481;
-- INSERT INTO `creature_ai_scripts` VALUES
-- ('2048101','20481','4','0','100','6','0','0','0','0','11','35278','0','7','0','0','0','0','0','0','0','0','Raging Flames - Cast Raging Flames on Aggro'),
-- ('2048102','20481','0','0','100','3','15700','31300','15700','28900','11','35268','0','0','14','-99','0','0','13','100','4','0','Raging Flames (Normal) - Cast Inferno and Drop Aggro and Take on New Target'),
-- ('2048103','20481','0','0','100','5','15700','31300','15700','28900','11','39346','0','0','14','-99','0','0','13','100','4','0','Raging Flames (Heroic) - Cast Inferno and Drop Aggro and Take on New Target');

--

-- Pathaleon the Calculator 19220,21537
-- Other than that, he will melee the main tank and does not hit incredibly hard. -> more than Nethermancer Sepethrea cuz last boss
UPDATE `creature_template` SET `mindmg`='1400',`maxdmg`='2200',`mechanic_immune_mask`='787431423',`equipment_id`='8002' WHERE `entry` = 19220; --
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='5266 ',`maxdmg`='5966',`pickpocketloot`='19220',`mechanic_immune_mask`='787431423',`equipment_id`='8002' WHERE `entry` = 21537; -- 1054 1754

-- Nether Wraith 21062,21535
UPDATE `creature_template` SET `maxhealth`='8854',`minmana`='3155',`maxmana`='3155',`speed`='1.20',`mindmg`='366',`maxdmg`='482' WHERE `entry` = 21062; -- 139 285
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`armor`='5950',`mindmg`='639',`maxdmg`='759' WHERE `entry` = 21535; -- 144 294
-- no rep from summoned adds
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` IN (21062,21535,20481);

-- =======================
-- Movement & Visuals
-- =======================

DELETE FROM `creature_addon` WHERE `guid` IN (83162,83163,83166,83167,83170,83171,83182,83183,83200,83201,83202,83203,83209,83210,83211,83212,83219,83220,83222,83223);
INSERT INTO `creature_addon` VALUES
(83162,0,0,0,0,4097,28,0,''),
(83163,0,0,0,0,4097,28,0,''),
(83166,0,0,0,0,4097,28,0,''),
(83167,0,0,0,0,4097,28,0,''),
(83170,0,0,0,0,4097,28,0,''),
(83171,0,0,0,0,4097,28,0,''),
(83182,0,0,0,0,4097,28,0,''),
(83183,0,0,0,0,4097,28,0,''),
(83200,0,0,0,0,4097,28,0,''),
(83201,0,0,0,0,4097,28,0,''),
(83202,0,0,0,0,4097,28,0,''),
(83203,0,0,0,0,4097,28,0,''),
(83209,0,0,0,0,4097,28,0,''),
(83210,0,0,0,0,4097,28,0,''),
(83211,0,0,0,0,4097,28,0,''),
(83212,0,0,0,0,4097,28,0,''),
(83219,0,0,0,0,4097,28,0,''),
(83220,0,0,0,0,4097,28,0,''),
(83222,0,0,0,0,4097,28,0,''),
(83223,0,0,0,0,4097,28,0,'');
-- (GUID,0,0,0,0,4097,28,0,''),

-- movement

UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid IN (83205,83204,83199,83161,87087);
UPDATE creature SET position_x = '131.177628', position_y = '40.859821', position_z = '0.007842', orientation = '1.005482',Spawndist=3, MovementType=1 WHERE guid = 83164;
UPDATE creature SET Spawndist=0, MovementType=0,`position_x`='89.4443',`position_y`='24.2701',`position_z`='14.9247',`orientation`='0.79717' WHERE guid = 83239; 
-- boom
UPDATE creature SET Spawndist=8, MovementType=1,position_x = '291.911', position_y = '30.5269', position_z = '25.3862', orientation = '1.54016' WHERE guid = '83233';
UPDATE creature SET Spawndist=8, MovementType=1,position_x = '295.365295', position_y = '-23.752296', position_z = '25.386166', orientation = '1.812110' WHERE guid = '83234';
UPDATE `creature` SET `position_x`='224.0076', `position_y`='-91.1133', `position_z`='0.0000', `orientation`='1.5662' WHERE `guid` = 83209;

SET @NPC := 83197;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 30.412413,16.788836,0.000004,0,0,0,100,0),
(@PATH,2, 36.220158,25.138645,0.004621,0,0,0,100,0),
(@PATH,3, 40.694798,29.127783,0.004768,0,0,0,100,0),
(@PATH,4, 45.805305,31.141100,0.001092,0,0,0,100,0),
(@PATH,5, 44.015568,30.612194,-0.000453,6500,0,0,100,0),
-- waypoint waittime
(@PATH,6, 39.310558,29.368536,0.006656,0,0,0,100,0),
(@PATH,7, 32.127644,20.360249,0.000805,0,0,0,100,0),
(@PATH,8, 28.386742,11.934106,-0.000624,0,0,0,100,0),
(@PATH,9, 23.5712,9.1859,0.0000,9700,0,0,100,0);
-- wayoint waittime

SET @NPC := 83195;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 30.826485,-14.130724,-0.000624,0,0,0,100,0),
(@PATH,2, 38.110409,-23.433033,0.001603,0,0,0,100,0),
(@PATH,3, 40.605125,-24.640640,0.006674,0,0,0,100,0),
(@PATH,4, 44.810520,-26.274139,0.007961,0,0,0,100,0),
(@PATH,5, 43.838703,-25.854248,0.007961,7000,0,0,100,0),
-- waypoint waittime
(@PATH,6, 39.890831,-25.479780,0.006565,0,0,0,100,0),
(@PATH,7, 31.973940,-15.707380,-0.000693,0,0,0,100,0),
(@PATH,8, 27.719234,-9.830593,-0.000693,0,0,0,100,0),
(@PATH,9, 23.979473,-6.516403,-0.000693,10000,0,0,100,0);
-- waypoint waittime

SET @NPC := 83189;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 31.522797,40.752026,0.010816,3000,0,0,100,0),
-- waypoint waittime
(@PATH,2, 30.842739,54.284309,0.161750,0,0,0,100,0),
(@PATH,3, 34.066273,59.263588,0.161750,0,0,0,100,0),
(@PATH,4, 43.226204,59.598656,1.907646,5000,0,0,100,0),
-- waypoint waittime
(@PATH,5, 77.777420,59.946453,14.924679,0,0,0,100,0),
(@PATH,6, 43.765900,59.991734,2.115064,0,0,0,100,0),
(@PATH,7, 34.121117,59.838612,0.163070,0,0,0,100,0),
(@PATH,8, 30.854591,55.892593,0.163070,0,0,0,100,0);

SET @NPC := 83229;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 32.364780,-36.320389,0.012541,3000,0,0,100,0),
-- waypoint waittime
(@PATH,2, 31.340508,-52.536175,0.161877,0,0,0,100,0),
(@PATH,3, 34.967564,-56.532352,0.161877,0,0,0,100,0),
(@PATH,4, 44.134144,-56.400688,2.256888,5000,0,0,100,0),
-- waypoint waittime
(@PATH,5, 77.792725,-56.561775,14.924669,0,0,0,100,0),
(@PATH,6, 52.576408,-55.619606,5.768441,0,0,0,100,0),
(@PATH,7, 34.518326,-56.106770,0.163073,0,0,0,100,0),
(@PATH,8, 30.980734,-49.934277,0.163073,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83224;
SET @NPC := 83224;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 99.881767,-54.005016,14.925436,0,0,0,100,0),
(@PATH,2, 103.471436,-61.750763,14.925436,0,0,0,100,0),
(@PATH,3, 103.371628,-72.745293,14.926078,0,0,0,100,0),
(@PATH,4, 100.888191,-76.364113,14.926305,25000,0,0,100,0),
(@PATH,5, 104.719116,-70.519615,14.926305,0,0,0,100,0),
(@PATH,6, 100.447876,-48.726372,14.924889,0,0,0,100,0),
(@PATH,7, 101.485870,-38.418503,14.924889,0,0,0,100,0),
(@PATH,8, 107.033684,-19.532484,14.924889,0,0,0,100,0),
(@PATH,9, 100.549118,-33.546970,14.924889,0,0,0,100,0),
(@PATH,10, 99.185951,-44.549625,14.924889,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83221;
SET @NPC := 83221;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 105.541664,-76.030334,14.926203,0,0,0,100,0),
(@PATH,2, 105.907463,-80.626686,14.927241,0,0,0,100,0),
(@PATH,3, 105.469017,-75.875488,14.927241,0,0,0,100,0),
(@PATH,4, 102.454506,-73.001167,14.927241,0,0,0,100,0),
(@PATH,5, 95.037025,-71.383080,14.927241,0,0,0,100,0),
(@PATH,6, 91.062798,-72.778725,14.925817,0,0,0,100,0),
(@PATH,7, 96.733337,-71.023415,14.925817,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2,`position_x`='176.955',`position_y`='-77.0281',`position_z`='0.005777',`orientation`='1.00923' WHERE guid = 83240;
SET @NPC := 83240;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 203.509796,-78.732452,0.003570,0,0,0,100,0),
(@PATH,2, 167.854065,-77.111694,1.042257,0,0,0,100,0),
(@PATH,3, 118.427399,-73.824837,14.926277,0,0,0,100,0),
(@PATH,4, 171.947784,-77.088531,0.004957,0,0,0,100,0);

UPDATE creature SET Spawndist=3, MovementType=1 WHERE guid = 83207;

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83208;
SET @NPC := 83208;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 226.707336,-109.535568,-0.006930,0,1,0,100,0),
(@PATH,2, 207.090210,-95.417854,-0.000968,0,1,0,100,0),
(@PATH,3, 204.143082,-88.258736,0.000499,0,1,0,100,0),
(@PATH,4, 206.055771,-76.719559,0.001450,0,1,0,100,0),
(@PATH,5, 213.491028,-69.769669,0.001450,0,1,0,100,0),
(@PATH,6, 220.044479,-69.263107,0.001450,0,1,0,100,0),
(@PATH,7, 212.019775,-69.871193,0.001450,0,1,0,100,0),
(@PATH,8, 205.587433,-76.048233,0.001631,0,1,0,100,0),
(@PATH,9, 202.411667,-87.217392,0.001631,0,1,0,100,0),
(@PATH,10, 203.795670,-92.609741,0.001631,0,1,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83213;
SET @NPC := 83213;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 224.938416,-55.702831,0.000941,0,0,0,100,0),
(@PATH,2, 229.919647,-57.626045,0.006562,0,0,0,100,0),
(@PATH,3, 224.517746,-55.831520,0.001421,0,0,0,100,0),
(@PATH,4, 217.022369,-59.497818,0.001421,0,0,0,100,0),
(@PATH,5, 214.244583,-63.656807,0.001421,0,0,0,100,0),
(@PATH,6, 213.930435,-67.416534,0.001421,0,0,0,100,0),
(@PATH,7, 214.230560,-61.333935,0.001421,0,0,0,100,0),
(@PATH,8, 220.343903,-55.360817,0.001421,0,0,0,100,0),
(@PATH,9, 225.221817,-55.463398,0.001421,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83165;
SET @NPC := 83165;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 161.706573,53.282810,0.002310,0,0,0,100,0),
(@PATH,2, 161.060913,59.076488,0.002684,0,0,0,100,0),
(@PATH,3, 160.107513,51.911293,0.002794,0,0,0,100,0),
(@PATH,4, 150.199112,46.691360,0.005608,0,0,0,100,0),
(@PATH,5, 142.633331,46.352474,0.007714,0,0,0,100,0),
(@PATH,6, 137.854980,38.167126,0.006300,0,0,0,100,0),
(@PATH,7, 131.464996,37.728703,0.004902,0,0,0,100,0),
(@PATH,8, 139.445343,39.673992,0.005337,0,0,0,100,0),
(@PATH,9, 143.096222,45.951504,0.007527,0,0,0,100,0),
(@PATH,10, 151.936371,47.027950,0.007527,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83168;
SET @NPC := 83168;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 199.667145,41.566208,-0.006497,0,0,0,100,0),
(@PATH,2, 201.486237,38.811203,-0.006497,0,0,0,100,0),
(@PATH,3, 198.420441,41.301003,-0.006497,0,0,0,100,0),
(@PATH,4, 177.188675,38.745346,-0.006497,0,0,0,100,0),
(@PATH,5, 175.856964,36.210339,1.010475,0,0,0,100,0),
(@PATH,6, 180.795578,39.218742,-0.006297,0,0,0,100,0),
(@PATH,7, 191.441925,40.948536,-0.006297,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83180;
SET @NPC := 83180;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 98.721977,51.839466,14.925819,0,0,0,100,0),
(@PATH,2, 104.441872,42.031506,14.925819,0,0,0,100,0),
(@PATH,3, 114.305786,38.485058,14.925819,0,0,0,100,0),
(@PATH,4, 105.319809,41.786606,14.925819,0,0,0,100,0),
(@PATH,5, 100.334404,50.523270,14.925819,0,0,0,100,0),
(@PATH,6, 102.819885,64.991608,14.922036,0,0,0,100,0),
(@PATH,7, 114.836563,73.296341,14.922540,0,0,0,100,0),
(@PATH,8, 103.302742,64.102264,14.920649,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83177;
SET @NPC := 83177;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 119.042442,78.411469,14.930287,0,0,0,100,0),
(@PATH,2, 173.877182,78.911194,0.003358,0,0,0,100,0),
(@PATH,3, 185.382538,69.350937,-0.005670,0,0,0,100,0),
(@PATH,4, 186.104767,50.859516,-0.005670,0,0,0,100,0),
(@PATH,5, 181.486160,47.454895,-0.005670,0,0,0,100,0),
(@PATH,6, 162.611740,47.148445,-0.003422,0,0,0,100,0),
(@PATH,7, 183.524628,47.419853,-0.006211,0,0,0,100,0),
(@PATH,8, 188.253357,53.326355,-0.006211,0,0,0,100,0),
(@PATH,9, 187.457611,68.593544,-0.006211,0,0,0,100,0),
(@PATH,10, 168.656601,80.567276,0.781544,0,0,0,100,0);

UPDATE creature SET Spawndist=0, MovementType=2 WHERE guid = 83173;
SET @NPC := 83173;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1, 191.8420,51.7363,-0.0055,0,0,0,100,0),
(@PATH,2, 225.529556,52.278435,-0.005581,0,0,0,100,0),
(@PATH,3, 244.322769,52.261787,0.180044,0,0,0,100,0),
(@PATH,4, 227.569061,52.611259,-0.002380,0,0,0,100,0);

-- gtl
UPDATE `creature` SET `position_x`='169.4451', `position_y`='71.1469', `position_z`='0.5139', `orientation`='3.1164',`spawndist`='0',`movementtype`='0' WHERE `guid` = 83176; 
UPDATE `creature` SET `position_x`='165.9649', `position_y`='84.1321', `position_z`='1.6047', `orientation`='3.1164',`spawndist`='0',`movementtype`='0' WHERE `guid` = 83175;
-- gtr
UPDATE `creature` SET `position_x`='169.0426', `position_y`='-78.0496', `position_z`='0.6619', `orientation`='3.1276',`spawndist`='0',`movementtype`='0' WHERE `guid` = 83216;

-- formations

DELETE FROM `creature_formations` WHERE `leaderguid` IN (83202,83203,83204,83205,4989305,83235,83236,4989311,4989307,83232,4989309,83231,83172,83169,83174,83175,83176,83178,83179,83182,87087,83183,83180,83170,83171,83168,83201,83164,83165,83166,83167,83200,83161,83162,83163,83199,83211,83212,83213,83207,83208,83209,83210,83215,83214,83216,83218,83217,83219,83220,83221,83222,83223,83224,83186,83185,83225,83226,83187,83188,83227,83228,83190,83191,83192,83193,83194,83196);
DELETE FROM `creature_formations` WHERE `memberguid` IN (83202,83203,83204,83205,4989305,83235,83236,4989311,4989307,83232,4989309,83231,83172,83169,83174,83175,83176,83178,83179,83182,87087,83183,83180,83170,83171,83168,83201,83164,83165,83166,83167,83200,83161,83162,83163,83199,83211,83212,83213,83207,83208,83209,83210,83215,83214,83216,83218,83217,83219,83220,83221,83222,83223,83224,83186,83185,83225,83226,83187,83188,83227,83228,83190,83191,83192,83193,83194,83196);
INSERT INTO `creature_formations` VALUES

(4989305,4989305,100,360,2),
(4989305,83235,100,360,2),
(4989305,83236,100,360,2),
(4989305,4989311,100,360,2),
--
(4989307,4989307,100,360,2),
(4989307,83232,100,360,2),
(4989307,4989309,100,360,2),
(4989307,83231,100,360,2),
--
(83169,83169,100,360,2),
(83169,83172,100,360,2),
-- 
(83174,83174,100,360,2),
(83174,83175,100,360,2),
(83174,83176,100,360,2),
--
(83178,83178,100,360,2),
(83178,83179,100,360,2),
--  
(83183,83183,100,360,2),
(83183,83182,100,360,2),
(83183,83180,100,360,2),
(83183,87087,100,360,2),
--
(83201,83201,100,360,2),
(83201,83168,100,360,2),
(83201,83170,100,360,2),
(83201,83171,100,360,2),
--
(83200,83200,100,360,2),
(83200,83167,100,360,2),
(83200,83166,100,360,2),
(83200,83165,100,360,2),
(83200,83164,100,360,2),
--
(83161,83161,100,360,2),
(83161,83162,100,360,2),
(83161,83163,100,360,2),
(83161,83199,100,360,2),
--
(83202,83202,100,360,2),
(83202,83203,100,360,2),
(83202,83204,100,360,2),
(83202,83205,100,360,2),
--
(83211,83211,100,360,2),
(83211,83212,100,360,2),
(83211,83213,100,360,2),
--
(83210,83210,100,360,2),
(83210,83209,100,360,2),
(83210,83208,100,360,2),
(83210,83207,100,360,2),
--
(83214,83214,100,360,2),
(83214,83215,100,360,2),
(83214,83216,100,360,2),
--
(83218,83218,100,360,2),
(83218,83217,100,360,2),
-- 
(83219,83219,100,360,2),
(83219,83220,100,360,2),
(83219,83221,100,360,2),
--
(83222,83222,100,360,2),
(83222,83223,100,360,2),
(83222,83224,100,360,2),
--
(83186,83186,100,360,2),
(83186,83185,100,360,2),
--
(83225,83225,100,360,2),
(83225,83226,100,360,2),
--
(83187,83187,100,360,2),
(83187,83188,100,360,2),
-- 
(83227,83227,100,360,2),
(83227,83228,100,360,2),
--
(83190,83190,100,360,2),
(83190,83191,100,360,2),
(83190,83192,100,360,2),
--
(83193,83193,100,360,2),
(83193,83194,100,360,2),
(83193,83196,100,360,2);
Looking4Group / L4G_Core

The Mechanar #1540
