Black Temple

[Xadras]

Complete Raid Overhaul for Black Temple with Focus on Complete Groups, AIs, NPC-Values, Linking, Movement, Immunities, Visuals and Texts.

---

ToDo:

• Gurtok oneshot issue
• http://wiki.eternal-wow.com/index.php/Black_Temple
• https://bitbucket.org/looking4group_b2tbc/hellground-wowemu/commits/1965c6cfa72e08c142ddfe048f9ccebdb650f81d
• https://redmine.rising-gods.de/issues/7087

---

• [ ] It is no longer possible to engage the Shade of Akama without completing phase 1 of the encounter.
• [ ] Ashtongue Spiritbinders may now cast heals on Ashtongue Sorcerors, Channelers, and the Shade of Akama.
• [ ] The Illidan Stormrage fight encounter has received additional tuning and improvements.

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

---

• [ ] Saber Lash tanks will no longer be knocked back by Sinister Beam or hit by Fatal Attraction, even if they dodge or parry the attack.
• [ ] Mother Shahraz will now pick a new beam to cast after every 3rd beam instead of after every 5th. This means she is much less likely to cast the same beam many times in a row.
• [ ] Fatal Attraction now deals 750 damage on the first tick, 1500 on the second, 2250 on the third, and 3000 on all subsequent ticks.
• [ ] Prismatic Shield is now more fun. Specifically, Mother Shahraz now takes bonus damage from one school when she is resistant to its opposite. Her resistances now change randomly every 15 seconds and are capped at 25%.

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

---

• [ ] The traps laid during the Illidan Stormrage encounter are no longer activated by clicking

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

---

• [ ] High Nethermancer Zerevor's Blizzard and Flamestrike will now last their full duration.

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

---

• [ ] The size of Supremus in Black Temple has increased significantly. Also, the hitbox of Supremus has been reduced significantly.

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

---

• [ ] Illidan will no longer despawn if a raid group wipes during his death speech.

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

[Xadras]

Sources:

http://wowwiki.wikia.com/wiki/Armor?file=Armor.JPG

http://wowwiki.wikia.com/wiki/Black_Temple , http://wow.gamepedia.com/Black_Temple , http://www.wowhead.com/zone=3959/black-temple

https://wow.gamepedia.com/index.php?title=Bonechewer_Brawler&oldid=2877736 https://wow.gamepedia.com/index.php?title=Bonechewer_Combatant&oldid=2877738

https://wowwiki.fandom.com/wiki/Black_Temple?oldid=902546 - adding trash textes

---

evaluate:

https://www.youtube.com/watch?v=pCXVD3flJ1I - Trash Skips

---

https://www.youtube.com/watch?v=lf2GUJBNPkA&feature=youtu.be - dragon turtle https://www.youtube.com/watch?v=EyYPl1-HVdY&feature=youtu.be - coilskar harpooner https://www.youtube.com/watch?v=vvzFCqD0lpY&feature=youtu.be - aqueous surger https://www.youtube.com/watch?v=wiUjM81pXog&feature=youtu.be - coilskar sea caller

https://www.youtube.com/watch?v=jzRjJzp_W0E&feature=youtu.be&t=149 - Last Resort vs Supremus by k3rp

https://www.youtube.com/watch?v=9A78vBofREg - Black Temple - Supremus - Fire mage POV

https://www.youtube.com/watch?v=GGGe8Z2SkiY - Bt Trash Farming

https://www.youtube.com/watch?v=ZilAbTe2VPQ - Black Temple complete solo run https://www.youtube.com/watch?v=NeMq-LlX_Cs

https://www.youtube.com/watch?v=FMgtWKm-rPI

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

https://www.youtube.com/playlist?list=PLbuIC74GtjJa6uJoGr8F550sMrJmp5Hnz - WoW Black Temple Trash 2.4.3

https://www.youtube.com/watch?v=lYns6mfWH0M - Shadow priest farms Black temple

https://www.youtube.com/watch?v=lnbZ19c1ers - Sp soloing the black temple trash mobs

https://www.youtube.com/watch?v=iDBfjnCaZqY - The Black Temple - All fights Including Illidan Stormrage!

https://www.youtube.com/watch?v=0C2kGDKl-AM - 4 Player in Black Temple

https://www.youtube.com/watch?v=FMgtWKm-rPI - Black Temple solo Farm Run (Pre WotLK)

https://www.youtube.com/watch?v=45m4JXPxJQY - Lost Chapter vs. The Black Temple

https://www.youtube.com/watch?v=4COPnTfCXqU - solo black temple trash

https://www.youtube.com/watch?v=WHv6h9pJWrE - BlackTemple raid and org raid

https://www.youtube.com/watch?v=y8eZYbicz5g - Black Temple Trash - Warlock Solo

https://www.youtube.com/watch?v=gDe9U7RNhs4 - Black Temple Trash Solo Level 70 (1 of 2)

https://www.youtube.com/watch?v=OwyXpU5Vif0 - Black Temple Trash Solo Level 70 (2 of 2)

https://www.youtube.com/watch?v=xMjlE3bwVIQ - black temple, najentus et supremus by kael horde

https://www.youtube.com/watch?v=rprrRaigXoQ - Core Fusion Supremus Trash Walkthrough

https://www.youtube.com/watch?v=nk_myIG6XAA - BT - Trash jusqu'à Akama

https://youtu.be/t7c5nBgPE5k?t=41s - Teron Gorefiend - Aggro Range

https://www.youtube.com/watch?v=yheB8xKMNbI - Oberster Kriegsfürst Naj'entus

https://www.youtube.com/watch?v=SEfPONwcjNk - Akama

https://www.youtube.com/watch?v=1MmuJDUmqoA - Teron Mechanic

https://www.youtube.com/watch?v=RrLotzyzq4Y&feature=youtu.be - In Excelsis vs IllidariCoul

---

http://wowwiki.wikia.com/wiki/Patch_2.1.2 , http://wowwiki.wikia.com/wiki/Essence_of_Anger_(mob)

[Xadras]

-- https://github.com/Looking4Group/L4G_Core/issues/634
-- http://hellfire-tbc.com/hellfire2/forums/showthread.php?tid=2477

-- ============
-- Black Temple
-- ============

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

DELETE FROM `creature` WHERE `guid` IN (53823,53926,53929,53948,240957,240995,241085,241141,242681,242745);
DELETE FROM `creature` WHERE `guid` IN (246422,246423);
INSERT INTO `creature` VALUES (246422, 23374, 564, 1, 0, 0, 631.877258, 251.739273, 112.665802, 3.0788, 7200, 0, 0, 215979, 0, 0, 0);
INSERT INTO `creature` VALUES (246423, 23374, 564, 1, 0, 0, 774.256470, 250.553162, 112.735138, 0.1076, 7200, 0, 0, 215979, 0, 0, 0);

-- free 52466 52467 52468 52469 52470 52478 53802 53803 53804 53805 53806 53807 53808 53810 53811 53812 53813 53814 53823 53919 53920 53921 53922 53923 53924 53925 53926 53927 53928 53929 53939 53940 53944 53945 53946 53947 53948 53949 53950 53952 53956 53974 53975 53976 53977 53978 

-- unused
-- INSERT INTO `creature` VALUES (52466, XXX, 564, 1, 0, 0, XXX, YYY, ZZZ, OOO, 7200, 0, 0, 0, 0, 0, 0);
-- INSERT INTO `creature` VALUES (52467, XXX, 564, 1, 0, 0, XXX, YYY, ZZZ, OOO, 7200, 0, 0, 0, 0, 0, 0);

-- already 2 with lower guid, but pos looks better on these.
-- INSERT INTO `creature` VALUES (52502, 23448, 564, 1, 0, 0, 678.06, 285.22, 354.325, 3.29867, 3600, 0, 0, 3079, 0, 0, 0);
-- INSERT INTO `creature` VALUES (52503, 23448, 564, 1, 0, 0, 676.226, 325.231, 354.319, 3.12414, 3600, 0, 0, 3079, 0, 0, 0);

DELETE FROM `creature` WHERE `guid` IN (12850,16202,12754,12841,12758,12776,12814,12819,12886,39926,39928,40233,40243,40244,40407,42920,52461,52484,52754,52768,52769,52846,53054,53211,53212,53796,53797,53798,53799,53800,53801,53821,53827,53828,53829,53831,53907,53909,53915,126600,244331,245098,16777200,16777194,16777195);

INSERT INTO `creature` VALUES (12754, 22881, 564, 1, 0, 0, 451.222992, 808.208008, 12.127271, 3.909540, 7200, 0, 0, 104000, 0, 0, 0);
INSERT INTO `creature` VALUES (12841, 22881, 564, 1, 0, 0, 436.329010, 793.070007, 12.044035, 0.837758, 7200, 0, 0, 104000, 0, 0, 0);

INSERT INTO `creature` VALUES (12758, 23339, 564, 1, 0, 517, 723.369, 430.184, 112.739, 1.6717, 3600, 0, 0, 215430, 0, 0, 0);
INSERT INTO `creature` VALUES (12776, 23089, 564, 1, 0, 1679, 757.5, 239.638, 353.281, 2.26385, 300, 0, 0, 1001550, 607000, 0, 0);
INSERT INTO `creature` VALUES (12814, 22849, 564, 1, 0, 0, 488.521, 395.2, 112.784, 3.26497, 10800, 0, 0, 102000, 0, 0, 0);
INSERT INTO `creature` VALUES (12819, 22849, 564, 1, 0, 0, 488.885, 407.437, 112.784, 3.22492, 10800, 0, 0, 102000, 0, 0, 0);
INSERT INTO `creature` VALUES (12886, 23394, 564, 1, 0, 0, 622.994, 126.932, 254.169, 3.17459, 3600, 5, 0, 664200, 0, 0, 2); -- 464940
INSERT INTO `creature` VALUES (39926, 23398, 564, 1, 0, 0, 538.471, 51.5336, 112.967, 4.92016, 30, 5, 0, 5500, 3155, 0, 1); -- 3912
INSERT INTO `creature` VALUES (39928, 23398, 564, 1, 0, 0, 513.068, 64.5998, 112.745, 6.27078, 30, 5, 0, 5500, 3155, 0, 1);
INSERT INTO `creature` VALUES (40233, 23398, 564, 1, 0, 0, 562.506, 94.6764, 112.695, 2.37427, 30, 5, 0, 5500, 3155, 0, 1);
INSERT INTO `creature` VALUES (40243, 23398, 564, 1, 0, 0, 617.138, 84.3218, 112.394, 6.19269, 30, 5, 0, 5500, 3155, 0, 1);
INSERT INTO `creature` VALUES (40244, 23398, 564, 1, 0, 0, 543.152, 82.0115, 113.121, 1.26602, 30, 5, 0, 5500, 3155, 0, 1);
INSERT INTO `creature` VALUES (40407, 23398, 564, 1, 0, 0, 605.794, 62.7557, 111.802, 4.54002, 30, 5, 0, 5500, 3155, 0, 1);
INSERT INTO `creature` VALUES (42920, 23399, 564, 1, 0, 0, 595.844, 41.3876, 112.717, 2.51799, 30, 5, 0, 70000, 66180, 0, 1); -- 49585
INSERT INTO `creature` VALUES (52461, 23412, 564, 1, 0, 0, 771.637, 304.536, 315.156, 3.12414, 3600, 0, 0, 1, 0, 0, 0);
INSERT INTO `creature` VALUES (52484, 22917, 564, 1, 0, 442, 701.94,    307.019,    354.27, 0.73, 604800, 0, 0, 6070400, 0, 0, 0);
INSERT INTO `creature` VALUES (52754, 22946, 564, 1, 0, 0, 525.3706, 144.4366, 164.7709, 3.1980, 7200, 5, 0, 71810, 0, 0, 0); -- 50267
INSERT INTO `creature` VALUES (52768, 22954, 564, 1, 0, 0, 635.48, 715.718, 73.3794, 3.20803, 7200, 30, 0, 552000, 0, 0, 1); -- 387450
INSERT INTO `creature` VALUES (52769, 22954, 564, 1, 0, 0, 744.237, 691.116, 71.9755, 0.055227, 7200, 30, 0, 552000, 0, 0, 1);
INSERT INTO `creature` VALUES (52846, 22956, 564, 1, 0, 0, 812.467, 489.963, 183.293, 4.69698, 3600, 5, 0, 295150, 33090, 0, 2); -- 206605
INSERT INTO `creature` VALUES (53054, 22964, 564, 1, 19199, 0, 833.48, 523.838, 165.731, 4.69426, 3600, 5, 0, 295150, 33090, 0, 2);
INSERT INTO `creature` VALUES (53211, 23232, 564, 1, 0, 0, 808.419, 107.089, 112.659, 0.92698, 7200, 5, 0, 144000, 0, 0, 1); -- 100534
INSERT INTO `creature` VALUES (53212, 23232, 564, 1, 0, 0, 797.713, 119.231, 112.187, 3.52653, 7200, 5, 0, 144000, 0, 0, 1);
INSERT INTO `creature` VALUES (53796, 23018, 564, 1, 0, 0, 434.989, 261.706, 172.368, 4.70618, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53797, 23018, 564, 1, 0, 0, 439.994, 262.253, 172.612, 4.70577, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53798, 23018, 564, 1, 0, 0, 458.21, 170.244, 163.981, 6.27262, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53799, 23018, 564, 1, 0, 0, 436.145, 170.477, 163.981, 4.62763, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53800, 23018, 564, 1, 0, 0, 563.892, 110.831, 148.604, 3.12589, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53801, 23018, 564, 1, 0, 0, 586.709, 110.746, 139.313, 3.15837, 7200, 0, 0, 200000, 64620, 0, 0);
INSERT INTO `creature` VALUES (53821, 23028, 564, 1, 0, 0, 623.037, 970.488, 56.0675, 5.46771, 3600, 5, 0, 172000, 32310, 0, 1); -- 120624
INSERT INTO `creature` VALUES (53827, 23030, 564, 1, 0, 0, 586.461, 877.008, 184.506, 1.56462, 3600, 5, 0, 200000, 32310, 0, 1); -- 140728
INSERT INTO `creature` VALUES (53828, 23030, 564, 1, 0, 0, 671.666, 851.845, 184.506, -3.12458, 3600, 5, 0, 200000, 32310, 0, 1);
INSERT INTO `creature` VALUES (53829, 23030, 564, 1, 0, 0, 613.381, 861.349, 184.506, 3.2175, 3600, 5, 0, 200000, 32310, 0, 1);
INSERT INTO `creature` VALUES (53831, 23030, 564, 1, 0, 0, 782.901, 826.758, 157.837, 2.88201, 3600, 5, 0, 200000, 32310, 0, 1);
INSERT INTO `creature` VALUES (53907, 23030, 564, 1, 0, 0, 619.52, 736.459, 181.093, 0.897722, 3600, 5, 0, 200000, 32310, 0, 1);
INSERT INTO `creature` VALUES (53909, 23030, 564, 1, 0, 0, 630.91, 721.643, 181.093, 0.960804, 3600, 5, 0, 200000, 32310, 0, 1);
INSERT INTO `creature` VALUES (53915, 23030, 564, 1, 21543, 0, 676.9092, 741.6328, 98.4910, -2.51146, 3600, 5, 0, 201040, 32310, 0, 1);

