Steamvault

[Xadras]

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

---

• [ ] Coilfang Oracles, Coilfang Sirens and Coilfang Sorceresses now have more mana.

• [ ] Coilfang Engineer damage has been increased in Heroic difficulty.

• [ ] Coilfang Engineer Throw Bomb ability damage has been increased and will throw more frequently.

• [ ] Steam Surger damage has been significantly reduced.

• [ ] Tidal Surger damage has been slightly reduced in Heroic difficulty.

• [ ] The Bog Overlord's Trample has been changed to be a 50 yard radius effect, but now does decreased damage and will be used less frequently in both heroic and normal difficulty.

• [ ] Coilfang Siren's Fear now has a 1 second cast time and no longer removes all threat from feared players.

• [x] The 2 Myrmidon, 1 Sorceress, 1 Slavehandler pull has been changed to a 2 Myrmidon pull.

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

---

• [ ] Mekgineer Steamrigger's Main Chambers Access Panel is no longer interactable until Mekgineer Steamrigger has been killed.

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

---

[Xadras]

Sources:

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

https://youtu.be/aBY9jqWbz8Q?t=142 - combat ready state https://www.youtube.com/watch?v=aKc7v8cCUaw https://www.youtube.com/watch?v=L28kubmLJ74 https://www.youtube.com/watch?v=Qgqc-DTCXzo https://www.youtube.com/watch?v=t98Q2HZb8bE https://www.youtube.com/watch?v=OdWQYk6ZK-4 https://youtu.be/3WirTKzw7aA?t=44 https://www.youtube.com/watch?v=yv1UwMJdH0U https://www.youtube.com/watch?v=aBY9jqWbz8Q https://www.youtube.com/watch?v=3WirTKzw7aA https://www.youtube.com/watch?v=HN5qDWmKwn8 https://www.youtube.com/watch?v=1Qc1Cd4izrs https://www.youtube.com/watch?v=RT10-vZHabA https://www.youtube.com/watch?v=xN4Qm3Y0wWM&feature=youtu.be

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

https://www.youtube.com/watch?v=9lOBcbnrKUE - warmane farming?

http://www.wowhead.com/zone=3715/the-steamvault , http://wowwiki.wikia.com/wiki/Steamvault http://wowwiki.wikia.com/wiki/Warlord_Kalithresh

[Xadras]

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/521
-- ==================================
-- Coilfang Reservoir: The Steamvault
-- ==================================

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

UPDATE `creature_ai_texts` SET `content_loc3`='Was ist das?! Haben Mami und Papi Dir nichts beigebracht?' WHERE `entry` = -685; 
UPDATE `creature_ai_texts` SET `content_loc3`='Geht zurück an die Arbeit!' WHERE `entry` = -684; 
UPDATE `creature_ai_texts` SET `content_loc3`='Schrecklich... meine Arme sind durch die ganzen Schläge schon ganz lahm geworden!' WHERE `entry` = -683;
UPDATE `creature_ai_texts` SET `content_loc3`='Slackerband!' WHERE `entry` = -681; 
UPDATE `creature_ai_texts` SET `content_loc3`='Aufwachen! Zurück an die Arbeit!' WHERE `entry` = -680; 
UPDATE `creature_ai_texts` SET `content_loc3`='Beeilt Euch! Je länger Ihr braucht, desto mehr Schläge für Euch!' WHERE `entry` = -679; 
UPDATE `creature_ai_texts` SET `content_loc3`='Helft mir, Sklaven!' WHERE `entry` = -678;

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

-- Coilfang Engineer 17721,20620
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='429' WHERE `entry` = 17721;
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='429',`mindmg`='3792',`maxdmg`='3952' WHERE `entry` = 20620; -- 1332 1572

