search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 69 forks source link

Shadow Labyrinth #627

Open Xadras opened 8 years ago

Xadras commented 8 years ago

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

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

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

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

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

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

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

Xadras commented 8 years ago

Sources:

https://www.youtube.com/watch?v=CdXrxvZa89A - Ambassador Hellmaw https://www.youtube.com/watch?v=OM-TmH_3UVM

https://www.youtube.com/watch?v=qnkIVXoBOw0 - Das Schattenlabyrinth https://www.youtube.com/watch?v=0ZLicv-LtPI - Shadow Labyrinth (normal mode) https://www.youtube.com/watch?v=rSysw94a9aU - Murmur - Shadow Labyrinth

https://www.youtube.com/watch?v=9xvDNa5jpzo&feature=youtu.be&t=890 - 3boss Shadow Labyrinth https://www.youtube.com/watch?v=muAdednmvoQ&list=PL3227D87BC8FA1294 - Shadow Labyrinth (part 1/4) https://www.youtube.com/watch?v=UKt6PQFSC4Y&index=37&list=PL3227D87BC8FA1294 - Shadow Labyrinth (part 2/4) - First Boss https://www.youtube.com/watch?v=FiZ88noFb6Q&index=36&list=PL3227D87BC8FA1294 - Shadow Labyrinth (part 23/4) - Second Boss https://www.youtube.com/watch?v=qP6lI0gzteg 1:56 - Feral Tank Druid in Shadow Labyrinth (part 4/4) https://www.youtube.com/watch?v=y1RncJolyi0 - schattenlabyrinth wow https://www.youtube.com/watch?v=rMrj24ssfio - Schattenlabby Teil 1 https://www.youtube.com/watch?v=yH3xyCw_m3g - Schattenlabby Teil 2 https://www.youtube.com/watch?v=EVOHUg-G5k8 - XDDDD Schattenlabby Teil 3 https://www.youtube.com/watch?v=TlnAVvVMsyw - Das Schattenlabyrinth https://www.youtube.com/watch?v=kmcsT1v7IR4

https://github.com/Schaka/TBC-research/issues/12 https://github.com/ccshiro/cc-buglist/issues/1878
https://bitbucket.org/oregon/oregoncore/issues/1156/shadow-labirynth-murmur-event

http://www.wowhead.com/zone=3789/shadow-labyrinth http://wowwiki.wikia.com/wiki/Shadow_Labyrinth http://wow.gamepedia.com/Shadow_Labyrinth

https://docs.google.com/spreadsheets/d/1CU65XzyLqfxfRcBNO2shJg-UWhLL2b4ul3lY3Tb4RGU/edit#gid=0

Xadras commented 8 years ago 

-- https://github.com/Looking4Group/L4G_Core/issues/627
-- Shadow Labyrinth

DELETE FROM `creature` WHERE `guid` IN (54543,54545,54546,54551,54552,54554,54556,54557); -- spinnen in slabby nahe boss 2
-- freie guides ab 67000: 67047 67051 bis 67101
-- freie guids ab 67101:
-- free guids ab 66800:

DELETE FROM `creature` WHERE `guid` IN ('67061','67062','67063','67064','67065','67066','68738','67046','85585');
INSERT INTO `creature` VALUES 
('67061',18794,555,3,0,0,'-174.3863','-71.6187','8.0657','4.6840',7200,0,0,16227,9240,0,0),
('67062',18794,555,3,0,0,'-138.5483','-71.6872','8.0657','4.6565',7200,0,0,16227,9240,0,0),
('67063',18794,555,3,0,0,'-157.1650','-52.1697','8.0715','4.6918',7200,0,0,16227,9240,0,0),
('67064',18794,555,3,0,0,'-157.1913','-13.3733','8.0730','4.6918',7200,0,0,16227,9240,0,0),
('67065',18794,555,3,0,0,'-138.4785','6.0797','8.0729','4.6486',7200,0,0,16227,9240,0,0), 
('67066',18794,555,3,0,0,'-174.5978','6.4346','8.0730','4.6722',7200,0,0,16227,9240,0,0),
('68738',18632,555,3,0,0,'-176.9837','-329.1368','17.0859','5.6138',7200,0,0,0,0,0,0),
('67046',18632,555,3,0,0,'-149.9922','-394.6699','17.0813','4.7003',7200,0,0,0,0,0,0),
('85585',18639,555,3,0,0,'-153.6999','-344.0391','17.0833','4.7342',7200,0,0,0,0,0,0);

-- linked_respawn_respawn
DELETE FROM `creature_linked_respawn` WHERE `guid` IN ('67061','67062','67063','67064','67065','67066');
INSERT INTO `creature_linked_respawn` VALUES
(67061,66999),
(67062,66999),
(67063,66999),
(67064,66999),
(67065,66999),
(67066,66999);

