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.

Reply
 
Thread Tools Display Modes
  #1  
Old 08-10-2010, 02:27 PM
bowmaster
Discordant
 
Join Date: Jan 2007
Posts: 300
Default question about PeQ editor

Right , is ther a way i use tyhe peq editor and edit a whole zone?
like to increase the atk and acruaxy of all mobs to 1000 in 1 basic command , beacsue its tedious to go though each mob of a zone doing it 1 byt1 thanks
Reply With Quote
  #2  
Old 08-11-2010, 11:10 AM
bowmaster
Discordant
 
Join Date: Jan 2007
Posts: 300
Default

noone , knows a soloution?
Reply With Quote
  #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
  #4  
Old 08-11-2010, 05:28 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Quote:
Originally Posted by bowmaster View Post
Right , is ther a way i use tyhe peq editor and edit a whole zone?
like to increase the atk and acruaxy of all mobs to 1000 in 1 basic command , beacsue its tedious to go though each mob of a zone doing it 1 byt1 thanks
Not at the moment for most stats, but I do plan on adding this functionality. If you grab the newest SVN version, you will see this functionality has been started.
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 12:30 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3