UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='18721');
UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='20212');
UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='20213');
UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='21122');
UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='21987');
UPDATE `creature_template` SET `civilian`='1' WHERE (`entry`='22517');
UPDATE `creature_template` SET `flags`='33555200',`civilian`='1' WHERE (`entry`='23472');
-- High Warlord Naj'entus
Update `creature_template` set `armor`='2000', `spell1`='39837', `spell2`='39835' where `entry` in (22887);
-- Teron Gorefiend
Update `creature_template` set `armor`='2000', `spell1`='24239', `spell2`='40157', `spell3`='40314' where `entry` in (22871);
-- Gurtogg Bloodboil
Update `creature_template` set `armor`='2000', `spell1`='40599', `spell2`='40595', `spell3`='42005' where `entry` in (22948);
-- Mother Shahraz
Update `creature_template` set `armor`='2000', `spell1`='40827', `spell2`='40860' where `entry` in (22947);
-- Illidan Stormrage
Update `creature_template` set `armor`='2000', `spell1`='37462', `spell2`='36921', `spell3`='42395' where `entry` in (22917);

update `creature_template` set `faction_a`='35', `faction_h`='35' where `entry`='15760';
-- Essence of Desire
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (23419);
-- Essence of Suffering
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (23418);
-- Essence of Anger
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (23420);
-- Gathios the Shatterer
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22949);
-- Gurtogg Bloodboil
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22948);
-- High Nethermancer Zerevor
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22950);
-- High Warlord Naj'entus
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22887);
-- Illidan Stormrage <The Betrayer>
Update `creature_template` set `flags`='8', `mindmg`='3500', `maxdmg`='5500', attackpower='15750', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22917);
-- Lady Malande
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22951);
-- Mother Shahraz
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22947);
-- Shade of Akama
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22841);
-- Supremus
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22898);
-- Teron Gorefiend
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22871);
-- Veras Darkshadow
Update `creature_template` set `flags`='8', `mindmg`='2900', `maxdmg`='4500', attackpower='12950', `rank`='3', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20' where `entry` in (22952);



-- Akil'zon
Update `creature_template` set `flags`='8', `armor`='1000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='43661', `spell2`='44008', `ScriptName`='generic_creature' where `entry` in (23574);
-- Nalorakk
Update `creature_template` set `flags`='8', `armor`='1000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='42402', `spell2`='42384', `spell3`='42395', `ScriptName`='generic_creature' where `entry` in (23576);
-- Halazzi
Update `creature_template` set `flags`='8', `armor`='1000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='42395', `spell2`='43303', `ScriptName`='generic_creature' where `entry` in (23577);
-- Jan'alai
Update `creature_template` set `flags`='8', `armor`='1000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='36921', `spell2`='42395', `spell3`='43661', `ScriptName`='generic_creature' where `entry` in (23578);
-- Hex Lord Malacrass
Update `creature_template` set `flags`='8', `armor`='1000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='42395', `spell2`='37462', `spell3`='36921', `ScriptName`='generic_creature' where `entry` in (24239);
-- Zul'jin
Update `creature_template` set `minmana`='66063', `maxmana`='66500', `flags`='8', `armor`='3000', `resistance2`='20', `resistance1`='20', `resistance3`='20', `resistance4`='20', `resistance5`='20', `resistance6`='20', `spell1`='43153', `spell2`='43150', `spell3`='43217', `spell4`='42395', `ScriptName`='generic_creature' where `entry` in (23863);

update `creature_template` set `mindmg`=ROUND(mindmg*2), `maxdmg`=ROUND(maxdmg*3), `attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7) where entry in (23574,23577,24239,23578,23576,23863,23420,23419,23418,22949,22948,22950,22887,22917,22951,22947,22841,22898,22871,22952);
update `creature_template` set `mindmg`=ROUND(maxlevel*(rank+1)+(maxlevel+((rank+1)*1.29))*(rank+1)), `maxdmg`=ROUND(mindmg*1.29), `attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7) WHERE mindmg <  '121' AND rank in (0,4) AND minlevel > '59';
update `creature_template` set `mindmg`=ROUND(maxlevel*(rank+1)+(maxlevel+((rank+1)*1.29))*(rank+1)), `maxdmg`=ROUND(mindmg*1.29), `attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7) WHERE mindmg <  '365' AND rank in (1) AND minlevel > '59';




Update `creature_template` set `minhealth`='15000', `maxhealth`='15000', `mindmg`='1500', `maxdmg`='3000', attackpower='7875' where `entry` in (4262,5595,68,3084,3296,5624);
Update `creature_template` set `flags`='2', `mindmg`='1500', `maxdmg`='3000', attackpower='7875' where `entry`='4624';
Update `creature_template` set `flags`='2', `mindmg`='1500', `maxdmg`='3000', attackpower='7875' where `entry`='3502';
Update `creature_template` set `flags`='2', `mindmg`='1500', `maxdmg`='3000', attackpower='7875' where `entry`='9460';
update `creature` set `id`='8661' where `id` in (8671,15682,15679,8670,8721,8719,8723,15677,9856,9857,8722,15659,9858,8672,9859,15683,15681,8720,15686,15678,8674,15675,8673,8669,15684,8724,15676,16628,18761,16707,18348,17629,18349,16627,17627,16629,17628);


-- Zul'gurub FIX.
DELETE FROM creature WHERE id IN (14988, 15114);
UPDATE `creature` SET `id` = 14826 WHERE `creature`.`id` = 8324 and `creature`.`map` = 309;



update creature_template set flags=0 where `npcflag` > '0';
update creature_template set flags=0 where entry in (select entry from creature_loot_template) and flags not in (0,8,67108864,4096);