Blood Furnace

[Xadras]

Complete Dungeon Overhaul for The Blood Furnace with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

---

ToDo:

• Second Boss

---

• [ ] Shadowmoon Adepts on Heroic now double attack instead of triple attack on occasion.
• [x] Laughing Skull Legionnaire no longer uses the Sweeping Strikes ability.
• [x] Shadowmoon Technician's Silence spell is used less frequently.
• [ ] Laughing Skull Warden will stay engaged with his main target on Heroic difficulty.
• [ ] The Maker's Exploding Beaker damage and knockback radii have changed for consistency to both be 8 yards.
• [ ] The Maker's Exploding Beaker damage has been increased on Heroic difficulty.
• [ ] Shadowmoon Technician's Throw Dynamite ability damage has been increased.
• [ ] Nascent Fel Orc will Dual Wield properly now.
• [ ] Keli'dan the Breaker's Shadow Bolt Volley has had both its damage and range increased
• [ ] Shadowmoon Channeler's Mark of Shadow will have a longer delay before being cast at the start of the fight and now does more damage.
• [ ] Felguard Annihilators and Felguard Brutes will now do less damage.

http://wowwiki.wikia.com/wiki/Patch_2.1.0

---

[Xadras]

Sources:

https://github.com/Schaka/TBC-research/issues/2

https://www.youtube.com/watch?v=A25kUo5ybVg

https://www.youtube.com/watch?v=jZ-uACiYgdA

https://www.youtube.com/watch?v=0OuDI4ga6Ww

https://www.youtube.com/watch?v=2FdbwuTyL-M

https://www.youtube.com/watch?v=HNEvRP5QDT4

https://www.youtube.com/watch?v=WD54MiZFE0U

[Xadras]

-- Broggok Poison Cloud 17662,18602
-- Change 30915 and 38463 Radius to 1 from 12 and make it scale with modelsize
-- UPDATE `creature_template` SET `faction_A` = 45, `faction_H` = 45, `heroic_entry` = 18602,`scale` = 3, `unit_flags` = 4, `ScriptName` = '', `AIName` = 'EventAI' WHERE `entry` = 17662; -- 1 spell1 30914 mob_broggok_poisoncloud
-- UPDATE `creature_template` SET `faction_A` = 45, `faction_H` = 45, `minlevel` = 70, `maxlevel` = 70, `scale` = 3, `unit_flags` = 4, `spell1` = 38462, `flags_extra` = 128 WHERE `entry` = 18602; -- 1
-- DELETE FROM `creature_template_addon` WHERE `entry` = 18602;
-- INSERT INTO `creature_template_addon` VALUES (18602, 0, 0, 0, 0, 0, 0, 0, '38462 0'); -- 
-- DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17662;
-- INSERT INTO `creature_ai_scripts` VALUES
-- ('1766201','17662','0','0','100','7','2000','2000','2000','2000','11','31671','0','7','21','0','0','0','20','0','0','0','Broggok Poison Cloud - Cast Growth OOC'),
-- ('1766202','17662','0','0','100','6','60000','60000','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Broggok Poison Cloud - Despawn OOC');

