QUOTE(helldoc @ May 30 2006, 11:16 PM)

You iso detection could have failed since the software was released only yesterday night with only 2 games in the database.
hi helldoc!
I tested only shortly before posting. Maybe i'll test again to make sure.
Also, I did a bit of work on this tonight, with regards to a proper database for storing all the infomation and linking everything up really nicely.
Anyway, i made a mysql database schema in mysql workbench, submitted a bunch of bug reports to them regarding that too but that's another story... Finally got a working db on my local install of mysql and i stuck some test data in it and mae a few queries, works great.
here's a list of tables:
GeoRegion, list of known regions that have differing ss's for the same game + autoid
VideoRegion, list of video regions, pal, ntsc, etc + autoid
Group, contains list of people/groups that make isos + autoid
ISOInfo, contains 4 md5's - 1 - whole iso, 2, data part, 3 video part, 4 ss part, though i might ditch 4 (see below) + autoid. Could contain data/filesizes and offsets too which could be used before even bothering to make md5's as comparing filesizes/data sizes is way quicker, and then use md5 to verify.
SSInfo, list of MD5's and an autoid field, nothing more
ReleaseInfo, list of known releases or otherwise available/created isos, links to GeoRegion, VideoRegion, GroupRegion via Foreign keys
ReleaseInfo_SSInfo, links SSInfo autoid's to ReleaseInfo autoid's also has two boolean fields, "Tested" and "Working"
ReleaseInfo_ISOInfo, links ISOInfo autoid's to ReleaseInfo autoid's.
With that you'd be able to list all SS's easily, in one place. then fill the rest of the data up as people submit it.
You could then do queries like this:
List all SS's for all releases
select * from releaseinfo as r
inner join releaseinfo_ssinfo as r_s on r_s.fkreleaseinfoid = r.id
inner join ssinfo as s on r_s.fkssinfoid = s.id;
List all releases that use a given SS MD5
select * from releaseinfo as r
inner join releaseinfo_ssinfo as r_s on r_s.fkreleaseinfoid = r.id
inner join ssinfo as s on r_s.fkssinfoid = s.id where s.md5 = 'd0350e6b02c4861b3254ffca975006fe';
List all releases by a group
select * from releaseinfo as r inner join `group` as g on g.id = r.fkgroupid where g.name like '%pi%';
Let me know if you want the SQL to create the DB and the mysql workbench files and some example data.
This post has been edited by hydrasworld: May 31 2006, 12:47 AM