Hyjal Summit

[Xadras]

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

---

ToDo:

• http://piclair.com/1jccq https://media-curse.cursecdn.com/attachments/37/135/forte-archimonde.jpg loottable

---

• [ ] The number of preliminary waves before each boss in the Caverns of Time: Battle for Mount Hyjal event has been reduced from 12 to 8, and some of the larger waves have fewer creatures than before.

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

---

• [ ] Faction and loot rewards have been added to non-boss mobs in the Battle of Mount Hyjal raid event. The faction awarded by bosses has been decreased to balance this.

• [ ] The health of Jaina and Thrall have been increased again from their temporarily lowered values. They should be able to absorb quite a bit more incidental damage during the event.

• [ ] Archimonde has received several adjustments and fixes to prevent some of the harder to counter combinations of his abilities.

• [ ] Archimonde's Soul Charge silence has been lowered in duration to 4 seconds, and the death of the Priest with Spirit of Redemption will no longer create two Soul Charges. Reduced from 6 Seconds Duration. http://wowwiki.wikia.com/wiki/Archimonde_(tactics)?oldid=824048

• [ ] The casting time of Archimonde's fear has been increased to 1.5 seconds, and he should now use his Fear ability on a much more consistent interval.

• [ ] Archimonde will also no longer cast Grip of the Legion on very far away targets.

• [ ] Archimonde will no longer cast Grip of the Legion on targets that have just been hit with Air Burst.

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

---

• [ ] Howl of Azgalor is now a zone-wide effect

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

---

• [ ] Increased the reputation awarded for killing Archimonde in Hyjal Summit.

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

---

• [ ] The Vials of Eternity quest is no longer necessary for entry to Hyjal. This quest is still required for faction rings.
• [ ] Azgalor's Rain of Fire now affects a smaller area.
• [ ] Archimonde's Grip of the Legion will no longer target pets.

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

---

• [x] The area around Archimonde in Battle for Mount Hyjal has been decreased in size and players are no longer able to go into the hills around his area. Also, the hitbox of Archimonde has been reduced significantly.

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

[Xadras]

Sources:

http://wow.gamepedia.com/Battle_for_Mount_Hyjal#Trash_Waves_2 , http://wowwiki.wikia.com/wiki/Battle_for_Mount_Hyjal

---

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

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

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

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

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

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

https://www.youtube.com/watch?v=0HHxZgVhsa4 - P1

https://www.youtube.com/watch?v=xp6rRQrJ8tE - P2

https://www.youtube.com/watch?v=9lbrZkXC0qk - P3

---

Visuals:

https://www.youtube.com/watch?v=5DyK-rxftTs

https://www.youtube.com/watch?v=P7lgX-TtAfQ

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

[Xadras]

#!sql
-- https://github.com/Looking4Group/L4G_Core/issues/641
-- http://hellfire-tbc.com/hellfire2/forums/showthread.php?tid=2477
-- =============================
-- Caverns of Time: Hyjal Summit
-- =============================

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

UPDATE `creature_ai_texts` SET `content_loc3` = 'Lasst diese Monster kalten Stahl schmecken!' WHERE `entry` = -985;

-- -XXX- -XXX
-- DELETE FROM `creature_ai_texts` WHERE `entry` IN ('XXX');
-- INSERT INTO `creature_ai_texts` VALUES
-- (-XXX,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'HyjalPlatzhalter'),
-- (-XXX,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'HyjalPlatzhalter'),

-- ('-695','A pleasure... to serve the master.','0','0','0','17899','0'),
-- ('-696','You will... ultimately fail.','0','0','0','17899','0'),
-- ('-697','My life... to the master.','0','0','0','17899','0'),

-- Shadowy Necromancer says: Rise, my soldiers, and march for me!

-- Lady Jaina Proudmoore yells: Hold them back as long as possible!
-- Lady Jaina Proudmoore yells: We have won valuable time. Now we must pull back.
-- Lady Jaina Proudmoore yells: We must hold strong!

-- Thrall yells: Bring the fight to me and pay with your lives!
-- Thrall yells: I will lay down for no one!
-- Thrall yells: It is over! Withdraw! We have failed....

-- Banshee says: I am... released?
-- Banshee says: Is it really... over?
-- Banshee says: Let this torment end!!

-- ======================================================
-- Spawns
-- ======================================================

DELETE FROM `creature` WHERE `guid` IN (27135,48568,49995,256773,51861,52942,52943,48425);
INSERT INTO `creature` VALUES (27135, 4646, 1, 1, 9420, 0, -2239.72, 2411.1, 54.4443, 2.60245, 300, 5, 0, 1163, 0, 0, 1);
INSERT INTO `creature` VALUES (48568, 17919, 534, 1, 0, 0, 5017.48, -1737.11, 1324.66, 2.52227, 120, 0, 0, 41916, 0, 0, 0); -- 20700
INSERT INTO `creature` VALUES (49995, 17921, 534, 1, 0, 0, 5026.87, -1841.01, 1322.42, 5.12241, 120, 0, 0, 41916, 0, 0, 0); -- 16200
INSERT INTO `creature` VALUES (51861, 23437, 534, 1, 0, 0, 4206.96, -4174.64, 870.099, 1.40248, 120, 0, 0, 9800, 0, 0, 0);
INSERT INTO `creature` VALUES (52942, 17852, 534, 1, 0, 1048, 5449.97, -2723.77, 1485.67, 5.8858, 300, 0, 0, 455250, 50805, 0, 0);
INSERT INTO `creature` VALUES (52943, 17936, 534, 1, 0, 0, 5454.07, -2713.43, 1485.8, 5.6903, 120, 0, 0, 33534, 22716, 0, 0); -- 20700
INSERT INTO `creature` VALUES (48425, 17922, 534, 1, 0, 0, 5078.84, -1795.86, 1320.79, 3.16519, 120, 0, 0, 29340, 32382, 0, 0); -- 18000

