Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2020, 12:14 PM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 188
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
  #2  
Old 01-15-2020, 01:03 PM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 188
Default

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
Reply With Quote
  #3  
Old 01-15-2020, 03:19 PM
Sturm
Hill Giant
 
Join Date: Dec 2015
Posts: 116
Default

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!
__________________
Developer of the Imperium Server.
https://imperium-eq.com/
Reply With Quote
  #4  
Old 01-15-2020, 03:21 PM
nilbog
Hill Giant
 
Join Date: Nov 2007
Posts: 197
Default

Quote:
Originally Posted by Fridgecritter View Post
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!
__________________
https://www.project1999.com
Reply With Quote
  #5  
Old 01-17-2020, 09:57 AM
Fridgecritter
Hill Giant
 
Join Date: Feb 2008
Posts: 188
Default

Thanks a ton! I wasn't sure about the numbers of ALL the pets being under 1001.
Reply With Quote
  #6  
Old 03-23-2020, 12:09 AM
raulcox
Fire Beetle
 
Join Date: Mar 2020
Posts: 1
Default

Thank you, great help.
__________________
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:29 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3