View Single Post
  #3  
Old 05-23-2002, 01:20 AM
strychn
Hill Giant
 
Join Date: Feb 2002
Posts: 129
Default

do you mean something like....

select npc_types.name, npc_types.level, spawn2.spawngroupid, spawn2.zone, spawn2.x, spawn2.y, spawn2.z
from npc_types, spawn2, spawnentry where spawn2.spawngroupid=spawnentry.spawngroupid and npc_types.id=spawngroup.npcid and spawn2.zone='qeynos'

that would return all the spawn entries for all the spawns in qeynos. you can add/remove what fields from npc_types to display.
??
Reply With Quote