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 ...
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
Moderator: Jimbo
- .mad.
- Honoured Member
- Location: Lancashire
Post
Re: Access to "popularity" values in Gamebase64
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.
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
Post
Re: Access to "popularity" values in Gamebase64
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?
![Smile :-)](./images/smilies/icon_smile.gif)
... 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.
- .mad.
- Honoured Member
- Location: Lancashire
Post
Re: Access to "popularity" values in Gamebase64
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.
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
Post
Re: Access to "popularity" values in Gamebase64
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![Smile :-)](./images/smilies/icon_smile.gif)
Thanks for the hints!
Edit: Just found the field - Table "Extras", Field "Type" must be 1 - this brings down the database to 11.145 games - better than nothing
![Smile :-)](./images/smilies/icon_smile.gif)
Thanks for the hints!
Who is online
Users browsing this forum: No registered users and 6 guests