Open Xadras opened 8 years ago
Sources:
https://github.com/Schaka/TBC-research/issues/14
HG: https://www.youtube.com/watch?v=l2qh69TbNdQ
http://www.wowhead.com/zone=3791/sethekk-halls , http://wowwiki.wikia.com/wiki/Sethekk_Halls , http://wow.gamepedia.com/Sethekk_Halls
https://www.youtube.com/watch?v=Bw9vQZt8ty0 https://www.youtube.com/watch?v=a3QViwiJUlY https://www.youtube.com/watch?v=Iog4ERQRGcQ https://www.youtube.com/watch?v=fBFcfSVPHN0 https://www.youtube.com/watch?v=ntYHzbtiqwI https://www.youtube.com/watch?v=6Hkjlj2uOgY https://www.youtube.com/watch?v=W1LGW01ZPsY
-- https://github.com/Looking4Group/L4G_Core/issues/626
-- Sethekk Halls
-- Spawns need a complete ReGuid
-- =============
-- Npc Research
-- =============
-- Sethekk Guard 18323,20692
UPDATE `creature_template` SET `minhealth`='17972' WHERE `entry` = 18323;
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`mechanic_immune_mask`='617299835',`mindmg`='2698',`maxdmg`='3470' WHERE `entry` = 20692; -- 770 2314 Waffe passt
DELETE FROM `creature_ai_scripts` WHERE `id` = 1832302;
INSERT INTO `creature_ai_scripts` VALUES
('1832302','18323','4','0','15','6','0','0','0','0','1','-1240','-1241','-1242','0','0','0','0','0','0','0','0','Sethekk Guard - Random Say on Aggro');
-- Avian Darkhawk 19429,20686
UPDATE `creature_template` SET `armor`='5900',`speed`='1.48' WHERE `entry` = 19429;
UPDATE `creature_template` SET `armor`='6800',`speed`='1.48',`minlevel`='70',`lootid`='19429',`mindmg`='1960',`maxdmg`='2374' WHERE `entry` = 20686; -- 770 2314
UPDATE `creature_ai_scripts` SET `event_param3`='8000',`event_param4`='10000',`action1_param2`='4' WHERE `id` IN (1942901,1942902);
UPDATE `creature_ai_scripts` SET `event_param3`='5000' WHERE `id` IN (1942903,1942904);
-- Sethekk Initiate 18318,20693
UPDATE `creature_template` SET `armor`='5900',`speed`='1.48' WHERE `entry` = 18318; -- Roter gewellter Dolch wie im Tempel und Bronze Schild
UPDATE `creature_template` SET `armor`='6800',`speed`='1.48',`lootid`='18318',`mindmg`='2404',`maxdmg`='2777' WHERE `entry` = 20693; -- Roter gewellter Dolch wie im Tempel und Bronze Schild 922 1668
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18318;
INSERT INTO `creature_ai_scripts` VALUES
('1831801','18318','4','0','15','6','0','0','0','0','1','-1240','-1241','-1243','0','0','0','0','0','0','0','0','Sethekk Initiate - Random Say on Aggro'),
('1831802','18318','4','0','100','6','0','0','0','0','23','1','0','0','0','0','0','0','0','0','0','0','Sethekk Initiate - Set Phase 1 on Aggro'),
('1831803','18318','9','5','100','7','0','5','5000','5000','11','16145','1','0','0','0','0','0','0','0','0','0','Sethekk Initiate - Cast Sunder Armor (Phase 1)'),
-- ('1831804','18318','24','5','100','7','16145','5','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Sethekk Initiate - Set Phase 2 on Target Max Sunder Armor Aura Stack (Phase 1)'),
-- ('1831805','18318','28','3','100','7','16145','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Sethekk Initiate - Set Phase 1 on Target Missing Sunder Armor Aura Stack (Phase 2)'),
('1831806','18318','0','0','100','7','5000','7000','12000','15000','11','33961','0','1','0','0','0','0','0','0','0','0','Sethekk Initiate - Cast Spell Reflection'),
('1831807','18318','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Sethekk Initiate - Set Phase to 0 on Evade');
-- Time-Lost Controller 18327,20691
-- Immune to CC
UPDATE `creature_template` SET `armor`='5200',`mechanic_immune_mask`='13111315' WHERE `entry` = 18327; -- kleiner gebogener Holzstock wie die Furbolgs
UPDATE `creature_template` SET `armor`='5950',`minmana`='35980',`maxmana`='35980',`speed`='1.48',`lootid`='18327',`mindmg`='1181',`maxdmg`='1421',`mechanic_immune_mask`='13111315' WHERE `entry` = 20691; -- 411 890
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18327;
INSERT INTO `creature_ai_scripts` VALUES
('1832701','18327','4','0','15','6','0','0','0','0','1','-1240','-1241','-1244','0','0','0','0','0','0','0','0','Time-Lost Controller - Random Say on Aggro'),
('1832702','18327','9','0','100','7','0','5','17800','28300','12','20343','0','30000','0','0','0','0','0','0','0','0','Time-Lost Controller - Summon Charming Totem'), -- spell 32764 bugged
('1832703','18327','9','0','100','7','0','15','10000','15000','11','35013','4','32','0','0','0','0','0','0','0','0','Time-Lost Controller - Cast Shrink'),
('1832705','18327','1','0','100','7','1000','1000','900000','900000','11','32689','0','1','0','0','0','0','0','0','0','0','Time-Lost Controller - Cast Arcane Destruction OCC'),
('1832706','18327','0','0','100','7','10000','10000','5000','5000','11','32689','0','32','0','0','0','0','0','0','0','0','Time-Lost Scryer - Cast Arcane Destruction on Missing Arcane Destruction Aura');
-- Charming Totem 20343,20687
UPDATE `creature_template` SET `minlevel`='67',`maxlevel`='67',`minhealth`='2000',`maxhealth`='2000',`faction_A`='16',`faction_H`='16',`armor`='0',`speed`='0',`mindmg`='0',`maxdmg`='0',`unit_flags`='131072',`resistance5`='-1',`mechanic_immune_mask`='1073741823',`flags_extra`='196732' WHERE `entry` = 20343;
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`minhealth`='5000',`maxhealth`='5000',`faction_A`='16',`faction_H`='16',`speed`='0',`mindmg`='0',`maxdmg`='0',`unit_flags`='131072',`resistance5`='-1',`mechanic_immune_mask`='1073741823',`flags_extra`='196732' WHERE `entry` = 20687;
DELETE FROM `creature_template_addon` WHERE `entry` IN (20343,20687);
INSERT INTO `creature_template_addon` VALUES
(20343,0,0,0,0,0,0,0,''),
(20687,0,0,0,0,0,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 20343;
INSERT INTO `creature_ai_scripts` VALUES
('2034301','20343','0','0','100','7','2500','4500','15000','15000','11','37122','4','7','20','0','0','0','21','0','0','0','Charming Totem - Cast Charm and Stop Melee and Stop Movement on Aggro'),
('2034302','20343','1','0','100','7','15000','15000','1000','1000','41','0','0','0','0','0','0','0','0','0','0','0','Charming Totem - Despawn OOC');
-- Sethekk Oracle 18328,20694
UPDATE `creature_template` SET `armor`='5450',`faction_A`='16',`faction_H`='16' WHERE `entry` = 18328; -- holzvoodoostecker
UPDATE `creature_template` SET `armor`='6200',`faction_A`='16',`faction_H`='16',`speed`='1.48',`mindmg`='1376',`maxdmg`='1647' WHERE `entry` = 20694; -- 485 1026
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18328;
INSERT INTO `creature_ai_scripts` VALUES
('1832801','18328','4','0','15','6','0','0','0','0','1','-1240','-1242','-1243','0','0','0','0','0','0','0','0','Sethekk Oracle - Random Say on Aggro'),
('1832802','18328','9','0','100','3','0','20','6000','12000','11','32690','1','0','0','0','0','0','0','0','0','0','Sethekk Oracle (Normal) - Cast Arcane Lightning'),
('1832803','18328','9','0','100','5','0','20','6000','12000','11','38146','1','0','0','0','0','0','0','0','0','0','Sethekk Oracle (Heroic) - Cast Arcane Lightning'),
('1832804','18328','0','0','100','7','2400','8700','8400','19300','11','32129','1','32','0','0','0','0','0','0','0','0','Sethekk Oracle - Cast Faerie Fire');
-- Sethekk Ravenguard
UPDATE `creature_template` SET `armor`='6200',`faction_A`='16',`faction_H`='16',`mechanic_immune_mask`='617289563',`baseattacktime`='1200' WHERE `entry` = 18322;
UPDATE `creature_template` SET `armor`='7100',`faction_A`='16',`faction_H`='16',`mindmg`='4063',`maxdmg`='4547',`attackpower`='0',`speed`='1.48',`mechanic_immune_mask`='617289563' WHERE `entry` = 20696;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18322;
INSERT INTO `creature_ai_scripts` VALUES
('1832201','18322','4','0','15','38','0','0','0','0','1','-1240','-1243','-1244','0','0','0','0','0','0','0','0','Sethekk Ravenguard - Random Say on Aggro'),
('1832202','18322','9','0','100','3','0','5','4000','8000','11','33964','1','1','0','0','0','0','0','0','0','0','Sethekk Ravenguard (Normal) - Cast Bloodthirst'),
('1832203','18322','9','0','100','5','0','5','4000','8000','11','40423','1','1','0','0','0','0','0','0','0','0','Sethekk Ravenguard (Heroic) - Cast Bloodthirst'),
('1832204','18322','0','0','100','7','2000','8000','6000','18000','11','32651','0','1','0','0','0','0','0','0','0','0','Sethekk Ravenguard - Cast Howling Screech'),
('1832205','18322','2','0','100','6','15','0','120000','120000','11','34970','0','7','0','0','0','0','0','0','0','0','Sethekk Ravenguard - Cast Frenzy at 15% HP'),
('1832206','18322','14','0','100','3','17000','15','120000','120000','11','34970','0','7','0','0','0','0','0','0','0','0','Sethekk Ravenguard (Normal) - Cast Frenzy on friendly Death'),
('1832207','18322','14','0','100','5','39000','15','120000','120000','11','34970','0','7','0','0','0','0','0','0','0','0','Sethekk Ravenguard (Heroic) - Cast Frenzy on friendly Death'),
('1832208','18322','4','0','100','6','0','0','0','0','11','29651','0','0','0','0','0','0','0','0','0','0','Sethekk Ravenguard - Casts Dual Wield on Aggro');
-- Cobalt Serpent 19428,20688
UPDATE `creature_template` SET `armor`='6200',`speed`='1.48',`family`='27',`inhabittype`='3',`mechanic_immune_mask`='753866495' WHERE `entry` = 19428;
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`family`='27',`inhabittype`='3',`lootid`='19428',`skinloot`='70063',`mechanic_immune_mask`='753866495',`mindmg`='3732',`maxdmg`='3902' WHERE `entry` = 20688; -- 1739 2078
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 19428;
INSERT INTO `creature_ai_scripts` VALUES
('1942801','19428','9','0','75','3','0','40','3000','5000','11','17503','1','0','0','0','0','0','0','0','0','0','Cobalt Serpent (Normal) - Cast Frostbolt'),
('1942802','19428','9','0','75','5','0','40','3000','5000','11','38238','1','0','0','0','0','0','0','0','0','0','Cobalt Serpent (Heroic) - Cast Frostbolt'),
('1942803','19428','0','0','100','3','4000','8000','8000','12000','11','38193','1','0','0','0','0','0','0','0','0','0','Cobalt Serpent (Normal) - Cast Lightning Breath'),
('1942804','19428','0','0','100','5','4000','8000','8000','12000','11','38133','1','0','0','0','0','0','0','0','0','0','Cobalt Serpent (Heroic) - Cast Lightning Breath'),
('1942805','19428','0','0','100','7','6000','10000','10000','15000','11','38110','0','0','0','0','0','0','0','0','0','0','Cobalt Serpent - Cast Wing Buffet');
-- Time-Lost Scryer 18319,20697
UPDATE `creature_template` SET `armor`='5450',`faction_A`='16',`faction_H`='16' WHERE `entry` = 18319;
UPDATE `creature_template` SET `minmana`='73320',`maxmana`='73320',`armor`='6200',`faction_A`='16',`faction_H`='16',`speed`='1.48',`mindmg`='1720',`maxdmg`='1894' WHERE `entry` = 20697; -- 730 1078
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18319;
INSERT INTO `creature_ai_scripts` VALUES
('1831901','18319','1','0','100','7','1000','1000','90000','90000','11','32689','0','1','0','0','0','0','0','0','0','0','Time-Lost Scryer - Cast Arcane Destruction on Spawn'),
('1831902','18319','4','0','15','38','0','0','0','0','1','-1240','-1242','-1243','0','0','0','0','0','0','0','0','Time-Lost Scryer - Random Say on Aggro'),
('1831903','18319','0','0','100','3','1500','1500','1500','1500','11','22273','1','0','0','0','0','0','0','0','0','0','Time-Lost Scryer (Normal)- Cast Arcane Missiles'),
('1831904','18319','0','0','100','5','1500','1500','1500','1500','11','33989','1','0','0','0','0','0','0','0','0','0','Time-Lost Scryer (Heroic) - Cast Arcane Missiles'),
('1831905','18319','14','0','100','3','3300','40','7000','10000','11','17843','6','0','0','0','0','0','0','0','0','0','Time-Lost Scryer (Normal) - Cast Flash Heal on Friendies'),
('1831906','18319','14','0','100','5','4900','40','7000','10000','11','17138','6','0','0','0','0','0','0','0','0','0','Time-Lost Scryer (Heroic) - Cast Flash Heal on Friendies'),
('1831907','18319','14','0','100','3','2000','40','8000','10000','11','12160','6','1','0','0','0','0','0','0','0','0','Time-Lost Scryer (Normal) - Cast Rejuvenation on Friendies'),
('1831908','18319','14','0','100','5','3500','40','8000','10000','11','15981','6','1','0','0','0','0','0','0','0','0','Time-Lost Scryer (Heroic) - Cast Rejuvenation on Friendies'),
('1831909','18319','0','0','100','7','10000','10000','5000','5000','11','32689','0','33','0','0','0','0','0','0','0','0','Time-Lost Scryer - Cast Arcane Destruction on Missing Arcane Destruction Aura');
-- Avian Ripper 21891,21989
UPDATE `creature_template` SET `armor`='4900',`faction_A`='16',`faction_H`='16',`speed`='1.20' WHERE `entry` = 21891;
UPDATE `creature_template` SET `armor`='5800',`faction_A`='16',`faction_H`='16',`lootid`='21891',`mindmg`='1351',`maxdmg`='1572' WHERE `entry` = 21989; -- 510 951
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21891;
INSERT INTO `creature_ai_scripts` VALUES
('2189101','21891','9','0','100','7','0','5','5000','10000','11','38056','4','1','0','0','0','0','0','0','0','0','Avian Ripper - Cast Flesh Rip');
-- Sethekk Prophet 18325,20695
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16',`armor`='5700' WHERE `entry` = 18325;
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16',`minlevel`='71',`armor`='6450',`speed`='1.48',`spell1`='0',`mindmg`='1578',`maxdmg`='1808',`spell1`='0' WHERE `entry` = 20695; -- 616 1077 s1 27641
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18325;
INSERT INTO `creature_ai_scripts` VALUES
('1832501','18325','0','0','100','7','8700','12700','10000','15000','11','27641','4','0','0','0','0','0','0','0','0','0','Sethekk Prophet - Cast Fear'),
('1832502','18325','6','0','100','6','0','0','0','0','11','32692','0','7','0','0','0','0','0','0','0','0','Sethekk Prophet - Summon Arakkoa Spirit on Death');
-- Sethekk Spirit 18703,20700
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16',`speed`='1',`mechanic_immune_mask`='653230079',`unit_flags`='33554688',`flags_extra`='1048576',`speed`='1' WHERE `entry` = 18703;
UPDATE `creature_template` SET `faction_A`='16',`faction_H`='16',`speed`='1',`mechanic_immune_mask`='653230079',`unit_flags`='33554688',`flags_extra`='1048576',`mindmg`='3825',`maxdmg`='4758',`speed`='1' WHERE `entry` = 20700; -- 2000 3000 -- 5,737 - 7,137
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18703;
INSERT INTO `creature_ai_scripts` VALUES
('1870301','18703','11','0','100','6','0','0','0','0','11','24051','0','7','0','0','0','0','0','0','0','0','Sethekk Spirit - Cast Spirit Burst on Spawn');
-- Sethekk Talon Lord 18321,20701
UPDATE `creature_template` SET `armor`='6500',`faction_A`='16',`faction_H`='16' WHERE `entry` = 18321; -- gelbe eisen Lanze
UPDATE `creature_template` SET `armor`='7400',`faction_A`='16',`faction_H`='16',`speed`='1.48',`mechanic_immune_mask`='0',`mindmg`='2595',`maxdmg`='2873',`spell1`='0',`spell2`='0' WHERE `entry` = 20701; -- gelbe eisen Lanze 1089 1645 s1 32674 s2 32654
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18321;
INSERT INTO `creature_ai_scripts` VALUES
('1832101','18321','4','0','15','38','0','0','0','0','1','-1240','-1241','-1244','0','0','0','0','0','0','0','0','Sethekk Talon Lord - Random Say on Aggro'),
('1832102','18321','9','0','100','7','0','30','10000','20000','11','32674','4','0','0','0','0','0','0','0','0','0','Sethekk Talon Lord - Cast Avengers Shield'),
('1832103','18321','9','0','100','7','0','10','8000','12000','11','32654','4','0','0','0','0','0','0','0','0','0','Sethekk Talon Lord - Cast Talon of Justice');
-- Time-Lost Shadowmage 18320,20698
UPDATE `creature_template` SET `armor`='5700' WHERE `entry` = 18320;
UPDATE `creature_template` SET `armor`='6450',`speed`='1.48',`mindmg`='949',`maxdmg`='1141',`spell1`='0',`spell2`='0' WHERE `entry` = 20698; -- 330 715 s1 32682 s2 38148
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18320;
INSERT INTO `creature_ai_scripts` VALUES
('1832001','18320','4','0','100','6','0','0','0','0','23','1','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage - Set Phase 1 on Aggro'),
('1832002','18320','0','5','100','3','4000','7000','10000','20000','11','32682','1','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Normal) - Cast Curse of the Dark Talon (Phase 1)'),
('1832003','18320','0','5','100','5','4000','7000','10000','20000','11','38149','1','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Heroic) - Cast Curse of the Dark Talon (Phase 1)'),
-- ('1832004','18320','24','5','100','3','32682','5','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Normal) - Set Phase 2 on Target Max Curse of the Dark Talon Aura Stack (Phase 1)'),
-- ('1832005','18320','24','5','100','5','38149','5','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Heroic) - Set Phase 2 on Target Max Curse of the Dark Talon Aura Stack (Phase 1)'),
-- ('1832006','18320','28','3','100','3','32682','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Normal) - Set Phase 1 on Target Missing Curse of the Dark Talon Aura Stack (Phase 2)'),
-- ('1832007','18320','28','3','100','5','38149','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Heroic) - Set Phase 1 on Target Missing Curse of the Dark Talon Aura Stack (Phase 2)'),
('1832008','18320','9','0','100','7','0','20','9300','21800','11','32677','1','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Normal) - Cast Shadow Missiles'),
('1832009','18320','9','0','100','7','0','20','9300','21800','11','38147','1','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage (Normal) - Cast Shadow Missiles'),
('1832010','18320','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Time-Lost Shadowmage - Set Phase to 0 on Evade'),
('1832011','18320','1','0','100','7','1000','1000','900000','900000','11','32689','0','1','0','0','0','0','0','0','0','0','Time-Lost Shadowmage - Cast Arcane Destruction OCC'),
('1832012','18320','16','0','100','7','32689','1','5000','5000','11','32689','0','1','0','0','0','0','0','0','0','0','Time-Lost Shadowmage - Cast Arcane Destruction on Missing Arcane Destruction Aura');
-- Sethekk Shaman 18326,20699
UPDATE `creature_template` SET `armor`='5700',`faction_A`='16',`faction_H`='16' WHERE `entry` = 18326;
UPDATE `creature_template` SET `armor`='6450',`faction_A`='16',`faction_H`='16',`speed`='1.48',`spell1`='0',`spell2`='0',`mindmg`='1427',`maxdmg`='1763' WHERE `entry` = 20699; -- 462 1133 s1 22885 s2 32663
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18326;
INSERT INTO `creature_ai_scripts` VALUES
('1832601','18326','4','0','15','6','0','0','0','0','1','-1240','-1242','-1243','0','0','0','0','0','0','0','0','Sethekk Shaman - Random Say on Aggro'),
('1832602','18326','4','0','100','6','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Sethekk Shaman - Set Phase 1 on Aggro'),
('1832603','18326','0','5','100','7','1000','5000','30000','30000','11','32663','1','1','39','10','0','0','0','0','0','0','Sethekk Shaman - Summon Dark Vortex (Phase 1)'),
-- ('1832604','18326','17','5','100','7','18701','5000','5000','0','23','1','0','0','0','0','0','0','0','0','0','0','Sethekk Shaman - Set Phase 2 on Dark Vortex Spawn (Phase 1)'),
-- ('1832605','18326','25','3','100','7','18701','5000','5000','0','23','-1','0','0','0','0','0','0','0','0','0','0','Sethekk Shaman - Set Phase 1 on Dark Vortex Death (Phase 2)'),
('1832606','18326','13','0','100','3','4300','9100','0','0','11','15501','6','1','0','0','0','0','0','0','0','0','Sethekk Shaman (Normal) - Cast Earth Shock'),
('1832607','18326','13','0','100','5','4300','9100','0','0','11','22885','6','1','0','0','0','0','0','0','0','0','Sethekk Shaman (Heroic) - Cast Earth Shock'),
('1832608','18326','6','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Sethekk Shaman - Set Phase 0 on Death');
-- Dark Vortex 18701,20689
UPDATE `creature_template` SET `maxlevel`='69',`armor`='5900',`faction_A`='16',`faction_H`='16',`speed`='1.20' WHERE `entry` = 18701;
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`armor`='7400',`faction_A`='16',`faction_H`='16',`mindmg`='903',`maxdmg`='1136' WHERE `entry` = 20689; -- 276 743 s1 12471
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18701;
INSERT INTO `creature_ai_scripts` VALUES
('1870101','18701','0','0','100','7','1000','2000','3000','4000','11','12471','1','0','0','0','0','0','0','0','0','0','Dark Vortex - Cast Shadow Bolt'),
('1870102','18701','7','0','100','6','0','0','0','0','41','0','0','0','0','0','0','0','0','0','0','0','Dark Vortex - Despawn on Evade');
-- Avian Warhawk 21904,21990
UPDATE `creature_template` SET `armor`='6200',`faction_H`='16',`faction_A`='16',`speed`='1.71' WHERE `entry` = 21904;
UPDATE `creature_template` SET `armor`='7100',`faction_H`='16',`faction_A`='16',`speed`='1.71',`spell1`='0',`spell2`='0',`spell3`='0',`mindmg`='1921',`maxdmg`='2232' WHERE `entry` = 21990; -- 727 1349 s1 32901 s2 38059 s3 18144
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21904;
INSERT INTO `creature_ai_scripts` VALUES
('2190401','21904','9','0','100','3','8','25','6000','8000','11','38059','4','1','0','0','0','0','0','0','0','0','Avian Warhawk (Normal) - Cast Sonic Charge'),
('2190402','21904','9','0','100','5','8','25','6000','8000','11','39197','4','1','0','0','0','0','0','0','0','0','Avian Warhawk (Heroic) - Cast Sonic Charge'),
('2190403','21904','0','0','100','3','3000','4000','4000','8000','11','32901','1','0','0','0','0','0','0','0','0','0','Avian Warhawk (Normal) - Cast Carnivorous Bite'),
('2190404','21904','0','0','100','5','3000','4000','4000','8000','11','39198','1','0','0','0','0','0','0','0','0','0','Avian Warhawk (Heroic) - Cast Carnivorous Bite'),
('2190405','21904','0','0','100','7','6000','8000','8000','10000','11','18144','0','1','0','0','0','0','0','0','0','0','Avian Warhawk - Cast Swoop');
-- ===================
-- Bosses
-- ===================
-- Darkweaver Syth 18472,20690
UPDATE `creature_template` SET `armor`='5700',`mechanic_immune_mask`='787431423' WHERE `entry` = 18472; -- 479 970
UPDATE `creature_template` SET `armor`='6450',`speed`='1.48',`mechanic_immune_mask`='787431423',`mindmg`='2535',`maxdmg`='2795',`dmgschool`='5' WHERE `entry` = 20690; -- 804 1195
DELETE FROM `creature_template_addon` WHERE `entry` IN (18472,20690);
INSERT INTO `creature_template_addon` VALUES
(18472, 0, 0, 0, 0, 0, 0, 0, '18950 0 18950 1'),
(20690, 0, 0, 0, 0, 0, 0, 0, '18950 0 18950 1');
-- Syth Fire Elemental
UPDATE `creature_template` SET `speed`='1.20',`resistance2`='-1' WHERE `entry` = 19203;
UPDATE `creature_template` SET `dmgschool` = 2, `resistance2`='-1' WHERE `entry` = 20703;
-- Syth Frost Elemental
UPDATE `creature_template` SET `speed`='1.20',`resistance4`='-1' WHERE `entry` = 19204;
UPDATE `creature_template` SET `resistance4`='-1' WHERE `entry` = 20704;
-- Syth Arcane Elemental
UPDATE `creature_template` SET `speed`='1.20',`resistance6`='-1' WHERE `entry` = 19205;
UPDATE `creature_template` SET `minhealth`='5903',`maxhealth`='5903',`resistance6`='-1' WHERE `entry` = 20702;
-- Syth Shadow Elemental
UPDATE `creature_template` SET `speed`='1.20',`resistance5`='-1' WHERE `entry` = 19206;
UPDATE `creature_template` SET `resistance5`='-1' WHERE `entry` = 20705;
DELETE FROM `creature_template_addon` WHERE `entry` IN (19203,19204,19205,19206);
-- Anzu 23035
UPDATE `creature_template` SET `armor`='7400',`mechanic_immune_mask`='787431423',`mindmg`='7134',`maxdmg`='8469' WHERE `entry` = 23035;
-- Talon King Ikiss 18473,20706
UPDATE `creature_template` SET `minlevel`='69',`maxlevel`='69',`minmana`='37500',`maxmana`='37500',`armor`='5700',`faction_A`='16',`faction_H`='16',`speed`='1.48',`equipment_id`='1445',`mechanic_immune_mask`='787431423' WHERE `entry` = 18473;
UPDATE `creature_template` SET `minmana`='42186',`maxmana`='42186',`armor`='6450',`faction_A`='16',`faction_H`='16',`speed`='1.48',`equipment_id`='1445',`mechanic_immune_mask`='787431423',`mindmg`='4825',`maxdmg`='5802' WHERE `entry` = 20706;
-- Brood of Anzu
-- UPDATE `creature_template` SET ` WHERE `entry` IN ('23132');
-- Hawk Spirit
-- UPDATE `creature_template` SET ` WHERE `entry` IN ('23134');
-- Falcon Spirit
-- UPDATE `creature_template` SET ` WHERE `entry` IN ('23135');
-- Eagle Spirit
-- UPDATE `creature_template` SET ` WHERE `entry` IN ('23136');
-- Avian Flye 21931,21988
UPDATE `creature` SET `map` = 556 WHERE `id` IN (21931);
UPDATE creature_template SET `modelid_A2` = 4566, `modelid_H2` = 4566, `scale` = 0.75, `InhabitType` = 4, `unit_flags` = `unit_flags`|33554432 WHERE entry IN (21931,21988);
DELETE FROM creature_ai_scripts WHERE entryOrGUID = 21931;
INSERT INTO creature_ai_scripts VALUES
('2193101','21931','11','0','100','0','0','0','0','0','31','1','4','0','0','0','0','0','0','0','0','0','Avian Flye - Random Phase on Spawn'),
('2193102','21931','1','13','100','0','0','0','0','0','3','0','4566','0','0','0','0','0','0','0','0','0','Avian Flye - Random Model (Phase 1)'),
('2193103','21931','1','11','100','0','0','0','0','0','3','0','20588','0','0','0','0','0','0','0','0','0','Avian Flye - Random Model (Phase 2)'),
('2193104','21931','1','7','100','0','0','0','0','0','3','0','20730','0','0','0','0','0','0','0','0','0','Avian Flye - Random Model (Phase 3)');
UPDATE `creature_model_info` SET `modelid_other_gender` = 20588, `gender` = 1 WHERE `modelid` = 18933;
UPDATE `creature_model_info` SET `modelid_other_gender` = 20730, `gender` = 1 WHERE `modelid` = 4566;
UPDATE `creature_model_info` SET `bounding_radius` = 2 WHERE `modelid` = 20588;
DELETE FROM `creature` WHERE `guid` BETWEEN 84904 AND 84936;
SET @GUID := 84904;
INSERT INTO creature (guid, id, map, spawnMask, position_x, position_y, position_z, orientation, spawntimesecs, curhealth, curmana, spawndist, MovementType) VALUES
(@GUID := @GUID + 0, 21931, 556, 3, -69.078, 255.062, 27.6692, 2.23169, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, 84.91618,251.3969,37.0668, 3.204143, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, 82.7928, 251.0653, 37.0668, 3.192098, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -55.35431, 292.4135, 27.84376, 3.334406, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -56.81138, 293.4768, 27.82975, 1.066901, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -109.229, 288.209, 53.3584, 3.249347, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -77.7733, 299.15, 60.5558, 5.757163, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -52.39689, 293.2879, 27.82958, 1.420948, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -65.26201, 281.413, 47.28283, 0.8305511, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -59.42, 289.0999, 27.89292, 2.894336, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -102.279, 278.86, 56.0703, 5.414571, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -86.60637, 286.1224, 27.48317, 2.953945, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -68.3353, 281.741, 61.757, 3.844181, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -71.9701, 272.574, 59.1446, 6.184331, 7200, 6326, 0, 0, 2),
(@GUID := @GUID + 1, 21931, 556, 3, -84.35631, 263.7281, 27.80793, 4.523829, 7200, 6326, 0, 0, 2);
DELETE FROM `creature_addon` WHERE `guid` BETWEEN 84904 AND 84918;
INSERT INTO `creature_addon` VALUES
(84904,84904,0,0,0,4097,0,0,''),
(84905,84905,0,0,0,4097,0,0,''),
(84906,84906,0,0,0,4097,0,0,''),
(84907,84907,0,0,0,4097,0,0,''),
(84908,84908,0,0,0,4097,0,0,''),
(84909,84909,0,0,0,4097,0,0,''),
(84910,84910,0,0,0,4097,0,0,''),
(84911,84911,0,0,0,4097,0,0,''),
(84912,84912,0,0,0,4097,0,0,''),
(84913,84913,0,0,0,4097,0,0,''),
(84914,84914,0,0,0,4097,0,0,''),
(84915,84915,0,0,0,4097,0,0,''),
(84916,84916,0,0,0,4097,0,0,''),
(84917,84917,0,0,0,4097,0,0,''),
(84918,84918,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` BETWEEN 84904 AND 84918;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- #1
(84904,1,-69.078,255.062,27.6692,1000,1,0,0,0),
(84904,2,-69.078,255.062,27.6692,0,1,0,0,0),
(84904,3,-77.6467,256.825,27.8182,0,1,0,0,0),
(84904,4,-85.5541,263.248,37.4314,0,1,0,0,0),
(84904,5,-89.3701,273.449,46.1637,0,1,0,0,0),
(84904,6,-87.3918,283.626,55.5433,0,1,0,0,0),
(84904,7,-81.6323,288.392,67.374,0,1,0,0,0),
(84904,8,-83.6451,281.803,77.323,0,1,0,0,0),
(84904,9,-97.3242,280.983,74.488,0,1,0,0,0),
(84904,10,-95.2966,294.303,27.4832,0,1,0,0,0),
(84904,11,-91.9066,298.554,40.3148,0,1,0,0,0),
(84904,12,-84.9968,296.969,52.3776,0,1,0,0,0),
(84904,13,-81.5458,289.807,63.8514,0,1,0,0,0),
(84904,14,-91.5585,284.275,71.9894,0,1,0,0,0),
(84904,15,-95.834,292.943,27.4832,0,1,0,0,0),
(84904,16,-94.3393,295.352,41.1404,0,1,0,0,0),
(84904,17,-88.5665,292.19,53.5047,0,1,0,0,0),
(84904,18,-88.0789,284.173,65.0211,0,1,0,0,0),
(84904,19,-96.7033,282.247,75.63,0,1,0,0,0),
(84904,20,-92.1857,296.241,27.4832,0,1,0,0,0),
-- #2
(84905,1,-84.35631,263.7281,27.80793,1000,1,0,0,0),
(84905,2,-87.4666,261.464,58.4138,0,1,0,0,0),
(84905,3,-94.4575,270.352,66.6585,0,1,0,0,0),
(84905,4,-95.7386,284.443,27.4832,0,1,0,0,0),
(84905,5,-91.3219,290.488,39.2894,0,1,0,0,0),
(84905,6,-84.573,290.53,51.5467,0,1,0,0,0),
(84905,7,-83.1581,284.409,64.0506,0,1,0,0,0),
(84905,8,-92.9101,280.978,73.484,0,1,0,0,0),
(84905,9,-96.079,293.202,74.566,0,1,0,0,0),
(84905,10,-82.8515,297.569,74.9201,0,1,0,0,0),
(84905,11,-77.4638,284.989,27.4832,0,1,0,0,0),
(84905,12,-81.0183,279.803,39.9446,0,1,0,0,0),
(84905,13,-89.1536,280.506,51.3678,0,1,0,0,0),
(84905,14,-94.1382,293.611,27.4832,0,1,0,0,0),
(84905,15,-88.9669,297.982,39.6762,0,1,0,0,0),
(84905,16,-84.4414,293.357,52.098,0,1,0,0,0),
(84905,17,-86.5034,284.787,63.0289,0,1,0,0,0),
(84905,18,-97.8593,278.945,26.2094,0,1,0,0,0),
(84905,19,-83.9472,285.452,63.0513,0,1,0,0,0),
(84905,20,-93.4871,275.608,26.8408,0,1,0,0,0),
-- #3
(84906,1,84.91618,251.3969,37.0668,1000,1,0,0,0),
(84906,2,83.96513,251.0878,37.0668,0,1,0,0,0),
(84906,3,51.4796,252.1832,37.0668,0,1,0,0,0),
(84906,4,33.24739,282.4318,37.0668,0,1,0,0,0),
(84906,5,-4.585953,288.248,37.0668,0,1,0,0,0),
(84906,6,-33.12523,287.3879,33.65012,0,1,0,0,0),
(84906,7,-63.6614,287.1449,37.0668,0,1,0,0,0),
(84906,8,-86.58053,281.3122,37.0668,0,1,0,0,0),
(84906,9,-122.8668,287.5829,33.70568,0,1,0,0,0),
(84906,10,-166.1352,286.0018,37.0668,0,1,0,0,0),
(84906,11,-197.1293,319.5987,41.56683,0,1,0,0,0),
(84906,12,-226.7219,321.6883,41.53905,0,1,0,0,0),
(84906,13,-241.978,284.0257,37.0668,0,1,0,0,0),
(84906,14,-241.867,239.6969,34.78908,0,1,0,0,0),
(84906,15,-240.4087,205.2585,33.28898,0,1,0,0,0),
(84906,16,-247.9211,181.8263,37.0668,0,1,0,0,0),
(84906,17,-258.5413,176.8185,28.87236,0,1,0,0,0),
(84906,18,-254.5885,187.9291,17.59458,0,1,0,0,0),
(84906,19,-233.2822,183.525,9.455688,0,1,0,0,0),
(84906,20,-207.9685,174.1038,9.455688,0,1,0,0,0),
(84906,21,-174.2731,173.5923,7.177915,0,1,0,0,0),
(84906,22,-153.4284,164.0868,10.48346,0,1,0,0,0),
(84906,23,-141.7187,162.8539,10.98347,0,1,0,0,0),
(84906,24,-125.9314,171.5796,9.150148,0,1,0,0,0),
(84906,25,-97.73457,173.6499,7.150136,0,1,0,0,0),
(84906,26,-82.8989,173.9212,10.3168,0,1,0,0,0),
(84906,27,-73.91816,173.0771,10.3168,0,1,0,0,0),
(84906,28,-69.98465,163.4588,10.3168,0,1,0,0,0),
(84906,29,-70.28123,156.7726,9.34458,0,1,0,0,0),
(84906,30,-71.15484,128.5923,6.705695,0,1,0,0,0),
(84906,31,-80.03834,115.5755,7.511248,0,1,0,0,0),
(84906,32,-82.54434,99.08558,7.511248,0,1,0,0,0),
(84906,33,-74.70563,88.52892,7.511248,0,1,0,0,0),
(84906,34,-60.10373,87.1475,7.511248,0,1,0,0,0),
(84906,35,-43.85668,99.20913,7.039028,0,1,0,0,0),
(84906,36,-21.47738,99.80711,7.261249,0,1,0,0,0),
(84906,37,7.509675,100.2483,7.511248,0,1,0,0,0),
(84906,38,27.40248,97.8097,19.31681,0,1,0,0,0),
(84906,39,37.0373,95.82257,30.84459,3000,1,2193102,0,0),
-- #4
(84907,1,-119.16,291.958,26.7305,1000,1,0,0,0),
(84907,2,-119.16,291.958,26.7305,0,1,0,0,0),
(84907,3,-118.246,291.551,26.7198,0,1,0,0,0),
(84907,4,-116.125,290.169,41.5238,0,1,0,0,0),
(84907,5,-114.528,275.12,40.1532,0,1,0,0,0),
(84907,6,-90.689,265.24,41.0333,0,1,0,0,0),
(84907,7,-62.0894,286.098,48.6939,0,1,0,0,0),
(84907,8,-76.8407,304.686,51.9439,0,1,0,0,0),
(84907,9,-98.7576,303.572,46.4161,0,1,0,0,0),
-- #5
(84908,1,-56.81138,293.4768,27.82975,1000,1,0,0,0),
(84908,2,-58.7468,295.764,29.4033,0,1,0,0,0),
(84908,3,-80.8255,317.109,28.9557,0,1,0,0,0),
(84908,4,-84.6018,313.357,62.0829,0,1,0,0,0),
(84908,5,-100.485,310.06,60.6726,0,1,0,0,0),
(84908,6,-119.643,290.201,57.4676,0,1,0,0,0),
(84908,7,-119.602,271.028,61.3137,0,1,0,0,0),
(84908,8,-99.3827,260.039,59.8997,0,1,0,0,0),
(84908,9,-62.9444,265.206,63.3061,0,1,0,0,0),
(84908,10,-53.9817,286.896,63.0482,0,1,0,0,0),
(84908,11,-66.9341,300.934,58.5854,0,1,0,0,0),
(84908,12,-82.0958,309.241,61.3414,0,1,0,0,0),
(84908,13,-100.199,310.19,60.9001,0,1,0,0,0),
(84908,14,-109.249,296.2,58.5368,0,1,0,0,0),
(84908,15,-112.956,287.824,28.945,0,1,0,0,0),
(84908,16,-131.244,263.41,30.9794,0,1,0,0,0),
(84908,17,-124.562,262.687,57.9071,0,1,0,0,0),
(84908,18,-89.1208,261.935,60.3001,0,1,0,0,0),
(84908,19,-66.6449,264.328,64.3038,0,1,0,0,0),
(84908,20,-56.4546,270.201,65.3866,0,1,0,0,0),
(84908,21,-53.7442,287.453,64.0839,0,1,0,0,0),
(84908,22,-56.4072,293.549,29.5758,0,1,0,0,0),
-- #6
(84909,1,-59.42,289.0999,27.89292,1000,1,0,0,0),
(84909,2,-58.7468,295.764,29.4033,0,1,0,0,0),
(84909,3,-80.8255,317.109,28.9557,0,1,0,0,0),
(84909,4,-84.6018,313.357,62.0829,0,1,0,0,0),
(84909,5,-100.485,310.06,60.6726,0,1,0,0,0),
(84909,6,-119.643,290.201,57.4676,0,1,0,0,0),
(84909,7,-119.602,271.028,61.3137,0,1,0,0,0),
(84909,8,-99.3827,260.039,59.8997,0,1,0,0,0),
(84909,9,-62.9444,265.206,63.3061,0,1,0,0,0),
(84909,10,-53.9817,286.896,63.0482,0,1,0,0,0),
(84909,11,-66.9341,300.934,58.5854,0,1,0,0,0),
(84909,12,-82.0958,309.241,61.3414,0,1,0,0,0),
(84909,13,-100.199,310.19,60.9001,0,1,0,0,0),
(84909,14,-109.249,296.2,58.5368,0,1,0,0,0),
(84909,15,-112.956,287.824,28.945,0,1,0,0,0),
(84909,16,-131.244,263.41,30.9794,0,1,0,0,0),
(84909,17,-124.562,262.687,57.9071,0,1,0,0,0),
(84909,18,-89.1208,261.935,60.3001,0,1,0,0,0),
(84909,19,-66.6449,264.328,64.3038,0,1,0,0,0),
(84909,20,-56.4546,270.201,65.3866,0,1,0,0,0),
(84909,21,-53.7442,287.453,64.0839,0,1,0,0,0),
(84909,22,-56.4072,293.549,29.5758,0,1,0,0,0),
-- #7
(84910,1,-52.39689,293.2879,27.82958,1000,1,0,0,0),
(84910,2,-58.7468,295.764,29.4033,0,1,0,0,0),
(84910,3,-80.8255,317.109,28.9557,0,1,0,0,0),
(84910,4,-84.6018,313.357,62.0829,0,1,0,0,0),
(84910,5,-100.485,310.06,60.6726,0,1,0,0,0),
(84910,6,-119.643,290.201,57.4676,0,1,0,0,0),
(84910,7,-119.602,271.028,61.3137,0,1,0,0,0),
(84910,8,-99.3827,260.039,59.8997,0,1,0,0,0),
(84910,9,-62.9444,265.206,63.3061,0,1,0,0,0),
(84910,10,-53.9817,286.896,63.0482,0,1,0,0,0),
(84910,11,-66.9341,300.934,58.5854,0,1,0,0,0),
(84910,12,-82.0958,309.241,61.3414,0,1,0,0,0),
(84910,13,-100.199,310.19,60.9001,0,1,0,0,0),
(84910,14,-109.249,296.2,58.5368,0,1,0,0,0),
(84910,15,-112.956,287.824,28.945,0,1,0,0,0),
(84910,16,-131.244,263.41,30.9794,0,1,0,0,0),
(84910,17,-124.562,262.687,57.9071,0,1,0,0,0),
(84910,18,-89.1208,261.935,60.3001,0,1,0,0,0),
(84910,19,-66.6449,264.328,64.3038,0,1,0,0,0),
(84910,20,-56.4546,270.201,65.3866,0,1,0,0,0),
(84910,21,-53.7442,287.453,64.0839,0,1,0,0,0),
(84910,22,-56.4072,293.549,29.5758,0,1,0,0,0),
-- #8
(84911,1,-62.0894,286.098,48.6939,1000,1,0,0,0),
(84911,2,-76.8407,304.686,51.9439,0,1,0,0,0),
(84911,3,-98.7576,303.572,46.4161,0,1,0,0,0),
(84911,4,-119.16,291.958,26.7305,0,1,0,0,0),
(84911,5,-119.16,291.958,26.7305,0,1,0,0,0),
(84911,6,-118.246,291.551,26.7198,0,1,0,0,0),
(84911,7,-116.125,290.169,41.5238,0,1,0,0,0),
(84911,8,-114.528,275.12,40.1532,0,1,0,0,0),
(84911,9,-90.689,265.24,41.0333,0,1,0,0,0),
-- #9
(84912,1,-109.229,288.209,53.3584,1000,1,0,0,0),
(84912,2,-102.279,278.86,56.0703,0,1,0,0,0),
(84912,3,-88.1313,272.423,59.4688,0,1,0,0,0),
(84912,4,-71.9701,272.574,59.1446,0,1,0,0,0),
(84912,5,-68.3353,281.741,61.757,0,1,0,0,0),
(84912,6,-77.7733,299.15,60.5558,0,1,0,0,0),
(84912,7,-94.7425,300.49,56.1018,0,1,0,0,0),
-- #10
(84913,1,-71.9701,272.574,59.1446,1000,1,0,0,0),
(84913,2,-68.3353,281.741,61.757,0,1,0,0,0),
(84913,3,-77.7733,299.15,60.5558,0,1,0,0,0),
(84913,4,-94.7425,300.49,56.1018,0,1,0,0,0),
(84913,5,-109.229,288.209,53.3584,0,1,0,0,0),
(84913,6,-102.279,278.86,56.0703,0,1,0,0,0),
(84913,7,-88.1313,272.423,59.4688,0,1,0,0,0),
-- #11
(84914,1,-68.3353,281.741,61.757,1000,1,0,0,0),
(84914,2,-77.7733,299.15,60.5558,0,1,0,0,0),
(84914,3,-94.7425,300.49,56.1018,0,1,0,0,0),
(84914,4,-109.229,288.209,53.3584,0,1,0,0,0),
(84914,5,-102.279,278.86,56.0703,0,1,0,0,0),
(84914,6,-88.1313,272.423,59.4688,0,1,0,0,0),
(84914,7,-71.9701,272.574,59.1446,0,1,0,0,0),
-- #12
(84915,1,-102.279,278.86,56.0703,1000,1,0,0,0),
(84915,2,-88.1313,272.423,59.4688,0,1,0,0,0),
(84915,3,-71.9701,272.574,59.1446,0,1,0,0,0),
(84915,4,-68.3353,281.741,61.757,0,1,0,0,0),
(84915,5,-77.7733,299.15,60.5558,0,1,0,0,0),
(84915,6,-94.7425,300.49,56.1018,0,1,0,0,0),
(84915,7,-109.229,288.209,53.3584,0,1,0,0,0),
-- #13
(84916,1,-77.7733,299.15,60.5558,1000,1,0,0,0),
(84916,2,-94.7425,300.49,56.1018,0,1,0,0,0),
(84916,3,-109.229,288.209,53.3584,0,1,0,0,0),
(84916,4,-102.279,278.86,56.0703,0,1,0,0,0),
(84916,5,-88.1313,272.423,59.4688,0,1,0,0,0),
(84916,6,-71.9701,272.574,59.1446,0,1,0,0,0),
(84916,7,-68.3353,281.741,61.757,0,1,0,0,0),
-- #14
(84917,1,-86.60637,286.1224,27.48317,1000,1,0,0,0),
(84917,2,-84.2669,286.076,57.4227,0,1,0,0,0),
(84917,3,-71.9701,272.574,59.1446,0,1,0,0,0),
(84917,4,-68.3353,281.741,61.757,0,1,0,0,0),
(84917,5,-77.7733,299.15,60.5558,0,1,0,0,0),
(84917,6,-94.7425,300.49,56.1018,0,1,0,0,0),
(84917,7,-109.229,288.209,53.3584,0,1,0,0,0),
(84917,8,-102.279,278.86,56.0703,0,1,0,0,0),
(84917,9,-88.1313,272.423,59.4688,0,1,0,0,0),
-- #15
(84918,1,84.91618,251.3969,37.0668,1000,1,0,0,0),
(84918,2,83.96513,251.0878,37.0668,0,1,0,0,0),
(84918,3,51.4796,252.1832,37.0668,0,1,0,0,0),
(84918,4,33.24739,282.4318,37.0668,0,1,0,0,0),
(84918,5,-4.585953,288.248,37.0668,0,1,0,0,0),
(84918,6,-33.12523,287.3879,33.65012,0,1,0,0,0),
(84918,7,-63.6614,287.1449,37.0668,0,1,0,0,0),
(84918,8,-77.5616,286.325,98.1903,3000,1,2193102,0,0);
--
--
--
--
-- Lost GUIDS
UPDATE `creature` SET `map`='556' WHERE `id` IN (18318,18327,19429);
UPDATE `creature` SET `id`='18318' WHERE `guid` IN (16777340,16777359);
UPDATE `creature` SET `id`='18321' WHERE `guid` = 16777345;
UPDATE `creature` SET `spawnmask`='3',`spawntimesecs`='7200' WHERE `id` = 19429;
UPDATE `creature` SET `id`='18325' WHERE `guid` = 16777395;
--
-- free guids
DELETE FROM `creature` WHERE `guid` IN (84657,84658,84659,84660,84661,84662,84663,84664,84665,84666,84667,84668,84766,84767,84768,84769,84770,84771,84772);
INSERT INTO `creature` VALUES
(84657,4075,556,3,0,0,-84.8641,113.7530,0.0072,0.4395,300,5,0,0,0,0,1);
-- (84659,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84660,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84661,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84662,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84663,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84664,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84665,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84666,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84667,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84668,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84766,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84767,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84768,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84769,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84770,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84771,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0),
-- (84772,ID,556,3,0,0,XXX,YYY,ZZZ,OOO,7200,0,0,0,0,0,0);
--
-- Respawn Linking
DELETE FROM `creature_linked_respawn` WHERE `guid` IN (16777500,16777501,16777504,16777503,16800023,16800019,16800030,16800017,16800018,16800024,16800028,16800027,16800029,16800014,16800013,16800025,16800026,16800031,16800011,16800012,16800022,16800021,16800020,16800015,16800016,16777502,16800010,16777340,16777347,16777349,16777351,16777353,16777355,16777357,16777359,16777361,16777344,16777342,16777369,16777371,16777373,16777375,16777377,16777367,16777365,16777363,16777505,16777506,16777513,16777315,16777514,16777316,16777507,16777508,16777509,16777510,16777511,16777319,16777318,16777317,16777320,16777322,16777323,16777324,16777325,16777326,16777327,16777328,16777329,16777330,16777331,16777332,16777333,16777334,16777335,16777336,16777337,16777339,16777341,16777343,16777345,16777356,16777358,16777360,16777362,16777364,16777346,16777348,16777350,16777352,16777354,16777370,16777368,16777366,16777372,16777374,16777376,16777380,16777379,16777381,16777382,16777383,16777384,16777385,16777386,16777387,16777388,16777389,16777390,16777391,16777392,16777393,16777394,16777395,16777396,16777397,16777398,16777403,16777402,16777401,16777400,16777399,16777512);
INSERT INTO `creature_linked_respawn` VALUES
(16777500,83270),(16777501,83270),
(16777504,83270),(16777503,83270),
(16800023,83270),(16800019,83270),
(16800030,83270),(16800017,83270),
(16800018,83270),(16800024,83270),
(16800028,83270),(16800027,83270),
(16800029,83270),(16800014,83300),
(16800013,83300),(16800025,83270),
(16800026,83270),(16800031,83270),
(16800011,83270),(16800012,83270),
(16800022,83270),(16800021,83270),
(16800020,83270),(16800015,83270),
(16800016,83270),(16777502,83270),
(16800010,83270),(16777340,83270),
(16777347,83270),(16777349,83270),
(16777351,83270),(16777353,83270),
(16777355,83270),(16777357,83270),
(16777359,83270),(16777361,83270),
(16777344,83270),(16777342,83270),
(16777369,83270),(16777371,83270),
(16777373,83270),(16777375,83270),
(16777377,83270),(16777367,83270),
(16777363,83270),(16777365,83270),
--
(16777505,83300),
(16777506,83300),
--
(16777513,83300),
(16777315,83300),
(16777514,83300),
(16777316,83300),
--
(16777507,83300),
(16777508,83300),
(16777509,83300),
(16777510,83300),
(16777511,83300),
--
(16777319,83300),
(16777318,83300),
(16777317,83300),
(16777320,83300),
--
(16777322,83300),
(16777323,83300),
--
(16777324,83300),
(16777325,83300),
(16777326,83300),
(16777327,83300),
(16777328,83300),
(16777329,83300),
(16777330,83300),
(16777331,83300),
(16777332,83300),
(16777333,83300),
--
(16777334,83300),
(16777335,83300),
(16777336,83300),
(16777337,83300),
--
(16777339,83300),
(16777341,83300),
(16777343,83300),
(16777345,83300),
--
(16777356,83300),
(16777358,83300),
(16777360,83300),
(16777362,83300),
(16777364,83300),
--
(16777346,83300),
(16777348,83300),
(16777350,83300),
(16777352,83300),
(16777354,83300),
--
(16777370,83300),
(16777368,83300),
(16777366,83300),
(16777372,83300),
--
(16777374,83300),
(16777376,83300),
--
(16777380,83300),
(16777379,83300),
(16777381,83300),
(16777382,83300),
--
(16777383,83300),
(16777384,83300),
(16777385,83300),
(16777386,83300),
--
(16777387,83300),
(16777388,83300),
(16777389,83300),
(16777390,83300),
--
(16777391,83300),
(16777392,83300),
(16777393,83300),
(16777394,83300),
--
(16777395,83300),
(16777396,83300),
(16777397,83300),
(16777398,83300),
--
(16777403,83300),
(16777402,83300),
(16777401,83300),
(16777400,83300),
(16777399,83300);
--
--
--
--
--
--
-- Stance & Visuals & Auras
--
DELETE FROM `creature_addon` WHERE `guid` IN (16777375,16777377,16777506,16777505,16777322,16777323,16777374,16777376);
INSERT INTO `creature_addon` VALUES
(16777375,0,0,0,0,4097,333,0,''),
(16777377,0,0,0,0,4097,333,0,''),
--
(16777505,0,0,0,0,4097,333,0,''),
(16777506,0,0,0,0,4097,333,0,''),
--
(16777322,0,0,0,0,4097,333,0,''),
(16777323,0,0,0,0,4097,333,0,''),
--
(16777374,0,0,0,0,4097,333,0,''),
(16777376,0,0,0,0,4097,333,0,'');
--
--
-- Linking
--
DELETE FROM `creature_formations` WHERE `leaderGUID` IN (16777500,16777501,16777504,16777503,16800023,16800019,16800030,16800017,16800018,16800024,16800028,16800027,16800029,16800014,16800013,16800025,16800026,16800031,16800011,16800012,16800022,16800021,16800020,16800015,16800016,16777502,16800010,16777340,16777347,16777349,16777351,16777353,16777355,16777357,16777359,16777361,16777344,16777342,16777369,16777371,16777373,16777375,16777377,16777505,16777506,16777513,16777315,16777514,16777316,16777507,16777508,16777509,16777510,16777511,16777319,16777318,16777317,16777320,16777322,16777323,16777324,16777325,16777326,16777327,16777328,16777329,16777330,16777331,16777332,16777333,16777334,16777335,16777336,16777337,16777339,16777341,16777343,16777345,16777356,16777358,16777360,16777362,16777364,16777346,16777348,16777350,16777352,16777354,16777370,16777368,16777366,16777372,16777374,16777376,16777379,16777380,16777381,16777382,16777383,16777384,16777385,16777386,16777387,16777388,16777389,16777390,16777391,16777392,16777393,16777394,16777395,16777396,16777397,16777398,16777399,16777400,16777401,16777402,16777403);
DELETE FROM `creature_formations` WHERE `memberGUID` IN (16777500,16777501,16777504,16777503,16800023,16800019,16800030,16800017,16800018,16800024,16800028,16800027,16800029,16800014,16800013,16800025,16800026,16800031,16800011,16800012,16800022,16800021,16800020,16800015,16800016,16777502,16800010,16777340,16777347,16777349,16777351,16777353,16777355,16777357,16777359,16777361,16777344,16777342,16777369,16777371,16777373,16777375,16777377,16777505,16777506,16777513,16777315,16777514,16777316,16777507,16777508,16777509,16777510,16777511,16777319,16777318,16777317,16777320,16777322,16777323,16777324,16777325,16777326,16777327,16777328,16777329,16777330,16777331,16777332,16777333,16777334,16777335,16777336,16777337,16777339,16777341,16777343,16777345,16777356,16777358,16777360,16777362,16777364,16777346,16777348,16777350,16777352,16777354,16777370,16777368,16777366,16777372,16777374,16777376,16777379,16777380,16777381,16777382,16777383,16777384,16777385,16777386,16777387,16777388,16777389,16777390,16777391,16777392,16777393,16777394,16777395,16777396,16777397,16777398,16777399,16777400,16777401,16777402,16777403);
INSERT INTO `creature_formations` VALUES
(16777500,16777500,60,360,2),
(16777500,16777501,60,360,2),
--
(16800010,16800010,60,360,2),
(16800010,16777502,5,3,2),
--
(16777503,16777503,60,360,2),
(16777503,16777504,60,360,2),
--
(16800023,16800023,60,360,2),
(16800023,16800019,60,360,2),
(16800023,16800030,60,360,2),
--
(16800017,16800017,60,360,2),
(16800017,16800018,60,360,2),
(16800017,16800024,60,360,2),
--
(16800028,16800028,60,360,2),
(16800028,16800027,60,360,2),
(16800028,16800029,60,360,2),
--
(16800014,16800014,60,360,2),
(16800014,16800013,60,360,2),
--
(16800025,16800025,60,360,2),
(16800025,16800026,60,360,2),
(16800025,16800031,60,360,2),
--
(16800011,16800011,60,360,2),
(16800011,16800012,60,360,2),
--
(16800022,16800022,60,360,2),
(16800022,16800021,60,360,2),
(16800022,16800020,60,360,2),
--
(16800015,16800015,60,360,2),
(16800015,16800016,60,360,2),
--
(16777340,16777340,60,360,2),
(16777340,16777347,60,360,2),
(16777340,16777349,60,360,2),
--
(16777351,16777351,60,360,2),
(16777351,16777353,60,360,2),
(16777351,16777355,60,360,2),
--
(16777357,16777357,60,360,2),
(16777357,16777359,60,360,2),
(16777357,16777361,60,360,2),
--
(16777344,16777344,60,360,2),
(16777344,16777342,60,360,2),
--
(16777369,16777369,60,360,2),
(16777369,16777371,60,360,2),
(16777369,16777373,60,360,2),
--
(16777375,16777375,60,360,2),
(16777375,16777377,60,360,2),
-- 1boss
(16777505,16777505,60,360,2),
(16777505,16777506,60,360,2),
--
(16777513,16777513,60,360,2),
(16777513,16777315,60,360,2),
(16777513,16777514,60,360,2),
(16777513,16777316,60,360,2),
--
(16777507,16777507,60,360,2),
(16777507,16777508,60,360,2),
(16777507,16777509,60,360,2),
(16777507,16777510,60,360,2),
(16777507,16777511,60,360,2),
--
(16777319,16777319,60,360,2),
(16777319,16777318,60,360,2),
(16777319,16777317,60,360,2),
(16777319,16777320,60,360,2),
--
(16777322,16777322,60,360,2),
(16777322,16777323,60,360,2),
--
(16777324,16777324,60,360,2),
(16777324,16777325,60,360,2),
(16777324,16777326,60,360,2),
(16777324,16777327,60,360,2),
(16777324,16777328,60,360,2),
(16777324,16777329,60,360,2),
(16777324,16777330,60,360,2),
(16777324,16777331,60,360,2),
(16777324,16777332,60,360,2),
(16777324,16777333,60,360,2),
--
(16777334,16777334,60,360,2),
(16777334,16777335,60,360,2),
(16777334,16777336,60,360,2),
(16777334,16777337,60,360,2),
--
(16777339,16777339,60,360,2),
(16777339,16777341,60,360,2),
(16777339,16777343,60,360,2),
(16777339,16777345,60,360,2),
--
(16777356,16777356,60,360,2),
(16777356,16777358,60,360,2),
(16777356,16777360,60,360,2),
(16777356,16777362,60,360,2),
(16777356,16777364,60,360,2),
--
(16777346,16777346,60,360,2),
(16777346,16777348,60,360,2),
(16777346,16777350,60,360,2),
(16777346,16777352,60,360,2),
(16777346,16777354,60,360,2),
--
(16777370,16777370,60,360,2),
(16777370,16777368,60,360,2),
(16777370,16777366,60,360,2),
(16777370,16777372,60,360,2),
--
(16777374,16777374,60,360,2),
(16777374,16777376,60,360,2),
--
(16777380,16777380,60,360,2),
(16777380,16777379,60,360,2),
(16777380,16777381,60,360,2),
(16777380,16777382,60,360,2),
--
(16777383,16777383,60,360,2),
(16777383,16777384,60,360,2),
(16777383,16777385,60,360,2),
(16777383,16777386,60,360,2),
--
(16777387,16777387,60,360,2),
(16777387,16777388,60,360,2),
(16777387,16777389,60,360,2),
(16777387,16777390,60,360,2),
--
(16777391,16777391,60,360,2),
(16777391,16777392,60,360,2),
(16777391,16777393,60,360,2),
(16777391,16777394,60,360,2),
--
(16777395,16777395,60,360,2),
(16777395,16777396,60,360,2),
(16777395,16777397,60,360,2),
(16777395,16777398,60,360,2),
--
(16777403,16777403,60,360,2),
(16777403,16777402,60,360,2),
(16777403,16777401,60,360,2),
(16777403,16777400,60,360,2),
(16777403,16777399,60,360,2);
--
--
SET @NPC := 16800010;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,35.6673,0.3671,0.0055,0,0,0,100,0),
(@PATH,2,30.9514,0.4350,0.0055,0,0,0,100,0),
(@PATH,3,35.6673,0.3671,0.0055,0,0,0,100,0),
(@PATH,4,44.3891,10.7213,0.0067,0,0,0,100,0),
(@PATH,5,43.6527,49.4565,0.0067,0,0,0,100,0),
(@PATH,6,43.7692,46.7977,0.0067,0,0,0,100,0),
(@PATH,7,44.3891,10.7213,0.0067,0,0,0,100,0);
--
SET @NPC := 16777367;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-65.4372,144.1123,0.0077,0,1,0,100,0),
(@PATH,2,-70.7362,137.8905,0.0077,0,1,0,100,0),
(@PATH,3,-75.1450,149.7986,0.0063,0,1,0,100,0),
(@PATH,4,-77.3116,166.5089,0.0117,0,1,0,100,0),
(@PATH,5,-97.0024,174.2967,0.0090,0,1,0,100,0),
(@PATH,6,-71.5358,170.1941,0.0100,0,1,0,100,0),
(@PATH,7,-66.5453,161.6517,0.0077,0,1,0,100,0);
--
SET @NPC := 16777512;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-221.5782','169.2109','0.0363',0,0,0,100,0),
(@PATH,2,'-241.5758','176.4109','0.0531',0,0,0,100,0),
(@PATH,3,'-245.4189','191.9884','0.0592',0,0,0,100,0),
(@PATH,4,'-255.8401','188.8240','0.0416',0,0,0,100,0),
(@PATH,5,'-250.3469','178.4842','0.0681',0,0,0,100,0),
(@PATH,6,'-227.0475','158.3140','-0.7059',0,0,0,100,0);
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
--
SET @NPC := 16777316;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-242.5776','158.4610','0.0637',0,0,0,100,0),
(@PATH,2,'-242.1789','164.4197','0.0614',0,0,0,100,0),
(@PATH,3,'-245.4548','168.9709','0.0685',0,0,0,100,0),
(@PATH,4,'-242.1789','164.4197','0.0614',0,0,0,100,0);
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),
--
SET @NPC := 16777320;
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-258.1570','190.3426','0.0365',0,0,0,100,0),
(@PATH,2,'-260.8991','183.9163','0.0339',0,0,0,100,0),
(@PATH,3,'-265.7251','180.4423','0.0339',0,0,0,100,0),
(@PATH,4,'-260.8991','183.9163','0.0339',0,0,0,100,0);
--
SET @NPC := 16777321;
UPDATE `creature` SET `position_x`='-271.5566',`position_y`='176.4627',`position_z`='0.0340',`orientation`='4.6456' WHERE guid = @NPC;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-271.6853','171.0043','1.6226',0,0,0,100,0),
(@PATH,2,'-271.6753','152.7178','15.2746',0,0,0,100,0),
(@PATH,3,'-259.4909','141.1078','15.7380',0,0,0,100,0),
(@PATH,4,'-241.9135','141.5540','28.5620',0,0,0,100,0),
(@PATH,5,'-211.5764','141.5957','28.6888',0,0,0,100,0),
(@PATH,6,'-210.7771','205.3881','28.4071',0,0,0,100,0),
(@PATH,7,'-242.2094','204.6739','30.4912',0,0,0,100,0),
(@PATH,8,'-210.7771','205.3881','28.4071',0,0,0,100,0),
(@PATH,9,'-211.5764','141.5957','28.6888',0,0,0,100,0),
(@PATH,10,'-241.9135','141.5540','28.5620',0,0,0,100,0),
(@PATH,11,'-259.4909','141.1078','15.7380',0,0,0,100,0),
(@PATH,12,'-271.6753','152.7178','15.2746',0,0,0,100,0),
(@PATH,13,'-271.6853','171.0043','1.6226',0,0,0,100,0),
(@PATH,14,'-271.5566','176.4627','0.0340',0,0,0,100,0);
--
UPDATE `creature` SET `position_x`='-242.4832',`position_y`='299.1720',`position_z`='26.7562',`orientation`='4.3511' WHERE guid = 16777338;
UPDATE `waypoint_data` SET `position_x`='-242.4832',`position_y`='299.1720',`position_z`='26.7562' WHERE `id` = 16777338 AND `point` = 0;
UPDATE `creature` SET `orientation`='3.1591' WHERE guid = 16777376;
UPDATE `creature` SET `orientation`='5.3875' WHERE guid IN (16777322,16777323);
--
-- Guard Hammon
UPDATE `creature` SET `movementtype`='0' WHERE `guid` = 20;
-- NPC steckt in Gameobject fest
UPDATE `creature` SET `position_x`=-2087.0337, `position_y`=-3499.281738, `position_z`=130.085, `orientation`=0.872212 WHERE `guid`=12166;
-- escort mob dies on spawn
UPDATE `creature_template` SET `flags_extra`='0',`unit_flags`='0' WHERE `entry` = 7780;
Complete Dungeon Overhaul for Sethekk Halls with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.
ToDo:
http://wowwiki.wikia.com/wiki/Patch_2.0.7
http://wowwiki.wikia.com/wiki/Patch_2.1.0
http://wowwiki.wikia.com/wiki/Patch_2.1.2
[ ] Polymorph should no longer affect the main tank.
[ ] Anzu can no longer be kited far from his spawn point and will properly leash.
http://wowwiki.wikia.com/wiki/Patch_2.2.0
http://wowwiki.wikia.com/wiki/Patch_2.3.0