HowTo: Adding to the games database
Posted 10 May 2003 - 09:34 PM
Thanks; thats quite a pile.. how'd you do it all?
Posted 10 May 2003 - 10:10 PM
thats quite a pile.. how'd you do it all?
A mix of automatic (thanks to mighty Borland Delphi) and manual work
Posted 10 May 2003 - 11:35 PM
I'll check it though and report back, but mothers day will hold me up!
Posted 11 May 2003 - 03:48 AM
loic -- your GAU 1-100 -- I'll redo them, and the rest too, for you. KMy bug, I'll fix 'em. Also, I think I can script it.. I've got half the GAU disks downloaded. Once I get the other half, I can automate it, since I'll have them.
A600's GAU CRC32 are for the .ST versions; the Joe's versions are MSA.. so the two are complimentary, and not in collision. Will be good to have both.
Anyone else.. if you're using the old CRC32 from my site.. toss it, no good.. some of your numebrs will be bad Sorry about that. Stupid Windows :/
Iv'e got submissions for Cunix (good), SuperGau (all, good, .ST version), Pompey (not sure yet, I'll check them), and SuperGAU 1-100 (bad, sadly, but I'll redo them)
Posted 11 May 2003 - 03:58 AM
I will start on the Medway Boys.
Should be done by monday.
Hopefully we will not have aduplicate this time
Posted 11 May 2003 - 02:17 PM
Lets see.. I already had Flame of Finland...
Hmm. We're getting pretty complete
DBug has the games list already in the database, but no CRC32's. Anyone want to tackle them?
I'll post a new database tonight with all the changes and updates merged in. Should be quite spectacular, and I'll start on the by-game game listing mode.
Posted 11 May 2003 - 11:40 PM
Over the last few days, we've managed to add about 3000 entries to it or more
(approx 1000 super gau .ST, approx 1000 supergau .MSA, approx 1000 original disks, approx 112 Pompey, 8 Cynix, and what.. 50 or 80 Medway? Not to mention others I've forgotten
Take a look in the latest database for things like "::" which should locate disks and groups that have entries, but no CRCs. Also take a look for groups that are missing.. I think we've covered the major groups (like Automation, SuperGau, MEdway, DBug, etc), but theres a lot of smaller groups. Make sure we've filled in all the DBug, etc.
Maybe try CRC32'ing your own collection.. maybe we've got ST or MSA, and you've got the others so we could dobule up to make good and sure.
But I think this is a big success! Congrats all! Lots more to do, but we've come a very long way!
Grab 1.6 (or latest) here:
Posted 12 May 2003 - 01:16 AM
I just CRC32ed all my files (mostly single game disks), and gave proper names.
Trying the database, the Castaway correctly identified the images by their checksums, but spit
out a game name like "%§§$&§"
Here's a copy of the first lines of the database:
OR:1:269d8e3d:Great Giana Sisters
OR:1:f975338c:Fire and Ice - Disk 1
OR:1:ddbf2cd9:Arkanoid - Revenge of Doh
OR:1:c75a3bf:Nebulus; Mouse Trap
I copied ALL my files onto the SMC and tried the database line by line.
The first few entries were correct, but when I got to the Nebulus entry, Castaway told me
on that disk... I don't know why.
Okay, I thought for myself, I'd just kill that faulty Nebulus-entry and everything worked fine.
But after deleting, also the first few lines, which were working correctly until that time, spit out unreadable
names... so I think it's something else.
Any ideas what this could be?
I'm using the latest Batch CRC32. And I'm always deleting the STCACHE1.TXT before trying again...
Posted 12 May 2003 - 09:01 AM
edit: I was also thinking about contacting Joe who runs the FTP site and asking him if he'd be interested in doing a btach CRC of all the discs on his server? All we'd have to dio then is collate.
Posted 12 May 2003 - 12:11 PM
Calculate CRC or pick it up from Cache.
Look for CRC in the database.
Search for newline so it knows where end of line is.. it never goes past end of line.
Search for semicolon and newline; whichever comes first is gamename.
If it was semicolon, repeat the above test.
When it has a game name, it dupes it into a return list; perhaps the GP32 is failinfg to get memory for the return list, though that should be fine and I've never had a problem myself.
The fact it can vary though is odd.. items work, then next time do not.
I need to see that occuring :/ If I coudl see it, I could fix it asap :/
So hang on.. I'll see it eventually
Posted 15 May 2003 - 01:24 PM
Posted 15 May 2003 - 03:35 PM
Theres also groups missing.. like Zuul, etc, and the megademos and such are all missing..
Posted 15 May 2003 - 03:41 PM
edit: 1 to 58 inclusive (37 discs from JOE'S FTP) DONE
I don't have them but I may as well abuse the work T1 connection to get them. I'll do MSA and ST CRCs and take the data home to format.
COME ON PEOPLE! Give as well as taking!
Posted 16 May 2003 - 04:40 PM
Posted 04 June 2003 - 03:15 PM
If so, is anyone doing the 'Atari ST Pirate Gold' set? if not, ill do them, these are single disks but would be nice to see them in the new list in 12.1
little confused on this but ill give it a shot tomorrow