Major NPC locations

[DazL1974]

Sorry if someone started a thread like this already. I wanted to make a list of nice spawns to visit with #goto, with their exact locs.

Will add more the next weeks, but I visited these four tonight,

Nagafen -1296, -824, 91 in Soldungb
Vox 840, -65, 6 in Permafrost
King Tormax -1492, 1711, -194 in Kael
Wuoshi -2800, -3000, 40 in Wakenings

Anyone been able to locate Innoruuk? I spend some time looking for him, and he is in the database, but couldnt find him.

[MysticDeath]

Spore King! - #zone Sebilis 110 -920 -165
Kerafyrm! (AKA: The Sleeper) - #zone Sleeper -1560 -2400 -1050

[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.