Re: PS1 Vault

Yes, I was looking at that last night and the discrepancy is due to duplicate records. I should be able to craft a query to identify them all.

MediEvil's an odd duck due to its double digit betas. The Vault assigns each beta a unique version number starting with 0.1. That's a problem when you reach beta 10, since mathematically 0.1 == 0.10
Perhaps I should start at v0.01 instead.

Looks like there are some errors in the PS1 Vault. Redump dat contains 10678 discs (10685 with possible bad dumps), but the Vault "...contains 10773 of 10785...". I think this is because of duplicate records. There are some examples:

Astronoka (Japan) (Demo) - two records in the vault, the same link
Bio Hazard (Japan) (Demo) - two records in the vault, the same link
Crime Killer (Europe) (En,Fr,De,Es,It) - two records in the vault, two links, the same file/hash
Crisis Beat (Europe) - two records in the vault, two links, the same file/hash
CT Special Forces (Europe) (En,Fr,De,Es,It,Nl) - two records in the vault, two links, the same file/hash
etc.

Is it possible to find and delete all duplicate records on server?

Also MediEvil (Europe) Beta 10, Beta 11 and Beta 12 are linked to Beta 13 (and all of them have version 1.0 in the Vault)