database relationship for spawns
 

The Apology: Excuse me if this has been answered somewhere else, i did multiple searches and couldn't find what I was looking for.

The Question: Is there a discussion somewhere on how the 5 table for NPC's relate to each other? Why 5 and not 2? How do Spawn2, npc_types, spawnentry, and spawngroup relate?

several more searches and I found what I was looking for.

Since you found it, would you mind posting the link to that article(s) which explain it? I'll bet more people would like to benefit from your digging.

npc_types: The actual entry of the NPC. This is where the data for the npc is stored like hitpoints, level, race, and many, many other things.

spawngroup: This is the "spawn group" for a set of NPCs, spawnentry and spawn2 both use this.

spawnentry: This is where an NPC is entered into a specific spawn group, you can put multiple NPCs in the same spawn group and give them "chances" to spawn.

spawn2: This is the entry that will tell the server where to place an NPC in the world. It contains things like the NPCs location, respawn time, the zone it spawns in, and a few other things.

what he said.