-- Coilfang Sorceress 17722,20625
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1572' WHERE `entry` = 17722; 
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1572' WHERE `entry` = 20625; 
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17722;
INSERT INTO `creature_ai_scripts` VALUES
('1772201','17722','1','0','100','7','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress - Combat Movement on Spawn'),
('1772202','17722','4','0','100','2','0','0','0','0','11','12675','1','0','23','1','0','0','0','0','0','0','Coilfang Sorceress (Normal) - Cast Frostbolt and Set Phase 1 on Aggro'),
('1772203','17722','9','5','100','3','0','40','2400','3800','11','12675','1','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Normal) - Cast Frostbolt (Phase 1)'),
('1772204','17722','4','0','100','4','0','0','0','0','11','37930','1','0','23','1','0','0','0','0','0','0','Coilfang Sorceress (Heroic) - Cast Frostbolt and Set Phase 1 on Aggro'),
('1772205','17722','9','5','100','5','0','40','2400','3800','11','37930','1','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Heroic) - Cast Frostbolt (Phase 1)'),
('1772206','17722','3','5','100','6','5','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Coilfang Sorceress - Start Combat Movement and Set Phase 2 when Mana is at 5% (Phase 1)'),
('1772207','17722','9','5','100','7','0','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress - Start Combat Movement at 35 Yards (Phase 1)'),
('1772208','17722','3','3','100','7','100','30','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress - Set Phase 1 when Mana is above 30% (Phase 2)'),
('1772209','17722','0','0','100','3','18000','20000','25000','27000','11','31581','1','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Normal) - Cast Blizzard'),
('1772210','17722','0','0','100','5','18000','20000','25000','27000','11','39416','1','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Heroic) - Cast Blizzard'),
('1772211','17722','9','0','100','3','0','6','13000','18000','11','15063','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Normal) - Cast Frost Nova'),
('1772212','17722','9','0','100','5','0','6','13000','18000','11','15531','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress (Heroic) - Cast Frost Nova'),
('1772213','17722','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Coilfang Sorceress - Set Phase to 0 on Evade');

-- Dreghood Slave 17799,20628
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 17799;
UPDATE `creature_template` SET `speed`='1.48',`armor`='7100' WHERE `entry` = 20628;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17799;
INSERT INTO `creature_ai_scripts` VALUES
(1779901,17799,2,0,100,6,30,0,0,0,11,8269,0,0,1,-106,0,0,0,0,0,0,'Dreghood Slave - Casts Enrage at 30% HP');

-- Coilfang Myrmidon 17800,20621
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1020',`mindmg`='762',`maxdmg`='1010', `mechanic_immune_mask` = `mechanic_immune_mask`|1 WHERE `entry` = 17800; -- 467 954 -- 1,532 - 2,019
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1020',`mindmg`='3550',`maxdmg`='3825' WHERE `entry` = 20621; -- 1568 2119 -- 7,099 - 7,650
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17800;
INSERT INTO `creature_ai_scripts` VALUES
('1780001','17800','9','0','100','7','0','5','6000','10000','11','15496','1','0','0','0','0','0','0','0','0','0','Coilfang Myrmidon - Cast Cleave'),
('1780002','17800','12','0','100','6','20','0','0','0','11','7160','1','1','0','0','0','0','0','0','0','0','Coilfang Myrmidon - Cast Execute at 20% Player HP');

-- Coilfang Siren 17801,20623
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='838' WHERE `entry` = 17801; 
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='838',`spell1` = 0, `spell2` = 0, `spell3` = 0 WHERE `entry` = 20623; -- 37856 38660 37664
UPDATE `creature_ai_scripts` SET `action1_param2`='4' WHERE `id` = 1780113;
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (1780101,1780108);

-- Coilfang Warrior 17802,20626
UPDATE `creature_template` SET `maxlevel`='70',`speed`='1.48',`equipment_id` ='940' WHERE `entry` = 17802; 
UPDATE `creature_template` SET `maxlevel`='70',`speed`='1.48',`equipment_id` ='940',`mindmg`='3738',`maxdmg`='3932' WHERE `entry` = 20626; -- 1724 2111 -- 7,476 - 7,863
UPDATE `creature_ai_scripts` SET `event_flags`='6',`action1_param3`='7' WHERE `id` = 1780201;

-- Coilfang Oracle 17803,20622
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='619' WHERE `entry` = 17803;
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='619' WHERE `entry` = 20622; 
UPDATE `creature_ai_scripts` SET `event_param1`='6600' WHERE `id` IN (1780303,1780304);

-- Coilfang Slavemaster 17805,20624
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1571' WHERE `entry` = 17805;
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1571' WHERE `entry` = 20624;

-- Coilfang Water Elemental 17917,20627
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 17917;
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`speed`='1.48',`lootid`='17917' WHERE `entry` = 20627;

