//所有BOSS修攺攻击降低5倍
UPDATE creature_template SET mindmg = mindmg/5 where rank=3;
UPDATE creature_template SET maxdmg = maxdmg/5 where rank=3;
//所有BOSS修攺攻击增加5倍
UPDATE creature_template SET mindmg = mindmg*5 where rank=3;
UPDATE creature_template SET maxdmg = maxdmg*5 where rank=3;
mindmg 表示最小攻击值 maxdmg 表示最大攻击值 rank表示怪物的类型 分为0.1.2.3.4 类型如下
0 Normal 普通
1 Elite 精英
2 Rare Elite 稀有精英
3 World Boss 世界BOSS
4 Rare 稀有.
//所有BOSS修攺血量降低5倍
UPDATE creature_template SET minhealth = minhealth/5 where rank=3;
UPDATE creature_template SET maxhealth = maxhealth/5 where rank=3;
//所有BOSS修攺血量增加5倍
UPDATE creature_template SET minhealth = minhealth*5 where rank=3;
UPDATE creature_template SET maxhealth = maxhealth*5 where rank=3;
多重条件：
//所有BOSS修攺血量降低5倍
UPDATE creature_template SET minhealth = minhealth/5 where rank=3 and minlevel > 60;
UPDATE creature_template SET maxhealth = maxhealth/5 where rank=3 and minlevel > 60;
//所有BOSS修攺血量增加5倍
UPDATE creature_template SET minhealth = minhealth*5 where rank=3 and minlevel > 60;
UPDATE creature_template SET maxhealth = maxhealth*5 where rank=3 and minlevel > 60;
增加一个条件判断 and minlevel > 60 。。就是批量修改怪物最小等级必须大于60级的怪物，！