Perl Script to Compare Two Database Tables - What's Different?

[Angelox]

You're better off starting with the PEQ database and pulling data off the EQ database ( a lot of us are doing this). This way, you will have most of your work done, up to Kunark expansion.
EQ database is great for pulling out some basic spawns and transfering them to PEQ.
At first, I did what you are doing , and found myself doing all my work in pre-Kunark expansions.
Example:
PEQ - pre-Kunark, has most named mobs (not all) and drops EQ Pre-Kunark has very few named (boss) mobs.
After Kunark , PEQ has nothing - but EQ has many "populated" zones. EQ's "after Kunark" zones have little if any named (boss) mobs and partial drops.
In reality, they both lack a lot , but the PEQ database is a much better start with the EQ database for a reference.
What a few of us are working at, is getting work done in the PEQ database in such a way that it can be posted in these forums, so we all can benefit.
Your help is not only welcomed, but needed.

[zephyr325]

Understood - thanks - I'm actually working with Soulshot on the Darktides DB. He started from the Cavedude database and has done a lot of customizing it, and is already up and running, so we don't want to do a wholesale replacement. This is just a way to do some comparisons between the two.

My next project is actually to write something that will, based on an npc id, grab the data from the Lucin db (npc_type, spawn stuff, loot stuff, spell stuff, etc) and create insert statements in a nice, easy-to-source file. Presto, chango - you've now got a new, fully functional npc in your server.

Unless someone has already written something like this?

[Angelox]

Originally Posted by zephyr325

My next project is actually to write something that will, based on an npc id, grab the data from the Lucin db (npc_type, spawn stuff, loot stuff, spell stuff, etc) and create insert statements in a nice, easy-to-source file. Presto, chango - you've now got a new, fully functional npc in your server.

Unless someone has already written something like this?

No body is on that type of a grove here - it would be real nice to have a tool like that.

[soulshot]

Kind of meshing the peq's mobs, quests, and spawn tables with cavedudes extra zones and mobs. Plus our custom items, zonelines, portals. npcs, bazaar vendors etc.

[Zengez]

Got it to work great, but is there anyway to have this exported to a file? only shows the last couple dozen rows of a 2,500+ querry which doesn't really help me much

[zephyr325]

Pipe it to a file... use " > filename.txt" on the end.

[Zengez]

ah, well thanks for the instantaneous reply, and i'm a newb thanks again for the great tool