Tuning pets

[woton]

On a server with npcs having been reduced in power but pets are still too tough. Is there a way to target tune pets all at once?

[Mistmaker]

I used this code awhile back to buff pets so change it around to reduce them.

update npc_types set hp = hp * 2 where id > 499 and id < 529;
update npc_types set mana = mana * 2 where id > 499 and id < 529;
update npc_types set mindmg = mindmg + 5 where id > 499 and id < 529;
update npc_types set maxdmg = maxdmg + 10 where id > 499 and id < 529;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id > 499 and id < 529;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id > 499 and id < 529;
 
update npc_types set hp = hp * 2 where id  > 540 and id < 641;
update npc_types set mana = mana * 2 where id  > 540 and id < 641;
update npc_types set mindmg = mindmg + 5 where id  > 540 and id < 641;
update npc_types set maxdmg = maxdmg + 10 where id > 540 and id < 641;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id  > 540 and id < 641;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id  > 540 and id < 641;
 
update npc_types set hp = hp * 2 where id  > 745 and id < 771;
update npc_types set mana = mana * 2 where id  > 745 and id < 771;
update npc_types set mindmg = mindmg + 5 where id  > 745 and id < 771;
update npc_types set maxdmg = maxdmg + 10 where id  > 745 and id < 771;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id  > 745 and id < 771;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id  > 745 and id < 771;
 
update npc_types set hp = hp * 2 where id  > 783 and id < 824;
update npc_types set mana = mana * 2 where id  > 783 and id < 824;
update npc_types set mindmg = mindmg + 5 where id  > 783 and id < 824;
update npc_types set maxdmg = maxdmg + 10 where id  > 783 and id < 824;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id  > 783 and id < 824;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id  > 783 and id < 824;
 
update npc_types set hp = hp * 2 where id  > 836 and id < 854;
update npc_types set mana = mana * 2 where id  > 836 and id < 854;
update npc_types set mindmg = mindmg + 5 where id  > 836 and id < 854;
update npc_types set maxdmg = maxdmg + 10 where id  > 836 and id < 854;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id  > 836 and id < 854;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id  > 836 and id < 854;
 
update npc_types set hp = hp * 2 where id  > 893 and id < 923;
update npc_types set mana = mana * 2 where id  > 893 and id < 923;
update npc_types set mindmg = mindmg + 5 where id  > 893 and id < 923;
update npc_types set maxdmg = maxdmg + 10 where id  > 893 and id < 923;
update npc_types set mana_regen_rate = mana_regen_rate * 2 where id  > 893 and id < 923;
update npc_types set hp_regen_rate = hp_regen_rate * 2 where id  > 893 and id < 923;

[woton]

thx for the post, weve added your script and it seems to be working well.