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