Shattered Halls

[Xadras]

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

---

ToDo:

• https://github.com/Xadras/looking4group-core/commit/380b02e0a17d88003c92eaf648ce0264df6faba7
• Die Gladiatoren der Zerschmetterten Hand (Die Mobs die in den Nischen nach dem Flamegauntlet Event links und rechts stehen) sollten sich von Zeit zu Zeit bekämpfen bis ca. 50% HP oder so. Momentan stehen die einfach nur rum.

---

• [ ] Removed a problematic chest.
• [ ] The "Resist Shadow" spell cast by Shadowmoon Acolyte's in Shattered Halls will now be removed if a player leaves the zone.
• [ ] Shattered Hand Gladiators will no longer break players' stealth when engaged in combat.

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

---

• [ ] The Resist Shadow buff cast by Shadowmoon Acolytes will be dispelled from players if they leave the dungeon. -> Dublicate 2.0.10 xD had to be fixed twice
• [ ] Shattered Hand Reavers will do less damage in Heroic difficulty.
• [ ] The Uppercut used by the Shattered Hand Reaver now has a smaller combat range.
• [ ] Rabid Warhounds on Heroic will now do less damage.
• [ ] Shattered Hand Houndmaster's Impaling bolt damage and movement impairing effects have been increased.
• [ ] Warbringer O'mrogg now applies a smaller amount of threat to the target of his Beatdown ability and will now correctly disable his Burning Maul ability after a wipe.
• [ ] Warbringer O'mrogg and Warchief Kargath Bladefist can be seen from a farther distance.
• [ ] Warchief Kargath Bladefist can now travel slightly farther during Blade Dance.

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

---

• [ ] The melee damage dealt by Shattered Hand Reavers, Shattered Hand Legionnaires, Shattered Hand Heathens, and Rabid Warhounds has been reduced.

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

---

• [ ] If players eat or drink during the gauntlet event, they will no longer stand up every few seconds, but remain eating and drinking until engaged in combat again.

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

[Xadras]

Sources:

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

https://www.youtube.com/watch?v=36c_THaqHwY - Zerschmetterte Hallen [67] https://www.youtube.com/watch?v=Tgok9bDH9N4 - WoW IR-Hellfire Citadel: The Shattered Halls-HD https://www.youtube.com/watch?v=HDGw_41Xz4E https://www.youtube.com/watch?v=vjvPjh9JXn4 https://www.youtube.com/watch?v=VoZpsZwWBkk&t= https://youtu.be/4VFpnpn4_ng?t= https://youtu.be/xxHAYroaxtM?t= https://www.youtube.com/watch?v=yHx_5mHBIj0 https://www.youtube.com/watch?v=z2pZgpA1cjU https://www.youtube.com/watch?v=ilwK9l18Iqg - 33 Minute Shattered Halls Speed Run Part1 https://www.youtube.com/watch?v=yb_MyCRniQw - 33 Minute Shattered Halls Speed Run Part2 https://www.youtube.com/watch?v=4VFpnpn4_ng

http://www.wowhead.com/zone=3714/the-shattered-halls , http://wowwiki.wikia.com/wiki/Shattered_Hand , http://wow.gamepedia.com/Shattered_Hand

• Flamegauntlet http://www.excalibur-nw.com/forum/tracker/issue-3899-shattered-halls-heroic-mode-gauntlet/

[Xadras]

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/613
-- Zerschmetterten Hallen

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

DELETE FROM `creature_ai_texts` WHERE `entry` = -9997;
INSERT INTO `creature_ai_texts` VALUES
(-9997,'Invaders have breached the defenses!','','','Eindringlinge haben unsere Verteidigung durchbrochen!','','','','','',0,1,0,0,'ZH FLame Gauntlet');

DELETE FROM `creature_ai_texts` WHERE `entry` = -768;
INSERT INTO `creature_ai_texts` VALUES
(-768,'You cannot stop us!','','','Ihr könnt uns nicht stoppen!','','','','','',0,1,0,0,'17670');
--
UPDATE `creature_ai_texts` SET `content_default`='goes into a rage after seeing a friend fall in battle!',`content_loc3`='dreht durch, als ein Freund im Kampf fällt!' WHERE `entry` = -550;

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

DELETE FROM `creature` WHERE `guid` IN (16777014,34038);
INSERT INTO `creature` VALUES (34038, 20923, 540, 2, 0, 0, 513.24, 315.927, 1.93557, 3.1429, 86400, 0, 0, 103320, 0, 0, 0);
-- INSERT INTO `creature` VALUES (59476, 17083, 540, 3, 0, 0, 78.1228, 268.416, -13.2074, 3.96182, 7200, 0, 0, 9803, 0, 0, 0);

-- Dublicates 
DELETE FROM `creature` WHERE `guid` IN (15373,15484,15487,15466,15480,15482);
INSERT INTO `creature` VALUES (15373, 2375, 0, 1, 3617, 0, -1108.67, -39.2486, -2.84983, 0.361285, 300, 10, 0, 950, 0, 0, 1);
INSERT INTO `creature` VALUES (15466, 2349, 0, 1, 6808, 0, -285.62, -1156.22, 53.6537, 6.20492, 300, 10, 0, 664, 0, 0, 1);
INSERT INTO `creature` VALUES (15484, 2348, 0, 1, 8014, 0, -781.564, -891.376, 27.1351, 4.64985, 300, 5, 0, 788, 0, 0, 1);
INSERT INTO `creature` VALUES (15487, 2349, 0, 1, 6808, 0, -554.877, -972.102, 43.8503, 0.59589, 300, 10, 0, 664, 0, 0, 1);
INSERT INTO `creature` VALUES (15480, 2350, 0, 1, 1989, 0, -705.869, 388.254, 70.2089, 2.22054, 300, 10, 0, 494, 0, 0, 1);
INSERT INTO `creature` VALUES (15482, 2356, 0, 1, 3201, 0, -583.157, -950.196, 40.9115, 2.38018, 300, 10, 0, 944, 0, 0, 1);

