View Single Post
Old 01-15-2020, 12:14 PM
Hill Giant
Join Date: Feb 2008
Posts: 182
Default reduce stats on npcs without effecting pets

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?
Reply With Quote