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

[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