All pastes #709177 Raw Edit

Someone

public text v1 · immutable
#709177 ·published 2007-09-24 13:20 UTC
rendered paste body
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);