EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   reduce stats on npcs without effecting pets (https://www.eqemulator.org/forums/showthread.php?t=42776)

Fridgecritter 01-15-2020 12:14 PM

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?

Fridgecritter 01-15-2020 01:03 PM

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 01-15-2020 03:19 PM

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 01-15-2020 03:21 PM

Quote:

Originally Posted by Fridgecritter (Post 264323)
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:
Code:

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:
Code:

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 01-17-2020 09:57 AM

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

raulcox 03-23-2020 12:09 AM

Thank you, great help.


All times are GMT -4. The time now is 10:07 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.