-- ======================================================
-- NPC Research
-- Trash /1.75
-- ======================================================

-- Toad (1420) - NSR
-- Snake (2914) - NSR
-- Giant Surf Glider (5432) - NSR
-- Spider (14881) - NSR
-- Mechanical Greench (15721) - NSR

-- Ashtongue Battlelord 22844- mob_ashtongue_battlelord
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22844;
UPDATE `creature_template` SET `mindmg`='11485',`maxdmg`='13542',`speed` = '1.48', `lootid` = 22844 WHERE `entry` = 22844; -- 5900 9500 -- 20,099 - 23,699
DELETE FROM `creature_template_addon` WHERE `entry` = 22844;
INSERT INTO `creature_template_addon` VALUES (22844, 0, 0, 16777472, 0, 4097, 0, 0, '');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22844;
INSERT INTO `creature_onkill_reputation` VALUES (22844, 1012, 0, 7, 0, 15, 0, 0, 0, 0);
UPDATE `creature_model_info` SET `modelid_other_gender`= 0 WHERE `modelid` = 21115; -- 21118

-- Ashtongue Mystic 22845- mob_ashtongue_mystic
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22845;
UPDATE `creature_template` SET `speed` = '1.48',`mindmg`='6835',`maxdmg`='7263',`lootid` = '22845',`mechanic_immune_mask`='125709185',`flags_extra`='4259840' WHERE `entry` = 22845; -- 4201 4951 -- 11,961 - 12,711
DELETE FROM `creature_template_addon` WHERE `entry` = 22845;
INSERT INTO `creature_template_addon` VALUES (22845, 0, 0, 512, 0, 4097, 0, 0,'');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22845;
INSERT INTO `creature_onkill_reputation` VALUES (22845, 1012, 0, 7, 0, 15, 0, 0, 0, 0);

-- #define NPC_CYCLONE_TOTEM           22894
-- #define NPC_ASHTONGUE_SEARING_TOTEM 22896
-- #define NPC_SUMMONED_WINDFURY_TOTEM 22897

-- Ashtongue Stormcaller 22846- mob_ashtongue_stormcaller
-- Ashtongue Stormcaller - Summon Storm Fury on Spawn so always has one!
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22846;
UPDATE `creature_template` SET `modelid_A2`='0',`modelid_H2`='0',`speed`='1.48',`mindmg`='5399',`maxdmg`='6085',`lootid`='22846',`mechanic_immune_mask`='125709185' WHERE `entry` = 22846; -- 2551 3751 -- 9,449 - 10,649
DELETE FROM `creature_template_addon` WHERE `entry` = 22846;
INSERT INTO `creature_template_addon` VALUES (22846, 0, 0, 512, 0, 4097, 0, 0, '41151 0');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22846;
INSERT INTO `creature_onkill_reputation` VALUES (22846, 1012, 0, 7, 0, 15, 0, 0, 0, 0);
UPDATE `creature_model_info` SET `modelid_other_gender`=0 WHERE `modelid` = 21118; -- 21115

-- Ashtongue Primalist 22847- mob_ashtongue_primalist
-- 39584 not breakable by damage, otherwise instantly broken, doesnt make sense
-- Spell 39535 Summon Feral Spirit no movement 
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22847;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8663',`maxdmg`='10163',`lootid`='22847',`mechanic_immune_mask`='648232951',`flags_extra`='4259840' WHERE `entry` = 22847; -- 3751 6376 -- 15,160 - 17,785
DELETE FROM `creature_template_addon` WHERE `entry` = 22847;
INSERT INTO `creature_template_addon` VALUES (22847, 0, 0, 512, 0, 4097, 0, 0, ''); 
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22847;
INSERT INTO `creature_onkill_reputation` VALUES (22847, 1012, 0, 7, 0, 15, 0, 0, 0, 0);
UPDATE `creature_model_info` SET `modelid_other_gender`=0 WHERE `modelid` = 21117; -- 20422

-- Storm Fury 22848- mob_storm_fury
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22848;
UPDATE `creature_template` SET `armor`='5800',`speed`='1.48',`mindmg`='4122',`maxdmg`='5172',`baseattacktime`='1400',`mechanic_immune_mask`='1073588143' WHERE `entry` = 22847; -- 3001 4051 2000 -- 4,122 - 5,172
DELETE FROM `creature_template_addon` WHERE `entry` = 22848;
INSERT INTO `creature_template_addon` VALUES (22848, 0, 0, 512, 0, 4097, 0, 0, '');
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22848;
INSERT INTO `creature_onkill_reputation` VALUES (22848, 1012, 0, 5, 0, 3, 0, 0, 0, 0);   

-- Ashtongue Feral Spirit 22849- mob_ashtongue_feral_spirit
-- insanly hugh aggro radius
UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` = 22849;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4682',`maxdmg`='5539',`mechanic_immune_mask`='662569871' WHERE `entry` = 22849; -- 2251 3751 -- 8,193 - 9,693
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22849;
INSERT INTO `creature_onkill_reputation` VALUES (22849, 1012, 0, 15, 0, 7, 0, 0, 0, 0);

-- Illidari Defiler 22853- mob_illidari_defiler
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22853;
UPDATE `creature_template` SET `mindmg`='6149',`maxdmg`='7221',`mechanic_immune_mask`='787038035' WHERE `entry` = 22853; -- 3001 4876 -- 10,761 - 12,636
DELETE FROM `creature_template_addon` WHERE `entry` = 22853;
INSERT INTO `creature_template_addon` VALUES (22853, 0, 0, 512, 0, 4097, 0, 0, '39839 0');

-- Illidari Nightlord 22855- mob_illidari_nightlord
UPDATE `creature` SET `modelid` = 0, `spawndist` = 0, `spawntimesecs` = 7200 WHERE `id` = 22855;
UPDATE `creature_template` SET `mindmg`='12895',`maxdmg`='15895',`mechanic_immune_mask`='805257207',`flags_extra`='1078001664' WHERE `entry` = 22855; -- 6001 11251 -- 22,566 - 27,816
DELETE FROM `creature_template_addon` WHERE `entry` = 22855;
INSERT INTO `creature_template_addon` VALUES (22855, 0, 0, 16777472, 0, 4097, 0, 0, '');

-- Illidari Boneslicer 22869- mob_illidari_boneslicer
UPDATE `creature` SET `modelid` = 0, `spawndist` = 0, `spawntimesecs` = 7200 WHERE `id` = 22869;
UPDATE `creature_template` SET `speed` = 1.71,`mindmg`='5707',`maxdmg`='7122',`mechanic_immune_mask`='787038035' WHERE `entry` = 22869; -- 2551 5026 -- 9,988 - 12,463
DELETE FROM `creature_template_addon` WHERE `entry` = 22869;
INSERT INTO `creature_template_addon` VALUES (22869, 0, 0, 16777472, 0, 4097, 0, 0, '');    

-- Coilskar General 22873- mob_coilskar_general
UPDATE `creature` SET `modelid` = 0, `spawndist` = 0, `spawntimesecs` = 7200 WHERE `id` = 22873;
UPDATE `creature_template` SET `modelid_A2`= 21160,`modelid_H2` = 21160,`speed` = 1.71,`mindmg`='12742',`maxdmg`='14557',`mechanic_immune_mask`='788512759' WHERE `entry` = 22873; -- 2776 5951 -- 22,299 - 25,474
DELETE FROM `creature_template_addon` WHERE `entry` = 22873;
INSERT INTO `creature_template_addon` VALUES (22873, 0, 0, 16777472, 0, 4097, 0, 0, '');

-- Coilskar Harpooner 22874- mob_coilskar_harpooner
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22874;
DELETE FROM `creature_template_addon` WHERE `entry` = 22874;
INSERT INTO `creature_template_addon` VALUES (22874, 0, 0, 512, 0, 4097, 0, 0, ''); 
UPDATE `creature_template` SET `speed` = 1.71, `mindmg`='7370',`maxdmg`='8527' WHERE `entry` = 22874; -- 4276 6300 -- 12,898 - 14,922
UPDATE `creature_onkill_reputation` SET `MaxStanding1` = 3 WHERE `creature_id` = 22874;

-- Coilskar Sea-Caller 22875- mob_coilskar_seacaller
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22875;
UPDATE `creature_template` SET `modelid_A2`='21163',`modelid_H2`='21163',`speed` = 1.71,`mindmg`='4806',`maxdmg`='5706',`mechanic_immune_mask`='67125063' WHERE `entry` = 22875; -- 1513 3087 -- 8,411 - 9,985
DELETE FROM `creature_template_addon` WHERE `entry` = 22875;
INSERT INTO `creature_template_addon` VALUES (22875, 0, 0, 66048, 0, 4097, 0, 0, '');   

-- Coilskar Soothsayer 22876- mob_coilskar_soothsayer
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22876;
UPDATE `creature_template` SET `speed` = 1.71,`mindmg`='5973',`maxdmg`='6087',`mechanic_immune_mask`='10241' WHERE `entry` = 22876; -- 3555 3755 -- 10,453 - 10,653
DELETE FROM `creature_template_addon` WHERE `entry` = 22876;
INSERT INTO `creature_template_addon` VALUES (22876, 0, 0, 66048, 0, 4097, 0, 0, '');

-- Coilskar Wrangler 22877- mob_coilskar_wrangler
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22877;
UPDATE `creature_template` SET `modelid_A2`='21166',`modelid_H2`='21166',`speed` = 1.71,`mindmg`='10362',`maxdmg`='10939' WHERE `entry` = 22877; -- 5200 6210 -- 18,134 - 19,144
DELETE FROM `creature_template_addon` WHERE `entry` = 22877;
INSERT INTO `creature_template_addon` VALUES (22877, 0, 0, 512, 0, 4097, 0, 0, '');

-- Aqueous Lord 22878- mob_aqueous_lord
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22878;
UPDATE `creature_template` SET `speed` = 1.71, `mindmg`='6938',`maxdmg`='7257',`flags_extra` = 1074069536 WHERE `entry` = 22878; -- 3938 4576 -- 13,876 - 14,514
DELETE FROM `creature_template_addon` WHERE `entry` = 22878;
INSERT INTO `creature_template_addon` VALUES (22878, 0, 0, 16908544, 0, 4097, 0, 0, '18950 0');

-- Shadowmoon Reaver 22879- mob_shadowmoon_reaver
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0, `MovementType` = 0 WHERE `id` = 22879;
UPDATE `creature_template` SET `speed` = 1.48,`mindmg`='9542',`maxdmg`='12751',`mechanic_immune_mask`='10497' WHERE `entry` = 22879; -- 4394 10009 -- 16,699 - 22,314
DELETE FROM `creature_template_addon` WHERE `entry` = 22879;
INSERT INTO `creature_template_addon` VALUES (22879, 0, 0, 16777472, 0, 4097, 375, 0, '');  

-- Shadowmoon Champion 22880- mob_shadowmoon_champion
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22880;
UPDATE `creature_template` SET `modelid_A2`='21368',`modelid_H2`='21368',`speed` = 1.71, `mindmg`='9319',`maxdmg`='14318', `flags_extra` = 1073807360 WHERE `entry` = 22880; -- 2109 10857 -- 16,308 - 25,056
DELETE FROM `creature_template_addon` WHERE `entry` = 22880;
INSERT INTO `creature_template_addon` VALUES (22880, 0, 0, 16777472, 0, 4097, 375, 0, '');  

-- Aqueous Surger 22881
UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` = 22881;
UPDATE `creature_template` SET `speed` = '1.48',`mindmg`='3376',`maxdmg`='4126',`mechanic_immune_mask`='11265' WHERE `entry` = 22881; -- 3376 4126 -- 11,604 - 12,354 elemental
DELETE FROM `creature_template_addon` WHERE `entry` = 22881;
INSERT INTO `creature_template_addon` VALUES (22881, 0, 0, 16908544, 0, 4097, 0, 0, '');
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 22881;
INSERT INTO `creature_ai_scripts` VALUES
('2288101','22881','9','0','100','3','0','55','13000','18000','11','40095','1','0','0','0','0','0','0','0','0','0','Aqueous Surger - Cast Poison Bolt Volley');

