Finding Game Images In LaunchBox.Metadata.db

[tikiTofu]

Hi, I'm trying to get the path for the game images used per game in LaunchBox.
I assume I need to look through LaunchBox.Metadata.db to do this...

My results seems be this guid-looking-filename which doesn't exist on disk.
Is the approach correct or is there a better method to getting this data?

import sqlite3

db_path = r"C:\Users\HP\LaunchBox\Metadata\LaunchBox.Metadata.db"
conn = sqlite3.connect(db_path)

def check_game_images(conn, platform_name):
    cursor = conn.cursor()
    
    query = """
    SELECT g.Name, gi.FileName, gi.Type, gi.Region
    FROM GameImages gi
    JOIN Games g ON g.DatabaseID = gi.DatabaseId
    WHERE g.Platform = ?
    """
    
    cursor.execute(query, (platform_name,))
    results = cursor.fetchall()
    
    if results:
        for result in results:
            game_name = result[0]
            file_name = result[1]
            image_type = result[2]
            region = result[3] if result[3] else "Unknown"
            print(f"Game: {game_name}")
            print(f"Image FileName: {file_name}")
            print(f"Image Type: {image_type}")
            print(f"Region: {region}")
            print("-" * 40)
    else:
        print(f"No images found for platform '{platform_name}' in the GameImages table.")

check_game_images(conn, "Nintendo Entertainment System")

conn.close()

 

My results look like
Game: Zelda II: The Adventure of Link
Image FileName: 340d97ea-ad0e-4801-9b53-479df72f9f11.png
Image Type: Clear Logo
Region: World

Where the filename should be:
Zelda II_ The Adventure of Link-01.png

Thanks!!

 

[JoeViking245]

30 minutes ago, tikiTofu said:

My results look like
Game: Zelda II: The Adventure of Link
Image FileName: 340d97ea-ad0e-4801-9b53-479df72f9f11.png
Image Type: Clear Logo
Region: World

Where the filename should be:
Zelda II_ The Adventure of Link-01.png

The [GUID] Image FileName shown is how it's stored on the Games Database website.

In normal operations when you download the image, LaunchBox will rename the image file to your games' Title (replacing invalid characters with _ (underscore)) and adding the 'next available image count' (in your case, -01). Then of course, keeping the file extension.

 

If you're wanting to get the images you have already per game, you'd need to look in your Images folder.  LaunchBox doesn't store information anywhere about your local images.  It simply looks in the respective folder(s).

[C-Beats]

That file is for the Games DB not your local library data. The image file is typically {Coerced Game  Title}{Game Guid (optional, only if platform has multiple games with same name)}-##.{Extension}. The file is located in the folder that platform has set for that image type. If you're building a LB plugin you can just use the IGame.GetAllImagesWithDetails function to get all images associated to a game as well.

[tikiTofu]

4 minutes ago, JoeViking245 said:

If you're wanting to get the images you have already per game, you'd need to look in your Images folder.  LaunchBox doesn't store information anywhere about your local images.  It simply looks in the respective folder(s).

Ahh ok, my purpose was to build compile marquee images via python using existing game images.  I can just use a different method based on the game/folder names. Thanks everyone.

[JoeViking245]

7 minutes ago, tikiTofu said:

Ahh ok, my purpose was to build compile marquee images via python using existing game images.  I can just use a different method based on the game/folder names. Thanks everyone.

If you by-chance have a Pixelcade marquee, you could use this plugin to create them for you.   Or if you'd prefer to 'play' with Python, continue on.  

[C-Beats]

If you're using LB you can just make a Marquee view that utilizes existing images as well (though the default one does this already)

[tikiTofu]

1 hour ago, C-Beats said:

If you're using LB you can just make a Marquee view that utilizes existing images as well (though the default one does this already)

Interesting! This seems like the most accessible approach, C-Beats and likely what I've been looking for. Would you be able to point me to some resources?  Thank you.

Also, JoeViking245, I don't have pixelcade but a generic 1920x360, but that looks interesting, thanks for sharing.

 

[tikiTofu]

I found this and will review. Thank you. 😀