[ChaosSlayerZ]

you can modify hps like this:

update npc_types set hp=X where id>A and id<B;

X will be whatever formula you want use - like 1000*level
A and B are npc ids range that you want to modify

backup your DB before running any code