update creature_template set mindmg=minlevel*1.5 where minlevel>60 and rank in (0,4) and entry in (select id from creature where map=530); update creature_template set maxdmg=maxlevel*3 where minlevel>60 and rank in (0,4) and entry in (select id from creature where map=530); update creature_template set attackpower = round((maxdmg + mindmg) / 4 * 7) where minlevel>60 and rank in (0,4) and entry in (select id from creature where map=530); update creature_template set mindmg = round(mindmg - attackpower / 7) where minlevel>60 and rank in (0,4) and entry in (select id from creature where map=530); update creature_template set maxdmg = round(maxdmg - attackpower / 7) where minlevel>60 and rank in (0,4) and entry in (select id from creature where map=530);