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.