Xadras commented 8 years ago

Complete Raid Overhaul for Tempest Keep: The Eye with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

ToDo:

[ ] The hitpoints of all non-boss mobs has been reduced. The boss specific adds should not be affected by this change.
[ ] The damage dealt by Novice Astromancers and Apprentice Star Scryers has been greatly reduced. Crystalcore Sentinels no longer Trample.
[ ] The range of Crimson Hand Battle Mage's Frost Bolt Volley has been increased.
[x] Astromancers and Astromancer Lords no longer use the Blast Wave ability, and the range of their Fireball Volley spells has been increased.
[ ] The damage over time and radius of the Star Scryer's Starfall spell has been reduced.
[ ] Arcane Resistance will prove much more effective against High Astromancer Solarian's spells.
[ ] High Astromancer Solarian now summons fewer Solarian agents, and the Solarium Agents now deal less damage.
[ ] The Al'ar encounter has been significantly reworked. Her movement around the room will now be more predictable, Al'ar's hit points have been reduced, and killing the Embers of Al'ar will now be both much more possible and more rewarding to the raid.
[ ] High Astromancer Solarian's hit points have been greatly reduced.
[ ] Reduced the radius of Fragmentation Bombs in Tempest Keep to better match their visual.

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

[ ] When Kael'thas Sunstrider is engaged in combat, the doors leading into his room will now properly close.

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

[ ] Tempest Keep and Coilfang raid bosses will now all drop at least 3 items each.
[ ] The spells cast by High Astromancer Solarian have been extensively reworked. Wrath of the Astromancer is a now completely different in function. Mark of the Astromancer has been renamed to Light of the Astromancer and no longer reduces Arcane resistance. A player's Arcane Resistance now also provides normal damage mitigation to Solarian's spells.
[x] Phoenix-Hawk Hatchlings now Wing Buffet less frequently.
[ ] Crimson Hand Centurions now deal less damage with Arcane Flurry.
[ ] Crimson Hand Battle Mages have had their Frost Attack damage reduced.

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

[ ] The Blood Elves that patrol the Tempest Bridge no longer patrol directly into Prince Kael'thas Sunstrider's chamber.
[ ] All four advisors have had their health reduced by 10%.
[ ] All of the summoned weapons have had their health reduced by 10%.
[ ] The ability "Meteor" has been renamed to "Dive Bomb".
[ ] The use of Ice Block, Divine Shield, Cloak of Shadows, and other similar spells and abilities will no longer prematurely detonate High Astromancer Solarian's Wrath of the Astromancer spell.

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

[ ] The number of Blood Elves guarding Prince Kael'Thas' room has been reduced.

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

[ ] The High Astromancer Solarian encounter can no longer be reset by running out of the room.
[ ] High Astromancer Solarian now uses her ability Light of the Astromancer at a much greater frequency.
[ ] Astromancer Lords in the packs prior to High Astromancer Solarian have gained the Domination ability.

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

[ ] You may now fight Prince Kael'thas and Lady Vashj without first killing all the other bosses in their respective dungeons.
[ ] The Vapor Clouds in the Kael'thas encounter are significantly easier to see.
[ ] Void Reaver is now immune to Vindication again.

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

[ ] Void Reaver no longer targets a player before casting an Arcane Orb, so Add Ons such as Deadly Boss Mods or BigWigs (AddOn) are no longer able to warn of incoming Orbs.
[ ] Flame patches in phase 2 can no longer be killed with spell reflect by warriors. Al'ar's hit box was made smaller.

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

[ ] Arcane orbs now generate combat log entries. Still no combat logs as of 5/15/08

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

Xadras commented 8 years ago

Souces:

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

http://www.wowhead.com/zone=3845/the-eye , http://wowwiki.wikia.com/wiki/Eye_%28Tempest_Keep%29 , http://wow.gamepedia.com/Eye_(Tempest_Keep) , http://wowwiki.wikia.com/wiki/Patch_2.1.0 , http://wowwiki.wikia.com/wiki/Patch_2.2.0

http://web.archive.org/web/20100127140410/http://www.hordeguides.de/index.php?rb=19622

http://www.mmo-champion.com/threads/1623524-why-did-it-take-players-so-long-to-kill-kael-thas-sunstrider/page12 , https://enhancementshaman.wordpress.com/category/tempest-keep/

https://www.youtube.com/watch?v=X1_uLvCYkzI ,

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

https://www.youtube.com/watch?v=49eEaKnRvz4 - Conquest - The Eye - Trash Clear

https://www.youtube.com/watch?v=3LcosmADU_0 - Paladin in Tempest Keep

https://www.youtube.com/watch?v=jMt6vjmfQo0 - Melee DPS Life on Void Reaver trash - Multiple Sawblades

https://www.youtube.com/watch?v=Gx3DWaVMP4U - Spoonizm-Tempest Keep-Void Reaver - Trash

https://www.youtube.com/watch?v=LlRT4q7AV4c - Void Reaver Resto Shaman POV @ World of Warcraft: The Burning Crusade

https://www.youtube.com/watch?v=jI5Szs_r5kQ - The Answer (Jaedenar EU) vs Void Reaver

https://youtu.be/wm4XsKdLNzk?t=8m40s - Al'ar

https://www.youtube.com/watch?v=it01BSGM_ko - Astromancer

http://wowwiki.wikia.com/wiki/High_Astromancer_Solarian?oldid=1192499

https://www.youtube.com/watch?v=usi9Pi27quA&t= - Twilight's Hammer vs Kael'thas Sunstrider

Trash: https://www.youtube.com/watch?v=C8QRGEEtc3o

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

#!sql