-- Naga Distiller 17954,20631
UPDATE `creature_template` SET `armor`='6310',`mindmg`='0',`maxdmg`='0',`attackpower`='0',`baseattacktime`='0',`unit_flags`='33947654',`mechanic_immune_mask`='1073741823' WHERE `entry` = 17954;
UPDATE `creature_template` SET `armor`='6800',`unit_flags`='33947654',`mechanic_immune_mask`='1073741823',`flags_extra`='2' WHERE `entry` = 20631;
DELETE FROM `creature_template_addon` WHERE `entry` IN (17954,20631);
INSERT INTO `creature_template_addon` VALUES
(17954,0,0,16908544,0,4097,0,0,''),
(20631,0,0,16908544,0,4097,0,0,'');

-- Invisible Stalker Coilfang Doors 20926
UPDATE `creature_template` SET `flags_extra` ='128' WHERE entry = 20926;

-- Coilfang Leper 21338,21915
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1731' WHERE `entry` = 21338;
UPDATE `creature_template` SET `speed`='1.48',`equipment_id` ='1731' WHERE `entry` = 21915;
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (2133801,2133809,2133818);

-- Bog Overlord 21694,21914
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2136',`maxdmg`='2816',`baseattacktime`='2000',`mechanic_immune_mask`='1073723391' WHERE `entry` = 21694; -- 2272 3631 -- 4272 - 5631  
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5519',`maxdmg`='6036',`baseattacktime`='0',`skinloot`='80001',`mechanic_immune_mask`='1073723391' WHERE `entry` = 21914; -- 6622 7243 -- 8,278 - 9,054 
DELETE FROM `creature_template_addon` WHERE `entry` IN (21694,21914);
INSERT INTO `creature_template_addon` VALUES
(21694,0,0,0,0,0,0,0,'18950 0 18950 1'), -- b1 = 1
(21914,0,0,0,0,0,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21694;
INSERT INTO `creature_ai_scripts` VALUES
('2169401','21694','11','0','100','2','0','0','0','0','11','37266','0','1','0','0','0','0','0','0','0','0','Bog Overlord (Normal) - Cast Disease Cloud on Spawn'),
('2169402','21694','11','0','100','4','0','0','0','0','11','37863','0','1','0','0','0','0','0','0','0','0','Bog Overlord (Heroic) - Cast Disease Cloud on Spawn'),
('2169403','21694','4','0','100','6','0','0','0','0','23','1','0','0','0','0','0','0','0','0','0','0','Bog Overlord - Set Phase 1 on Aggro'),
('2169404','21694','9','5','100','3','0','5','4000','6000','11','37272','1','0','0','0','0','0','0','0','0','0','Bog Overlord (Normal) - Cast Poison Bolt (Phase 1)'),
('2169405','21694','9','5','100','5','0','5','4000','6000','11','37862','1','0','0','0','0','0','0','0','0','0','Bog Overlord (Heroic) - Cast Poison Bolt (Phase 1)'),
-- ('2169406','21694','24','5','100','3','37272','3','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Normal) - Set Phase 2 on Target Max Poison Bolt Aura Stack (Phase 1)'),
-- ('2169407','21694','24','5','100','5','37862','3','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Heroic) - Set Phase 2 on Target Max Poison Bolt Aura Stack (Phase 1)'),
-- ('2169408','21694','28','3','100','3','37272','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Normal) - Set Phase 1 on Target Missing Poison Bolt Aura Stack (Phase 2)'),
-- ('2169409','21694','28','3','100','5','37862','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Heroic) - Set Phase 1 on Target Missing Poison Bolt Aura Stack (Phase 2)'),
('2169410','21694','0','0','100','7','2000','5000','12000','19000','11','32065','4','33','0','0','0','0','0','0','0','0','Bog Overlord - Cast Fungal Decay'),
('2169411','21694','0','0','100','3','7000','9500','12000','15000','11','40340','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Normal) - Cast Trample'), -- eig nur 40340
('2169412','21694','0','0','100','5','7000','9500','12000','15000','11','40492','0','0','0','0','0','0','0','0','0','0','Bog Overlord (Heroic) - Cast Trample'), -- eig nur 40340
('2169413','21694','2','0','100','6','20','0','0','0','11','8599','0','0','1','-46','0','0','0','0','0','0','Bog Overlord - Cast Enrage at 20% HP'),
('2169414','21694','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Bog Overlord - Set Phase to 0 on Evade');

-- Tidal Surger 21695,21917
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 21695;
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 21917;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 21695;
INSERT INTO `creature_ai_scripts` VALUES
('2169501','21695','0','0','100','7','3000','7000','14000','18000','11','37250','4','0','0','0','0','0','0','0','0','0','Tidal Surger - Cast Water Spout'),
('2169502','21695','9','0','100','7','0','8','12000','17000','11','15531','0','1','0','0','0','0','0','0','0','0','Tidal Surger - Cast Frost Nova');

-- Steam Surger 21696,21916
UPDATE `creature` SET `MovementType` = 0 WHERE `id` = 21696;
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 21696;
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 21916;

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

-- Hydromancer Thespia 17797,20629
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2051',`maxdmg`='2702',`mechanic_immune_mask`='787431423' WHERE `entry` = 17797; -- 625 1276
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3060',`maxdmg`='3762',`pickpocketloot`='17797',`mechanic_immune_mask`='787431423' WHERE `entry` = 20629;
DELETE FROM `creature_template_addon` WHERE `entry` IN (17797,20629);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(17797,0,0x0,0x1,'18950 0 18950 1'),
(20629,0,0x0,0x1,'18950 0 18950 1');
--
-- Mekgineer Steamrigger 17796,20630
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2722',`maxdmg`='3588',`baseattacktime`='1400',`mechanic_immune_mask`='787431423' WHERE `entry` = 17796; -- 829 1695
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4179',`maxdmg`='4603',`baseattacktime`='0',`equipment_id`='0',`pickpocketloot`='17796',`mechanic_immune_mask`='787431423' WHERE `entry` = 20630;
DELETE FROM `creature_template_addon` WHERE `entry` IN (17796,20630);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(17796,0,0x0,0x1,'18950 0 18950 1'),
(20630,0,0x0,0x1,'18950 0 18950 1');

-- By Parmigiana (135 – 0) on 2007/07/18 (Patch 2.1.3)       
-- As of 18/07/2007 these guys have got harder. 13K hp on them and I found TC didn't do much to interrupt their heal on heroic mode.
-- Steamrigger Mechanic 17951,20632 
-- UPDATE `creature_template` SET `minhealth` = , `maxhealth` = WHERE `entry` = 17951;
-- UPDATE `creature_template` SET `minhealth` = , `maxhealth` = WHERE `entry` = 20632;

-- Warlord Kalithresh 17798,20633
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2212',`maxdmg`='2916',`equipment_id` ='1752',`mechanic_immune_mask`='787431423' WHERE `entry` = 17798; -- 674 1378
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5463',`maxdmg`='5683',`equipment_id` ='1752',`pickpocketloot`='17798',`mechanic_immune_mask`='787431423' WHERE `entry` = 20633;
DELETE FROM `creature_template_addon` WHERE `entry` IN (17798,20633);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(17798,0,0x0,0x1,'18950 0 18950 1'),
(20633,0,0x0,0x1,'18950 0 18950 1'); 

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

DELETE FROM `creature` WHERE `guid` IN (12624,306,307,308,299,394,42409,42440,42492);
INSERT INTO `creature` VALUES (306,17801,545,3,0,0,-11.9115,-111.5610,-22.0738,2.7426,7200,0,0,16208,15775,0,0);
INSERT INTO `creature` VALUES (12624,17722,545,3,0,0,0,0,0,0,7200,0,0,22357,15775,0,0);
INSERT INTO `creature` VALUES (307,17721,545,3,0,0,-27.3369,-186.1193,-20.7097,1.2739,7200,0,0,0,0,0,0);
INSERT INTO `creature` VALUES (308,17801,545,3,0,0,6.7600,-258.0846,-21.7040,1.7255,7200,0,0,0,0,0,0);
INSERT INTO `creature` VALUES (299,17802,545,3,0,0,13.5726,-261.4963,-21.7032,2.1731,7200,0,0,0,0,0,0);
INSERT INTO `creature` VALUES (394,17802,545,3,0,0,-82.4439,-255.9031,-11.9954,1.5600,7200,0,0,0,0,0,0);
INSERT INTO `creature` VALUES (42409,17803,545,3,0,0,13.2024,-207.3253,-22.4309,3.7751,7200,0,0,0,0,0,0);   
INSERT INTO `creature` VALUES (42440,17802,545,3,0,0,6.3134,-198.6056,-22.4149,5.9974,7200,0,0,0,0,0,0);
INSERT INTO `creature` VALUES (42492,17802,545,3,0,0,45.3809,-229.7579,-22.6132,3.4003,7200,0,0,0,0,0,0);  

-- ======================================================
-- Group Linking
-- ======================================================

DELETE FROM `creature_formations` WHERE `leaderGUID` IN (2090,2093,3453,12667,12668,12669,12630, 12633, 12635, 12592, 12593, 12585, 12586, 12634, 12608,12609, 12610, 12612,12690,42409,12693,12629,12584,1561,308,299,12709,317,12686,1741,452,12646,12649,12641,12636,12587,12591,12616,12619,12627,1552,118,12663,12626,12624,12625,1723,1561,12679,12680,12681,12682,12683,12700,12684,12701,12702,12703,12695,12688,12696,12704,12694,12697,12698,12699);
DELETE FROM `creature_formations` WHERE `memberGUID` IN (2090,2093,3453,12667,12668,12669,12630, 12633, 12635, 12592, 12593, 12585, 12586, 12634, 12608,12609, 12610, 12612,12690,42409,12693,12629,12584,1561,308,299,12709,317,12686,1741,452,12646,12649,12641,12636,12587,12591,12616,12619,12627,1552,118,12663,12626,12624,12625,1723,1561,12679,12680,12681,12682,12683,12700,12684,12701,12702,12703,12695,12688,12696,12704,12694,12697,12698,12699);
--
-- 12670,12579,12580,12581,12578,12577
-- 12605,12574,12575,12576,3641,12396,6439,116
--
INSERT INTO `creature_formations` VALUES 
(3453,3453,60,360,2),
(3453,2090,60,360,2),
(3453,2093,60,360,2);
--
INSERT INTO `creature_formations` VALUES 
(12697,12697,60,360,2),
(12697,12698,60,360,2),
(12697,12699,60,360,2);
--
INSERT INTO `creature_formations` VALUES 
(12667,12667,60,360,2),
(12667,12668,60,360,2),
(12667,12669,60,360,2);
INSERT INTO `creature_formations` VALUES 
(12690,12690,40,360,2),
(12690,42492,5,2,2),
(12690,12691,5,2,2),
(12690,12676,5,2,2);
INSERT INTO `creature_formations` VALUES 
(42409,42409,40,360,2),
(42409,12678,5,2,2),
(42409,12715,5,2,2),
(42409,42440,5,2,2);
INSERT INTO `creature_formations` VALUES 
(12693,12693,40,360,2),
(12693,12692,5,2,2),
(12693,12705,5,2,2),
(12693,12689,5,4,2);
INSERT INTO `creature_formations` VALUES 
(308,308,40,360,2),
(308,299,5,2,2),
(308,1560,5,2,2),
(308,1557,5,4,2);
INSERT INTO `creature_formations` VALUES 
(317,317,40,360,2),
(317,306,5,1,2);
INSERT INTO `creature_formations` VALUES 
(12709,12709,40,360,2),
(12709,12710,5,2,2),
(12709,12711,5,4,2);
INSERT INTO `creature_formations` VALUES 
(12686,12686,40,360,2),
(12686,12687,5,2,2),
(12686,12716,5,4,2);
INSERT INTO `creature_formations` VALUES 
(1741,1741,40,360,2),
(1741,1742,5,2,2),
(1741,2080,5,4,2);
 INSERT INTO `creature_formations` VALUES 
(452,452,40,360,2),
(452,502,5,2,2),
(452,307,5,2,2),
(452,1550,5,4,2);
INSERT INTO `creature_formations` VALUES 
(118,118,40,360,2),
(118,120,1,360,2);
INSERT INTO `creature_formations` VALUES 
(12624,12624,40,360,2),
(12624,12626,5,1,2),
(12624,12625,5,5,2);
INSERT INTO `creature_formations` VALUES 
(1561,1561,40,360,2),
(1561,394,5,1,2),
(1561,1723,5,5,2);
INSERT INTO `creature_formations` VALUES 
(1552,1552,40,360,2),
(1552,1554,5,1,2);
INSERT INTO `creature_formations` VALUES 
(12679,12679,40,360,2),
(12679,12680,5,1,2),
(12679,12681,5,2,2),
(12679,12682,5,4,2),
(12679,12683,5,5,2);
INSERT INTO `creature_formations` VALUES 
(12700,12700,40,360,2),
(12700,12684,5,1,2),
(12700,12701,5,2,2),
(12700,12702,5,4,2),
(12700,12703,5,5,2);
INSERT INTO `creature_formations` VALUES 
(12695,12695,40,360,2),
(12695,12688,5,1,2),
(12695,12696,5,2,2),
(12695,12704,5,4,2),
(12695,12694,5,5,2);
INSERT INTO `creature_formations` VALUES 
(12663,12663,40,360,2),
(12663,12661,40,360,2),
(12663,12662,40,360,2),
(12663,12660,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12627,12627,40,360,2),
(12627,12628,40,360,2),
(12627,12631,40,360,2),
(12627,12632,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12619,12619,40,360,2),
(12619,12620,40,360,2),
(12619,12621,40,360,2),
(12619,12622,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12616,12616,40,360,2),
(12616,12618,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12629,12629,40,360,2),
(12629,12591,40,360,2),
(12629,12630,40,360,2),
(12629,12633,40,360,2),
(12629,12635,40,360,2),
(12629,12592,40,360,2),
(12629,12593,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12584,12584,40,360,2),
(12584,12587,40,360,2),
(12584,12585,40,360,2),
(12584,12586,40,360,2),
(12584,12634,40,360,2),
(12584,12608,40,360,2),
(12584,12609,40,360,2),
(12584,12610,40,360,2),
(12584,12612,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12636,12636,40,360,2),
(12636,12637,40,360,2),
(12636,12638,40,360,2),
(12636,12615,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12641,12641,40,360,2),
(12641,12642,40,360,2),
(12641,12643,40,360,2),
(12641,12614,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12649,12649,40,360,2),
(12649,12650,40,360,2),
(12649,12651,40,360,2),
(12649,12652,40,360,2);
INSERT INTO `creature_formations` VALUES 
(12646,12646,40,360,2),
(12646,12647,40,360,2),
(12646,12648,40,360,2),
(12646,12653,40,360,2);

-- ======================================================
-- Respawn Linking
-- ======================================================

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (12624,12625,12626,306,317,2093,2090,307,1550,502,452,308,1560,1557,299,394,1561,1723,42409,12678,12715,42440,42492,12691,12690,12676,118,120);
INSERT INTO `creature_linked_respawn` VALUES
(12624,12613),
(12625,12613),
(12626,12613),
(306,3453),
(317,3453),
(2093,3453),
(2090,3453),
(307,3453),
(1550,3453),
(502,3453),
(452,3453),
(308,3453),
(1560,3453),
(1557,3453),
(299,3453),
(394,12613),
(1561,12613),
(1723,12613),
(42409,3453),
(12678,3453),
(12715,3453),
(42440,3453),
(42492,3453),
(12691,3453),
(12690,3453),
(12676,3453),
(118,3453),
(120,3453);

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

SET @GUID := 12679;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12679, 1, 22.672, -223.202, -22.536, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12679, 2, 39.0578, -210.222, -22.6133, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12679, 3, 22.1297, -224.366, -22.5328, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12679, 4, 8.45932, -247.386, -23.3366, 0, 0, 0, 0, 0);

