Log what zone NPCs are in?

[Maze_EQ]

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]

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

[cavedude]

Originally Posted by sorvani

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]

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

Here is an example.

[Caryatis]

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]

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