[NES] Master sheet comparisons

Post all database contributions here.
Post Reply
Vigi
Posts: 128
Joined: 18 Jun 2008 10:16

[NES] Master sheet comparisons

Post by Vigi » 14 Oct 2018 18:24

Here is an Excel file with 2 sheets: https://www35.zippyshare.com/v/AqVgbvEJ/file.html
No-Intro = No-Intro NES ROMs, split in Program and Character parts using ReadNES. Then the Checksum (16 bits) was calculated on all these files.
Nintendo = FileList.csv from the nintendo release spreadsheets

What we can check for:
- No-Intro not in Nintendo: Assuming the Nintendo data is complete, these should be Unlicensed/Beta/Proto ROMs and possibly bad dumps? Possibly there are some (Unl) games that don't have the correct filename yet.
- Nintendo not in No-Intro: These should be undumped retail games and possibly bad dumps.

ps. I'm not sure what the odds are of getting an identical 16-bit checksum between files with different contents (that could mess up our research), but I guess this is the best we can do with this data.
Last edited by Vigi on 14 Oct 2018 20:34, edited 4 times in total.

Vigi
Posts: 128
Joined: 18 Jun 2008 10:16

Re: [NES] Master sheet comparisons

Post by Vigi » 14 Oct 2018 18:49

edit: See this post for the results: viewtopic.php?f=6&t=3228&p=20298#p20298
Last edited by Vigi on 17 Oct 2018 15:06, edited 48 times in total.

Vigi
Posts: 128
Joined: 18 Jun 2008 10:16

Re: [NES] Master sheet comparisons

Post by Vigi » 14 Oct 2018 20:04

So it looks like the FileList.csv is incomplete. The other sheet contains more checksums of games that are dumped and possibly undumped. I will do more checks later if someone else doesn't beat me to it.

relax
High Council
Posts: 693
Joined: 27 May 2008 17:52

Re: [NES] Master sheet comparisons

Post by relax » 14 Oct 2018 20:34

Vigi wrote:
14 Oct 2018 20:04
So it looks like the FileList.csv is incomplete and the other sheet contains more checksums of games dumped by No-Intro, so additional checks are needed.
Yes, I was just going to write that, couldn't find Zelda rev 2 in FileList.csv for instance. HNPdata_List has more entries it seems, but it's still not complete, it only contain carts that Nintendo made, not third parties.

Mighty Bomb Jack (Japan): We have character ROM checksum of B2E2. This is the same as CHR-0 in HNPdata_List, but CHRCRC is listed as 52E2. CHR size is 8KB, while CHR size for USA and Europe is 32KB. I filled the CHR ROM with FFs to make it 32KB, 8KB at the front and 16KB at the end, then I got a checksum of 52E2. So maybe we can't use CHRCRC to compare in all cases.

Rockman 4 - Aratanaru Yabou!! (Japan) (Rev A): Matches the 3DS Virtual Console dump.
viewtopic.php?p=20132#p20132

Vigi
Posts: 128
Joined: 18 Jun 2008 10:16

Re: [NES] Master sheet comparisons

Post by Vigi » 14 Oct 2018 20:50

relax wrote:
14 Oct 2018 20:34
Mighty Bomb Jack (Japan): We have character ROM checksum of B2E2. This is the same as CHR-0 in HNPdata_List, but CHRCRC is listed as 52E2. CHR size is 8KB, while CHR size for USA and Europe is 32KB. I filled the CHR ROM with FFs to make it 32KB, 8KB at the front and 16KB at the end, then I got a checksum of 52E2. So maybe we can't use CHRCRC to compare in all cases.
So the actual cartridges are confirmed to have 8KB chips? If so, then I guess we should do the same checks for the other "bad dumps" in the list.
Rockman 4 - Aratanaru Yabou!! (Japan) (Rev A): Matches the 3DS Virtual Console dump.
viewtopic.php?p=20132#p20132
Hope it gets added then? :P

relax
High Council
Posts: 693
Joined: 27 May 2008 17:52

Re: [NES] Master sheet comparisons

Post by relax » 14 Oct 2018 21:09

Vigi wrote:
14 Oct 2018 20:50
relax wrote:
14 Oct 2018 20:34
Mighty Bomb Jack (Japan): We have character ROM checksum of B2E2. This is the same as CHR-0 in HNPdata_List, but CHRCRC is listed as 52E2. CHR size is 8KB, while CHR size for USA and Europe is 32KB. I filled the CHR ROM with FFs to make it 32KB, 8KB at the front and 16KB at the end, then I got a checksum of 52E2. So maybe we can't use CHRCRC to compare in all cases.
So the actual cartridges are confirmed to have 8KB chips? If so, then I guess we should do the same checks for the other "bad dumps" in the list.
It's 8KB according to bootgod and Nintendo's masterlist.
http://bootgod.dyndns.org:7777/profile.php?id=1261
Vigi wrote:
14 Oct 2018 20:50
relax wrote:
14 Oct 2018 20:34
Rockman 4 - Aratanaru Yabou!! (Japan) (Rev A): Matches the 3DS Virtual Console dump.
viewtopic.php?p=20132#p20132
Hope it gets added then? :P
It will sooner or later ;)

User avatar
BigFred
High Council
Posts: 1140
Joined: 22 May 2008 22:42

Re: [NES] Master sheet comparisons

Post by BigFred » 14 Oct 2018 21:39

.\PAL\NINTENDO\PALMJ0P.031 = "MAHJAN" (title unknown?) = undumped
I bet this is the rare PAL Hong Kong Mah Jong cart.
.\HVC\HFCV60C.537 = Klax (Japan)Character.bin = bad dump?
KLAX CHR 830C = 2xCHR of current dump