SET @GUID := 12695;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12695, 1, 27.0136, -145.039, -22.3968, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12695, 2, 18.9726, -161.946, -22.438, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12695, 3, 26.7279, -177.709, -22.3997, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12695, 4, 18.9726, -161.946, -22.438, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12695, 5, 30.8925, -138.629, -22.5491, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12695, 6, 57.7822, -114.87, -22.6239, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12695, 7, 38.5541, -130.114, -22.6439, 0, 0, 0, 0, 0);

SET @GUID := 12700;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
DELETE FROM `creature_addon` WHERE `guid` = @GUID;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@GUID,@GUID,0,0,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12700, 1, 13.0123, -180.845, -22.3747, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 2, 17.6451, -189.086, -22.4312, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 3, 29.465, -208.979, -22.5932, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 4, 17.0985, -188.306, -22.4238, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 5, 9.53988, -180.075, -22.4403, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 6, -7.20501, -173.28, -23.2732, 0, 0, 0, 0, 0);
INSERT INTO `waypoint_data` VALUES (12700, 7, 2.36385, -176.577, -22.3011, 0, 0, 0, 0, 0);

UPDATE `creature` SET `position_x`='-82.3836',`position_y`='-371.1122',`position_z`='-7.7673',`orientation`='1.5882',`MovementType`='0',`id`='17722' WHERE `guid` = 12624;
UPDATE `creature` SET `position_x`='-91.6113',`position_y`='-372.0186',`position_z`='-7.7673',`orientation`='1.6235',`MovementType`='0',`id`='17800' WHERE `guid` = 12626;
UPDATE `creature` SET `position_x`='-100.3674',`position_y`='-372.1709',`position_z`='-7.7673',`orientation`='1.5882',`MovementType`='0' WHERE `guid` = 12625;
UPDATE `creature` SET `position_x`='-53.7041',`position_y`='-390.5220',`position_z`='-7.7683',`orientation`='3.6458',`MovementType`='0' WHERE `guid` = 12660;
UPDATE `creature` SET `position_x`='-12.3939',`position_y`='-378.7253',`position_z`='-7.7685',`orientation`='6.0099',`MovementType`='0' WHERE `guid` = 12662;
UPDATE `creature` SET `position_x`='-18.3115',`position_y`='-129.3071',`position_z`='-22.1619',`orientation`='4.4941',`MovementType`='0' WHERE `guid` = 12686;
UPDATE `creature` SET `position_x`='-3.6617',`position_y`='-132.7701',`position_z`='-21.1049',`orientation`='4.4548',`MovementType`='0' WHERE `guid` = 12687;
UPDATE `creature` SET `position_x`='58.5484',`position_y`='-127.0172',`position_z`='-22.7188',`orientation`='2.7068',`MovementType`='0' WHERE `guid` = 12710;
UPDATE `creature` SET `position_x`='60.2239',`position_y`='-121.2375',`position_z`='-22.6504',`orientation`='2.7068',`MovementType`='0' WHERE `guid` = 12711;
UPDATE `creature` SET `position_x`='-327.4291',`position_y`='-112,0949',`position_z`='-7,7555',`orientation`='3,2950',`MovementType`='0' WHERE `guid` = 12607;

