zone npcids

[tricyclethief2]

Is there any program or anyway to dump the npcids of all mobs in 1 specific zone? Im working on a task that requires killing 150 creatures and theres about 300ish total in zone. trying to find a fast way to add every npcid into the task goals list. Thanks

[Secrets]

Originally Posted by tricyclethief2

Is there any program or anyway to dump the npcids of all mobs in 1 specific zone? Im working on a task that requires killing 150 creatures and theres about 300ish total in zone. trying to find a fast way to add every npcid into the task goals list. Thanks

SELECT DISTINCT `npc_types`.`id` FROM `npc_types` INNER JOIN `spawnentry` ON `npc_types`.`id` = `spawnentry`.`npcID` INNER JOIN `spawn2` ON `spawnentry`.`spawngroupID` = `spawn2`.`spawngroupID` INNER JOIN `zone` ON `spawn2`.`zone` = `zone`.`short_name` WHERE `zone`.`zoneidnumber` = 1;

This will dump all NPCs for South Qeynos.

You could also do it with short_name instead of ID, but be careful when you do to not use like, use equals. (In the case of qeynos, there is qeynos and qeynos2, just using like 'qeynos' will result in both zones.)

[tricyclethief2]

Thanks secrets thats awesome