[Arcalyn]

How will you write a script to elliminate the duplicates?

spawnentry & spawn2 contain the duplicates but I can't see any field which could be an identifier.

spawnentry the second number(which has the duplicates) could be used but what would your variable be? Can't just delete them all, and everything else within spawnentry doesn't have a duplicate.

spawn2 the only thing I've found which shows that they are duplicates is if there is only a SMALL varience in the X,Y fields with Z staying constant BUT....

EXAMPLE from actually DB:
-<npc_types>-
(7045,'Guntrik',61,10,17,37529,0,3,0,-1,0,0,7,0,0,0,'','',0,0,0,1,1,1,1,1,0,0,0,0.67,1.2 5),

-<spawngroup>-
(7045,'oggok7045'),

Everything makes sense so far.......BUT......

-<spawnentry>-
if ya look for 7045 in the first field only one entry BUT
(7045,7078,15), ------> is >NOT< Guntrik its Uoola
so search through second field
(7050,7045,12), ------> Guntrik in emulator
(7076,7045,1), --------> Guntrik in emulator
(7086,7045,4), --------> Guntrik in emulator

-<spawn2>-
(7045,7045,'oggok',684,659,5.6,50,180,0), -----> Unfound
(7076,7076,'oggok',64,26,-24.8,173,180,0), --> Front Guntrik
(7087,7087,'oggok',69,26,-24.8,173,180,0), --> Middle Guntrik
(7050,7050,'oggok',74,26,-24.8,173,180,0), --> By-wall Guntrik

(7078,7078,'oggok',-44,356,17.3,74,180,0), --> Uoola

Since no one will answer my original post up top, I'd have to officially say the DB is wacked. *chuckles*

So if a DEV or Lurker_005 if you can answer my first post up top it'd help a whole bunch!