Welcome to the Gamebase 64 forums.                 An attempt to document ALL Commodore 64 gameware before it's too late!

Access to "popularity" values in Gamebase64

Are you having problems setting up GB64 on your machine? Ask your questions in here!

Moderator: Jimbo

badda
New Member
Posts: 4
Joined: Wed Feb 05, 2020 9:53 am

Access to "popularity" values in Gamebase64

Fri Apr 03, 2020 7:24 pm

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 ...
User avatar
.mad.
Honoured Member
Honoured Member
Location: Lancashire
Posts: 2256
Joined: Sun Jun 19, 2005 3:30 pm

Re: Access to "popularity" values in Gamebase64

Sat Apr 04, 2020 7:14 pm

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.
badda
New Member
Posts: 4
Joined: Wed Feb 05, 2020 9:53 am

Re: Access to "popularity" values in Gamebase64

Sun Apr 05, 2020 5:20 pm

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?
Last edited by badda on Sun Apr 05, 2020 5:56 pm, edited 1 time in total.
User avatar
.mad.
Honoured Member
Honoured Member
Location: Lancashire
Posts: 2256
Joined: Sun Jun 19, 2005 3:30 pm

Re: Access to "popularity" values in Gamebase64

Sun Apr 05, 2020 5:40 pm

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.
badda
New Member
Posts: 4
Joined: Wed Feb 05, 2020 9:53 am

Re: Access to "popularity" values in Gamebase64

Sun Apr 05, 2020 6:47 pm

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!

Return to “GB64 Help!”

Who is online

Users browsing this forum: Ahrefs [Bot], Google [Bot] and 7 guests