UPDATE `creature` SET `id`='17802',`position_x`='-19.2700',`position_y`='-122.4256',`position_z`='-22.2596',`orientation`='6.1316',`MovementType`='2' WHERE `guid` = 12716;
UPDATE `creature` SET `spawndist`='5' WHERE `id` = 21338;
UPDATE `creature` SET `MovementType`='2' WHERE `guid`  IN (1741,1550,299,1561,12587,12591,42440,42492);
UPDATE `creature` SET `MovementType`='0' WHERE `guid` IN (1723,118,120,394,12621,12641,12642,12616,12618,1554,1552,12622,12636,12646,12649,12661,12668,12694,12703);
UPDATE `creature` SET `orientation`='2.5716',`MovementType`='0' WHERE `guid` IN (12628,12632,12631);

DELETE FROM `creature_addon` WHERE `guid` IN (307,12716,12686,12687,12715,12678,452,12709,12677,12676,12691,12660,12662);
INSERT INTO `creature_addon` VALUES 
(307,0,0,0,0,1,173,0,''),
(12716,0,0,0,0,1,173,0,''),
(12686,0,0,0,0,1,173,0,''),
(12687,0,0,0,0,1,173,0,''),
(12715,0,0,0,0,1,173,0,''),
(12678,0,0,0,0,1,173,0,''),
(452,0,0,0,0,1,173,0,''),
(12709,0,0,0,0,1,173,0,''),
(12677,0,0,0,0,1,173,0,''),
(12676,0,0,0,0,1,173,0,''),
(12691,0,0,0,0,1,173,0,''),
(12660,0,0,0,0,1,173,0,''),
(12662,0,0,0,0,1,173,0,'');

