Hellfire Ramparts

[Xadras]

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

---

ToDo:

• recheck npcs again & order: 17280 17309 17517 17540 17281 17264 17259 17271 17455 17478 17269 17270 17306 17307 17537 17308

• Endboss Reset Bug, he does actually reset but it takes a long time -> Reset Timer?

---

• [x] Bonechewer Destroyers now has a 2 second melee round time and will no longer Knock Away and wipe the target's threat on Heroic.

• [ ] Bonechewer Evokers now attack slower.

• [ ] Bleeding Hollow Scryer's Fear extended the repeat cooldown so the ability will happen less frequently.

• [ ] Bonechewer Raveners on Heroic, damage has been reduced and will now attack slower.

• [ ] The Liquid Fire damage radius graphic has been slightly altered to align more properly with damage; and damage has been significantly reduced in Heroic difficulty.

• [ ] Omor the Unscarred's Treacherous Bane ability on Heroic will now have the correct damage listed on the tooltip. The damage has also been reduced in Heroic. Changed the graphic to be more noticeable.

• [x] Added a 2 second cast time to Omor the Unscarred's Treacherous Aura and Treacherous Bane abilities.

• [ ] Vazruden's Revenge damage has been raised on Heroic difficulty.

• [x] Nazan now emotes before landing.

• [ ] Nazan now has a slight delay before fireballing after breathing fire while landed.

• [ ] Vazruden's Warn Horn is now present in Hellfire Ramparts. It can be used to call Vazruden back if he leaves the instance between wipes.

• [x] Nazan in the Hellfire Ramparts is no longer affected by Disarm.

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

---

• [ ] The Reinforced Fel Iron Chest can now only be looted by players who are present during some portion of a successful attempt of the Vazruden and Nazan encounter. In addition, on Heroic difficulty the chest now contains a [Badge of Justice] for each player present.

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

---

• [ ] Nazan in Hellfire Citadel: Nazan will no longer sometimes not land on the ground until after Combat 15 Vazruden the Herald is killed or Nazan is heavily damaged.

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

[Xadras]

Sources:

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

https://www.youtube.com/watch?v=tg8V5ogqMBI , https://www.youtube.com/watch?v=MJFqAOBLOKo , https://www.youtube.com/watch?v=O16s52k1Vzo https://www.youtube.com/watch?v=6daOHGfyH_c

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

How not to: https://www.youtube.com/watch?v=ju-4WEh95I8

http://www.wowhead.com/zone=3562 , http://wowwiki.wikia.com/wiki/Hellfire_Ramparts?oldid=1591187

http://www.wowhead.com/npc=17270/bleeding-hollow-archer

https://github.com/ACID-Scripts/TBC/commit/c4666cfdef104a9c8d0e57c1aed29038f4b1625f

-- Bonechewer Hungerer 17259 (3.0.3 Official Data - Normal Log Only)
('1725901','17259','4','0','10','6','100','0','0','0','1','-158','-181','-672','0','0','0','0','0','0','0','0','Bonechewer Hungerer - Random Say on Aggro'),
('1725902','17259','9','0','100','7','0','5','2400','5800','11','14516','1','0','0','0','0','0','0','0','0','0','Bonechewer Hungerer - Cast Strike'),
('1725903','17259','0','0','100','7','1300','9200','30100','34100','11','16244','0','1','0','0','0','0','0','0','0','0','Bonechewer Hungerer - Cast Demoralizing Shout'),
('1725904','17259','0','0','100','7','3600','15400','5600','24100','11','6713','1','1','0','0','0','0','0','0','0','0','Bonechewer Hungerer - Cast Disarm'),
('1725905','17259','2','0','100','6','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Bonechewer Hungerer - Flee at 15% HP'),

-- Bonechewer Ravener (3.0.3 Official Data - Normal Log Only)
('1726401','17264','4','0','20','6','0','0','0','0','1','-156','-181','-672','0','0','0','0','0','0','0','0','Bonechewer Ravener - Random Say on Aggro'),
('1726402','17264','0','0','100','7','3200','8800','20100','30100','11','30621','1','0','13','-40','1','0','0','0','0','0','Bonechewer Ravener - Cast Kidney Shot and Reduce Aggro'),

-- Bleeding Hollow Darkcaster (3.0.3 Official Data - Normal Log Only)
('1726901','17269','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Bleeding Hollow Darkcaster - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1726902','17269','9','5','100','3','0','30','2400','3600','11','15241','1','0','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster (Normal) - Cast Scorch (Phase 1)'),
('1726903','17269','9','5','100','5','0','30','2400','3600','11','36807','1','0','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster (Heroic) - Cast Scorch (Phase 1)'),
('1726904','17269','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1726905','17269','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster - Disable Dynamic Movement at 0-8 Yards'),
('1726906','17269','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Bleeding Hollow Darkcaster - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1726907','17269','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1726908','17269','0','0','100','3','11600','31300','22700','45500','11','20754','4','1','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster (Normal) - Cast Rain of Fire'),
('1726909','17269','0','0','100','5','11600','31300','22700','45500','11','36808','4','1','0','0','0','0','0','0','0','0','Bleeding Hollow Darkcaster (Heroic) - Cast Rain of Fire'),

-- Bleeding Hollow Archer (3.0.3 Official Data - Normal Log Only)
('1727001','17270','4','0','10','6','100','0','0','0','1','-156','-181','-672','0','0','0','0','0','0','0','0','Bleeding Hollow Archer - Random Say on Aggro'),
('1727002','17270','4','0','100','6','0','0','0','0','49','1','0','0','20','0','0','0','0','0','0','0','Bleeding Hollow Archer - Enable Dynamic Movement and Prevent Melee on Aggro'),
('1727003','17270','9','0','100','3','5','30','2300','5000','11','18651','1','0','40','2','0','0','0','0','0','0','Bleeding Hollow Archer (Normal) - Cast Multi Shot and Set Ranged Weapon Model'),
('1727004','17270','9','0','100','5','5','30','2300','5000','11','31942','1','0','40','2','0','0','0','0','0','0','Bleeding Hollow Archer (Heroic) - Cast Multi Shot and Set Ranged Weapon Model'),
('1727005','17270','9','0','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Archer - Enable Dynamic Movement at 9-80 Yards'),
('1727006','17270','9','0','100','7','0','8','1000','1000','49','0','0','0','20','1','0','0','40','1','0','0','Bleeding Hollow Archer - Disable Dynamic Movement and Enable Melee and Set Melee Weapon Model at 0-8 Yards'),
('1727007','17270','0','0','100','7','12100','15300','13300','18200','11','30614','1','1','40','2','0','0','0','0','0','0','Bleeding Hollow Archer - Cast Aimed Shot'),
('1727008','17270','7','0','100','6','0','0','0','0','40','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Archer - Set Melee Weapon Model on Evade'),
-- Bonechewer Destroyer (3.0.3 Official Data - Normal Log Only)
('1727101','17271','4','0','20','6','0','0','0','0','1','-156','-181','-674','0','0','0','0','0','0','0','0','Bonechewer Destroyer - Random Say on Aggro'),
('1727102','17271','9','0','100','7','0','5','6100','21400','11','16856','1','0','0','0','0','0','0','0','0','0','Bonechewer Destroyer - Cast Mortal Strike'),
('1727103','17271','0','0','100','7','19300','31400','11100','32200','11','10101','1','1','13','-80','1','0','0','0','0','0','Bonechewer Destroyer - Cast Knock Away and Reduce Threat'),

