Question about the structure of the SQLite database

[Rinusch]

Hi,

I have a question about the structure of the SQLite database and maybe the various XML files. I'm trying to figure out how to relate game images in my filesystem to games in the database.
What I'm trying to achieve, is to get the various game images and video's, including their filesystem paths, based on a game's DatabaseID. There must be some way. I can't imagine Launchbox is looking up all related media (for e.g. displaying in preview) by searching the file system at runtime every time I select a different game.

The filenames in the GameImages table seem to relate to image types in the various different categories, mentioned in the 'type' column. So I guess the names don't relate to thumbnail images in the cache folders (as they only contain box images). But they don't map to actual names in the filesystem. Also, I usually get more results than the actual number of images shown in Launchbox when I edit a game's metadata.

Is something like this possible?

Hope you can shed a light for me.
Very kind regards!

Edited Tuesday at 06:57 AM by Rinusch

[C-Beats]

6 hours ago, Rinusch said:

I can't imagine Launchbox is looking up all related media (for e.g. displaying in preview) by searching the file system at runtime every time I select a different game.

Unless I'm misunderstanding you this is exactly what is done. When you select a game we poll the drive for the box image (in cache if possible) as well as any artwork needed to display in the details panel of the app in question. The only time the DB is used is when attempting to see what images are available to download for a game in question and the filename of those images so we can then download it.