-- added npcs
DELETE FROM `creature` WHERE `guid` IN (3666851,99996,99997,99998,99979,99965,99964,99963,99962,99961,99960,99959,99958,99957,99956,99955,99954,99953,99951,99950,99949,99948,99947,99946,99945,99944,99943,99942,99941,99940,99939,134711);
INSERT INTO `creature` (`guid`,`id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(99996,17462,540,3,77.3463,264.6607,-13.2028,4.0404,7200,0,0),
(99997,17462,540,3,68.6459,271.7706,-13.2043,4.0404,7200,0,0),
(99998,17420,540,3,43.2567,254.2895,-10.9824,1.6006,7200,0,0),
(99979,17462,540,3,379.6138,310.3692,1.9438,3.1254,180,0,0),
(99965,17462,540,3,379.8101,322.5056,1.9440,3.1254,180,0,0),
(99964,17462,540,3,401.9723,323.2708,1.9082,3.1254,180,0,0),
(99963,17462,540,3,402.7467,310.5365,1.9020,3.1254,180,0,0),
(99962,17462,540,3,427.0512,308.9408,1.9322,3.1254,180,0,0),
(99961,17462,540,3,427.2383,320.5103,1.9322,3.1254,180,0,0),
(99960,17462,540,3,458.3092,322.9482,1.9467,3.1254,180,0,0),
(99959,17462,540,3,458.0854,309.1110,1.9467,3.1254,180,0,0),
(99958,17462,540,3,93.1910,246.8917,-13.2047,2.9958,7200,0,0),
(99957,17462,540,3,93.1910,246.8917,-13.2047,2.9958,7200,0,0),
(99956,17462,540,3,93.1910,246.8917,-13.2047,2.9958,7200,0,0),
(99955,17462,540,3,93.1910,246.8917,-13.2047,2.9958,7200,0,0),
(99954,17695,540,3,315.9148,58.2639,1.0244,6.2479,7200,5,1),
(99953,17695,540,3,138.6280,-84.2911,1.9078,6.2700,7200,5,1),
-- 99952 maggi
(99951,17695,540,3,522.0420,103.0975,1.9230,6.2700,7200,5,1),
(99950,17695,540,3,513.5316,101.9586,1.9230,6.2700,7200,5,1),
(99949,17695,540,3,274.4971,317.3325,-0.3597,6.2700,7200,5,1),
(99948,17695,540,3,535.7389,294.3880,1.9401,6.2700,7200,5,1),
(99947,17695,540,3,467.4152,57.9210,1.9360,0.0064,7200,5,1),
(99946,17695,540,3,531.5406,333.6080,2.1095,3.9334,7200,5,1),
(99945,17695,540,3,427.2488,57.6792,2.0958,0.0103,7200,5,1),
(99944,17695,540,3,330.8828,296.9179,1.9263,1.4672,7200,5,1),
(99943,17695,540,3,320.0052,328.7619,1.9297,4.4950,7200,5,1),
(99942,17695,540,3,297.2097,316.2634,1.9170,3.1127,7200,5,1),
(99941,17695,540,3,257.4549,307.2904,-5.4710,4.4046,7200,5,1),
(99940,17695,540,3,517.8952,202.3979,1.9305,1.5851,7200,5,1),
(99939,17695,540,3,518.4773,173.6161,1.9417,1.6165,7200,5,1),
(134711,17670,540,3,518.815,171.06,1.94158,3.09919,7200, 0, 0);

-- =============
-- Pool Templates
-- =============

DELETE FROM `pool_template` WHERE `entry` = 30028;
INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES ('30028','5','Shattared Halls - Shattered Hand Assassin - Pool'); 
DELETE FROM `pool_creature` WHERE `pool_entry` = 30028;
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99941,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99949,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99942,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99943,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99944,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99946,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99948,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99940,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99939,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99947,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99945,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');
INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES (99954,'30028','0','Shattared Halls - Shattered Hand Assassin - Pool');

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

DELETE FROM `item_template` WHERE `entry` IN (18419,21554,12902,13160,22199,29484);
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `Duration`) VALUES
('18419', '2', '1', '-1', 'Monster - Axe, 2H Horde Red War Axe' , '30791', '0', '0', '1', '0', '0', '17', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0'),
('21554', '2', '3', '-1', 'Monster - Gun, PvP Horde' , '34107', '0', '0', '1', '0', '0', '26', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0'),
('12902', '2', '8', '-1', 'Monster - Sword2H, Luminous Evil Blade' , '23405', '0', '0', '1', '0', '0', '17', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0'),
('13160', '2', '8', '-1', 'Monster - Sword2H, Claymore Silver' , '23669', '0', '0', '1', '0', '0', '17', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0'),
('22199', '2', '1', '-1', 'Monster - Axe, 2H Arcanite Reaper' , '34534', '0', '0', '1', '0', '0', '17', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0');
-- ('29484', '2', '5', '-1', 'Monster - Mace2H, Firemaul of Destruction (No Fire)' , '39840', '0', '0', '1', '0', '0', '17', '-1', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3400', '0', '0', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '-1', '0', '-1', '0', '', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '', '0', '0', '0', '0', '0');

-- Shattered Hand Brawler 16593,20582
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662 WHERE `entry` = 16593;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`minhealth`= 27350,`maxhealth`= 27350 WHERE `entry` = 20582;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16593;
INSERT INTO `creature_ai_scripts` VALUES
('1659301','16593','11','0','100','7','0','0','0','0','11','8876','0','0','0','0','0','0','0','0','0','0','Shattered Hand Brawler - Cast Thrash on Spawn'),
('1659302','16593','9','0','100','7','0','5','7000','10000','11','36020','1','32','0','0','0','0','0','0','0','0','Shattered Hand Brawler - Cast Curse of Shattered Hand'),
('1659303','16593','13','0','100','7','9500','9500','0','0','11','36033','1','1','0','0','0','0','0','0','0','0','Shattered Hand Brawler - Cast Kick on Target Spell Casting');

-- Shattered Hand Champion 17671 20584
UPDATE `creature_template` SET `minlevel` = 70, `maxlevel` = 70, `armor` = 6800, `equipment_id`='8019',`mechanic_immune_mask`='346100947',`mindmg`='1337',`maxdmg`='1762' WHERE `entry` = 17671; -- Schwert und Schild orange 509 1040 -- 1,671 - 2,202
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='8019',`mechanic_immune_mask`='346100947',`mindmg`='4673',`maxdmg`='4973' WHERE `entry` = 20584; -- Schwert und Schild orange 2112 2712 -- 4673 4973 -- 9,346 - 9,946
DELETE FROM `creature_equip_template` WHERE `entry` = 8019;
INSERT INTO `creature_equip_template` VALUES
(8019,20029,26283,0,218171138,33490436,0,3,1038,0); -- sword shield
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17671;
INSERT INTO `creature_ai_scripts` VALUES
('1767101','17671','9','0','100','7','0','8','8000','16000','11','32588','1','32','0','0','0','0','0','0','0','0','Shattered Hand Champion - Cast Concussion Blow'),
('1767102','17671','0','0','100','7','2000','4000','5000','8000','11','32587','0','0','0','0','0','0','0','0','0','0','Shattered Hand Champion - Cast Shield Block'),
('1767103','17671','13','0','100','7','5000','10000','0','0','11','11972','1','1','0','0','0','0','0','0','0','0','Shattered Hand Champion - Cast Shield Bash on Target Spell Casting');

-- Shattered Hand Sharpshooter 16704 20594
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='5603',`armor`='6800',`mindmg`=' 1181',`maxdmg`='1610' WHERE `entry` = 16704; -- Tryout Hordegewehr + ? 429 966 -- 1,476 - 2,013
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='5603',`armor`='6800',`mindmg`='3233',`maxdmg`='3393' WHERE `entry` = 20594; -- Tryout Hordegewehr + ? 1871 2270 -- 8,083 - 8,482
DELETE FROM `creature_equip_template` WHERE `entry` = 5603;
INSERT INTO `creature_equip_template` VALUES
(5603,0,0,31747,0,0,33489666,0,0,26);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16704;
INSERT INTO `creature_ai_scripts` VALUES (1670401, 16704, 0, 0, 100, 7, 1000, 1000, 2000, 2000, 21, 1, 0, 0, 40, 1, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Start Movement and Set Melee Weapon Model');
INSERT INTO `creature_ai_scripts` VALUES (1670402, 16704, 9, 0, 100, 3, 5, 30, 2300, 5000, 11, 15620, 1, 0, 40, 2, 0, 0, 21, 0, 0, 0, 'Shattered Hand Sharpshooter (Normal) - Cast Shoot and Set Ranged Weapon Model  and Stop Movement');
INSERT INTO `creature_ai_scripts` VALUES (1670403, 16704, 9, 0, 100, 5, 5, 30, 2300, 5000, 11, 22907, 1, 0, 40, 2, 0, 0, 21, 0, 0, 0, 'Shattered Hand Sharpshooter (Heroic) - Cast Shoot and Set Ranged Weapon Model  and Stop Movement');
INSERT INTO `creature_ai_scripts` VALUES (1670404, 16704, 9, 0, 100, 3, 0, 30, 6000, 9000, 11, 30481, 4, 1, 40, 2, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter (Normal) - Cast Incendiary Shot and Set Ranged Weapon Model  and Stop Movement');
INSERT INTO `creature_ai_scripts` VALUES (1670405, 16704, 9, 0, 100, 5, 0, 30, 6000, 9000, 11, 35945, 4, 1, 40, 2, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter (Heroic) - Cast Incendiary Shotand Set Ranged Weapon Model and Stop Movement');
INSERT INTO `creature_ai_scripts` VALUES (1670406, 16704, 9, 0, 100, 7, 5, 30, 10000, 14000, 11, 37551, 4, 33, 40, 2, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Cast Viper Sting and Set Ranged Weapon Model and Stop Movement');
INSERT INTO `creature_ai_scripts` VALUES (1670407, 16704, 7, 0, 100, 6, 0, 0, 0, 0, 21, 1, 0, 0, 40, 1, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Set Phase to 0 and Set Melee Weapon Model on Evade');
INSERT INTO `creature_ai_scripts` VALUES (1670408, 16704, 0, 0, 100, 7, 5000, 8000, 11000, 12000, 11, 23601, 4, 33, 40, 2, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Cast Random Scatter Shoot and Set Ranged Weapon Model');
INSERT INTO `creature_ai_scripts` VALUES (1670409, 16704, 9, 0, 100, 7, 0, 5, 5000, 5000, 21, 1, 0, 0, 40, 1, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Start Movement and Set Melee Weapon Model Below 5 Yards');
INSERT INTO `creature_ai_scripts` VALUES (1670410, 16704, 9, 0, 100, 7, 6, 40, 5000, 5000, 21, 0, 0, 0, 40, 2, 0, 0, 0, 0, 0, 0, 'Shattered Hand Sharpshooter - Stop Movement and Set Ranged Weapon Model Above 5 Yards');

-- Shattered Hand Houndmaster 17670 20588 
-- equipmodel 3 39059
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='5605',`mindmg`='1226',`maxdmg`='1615' WHERE `entry` = 17670; -- Tryout Rote Armbrust + großer Säbel 1800 -- 467 954 -- 1,532 - 2,019
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='5605',`mindmg`='3230',`maxdmg`='3383' WHERE `entry` = 20588; -- Tryout Rote Armbrust + großer Säbel 1800 -- 1875 2259 -- 8,074 - 8,458
DELETE FROM `creature_equip_template` WHERE `entry` = 5605;
INSERT INTO `creature_equip_template` VALUES
(5605,4788,0,33828,218171138,0,33493506,3,0,26);

-- Shattered Hand Archer 17427 20579
-- equipslot 3 20650
UPDATE `creature` SET `spawntimesecs`= 86400 WHERE `id` = 17427;
UPDATE `creature_template` SET `mindmg`='1007',`maxdmg`='1326',`equipment_id`='5609',`mechanic_immune_mask`='614535379' WHERE `entry` = 17427; -- Schwarzer Bogen + großer Säbel 384 782 -- 1,259 - 1,657
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`armor`='6800',`mindmg`='2324',`maxdmg`='2510',`equipment_id`='5609',`mechanic_immune_mask`='614535379',`minrangedmg`='1000',`maxrangedmg`='2000' WHERE `entry` = 20579; -- Schwarzer Bogen + großer Säbel 1279 1743 -- 1257 1809 -- 5,810 - 6,274
DELETE FROM `creature_equip_template` WHERE `entry` = 5609;
INSERT INTO `creature_equip_template` VALUES
(5609,22081, 0, 20650,33490690,0,50266626,781,0,15);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17427;
INSERT INTO `creature_ai_scripts` VALUES
('1742701','17427','0','0','100','7','1000','1000','3000','3000','21','1','0','0','40','1','0','0','0','0','0','0','Shattered Hand Archer - Start Movement and Set Melee Weapon Model'),
('1742702','17427','4','0','100','6','0','0','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Archer - Start Movement on Aggro'),
('1742703','17427','9','0','100','3','5','30','2300','5000','11','16100','4','0','40','2','0','0','21','0','0','0','Shattered Hand Archer (Normal) - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
('1742704','17427','9','0','100','5','5','30','2300','5000','11','22907','4','0','40','2','0','0','21','0','0','0','Shattered Hand Archer (Heroic) - Cast Shoot and Set Ranged Weapon Model and Stop Movement'),
('1742705','17427','9','0','100','7','5','30','6000','9000','11','30990','4','0','40','2','0','0','21','0','0','0','Shattered Hand Archer - Cast Multi-Shot and Set Ranged Weapon Model and Stop Movement'),
('1742706','17427','9','0','100','3','0','4','0','0','21','1','0','0','40','1','0','0','0','0','0','0','Shattered Hand Archer - Start Movement and Set Melee Weapon Model Below 5 Yards'),
('1742707','17427','9','0','100','6','5','30','0','0','21','0','0','0','40','2','0','0','22','1','0','0','Shattered Hand Archer - Stop Movement and Set Ranged Weapon Model and Set Phase 1 Above 5 Yards (Phase 0)'),
('1742708','17427','7','0','100','6','0','0','0','0','40','1','0','0','21','1','0','0','0','0','0','0','Shattered Hand Archer - Set Melee Weapon Model and Start Movement on Evade');

-- Shattered Hand Scout 17693 20592
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='52',`MovementType`='0',`AIName`='EventAI',`mindmg`='393',`maxdmg`='517' WHERE `entry` = 17693; -- Fakel 120 244
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='52',`MovementType`='0',`mindmg`='1000',`maxdmg`='1500' WHERE `entry` = 20592; -- Fakel 1221 1827
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` = 17693;
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
(1769301,17693,4,0,100,6,0,0,0,0,1,-9997,-9997,-9997,0,0,0,0,0,0,0,0,'Shattered Hand Scout - Yell when Gauntlet begins'); -- sollte eigentlich zum Miniboss laufen und dort Despawnen.

-- Shattered Hand Zealot 17462 20595
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='990',`mindmg`='315',`maxdmg`='414' WHERE `entry` = 17462; -- 1 rotes schwert 96 195
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='990',`mindmg`='1600',`maxdmg`='2400' WHERE `entry` = 20595; -- 1 rotes schwert 1430 2000 -- 1500 2500
DELETE FROM `creature_equip_template` WHERE `entry` = 990;
INSERT INTO `creature_equip_template` VALUES
(990,20502,0,0,33490690,0,0,781,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17462;
INSERT INTO `creature_ai_scripts` VALUES
('1746201','17462','9','0','100','7','0','5','8000','10000','11','30989','1','0','0','0','0','0','0','0','0','0','Shattered Hand Zealot - Cast Hamstring');

-- Shattered Hand Assassin 17695 20580
UPDATE `creature` SET `spawnmask` = 3, `spawntimesecs` = 86400 WHERE `id` = 17695 AND `spawntimesecs` = 7200; -- 7200
UPDATE `creature` SET  WHERE `guid` = 110619;
UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `guid` = 112008;

UPDATE `creature_template` SET `minlevel` = 69, `maxlevel` = 70, `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='518',`armor`='6800',`mindmg`='1054',`maxdmg`='1408' WHERE `entry` = 17695; -- 2 geschwungene dolche 395 837 -- 1,318 - 1,760
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='518',`armor`='7100',`mindmg`='2897',`maxdmg`='3153',`lootid`='17695' WHERE `entry` = 20580; -- 2 geschwungene dolche 1571 2210 -- 7,243 - 7,882
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` = 17695;
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
(1769501,17695,1,0,100,6,0,0,0,0,11,30991,0,3,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Stealth on Spawn'),
(1769502,17695,0,0,100,7,2000,4000,4500,6500,11,30992,1,1,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Backstab'),
(1769503,17695,9,0,100,6,0,30,0,0,11,30980,5,35,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Sap'),
(1769504,17695,0,0,100,7,15000,20000,15000,20000,11,30980,5,35,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Sap IC'),
(1769505,17695,9,0,100,7,0,5,10000,20000,11,30986,1,3,0,0,0,0,0,0,0,0,'Shattered Hand Assassin - Casts Cheap Shot'),
(1769506,17695,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');

-- Shattered Hand Centurion 17465 20583
UPDATE `creature_template` SET `equipment_id`='1481',`mechanic_immune_mask`='614546655',`mindmg`='1337',`maxdmg`='1762',`baseattacktime`='1800' WHERE `entry` = 17465; -- totenschädelaxt 509 1040 -- 1,671 - 2,202
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1481',`mechanic_immune_mask`='614546655',`mindmg`='3454',`maxdmg`='3734',`baseattacktime`='0' WHERE `entry` = 20583; -- totenschädelaxt 1897 2597 -- 8,636 - 9,336
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17465;
INSERT INTO `creature_ai_scripts` VALUES
('1746501','17465','4','0','100','6','0','0','0','0','23','1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion - Set Phase 1 on Aggro'),
('1746502','17465','9','5','100','3','0','5','4000','5000','11','15572','1','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Normal) - Cast Sunder Armor (Phase 1)'),
('1746503','17465','9','5','100','5','0','5','4000','5000','11','16145','1','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Heroic) - Cast Sunder Armor (Phase 1)'),
-- ('1746504','17465','24','5','100','3','15572','5','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Normal) - Set Phase 2 on Target Max Sunder Armor Aura Stack (Phase 1)'),
-- ('1746505','17465','24','5','100','5','16145','5','5000','5000','23','1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Heroic) - Set Phase 2 on Target Max Sunder Armor Aura Stack (Phase 1)'),
-- ('1746506','17465','28','3','100','3','15572','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Normal) - Set Phase 1 on Target Missing Sunder Armor Aura Stack (Phase 2)'),
-- ('1746507','17465','28','3','100','5','16145','1','5000','5000','23','-1','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion (Heroic) - Set Phase 1 on Target Missing Sunder Armor Aura Stack (Phase 2)'),
('1746508','17465','0','0','100','3','50','50','17000','21000','11','30931','0','1','0','0','0','0','0','0','0','0','Shattered Hand Centurion - Cast Battle Shout'),
('1746509','17465','7','0','100','6','0','0','0','0','22','0','0','0','0','0','0','0','0','0','0','0','Shattered Hand Centurion - Set Phase to 0 on Evade');

-- Shattered Hand Gladiator 17464 20586
UPDATE `creature_template` SET `equipment_id`='1375',`mechanic_immune_mask`='0',`mindmg`='1226',`maxdmg`='1615' WHERE `entry` = 17464; -- hordeaxt 467 954 -- 1,532 - 2,019
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1375',`mechanic_immune_mask`='0',`mindmg`='3484',`maxdmg`='3705' WHERE `entry` = 20586; -- hordeaxt 1970 2523 -- 8,709 - 9,262
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17464;
INSERT INTO `creature_ai_scripts` VALUES
('1746401','17464','9','0','100','7','0','5','6000','9000','11','16856','1','0','0','0','0','0','0','0','0','0','Shattered Hand Gladiator - Cast Mortal Strike');

-- Shattered Hand Reaver 16699,20590
UPDATE `creature_template` SET `equipment_id`='1429',`armor`='6800',`mindmg`='738',`maxdmg`='1007',`baseattacktime`='1800',`mechanic_immune_mask`='1' WHERE `entry` = 16699; -- rote wirbelaxt 429 966 1420 -- 1,476 - 2,013
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1429',`armor`='6800',`mindmg`='3470',`maxdmg`='3728',`mechanic_immune_mask`='1089' WHERE `entry` = 20590; -- rote wirbelaxt 1927 2573 -- 8,675 - 9,321
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16699;
INSERT INTO `creature_ai_scripts` VALUES
('1669901','16699','0','0','100','7','8000','12000','5000','9000','11','15496','1','0','0','0','0','0','0','0','0','0','Shattered Hand Reaver - Cast Cleave'),
('1669902','16699','9','0','100','7','0','5','9000','13000','11','30471','1','1','0','0','0','0','0','0','0','0','Shattered Hand Reaver - Cast Uppercut'),
('1669903','16699','2','0','100','7','30','0','120000','120000','11','30485','0','1','1','-106','0','0','0','0','0','0','Shattered Hand Reaver - Cast Enrage at 30% HP');

-- Shattered Hand Heathen 17420,20587
-- dualwield 3.0
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1290',`mindmg`='1056',`maxdmg`='1390' WHERE `entry` = 17420; -- 2 rote 1h schwerter 403 820 -- 1,320 - 1,737
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1290',`armor`='6800',`mindmg`='2718',`maxdmg`='2828',`baseattacktime`='0' WHERE `entry` = 20587; -- 2 rote 1h schwerter 1915 2244 4077 4242 -- 8,154 - 8,483
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17420;
INSERT INTO `creature_ai_scripts` VALUES
('1742001','17420','9','0','100','3','0','5','7000','14000','11','30474','1','0','0','0','0','0','0','0','0','0','Shattered Hand Heathen (Normal) - Cast Bloodthirst'),
('1742002','17420','9','0','100','5','0','5','7000','12000','11','35949','1','0','0','0','0','0','0','0','0','0','Shattered Hand Heathen (Heroic) - Cast Bloodthirst'),
('1742003','17420','2','0','100','7','30','0','120000','120000','11','30485','0','1','1','-106','0','0','0','0','0','0','Shattered Hand Heathen - Cast Enrage at 30% HP'),
(1742004,17420,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Shattered Hand Heathen - Casts Dual Wield on Aggro');

-- Shattered Hand Sentry 16507 20593
UPDATE `creature_template` SET `equipment_id`='5601',`mindmg`='1467',`maxdmg`='1931' WHERE `entry` = 16507; -- nicht ganz 448 912 -- 1,467 - 1,931
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='5601',`armor`='6800',`mindmg`='3448',`maxdmg`='3669' WHERE `entry` = 20593; -- nicht ganz 1948 2500 -- 8,620 - 9,172
DELETE FROM `creature_equip_template` WHERE `entry` = 5601;
INSERT INTO `creature_equip_template` VALUES
(5601,0,18816,0,0,33490436,0,0,1038,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16507;
INSERT INTO `creature_ai_scripts` VALUES
('1650701','16507','4','0','100','2','0','0','0','0','11','22911','1','0','0','0','0','0','0','0','0','0','Shattered Hand Sentry (Normal) - Cast Charge on Aggro'),
('1650702','16507','4','0','100','4','0','0','0','0','11','37511','1','0','0','0','0','0','0','0','0','0','Shattered Hand Sentry (Heroic) - Cast Charge on Aggro'),
('1650703','16507','9','0','100','7','0','5','4000','4000','11','31553','1','0','0','0','0','0','0','0','0','0','Shattered Hand Sentry - Cast Hamstring');

-- Shattered Hand Savage 16523 20591
-- dualwield 3.0
UPDATE `creature_template` SET `equipment_id`='926',`mindmg`='1174',`maxdmg`='1545' WHERE `entry` = 16523; -- 2 äxte 448 912  -- 1,467 - 1,931
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='926',`armor`='6800',`mindmg`='2749',`maxdmg`='2928' WHERE `entry` = 20591; -- 2 äxte 1860 2397 4123 4392 -- 8,246 - 8,783
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16523;
INSERT INTO `creature_ai_scripts` VALUES
('1652301','16523','9','0','100','7','0','5','8000','14000','11','30470','0','0','0','0','0','0','0','0','0','0','Shattered Hand Savage - Cast Slice and Dice'),
('1652302','16523','2','0','100','7','30','0','120000','120000','11','30485','0','1','1','-106','0','0','0','0','0','0','Shattered Hand Savage - Cast Enrage at 30% HP'),
-- für on death muss der spell editiert werden
('1652303','16523','2','0','100','3','15','0','5000','5000','11','36023','1','7','0','0','0','0','0','0','0','0','Shattered Hand Savage (Normal) - Cast Deathblow near Death'),
('1652304','16523','2','0','100','5','15','0','5000','5000','11','36054','1','7','0','0','0','0','0','0','0','0','Shattered Hand Savage (Heroic) - Cast Deathblow near Death'),
(1652305,16523,4,0,100,6,0,0,0,0,11,29651,0,0,0,0,0,0,0,0,0,0,'Shattered Hand Savage - Casts Dual Wield on Aggro');

-- Shattered Hand Legionnaire 16700 20589
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='52',`mindmg`='1314',`maxdmg`='1733',`mechanic_immune_mask`='614544851' WHERE `entry` = 16700; -- Fakel 500 1023 -- 1,643 - 2,166
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='52',`mindmg`='3951',`maxdmg`='4185',`mechanic_immune_mask`='614544851' WHERE `entry` = 20589; -- Fakel 2250 2835 -- 9,877 - 10,462
UPDATE `creature_template` SET `AIName`='EventAI' WHERE `entry` = 16700;
DELETE FROM creature_ai_scripts WHERE `entryOrGUID` = 16700;
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
(1670001,16700,1,0,100,7,1000,1000,240000,240000,11,30472,0,3,0,0,0,0,0,0,0,0,'Shattered Hand Legionnaire - Casts Aura of Discipline OOC'),
(1670002,16700,2,0,100,6,30,0,0,0,11,30485,0,0,1,-46,0,0,0,0,0,0,'Shattered Hand Legionnaire - Casts Enrage at 30% HP'),
(1670003,16700,13,0,100,7,4000,8000,0,0,11,15615,6,1,0,0,0,0,0,0,0,0,'Shattered Hand Legionnaire - Casts Pummel'),
(1670004,16700,4,0,100,6,0,0,0,0,11,30485,0,3,1,-550,0,0,0,0,0,0,'Shattered Hand Legionnaire - Casts Enrage on friendly Death solved with on Aggro'),
(1670005,16700,4,0,100,6,0,0,0,0,11,30472,0,3,0,0,0,0,0,0,0,0,'Shattered Hand Legionnaire - Casts Aura of Discipline on Aggro');

UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662  WHERE `entry` = 16594;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662  WHERE `entry` = 20576;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 16594;
INSERT INTO `creature_ai_scripts` VALUES
('1659401','16594','1','0','100','6','0','0','0','0','21','1','0','0','22','0','0','0','0','0','0','0','Shadowmoon Acolyte - Prevent Combat Movement and Set Phase to 0 on Spawn'),
('1659402','16594','1','0','100','7','1000','1000','3600000','3600000','11','30479','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Cast Resist Shadow on Spawn'),
('1659403','16594','4','0','100','2','0','0','0','0','11','31516','1','0','23','1','0','0','0','0','0','0','Shadowmoon Acolyte (Normal) - Cast Mind Blast and Set Phase 1 on Aggro'),
('1659404','16594','9','13','100','3','0','30','3400','4800','11','31516','1','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Normal) - Cast Mind Blast (Phase 1)'),
('1659405','16594','4','0','100','4','0','0','0','0','11','15587','1','0','23','1','0','0','0','0','0','0','Shadowmoon Acolyte (Heroic) - Cast Mind Blast and Set Phase 1 on Aggro'),
('1659406','16594','9','13','100','5','0','30','3400','4800','11','15587','1','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Heroic) - Cast Mind Blast (Phase 1)'),
('1659407','16594','3','13','100','6','7','0','0','0','21','1','0','0','23','1','0','0','0','0','0','0','Shadowmoon Acolyte - Start Combat Movement and Set Phase 2 when Mana is at 7% (Phase 1)'),
('1659408','16594','9','13','100','6','25','80','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Start Combat Movement at 25 Yards (Phase 1)'),
('1659409','16594','9','13','100','6','5','15','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Prevent Combat Movement at 15 Yards (Phase 1)'),
('1659410','16594','9','13','100','6','0','5','0','0','21','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Start Combat Movement Below 5 Yards'),
('1659411','16594','3','11','100','7','100','15','1000','1000','23','-1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Set Phase 1 when Mana is above 15% (Phase 2)'),
('1659412','16594','14','0','100','3','5000','40','20000','25000','11','35944','6','3','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Normal) - Cast Power Word: Shield'),
('1659413','16594','14','0','100','5','5000','40','20000','25000','11','36052','6','3','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Heroic) - Cast Power Word: Shield'),
('1659414','16594','14','0','100','3','8000','30','7000','7000','11','15585','0','1','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Normal) - Cast Prayer of Healing'),
('1659415','16594','14','0','100','5','8000','30','7000','7000','11','35943','0','1','0','0','0','0','0','0','0','0','Shadowmoon Acolyte (Heroic) - Cast Prayer of Healing'),
('1659416','16594','2','0','100','6','15','0','0','0','22','3','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Set Phase 3 at 15% HP'),
('1659417','16594','2','7','100','6','15','0','0','0','21','1','0','0','25','0','0','0','1','-47','0','0','Shadowmoon Acolyte - Start Combat Movement and Flee at 15% HP (Phase 3)'),
('1659418','16594','7','0','100','6','0','0','0','0','22','1','0','0','0','0','0','0','0','0','0','0','Shadowmoon Acolyte - Set Phase to 0 on Evade');

-- RESEARCH 17694,20577
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662 WHERE `entry` = 17694;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662 WHERE `entry` = 20577;
UPDATE `creature` SET `id`=17694 WHERE `guid` = 57581;
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` IN (1769401,1769408);
UPDATE `creature_ai_scripts` SET `action1_param2`='4',`action1_param3`='33' WHERE `id` = 1769413;

-- Shattered Hand Houndmaster 17670,20588
-- UPDATE `creature_template` SET WHERE `entry` = 17670;
UPDATE `creature_template` SET `mechanic_immune_mask`='379665875' WHERE `entry` = 20588;
UPDATE `creature_ai_scripts` SET `action1_param1`='1' WHERE `id` = 1767001;
UPDATE `creature_ai_scripts` SET `event_param2`='15',`action3_type`='29',`action3_param1`='15',`action3_param2`='360',`comment`='Shattered Hand Houndmaster - Prevent Combat Movement and Prevent Melee at 15 Yards (Phase 1)' WHERE `id` = 1767008;
DELETE FROM `creature_ai_scripts` WHERE `id` = 1767014;
INSERT INTO `creature_ai_scripts` VALUES
('1767014','17670','15','0','100','7','0','30','0','0','11','23859','6','3','1','-768','0','0','0','0','0','0','Shattered Hand Sharpshooter - Cast Despell on CCed Friendlys and Shout');

-- Rabid Warhound 17669,20574
-- http://wow.gamepedia.com/Rabid_Warhound 
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`maxlevel`='68',`maxhealth`='9473',`mindmg`='388',`maxdmg`='509',`mechanic_immune_mask`='1' WHERE `entry` = 17669; -- 119 240 -- 388 - 509
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`rank`='0',`mindmg`='3270',`maxdmg`='3474',`baseattacktime`='0',`mechanic_immune_mask`='1' WHERE `entry` = 20574; -- 1482 1890 -- 6,540 - 6,948
DELETE FROM `creature_template_addon` WHERE `entry` IN (17669,20574);
INSERT INTO `creature_template_addon` VALUES
(17669,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20574,0,0,512,0,4097,0,0,'18950 0 18950 1');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17669;
INSERT INTO `creature_ai_scripts` VALUES
('1766901','17669','9','0','100','7','0','5','4000','6000','11','30639','1','0','0','0','0','0','0','0','0','0','Rabid Warhound - Cast Carnivorous Bite'),
('1766902','17669','0','0','100','3','2000','6000','12000','16000','11','30636','0','1','0','0','0','0','0','0','0','0','Rabid Warhound (Normal) - Cast Furious Howl'),
('1766903','17669','0','0','100','5','2000','4000','10000','12000','11','35942','0','1','0','0','0','0','0','0','0','0','Rabid Warhound (Heroic) - Cast Furious Howl');

-- Creeping Oozeling 17357,20566
UPDATE `creature_template` SET `minhealth`='3200',`speed`='1.48',`mindmg`='158',`maxdmg`='208',`AIName`='EventAI' WHERE `entry` = 17357; -- 48 98 -- 158 - 208
UPDATE `creature_template` SET `minhealth`='4400',`speed`='1.48',`mindmg`='661',`maxdmg`='849',`baseattacktime`='0' WHERE `entry` = 20566; -- 190 566 -- 1,322 - 1,698
DELETE FROM `creature_template_addon` WHERE `entry` IN (17357,20566);
INSERT INTO `creature_template_addon` VALUES
(17357,0,0,512,0,4097,0,0,''),
(20566,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17357;
INSERT INTO `creature_ai_scripts` VALUES
('1735701','17357','0','0','100','7','3000','6000','3800','6500','11','30494','0','0','0','0','0','0','0','0','0','0','Creeping Oozeling - Cast Sticky Ooze');

-- Creeping Ooze 17356,20565
UPDATE `creature_template` SET `mindmg`='1467',`maxdmg`='1931' WHERE `entry` = 17356; -- 448 912 -- 1,467 - 1,931
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='3037',`maxdmg`='3322',`baseattacktime`='0' WHERE `entry` = 20565; -- 1304 1875 -- 6,073 - 6,644
DELETE FROM `creature_template_addon` WHERE `entry` IN (17356,20565);
INSERT INTO `creature_template_addon` VALUES
(17356,0,0,512,0,4097,0,0,''),
(20565,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17356;
INSERT INTO `creature_ai_scripts` VALUES
('1735601','17356','0','0','100','7','3000','6000','3800','6500','11','30494','0','0','0','0','0','0','0','0','0','0','Creeping Ooze - Cast Sticky Ooze');

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

-- Shattered Hand Blood Guard 17461, 20581
UPDATE `creature` SET `position_x` = '513.24', `position_y` = '315.927', `position_z` = '1.93557', `orientation` = '3.1429', `spawntimesecs`= 86400 WHERE `id` = 17461;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`mindmg`='1337',`maxdmg`='1762',`equipment_id`='5607',`mechanic_immune_mask` = 787431423 WHERE `entry` = 17461; -- 509 1040 -- 1,671 - 2,202

-- Blood Guard Porung 20923, 20992, 20993
UPDATE `creature` SET `spawntimesecs`= 86400 WHERE `id` = 20923;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662 WHERE `entry` = 20923;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`ScriptName`='boss_blood_guard_porung',`mechanic_immune_mask`='787431423',`mindmg`='4734',`maxdmg`='4933',`equipment_id`='5607' WHERE `entry` = 20992; -- nicht exakt aber passend rotes 2h schwert -- 6311 6577 -- 9,467 - 9,865
DELETE FROM `creature_equip_template` WHERE `entry` = 5607;
INSERT INTO `creature_equip_template` VALUES
(5607,20195,0,0,218171394,0,0,1,0,0);

-- Grand Warlock Nethekurse 16807,20568
-- Sollte ein anderes kleineres Schwert tragen
UPDATE `creature` SET `position_x`='178.8155', `position_y`='287.1836', `position_z`='-8.1846', `orientation`='4.6464',`spawndist`='0',`movementtype`='0' WHERE `guid` = 13681415;
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1187',`mindmg`='1830',`maxdmg`='2410',`mechanic_immune_mask` = 787431423 WHERE `entry` = 16807; -- 558 1138 rotes 2h schwert -- 1,830 - 2,410 --
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`equipment_id`='1187',`mindmg`='4117',`maxdmg`='4522',`pickpocketloot`='16807',`baseattacktime`='0',`mechanic_immune_mask` = 787431423 WHERE `entry` = 20568; -- 8,233 - 9,043

-- Fel Orc Convert 17083,20567
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`minlevel`='68',`maxlevel`='69',`minhealth`='9803',`maxhealth`='10000',`mindmg`='566',`maxdmg`='745',`baseattacktime`='1400',`mechanic_immune_mask`='1' WHERE `entry` = 17083; -- 173 352 -- 566 - 745
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`minhealth`='13972',`maxhealth`='14000',`mindmg`='1114',`maxdmg`='1324',`baseattacktime`='0',`lootid`='17083',`pickpocketloot`='17083',`mechanic_immune_mask`='1' WHERE `entry` = 20567; -- 400 819 -- 2,228 - 2,647

-- Warbringer O'mrogg 16809,20596
UPDATE `creature_template` SET `mindmg`='1677',`maxdmg`='2210',`speed`='1.00',`mechanic_immune_mask` = 787431423 WHERE `entry` = 16809; -- 638 1305 s1 2h hammer -- 638 1305 -- 2,096 - 2,763
UPDATE `creature_template` SET `mindmg`='5623',`maxdmg`='5936',`pickpocketloot`='16809',`speed`='1.00',`mechanic_immune_mask` = 787431423 WHERE `entry` = 20596; -- 2255 2802 -- 9,841 - 10,388

-- Warchief Kargath Bladefist 16808,20597
-- 2 guids 3666851 5274944 npc flag 2 ? y
UPDATE  `creature` SET `spawnmask`='3',`spawntimesecs`='43200' WHERE `guid` IN ('5274944');
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`mindmg`='1446',`maxdmg`='1906',`baseattacktime`='1000',`mechanic_immune_mask` = 787431423 WHERE `entry` = 16808; -- 550 1125 1464 -- 1,807 - 2,382
UPDATE `creature_template` SET `speed`=1.48,`faction_A`=1662,`faction_H`=1662,`mindmg`='3060',`maxdmg`='3223',`pickpocketloot`='16808',`baseattacktime`='0',`mechanic_immune_mask` = 787431423 WHERE `entry` = 20597; -- 7141 7521 -- 6121 6446 -- 10,711 - 11,281
DELETE FROM `creature_template_addon` WHERE `entry` IN (16808,20597);
INSERT INTO `creature_template_addon` VALUES
(16808,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20597,0,0,512,0,4097,0,0,'18950 0 18950 1');

-- Heathen Guard 17621,20569
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='566',`maxdmg`='746',`equipment_id`='1290',`AIName`='EventAI' WHERE `entry` = 17621; -- 216 440 --  708 - 932
UPDATE `creature_template` SET `mindmg`='1000',`maxdmg`='1763',`armor`='6800',`equipment_id`='1290' WHERE `entry` = 20569; -- 557 1077 -- 3,006 - 3,526
DELETE FROM `creature_template_addon` WHERE `entry` IN (17621,20569);
INSERT INTO `creature_template_addon` VALUES
(17621,0,0,512,0,4097,0,0,''),
(20569,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17621;
INSERT INTO `creature_ai_scripts` VALUES
('1762101','17621','9','0','100','7','0','5','10000','12000','11','30474','1','0','0','0','0','0','0','0','0','0','Heathen Guard - Cast Bloodthirst'),
('1762102','17621','2','0','100','7','30','0','120000','120000','11','30485','0','1','1','-106','0','0','0','0','0','0','Heathen Guard - Cast Enrage at 30% HP');

-- Sharpshooter Guard 17622,20578
-- equipslot 3 31747 polish 17622 ai
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='566',`maxdmg`='746',`minrangedmg`='400',`maxrangedmg`='800',`equipment_id`='5603' WHERE `entry` = 17622; -- 216 440 -- 708 - 932
UPDATE `creature_template` SET `mindmg`='1000',`maxdmg`='1763',`armor`='6800',`minrangedmg`='800',`maxrangedmg`='1600',`equipment_id`='5603' WHERE `entry` = 20578; -- 863 1642 -- 4,620 - 5,399
DELETE FROM `creature_template_addon` WHERE `entry` IN (17622,20578);
INSERT INTO `creature_template_addon` VALUES
(17622,0,0,512,0,4098,0,0,''),
(20578,0,0,512,0,4098,0,0,'');

-- Reaver Guard 17623,20575
UPDATE `creature_template` SET `speed`='1.20',`equipment_id`='1429',`mindmg`='708',`maxdmg`='932',`baseattacktime`='2000' WHERE `entry` = 17623; -- 216 440 --  708 - 932
UPDATE `creature_template` SET `armor`='6800',`mindmg`='2095',`maxdmg`='2495',`equipment_id`='1429' WHERE `entry` = 20575; -- 748 1547 -- 4,190 - 4,989
DELETE FROM `creature_template_addon` WHERE `entry` IN (17623,20575);
INSERT INTO `creature_template_addon` VALUES
(17623,0,0,512,0,4097,0,0,''),
(20575,0,0,512,0,4097,0,0,'');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17623;
INSERT INTO `creature_ai_scripts` VALUES
('1762301','17623','9','0','100','7','0','7','6000','9000','11','15496','1','0','0','0','0','0','0','0','0','0','Shattered Hand Reaver - Cast Cleave'),
('1762302','17623','0','0','100','7','8000','12000','5000','10000','11','30471','1','0','13','-99','1','0','0','0','0','0','Shattered Hand Reaver - Cast Uppercut'),
('1762303','17623','2','0','100','7','30','0','120000','120000','11','30485','0','1','1','-106','0','0','0','0','0','0','Shattered Hand Reaver - Cast Enrage at 30% HP');
-- add rep
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='0',`RewOnKillRepValue2`='0' WHERE `creature_id` IN (17621,17622,17623); -- 2
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='0',`RewOnKillRepValue2`='0' WHERE `creature_id` = 20578; -- 3 20569 nonexistent good
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='0',`RewOnKillRepValue2`='0' WHERE `creature_id` = 20575; -- 4

-- Shattered Hand Executioner 17301,20585
UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`equipment_id`='1429',`armor`='6800',`mindmg`='1476',`maxdmg`='2013',`baseattacktime`='2000',`mechanic_immune_mask`='1073692671',`speed`='1.48',`flags_extra`='65536' WHERE `entry` = 16699; -- rote wirbelaxt 448 912 1420
UPDATE `creature_template` SET `equipment_id`='1429',`armor`='6800',`mindmg`='4338',`maxdmg`='4661',`faction_A`='1662',`faction_H`='1662',`speed`='1.48',`unit_flags`='1',`baseattacktime`='0',`mechanic_immune_mask`='1073692671',`flags_extra`='65536'  WHERE `entry` = 20590; -- rote wirbelaxt 2188 2759 -- 8,675 - 9,321
DELETE FROM `creature_template_addon` WHERE `entry` IN (17301,20585);
INSERT INTO `creature_template_addon` VALUES
(17301,0,0,512,0,4097,0,0,'18950 0 18950 1'),
(20585,0,0,512,0,4097,0,0,'18950 0 18950 1');
INSERT IGNORE INTO `creature_onkill_reputation` VALUES (20585,946,947,7,0,15,7,0,15,1);
INSERT IGNORE INTO `creature_loot_template` VALUES
(17301,22829,80,1,2,8,0,0,0),
(17301,22832,80,2,2,8,0,0,0),
(17301,33457,0,3,1,1,0,0,0),
(17301,33458,0,3,1,1,0,0,0),
(17301,33459,0,3,1,1,0,0,0),
(17301,33460,0,3,1,1,0,0,0),
(17301,33461,0,3,1,1,0,0,0),
(17301,33462,0,3,1,1,0,0,0),
--
(20585,22829,80,1,2,8,0,0,0),
(20585,22832,80,2,2,8,0,0,0),
(20585,33457,0,3,1,1,0,0,0),
(20585,33458,0,3,1,1,0,0,0),
(20585,33459,0,3,1,1,0,0,0),
(20585,33460,0,3,1,1,0,0,0),
(20585,33461,0,3,1,1,0,0,0),
(20585,33462,0,3,1,1,0,0,0);
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 17301;
INSERT INTO `creature_ai_scripts` VALUES
('1730101','17301','9','0','100','7','0','5','5000','7000','11','15284','1','0','0','0','0','0','0','0','0','0','Shattered Hand Executioner - Cast Cleave'),
('1730102','17301','0','0','100','7','4000','8000','8000','12000','11','11876','0','1','0','0','0','0','0','0','0','0','Shattered Hand Executioner - Cast War Stomp');

17289,17290,17292, -- Alliance Sentenced
17295,17296,17297, -- Horde Sentenced

-- Captain Boneshatter
UPDATE `creature_template` SET `faction_A`='1729',`faction_H`='1729' WHERE `entry` = 17296; -- 1668

-- Captain Alina 17290
UPDATE `creature_template` SET `faction_A`='1737',`faction_H`='1737' WHERE `entry` = 17290; -- 1666

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

UPDATE `creature` SET `spawntimesecs` = 30 WHERE `guid` IN (86466,112008,111481);
UPDATE `creature` SET `spawntimesecs`= 7200 WHERE `guid` IN (13590, 13414, 13244, 110619);

-- Rogue Boss Abuse Prevention
UPDATE `creature` SET `position_x`='280.7941', `position_y`='-84.0852', `position_z`='2.1465', `orientation`='3.1313',`spawndist`='5',`movementtype`='1' WHERE `guid` = 112008;
UPDATE `creature` SET `position_x`='319.6404', `position_y`='-84.4010', `position_z`='1.9295', `orientation`='3.1195',`spawndist`='5',`movementtype`='1' WHERE `guid` = 111481;
UPDATE `creature` SET `position_x`='181.4242',`position_y`='-84.2836',`position_z`='2.2300' WHERE `guid` = 86466;
DELETE FROM `creature` WHERE `guid` IN (13403387);
UPDATE `creature` SET `spawnMask`='3',`curhealth`='149420',`curmana`='60581' WHERE `guid` IN (13681415);

-- special npcs + npcs with false values
DELETE FROM `creature_addon` WHERE `guid` IN (18485,18838,18601,18788,18536,57700,57690,13540,11262,15610,57698,57694,15331,57688,57222,57223,57220,57221,163832,163872,163892,163676,163620,34034,34199,99998,20420,30418,31564,13540,32301,13590,24089,62926,62927,62932,99979,99965,99964,99963,99962,99961,99960,99959,85748,85749,85752,85753,11033,11074,113165,113221);

INSERT INTO `creature_addon` VALUES
(34034,0,0,0,3,0,12,0,''),
(34199,0,0,0,3,0,12,0,''),
(99998,0,0,0,3,0,12,0,''),
(18485,0,0,512,0,4098,376,0,''),
(18838,0,0,0,0,4097,375,0,''),
(18601,0,0,512,0,4098,376,0,''),
(18788,0,0,0,0,4097,375,0,''),
(18536,0,0,512,0,4098,376,0,''),
(57700,0,0,512,0,4098,376,0,''),
(57690,0,0,0,0,4097,375,0,''),
(13540,0,0,0,0,4097,0,0,''), -- caster no battle stance
(11262,0,0,512,0,4098,376,0,''),
(15610,0,0,0,0,4097,333,0,''),
(57698,0,0,512,0,4098,376,0,''),
(57694,0,0,0,0,4097,333,0,'30472 0 30472 1'),
(15331,0,0,0,0,4097,333,0,''),
(57688,0,0,0,0,4097,375,0,''),
(57222,0,0,0,0,4097,333,0,''),
(57223,0,0,0,0,4097,333,0,''),
(57220,0,0,0,0,4097,333,0,''),
(57221,0,0,0,0,4097,333,0,''),
(163832,0,0,0,0,4097,333,0,''),
(163872,0,0,0,0,4097,333,0,''),
(163892,0,0,0,0,4097,333,0,''),
(163676,0,0,0,0,4097,333,0,''),
(163620,0,0,0,0,4097,333,0,''),
(62926,0,0,0,0,4097,333,0,''),
(62927,0,0,0,0,4097,333,0,''),
(62932,0,0,0,0,4097,333,0,''),
(99979,0,0,0,0,4097,333,0,''),
(99965,0,0,0,0,4097,333,0,''),
(99964,0,0,0,0,4097,333,0,''),
(99963,0,0,0,0,4097,333,0,''),
(99962,0,0,0,0,4097,333,0,''),
(99961,0,0,0,0,4097,333,0,''),
(99960,0,0,0,0,4097,333,0,''),
(99959,0,0,0,0,4097,333,0,''),
(85748,0,0,0,0,4097,333,0,''),
(85749,0,0,0,0,4097,333,0,''),
(85752,0,0,0,0,4097,333,0,''),
(85753,0,0,0,0,4097,333,0,''),
(11033,0,0,0,0,4097,333,0,''),
(11074,0,0,0,0,4097,333,0,''),
(113165,0,0,0,0,4097,333,0,''),
(113221,0,0,0,0,4097,333,0,'');

UPDATE `creature_addon` SET `auras`='30472 0 30472 1' WHERE `guid` IN (123402, 187294);

UPDATE `creature` SET `spawndist`='10',`MovementType`='1' WHERE `guid` IN (57855);

-- slight movement for rogues
UPDATE `creature` SET `MovementType` = '1',`spawndist`='5' WHERE `guid` IN (112008,111481,110619,13590,13414,13244,15373,15466,86466);
-- adds bei 1 Boss
UPDATE `creature` SET `spawndist`='0',`MovementType`='0',`position_x`='175.5123',`position_y`='274.6477',`position_z`='-13.1881',`orientation`='1.3332' WHERE `guid` = 59478;
UPDATE `creature` SET `spawndist`='0',`MovementType`='0',`position_x`='169.7071',`position_y`='275.8798',`position_z`='-13.1888',`orientation`='1.0819' WHERE `guid` = 59479;
UPDATE `creature` SET `spawndist`='0',`MovementType`='0',`position_x`='181.3458',`position_y`='274.9934',`position_z`='-13.1926',`orientation`='1.7261' WHERE `guid` = 59480;
UPDATE `creature` SET `spawndist`='0',`MovementType`='0',`position_x`='187.4927',`position_y`='275.7191',`position_z`='-13.1879',`orientation`='1.9733' WHERE `guid` = 59481;
DELETE FROM `creature_addon` WHERE `guid` IN (59478,59479,59480,59481);
INSERT INTO `creature_addon` VALUES 
(59478,0,0,0,8,4097,0,0,''),
(59479,0,0,0,8,4097,0,0,''),
(59480,0,0,0,8,4097,0,0,''),
(59481,0,0,0,8,4097,0,0,'');

-- Movement
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 11612;
SET @NPC := 11612;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'30472 0 30472 1'); 
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,513.0515,153.8430,1.9244,0,0,0,100,0),
(@PATH,2,524.3060,152.4040,1.9236,0,0,0,100,0); 

UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 57693;
SET @NPC := 57693;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'30472 0 30472 1'); 
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.9639,1.4408,-13.2116,0,0,0,100,0),
(@PATH,2,60.2413,5.1070,-13.2089,0,0,0,100,0),
(@PATH,3,69.8133,19.0945,-13.2075,0,0,0,100,0),
(@PATH,4,70.0109,32.3430,-13.2046,0,0,0,100,0),
(@PATH,5,69.8133,19.0945,-13.2075,0,0,0,100,0),
(@PATH,6,60.2413,5.1070,-13.2089,0,0,0,100,0),
(@PATH,7,35.9639,1.4408,-13.2116,0,0,0,100,0),
(@PATH,8,24.0561,1.8183,-13.1981,0,0,0,100,0);
--
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 19314;
SET @NPC := 19314;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'30472 0 30472 1'); 
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,76.5898,203.8892,-13.1954,0,0,0,100,0),
(@PATH,2,62.5537,203.8860,-13.1971,0,0,0,100,0);
--
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 57695;
SET @NPC := 57695;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'30472 0 30472 1'); 
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,69.6280,158.9295,-13.2195,0,0,0,100,0),
(@PATH,2,69.7576,174.6510,-13.2070,0,0,0,100,0);
--
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 57696;
SET @NPC := 57696;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,391,0,'30472 0 30472 1'); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,65.2870,268.8684,-13.2005,0,0,0,100,0), 
(@PATH,2,71.7101,263.7010,-13.2009,0,0,0,100,0), 
(@PATH,3,73.2797,265.7437,-13.2013,2700,0,0,100,0),
(@PATH,4,71.7101,263.7010,-13.2009,0,0,0,100,0),
(@PATH,5,78.9588,257.5530,-13.2005,0,0,0,100,0),
(@PATH,6,71.7101,263.7010,-13.2009,0,0,0,100,0),
(@PATH,7,73.2797,265.7437,-13.2013,2700,0,0,100,0),
(@PATH,8,71.7101,263.7010,-13.2009,0,0,0,100,0), 
(@PATH,9,65.2870,268.8684,-13.2005,0,0,0,100,0);
--
-- grp nach gauntlet boss
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 123402;
SET @NPC := 123402; 
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'30472 0 30472 1'); 
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,521.2297,217.6290,1.9231,0,0,0,100,0), 
(@PATH,2,529.8040,226.0390,1.9306,0,0,0,100,0);
--
-- 1st Hundemeisterpat
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 134711;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 136542;
SET @NPC := 136542;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,0,0,0,''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,'1','519.9730','195.1775','1.9408','0','0','0','100','0'),
(@PATH,'2','518.6427','215.8883','1.9158','0','0','0','100','0'),
(@PATH,'3','519.9730','195.1775','1.9408','0','0','0','100','0'),
(@PATH,'4','518.8150','171.0599','1.9415','0','0','0','100','0'),
(@PATH,'5','503.0823','150.0780','1.9316','0','0','0','100','0'),   
(@PATH,'6','511.2404','137.6811','1.9329','0','0','0','100','0'),  
(@PATH,'7','526.5178','137.5205','1.9338','0','0','0','100','0'),    
(@PATH,'8','533.7495','154.7415','1.9302','0','0','0','100','0'),  
(@PATH,'9','518.8150','171.0599','1.9415','0','0','0','100','0');
--
-- 2nd Hundemeisterpat
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 19742;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 19868;
SET @NPC := 19868;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,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','518.9190','68.9030','1.9103','0','0','0','100','0'),    
(@PATH,'2','505.4788','58.5282','1.9274','0','0','0','100','0'),
(@PATH,'3','473.6363','57.6172','1.9303','0','0','0','100','0'),
(@PATH,'4','429.1069','57.5724','2.0470','0','0','0','100','0'), 
(@PATH,'5','473.6363','57.6172','1.9303','0','0','0','100','0'), 
(@PATH,'6','505.4788','58.5282','1.9274','0','0','0','100','0'),   
(@PATH,'7','518.9190','68.9030','1.9103','0','0','0','100','0'),     
(@PATH,'8','518.2490','109.2559','1.9397','0','0','0','100','0');
--
-- 3rd Hundemeisterpat
UPDATE `creature` SET `MovementType`='0' WHERE `guid` = 106659;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 107109;
SET @NPC := 107109;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,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','319.6603','-84.3010','1.9296','0','0','0','100','0'),
(@PATH,'2','364.5243','-84.1685','1.9203','0','0','0','100','0'),    
(@PATH,'3','374.8218','-69.1961','1.9160','0','0','0','100','0'),      
(@PATH,'4','374.4144','-15.9977','1.9386','0','0','0','100','0'),    
(@PATH,'5','374.8218','-69.1961','1.9160','0','0','0','100','0'),     
(@PATH,'6','364.5243','-84.1685','1.9203','0','0','0','100','0'),
(@PATH,'7','319.6603','-84.3010','1.9296','0','0','0','100','0'),
(@PATH,'8','284.3859','-84.4404','2.0522','0','0','0','100','0');
--
-- Späher
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = 107964;
SET @NPC := 107964;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,0,0,4097,0,0,'18950 0 18950 1'); 
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','363.6064','316.2029','1.9181','0','1','0','100','0'),
(@PATH,'2','403.6547','315.8898','1.9170','0','1','0','100','0'),
(@PATH,'3','450.6195','315.6488','1.9353','0','1','0','100','0'),
(@PATH,'4','403.6547','315.8898','1.9170','0','1','0','100','0'),
(@PATH,'5','363.6064','316.2029','1.9181','0','1','0','100','0');
--
-- Add Aura of Discipline to Shattered Hand Legionnaire, Glads fighting but no hp loss
DELETE FROM `creature_template_addon` WHERE `entry` IN (16700,20589,17464,20586);
INSERT INTO `creature_template_addon` VALUES
(16700,0,0,0,0,4097,0,0,'30472 0 30472 1'),
(20589,0,0,0,0,4097,0,0,'30472 0 30472 1'),
(17464,0,0,0,0,4097,389,0,''),
(20586,0,0,0,0,4097,389,0,'');
--
-- Stealth Sight for Warhounds
DELETE FROM `creature_addon` WHERE `guid` IN (19868,19889,107109,107255,136542,136592,63390,63391);
INSERT INTO `creature_addon` VALUES 
(19868,198680,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(19889,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(107109,1071090,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(107255,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(136542,1365420,0,0,0,0,0,0,'18950 0 18950 1'),
(136592,0,0,0,0,0,0,0,'18950 0 18950 1'),
(63390,0,0,16908544,0,4097,0,0,'18950 0 18950 1'),
(63391,0,0,16908544,0,4097,0,0,'18950 0 18950 1');
--
UPDATE `creature` SET `orientation`='0.0037' WHERE `guid` = 62935;
UPDATE `creature` SET `orientation`='0.1170' WHERE `guid` IN (62948,62949);
UPDATE `creature` SET `orientation`='6.2713' WHERE `guid` IN (62938,62941);
--
SET @GUID := 90805;
SET @POINT := 0;
UPDATE `creature` SET `MovementType`='2' WHERE `guid` = @GUID;
-- sewerage
UPDATE `creature` SET `spawntimesecs`='90' WHERE `guid` IN (90805,91716,91731,91744,90996);
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,1,0,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,@POINT := @POINT + '1','122.7454','222.4703','-47.7508',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','123.3319','233.6680','-46.5076',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','125.0957','204.5529','-48.7063',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','135.2930','189.6980','-47.3058',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','161.6374','168.8098','-42.4846',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','135.2930','189.6980','-47.3058',0,1,0,100,0),
(@GUID,@POINT := @POINT + '1','125.0957','204.5529','-48.7063',0,1,0,100,0);
--
-- ======================================================
-- Group Linking
-- ======================================================

DELETE FROM `creature_formations` WHERE `leaderGUID` IN (99954,99953,112008,111481,110619,90805,91716,91731,91744,90996,13681415,59478,59479,59480,59481,136542,3666851,113165,11033,85752,15484,85749,62946,62942,8439,62934,62938,121466,15480,117515,15373,63392,30418,18601,11262,106659,107255,19314,107109,19742,19868,11612,57695,57694,57220,20420,24360,136542,163620,57222,16777014,34038,62871,62872);
DELETE FROM `creature_formations` WHERE `memberGUID` IN (99954,99953,112008,111481,110619,90805,91716,91731,91744,90996,13681415,59478,59479,59480,59481,136542,3666851,113165,11033,85752,15484,85749,62946,62942,8439,62934,62938,121466,15480,62921,117515,15373,63392,30418,18601,11262,106659,107255,19314,107109,19742,19868,11612,57695,57694,57220,20420,24360,136542,163620,57222,16777014,34038,62871,62872);

INSERT INTO `creature_formations` VALUES
(34038,34038,150,360,2),
(34038,62921,150,360,2),
(34038,62871,150,360,2),
(34038,62872,150,360,2);

INSERT INTO `creature_formations` VALUES 
(112008,112008,100,360,1),
(112008,111481,100,360,1),
(112008,110619,100,360,1);

INSERT INTO `creature_formations` VALUES 
(90805,90805,2,100,2),
(90805,91716,2,4,2),
(90805,91731,2,5,2),
(90805,91744,2,1,2),
(90805,90996,2,2,2);

INSERT INTO `creature_formations` VALUES 
(13681415,13681415,60,360,2),
(13681415,59481,60,360,2),
(13681415,59480,60,360,2),
(13681415,59479,60,360,2),
(13681415,59478,60,360,2);

-- INSERT INTO `creature_formations` VALUES
-- (5274944,5274944,1000,360,1),
-- (5274944,99954,1000,360,1),
-- (5274944,99953,1000,360,1);

INSERT INTO `creature_formations` VALUES 
(113165,113165,60,360,2),
(113165,113221,60,360,2);

INSERT INTO `creature_formations` VALUES 
(11033,11033,60,360,2),
(11033,11074,60,360,2);

INSERT INTO `creature_formations` VALUES 
(85752,85752,60,360,2),
(85752,85753,60,360,2);

INSERT INTO `creature_formations` VALUES 
(15484,15484,60,360,2),
(15484,15487,60,360,2);

INSERT INTO `creature_formations` VALUES 
(85749,85749,60,360,2),
(85749,85748,60,360,2);

INSERT INTO `creature_formations` VALUES 
(62946,62946,60,360,2),
(62946,62947,60,360,2),
(62946,62948,60,360,2),
(62946,62949,60,360,2),
(62946,62955,60,360,2);

INSERT INTO `creature_formations` VALUES 
(136542,136542,60,360,2),
(136542,134711,3,1,2),
(136542,136592,3,3,2);

INSERT INTO `creature_formations` VALUES 
(19868,19868,60,360,2),
(19868,19742,3,1,2),
(19868,19889,3,3,2);

INSERT INTO `creature_formations` VALUES 
(107109,107109,60,360,2),
(107109,107255,3,1,2),
(107109,106659,3,3,2);

INSERT INTO `creature_formations` VALUES 
(62942,62942,60,360,2),
(62942,62943,60,360,2),
(62942,62944,60,360,2),
(62942,62945,60,360,2),
(62942,62954,60,360,2);

INSERT INTO `creature_formations` VALUES 
(8439,8439,60,360,2),
(8439,8966,60,360,2),
(8439,7746,60,360,2),
(8439,138404,60,360,2),
(8439,138169,60,360,2),
(8439,11612,60,360,2);

INSERT INTO `creature_formations` VALUES 
(62934,62934,60,360,2),
(62934,62935,60,360,2),
(62934,62936,60,360,2),
(62934,62937,60,360,2),
(62934,62952,60,360,2);

INSERT INTO `creature_formations` VALUES 
(62938,62938,60,360,2),
(62938,62939,60,360,2),
(62938,62940,60,360,2),
(62938,62941,60,360,2),
(62938,62953,60,360,2);

INSERT INTO `creature_formations` VALUES 
(121466,121466,60,360,2),
(121466,121269,60,360,2),
(121466,121724,60,360,2),
(121466,122141,60,360,2),
(121466,122190,60,360,2),
(121466,123402,60,360,2);

INSERT INTO `creature_formations` VALUES 
(15480,15480,60,360,2),
(15480,15482,60,360,2);

INSERT INTO `creature_formations` VALUES 
(117515,117515,60,360,2), -- Leader hinten
(117515,107964,60,360,2), -- Scout
(117515,62927,60,360,2),
(117515,62932,60,360,2),
(117515,62926,60,360,2),
(117515,117489,60,360,2),
(117515,117436,60,360,2),
(117515,117466,60,360,2);

INSERT INTO `creature_formations` VALUES 
(15373,15373,60,360,2),
(15373,15466,60,360,2);

INSERT INTO `creature_formations` VALUES 
(63392,63392,60,360,2),
(63392,63390,60,360,2),
(63392,63391,60,360,2);

INSERT INTO `creature_formations` VALUES 
(30418,30418,60,360,2),
(30418,31564,60,360,2),
(30418,32301,60,360,2),
(30418,99996,60,360,2),
(30418,32163,60,360,2),
(30418,99997,60,360,2),
(30418,57696,60,360,2);

INSERT INTO `creature_formations` VALUES 
(18601,18601,60,360,2),
(18601,18536,60,360,2),
(18601,18788,60,360,2),
(18601,19314,60,360,2),
(18601,18485,60,360,2),
(18601,18838,60,360,2),
(18601,99955,60,360,2);

INSERT INTO `creature_formations` VALUES 
(11262,11262,60,360,2),
(11262,57695,60,360,2),
(11262,13540,60,360,2),
(11262,57690,60,360,2),
(11262,57700,60,360,2),
(11262,99956,60,360,2);

INSERT INTO `creature_formations` VALUES 
(57694,57694,60,360,2),
(57694,57688,60,360,2),
(57694,15331,60,360,2),
(57694,57698,60,360,2),
(57694,15610,60,360,2),
(57694,99957,60,360,2);

INSERT INTO `creature_formations` VALUES 
(57222,57222,60,360,2),
(57222,57223,60,360,2),
(57222,99958,60,360,2);

INSERT INTO `creature_formations` VALUES 
(20420,20420,60,360,2),
(20420,20624,60,360,2),
(20420,21428,60,360,2),
(20420,57584,60,360,2);

INSERT INTO `creature_formations` VALUES 
(24360,24360,60,360,2),
(24360,24089,60,360,2),
(24360,22961,60,360,2),
(24360,57581,60,360,2);

INSERT INTO `creature_formations` VALUES 
(57220,57220,60,360,2),
(57220,57221,60,360,2);

INSERT INTO `creature_formations` VALUES 
(163620,163620,60,360,2),
(163620,163676,60,360,2),
(163620,163892,60,360,2),
(163620,163872,60,360,2),
(163620,163832,60,360,2);

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

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (86466,112008,111481,22961,57698,62871,62872,16777014,34038,62921,15118,15120,15112,15110,99949,99948,15094,15092,117515,117489,117436,117466,107964,62926,62927,62932,99979,99965,99964,99963,99962,99961,99960,99959,99958,99957,99956,99955,99996,99997,99998,99954,99953,99951,99950,99949,99948,99947,99946,99945,99944,99943,99942,99941,99940,99939);
INSERT INTO `creature_linked_respawn` VALUES

(62921, 62921),
(34038, 34038),

(86466,99953),
(112008,99953),
(111481,99953),

(22961,13681415),
(57698,13681415),

(99996,13681415),
(99997,13681415),
(99998,13681415),
(99979,62871),
(99965,62871),
(99964,62871),
(99963,62871),
(99962,62871),
(99961,62871),
(99960,62871),
(99959,62871),
(99958,13681415),
(99957,13681415),
(99956,13681415),
(99955,13681415),
(99954,5274944),
(99953,5274944),
(99951,5274944),
(99950,5274944),

(15118,5274944),
(15120,5274944),
(15112,5274944),
(15110,5274944),
(99949,5274944),
(99948,5274944),
(15094,5274944),
(15092,5274944),
(99947,5274944),
(99946,5274944),
(99945,5274944),
(99944,5274944),
(99943,5274944),
(99942,5274944),
(99941,5274944),
(99940,5274944),
(99939,5274944),

(62926,62871),
(62927,62871),
(62932,62871),

(117489,62871),
(117436,62872),
(117466,62872),
(117515,62871),
(107964,62871);

-- respawn gauntlet
UPDATE `creature` SET `spawntimesecs`='180' WHERE `guid` IN (117515,117489,117436,117466);
UPDATE `creature` SET `spawntimesecs`='180' WHERE `guid` IN (62926,62927,62932,107964);

-- ======================================================
-- Gameobjects
-- ======================================================
--
--
-- ======================================================
-- Miscellaneous
-- ======================================================
--
--
--
--
--
--
-- sleeping orcs, abandoned maybe another time
-- Give Passiv spell as Aura and Remove Aura on Aggro. ;)
-- DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` IN (34034,34199,99998);