-- Shadowmoon Deathshaper 22882- mob_shadowmoon_deathshaper
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22882;
UPDATE `creature_template` SET `speed` = 1.48, `mindmg`='6646',`maxdmg`='8247',`mechanic_immune_mask`='100673793' WHERE `entry` = 22882; -- 3732 6534 -- 11,631 - 14,433
DELETE FROM `creature_template_addon` WHERE `entry` = 22882;
INSERT INTO `creature_template_addon` VALUES (22882, 0, 0, 512, 0, 4097, 0, 0, '13787 0');

-- Shadowmoon Fallen 23371
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`speed`='1.20',`mindmg`='5070',`maxdmg`='7013',`mechanic_immune_mask`='8398929' WHERE `entry` = 23371; -- 1900 5300 -- 8,873 - 12,273

-- Aqueous Spawn 22883- mob_aqueous_spawn
-- add Zcheck = 5000; to SludgeNova to prevent spell cancel
UPDATE `creature` SET `spawntimesecs` = 1200 WHERE `id` = 22883; 
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='3333',`maxdmg`='3632',`mechanic_immune_mask`='10241' WHERE `entry` = 22883; -- 2.5 1262 1785 -- 5,833 - 6,356 elemental
DELETE FROM `creature_template_addon` WHERE `entry` = 22883;
INSERT INTO `creature_template_addon` VALUES (22883, 0, 0, 16908544, 0, 4097, 0, 0, '');

-- Leviathan 22884- mob_leviathan
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22884;
UPDATE `creature_template` SET `speed` = 1.71, `mindmg`='10673',`maxdmg`='11422',`mechanic_immune_mask`='650854143',`flags_extra`='1078001664' WHERE `entry` = 22884; -- 5900 7210 -- 18,678 - 19,988
DELETE FROM `creature_template_addon` WHERE `entry` = 22884;
INSERT INTO `creature_template_addon` VALUES (22884, 0, 0, 16908544, 0, 4097, 0, 0, '');

-- Dragon Turtle 22885- mob_dragon_turtle
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22885;
UPDATE `creature_template` SET `speed` = 1.48, `mindmg`='10045',`maxdmg`='10259',`mechanic_immune_mask`='11265' WHERE `entry` = 22885; -- 6151 6526 -- 17,579 - 17,954
DELETE FROM `creature_template_addon` WHERE `entry` = 22885;
INSERT INTO `creature_template_addon` VALUES (22885, 0, 0, 16908544, 0, 4097, 0, 0, '');    
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22885;
INSERT INTO `creature_onkill_reputation` VALUES (22885, 1012, 0, 7, 0, 15, 0, 0, 0, 0);

-- Greater Shadowfiend 22929
UPDATE `creature_template` SET `minhealth`='4400',`maxhealth`='4400',`speed` = 1.20,`mindmg`='415',`maxdmg`='645' WHERE `entry` = 22929; -- 2900 1 -- 18 248 -- 415 - 645

-- Temple Concubine 22939- mob_temple_concubine
-- 29k hp?
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22939; -- Emotes 1 10 69
UPDATE `creature_template` SET `modelid_A`='21449',`modelid_H`='21449',`modelid_A2`='21451',`modelid_H2`='21451', `armor` = 6200,`speed` = 1.48, `mindmg`='885',`maxdmg`='999', `mechanic_immune_mask`='67124289' WHERE `entry` = 22939; -- 612 812 -- 1,548 - 1,748
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 3 WHERE `creature_id` = 22939; -- 15

-- Shadowmoon Blood Mage 22945- mob_shadowmoon_blood_mage
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22945;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='6646',`maxdmg`='8476',`mechanic_immune_mask`='100673793' WHERE `entry` = 22945; -- 3732 6934 -- 11,631 - 14,833

-- Shadowmoon War Hound 22946
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0, `MovementType` = 0 WHERE `id` = 22946;
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='3825',`maxdmg`='4543' WHERE `entry` = 22946; -- 687 1405 -- 3,825 - 4,543
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 22946;
INSERT INTO `creature_onkill_reputation` VALUES (22946, 1012, 0, 7, 0, 3, 0, 0, 0, 0);

-- Wrathbone Flayer 22953- mob_wrathbone_flayer
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22953;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='12761',`maxdmg`='16659',`flags_extra`='1073807360' WHERE `entry` = 22953; -- 6062 12884 -- 22,331 - 29,153

-- Illidari Fearbringer 22954- mob_illidari_fearbringer
-- http://wowwiki.wikia.com/wiki/Illidari_Fearbringer?oldid=1828758 40946 amplitude to 1000 not 3000 for prenerf trash.
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22954;
UPDATE `creature_template` SET `mindmg`='10943',`maxdmg`='12829',`mechanic_immune_mask`='1073725439',`flags_extra`='1078001664' WHERE `entry` = 22954; -- 4951 8251 -- 19,150 - 22,450

-- Charming Courtesan 22955- mob_charming_courtesan
-- emote 1 10 69
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 22955;
UPDATE `creature_template` SET `modelid_A`='21452',`modelid_H`='21452',`modelid_A2`='21454',`modelid_H2`='21454',`speed`='1.10',`mindmg`='1353',`maxdmg`='1574',`mechanic_immune_mask`='67185729' WHERE `entry` = 22955; -- 672 1059 -- 2,368 - 2,755
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1` = 3 WHERE `creature_id` = 22955; -- 15

-- Sister of Pain 22956- mob_sister_of_pain
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22956;
UPDATE `creature` SET `MovementType` = 0 WHERE `guid` IN (52848,52850,52855);
-- http://www.wowhead.com/npc=22956 http://wowwiki.wikia.com/wiki/Sister_of_Pain
UPDATE `creature_template` SET `speed` = 1.71, `mindmg`='12030',`maxdmg`='14889', `mechanic_immune_mask` = 650854259, `flags_extra` = 1078001664 WHERE `entry` = 22956; -- 7887 12890 -- 21,052 - 26,055

-- Sister of Pleasure 22964- mob_sister_of_pleasure
-- http://www.wowhead.com/npc=22964 http://wowwiki.wikia.com/wiki/Sister_of_Pleasure
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22964;
UPDATE `creature` SET `MovementType` = 0 WHERE `guid` IN (53054,53055,53058);
UPDATE `creature_template` SET `speed` = 1.71, `mindmg`='11458',`maxdmg`='13746', `mechanic_immune_mask` = 617299967, `flags_extra` = 1078001664 WHERE `entry` = 22964; -- 6887 10890 -- 20,052 - 24,055

-- Priestess of Dementia 22957
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22957;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='10366',`maxdmg`='14007',`mechanic_immune_mask`='113982939',`flags_extra`='1073807360' WHERE `entry` = 22957; -- 6731 13104 -- 18,140 - 24,513

-- Spellbound Attendant 22959- mob_spellbound_attendent
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22959;
UPDATE `creature_template` SET `modelid_A`='21530',`modelid_H`='21530',`modelid_A2`='21532',`modelid_H2`='21532',`speed`='1.48',`mindmg`='8254',`maxdmg`='9691',`mechanic_immune_mask`='67124289' WHERE `entry` = 22959; -- 3418 5933 -- 14,444 - 16,959

-- Dragonmaw Wyrmcaller 22960- mob_dragonmaw_wyrmcaller
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 22960;
UPDATE `creature` SET `MovementType` = 0 WHERE `guid` IN (52872,52873,52889,52902); 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='10498',`maxdmg`='11441',`mechanic_immune_mask`='788217811',`flags_extra`='1078001664' WHERE `entry` = 22960; -- 6301 7951 -- 18,372 - 20,022

-- Priestess of Delight 22962- mob_pristess_of_delight
UPDATE `creature` SET `modelid` = 21502, `spawntimesecs` = 7200 WHERE `id` = 22962;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='14725',`maxdmg`='19238',`mechanic_immune_mask`='113982811',`flags_extra`='1073807360' WHERE `entry` = 22962; -- 8731 16629 -- 25,769 - 33,667

-- Bonechewer Worker 22963- mob_bonechewer_worker
UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `spawntimesecs` = 7200 WHERE `id` = 22963;
UPDATE `creature_template` SET `modelid_A`='21535',`modelid_H`='21535',`modelid_A2`='21537',`modelid_H2`='21537',`speed`='1.48',`mindmg`='1218',`maxdmg`='1227',`mechanic_immune_mask`='75795' WHERE `entry` = 22963; -- 436 451 -- 2,132 - 2,147

-- Enslaved Servant 22965- mob_enslaved_servant
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0, `MovementType` = 0 WHERE `id` = 22965;
UPDATE `creature_template` SET `modelid_A`='21196',`modelid_H`='21196',`modelid_A2`='21528',`modelid_H2`='21528',`speed`='1.00',`mindmg`='9714',`maxdmg`='10751',`mechanic_immune_mask`='67124289' WHERE `entry` = 22965; -- 4694 6509 -- 16,999 - 18,814        

-- Shadowmoon Houndmaster 23018- mob_shadowmoon_houndmaster
-- http://wowwiki.wikia.com/wiki/Shadowmoon_Houndmaster?direction=next&oldid=1320513
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='10154',`maxdmg`='13270',`minrangedmg`='4000',`maxrangedmg`='8000',`flags_extra`='536870912' WHERE `entry` = 23018; -- 4836 10288 0 0-- 17,770 - 23,222
-- UPDATE `creature_template_addon` SET `mount`='' WHERE `entry` IN (''); -- 14334

-- Bonechewer Taskmaster 23028- mob_bonechewer_taskmaster
UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `spawntimesecs` = 7200 WHERE `id` = 23028; 
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7199',`maxdmg`='8913',`mechanic_immune_mask`='646004703' WHERE `entry` = 23028; -- 2251 5251 -- 12,598 - 15,598
DELETE FROM `creature_template_addon` WHERE `entry` = 23028;
INSERT INTO `creature_template_addon` VALUES (23028, 0, 0, 16908544, 0, 4097, 0, 0, '');

-- Dragonmaw Sky Stalker 23030- mob_dragonmaw_skystalker
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23030;
UPDATE `creature` SET `currentwaypoint` = 2 WHERE `guid` = 53912;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='4806',`maxdmg`='5706',`mechanic_immune_mask`='646004699',`flags_extra`='1078001664' WHERE `entry` = 23030; -- 1513 3087 -- 8,411 - 9,985

-- Shadowmoon Soldier 23047- mob_shadowmoon_soldier
UPDATE `creature` SET `modelid`  = 0, `spawntimesecs` = 7200 WHERE `id` = 23047; 
UPDATE `creature_template` SET `modelid_A`='21383',`modelid_H`='21383',`modelid_A2`='21385',`modelid_H2`='21385',`speed`='1.48',`mindmg`='1809',`maxdmg`='2398' WHERE `entry` = 23047; -- 800 1830 -- 3,166 - 4,196
DELETE FROM `creature_template_addon` WHERE `entry` = 23047;
INSERT INTO `creature_template_addon` VALUES (23047, 0, 0, 16777472, 0, 4097, 0, 0, '');

-- Shadowmoon Weapon Master 23049- mob_shadowmoon_weapon_master
-- #define DATA_WEAPONMASTER_LIST_SIZE     32
-- #define DATA_WEAPONMASTER_SOLDIER 33 // -40
-- missing guids
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23049;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='15389',`maxdmg`='21846',`mechanic_immune_mask`='650854399',`flags_extra`='1078001664' WHERE `entry` = 23049; -- 8000 19300 -- 26,931 - 38,231
DELETE FROM `creature_template_addon` WHERE `entry` = 23049;
INSERT INTO `creature_template_addon` VALUES (23049, 0, 0, 16777472, 0, 4097, 0, 0, '');

-- Demon Fire 23069- mob_demon_fire
-- spell 1 = 40029

-- Shadowmoon Riding Hound 23083- mob_shadowmoon_riding_hound
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4857',`maxdmg`='5940',`baseattacktime`='1000',`mechanic_immune_mask`='75507183' WHERE `entry` = 23083; -- 1527 3422 1000 -- 8,500 - 10,395

-- Sewer Rat (23086) - NSR
-- Sewer Crocolisk (23087) - NSR

-- Shadowmoon Grunt (23147) - NSR -- mob_shadowmoon_grunt
-- aura 34664 0
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `MovementType` = 0 WHERE `id` = 23147;
UPDATE `creature_addon` SET `moveflags` = 0 WHERE `guid` IN (52447,52449); -- 2048
UPDATE `creature_addon` SET `auras` = '34664 0' WHERE `guid` IN (52441,52448,52457);
UPDATE `creature_template` SET `modelid_A2`='21377',`modelid_H2`='21377',`speed`='1.48',`mindmg`='1548',`maxdmg`='1967' WHERE `entry` = 23147;  -- 815 1548 -- 2,709 - 3,442
DELETE FROM `creature_template_addon` WHERE `entry` = 23147;
INSERT INTO `creature_template_addon` VALUES (23147, 0, 0, 16777472, 0, 4097, 0, 0, '');

-- Aluyen (23157) - NSR
-- Seer Kanai (23158) - NSR
-- Okuno (23159) - NSR

-- Hand of Gorefiend 23172- mob_hand_of_gorefiend
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `curmana` = 0 WHERE `id` = 23172;
UPDATE `creature_template` SET `minlevel`='72',`maxlevel`='72',`minmana`='0',`maxmana`='0',`armor`='7400',`speed`='1.48',`mindmg`='11436',`maxdmg`='18596',`flags_extra` = 1078001664 WHERE `entry` = 23172; -- 10500 17660 -- 11436 - 18596
DELETE FROM `creature_template_addon` WHERE `entry` = 23172;
INSERT INTO `creature_template_addon` VALUES
(23172, 0, 0, 512, 0, 4097, 0, 0, '');

-- Bonechewer Behemoth 23196- mob_bonechewer_behemoth
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0 WHERE `id` = 23196;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='9890',`maxdmg`='15657',`flags_extra`='1073807360' WHERE `entry` = 23196; -- 3109 13200 -- 17,308 - 27,399
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`= '23' WHERE `creature_id` = 23196;

