Page 1 of 1

Access to "popularity" values in Gamebase64

Posted: Fri Apr 03, 2020 7:24 pm
by badda
Hi,
is there a way I can access the values of special gamebase64 fields, like "GB64 Recommended", "Downloads" or "Top 100"? These fields only seem to be available for the Webpage, but not in the GBC_v16.mdb file ...

Re: Access to "popularity" values in Gamebase64

Posted: Sat Apr 04, 2020 7:14 pm
by .mad.
Only data for the top 50 games can be viewed in a custom filter.

from GameBase select...
Add View (CTRL+A)
type "Classic Games" for the filter name.
Click ADD.
select Classic Game from the Field list.
Opertator IS
Fliter Data YES
Click OK.

select Classic Games from the custom filters.

Re: Access to "popularity" values in Gamebase64

Posted: Sun Apr 05, 2020 5:20 pm
by badda
Thanks for the info :-) My issue is that I need to reduce the filesize of the gb64 database to about 1/4th for a low mem system and would like to kick out the least popular games. Is there any way for me to identify which games I could kick out?
... or could you guys help me by giving me the number of downloads?

Re: Access to "popularity" values in Gamebase64

Posted: Sun Apr 05, 2020 5:40 pm
by .mad.
There's no quick fix to do that.

selecting the best games out of a list of 29,000 is a personal choice.
whatever you choose to leave out, someone will want it.

you could add all the games you want to keep to the favourites filter.
then delete all the others.

Or reduce the list by filtering commercial releases.
keeping only the games containing Original Disk, Tape or Cart images.
and delete everthing else.

if you want to keep every game, and reduce the actual size of the database uses on an SD card.
you could delete all EXTRAS and Music.
this would reduce the size from 12GB to approx 800MB.

all options require editing the database file in Microsoft Access.

Re: Access to "popularity" values in Gamebase64

Posted: Sun Apr 05, 2020 6:47 pm
by badda
The Access-DB is my base of information already. The fields "Rating" and "Classic" in table "Games" identify the top 50, but which field identifies commercial releases?

Edit: Just found the field - Table "Extras", Field "Type" must be 1 - this brings down the database to 11.145 games - better than nothing :-)

Thanks for the hints!