-- Some triggers attacked players.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');-- Christmas Reveler were kick horde butts :Dupdate `creature_template` set `faction_a`='35', `faction_h`='35' where `entry`='15760';-- =======================SOME POWERUPS FOR BOSSES=====================================-- ====================================================================================-- High Warlord Naj'entusUpdate `creature_template` set `armor`='2000', `spell1`='39837', `spell2`='39835' where `entry` in (22887);-- Teron GorefiendUpdate `creature_template` set `armor`='2000', `spell1`='24239', `spell2`='40157', `spell3`='40314' where `entry` in (22871);-- Gurtogg BloodboilUpdate `creature_template` set `armor`='2000', `spell1`='40599', `spell2`='40595', `spell3`='42005' where `entry` in (22948);-- Mother ShahrazUpdate `creature_template` set `armor`='2000', `spell1`='40827', `spell2`='40860' where `entry` in (22947);-- Illidan StormrageUpdate `creature_template` set `armor`='2000', `spell1`='37462', `spell2`='36921', `spell3`='42395' where `entry` in (22917);-- Essence of DesireUpdate `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 SufferingUpdate `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 AngerUpdate `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 ShattererUpdate `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 BloodboilUpdate `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 ZerevorUpdate `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'entusUpdate `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 MalandeUpdate `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 ShahrazUpdate `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 AkamaUpdate `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);-- SupremusUpdate `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 GorefiendUpdate `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 DarkshadowUpdate `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'zonUpdate `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);-- NalorakkUpdate `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);-- HalazziUpdate `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'alaiUpdate `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 MalacrassUpdate `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'jinUpdate `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);-- ====================================================================================-- ====================================================================================-- Some dmg increase for some bosses.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);-- Some too low damage fixes.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';-- Made some guards stronger (to not let those players own them easily)Update `creature_template` set `minhealth`='15000', `maxhealth`='15000', `mindmg`='1500', `maxdmg`='3000', attackpower='7875' where `entry` in (4262,5595,68,3084,3296,5624);-- Made Contested guards to pwn criminals :DUpdate `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';-- Made all auctioneers same (Connected auctions)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. (from udb forum)DELETE FROM creature WHERE id IN (14988, 15114);UPDATE `creature` SET `id` = 14826 WHERE `creature`.`id` = 8324 and `creature`.`map` = 309;-- Fix all unattackable/unselectable creatures, to be attackable and selectable. (only those who should be attackable and selectable MAYBE)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);