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级的怪物,!