View Single Post
  #1  
Old 10-27-2007, 11:03 PM
Secrets's Avatar
Secrets
Demi-God
 
Join Date: May 2007
Location: b
Posts: 1,449
Default Possibility of getting the old indexing formula back in databases?

I dunno about you guys, but if you look at ProjectEQ, you'll see a bit of ordered numbers for npc_types, spawngroup, spawnentry, and spawn2.

What I mean by this is: You'll have 1000 NPCs per zone, which is determined by the zone ID. Say the zone ID is 1, you'll use npc_types IDs 1000-1999, spawngroups 1000-1999, spawnentry 1000-1999, and spawn2 10000-19999.

For zone 2, replace the 1s with a 2.

For zone 20, replace the 1s with a 2 and add a zero.

Is it too late to hope restructuring the 200+ zones, or am I going to have a nightmare trying to see which NPCs are in zones with a large query?

Just a thought, is all, it just is one of those things that 'looks better', but is not nessessary.
Reply With Quote