I organize my database in a per zone structure, but not with such ids. I create a "null" NPC with the name IE: ---- West Freeport NPC Data ----". Just a personal touch that helps me better organize my npc_types and spawns. I also organize spawn tables by name, rather than spawnxxxx format. Just personal preferrences.
I do agree that we database builders need to get togther and collaberate our work. Personally I've been using Trumpcards spawnlogs and when I need to I jump onto live for merchant data and the weapon textures for NPCs. I also use the information from
www.eqcaster.com for the zone quest data. I think everyone who is working on a database needs to set up a changelog file and undertake tasks to fill the zones properly. But on the opposite note most of us design and organize our databases differently, as per my pervious statement, and it would be difficult to create a general guide we would be comfortable in sticking to.
All in all, if either Drawde, Ariak, or Lurker what me to work on a zone for them I'd be more than happy to convert my orgainzation system over, since I have been working from an originally blank database. I've been trying to make my database as close to live as one currently can with the tools available, but with some slight modifications and Lord of the Rings easter eggs scattered about Norrath.
Just let me know what you need and if I am capable of doing it I shall gladly offer my assistance. And a special thanks to Trumpcard for being kind enough to gather SEQ logs for we builders.