-- Bonechewer Brawler 23222- mob_bonechewer_brawler
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23222;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='12380',`maxdmg`='16525',`flags_extra`='1073741824' WHERE `entry` = 23222; -- 3071 10325 -- 21,665 - 28,919

-- Bonechewer Spectator 23223- mob_bonechewer_spectator emote 22
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23223;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='1295',`maxdmg`='1652',`mechanic_immune_mask`='662781919' WHERE `entry` = 23223; -- 407 1032 -- 2,266 - 2,891

-- Mutant War Hound 23232- mob_mutated_war_hound
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200, `spawndist` = 0, `MovementType` = 0 WHERE `id` = 23232;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4142',`maxdmg`='4723',`mechanic_immune_mask`='662715903' WHERE `entry` = 23232; -- 2368 3385 -- 7,248 - 8,265
DELETE FROM `creature_template_addon` WHERE `entry` = 23232;
INSERT INTO `creature_template_addon` VALUES (23232, 0, 0, 16777472, 0, 4097, 0, 0, '41290 0'); 

-- Bonechewer Blade Fury 23235- mob_bonechewer_blade_fury
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23235;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8483',`maxdmg`='11111',`mechanic_immune_mask`='67119105' WHERE `entry` = 23235; -- 3487 8086 -- 14,846 - 19,445

-- Bonechewer Shield Deciple 23236- mob_bonechewer_shield_disciple
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23236;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='10847',`maxdmg`='12835',`mechanic_immune_mask`='67119105' WHERE `entry` = 23236; -- 6521 10000 -- 18,982 - 22,461

-- Bonechewer Blood Prophet 23237- mob_bonechewer_blood_prophet
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23237;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5863',`maxdmg`='7904' WHERE `entry` = 23237; -- 2501 6072 -- 10,261 - 13,832

-- Bonechewer Combatant 23239- mob_bonechewer_combatant
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23239;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='14380',`maxdmg`='18811',`mechanic_immune_mask`='662781919',`flags_extra`='1073741824' WHERE `entry` = 23239; -- 6571 14325 -- 25,165 - 32,919

-- Dragonmaw Wind Reaver 23330- mob_dragonmaw_windreaver
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23330;
UPDATE `creature_addon` SET `mount`= 21548 WHERE `guid` IN (12737,12738,12739,12740,12741,12742,12743); -- 24725
UPDATE `creature_template` SET `speed` = 1.71,`mindmg`='4205',`maxdmg`='4993',`mechanic_immune_mask`='646004699',`flags_extra`='1078001664' WHERE `entry` = 23330; -- 1323 2701 -- 7,359 - 8,737

-- Illidari Centurion 23337- mob_illidari_centurion
UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `spawntimesecs` = 7200, `curhealth` = 293000 WHERE `id` = 23337;
UPDATE `creature_template` SET `mindmg`='12038',`maxdmg`='13753',`mechanic_immune_mask`='652951551',`flags_extra`='1078001664' WHERE `entry` = 23337; -- 6301 9301 -- 21,067 - 24,067
DELETE FROM `creature_template_addon` WHERE `entry` = 23337;
INSERT INTO `creature_template_addon` VALUES (23337, 0, 0, 16777472, 0, 4097, 375, 0, '');  

-- Illidari Heartseeker 23339- mob_illidari_heartseeker
UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `spawntimesecs` = 7200 WHERE `id` = 23339;
UPDATE `creature_template` SET `mindmg`='6925',`maxdmg`='7782',`mechanic_immune_mask`='46153555' WHERE `entry` = 23339; -- 3751 5251 -- 12,118 - 13,618
DELETE FROM `creature_template_addon` WHERE `entry` = 23339;
INSERT INTO `creature_template_addon` VALUES (23339, 0, 0, 16777472, 0, 4097, 0, 0, '');    

-- Whirling Blade 23369 -- mob_whirling_blade
-- UPDATE `creature_template` SET WHERE `entry` = 23369;

-- Ashtongue Stalker 23374- mob_ashtongue_stalker
UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `spawntimesecs` = 7200 WHERE `id` = 23374;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='5855',`maxdmg`='7295',`mechanic_immune_mask`='570568513' WHERE `entry` = 23374; -- 2551 6151 -- 14,637 - 18,237 /2.5
DELETE FROM `creature_template_addon` WHERE `entry` = 23374;
INSERT INTO `creature_template_addon` VALUES (23374, 0, 0, 16777472, 0, 4097, 0, 0, '');    

-- Black Temple - Houndmaster Flare Dummy 23379
-- trigger doesnt despawn should despawn or change model to 11686 only
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` = 23379;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 23379;
INSERT INTO `creature_ai_scripts` VALUES   
('2337901','23379','0','0','100','0','30000','30000','0','0','37','0','0','0','0','0','0','0','0','0','0','0','Houndmaster Flare Dummy - Kill Self after 30sec');         

-- Fallen Ally 23389
-- These appear when a person in the raid dies while fighting the trash packs just after Supremus.
UPDATE `creature_template` SET `mechanic_immune_mask`='8398929' WHERE `entry` = 23389; -- 1500 2500 -- 1,786 - 2,786

-- Promenade Sentinal 23394- mob_promenade_sentinel
UPDATE `creature` SET `modelid` = 0, `spawntimesecs`  = 7200, `spawndist` = 0 WHERE `id` = 23394;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='12835',`maxdmg`='17101',`resistance3`='-1',`mechanic_immune_mask`='787169279',`flags_extra`='1078001664' WHERE `entry` = 23394; -- 7316 14781 -- 22,461 - 29,926
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='30' WHERE `creature_id` = 23394;
DELETE FROM `creature_template_addon` WHERE `entry` = 23394;
INSERT INTO `creature_template_addon` VALUES (23394, 0, 0, 16908544, 0, 4097, 0, 0, '');

-- Illidari Blood Lord 23397- mob_illidari_blood_lord
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23397;
UPDATE `creature_template` SET `modelid_A`='21560',`modelid_H`='21560',`modelid_A2`='21562',`modelid_H2`='21562',`speed`='1.48',`mindmg`='12866',`maxdmg`='16289',`mechanic_immune_mask`='788217855',`flags_extra`='1078001664' WHERE `entry` = 23397; -- 9790 15781 -- 22,515 - 28,506
DELETE FROM `creature_template_addon` WHERE `entry` = 23397;
INSERT INTO `creature_template_addon` VALUES (23397, 0, 0, 512, 0, 4097, 0, 0, '');

-- Angered Soul Fragment 23398 -- mob_angered_soul_fragment
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 20, `spawndist` = 5, `MovementType` = 1 WHERE `id` = 23398;
UPDATE `creature_addon` SET `auras` = '35841 0' WHERE `guid` IN (9794,9821,9851,9869,9953);
UPDATE `creature_template` SET `modelid_A` = 11686, `speed` = 1.20, `mindmg`='1404',`maxdmg`='1981' WHERE `entry` = 23398; -- 236 1246 -- 2,457 - 3,467
DELETE FROM `creature_template_addon` WHERE `entry` = 23398;
INSERT INTO `creature_template_addon` VALUES (23398, 0, 0, 131584, 0, 4097, 0, 0, '35841 0');

-- Suffering Soul Fragment 23399- mob_suffering_soul_fragment
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 20 WHERE `id` = 23399;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4764',`maxdmg`='5762' WHERE `entry` = 23399; -- 2555 4301 -- 8,337 - 10,083 

-- Illidari Archon 23400- mob_illidari_archon
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23400;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='7258',`maxdmg`='9545',`mechanic_immune_mask`='67120471',`flags_extra`='1077936128' WHERE `entry` = 23400; -- 3925 7927 -- 12,701 - 16,703
DELETE FROM `creature_template_addon` WHERE `entry` = 23400;
INSERT INTO `creature_template_addon` VALUES (23400, 0, 0, 512, 0, 4097, 0, 0, '');

-- Hungering Soul Fragment 23401- mob_hungering_soul_fragment
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 20, `spawndist` = 5, `MovementType` = 1 WHERE `id` = 23401;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4253',`maxdmg`='4596' WHERE `entry` = 23401; -- 3000 3600 -- 7,443 - 8,043
DELETE FROM `creature_template_addon` WHERE `entry` = 23401;
INSERT INTO `creature_template_addon` VALUES (23401, 0, 0, 16908544, 0, 4097, 0, 0, '41248 0'); 

-- Illidari Battle-Mage 23402- mob_illidari_battle_mage
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23402;#
UPDATE `creature_addon` SET `emote` = 0 WHERE `guid` = 52433; -- 69
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='8401',`maxdmg`='11259',`mechanic_immune_mask`='109063511' WHERE `entry` = 23402; -- 5925 10927 -- 14,701 - 19,703

-- Illidari Assassin 23403- mob_illidari_assassin
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 7200 WHERE `id` = 23403;
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='6969',`maxdmg`='8452',`mechanic_immune_mask`='109064151',`flags_extra`='1078001664' WHERE `entry` = 23403; -- 5591 9297 -- 17,423 - 21,129 /2.5

-- Teleport NPCs
-- Spirit of Udalo (23410) - npc_spirit_of_udalo
-- Spirit of Olum (23411) - npc_spirit_of_olum

-- Image of Dementia 23436- mob_image_of_dementia
-- http://www.wowhead.com/npc=23436/image-of-dementia#comments
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='700',`maxdmg`='1400',`mechanic_immune_mask`='650854359',`flags_extra`='1078001664' WHERE `entry` = 23436; -- 500 900
UPDATE `creature_onkill_reputation` SET `RewOnKillRepValue1`='0' WHERE `creature_id` = 23436;
DELETE FROM `creature_template_addon` WHERE `entry` = 23436;
INSERT INTO `creature_template_addon` VALUES (23436, 0, 0, 16777472, 0, 4097, 0, 0, '41399 0 41399 1');

-- ============================
-- Bosses
-- http://wowwiki.wikia.com/wiki/Armor?file=Armor.JPG Bosse
-- ============================

-- High Warlord Naj'entus 22887 - boss_najentus 
-- http://wowwiki.wikia.com/wiki/High_Warlord_Naj%27entus?oldid=1593265
UPDATE `creature` SET `modelid` = 0 WHERE `id` = 22887;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='14595',`maxdmg`='16095',`mechanic_immune_mask`='617299807',`flags_extra`='1078001665' WHERE `entry` = 22887; -- 1.2 9000 12000 -- 29,190 - 32,190 /2

-- GOBJECT_SPINE 185584

-- ===============

-- Supremus 22898- boss_supremus 
-- http://wowwiki.wikia.com/wiki/Supremus?oldid=1618153
UPDATE  `creature` SET `modelid` = 0 WHERE `id` = 22898;
UPDATE `creature_template` SET `speed` = 1.71,`mindmg`='16865',`maxdmg`='20495',`mechanic_immune_mask`='650854239',`flags_extra`='1078001697' WHERE `entry` = 22898; -- 6690 13950 -- 33,730 - 40,990 /2
-- core scripted atm
-- UPDATE `creature_model_info` SET `bounding_radius` = 20,`combat_reach` = 20 WHERE `modelid` = 21145; -- 13 0

-- Supremus Punch Invis Stalker 23095

-- Supremus Volcano 23085

-- ===============

-- Akama 23191- npc_akama_shade
UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` = 23191;
-- UPDATE `creature_template` SET WHERE `entry` = 23191;
-- Akama Soul Expel Cosmetic Spell doesnt work
DELETE FROM `spell_script_target` WHERE `entry` = 40855;
INSERT INTO `spell_script_target` VALUES (40855,2,22841);

-- Shade of Akama 22841- boss_shade_of_akama
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 604800 WHERE `id` = 22841;
UPDATE `creature_template` SET `speed`='1.00',`mindmg`='30500',`maxdmg`='30500',`unit_flags`='33554496',`mechanic_immune_mask`='650854271',`flags_extra`='1078001667' WHERE `entry` = 22841; -- 1.2 -- 9476 19367 -- 52,741 - 62,632

-- Ashtongue Channeler 23421- mob_ashtongue_channeler
UPDATE `creature_template` SET `armor`='5714',`speed`='1.48',`mindmg`='3097',`maxdmg`='3674',`mechanic_immune_mask`='788217855',`flags_extra`='1078001664' WHERE `entry` = 23421; -- 3577 1.2 976 1986 -- 5,419 - 6,429
DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 23421;
INSERT INTO `creature_onkill_reputation` VALUES (23421, 1012, 0, 5, 0, 15, 0, 0, 0, 0);

-- Ashtongue Sorcerer 23215- mob_ashtongue_sorcerer
UPDATE `creature_template` SET `modelid_A`='21402',`modelid_H`='21402',`modelid_A2`='21593',`modelid_H2`='21593',`armor`='5800',`speed`='1.48',`mindmg`='7190',`maxdmg`='8529',`mechanic_immune_mask`='1056653183',`flags_extra`='1073807360' WHERE `entry` = 23215; -- 3577 1,5 2267 4610 -- 12,582 - 14,925
-- UPDATE `creature_template` SET `ScriptName`='', `AIName`='EventAI' WHERE `entry`= 23215;
-- UPDATE `creature_template` SET `ScriptName`='mob_ashtongue_sorcerer', `AIName`='' WHERE `entry`= 23215;

