Underbog

[Xadras]

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

---

ToDo:

• Ghaz'an [18105] uses Acid Spit [34290] in a 360 Degree Angle resulting in hitting the whole Group, the Breath [34268] also seems to hit everyone
• evtl bis zum fix die ai umbauen mit nh 20657 hc 34290
• Final Boss should spawn 3 adds not 1, dmg spell should do more damage, levitate spell bugged
• https://github.com/TrinityCore/TrinityCore/commit/7bfc62639a8d6d378900c7878a0d1763e62344ee

---

• [ ] Underbat in Heroic difficulty damage has been reduced.
• [ ] Underbog Lurker in Heroic difficulty damage has been reduced.
• [ ] Wild Growth on the Underbog Lurkers has been fixed.
• [ ] Underbog Lurkers will now have a slight delay before using the Coral Cut ability on a target.
• [ ] Murkblood Oracles and Murkblood Healers now have more mana.
• [ ] The Murkblood Spearmen's Throw ability does more damage in Heroicdifficulty.
• [ ] Lykul Wasp and Lykul Stinger melee damage has been reduced.
• [ ] Underbog Lords have had their damage reduced.
• [ ] The Black Stalker's Spore Strider Summon should happen at more regular intervals and be less random.

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

---

[Xadras]

Sources:

http://www.tentonhammer.com/guides/underbog-guide http://guidecraft.blogspot.com/2007/01/coilfang-reservoir-underbog.html?m=1

http://www.caseysmac.com/wow/bc_info.html. http://burntcrusade.blogspot.ca/2006/.

http://handmaidenoftheempress.tumblr.com/post/134126271626/fish-fridays-feature-illidans-naga-overseer. ID: https://pastebin.com/Ky3GCkwv. Loc: http://z4.ifrm.com/12415/9/0/p1021761/npcdisplay.txt. Asian - translate: https://tieba.baidu.com/p/325214910

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

https://www.youtube.com/watch?v=CRMNLQtsxig https://www.youtube.com/watch?v=t1OKsqd2D-E

https://www.youtube.com/watch?v=kTQhlNH_I18 https://www.youtube.com/watch?v=O-5wqw_UwJA https://www.youtube.com/watch?v=_22InIwYusA https://gaming.youtube.com/watch?v=CRMNLQtsxig

https://www.youtube.com/watch?v=TCBfERMHpDM https://www.youtube.com/watch?v=LpzYJ_LzqWY https://www.youtube.com/watch?v=eTVPhaopFyM https://www.youtube.com/watch?v=Ylh0eGhifus https://www.youtube.com/watch?v=DRS2Nsm9Ick https://www.youtube.com/watch?v=q-_JeSaRyX4 https://www.youtube.com/watch?v=irwg132wIdA

http://www.wowhead.com/zone=3716/the-underbog http://wowwiki.wikia.com/wiki/Underbog http://wow.gamepedia.com/Underbog http://wowwiki.wikia.com/wiki/Hungarfen http://wowwiki.wikia.com/wiki/Ghaz'an http://wowwiki.wikia.com/wiki/Swamplord_Musel'ek http://wowwiki.wikia.com/wiki/The_Black_Stalker

[Xadras]

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/617
-- Underbog