-- ===================================
-- Hellfire Citadel: The Blood Furnace
-- ===================================
-- Laughing Skull Enforcer (3.0.3 Official Data - Normal Log Only)
('1737001','17370','4','0','10','6','0','0','0','0','1','-157','0','0','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Say on Aggro'),
('1737002','17370','9','0','100','7','0','5','9300','14700','11','14516','1','0','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Cast Strike'),
('1737003','17370','0','0','100','7','4200','9500','9500','15300','11','15655','4','1','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Shield Slam'),
-- Shadowmoon Warlock (3.0.3 Official Data - Normal Log Only)
('1737101','17371','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Shadowmoon Warlock - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1737102','17371','9','5','100','3','0','40','3300','4900','11','12739','1','0','0','0','0','0','0','0','0','0','Shadowmoon Warlock (Normal) - Cast Shadow Bolt (Phase 1)'),
('1737103','17371','9','5','100','5','0','40','3300','4900','11','15472','1','0','0','0','0','0','0','0','0','0','Shadowmoon Warlock (Heroic) - Cast Shadow Bolt (Phase 1)'),
('1737104','17371','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Warlock - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1737105','17371','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Shadowmoon Warlock - Disable Dynamic Movement at 0-8 Yards'),
('1737106','17371','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Shadowmoon Warlock - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1737107','17371','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Warlock - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1737108','17371','0','0','100','3','1100','7800','14800','30100','11','32197','4','33','0','0','0','0','0','0','0','0','Shadowmoon Warlock (Normal) - Cast Corruption'),
('1737109','17371','0','0','100','5','1100','7800','14800','30100','11','37113','4','33','0','0','0','0','0','0','0','0','Shadowmoon Warlock (Heroic) - Cast Corruption'),
('1737110','17371','0','0','100','7','6600','10700','14900','14900','11','13338','4','33','0','0','0','0','0','0','0','0','Shadowmoon Warlock - Cast Curse of Tongues'),
-- Shadowmoon Summoner (3.0.3 Official Data - Normal Log Only)
('1739501','17395','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Shadowmoon Summoner - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1739502','17395','9','5','100','3','0','40','2400','3800','11','15242','1','0','0','0','0','0','0','0','0','0','Shadowmoon Summoner (Normal) - Cast Fireball (Phase 1)'),
('1739503','17395','9','5','100','5','0','40','2400','3800','11','17290','1','0','0','0','0','0','0','0','0','0','Shadowmoon Summoner (Heroic) - Cast Fireball (Phase 1)'),
('1739504','17395','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Summoner - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1739505','17395','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Shadowmoon Summoner - Disable Dynamic Movement at 0-8 Yards'),
('1739506','17395','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Shadowmoon Summoner - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1739507','17395','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Summoner - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1739508','17395','0','0','100','6','1000','5000','0','0','11','30853','0','1','0','0','0','0','0','0','0','0','Shadowmoon Summoner - Summon Seductress'),
('1739509','17395','0','0','100','6','10500','13000','0','0','11','30851','0','1','0','0','0','0','0','0','0','0','Shadowmoon Summoner - Summon Felhound Manastalker'),
('1739510','17395','0','0','100','3','12000','14000','12000','14000','11','18399','4','1','0','0','0','0','0','0','0','0','Shadowmoon Summoner (Normal) - Cast Flamestrike'),
('1739511','17395','0','0','100','5','12000','14000','12000','14000','11','16102','4','1','0','0','0','0','0','0','0','0','Shadowmoon Summoner (Heroic) - Cast Flamestrike'),
-- Shadowmoon Adept (3.0.3 Official Data - Normal Log Only)
('1739701','17397','11','0','100','6','0','0','0','0','11','8876','0','0','0','0','0','0','0','0','0','0','Shadowmoon Adept - Cast Thrash on Spawn'),
('1739702','17397','4','0','10','6','0','0','0','0','1','-158','-159','-160','0','0','0','0','0','0','0','0','Shadowmoon Adept - Random Say on Aggro'),
('1739703','17397','0','0','100','7','5600','12300','9600','11400','11','11978','4','0','0','0','0','0','0','0','0','0','Shadowmoon Adept - Cast Kick'),
('1739704','17397','2','0','100','6','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Shadowmoon Adept - Flee at 15% HP'),
-- Nascent Fel Orc (3.0.3 Official Data - Normal Log Only)
('1739801','17398','0','0','100','7','4800','11600','12000','16000','11','22427','4','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - Cast Concussion Blow'),
('1739802','17398','0','0','100','7','4200','14700','13000','20500','11','31900','4','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - Cast Stomp'),
-- Seductress (3.0.3 Official Data - Normal Log Only)
('1739901','17399','0','0','100','7','1000','3000','12800','12800','11','32202','1','0','0','0','0','0','0','0','0','0','Seductress - Cast Lash of Pain'),
('1739902','17399','0','0','100','7','3200','5700','13700','13700','11','31865','5','1','0','0','0','0','0','0','0','0','Seductress - Cast Seduction'),
-- Felguard Annihilator (3.0.3 Official Data - Normal Log Only)
('1740001','17400','0','0','100','4','0','0','8700','14700','11','27577','4','0','0','0','0','0','0','0','0','0','Felguard Annihilator (Heroic) - Cast Intercept'),
('1740002','17400','9','0','100','7','0','10','8200','22100','11','18072','1','0','0','0','0','0','0','0','0','0','Felguard Annihilator - Cast Uppercut'),
('1740003','17400','0','0','100','7','6000','9500','6900','14800','11','15615','1','0','0','0','0','0','0','0','0','0','Felguard Annihilator - Cast Pummel'),
-- Felhound Manastalker (3.0.3 Official Data - Normal Log Only)
('1740101','17401','0','0','100','7','1000','2500','11100','11300','11','13321','4','0','0','0','0','0','0','0','0','0','Felhound Manastalker - Cast Mana Burn'),
('1740102','17401','0','0','100','7','3300','8700','12900','12900','11','30849','1','0','0','0','0','0','0','0','0','0','Felhound Manastalker - Cast Spell Lock'),
-- Shadowmoon Technician (3.0.3 Official Data - Normal Log Only)
('1741401','17414','0','0','100','3','2800','4700','1400','23400','11','30846','4','1','1','-155','0','0','0','0','0','0','Shadowmoon Technician (Normal) - Throw Proximity Bomb'),
('1741402','17414','0','0','100','5','2800','4700','17700','23400','11','32784','4','1','1','-155','0','0','0','0','0','0','Shadowmoon Technician (Heroic) - Throw Proximity Bomb'),
('1741403','17414','0','0','100','3','4400','10600','3600','6200','11','40062','4','0','0','0','0','0','0','0','0','0','Shadowmoon Technician (Normal) - Cast Throw Dynamite'),
('1741404','17414','0','0','100','5','4400','10600','3600','6200','11','40064','4','0','0','0','0','0','0','0','0','0','Shadowmoon Technician (Heroic) - Cast Throw Dynamite'),
('1741405','17414','0','0','100','7','5400','11600','24300','24300','11','6726','4','1','0','0','0','0','0','0','0','0','Shadowmoon Technician - Cast Silence'),
-- Fel Orc Neophyte (3.0.3 Official Data - Normal Log Only)
('1742901','17429','0','0','100','7','0','0','20500','20500','11','22120','4','0','0','0','0','0','0','0','0','0','Fel Orc Neophyte - Cast Charge on Aggro'),
('1742902','17429','0','0','100','7','2300','2500','120000','130000','11','8269','0','0','0','0','0','0','0','0','0','0','Fel Orc Neophyte - Cast Frenzy'),
-- Hellfire Imp - (3.0.3 Official Data - Normal Log Only)
('1747701','17477','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Hellfire Imp - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1747702','17477','9','5','100','3','0','40','3400','4800','11','15242','1','0','0','0','0','0','0','0','0','0','Hellfire Imp (Normal) - Cast Fireball (Phase 1)'),
('1747703','17477','9','5','100','5','0','40','3400','4800','11','17290','1','0','0','0','0','0','0','0','0','0','Hellfire Imp (Heroic) - Cast Fireball (Phase 1)'),
('1747704','17477','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Hellfire Imp - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1747705','17477','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Hellfire Imp - Disable Dynamic Movement at 0-8 Yards'),
('1747706','17477','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Hellfire Imp - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1747707','17477','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Hellfire Imp - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1747708','17477','0','0','100','5','6000','9000','6000','9000','11','16144','1','0','0','0','0','0','0','0','0','0','Hellfire Imp (Heroic) - Cast Fire Blast'),
-- Laughing Skull Rogue (3.0.3 Official Data - Normal Log Only)
('1749101','17491','1','0','100','6','1000','1000','0','0','11','30991','0','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Cast Stealth on Spawn'),
('1749102','17491','4','0','100','6','0','0','0','0','1','-156','0','0','28','0','30991','0','22','1','0','0','Laughing Skull Rogue - Say and Remove Stealth and Phase 1 on Aggro'),
('1749103','17491','9','5','100','7','0','5','4300','8700','11','34969','1','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Cast Poison (Phase 1)'),
('1749104','17491','24','5','100','7','34969','10','5000','5000','22','2','0','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Set Phase 2 on Target Max Poison Aura Stack (Phase 1)'),
('1749105','17491','28','3','100','7','34969','1','5000','5000','22','1','0','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Set Phase 1 on Target Missing Poison Aura Stack (Phase 2)'),
('1749106','17491','0','0','100','7','1000','5900','15000','20000','11','6434','0','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Cast Slice and Dice'),
('1749107','17491','0','0','100','7','4100','7800','12000','15000','11','30832','1','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Cast Kidney Shot'),
('1749108','17491','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Laughing Skull Rogue - Set Phase to 0 on Evade'),
-- Laughing Skull Warden (3.0.3 Official Data - Normal Log Only)
('1762401','17624','1','0','100','7','1000','1000','120000','130000','11','38551','0','0','0','0','0','0','0','0','0','0','Laughing Skull Warden - Cast Stealth Detection OOC'),
('1762402','17624','0','0','100','7','300','1200','15800','15800','11','9128','0','0','0','0','0','0','0','0','0','0','Laughing Skull Warden - Cast Battle Shout on Aggro'),
-- Laughing Skull Legionaire (3.0.3 Official Data - Normal Log Only)
('1762601','17626','0','0','100','7','5800','7200','11900','12400','11','10966','1','0','0','0','0','0','0','0','0','0','Laughing Skull Legionaire - Cast Uppercut'),
('1762602','17626','2','0','100','6','30','0','0','0','11','8599','0','2','1','-106','0','0','0','0','0','0','Laughing Skull Legionaire - Cast Enrage at 30% HP'),
-- Felguard Brute (3.0.3 Official Data - Normal Log Only)
('1889401','18894','9','0','100','7','0','10','13700','15700','11','18072','1','0','0','0','0','0','0','0','0','0','Felguard Brute - Cast Uppercut'),
('1889402','18894','0','0','100','7','4000','8000','10000','15000','11','15615','1','0','0','0','0','0','0','0','0','0','Felguard Brute - Cast Pummel'),
-- Hellfire Familiar (3.0.3 Official Data - Normal Log Only)
('1901601','19016','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Hellfire Familiar - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1901602','19016','9','5','100','3','0','40','2900','4800','11','11921','1','0','0','0','0','0','0','0','0','0','Hellfire Familiar (Normal) - Cast Fireball (Phase 1)'),
('1901603','19016','9','5','100','5','0','40','2900','4800','11','17290','1','0','0','0','0','0','0','0','0','0','Hellfire Familiar (Heroic) - Cast Fireball (Phase 1)'),
('1901604','19016','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Hellfire Familiar - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1901605','19016','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Hellfire Familiar - Disable Dynamic Movement at 0-8 Yards'),
('1901606','19016','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Hellfire Familiar - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1901607','19016','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Hellfire Familiar - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1901608','19016','0','0','100','5','6000','9000','6000','9000','11','14034','1','0','0','0','0','0','0','0','0','0','Hellfire Familiar (Heroic) - Cast Fire Blast'),