-- Ashtongue Defender 23216- mob_ashtongue_defender
UPDATE `creature_template` SET `modelid_A`='21595',`modelid_H`='21595',`speed`='1.48',`mindmg`='4087',`maxdmg`='8000',`mechanic_immune_mask`='1056653179',`flags_extra`='0' WHERE `entry` = 23216; -- 4000 8000 -- 7,152 - 11,152
-- UPDATE `creature_template` SET `ScriptName`='', `AIName`='EventAI' WHERE `entry`=23216;
-- UPDATE `creature_template` SET `ScriptName`='mob_ashtongue_defender', `AIName`='' WHERE `entry`= 23216;

-- Ashtongue Broken (23319) - NSR

-- Ashtongue Elementalist 23523- mob_ashtongue_elementalist
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 23523; -- 1.5
-- UPDATE `creature_template` SET `ScriptName`='', `AIName`='EventAI' WHERE `entry`= 23523;
-- UPDATE `creature_template` SET `ScriptName`='mob_ashtongue_elementalist', `AIName`='' WHERE `entry`= 23523;

-- Ashtongue Spiritbinder 23524- mob_ashtongue_spiritbinder
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 23524; -- 1.5
-- UPDATE `creature_template` SET `ScriptName`='', `AIName`='EventAI' WHERE `entry`= 23524;
-- UPDATE `creature_template` SET `ScriptName`='mob_ashtongue_spiritbinder', `AIName`='' WHERE `entry`= 23524;

-- Akama (22990) - npc_akama_shade Shadowmoonvalley

-- Ashtongue Rogue 23318- mob_ashtongue_rogue
UPDATE `creature_template` SET `speed`='1.48' WHERE `entry` = 23318; -- 1.5
-- UPDATE `creature_template` SET `ScriptName`='', `AIName`='EventAI' WHERE `entry`= 23318;
-- UPDATE `creature_template` SET `ScriptName`='mob_ashtongue_rogue', `AIName`='' WHERE `entry`= 23318;

-- ===============

-- Teron Gorefiend 22871- boss_teron_gorefiend
UPDATE `creature` SET `modelid` = 0, `spawntimesecs` = 604800 WHERE `id` = 22871;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='14489',`maxdmg`='17198',`mechanic_immune_mask`='650854399',`flags_extra`='1078001665' WHERE `entry` = 22871; -- 7820 15946 -- 14000 18800calc -- 43,467 - 51,593 /3

-- Doom Blossom 23123- mob_doom_blossom
-- faction 35

-- Shadowy Construct 23111- mob_shadowy_construct
-- maybe increase speed slightly
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='1500',`maxdmg`='3000',`mechanic_immune_mask`='12582928',`flags_extra`='1078001664' WHERE `entry` = 23111; -- 600 900 -- 1600 2800

-- Add missing auras in Shadowy Construct
-- DELETE FROM `creature_template_addon` WHERE `entry`=23111;
-- INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (23111, 0, 0, 0, 0, 0, '40326 40334');

-- Vengeful Spirit (23109) - NSR

-- ===============

-- Gurtogg Bloodboil 22948- boss_gurtogg_bloodboil /2.25
UPDATE `creature` SET `modelid` = 0 WHERE `id` = 22948;
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='8790',`maxdmg`='10439',`mechanic_immune_mask`='650854399' WHERE `entry` = 22948; -- 4738 9684 -- 26,371 - 31,317

-- Fel Geyser 23254
UPDATE `creature_template` SET `AIName` = 'EventAI', `ScriptName` = '' WHERE `entry` = 23254;
DELETE FROM `creature_ai_scripts` WHERE `entryOrGUID` = 23254;
INSERT INTO `creature_ai_scripts` VALUES (2325401, 23254, 4, 0, 100, 2, 0, 0, 0, 0, 11, 40593, 0, 7, 37, 0, 0, 0, 0, 0, 0, 0, 'Fel Geyser - Cast Fel Geyser and Die on Aggro');

-- ===============
-- https://web.archive.org/web/20100907205653/http://www.hordeguides.de/Schlachtzug/TBC/Boss/23420/Relikt-der-Seelen/index.htm

-- Reliquary of the Lost 22856 -- Visual
UPDATE `creature_template` SET `unit_flags`='33816896' WHERE `entry` = 22856; -- 33554752

-- Essence of Suffering 23418- boss_essence_of_suffering
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='788',`maxdmg`='1013',`mechanic_immune_mask`='650854399' WHERE `entry` = 23418; -- 1.2 700 1200 -- 843 - 1343

-- Essence of Desire 23419- boss_essence_of_desire
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='9458',`maxdmg`='10462',`mechanic_immune_mask`='617299967' WHERE `entry` = 23419; -- 1.2 10000 13010 -- 28,375 - 31,385

-- Essence of Anger 23420- boss_essence_of_anger
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='10058',`maxdmg`='11025',`mechanic_immune_mask`='650854399' WHERE `entry` = 23420; -- 1.2 11800 14700 -- 30,175 - 33,075

-- Enslaved Soul 23469- npc_enslaved_soul
UPDATE `creature_template` SET `speed`='1.48',`mechanic_immune_mask`='650854239' WHERE `entry` = 23469; -- 540 580
-- visual
DELETE FROM `creature_template_addon` WHERE `entry` = 23469;
INSERT INTO `creature_template_addon` VALUES (23469, 0, 0, 0, 0, 4097, 0, 0, '30206 0');

-- Invisible Stalker (Floating) 23033
UPDATE `creature_template` SET `InhabitType`= 7 WHERE `entry` = 23033; -- 3

-- Reliquary Combat Trigger 23417
UPDATE `creature_template` SET `modelid_A` = 15435, `flags_extra`= 130 WHERE `entry` = 23417;

-- http://db.looking4group.eu/?npc=23472

-- ===============

-- Mother Shahraz 22947- boss_mother_shahraz
-- https://web.archive.org/web/20100907205638/http://www.hordeguides.de/Schlachtzug/TBC/Boss/22947/Mutter-Shahraz/index.htm
UPDATE `creature` SET `modelid` = 0 WHERE `id` = 22947;
UPDATE `creature_template` SET `speed`='1.71',`mindmg`='11758',`maxdmg`='15406',`mechanic_immune_mask`='650854399',`flags_extra`='1078001705' WHERE `entry` = 22947; -- 8797 17938 -- 48,900 - 58,041

-- ===============

-- The Illidari Council 23426- mob_illidari_council
-- https://web.archive.org/web/20100907205648/http://www.hordeguides.de/Schlachtzug/TBC/Boss/22949/Rat-der-Illidari/index.htm

-- Gathios the Shatterer 22949- boss_gathios_the_shatterer
UPDATE `creature` SET `modelid`  = 0 WHERE `id` = 22949;
UPDATE `creature_template` SET `mindmg`='12214',`maxdmg`='14676',`mechanic_immune_mask`='617299967',`mingold`=62500, `maxgold` = 62500 WHERE `entry` = 22949; -- 9331 17949 -- 42,749 - 51,367 /3.5

-- High Nethermancer Zerevor 22950- boss_high_nethermancer_zerevor
UPDATE `creature` SET `modelid`  = 0 WHERE `id` = 22950;
UPDATE `creature_template` SET `mindmg`='2484',`maxdmg`='2948',`mechanic_immune_mask`='617299967',`mingold`=62500, `maxgold` = 62500 WHERE `entry` = 22950; -- 1564 3189 -- 8,693 - 10,318

-- Lady Malande 22951- boss_lady_malande
UPDATE `creature` SET `modelid`  = 0 WHERE `id` = 22951;
UPDATE `creature_template` SET `mindmg`='4452',`maxdmg`='5463',`mingold`=62500, `maxgold` = 62500,`mechanic_immune_mask`='617299967' WHERE `entry` = 22951; -- 4443 7983 -- 15,582 - 19,122

-- Veras Darkshadow 22952- boss_veras_darkshadow
UPDATE `creature` SET `modelid`  = 0 WHERE `id` = 22952;
UPDATE `creature_template` SET `mindmg`='7269',`maxdmg`='9096',`mechanic_immune_mask`='617297919',`mingold`=62500, `maxgold` = 62500 WHERE `entry` = 22952; -- 6212 12608 -- 25,440 - 31,836

-- ===============

-- Illidan Stormrage 22917- boss_illidan_stormrage
-- https://web.archive.org/web/20100907205633/http://www.hordeguides.de/Schlachtzug/TBC/Boss/22917/Illidan-Sturmgrimm/index.htm
-- he is floating since some time
UPDATE `creature_template` SET `speed`='2.4',`mindmg`='16500',`maxdmg`='21500',`mechanic_immune_mask`='617299967' WHERE `entry` = 22917; -- 2 16500 21500 -- ~12858 17144! -- 20,786 - 25,786

-- Akama 23089- boss_illidan_akama
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='4075',`maxdmg`='4837'  WHERE `entry` = 23089; -- 2932 5979 -- 16,299 - 19,346 /4

-- Illidari Elite 23226- NSR fights against akama illidan
UPDATE `creature_template` SET `speed`='1.48',`mindmg`='2785',`maxdmg`='3308' WHERE `entry` = 23226; -- 500 1023 -- 2785 - 3308

-- Parasitic Shadowfiend 23498- boss_illidan_parasite_shadowfiend
UPDATE `creature_template` SET `speed`='1.20',`mindmg`='873',`maxdmg`='993',`mechanic_immune_mask`='650854335',`flags_extra`='1086390272' WHERE `entry` = 23498; -- 1.1 188 308 -- 873 - 993

-- Shadow Demon 23375- boss_illidan_shadowdemon
UPDATE `creature_template` SET `maxhealth`='22958',`speed`='0.6',`mindmg`='557',`maxdmg`='662',`mechanic_immune_mask`='650853375',`flags_extra`='1086390272' WHERE `entry` = 23375; -- 20958 0.5 100 205 -- 557 - 662

-- Maiev Shadowsong 23197- boss_illidan_maiev
UPDATE `creature_template` SET `armor`='6800',`speed`='1.48',`flags_extra`='1078001664' WHERE `entry` = 23197; -- 3000 4000 -- 5,625 - 6,625

-- Flame of Azzinoth 22997- boss_illidan_flameofazzinoth
-- http://de.wowhead.com/npc=22997/flamme-von-azzinoth#english-comments
UPDATE `creature_template` SET `mindmg`='11000',`maxdmg`='12000',`mechanic_immune_mask`='650854399',`flags_extra`='1078198304' WHERE `entry` = 22997; -- 13000 13000 -- 7502!

-- Blade of Azzinoth 22996- boss_illidan_glaive
-- trigger
UPDATE `creature_template` SET `unit_flags` = `unit_flags`|262144 WHERE `entry` = 22996;

-- Flame Crash 23336- mob_flame_crash
-- trigger

-- Glaive Target 23448
UPDATE `creature_template` SET `unit_flags` = `unit_flags`|262144 WHERE `entry` = 23448;

-- CAGE_TRAP_TRIGGER = 23292
-- trigger

-- Illidan Door Trigger
UPDATE `creature` SET `position_x`='772.6823', `position_y`='304.5182', `position_z`='316.3370' WHERE `guid` = 52461;
UPDATE `creature_template` SET `InhabitType` = 7 WHERE `entry` = 23412;

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

DELETE FROM `creature_formations` WHERE `leaderguid` IN (52745,12817,12803,12812,12797,12788,12789,12810,52874,52873,12847,12846,12855,12856,12850,16202,12754,12841,12782,12793,12807,12815,12780,12804,12791,18239,12866,12852,12851,12746,12747,12755,12820,12833,12834,12752,12753,12842,12758,12825,12750,12751,12839,12757,12823,12806,12819,12805,12814,52846,53054,53798,53799,53796,53797,53801,53800);
DELETE FROM `creature_formations` WHERE `memberguid` IN (52745,13236,12817,12803,12812,12797,12788,12789,12810,52874,52873,12782,12793,12807,12815,12780,12804,12791,18239,12866,12852,12851,12746,12747,12755,12820,12833,12834,12752,12753,12842,12758,12825,12750,12751,12839,12757,12823,12806,12819,12805,12814,52846,53054,53798,53799,53796,53797,53801,53800);
INSERT INTO `creature_formations` VALUES

(52745, 52754, 0, 0, 2),
(52745, 12883, 0, 0, 2),
(52745, 52744, 0, 0, 2),
(52745, 52745, 0, 0, 2),
(52745, 52755, 0, 0, 2),

(13268,13236,100,360,2),

(12817,12817,100,360,2),
(12817,12803,100,360,2),
(12817,12812,100,360,2),
(12817,12797,100,360,2),
(12817,12788,100,360,2),
(12817,12789,100,360,2),
(12817,12810,100,360,2),

(52874,52874,100,360,2),
(52874,52873,5,1.57,2),

(12847,12847,100,360,2),
(12847,12846,100,360,2),
(12847,12855,100,360,2),
(12847,12856,100,360,2),
-- (12847,12850,100,360,2),
-- (12847,16202,100,360,2),
(12847,12754,100,360,2),
(12847,12841,100,360,2),

(12782,12782,100,360,2),
(12782,12793,5,4.71,2),
(12782,12807,5,1.57,2),
(12782,12815,7,1.57,2),

