Tool: Migrate NPC's (ID, Spawn, Loot, etc). from Lucin DB to Current EQ

zephyr325 · #1 08-21-2006, 01:32 AM

One of the things I did as a precursor to starting to rewrite this program was to review each of the tables that we would need to touch to come up with what the existing ranges are for all of the key fields (there are sometimes more than just the ID field) to find a "safe" range.

There are several cases of where the databases are the same up to a point, but then they diverge. In cases where there is any discrepancy, I'm taking the safe route to come up with a range of id's (for all the key fields) that new records could be imported with. This will be true if you're going cavedude -> PEQ or PEQ -> cavedude. It looks like there is going to be at least one case where we're going to have to alter the database structure (by expanding a field) as the existing ranges are already using all the available space.

Part of what I'll publish when I get the program running is that analysis. That way if I missed something, I'll have lots of folks helping me troubleshoot it. =)

zephyr325 · #2 08-30-2006, 10:30 AM

Tool is now written - we're beta testing it on Dark Tides right now. As long as things look good, I'll get the update out in the next couple of days.

It's gonna be a biggie. =)

Here's a precursor of what it does:

http://www.verycarr.com/apps/scripts...ldchanges.html

John Adams · #3 08-31-2006, 04:46 AM

That looks very well thought out. I can't wait to give it a whirl.

One thing, what does "add 500,000" mean on Items? Does that mean your IDs will start with 500,000 and go up from there? I ask because I ran into a problem when I tried to make a custom item with am id > 100,000, and believe I tracked it to this:

Items.h in EmuShareMem

Code:

#define MMF_EQMAX_ITEMS		100000
// MMF_MEMMAX_ITEMS: Maxium number of items to load into memory. Make sure this is bigger
//                   than the total number of items in the server's database!

Of course, I am unfamiliar with this code, so I could be wrong. Will this effect you?

zephyr325 · #4 09-04-2006, 05:30 AM

Yes, you're correct with what I'm adding to the item ID's. I haven't found a problem yet with range I'm using. Just to be sure, I've made a section that allows you to easily set what you want to increment each key field by.

I'm working on posting the code for the program now.