UPDATE `creature_addon` SET `bytes0`='0',`emote`='0' WHERE `guid` = 394;

DELETE FROM `creature_addon` WHERE `guid` IN (12624,12625,12626);
DELETE FROM `creature_addon` WHERE `path_id` IN (1723,394,1561);
DELETE FROM `waypoint_data` WHERE `id` IN ('1723991','3940','15610');

DELETE FROM `waypoint_data` WHERE `id` IN (126240,126250,126260);
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 12624;
SET @NPC := 12624;
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,0,0,1,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,-91.3785,-333.8914,-7.7673,0,0,0,0,0),
(@PATH,2,-89.9023,-288.1805,-7.7673,0,0,0,0,0),
(@PATH,3,-91.3785,-333.8914,-7.7673,0,0,0,0,0),
(@PATH,4,-92.2922,-377.9305,-7.7673,0,0,0,0,0); 

SET @NPC := 1741;
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,0,0,1,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,35.5512,-299.6387,-10.2368,0,0,0,0,0),
(@PATH,2,30.4756,-287.1654,-16.2907,0,0,0,0,0),
(@PATH,3,28.2474,-270.8317,-22.7606,0,0,0,0,0),
(@PATH,4,30.4756,-287.1654,-16.2907,0,0,0,0,0),
(@PATH,5,35.5512,-299.6387,-10.2368,0,0,0,0,0),
(@PATH,6,50.7598,-307.0406,-8.2670,0,0,0,0,0);