DELETE FROM `creature` WHERE `guid` BETWEEN 190700 AND 190701;
INSERT INTO `creature` VALUES (190700, 17919, 534, 1, 0, 0, 4989.3134, -1751.1210, 1331.4525, 1.7154, 120, 0, 0, 41916, 0, 0, 0);
INSERT INTO `creature` VALUES (190701, 17919, 534, 1, 0, 0, 4976.4956, -1752.9862, 1330.7408, 1.7154, 120, 0, 0, 41916, 0, 0, 0);

-- ======================================================
-- NPC Research
-- Trash /1.25
-- ======================================================

-- Druid of the Talon 3794
-- wooden staff
UPDATE `creature_template` SET `AIName`='EventAI',`flags_extra`='0' WHERE `entry` = '3794';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '3794';
INSERT INTO `creature_ai_scripts` VALUES
('379401','3794','9','0','100','0','8','40','2400','4800','11','31784','1','0','0','0','0','0','0','0','0','0','Druid of the Talon - Cast Wrath'),
('379402','3794','9','0','100','3','0','30','30000','33000','11','25602','4','32','0','0','0','0','0','0','0','0','Druid of the Talon - Cast Faerie Fire');

-- Druid of the Claw 3795
UPDATE `creature_template` SET `AIName`='EventAI',`flags_extra`='0' WHERE `entry` = '3795';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '3795';
INSERT INTO `creature_ai_scripts` VALUES
('379501','3795','4','0','100','2','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Druid of the Claw - Set Phase 1 on Aggro'),
('379502','3795','14','5','100','3','5000','40','4000','8000','11','31782','6','0','0','0','0','0','0','0','0','0','Druid of the Claw - Cast Rejuvenation on Friendlies (Phase 1)'),
('379503','3795','2','5','100','3','95','0','12000','15000','11','31782','0','0','0','0','0','0','0','0','0','0','Druid of the Claw - Cast Rejuvenation on Self (Phase 1)'),
('379504','3795','2','0','100','2','50','0','0','0','11','31792','0','1','22','2','0','0','0','0','0','0','Druid of the Claw - Cast Bear Form and Set Phase 2 on 50% Health'),
('379505','3795','3','0','100','2','5','0','0','0','11','31792','0','1','22','2','0','0','0','0','0','0','Druid of the Claw - Cast Bear Form and Set Phase 2 on 5% Mana'),
('379506','3795','7','0','100','2','0','0','0','0','28','0','31792','0','0','0','0','0','0','0','0','0','Druid of the Claw - Remove Bear Form on Evade');

-- Tyrande Whisperwind 7999
-- not hyjal darnassus version
UPDATE `creature_template` SET `AIName`='EventAI',`flags_extra`='0' WHERE `entry` = '7999'; -- 3
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '7999';
INSERT INTO `creature_ai_scripts` VALUES
('799901','7999','9','0','100','3','0','15','6000','8000','11','20691','1','0','0','0','0','0','0','0','0','0','Tyrande Whisperwind - Cast Cleave'),
('799902','7999','9','0','100','3','0','30','16000','21000','11','20687','4','1','0','0','0','0','0','0','0','0','Tyrande Whisperwind - Cast Starfall'),
('799903','7999','0','0','100','3','9000','12000','17000','22000','11','20690','5','0','0','0','0','0','0','0','0','0','Tyrande Whisperwind - Cast Moonfire'),
('799904','7999','0','0','100','3','11000','14000','9000','12000','11','20688','2','1','0','0','0','0','0','0','0','0','Tyrande Whisperwind - Cast Searing Arrow');

-- Echo of Archimonde 13083
-- UPDATE `creature_template` SET  WHERE `entry` = '';

-- Lady Jaina Proudmoore 17772- npc_jaina_proudmoore
UPDATE `creature_template` SET `armor`='6350' WHERE `entry` = 17772;

-- Thrall 17852- npc_thrall

-- Dire Wolf 17854
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = 17854;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17854;
INSERT INTO `creature_ai_scripts` VALUES
('1785401','17854','9','0','100','3','0','5','9000','14000','11','31334','1','0','0','0','0','0','0','0','0','0','Dire Wolf - Cast Growl');

-- Ghoul 17895- mob_ghoul
-- http://wowwiki.wikia.com/wiki/Ghoul_(Hyjal)
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='2700',`maxdmg`='2940',`mechanic_immune_mask`='8388625',`flags_extra`='1073741824' WHERE `entry` = 17895; -- 1.2 2200 2500 -- 3375 - 3675
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='3' WHERE `creature_id` = 17895; -- 12 in 2.4
DELETE FROM creature_template_addon WHERE entry = 17895;
INSERT INTO creature_template_addon VALUES (17895,0,0,0,0,4097,0,0,'8278 0');

