Major NPC locations

[sesmar]

You can pull this information out of the Database fairly easily with the right query.

Using this query

SELECT
  npc_types.id AS ID,
  npc_types.name AS NAME,
  spawnentry.chance AS SpawnChance,
  spawn2.zone AS Zone,
  spawn2.x AS X,
  spawn2.y AS Y,
  spawn2.z AS Z
FROM
  npc_types
  INNER JOIN spawnentry
    ON spawnentry.npcID = npc_types.id
  INNER JOIN  spawn2
    ON spawn2.spawngroupID = spawnentry.spawngroupID
WHERE
  npc_types.name LIKE '%Innoruuk%'

All you have to do is change the Npc Name you are searching for in the where clause and you can search for any NPC you want to by name.

Or you can just slightly modify the query to this:

SELECT
  npc_types.id AS ID,
  npc_types.name AS NAME,
  spawnentry.chance AS SpawnChance,
  spawn2.zone AS Zone,
  spawn2.x AS X,
  spawn2.y AS Y,
  spawn2.z AS Z
FROM
  npc_types
  INNER JOIN spawnentry
    ON spawnentry.npcID = npc_types.id
  INNER JOIN  spawn2
    ON spawn2.spawngroupID = spawnentry.spawngroupID
WHERE
  npc_types.id = 76007

And you can search by NPC ID just by changing the ID in the where clause.