Not sure how you are doing it, I normally use 2 different ways to get the spawn info. I'll use Naggy as a reference.
1. Start with a name of the npc find/filter/query of the npc_types database by using Navicat/MS Access or whatever you are using.
Lord_Nagafen gives us an npctypeid of 32040
Now go into the spawnentry database and find/filter/query 32040 for the npcID column. Some mobs/npcs will have multiple entries.
32040 gives us a spawngroupID of 6712
Now go into the spawn2 database and search on 6712 in the spawngroupID column. There should only be entry per spawngroupID number. This will give his spawn loc as well as respawn time and other things.
2. Go target Lord Nagafen in SolB and use #npcstats. This will give you a spawngroupID that you can look up in the spawn2 database. Using #dbspawn will result in a 0 spawngroupID.
|