(12780,12780,100,360,2),
(12780,12791,5,1.57,2),
(12780,12804,5,4.71,2),
(12780,18239,7,4.71,2),

(12866, 12852, 5, 1.57, 2), -- 10
(12866, 12851, 5, 4.71, 2), -- 10
(12866, 12866, 0, 0, 2),

(12746,12746,100,360,2),
(12746,12747,100,360,2),
(12746,12755,100,360,2),
(12746,12820,100,360,2),
(12746,12833,100,360,2),
(12746,12834,100,360,2),
--
(12752,12752,100,360,2),
(12752,12753,100,360,2),
(12752,12842,100,360,2),
(12752,12758,100,360,2),
(12752,12825,100,360,2),
-- 
(12750,12750,100,360,2),
(12750,12751,100,360,2),
(12750,12839,100,360,2),
(12750,12757,100,360,2),
(12750,12823,100,360,2),
--
(12806,12806,100,360,2),
(12806,12819,2,4.7,2),

(12805,12805,100,360,2),
(12805,12814,2,1.5,2),

(52846,52846,100,360,2),
(52846,53054,3,1.5,2),

(53798,53798,100,360,2),
(53798,53799,6,0,2),

-- (53800,53800,100,360,2),
-- (53800,53801,6,0,2),

(53796,53796,100,360,2),
(53796,53797,4,4.7,2);

-- (12794,  242745, 7, 0.69, 2),
-- (12796,  240995, 7, 0.69, 2);

DELETE FROM creature_formations WHERE leaderguid IN (12880,12881,12872,12873);
DELETE FROM creature_formations WHERE memberguid IN (12880,12881,12872,12873);
INSERT INTO creature_formations VALUES
(12880,12880,100,360,2),
(12880,12881,100,360,2),
(12880,12872,100,360,2),
(12880,12873,100,360,2);

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

DELETE FROM `creature_linked_respawn` WHERE `guid` IN (12841,12754,246422,246423,16196,16193,12886,52846,42920,9851,9869,40407,40243,16221,40233,40244,39926,16215,9953,39928,16205,53211,53212,53797,53796,12880,53799,53798,52754,53827,53829,53828,53831,53907,53909,53800,53801,12749,12753,12758,12751,12781,12792,12799,12800,241261,12782,12793,12807,12815,12779,12778,12790,12798,241416,12780,12791,12804,18239,247005,247051,12806,12819,12805,12814,12789,12788,12797,12812,12803,12817,12810,12786,12801,12811,12809,12816,12795,12785,12830,12829,246569,246615,12796,12787,12802,12794,12808,12784,246485,246421,53821,52768,52769,12849,12848,16199,16201,13418,13416,13774,13429,13408,13402,13401,13404,13400,13406,13236,126600,240198,240807,240957,240995,241085,241141,241960,242412,242681,242745,243224,244331,245098);
INSERT INTO `creature_linked_respawn` VALUES

(16196,52479),
(16193,52479),
(12886,52479),

(52846,52760),

(42920,12828),
(9851,12828),
(9869,12828),
(40407,12828),
(40243,12828),
(16221,12828),
(40233,12828),
(40244,12828),
(39926,12828),
(16215,12828),
(9953,12828),
(39928,12828),
(16205,12828),

(53211,52761),
(53212,52761),

(53797,12843),
(53796,12843),
(12880,12843),
(53799,12843),
(53798,12843),
(52754,12843),
(53801,12843),
(53800,12843),

-- should be 12777
(12749,12777),
(12753,12777),
(12758,12777),
(12751,12777),

-- should be 84716
(246422,12777),
(246423,12777),

(12781,12777),
(12792,12777),
(12799,12777),
(12800,12777),
(241261,12777),
(12782,12777),
(12793,12777),
(12807,12777),
(12815,12777),
(12779,12777),
(12778,12777),
(12790,12777),
(12798,12777),
(241416,12777),
(12780,12777),
(12791,12777),
(12804,12777),
(18239,12777),
(247005,12777),
(247051,12777),
(12806,12777),
(12819,12777),
(12805,12777),
(12814,12777),
(12789,12777),
(12788,12777),
(12797,12777),
(12812,12777),
(12803,12777),
(12817,12777),
(12810,12777),
(12786,12777),
(12801,12777),
(12811,12777),
(12809,12777),
(12816,12777),
(12795,12777),
(12785,12777),
(12830,12777),
(12829,12777),
(246569,12777),
(246615,12777),
(12796,12777),
(12787,12777),
(12802,12777),
(12794,12777),
(12808,12777),
(12784,12777),
(246485,12777),
(246421,12777),

(53827,52458),
(53829,52458),
(53828,52458),
(53831,52458),
(53907,52458),
(53909,52458),
(53821,52458),
(52768,52458),
(52769,52458),

(12754,40527),
(12841,40527),
(12849,40527),
(12848,40527),
(16199,40527),
(16201,40527),
(13418,40527),
(13416,40527),
(13774,40527),
(13429,40527),
(13408,40527),
(13402,40527),
(13401,40527),
(13404,40527),
(13400,40527),
(13406,40527),
(13236,40527);

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

-- General
UPDATE `creature_addon` SET `bytes1` = 8 WHERE `guid` IN (12779,12781,12790,12799); -- 1
UPDATE `creature_addon` SET `bytes1` = 0 WHERE `guid` IN (12785,12786,12795,12801,12809); -- 8
UPDATE `creature_addon` SET `bytes1` = 8 WHERE `guid` = 12800; -- 0
UPDATE `creature_addon` SET `emote` = 0 WHERE `guid` = 12789; -- 378
UPDATE `creature_addon` SET `path_id` = 0 WHERE `guid` = 12793;
DELETE FROM `creature_addon` WHERE `guid` = 18239;
UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0 WHERE `guid` IN (18239,12793,12815,12807);

-- Specific

UPDATE `creature` SET `position_x`='265.8057', `position_y`='885.8453', `position_z`='-25.7932' WHERE `guid` = 12853;

UPDATE `creature` SET `currentwaypoint` = '5' WHERE `guid` = 12737;

UPDATE `creature` SET `currentwaypoint` = 4 WHERE `guid` = 53912;

UPDATE `creature` SET `currentwaypoint` = '5', `MovementType`='2' WHERE `guid` = 53829;
DELETE FROM `creature_addon` WHERE `guid` = 53829;
INSERT INTO `creature_addon` VALUES
(53829, 53827, 24725, 512, 0, 4097, 0, 1024, '');   

DELETE FROM `creature_addon` WHERE `guid` IN (53827,53828);
INSERT INTO `creature_addon` VALUES
(53827, 0, 24725, 512, 0, 4097, 0, 0, ''),  
(53828, 0, 24725, 512, 0, 4097, 0, 0, '');

UPDATE `creature` SET `position_x`='777.311829', `position_y`='851.671875', `position_z`='59.054199', `orientation`='5.1064',`spawndist`='0',`movementtype`='0' WHERE `guid` = 53827;
UPDATE `creature` SET `position_x`='801.692261', `position_y`='853.007812', `position_z`='60.433735', `orientation`='4.1497',`spawndist`='0',`movementtype`='0' WHERE `guid` = 53828;

SET @GUID := 52874;
SET @POINT := 0;
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,NULL);
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, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 702.7473, 801.6859, 62.1615,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 702.6610, 794.3372, 63.3655,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 702.7971, 690.7724, 72.1014,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 702.7948, 696.1107, 71.6445,0,0,0,100,0);

UPDATE `creature` SET `position_x`='449.290985', `position_y`='790.747986', `position_z`='12.031914', `orientation`='2.076940' WHERE `guid` = 12846;
UPDATE `creature` SET `position_x`='454.178986', `position_y`='802.715027', `position_z`='12.097442', `orientation`='3.385940' WHERE `guid` = 12855;
UPDATE `creature` SET `position_x`='442.347992', `position_y`='790.156982', `position_z`='12.028371', `orientation`='1.466080' WHERE `guid` = 12856;
-- INSERT INTO `creature` VALUES (12850, 22874, 564, 1, 0, 0, 446.81, 810.571, 12.1399, 4.56447, 7200, 0, 0, 172000, 129240, 0, 0);
-- INSERT INTO `creature` VALUES (16202, 22885, 564, 1, 0, 0, 440.881, 810.689, 12.1405, 4.73333, 7200, 0, 0, 102000, 0, 0, 0);

UPDATE `creature` SET `position_x`='599.337952', `position_y`='904.976135', `position_z`='59.033104', `orientation`='2.514592' WHERE `guid` = 26677;

SET @GUID := 53054;
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 (53054, 1, 833.48, 523.838, 165.731, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 2, 820.928, 518.631, 165.988, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 3, 815.696, 514.767, 166.104, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 4, 815.656, 506.274, 170.29, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 5, 815.522, 493.552, 180.4, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 6, 815.273, 477.568, 192.706, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 7, 815.569, 467.024, 192.791, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 8, 815.274, 477.438, 192.706, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 9, 815.522, 493.567, 180.4, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 10, 815.656, 506.292, 170.29, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 11, 814.793, 512.636, 166.104, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 12, 820.021, 518.023, 165.988, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 13, 834.557, 524.627, 165.731, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 14, 840.495, 531.905, 165.753, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 15, 840.718, 540.302, 165.679, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 16, 849.122, 540.508, 165.822, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 17, 862.165, 540.535, 156.232, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 18, 874.748, 540.406, 146.189, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 19, 890.828, 540.022, 139.304, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 20, 874.789, 540.405, 146.189, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 21, 862.202, 540.535, 156.232, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 22, 849.189, 540.509, 165.822, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 23, 843.528, 542.474, 165.679, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53054, 24, 839.879, 530.768, 165.753, 0, 0, 0, 100, 0);

SET @GUID := 52846;
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 (52846, 1, 832.29, 526.592, 165.731, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 2, 818.831, 520.776, 165.988, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 3, 812.696, 514.781, 166.104, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 4, 812.656, 506.306, 170.29, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 5, 812.523, 493.598, 180.4, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 6, 812.274, 477.484, 192.706, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 7, 812.571, 466.939, 192.791, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 8, 812.274, 477.484, 192.706, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 9, 812.523, 493.598, 180.4, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 10, 812.656, 506.306, 170.29, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 11, 812.696, 514.781, 166.104, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 12, 818.831, 520.776, 165.988, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 13, 832.29, 526.592, 165.731, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 14, 837.612, 532.732, 165.753, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 15, 840.644, 543.301, 165.679, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 16, 849.115, 543.508, 165.822, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 17, 862.196, 543.535, 156.232, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 18, 874.82, 543.405, 146.189, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 19, 883.0063, 543.1736, 139.6635, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 20, 890.899, 543.021, 139.304, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 21, 896.5783, 542.9110, 139.3039, 0, 0, 0, 100, 0); 
INSERT INTO `waypoint_data` VALUES (52846, 22, 883.0063, 543.1736, 139.6635, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 23, 874.82, 543.405, 146.189, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 24, 862.196, 543.535, 156.232, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 25, 849.115, 543.508, 165.822, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 26, 840.644, 543.301, 165.679, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52846, 27, 837.612, 532.732, 165.753, 0, 0, 0, 100, 0);

SET @GUID := 12886;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12886, 1, 624.821, 173.841, 253.243, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 2, 640.569, 173.921, 245.059, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 3, 642.414, 149.818, 245.051, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 4, 639.994, 127.37, 245.058, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 5, 626.282, 127.041, 251.905, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 6, 611.546, 126.554, 258.893, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 7, 606.469, 138.467, 258.76, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 8, 607.16, 162.469, 258.751, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 9, 613.019, 175.03, 258.94, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12886, 10, 624.821, 173.841, 253.243, 0, 0, 0, 100, 0);

SET @GUID := 12782;
SET @POINT := 0;
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,NULL);
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, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 495.7767, 354.6180, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 477.3133, 365.3570, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 480.2561, 363.5315, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 495.7767, 354.6180, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 503.9439, 358.6741, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 524.2752, 370.0444, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 534.4701, 385.5416, 112.7836,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 532.5229, 379.8294, 112.7836,0,0,0,100,0);

SET @GUID := 53796;
SET @POINT := 0;
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,NULL);
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, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 434.8668, 243.5092, 164.7588,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 434.9193, 239.2255, 164.7675,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 434.8668, 243.5092, 164.7588,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 434.9783, 279.1066, 179.6963,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 435.2803, 310.2175, 192.7752,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 435.2467, 320.0552, 192.7752,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 435.2803, 310.2175, 192.7752,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 434.9783, 279.1066, 179.6963,0,0,0,100,0);

