Duplicate Spawn Entries

Glasswalker · #1 10-28-2002, 04:17 AM

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...

Norvak · #2 10-29-2002, 12:54 AM

The problem isn't usually in the NPC_Types table.

The problem with milti-mobs is in the Spawngroup, Spawnentry, etc tables. Search there and I bet you'd find a lot of duplicates. I linked my tables with MS Access to filter the dupes and managed to get a few done.

REMEMBER THOUGH!!!

If you delete a spawn from the spawngroup table, you need to delete it from the other "spawn_*" tables too. Otherwise you'll be creating a headache for the zone server.