-- Shattered Hand Warhound (3.0.3 Official Data - Normal Log Only)
('1728001','17280','0','0','100','7','1000','3100','13100','25300','11','30636','1','0','0','0','0','0','0','0','0','0','Shattered Hand Warhound - Cast Furious Howl'),
('1728002','17280','0','0','100','7','2300','8600','3600','8400','11','30639','1','0','0','0','0','0','0','0','0','0','Shattered Hand Warhound - Cast Carnivorous Bite'),

-- Bonechewer Ripper (3.0.3 Official Data - Normal Log Only)
('1728101','17281','1','0','100','7','10000','30000','20000','40000','5','15','0','0','0','0','0','0','0','0','0','0','Bonechewer Ripper - Random Emote OOC'),
('1728102','17281','0','0','100','7','700','1000','12000','19000','11','18501','0','0','1','-46','0','0','0','0','0','0','Bonechewer Ripper - Cast Enrage'),
('1728103','17281','30','0','100','6','0','17478','0','0','11','30659','0','7','0','0','0','0','0','0','0','0','Bonechewer Ripper - Cast Fel Infusion on Recieve AI_EVENT_JUST_DIED From Bleeding Hollow Scryer'),

-- Watchkeeper Gargolmar (17306) - boss_watchkeeper_gargolmar

-- Vazruden the Herald (17307) - boss_vazruden_herald

-- Omor the Unscarred (17308) - boss_omor_the_unscarred

-- Hellfire Watcher (3.0.3 Official Data - Normal Log Only)

('1730901','17309','0','0','100','7','4800','10400','10500','31300','11','14032','1','0','0','0','0','0','0','0','0','0','Hellfire Watcher - Cast Shadow Word: Pain'),
('1730902','17309','14','0','100','3','15000','40','12000','20000','11','12039','6','1','0','0','0','0','0','0','0','0','Hellfire Watcher (Normal) - Cast Heal on Friendlies'),
('1730903','17309','14','0','100','5','50000','40','12000','20000','11','30643','6','1','0','0','0','0','0','0','0','0','Hellfire Watcher (Heroic) - Cast Heal on Friendlies'),
('1730904','17309','2','0','100','7','50','0','20000','25000','11','8362','0','0','0','0','0','0','0','0','0','0','Hellfire Watcher - Cast Renew at 50% HP'),

-- Bonechewer Beastmaster (3.0.3 Official Data - Normal Log Only)

