EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   question about PeQ editor (https://www.eqemulator.org/forums/showthread.php?t=31827)

bowmaster 08-10-2010 02:27 PM

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

bowmaster 08-11-2010 11:10 AM

noone , knows a soloution?

Tabasco 08-11-2010 12:00 PM

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.

cavedude 08-11-2010 05:28 PM

Quote:

Originally Posted by bowmaster (Post 190598)
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.


All times are GMT -4. The time now is 10:18 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.