Serpentshrine Cavern

[Xadras]

Complete Raid Overhaul for Serpentshrine Cavern with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

---

ToDo:

• Implement Hidden Spells: 31691, 38651, 26567, 37026, 37545
• Tidewalker Depth-Seer Channeling autocancels -> general problem with channelled npc spells
• 1800 Damage static Charge
• The Mark of Hydross and Mark of Corruption debuffs can now affect the increases of the nature or frost damage taken up to 500%.
• https://bitbucket.org/looking4group_b2tbc/hellground-wowemu/commits/bcb95a18b15ebc69b64f988efac92d653c24c23b
• Add SPELL_ATTR_EX5_START_PERIODIC_AT_APPLY to Vashj Sporebat Spores

---

• [ ] The creatures that lead up to Hydross the Unstable and creatures at the six pumping stations are now on a 2 hour respawn instead of 45 minutes.
• [ ] Slight changes on most creatures have been made including: aggro range changed to 30 yards detect, 15 yard call for help and hitpoints reduced. (Boss specific adds are not affected by this hitpoint reduction.)
• [ ] Slightly reduced the number of creatures from the cavern entrance.
• [ ] Modified the patrol patterns of some of the murlocs in Morogrim's room to make them easier to pull.
• [ ] Non-boss creatures in Serpentshrine will now no longer respawn if the nearby boss has been killed, and should not respawn while in combat with the boss in question.
• [ ] Fixed an issue with Hydross where you would kill him and he would instead change into his alternate form with 1 health.
• [ ] The Mark of Hydross and Mark of Corruption debuffs can now affect the increases of the nature or frost damage taken up to 500%.
• [ ] Refreshing Mist now correctly restores health.
• [ ] Fixed an exploit related to Leotheras' Consuming Madness spell.
• [ ] Lady Vashj can no longer use the ability Persuasion.
• [ ] Toxic Spores no longer deal damage upon impact.
• [ ] Tidewalker Lurkers no longer call for help from other nearby creatures.
• [ ] Greyheart Technicians are now much easier to kill, and deal less damage.
• [ ] Coilfang Priestesses may now be polymorphed.
• [ ] Coilfang Priestess' Holy Fire spell now deals Holy damage, and the damage dealt by the spell has been lowered.
• [ ] Morogrim Tidewalker's Earthquake no longer obeys line of sight restrictions
• [ ] Creatures in the Serpentshrine now have a chance to drop Coilfang Armaments.
• [ ] Hydross the Unstable's Vile Sludge spell will no longer hit pets.
• [ ] Hydross the Unstable's melee damage has been reduced.
• [ ] The spawns of Hydross have fewer hit points.
• [ ] The Coilfang Frenzy now does increased melee damage, but Scalding Water damage has been decreased.
• [ ] Leotheras the Blind's Chaos Blast radius has been significantly reduced, which will allow additional melee to damage Leotheras while he is in metamorphosis form.
• [ ] Leotheras the Blind will now also spend less time whirlwinding before shifting into his metamorphosis form.
• [ ] Leotheras the Blind's hit points have been reduced.
• [ ] Inner Demons are now slightly easier to kill and deal less damage.
• [ ] Serpentshrine Lurkers are now banishable and fearable, and no longer create mushrooms so quickly.
• [ ] Morogrim Tidewalker has been moved to a more central location in his room.
• [ ] Hydross the Unstable's hit points have been slightly reduced.
• [ ] Colossus Ragers have had their health reduced significantly.

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

---

• [ ] Tempest Keep and Coilfang raid bosses will now all drop at least 3 items each.

• [ ] Coilfang Priestesses no longer perform Spirit of Redemption.

• [ ] Underbog Colossus' Acid Spray is now somewhat less dangerous.

• [ ] Underbog Colossus' Spore Quake now has a shorter duration.

• [ ] Greyheart Tidecallers' Virulent poison is now less deadly.

• [ ] Serpentshrine Sporebats now charge less frequently.

• [ ] Greyheart Nether-Mages now blink less frequently.

• [ ] Serpentshrine Lurkers have had their damage output reduced.

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

---

• [ ] The Circular platform in The Lurker Below encounter was a bit changed. There are now small ramps on its borders, making it easier to get back onto it. The platform where the ranged adds appear remains unchanged.
• [ ] Whirlwind animation for Leotheras the Blind was fixed and no longer looks insanely buggy.

http://wowwiki.wikia.com/wiki/Patch_2.3.0_(undocumented_changes)

---

• [ ] You may now fight Prince Kael'thas and Lady Vashj without first killing all the other bosses in their respective dungeons.

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

[Xadras]

Sources:

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

http://www.wowhead.com/zone=3607/serpentshrine-cavern , http://wowwiki.wikia.com/wiki/Serpentshrine_Cavern , http://wow.gamepedia.com/Serpentshrine_Cavern

https://bitbucket.org/looking4group_b2tbc/hellfire/src/febfc44387e9ff9477b3b78f4fd3bc15963207c2/src/scripts/scripts/zone/coilfang_resevoir/serpent_shrine/?at=master

https://github.com/FeenixServerProject/Archangel_2.4.3_Bugtracker/issues/1656 , http://www.worldofstrats.com/MorogrimTidewalker/tabid/55/Default.aspx

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

http://wowwiki.wikia.com/wiki/Hydross_the_Unstable , http://wowwiki.wikia.com/wiki/Hydross_the_Unstable?direction=next&oldid=529780

http://web.archive.org/web/20100127162817/http://www.hordeguides.de/index.php?ra=3607

https://docs.google.com/spreadsheets/d/1vwQq5KfK0s0HvUF2taafPnP5JDLPZWaDCDTM299rEGk/edit#gid=0

Videos:

https://www.youtube.com/watch?v=RttIwB-NZLw&feature=youtu.be - Leo 21215 Leash

https://www.youtube.com/watch?v=Mz4NZIF5Pa8 - Lady Vashj vs Method Part 1

https://www.youtube.com/watch?v=pVvAnj2HzFg - Lady Vashj vs Method Part 2

https://www.youtube.com/watch?v=siCBD90IJ7k - WoW - SSC - Fathom-Lord Karathress

https://www.youtube.com/watch?v=YCFaA9bV2mE - Solo guide: Serpentshrine Cavern - World of Warcraft [Full Run] {Commentary}

https://www.youtube.com/watch?v=2-hC-RVPq7c - SSC Elevator

https://www.youtube.com/watch?v=oneS53Efw74 - How to Hydross The Unstable Guide. 2.4.3 TBC World Of Warcraft

https://www.youtube.com/watch?v=yRx0UoZHDnM - Serpentshrine Cavern - trash vs Granto

https://www.youtube.com/watch?v=0ZRFZKPMBWo - World of Warcraft - Serpentshrine Cavern Raid

https://www.youtube.com/watch?v=ZXm4lkyNNpQ - Trash before Leo

