EQEmulator Forums - Major NPC locations

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)

- - Major NPC locations (https://www.eqemulator.org/forums/showthread.php?t=20172)

Major NPC locations

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.

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

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

Using this query

Code:

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:

Code:

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.