SET @NPC := 12716;
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,0,0,1,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,-0.0599,-127.2395,-20.0795,0,0,0,0,0),
(@PATH,2,-19.7878,-121.7839,-22.2396,0,0,0,0,0);

SET @NPC := 1550;
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,0,0,1,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,-12.9851,-189.2772,-22.7799,0,0,0,0,0),
(@PATH,2,-7.0073,-181.1557,-23.4808,0,0,0,0,0),
(@PATH,3,-12.9851,-189.2772,-22.7799,0,0,0,0,0),
(@PATH,4,-30.1536,-190.2982,-20.3857,0,0,0,0,0);

SET @NPC := 42492;
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,0,0,1,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,25.3680,-235.2199,-22.5675,0,0,0,0,0),
(@PATH,2,45.3809,-229.7579,-22.6131,0,0,0,0,0);

SET @NPC := 42440;
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,0,0,1,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,18.5333,-204.9412,-22.3882,0,0,0,0,0),
(@PATH,2,20.1530,-212.7591,-22.5006,0,0,0,0,0), 
(@PATH,3,18.5333,-204.9412,-22.3882,0,0,0,0,0),
(@PATH,4,6.3134,-198.6056,-22.4149,0,0,0,0,0);

SET @NPC := 299;
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,0,0,1,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,4.0809,-241.2227,-21.9188,0,0,0,0,0),
(@PATH,2,12.8337,-256.1345,-21.8768,0,0,0,0,0);