DELETE FROM `creature_addon` WHERE `guid` IN ('66837','66872','66873','66874','66875','66799','66838','66839','66840','66841','66842','66798','66802','66800','66801','66803','66804','66863','66864','66865','66866','66867');
INSERT INTO `creature_addon` VALUES 
-- 2nd boss trash
-- sp
(66837,0,0,512,8,4097,0,0,'16592 0'),
(66872,0,0,512,8,4097,0,0,'16592 0'),
(66873,0,0,512,8,4097,0,0,'16592 0'),
(66874,0,0,512,8,4097,0,0,'16592 0'),
(66875,0,0,512,8,4097,0,0,'16592 0'),
-- acos
(66799,0,0,512,8,4097,0,0,''),
(66838,0,0,512,8,4097,0,0,''),
(66839,0,0,512,8,4097,0,0,''),
(66840,0,0,512,8,4097,0,0,''),
(66841,0,0,512,8,4097,0,0,''),
(66842,0,0,512,8,4097,0,0,''),
-- kult
(66798,0,0,16843008,8,4097,0,0,''),
(66802,0,0,16843008,8,4097,0,0,''),
(66800,0,0,16843008,8,4097,0,0,''),
(66801,0,0,16843008,8,4097,0,0,''),
(66803,0,0,16843008,8,4097,0,0,''),
(66804,0,0,16843008,8,4097,0,0,''),
-- deathsworn
(66863,0,0,16777472,8,4097,0,0,''),
(66864,0,0,16777472,8,4097,0,0,''),
(66865,0,0,16777472,8,4097,0,0,''),
(66866,0,0,16777472,8,4097,0,0,''),
(66867,0,0,16777472,8,4097,0,0,'');
--
--
--
--
--
--
--
--
-- texts 9989-9980
-- Reentry da die in anderen dbs vorgesehene entry vergeben ist 664 - 669, 670 ist bereits 9999
DELETE FROM `creatire_ai_texts` WHERE `entry` = -9999;
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9989 AND -9980;
DELETE FROM `creature_ai_texts` WHERE `entry` BETWEEN -9959 AND -9950;
INSERT INTO `creature_ai_texts` VALUES
('-9999','Pathetic worm!','','','Erbärmlicher Wurm!','','','','','','0','1','0','0','18848 on Aggro Yell'),
(-9989,'The end comes for you!',NULL,NULL,'Euer Ende naht!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Schattenpriester'),
(-9988,'I shall be rewarded!',NULL,NULL,'Meine Taten werden entlohnt werden!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Akolyth / Kultist'),
(-9987,'I do as I must!',NULL,NULL,'Ich tue, was ich tun muss!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Akolyth'),
(-9986,'Ruin finds us all!',NULL,NULL,'Alles endet einmal!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Ritualist / Zelot / Beschwörer'),
(-9985,'In Sargeras\' name!',NULL,NULL,'Im Namen Sargeras\'!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Todeshöriger / Beschwörer / Zauberbinder'),
(-9984,'The Legion reigns!',NULL,NULL,'Die Legion obsiegt!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth pref Kultist / Akolyth / Henker'),
(-9983,'The end is come!',NULL,NULL,'Das Ende ist gekommen!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth 18796 -147'),
(-9982,'The only justice is death!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Shadow Labyrinth 18796 -345'),
(-9981,'Embrace the Nothing!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'18796 on Death'),
(-9980,'I\'ll feast on your soul!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'18796 on Aggro'),
(-9959,'None can stand against the Legion!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'18796 on Aggro'),
(-9958,'This world shall burn!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'18796 on Aggro'),
(-9957,'You shall not escape.',NULL,NULL,'Es gibt kein Entkommen!',NULL,NULL,NULL,NULL,NULL,0,0,0,0,'18796 on Death');

DELETE FROM creature_ai_texts WHERE entry IN ('-1245', '-1246');
INSERT INTO `creature_ai_texts` (`entry`,`content_default`, `content_loc3`, `sound`,`type`,`language`,`comment`,`emote`) VALUES
('-1245','%s begins to summon in a Cabal Deathsworn!', '%s beschwört einen Todeshöriger der Kabale!','0','2','0','18634','0'),
('-1246','%s begins to summon in a Cabal Acolyte!','%s beschwört einen Akolyt der Kabale!' ,'0','2','0','18634','0');

-- ===================
-- Creature Research
-- ===================

-- Fel Overseer 18796,20652
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 18796;
UPDATE `creature` SET `id`='18796' WHERE `guid` = 67088;
UPDATE `creature_template` SET `mechanic_immune_mask`='4325377',`mindmg`='969',`maxdmg`='1324' WHERE `entry` = 18796; -- 382 666 -- 775 - 1,059
UPDATE `creature_template` SET `armor`='6800',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18796',`equipment_id`='1075',`mechanic_immune_mask`='4325377',`mindmg`='5473',`maxdmg`='5970' WHERE `entry` = 20652; -- 1773 2519 -- 6567 7164 -- 8,209 - 8,955
DELETE FROM `creature_template_addon` WHERE `entry` IN (18796,20652);
INSERT INTO `creature_template_addon` VALUES
(18796,0,0,16908544,0,4097,0,0,''),
(20652,0,0,16908544,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18796;
INSERT INTO `creature_ai_scripts` VALUES
('1879601','18796','4','0','5','6','0','0','0','0','1','-9983','-9982','-9959','0','0','0','0','1','0','0','0','Fel Overseer - Random Say on Aggro'),
('1879602','18796','9','0','100','7','0','25','15000','15000','11','27577','1','7','11','27577','1','7','0','0','0','0','Fel Overseer - Cast Intercept in Range'),
('1879603','18796','0','0','100','7','9000','12000','9000','15000','11','30471','1','0','0','0','0','0','0','0','0','0','Fel Overseer - Cast Uppercut'),
('1879604','18796','9','0','100','5','0','5','8000','12000','11','16856','1','0','0','0','0','0','0','0','0','0','Fel Overseer (Heroic) - Cast Mortal Strike'),
('1879605','18796','0','0','100','7','30000','30000','30000','30000','11','19134','1','1','0','0','0','0','0','0','0','0','Fel Overseer (Heroic) - Cast Frightening Shout every 30 Secs'),
('1879606','18796','6','0','20','6','0','0','0','0','1','-9958','-9957','-9981','0','0','0','0','0','0','0','0','Fel Overseer - Say on Death');

-- Cabal Acolyte 18633,20638
UPDATE `creature` SET `id` ='18633' WHERE `guid` = 66799;
UPDATE `creature_template` SET `armor`='4450',`maxlevel`='70',`modelid_A2`='18582',`modelid_H2`='18579' WHERE `entry` = 18633;
UPDATE `creature_template` SET `modelid_A2`='18582',`modelid_H2`='18582',`speed`='1.48',`armor`='5700',`unit_flags`='32832',`pickpocketloot`='18633',`equipment_id`='1126' WHERE `entry` = 20638;
DELETE FROM `creature_template_addon` WHERE `entry` = 20638;
INSERT INTO `creature_template_addon` VALUES
(20638,0,0,512,0,4097,0,0,'');  
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18633;
INSERT INTO `creature_ai_scripts` VALUES
('1863301','18633','4','0','10','6','0','0','0','0','1','-9988','-9987','-9984','0','0','0','0','0','0','0','0','Cabal Acolyte - Random Say on Aggro'),
('1863302','18633','1','0','100','7','1000','1000','3600000','3600000','11','33482','0','1','0','0','0','0','0','0','0','0','Cabal Acolyte - Cast Shadow Defense OCC'),
('1863303','18633','14','0','100','3','6500','20','5000','9000','11','12039','6','0','0','0','0','0','0','0','0','0','Cabal Acolyte (Normal) - Cast Heal on Friendlies'),
('1863304','18633','14','0','100','5','10000','20','5000','9000','11','38209','6','0','0','0','0','0','0','0','0','0','Cabal Acolyte (Heroic) - Cast Heal on Friendlies'),
('1863305','18633','14','0','100','3','4000','20','12000','15000','11','25058','6','0','0','0','0','0','0','0','0','0','Cabal Acolyte (Normal) - Cast Renew on Friendlies'),
('1863306','18633','14','0','100','5','7000','20','12000','15000','11','38210','6','0','0','0','0','0','0','0','0','0','Cabal Acolyte (Heroic) - Cast Renew on Friendlies'),
('1863307','18633','2','0','100','6','15','0','0','0','25','0','0','0','0','0','0','0','0','0','0','0','Cabal Acolyte - Fleeing on 15% HP'),
('1863308','18633','16','0','100','7','33482','1','15000','30000','11','33482','0','1','0','0','0','0','0','0','0','0','Cabal Warlock - Cast Shadow Defense on Missing Buff');

-- Cabal Deathsworn 18635,20641
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18635;
UPDATE `creature_template` SET `modelid_A2`='18592',`modelid_H2`='18589' WHERE `entry` = 18635;
UPDATE `creature_template` SET `modelid_A2`='18592',`modelid_H2`='18592',`minlevel`='70',`maxlevel`='71',`armor`='7100',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18635',`equipment_id`='1360',`mindmg`='3786',`maxdmg`='4105' WHERE `entry` = 20641;
DELETE FROM `creature_template_addon` WHERE `entry` = 20641;
INSERT INTO `creature_template_addon` VALUES
(20641,0,0,16777472,0,4097,0,0,''); 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18635;
INSERT INTO `creature_ai_scripts` VALUES
('1863501','18635','4','0','10','38','0','0','0','0','1','-9985','-9989','-9988','0','0','0','0','0','0','0','0','Cabal Deathsworn - Random Say on Aggro'),
('1863502','18635','0','0','100','3','8000','10000','12000','15000','11','33480','1','0','0','0','0','0','0','0','0','0','Cabal Deathsworn (Normal) - Cast Black Cleave'),
('1863503','18635','0','0','100','5','8000','10000','12000','15000','11','38226','1','0','0','0','0','0','0','0','0','0','Cabal Deathsworn (Heroic) - Cast Black Cleave'),
('1863504','18635','9','0','100','7','0','5','5000','6000','11','11428','1','0','0','0','0','0','0','0','0','0','Cabal Deathsworn - Cast Knockdown'),
('1863505','18635','2','0','100','6','30','0','120000','120000','11','8599','0','0','0','0','0','0','0','0','0','0','Cabal Deathsworn - Cast Enrage at 30% HP');

-- Cabal Warlock 18640,20649
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18640;
UPDATE `creature` SET `position_x`='-75.3067',`position_y`='-78.1338',`position_z`='-1.1352',`orientation`='0.0244' WHERE `guid` = 66895;
UPDATE `creature_template` SET `armor`='4200' WHERE `entry` = 18640;
UPDATE `creature_template` SET `armor`='5450',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18640',`equipment_id`='191' WHERE `entry` = 20649;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18640,20649);
INSERT INTO `creature_template_addon` VALUES
(18640,0,0,512,0,4097,0,0,''),
(20649,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18640;
INSERT INTO `creature_ai_scripts` VALUES
('1864001','18640','11','0','100','6','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Start Combat Movement on Spawn'),
('1864002','18640','1','0','100','7','1000','1000','1800000','1800000','11','13787','0','1','0','0','0','0','0','0','0','0','Cabal Warlock - Cast Demon Armor OCC'),
('1864003','18640','4','0','10','38','0','0','0','0','1','-9986','-9985','-9984','0','0','0','0','0','0','0','0','Cabal Warlock - Random Say on Aggro'),
('1864004','18640','4','0','100','2','0','0','0','0','11','12471','1','0','23','1','0','0','0','0','0','0','Cabal Warlock (Normal) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('1864005','18640','9','5','100','3','0','40','3000','4500','11','12471','1','0','0','0','0','0','0','0','0','0','Cabal Warlock (Normal) - Cast Shadow Bolt (Phase 1)'),
('1864006','18640','4','0','100','4','0','0','0','0','11','15232','1','0','23','1','0','0','0','0','0','0','Cabal Warlock (Heroic) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('1864007','18640','9','5','100','5','0','40','3000','4500','11','15232','1','0','0','0','0','0','0','0','0','0','Cabal Warlock (Heroic) - Cast Shadow Bolt (Phase 1)'),
('1864008','18640','3','5','100','6','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Cabal Warlock - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('1864009','18640','9','5','100','6','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Start Combat Movement at 35 Yards (Phase 1)'),
('1864010','18640','9','5','100','6','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Start Combat Movement at 15 Yards (Phase 1)'),
('1864011','18640','9','5','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Start Combat Movement Below 5 Yards'),
('1864012','18640','3','3','100','7','100','30','100','100','23','-1','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1864013','18640','0','0','100','3','6000','6600','6000','9000','11','32863','4','32','0','0','0','0','0','0','0','0','Cabal Warlock (Normal) - Cast Seed of Corruption'),
('1864014','18640','0','0','100','5','6000','6600','6000','9000','11','38252','4','32','0','0','0','0','0','0','0','0','Cabal Warlock (Heroic) - Cast Seed of Corruption'),
('1864015','18640','16','0','100','7','13787','1','15000','30000','11','13787','0','1','0','0','0','0','0','0','0','0','Cabal Warlock - Cast Demon Armor on Missing Buff'),
('1864016','18640','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Cabal Warlock - Set Phase to 0 on Evade');

-- Cabal Familiar 18641,20643
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 18641;
UPDATE `creature` SET `spawndist`='5',`movementtype`='1' WHERE `guid` IN ('66898','66899','66900','66901','66902');
UPDATE `creature_template` SET `armor`='4200',`speed`='1.78' WHERE `entry` = 18641;
UPDATE `creature_template` SET `armor`='5450',`speed`='1.78',`unit_flags`='32768' WHERE `entry` = 20643;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18641,20643);
INSERT INTO `creature_template_addon` VALUES
(18641,0,0,133120,0,4097,0,0,''),
(20643,0,0,133120,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='2' WHERE `creature_id`='18641';
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='3' WHERE `creature_id`='20643';
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18641;
INSERT INTO `creature_ai_scripts` VALUES
('1864101','18641','1','0','100','6','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Start Combat Movement on Spawn'),
('1864102','18641','4','0','100','2','0','0','0','0','11','20801','1','0','23','1','0','0','0','0','0','0','Cabal Familiar (Normal) - Cast Firebolt and Set Phase 1 on Aggro'),
('1864103','18641','9','5','100','3','0','30','2000','3000','11','20801','1','0','0','0','0','0','0','0','0','0','Cabal Familiar (Normal) - Cast Firebolt (Phase 1)'),
('1864104','18641','4','0','100','4','0','0','0','0','11','38239','1','0','23','1','0','0','0','0','0','0','Cabal Familiar (Heroic) - Cast Firebolt and Set Phase 1 on Aggro'),
('1864105','18641','9','5','100','5','0','30','2000','3000','11','38239','1','0','0','0','0','0','0','0','0','0','Cabal Familiar (Heroic) - Cast Firebolt (Phase 1)'),
('1864106','18641','3','5','100','6','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Cabal Familiar - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('1864107','18641','9','5','100','6','25','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Start Combat Movement at 25 Yards (Phase 1)'),
('1864108','18641','9','5','100','6','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Start Combat Movement at 15 Yards (Phase 1)'),
('1864109','18641','9','5','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Start Combat Movement Below 5 Yards'),
('1864110','18641','3','3','100','7','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1864111','18641','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Cabal Familiar - Set Phase to 0 on Evade');

-- Fel Guardhound 18642,20651
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 18642;
UPDATE `creature_template` SET `armor`='5500',`speed`='1.20' WHERE `entry` = 18642;
UPDATE `creature_template` SET `armor`='5800',`unit_flags`='32768',`skinloot`='70162' WHERE `entry` = 20651;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18642,20651);
INSERT INTO `creature_template_addon` VALUES
(18642,0,0,131584,0,4097,0,0,''),
(20651,0,0,131584,0,4097,0,0,'');
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='2' WHERE `creature_id`='18642';
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='3' WHERE `creature_id`='20651';

-- Containment Beam Trigger NPC
UPDATE `creature` SET `position_z`='22' WHERE `id` = 21159;
UPDATE `creature_template` SET `scale`='4',`inhabittype`='7' WHERE `entry` = 21159;

-- Cabal Ritualist 18794,20645
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18794;
UPDATE `creature` SET `equipment_id`='8032' WHERE `guid` IN (67061,67065,67069,67073,67077,67081);
UPDATE `creature` SET `equipment_id`='8033' WHERE `guid` IN (67063,67067,67071,67075,67079,67083);
UPDATE `creature_template` SET `modelid_A2`='18192',`modelid_H2`='18191',`armor`='4450' WHERE `entry` = 18794;
UPDATE `creature_template` SET `modelid_A2`='18192',`modelid_H2`='18192',`minlevel`='70',`armor`='5700',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18794',`equipment_id`='1364',`mindmg`='2558',`maxdmg`='2761' WHERE `entry` = 20645;
DELETE FROM `creature_equip_template` WHERE `entry` IN (8032,8033);
INSERT INTO `creature_equip_template` VALUES
(8032,20030,0,0,218171138,0,0,3,0,0),
(8033,31820,31820,0,218173186,218173186,0,3,3,0);
DELETE FROM `creature_template_addon` WHERE `entry` IN (18794,20645);
INSERT INTO `creature_template_addon` VALUES
(18794,0,0,0,0,4097,0,0,''),
(20645,0,0,0,0,4097,0,0,'');    
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18794;
INSERT INTO `creature_ai_scripts` VALUES
('1879401','18794','11','0','100','6','0','0','0','0','21','1','0','0','0','0','0','0','30','1','3','5','Cabal Ritualist - Start Combat Movement and Random Phase Select on Spawn'),
('1879402','18794','4','0','10','0','0','0','0','0','1','-9988','-9984','-9985','30','1','3','5','0','0','0','0','Cabal Ritualist - Random Say on Aggro'),
('1879403','18794','4','0','100','0','0','0','0','0','30','1','3','5','0','0','0','0','0','0','0','0','Cabal Ritualist - Random Phase Select on Aggro'),
('1879404','18794','4','61','100','2','0','0','0','0','11','15497','1','0','28','0','32958','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Frostbolt and Stop Crystal Channeling on Aggro (Phase 1)'),
('1879405','18794','0','61','100','3','3000','3800','3000','3800','11','15497','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Frostbolt (Phase 1)'),
('1879406','18794','4','61','100','4','0','0','0','0','11','12675','1','0','23','1','0','0','28','0','32958','0','Cabal Ritualist (Heroic) - Cast Frostbolt and Stop Crystal Channeling Aggro (Phase 1)'),
('1879407','18794','0','61','100','5','3000','3800','3000','3800','11','12675','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Heroic) - Cast Frostbolt (Phase 1)'),
('1879408','18794','3','61','100','6','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('1879409','18794','9','61','100','6','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement at 35 Yards (Phase 1)'),
('1879410','18794','9','61','100','6','5','10','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement at 10 Yards (Phase 1)'),
('1879411','18794','9','61','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement Below 5 Yards (Phase 1)'),
('1879412','18794','9','61','100','3','0','8','7000','12000','11','15532','0','1','0','0','0','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Frost Nova and Start Ranged Combat Movement'),
('1879413','18794','9','61','100','5','0','8','7000','12000','11','15063','0','1','0','0','0','0','0','0','0','0','Cabal Ritualist (Heroic) - Cast Frost Nova and Start Ranged Combat Movement'),
('1879414','18794','3','59','100','7','100','30','100','100','23','-1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1879415','18794','4','55','100','2','0','0','0','0','11','33833','1','0','28','0','32958','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Arcane Missiles on Aggro and Stop Crystal Channeling (Phase 3)'),
('1879416','18794','9','55','100','3','0','30','2400','3000','11','33833','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Arcane Missiles (Phase 3)'),
('1879417','18794','4','55','100','4','0','0','0','0','11','38264','1','0','23','1','0','0','28','0','32958','0','Cabal Ritualist (Heroic) - Cast Arcane Missiles on Aggro and Stop Crystal Channeling (Phase 3)'),
('1879418','18794','9','55','100','5','0','30','2400','3000','11','38264','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Heroic) - Cast Arcane Missiles (Phase 3)'),
('1879419','18794','3','55','100','6','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 3)'),
('1879420','18794','9','55','100','6','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement at 35 Yards (Phase 3)'),
('1879421','18794','9','55','100','6','5','10','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement at 10 Yards (Phase 3)'),
('1879422','18794','9','55','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement Below 5 Yards (Phase 3)'),
('1879423','18794','9','55','100','7','0','10','5200','16000','11','33487','4','1','0','0','0','0','0','0','0','0','Cabal Ritualist - Cast Addle Humanoid (Phase 3)'),
('1879424','18794','3','47','100','7','100','30','100','100','23','-1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Set Phase 3 when Mana is above 30% (Phase 4)'),
('1879425','18794','4','31','100','6','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Start Combat Movement on Aggro (Phase 5)'),
('1879426','18794','4','31','100','6','0','0','0','0','11','9574','1','0','28','0','32958','0','0','0','0','0','Cabal Ritualist (ALL) - Cast Flame Buffet and Stop Crystal Channeling on Aggro (Phase 5)'),
('1879427','18794','0','31','100','7','2200','6200','4800','9600','11','9574','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (ALL) - Cast Flame Buffet (Phase 5)'),
('1879428','18794','0','31','100','3','6000','10000','4000','6000','11','20795','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Normal) - Cast Fire Blast (Phase 5)'),
('1879429','18794','0','31','100','5','6000','10000','4000','6000','11','14145','1','0','0','0','0','0','0','0','0','0','Cabal Ritualist (Heroic) - Cast Fire Blast (Phase 5)'),
('1879430','18794','9','0','100','7','0','5','6000','8000','11','12540','5','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Cast Gouge'),
('1879431','18794','2','0','100','6','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Cabal Ritualist - Flee at 15% HP'),
('1879432','18794','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Set Phase to 0 on Evade'),
('1879433','18794','21','0','100','6','0','0','0','0','11','32958','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Cast Crystal Channel on Reaching Home'),
('1879434','18794','1','0','100','6','1000','1000','0','0','11','32958','0','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Cast Crystal Channel on OOC Timer'),
('1879435','18794','6','0','100','6','0','0','0','0','34','2','3','0','0','0','0','0','0','0','0','0','Cabal Ritualist - Set Instance Data on Death'),
('1879436','18794','15','0','100','7','0','40','4000','8000','11','43577','6','7','0','0','0','0','0','0','0','0','Cabal Ritualist - Cast Despell Magic on friendly Target CC');

-- Malicious Instructor 18848,20656
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 18848;
UPDATE `creature_template` SET `maxlevel`='70',`mechanic_immune_mask`='4325377',`armor`='6800',`mindmg`='824',`maxdmg`='1113' WHERE `entry` = 18848; -- 427 716
UPDATE `creature_template` SET `minlevel`='71',`armor`='7100',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18848',`equipment_id`='1676',`mechanic_immune_mask`='4325377',`mindmg`='3601',`maxdmg`='4274' WHERE `entry` = 20656; -- 972 1982 -- 2701 3206 -- 5,401 - 6,411
DELETE FROM `creature_template_addon` WHERE `entry` IN (18848,20656);
INSERT INTO `creature_template_addon` VALUES
(18848,0,0,66048,0,4097,0,0,''),
(20656,0,0,66048,0,4097,0,0,'');   
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18848;
INSERT INTO `creature_ai_scripts` VALUES
(1884801,18848,4,0,10,6,0,0,0,0,1,-9999,-9980,-9958,0,0,0,0,0,0,0,0,'Malicious Instructor - Say on Aggro'),
-- (1884802,18848,0,0,100,7,5400,5400,12000,12000,11,33493,1,32,20,1,0,0,0,0,0,0,'Malicious Instructor - Cast Mark of Malice & Start Autoattack again'), -- Crash Related
(1884803,18848,0,0,100,7,7000,7000,12000,12000,11,33501,0,0,0,0,0,0,0,0,0,0,'Malicious Instructor - Cast Shadow Nova'),
(1884804,18848,0,0,100,9,0,5,10000,20000,11,6713,1,0,0,0,0,0,0,0,0,0,'Malicious Instructor - Cast Disarm HC Only'),
(1884805,18848,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Malicious Instructor - Cast Dual Wield on Aggro'),
(1884806,18848,6,0,20,6,0,0,0,0,1,-9959,-9958,-9981,0,0,0,0,0,0,0,0,'Malicious Instructor - Say on Death');

-- Cabal Shadow Priest 18637,20646
UPDATE `creature` SET `id` ='18637' WHERE `guid` = 66837;
UPDATE `creature` SET `spawndist`='0' WHERE `id` = 18637;
UPDATE `creature_template` SET `mechanic_immune_mask`='0',`armor`='4450' WHERE `entry` = 18637;
UPDATE `creature_template` SET `armor`='5700',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18637',`equipment_id`='1128',`mechanic_immune_mask`='0' WHERE `entry` = 20646;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18637,20646);
INSERT INTO `creature_template_addon` VALUES
(18637,0,0,512,0,4097,0,0,'16592 0'),
(20646,0,0,512,0,4097,0,0,'16592 0');   
UPDATE `creature_ai_scripts` SET `action1_param3`='33' WHERE `id` = 1863701; 
DELETE FROM `creature_ai_scripts` WHERE `id` IN (1863702,1863703,1863704,1863705,1863706);
INSERT INTO `creature_ai_scripts` VALUES
('1863702','18637','9','0','100','3','0','15','4800','9700','11','17165','1','0','0','0','0','0','0','0','0','0','Cabal Shadow Priest (Normal) - Cast Mind Flay'),
('1863703','18637','9','0','100','5','0','15','2400','4800','11','38243','1','0','0','0','0','0','0','0','0','0','Cabal Shadow Priest (Heroic) - Cast Mind Flay'),
('1863704','18637','0','0','100','3','3600','7000','5400','12900','11','14032','4','0','0','0','0','0','0','0','0','0','Cabal Shadow Priest (Normal) - Cast Shadow Word: Pain'),
('1863705','18637','0','0','100','5','3100','7000','4800','7200','11','17146','4','0','0','0','0','0','0','0','0','0','Cabal Shadow Priest (Heroic) - Cast Shadow Word: Pain'),
('1863706','18637','4','0','10','38','0','0','0','0','1','-9989','-9988','-9985','0','0','0','0','0','0','0','0','Cabal Shadow Priest - Random Say on Aggro');

-- Cabal Cultist 18631,20640
UPDATE `creature` SET `id`='18631' WHERE `guid` = 66878;
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18631;
UPDATE `creature_template` SET `mechanic_immune_mask`='0',`armor`='5800' WHERE `entry` = 18631;
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18631',`equipment_id`='361',`mechanic_immune_mask`='1',`mindmg`='2780',`maxdmg`='3011' WHERE `entry` = 20640;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18631,20640);
INSERT INTO `creature_template_addon` VALUES
(18631,0,0,16843008,0,4097,0,0,''),
(20640,0,0,16843008,0,4097,0,0,'');   
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18631;
INSERT INTO `creature_ai_scripts` VALUES
('1863101','18631','11','0','100','6','0','0','0','0','11','8876','0','0','0','0','0','0','0','0','0','0','Cabal Cultist - Cast Thrash on Spawn'),
('1863102','18631','13','0','100','7','5000','10000','0','0','11','15614','1','1','0','0','0','0','0','0','0','0','Cabal Cultist - Cast Kick on Target Spell Casting'),
('1863103','18631','2','0','100','6','15','0','0','0','25','0','0','0','1','-47','0','0','0','0','0','0','Cabal Cultist - Flee at 15% HP'),
('1863104','18631','4','0','10','6','0','0','0','0','1','-9988','-9984','-9987','0','0','0','0','0','0','0','0','Cabal Cultist - Random Say on Aggro');

-- Cabal Assassin 18636,20639
-- They spawn once you kill the first boss, they pat the first boss room and the 2nd boss room.
-- They can pretty much 3 shot a cloth class.
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18636;
UPDATE `creature_template` SET `mechanic_immune_mask`='0',`armor`='5800' WHERE `entry` = 18636;
UPDATE `creature_template` SET `armor`='7100',`speed`='1.48',`unit_flags`='32832',`lootid`='18636',`pickpocketloot`='18636',`equipment_id`='1288',`mechanic_immune_mask`='1',`mindmg`='3046',`maxdmg`='3469' WHERE `entry` = 20639;
DELETE FROM `creature_template_addon` WHERE `entry` IN (18636,20639);
INSERT INTO `creature_template_addon` VALUES
(18636,0,0,16777472,0,4097,0,0,''),
(20639,0,0,16777472,0,4097,0,0,'');   
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` = 18636;
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
(1863601,18636,1,0,100,6,0,0,0,0,11,30991,0,3,0,0,0,0,0,0,0,0,'Cabal Assassin - Casts Stealth on Spawn'),
(1863602,18636,0,0,100,7,2000,4000,4500,6500,11,30992,1,1,0,0,0,0,0,0,0,0,'Cabal Assassin - Casts Backstab'),
(1863603,18636,9,0,100,6,0,30,0,0,11,30980,5,35,0,0,0,0,0,0,0,0,'Cabal Assassin - Casts Sap'),
(1863604,18636,0,0,100,7,15000,20000,15000,20000,11,30980,5,35,0,0,0,0,0,0,0,0,'Cabal Assassin - Casts Sap IC'),
(1863605,18636,9,0,100,7,0,5,10000,20000,11,30986,1,3,0,0,0,0,0,0,0,0,'Cabal Assassin - Casts Cheap Shot'),
(1863606,18636,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Dual Wield on Aggro'),
(1863607,18636,9,0,100,7,0,5,5000,10000,11,36974,1,3,11,44289,1,3,0,0,0,0,'Cabal Assassin - Cast Wound and Cripp Poison');

-- Cabal Executioner 18632,20642
UPDATE `creature` SET `spawndist`='0',`movementtype`='0' WHERE `id` = 18632;
UPDATE `creature` SET `position_x`='-160.8294', `position_y`='-375.9169', `position_z`='17.0817', `orientation`='4.7106' WHERE `guid` = 66818;
UPDATE `creature` SET `id`='18632',`position_x`='-160.8620', `position_y`='-394.5789', `position_z`='17.0803', `orientation`='4.7106' WHERE `guid` = 66884;
UPDATE `creature` SET `position_x`='-160.9018', `position_y`='-417.3753', `position_z`='17.0789', `orientation`='4.7106' WHERE `guid` = 66820;
UPDATE `creature` SET `position_x`='-149.2971', `position_y`='-376.0131', `position_z`='17.0822', `orientation`='4.7263' WHERE `guid` = 66817;
UPDATE `creature_template` SET `modelid_A2`='18595',`modelid_H2`='18593' WHERE `entry` = 18632;
UPDATE `creature_template` SET `modelid_A2`='18595',`modelid_H2`='18595',`minlevel`='71',`maxlevel`='71',`armor`='7100',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18632',`equipment_id`='1111',`mindmg`='3091',`maxdmg`='3444' WHERE `entry` = 20642; -- 1280 1987 s1 30485 s2 15578 s3 33500 s4 38959
DELETE FROM `creature_addon` WHERE `guid` IN (66817,66818,66819,66820);
DELETE FROM `creature_template_addon` WHERE `entry` IN (18632,20642);
INSERT INTO `creature_template_addon` VALUES
(18632,0,0,16777472,0,4097,376,0,'33332 0'),
(20642,0,0,16777472,0,4097,376,0,'33332 0');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18632;
INSERT INTO `creature_ai_scripts` VALUES
('1863201','18632','4','0','10','6','0','0','0','0','1','-9984','-9989','-9985','0','0','0','0','0','0','0','0','Cabal Executioner - Random Say on Aggro'),
('1863202','18632','0','0','100','3','7000','10000','10000','13000','11','33500','0','0','0','0','0','0','0','0','0','0','Cabal Executioner (Normal) - Cast Whirlwind'),
('1863203','18632','0','0','100','5','7000','10000','10000','13000','11','15578','0','0','0','0','0','0','0','0','0','0','Cabal Executioner (Heroic) - Cast Whirlwind'),
('1863204','18632','12','0','100','7','20','0','8000','12000','11','7160','1','1','0','0','0','0','0','0','0','0','Cabal Executioner - Cast Execute when Target is at 20% HP'),
('1863205','18632','2','0','100','6','30','0','0','0','11','30485','0','0','0','0','0','0','0','0','0','0','Cabal Executioner - Cast Enrage at 30% HP');

-- Tortured Skeleton hardcoded
UPDATE `creature_template` SET `speed`='1.20' WHERE `entry` = 18797;
UPDATE `creature_template` SET `armor`='6800' WHERE `entry` = 20662;
UPDATE `creature_onkill_reputation` SET `MaxStanding1`='5' WHERE `creature_id` IN (18797,20662);

-- Cabal Zealot 18638,20650
UPDATE `creature_template` SET `modelid_A`='18612',`modelid_A2`='18614',`modelid_H`='18612',`modelid_H2`='18614',`heroic_entry`='20650' WHERE `entry` = 18638;
UPDATE `creature_template` SET `modelid_A`='18612',`modelid_A2`='18614',`modelid_H`='18612',`modelid_H2`='18614',`speed`='1.48',`mechanic_immune_mask`='1',`unit_flags`='32832',`pickpocketloot`='18638',`equipment_id`='1498',`mindmg`='2895',`maxdmg`='3203' WHERE `entry` = 20650; -- 1217 1832
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18638;
INSERT INTO `creature_ai_scripts` VALUES
('1863801','18638','1','0','100','6','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Zealot - Start Combat Movement on Spawn'),
('1863802','18638','4','0','10','38','0','0','0','0','1','-9986','-9984','-9989','0','0','0','0','0','0','0','0','Cabal Zealot - Random Say on Aggro'),
('1863803','18638','4','0','100','2','0','0','0','0','11','12471','1','0','23','1','0','0','0','0','0','0','Cabal Zealot (Normal) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('1863804','18638','9','13','100','3','0','40','3000','4000','11','12471','1','0','0','0','0','0','0','0','0','0','Cabal Zealot (Normal) - Cast Shadow Bolt (Phase 1)'),
('1863805','18638','4','0','100','4','0','0','0','0','11','15472','1','0','23','1','0','0','0','0','0','0','Cabal Zealot (Heroic) - Cast Shadow Bolt and Set Phase 1 on Aggro'),
('1863806','18638','9','13','100','5','0','40','3000','4000','11','15472','1','0','0','0','0','0','0','0','0','0','Cabal Zealot (Heroic) - Cast Shadow Bolt (Phase 1)'),
('1863807','18638','3','13','100','6','15','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Cabal Zealot - Start Combat Movement and Set Phase 2 when Mana is at 15% (Phase 1)'),
('1863808','18638','9','13','100','6','35','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Zealot - Start Combat Movement at 35 Yards (Phase 1)'),
('1863809','18638','9','13','100','6','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Zealot - Start Combat Movement at 15 Yards (Phase 1)'),
('1863810','18638','9','13','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Cabal Zealot - Start Combat Movement Below 5 Yards'),
('1863811','18638','3','11','100','7','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Cabal Zealot - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1863812','18638','2','0','100','6','50','0','0','0','11','33499','0','1','22','3','0','0','0','0','0','0','Cabal Zealot - Cast Shape of the Beast and Set Phase 3 at 50% HP'),
('1863813','18638','7','0','100','6','0','0','0','0','28','0','33499','0','22','0','0','0','0','0','0','0','Cabal Zealot - Remove Shape of the Beast Aura and Set Phase to 0 on Evade'),
('1863814','18638','2','0','100','6','25','0','0','0','11','33958','0','7','0','0','0','0','0','0','0','0','Cabal Zealot - Cast Enrage at 25% HP');

-- Cabal Fanatic 18830,20644
-- UPDATE `creature_template` SET ``='' WHERE `entry` = 18830;
UPDATE `creature_template` SET `speed`='1.48',`armor`='7100',`unit_flags`='32832',`pickpocketloot`='18830',`equipment_id`='1275',`mindmg`='2848',`maxdmg`='3054' WHERE `entry` = 20644; -- 1270 1681 s1 12021 s2 30798
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 18830;
INSERT INTO `creature_ai_scripts` VALUES
('1883001','18830','4','0','10','6','0','0','0','0','1','-9985','-9989','-9984','0','0','0','0','0','0','0','0','Cabal Fanatic - Random Say on Aggro'),
('1883002','18830','9','0','100','7','0','5','10000','15000','11','12021','1','0','0','0','0','0','0','0','0','0','Cabal Fanatic - Cast Fixate');

-- Cabal Summoner
UPDATE `creature` SET `id`='18634' WHERE `guid` = 68739;
UPDATE `creature` SET `position_x`='-156.5180', `position_y`='-321.9327', `position_z`='17.0849',`orientation`='4.6988' WHERE `guid` = 66845;
UPDATE `creature` SET `position_x`='-177.9019', `position_y`='-352.4571', `position_z`='17.0837', `orientation`='5.6016' WHERE `guid` = 66849;
UPDATE `creature` SET `position_x`='-155.3057', `position_y`='-440.3734', `position_z`='17.0789', `orientation`='4.7106' WHERE `guid` = 66855;
UPDATE `creature` SET `position_x`='-157.9039', `position_y`='-440.3331', `position_z`='17.0789', `orientation`='4.7106' WHERE `guid` = 66853;
UPDATE `creature_template` SET `maxlevel`='70' WHERE `entry` = 18634;
UPDATE `creature_template` SET `minlevel`='71',`modelid_H`='18608',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18634',`equipment_id`='1372' WHERE `entry` = 20648;
DELETE FROM `creature_template_addon` WHERE `entry` = 20648;
INSERT INTO `creature_template_addon` VALUES
(20648,0,0,66048,0,4097,0,0,'');    
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = '18634';
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
('1863401','18634','0','0','100','3','4400','4500','4000','5000','11','14034','1','0','39','7','0','0','0','0','0','0','Cabal Summoner (Normal) - Cast Fireball'),
('1863402','18634','0','0','100','5','4400','4500','4000','5000','11','15228','1','0','39','7','0','0','0','0','0','0','Cabal Summoner (Heroic) - Cast Fireball'),
('1863403','18634','4','0','50','6','0','100','0','0','11','33507','0','1','11','33507','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Acolyte Emote -1246'),
('1863404','18634','4','0','50','6','0','100','0','0','11','33506','0','1','11','33506','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Deathsworn Emote -1245'),
('1863405','18634','4','0','50','6','0','100','0','0','11','33507','0','1','11','33507','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Acolyte'),
('1863406','18634','4','0','50','6','0','100','0','0','11','33506','0','1','11','33506','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Deathsworn'),
('1863407','18634','4','0','50','6','0','100','0','0','11','33507','0','1','11','33507','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Acolyte'),
('1863408','18634','4','0','50','6','0','100','0','0','11','33506','0','1','11','33506','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Deathsworn'),
('1863409','18634','4','0','50','6','0','100','0','0','11','33507','0','1','11','33507','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Acolyte'),
('1863410','18634','4','0','50','6','0','100','0','0','11','33506','0','1','11','33506','0','1','39','7','0','0','Cabal Summoner - Summon Cabal Deathsworn'),
('1863411','18634','0','0','50','7','25000','25000','25000','25000','11','33507','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Acolyte'),
('1863412','18634','0','0','50','7','25000','25000','25000','25000','11','33506','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Deathsworn'),
('1863413','18634','0','0','50','7','25000','25000','25000','25000','11','33507','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Acolyte'),
('1863414','18634','0','0','50','7','25000','25000','25000','25000','11','33506','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Deathsworn'),
('1863415','18634','0','0','50','7','25000','25000','25000','25000','11','33507','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Acolyte'),
('1863416','18634','0','0','50','7','25000','25000','25000','25000','11','33506','0','1','39','7','0','0','0','0','0','0','Cabal Summoner - Resummon Cabal Deathsworn'),
('1863417','18634','0','0','100','7','5010','5010','50','50','39','7','0','0','0','0','0','0','0','0','0','0','Cabal Summoner Set Summoned Combat');

-- Cabal Spellbinder
UPDATE `creature` SET `id`='18639' WHERE `guid` = 66852;
UPDATE `creature` SET `position_x`='-175.0080', `position_y`='-431.7518', `position_z`='17.0784', `orientation`='5.3546' WHERE `guid` = 66892;
UPDATE `creature` SET `position_x`='-152.4489', `position_y`='-440.2602', `position_z`='17.0779', `orientation`='4.7106' WHERE `guid` = 66887; 
UPDATE `creature` SET `position_x`='-160.8228', `position_y`='-440.3280', `position_z`='17.0789', `orientation`='4.7106' WHERE `guid` = 66893;
UPDATE `creature_template` SET `modelid_A2`='18604',`modelid_H2`='18602' WHERE `entry` = 18639;
UPDATE `creature_template` SET `modelid_A2`='18604',`modelid_H2`='18602',`modelid_H`='18604',`minlevel`='71',`speed`='1.48',`unit_flags`='32832',`pickpocketloot`='18639',`equipment_id`='859' WHERE `entry` = 20647;
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1863901','1863908');
UPDATE `creature_ai_scripts` SET `event_param3`='3000',`event_param4`='4000' WHERE `id` IN ('1863903','1863905');
DELETE FROM `creature_template_addon` WHERE `entry` = 20647;
INSERT INTO `creature_template_addon` VALUES
(20647,0,0,512,0,4097,0,0,'');

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

-- Ambassador Hellmaw 18731,20636
-- UPDATE `creature_template` SET `mindmg`='1975',`maxdmg`='2922' WHERE `entry` = 18731;  -- 906 1853 -- 2,975 - 3,922
UPDATE `creature_template` SET `mindmg`='4233',`maxdmg`='4740',`speed`='1.48',`unit_flags`='2147483712',`pickpocketloot`='18731',`equipment_id`='1547',`rank`='1' WHERE `entry` = 20636; --

-- Blackheart the Inciter 18667,20637
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`mindmg`='1411',`maxdmg`='2178' WHERE `entry` = 18667; -- 734 1501 2411 3178
UPDATE `creature_template` SET `speed`='1.48',`rank`='1',`unit_flags`='64',`pickpocketloot`='18667',`equipment_id`='1369',`mechanic_immune_mask`='787431423',`mindmg`='3791',`maxdmg`='4366' WHERE `entry` = 20637; -- 5791 6366

-- Grandmaster Vorpil 18732,20653
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`mindmg`='1840',`maxdmg`='2424' WHERE `entry` = 18732; -- 561 1145
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='64',`equipment_id`='1487',`mechanic_immune_mask`='787431423',`mindmg`='4626',`maxdmg`='5392' WHERE `entry` = 20653;

-- Void Traveler 19226,20664
UPDATE `creature_template` SET `armor`='5500',`speed`='0.30',`mechanic_immune_mask`='1072644095',`unit_flags`='131072',`flags_extra`='65538'WHERE `entry` = 19226; -- 0.3 0 0 0
UPDATE `creature_template` SET `armor`='5800',`speed`='0.50',`mechanic_immune_mask`='1072644095',`unit_flags`='131072',`flags_extra`='65538' WHERE `entry` = 20664; -- 1.2 1 0 0
DELETE FROM `creature_template_addon` WHERE `entry` = 20664;
INSERT INTO `creature_template_addon` VALUES
(20664,0,0,131584,0,4097,0,0,'');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 19226;

-- Murmur 18708,20657
UPDATE `creature_template` SET `armor`='7387',`minhealth`='411750',`maxhealth`='411750',`mindmg`='3000',`maxdmg`='3500',`baseattacktime`='2500' WHERE `entry` = 18708; -- 1905 2305
UPDATE `creature_template` SET `unit_flags`='64',`speed`='1.48',`minhealth`='575445',`maxhealth`='575445',`mindmg`='5727',`maxdmg`='6138',`rank`='1' WHERE `entry` = 20657; -- 4765 5725
DELETE FROM `creature_template_addon` WHERE `entry` = 20657;
INSERT INTO `creature_template_addon` VALUES
(20657,0,0,16908544,0,4097,0,0,'');

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

UPDATE `creature` SET `position_x`='-60.2118',`position_y`='-18.3663',`position_z`='-1.1284',`orientation`='0.0270',`MovementType`='2' WHERE `guid` = 66834;
SET @NPC := 66834;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,512,0,4097,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,'-59.9454','9.6533','-1.1284',0,0,0,100,0),
(@PATH,2,'-38.4693','9.5239','-1.1284',0,0,0,100,0),
(@PATH,3,'-37.9432','-3.5488','-1.13225',0,0,0,100,0),
(@PATH,4,'-57.7408','-23.8390','-1.1281',30000,0,0,100,0);

UPDATE `creature` SET `movementtype`='2' WHERE `guid` = 66903;
SET @NPC := 66903;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,133120,0,4097,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,'-67.5488','-68.8090','-1.1282',0,1,0,0,0),
(@PATH,2,'-72.3086','-84.4273','-1.1296',0,1,0,0,0),
(@PATH,3,'-75.4540','-70.3720','-1.1299',0,1,0,0,0),
(@PATH,4,'-64.5152','-84.1939','-1.1302',0,1,0,0,0);

UPDATE `creature` SET `movementtype`='2' WHERE `guid` = 67085;
SET @NPC := 67085;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16908544,0,4097,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,'-177.4478','-38.9762','8.0731',0,0,0,0,0),
(@PATH,2,'-197.1124','-38.8803','8.0731',0,0,0,0,0),
(@PATH,3,'-225.9228','-38.9276','8.0731',0,0,0,0,0),
(@PATH,4,'-197.1124','-38.8803','8.0731',0,0,0,0,0);

UPDATE `creature` SET `movementtype`='2' WHERE `guid` = 67088;
SET @NPC := 67088;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,66048,0,4097,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,'-430.8858','-118.2825','12.6930',0,0,0,0,0),
(@PATH,2,'-430.6822','-151.3052','12.3729',0,0,0,0,0),
(@PATH,3,'-431.0554','-190.3011','12.6891',0,0,0,0,0),
(@PATH,4,'-419.4606','-182.5914','12.6502',0,0,0,0,0),
(@PATH,5,'-430.6822','-151.3052','12.3729',0,0,0,0,0);
-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,0,0),

-- linking
DELETE FROM `creature_formations` WHERE `memberguid` IN (66889,66890,66891,66893,66887,66853,66855,66892,66854,66819,66820,66885,66850,66888,66851,67046,66852,68739,66884,66817,66818,66882,66848,66844,66849,66886,66814,85585,66846,66816,66847,66881,66883,66845,68738,66815,66904,66896,66841,66867,66803,66875,66873,66864,66842,66804,66906,66897,66877,66810,67245,66872,66839,66802,66840,66866,66800,66838,66865,66801,66874,66837,66799,66798,66863,67084,67083,67077,67065,67073,67081,67082,67066,67069,67068,67067,67064,67072,67071,67070,67063,67080,67079,67078,67062,67076,67075,67074,67061,66903 ,66905 ,66895,66894,66898,66899,66900,66901,66902,66862,66836,66861,66857,66825,66826,66831,66832,66860,66828,66859,66833,66834,66858,66827,66822,66821,66856);
DELETE FROM `creature_formations` WHERE `leaderguid` IN (66889,66890,66891,66893,66887,66853,66855,66892,66854,66819,66820,66885,66850,66888,66851,67046,66852,68739,66884,66817,66818,66882,66848,66844,66849,66886,66814,85585,66846,66816,66847,66881,66883,66845,68738,66815,66904,66896,66841,66867,66803,66875,66873,66864,66842,66804,66906,66897,66877,66810,67245,66872,66839,66802,66840,66866,66800,66838,66865,66801,66874,66837,66799,66798,66863,67084,67083,67077,67065,67073,67081,67082,67066,67069,67068,67067,67064,67072,67071,67070,67063,67080,67079,67078,67062,67076,67075,67074,67061,66903 ,66905 ,66895,66894,66898,66899,66900,66901,66902,66862,66836,66861,66857,66825,66826,66831,66832,66860,66828,66859,66833,66834,66858,66827,66822,66821,66856);
INSERT INTO `creature_formations` VALUES
--
-- GK5
(66889,66889,100,360,2),
(66889,66890,100,360,2),
(66889,66891,100,360,2),
-- GG5
(66893,66893,100,360,2),
(66893,66887,100,360,2),
(66893,66853,100,360,2),
(66893,66855,100,360,2),
-- GK4
(66892,66892,100,360,2),
(66892,66854,100,360,2),
-- GG4
(66819,66819,100,360,2),
(66819,66820,100,360,2),
(66819,66885,100,360,2),
(66819,66850,100,360,2),
-- GK3
(66888,66888,100,360,2),
(66888,66851,100,360,2),
-- GG3
(67046,67046,100,360,2),
(67046,66852,100,360,2),
(67046,68739,100,360,2),
(67046,66884,100,360,2),
-- GG2
(66817,66817,100,360,2),
(66817,66818,100,360,2),
(66817,66882,100,360,2),
(66817,66848,100,360,2),
-- GK1
(66844,66844,100,360,2),
(66844,66849,100,360,2),
(66844,66886,100,360,2),
-- GG1
(66814,66814,100,360,2),
(66814,85585,100,360,2),
(66814,66846,100,360,2),
(66814,66816,100,360,2),
-- GK2
(66847,66847,100,360,2),
(66847,66881,100,360,2),
(66847,66883,100,360,2),
-- GE
(66845,66845,100,360,2),
(66845,68738,100,360,2),
(66845,66815,100,360,2),
--
(66904,66904,100,360,2),
(66904,66896,100,360,2),
(66904,66841,100,360,2),
(66904,66867,100,360,2),
(66904,66803,100,360,2),
(66904,66875,100,360,2),
--
(66873,66873,100,360,2),
(66873,66864,100,360,2),
(66873,66842,100,360,2),
(66873,66804,100,360,2),
(66873,66906,100,360,2),
(66873,66897,100,360,2),
--
(66877,66877,100,360,2),
(66877,66810,3,1,2),
(66877,67245,3,4,2),
--
(66872,66872,100,360,2),
(66872,66839,100,360,2),
(66872,66802,100,360,2),
(66872,66840,100,360,2),
(66872,66866,100,360,2),
--
(66800,66800,100,360,2),
(66800,66838,100,360,2),
(66800,66865,100,360,2),
(66800,66801,100,360,2),
(66800,66874,100,360,2),
--
(66837,66837,100,360,2),
(66837,66799,100,360,2),
(66837,66798,100,360,2),
(66837,66863,100,360,2),
--
(67084,67084,100,360,2),
(67084,67083,100,360,2),
(67084,67077,100,360,2),
(67084,67065,100,360,2),
--
(67066,67066,100,360,2),
(67066,67073,100,360,2),
(67066,67081,100,360,2),
(67066,67082,100,360,2),
--
(67069,67069,100,360,2),
(67069,67068,100,360,2),
(67069,67067,100,360,2),
(67069,67064,100,360,2),
--
(67072,67072,100,360,2),
(67072,67071,100,360,2),
(67072,67070,100,360,2),
(67072,67063,100,360,2),
--
(67080,67080,100,360,2),
(67080,67079,100,360,2),
(67080,67078,100,360,2),
(67080,67062,100,360,2),
--
(67076,67076,100,360,2),
(67076,67075,100,360,2),
(67076,67074,100,360,2),
(67076,67061,100,360,2),
--
(66903,66903,100,360,2),
(66903,66905,2,0,2),
--
(66894,66894,100,360,2),
(66894,66898,100,360,2),
(66894,66899,100,360,2),
(66894,66900,100,360,2),
(66894,66901,100,360,2),
(66894,66902,100,360,2),
--
(66862,66862,100,360,2),
(66862,66836,100,360,2),
(66862,66861,100,360,2),
--
(66857,66857,100,360,2),
(66857,66825,100,360,2),
(66857,66826,100,360,2),
--
(66831,66831,100,360,2),
(66831,66832,100,360,2),
(66831,66860,100,360,2),
--
(66833,66833,100,360,2),
(66833,66859,100,360,2),
(66833,66828,100,360,2),
--
(66827,66827,100,360,2),
(66827,66858,100,360,2),
(66827,66834,100,360,0),
--
(66822,66822,100,360,2),
(66822,66821,100,360,2),
(66822,66856,100,360,2);

-- freie guids ab 66800:   bis 66900
DELETE FROM `creature` WHERE `guid` IN ('66813','66880','67001','41938');
INSERT INTO `creature` VALUES
(66880,18638,555,3,0,0,-360.7011,-271.3119,12.6870,3.1503,7200,0,0,16767,9465,0,0),
(66813,18830,555,3,0,0,-360.9296,-268.1266,12.6871,3.1503,7200,0,0,20958,0,0,0),
(67001,18631,555,3,0,0,-311.2900,-263.5787,12.6832,0.0375,7200,0,0,0,0,0,2),
(41938,18638,555,3,0,0,'-248.1580','-282.0476','17.0551','0.7107',7200,0,0,0,0,0,2);
-- 
UPDATE `creature` SET `movementtype`='0' WHERE `guid` IN ('66876','66810','66877','67245','66812','66811','67248');
DELETE FROM `creature_linked_respawn` WHERE `guid` IN ('66813','66880','67001','41938');
INSERT INTO `creature_linked_respawn` VALUES
(66813,67000),
(66880,67000),
(67001,67000),
(41938,67000);

UPDATE `creature` SET `MovementType`= 2 WHERE `guid` = 67244;

DELETE FROM `creature_formations` WHERE `leaderguid` IN (67244,66876,66813,66880,67001,66810,66877,67245,41938,66812,66811,67248);
DELETE FROM `creature_formations` WHERE `memberguid` IN (67244,66876,66813,66880,67001,66810,66877,67245,41938,66812,66811,67248);
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67244', '67244', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67244', '66876', '3', '1.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67244', '66813', '3', '4.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67244', '66880', '5', '4.7', '2');
-- 2nd
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67001', '67001', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67001', '66810', '3', '1.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67001', '66877', '3', '4.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('67001', '67245', '5', '4.7', '2');
-- 3nd
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('41938', '41938', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('41938', '66812', '3', '1.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('41938', '66811', '3', '4.7', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('41938', '67248', '5', '4.7', '2');
-- movement
SET @NPC := 67244;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16843008,8,4097,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,'-376.4696','-263.6311','12.6873',0,0,0,100,0),
(@PATH,2,'-367.6968','-266.1493','12.6874',10000,0,0,100,0),
(@PATH,3,'-354.4210','-266.5058','12.6872',10000,0,0,100,0),
(@PATH,4,'-343.5341','-266.2626','12.6862',10000,0,0,100,0),
(@PATH,5,'-333.3719','-266.3019','12.6858',10000,0,0,100,0),
(@PATH,6,'-334.6597','-266.3112','12.6858',0,0,0,100,0);
-- movement
SET @NPC := 67001;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,16843008,8,4097,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,'-328.7413','-263.6261','12.6842',0,0,0,100,0),
(@PATH,2,'-325.7293','-263.6195','12.6842',0,0,0,100,0),
(@PATH,3,'-323.2213','-263.6140','12.6842',10000,0,0,100,0),
(@PATH,4,'-306.1796','-263.6307','12.6842',10000,0,0,100,0),
(@PATH,5,'-286.3014','-263.7122','12.6828',10000,0,0,100,0),
(@PATH,6,'-288.3309','-263.7166','12.6828',0,0,0,100,0);
--
-- movement
SET @NPC := 41938;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,0,66048,0,4097,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.9469','-280.4153','17.0863',0,0,0,100,0),
(@PATH,2,'-230.5894','-270.9914','17.0863',0,0,0,100,0),
(@PATH,3,'-230.9540','-255.6564','17.0863',0,0,0,100,0),
(@PATH,4,'-247.8520','-244.2876','17.0863',0,0,0,100,0),
(@PATH,5,'-257.4732','-244.9607','12.6798',0,0,0,100,0),
(@PATH,6,'-274.0536','-249.8396','12.6818',0,0,0,100,0),
(@PATH,7,'-279.8959','-260.0153','12.6818',0,0,0,100,0),
(@PATH,8,'-279.6782','-268.3355','12.6818',0,0,0,100,0),
(@PATH,9,'-267.3201','-281.7868','12.6818',0,0,0,100,0),
(@PATH,10,'-257.2441','-282.6065','12.6967',0,0,0,100,0),
(@PATH,11,'-247.5964','-283.5028','17.0863',0,0,0,100,0);

-- (@PATH,1,'XXX','YYY','ZZZ',0,0,0,100,0),

DELETE FROM `creature_addon` WHERE `guid` IN (66876,66813,66880,66877,67245,66810);
INSERT INTO `creature_addon` VALUES
-- Cabal Zealot
(66880,0,0,66048,8,4097,0,0,''),    
(66876,0,0,66048,8,4097,0,0,''),    
(66877,0,0,66048,8,4097,0,0,''),    
-- Cabal Fanatic
(66813,0,0,16843008,8,4097,0,0,''),
(67245,0,0,16843008,8,4097,0,0,''),
-- Cabal Cultist
(66810,0,0,16843008,8,4097,0,0,'');

-- GG1 85585 fresh spawn
UPDATE `creature` SET `position_x`='-149.9768', `position_y`='-343.9579', `position_z`='17.0833', `orientation`='4.7342' WHERE `guid` = 66814;
UPDATE `creature` SET `position_x`='-157.9969', `position_y`='-344.1329', `position_z`='17.0833', `orientation`='4.7342' WHERE `guid` = 66846;
UPDATE `creature` SET `position_x`='-160.7612', `position_y`='-344.1932', `position_z`='17.0833', `orientation`='4.7342' WHERE `guid` = 66816;
-- GK2
UPDATE `creature` SET `position_x`='-138.3816', `position_y`='-349.7464', `position_z`='17.0825', `orientation`='5.2761' WHERE `guid` = 66847;
UPDATE `creature` SET `position_x`='-140.7230', `position_y`='-358.6558', `position_z`='17.0820', `orientation`='0.7168' WHERE `guid` = 66881;
UPDATE `creature` SET `position_x`='-134.8815', `position_y`='-359.5601', `position_z`='17.0813', `orientation`='3.8089' WHERE `guid` = 66883;
-- GK3
UPDATE `creature` SET `position_x`='-179.3842', `position_y`='-402.3081', `position_z`='17.0799', `orientation`='6.1753' WHERE `guid` = 66851;  
UPDATE `creature` SET `position_x`='-174.1181', `position_y`='-403.0668', `position_z`='17.0799', `orientation`='2.9945' WHERE `guid` = 66888;