('1745501','17455','4','0','100','6','0','0','0','0','1','-179','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Yell on Aggro'),
('1745502','17455','0','0','100','7','4200','12400','15200','20500','11','9128','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Cast Battle Shout'),
('1745503','17455','0','0','100','7','1200','10400','10800','21700','11','10966','1','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Cast Uppercut'),
('1745504','17455','0','0','100','2','20000','20000','0','0','1','-180','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Normal) - Yell For Summon Shattered Hand Warhounds'),
('1745505','17455','0','0','100','4','17000','17000','0','0','1','-180','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Heroic) - Yell For Summon Shattered Hand Warhounds'),
('1745506','17455','0','0','100','2','20100','20100','0','0','32','17280','1','16','32','17280','1','17','32','17280','1','18','Bonechewer Beastmaster (Normal) - Summon 3 Shattered Hand Warhounds'),
('1745507','17455','0','0','100','4','17100','17100','0','0','32','17280','1','16','32','17280','1','17','32','17280','1','18','Bonechewer Beastmaster (Heroic) - Summon 3 Shattered Hand Warhounds'),
('1745508','17455','0','0','25','2','20100','20100','0','0','32','17280','1','19','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Normal) - Summon 4th Shattered Hand Warhound'),
('1745509','17455','0','0','75','4','17100','17100','0','0','32','17280','1','19','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Heroic) - Summon 4th Shattered Hand Warhound'),
-- Bleeding Hollow Scryer (3.0.3 Official Data - Normal Log Only)
('1747801','17478','4','0','10','6','100','0','0','0','1','-156','-181','-672','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Random Say on Aggro'),
('1747802','17478','4','0','100','6','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Bleeding Hollow Scryer - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('1747803','17478','9','5','100','3','0','40','3600','4800','11','12471','1','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer (Normal) - Cast Shadowbolt (Phase 1)'),
('1747804','17478','9','5','100','5','0','40','3100','4700','11','15232','1','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer (Heroic) - Cast Shadowbolt (Phase 1)'),
('1747805','17478','9','5','100','7','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('1747806','17478','9','0','100','7','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Disable Dynamic Movement at 0-8 Yards'),
('1747807','17478','3','5','100','6','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Bleeding Hollow Scryer - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1747808','17478','3','3','100','7','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1747809','17478','0','0','100','7','6600','23500','17100','23800','11','30615','5','1','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Cast Fear'),
('1747810','17478','6','0','100','6','0','0','0','0','45','0','50','0','0','0','0','0','0','0','0','0','Bleeding Hollow Scryer - Send AI_EVENT_JUST_DIED on Death'),
-- Hellfire Sentry (3.0.3 Official Data - Normal Log Only)
('1751701','17517','0','0','100','7','1200','7900','20800','24100','11','30621','1','0','0','0','0','0','0','0','0','0','Hellfire Sentry - Cast Kidney Shot'),
('1751702','17517','6','0','100','6','0','0','0','0','34','2','4','0','0','0','0','0','0','0','0','0','Hellfire Sentry - Set Instance Data on Death'),

-- Nazan (17536) - NSR

-- Vazruden (17537) - boss_vazruden

-- Fiendish Hound (3.0.3 Official Data - Normal Log Only)

('1754001','17540','0','0','100','7','6000','8000','11000','13000','11','15785','4','0','0','0','0','0','0','0','0','0','Fiendish Hound - Cast Mana Burn'),
('1754002','17540','2','0','100','7','30','0','7000','10000','11','35748','4','0','0','0','0','0','0','0','0','0','Fiendish Hound - Cast Drain Life at 30% HP'),

[Xadras]

#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/610
-- ===================================
-- Hellfire Citadel: Hellfire Ramparts
-- ===================================
-- 
-- ======================================================
-- Texts & Scripts
-- ======================================================

DELETE FROM `creature_ai_texts` WHERE `entry` = -9998;
INSERT INTO `creature_ai_texts` VALUES
('-9998','Yes sir!  I will not fail the Fel Horde!','','','Ja Sir! Ich werde Euch nicht enttäuschen!','','','','','','0','1','0','66','Answer to -673');

UPDATE `creature_ai_texts` SET `content_loc3`='Für Kargath! Für den Sieg!' WHERE `entry` = -674;
UPDATE `creature_ai_texts` SET `content_loc3`='Du da! Bleib wachsam! Es könnten Eindringlinge in der Nähe sein!' WHERE `entry` = -673;
UPDATE `creature_ai_texts` SET `content_loc3`='Diese Welt gehört uns!' WHERE `entry` = -672;
UPDATE `creature_ai_texts` SET `content_loc3`='Wir sind die wahre Horde!' WHERE `entry` = -181;
UPDATE `creature_ai_texts` SET `content_loc3`='Zu spät! Spürt den Zorn meiner Kriegshunde!' WHERE `entry` = -180;
UPDATE `creature_ai_texts` SET `content_loc3`='Eindringlinge! Haltet sie auf, bis ich die Kriegshunde losgelassen habe!' WHERE `entry` = -179;
UPDATE `creature_ai_texts` SET `content_loc3`='Das Blut gibt uns Kraft!' WHERE `entry` = -156;
UPDATE `creature_ai_texts` SET `content_loc3`='versucht zu flüchten!' WHERE `entry` = -47;

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

-- Shattered Hand Warhound 17280,18059
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16',`unit_flags`='32832',`baseattacktime`='1500', `mindmg` = 118, `maxdmg` = 151 WHERE `entry` = 17280; -- 37 70 -- 118 - 151
UPDATE `creature_template` SET `speed`='1.48', `faction_A`='16',`faction_H`='16',`unit_flags`='32832',`baseattacktime`='1500',`skinloot` = 70062, `mindmg` = 3114, `maxdmg` = 3713 WHERE `entry` = 18059; -- 1108 2306 -- 6,227 - 7,425
UPDATE `creature_template` SET `mechanic_immune_mask`='0' WHERE `entry` = 18049;
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='5' WHERE `id` = 1728002;

-- Hellfire Sentry <Herald's Sentry> 17517,18057
UPDATE `creature_template` SET `equipment_id` ='1260',`mindmg`='431',`maxdmg`='619' WHERE `entry` = 17517; -- 116 304 -- 431 - 619
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832', `equipment_id` ='1260',`mindmg`='1172',`maxdmg`='1446',`lootid` = 17517, `pickpocketloot` = 17517, `baseattacktime` = 0 WHERE `entry` = 18057; -- 381 927 -- 2,343 - 2,889

-- Bonechewer Ripper 17281,18055
UPDATE `creature_template` SET `mindmg`='496',`maxdmg`='643' WHERE `entry` = 17281; -- 154 301 -- 496 - 643 --
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='0', `mindmg`='2720',`maxdmg`='3230', `baseattacktime` = 1304, `pickpocketloot` = 17281 WHERE `entry` = 18055; -- 977 1998 -- 5,439 - 6,460
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17281;
INSERT INTO `creature_ai_scripts` VALUES 
(1728101, 17281, 2, 0, 100, 6, 30, 0, 0, 0, 11, 18501, 0, 0, 1, -46, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Casts Enrage at 30% HP'),
(1728102, 17281, 4, 0, 100, 6, 0, 0, 0, 0, 11, 29651, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Casts Dual Wield on Aggro'),
(1728103, 17281, 1, 0, 100, 7, 2000, 2000, 15000, 15000, 17, 159, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Set Stand State OOC'),
(1728104, 17281, 1, 0, 100, 7, 4000, 4000, 15000, 15000, 17, 169, 71, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Emote Cheer OOC'),
(1728105, 17281, 1, 0, 100, 7, 5700, 5700, 15000, 15000, 17, 159, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Set Kneel State OOC'),
(1728106, 17281, 0, 0, 100, 7, 10000, 10000, 10000, 10000, 11, 30659, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 'Bonechewer Ripper - Workaround slowly enrage, should be casted by 17478 when they die');

-- Bonechewer Ravener 17264,18054
UPDATE `creature` SET `spawndist`='0' WHERE `guid` IN (62012,62013);
UPDATE `creature_template` SET `mindmg`='452',`maxdmg`='638' WHERE `entry` = 17264; -- 125 311 -- 452 - 638
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832', `armor` = 7089, `equipment_id`='953',`mindmg`='2442',`maxdmg`='2897', `baseattacktime` = 1200, `lootid` = 17264, `pickpocketloot` = 17264 WHERE `entry` = 18054; -- 880 1790 -- 4,883 - 5,793
UPDATE `creature_ai_scripts` SET `event_flags`='7',`event_chance`='10',`event_param1`='60000',`event_param2`='60000',`event_param3`='180000',`event_param4`='180000' WHERE `id` = 1726401;
UPDATE `creature_ai_scripts` SET `event_flags`='6' WHERE `id` = 1726402;
UPDATE `creature_ai_scripts` SET `event_param1`='3500',`event_param2`='5500',`event_param3`='12100',`event_param4`='15200' WHERE `id` = 1726403;
DELETE FROM `creature_ai_scripts` WHERE `id` = 1726404;
INSERT INTO `creature_ai_scripts` VALUES
(1726404,17264,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Bonechewer Ravener - Casts Dual Wield on Aggro');

-- Bonechewer Hungerer 17259,18053
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 17259;
UPDATE `creature` SET `MovementType`='1',`spawndist`='3' WHERE `guid` IN (200917,200918,99985,99986);
UPDATE `creature_template` SET `mindmg`='452',`maxdmg`='638' WHERE `entry` = 17259; -- 125 311 -- 452 - 638
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832',`equipment_id`='928',`mindmg`='2720',`maxdmg`='3230', `baseattacktime` = 0, `pickpocketloot` = 17259 WHERE `entry` = 18053; -- 977 1998 -- 5,439 - 6,460
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='5',`event_param3`='2400',`event_param4`='5800' WHERE `id` = 1725904;

-- Bonechewer Destroyer 17271,18052
UPDATE `creature` SET `id`='17271',`equipment_id`='1429' WHERE `guid` IN (99982,99983);
UPDATE `creature_template` SET `mindmg`='816',`maxdmg`='1152', `baseattacktime` = 2000 WHERE `entry` = 17271; -- 226 562 -- 816 - 1152
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832', `equipment_id`='1429',`mindmg`='3343',`maxdmg`='3971', `lootid` = 17271, `pickpocketloot` = 17271 WHERE `entry` = 18052; -- 1201 2456 -- 4457 5294 -- 6,686 - 7,941
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='5' WHERE `id` = 1727102;
UPDATE `creature_ai_scripts` SET `event_param1`='5000',`event_param2`='10000',`event_param3`='5000',`event_param4`='15000' WHERE `id` = 1727103;

-- Bonechewer Beastmaster 17455,18051
UPDATE `creature_template` SET `equipment_id`='359',`mindmg`='280',`maxdmg`='536',`mechanic_immune_mask`='545338715' WHERE `entry` = 17455; -- 140 - 268
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `equipment_id`='359',`mindmg`='1817',`maxdmg`='2570', `baseattacktime`  = 1289, `lootid` = 17455, `pickpocketloot` = 17455, `mechanic_immune_mask`='545338715' WHERE `entry` = 18051; -- 800 1000 -- 1817-2570
DELETE FROM `creature_template_addon` WHERE `entry` IN (17455,18051);
INSERT INTO `creature_template_addon` VALUES
(17455,0,0,0,0,0,0,0,'18950 0 18950 1'),
(18051,0,0,0,0,0,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17455;
INSERT INTO `creature_ai_scripts` VALUES
('1745501','17455','4','0','100','6','0','0','0','0','1','-179','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Yell on Aggro'),
('1745502','17455','0','0','100','7','4200','12400','15200','20500','11','9128','0','1','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Cast Battle Shout'),
('1745503','17455','0','0','100','7','1200','10400','10800','21700','11','10966','1','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster - Cast Uppercut'),
('1745504','17455','0','0','100','2','20000','20000','0','0','1','-180','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Normal) - Yell For Summon Shattered Hand Warhounds'),
('1745505','17455','0','0','100','4','15000','15000','0','0','1','-180','0','0','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Heroic) - Yell For Summon Shattered Hand Warhounds'),
('1745506','17455','0','0','100','2','20000','20000','0','0','12','17280','1','300','12','17280','1','30000','4','10161','0','0','Bonechewer Beastmaster (Normal) - Summon 2 Shattered Hand Warhounds'),
('1745507','17455','0','0','100','4','15000','15000','0','0','12','17280','1','300','12','17280','1','30000','4','10161','0','0','Bonechewer Beastmaster (Heroic) - Summon 2 Shattered Hand Warhounds'),
('1745508','17455','0','0','50','2','20000','20000','0','0','12','17280','1','30000','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Normal) - Summon 3th Shattered Hand Warhound'),
('1745509','17455','0','0','50','4','15000','15000','0','0','12','17280','1','30000','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Heroic) - Summon 3th Shattered Hand Warhound'),
('1745510','17455','0','0','50','2','20000','20000','0','0','12','17280','1','30000','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Normal) - Summon 4th Shattered Hand Warhound'),
('1745511','17455','0','0','50','4','15000','15000','0','0','12','17280','1','30000','0','0','0','0','0','0','0','0','Bonechewer Beastmaster (Heroic) - Summon 4th Shattered Hand Warhound');

-- Bleeding Hollow Scryer 17478,18050
UPDATE `creature_template` SET `equipment_id` = '4001',`mindmg`='416',`maxdmg`='561' WHERE `entry` = 17478; -- 123 268 -- 416 - 561
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `equipment_id` = '4001',`mindmg`='1111',`maxdmg`='1362',`baseattacktime` = 1303, `lootid` = 17478, `pickpocketloot` = 17478 WHERE `entry` = 18050; -- 367 869 -- 2,221 - 2,723
DELETE FROM `creature_template_addon` WHERE `entry` IN (17478,18050);
INSERT INTO `creature_template_addon` VALUES
(17478,0,0,0,0,4096,193,0,''),
(18050,0,0,0,0,4096,193,0,'');
DELETE FROM `creature_equip_template` WHERE `creature_equip_template`.`entry` = 4001;
INSERT INTO `creature_equip_template` (`entry`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `equipinfo1`, `equipinfo2`, `equipinfo3`, `equipslot1`, `equipslot2`, `equipslot3`) VALUES
(4001, 45947, 0, 0, 50268674, 0, 0, 529, 0, 0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17478;
INSERT INTO `creature_ai_scripts` VALUES (1747801, 17478, 1, 0, 100, 6, 0, 0, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Prevent Combat Movement on Spawn');
INSERT INTO `creature_ai_scripts` VALUES (1747802, 17478, 4, 0, 10, 6, 100, 0, 0, 0, 1, -156, -181, -672, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Random Say on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1747803, 17478, 4, 0, 100, 2, 0, 0, 0, 0, 11, 12471, 1, 1, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer (Normal) - Cast Shadowbolt and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1747804, 17478, 9, 5, 100, 3, 0, 40, 2700, 4700, 11, 12471, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer (Normal) - Cast Shadowbolt (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1747805, 17478, 4, 0, 100, 4, 0, 0, 0, 0, 11, 15232, 1, 1, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer (Heroic) - Cast Shadowbolt and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1747806, 17478, 9, 5, 100, 5, 0, 40, 2700, 4700, 11, 15232, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer (Heroic) - Cast Shadowbolt (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1747807, 17478, 3, 5, 100, 6, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1747808, 17478, 9, 5, 100, 6, 35, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Start Combat Movement at 35 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1747809, 17478, 9, 5, 100, 6, 5, 8, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Prevent Combat Movement at 8 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1747810, 17478, 9, 5, 100, 6, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Start Combat Movement Below 5 Yards');
INSERT INTO `creature_ai_scripts` VALUES (1747811, 17478, 3, 3, 100, 7, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Set Phase 1 when Mana is above 30% (Phase 2)');
INSERT INTO `creature_ai_scripts` VALUES (1747812, 17478, 0, 0, 100, 7, 6600, 23500, 17100, 23800, 11, 30615, 5, 32, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fear');
-- INSERT INTO `creature_ai_scripts` VALUES (1747813, 17478, 2, 0, 100, 6, 15, 0, 0, 0, 11, 30659, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion at 15% HP (THIS SHOULD BE CAST ON BONECHEWER RIPPER ON DEATH BUT IS A CORE LIMITATION CURRENTLY)');
INSERT INTO `creature_ai_scripts` VALUES (1747814, 17478, 7, 0, 100, 6, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Set Phase to 0 on Evade');
INSERT INTO `creature_ai_scripts` VALUES (1747815, 17478, 4, 0, 5, 6, 0, 0, 0, 0, 1, -674, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - More Random Say on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1747816, 17478, 1, 0, 100, 7, 1000, 1000, 0, 0, 11, 31059, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Warlock Channeling OOC');
DELETE FROM `creature_ai_scripts` WHERE `id` IN (1747817,1747818,1747819,1747820,1747821,1747822,1747823);
INSERT INTO `creature_ai_scripts` VALUES
(1747817, -85637, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85642, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747818, -85639, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85642, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747819, -85641, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85642, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747820, -85646, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85652, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747821, -85650, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85652, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747822, -85649, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85652, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death'),
(1747823, -85648, 0, 0, 100, 7, 1000, 1000, 1000, 1000, 44, 30659, 85652, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Scryer - Cast Fel Infusion on Bonechewer Ripper at death');
DELETE FROM `spell_script_target` WHERE `entry` = 30659;
INSERT INTO `spell_script_target` VALUES (30659, 1, 17281);
INSERT INTO `spell_script_target` VALUES (30659, 1, 18055);

-- Bleeding Hollow Darkcaster 17269,18049
UPDATE `creature` SET `id` = 17269, `equipment_id` = 0 WHERE `guid` = 200911;
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 17269;
UPDATE `creature_template` SET `mindmg`='307',`maxdmg`='427' WHERE `entry` = 17269; -- 173 413 -- 613 - 853
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832', `equipment_id`='1280',`mindmg`='1110',`maxdmg`='1360', `baseattacktime` = 1200, `lootid` = 17269, `pickpocketloot` = 17269 WHERE `entry` = 18049; -- 368 868 -- 2,220 - 2,720
DELETE FROM `creature_template_addon` WHERE `entry` IN (17269,18049);
INSERT INTO `creature_template_addon` VALUES
(17269,0,0,0,0,4096,0,0,''),
(18049,0,0,0,0,4096,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17269;
INSERT INTO `creature_ai_scripts` VALUES (1726901, 17269, 1, 0, 100, 6, 0, 0, 0, 0, 21, 1, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Prevent Combat Movement and Set Phase to 0 on Spawn');
INSERT INTO `creature_ai_scripts` VALUES (1726902, 17269, 4, 0, 100, 2, 0, 0, 0, 0, 11, 15241, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Normal) - Cast Scorch and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1726903, 17269, 9, 5, 100, 3, 0, 30, 2400, 4900, 11, 15241, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Normal) - Cast Scorch (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1726904, 17269, 4, 0, 100, 4, 0, 0, 0, 0, 11, 36807, 1, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Heroic) - Cast Scorch and Set Phase 1 on Aggro');
INSERT INTO `creature_ai_scripts` VALUES (1726905, 17269, 9, 5, 100, 5, 0, 30, 2400, 4900, 11, 36807, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Heroic) - Cast Scorch (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1726906, 17269, 3, 5, 100, 6, 15, 0, 0, 0, 21, 1, 0, 0, 23, 1, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1726907, 17269, 9, 5, 100, 6, 25, 80, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Start Combat Movement at 25 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1726908, 17269, 9, 5, 100, 6, 5, 8, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Prevent Combat Movement at 8 Yards (Phase 1)');
INSERT INTO `creature_ai_scripts` VALUES (1726909, 17269, 9, 5, 100, 6, 0, 5, 0, 0, 21, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Start Combat Movement Below 5 Yards');
INSERT INTO `creature_ai_scripts` VALUES (1726910, 17269, 3, 3, 100, 7, 100, 30, 100, 100, 23, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Set Phase 1 when Mana is above 30% (Phase 2)');
INSERT INTO `creature_ai_scripts` VALUES (1726911, 17269, 0, 0, 100, 3, 11600, 23300, 22700, 33400, 11, 20754, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Normal) - Cast Rain of Fire');
INSERT INTO `creature_ai_scripts` VALUES (1726912, 17269, 0, 0, 100, 5, 11600, 23300, 22700, 33400, 11, 36808, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster (Heroic) - Cast Rain of Fire');
INSERT INTO `creature_ai_scripts` VALUES (1726913, 17269, 7, 0, 100, 6, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Set Phase to 0 on Evade');
INSERT INTO `creature_ai_scripts` VALUES (1726914, 17269, 1, 0, 2, 7, 60000, 60000, 180000, 180000, 1, -9998, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Bleeding Hollow Darkcaster - Random Say OOC');

-- recheck weiter

-- Bleeding Hollow Archer 17270,18048
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='32832', `equipment_id`='1105',`mindmg`='2052',`maxdmg`='2569',`minrangedmg`='750',`maxrangedmg`='1250',`pickpocketloot`='17270' WHERE `entry` = 18048; -- 479 1255 281,739 399,315
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17270;
INSERT INTO `creature_ai_scripts` VALUES
('1727001','17270','4','0','10','6','0','0','0','0','1','-158','-160','-157','0','0','0','0','0','0','0','0','Bleeding Hollow Archer - Random Say on Aggro'), -- -156','-181','-672'=160
('1727002','17270','0','0','100','7','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Bleeding Hollow Archer - Start Movement and Set Melee Weapon Model'),
('1727003','17270','9','0','100','7','5','30','2300','4000','11','18651','1','0','40','2','0','0','21','0','0','0','Bleeding Hollow Archer - Cast Multi Shot and Set Ranged Weapon Model and Stop Movement'),
-- ('1727004','17270','9','0','100','3','5','30','2300','5000','11','18651','1','0','40','2','0','0','21','0','0','0','Bleeding Hollow Archer (Normal) - Cast Multi Shot and Set Ranged Weapon Model and Stop Movement'),
-- ('1727005','17270','9','0','100','5','5','30','2300','5000','11','31942','1','0','40','2','0','0','21','0','0','0','Bleeding Hollow Archer (Heroic) - Cast Multi Shot and Set Ranged Weapon Model and Stop Movement'),
('1727006','17270','0','0','100','7','12100','15300','13300','18200','11','30614','4','1','40','2','0','0','21','0','0','0','Bleeding Hollow Archer - Cast Aimed Shot and Set Ranged Weapon Model and Stop Movement'),
-- ('1727007','17270','9','0','50','3','5','30','2000','5000','11','15620','1','0','40','2','0','0','21','0','0','0','Bleeding Hollow Archer (Normal) - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
-- ('1727008','17270','9','0','50','5','5','30','2000','5000','11','22907','1','0','40','2','0','0','21','0','0','0','Bleeding Hollow Archer (Heroic) - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
('1727009','17270','9','0','100','6','0','5','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Bleeding Hollow Archer - Start Movement and Set Melee Weapon Model Below 6 Yards'),
('1727010','17270','9','0','100','6','6','15','0','0','21','0','0','0','40','2','0','0','0','0','0','0','Bleeding Hollow Archer - Stop Movement and Set Ranged Weapon Model Above 5 Yards');

-- General

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

-- Watchkeeper Gargolmar 17306,18436
-- heroic - hits tank for 2K.
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64', `mindmg`='300',`maxdmg`='600',`mechanic_immune_mask`='787431423' WHERE `entry` = 17306;
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64', `armor`='7400',`mindmg`='2897',`maxdmg`='3418',`pickpocketloot`='17306',`mechanic_immune_mask`='787431423' WHERE `entry` = 18436; -- 3622 4272 -- 7,243 - 8,544

-- Hellfire Watcher <Watchkeeper's Subordinate> 17309,18058
UPDATE `creature_template` SET `mindmg`='370',`maxdmg`='486' WHERE `entry` = 17309; --  113 229 -- 370 - 486
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64', `equipment_id` ='1024',`mindmg`='932',`maxdmg`='1145', `baseattacktime` = 0, `pickpocketloot` = 17309 WHERE `entry` = 18058; -- 306 732 2000 -- 1,863 - 2,289
UPDATE `creature_ai_scripts` SET `event_param3`='12000',`event_param4`='15000' WHERE `id` = 1730904;
UPDATE `creature_ai_scripts` SET `event_param4`='15000' WHERE `id` IN (1730902,1730903);
DELETE FROM `creature_ai_scripts` WHERE `id` = 1730905;
INSERT INTO `creature_ai_scripts` VALUES
('1730905','17309','14','0','100','7','1000','40','12000','15000','11','8362','6','0','0','0','0','0','0','0','0','0','Hellfire Watcher - Casts Renew on Friendlies');

-- Omor the Unscarred 17308,18433
UPDATE `creature` SET `position_x` = -1122.34, `position_y` = 1718.41, `position_z` = 89.4315, `orientation` = 3.75246 WHERE `guid` = 62087;
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64', `mindmg`='800',`maxdmg`='1600',`baseattacktime`='1400', `unit_flags` = 68,`mechanic_immune_mask`='787431423' WHERE `entry` = 17308;  -- 1,443 - 1,875
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64',`armor`='5954',`resistance5`='200',`mindmg`='2852',`maxdmg`='3387', `unit_flags` = 68,`mechanic_immune_mask`='787431423' WHERE `entry` = 18433; -- 2852 3387 -- 4,279 - 5,081

-- Fiendish Hound 17540,18056
UPDATE `creature_template` SET `minlevel`='62',`maxlevel`='62',`armor`='3450',`speed`='1.20',`mindmg`='300',`maxdmg`='900',`baseattacktime`='1289',`AIName` = 'EventAI' WHERE `entry` = 17540; -- 710 1060 -- 187 - 242
UPDATE `creature_template` SET `armor`='5474',`mindmg`='1720',`maxdmg`='2230',`baseattacktime`='0' WHERE `entry` = 18056; -- 2293 2973 -- 3,439 - 4,460
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17540;
INSERT INTO `creature_ai_scripts` VALUES
('1754001','17540','9','0','100','5','0','30','6000','12000','11','15785','4','0','0','0','0','0','0','0','0','0','Fiendish Hound (Heroic) - Cast Mana Burn'),
('1754002','17540','2','0','100','3','75','0','7000','10000','11','35748','4','0','0','0','0','0','0','0','0','0','Fiendish Hound - Cast Drain Life at 75% HP'), -- 30%
('1754003','17540','7','0','100','5','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Fiendish Hound - Die on Evade');

-- Vazruden the Herald 17307 Flying ?

-- Nazan 17536,18432
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `resistance1`='105',`resistance2`='105',`resistance3`='105',`resistance4`='105',`resistance5`='105',`resistance6`='105',`mechanic_immune_mask`='787431423', `baseattacktime` = 2000 WHERE `entry` = 17536; -- 404 797
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `resistance1`='210',`mindmg`='3186',`maxdmg`='3854',`skinloot`='70065',`mechanic_immune_mask`='787431423',`MovementType`='2',`flags_extra`='1', `baseattacktime` = 2000 WHERE `entry` = 18432;

-- Vazruden 17537,18434
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `mindmg`='500',`maxdmg`='1000',`mechanic_immune_mask`='787431423',`baseattacktime` = 2000 WHERE `entry` = 17537; -- 437 862
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1', `mindmg`='4870',`maxdmg`='5287',`mechanic_immune_mask`='787431423',`MovementType`='1',`baseattacktime` = 2000 WHERE `entry` = 18434;

-- ======================================================
-- Spawns & Pooling
-- ======================================================

DELETE FROM `creature` WHERE `guid` = 99989;
INSERT INTO `creature` (`guid`,`id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
('99989','17270','543','3','-1148.2196','1497.3516','68.4024','2.9934','7200','0','0');

-- ======================================================
-- Group & Respawn Linking
-- ======================================================

DELETE FROM `creature_formations` WHERE `leaderGUID` IN (62020,61997,61995,200949,99978,200917,200921,62083,99986,200936,200922,200927,200938,200943,62016,61994,61996,63011,85642,85652,200939,200941,18,15,200911,14,61999,99983,62012,200952,200933,200929,200933,200949);
DELETE FROM `creature_formations` WHERE `memberGUID` IN (62020,61997,61995,200949,99978,200917,200921,62083,99986,200936,200922,200927,200938,200943,62016,61994,61996,63011,85642,85652,200939,200941,18,15,200911,14,61999,99983,62012,200952,200933,200929,200933,200949);

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES 
('200917', '200916', '60', '360', '2'),
('200917', '23', '60', '360', '2'),
('200917', '200918', '60', '360', '2'),
('200917', '200917', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('62020', '62020', '60', '360', '2'),
('62020', '62021', '60', '360', '2'),
('62020', '62022', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('99978', '99978', '60', '360', '2'),
('99978', '99977', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('200949', '200949', '60', '360', '2'),
('200949', '200955', '3', '2', '2'),
('200949', '200956', '3', '4', '2');
INSERT INTO `creature_formations` VALUES 
('200933', '200933', '60', '360', '2'),
('200933', '200934', '60', '360', '2'),
('200933', '200935', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('200929', '200929', '60', '360', '2'),
('200929', '200930', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('85642', '85642', '60', '360', '2'),
('85642', '85637', '60', '360', '2'),
('85642', '85639', '60', '360', '2'),
('85642', '85641', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('18', '18', '60', '360', '2'),
('18', '200914', '60', '360', '2'),
('18', '200915', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('15', '15', '60', '360', '2'),
('15', '200912', '60', '360', '2'),
('15', '200913', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('200911', '200911', '60', '360', '2'),
('200911', '62018', '60', '360', '2'),
('200911', '62023', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('14', '14', '60', '360', '2'),
('14', '62000', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('61999', '61999', '60', '360', '2'),
('61999', '61998', '60', '360', '2');
INSERT INTO `creature_formations` VALUES 
('62012', '62012', '60', '360', '2'),
('62012', '200953', '3', '2', '2'),
('62012', '200954', '3', '4', '2');
INSERT INTO `creature_formations` VALUES 
('200952', '200952', '60', '360', '2'),
('200952', '200951', '3', '2', '2'),
('200952', '200950', '3', '4', '2'); 

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200921', '200919', '60', '360', '2'),
('200921', '200921', '60', '360', '2'),
('200921', '99984', '60', '360', '2'),
('200921', '200920', '60', '360', '2');

-- grouped movement for 1st boss adds
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('62083', '62088', '5', '1', '2'),
('62083', '62089', '5', '5', '2'),
('62083', '62083', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('99986', '99981', '60', '360', '2'),
('99986', '99980', '60', '360', '2'),
('99986', '99985', '60', '360', '2'),
('99986', '99986', '60', '360', '2');

-- link + completing grp
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200936', '200936', '60', '360', '2'),
('200936', '99988', '60', '360', '2'),
('200936', '99987', '60', '360', '2'),
('200936', '200937', '60', '360', '2'),
('200936', '99989', '60', '360', '2');

DELETE FROM `creature_formations` WHERE `leaderGUID` = 200922;
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200922', '200922', '60', '360', '2'),
('200922', '200925', '60', '360', '2'),
('200922', '200924','60', '360', '2'),
('200922 ', '200923', '60', '360', '2'),
('200922 ', '200910', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200927', '200927','60', '360', '2'),
('200927', '200926','60', '360', '2'),
('200927', '200928', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200938', '200938', '60', '360', '2'),
('200938', '99900', '60', '360', '2');

INSERT INTO `creature_formations` VALUES 
('85652', '85652', '60', '360', '2'),
('85652', '85646', '60', '360', '2'),
('85652', '85648', '60', '360', '2'),
('85652', '85649', '60', '360', '2'),
('85652', '85650', '60', '360', '2');

INSERT INTO `creature_formations` VALUES 
('200939', '200939', '60', '360', '2'),
('200939', '200940', '60', '360', '2');

INSERT INTO `creature_formations` VALUES 
('99983', '99983', '60', '360', '2'),
('99983', '99982', '60', '360', '2'),
('99983', '86360', '60', '360', '2');

INSERT INTO `creature_formations` VALUES 
('200941', '200941', '60', '360', '2'),
('200941', '200942', '60', '360', '2'),
('200941', '62019', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('200943', '200943', '60', '360', '2'),
('200943', '200947', '60', '360', '2'),
('200943', '200946', '60', '360', '2'),
('200943', '200945', '60', '360', '2'),
('200943', '200944', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('62016', '62016', '60', '360', '2'),
('62016', '62067', '60', '360', '2'),
('62016', '62017', '60', '360', '2'),
('62016', '62064', '60', '360', '2');

-- grouped movement 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('61995', '61995', '60', '360', '2'),
('61995', '61994', '3', '360', '2');
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 61995;
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 61994;

-- grouped movement 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('61997', '61997', '60', '360', '2'),
('61997', '61996', '3', '360', '2');
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 61997;
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 61996;

-- linking last boss adds
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('63011', '63011', '60', '360', '2'),
('63011', '63012', '60', '360', '2');

DELETE FROM `creature_linked_respawn` WHERE `guid` = 99989;
INSERT INTO `creature_linked_respawn` VALUES
(99989,62087);

-- ======================================================
-- Respawn
-- ======================================================

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

UPDATE `creature` SET `equipment_id` ='1280' WHERE `guid` IN (99977,99978);

DELETE FROM `creature_addon` WHERE `guid` IN (85642,85652,62020,99982,99983);
INSERT INTO `creature_addon` VALUES
-- (85642,0,0,0,0,4097,0,0,''),
-- (85652,0,0,0,0,4097,0,0,'');
-- kneel
(85642,0,0,0,8,4097,0,0,''),
(85652,0,0,0,8,4097,0,0,'');

DELETE FROM `creature_template_addon` WHERE `entry` IN (18048,18053,17264,18054,17280,18059,18052,18049,18058,18057,17517);
INSERT INTO `creature_template_addon` VALUES
(18048,0,0,512,0,4098,0,0,''),
(18053,0,0,16777472,0,4097,0,0,''),
(17264,0,0,16777472,0,4097,0,0,'18950 0 18950 1'),
(18054,0,0,16777472,0,4097,0,0,'18950 0 18950 1'),
(17280,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(18059,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(18052,0,0,16777472,0,4097,0,0,''),
(18049,0,0,0,0,4096,0,0,''),
(18058,0,0,2048,0,4097,0,0,''),
(18057,0,0,16777472,0,4097,0,0,''),
(17517,0,0,16777472,0,4097,0,0,'');

UPDATE creature SET position_x = '-1184.730835', position_y = '1453.478271', position_z = '68.439384', orientation = '1.172138',`MovementType`='0',`spawndist`='0' WHERE guid = 62088;
UPDATE creature SET position_x = '-1178.800659', position_y = '1452.270264', position_z = '68.430794', orientation = '1.410114',`MovementType`='0',`spawndist`='0' WHERE guid = 62089;

DELETE FROM `creature_addon` WHERE `guid` = 62083;
INSERT INTO `creature_addon` VALUES 
(62083,62083,0,16777472,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = 62083;
INSERT INTO `waypoint_data` VALUES 
('62083','1','-1169.96','1474.88','68.4357','0','0','0','100','0'),
('62083','2','-1170.63','1511.93','68.4449','0','0','0','100','0'),
('62083','3','-1196.09','1540.39','68.4821','3000','0','0','100','0'),
('62083','4','-1170.63','1511.93','68.4449','0','0','0','100','0'),
('62083','5','-1169.96','1474.88','68.4357','0','0','0','100','0'),
('62083','6','-1181.54','1452.92','68.4353','3000','0','0','100','0');
DELETE FROM `waypoint_data` WHERE `id` = 61997;
INSERT INTO `waypoint_data` VALUES 
('61997','1','-1327.4836','1661.3322','93.2683','0','0','0','100','0'),
('61997','2','-1345.0452','1684.6530','90.2198','0','0','0','100','0'),
('61997','3','-1361.7486','1701.9191','84.4676','0','0','0','100','0'),
('61997','4','-1374.3369','1714.3691','82.8427','0','0','0','100','0'),
('61997','5','-1361.7486','1701.9191','84.4676','0','0','0','100','0'),
('61997','6','-1345.0452','1684.6530','90.2198','0','0','0','100','0'),
('61997','7','-1327.4836','1661.3322','93.2683','0','0','0','100','0');
DELETE FROM `waypoint_data` WHERE `id` = 61995;
INSERT INTO `waypoint_data` VALUES 
('61995','1','-1271.6276','1640.7673','91.6450','0','0','0','100','0'),
('61995','2','-1236.8786','1660.6995','92.6799','0','0','0','100','0'),
('61995','3','-1271.6276','1640.7673','91.6450','0','0','0','100','0');

UPDATE `waypoint_data` SET `action`='1068' WHERE `id` IN (200932) AND `point` IN (5,10);
UPDATE `waypoint_data` SET `action`='1000' WHERE `id` IN (200932) AND `point` IN (6,11);
UPDATE `waypoint_data` SET `action`='1068' WHERE `id` IN (200931) AND `point` IN (1,7,13);
UPDATE `waypoint_data` SET `action`='1000' WHERE `id` IN (200931) AND `point` IN (2,8,14);
UPDATE `waypoint_data` SET `action`='1068' WHERE `id` IN (200948) AND `point` IN (1,4,13);
UPDATE `waypoint_data` SET `action`='1000' WHERE `id` IN (200948) AND `point` IN (2,5,14);

SET @GUID := 86360;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,''); -- 1817
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (86360, 1, -1279.48, 1541.65, 68.5788, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 2, -1276.81, 1551.19, 68.0778, 1000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 3, -1288.84, 1543.69, 68.0947, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 4, -1291.91, 1547.43, 68.6043, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 5, -1287.21, 1543.23, 68.5932, 1000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 6, -1277.49, 1540.49, 68.5745, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 7, -1280.36, 1543.57, 68.5816, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 8, -1282.43, 1545.78, 68.5867, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 9, -1284.81, 1537.81, 68.5853, 1000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 10, -1289.31, 1553.19, 68.6038, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 11, -1282.18, 1549.24, 68.5888, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 12, -1284.69, 1546.26, 68.591, 1000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 13, -1286.31, 1543.59, 68.5919, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 14, -1286.87, 1553.08, 68.5995, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 15, -1291.56, 1543.9, 68.6012, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 16, -1284.3, 1546.04, 68.5902, 1000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 17, -1285.29, 1542.65, 68.5895, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (86360, 18, -1283.74, 1545.23, 68.5886, 0, 0, 0, 100, 0);

UPDATE `creature_addon` SET `auras` = '18950 0 18950 1' WHERE `guid` IN (200931,200932,200949,200952);

SET @GUID := 62012;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'18950 0 18950 1');
DELETE FROM `waypoint_data` WHERE `id` IN (1410,@GUID);
INSERT INTO `waypoint_data` VALUES (62012, 1, -1257.71, 1651, 67.9137, 5000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62012, 2, -1277.2553, 1670.4768, 68.7051, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62012, 3, -1257.71, 1651, 67.9137, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62012, 4, -1249, 1629.44, 68.5386, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62012, 5, -1248.3504, 1603.1793, 68.5528, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62012, 6, -1249, 1629.44, 68.5386, 0, 0, 0, 100, 0);

SET @GUID := 62013;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 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,'18950 0 18950 1');
DELETE FROM `waypoint_data` WHERE `id` IN (1411,@GUID);
INSERT INTO `waypoint_data` VALUES (62013, 1, -1294.61, 1671.99, 67.6775, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 2, -1306.92, 1669.19, 65.5432, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 3, -1316.17, 1666.43, 66.9309, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 4, -1325.66, 1663.59, 68.6933, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 5, -1333.06, 1660.84, 68.7694, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 6, -1341.02, 1656.47, 68.7922, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 7, -1333.15, 1660.58, 68.7765, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 8, -1322.8172, 1665.2110, 68.28718, 0, 0, 0, 100, 0);  -- -1321.47, 1664.95, 68.1255
INSERT INTO `waypoint_data` VALUES (62013, 9, -1309.64, 1668.51, 65.7793, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 10, -1299.97, 1671.23, 66.5435, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (62013, 11, -1287.35, 1673.12, 68.7382, 0, 0, 0, 100, 0);

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

-- Reinforced Fel Iron Chest 185168,185169
UPDATE `gameobject_template` SET `size` = 1.5 WHERE `entry` IN (185168,185169);

-- ======================================================
-- Miscellaneous
-- ======================================================

DELETE FROM `item_template` WHERE `entry` IN (10612,11589,10616,22215,13698,12629,11365,3494,11506,13504,18419);
INSERT INTO `item_template` (entry, class, subclass, displayid, inventorytype, sheath) VALUES
(10612,2,0,19550,13,3), -- 1h axe, Bonechewer Hungerer
(11589,4,6,21553,14,4), -- Shield, Bonechewer Hungerer
(10616,2,15,19555,13,3), -- Dagger, Bonechewer Ravener
(22215,2,15,34560,13,3), -- Dagger, Bonechewer Ravener
(13698,2,10,24394,17,2), -- Staff, Bleeding Hollow Darkcaster
(12629,2,0,22893,13,3), -- 1h axe, Bleeding Hollow Archer
(11365,2,10,21341,17,2), -- Staff, Hellfire Watcher
(3494,2,13,7430,13,7), -- Fist, Bonechewer Beastmaster
(11506,2,13,21144,22,7), -- OH fist, Bonechewer Beastmaster
(13504,2,8,24167,13,3), -- 1h sword, Hellfire Sentry
(18419,2,1,18419,17,1); -- 2h axe, Bonechewer Destroyer

-- Vazruden - Hellfire Ramparts - Dungeons - Visual Bug
UPDATE `gameobject_template` SET `data2` = '0' WHERE `entry` = 182533;