Possibility of getting the old indexing formula back in databases?

[Secrets]

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.

[John Adams]

There are many posts here about the "old PEQ standard" for zones and their contents. And just as many attempts to get things back under control, since so many databases have been created, merged, dissected, and stapled back together.

zoneid * 1000 has always been the rule. The only place I do not think that rule applies is in the spawnGroupID itself - cuz it's not really that important.

I'm surprised you missed the previous discussions about this. Angelox just recently mentioned it again as well in his effort to de-mystify the IDs.