All pastes #901074 Raw Edit

Stuff

public text v1 · immutable
·published 2008-02-12 11:34 UTC
rendered paste body
update creature_template set mindmg=minlevel*1.5*maxlevel/60*maxlevel/60 where minlevel>55 and rank in (0,4) and entry in (select id from creature where map=530);
update creature_template set maxdmg=maxlevel*3*maxlevel/60*maxlevel/60 where minlevel>55 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>55 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>55 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>55 and rank in (0,4) and entry in (select id from creature where map=530);