Duplicates/Overlaps in the Game Code Database

[safaribans]

I've been looking for missing games or codes (PAR) that are already made (so I can create different ones and not submit codes that have already been made...)

Here are a few overlaps I've stumbled upon:

Astyanax
Not a great set of codes, values in decimal
http://www.thegshi.org/?s=bsfree2&sys=2&gid=5434

Way better, and contains the same code as the first link
http://www.thegshi.org/?s=bsfree2&sys=2&gid=7932

Castlevania II (There are 2 entries where there is Castlevania 2, they are same game, II is the correct titling.)

Bad:
http://www.thegshi.org/?s=bsfree2&sys=2&gid=5023

This one is alright, but
http://www.thegshi.org/?s=bsfree2&sys=2&gid=5445

thi is better formatted, contains the same codes as above, but in hex, and has a couple of more codes...
http://www.thegshi.org/?s=bsfree2&sys=2&gid=6688

This GG one is great, maybe rename 2 to II?
http://www.thegshi.org/?s=bsfree2&sys=2&gid=1347

I have a couple of questions. What about hacked games? Many have overlap with the original game codes (There is something called Final Fantasy 99 in your NES listing...) It seems like it would clutter the listings if there were more submissions like that...

Same goes for japanese games (many playable with fan translation patchs) or have us/eu ports. Would it be possible to have a game name and an alternate to avoid this type of overlap?

For example:
Ducktales / Wanpaku Duck Yume Bouken
Dragon Warrior / Dragon Quest
Mega Man / Rockman

Or require a region for which game the codes were made for?
(U)
(E)
(J)
(World)

[LiquidManZero]

Unfortunately this mess was mostly caused by the collected all of those codes together in the first place. They made no attempt at sorting or any casual checking to see if the codes even are codes.

Your ideas are good.

Sadly implementing any of the changes to that data will take quite a lot of time and effort as currently there's not really an efficient way to manipulate what needs to be cleaned up.