EQEmulator Forums - Log what zone NPCs are in?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Log what zone NPCs are in? (https://www.eqemulator.org/forums/showthread.php?t=35620)

Maze_EQ

08-07-2012 02:46 PM

Log what zone NPCs are in?

Is there any way to tell which zone an npc in NPC_Types belongs to?

AS in, If I wanted to run a query on soldungb mobs, it would affect each mob in that zone, but nothing else? I'm thinking this would require an identifier in the npc_types field to tell which zone the monster belonged to.it'd just be a hassle to do that all by hand.

sorvani

08-07-2012 02:58 PM

XXX000 through XXX999 are the NPCID's for every NPC in zone XXX

cavedude

08-07-2012 05:54 PM

Quote:

Originally Posted by sorvani (Post 211517)

XXX000 through XXX999 are the NPCID's for every NPC in zone XXX

Yep, in PEQ NPCID is derived by zoneidnumber*1000. However, other databases may not follow this numbering system.

wolfwalkereci

08-07-2012 06:06 PM

Quote:

UPDATE npc_types SET luclin_haircolor = FLOOR(1 + (RAND() * 20)) WHERE race = 2 AND (id>=8000 AND id<=8999);

Here is an example.

Caryatis

08-07-2012 07:32 PM

Keep in mind that unless you are careful when adding custom NPCs they may not follow that numbering scheme. If you have loads of custom NPCs, then you will need to cross reference the spawn tables as well.

Maze_EQ

08-08-2012 09:04 AM

Thank you guys so much, makes it 1000% easier to edit specific zones.

All times are GMT -4. The time now is 01:26 PM.