SET @NPC := 1561;
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,0,0,1,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,-78.2618,-233.3967,-19.0738,0,0,0,0,0),  
(@PATH,2,-62.7014,-220.6495,-18.5730,0,0,0,0,0),
(@PATH,3,-46.1952,-214.9539,-18.5513,5000,0,0,0,0),
(@PATH,4,-62.7014,-220.6495,-18.5730,0,0,0,0,0),
(@PATH,5,-78.2618,-233.3967,-19.0738,0,0,0,0,0),  
(@PATH,6,-90.4510,-257.7790,-11.7885,0,0,0,0,0),
(@PATH,7,-90.4720,-265.1724,-9.5625,0,0,0,0,0),
(@PATH,8,-91.9829,-255.4900,-12.5682,0,0,0,0,0); 

SET @NPC := 12587;
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,0,0,1,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,-234.9901,-204.9100,-8.0766,0,0,0,0,0), 
(@PATH,2,-235.0330,-198.5261,-8.0272,0,0,0,0,0),
(@PATH,3,-234.9901,-204.9100,-8.0766,0,0,0,0,0), 
(@PATH,4,-233.7279,-235.8910,-7.9739,0,0,0,0,0),
(@PATH,5,-229.2011,-248.5270,-7.8836,0,0,0,0,0),
(@PATH,6,-217.7293,-255.9783,-7.9923,0,0,0,0,0),
(@PATH,7,-207.1499,-258.4804,-8.0811,5000,0,0,0,0),
(@PATH,8,-217.7293,-255.9783,-7.9923,0,0,0,0,0),
(@PATH,9,-229.2011,-248.5270,-7.8836,0,0,0,0,0),
(@PATH,10,-233.7279,-235.8910,-7.9739,0,0,0,0,0);

SET @NPC := 12591;
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,0,0,1,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,-228.8183,-264.3383,-7.8840,5000,0,0,0,0),
(@PATH,2,-213.3816,-267.5317,-8.0438,5000,0,0,0,0);

UPDATE `creature_addon` SET `path_id` = 317 WHERE `guid` = 317;
DELETE FROM `waypoint_data` WHERE `id` = 317;
INSERT INTO `waypoint_data` VALUES (317, 1, 13.542, -115.249, -22.0705, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (317, 2, -32.8072, -95.2656, -21.5533, 0, 0, 0, 100, 0);

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

-- chest respawn in sv
UPDATE `gameobject` SET `spawntimesecs`='43200' WHERE `guid` IN (32635,32636,32710);

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