SET @GUID := 42920;
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,NULL);
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (42920, 1, 629.089, 47.3309, 112.777, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (42920, 2, 601.507, 37.5607, 112.735, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (42920, 3, 575.11, 56.3028, 111.031, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (42920, 4, 601.277, 37.4792, 112.741, 0, 0, 0, 100, 0);

DELETE FROM `creature_addon` WHERE `guid` IN (52480,52481);
INSERT INTO `creature_addon` VALUES 
(52480, 0, 0, 512, 8, 4097, 0, 0, ''),
(52481, 0, 0, 512, 8, 4097, 0, 0, '');

SET @GUID := 53816;
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,16908544,0,4097,0,0,NULL);
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (53816, 1, 775.079, 766.952, 66.1695, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 2, 776.475, 758.128, 68.5918, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 3, 776.724, 748.545, 70.0428, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 4, 771.158, 744.486, 69.7692, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 5, 776.724, 748.545, 70.0428, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 6, 776.475, 758.128, 68.5918, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 7, 775.079, 766.952, 66.1695, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 8, 776.642, 775.294, 65.648, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 9, 779.1, 781.978, 65.9348, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 10, 776.998, 791.397, 65.6326, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 11, 779.1, 781.978, 65.9348, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (53816, 12, 776.642, 775.294, 65.648, 0, 0, 0, 100, 0);

SET @GUID := 52418;
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, 16908544, 0, 4097, 0, 0, '41248 0'); 
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (52418, 1, 617.44, 102.765, 112.751, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52418, 2, 601.631, 74.0624, 111.239, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52418, 3, 578.161, 98.9663, 113.047, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52418, 4, 601.55, 73.9752, 111.243, 0, 0, 0, 100, 0);

SET @GUID := 52420;
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, 16908544, 0, 4097, 0, 0, '41248 0'); 
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (52420, 1, 620.916, 30.2202, 112.736, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52420, 2, 607.715, 64.6145, 111.726, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52420, 3, 589.44, 39.2402, 112.765, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52420, 4, 607.578, 64.4233, 111.72, 0, 0, 0, 100, 0);

SET @GUID := 52423;
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, 16908544, 0, 4097, 0, 0, '41248 0'); 
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (52423, 1, 512.155, 30.0493, 113.648, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52423, 2, 487.486, 43.7172, 112.325, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52423, 3, 512.155, 30.0493, 113.648, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52423, 4, 550.625, 48.4656, 112.568, 0, 0, 0, 100, 0);

SET @GUID := 52424;
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, 16908544, 0, 4097, 0, 0, '41248 0'); 
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (52424, 1, 518.947, 74.61, 112.913, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52424, 2, 473.218, 73.2273, 111.846, 0, 0, 0, 100, 0);

SET @GUID := 52427;
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, 16908544, 0, 4097, 0, 0, '41248 0'); 
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (52427, 1, 552.323, 97.9542, 112.481, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52427, 2, 536.094, 78.042, 113.071, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52427, 3, 552.323, 97.9542, 112.481, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (52427, 4, 573.458, 103.49, 113.186, 0, 0, 0, 100, 0);

SET @GUID := 12780;
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,16777472,0,4097,0,0,NULL);
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12780, 1, 478.281, 443.979, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12780, 2, 526.059, 429.854, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12780, 3, 535.645, 409.609, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12780, 4, 526.018, 432.29, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12780, 5, 483.452, 438.467, 112.784, 0, 0, 0, 100, 0);

SET @GUID := 13405;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13405, 1, 251.44, 759.29, -27.23, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 2, 217.36, 759.36, -23.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 3, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 4, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 5, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 6, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 7, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 8, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 9, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 10, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 11, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 12, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 13, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 14, 216.84, 1048.74, -59.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 15, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 16, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 17, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 18, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 19, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 20, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 21, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 22, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 23, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 24, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 25, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13405, 26, 217.36, 759.36, -23.86, 0, 0, 0, 100, 0);

SET @GUID := 13429;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13429, 1, 229.7791, 1071.0634, -60.7522, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 2, 229.4675, 1055.7926, -60.7067, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 3, 216.84, 1048.74, -59.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 4, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 5, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 6, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 7, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 8, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 9, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 10, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 11, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 12, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 13, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 14, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 15, 217.36, 759.36, -23.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 16, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 17, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 18, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 19, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 20, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 21, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 22, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 23, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 24, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 25, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 26, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 27, 216.84, 1048.74, -59.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 28, 229.4675, 1055.7926, -60.7067, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 29, 229.7791, 1071.0634, -60.7522, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13429, 30, 224.4049, 1088.6700, -60.7743, 0, 0, 0, 100, 0);

SET @GUID := 13774;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13774, 1, 229.7791, 1071.0634, -60.7522, 20000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 2, 229.4675, 1055.7926, -60.7067, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 3, 216.84, 1048.74, -59.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 4, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 5, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 6, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 7, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 8, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 9, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 10, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 11, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 12, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 13, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 14, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 15, 217.36, 759.36, -23.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 16, 225.43, 782.14, -24.39, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 17, 227.67, 805.59, -24.22, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 18, 219.13, 812.14, -24.17, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 19, 228.22, 841.06, -23.87, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 20, 219.55, 860.39, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 21, 227.97, 877.38, -24.26, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 22, 221.87, 886.87, -24.52, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 23, 224.47, 958.78, -60.14, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 24, 225.26, 976.52, -61.56, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 25, 216.84, 996.08, -61.48, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 26, 229.36, 1021.73, -61.49, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 27, 216.84, 1048.74, -59.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 28, 229.4675, 1055.7926, -60.7067, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 29, 229.7791, 1071.0634, -60.7522, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13774, 30, 224.4049, 1088.6700, -60.7743, 0, 0, 0, 100, 0);

SET @GUID := 13403;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13403, 1, 286.43, 1048.05, -60, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 2, 274.88, 1019.67, -60.75, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 3, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 4, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 5, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 6, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 7, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 8, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 9, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 10, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 11, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 12, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 13, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 14, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 15, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13403, 16, 274.88, 1019.67, -60.75, 0, 0, 0, 100, 0);

SET @GUID := 13416;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13416, 1, 295.4839, 969.7720, -60.9073, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 2, 293.6034, 980.6284, -60.4646, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 3, 276.6246, 981.1029, -60.2640, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 4, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 5, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 6, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 7, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 8, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 9, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 10, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 11, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 12, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 13, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 14, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 15, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 16, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 17, 276.6246, 981.1029, -60.2640, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 18, 293.6034, 980.6284, -60.4646, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13416, 19, 295.4839, 969.7720, -60.9073, 0, 0, 0, 100, 0);

SET @GUID := 13418;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13418, 1, 295.4839, 969.7720, -60.9073, 15000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 2, 293.6034, 980.6284, -60.4646, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 3, 276.6246, 981.1029, -60.2640, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 4, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 5, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 6, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 7, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 8, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 9, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 10, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 11, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 12, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 13, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 14, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 15, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 16, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 17, 276.6246, 981.1029, -60.2640, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 18, 293.6034, 980.6284, -60.4646, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13418, 19, 295.4839, 969.7720, -60.9073, 0, 0, 0, 100, 0);

SET @GUID := 13407;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13407, 1, 286.43, 1048.05, -60, 20000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 2, 274.88, 1019.67, -60.75, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 3, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 4, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 5, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 6, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 7, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 8, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 9, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 10, 277.3314, 842.3016, -24.2162, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 11, 284.51, 860.11, -23.27, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 12, 276.59, 870.45, -24.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 13, 276.64, 885.94, -24.15, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 14, 279.9772, 924.4305, -43.3291, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 15, 276.16, 957.98, -60.16, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13407, 16, 274.88, 1019.67, -60.75, 0, 0, 0, 100, 0);

SET @GUID := 13410;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13410, 1, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 2, 291.14, 826.66, -22.94, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 3, 332.54, 826.46, -4.84, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 4, 341.42, 824.14, -0.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 5, 349.66, 826.58, 1.78, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 6, 388.74, 826.42, 15.69, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 7, 405.79, 826.48, 14.46, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 8, 388.74, 826.42, 15.69, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 9, 349.66, 826.58, 1.78, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 10, 341.42, 824.14, -0.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 11, 332.54, 826.46, -4.84, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13410, 12, 291.14, 826.66, -22.94, 0, 0, 0, 100, 0);

SET @GUID := 13411;
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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13411, 1, 275.65, 826.39, -24.41, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 2, 291.14, 826.66, -22.94, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 3, 332.54, 826.46, -4.84, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 4, 341.42, 824.14, -0.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 5, 349.66, 826.58, 1.78, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 6, 388.74, 826.42, 15.69, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 7, 405.79, 826.48, 14.46, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 8, 406.1925, 844.5750, 14.6775, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 9, 398.2640, 864.1204, 14.9389, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 10, 408.9743, 875.9220, 14.0330, 5000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 11, 398.2640, 864.1204, 14.9389, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 12, 406.1925, 844.5750, 14.6775, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 13, 405.79, 826.48, 14.46, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 14, 388.74, 826.42, 15.69, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 15, 349.66, 826.58, 1.78, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 16, 341.42, 824.14, -0.86, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 17, 332.54, 826.46, -4.84, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13411, 18, 291.14, 826.66, -22.94, 0, 0, 0, 100, 0);

UPDATE `waypoint_data` SET `move_type` = 0 WHERE `id` = 13412;

SET @GUID := 13413;
UPDATE `creature` SET `position_x`='286.8793', `position_y`='799.1722', `position_z`='-24.2530', `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,16908544,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13413, 1, 279.07, 799, -24.25, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 2, 289.22, 799.62, -24.23, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 3, 346.48, 799.92, -0.28, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 4, 354.12, 798.57, 2.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 5, 389.46, 800.64, 14.13, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 6, 406.17, 799.02, 14.91, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 7, 389.46, 800.64, 14.13, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 8, 354.12, 798.57, 2.07, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 9, 346.48, 799.92, -0.28, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13413, 10, 289.22, 799.62, -24.23, 0, 0, 0, 100, 0);

SET @GUID := 12869;
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,16908544,0,4097,0,0,'18950 0');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12869, 1, 252.726, 915.427, -41.2835, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 2, 252.709, 958.494, -62.6302, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 3, 252.587, 968.839, -62.6023, 3000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 4, 252.709, 958.494, -62.6302, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 5, 252.726, 915.427, -41.2835, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 6, 252.71, 888.408, -28.1103, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 7, 252.661, 875.529, -27.0654, 3000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12869, 8, 252.71, 888.408, -28.1103, 0, 0, 0, 100, 0);

UPDATE `creature` SET `position_x`='712.9567', `position_y`='387.4395', `position_z`='117.7117', `orientation`='1.5677' WHERE `guid` = 12746;
UPDATE `creature` SET `position_x`='694.8687', `position_y`='387.4951', `position_z`='117.7328', `orientation`='1.5677' WHERE `guid` = 12747; 
UPDATE `creature` SET `position_x`='697.5386', `position_y`='383.8868', `position_z`='119.9242', `orientation`='1.5677' WHERE `guid` = 12755; 
UPDATE `creature` SET `position_x`='710.2506', `position_y`='383.8477', `position_z`='119.9090', `orientation`='1.5677' WHERE `guid` = 12820;
UPDATE `creature` SET `position_x`='719.8175', `position_y`='385.3928', `position_z`='118.9384', `orientation`='1.5677' WHERE `guid` = 12833;
UPDATE `creature` SET `position_x`='687.7366', `position_y`='385.4914', `position_z`='118.9758', `orientation`='1.5677' WHERE `guid` = 12834;

SET @GUID := 12806;
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,512,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12806, 1, 485.9926, 406.4437, 112.7849, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12806, 2, 488.9220, 406.4711, 112.7849, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12806, 3, 526.5108, 406.2319, 112.785, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12806, 4, 524.5601, 406.2302, 112.785, 0, 0, 0, 100, 0);

SET @GUID := 12805;
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,512,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12805, 1, 526.6975, 395.3765, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12805, 2, 524.4810, 395.3703, 112.784, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12805, 3, 485.7506, 395.6316, 112.7838, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12805, 4, 488.6212, 395.5325, 112.7838, 0, 0, 0, 100, 0);

-- those stairs drive me crazy
SET @GUID := 53800;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 575.3708, 110.8513, 139.4759,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 586.7089, 110.7460, 139.3130,5000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 575.3708, 110.8513, 139.4759,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 573.7471, 110.8180, 140.8192,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 541.8935, 110.9994, 165.9266,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 528.6511, 110.9819, 165.3688,5000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 542.1239, 111.1832, 165.9393,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 543.0819, 111.0051, 165.2134,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 573.7471, 110.8180, 140.8192,0,0,0,100,0);

SET @GUID := 53801;
SET @POINT := 0;
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` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
-- (@GUID,@POINT := @POINT + 1, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 575.3708, 110.8513, 139.4759,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 580.7092, 110.8015, 139.3103,8000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 575.3708, 110.8513, 139.4759,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 573.7471, 110.8180, 140.8192,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 541.8935, 110.9994, 165.9266,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 535.1976, 110.8754, 165.7051,8000,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 542.1239, 111.1832, 165.9393,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 543.0819, 111.0051, 165.2134,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 573.7471, 110.8180, 140.8192,0,0,0,100,0);

SET @GUID := 53798;
SET @POINT := 0;
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,NULL);
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, XXX, YYY, ZZZ,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 494.1227, 170.0645, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 489.4893, 170.1348, 163.9814,0,0,0,100,0), 
(@GUID,@POINT := @POINT + 1, 437.9820, 176.2317, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 437.7856, 180.4702, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 436.4199, 209.9411, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 446.7656, 209.7393, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 494.2183, 209.3279, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 489.7312, 209.4832, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 436.4199, 209.9411, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 436.7008, 203.8786, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 437.9820, 176.2317, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 448.7488, 170.3644, 163.9814,0,0,0,100,0),
(@GUID,@POINT := @POINT + 1, 458.2099, 170.2440, 163.9810,0,0,0,100,0);

UPDATE `creature` SET `position_x`='817.6086', `position_y`='489.8837', `position_z`='183.3297', `orientation`='1.5514',`spawndist`='0',`movementtype`='0' WHERE `guid` = 53054;

UPDATE `creature` SET `orientation` = '0.3351' WHERE `guid` = 12810;

UPDATE `creature` SET `MovementType` = 0, `spawndist` = 0 WHERE `guid` IN (12784,12787,12802,12808,12821,12824,12835,12840,12851,12852,52447,52449);