-- Crypt Fiend 17897- mob_crypt_fiend
-- http://wowwiki.wikia.com/wiki/Crypt_Fiend_(Hyjal)
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='3791',`maxdmg`='3958',`mechanic_immune_mask`='8388625',`flags_extra`='1073741824' WHERE `entry` = 17897; -- 1.2 3750 4000 -- 5687 - 5937 /1.5

-- Abomination 17898- mob_abomination
-- http://wowwiki.wikia.com/wiki/Abomination_(Hyjal)
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='6300',`maxdmg`='6540',`mechanic_immune_mask`='8388625',`flags_extra`='1073741824' WHERE `entry` = 17898; -- 1.2 5200 5500 1400 -- 7875 - 8175

-- Shadowy Necromancer 17899- mob_necromancer
-- http://wowwiki.wikia.com/wiki/Shadowy_Necromancer_(Hyjal)
UPDATE `creature_template` SET `armor`='5450',`speed`='1.20',`mindmg`='2995',`maxdmg`='3795' WHERE `entry` = 17899; -- 0 1.2 3230 4230 -- 3744 - 4744

-- ('1789901','17899','0','0','100','3','6000','10000','9000','16000','11','31627','1','0','0','0','0','0','0','0','0','0','Shadowy Necromancer - Cast Shadow Bolt'),
-- ('1789902','17899','5','0','100','3','0','0','0','0','30','1','2','3','0','0','0','0','0','0','0','0','Shadowy Necromancer - Random Phase on Player Death'),
-- ('1789903','17899','0','13','100','2','0','0','1500','1500','11','31617','0','1','22','0','0','0','0','0','0','0','Shadowy Necromancer - Cast Raise Dead On Player Kill and Set Phase Back To 0 (Phase 1)'),
-- ('1789904','17899','0','11','100','2','0','0','1500','1500','11','31624','0','1','22','0','0','0','0','0','0','0','Shadowy Necromancer - Cast Raise Dead On Player Kill and Set Phase Back To 0 (Phase 2)'),
-- ('1789905','17899','0','7','100','2','0','0','1500','1500','11','31625','0','1','22','0','0','0','0','0','0','0','Shadowy Necromancer - Cast Raise Dead On Player Kill and Set Phase Back To 0 (Phase 3)'),
-- ('1789906','17899','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Shadowy Necromancer - Set Phase To 0 On Evade'),
-- ('1789907','17899','6','0','25','2','0','0','0','0','1','-695','-696','-697','0','0','0','0','0','0','0','0','Shadowy Necromancer - Random Say on Death'),

-- Skeleton Invader 17902
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='1201',`maxdmg`='1457',`mechanic_immune_mask`='8388625' WHERE `entry` = 17902; -- 1.2 408 921 -- 2,401 - 2,914 /2
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = 3 WHERE `creature_id` = 17902;

