Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 08-11-2010, 12:00 PM
Tabasco's Avatar
Tabasco
Discordant
 
Join Date: Sep 2009
Posts: 269
Default

I'm not aware of a way to do that with the PEQ editor, you would need to run SQL queries.

The PEQ db has npc id's set up by zone, which makes this fairly simple.
Blackburrow's zone id is 17, so all npc's in blackburrow will have and id like 17xxx in the npc_types table. (This might not be perfectly true if you've done a lot of customization. It's wisely implemented, but not enforced.)

The sql for what you're wanting would then look like this:
UPDATE npc_types SET ATK = 1000, Accuracy = 1000 WHERE id LIKE '17%' AND LENGTH(id) = 5

The length component is important. Iceclad is 174, so npc's there should be 174xxx. The query for Iceclad becomes:
UPDATE npc_types SET ATK = 1000, Accuracy = 1000 WHERE id LIKE '174%' AND LENGTH(id) = 6

Before doing any update, it's a good idea to run a select with the same where clause to make sure you know what rows you're going to effect, and of course, back up your db, standard disclaimer, etc.

You could also write a script that assembles npc id's from spawn2 and spawngroup by zone. It would be much more reliable, but also much more involved.
Reply With Quote
 


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