New Tool: Migrate NPC's (spells/faction/loot/spawn/move/items) from PEQ <=> Cavedude

[zephyr325]

This post supersedes the one I posted here.

There are several enhancements to this program over the old one, but here's a full feature list. You can:

- Move NPC's from PEQ -> Cavedude, or Cavedude -> PEQ
- It will grab all pertinent info on the NPC, including spells, faction, spawn, loot tables, loot items and movement.
- You can move a single NPC, a list of NPC ID's, or a whole zone at a time.
- For a zone move, you can tell it to pull just the NPC's in the "From" database that the "To" database doesn't already have. You can also tell it to grab all of them.
- Output can be one file per NPC (i.e., 1001-Guard_Mezzt.sql) or one big file for all NPC's.
- If you tell it to, it will adjust the key fields for all the pertinent tables so the two databases will play nicely together. This should probably be used every time you run the program.
- I've done a lot of checking into what are safe values to increment key field ID's are (information is here). There is a section in the program where you can change these increments if you so desire.


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 both databases into mysql; this program will read from both of them. Make sure to keep them seperate (don't source them into the same database).


Installing it:
- Make sure you

[zephyr325]

(bumping this thread - the old post I had got on top of this when I edited it to point to this new post)

[Angelox]

The stuff I put out is probably only good if you have a new database, or are downloading my whole database.
If you already have a database you are working on and have added stuff, then there's always a chance things will get crossed and mess up your database.
If you want to add my stuff to your custom database - this tool is what you need; just download my database and merge what you want to yours. This is a great tool and long-waited for.
Thank you zephyr325 !!!

[zephyr325]

Actually, you can use it with other databases as well. The key is making sure that you're incrementing your key field ID's by an amount that isn't going to step on something you already have. Once you have those values, there is a section in this program that you can edit (its towards the top of the file, and labeled) that will allow you to put those amounts in, rather than the defaults I put in.

Check out the link above as well for my listing of what I did with each table; that will be a good starting point for folks to use.

The only one I've found so far that has a hard cap on it is npc_faction - make sure you don't increment your id to be more than 50000 or EQEmu won't start up. I've got a safety in the program that won't write that insert statement out if that value is too high.

[zephyr325]

Small updates:

- Changed the -e option to not check at all for duplicate records in the target database

- put double quotes around all field values to keep the insert statement from generating an error if a field value is null

[vales]

Wow, I don't know how I missed it. :p

Thanks for the program, zephyr325!

[rogabean]

I know this post is a bit old and I dislike bringing back an old thread, but does anyone have this tool still they could send me a link too as I'm not seeing it in the thread.

Thanks.

[cavedude]

If the purpose of this tool was to transfer data between my old db and PEQ's, then it is no longer needed. When I took over PEQ I slowly merged the two together and at this point the merger is pretty much done.

[John Adams]

This'll be a noob question (sorry, been out of it a while), but how does one get their hands on the latest-greatest PEQ.db? The link on ProjectEQ is the Luclin final release, and I think the /sql is just the schema... Is there a CVS or other downloadable source just for the current PEQ DB work?

[rogabean]

I understand that cavedude.. but I was wondering if it would be useful for importing some info from ax's database and the peq database into a new database.. I've been moving a few things by hand, but was hoping this old tool might still be around just to see if it would be of help.

and to answer John.. yes there is a CVS setup that if you check the latest server setup howto on the wiki will give you all the info on downloading it from cvs.

cheers!

[GeorgeS]

Perhaps this is the file you need

http://66.159.225.58/eqemu/grabnpc.zip

If not I have about everyfile emu related from 2002

GeorgeS

[joligario]

Doubtful. However, the PEQ editor has an export option for NPCs. I haven't looked at it in a while, so I'm not sure if any of the fields need updating.