p4lm0r3,
You can have my source code if you want it. I wrote an app to do exactly what you are asking. It is in VC++/MFC and uses MyODBC to talk to mysql. Another feature of the app is to pack the NPC_TYPES after dups are removed. It works well but, because of the way the DB was originally setup- It removes a bit too much. You still need to handcraft some zones... Even after deleting by distance (spawn2) or dupe NPCType.
I tried emailing several people here supposedly doing EQEMu DB work offering my help. My Offer to help was turned down in all cases. Since I don't have much free time anyway, I just gave up on doing any more EqEmu database work. <shrug>
There has been alot of great work done on various EMU databases. Still, I look forward to the day when one is released that more resembles EqLive.
PM me your email address and I will send ya a copy of the source.
BoB
|