-- Underbog Frenzy 20465,21943
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`minhealth`='33333',`maxhealth`='34822',`armor`='6800',`speed`='1.48',`mindmg`='1371',`maxdmg`='2333',`baseattacktime`='1000',`attackpower`='0',`MovementType`='1',`mechanic_immune_mask`='787431423',`unit_flags`='32832' WHERE `entry` IN ('21943');
UPDATE `creature_template` SET `MovementType`='1',`unit_flags`='32832' WHERE `entry` IN ('20465');
DELETE FROM `creature_template_addon` WHERE `entry` IN (20465,21943);
INSERT INTO `creature_template_addon` VALUES 
(20465,0,0,0,0,0,0,0,'18950 0 18950 1'), -- moveflag 2097152
(21943,0,0,0,0,0,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `id` IN ('2046501');
INSERT INTO `creature_ai_scripts` VALUES
(2046501,20465,9,0,100,7,0,5,7500,10000,11,12097,1,0,13,-25,1,0,0,0,0,0,'Underbog Frenzy - Cast Pierce Armor');

-- Underbat 17724, 20185
UPDATE `creature_template` SET `mechanic_immune_mask`='8520720' WHERE `entry` IN (17724);
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='8530960',`mindmg`='3440',`maxdmg`='4572' WHERE `entry` IN (20185); -- 1802 3684
DELETE FROM `creature_template_addon` WHERE `entry` IN (17724,20185);
INSERT INTO `creature_template_addon` VALUES 
(17724,0,0,0,0,4097,0,0,'36151 0'),
(20185,0,0,0,0,4097,0,0,'36151 0');
DELETE FROM `creature_ai_scripts` WHERE `id` = 1772403;
INSERT INTO `creature_ai_scripts` VALUES
('1772403','17724','4','0','100','6','0','0','0','0','39','5','0','0','0','0','0','0','0','0','0','0','Underbat - Call For Help on Aggro');

-- Underbog Shambler 17871, 20190
UPDATE `creature_template` SET `mechanic_immune_mask`='8389648' WHERE `entry` = 17871;
UPDATE `creature_template` SET `speed`='1.48',`unit_flags`='1',`mechanic_immune_mask`='8399888',`mindmg`='3440',`maxdmg`='4572' WHERE `entry` = 20190; -- 4,832 - 6,283
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('17871');
INSERT INTO `creature_ai_scripts` VALUES
('1787101','17871','9','0','100','3','0','15','10000','15000','11','32329','4','32','0','0','0','0','0','0','0','0','Underbog Shambler (Normal) - Cast Itchy Spores'),
('1787102','17871','9','0','100','5','0','15','8000','12500','11','37965','4','32','0','0','0','0','0','0','0','0','Underbog Shambler (Heroic) - Cast Itchy Spores'),
('1787103','17871','2','0','100','3','75','0','25000','30000','11','34163','0','0','0','0','0','0','0','0','0','0','Underbog Shambler (Normal) - Cast Fungal Regrowth at 75% HP'),
('1787104','17871','2','0','100','5','75','0','25000','30000','11','37967','0','0','0','0','0','0','0','0','0','0','Underbog Shambler (Heroic) - Cast Fungal Regrowth at 75% HP'),
('1787105','17871','14','0','100','3','4000','40','25000','30000','11','34163','6','0','0','0','0','0','0','0','0','0','Underbog Shambler (Normal) - Cast Fungal Regrowth on Friendlies'),
('1787106','17871','14','0','100','5','8000','40','25000','30000','11','37967','6','0','0','0','0','0','0','0','0','0','Underbog Shambler (Heroic) - Cast Fungal Regrowth on Friendlies'),
('1787107','17871','9','0','25','7','0','5','4000','8000','11','31427','5','0','0','0','0','0','0','0','0','0','Underbog Shambler - Cast Allergies');

-- Underbog Lurker 17725, 20188
UPDATE `creature_template` SET `mechanic_immune_mask`='8389648' WHERE `entry` = 17725;
UPDATE `creature_template` SET `maxhealth`='27350',`speed`='1.48',`unit_flags`='1',`mechanic_immune_mask`='8399888',`mindmg`='4012',`maxdmg`='4764' WHERE `entry` = 20188; -- 4572 6858 -- 10,029 - 11,911 /2.5
UPDATE `creature_ai_texts` SET `content_loc3`='wächst, als er $N sieht!' WHERE `entry` = -152;
UPDATE `creature_ai_texts` SET `content_loc3`='\'s Kraft verschwindet!' WHERE `entry` = -153;

-- Bog Giant 17723, 20164
UPDATE `creature_template` SET `mechanic_immune_mask`='652885759',`mindmg`='1132',`maxdmg`='1475',`baseattacktime`='2000' WHERE `entry` = 17723; -- 525-1040 
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='652885759',`mindmg`='6686',`maxdmg`='7941',`baseattacktime`='0' WHERE `entry` = 20164; -- 8023 9529 -- 10,029 - 11,911
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('17723');
INSERT INTO `creature_ai_scripts` VALUES
('1772301','17723','9','0','75','3','0','5','13650','16100','11','15550','0','0','0','0','0','0','0','0','0','0','Bog Giant (Normal) - Cast Trample'), -- 40340 eig nur 15550
('1772302','17723','9','0','75','5','0','5','13650','16100','11','40492','0','0','0','0','0','0','0','0','0','0','Bog Giant (Heroic) - Cast Trample'), -- 40340 eig nur 15550
('1772303','17723','9','0','100','7','0','15','9300','9300','11','32065','4','32','0','0','0','0','0','0','0','0','Bog Giant - Cast Fungal Decay'),
('1772304','17723','2','0','100','6','50','0','0','0','11','40318','0','1','0','0','0','0','0','0','0','0','Bog Giant - Cast Growth at 50% HP'),
('1772305','17723','2','0','100','6','30','0','120000','120000','11','8599','0','1','1','-46','0','0','0','0','0','0','Bog Giant - Cast Enrage at 30% HP');
--
--
UPDATE `creature_ai_texts` SET `content_loc3`='Ich werde Eure Haut als Hausjacke tragen! Die Zigarren? Die müsst Ihr schon aus meinen kalten, toten... ääh... RAAAR!!!' WHERE `entry`='-177';
UPDATE `creature_ai_texts` SET `content_loc3`='Die Zigarren? Die müsst Ihr schon aus meinen kalten, toten... ääh... RAAAR!!!' WHERE `entry`='-178';
-- recheck
UPDATE `creature_ai_texts` SET `content_loc3`='wird wütend!' WHERE `entry`='-46';
UPDATE `creature_template` SET `mechanic_immune_mask`='67109571',`equipment_id`='832' WHERE `entry` IN (17726); 
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='67109571',`equipment_id`='832' WHERE `entry` IN (20191);
UPDATE `creature_template` SET `mechanic_immune_mask`='75578067',`equipment_id`='72' WHERE `entry` IN (17727); -- Holzschild + Langschwert  72 nice aqua look 1711 eisenschild 1766 holzschild  
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='75578067',`equipment_id`='72' WHERE `entry` IN (20192); -- Holzschild + Langschwert
DELETE FROM `creature_template_addon` WHERE `entry` IN (17727,20192);
INSERT INTO `creature_template_addon` VALUES 
(17727,0,0,0,0,4097,0,0,'18950 0 18950 1'),
(20192,0,0,0,0,4097,0,0,'18950 0 18950 1'),

UPDATE `creature_ai_texts` SET `content_loc3`='Heil Illidan!',`type`='1' WHERE `entry` IN (-154);
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='5' WHERE `id` IN (1772702);
UPDATE `creature_template` SET `mechanic_immune_mask`='75507923',`equipment_id`='940' WHERE `entry` IN (17735); -- Holzschild + Säbel
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='75507923',`equipment_id`='940' WHERE `entry` IN (20193); -- Holzschild + Säbel
UPDATE `creature_ai_scripts` SET `event_type`='9',`event_param1`='0',`event_param2`='5' WHERE `id` IN (1773501);
UPDATE `creature_template` SET `equipment_id`='397' WHERE `entry` IN (17730); -- Dolch Einhändig
UPDATE `creature_template` SET `speed`='1.48',`equipment_id`='397' WHERE `entry` IN (20177); -- Dolch Einhändig
UPDATE `creature_ai_texts` SET `content_default`='begins a massive heal!',`content_loc3`='beginnt eine große Heilung!' WHERE `entry` IN (-686);

UPDATE `creature_template` SET `equipment_id`='1754'  WHERE `entry` IN (17729); -- Spear
UPDATE `creature_template` SET `speed`='1.48',`equipment_id`='1754' WHERE `entry` IN (20180); -- Spear
UPDATE `creature_ai_scripts` SET `action1_param1`= '1' WHERE `id` IN (1772901,1772908);
UPDATE `creature_ai_scripts` SET `event_param2`= '10' WHERE `id` = 1772908;
UPDATE `creature_ai_scripts` SET `event_param4`= '2200' WHERE `id` IN (1772903,1772905);
UPDATE `creature_ai_scripts` SET `action1_param3`= '33' WHERE `id` IN (1772909,1772910);

-- Murkblood Tribesman
UPDATE `creature_template` SET `equipment_id`='437',`mindmg`='474',`maxdmg`='645'  WHERE `entry` IN (17728); -- Doppel Eisenhammer 277 619
UPDATE `creature_template` SET `speed`='1.48',`equipment_id`='437',`mindmg`='2266',`maxdmg`='2692' WHERE `entry` IN (20181); -- Doppel Eisenhammer 814 1665 5383
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('17728');
INSERT INTO `creature_ai_scripts` VALUES
('1772801','17728','9','0','100','7','0','5','4400','8700','11','12057','1','0','0','0','0','0','0','0','0','0','Murkblood Tribesman - Cast Strike'),
('1772802','17728','2','0','100','6','30','0','0','0','11','8599','0','1','1','-106','0','0','0','0','0','0','Murkblood Tribesman - Cast Enrage at 30% HP'),
('1772803','17728','4','0','100','6','0','0','0','0','11','29651','0','1','0','0','0','0','0','0','0','0','Murkblood Tribesman - Casts Dual Wield on Aggro');
--
-- Murkblood Oracle 17771 20179
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1033',`maxdmg`='1226' WHERE `entry` IN (20179); -- 372 758
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN ('1777101','1777110','1777121','1777132');
--
-- Fen Ray
UPDATE `creature_template` SET `mechanic_immune_mask`='1024' WHERE `entry` IN (17731);
UPDATE `creature_template` SET `mechanic_immune_mask`='75569011',`speed`='1.48',`unit_flags`='1',`mindmg`='3021',`maxdmg`='3588' WHERE `entry` IN (20173);
--
-- Lykul Stinger
UPDATE `creature_template` SET `mechanic_immune_mask`='1024' WHERE `entry` IN (19632);
UPDATE `creature_template` SET `mechanic_immune_mask`='75564915',`speed`='1.48',`mindmg`='2288',`maxdmg`='2722' WHERE `entry` IN (20174); -- 614 1265
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (1773201,1773205);
UPDATE `creature_ai_scripts` SET `event_param3`='2500',`event_param4`='4000' WHERE `id` IN (1773203);

-- Bosses

-- Hungarfen 17770,20169
UPDATE `creature_template` SET `mindmg` = '652',`maxdmg` = '853', `baseattacktime` = 2000 WHERE `entry` = 17770; -- 802 1606 1362 --  2,607 - 3,411
UPDATE `creature_template` SET `mindmg`='5763',`maxdmg`='6838', `baseattacktime` = 2000 WHERE `entry` = 20169; -- 7683 9117 11,525 - 13,675

-- Hungarfen 17770,20169
UPDATE `creature_template` SET `mindmg` = '802',`maxdmg` = '1606', `baseattacktime` = 2000 WHERE `entry` = 17770; -- 802 1606 1362 --  2,607 - 3,411
UPDATE `creature_template` SET `mindmg`='7683',`maxdmg`='9117', `baseattacktime` = 2000 WHERE `entry` = 20169; -- 7683 9117 1362 -- 11,525 - 13,675

-- Underbog Mushroom 17990,20189
-- UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`unit_flags`= 262148,`resistance3`= 0,`ScriptName` = 'mob_underbog_mushroom', `AIName` = '' WHERE `entry` = 17990; -- 919556
-- UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`unit_flags`= 262148,`resistance3`= 0,`ScriptName` = 'mob_underbog_mushroom' WHERE `entry` = 20189;
-- DELETE FROM `creature_template_addon` WHERE `entry` IN (17990,20189); 
-- INSERT INTO `creature_template_addon` VALUES
-- (17990,0,0,0,0,0,0,0,'34168 0 34168 1'),
-- (20189,0,0,0,0,0,0,0,'34168 0 34168 1'); -- 34168 0 34168 1 31690 0
-- DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17990;
-- INSERT INTO `creature_ai_scripts` VALUES
-- ('1799001','17990','4','0','100','2','0','0','0','0','21','0','0','0','20','0','0','0','11','34168','0','7','Rancid Mushroom (Normal) - Stop Movement and Stop Melee and Cast Spore Cloud on Aggro'),
-- ('1799002','17990','4','0','100','4','0','0','0','0','21','0','0','0','20','0','0','0','11','34168','0','7','Rancid Mushroom (Heroic) - Stop Movement and Stop Melee and Cast Spore Cloud on Aggro'),
-- ('1799003','17990','0','0','100','7','1000','1000','3000','3000','11','31698','0','7','0','0','0','0','0','0','0','0','Rancid Mushroom - Cast Grow'),
-- ('1799004','17990','6','0','100','2','0','0','0','0','11','31689','0','7','0','0','0','0','0','0','0','0','Rancid Mushroom (Normal) - Cast Spore Cloud on Death'),
-- ('1799005','17990','6','0','100','4','0','0','0','0','11','38652','0','7','0','0','0','0','0','0','0','0','Rancid Mushroom (Heroic) - Cast Spore Cloud on Death'),
-- ('1799006','17990','0','0','100','6','19000','19000','0','0','11','31689','0','7','37','0','0','0','0','0','0','0','Rancid Mushroom (Normal) - Cast Spore Cloud and Die');
-- ('1799006','17990','0','0','100','4','19000','19000','0','0','11','31689','0','7','37','0','0','0','0','0','0','0','Rancid Mushroom (Heroic) - Cast Spore Cloud and Die');

-- Ghaz'an 18105,20168
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`speed`='1.48',`mindmg`='417',`maxdmg`='546', `baseattacktime` = 2000 WHERE `entry` = 18105; -- 385 771 1362 1,251 - 1,637
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`armor`='7400',`speed`='1.48',`mindmg`='3077',`maxdmg`='3654',`skinloot`='70063', `baseattacktime` = 2000 WHERE `entry` = 20168; -- 6153 7308 -- 9,230 - 10,962
DELETE FROM `creature_ai_scripts` WHERE `id` = 1810503;
INSERT INTO `creature_ai_scripts` VALUES 
('1810503','18105','4','0','100','6','0','0','0','0','11','8876','0','0','0','0','0','0','0','0','0','0','Ghaz\'an - Cast Thrash on Aggro');

-- Overseer Tidewrath 18107
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`minhealth`='250000',`maxhealth`='250000',`armor`='7400',`speed`='3',`mindmg`='10000',`maxdmg`='15000',`baseattacktime`='2000',`attackpower`='0',`mingold`='8000',`maxgold`='12000',`AIName`='EventAI',`mechanic_immune_mask`='787431423',`flags_extra`='4259841',`equipment_id` ='1752',`faction_A`='14',`faction_H`='14' WHERE `entry` = 18107; -- Dreizack wie DK Endboss

-- Swamplord Musel'ek 17826,20183 -- 89224 ?
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`equipment_id`='1713',`baseattacktime`='2000' WHERE `entry` = 17826; --
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`speed`='1.48',`equipment_id`='1713',`minhealth`='89652',`maxhealth`='89652',`mindmg`='4171',`maxdmg`='4950',`baseattacktime`='2000' WHERE `entry` = 20183; -- 10,428 - 12,376
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17826;
INSERT INTO `creature_ai_scripts` VALUES
('1782600','17826','0','0','100','7','4000','4000','4000','4000','21','1','0','0','40','1','0','0','20','1','0','0','Swamplord Musel\'ek - Start Combat Movement and Start Melee'),
('1782601','17826','1','0','100','7','0','0','0','0','21','0','0','0','0','0','0','0','0','0','0','0','Swamplord Musel\'ek - Prevent Combat Movement on Spawn'),
('1782602','17826','4','0','100','6','0','0','0','0','1','-463','-464','0','22','1','0','0','0','0','0','0','Swamplord Musel\'ek - Yell and Set Phase 1 on Aggro'),
('1782603','17826','9','1','100','3','6','30','2000','2000','11','16100','1','0','40','2','0','0','21','0','0','0','Swamplord Musel\'ek (Normal) - Cast Shoot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('1782604','17826','9','1','100','5','6','30','2000','2000','11','38940','1','0','40','2','0','0','21','0','0','0','Swamplord Musel\'ek (Heroic) - Cast Shoot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('1782605','17826','9','0','100','6','0','5','1000','1000','21','1','0','0','40','1','0','0','22','0','0','0','Swamplord Musel\'ek - Start Movement and Set Melee Weapon Model and Set Phase 0 Below 5 Yards'),
('1782606','17826','9','0','100','7','0','5','2000','4000','11','31566','1','0','40','1','0','0','0','0','0','0','Swamplord Musel\'ek - Cast Raptor Strike and Set Melee Weapon Model Below 5 Yards'),
('1782607','17826','0','1','100','7','8000','12000','10000','15000','11','34974','1','0','40','2','0','0','21','0','0','0','Swamplord Musel\'ek - Cast Multi-Shot and Set Ranged Weapon Model and Stop Movement (Phase 1)'),
('1782608','17826','0','0','100','7','6000','6000','31000','31000','11','31946','4','0','21','0','0','0','0','0','0','0','Swamplord Musel\'ek - Throw Freezing Trap and Stop Movement'),
('1782609','17826','0','0','100','7','5000','5000','30000','30000','11','18813','1','1','21','0','0','0','22','1','0','0','Swamplord Musel\'ek - Cast Knock Away and Stop Movement and Set Phase 1'),
('1782610','17826','0','0','100','7','5000','5000','30000','30000','1','-465','0','0','0','0','0','0','0','0','0','0','Swamplord Musel\'ek - Pet Enrage Yell During Combat'),
('1782611','17826','5','0','100','7','0','0','0','0','1','-467','-468','0','0','0','0','0','0','0','0','0','Swamplord Musel\'ek - Yell on Player Kill'),
('1782612','17826','7','0','100','6','0','0','0','0','40','1','0','0','22','0','0','0','0','0','0','0','Swamplord Musel\'ek - Set Melee Weapon Model and Set Phase 0 on Evade'),
('1782613','17826','6','0','100','6','0','0','0','0','1','-466','0','0','0','0','0','0','0','0','0','0','Swamplord Musel\'ek - Yell on Death'),
('1782614','17826','2','0','100','7','30','0','12000','18000','11','31567','0','1','0','0','0','0','0','0','0','0','Swamplord Musel\'ek - Cast Deterrence at 30% HP'),
('1782615','17826','9','0','100','7','5','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Swamplord Musel\'ek - Stop Combat Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)');

-- infight text
UPDATE creature_ai_texts SET content_loc3='Kurz und schmerzvoll....' WHERE entry='-463';
UPDATE creature_ai_texts SET content_loc3='Wir kämpfen bis zum Tod!' WHERE entry='-464';
UPDATE creature_ai_texts SET content_loc3='Bestie! Gehorche deinem Meister! Töte sie!' WHERE entry='-465';
UPDATE creature_ai_texts SET content_loc3='Krypta!' WHERE entry='-467';
UPDATE creature_ai_texts SET content_loc3='Es ist vollbracht.' WHERE entry='-468';
UPDATE creature_ai_texts SET content_loc3='Gut...gemacht...' WHERE entry='-466';

-- Claw 17827,20165 -- 88626  ?
UPDATE `creature` SET `spawntimesecs`='60' WHERE `guid` = 56862;
UPDATE `creature_template` SET `baseattacktime`='1800',`mechanic_immune_mask`='787430911' WHERE `entry` = 17827;
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423',`speed`='1.48',`minhealth`='89667',`maxhealth`='89667',`mindmg`='1752',`maxdmg`='2327',`baseattacktime`='0' WHERE `entry` = 20165;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN ('17827');
INSERT INTO `creature_ai_scripts` VALUES
('1782701','17827','0','0','100','3','7400','7400','15000','20000','11','39435','4','0','14','-10','0','0','0','0','0','0','Claw (Normal) - Cast Feral Charge and Modify Threat'),
('1782702','17827','0','0','100','5','7400','7400','10000','12000','11','39435','4','0','14','-10','0','0','0','0','0','0','Claw (Heroic) - Cast  Feral Charge and Modify Threat'),
('1782703','17827','9','0','100','7','0','5','15000','30000','11','31429','0','0','0','0','0','0','0','0','0','0','Claw - Cast  Echoing Roar'),
('1782704','17827','0','0','100','7','5000','5000','30000','30000','11','34971','0','1','13','-25','1','0','0','0','0','0','Claw - Cast Frenzy'),
('1782705','17827','0','0','100','9','0','5','11100','21500','11','34298','1','1','0','0','0','0','0','0','0','0','Claw - Cast Maul'),
('1782706','17827','2','0','100','6','19','0','0','0','24','0','0','0','36','17894','0','0','5','13','0','0','Claw - Transform to Windcaller Claw at 19% HP');
UPDATE `creature_template` SET `armor`='0',`minhealth`='6000',`maxhealth`='6000' WHERE `entry` IN ('17894');
UPDATE `creature` SET `spawndist`='5',`MovementType`='1' WHERE `guid` IN ('56168','56145','98233','98232','98231','98230','98229','98228');
UPDATE `creature_template` SET `mechanic_immune_mask`='787431423' WHERE `entry` IN ('17882');
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='787431423' WHERE `entry` IN ('20184');
--
 -- 127505 The Black Stalker 17882,20184 
UPDATE `creature_template` SET `minhealth`='130000',`maxhealth`='130000',`mindmg`='4279',`maxdmg`='5080' WHERE `entry` IN ('20184');
--
-- Repos
--
UPDATE `creature` SET `position_x`='-107.5208', `position_y`='-353.3462', `position_z`='34.4018', `orientation`='1.6084',`spawndist`='0',`movementtype`='0' WHERE `guid` IN ('98214');
UPDATE `creature` SET `position_x`='-131.2513', `position_y`='-340.2707', `position_z`='33.2630', `orientation`='0.6738',`spawndist`='0',`movementtype`='0' WHERE `guid` IN ('98215');
--
UPDATE `creature` SET `position_x`='16.2012',`position_y`='-175.8611',`position_z`='-4.4923',`orientation`='4.1284' WHERE `guid` IN (98203);
UPDATE `creature` SET `position_x`='11.6524',`position_y`='-170.7431',`position_z`='-4.5332',`orientation`='3.2101' WHERE `guid` IN (54212);
UPDATE `creature` SET `position_x`='22.7546',`position_y`='-175.8437',`position_z`='-4.3584',`orientation`='5.7823',`id`='17871' WHERE `guid` IN (54215);
UPDATE `creature` SET `orientation`='1.7565',`spawndist`='3',`MovementType`='1' WHERE `guid` IN (54213,54214);
UPDATE `creature` SET `orientation`='1.1203' WHERE `guid` IN (54216,54217);
UPDATE `creature` SET `MovementType`='1',`spawndist`='5' WHERE `guid` IN (54210);

DELETE FROM `creature` WHERE `guid` IN (55000,54962,54940,54609,54610,54866,54962,54940,53011,54203,54289,54290,54291,54292,54293,54294,54295,54296,54297,54298,54299,54300,54301,54302,54303,54317,54405,54442,54487,54555,4920659,4920764);
-- hohe guides die gelöscht werden da fehlerhaft 4922530,4922558,4920659,4920764
-- hier haben wir faulen code rumliegen der dort immer wieder npcs einfügt wenn ihr ein update schaltet...
-- add npcs
INSERT INTO `creature` (`guid`,`id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
('55000','18107','546','2','330.3231','-543.7508','42.1390','1.3225','43200','0','0'),
('54962','17724','546','3','62.3316','-246.7358','-4.5090','2.5975','7200','0','0'),
('54940','17724','546','3','62.3317','-246.7359','-4.5091','2.5976','7200','0','0'),
('54609','17724','546','3','72.8584','-260.8788','-4.5240','2.4640','7200','3','1'),
('54610','17724','546','3','79.4202','-241.7153','-4.4715','2.7585','7200','3','1'),
('54866','17725','546','3','70.0774','-248.4127','-4.4962','2.6172','7200','0','0'),
('53011','17724','546','3','10.6741','-193.8280','-4.5321','2.1307','7200','0','0'),
('54203','17724','546','3','8.2230','-199.9580','-4.5321','2.1307','7200','0','0'), 
('54289','17724','546','3','18.8243','-192.7174','-4.3985','2.1307','7200','0','0'),
('54290','17871','546','3','-56.5549','-253.0245','-4.5365','6.1810','7200','0','0'),
('54291','17724','546','3','-9.3767','-232.0353','-4.5348','6.1810','7200','0','0'),
('54292','17724','546','3','-6.7228','-231.8936','-4.5348','6.1810','7200','0','0'), 
('54293','17724','546','3','10.6742','-193.8281','-4.5322','2.1308','7200','0','0'),
('54294','17724','546','3','-21.1292','-209.9807','-4.5350','6.1810','7200','0','0'), 
('54295','17724','546','3','-25.6935','-210.2410','-4.5350','6.1810','7200','0','0'),
('54296','17723','546','3','84.8842','-282.8594','32.1868','4.9909','7200','0','0'),
('54297','17726','546','3','185.5287','-398.0972','72.3938','4.2372','7200','0','0'), 
('54298','17726','546','3','189.0179','-400.3017','72.4666','4.2372','7200','0','0'),
('54299','17731','546','3','329.8336','-332.2165','22.0885','1.9840','7200','0','0'),
('54300','17731','546','3','276.7394','-183.3901','29.0624','4.3312','7200','0','0'),
('54301','17731','546','3','243.9074','-177.5774','26.8624','5.8923','7200','0','0'),
('54302','20465','546','3','6.9152','-274.8950','-20.8859','1.5021','7200','5','1'),
('54303','20465','546','3','-15.5462','-302.5088','-18.4072','2.1352','7200','5','1'),
('54317','20465','546','3','221.8629','-420.4852','37.8492','4.9076','7200','5','1'), 
('54405','20465','546','3','201.3661','-459.3652','36.8523','4.2283','7200','5','1'), 
('54442','20465','546','3','216.2375','-499.4735','39.2713','1.7975','7200','5','1'),
('54487','20465','546','3','261.9448','-437.2689','35.2546','4.0005','7200','5','1'),
('54555','20465','546','3','-49.4212','-333.6355','-21.5887','4.9076','7200','5','1');
--
UPDATE `creature` SET `position_z`='-15',`spawndist`='10',`MovementType`='1' WHERE `guid` IN (54250,54249,54555,54387,54303,54248,54385,54383,54337,54381,54337,54339);
--
DELETE FROM `waypoint_data` WHERE `id` IN ('1361') AND `point` IN ('0');
INSERT INTO `waypoint_data` VALUES
(1361,0,232.1944,-132.0565,25.7789,0,0,0,100,0);

-- fische kein linking
DELETE FROM `creature_linked_respawn` WHERE `guid` IN (54962,54940,54609,54866,54610,53011,54203,54289,54290,98207,98206,54291,54292,98205,54293,54211,98208,54294,54295,98204,54296,54297,54298,54299,56112,56142,54300,56316,56168,54301,56164,56145);
INSERT INTO `creature_linked_respawn` VALUES
(54962,54392),
(54940,54392),
(54609,54392),
(54866,54392),
(54610,54392),
(53011,54392),
(54203,54392),
(54289,54392),
(54290,54392),
(98207,54392),
(98206,54392),
(54291,54392),
(54292,54392),
(98205,54392),
(54293,54392),
(54211,54392),
(98208,54392),
(54294,54392),
(54295,54392),
(98204,54392),
(54296,56111),
(54297,56111),
(54298,56111),
(54299,56551),
(56112,56551),
(56142,56551),
(54300,56551),
(56316,56551),
(56168,56551),
(54301,56551),
(56164,56551),
(56145,56551);
-- (GUID,BOSSGUID),

DELETE FROM `creature_formations` WHERE `leaderGUID` IN (98202,54213,5421456551,56862,54410,54407,54406,54615,54421,54420,54940,54337,98203,54247,54866,54211,54291,53011,4920764,98214,54424,54703,55102,98222,98224,56112,56316,56164,54317,54555,54249,54248,54383,54294,54297,57013);
DELETE FROM `creature_formations` WHERE `memberGUID` IN (98202,54213,5421456551,56862,54410,54407,54406,54615,54421,54420,54940,54337,98203,54247,54866,54211,54291,53011,4920764,98214,54424,54703,55102,98222,98224,56112,56316,56164,54317,54555,54249,54248,54383,54294,54297,57013);
--
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98202', '98202', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98202', '54213', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98202', '54214', '60', '360', '2'); 
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54410', '54410', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54410', '54411', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54410', '54409', '60', '360', '2'); 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54410', '54412', '60', '360', '2'); 

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54615', '54615', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54615', '54622', '60', '360', '2');

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54866', '54866', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54866', '54610', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54866', '54609', '60', '360', '2');  
-- 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('53011', '53011', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('53011', '54203', '4', '4', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('53011', '54289', '4', '2', '2');
-- waypoints for 53011
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=53011;
SET @NPC := 53011;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'-6.3262','-167.7156','-4.5332',0,1,0,100,0),
(@PATH,2,'-11.9886','-144.4640','-4.5332',0,1,0,100,0),
(@PATH,3,'-1.5781','-119.7016','-4.5332',0,1,0,100,0),
(@PATH,4,'23.5109','-105.8123','-4.5332',0,1,0,100,0),
(@PATH,5,'30.1299','-106.9713','-4.2840',0,1,0,100,0),
(@PATH,6,'23.5109','-105.8123','-4.5332',0,1,0,100,0),
(@PATH,7,'-1.5781','-119.7016','-4.5332',0,1,0,100,0),
(@PATH,8,'-11.9886','-144.4640','-4.5332',0,1,0,100,0),
(@PATH,9,'-6.3262','-167.7156','-4.5332',0,1,0,100,0),
(@PATH,10,'14.7810','-199.3200','-4.4825',0,1,0,100,0);
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98203', '98203', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98203', '54215', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98203', '54212', '60', '360', '2');
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54337', '54337', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54337', '54339', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54337', '54381', '60', '360', '2');

--
-- waypoints for 54389
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54389;
SET @NPC := 54389;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'-54.1570','-230.6118','-4.5369',0,0,0,100,0), 
(@PATH,2,'-96.1847','-229.0249','-4.4022',0,0,0,100,0),
(@PATH,3,'-131.6086','-227.0444','-4.1064',0,0,0,100,0),
(@PATH,4,'-153.2215','-278.6024','-4.8326',0,0,0,100,0), 
(@PATH,5,'-145.5415','-307.3332','-4.7787',0,0,0,100,0), 
(@PATH,6,'-153.2215','-278.6024','-4.8326',0,0,0,100,0), 
(@PATH,7,'-131.6086','-227.0444','-4.1064',0,0,0,100,0),
(@PATH,8,'-96.1847','-229.0249','-4.4022',0,0,0,100,0);
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('57013', '57013', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('57013', '54247', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('57013', '54218', '60', '360', '2');
-- linking pat
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54940', '54940', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54940', '54962', '4', '0', '2');
--
-- waypoints for 54940
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54940;
SET @NPC := 54940;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'15.6159','-213.5929','-4.5332',0,1,0,100,0),
(@PATH,2,'69.4439','-256.2760','-4.5127',0,1,0,100,0);
--
-- Update Respawntimer 
UPDATE `creature` SET `spawntimesecs` = '7200' WHERE `guid` IN ('4922530 ','4920659 ','4920764 ','4922558');
UPDATE `creature` SET `id`='17725' WHERE `guid` IN (4922558);
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54211','54211','60','360','2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54211','98208','4','0','2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54211','54293','8','0','2');
--

-- pat wasser 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54291', '54291', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54291', '54292', '4', '0', '2');
-- waypoints for 54291
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54291;
SET @NPC := 54291;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'-19.1250','-229.9605','-4.5345',0,1,0,100,0),
(@PATH,2,'-20.9508','-246.5982','-4.5345',0,1,0,100,0),
(@PATH,3,'-8.0874','-247.3370','-4.5345',0,1,0,100,0),
(@PATH,4,'-5.0299','-233.6673','-4.5345',0,1,0,100,0);
-- pat wand
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54294', '54294', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54294', '54295', '4', '0', '2');
-- waypoints for 54294
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54294;
SET @NPC := 54294;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'-9.3977','-207.5093','-4.5348',0,1,0,100,0), 
(@PATH,2,'-10.3382','-192.7245','-4.5348',0,1,0,100,0), 
(@PATH,3,'-27.4060','-199.7562','-4.5348',0,1,0,100,0),
(@PATH,4,'-19.8416','-210.6138','-4.5348',0,1,0,100,0);
--
-- Linking Big Ones
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98214', '98214', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98214', '98215', '60', '360', '2');
-- 

UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54296;
SET @NPC := 54296;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'61.3535','-286.4179','32.5175',0,0,0,100,0),
(@PATH,2,'31.4342','-297.8602','32.4165',0,0,0,100,0), 
(@PATH,3,'-1.9689','-317.3247','30.8063',0,0,0,100,0),
(@PATH,4,'-31.9453','-337.1885','31.2870',0,0,0,100,0),
(@PATH,5,'-1.9689','-317.3247','30.8063',0,0,0,100,0),
(@PATH,6,'31.4342','-297.8602','32.4165',0,0,0,100,0),
(@PATH,7,'61.3535','-286.4179','32.5175',0,0,0,100,0),
(@PATH,8,'82.3772','-276.9742','32.2350',0,0,0,100,0);
SET @NPC := 54394;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'-27.9396','-383.3765','32.1395',0,0,0,100,0), 
(@PATH,2,'-7.5633','-351.0335','28.7634',0,0,0,100,0),
(@PATH,3,'17.8824','-314.9304','31.8449',0,0,0,100,0),
(@PATH,4,'67.4062','-289.4926','32.3532',0,0,0,100,0),
(@PATH,5,'95.7083','-312.5867','32.6117',0,0,0,100,0),
(@PATH,6,'67.4062','-289.4926','32.3532',0,0,0,100,0),
(@PATH,7,'17.8824','-314.9304','31.8449',0,0,0,100,0),
(@PATH,8,'-7.5633','-351.0335','28.7634',0,0,0,100,0),
(@PATH,9,'-27.9396','-383.3765','32.1395',0,0,0,100,0), 
(@PATH,10,'-39.2647','-387.6842','31.0512',0,0,0,100,0);
--
UPDATE `creature` SET `MovementType`='1',`spawndist`='5' WHERE `guid` IN ('54408');
-- pat unten draußen
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54406', '54406', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54406', '54407', '4', '2', '2');
UPDATE `creature` SET `MovementType`='0' WHERE `guid`=54407;
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54406;
SET @NPC := 54406;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'99.6727','-396.6582','36.6336',0,0,0,100,0),
(@PATH,2,'135.8842','-413.7192','48.6510',0,0,0,100,0),
(@PATH,3,'167.9092','-428.4701','48.1789',0,0,0,100,0),
(@PATH,4,'151.8593','-421.9701','48.4968',0,0,0,100,0),
(@PATH,5,'135.8842','-413.7192','48.6510',0,0,0,100,0),
(@PATH,6,'99.6727','-396.6582','36.6336',0,0,0,100,0),
(@PATH,7,'90.0270','-391.8455','34.2241',0,0,0,100,0);
-- (@PATH,1,'XXXX','YYYY','ZZZZ',0,0,0,100,0),

-- pat unten
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54420', '54420', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54420', '54421', '4', '2', '2');
UPDATE `creature` SET `MovementType`='0' WHERE `guid`=54421;
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54420;
SET @NPC := 54420;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'178.4817','-399.9548','48.1129',0,0,0,100,0),
(@PATH,2,'209.5823','-372.0679','48.4515',0,0,0,100,0),
(@PATH,3,'242.2194','-363.8118','72.2513',0,0,0,100,0),
(@PATH,4,'209.5823','-372.0679','48.4515',0,0,0,100,0),
(@PATH,5,'178.4817','-399.9548','48.1129',0,0,0,100,0),
(@PATH,6,'166.1878','-421.2389','48.1341',0,0,0,100,0),
(@PATH,7,'163.7172','-434.8401','48.1644',0,0,0,100,0),
(@PATH,8,'166.1878','-421.2389','48.1341',0,0,0,100,0),
(@PATH,9,'173.3470','-409.8232','48.1284',0,0,0,100,0);
--
-- Linking Group
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54424', '54424', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54424', '54701', '2', '0', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54424', '54637', '2', '4', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54424', '54700', '4', '2', '2');
-- Leader is moving
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54424;
SET @NPC := 54424;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'203.8385','-381.5525','48.1362',2000,0,0,100,0),  
(@PATH,2,'233.2160','-375.2340','48.1963',2000,0,0,100,0);
--

-- Linking Pat
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54297', '54297', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54297', '54298', '4', '2', '2');
UPDATE `creature` SET `MovementType`='2' WHERE `guid`=54297;
SET @NPC := 54297;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
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,'186.9925','-402.6037','72.4654',0,0,0,100,0),
(@PATH,2,'178.5218','-413.6560','72.4603',0,0,0,100,0),
(@PATH,3,'169.8880','-424.2919','72.4484',0,0,0,100,0),
(@PATH,4,'161.4302','-454.0822','72.4702',0,0,0,100,0), 
(@PATH,5,'169.8880','-424.2919','72.4484',0,0,0,100,0),
(@PATH,6,'178.5218','-413.6560','72.4603',0,0,0,100,0),
(@PATH,7,'186.9925','-402.6037','72.4654',0,0,0,100,0),
(@PATH,8,'213.9510','-385.2624','72.4896',0,0,0,100,0),
(@PATH,9,'251.4497','-372.9180','72.3382',0,0,0,100,0), 
(@PATH,10,'213.9510','-385.2624','72.4896',0,0,0,100,0);
-- (@PATH,2,'XXX','YYY','ZZZ',0,0,0,100,0),

SET @GUID:= 98209;
UPDATE `creature` SET `MovementType`='2', `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid`=@GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'36151 0');
DELETE FROM `waypoint_data` WHERE `id`=@GUID;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@GUID,1,'27.2480','-194.4162','-4.2727',0,1,0,100,0),
(@GUID,2,'56.4067','-171.6072','-3.3128',0,1,0,100,0),
(@GUID,3,'11.1139','-207.1972','-4.5332',0,1,0,100,0),
(@GUID,4,'-3.5688','-205.4432','-4.5332',0,1,0,100,0),
(@GUID,5,'-9.2726','-220.6104','-4.5332',0,1,0,100,0),
(@GUID,6,'14.8130','-222.3226','-4.5332',0,1,0,100,0),
(@GUID,7,'11.1139','-207.1972','-4.5332',0,1,0,100,0);

SET @GUID := 98200;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'36151 0');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (98200, 1, 74.0433, -68.8504, -2.7532, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98200, 2, 29.3908, -30.3243, -2.7497, 0, 1, 0, 100, 0);

SET @GUID := 98211;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'36151 0');
DELETE FROM `waypoint_data` WHERE `id` IN (1316, @GUID);
INSERT INTO `waypoint_data` VALUES (98211, 1, -78.2187, -278.08, -1.29024, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 2, -101.42, -287.156, 1.83909, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 3, -117.784, -281.744, 6.29074, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 4, -114.828, -265.574, 14.1106, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 5, -100.356, -256.529, 24.1543, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 6, -94.5013, -260.984, 23.5905, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 7, -111.209, -322.297, 31.7191, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 8, -92.9906, -259.027, 23.2777, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 9, -104.135, -255.064, 24.1181, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 10, -117.155, -271.564, 9.91377, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 11, -120.779, -289.544, 4.69137, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 12, -100.661, -289.117, 1.68816, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 13, -82.6219, -280.77, -0.527521, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98211, 14, -62.776, -265.349, -4.53726, 0, 1, 0, 100, 0);

SET @GUID := 98225;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` IN (1330, @GUID);
INSERT INTO `waypoint_data` VALUES (98225, 1, 337.392, -369.792, 37.5788, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 2, 340.685, -352.773, 30.5923, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 3, 325.793, -326.49, 19.6275, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 4, 282.261, -299.356, 19.1603, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 5, 270.244, -282.533, 24.1691, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 6, 290.544, -301.37, 18.3725, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 7, 325.27, -324.578, 19.2048, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98225, 8, 336.507, -346.866, 28.18, 0, 0, 0, 100, 0);

SET @GUID := 98234;
UPDATE `creature` SET `MovementType`= 2, `spawndist` = 0 WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'36151 0');
DELETE FROM `waypoint_data` WHERE `id` IN (1329, @GUID);
INSERT INTO `waypoint_data` VALUES (98234, 1, 266.995, -202.99, 28.7592, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98234, 2, 268.777, -256.844, 26.6499, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98234, 3, 268.675, -203.632, 28.8667, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (98234, 4, 249.744, -147.077, 28.5912, 0, 0, 0, 100, 0);

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54703', '54703', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54703', '54799', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54703', '54427', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54703', '55068', '60', '360', '2');
--
-- Linking Group
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('55102', '55102', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('55102', '55106', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('55102', '55391', '60', '360', '2');
--
-- Linking Group
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98222', '98222', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98222', '55552', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98222', '55536', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98222', '55553', '60', '360', '2');
--
-- Linking Group
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98224', '98224', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98224', '98223', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98224', '56109', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('98224', '55903', '60', '360', '2');
--

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56112', '56112', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56112', '54299', '4', '2', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56112', '56142', '4', '4', '2');
--
-- Completing Group vor 3 Boss rechts + Linking

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56316','56316','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56316','56168','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56316', '54300', '60', '360', '2');
--
-- Completing Group vor 3 Boss links + Linking

INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56164','56164','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56164','56145','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('56164', '54301', '60', '360', '2');
UPDATE `creature` SET `position_x`='-8.1499',`position_y`='-292.6946',`position_z`='-18.5731' WHERE `guid` IN ('54248');
UPDATE `creature` SET `position_x`='-43.1317',`position_y`='-313.8300',`position_z`='-18.5057' WHERE `guid` IN ('54249');
UPDATE `creature` SET `position_x`='-63.5895',`position_y`='-310.5407',`position_z`='-18.8755' WHERE `guid` IN ('54250');
-- fish in se water are deadly
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54317','54317','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54317','54405','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54317', '54442', '60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54317', '54487', '60', '360', '2');
-- 
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54249','54249','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54249','54250','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54249','54555','60', '360', '2');
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54248','54248','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54248','54302','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54248','54303','60', '360', '2');
--
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54383','54383','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54383','54385','60', '360', '2');
INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES ('54383','54387','60', '360', '2');
--
--
-- Gameobjects
DELETE FROM `gameobject` WHERE `guid` IN (32634);
INSERT INTO `gameobject` VALUES 
(32634,184941,546,2,74.7062,-252.385,-4.50239,2.04204,0,0,0.85264,0.522499,43200,100,1);