Re: Boulderdash conversion
Posted: Mon Jan 05, 2026 4:01 pm
Hi,
how to use the database.
-- Get all "tosec" caves which are not included in GDash.
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and g.GDASHGAME_TYPE != 1 -- not GDash cave
--and g.gdashgame_ref = 10005
and not exists (select * from gdash_cave ce, gdash_game ge
where ge.GDASHGAME_REF = ce.gdashgame_ref
and ce.GDASHGAME_REF != c.gdashgame_ref
and ge.gdashgame_type = 1 -- GDash cave
and ce.GDASHCAVE_MD5 = c.GDASHCAVE_MD5)
order by c.gdashgame_ref, c.GDASHCAVE_NO;
-- determine most used caves
select c.GDASHCAVE_MD5, count(*) cnt from gdash_cave c group by c.GDASHCAVE_MD5 order by cnt desc;
-- check specific checksum ---- Intermission 17 of "AFL Boulderdash (MUSIC)" dont exists in GDash (or have differences).
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and c.GDASHCAVE_MD5 = '3C9850A5D295E14C83B695EA0D2044E5';
-- check specific checksum ---- Intermission 2 of "Boulderdash VIII" (Don Pedro) is used multiple times.
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and c.GDASHCAVE_MD5 = '795FA4752BC54CB9EF1B5BEE36605791';
how to use the database.
-- Get all "tosec" caves which are not included in GDash.
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and g.GDASHGAME_TYPE != 1 -- not GDash cave
--and g.gdashgame_ref = 10005
and not exists (select * from gdash_cave ce, gdash_game ge
where ge.GDASHGAME_REF = ce.gdashgame_ref
and ce.GDASHGAME_REF != c.gdashgame_ref
and ge.gdashgame_type = 1 -- GDash cave
and ce.GDASHCAVE_MD5 = c.GDASHCAVE_MD5)
order by c.gdashgame_ref, c.GDASHCAVE_NO;
-- determine most used caves
select c.GDASHCAVE_MD5, count(*) cnt from gdash_cave c group by c.GDASHCAVE_MD5 order by cnt desc;
-- check specific checksum ---- Intermission 17 of "AFL Boulderdash (MUSIC)" dont exists in GDash (or have differences).
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and c.GDASHCAVE_MD5 = '3C9850A5D295E14C83B695EA0D2044E5';
-- check specific checksum ---- Intermission 2 of "Boulderdash VIII" (Don Pedro) is used multiple times.
select g.*, c.* from gdash_game g, gdash_cave c
where c.gdashgame_ref = g.gdashgame_ref
and c.GDASHCAVE_MD5 = '795FA4752BC54CB9EF1B5BEE36605791';