[nilbog]

Originally Posted by Fridgecritter

I see there's a pet table in the DB, but the pets also seem to be in the npc_types table.

Is there a way to isolate the pets and only reduce the stats on NPCs?

I want to run a query like this:

update npc_types set hp = hp*.3

But I know it will effect pets as well. Is the easiest way to just run the query and then go back in and run separate queries for the id numbers for the pets?

Or should I just run the query and then make a pet focus item on a newbie vendor that brings pet stats back up?

You could just exclude the pets in the update query. If you know all the ids, or they are in a certain id range, I will provide a couple of examples:

if for example all pets were less than id 1000, and all normal npcs were higher:

update npc_types set hp = hp*.3 where id > 1000;

or you could list them..

if for example your pets were ids 888,777,666,5555,444:

update npc_types set hp = hp*.3 where id not in (888,777,666,5555,444);

make a backup, experiment at will, good luck!