reduce stats on npcs without effecting pets

[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?

[Fridgecritter]

I searched the forums looking for posts from folks who have queries for balancing for solo play, but all of them are old and there are new or changed fields in the DB. I've been using Akka's EOC online editor, and it's awesome, but jeez I can't fathom how long it would take if I have to edit each pet lol

[Sturm]

UPDATE npc_types SET hp = hp * 0.3 WHERE id >= '1001';

All the pets should be in the lower than 1000 range. At least they are in my database.

Remember to back up your npc_types table before running queries that effect such a large amount of data so you can easily revert should something go horribly wrong!

You can always further define the query if needed aswell. Hope this helps!

[nilbog]

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!

[Fridgecritter]

Thanks a ton! I wasn't sure about the numbers of ALL the pets being under 1001.

[raulcox]

Thank you, great help.