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

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

Thread Tools Display Modes
Prev Previous Post   Next Post Next
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

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 12:54 PM.


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 - 2020, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3