SET @GUID := 13412;
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,16908544,0,4097,0,0,''); -- 12873
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (13412, 1, 225.599, 787.167, -24.1854, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 2, 226.255, 784.008, -23.9493, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 3, 219.755, 774.258, -23.4493, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 4, 219.399, 766.433, -23.471, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 5, 225.785, 743.861, -23.8015, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 6, 225.859, 730.236, -15.9509, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 7, 226.609, 726.486, -13.9509, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 8, 236.528, 706.583, -4.81124, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 9, 265.267, 707.321, -4.30114, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 10, 272.355, 719.12, -10.1958, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 11, 275.13, 743.173, -24.0094, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 12, 279.329, 758.15, -23.9057, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 13, 281.99, 760.675, -23.696, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 14, 282.882, 767.979, -23.4587, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 15, 277.356, 793.042, -24.1517, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 16, 285.965, 799.731, -23.8582, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 17, 292.121, 799.703, -22.6732, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 18, 303.121, 795.203, -17.1732, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 19, 295.627, 798.385, -20.6824, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 20, 286.127, 799.635, -23.9324, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 21, 276.864, 782.945, -23.9255, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 22, 282.114, 770.695, -23.4255, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 23, 279.363, 758.279, -24.0036, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 24, 275.226, 743.77, -24.0494, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 25, 272.431, 719.382, -10.38, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 26, 266.067, 708.079, -4.45915, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 27, 258.067, 704.329, -4.95915, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 28, 236.291, 706.643, -3.6331, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 29, 226.627, 726.214, -13.6222, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 30, 225.89, 730.388, -15.9331, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 31, 226.062, 743.571, -23.9032, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 32, 220.638, 762.828, -23.166, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 33, 218.63, 769.206, -23.467, 0, 1, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (13412, 34, 226.297, 784.119, -24.1624, 0, 1, 0, 100, 0);

SET @GUID := 12826;
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,16777472,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12826, 1, 608.289, 313.645, 112.705, 2000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 2, 609.0838, 320.8728, 112.7056, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 3, 616.423, 387.615, 112.713, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 4, 645.102, 412.355, 112.713, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 5, 695.16, 413.139, 112.735, 2000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 6, 691.5309, 413.0821, 112.7346, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 7, 645.102, 412.355, 112.713, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12826, 8, 616.423, 387.615, 112.713, 0, 0, 0, 100, 0);

SET @GUID := 12827;
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,16777472,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id` = @GUID;
INSERT INTO `waypoint_data` VALUES (12827, 1, 798.3474, 312.9170, 112.7486, 2000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 2, 798.0026, 319.1691, 112.7481, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 3, 796.152, 379.841, 112.747, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 4, 765.0722, 410.3952, 112.7434, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 5, 712.2567, 412.4319, 112.7470, 2000, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 6, 717.1557, 412.5141, 112.7488, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 7, 765.0722, 410.3952, 112.7434, 0, 0, 0, 100, 0);
INSERT INTO `waypoint_data` VALUES (12827, 8, 796.152, 379.841, 112.747, 0, 0, 0, 100, 0);

UPDATE `creature` SET `position_x`='558.3591', `position_y`='296.2860', `position_z`='271.6911', `orientation`='0.0527',`spawndist`='0',`movementtype`='0' WHERE `guid` = 52413;
UPDATE `creature` SET `orientation`='6.2181' WHERE `guid` = 16195;

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

-- 185483

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

-- Creatures
DELETE FROM `creature_loot_template` WHERE `entry` = 22844;
INSERT INTO `creature_loot_template` VALUES (22844, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 21877, 37.85, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24012, 0.5, 1, -24012, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24014, 0.5, 1, -24014, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24015, 0.1, 1, -24015, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 32428, 13.88, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22844, 32897, 5.36, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 22845;
INSERT INTO `creature_loot_template` VALUES (22845, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 21877, 42.48, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 50028, 0.05, 1, -50028, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 32428, 12.03, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22845, 32897, 12.41, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 22846;
INSERT INTO `creature_loot_template` VALUES (22846, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 21877, 40.1, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 24014, 0.5, 1, -24014, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 50028, 0.05, 1, -50028, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 32428, 6.28, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22846, 32897, 8.21, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 22847;
INSERT INTO `creature_loot_template` VALUES (22847, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 21877, 38.14, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 22153, 0.93, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 50028, 0.05, 1, -50028, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 32428, 11.63, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22847, 32897, 10.23, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 22962;
INSERT INTO `creature_loot_template` VALUES (22962, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 21877, 36.02, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 32428, 13.98, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22962, 32897, 5.91, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 23374;
INSERT INTO `creature_loot_template` VALUES (23374, 79, 0.01, 1, -10006, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 14099, 1.5, 0, -14099, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 21877, 41.05, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 24001, 5, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 24002, 5, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 32428, 10.92, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 32897, 10.48, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (23374, 50028, 0.05, 1, -50028, 1, 0, 0, 0);

-- missing something
DELETE FROM `creature_loot_template` WHERE `entry` = 22874 AND `item` = 32897;
INSERT INTO `creature_loot_template` VALUES (22874, 32897, 8.21, 0, 1, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` = 23049 AND `item` = 50028;
INSERT INTO `creature_loot_template` VALUES (23049, 50028, 0.05, 1, -50028, 1, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE `entry` IN (23196,23147,23047,23018,22965,22963,22959,22957,22964,22956,22883,22879,23339,23330,23239,23237,23236,23235,23232,22946,23049,23222,23223) AND `item` = 14099;
INSERT INTO `creature_loot_template` VALUES
(23196, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(23047, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(23018, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(22965, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(22959, 14099, 1.5, 0, -14099, 1, 0, 0, 0),   
(22957, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(22964, 14099, 1.5, 0, -14099, 1, 0, 0, 0), 
(22956, 14099, 1.5, 0, -14099, 1, 0, 0, 0), 
(22879, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23339, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23330, 14099, 1.5, 0, -14099, 1, 0, 0, 0),  
(23239, 14099, 1.5, 0, -14099, 1, 0, 0, 0), 
(23237, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23236, 14099, 1.5, 0, -14099, 1, 0, 0, 0), 
(23235, 14099, 1.5, 0, -14099, 1, 0, 0, 0), 
(23232, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(22946, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23049, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23222, 14099, 1.5, 0, -14099, 1, 0, 0, 0),
(23223, 14099, 1.5, 0, -14099, 1, 0, 0, 0);

-- Boss Loot Changes

-- Mother Shahraz Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 22947 AND `item` = 34076;

-- Council
DELETE FROM `creature_loot_template` WHERE `entry` IN (22949,22950,22952);
INSERT INTO `creature_loot_template` VALUES (22949, 31098, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22949, 31099, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22949, 31100, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 29434, 0, 0, 2, 2, 0, 0, 0);
-- INSERT INTO `creature_loot_template` VALUES (22950, 31098, 0, 2, 1, 1, 0, 0, 0);
-- INSERT INTO `creature_loot_template` VALUES (22950, 31099, 0, 2, 1, 1, 0, 0, 0);
-- INSERT INTO `creature_loot_template` VALUES (22950, 31100, 0, 2, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32331, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32373, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32376, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32505, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32518, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22950, 32519, 0, 1, 1, 1, 0, 0, 0);
-- 22951 Epic GEM
INSERT INTO `creature_loot_template` VALUES (22952, 31098, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22952, 31099, 0, 1, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (22952, 31100, 0, 1, 1, 1, 0, 0, 0);

-- Illidan Stormrage <The Betrayer> Token
UPDATE `creature_loot_template` SET `maxcount` = 2 WHERE `entry` = 22917 AND `item` = 34077;
DELETE FROM `creature_loot_template` WHERE `entry` = 22917 AND `item` IN (90077,90078);

-- Badge of Justice for Hyjal and BT
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 0 WHERE `entry` IN (22887,22898,22841,22871,22948,22856,22947,23426,22917,23420,22950,17767,17808,17842,17888,17968) AND `item` = 29434;

-- ===========
-- Overall Loot Issues
-- ===========

-- epics which should not be listed directly in creature_loot_template
-- includes random epics and patterns and epic gems
DELETE FROM `creature_loot_template` WHERE `item` IN (32526,32527,32528,32589,32590,32591,32592,32593,32606,32608,32609,32943,32945,32946,34009,34010,34011,34012,32736,32737,32738,32739,32744,32745,32746,32747,32748,32749,32750,32751,32752,32753,32754,32755);

DELETE FROM `reference_loot_template` WHERE `entry` = 14099 AND `item` = 32526;
INSERT INTO `reference_loot_template` VALUES
(14099, 32526, 0, 1, 1, 1, 0, 0, 0);

-- BT Random Epics Reference -14099 9 out of 18
-- Hyjal Random Epics Reference -39534 9 out of 18
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 2 WHERE `mincountOrRef` IN (-14099,-39534); -- 1.5 / 2

-- no need for patterns in the hyjal random epic items template
DELETE FROM `reference_loot_template` WHERE `entry` = 39534 AND `item` IN (32736,32739,32745,32746,32748,32751,32752,32755);

-- Pattern Drop Reference Loot Template some drop only Hyjal(3&4) some drop only BT(1&2)
-- Some have Profession Loot Restrictions with higher % (creature_loot)(Groupid 1&3) some have no Restrictions but lower % (Groupid 2&4)
DELETE FROM `reference_loot_template` WHERE `entry` = 34069;
INSERT INTO `reference_loot_template` VALUES (34069, 32736, 0, 3, 1, 1, 7, 164, 1); -- Hyjal only
INSERT INTO `reference_loot_template` VALUES (34069, 32739, 0, 4, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32745, 0, 4, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32746, 0, 3, 1, 1, 7, 165, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32748, 0, 3, 1, 1, 7, 165, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32751, 0, 4, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32752, 0, 3, 1, 1, 7, 197, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32755, 0, 4, 1, 1, 0, 0, 0);

INSERT INTO `reference_loot_template` VALUES (34069, 32737, 0, 2, 1, 1, 0, 0, 0); -- BT only
INSERT INTO `reference_loot_template` VALUES (34069, 32738, 0, 1, 1, 1, 7, 164, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32744, 0, 1, 1, 1, 7, 165, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32747, 0, 2, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32749, 0, 2, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32750, 0, 1, 1, 1, 7, 165, 1);
INSERT INTO `reference_loot_template` VALUES (34069, 32753, 0, 2, 1, 1, 0, 0, 0);
INSERT INTO `reference_loot_template` VALUES (34069, 32754, 0, 1, 1, 1, 7, 197, 1);

-- Patterns
DELETE FROM `creature_loot_template` WHERE `mincountOrRef` =  -34069;
INSERT INTO `creature_loot_template` VALUES

-- Hyjal 3&4
(17895, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17895, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17897, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17897, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17898, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17898, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17899, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17899, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17905, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17905, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17906, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17906, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17907, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17907, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17908, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17908, 90069, 1, 4, -34069, 1, 0, 0, 0),

(17916, 34069, 1, 3, -34069, 1, 0, 0, 0),
(17916, 90069, 1, 4, -34069, 1, 0, 0, 0),

-- BT 1&2
(22844, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22844, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22845, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22845, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22846, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22846, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22847, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22847, 90069, 1, 2, -34069, 1, 0, 0, 0), 

(22853, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22853, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22855, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22855, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22869, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22869, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22879, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22879, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22880, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22880, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22882, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22882, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22939, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22939, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22945, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22945, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22946, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22946, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22953, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22953, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22954, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22954, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22955, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22955, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22956, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22956, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22957, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22957, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22959, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22959, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22962, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22962, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22964, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22964, 90069, 1, 2, -34069, 1, 0, 0, 0),

(22965, 34069, 1, 1, -34069, 1, 0, 0, 0),
(22965, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23018, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23018, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23047, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23047, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23049, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23049, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23172, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23172, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23196, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23196, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23222, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23222, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23223, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23223, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23232, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23232, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23235, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23235, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23236, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23236, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23237, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23237, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23239, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23239, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23330, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23330, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23337, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23337, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23339, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23339, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23374, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23374, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23394, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23394, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23397, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23397, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23400, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23400, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23402, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23402, 90069, 1, 2, -34069, 1, 0, 0, 0),

(23403, 34069, 1, 1, -34069, 1, 0, 0, 0),
(23403, 90069, 1, 2, -34069, 1, 0, 0, 0);

UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = 1 WHERE `mincountOrRef` IN (-14099,-39534,-34069); -- 1.5 / 2

-- Heart of Darkness 32428 seems ok
-- Mark of the Illidari 32897 seems ok

-- Epic GEMs
DELETE FROM `creature_loot_template` WHERE `item` IN (32227,32228,32229,32230,32231,32249);

DELETE FROM `creature_loot_template` WHERE `mincountOrRef` = -34093;
INSERT INTO `creature_loot_template` VALUES
(22844, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22845, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22846, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22847, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22853, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22855, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22869, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22873, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22874, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22875, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22876, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22877, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22878, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22879, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22880, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22881, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22882, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22884, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22885, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22939, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22945, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22946, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22951, 34093, 100, 1, -34093, 1, 0, 0, 0),
(22953, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22954, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22955, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22956, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22957, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22959, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22964, 34093, 6, 1, -34093, 1, 0, 0, 0),
(22965, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23018, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23047, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23049, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23172, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23196, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23222, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23223, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23232, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23235, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23236, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23237, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23239, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23330, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23337, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23339, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23394, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23397, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23400, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23402, 34093, 6, 1, -34093, 1, 0, 0, 0),
(23403, 34093, 6, 1, -34093, 1, 0, 0, 0),
(25593, 34093, 6, 1, -34093, 1, 0, 0, 0),
(25595, 34093, 6, 1, -34093, 1, 0, 0, 0);

[AnonXS]

Placeholder