relax
High Council
Posts: 693
Joined: 27 May 2008 17:52

Re: [NES] Master sheet comparisons

Post by relax » 14 Oct 2018 22:14

.\PAL\NINTENDO\PALGFY0P.011 = "GOLF(ヤード表示)" (title unknown?) = undumped
This is a PAL version with yard display instead of metric.

KingMike
Posts: 395
Joined: 22 Sep 2012 16:36

Re: [NES] Master sheet comparisons

Post by KingMike » 15 Oct 2018 03:57

Vigi wrote:
14 Oct 2018 20:50
relax wrote:
14 Oct 2018 20:34
Mighty Bomb Jack (Japan): We have character ROM checksum of B2E2. This is the same as CHR-0 in HNPdata_List, but CHRCRC is listed as 52E2. CHR size is 8KB, while CHR size for USA and Europe is 32KB. I filled the CHR ROM with FFs to make it 32KB, 8KB at the front and 16KB at the end, then I got a checksum of 52E2. So maybe we can't use CHRCRC to compare in all cases.
So the actual cartridges are confirmed to have 8KB chips? If so, then I guess we should do the same checks for the other "bad dumps" in the list.
Well, I think it was Star Force, another Tecmo game, was known to use CHR bankswapping despite having only one bank, as a copy-protection measure (that is, it expected to get consistent garbage data when it swaps in bad data). Not sure if Tecmo tried that on other games.

User avatar
BigFred
High Council
Posts: 1140
Joined: 22 May 2008 22:42

Re: [NES] Master sheet comparisons

Post by BigFred » 15 Oct 2018 10:50

relax wrote:
14 Oct 2018 22:14
.\PAL\NINTENDO\PALGFY0P.011 = "GOLF(ヤード表示)" (title unknown?) = undumped
This is a PAL version with yard display instead of metric.
Is the Golf "GFM" version dumped? Possibly the M is not part of the serial but the one printed on the back of some carts? (And the Y as well?)

https://www.ebay.de/itm/Golf-inkl-Handb ... SwtXBatRgC

*edit*

I see - the PRG of all currently dumped PAL-versions is PAL-GFm0 which is quite unusual especially since the cart serial is just NES-GF-XXX. According to the list there is also a PAL GF 0 release which appears to be completely identical to the US release. I wonder where it was released?

So basically we miss a version with PAL-GFy0 PRG ROM. Where do they use yards? I guess we should check the UK version?

relax
High Council
Posts: 693
Joined: 27 May 2008 17:52

Re: [NES] Master sheet comparisons

Post by relax » 15 Oct 2018 16:53

Yes, they use yards in the UK. There's a UK-version of Golf.
https://www.ebay.co.uk/itm/173106904616
https://www.ebay.co.uk/itm/202454377672

Not to be confused with the GBR-version (Great Britain?), which also has Italian text on the label, so this can't have yards.
https://www.ebay.co.uk/itm/323432350508

KingMike
Posts: 395
Joined: 22 Sep 2012 16:36

Re: [NES] Master sheet comparisons

Post by KingMike » 15 Oct 2018 18:07

As I understand NES PAL-A region was UK, Italy (and Australia/NZ).
Perhaps the GBR cart was made for all those regions (what ever the country code means).

Vigi
Posts: 128
Joined: 18 Jun 2008 10:16

Re: [NES] Master sheet comparisons

Post by Vigi » 15 Oct 2018 20:35

I cleaned up the "In FileList.csv but not in No-Intro" check in the 2nd post: viewtopic.php?f=6&t=3228#p20209
There are still some "bad dumps" left that need to be double checked.

I also started the check "In HNPdata but not in No-Intro" on the bottom of the post (WIP).
After removing any games from the NHPdata that had matching No-Intro ROMS, there are around 150 titles left to check. These are titles where the PRG checksum in the sheet doesn't match any No-Intro ROM, and that also don't have any PRG ROM listed in the FileList.csv.
I checked around 20 titles, and on first glance it seems that many of the titles are unreleased / cancelled. I don't know if there is a column somewhere in the sheet that confirms this? My Japanese is not that good :P

relax
High Council
Posts: 693
Joined: 27 May 2008 17:52

Re: [NES] Master sheet comparisons

Post by relax » 15 Oct 2018 21:16

Great initiative. :) When you write "Unreleased?", is that your speculation, or did you find some clues supporting this?

User avatar
BigFred
High Council
Posts: 1140
Joined: 22 May 2008 22:42

Re: [NES] Master sheet comparisons

Post by BigFred » 15 Oct 2018 21:51

The confirmation of R.C. Pro Am from a physical cart is not really required imo because the hypothetical revision 2 is actually the exact same as the existing revision 1. The first release to use PRG + CHR ROMs according to their list is what they call revision 2 which is our known revision A so they must refer to the same release and a "B" stamped cart doesn't make sense. They don't list a B in the first column as well, just A. They can't mean "our" revision A by revision 1 as they use different ROM sets. It is unclear what they actually mean by version 1 and how you identify it.

About the "unreleased " section:

I have seen an A stamped Batteltoads in a local shop and I listed it in my undumped xls - I believe there is a good chance it exists.

Afair Cowering mentioned he has Home Alone 2. I can ask him for pictures maybe.

Zelda is strange because the revision 2 is supposed to be produced much earlier than the release of the Nintendo Classics series. It would be the only version using PRG + CHR Roms.

Post Reply