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

[zephyr325]

This is a tool I wrote that will allow you take just about everything about an NPC from the current PEQ (Lucin RC1) database and move it into the current EQ database. Basically, you give it an NPC number and it parse through the Lucin DB to get that NPC's:

- Core character information;
- Spells
- Spawning
- Loot
- Movement

The program will then create a file of insert statements that you can source into your existing eq database.

Prerequisites:
- FIRST: THIS IS TEST CODE. BACKUP YOUR EXISTING EQ DATABASE.
- This is a perl program; you need perl installed.
- You will need to source the current PEQ Lucin RC1 database into a separate database on your server; that is what this program will read.

Installing it:
- Make sure you

[zephyr325]

Hold off on this - I've had a couple of people point some things out; I'll patch and re-release.

[Zengez]

possibly a silly question but... does it work in reverse? (i.e. take mob info from eq DB and insert it into PEQ db?)

[Angelox]

Originally Posted by Zengez

possibly a silly question but... does it work in reverse? (i.e. take mob info from eq DB and insert it into PEQ db?)

I don't see why not , just so long as the Databases you use , have all the updates to what ever version EQEMU he's using.

[zephyr325]

Found out my key problem is that the records you pull from the PEQ Lucin database sometimes steps on key fields in the exising Cavedude's database, so you can't just take one and move it over. I'm trying to work through how to do that key field adjustment in a systematic fashion.

moved to correct forum

[sdabbs65]

If it was possable to add a wildcard feature such as npc's 1 thu 10000 it would make it a lot easier,theres about 3k in npc's in my old database.

[zephyr325]

I'm working on that...

But in the interim, I wrote another script that will compare the differences between two databases (it looks at one field in one table in both of them) and prints out the differences. Pipe that to a file, then run a shell/batch script that will call this script for each of those numbers.

That comparison script is posted here:

http://www.eqemulator.net/forums/showthread.php?t=21258

[GeorgeS]

Thanks for writing this, as it's a tool we've been wanting!

GeorgeS

[zephyr325]

No probs - I'm a few days away from releasing the next version of this. I've done a pretty detailed review of the Cavedude/PEQ databases to figure out in all the fields where I can safely renumber key fields. The next version or two is going to include:

- Automatic key re-numbering
- The ability to do batches of people at a time (maybe something like zones, maybe everyone)
- Generating the scripts that will reverse the adds. For example, if something doesn't work, remove what you just added in.

[John Adams]

Most excellent work, Zephyr. I think the renumbering project was going to be enormous, and I know how to do it, just not sure what the accepted standard really is (besides simply zoneid * 1000 heh). Since loots and merchant sets could belong to NPCs in multiple zones, it mades my brains ache.

I can't wait to try this out.

[zephyr325]

This thread is now superseded by the one here