-- Netherstrand Longbow
('2126801','21268','4','0','100','2','0','0','0','0','49','1','0','0','20','0','0','0','0','0','0','0','Netherstrand Longbow - Enable Dynamic Movement and Prevent Melee on Aggro'),
('2126802','21268','9','0','100','3','0','100','4000','6000','11','36980','4','0','40','2','0','0','0','0','0','0','Netherstrand Longbow - Cast Shoot and Set Ranged Weapon Model'),
('2126803','21268','0','0','100','3','7000','11000','12000','16000','11','36979','4','0','40','2','0','0','0','0','0','0','Netherstrand Longbow - Cast Multi-Shot and Set Ranged Weapon Model'),
('2126804','21268','9','0','100','3','0','20','24000','30000','11','36994','0','1','0','0','0','0','0','0','0','0','Netherstrand Longbow - Cast Blink'),
('2126805','21268','9','0','100','3','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Netherstrand Longbow - Enable Dynamic Movement at 9-80 Yards'),
('2126806','21268','9','0','100','3','0','8','1000','1000','49','0','0','0','20','1','0','0','40','1','0','0','Netherstrand Longbow - Disable Dynamic Movement and Enable Melee and Set Melee Weapon Model at 0-8 Yards'),
('2126807','21268','7','0','100','2','0','0','0','0','40','1','0','0','0','0','0','0','0','0','0','0','Netherstrand Longbow - Set Melee Weapon Model on Evade'),
-- Devastation
('2126901','21269','9','0','100','3','0','8','11000','15000','11','36981','0','0','0','0','0','0','0','0','0','0','Devastation - Cast Whirlwind'),
-- Cosmic Infuser
('2127001','21270','9','0','100','3','0','15','8000','12000','11','36985','0','0','0','0','0','0','0','0','0','0','Cosmic Infuser - Cast Holy Nova'),
('2127002','21270','14','0','100','3','80000','40','21000','30000','11','36983','6','1','0','0','0','0','0','0','0','0','Cosmic Infuser - Cast Heal on Friendlies'),
-- Infinity Blades
('2127101','21271','11','0','100','2','0','0','0','0','11','12787','0','0','0','0','0','0','0','0','0','0','Infinity Blades - Cast Thrash on Spawn'),
-- Warp Slicer
('2127201','21272','9','0','100','3','0','5','7000','9000','11','36991','1','0','0','0','0','0','0','0','0','0','Warp Slicer - Cast Rend'),
-- Phaseshift Bulwark
('2127301','21273','9','0','100','3','0','5','13000','17000','11','36988','1','0','0','0','0','0','0','0','0','0','Phaseshift Bulwark - Cast Shield Bash'),
-- Staff of Disintegration
('2127401','21274','4','0','100','2','0','0','0','0','49','1','0','0','22','1','0','0','0','0','0','0','Staff of Disintegration - Enable Dynamic Movement and Set Phase 1 on Aggro'),
('2127402','21274','9','5','100','3','0','100','6000','9000','11','36990','4','0','0','0','0','0','0','0','0','0','Staff of Disintegration - Cast Frostbolt (Phase 1)'),
('2127403','21274','9','5','100','3','9','80','1000','1000','49','1','0','0','0','0','0','0','0','0','0','0','Staff of Disintegration - Enable Dynamic Movement at 9-80 Yards (Phase 1)'),
('2127404','21274','9','0','100','3','0','8','1000','1000','49','0','0','0','0','0','0','0','0','0','0','0','Staff of Disintegration - Disable Dynamic Movement at 0-8 Yards'),
('2127405','21274','3','5','100','2','7','0','0','0','49','0','0','0','22','2','0','0','0','0','0','0','Staff of Disintegration - Disable Dynamic Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('2127406','21274','3','3','100','3','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Staff of Disintegration - Set Phase 1 when Mana is above 15% (Phase 2)'),
('2127407','21274','9','0','100','3','0','10','12000','15000','11','36989','0','1','0','0','0','0','0','0','0','0','Staff of Disintegration - Cast Frost Nova'),
('2127408','21274','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Staff of Disintegration - Set Phase to 0 on Evade'),

Xadras commented 8 years ago

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/2327
-- Tempest Keep: The Eye
-- ======================================================
-- Texts & Scripts
-- ======================================================

-- -9711 - -9725
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9725 AND -9708;
INSERT INTO `creature_ai_texts` VALUES
(-9708,'This unit is ready to serve.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20040 OOC'),
(-9709,'After this mobility test, we\'ll only have the final weapons check to complete.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20042 OOC'),
(-9710,'Golem. Command. Operational status report.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20042 OOC'),
(-9711,'\'s hand begins to glow with Arcane energy.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'20041 on Overcharged Arcane Explosion Spellcast'),
(-9712,'All clear!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9713,'First squad is ready for battle!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9714,'Our blades and spells are at the ready!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9715,'Our defenses stand ready!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9716,'Second squad is ready to fight!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9717,'The enemy will not get past us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9718,'Third squad reporting in!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9719,'We stand ready to defend the Eye!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9720,'We will show our enemies no quarter!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'20031 on Event'),
(-9721,'As you were!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'20035 OOC'),
(-9722,'Excellent work.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'20035 OOC'),
(-9723,'Stand vigilant.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'20035 OOC'),
(-9724,'Very well.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'20035 OOC'),
(-9725,'Your conduct makes me proud.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'20035 OOC');

-- Script for Patrol

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

-- Bloodwarder Legionnaire 20031
-- Vulnerable to Crowd Control.Vulnerable to snares. 
-- 33500/whirlwind 15284/cleave 35949/bloodthirst
-- http://wowwiki.wikia.com/wiki/Bloodwarder_Legionnaire , http://www.wowhead.com/npc=20031/bloodwarder-legionnaire#abilities
UPDATE `creature` SET `modelid`='0',`equipment_id`='0' WHERE `id` = 20031;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='6346',`maxdmg`='7537' WHERE `entry` = 20031; -- 2279 4662 -- 12,691 - 15,074
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20031;
INSERT INTO `creature_ai_scripts` VALUES
('2003101','20031','4','0','100','2','0','0','0','0','11','42459','0','1','0','0','0','0','0','0','0','0','Bloodwarder Legionnaire - Cast Dual Wield on Aggro'),
('2003102','20031','9','0','100','3','0','5','8000','11000','11','15284','1','0','0','0','0','0','0','0','0','0','Bloodwarder Legionnaire - Cast Cleave'),
('2003103','20031','0','0','100','3','8000','15000','12000','15000','11','33500','0','0','0','0','0','0','0','0','0','0','Bloodwarder Legionnaire - Cast Whirlwind'),
('2003104','20031','0','0','100','3','5000','10000','12000','18000','11','35949','1','0','0','0','0','0','0','0','0','0','Bloodwarder Legionnaire - Cast Bloodthirst');

-- Bloodwarder Vindicator 20032-mob_Bloodwarder_Vindicator
-- http://www.wowhead.com/npc=20032/bloodwarder-vindicator#comments http://wowwiki.wikia.com/wiki/Bloodwarder_Vindicator?direction=next&oldid=796374 
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`mindmg`='8410',`maxdmg`='9985',`mechanic_immune_mask`='1073691647',`flags_extra`='4194304'  WHERE `entry` = 20032; -- 3024 6173 2000 -- 16,820 - 19,969
UPDATE `creature_equip_template` SET `equipmodel2`='41645',`equipinfo2`='33490436',`equipslot2`='1038' WHERE `entry` = 2192;

-- Astromancer 20033
-- 37109/fireball-volley 35916/molten-armor
-- Vulnerable to all Crowd Control.Vulnerable to snares.Immune to all Stun effects.Immune to Curse of Tongues.Immune to Mind Control 
-- http://wowwiki.wikia.com/wiki/Astromancer?direction=next&oldid=1476928 , http://www.wowhead.com/npc=20033/astromancer
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4906',`maxdmg`='5825',`baseattacktime`='2000',`mechanic_immune_mask`='10241',`flags_extra`='4194304'  WHERE `entry` = 20033; -- 1323 2701 1500 -- 7,359 - 8,737
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20033;
INSERT INTO `creature_ai_scripts` VALUES
('2003301','20033','1','0','100','3','1000','1000','600000','600000','11','35915','0','1','0','0','0','0','0','0','0','0','Astromancer - Cast Molten Armor OOC'),
('2003302','20033','4','0','100','2','0','0','0','0','11','35915','0','32','0','0','0','0','0','0','0','0','Astromancer - Cast Molten Armor on Aggro'),
('2003303','20033','9','0','100','3','0','40','5000','7000','11','37109','4','0','0','0','0','0','0','0','0','0','Astromancer - Cast Fireball Volley'),
('2003304','20033','9','0','100','3','0','20','6000','18000','11','37110','1','0','0','0','0','0','0','0','0','0','Astromancer - Cast Fire Blast'),
('2003305','20033','16','0','100','3','35915','1','8000','24000','11','33482','0','32','0','0','0','0','0','0','0','0','Astromancer - Cast Molten Armor on Missing Buff'),
('2003306','20033','0','0','100','3','8000','16000','8000','12000','11','36278','0','1','0','0','0','0','0','0','0','0','Astromancer - Cast Blast Wave');

-- Star Scryer 20034
-- 37126/arcane-blast 37122/domination Starfire
-- Vulnerable to sheep and trap and sap,Vulnerable to snares,Immune to all Stun effects,Immune to Curse of Tongues,Immune to Mind Control
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5607',`maxdmg`='6657',`mechanic_immune_mask`='10241',`flags_extra`='4194304' WHERE `entry` = 20034; -- 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20034;
INSERT INTO `creature_ai_scripts` VALUES
('2003401','20034','9','0','100','3','0','5','10000','15000','11','37126','1','0','0','0','0','0','0','0','0','0','Star Scryer - Cast Arcane Blast'),
('2003402','20034','0','0','100','3','5000','10000','7000','15000','11','37124','4','32','0','0','0','0','0','0','0','0','Star Scryer - Cast Starfall'),
('2003403','20034','0','0','100','3','7000','15000','15000','20000','11','37122','5','1','0','0','0','0','0','0','0','0','Star Scryer - Cast Domination');

-- Bloodwarder Marshal 20035
-- http://www.wowhead.com/npc=20035/bloodwarder-marshal#comments http://wowwiki.wikia.com/wiki/Bloodwarder_Marshal?direction=next&oldid=796387
UPDATE `creature` SET `equipment_id`='0' WHERE `id` = 20035;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7385',`maxdmg`='8770',`baseattacktime`='1600',`mechanic_immune_mask`='1073691647' WHERE `entry` = 20035; -- 2653 5424 2000 -- 14,769 - 17,540
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20035;
INSERT INTO `creature_ai_scripts` VALUES
('2003501','20035','4','0','100','2','0','0','0','0','11','42459','0','1','0','0','0','0','0','0','0','0','Bloodwarder Marshal - Cast Dual Wield on Aggro'),
('2003502','20035','9','0','100','3','0','5','9000','12000','11','34996','1','0','13','-5','1','0','0','0','0','0','Bloodwarder Marshal - Cast Uppercut and Modify Threat'),
('2003503','20035','0','0','100','3','6000','12000','7000','14000','11','36132','0','0','0','0','0','0','0','0','0','0','Bloodwarder Marshal - Cast Whirlwind'),
('2003504','20035','0','0','100','3','3000','9000','10000','15000','11','35949','1','0','0','0','0','0','0','0','0','0','Bloodwarder Marshal - Cast Bloodthirst at 50% HP');

-- Bloodwarder Squire 20036-mob_Bloodwarder_Squire
-- http://www.wowhead.com/npc=20036/bloodwarder-squire#abilities http://wowwiki.wikia.com/wiki/Bloodwarder_Squire?direction=next&oldid=796394
UPDATE `creature` SET `modelid`='0',`equipment_id`='0' WHERE `id` = 20036;
UPDATE `creature_template` SET `modelid_A2`='21001',`modelid_H2`='21001',`armor`='7100',`speed`='1.48',`mindmg`='6308',`maxdmg`='7489',`mechanic_immune_mask`='1073692659',`flags_extra`='4194304' WHERE `entry` = 20036; -- 2268 4630 1600 -- 12,615 - 14,977

-- Tempest Falconer 20037-mob_tempest_falconer
-- http://www.wowhead.com/npc=20037/tempest-falconer#comments http://wowwiki.wikia.com/wiki/Tempest_Falconer?direction=next&oldid=796410 
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`mindmg`='5555',`maxdmg`='7777',`baseattacktime`='1400',`mechanic_immune_mask`='1073692671' WHERE `entry` = 20037; -- 556 2778 2000 -- 5,555 - 7,777

-- Phoenix-Hawk Hatchling 20038-mob_phoenixhawk_hatchling
-- packs of 5-7 currently fix 6
-- http://wowwiki.wikia.com/wiki/Phoenix-Hawk_Hatchling?direction=next&oldid=796420 , http://www.wowhead.com/npc=20038/phoenix-hawk-hatchling 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3901',`maxdmg`='4633',`baseattacktime`='1400',`mechanic_immune_mask`='2053' WHERE `entry` = 20038; -- 1402 2865 2000 -- 7,802 - 9,265

-- Phoenix-Hawk 20039-mob_phoenix_hawk
-- http://www.wowhead.com/npc=20039 , http://wowwiki.wikia.com/wiki/Phoenix-Hawk?direction=next&oldid=706656
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='9753',`maxdmg`='11581',`mechanic_immune_mask`='1073692671',`flags_extra`='4194304'  WHERE `entry` = 20039; -- 1402 2865 -- 7,802 - 9,265 -- 9753 11581

-- Crystalcore Devastator 20040-mob_crystalcore_devastator
-- http://wowwiki.wikia.com/wiki/Crystalcore_Devastator?direction=next&oldid=1343520 http://www.wowhead.com/npc=20040/crystalcore-devastator#comments
-- By huntergenwedar (2,153 – 4·15) on 2007/05/15 (Patch 2.0.12) These guys have about 1 million HP
-- These have around 450k-500k hp after 2.1
UPDATE `creature_template` SET `speed`='1',`mindmg`='7384',`maxdmg`='8770',`mechanic_immune_mask`='1073709055',`flags_extra`='4194304' WHERE `entry` = 20040; -- 0.6 3316 6781 -- 18,461 - 21,926

-- Crystalcore Sentinel 20041
-- http://www.wowhead.com/npc=20041/crystalcore-sentinel#comments http://wowwiki.wikia.com/wiki/Crystalcore_Sentinel
UPDATE `creature_template` SET `mindmg`='6462',`maxdmg`='7674',`dmgschool`='6',`mechanic_immune_mask`='1073709055',`flags_extra`='4194304' WHERE `entry` = 20041; -- 2902 5933 0 -- 16,154 - 19,185 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20041;
INSERT INTO `creature_ai_scripts` VALUES
('2004101','20041','0','0','100','3','9000','14000','25000','35000','11','37104','1','0','0','0','0','0','0','0','0','0','Crystalcore Sentinel - Cast Overcharge'), -- 4
('2004102','20041','0','0','100','3','21000','25000','25000','30000','11','37106','0','0','1','-9711','0','0','0','0','0','0','Crystalcore Sentinel - Cast Charged Arcane Explosion and Emote'),
('2004103','20041','2','0','100','2','15','0','0','0','11','34937','0','1','0','0','0','0','0','0','0','0','Crystalcore Sentinel - Cast Power Down at 15% HP'),
('2004104','20041','0','0','100','3','4000','8000','8000','16000','11','40492','0','0','0','0','0','0','0','0','0','0','Crystalcore Sentinel - Cast Trample');

-- Tempest-Smith 20042-mob_tempest_smith
-- http://www.wowhead.com/npc=20042/tempest-smith#comments http://wowwiki.wikia.com/wiki/Tempest-Smith?oldid=796371 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3631',`maxdmg`='4468',`baseattacktime`='1400',`mechanic_immune_mask`='1092',`flags_extra`='4194304' WHERE `entry` = 20042; -- 1188 2862 2000 -- 7,261 - 8,935

-- Apprentice Star Scryer 20043
-- http://www.wowhead.com/npc=20043/apprentice-star-scryer#abilities http://wowwiki.wikia.com/wiki/Apprentice_Star_Scryer?direction=next&oldid=803127
-- Melee for 3-4k  (on cloth i think)
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2778',`maxdmg`='3889' WHERE `entry` = 20043; -- 1 556 2778 -- 5,555 - 7,777
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20043;
INSERT INTO `creature_ai_scripts` VALUES
('2004301','20043','4','0','100','2','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Set Phase 1 on Aggro'),
('2004302','20043','9','0','100','3','0','50','3400','4800','11','37129','4','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Cast Arcane Volley'),
('2004303','20043','9','13','100','3','0','20','8000','12000','11','37133','1','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Cast Arcane Buffet (Phase 1)'),
-- ('2004304','20043','24','13','100','3','37133','10','5000','5000','22','2','0','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Set Phase 2 on Target Max Arcane Buffet Aura Stack (Phase 1)'),
-- ('2004305','20043','28','11','100','3','37133','1','5000','5000','22','1','0','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Set Phase 1 on Target Missing Arcane Buffet Aura Stack (Phase 2)'),
('2004306','20043','9','0','100','3','0','8','12000','16000','11','38725','0','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Cast Arcane Explosion'),
('2004307','20043','0','0','100','3','15000','18000','14000','17000','11','37132','1','0','0','0','0','0','0','0','0','0','Apprentice Star Scryer - Cast Arcane Shock');

-- Novice Astromancer 20044-mob_novice_astromancer
-- http://wowwiki.wikia.com/wiki/Novice_Astromancer?direction=next&oldid=1377868 http://www.wowhead.com/npc=20044/novice-astromancer#comments
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2778',`maxdmg`='3889',`mechanic_immune_mask`='612447863' WHERE `entry` = 20044; -- 556 2778 -- 5,555 - 7,777
-- ('2004401','20044','1','0','100','3','1000','1000','600000','600000','11','37282','0','1','0','0','0','0','0','0','0','0','Novice Astromancer - Cast Fire Shield on Spawn'),
-- ('2004403','20044','9','5','100','3','8','50','3400','4800','11','37111','1','0','0','0','0','0','0','0','0','0','Novice Astromancer - Cast Fireball (Phase 1)'),
-- ('2004408','20044','9','0','100','3','0','20','12000','16000','11','38728','0','1','0','0','0','0','0','0','0','0','Novice Astromancer - Cast Fire Nova'),
-- ('2004409','20044','0','0','100','3','15000','19000','18000','22000','11','37279','5','1','0','0','0','0','0','0','0','0','Novice Astromancer - Cast Rain of Fire'),
-- ('2004410','20044','27','0','100','3','37282','1','15000','30000','11','37282','0','1','0','0','0','0','0','0','0','0','Novice Astromancer - Cast Fire Shield on Missing Buff'),

-- Nether Scryer 20045
UPDATE `creature` SET `modelid`='0' WHERE `id` = 20045;
-- http://www.wowhead.com/npc=20045/nether-scryer#abilities http://wowwiki.wikia.com/wiki/Nether_Scryer 
-- ai maybe malfunction, was deleted in db atm
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5351',`maxdmg`='6352',`equipment_id`='8036',`mechanic_immune_mask`='1073430527',`flags_extra`='4194304' WHERE `entry` = 20045; -- 1925 3927 -- 10,701 - 12,703
DELETE FROM `creature_equip_template` WHERE `entry` = 8036;
INSERT INTO `creature_equip_template` VALUES
(8036,40359,0,0,285346306,0,0,2,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20045;
INSERT INTO `creature_ai_scripts` VALUES
('2004501','20045','9','0','100','3','0','5','12000','16000','11','37126','4','0','0','0','0','0','0','0','0','0','Nether Scryer - Cast Arcane Blast'),
('2004502','20045','2','0','100','2','99','0','30000','30000','11','36797','5','39','0','0','0','0','0','0','0','0','Nether Scryer - Cast Domination'),
('2004503','20045','2','0','100','2','98','0','30000','30000','11','36797','5','39','0','0','0','0','0','0','0','0','Nether Scryer - Cast Domination'),
('2004504','20045','2','0','100','2','97','0','30000','30000','11','36797','5','39','0','0','0','0','0','0','0','0','Nether Scryer - Cast Domination'),
('2004505','20045','2','0','100','2','96','0','30000','30000','11','36797','5','39','0','0','0','0','0','0','0','0','Nether Scryer - Cast Domination'),
('2004506','20045','2','0','100','2','95','0','30000','30000','11','36797','5','39','0','0','0','0','0','0','0','0','Nether Scryer - Cast Domination');

-- Astromancer Lord 20046
-- Has a fire shield buff like the astromages in Mechanaar, however it is not stealable/dispelable.
-- da in dem pack kein mc mob ist ist davon auszugehen, dass der npc tatsächlich mc konnte prenerf.
-- http://www.wowhead.com/npc=20046/astromancer-lord#abilities http://wowwiki.wikia.com/wiki/Astromancer_Lord?direction=next&oldid=1518430
UPDATE `creature` SET `modelid`='0',`equipment_id`='0' WHERE `id` = 20046;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5351',`maxdmg`='6352',`baseattacktime`='1400',`mechanic_immune_mask`='612450143',`flags_extra`='4194304' WHERE `entry` = 20046; -- 1925 3927 2000 -- 10,701 - 12,703
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20046;
INSERT INTO `creature_ai_scripts` VALUES
('2004601','20046','1','0','100','3','1000','1000','600000','600000','11','38732','0','1','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Fire Shield OOC'),
('2004602','20046','9','0','100','3','0','40','3400','4800','11','37109','4','0','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Fireball Volley'),
('2004603','20046','9','0','100','3','0','20','12000','16000','11','37110','4','0','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Fire Blast'),
('2004604','20046','9','0','100','3','0','5','15000','20000','11','37289','1','1','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Dragon\'s Breath'),
('2004605','20046','16','0','100','3','38732','1','3000','6000','11','38732','0','32','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Fire Shield on Missing Buff'),
('2004606','20046','0','0','100','3','8000','12000','10000','20000','11','37122','5','1','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Domination'),
('2004607','20046','0','0','100','3','8000','16000','16000','32000','11','36278','0','1','0','0','0','0','0','0','0','0','Astromancer Lord - Cast Blast Wave');

-- Crimson Hand Battle Mage 20047
-- http://www.wowhead.com/npc=20047/crimson-hand-battle-mage#abilities http://wowwiki.wikia.com/wiki/Crimson_Hand_Battle_Mage
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4206',`maxdmg`='4993',`baseattacktime`='1400',`equipment_id`='8037',`mechanic_immune_mask`='502935279',`flags_extra`='4194304' WHERE `entry` = 20047; -- 1513 3087 2000 -- 8,411 - 9,985
DELETE FROM `creature_equip_template` WHERE `entry` = 8037;
INSERT INTO `creature_equip_template` VALUES
(8037,43036,0,0,218171138,0,0,3,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20047;
INSERT INTO `creature_ai_scripts` VALUES
('2004701','20047','9','0','100','3','0','40','4400','5800','11','37262','1','0','0','0','0','0','0','0','0','0','Crimson Hand Battle Mage - Cast Frostbolt Volley'), -- 0
('2004702','20047','9','0','100','3','0','8','15000','21000','11','37265','1','0','0','0','0','0','0','0','0','0','Crimson Hand Battle Mage - Cast Cone of Cold'), -- 0
('2004703','20047','0','0','100','3','12000','15000','18000','24000','11','37263','4','0','0','0','0','0','0','0','0','0','Crimson Hand Battle Mage - Cast Blizzard'),
('2004704','20047','9','0','100','3','0','5','5000','10000','11','39087','1','0','0','0','0','0','0','0','0','0','Crimson Hand Battle Mage - Cast Frost Attack');

-- Crimson Hand Centurion 20048
-- http://www.wowhead.com/npc=20048/crimson-hand-centurion#comments http://wowwiki.wikia.com/wiki/Crimson_Hand_Centurion?direction=next&oldid=1338002
UPDATE `creature` SET `modelid`='0',`equipment_id`='0' WHERE `id` = 20048;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8411',`maxdmg`='9985',`mechanic_immune_mask`='33557825',`flags_extra`='4194304' WHERE `entry` = 20048; -- 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20048;
INSERT INTO `creature_ai_scripts` VALUES
('2004801','20048','0','0','100','3','5000','9000','15000','22000','11','37268','0','1','0','0','0','0','0','0','0','0','Crimson Hand Centurion - Cast Arcane Flurry');

-- Crimson Hand Blood Knight 20049-mob_crimson_hand_blood_knight
-- http://www.wowhead.com/npc=20049/crimson-hand-blood-knight#comments http://wowwiki.wikia.com/wiki/Crimson_Hand_Blood_Knight?direction=next&oldid=1252922
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4206',`maxdmg`='4993',`baseattacktime`='1400',`mechanic_immune_mask`='1073430515',`flags_extra`='4194304' WHERE `entry` = 20049; -- 1513 3087 2000 -- 8,411 - 9,985
UPDATE `creature_equip_template` SET `equipmodel2`='41645',`equipinfo2`='33490436',`equipslot2`='1038' WHERE `entry` = 2196;

-- Crimson Hand Inquisitor 20050
-- http://www.wowhead.com/npc=20050/crimson-hand-inquisitor#abilities http://wowwiki.wikia.com/wiki/Crimson_Hand_Inquisitor
UPDATE `creature` SET `modelid`='0',`equipment_id`='0' WHERE `id` = 20050;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4206',`maxdmg`='4993',`mechanic_immune_mask`='536489955',`flags_extra`='4194304' WHERE `entry` = 20050; -- 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20050;
INSERT INTO `creature_ai_scripts` VALUES
('2005001','20050','4','0','100','2','0','0','0','0','11','37274','0','0','0','0','0','0','0','0','0','0','Crimson Hand Inquisitor - Cast Power Infusion on Aggro'),
('2005002','20050','0','0','100','3','10000','20000','10000','20000','11','37274','0','32','0','0','0','0','0','0','0','0','Crimson Hand Inquisitor - Cast Power Infusion'),
('2005003','20050','9','0','100','3','0','20','3000','9000','11','37276','1','0','0','0','0','0','0','0','0','0','Crimson Hand Inquisitor - Cast Mind Flay'),
('2005004','20050','9','0','100','3','0','30','8000','13000','11','37275','4','32','0','0','0','0','0','0','0','0','Crimson Hand Inquisitor - Cast Shadow Word: Pain');

-- Crystalcore Mechanic 20052-mob_crystalcore_mechanic
-- http://www.wowhead.com/npc=20052/crystalcore-mechanic#comments http://wowwiki.wikia.com/wiki/Crystalcore_Mechanic
-- They are confirmed to do about 2500-2900 physical damage. 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5714',`maxdmg`='6629',`baseattacktime`='1400',`mechanic_immune_mask`='1073561599',`flags_extra`='4194304' WHERE `entry` = 20052; -- 2035 4162 2000 -- 11,331 - 13,458

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

-- Al'ar <Phoenix God> 19514
UPDATE `creature_template` SET `mindmg`='10222',`maxdmg`='12000',`resistance2`='-1',`inhabittype`='7',`mechanic_immune_mask`='1073430527',`flags_extra`='1077936129' WHERE `entry` = 19514; -- 3778 7333 -- 20,444 - 23,999

-- Ember of Al'ar 19551- mob_ember_of_alar
-- http://www.wowhead.com/npc=19551/ember-of-alar#abilities http://wowwiki.wikia.com/wiki/Ember_of_Al'ar
-- Hit for ~1500 damage.  
UPDATE `creature_template` SET `minlevel`=70,`maxlevel`=70,`speed`=4,`mindmg`=4196,`maxdmg`=4292, `dmgschool` = 2, `baseattacktime`=1400,`resistance2`=-1,`mechanic_immune_mask`=75642198,`flags_extra`=1077936128 WHERE `entry` = 19551; -- 1520 1664 0 2000 -- 6,294 - 6,438

-- Void Reaver 19516
-- http://wowwiki.wikia.com/wiki/Void_Reaver?direction=next&oldid=565999
UPDATE `creature_template` SET `speed`='2',`scale`='1',`mindmg`='9780',`maxdmg`='11608',`mechanic_immune_mask`='1073709055' WHERE `entry` = 19516; -- 1.2 0.8 3519 7175 -- 19,560 - 23,216 

-- High Astromancer Solarian 18805
-- www.wowhead.com/npc=18925/high-astromancer-solarian#comments http://wowwiki.wikia.com/wiki/High_Astromancer_Solarian?oldid=829691 http://wowwiki.wikia.com/wiki/High_Astromancer_Solarian?direction=next&oldid=697382
-- As a DPS warrior, she can crush me for 8k, and one of our rogues reported 10k. (Arcane Dmg?)
UPDATE `creature_template` SET `minmana`='420970',`maxmana`='420970',`speed`='3',`scale`='0.7',`mindmg`='5434',`maxdmg`='6449',`dmgschool`='0',`baseattacktime`='1400',`mechanic_immune_mask`='650854399' WHERE `entry` = 18805; -- 1.2 0.7 2444 4983 2000 -- 6792 8062 --13,584 - 16,123

-- Solarium Agent 18925
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1500',`maxdmg`='2000',`baseattacktime`='1400',`equipment_id`='8002' WHERE `entry` = 18925; -- 1 845 1267 2000 -- 2,111 - 2,333

-- Solarium Priest 18806
-- http://wowwiki.wikia.com/wiki/High_Astromancer_Solarian?direction=next&oldid=829694 mob_solarium_priest
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='200',`maxdmg`='400',`baseattacktime`='1400',`flags_extra`='4194304'  WHERE `entry` = 18806; -- 66 155 2000

-- Astromancer Solarian Spotlight 18928
UPDATE `creature` SET `position_x`='432.5939', `position_y`='-373.6006', `position_z`='17.9604', `orientation`='1.0367' WHERE `guid` = 12457; 
UPDATE `creature_template` SET `flags_extra`='128' WHERE `entry` = 18928;

-- Kael'thas Sunstrider <Lord of the Blood Elves> 19622
-- http://wowwiki.wikia.com/wiki/Kael%27thas_Sunstrider_(tactics)?direction=prev&oldid=1187868
-- ~ 1,700,000? atm 4188300 -> 3624683 * 1.15549415
-- http://wowwiki.wikia.com/wiki/Kael%27thas_Sunstrider_(tactics)?oldid=958878
UPDATE `creature_template` SET `speed`='2',`mindmg`='9781',`maxdmg`='11608',`baseattacktime`='1400',`mechanic_immune_mask`='617299967' WHERE `entry` = 19622; -- 1.2 4399 8969 2000 -- 24,451 - 29,021

-- Thaladred the Darkener <Advisor to Kael'thas> 20064
-- http://wowwiki.wikia.com/wiki/Thaladred_the_Darkener 378000
UPDATE `creature_template` SET `rank`= 3, `speed`='0.9',`mindmg`='10548',`maxdmg`='12527',`mechanic_immune_mask`='653213695' WHERE `entry` = 20064; -- 1 XXX 3790 7747 -- 21,096 - 25,053

-- Lord Sanguinar <The Blood Hammer> 20060
-- http://wowwiki.wikia.com/wiki/Lord_Sanguinar 376000
UPDATE `creature_template` SET `rank`='3',`speed`='1.48',`mindmg`='7501',`maxdmg`='8908',`mechanic_immune_mask`='653213695' WHERE `entry` = 20060; -- 1 3369 6886 -- 18,752 - 22,269

-- Grand Astromancer Capernian <Advisor to Kael'thas> 20062
-- http://wowwiki.wikia.com/wiki/Grand_Astromancer_Capernian 281000
UPDATE `creature_template` SET `rank`='3',`armor`='6700',`speed`='1.48',`mindmg`='2754',`maxdmg`='3312',`baseattacktime`='2000' WHERE `entry` = 20062; -- 1 959 2074 -- 5,508 - 6,623

-- Master Engineer Telonicus <Advisor to Kael'thas> 20063
-- http://wowwiki.wikia.com/wiki/Master_Engineer_Telonicus 377000
UPDATE `creature_template` SET `rank`='3',`speed`='1.48',`mindmg`='6692',`maxdmg`='7192' WHERE `entry` = 20063; -- 1 2754 3312 -- 13,383 - 14,383

-- http://wowwiki.wikia.com/wiki/Kael%27thas_Sunstrider_(tactics)?oldid=738387
-- All of the weapons have approximately 300k HP, besides the staff which has about 100k less and the shield which has about 100k more.
-- First with actual weapon hp data http://wowwiki.wikia.com/wiki/Kael%27thas_Sunstrider_(tactics)?direction=next&oldid=1176105

-- weapon wowhead nerf * 1.57533987 +10% (documented nerf) +((30% buff (talents / knowledge)) 
-- Netherstrand Longbow 21268- weapon_advisor
-- ~210,000 HP (208000) + 10% nerf for advisor+weapon 231000 -> 300300 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4179',`maxdmg`='4963',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21268; -- 1502 3070 -- 8,358 - 9,926

-- Devastation 21269
-- http://wowwiki.wikia.com/wiki/Kael%27thas_Sunstrider_(tactics)?oldid=1139113 ~230,000 HP + 10% 253000 -> 328900
-- Also has much higher HP than the other weapons. 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8358',`maxdmg`='9926',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21269; -- 220059 3003 6139 --  16,716 - 19,852

-- Cosmic Infuser 21270
-- ~280,000 HP  + 10% nerf for advisor+weapon 308000 -> 400400 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4179',`maxdmg`='4963',`baseattacktime`='1400',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21270; -- 251496 1502 3070 2000 -- 8,358 - 9,926

-- Infinity Blades 21271
-- ~210,000 HP + 10% 231000 -> 300300
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5000',`maxdmg`='6111',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21271; -- 1667 3889 -- 9,999 - 12,221

-- Warp Slicer 21272
-- ~290,000 HP + 10% 319000 -> 414700
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='6686',`maxdmg`='7941',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21272; -- 1502 3070 -- 8,358 - 9,926

-- Phaseshift Bulwark 21273
-- ~290,000 HP + 10% 319000 -> 414700
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3999',`maxdmg`='4444',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21273; -- 1666 2555 -- 7,998 - 8,887

-- Staff of Disintegration 21274
-- ~170,000 HP + 10% 187000 -> 243100
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4179',`maxdmg`='4963',`mechanic_immune_mask`='1040135103',`flags_extra`='4194304'  WHERE `entry` = 21274; -- 1502 3070 -- 8,358 - 9,926

-- Phoenix Egg 21364-mob_phoenix_egg_tk
--  70k HP + 10% 77000 -> 100100
UPDATE `creature_template` SET `armor`='5800',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`=`unit_flags`|'262144',`dynamicflags`='8',`flags_extra`='4194304' WHERE `entry` = 21364;

-- Phoenix 21362-mob_phoenix_tk
-- http://www.wowhead.com/npc=21362/phoenix#abilities ~ 177458 + 10% 195204 -> 253765
-- added stun immunity
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2278',`maxdmg`='3309',`resistance2`='0',`mechanic_immune_mask`='1073561599',`flags_extra`='1077936128' WHERE `entry` = 21362; -- 1001 2046 -- 5,572 - 6,617 

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

DELETE FROM `creature` WHERE `guid` IN (12459,12460,12545,12546,12547,12548);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES 
(12459, 20031, 550, 1, 0, 0, 497.37, 101.67, 20.2899, 3.81968, 7200, 0, 0, 125668, 0, 0, 0),
(12460, 20031, 550, 1, 0, 0, 488.734, 107.574, 20.2899, 4.13952, 7200, 0, 0, 125668, 0, 0, 0),
(12545, 20033, 550, 1, 0, 0, 485.237, 107.537, 20.2899, 4.0116, 7200, 0, 0, 100520, 32310, 0, 0),
(12546, 20033, 550, 1, 0, 0, 482.367, 105.012, 20.2899, 4.0155, 7200, 0, 0, 100520, 32310, 0, 0),
(12547, 20032, 550, 1, 0, 0, 497.415, 97.8661, 20.2899, 3.7131, 7200, 0, 0, 160832, 48465, 0, 0),
(12548, 20034, 550, 1, 0, 0, 494.6575, 94.2722, 20.2898, 3.8506, 7200, 0, 0, 100520, 32310, 0, 0);

DELETE FROM `creature` WHERE `guid` IN (200032,200033,200034);
INSERT INTO `creature` VALUES
(200032, 20050, 550, 1, 0, 0, 742.0285, -0.7949, 46.7796, 3.1573, 7200, 0, 0, 230000, 49635, 0, 2),
(200033, 20048, 550, 1, 0, 0, 741.9401, 4.8253, 46.7796, 3.1573, 7200, 0, 0, 180000, 0, 0, 0),
(200034, 20048, 550, 1, 0, 0, 742.1139, -6.2403, 46.7788, 3.1573, 7200, 0, 0, 180000, 0, 0, 0);

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

DELETE FROM `creature_formations` WHERE `leaderguid` IN (12545,12546,12547,12548,12459,12460,200032,200033,200034);
DELETE FROM `creature_formations` WHERE `memberguid` IN (12545,12546,12547,12548,12459,12460,200032,200033,200034);
INSERT INTO `creature_formations` VALUES

(200032,200032,100,360,2),
(200032,200033,3,1.1,2),
(200032,200034,3,5.1,2),

(12545,12545,100,360,2),
(12545,12546,100,360,2),
(12545,12547,100,360,2),
(12545,12548,100,360,2),
(12545,12459,100,360,2),
(12545,12460,100,360,2);

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (12545,12546,12547,12548,12459,12460,200032,200033,200034);
INSERT INTO `creature_linked_respawn` VALUES

(200032,82162),
(200033,82162),
(200034,82162),

(12545,12478),
(12546,12478),
(12547,12478),
(12548,12478),
(12459,12478),
(12460,12478);

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

SET @GUID := 200032;
SET @POINT := 0;
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,16908544,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,740.5244,-0.7594,46.7795,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,707.7401,-0.7159,46.7795,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1,709.5639,-0.6971,46.7795,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1,742.0285,-0.7949,46.7796,10000,0,0,100,0);

UPDATE `creature` SET `position_x`='528.0247', `position_y`='159.3643', `position_z`='20.2494', `orientation`='2.8928' WHERE `guid` = '12544';
UPDATE `creature` SET `position_x`='522.1024', `position_y`='136.0457', `position_z`='20.2510', `orientation`='2.8928' WHERE `guid` = '12543';

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

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

-- Other T5 Loot in SSC 2.1 Changes

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

-- Void Reaver
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 19516 AND `item` = 29434; -- 100

-- Token
UPDATE `creature_loot_template` SET `maxcount` = 1 WHERE `entry` = 19516 AND `item` = 34054; -- 3

-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 19516 AND `item` = 34052; -- 10
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 19516 AND `item` = 90052; -- 2

-- Solarian
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 18805 AND `item` = 29434; -- 100
-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 18805 AND `item` = 34052; -- 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 18805 AND `item` = 90052; -- 10

-- Kael'thas Sunstrider
-- BoJ
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` = 19622 AND `item` = 29434; -- 100
-- Pattern
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 19622 AND `item` = 34052; -- 2
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `entry` = 19622 AND `item` = 90052; -- 10
-- Items
DELETE FROM `creature_loot_template` WHERE `entry` = 19622 AND `item` = 90056; -- not needed
UPDATE `creature_loot_template` SET `groupid`= 0, `maxcount` = 2 WHERE `entry` = 19622 AND `item` = 34056; -- make 90056 not needed anymore

-- Tokens
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 19622 AND `item` = 50032; -- 3

Looking4Group / L4G_Core

Tempest Keep: The Eye #2327

Souces: