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 05-18-2015, 07:29 PM
Aquaojo
Sarnak
 
Join Date: Feb 2012
Location: GA
Posts: 34
Default Changing NPC Stats In One Zone

First off...Thanks to everyone in this community for the immense freaking wealth of knowledge in these boards!! I'm new to all this, but y'all have made it pretty simple!!

I've searched for this, but couldn't find anything...I'm looking to make some changes to the mobs in one particular zone. For instance: Lowering the HP of all NPC's in Crushbone.

I know how to do it for NPC's across the board, but can't seem to figure out how to identify the mobs by the zone they are in. So far I have done this by using the faction row in the NPC_TYPES table, but I'm sure there is a more thorough way...Just missing it I guess.

Any help greatly appreciated!!
Reply With Quote
  #2  
Old 05-18-2015, 07:34 PM
epilz
Hill Giant
 
Join Date: Sep 2013
Posts: 247
Default

SELECT * FROM `spawn2` WHERE `zone` LIKE '%crushbone%' LIMIT 0, 1000
__________________
The neighborhood asshole......New Server.....Maybe.....
Reply With Quote
  #3  
Old 05-18-2015, 07:43 PM
epilz
Hill Giant
 
Join Date: Sep 2013
Posts: 247
Default

lots of way to change shit, what exactly do you want to change?
__________________
The neighborhood asshole......New Server.....Maybe.....
Reply With Quote
  #4  
Old 05-18-2015, 08:14 PM
Aquaojo
Sarnak
 
Join Date: Feb 2012
Location: GA
Posts: 34
Default

Thanks Epilz - I'm just looking to make some changes to mobs in Kael...Taking the HP down by 25%, AC by 25%, Min/Max Dmg by 25% for starters.

I know I can do it in EoC using the mass field editor, but that sets everything to the same value. I figure I can use SQL and do it all by percentages.
Reply With Quote
  #5  
Old 05-18-2015, 08:29 PM
epilz
Hill Giant
 
Join Date: Sep 2013
Posts: 247
Default

its much easier to use SQL to do it, give a few, I will build you a query for it
__________________
The neighborhood asshole......New Server.....Maybe.....
Reply With Quote
  #6  
Old 05-19-2015, 10:30 AM
Aquaojo
Sarnak
 
Join Date: Feb 2012
Location: GA
Posts: 34
Default

So far I have figured out how to pull the mobs from Kael using this query:

SELECT * FROM spawn2 JOIN spawngroup ON spawngroup.id = spawn2.spawngroupID
JOIN spawnentry ON spawngroup.id = spawnentry.spawngroupID
JOIN npc_types ON spawnentry.npcID = npc_types.id
WHERE spawn2.zone LIKE 'kael'

Admittedly I am just learning about JOIN and figuring out how all this works...So anyone able to tell me how I would now add in:

UPDATE npc_types SET HP = HP * 0.75

in order to decrease all NPC HP in Kael by 25%??

I know it has to be right in front of my face, but I am missing it for some reason...

Thanks everyone!!
Reply With Quote
  #7  
Old 05-19-2015, 11:12 AM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

lower HP and AC by 25% in crushbone version 0


Code:
UPDATE npc_types n
INNER JOIN spawnentry se ON n.id = se.npcID 
INNER JOIN spawngroup sg ON sg.id = se.spawngroupID
INNER JOIN spawn2 s ON se.spawngroupID = s.spawngroupID 
SET 
n.`hp` = `hp` * 0.75,
n.`ac` = `ac` * 0.75
WHERE s.zone = 'crushbone'
and s.version = 0;
Reply With Quote
  #8  
Old 05-19-2015, 11:15 AM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

I am sure there is an easier way but I simply use the ID number range for the zone... kael's mobs are 113000..113552

so..

Update npc_types Set hp=hp*.75 where id between 113000 and 113552;

etc...
Reply With Quote
  #9  
Old 05-19-2015, 11:16 AM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

well, natedog posted at the same time as me and he knows a lot more than me so...go with him :P
Reply With Quote
  #10  
Old 05-19-2015, 11:29 AM
Aquaojo
Sarnak
 
Join Date: Feb 2012
Location: GA
Posts: 34
Default

Awesome!! Thanks to all of you guys!! I'm amazed at the wealth of knowledge everyone here has.
Reply With Quote
  #11  
Old 05-19-2015, 12:06 PM
NatedogEZ's Avatar
NatedogEZ
Developer
 
Join Date: Dec 2012
Posts: 515
Default

The way Kimura said is 100% better BUT.. only works if you create NPCs in the correct zoneID range..

Exmaple.. zoneID 3 (QRG) or surefall glades... has NPCs from id 3000 - 3999

And the way I posted will miss mobs that are quest spawned.. ect since they are not part of a spawngroup.
Reply With Quote
Reply


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