Hi
You may or may not have heard, but I am creating a new gamebase engine and have a question about how you setup your databases...
For the following tables: -
Artists,
Developers,
Language,
Musicians,
Programmers,
Publishers,
Do any of you ever rename these in the ini file and use them entirely to represent something else? If so, these tables lend themselves to be changed to a one-to-many relationship with the "Games" table (i.e. 1 game links to *many* programmers).
For the following also: -
Crackers,
Difficulty,
Licenses,
Rarities
These tables lend themselves to a 1 to 1 relationship with Games... do any of you change the meaning of these and wish they were 1 to many?
I hope that makes sense.
Please post any examples where you do.
This is to help me with the converter from the old mdb format to the new sqlite format.
Cheers
Jimbo
Welcome to the Gamebase 64 forums. An attempt to document ALL Commodore 64 gameware before it's too late!
ATTN: DB CREATORS: question on how you setup your gamebases
Moderator: Jimbo
- .mad.
- Honoured Member
- Location: Lancashire
Post
Hi Jimbo,
i am always messing about with those fields in the text.ini to display something else.
example
[Record Selector Window]
;dialog for selecting a different publisher, programmer, musician, language, cracker etc.
;Keyboard Shortcuts: NO
CaptionPublisher=Select Publisher
CaptionProgrammer=Select Serial Number
CaptionMusician=Select Scene File Name
CaptionLanguage=Select Region
CaptionCracker=Select ROM Dumper
CaptionArtist=Select Save Type
CaptionDeveloper=Select Developer
CaptionLicense=Select Internal Name
CaptionRarity=Select CRC32
Publishers=Publishers
Programmers=Serial Number
Musicians=Scene File Name
Languages=Region
Crackers=ROM Dumper
Artists=Save Type
Developers=Developers
Licences=Internal Name
Rarities=Rarities
-
in several examples only 1 game will have that CRC32 or serial.
so it does not need to be a 'clickable' field.
i am always messing about with those fields in the text.ini to display something else.
example
[Record Selector Window]
;dialog for selecting a different publisher, programmer, musician, language, cracker etc.
;Keyboard Shortcuts: NO
CaptionPublisher=Select Publisher
CaptionProgrammer=Select Serial Number
CaptionMusician=Select Scene File Name
CaptionLanguage=Select Region
CaptionCracker=Select ROM Dumper
CaptionArtist=Select Save Type
CaptionDeveloper=Select Developer
CaptionLicense=Select Internal Name
CaptionRarity=Select CRC32
Publishers=Publishers
Programmers=Serial Number
Musicians=Scene File Name
Languages=Region
Crackers=ROM Dumper
Artists=Save Type
Developers=Developers
Licences=Internal Name
Rarities=Rarities
-
in several examples only 1 game will have that CRC32 or serial.
so it does not need to be a 'clickable' field.
- freenit
- Keen Member
Post
Hi Jimbo ,
I am very happy that finally someone is working on the GameBase frontend . I hope this new version has support for video and by selecting a game a video is displayed automatically .
I would also like to have support for Windows games , for those who want to make a pc gamebase without emulator.
Well, thanks for your work and I'd just like to know when this new version of the frontend will be released...
Regards.
I am very happy that finally someone is working on the GameBase frontend . I hope this new version has support for video and by selecting a game a video is displayed automatically .
I would also like to have support for Windows games , for those who want to make a pc gamebase without emulator.
Well, thanks for your work and I'd just like to know when this new version of the frontend will be released...
Regards.
- K.C.
- Cool Member
- Location: The Netherlands
Post
There are 3 Gamebase Collections where I modified the Text.ini file for storing information that the frontend has no appropriate fields for:
CBM Digital Library
(Collection of Commodore 8 bit computers related books in PDF format)
(Collection of C64 software that is not included in the GameBase64 collection, like productivity software and utilities)
(Collection Handheld LCD/LED game simulators)
CBM Digital Library
(Collection of Commodore 8 bit computers related books in PDF format)
- Field GameLength: Used for number of pages.
- Field Original: Used to indicate if PDF file is searchable
- Field Genres: Renamed to "Document type" and modified the genres in Access.
- A few minor changes (like "Programmer" renamed to "Author").
(Collection of C64 software that is not included in the GameBase64 collection, like productivity software and utilities)
- Field Musician: Used to specify the image type (D64, T64, TAP, etc).
- Field Genre: Modified the genres in Access.
- Field HighScoreSaver: Used to specify if the program is an (uncracked) Original. I used this field, because the development started when GameBase 1.2 was the current release. This version did not include the Original field.
(Collection Handheld LCD/LED game simulators)
- Field Genre: Modified the genres in Access.
Return to “Other GameBase Projects”
Who is online
Users browsing this forum: Bing [Bot] and 46 guests