Duplicate Spawn Entries

[Glasswalker]

Hello, I am currently working on using access in conjunction with MySQL to try and find a way to filter out the duplicate spawns...

I am curious though... from my initial queries I did not find that many duplicate entries in the DB. So is the duplicate spawn problem a code problem with the emu? or is it actually multiple entries in the database...

In which case what should I be using for my criteria?

I tried filtering out only unique records in a query of the spawn id, x, y, z, and heading... but only filtered out like 20 spawns...

So then I looked at the actual NPCID that is tied to each spawn, and noticed it repeats a bit more there, but my understanding of that table (spawnentry) is that it chooses ONE of the possible npcs and spawns it based on the probability...

Anyway I am willing to do the database work to weed out the doubles... and maybe tweak up the db some more, but I will need some assistance getting started...