[Xadras]

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/2326
-- Coilfang: Serpentshrine Cavern  
--
-- ======================================================
-- Texts & Scripts
-- ======================================================
--
-- -9700 - -9710
DELETE FROM `creature_ai_texts` WHERE `entry` IN (-9700,-9701,-9702,-9703,-9704,-9705,-9706,-9707);
INSERT INTO `creature_ai_texts` VALUES
(-9700,'Be wary of intruders.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21299 OOC'),
(-9701,'Stay alert!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21299 OOC'),
(-9702,'Understood.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21298 answer to 21299'),
(-9703,'Enough! I have had enough of you filthy warm bloods!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'21218 on 50% Enrage'),
(-9704,'Don\'t let the levels get too low.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21218 OOC'),
(-9705,'FASTER!!!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21218 OOC'),
(-9706,'Keep regulating the main valve to ensure steady flow.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21218 OOC'),
(-9707,'We appear to be on target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'21218 on Aggro?');

UPDATE `script_texts` SET `content_default`='Be gone, trifling elf. I am in control now!' WHERE `entry` = -1548010;
UPDATE `script_texts` SET `content_default`='Finally, my banishment ends!' WHERE `entry` = -1548009;

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

-- Coilfang Frenzy 21508
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='500',`maxdmg`='800',`baseattacktime`='1000',`mechanic_immune_mask`='1073741823',`flags_extra`='536936448',`InhabitType`='2' WHERE `entry` = 21508; -- 1 392 696 2000 0 0
DELETE FROM `creature_template_addon` WHERE `entry` = 21508;
INSERT INTO `creature_template_addon` VALUES (21508,0,0,0,0,0,0,33554432,NULL);

-- Coilfang Frenzy Corpse 21689
-- Morogrim
UPDATE `creature_template` SET `dynamicflags`= 36, `unit_flags` = 33554433 WHERE `entry` = 21689;
DELETE FROM `creature_template_addon` WHERE `entry` = 21689;
INSERT INTO `creature_template_addon` VALUES (21689, 0, 0, 0, 7, 0, 0, 268435456, '37284 35357'); -- 7

-- Colossus Rager 22352
-- http://www.wowhead.com/npc=22352/colossus-rager#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1671',`maxdmg`='1985',`baseattacktime`='1400' WHERE `entry` = 22352; -- 300 614 2000

-- Serpentshrine Lurker 21863
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8358',`maxdmg`='9926',`baseattacktime`='1400',`resistance3`= 0,`mechanic_immune_mask`='1073692671' WHERE `entry` = 21863; -- 3003 6139 2000 1 -- 16,716 - 19,852
-- pre 2.1 1073692671 post patch 2.1 `mechanic_immune_mask`='1073561599'
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21863;
INSERT INTO `creature_ai_scripts` VALUES
('2186301','21863','9','0','100','3','0','100','4000','8000','11','38655','1','0','0','0','0','0','0','0','0','0','Serpentshrine Lurker - Cast Poison Bolt Volley'),
-- ('2186302','21863','9','0','100','3','0','5','18900','18900','11','38650','0','1','0','0','0','0','0','0','0','0','Serpentshrine Lurker - Cast Rancid Mushroom Primer'),
('2186303','21863','9','0','100','3','0','5','5000','10000','12','22250','1','20000','0','0','0','0','0','0','0','0','Serpentshrine Lurker - Spawn Rancid Mushroom'); -- 17990

-- Rancid Mushroom 22250
UPDATE `creature_template` SET `modelid_A`='11686',`modelid_H`='11686',`faction_A`='14',`faction_H`='14',`armor`='6800',`flags_extra`='0',`unit_flags`= 262148,`speed`='0.0001',`mindmg`='0',`maxdmg`='0',`attackpower`='0',`resistance3`= 0 WHERE `entry` = 22250; -- 7999 7999 35 35 0 128 4
DELETE FROM `creature_template_addon` WHERE `entry` = 22250; 
INSERT INTO `creature_template_addon` VALUES (22250,0,0,0,0,0,0,0,'38652 0 38652 1 31690 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22250;
INSERT INTO `creature_ai_scripts` VALUES
('2225001','22250','0','0','100','3','1000','1000','3000','3000','11','31698','0','7','0','0','0','0','0','0','0','0','Rancid Mushroom - Cast Grow'),
('2225002','22250','6','0','100','2','0','0','0','0','11','38652','0','7','0','0','0','0','0','0','0','0','Rancid Mushroom - Cast Spore Cloud on Death'),
('2225003','22250','0','0','100','2','20000','20000','0','0','11','38652','0','7','37','0','0','0','0','0','0','0','Rancid Mushroom - Cast Spore Cloud and Die');

-- Coilfang Beast-Tamer 21221
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='10577',`maxdmg`='12562',`mechanic_immune_mask`='1073692671'  WHERE `entry` = 21221; -- 3705 7576 -- 7933 9422 -- 15,865 - 18,843
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21221;
INSERT INTO `creature_ai_scripts` VALUES
('2122101','21221','9','0','100','3','5','35','2000','3000','11','38904','4','0','0','0','0','0','0','0','0','0','Coilfang Beast-Tamer - Cast Throw'),
('2122102','21221','9','0','100','3','0','5','4900','10900','11','38474','1','0','0','0','0','0','0','0','0','0','Coilfang Beast-Tamer - Cast Cleave'),
('2122103','21221','0','0','100','3','2000','9000','19300','23400','11','38484','0','1','0','0','0','0','0','0','0','0','Coilfang Beast-Tamer - Cast Bestial Wrath');

-- Coilfang Fathom-Witch 21299- http://wowwiki.wikia.com/wiki/Coilfang_Fathom-Witch?direction=next&oldid=784889
UPDATE `creature_template` SET `armor`='5700',`speed`='1.48',`mindmg`='4206',`maxdmg`='4993',`mechanic_immune_mask`='1073692671'  WHERE `entry` = 21299; -- 5414 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21299;
INSERT INTO `creature_ai_scripts` VALUES
('2129901','21299','1','0','100','2','0','0','0','0','21','1','0','0','22','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Combat Movement and Set Phase to 0 on Spawn'),
('2129902','21299','4','0','100','2','0','0','0','0','11','38628','1','0','23','1','0','0','0','0','0','0','Coilfang Fathom-Witch - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('2129903','21299','9','5','100','3','0','45','5200','9200','11','38628','1','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Cast Shadow Bolt (Phase 1)'),
('2129904','21299','3','5','100','2','7','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Coilfang Fathom-Witch - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('2129905','21299','9','5','100','2','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Start Combat Movement at 35 Yards (Phase 1)'),
('2129906','21299','9','5','100','2','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Prevent Combat Movement at 15 Yards (Phase 1)'),
('2129907','21299','9','5','100','2','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Start Combat Movement Below 5 Yards (Phase 1)'),
('2129908','21299','3','3','100','3','100','15','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Set Phase 1 when Mana is above 15% (Phase 2)'),
('2129909','21299','0','0','100','3','8200','12200','36300','49300','11','38627','0','1','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Cast Shadow Nova'),
('2129910','21299','9','0','100','3','0','10','11900','16100','11','38626','5','1','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Cast Domination on TARGET_T_HOSTILE_WPET_RANDOM_NOT_TOP'),
('2129911','21299','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Coilfang Fathom-Witch - Set Phase to 0 on Evade');

-- Coilfang Hate-Screamer 21339- http://wowwiki.wikia.com/wiki/Coilfang_Hate-Screamer
-- Silence: PBAoE silence for 4 seconds, 30 yard range. Nerfed 20yards atm
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5607',`maxdmg`='6657',`mechanic_immune_mask`='1073692671',`flags_extra`='4194304' WHERE `entry` = 21339; -- 1913 4087 1 0 -- 4206 4993 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21339;
INSERT INTO `creature_ai_scripts` VALUES
('2133901','21339','0','0','100','3','5000','9000','10500','19600','11','38491','0','7','0','0','0','0','0','0','0','0','Coilfang Hate-Screamer - Cast PBAoE Silence'),
('2133902','21339','0','0','100','3','6100','11200','4800','12000','11','38496','4','0','0','0','0','0','0','0','0','0','Coilfang Hate-Screamer - Cast Sonic Scream');

-- Coilfang Priestess 21220
UPDATE `creature_template` SET `armor`='5950',`speed`='1.71',`mindmg`='5607',`maxdmg`='6657',`baseattacktime`='1400',`mechanic_immune_mask`='0',`flags_extra`='0' WHERE `entry` = 21220; -- 1513 3087 -- 8,411 - 9,985
-- 69649 after patch 2.1 `mechanic_immune_mask`='0'
-- Smite Holy Nova Shadow Word: Pain and Sprit of Redemption 15 seconds after death. 
-- http://wowwiki.wikia.com/wiki/Coilfang_Priestess?oldid=770831 , http://de.wowhead.com/npc=21220/priesterin-des-echsenkessels#english-comments
-- Prenerf Spirit of Redemption on Death, unkillable and 15sec kill self -> morph to 12904
-- Holy Nova on Death
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21220;
INSERT INTO `creature_ai_scripts` VALUES
('2122001','21220','1','0','100','2','0','0','0','0','21','1','0','0','22','0','0','0','19','6','0','0','Coilfang Priestess - Start Movement and Set Phase to 0 OOC'),
('2122002','21220','4','0','100','2','0','0','0','0','22','1','0','0','42','1','0','0','39','50','0','0','Coilfang Priestess - Set Phase 1 and Set Minhealth to 1 and Call for Help on Aggro'),
('2122003','21220','9','6 ','100','3','0','50','5000','7000','11','38582','1','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Holy Smite (Phase 1)'),
('2122004','21220','9','6 ','100','3','0','8','5000','10000','11','38589','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Holy Nova (Phase 1)'),
('2122005','21220','3','6 ','100','2','7','0','0','0','21','1','0','0','22','2','0','0','0','0','0','0','Coilfang Priestess - Start Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('2122006','21220','9','6 ','100','2','45','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Start Movement at 45 Yards (Phase 1)'),
('2122007','21220','9','6 ','100','2','5','40','0','0','21','0','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Prevent Movement at 30 Yards (Phase 1)'),
('2122008','21220','9','6 ','100','2','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Start Movement Below 5 Yards (Phase 1)'),
('2122009','21220','3','5','100','3','100','15','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Set Phase 1 when Mana is above 15% (Phase 2)'),
('2122010','21220','9','4','100','3','0','45','10400','14200','11','38585','4','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Holy Fire'),
('2122011','21220','14','4','100','3','40000','40','5000','10000','11','38580','6','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Greater Heal on Friendlies'),
('2122012','21220','2','4','100','2','80','0','15000','20000','11','38580','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Greater Heal at 80% HP'),
('2122013','21220','2','4','100','2','50','0','0','0','11','38580','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Greater Heal at 50% HP'),
('2122014','21220','2','4','100','2','20','0','0','0','11','38580','0','0','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Greater Heal at 20% HP'),
('2122015','21220','9','4','100','3','0','30','5400','7200','11','37275','4','32','0','0','0','0','0','0','0','0','Coilfang Priestess - Cast Shadow Word: Pain'),
('2122016','21220','2','0','100','2','1','0','0','0','11','38589','0','7','3','0','16031','0','22','3','0','0','Coilfang Priestess - Cast Holy Nova and Morph and Set Phase 3 at 1% HP'),
('2122017','21220','2','0','100','2','1','0','0','0','21','0','0','0','20','0','0','0','18','6','0','0','Coilfang Priestess - Stop Movement and Stop Melee and Set Unattackable at 1% HP'),
('2122018','21220','14','3','100','3','1000','40','2000','2000','11','38580','6','1','21','0','0','0','20','0','0','0','Coilfang Priestess - Cast Greater Heal and Stop Movement and Stop Melee on Friendlies (Phase 3)'),
('2122019','21220','7','0','100','2','0','0','0','0','22','0','0','0','3','0','0','0','19','6','0','0','Coilfang Priestess - Set Phase 0 and Demorph and Set Attackable on Evade'),
('2122020','21220','7','0','100','2','0','0','0','0','21','1','0','0','20','1','0','0','0','0','0','0','Coilfang Priestess - Start Movement and Melee on Evade'),
('2122021','21220','0','3','100','2','14750','14750','0','0','34','24','1','0','3','0','0','0','0','0','0','0','Coilfang Priestess - Set Instance Data 1 and Demorph to 0 (Phase 3)'),
('2122022','21220','0','3','100','2','15000','15000','0','0','42','0','0','0','37','0','0','0','0','0','0','0','Coilfang Priestess - Set Minhealth to 0 and Die after 15sec (Phase 3)');

-- Coilfang Serpentguard 21298
-- Cleave  Corrupt Devotion Aura 38603 Spell Reflection 38599 No CC
-- http://wowwiki.wikia.com/wiki/Coilfang_Serpentguard?direction=next&oldid=777756 , http://www.wowhead.com/npc=21298/coilfang-serpentguard#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7366',`maxdmg`='8749',`baseattacktime`='1400',`mechanic_immune_mask`='1073692667'  WHERE `entry` = 21298; -- 2646 5411 2000 -- 14,732 - 17,497
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21298;
INSERT INTO `creature_ai_scripts` VALUES
('2129801','21298','4','0','100','2','0','0','0','0','11','38603','0','7','0','0','0','0','0','0','0','0','Coilfang Serpentguard - Cast Corrupt Devotion Aura on Aggro'),
('2129802','21298','0','0','75','3','4900','7700','9900','13900','11','38599','0','0','0','0','0','0','0','0','0','0','Coilfang Serpentguard - Cast Spell Reflection'),
('2129803','21298','9','0','50','3','0','5','15900','18900','11','31779','0','0','0','0','0','0','0','0','0','0','Coilfang Serpentguard - Cast Cleave');

-- Coilfang Shatterer 21301
-- 3000 - 4500 damage to tanks Shatter Armor No CC
-- http://www.wowhead.com/npc=21301/coilfang-shatterer#comments , http://wowwiki.wikia.com/wiki/Coilfang_Shatterer?direction=next&oldid=1145233
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8000',`maxdmg`='12000',`baseattacktime`='1400',`mechanic_immune_mask`='1073692667' WHERE `entry` = 21301; -- 2646 5411 2000 -- -- 14,732 - 17,497
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21301;
INSERT INTO `creature_ai_scripts` VALUES
('2130101','21301','9','0','100','3','0','5','9200','11500','11','38591','1','32','0','0','0','0','0','0','0','0','Coilfang Shatterer - Cast Shatter Armor'),
('2130102','21301','6','0','100','2','0','0','0','0','34','24','1','0','0','0','0','0','0','0','0','0','Coilfang Shatterer - Set Instance Data 1'),
-- ('2130102','21301','29','0','100','2','1000','1000','0','0','35','1','0','0','0','0','0','0','0','0','0','0','Coilfang Shatterer - Set Instance Data64 (SD2) on Timer'),
('2130103','21301','4','0','100','2','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Coilfang Shatterer - Cast Dual Wield on Aggro');

-- Colossus Lurker 22347
-- http://wowwiki.wikia.com/wiki/Colossus_Lurker?direction=next&oldid=785020 , http://www.wowhead.com/npc=22347/colossus-lurker#comments
UPDATE `creature_template` SET `armor`='7100',`speed`='1.71',`mindmg`='9443',`maxdmg`='11216',`baseattacktime`='1400',`mechanic_immune_mask`='1073741823' WHERE `entry` = 22347; -- 2544 5203 -- -- 14,165 - 16,824

-- Greyheart Nether-Mage 21230
-- only Sheepable immune to cast speed reduce ( all casters )
-- Decides whether Fire 38635 38636 38641 Frost 38644 38645 38646 Arcane 38633 38634, additional Blink 38642 38643 and Buff 38647 38648 38649 depending on specc chosen maybe 38632 for visual something
-- http://www.wowhead.com/npc=21230/greyheart-nether-mage#comments , http://wowwiki.wikia.com/wiki/Greyheart_Nether-Mage?direction=prev&oldid=993664 , http://wowwiki.wikia.com/wiki/Greyheart_Nether-Mage?direction=next&oldid=1185956
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4206',`maxdmg`='4993',`baseattacktime`='1400',`mechanic_immune_mask`='1073627115' WHERE `entry` = 21230; -- 1513 3087 2000 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21230;
INSERT INTO `creature_ai_scripts` VALUES
('2123001','21230','11','0','100','2','0','0','0','0','30','1','3','5','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Random Phase Select on Spawn'),
('2123002','21230','4','125','100','2','0','0','0','0','11','38645','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Frostbolt on Aggro (Phase 1)'),
('2123003','21230','9','125','100','3','0','40','1200','4800','11','38645','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Frostbolt (Phase 1)'),
('2123004','21230','9','125','100','3','0','5','8000','12000','11','38644','0','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Cone of Cold (Phase 1)'),
('2123005','21230','0','125','100','3','6000','12000','8400','12000','11','38646','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Blizzard (Phase 1)'),
('2123006','21230','1','125','100','3','1000','1000','1800000','1800000','11','38649','0','1','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Frost Destruction OOC (Phase 1)'),
('2123007','21230','16','125','100','3','38649','1','5000','5000','11','38649','0','32','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Frost Destruction on Missing Buff (Phase 1)'),
('2123008','21230','1','119','100','3','1000','1000','1800000','1800000','11','38648','0','1','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Fire Destruction OOC (Phase 3)'),
('2123009','21230','4','119','100','2','0','0','0','0','11','38641','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Fireball on Aggro (Phase 3)'),
('2123010','21230','9','119','100','3','0','40','1200','4800','11','38641','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Fireball (Phase 3)'),
('2123011','21230','0','119','100','3','6000','12000','8400','12000','11','38635','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Rain of Fire (Phase 3)'),
('2123012','21230','9','119','100','2','0','30','9000','12000','11','38636','1','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Scorch (Phase 3)'),
('2123013','21230','16','119','100','3','38648','1','5000','5000','11','38648','0','32','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Fire Destruction on Missing Buff (Phase 3)'),
('2123014','21230','1','95','100','3','1000','1000','1800000','1800000','11','38647','0','1','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Arcane Destruction OOC (Phase 2)'),
('2123015','21230','4','95','100','2','0','0','0','0','11','38633','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Arcane Volley on Aggro (Phase 5)'),
('2123016','21230','9','95','100','3','0','40','4800','9600','11','38633','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Arcane Volley (Phase 5)'),
('2123017','21230','0','95','100','3','2000','6000','9600','12600','11','38634','4','0','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Arcane Lightning (Phase 5)'),
('2123018','21230','16','95','100','3','38647','1','5000','5000','11','38647','0','32','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Arcane Destruction on Missing Buff (Phase 5)'),
('2123019','21230','0','0','75','3','6000','18000','17000','24000','11','38642','0','1','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Cast Blink'),
('2123020','21230','7','0','100','2','0','0','0','0','30','1','3','5','0','0','0','0','0','0','0','0','Greyheart Nether-Mage - Random Phase Select on Evade');

-- Greyheart Shield-Bearer 21231
-- CC able ( Poly Sap Fear ) Charge 38630 ( should have meleedmg + X ) and Avenger's shield 38631
-- Being a holy priest he can usually one shot me on a charge.
-- http://www.wowhead.com/npc=21231/greyheart-shield-bearer#comments http://wowwiki.wikia.com/wiki/Greyheart_Shield-Bearer
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7083',`maxdmg`='8412',`baseattacktime`='1400',`mechanic_immune_mask`='461246433' WHERE `entry` = 21231; -- 2544 5203 2000 -- 14,165 - 16,824
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21231;
INSERT INTO `creature_ai_scripts` VALUES
('2123101','21231','9','0','100','3','8','25','10800','12800','11','38630','5','1','0','0','0','0','0','0','0','0','Greyheart Shield-Bearer - Cast Shield Charge'),
('2123102','21231','9','0','100','3','0','30','7600','12600','11','38631','4','1','0','0','0','0','0','0','0','0','Greyheart Shield-Bearer - Cast Avenger\'s Shield');

-- Greyheart Skulker 21232- http://wowwiki.wikia.com/wiki/Greyheart_Skulker?direction=next&oldid=1265744
-- 216000 HP Sheep / Disarm Fear Wyvern Sting  but immune to trap stuns
-- Random Kick in Melee Range
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`mindmg`='7932',`maxdmg`='9421',`baseattacktime`='1400',`mechanic_immune_mask`='6145' WHERE `entry` = 21232; -- 3562 7284 2000 -- 19,831 - 23,553
DELETE FROM `creature_template_addon` WHERE `entry` = 21232;
INSERT INTO `creature_template_addon` VALUES
(21232,0,0,512,0,4097,173,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21232;
INSERT INTO `creature_ai_scripts` VALUES
('2123201','21232','9','0','100','3','0','5','4800','7900','11','38625','4','0','0','0','0','0','0','0','0','0','Greyheart Skulker - Cast Kick'),
('2123202','21232','4','0','100','2','0','0','0','0','11','29651','0','7','0','0','0','0','0','0','0','0','Geyheart Skulker - Cast Dual Wield on Aggro');
-- ('2123203','21232','1','0','100','3','0','0','1000','1000','5','173','0','0','0','0','0','0','0','0','0','0','Geyheart Skulker - Emote work');

-- Greyheart Technician 21263
-- 24000 HP CC able
-- Harmstring http://www.wowhead.com/npc=21263/greyheart-technician#abilities , http://wowwiki.wikia.com/wiki/Greyheart_Technician
-- These mobs are NOT tied to the others on the platform, its possibly to aggro them without attracting the attention of the Naga. -> Recheck linking
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1133',`maxdmg`='1346',`baseattacktime`='1400' WHERE `entry` = 21263; -- 407 832 2000 -- 2,266 - 2,691
DELETE FROM `creature_template_addon` WHERE `entry` = 21263;
INSERT INTO `creature_template_addon` VALUES
(21263,0,0,512,0,4097,173,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21263;
INSERT INTO `creature_ai_scripts` VALUES
('2126301','21263','9','0','100','3','0','5','5300','9300','11','38995','4','32','0','0','0','0','0','0','0','0','Greyheart Technician - Cast Hamstring');
-- ('2126302','21263','29','0','100','2','1000','1000','0','0','35','1','0','0','0','0','0','0','0','0','0','0','Greyheart Technician - Set Instace Data64 (SD2) on Timer');
-- ('2126302','21263','1','0','100','3','0','0','1000','1000','5','173','0','0','0','0','0','0','0','0','0','0','Geyheart Technician - Emote work');

-- Greyheart Tidecaller 21229- mob_greyheart_tidecaller
-- 168000 HP fearable sheepable snare and rootable, but immune to trap  
-- Totem -> Elemantal , Poison Shield, Chain lightning with silence component http://looking4group.de/quelthalas/database/?spell=38624
-- http://wowwiki.wikia.com/wiki/Greyheart_Tidecaller?direction=next&oldid=1234828 , http://www.wowhead.com/npc=21229/greyheart-tidecaller#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5256',`maxdmg`='6240',`mechanic_immune_mask`='6145',`flags_extra`='4194304' WHERE `entry` = 21229; -- 1890 3858 -- 10,512 - 12,480
-- DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21229;
-- INSERT INTO `creature_ai_scripts` VALUES
-- ('2122901','21229','0','0','100','3','1000','10000','9500','13500','11','39027','0','0','0','0','0','0','0','0','0','0','Greyheart Tidecaller - Cast Poison Shield'),
-- ('2122902','21229','0','0','100','3','2300','3200','15700','23700','11','38624','0','0','0','0','0','0','0','0','0','0','Greyheart Tidecaller - Cast Water Elemental Totem'),
-- ('2122903','21229','9','0','100','3','0','30','5000','7000','11','38146','5','0','0','0','0','0','0','0','0','0','Greyheart Tidecaller - Cast Arcane Lightning');

-- Water Elemental Totem 22236 spell=38624
-- UPDATE `creature_template` SET `unit_flags`=`unit_flags`|'4'|'262144'  WHERE `entry` = 22236; -- TotemAI

-- Serpentshrine Tidecaller 22238 (Elemental)
-- http://looking4group.de/quelthalas/database/?spell=38624
-- 72000
-- Water Bolt Volley 38623 , Frost Nova 39035
-- http://www.wowhead.com/npc=22238/serpentshrine-tidecaller , http://wowwiki.wikia.com/wiki/Serpentshrine_Tidecaller?direction=next&oldid=1476724
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`mindmg`='4731',`maxdmg`='5616',`baseattacktime`='1400',`mechanic_immune_mask`='993859567'  WHERE `entry` = 22238; -- 1701 3472 2000 -- 9,461 - 11,232
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22238;
INSERT INTO `creature_ai_scripts` VALUES
('2223801','22238','0','0','100','3','1000','2400','11000','16000','11','38623','4','0','0','0','0','0','0','0','0','0','Serpentshrine Tidecaller - Cast Water Bolt Volley'),
('2223802','22238','9','0','100','3','0','8','16000','21000','11','39035','0','1','0','0','0','0','0','0','0','0','Serpentshrine Tidecaller - Cast Frost Nova');

-- Serpentshrine Sporebat 21246
-- 107150, 214300 Leben haben Spore Burst Charge 10-15 secs melee for 3000 on cloth. hacky charge fix
-- By 1313moridin (1,661 – 13·34) on 2007/04/30 (Patch 2.0.12) they only have alittle over 200k hp
-- http://wowwiki.wikia.com/wiki/Serpentshrine_Sporebat?direction=next&oldid=768437 , http://www.wowhead.com/npc=21246/serpentshrine-sporebat#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3000',`maxdmg`='5000',`baseattacktime`='1000',`mechanic_immune_mask`='0' WHERE `entry` = 21246; -- 1874 3809 2000 -- 2500 3500 7,649 - 9,084
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21246;
INSERT INTO `creature_ai_scripts` VALUES
('2124601','21246','9','0','50','2','6','30','0','0','11','38461','1','0','11','40602','1','0','0','0','0','0','Serpentshrine Sporebat - Cast Charge on Aggro'), -- 5 22120 -- 38461
('2124602','21246','9','0','100','3','0','5','15800','24000','11','38924','0','1','0','0','0','0','0','0','0','0','Serpentshrine Sporebat - Cast Spore Burst'),
('2124603','21246','0','0','100','3','10000','15000','10000','15000','11','38461','4','1','11','40602','4','1','0','0','0','0','Serpentshrine Sporebat - Cast Random Charge');

-- Tainted Water Elemental 21253
-- 13200 http://wowwiki.wikia.com/wiki/Tainted_Water_Elemental?direction=next&oldid=783566
-- These mobs move around Hydross the Unstable's platform Tainted Water Elemental's come from the right and stop in front of Hydross the Unstable and become Purified Water Elemental then continue along the platform
-- Elemental Spawn-in minievent relativ short respawn timer.
UPDATE `creature` SET `spawntimesecs`='720' WHERE `id` = 21253;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='850',`maxdmg`='1009',`baseattacktime`='1400',`dmgschool`='3' WHERE `entry` = 21253; -- 305 624 2000 -- 1,699 - 2,018
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21253;
INSERT INTO `creature_ai_scripts` VALUES
('2125301','21253','11','0','100','2','0','0','0','0','11','25035','0','0','0','0','0','0','0','0','0','0','Tainted Water Elemental - Cast Elemental Spawn-in on Spawn');

-- Purified Water Elemental 21260
-- 14400 http://wowwiki.wikia.com/wiki/Purified_Water_Elemental?direction=prev&oldid=795366
-- Elemental Spawn-in minievent relativ short respawn timer.
UPDATE `creature` SET `spawntimesecs`='720' WHERE `id` = 21260;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='850',`maxdmg`='1009',`baseattacktime`='1400',`dmgschool`='4' WHERE `entry` = 21260; -- 305 624 2000 -- 1,699 - 2,018
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21260;
INSERT INTO `creature_ai_scripts` VALUES
('2126001','21260','11','0','100','2','0','0','0','0','11','25035','0','0','0','0','0','0','0','0','0','0','Purified Water Elemental - Cast Elemental Spawn-in on Spawn');

-- Tidewalker Depth-Seer 21224
-- ~150000 -> 180000 plate for ~1500-2k 
-- 38657 38658 and uninterruptible tranquility 38659
-- Confirmed immune to all types of crowd control. but can be interrupted no silence abilitys
-- http://wowwiki.wikia.com/wiki/Tidewalker_Depth-Seer , http://www.wowhead.com/npc=21224/tidewalker-depth-seer#abilities
UPDATE `creature_template` SET `mindmg`='3784',`maxdmg`='4493',`baseattacktime`='1400',`mechanic_immune_mask`='1040138235',`flags_extra`='4194304'  WHERE `entry` = 21224; -- 1701 3472 2000 -- 9,461 - 11,232
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21224;
INSERT INTO `creature_ai_scripts` VALUES
('2122401','21224','2','0','100','3','75','0','25000','27000','11','38657','0','0','0','0','0','0','0','0','0','0','Tidewalker Depth-Seer - Cast Rejuvenation on Self'),
('2122402','21224','2','0','100','3','50','0','22000','31000','11','38658','0','0','0','0','0','0','0','0','0','0','Tidewalker Depth-Seer - Cast Healing Touch on Self'),
('2122403','21224','14','0','100','3','10000','40','13300','14500','11','38657','6','0','0','0','0','0','0','0','0','0','Tidewalker Depth-Seer - Cast Rejuvenation on Friendlies'),
('2122404','21224','14','0','100','3','25000','40','12000','21000','11','38658','6','0','0','0','0','0','0','0','0','0','Tidewalker Depth-Seer - Cast Healing Touch on Friendlies'),
('2122405','21224','2','0','100','3','20','0','12000','15000','11','38659','0','7','0','0','0','0','0','0','0','0','Tidewalker Depth-Seer - Cast Tranquility at 20% HP');

-- Tidewalker Harpooner 21227
-- 228000 They are immune to all forms of Crowd Control and Snares. 
-- These will net the tank they're on (immobilize) and drop aggro (permanent aggro drop, tanks need to taunt it back). They're not CC'able.
-- http://wowwiki.wikia.com/wiki/Tidewalker_Harpooner?oldid=1234855 , http://www.wowhead.com/npc=21227/tidewalker-harpooner#abilities
UPDATE `creature_template` SET `mindmg`='5100',`maxdmg`='6057',`mechanic_immune_mask`='1073692667' WHERE `entry` = 21227; -- 1832 3746 -- 10,199 - 12,113
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21227;
INSERT INTO `creature_ai_scripts` VALUES
('2122700','21227','0','0','100','3','1000','1000','2000','2000','21','1','0','0','0','0','0','0','0','0','0','0','Tidewalker Harpooner - Start Combat Movement'),
('2122701','21227','4','0','100','2','0','0','0','0','22','1','0','0','40','1','0','0','21','1','0','0','Tidewalker Harpooner - Set Phase 1 and Set Melee Weapon Model and Start Movement OOC'),
('2122702','21227','9','1','100','3','5','35','3000','4000','11','39060','1','0','40','2','0','0','21','0','0','0','Tidewalker Harpooner - Cast Throw and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('2122703','21227','9','1','100','3','5','30','7000','11000','11','39061','4','32','40','2','0','0','21','0','0','0','Tidewalker Harpooner - Cast Impale and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('2122704','21227','9','1','100','3','0','5','0','0','21','1','0','0','40','1','0','0','22','0','0','0','Tidewalker Harpooner - Start Combat Movement and Set Melee Weapon Model and Set Phase 0 at 5 Yards (Phase 1)'),
('2122705','21227','9','0','100','3','0','5','16800','25300','11','38661','1','1','13','-99','1','0','0','0','0','0','Tidewalker Harpooner - Cast Net and Reduces Threat'),
('2122706','21227','9','0','100','3','5','8','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Tidewalker Harpooner - Stop Combat Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)'),
('2122707','21227','7','0','100','2','0','0','0','0','22','1','0','0','40','1','0','0','0','0','0','0','Tidewalker Harpooner - Set Phase 1 and Set Melee Weapon Model on Evade');

-- Tidewalker Hydromancer 21228
-- 150000 -> 180000
-- 39063/frost-nova 39062/frost-shock 39064/frostbolt rare
-- Vulnerable to Stuns.These mobs can be both silenced and interrupted.These mobs are vulnerable to Curse of Tongues. 
-- http://www.wowhead.com/npc=21228/tidewalker-hydromancer#abilities http://wowwiki.wikia.com/wiki/Tidewalker_Hydromancer
UPDATE `creature_template` SET `mindmg`='3364',`maxdmg`='3994',`baseattacktime`='1400' WHERE `entry` = 21228; -- 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21228;
INSERT INTO `creature_ai_scripts` VALUES
('2122801','21228','9','0','100','3','0','40','7000','12000','11','39064','4','0','0','0','0','0','0','0','0','0','Tidewalker Hydromancer - Cast Frostbolt'),
('2122802','21228','9','0','100','3','0','20','12000','16000','11','39062','1','0','0','0','0','0','0','0','0','0','Tidewalker Hydromancer - Cast Frost Shock'),
('2122803','21228','9','0','100','3','0','8','12000','18000','11','39063','0','0','0','0','0','0','0','0','0','0','Tidewalker Hydromancer - Cast Frost Nova');

-- Tidewalker Shaman 21226
-- 180000 39066/chain-lightning 39065/lightning-bolt 39067/lightning-shield
-- They are immune to all forms of Crowd Control.Their spells can be interrupted, but they are immune to silence.They are immune to Curse of Tongues and snares. Can be stunned
-- http://www.wowhead.com/npc=21226/tidewalker-shaman#abilities , http://wowwiki.wikia.com/wiki/Tidewalker_Shaman
UPDATE `creature_template` SET `mindmg`='3364',`maxdmg`='3994',`baseattacktime`='1400',`mechanic_immune_mask`='1040136187' WHERE `entry` = 21226; -- 1513 3087 2000 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21226;
INSERT INTO `creature_ai_scripts` VALUES
('2122602','21226','1','0','100','3','1000','1000','600000','600000','11','39067','0','1','0','0','0','0','0','0','0','0','Tidewalker Shaman - Cast Lightning Shield OOC'),
('2122604','21226','9','0','100','3','0','40','5000','8000','11','39065','1','0','0','0','0','0','0','0','0','0','Tidewalker Shaman - Cast Lightning Bolt'),
('2122610','21226','16','0','100','3','39067','1','10000','20000','11','39067','0','32','0','0','0','0','0','0','0','0','Tidewalker Shaman - Cast Lightning Shield on Missing Buff'),
('2122611','21226','9','0','100','2','0','30','12000','18000','11','39066','4','0','0','0','0','0','0','0','0','0','Tidewalker Shaman - Cast Chain Lightning');

-- Tidewalker Warrior 21225
-- Cleave 39070/bloodthirst 39069/uppercut 38664/enrage gain frenzy every 20-25 -> uppercuts are blizzards aggro reset spells.
-- Repeat Drop Aggro, Frenzy can't be stunned, These mobs are vulnerable to Fear, Polymorph, tranq shot and Snares. They are vulnerable to Disarm 
-- http://www.wowhead.com/npc=21225/tidewalker-warrior#abilities , http://wowwiki.wikia.com/wiki/Tidewalker_Warrior
UPDATE `creature_template` SET `mindmg`='4532',`maxdmg`='5383',`baseattacktime`='1400' WHERE `entry` = 21225; -- 2035 4162  2000 -- 11,331 - 13,458
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21225;
INSERT INTO `creature_ai_scripts` VALUES
('2122501','21225','9','0','100','3','0','5','12000','15000','11','39070','1','1','0','0','0','0','0','0','0','0','Tidewalker Warrior - Cast Bloodthirst'),
('2122502','21225','0','0','100','3','12400','16100','15000','19000','11','39069','1','0','13','-99','1','0','0','0','0','0','Tidewalker Warrior - Cast Uppercut'),
('2122503','21225','0','0','100','3','7700','9300','20000','24600','11','38664','0','0','0','0','0','0','0','0','0','0','Tidewalker Warrior - Cast Frenzy'),
('2122504','21225','4','0','100','2','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Tidewalker Warrior - Cast Dual Wield on Aggro');

-- Vashj'ir Honor Guard 21218
-- Quotes missing cuz scripted
-- 260000 immune to all http://www.wowhead.com/npc=21218/vashjir-honor-guard#abilities http://wowwiki.wikia.com/wiki/Vashj%27ir_Honor_Guard?oldid=770642
-- 38959/execute 38947/frenzy on 50% + yell 38576/knockback 38572/mortal-cleave intimidating shout
-- yell on 50% hp + enrage: Enough! I have had enough of you filthy warm bloods!
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='11554',`maxdmg`='13332' WHERE `entry` = 21218; -- 2778 5000 -- 9629 11110 -- 14,443 - 16,665 mob_vashjir_honor_guard

-- Underbog Colossus 21251
-- 620000 2-3k on a tank http://wowwiki.wikia.com/wiki/Underbog_Colossus?direction=next&oldid=768654
-- different ai sets he is core scripted atm but poorly
-- set1 39031/enrage 39015/atrophic-blow
-- set2 38971/acid-geyser 39044/serpentshrine-parasite
-- spawns parasites that do lots of damage, but one hit kills them. 4 at a time 
-- Parasite - Does a ?2k dot to target, after dot a small 1hp 'parasite' will leave the infected person and go to a new target. Also spawns parasites if a parasite kills someone. 
-- set3 38976/spore-quake 39032/initial-infection
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='13856',`maxdmg`='16445',`mechanic_immune_mask`='1073692671',`flags_extra`='4194304' WHERE `entry` = 21251; -- 4571 6857 -- 620000 3109 6357 -- 17,308 - 20,556 mob_underbog_colossus

-- has random aura which increases the dmg it takes from a spellschool

-- random effects on death 38718/toxic-pool
-- Nothing.
-- Two big adds spawn. These need to be tanked.
-- 10-15 or so little adds spawn. AOE these down.
-- Blue mushrooms spawn. These put a heal/mana regain over time on you when you get close to them (if you run in and out of range you can stack the buff several times).
--
-- http://wowwiki.wikia.com/wiki/Underbog_Colossus?direction=next&oldid=768654 , http://www.wowhead.com/npc=21251/underbog-colossus#comments

-- Serpentshrine Parasite 22379
-- http://www.wowhead.com/npc=22379/serpentshrine-parasite#abilities http://wowwiki.wikia.com/wiki/Serpentshrine_Parasite
UPDATE `creature_template` SET `speed`='3',`mindmg`='10000',`maxdmg`='10000',`baseattacktime`='1000'  WHERE `entry` = 22379; -- 1 1 0 2222 2000

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

-- =================================
-- Hydross the Unstable <Duke of Currents> 21216
-- =================================

UPDATE `creature_template` SET `speed`='2.00',`mindmg`='6500',`maxdmg`='7500',`mechanic_immune_mask`='1072644095',`flags_extra`='4522017' WHERE `entry` = 21216; -- 6500 7500

-- Pure Spawn of Hydross 22035
-- Pure Spawns of Hydross has around 55,000 HP
UPDATE `creature_template` SET `mindmg`='3500',`maxdmg`='4500',`baseattacktime`='2000',`speed`='1.48',`resistance4`='-1',`AIName`='EventAI' WHERE `entry` = 22035; -- 55917 3500 4500 2000 -- 
DELETE FROM `creature_template_addon` WHERE `entry` = 22035; 
INSERT INTO `creature_template_addon` VALUES
(22035,0,0,512,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22035;
INSERT INTO `creature_ai_scripts` VALUES
('2203501','22035','11','0','100','2','0','0','0','0','11','25035','0','0','0','0','0','0','0','0','0','0','Pure Spawn of Hydross - Cast Elemental Spawn-in on Spawn');

-- Tainted Spawn of Hydross 22036
-- Tainted Spawn of Hydross has around 62,500 HP
UPDATE `creature_template` SET `mindmg`='3500',`maxdmg`='4500',`baseattacktime`='2000',`speed`='1.48',`resistance3`='-1',`AIName`='EventAI' WHERE `entry` = 22036; -- 62917 3500 4500 2000 --
DELETE FROM `creature_template_addon` WHERE `entry` = 22036; 
INSERT INTO `creature_template_addon` VALUES
(22036,0,0,512,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22036;
INSERT INTO `creature_ai_scripts` VALUES
('2203601','22036','11','0','100','2','0','0','0','0','11','25035','0','0','0','0','0','0','0','0','0','0','Tainted Spawn of Hydross - Cast Elemental Spawn-in on Spawn');

-- 21934 hydross trigger
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` = 21934;

-- ======================
-- The Lurker Below 21217
-- ======================

-- Hits tanks for 5000-9000 in melee http://wowwiki.wikia.com/wiki/The_Lurker_Below?direction=next&oldid=560965
UPDATE `creature_template` SET `speed`='3',`mindmg`='10900',`maxdmg`='18600',`baseattacktime`='2000',`mechanic_immune_mask`='1073692671' WHERE `entry` = 21217; -- 5311600 4738 9684 2000 -- 13000 24000 13186 15658 -- 26,371 - 31,317
-- UPDATE `creature_template` SET `mindmg`='6200',`maxdmg`='15700' WHERE `entry` = 21217; -- 5311600
UPDATE `creature_model_info` SET `bounding_radius`='17',`combat_reach`='17' WHERE `modelid` = 20216; -- 13  20

-- Coilfang Ambusher 21865
-- They have nasty burst damage and can Multishot for about 2.5k on leather. mob_coilfang_ambusher
UPDATE `creature_template` SET `mindmg`='3000',`maxdmg`='4000',`baseattacktime`='1400',`minrangedmg`='1000',`maxrangedmg`='2000',`speed`='1.48',`mechanic_immune_mask`='1' WHERE `entry` = 21865; -- 930 1898 2000 0 0 -- 2585 3069

-- Coilfang Guardian 21873
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8500',`maxdmg`='13000' WHERE `entry` = 21873; -- 3003 6139 -- 12800 16533 -- 16,716 - 19,852

-- =======================
-- Leotheras the Blind 21215
-- =======================

UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7911',`maxdmg`='12160',`baseattacktime`='2000',`mechanic_immune_mask`='1073692671' WHERE `entry` = 21215; -- 4494000(4.5 M HP) 1 2843 5810 2000 -- 3200 11000(12160) -- 9600 12800(dualwield doesnt need low value) -- 15,822 - 18,789

-- Shadow of Leotheras 21875
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='3200',`maxdmg`='6160',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671',`flags_extra`='1078001665' WHERE `entry` = 21875; -- 1.20 2843 5810 2000
-- UPDATE `creature_template` SET `mindmg`='6200',`maxdmg`='15700' WHERE `entry`='21215';

-- Leotheras Phase 3
UPDATE `creature_template` SET `mindmg`='3200',`maxdmg`='11000' WHERE `entry`='21845'; -- nonexistant

-- Greyheart Spellbinder 21806 mob_greyheart_spellbinder
-- Should cast Mindblast more frequent , kickable ( Core, also Core Spawned ) 
-- http://www.wowhead.com/npc=21806/greyheart-spellbinder#comments http://wowwiki.wikia.com/wiki/Greyheart_Spellbinder?direction=next&oldid=785172
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5700',`maxdmg`='7400',`mechanic_immune_mask`='1040138239',`flags_extra`='4194304'  WHERE `entry` = 21806; -- 2268 4630 -- 6308 7489 -- 12,615 - 14,977

-- Inner Demon 21857- mob_inner_demon
-- x1.1 will stay this value its already below 2.4.3
UPDATE `creature_template` SET `minhealth`='11550',`maxhealth`='12100', `speed`='1.20',`mindmg`='954',`maxdmg`='1259',`baseattacktime`='1400' WHERE `entry` = 21857; -- 10500-11000(12395) -- 11550-12100 -- 1 -- 718 1259 -- 1154 1370 -- 2,884 - 3,425

-- =================================
-- Fathom-Lord Karathress 21214
-- =================================

UPDATE `creature_template` SET `speed`='1.71',`mindmg`='11177',`maxdmg`='13266',`mechanic_immune_mask`='1073430527',`flags_extra`=`flags_extra`|'4194304' WHERE `entry` = 21214; -- 4519 8175 -- 6840 7630 -- 19,560 - 23,216
-- UPDATE `creature_template` SET `mindmg`='6840',`maxdmg`='7630' WHERE `entry`='21214';

-- Fathom-Guard Caribdis 21964
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4200',`maxdmg`='7100',`mechanic_immune_mask`='1039876095' WHERE `entry` = 21964; -- 1 2363 4823
-- UPDATE `creature_template` SET `mindmg`='4200',`maxdmg`='7100' WHERE `entry`='21964';

-- Fathom-Guard Tidalvess 21965
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='10800',`maxdmg`='15200',`mechanic_immune_mask`='1073692671' WHERE `entry` = 21965; -- 1 3969 8102 -- 22,076 - 26,209
-- UPDATE `creature_template` SET `mindmg`='8000',`maxdmg`='15200' WHERE `entry`='21965';

-- Fathom-Guard Sharkkis 21966
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7300',`maxdmg`='14000',`mechanic_immune_mask`='1073692671' WHERE `entry` = 21966; -- 1 2363 4823
-- UPDATE `creature_equip_template` SET `equipmodel3`='22031',`equipinfo3`='33492994',`equipslot3`='25' WHERE `entry` = 1041; -- 0 0 0

-- Fathom Lurker 22119
-- 204000 69 Elite no CC ( could be banished till 2.3 )
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4900',`maxdmg`='6200',`baseattacktime`='1400',`mechanic_immune_mask`='1073561599' WHERE `entry` = 22119; -- 2687 5495 -- 14,958 - 17,766
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22119;
INSERT INTO `creature_ai_scripts` VALUES
('2211901','22119','9','0','100','3','0','8','14000','21000','11','25778','1','0','13','-10','1','0','0','0','0','0','Fathom Lurker - Cast Knock Away');

-- Fathom Sporebat 22120
-- 69 Elite no CC http://www.wowhead.com/npc=22120/fathom-sporebat#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4900',`maxdmg`='6200',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 22120; -- 2687 5495 -- 14,958 - 17,766
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22120;
INSERT INTO `creature_ai_scripts` VALUES
('2212001','22120','9','0','100','3','0','8','14000','21000','11','25778','1','0','13','-10','1','0','0','0','0','0','Fathom Sporebat - Cast Knock Away');

-- Spitfire Totem 22091
UPDATE `creature_template` SET `armor`='6500',`speed`='0.001',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='393216',`dynamicflags`='8',`mechanic_immune_mask`='1073741823',`flags_extra`='65600' WHERE `entry` = 22091;

-- Greater Earthbind Totem 22486
UPDATE `creature_template` SET `armor`='6500',`speed`='0.001',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='393216',`dynamicflags`='8',`mechanic_immune_mask`='1073741823',`flags_extra`='65600' WHERE `entry` = 22486;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22486;
INSERT INTO `creature_ai_scripts` VALUES
('2248601','22486','0','0','100','3','1000','1000','5000','5000','11','3600','0','0','0','0','0','0','0','0','0','0','Greater Earthbind Totem - Cast Earthbind');

-- Greater Poison Cleansing Totem 22487
UPDATE `creature_template` SET `armor`='6500',`speed`='0.001',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='393216',`dynamicflags`='8',`mechanic_immune_mask`='1073741823',`flags_extra`='65600' WHERE `entry` = 22487;

-- Cyclone (Karathress)
UPDATE `creature_template` SET `minlevel` = 73, `maxlevel` = 73, `armor` = 20, `faction_A` = 14, `faction_H` = 14, `speed` = 1.125, `unit_flags` = 33554432, `type_flags` = 4, `MovementType` = 1, `flags_extra` = 0, `modelid_A` = 11686, `modelid_H` = 11686 WHERE `entry` = 22104;

-- ==========================
-- Morogrim Tidewalker 21213
-- ==========================

UPDATE `creature_template` SET `speed`='2',`mindmg`='16173',`maxdmg`='19207',`mechanic_immune_mask`='1073430527' WHERE `entry` = 21213; -- 5054 10330 -- 14064 16702 -- 28,128 - 33,404

-- Tidewalker Lurker 21920
UPDATE `creature_template` SET `mindmg`='1200',`maxdmg`='2220',`baseattacktime`='1400' WHERE `entry` = 21920; -- 611 1249 2000
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21920;
INSERT INTO `creature_ai_scripts` VALUES
('2192001','21920','9','0','100','3','0','5','5900','7100','11','41932','1','0','0','0','0','0','0','0','0','0','Tidewalker Lurker - Cast Carnivorous Bite'),
('2192002','21920','4','0','100','2','0','0','0','0','39','15','0','0','0','0','0','0','0','0','0','0','Tidewalker Lurker - Call for Help on Aggro'); -- 2.1 disable

-- Water Globule 21913
-- http://www.wowhead.com/npc=21913/water-globule

-- ===========================
-- Lady Vashj <Coilfang Matron> 21212
-- ===========================

-- http://wowwiki.wikia.com/wiki/Lady_Vashj_(tactics)?direction=next&oldid=882757
UPDATE `creature_template` SET `speed`='3',`mindmg`='8000',`maxdmg`='16000',`baseattacktime`='1800',`minrangedmg`='1500',`maxrangedmg`='3000',`mechanic_immune_mask`='1073430527' WHERE `entry` = 21212; -- 1 4398 8969 2000 0 0 -- 7200 157333

-- Tainted Elemental 22009   - This mob has 7,900 life
UPDATE `creature_template` SET `armor`='6800',`speed`='1.48',`mindmg`='169',`maxdmg`='299',`mechanic_immune_mask`='109264767' WHERE `entry` = 22009; -- 9250 20 1 1 131
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` = 11172; -- 0.61112

-- Enchanted Elemental 21958
-- mob_enchanted_elemental 7700
UPDATE `creature_template` SET `speed`='1.20',`mechanic_immune_mask`='109264767' WHERE `entry` = 21958;
UPDATE `creature_model_info` SET `bounding_radius`='2' WHERE `modelid` = 20076; -- 0.61112

-- Coilfang Elite 22055
-- (Pre Patch 2.1 about 340 000 HP) http://wowwiki.wikia.com/wiki/Lady_Vashj_(tactics)?direction=next&oldid=1200937
-- http://www.wowhead.com/npc=22055/coilfang-elite#comments , http://wowwiki.wikia.com/wiki/Coilfang_Elite?direction=next&oldid=784963
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='6400',`maxdmg`='13867',`mechanic_immune_mask`='1073420283' WHERE `entry` = 22055; -- 3129 6395 550183931 -- 8000 9400 8707 10340 -- 17,413 - 20,679 -- 

-- Coilfang Strider 22056
-- (Pre Patch 2.1 about 340 000 HP)
-- https://www.mmo-champion.com/threads/601152-Nihilum-take-Lady-Vashj-down-to-25-health
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='12000',`maxdmg`='15000',`mechanic_immune_mask`='1073427391',`flags_extra`='0' WHERE `entry` = 22056; -- 1 6007 12278 550183931 65536 -- 16717 19853 33,434 - 39,705

-- Toxic Spore Bat 22140
-- mob_toxic_sporebat
UPDATE `creature_template` SET `minlevel`=70,`maxlevel`=70,`speed`=1.20 WHERE `entry` = 22140; -- 70 73 6986 6986 1 -- 8000 8200

-- 22207 Trigger
-- UPDATE `creature_template` SET WHERE `entry` = 22207;

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

DELETE FROM `creature` WHERE `guid` IN (80273,178782);
INSERT INTO `creature` VALUES
(80273,21263,548,1,0,0,39.2109,-523.3978,0.7427,1.6433,2700,0,0,14362,0,0,0);

-- Respawn with correct GUID
DELETE FROM `creature` WHERE `guid` = 93838;
INSERT INTO `creature` VALUES (93838, 21217, 548, 1, 0, 0, 36.956867, -415.168793, -22.3911, 3.03312, 604800, 0, 0, 6905080, 0, 0, 0);-- -21.5911

INSERT INTO `creature` VALUES (93838, 21217, 548, 1, 0, 0, 39.2422, -416.1356, -21.5911, 3.03312, 3600000, 0, 0, 6905080, 0, 0, 0);

DELETE FROM `creature` WHERE `id` IN (21229,21230,21231);
DELETE FROM `creature` WHERE `guid` IN (93778,93785,93796);
INSERT INTO `creature` VALUES (80997, 21229, 548, 1, 0, 0, 334.2682, -430.3515, 28.8718, 6.2358, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (82756, 21229, 548, 1, 0, 2224, 374.2856, -347.3562, 21.8560, 5.4622, 7200, 0, 0, 143600, 48465, 0, 0);
-- INSERT INTO `creature` VALUES (82768, 21229, 548, 1, 0, 0, 553.778, -545.207, -7.23891, 2.79189, 7200, 0, 0, 143600, 48465, 0, 0);
-- INSERT INTO `creature` VALUES (82853, 21229, 548, 1, 0, 0, 561.644, -507.314, -13.1582, 3.055, 7200, 0, 0, 143600, 48465, 0, 0);
-- INSERT INTO `creature` VALUES (82862, 21229, 548, 1, 0, 0, 441.064, -512.791, -13.1582, 0.129391, 7200, 0, 0, 143600, 48465, 0, 0);
-- INSERT INTO `creature` VALUES (82959, 21229, 548, 1, 0, 0, 437.532, -481.711, -13.1582, 6.23586, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93774, 21229, 548, 1, 0, 0, 330.81, -350.956, 21.3821, 2.61292, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93775, 21229, 548, 1, 0, 0, 314.319, -329.828, 19.6541, 0.443651, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93776, 21229, 548, 1, 0, 0, 308.572, -367.721, 22.3129, 1.02799, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93777, 21230, 548, 1, 0, 0, 333.3426, -427.1696, 28.8718, 0.68634, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93781, 21229, 548, 1, 0, 2224, 423.121, -419.802, 9.39515, 1.14256, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93782, 21229, 548, 1, 0, 2224, 501.418, -454.667, -13.1574, 1.67115, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93783, 21229, 548, 1, 0, 2224, 496.749, -454.619, -13.1574, 1.67115, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93785, 21232, 548, 1, 0, 0, 324.7960, -435.9576, 29.0952, 3.9464, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93786, 21229, 548, 1, 0, 2224, 427.517, -422.144, 9.60363, 1.0813, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93797, 21229, 548, 1, 0, 0, 395.807, -354.966, 23.4089, 2.34588, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93800, 21229, 548, 1, 0, 0, 358.323, -317.66, 18.4688, 1.61074, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (198740, 21229, 548, 1, 0, 2224, 220.117, -430.829, -4.43271, 2.94987, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (202219, 21229, 548, 1, 0, 2224, 214.48, -509.495, -11.5361, 2.89592, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (208245, 21229, 548, 1, 0, 2224, 204.643, -613.358, -11.8273, 0.273917, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (210738, 21229, 548, 1, 0, 2224, 217.717, -264.914, -2.02762, 5.5094, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (257314, 21229, 548, 1, 0, 2224, 376.155, -498.513, 27.1909, 3.37391, 7200, 0, 0, 143600, 48465, 0, 0);

INSERT INTO `creature` VALUES (81912, 21230, 548, 1, 0, 1044, 369.8341, -350.7282, 21.6454, 5.4622, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93769, 21230, 548, 1, 0, 1044, 377.142, -511.228, 28.8012, 3.22154, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93778, 21232, 548, 1, 0, 0, 333.1330, -422.3574, 28.8717, 3.8365, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93779, 21229, 548, 1, 0, 0, 334.326, -427.819, 28.8718, 0.694979, 7200, 0, 0, 143600, 48465, 0, 2);
INSERT INTO `creature` VALUES (93790, 21230, 548, 1, 0, 0, 329.482, -346.314, 21.3023, 2.87367, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93795, 21230, 548, 1, 0, 0, 399.4429, -354.5076, 23.6099, 2.1189, 7200, 0, 0, 143600, 48465, 0, 2);
INSERT INTO `creature` VALUES (93796, 21232, 548, 1, 0, 0, 400.3313, -362.0697, 23.6713, 2.0788, 7200, 0, 0, 179525, 0, 0, 0);
INSERT INTO `creature` VALUES (93799, 21229, 548, 1, 0, 0, 346.7421, -319.6366, 18.5966, 1.6020, 7200, 5, 0, 143600, 48465, 0, 1);
INSERT INTO `creature` VALUES (93801, 21230, 548, 1, 0, 1044, 314.5498, -318.5748, 18.7143, 6.1651, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (93854, 21230, 548, 1, 0, 0, 309.366, -371.816, 22.3256, 0.790794, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (200581, 21230, 548, 1, 0, 1044, 226.337, -433.501, -4.43271, 2.87314, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (201667, 21230, 548, 1, 0, 1044, 231.933, -429.863, -4.43271, 1.88432, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (202652, 21230, 548, 1, 0, 1044, 221.87, -512.06, -11.5361, 2.77811, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (202740, 21230, 548, 1, 0, 1044, 224.503, -518.917, -11.5558, 3.68725, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (208340, 21230, 548, 1, 0, 1044, 198.197, -614.523, -11.8344, 0.273917, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (208389, 21230, 548, 1, 0, 1044, 191.42, -610.888, -11.8542, 0.554305, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (210824, 21230, 548, 1, 0, 1044, 213.501, -260.794, -2.02762, 5.5094, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (210894, 21230, 548, 1, 0, 1044, 205.82, -260.676, -2.02762, 5.49838, 7200, 0, 0, 143600, 48465, 0, 0);

INSERT INTO `creature` VALUES (80497, 21231, 548, 1, 0, 0, 337.1503, -438.3084, 28.8718, 0.0210, 7200, 0, 0, 179525, 0, 0, 0);
-- INSERT INTO `creature` VALUES (81025, 21231, 548, 1, 0, 0, 451.279, -570.087, -7.36974, 6.24372, 7200, 0, 0, 179525, 0, 0, 0);
-- INSERT INTO `creature` VALUES (81028, 21231, 548, 1, 0, 0, 549.974, -569.879, -7.14429, 2.91756, 7200, 0, 0, 179525, 0, 0, 0);
-- INSERT INTO `creature` VALUES (81770, 21231, 548, 1, 0, 0, 556.908, -478.109, -13.1582, 3.15946, 7200, 0, 0, 179525, 0, 0, 0);
INSERT INTO `creature` VALUES (82869, 21231, 548, 1, 0, 2135, 470.277, -413.445, -4.8385, 2.26183, 7200, 0, 0, 200000, 0, 0, 2);
INSERT INTO `creature` VALUES (93767, 21231, 548, 1, 0, 2135, 338.445, -505.401, 28.1543, 2.54137, 7200, 0, 0, 200000, 0, 0, 2);
INSERT INTO `creature` VALUES (93784, 21231, 548, 1, 0, 2135, 426.294, -419.788, 8.69177, 1.11581, 7200, 0, 0, 200000, 0, 0, 2);
INSERT INTO `creature` VALUES (93791, 21231, 548, 1, 0, 0, 315.756, -324.118, 19.0598, 6.01055, 7200, 0, 0, 200000, 0, 0, 0);
INSERT INTO `creature` VALUES (93792, 21231, 548, 1, 0, 0, 304.69, -367.878, 22.4158, 0.591305, 7200, 0, 0, 200000, 0, 0, 0);
INSERT INTO `creature` VALUES (93793, 21231, 548, 1, 0, 0, 394.402, -373.301, 23.3723, 2.44877, 7200, 0, 0, 200000, 0, 0, 0);
INSERT INTO `creature` VALUES (93794, 21231, 548, 1, 0, 0, 372.981, -350.218, 21.8563, 5.19217, 7200, 0, 0, 200000, 0, 0, 0);
INSERT INTO `creature` VALUES (93803, 21231, 548, 1, 0, 0, 313.666, -262.427, 14.0867, 2.89016, 7200, 0, 0, 200000, 0, 0, 2);
INSERT INTO `creature` VALUES (93804, 21231, 548, 1, 0, 0, 315.598, -255.441, 13.6739, 2.89959, 7200, 0, 0, 200000, 0, 0, 2);
INSERT INTO `creature` VALUES (255324, 21231, 548, 1, 0, 2135, 374.988, -508.343, 28.39, 3.42574, 7200, 0, 0, 200000, 0, 0, 0);
INSERT INTO `creature` VALUES (255453, 21231, 548, 1, 0, 2135, 374.519, -501.494, 27.4001, 3.19013, 7200, 0, 0, 200000, 0, 0, 0);

DELETE FROM `creature` WHERE `guid` BETWEEN 172714 AND 172722;
DELETE FROM `creature` WHERE `guid` IN (80510,80731,80498,81913,81914,81915,93768);
DELETE FROM `creature_linked_respawn` WHERE `guid` IN (80510,80731,80498,81912,82756,81913,81914,81915,93768,80497);
INSERT INTO `creature_linked_respawn` VALUES
(80510,93773),
(80731,93773),
(80498,93773),
(81912,93773),
(82756,93773),
(81913,93773),
(81914,93773),
(81915,93773),
(93768,93773),
(80497,93773);

INSERT INTO `creature` VALUES (93768, 21230, 548, 1, 0, 0, 392.107, -497.182, 28.4324, 3.21532, 7200, 0, 0, 143600, 48465, 0, 2);
SET @GUID := 93768;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (93768, 1, 345.004, -495.757, 27.4974, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 2, 332.75, -484.522, 28.8718, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 3, 342.738, -459.077, 28.357, 0, 0, 0, 0, 0);  
INSERT INTO `waypoint_data` VALUES (93768, 4, 356.3506, -403.3568, 27.0522, 0, 0, 0, 0, 0); 
INSERT INTO `waypoint_data` VALUES (93768, 5, 359.284, -371.831, 22.9121, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 6, 371.08, -355.191, 21.8825, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 7, 380.074, -343.367, 21.9524, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 8, 385.721, -357.798, 22.8594, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 9, 378.991, -384.532, 22.852, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 10, 367.8644, -403.3157, 27.8450, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 11, 325.218, -461.153, 28.9344, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93768, 12, 328.264, -497.084, 28.3245, 0, 0, 0, 0, 0);

SET @GUID := 93795;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (93795, 1, 392.887, -329.59, 20.8056, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93795, 2, 387.976, -320.925, 20.1713, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93795, 3, 373.389, -331.221, 19.8124, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93795, 4, 378.267, -350.125, 22.2263, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (93795, 5, 388.241, -344.162, 22.856, 0, 0, 0, 0, 0);

SET @GUID := 93779;
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,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 339.2322, -420.8434, 28.8717,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 330.7823, -417.7982, 28.8717,2000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 339.2322, -420.8434, 28.8717,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 341.9577, -432.8303, 28.7432,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 340.0797, -443.4074, 28.6889,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 333.6788, -443.5497, 28.8710,2000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 340.0797, -443.4074, 28.6889,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 341.9577, -432.8303, 28.7432,0,0,0,100,0);

INSERT INTO `creature` VALUES (80510, 21229, 548, 1, 0, 0, 334.5979, -403.3244, 28.2897, 5.3287, 7200, 0, 0, 143600, 48465, 0, 2);
SET @GUID := 80510;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (80510, 1, 338.786, -409.471, 28.3277, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80510, 2, 379.036, -396.841, 28.2056, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80510, 3, 359.758, -387.969, 23.7165, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80510, 4, 323.079, -385.927, 23.0982, 0, 0, 0, 0, 0);

INSERT INTO `creature` VALUES (80731, 21230, 548, 1, 0, 0, 345.9931, -506.1338, 28.1467, 3.1272, 7200, 0, 0, 143600, 48465, 0, 2);
SET @GUID := 80731;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (80731, 1, 335.054, -500.517, 27.8057, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 2, 329.97, -461.809, 28.8718, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 3, 340.265, -455.305, 28.5874, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 4, 363.066, -404.175, 27.2828, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 5, 377.62, -366.287, 22.4606, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 6, 344.51, -364.056, 21.7262, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 7, 343.749, -425.712, 28.7533, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 8, 328.873, -483.333, 28.8704, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 9, 333.436, -494.25, 27.7525, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (80731, 10, 393.779, -503.174, 27.205, 0, 0, 0, 0, 0);

INSERT INTO `creature` VALUES (80498, 21231, 548, 1, 0, 0, 333.5784, -343.7477, 21.0158, 2.7997, 7200, 0, 0, 179525, 0, 0, 0);

INSERT INTO `creature` VALUES (81913, 21230, 548, 1, 0, 1044, 390.1734, -381.4599, 23.1745, 3.0860, 7200, 0, 0, 143600, 48465, 0, 0);
INSERT INTO `creature` VALUES (81914, 21229, 548, 1, 0, 2224, 396.5572, -368.5735, 23.4723, 3.1547, 7200, 0, 0, 143600, 48465, 0, 0);

INSERT INTO `creature` VALUES (81915, 21863, 548, 1, 0, 0, 392.0486, -366.5477, 23.2245, 2.7640, 7200, 5, 0, 104790, 0, 0, 1);

UPDATE `creature` SET `equipment_id` = 2137 WHERE `guid` = 93798;
DELETE FROM `creature_addon` WHERE `guid` = 93798;
INSERT INTO `creature_addon` VALUES
(93798, 0, 0, 512, 0, 4097, 0, 0, NULL);

SET @GUID := 82952;
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,''); -- 1680
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (82952, 1, 364.177, -317.168, 18.3748, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 2, 353.5723, -310.7877, 18.1592, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 3, 334.063, -320.588, 18.6774, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 4, 322.622, -348.978, 21.6507, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 5, 326.463, -368.18, 22.0487, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 6, 380.639, -362.416, 22.6063, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (82952, 7, 382.796, -325.989, 19.9232, 0, 0, 0, 0, 0);

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

DELETE FROM `creature_formations` WHERE `leaderguid` IN (80497,93776,93790,93793,93794,93791,93798,93766);
DELETE FROM `creature_formations` WHERE `memberguid` IN (178782);
INSERT INTO `creature_formations` VALUES

(80497,80497,100,360,2),
(80497,93779,100,360,2),
(80497,93785,100,360,2),
(80497,80997,100,360,2),
(80497,93777,100,360,2),
(80497,93778,100,360,2),

(93776,93776,100,360,2),
(93776,93854,100,360,2),
(93776,93792,100,360,2),

(93790,93790,100,360,2),
(93790,80498,100,360,2),
(93790,93774,100,360,2),

(93793,93793,100,360,2),
(93793,81913,100,360,2),
(93793,81914,100,360,2),
(93793,81915,100,360,2),
(93793,93796,100,360,2),
(93793,93797,100,360,2),

(93794,93794,100,360,2),
(93794,82756,100,360,2),
(93794,81912,100,360,2),

(93791,93791,100,360,2),
(93791,93775,100,360,2),
(93791,93801,100,360,2),

(93798,93798,100,360,2),
(93798,93799,100,360,2),
(93798,93800,100,360,2),

(93766,93766,100,360,2),
(93766,82975,100,360,2),
(93766,82976,100,360,2),
(93766,93765,100,360,2);

-- 183607,82966,93837,93840,93841,
-- 82861,93789,172713,173195

-- 183607,82966,93837,93840,93841,
-- 82861,93789,172713,173195

UPDATE `creature_formations` SET `groupAI`='0' WHERE `leaderguid` IN ('183607') AND `memberguid` IN (82861,93789,172713,173195);

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (93838,183607,82966,93837,93840,93841,82861,172713,173195,93789,183141,93829,82965,93834,93830,93787,175587,175857,93831,182677,93820,93815,93824,93825,82036,176722,176935,82032,181841,93823,93821,93822,93819,82002,177699,81997,82003,180803,93816,82964,93827,93818,81917,81916,80273,81944,179801,93842,82955,93844,93826,81029,80445,80274,80473);
INSERT INTO `creature_linked_respawn` VALUES 
(93838,93838),(183607,93838),
(82966,93838),(93837,93838),
(93840,93838),(93841,93838),
(82861,93838),(172713,93838),
(173195,93838),(93789,93838),
(183141,93838),(93829,93838),
(82965,93838),(93834,93838),
(93830,93838),(93787,93838),
(175587,93838),(175857,93838),
(93831,93838),(182677,93838),
(93820,93838),(93815,93838),
(93824,93838),(93825,93838),
(82036,93838),(176722,93838),
(176935,93838),(82032,93838),
(181841,93838),(93823,93838),
(93821,93838),(93822,93838),
(93819,93838),(82002,93838),
(177699,93838),(81997,93838),
(82003,93838),(180803,93838),
(93816,93838),(82964,93838),
(93827,93838),(93818,93838),
(81917,93838),(81916,93838),
(80273,93838),(81944,93838),
(179801,93838),(93842,93838),
(82955,93838),(93844,93838),
(93826,93838),(81029,93838),
(80445,93838),(80274,93838),
(80473,93838);

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (37951,37987,37991,37989,93854,93883);
INSERT INTO `creature_linked_respawn` VALUES
(93883,82974),
--
(93854,93773),
--
(37951,93814),
(37987,93814),
(37991,93814),
(37989,93814);

-- ssc hydross & lurker trash 45min respawn timer
-- The creatures that lead up to Hydross the Unstable and creatures at the six pumping stations are now on a 2 hour respawn instead of 45 minutes. 
-- always 5min in despawn so -5min always
UPDATE `creature` SET `spawntimesecs`='7200' WHERE `guid` IN (80272,93853,93828,93851,82953,82961,82917,93848,93850,93852,82956,93832,93849,93847,82958,82957,93845);

-- Lurker Trash
UPDATE `creature` SET `spawntimesecs`='7200' WHERE `guid` IN (183607,82966,93837,93840,93841,82861,172713,173195,93789,183141,93829,82965,93834,93830,93787,175587,175857,93831,182677,93820,93815,93824,93825,82036,176722,176935,82032,181841,93823,93821,93822,93819,82002,177699,81997,82003,180803,93816,82964,93827,93818,81917,81916,80273,81944,179801,93842,82955,93844,93826,81029,80445,80274,80473);

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

UPDATE `creature` SET `position_x`='29.6855', `position_y`='-923.2489', `position_z`='42.9018', `orientation`='1.5949',`spawndist`='0',`movementtype`='0' WHERE `guid` = 93814;

SET @GUID := 37951;
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,512,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','19.6190','-56.7943','-72.0772',0,0,0,100,0),
(@GUID,@POINT := @POINT + '1','29.2468','-52.0036','-72.4646',0,0,0,100,0),
(@GUID,@POINT := @POINT + '1','19.6190','-56.7943','-72.0772',0,0,0,100,0),
(@GUID,@POINT := @POINT + '1','-11.0251','-66.2496','-71.2579',0,0,0,100,0),
(@GUID,@POINT := @POINT + '1','-37.1720','-64.7938','-69.9687',0,0,0,100,0),
(@GUID,@POINT := @POINT + '1','-11.0251','-66.2496','-71.2579',0,0,0,100,0);

UPDATE `creature` SET `position_x`='361.872009', `position_y`='-724.400024', `position_z`='-14.0032', `orientation`='3.2655',`spawndist`='0',`movementtype`='0' WHERE `guid` = 82974; -- `position_x`='354.7654', `position_y`='-723.9628', `position_z`='-13.8946' Post 2.1 `position_x`='361.872009', `position_y`='-724.400024', `position_z`='-14.0032'  

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

-- 184203 184204 184205 etc brückenteile

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

-- Lady Vashj
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21212 AND `item` = 29434; -- 100
-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21212 AND `item` = 34052; -- 10
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21212 AND `item` = 190052; -- 2

-- Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 21212 AND `item` = 50031; -- 3

-- The Lurker Below
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21217 AND `item` = 29434; -- 100
--
-- Hydross the Unstable
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21216 AND `item` = 29434; -- 100
-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21216 AND `item` = 34052; -- 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21216 AND `item` = 90052; -- 10
--
-- Leotheras the Blind
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21215 AND `item` = 29434; -- 100

-- Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 21215 AND `item` = 34059; -- 3

-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21215 AND `item` = 34052; -- 10
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21215 AND `item` = 190052; -- 2
--
-- Fathom-Lord Karathress
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21214 AND `item` = 29434; -- 100

-- Token
DELETE FROM `creature_loot_template` WHERE `entry` = 21214 AND `item` = 34060;
INSERT INTO `creature_loot_template` VALUES
(21214,34060,100,1,-34060,1,0,0,0);
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 21214 AND `item` = 34060; -- 3

-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21214 AND `item` = 34052; -- 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21214 AND `item` = 90052; -- 10
--
-- Morogrim Tidewalker 
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 21213 AND `item` = 29434; -- 100
-- Item
DELETE FROM `creature_loot_template` WHERE `entry` = 21213 AND `item` = 34061;
INSERT INTO `creature_loot_template` VALUES
(21213,34061,100,1,-34061,2,0,0,0);
-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21213 AND `item` = 34052; -- 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 21213 AND `item` = 90052; -- 10
--
-- Trash only one time apply to reduce %
-- Trash Patterns
-- SELECT * FROM `creature_loot_template` WHERE `item` IN (30321,30322,30323,30324,30280,30281,30282,30283,30301,30302,30303,30304,30305,30306,30307,30308);
-- SELECT * FROM `creature_loot_template` WHERE `item` = 30183;
-- SELECT * FROM `creature_loot_template` WHERE `item` IN (30020,30021,30022,30023,30024,30025,30026,30027,30028,30029,30030,30620);

-- Nether Vortex
-- >~1% first entry 1,0475
UPDATE `creature_loot_template` SET `groupid`=9 WHERE `item` = 30183; -- 0
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100,`mincountOrRef`=2,`maxcount`=2 WHERE `entry` = 19622 AND `item` = 30183;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100,`mincountOrRef`=2,`maxcount`=2 WHERE `entry` = 21212 AND `item` = 30183;

-- Random Epics 
-- ~1% first entry 0,3
-- UPDATE `creature_loot_template` SET `mincountOrRef`=1,`maxcount`=1 WHERE `item` IN (30020,30021,30022,30023,30024,30025,30026,30027,30028,30029,30030,30620);

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

-- Kael
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100 WHERE `item` IN (32405,34056,50032) AND `entry` = 19622;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -100 WHERE `item` = 29905 AND `entry` = 19622;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 2 WHERE `item` = 32458 AND `entry` = 19622;
-- Vashj
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 100 WHERE `item` IN (50031,90062) AND `entry` = 21212;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = -100 WHERE `item` = 29906 AND `entry` = 21212;

-- 2.1 (Re)Activate Mark of the Illidari
UPDATE `creature_loot_template` SET `mincountOrRef`=1, `maxcount`=1 WHERE `item` =32897; -- 1 1

-- 2.1 (Re)Activate Trash Patterns
-- <~1% fist entry 0,984
-- UPDATE `creature_loot_template` SET `mincountOrRef`=1,`maxcount`=1 WHERE `item` IN (30321,30322,30323,30324,30280,30281,30282,30283,30301,30302,30303,30304,30305,30306,30307,30308); -- 1 1

-- 2.1 (Re)Activate Boss Pattern
UPDATE `reference_loot_template` SET `mincountOrRef`=1, `maxcount`=1 WHERE `entry` = 34052; -- 1 1

-- 2.1 (Re)Activate 32902,32905 Bottled Nethergon Energy / Bottled Nethergon Vapor
UPDATE `creature_loot_template` SET `mincountOrRef` = 1, `maxcount` = 3 WHERE `item` IN (32902,32905); -- 1 3

-- 2.1 (Re)Activate Coilfang Armaments
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21863 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21339 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21301 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21299 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21298 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 16 WHERE `entry` = 21263 AND `item` = 24368; -- 16
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21251 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21232 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21231 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 16 WHERE `entry` = 21230 AND `item` = 24368; -- 16
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 16 WHERE `entry` = 21229 AND `item` = 24368; -- 16
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21228 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21227 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21226 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21225 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21224 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21221 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21220 AND `item` = 24368; -- 12
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 12 WHERE `entry` = 21218 AND `item` = 24368; -- 12