-- Skeleton Mage 17903
UPDATE `creature_template` SET `armor`='5450',`speed`='1.20',`mindmg`='941',`maxdmg`='1158',`AIName`='EventAI',`mechanic_immune_mask`='8388625' WHERE `entry` = 17903; -- 0 1.2 308 742 -- 1,881 - 2,315 /2
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = 3 WHERE `creature_id` = 17903;
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` = 17903;
INSERT INTO `creature_ai_scripts` (`id`,`entryOrGUID`,`event_type`,`event_inverse_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action1_type`,`action1_param1`,`action1_param2`,`action1_param3`,`action2_type`,`action2_param1`,`action2_param2`,`action2_param3`,`action3_type`,`action3_param1`,`action3_param2`,`action3_param3`,`comment`) VALUES
('1790301','17903','0','0','100','2','0','0','0','0','30','1','2','3','0','0','0','0','0','0','0','0','Skeleton Mage - Select Random Phase on Aggro'),
('1790302','17903','9','6','100','3','0','40','3400','4800','11','31622','1','0','0','0','0','0','0','0','0','0','Skeleton Mage - Cast Frostbolt (Phase 1)'),
('1790303','17903','9','5','100','3','0','40','3400','4800','11','31620','1','0','0','0','0','0','0','0','0','0','Skeleton Mage - Cast Fireball (Phase 2)'),
('1790304','17903','9','3','100','3','0','40','3400','4800','11','31618','1','0','0','0','0','0','0','0','0','0','Skeleton Mage - Cast Shadowbolt (Phase 3)');

-- Banshee 17905- mob_banshee
-- http://wowwiki.wikia.com/wiki/Banshee_(Hyjal)
UPDATE `creature_template` SET `speed`='1.2',`mindmg`='1531',`maxdmg`='1817',`mechanic_immune_mask`='8388625' WHERE `entry` = 17905; -- 1.2 826 1685 -- 4,592 - 5,451 /3

-- Gargoyle 17906- mob_gargoyle
-- http://wowwiki.wikia.com/wiki/Gargoyle_(Hyjal)
UPDATE `creature_template` SET `speed`='1.2',`mindmg`='2474',`maxdmg`='2938',`mechanic_immune_mask`='8388625' WHERE `entry` = 17906; -- 1.2 1334 2726 -- 7,422 - 8,814 /3 

-- Frost Wyrm 17907- mob_frost_wyrm
-- http://wowwiki.wikia.com/wiki/Frost_Wyrm_(Hyjal)
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='9222',`maxdmg`='10953',`mechanic_immune_mask`='652967935',`flags_extra`='1078001664' WHERE `entry` = 17907; -- 1.2 2071 4234 -- 11528 - 13691

-- Giant Infernal 17908- mob_giant_infernal
-- http://wowwiki.wikia.com/wiki/Giant_Infernal_(Hyjal)
UPDATE `creature_template` SET `speed`='1.2',`mindmg`='1400',`maxdmg`='1600',`dmgschool`='2',`mechanic_immune_mask`='14341' WHERE `entry` = 17908; -- 1.2 678 1386 -- 3,774 - 4,482

-- Fel Stalker 17916- mob_fel_stalker
-- http://wowwiki.wikia.com/wiki/Fel_Stalker_(Hyjal)
UPDATE `creature_template` SET `speed`='1.2',`mindmg`='1392',`maxdmg`='1653' WHERE `entry` = 17916; -- 1.2 1000 2045 -- 5,567 - 6,612 /4

-- Alliance Footman 17919
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17919;
UPDATE `creature_template` SET `armor` = 6800 WHERE `entry` = 17919; -- 0
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17919;
INSERT INTO `creature_ai_scripts` VALUES
(1791901, 17919, 0, 0, 100, 3, 4000, 8000, 16000, 25000, 11, 31731, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - Cast Shield Wall'),
(1791902, 17919, 4, 0, 25, 2, 0, 0, 0, 0, 1, -985, -986, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - Say on Aggro'),
(1791903, 17919, 6, 0, 25, 2, 0, 0, 0, 0, 1, -987, -988, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - Say on Death'),
(1791904, 17919, 12, 0, 25, 2, 2, 0, 0, 0, 1, -989, -990, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Footman - Say on Kill');

-- Alliance Knight 17920
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17920;
UPDATE `creature_template` SET `armor` = 6200, `speed` = '1.20' WHERE `entry` = 17920; -- 0 2
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17920;
INSERT INTO `creature_ai_scripts` VALUES
(1792001, 17920, 0, 0, 100, 3, 1000, 3000, 21000, 35000, 11, 31732, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Knight - Cast Rallying Cry'),
(1792002, 17920, 4, 0, 25, 2, 0, 0, 0, 0, 1, -977, -978, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Knight - Say on Aggro'),
(1792003, 17920, 6, 0, 25, 2, 0, 0, 0, 0, 1, -979, -980, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Knight - Say on Death'),
(1792004, 17920, 12, 0, 25, 2, 2, 0, 0, 0, 1, -981, -982, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Knight - Say on Kill');

-- Alliance Rifleman 17921- alliance_rifleman
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17921;

-- Alliance Sorceress 17922
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17922;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17922;
INSERT INTO `creature_ai_scripts` VALUES
('1792201','17922','4','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Alliance Sorceress - Set Phase 1 on Aggro'),
('1792202','17922','9','5','100','3','8','30','3400','4800','11','31743','1','0','0','0','0','0','0','0','0','0','Alliance Sorceress - Cast Arcane Missile (Phase 1)'),
('1792203','17922','3','5','100','2','7','0','0','0','22','2','0','0','0','0','0','0','0','0','0','0','Alliance Sorceress - Set Phase 2 when Mana is at 7% (Phase 1)'),
('1792204','17922','3','3','100','3','100','15','1000','1000','22','1','0','0','0','0','0','0','0','0','0','0','Alliance Sorceress - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1792205','17922','0','0','100','3','10000','14000','13000','18000','11','31741','4','32','0','0','0','0','0','0','0','0','Alliance Sorceress - Cast Slow'),
('1792206','17922','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Alliance Sorceress - Set Phase to 0 on Evade'),
(1792207, 17922, 6, 0, 25, 0, 0, 0, 0, 0, 1, -991, -992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Sorceress - Say on Death');

-- Alliance Priest 17928
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17928;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17928;
INSERT INTO `creature_ai_scripts` VALUES
('1792801','17928','4','0','100','2','0','0','0','0','22','1','0','0','21','0','0','0','0','0','0','0','Alliance Priest - Set Phase 1 and Stop Movement on Aggro'),
('1792802','17928','9','5','100','3','8','40','3400','4800','11','31740','1','0','0','0','0','0','0','0','0','0','Alliance Priest - Cast Holy Smite (Phase 1)'),
('1792803','17928','3','5','100','2','7','0','0','0','21','1','0','0','22','2','0','0','0','0','0','0','Alliance Priest - Enable Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1792804','17928','3','3','100','3','100','15','1000','1000','22','1','0','0','21','0','0','0','0','0','0','0','Alliance Priest - Set Phase 1 and Disable Movement when Mana is above 15% (Phase 2)'),
('1792805','17928','14','0','100','3','15000','40','15000','21000','11','31739','6','1','0','0','0','0','0','0','0','0','Alliance Priest - Cast Heal on Friendlies'),
('1792806','17928','7','0','100','2','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Alliance Priest - Set Phase to 0 on Evade'),
(1792807, 17928, 6, 0, 15, 0, 0, 0, 0, 0, 1, -983, -984, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Alliance Priest - Say on Death');

-- Alliance Peasant 17931
-- http://www.wowhead.com/npc=17931/alliance-peasant#english-comments
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17931;
DELETE FROM `creature_template_addon` WHERE `entry` = 17931;
INSERT INTO `creature_template_addon` VALUES
(17931,0,0,0,0,4097,173,0,'');

-- Horde Grunt 17932
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17932;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17932;
INSERT INTO `creature_ai_scripts` VALUES 
(1793201, 17932, 9, 0, 100, 3, 0, 5, 10000, 15000, 11, 31754, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - Cast Strike'),
(1793202, 17932, 4, 0, 25, 0, 0, 0, 0, 0, 1, -800, -801, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - Text on Aggro'),
(1793203, 17932, 6, 0, 25, 0, 0, 0, 0, 0, 1, -802, -803, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - Text on Death'),
(1793204, 17932, 12, 0, 25, 0, 2, 0, 500, 1000, 1, -804, -805, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Grunt - Text on Kill');

-- Tauren Warrior 17933
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17933;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17933;
INSERT INTO `creature_ai_scripts` VALUES
('1793301','17933','9','0','100','3','0','15','7000','11000','11','31755','0','0','0','0','0','0','0','0','0','0','Tauren Warrior - Cast War Stomp'),
(1793302, 17933, 4, 0, 25, 0, 0, 0, 0, 0, 1, -971, -972, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tauren Warrior - Say on Aggro'),
(1793303, 17933, 6, 0, 25, 0, 0, 0, 0, 0, 1, -973, -974, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tauren Warrior - Say on Death'),
(1793304, 17933, 12, 0, 25, 0, 2, 0, 500, 1000, 1, -975, -976, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tauren Warrior - Say on Kill');

-- Horde Headhunter 17934
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17934;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17934;
INSERT INTO `creature_ai_scripts` VALUES
('1793401','17934','0','0','100','3','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Horde Headhunter - Start Movement and Set Melee Weapon Model'),
('1793402','17934','9','0','100','3','8','40','3000','4500','11','31758','4','0','40','2','0','0','21','0','0','0','Horde Headhunter - Cast Spear Throw and Set Ranged Weapon Model and Stop Movement'),
('1793403','17934','9','0','100','3','0','8','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Horde Headhunter - Start Movement and Set Melee Weapon Model Below 8 Yards'),
('1793404','17934','7','0','100','0','0','0','0','0','21','1','0','0','40','1','0','0','21','1','0','0','Horde Headhunter - Start Movement and Set Melee Weapon Model on Evade'),
('1793405','17934','9','0','100','3','8','40','0','0','21','0','0','0','40','2','0','0','0','0','0','0','Horde Headhunter - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 8 Yards'),
(1793406, 17934, 4, 0, 25, 0, 0, 0, 0, 0, 1, -965, -966, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Headhunter - Say on Aggro'),
(1793407, 17934, 6, 0, 25, 0, 0, 0, 0, 0, 1, -967, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Headhunter - Say on Death'),
(1793408, 17934, 12, 0, 25, 0, 2, 0, 500, 1000, 1, -968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Headhunter - Say on Kill');

-- Horde Witch Doctor 17935
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17935;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17935;
INSERT INTO `creature_ai_scripts` VALUES
('1793501','17935','4','0','100','2','0','0','0','0','11','31760','0','0','0','0','0','0','0','0','0','0','Horde Witch Doctor - Cast Healing Ward on Aggro'),
('1793502','17935','9','0','100','3','8','40','3400','4800','11','31759','1','0','0','0','0','0','0','0','0','0','Horde Witch Doctor - Cast Holy Bolt'),
('1793503','17935','0','0','100','3','11000','16000','30000','36000','11','31760','0','33','0','0','0','0','0','0','0','0','Horde Witch Doctor - Cast Healing Ward'),
(1793504, 17935, 6, 0, 25, 0, 0, 0, 0, 0, 1, -970, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Witch Doctor - Say on Death');

-- Horde Shaman 17936
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17936;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17936;
INSERT INTO `creature_ai_scripts` VALUES
('1793601','17936','1','0','100','3','1000','1000','600000','600000','11','31765','0','1','0','0','0','0','0','0','0','0','Horde Shaman - Cast Lightning Shield OOC'),
('1793602','17936','9','0','100','3','8','40','3400','4800','11','31764','1','0','0','0','0','0','0','0','0','0','Horde Shaman - Cast Lightning Bolt'),
('1793603','17936','0','0','100','3','14000','26000','40000','55000','11','6742','0','1','0','0','0','0','0','0','0','0','Horde Shaman - Cast Bloodlust'),
('1793604','17936','16','0','100','3','31765','1','15000','30000','11','31765','0','33','0','0','0','0','0','0','0','0','Horde Shaman - Cast Lightning Shield on Missing Buff'),
(1793605, 17936, 6, 0, 25, 0, 0, 0, 0, 0, 1, -969, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Horde Shaman - Say on Death');

-- Horde Peon 17937
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 17937;
DELETE FROM `creature_template_addon` WHERE `entry` = 17937;
INSERT INTO `creature_template_addon` VALUES
(17937,0,0,0,0,4097,173,0,'');

-- Night Elf Archer 17943
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 17943;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17943;
INSERT INTO `creature_ai_scripts` VALUES
('1794301','17943','0','0','100','3','1000','1000','2000','2000','21','1','0','0','40','1','0','0','0','0','0','0','Night Elf Archer - Start Movement and Set Melee Weapon Model'),
('1794302','17943','9','0','100','3','8','40','3000','4500','11','32103','4','0','40','2','0','0','21','0','0','0','Night Elf Archer - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
('1794303','17943','9','0','100','3','0','8','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Night Elf Archer - Start Movement and Set Melee Weapon Model Below 8 Yards'),
('1794304','17943','7','0','100','0','0','0','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Night Elf Archer - Start Movement and Set Melee Weapon Model on Evade'),
('1794305','17943','9','0','100','3','8','40','0','0','21','0','0','0','40','2','0','0','0','0','0','0','Night Elf Archer - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 8 Yards');

-- Dryad 17944

-- Night Elf Huntress 17945
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 17945;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17945;
INSERT INTO `creature_ai_scripts` VALUES
('1794501','17945','9','0','100','3','0','5','6000','10000','11','31779','1','0','0','0','0','0','0','0','0','0','Night Elf Huntress - Cast Cleave');

-- Ancient Wisp 17946- mob_ancient_wisp

-- Tyrande Whisperwind 17948- npc_tyrande_whisperwind

-- Guardian Water Elemental 18001

-- Horde Healing Ward 18036- POSSIBLE HEALING SPELL CASTS?

-- Night Elf Ancient of War 18485

-- Night Elf Ancient of Lore 18486

-- Night Elf Ancient Protector 18487
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = 18487;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18487;
INSERT INTO `creature_ai_scripts` VALUES
('1848701','18487','9','0','100','3','0','30','9000','14000','11','11922','4','32','0','0','0','0','0','0','0','0','Night Elf Ancient Protector - Cast Entangling Roots'),
('1848702','18487','9','0','100','3','0','5','8000','12000','11','45','0','1','0','0','0','0','0','0','0','0','Night Elf Ancient Protector - Cast War Stomp');

-- Night Elf Wisp 18502
UPDATE `creature_template` SET `Inhabittype`='7' WHERE `entry` = 18502;

-- Tydormu 23381

-- Indormi 23437
UPDATE `creature` SET `spawnmask` = 1 WHERE `id` = 23437;

-- ==============
-- Bosses
-- /2.5
-- ==============

-- Rage Winterchill 17767- boss_rage_winterchill
-- http://wow.gamepedia.com/index.php?title=Rage_Winterchill_(tactics)&direction=next&oldid=725383
-- https://web.archive.org/web/20100907205436/http://www.hordeguides.de/Schlachtzug/TBC/Boss/17767/Furor-Winterfrost/index.htm
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='9796',`maxdmg`='11608',`mechanic_immune_mask`='650854231' WHERE `entry` = 17767; -- 4398 8969 -- ~5626 6563! -- 24,449 - 29,020 /2.5

-- Anetheron 17808- boss_anetheron
-- https://web.archive.org/web/20100907205442/http://www.hordeguides.de/Schlachtzug/TBC/Boss/17808/Anetheron/index.htm
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='10867',`maxdmg`='12898',`mechanic_immune_mask`='650854263' WHERE `entry` = 17808; -- 4888 9966 -- ~6082 12163! -- 27,167 - 32,245

-- Towering Infernal 17818- mob_towering_infernal
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4616',`maxdmg`='5482',`flags_extra`=`flags_extra`|1073741824 WHERE `entry` = 17818; -- 2073 4238 -- 11,539 - 13,704

-- Kaz'rogal 17888- boss_kazrogal
-- https://web.archive.org/web/20100907205452/http://www.hordeguides.de/Schlachtzug/TBC/Boss/17888/Kazrogal/index.htm
-- Warstomp cant be fixed as spell range is calculated from bounding radius.
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='6792',`maxdmg`='8061',`mechanic_immune_mask`='650854391' WHERE `entry` = 17888; -- 4888 9966 -- 8717 10744 -- 10867 12898 -- 27,167 - 32,245 /4
UPDATE `creature_model_info` SET `bounding_radius` = 13, `combat_reach` = 13 WHERE `modelid` = 17886; -- 0

-- Azgalor 17842- boss_azgalor
-- https://web.archive.org/web/20100907205446/http://www.hordeguides.de/Schlachtzug/TBC/Boss/17842/Azgalor/index.htm
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='16957',`maxdmg`='19292',`equipment_id`='1566',`mechanic_immune_mask`='650854263' WHERE `entry` = 17842; -- 13000 20000 -- 50,876 - 57,876 /3

-- Lesser Doomguard 17864- mob_lesser_doomguard
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='2675',`maxdmg`='3176',`mechanic_immune_mask`='1056914431',`flags_extra`='1078001664' WHERE `entry` = 17864; -- 1443 2945 -- 8025 - 9527

-- Archimonde 17968- boss_archimonde
-- https://web.archive.org/web/20100907205458/http://www.hordeguides.de/Schlachtzug/TBC/Boss/17968/Archimonde/index.htm
UPDATE `creature_template` SET `speed`='2.4',`mindmg`='18182',`maxdmg`='21242',`mechanic_immune_mask`='650854399' WHERE `entry` = 17968; -- 2 17786 21242 -- 15204 20271 -- 54,547 - 58,003

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

DELETE FROM `creature_addon` WHERE `guid` IN (49163,49164,49988,49995);
INSERT INTO `creature_addon` VALUES 
(49163,0,0,512,0,4097,333,0,''),
(49164,0,0,512,0,4097,333,0,''),
(49988,0,0,512,0,4097,214,0,''),
(49995,0,0,512,0,4097,214,0,'');

UPDATE `creature` SET `position_x`='5183.02', `position_y`='-3382.98', `position_z`='1638.14', `orientation`='6.03443',`spawndist`='0',`movementtype`='0' WHERE `guid` = 52080;

-- Delete wrong movement
DELETE FROM `creature_addon` WHERE `guid` = 51475;

SET @GUID := 48408;
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,NULL);
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, 5542.7763, -2623.4787, 1480.8839,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5544.7011, -2616.4560, 1480.6052,25000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5542.7763, -2623.4787, 1480.8839,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5524.6240, -2658.0793, 1479.7385,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5524.1284, -2672.3625, 1478.6580,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5535.5302, -2710.9177, 1480.4343,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5525.7451, -2731.6071, 1483.6087,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5511.0634, -2746.2360, 1486.3032,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5455.3535, -2776.0166, 1494.2977,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5429.9252, -2797.3664, 1499.1535,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5412.1474, -2830.4309, 1507.4825,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5413.0126, -2852.3854, 1512.1518,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5409.5488, -2853.1596, 1512.4718,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5363.7841, -2861.5798, 1512.8094,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5366.8540, -2860.8496, 1512.8094,25000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5413.0126, -2852.3854, 1512.1518,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5413.2294, -2846.2573, 1510.8695,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5412.1474, -2830.4309, 1507.4825,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5429.9252, -2797.3664, 1499.1535,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5455.3535, -2776.0166, 1494.2977,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5511.0634, -2746.2360, 1486.3032,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5525.7451, -2731.6071, 1483.6087,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5535.5302, -2710.9177, 1480.4343,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5524.1284, -2672.3625, 1478.6580,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5524.6240, -2658.0793, 1479.7385,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5542.7763, -2623.4787, 1480.8839,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5544.7011, -2616.4560, 1480.6052,0,0,0,100,0);

UPDATE `creature` SET `position_x`='5380.7304', `position_y`='-2784.2524', `position_z`='1500.9121', `orientation`='4.4290' WHERE `guid` = 52949;
UPDATE `creature` SET `position_x`='5593.1992', `position_y`='-2715.9479', `position_z`='1495.6308', `orientation`='0.6714' WHERE `guid` = 53013;

SET @GUID := 51901;
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,NULL);
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, 5004.2299, -1892.4552, 1325.9412,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4977.6147, -1885.4683, 1321.7950,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4976.6030, -1883.3793, 1321.6474,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4973.8300, -1871.4394, 1321.1518,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4974.6821, -1869.4301, 1321.1088,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4994.4121, -1846.3155, 1321.6802,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5014.2958, -1827.2132, 1321.6782,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5016.2309, -1821.8514, 1321.8298,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5030.5507, -1778.0809, 1321.8430,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5023.7495, -1767.4716, 1322.2296,10000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5030.4970, -1782.4370, 1321.7009,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5023.1923, -1812.6506, 1321.7681,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5016.2309, -1821.8514, 1321.8298,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4994.4121, -1846.3155, 1321.6802,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4974.6821, -1869.4301, 1321.1088,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4973.8300, -1871.4394, 1321.1518,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4976.6030, -1883.3793, 1321.6474,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 4982.3364, -1886.0722, 1322.4235,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5004.2299, -1892.4552, 1325.9412,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5049.2622, -1886.9235, 1331.6601,30000,0,0,100,0);

SET @GUID := 52946;
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,NULL);
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, 5436.8325, -2652.5925, 1485.2058,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5448.3828, -2664.9121, 1485.2918,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5461.2944, -2707.1530, 1485.5791,15000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5448.3828, -2664.9121, 1485.2918,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5436.8325, -2652.5925, 1485.2058,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5397.3999, -2634.8000, 1486.3599,15000,0,0,100,0);

-- 52528 movement 

-- 52532 movement

-- 52626 movement

-- 52679 / 52695 movement

SET @GUID := 52953;
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,NULL);
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, 5468.3818, -2949.1467, 1537.6992,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5457.8393, -2932.4338, 1534.6328,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5416.5107, -2896.8491, 1522.7535,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5416.9399, -2892.7543, 1521.9375,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5419.4677, -2873.1367, 1517.0444,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5415.6152, -2856.8845, 1513.1450,15000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5419.4677, -2873.1367, 1517.0444,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5416.5107, -2896.8491, 1522.7535,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5420.8706, -2900.8623, 1523.6153,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5457.8393, -2932.4338, 1534.6328,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5479.4702, -2960.3500, 1538.4300,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5501.1220, -2971.8000, 1537.5042,15000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 5479.4702, -2960.3500, 1538.4300,0,0,0,100,0);

-- 53024 movement

-- 53025 movement

-- ======================================================
-- Linking
-- ======================================================

DELETE FROM `creature_formations` WHERE `leaderguid` IN (52953,52946,51901,51877,51860,48408,48411,48415,48412,48413,48414,48425);
DELETE FROM `creature_formations` WHERE `memberguid` IN (48408,48411,48415,48412,48413,48414,48425);
INSERT INTO `creature_formations` VALUES

(52953, 52953, 100, 360, 2),
(52953, 52981, 3, 0.78, 2),
(52953, 52982, 3, 5.50, 2),

(52946, 52946, 100, 360, 2),
(52946, 52947, 3, 0.78, 2),
(52946, 52948, 3, 5.50, 2),

-- 52695,52679

-- 52626,52628

-- 52532,52533

(51901,51901,100,360,2),
(51901,51860,4,0,2),
(51901,51877,8,0,2),

(48408,48408,100,360,2),
(48408,48411,2,5.5,2),
(48408,48415,2,0.7,2),
(48408,48412,4,5.9,2),
(48408,48413,4,0,2),
(48408,48414,4,0.4,2);

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

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (48425);

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

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

-- 39534 random epic reference loot template hyjal 9 of 18
-- SELECT * FROM `creature_loot_template` WHERE `mincountOrRef` = -39534;
-- see http://www.wowhead.com/item=32589/hellfire-encased-pendant
-- 17908 missing
DELETE FROM `creature_loot_template` WHERE `mincountOrRef` = -39534 AND `entry` = 17908;
INSERT INTO `creature_loot_template` VALUES
(17908, 39534, 1, 1, -39534, 1, 0, 0, 0);

-- Epic GEM Patterns
-- 8 Trash
-- 9 Boss 17767,17808,17888,17842,17968 see wowhead
DELETE FROM `reference_loot_template` WHERE `entry` = 34999;
INSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES 
-- (34999, 32274, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32277, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32281, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32282, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32283, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32284, 0, 8, 1, 1, 7, 755, 1),
(34999, 32285, 0, 9, 1, 1, 7, 755, 1), -- Flashing Crimson Spinel
-- (34999, 32286, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32287, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32288, 0, 8, 1, 1, 7, 755, 1),
(34999, 32289, 0, 9, 1, 1, 7, 755, 1), -- Stormy Empyrean Sapphire
-- (34999, 32290, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32291, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32292, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32293, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32294, 0, 8, 1, 1, 7, 755, 1),
(34999, 32295, 0, 9, 1, 1, 7, 755, 1), -- Mystic Lionseye
(34999, 32296, 0, 9, 1, 1, 7, 755, 1), -- Great Lionseye
(34999, 32297, 0, 9, 1, 1, 7, 755, 1), -- Sovereign Shadowsong Amethyst
(34999, 32298, 0, 9, 1, 1, 7, 755, 1), -- Shifting Shadowsong Amethyst
-- (34999, 32299, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32300, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32301, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32302, 0, 8, 1, 1, 7, 755, 1),
(34999, 32303, 0, 9, 1, 1, 7, 755, 1), -- Inscribed Pyrestone
-- (34999, 32304, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32305, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32306, 0, 8, 1, 1, 7, 755, 1),
(34999, 32307, 0, 9, 1, 1, 7, 755, 1); -- Veiled Pyrestone
-- (34999, 32308, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32309, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32310, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32311, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 32312, 0, 8, 1, 1, 7, 755, 1),
-- (34999, 35762, 0, 8, 1, 1, 7, 755, 1), -- 35767
-- (34999, 35763, 0, 8, 1, 1, 7, 755, 1), -- 35768
-- (34999, 35764, 0, 8, 1, 1, 7, 755, 1), -- 35766
-- (34999, 35765, 0, 8, 1, 1, 7, 755, 1); -- 35769

SET @CHANCE := 0.5;
DELETE FROM `creature_loot_template` WHERE `item` IN (32274,32277,32281,32282,32283,32284,32285,32286,32287,32288,32289,32290,32291,32292,32293,32294,32295,32296,32297,32298,32299,32300,32301,32302,32303,32304,32305,32306,32307,32308,32309,32310,32311,32312,35762,35763,35764,35765,35766,35767,35768,35769);
DELETE FROM `creature_loot_template` WHERE `mincountOrRef` = -34999;
INSERT INTO `creature_loot_template` VALUES
-- Trash 8
-- (17895, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17897, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17898, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17899, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17905, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17906, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17907, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17908, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- (17916, 34999, @CHANCE, 8, -34999, 1, 0, 0, 0),
-- Boss 9
(17767, 34999, 15, 9, -34999, 1, 0, 0, 0),
(17808, 34999, 15, 9, -34999, 1, 0, 0, 0),
(17888, 34999, 20, 9, -34999, 1, 0, 0, 0),
(17842, 34999, 20, 9, -34999, 1, 0, 0, 0),
(17968, 34999, 30, 9, -34999, 1, 0, 0, 0);

-- Azgalor Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 17842 AND `item` = 34067;

-- Archimonde Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 17968 AND `item` = 34068;