View Single Post
  #3  
Old 03-22-2006, 12:39 AM
sesmar
I built it I will Support it!
 
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default

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.
__________________
Reply With Quote