The npc_types table released with 3.2 works if it is empty, but causes an error in zone if there is data. If the table from the 3.1 release is used it works fine, NO errors that I can find.

I understand this, but the code and the released DB don't appear to matchup. Besides, from what code I have read through I don't think extra fields in a table will disrupt anything. Perhaps it is a bug in the code, and the DB released is how it was meant to be.

Regardless, using the 3.1 npc_types table eliminates the errors.

Nice work
 

Seems to work well.....

Keep us(normal players) updated on any new DBs/DB info you gather.

Thanks!

Shawn do the new databases released with the new version of EQEmu come with npcs or are they always clean DBs?

Always clean

When will MSH-DB v0.2 come out? ;o)

probably not.. merkur left :( along with the spawn collector.

He left??

Does anyone have an old copy of the spawn collector? maybe it can be updated to current DB format and maintained by someone else.

It may be possible to alter the PacketCollector to harvest alot more information. Is it possible to get the source to add collection of addition information.

Left?
 

What u mean Left? He only one with source code?

I would guess since he took it with him, that means he didnt put the source into the public domain. Not sure how he handled the encryption routines, but thats probably why he didnt release the source... Spawns are encrpyted packets, im guessing items aren't. (why we have an itemcollector now but not a spawncollector). The emu project is not out here to flaunt decryption routines to verants protection policies.. Of course, i might be off my rocker here...

that sound about right to anyone that actually knows?

Trumpcard, that sounds right to me at least. One way to recreate the spawncollector would be to heavily modify showEQ It does have spawn decription. Perhaps someone could modify the spawnlog section of code to collect more info in the proper format for importing into the emu's mysql db Removing players pets and duplicate spawns would be a real plus too.

An idea
 

I know this was weeks ago but anyways...

ShowEQ and SINS both use a pre-compiled lib to decrypt the packets (libEQ.a), why not use these routines and fashion another collector using this lib?

Merkur was the one that made the "SpawnCollector" that collected the MSH DB (short for Merkur Spud Hogie, which were the ones that used the collector to gather the data).

He never gave us the source code and Spud/hogie were the only ones ot get the exe's.

After he left, he left without giving us the source code so we cannot continue that project unless we a) start over, or b) hope merkur comes back :)

Is there any chance of him giving out the source-code?

It is SO much better than #spawning npcs..

There is no way to find him. he is gone, we cant get in touch with him.