[Xadras]

-- https://github.com/Looking4Group/L4G_Core/issues/615
-- Blood Furnace

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

-- general fix
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16' WHERE `entry` IN (17624,18611,17397,17653,18620,17377,18607,18608,18615,17491,18610,17371,18619,17398,18612,17626,18609,17414,18618,17381,18621,17429,18603,19016,21646,18894,21645,17400,18604,17477,18606);

-- Laughing Skull Rogue 17491,18610
UPDATE `creature_template` SET `equipment_id` ='991',`mindmg`='361',`maxdmg`='457' WHERE `entry` = 17491; -- 206 402
UPDATE `creature_template` SET `armor`='7100',`equipment_id` ='991',`pickpocketloot`='17491',`mindmg`='3410',`maxdmg`='3478',`mechanic_immune_mask`='0',`spell1`='0',`spell2`='0',`spell3`='0',`spell4`='0' WHERE `entry` = 18610; -- 1404 1940 s1 30832 s2 34969 s3 6434 s4 30991
UPDATE `creature_ai_scripts` SET `event_chance`='10' WHERE `id` = 1749102; -- say on aggro
-- poison stacks
UPDATE `creature_ai_scripts` SET `event_param3`='2000',`event_param4`='4000',`action1_param2`='1',`action1_param3`='0' WHERE `id` = 1749105;
DELETE FROM `creature_ai_scripts` WHERE `id` = 1749106;
INSERT INTO `creature_ai_scripts` VALUES 
(1749106,17491,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Laughing Skull Rogue - Casts Dual Wield on Aggro');
UPDATE `creature_ai_scripts` SET `action3_param3`='3' WHERE `id` = 1749104; -- couldnt slice n dice 
-- rogues dont cancel stealth
UPDATE `creature_ai_scripts` SET `action2_type`='0',`action2_param2`='0',`comment`='Laughing Skull Rogue - Say on Aggro' WHERE `id` = 1749102;

-- Laughing Skull Legionnaire 17626,18609
UPDATE `creature_template` SET `equipment_id` ='1411',`mindmg`='426',`maxdmg`='571' WHERE `entry` = 17626; -- 257 502
UPDATE `creature_template` SET `equipment_id` ='1411',`armor`='6800',`pickpocketloot`='17626',`mindmg`='3893',`maxdmg`='4165' WHERE `entry` = 18609; -- 1742 2287
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17626;
INSERT INTO `creature_ai_scripts` VALUES
('1762601','17626','0','0','100','7','5800','7200','11900','12400','11','10966','1','0','13','-25','1','0','0','0','0','0','Laughing Skull Legionaire - Cast Uppercut'),
('1762602','17626','2','0','100','6','30','0','0','0','11','8599','0','2','1','-106','0','0','0','0','0','0','Laughing Skull Legionaire - Cast Enrage at 30% HP'),
('1762603','17626','4','0','100','6','0','0','0','0','11','18765','0','1','0','0','0','0','0','0','0','0','Laughing Skull Legionaire - Cast Sweeping Strikes on Aggro');

-- Laughing Skull Enforcer 17370,18608
UPDATE `creature_template` SET `equipment_id` ='993',`mindmg`='426',`maxdmg`='571',`minmana`='0',`maxmana`='0' WHERE `entry` = 17370; -- 257 502
UPDATE `creature_template` SET `equipment_id` ='993',`armor`='6800',`pickpocketloot`='17370',`mindmg`='4455',`maxdmg`='4795' WHERE `entry` = 18608; -- 1973 2653 -- 8,910 - 9,590
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17370;
INSERT INTO `creature_ai_scripts` VALUES
('1737001','17370','4','0','10','6','0','0','0','0','1','-157','-158','-159','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Say on Aggro'),
('1737002','17370','9','0','100','7','0','5','9300','14700','11','14516','1','0','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Cast Strike'),
('1737003','17370','0','0','100','7','4200','9500','9500','15300','11','15655','4','1','0','0','0','0','0','0','0','0','Laughing Skull Enforcer - Shield Slam');

-- Shadowmoon Warlock 17371,18619
UPDATE `creature_template` SET `mindmg`='349',`maxdmg`='509' WHERE `entry` = 17371; -- 182 442
UPDATE `creature_template` SET `armor`='5450',`spell1`='0',`spell2`='0',`spell3`='0',`spell4`='0',`pickpocketloot`='17371',`mindmg`='3464',`maxdmg`='3783' WHERE `entry` = 18619; -- 1493 2131 s1 32197 s2 13338 s3 33111 s4 12739
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17371;
INSERT INTO `creature_ai_scripts` VALUES 
(1737101,17371,4,0,100,6,0,0,0,0,21,1,0,0,1,-157,-158,-159,0,0,0,0,'Shadowmoon Warlock - Start Combat Movement and Say on Aggro'),
(1737102,17371,4,0,100,2,0,0,0,0,11,12739,1,0,23,1,0,0,0,0,0,0,'Shadowmoon Warlock (Normal) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
(1737103,17371,9,5,100,3,0,40,3000,5000,11,12739,1,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock (Normal) - Cast Shadow Bolt (Phase 1)'),
(1737104,17371,4,0,100,4,0,0,0,0,11,15472,1,0,23,1,0,0,0,0,0,0,'Shadowmoon Warlock (Heroic) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
(1737105,17371,9,5,100,5,0,40,3000,5000,11,15472,1,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock (Heroic) - Cast Shadow Bolt (Phase 1)'),
(1737106,17371,3,5,100,6,15,0,0,0,21,1,0,0,23,1,0,0,0,0,0,0,'Shadowmoon Warlock - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
(1737107,17371,9,5,100,6,35,80,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock - Start Combat Movement at 35 Yards (Phase 1)'),
(1737108,17371,9,5,100,6,5,15,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock - Start Combat Movement at 15 Yards (Phase 1)'),
(1737109,17371,9,5,100,6,0,5,0,0,21,1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock - Start Combat Movement Below 5 Yards'),
(1737110,17371,3,3,100,7,100,30,100,100,23,-1,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Warlock - Set Phase 1 when Mana is above 30% (Phase 2)'),
(1737111,17371,0,0,100,3,4100,7800,10800,15100,11,32197,4,32,0,0,0,0,0,0,0,0,'Shadowmoon Warlock (Normal) - Cast Corruption'),
(1737112,17371,0,0,100,5,4100,7800,10800,15100,11,37113,4,32,0,0,0,0,0,0,0,0,'Shadowmoon Warlock (Heroic) - Cast Corruption'),
(1737113,17371,0,0,100,7,6600,10700,10900,14900,11,13338,5,33,0,0,0,0,0,0,0,0,'Shadowmoon Warlock - Cast Curse of Tongues'),
(1737114,17371,7,0,100,6,0,0,0,0,22,0,0,0,21,1,0,0,0,0,0,0,'Shadowmoon Warlock - On Evade set Phase to 0');

-- Shadowmoon Technician 17414,18618
UPDATE `creature_template` SET `mindmg`='349',`maxdmg`='509' WHERE `entry` = 17414; -- 182 442
UPDATE `creature_template` SET `armor`='6800',`spell1`='0',`spell2`='0',`spell3`='0',`mindmg`='3400',`maxdmg`='3703'  WHERE `entry` = 18618; -- 1473 2078 s1 6726 s2 40062 s3 30846
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17414;
INSERT INTO `creature_ai_scripts` VALUES
('1741401','17414','9','0','100','3','0','5','7000','14900','11','30846','0','0','1','-155','0','0','0','0','0','0','Shadowmoon Technician (Normal) - Throw Proximity Bomb'),
('1741402','17414','9','0','100','5','0','5','7000','14900','11','32784','0','0','1','-155','0','0','0','0','0','0','Shadowmoon Technician (Heroic) - Throw Proximity Bomb'),
('1741403','17414','9','0','100','3','0','25','3600','6200','11','40062','4','0','0','0','0','0','0','0','0','0','Shadowmoon Technician (Normal) - Cast Throw Dynamite'),
('1741404','17414','9','0','100','5','0','25','3600','6200','11','40064','4','0','0','0','0','0','0','0','0','0','Shadowmoon Technician (Heroic) - Cast Throw Dynamite'),
('1741405','17414','0','0','100','7','6000','6000','12000','18000','11','6726','4','32','0','0','0','0','0','0','0','0','Shadowmoon Technician - Cast Silence'),
('1741406','17414','4','0','100','6','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Shadowmoon Technician - Casts Dual Wield on Aggro');

-- Shadowmoon Summoner 17395,18617 + Adds
UPDATE `creature_template` SET `speed`='1.48', `unit_flags`='32833', `faction_A`='16', `faction_H`='16',`mindmg`='287',`maxdmg`='451' WHERE `entry` = 17395; -- 156 420
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16',`minlevel`='70',`armor`='5450',`pickpocketloot`='17395',`spell1`='0',`spell2`='0',`spell3`='0',`mindmg`='3246',`maxdmg`='3532' WHERE `entry` = 18617; -- 1409 1981 s1 15242 s2 16102 s3 30853
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17395;
INSERT INTO `creature_ai_scripts` VALUES (1739501, 17395, 0, 0, 100, 7, 5000, 5000, 1000, 1000, 39, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Constant Call for Help');
INSERT INTO `creature_ai_scripts` VALUES (1739502, 17395, 0, 0, 100, 7, 3000, 6000, 15000, 20000, 11, 30853, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Summon Seductress');
INSERT INTO `creature_ai_scripts` VALUES (1739503, 17395, 0, 0, 100, 7, 6000, 9000, 15000, 20000, 11, 30851, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Summon Felhound Manastalker');
INSERT INTO `creature_ai_scripts` VALUES (1739504, 17395, 4, 0, 100, 2, 0, 0, 0, 0, 11, 15242, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Normal) - Cast Fireball and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1739505, 17395, 9, 5, 80, 3, 0, 40, 3000, 3800, 11, 15242, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Normal) - Cast Fireball (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1739506, 17395, 4, 0, 100, 4, 0, 0, 0, 0, 11, 17290, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Heroic) - Cast Fireball and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1739507, 17395, 9, 5, 80, 5, 0, 40, 3000, 3800, 11, 17290, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Heroic) - Cast Fireball (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1739508, 17395, 3, 5, 100, 6, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1739509, 17395, 9, 5, 100, 6, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Start Combat Movement at 35 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1739510, 17395, 9, 5, 100, 6, 5, 15, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Prevent Combat Movement at 15 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1739511, 17395, 9, 5, 100, 6, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Start Combat Movement Below 5 Yards');
INSERT INTO `creature_ai_scripts` VALUES (1739512, 17395, 3, 3, 100, 7, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Set Phase 1 when Mana is above 30% (Phase 2)');
INSERT INTO `creature_ai_scripts` VALUES (1739513, 17395, 0, 0, 100, 3, 12000, 14000, 6000, 9000, 11, 18399, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Normal) - Cast Flamestrike');
INSERT INTO `creature_ai_scripts` VALUES (1739514, 17395, 0, 0, 100, 5, 12000, 14000, 6000, 9000, 11, 16102, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner (Heroic) - Cast Flamestrike');
INSERT INTO `creature_ai_scripts` VALUES (1739515, 17395, 7, 0, 100, 6, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Shadowmoon Summoner - Set Phase to 0 on Evade');

-- Seductress 17399,18614
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16',`mindmg`='314',`maxdmg`='470',`mechanic_immune_mask`='1' WHERE `entry` = 17399; -- 209 465
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16',`mindmg`='2075',`maxdmg`='2260',`resistance5`='180',`mechanic_immune_mask`='1' WHERE `entry` = 18614; -- 903 1263
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17399;
INSERT INTO `creature_ai_scripts` VALUES (1739901, 17399, 0, 0, 100, 7, 1000, 3000, 12800, 12800, 11, 32202, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Seductress - Cast Lash of Pain');
INSERT INTO `creature_ai_scripts` VALUES (1739902, 17399, 0, 0, 100, 7, 3200, 5700, 13700, 13700, 11, 31865, 5, 32, 0, 0, 0, 0, 0, 0, 0, 0, 'Seductress - Cast Seduction');
INSERT INTO `creature_ai_scripts` VALUES (1739903, 17399, 7, 0, 100, 6, 0, 0, 0, 0, 41, 0, 0, 0, 18, 33554432, 0, 0, 0, 0, 0, 0, 'Seductress - Despawn on Evade');

-- Felhound Manastalker 17401,18605
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16',`mindmg`='377',`maxdmg`='514',`mechanic_immune_mask`='1' WHERE `entry` = 17401; -- 200 437
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32833',`faction_A`='16',`faction_H`='16',`armor`='4450',`mindmg`='1614',`maxdmg`='1796',`lootid`='17401',`mechanic_immune_mask`='1' WHERE `entry` = 18605; -- 671 1034
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17401;
INSERT INTO `creature_ai_scripts` VALUES (1740101, 17401, 0, 0, 100, 7, 1000, 2500, 11100, 11300, 11, 13321, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Felhound Manastalker - Cast Mana Burn');
INSERT INTO `creature_ai_scripts` VALUES (1740102, 17401, 0, 0, 100, 7, 3300, 8700, 12900, 12900, 11, 30849, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Felhound Manastalker - Cast Spell Lock');
INSERT INTO `creature_ai_scripts` VALUES (1740103, 17401, 7, 0, 100, 6, 0, 0, 0, 0, 41, 0, 0, 0, 18, 33554432, 0, 0, 0, 0, 0, 0, 'Felhound Manastalker - Despawn on Evade');

-- Shadowmoon Channeler 17653,18620
UPDATE `creature_template` SET `mindmg`='258',`maxdmg`='366',`baseattacktime`='1400',`mechanic_immune_mask`='1' WHERE `entry` = 17653; -- 111 219
UPDATE `creature_template` SET `armor`='5700',`mindmg`='2900',`maxdmg`='3130',`mechanic_immune_mask`='1' WHERE `entry` = 18620; -- 1278 1738
DELETE FROM `creature_template_addon` WHERE `entry` = 18620; 
INSERT INTO `creature_template_addon` VALUES
(18620,0,0,2048,0,4097,0,0,'');

-- Shadowmoon Adept 17397,18615
UPDATE `creature_template` SET `mindmg`='386',`maxdmg`='520',`baseattacktime`='1400' WHERE `entry` = 17397; -- 244 478
UPDATE `creature_template` SET `minlevel`='70',`armor`='5450',`mindmg`='3347',`maxdmg`='3549',`pickpocketloot`='17397' WHERE `entry` = 18615; -- 1902 2408 -- 8,367 - 8,873 dualwield /2.5
DELETE FROM `creature_ai_scripts` WHERE `id` = 1739705;
INSERT INTO `creature_ai_scripts` VALUES 
(1739705,17397,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Shadowmoon Adept - Casts Dual Wield on Aggro');
DELETE FROM `creature_template_addon` WHERE `entry` = 18615; 
INSERT INTO `creature_template_addon` VALUES
(18615,0,0,512,0,4097,0,0,'31059 0');

-- Nascent Fel Orc 17398,18612
UPDATE `creature_template` SET `mindmg`='285',`maxdmg`='394',`mechanic_immune_mask`='1025' WHERE `entry` = 17398; -- 81 190
UPDATE `creature_template` SET `mindmg`='3371',`maxdmg`='3538',`pickpocketloot`='17398',`mechanic_immune_mask`='1025' WHERE `entry` = 18612; -- 1560 1894
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17398;
INSERT INTO `creature_ai_scripts` VALUES 
('1739801','17398','0','0','100','7','4800','11600','12000','16000','11','22427','1','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - Cast Concussion Blow'),
('1739802','17398','0','0','100','7','4200','14700','13000','20500','11','31900','0','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - Cast Stomp'),
('1739803','17398','1','0','100','7','1','1','0','0','11','35766','0','7','0','0','0','0','0','0','0','0','Nascent Fel Orc - OCC Visual'),
('1739804','17398','4','0','100','6','0','0','0','0','28','0','35766','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - IC Cancel Visual'),
('1739805','17398','4','0','100','6','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Nascent Fel Orc - Casts Dual Wield on Aggro');

-- Laughing Skull Warden 17624,18611
UPDATE `creature_template` SET `equipment_id` ='993',`mindmg`='292',`maxdmg`='577' WHERE `entry` = 17624; --
UPDATE `creature_template` SET `armor`='7100',`mindmg`='3370',`maxdmg`='4162',`attackpower`='0',`equipment_id` ='993' WHERE `entry` = 18611; --
DELETE FROM `creature_template_addon` WHERE `entry` IN (17624,18611);
INSERT INTO `creature_template_addon` VALUES
(17624,0,0,0,0,4097,0,0,'18950 0 18950 1'),
(18611,0,0,0,0,4097,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17624;
INSERT INTO `creature_ai_scripts` VALUES
(1762401,17624,2,0,100,6,30,0,0,0,11,26527,0,3,0,0,0,0,0,0,0,0,'Laughing Skull Warden - Cast Enrage on 30% HP'),
(1762402,17624,0,0,100,7,0,1000,10000,15000,11,30833,0,0,0,0,0,0,0,0,0,0,'Laughing Skull Warden - Cast Battle Shout IC'),
('1762403','17624','4','0','10','6','0','0','0','0','1','-158','-672','-674','0','0','0','0','0','0','0','0','Laughing Skull Warden - Say on Aggro');

-- Hellfire Familiar
UPDATE `creature_template` SET `modelid_H`='16891',`mindmg`='145',`maxdmg`='218' WHERE `entry` = 19016; -- 76 149
UPDATE `creature_template` SET `modelid_H`='16891',`spell1`='0',`spell2`='0',`mindmg`='1496',`maxdmg`='1720' WHERE `entry` = 21646; -- 290 514 s1 13341 s2 11921
DELETE FROM `creature_ai_scripts` WHERE `id` = 1901613;
INSERT INTO `creature_ai_scripts` VALUES
('1901613','19016','1','0','100','7','1','1','0','0','11','35766','0','7','0','0','0','0','0','0','0','0','Hellfire Familiar - OCC Visual');

-- Hellfire Imp 17477 18606
UPDATE `creature_template` SET `modelid_A`='16888',`modelid_A2`='16891',`modelid_H`='16888',`modelid_H2`='16891',`mechanic_immune_mask`='0',`unit_flags`='32833',`baseattacktime`='1400' WHERE `entry` = 17477; -- spell 1 15242
UPDATE `creature_template` SET `modelid_A`='16888',`modelid_A2`='16891',`modelid_H`='16888',`modelid_H2`='16891',`mechanic_immune_mask`='0',`unit_flags`='32833',`mindmg`='1383',`maxdmg`='1689',`attackpower`='0',`spell1`='0',`spell2`='0' WHERE `entry` = 18606; -- spell 1 16144 spell 2 17290
UPDATE `creature_ai_scripts` SET `event_param3`='3000',`event_param4`='4000' WHERE `id` IN (1747703,1747705);
DELETE FROM `creature_ai_scripts` WHERE `id` = 1747713;
INSERT INTO `creature_ai_scripts` VALUES 
(1747713,17477,1,0,100,7,1,1,0,0,11,35766,0,7,0,0,0,0,0,0,0,0,'Hellfire Imp - OCC Visual');
--
UPDATE `creature_ai_scripts` SET `action3_type`='28',`action3_param1`='0',`action3_param2`='35766',`action3_param3`='0' WHERE `id` IN (1747702,1747704,1747706,1901602,1901604,1901606); -- 11,35766,0,7
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (1901601,1901608,1747701,1747708);

-- Fel Orc Neophytes  17429,18603
-- Uncontrollable — ignore threat, attacking any player that they choose.
UPDATE `creature_template` SET `mindmg`='226',`maxdmg`='294',`mechanic_immune_mask`='1' WHERE `entry` = 17429; -- 140 276 -- 452 - 588
UPDATE `creature_template` SET `mindmg`='2400',`maxdmg`='2578' WHERE `entry` = 18603; -- 1332 1779 5998 - 6445
UPDATE `creature_template` SET `flags_extra`='65538' WHERE `entry` IN (17429,18603);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17429;
INSERT INTO `creature_ai_scripts` VALUES
('1742901','17429','9','0','33','7','5','30','10250','20500','11','22120','4','1','0','0','0','0','0','0','0','0','Fel Orc Neophyte - Cast Random Charge and Aggro Reset'),
('1742902','17429','0','0','100','7','1000','30000','120000','240000','11','8269','0','3','0','0','0','0','0','0','0','0','Fel Orc Neophyte - Cast Frenzy'),
('1742903','17429','0','0','100','7','3000','9000','3000','9000','14','-99','0','0','13','100','4','0','0','0','0','0','Fel Orc Neophyte - Randomly Drop Aggro and Take on New Target');

-- Felguard Annihilator 17400, 18604
UPDATE `creature_template` SET `mindmg`='573',`maxdmg`='797',`equipment_id`='8020' WHERE `entry` = 17400; -- 332 656
UPDATE `creature_template` SET `mindmg`=6050,`maxdmg`=6699,`attackpower`='0',`speed`='1.48',`equipment_id`='8020' WHERE `entry` = 18604; -- 6050 - 6699
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17400;
INSERT INTO `creature_ai_scripts` VALUES
('1740001','17400','4','0','50','4','0','0','0','0','11','27577','1','1','0','0','0','0','0','0','0','0','Felguard Annihilator (Heroic) - Cast Intercept on Aggro'),
('1740002','17400','9','0','100','7','0','10','8200','15700','11','18072','1','0','13','-50','1','0','0','0','0','0','Felguard Annihilator - Cast Uppercut'),
('1740003','17400','0','0','100','7','6000','9500','6900','14800','11','15615','4','0','0','0','0','0','0','0','0','0','Felguard Annihilator - Cast Pummel'),
('1740004','17400','0','0','100','5','8700','14700','8700','14700','11','27577','4','1','0','0','0','0','0','0','0','0','Felguard Annihilator (Heroic) - Cast Random Intercept IC'),
('1740005','17400','1','0','100','7','20000','30000','20000','30000','11','33111','0','3','0','0','0','0','0','0','0','0','Felguard Annihilator - Fel Power');

-- Felguard Brute 18894, 21645
UPDATE `creature_template` SET `mindmg`='427',`maxdmg`='672',`equipment_id`='8020' WHERE `entry` = 18894; -- 257 502
UPDATE `creature_template` SET `mindmg`=6000,`maxdmg`=8000,`attackpower`='0',`speed`=1.48,`minlevel`='70',`equipment_id`='8020' WHERE `entry` = 21645; -- 7701 - 8067
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18894;
INSERT INTO `creature_ai_scripts` VALUES
('1889401','18894','9','0','100','7','0','10','13700','15700','11','18072','1','0','13','-50','1','0','0','0','0','0','Felguard Brute - Cast Uppercut'),
('1889402','18894','0','0','100','7','4000','8000','10000','15000','11','15615','4','0','0','0','0','0','0','0','0','0','Felguard Brute - Cast Pummel'),
('1889403','18894','1','0','100','7','20000','30000','20000','30000','11','33111','0','3','0','0','0','0','0','0','0','0','Felguard Brute - Fel Power');

DELETE FROM `creature_equip_template` WHERE `entry` = 8020;
INSERT INTO `creature_equip_template` VALUES
(8020,19647,0,0,33490946,0,0,256,0,0);

-- Orc Captive 17416,18613 
UPDATE `creature_template` SET `minlevel`='60',`maxlevel`='61',`minmana`='0',`maxmana`='0',`faction_A`='16',`faction_H`='16',`minhealth`='10000',`maxhealth`='11000',`armor`='3100',`speed`='1.20',`pickpocketloot`='17416' WHERE `entry` = 17416;
UPDATE `creature_template` SET `minlevel`='68',`maxlevel`='69',`minmana`='0',`maxmana`='0',`faction_A`='16',`faction_H`='16',`minhealth`='6000',`maxhealth`='9000',`armor`='5500',`speed`='1.20',`baseattacktime`='0',`pickpocketloot`='17416' WHERE `entry` = 18613;
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 17416;

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

-- The Maker 17381,18621
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1',`mechanic_immune_mask`='787431423',`mindmg`='815',`maxdmg`='1061' WHERE `entry` = 17381; -- 504 996 -- 1,630 - 2,122
UPDATE `creature_template` SET `mindmg`='5428',`maxdmg`='6115',`speed`='1.48',`unit_flags`='1',`mechanic_immune_mask`='787431423',`pickpocketloot`='17381' WHERE `entry` = 18621; -- 8,143 - 9,172

-- Broggok 17380,18601
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64',`mechanic_immune_mask`='787431423',`baseattacktime`='1400',`mindmg`='450',`maxdmg`='636' WHERE `entry` = 17380; -- 254 540
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64',`mechanic_immune_mask`='787431423',`armor`='7400',`mindmg`='3977',`maxdmg`='4238' WHERE `entry` = 18601; -- 7,953 - 8,476
DELETE FROM `creature_template_addon` WHERE `entry` = 18601;
INSERT INTO `creature_template_addon` VALUES 
(18601,0,0,2048,0,4097,0,0,'');

-- Broggok Poison Cloud 17662,18602

-- Keli'dan the Breaker 17377,18607
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='257',`mechanic_immune_mask`='787431423',`mindmg`='525',`maxdmg`='600',`equipment_id`='1250' WHERE `entry` = 17377; -- 314 667 -- 1,050 - 1,403
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='257',`mechanic_immune_mask`='787431423',`armor`='5950',`mindmg`='4983',`maxdmg`='5201',`equipment_id`='1250' WHERE `entry` = 18607; -- 7,475 - 7,801

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

SET @GUID := 99992;
SET @POINT := 0;
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,16777472,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
(@GUID, @POINT := @POINT + '1', '473.7266', '-92.67467', '9.554437', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '465.7649', '-88.24423', '9.549582', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '464.2817', '-79.56931', '9.581706', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '464.3057', '-70.73328', '9.551740', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '461.8463', '-52.14299', '9.531462', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '468.3394', '-42.80176', '9.564499', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '479.1956', '-39.19093', '9.549496', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '488.9319', '-34.26514', '9.548501', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '496.0039', '-28.06838', '9.550275', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '488.9319', '-34.26514', '9.548501', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '479.1956', '-39.19093', '9.549496', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '468.3394', '-42.80176', '9.564499', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '461.8463', '-52.14299', '9.531462', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '464.3057', '-70.73328', '9.551740', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '464.2817', '-79.56931', '9.581706', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '465.7254', '-88.01351', '9.568944', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '473.7266', '-92.67467', '9.554437', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '482.6924', '-92.77731', '9.550932', '0', '0', '0', '100', '0');

SET @GUID := 86449;
SET @POINT := 0;
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,16777472,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
(@GUID, @POINT := @POINT + '1', '117.3914', '-93.04942', '-9.4868940', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '109.2381', '-94.04441', '-13.245850', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '98.57112', '-93.50570', '-18.174310', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '87.04167', '-93.61084', '-23.506760', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '75.03605', '-94.70542', '-29.054450', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '87.04167', '-93.61084', '-23.506760', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '98.57112', '-93.50570', '-18.174310', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '109.2381', '-94.04441', '-13.245850', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '117.3914', '-93.04942', '-9.4868940', '0', '0', '0', '100', '0'),
(@GUID, @POINT := @POINT + '1', '135.9726', '-92.95206', '-0.9103361', '0', '0', '0', '100', '0');

DELETE FROM `creature_addon` WHERE `guid` IN (100007,100008,99952,200988,200989,200990,200991,200992,200993,201005,201006,201007,201009); -- casting for 193er
INSERT INTO `creature_addon` VALUES
(99952,0,0,0,0,4097,0,0,'44836 0 44836 1'),
(200988,0,0,0,8,4097,0,0,''),
(200989,0,0,0,0,4097,193,0,''),
(200990,0,0,0,0,4097,193,0,''),
(200991,0,0,0,8,4097,0,0,''),
(200992,0,0,0,0,4097,193,0,''),
(200993,0,0,0,0,4097,193,0,''),
(201005,0,0,0,0,4097,193,0,''),
-- (201006,0,0,0,8,4097,0,0,''),
-- (201007,0,0,0,8,4097,0,0,''),
(100007,0,0,0,8,4097,0,0,''),
(100008,0,0,0,8,4097,0,0,''),
(201009,0,0,0,0,4097,193,0,'');
DELETE FROM `creature_addon` WHERE `guid` IN (85684,85690,85699,85700,85701,85702,85704,200994,201001,201002,201004,201008);
INSERT INTO `creature_addon` VALUES
(85684,0,0,0,0,4097,69,0,''),
(85690,0,0,0,0,4097,69,0,''),
(85699,0,0,0,0,4097,69,0,''),
(85700,0,0,0,0,4097,69,0,''),
(85701,0,0,0,0,4097,69,0,''),
(85702,0,0,0,0,4097,69,0,''),
(85704,0,0,0,0,4097,69,0,''),
(200994,0,0,0,0,4097,69,0,''),
(201001,0,0,0,0,4097,69,0,''),
(201002,0,0,0,0,4097,69,0,''),
(201004,0,0,0,0,4097,69,0,''),
(201008,0,0,0,0,4097,69,0,'');
DELETE FROM `creature_addon` WHERE `guid` IN (200980,200981,62741,62742,62739,62740,200962,200963,200974,200975,85669,85670,85738,85739,201025,201026,201027,201028,201029,201030);
INSERT INTO `creature_addon` VALUES
(200980,0,0,0,0,4097,333,0,''),
(200981,0,0,0,0,4097,333,0,''),
(62741,0,0,0,0,4097,333,0,''),
(62742,0,0,0,0,4097,333,0,''),
(62739,0,0,0,0,4097,333,0,''),
(62740,0,0,0,0,4097,333,0,''),
(200962,0,0,0,0,4097,333,0,''),
(200963,0,0,0,0,4097,333,0,''),
(200974,0,0,0,0,4097,333,0,''),
(200975,0,0,0,0,4097,333,0,'');
INSERT INTO `creature_addon` VALUES
(85669,0,0,0,0,4097,375,0,''),
(85670,0,0,0,0,4097,375,0,''),
(201025,0,0,0,0,4097,375,0,''),
(201026,0,0,0,0,4097,375,0,''),
(201027,0,0,0,0,4097,375,0,''),
(201028,0,0,0,0,4097,375,0,''),
(201029,0,0,0,0,4097,375,0,''),
(201030,0,0,0,0,4097,375,0,''),
(85739,0,0,0,0,4097,375,0,''),
(85738,0,0,0,0,4097,375,0,'');
--
-- Hellfire Imp dont need that anymore
DELETE FROM `creature_template_addon` WHERE `entry` = 17477;
--
UPDATE `creature` SET `position_x`='316.2205',`position_y`='91.8548',`position_z`='9.6193',`orientation`='5.2314' WHERE `guid` = 85680;
UPDATE `creature` SET `position_x`='339.3155',`position_y`='91.1376',`position_z`='9.6177',`orientation`='4.2575' WHERE `guid` = 200983;  
UPDATE `creature` SET `position_x`='328.6021',`position_y`='70.0728',`position_z`='9.6147',`orientation`='1.9815' WHERE `guid` = 85691;
UPDATE `creature` SET `id` = '17414' WHERE `guid` = 201002;
UPDATE `creature` SET `id` = '17395' WHERE `guid` IN (201005,200982);
UPDATE `creature` SET `id`='17624' WHERE `guid` IN (16777209,85686);

UPDATE `waypoint_data` SET `position_x`='56.2926',`position_y`='-75.9798',`position_z`='-37.4172' WHERE `id`=86448 AND `point`=1;
DELETE FROM `waypoint_data` WHERE `id`=86448 AND `point`=2;
INSERT INTO `waypoint_data` VALUES
(86448,2,76.6289,-76.3756,-28.3290,0,0,0,100,0);
DELETE FROM `waypoint_data` WHERE `id`='200973';
INSERT INTO `waypoint_data` VALUES
(200973,1,231.5415,-84.9794,9.6011,0,0,0,100,0),
(200973,2,255.4323,-84.4162,9.6256,5000,0,0,100,0),
(200973,3,231.5415,-84.9794,9.6011,0,0,0,100,0),
(200973,4,237.4513,-74.3677,9.6180,1000,0,0,100,0),
(200973,5,228.4920,-73.3508,9.6186,1000,0,0,100,0),
(200973,6,231.5415,-84.9794,9.6011,0,0,0,100,0),
(200973,7,231.8938,-96.9141,9.6166,1000,0,0,100,0),
(200973,8,231.5415,-84.9794,9.6011,0,0,0,100,0),
(200973,9,214.5183,-84.5760,9.5798,0,0,0,100,0);

UPDATE `creature` SET `spawndist`='5',`MovementType`='1' WHERE `guid` IN (200960,200961,200987,200995);
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=16777209;
SET @NPC := 16777209;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'453.8304','124.4543','9.6142',0,0,0,100,0),
(@PATH,2,'431.2472','109.8159','9.6213',0,0,0,100,0),  
(@PATH,3,'439.4303','89.6606','9.6203',0,0,0,100,0), 
(@PATH,4,'465.2311','90.5623','9.6174',0,0,0,100,0), 
(@PATH,5,'469.1619','111.9710','9.6170',0,0,0,100,0);

UPDATE `creature` SET `MovementType`='2' WHERE `guid`=16777212;
SET @NPC := 16777212;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,457.2416,15.0185,9.5463,0,0,0,100,0),
(@PATH,2,437.4291,-8.7959,9.5577,0,0,0,100,0),   
(@PATH,3,459.5710,-20.9018,9.5502,0,0,0,100,0); 

SET @NPC := 99994;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,314.733,176.686,9.6203,0,0,0,100,0),
(@PATH,2,362.809,187.693,9.59284,0,0,0,100,0),
(@PATH,3,424.297,186.452,9.60443,0,0,0,100,0),
(@PATH,4,465.236,176.709,9.61783,0,0,0,100,0),
(@PATH,5,466.753,179.824,9.61999,0,0,0,100,0),
(@PATH,6,445.189,183.782,9.60686,0,0,0,100,0),
(@PATH,7,407.551,185.906,9.59662,0,0,0,100,0),
(@PATH,8,364.43,185.65,9.59515,0,0,0,100,0),
(@PATH,9,314.733,176.686,9.6203,0,0,0,100,0);

UPDATE `creature` SET `MovementType`='2' WHERE `guid`=16777211;
SET @NPC := 16777211;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,464.5809,-62.7163,9.5448,0,0,0,100,0),
(@PATH,2,492.5238,-62.8908,9.5453,0,0,0,100,0),
(@PATH,3,492.8998,-93.8801,9.5500,0,0,0,100,0),
(@PATH,4,463.4235,-93.1205,9.5518,0,0,0,100,0);

UPDATE `creature` SET `MovementType`='2' WHERE `guid`=85741;
SET @NPC := 85741;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,408.7515,-84.2657,9.6151,0,0,0,100,0),
(@PATH,2,397.5805,-84.4478,9.5448,5000,0,0,100,0),
(@PATH,3,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,4,427.5910,-82.5131,9.6187,1000,0,0,100,0),
(@PATH,5,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,6,414.5877,-88.4968,9.6202,1000,0,0,100,0), 
(@PATH,7,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,8,426.7911,-89.9782,9.6231,1000,0,0,100,0), 
(@PATH,9,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,10,415.4587,-80.9416,9.6208,1000,0,0,100,0),
(@PATH,11,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,12,420.6285,-76.6822,9.6247,1000,0,0,100,0),
(@PATH,13,421.0339,-84.4142,9.6159,0,0,0,100,0),
(@PATH,14,420.1806,-94.1676,9.6199,1000,0,0,100,0),
(@PATH,15,421.0339,-84.4142,9.6159,0,0,0,100,0);

-- ==============
-- Gameobjects
-- ==============

-- doors
UPDATE `gameobject` SET `spawntimesecs`='0' WHERE `guid` IN (22252,22301,22290,22297,22295,22296,22298,22299);