Kludge to add more thumbnail images!

[paulusm]

I wanted to add more thumbnails to my links, and thought about using one of the screenshot services, like browshot, but decided on something more hacky, which actually worked OK. The idea was to get the largest image from each page, which is often a banner, featured image or touch icon.

Requirements:

• PhpMyAdmin access to your LinkAce DB (I am on Docker so just had to open the port to make it accessible from the host);
• A web server you can host additional thumbnail images on

1. Exported a list of ids and urls from links with no existing thumbnail, save these to links.csv.

SELECT id, url FROM `links` WHERE thumbnail is null;

2. Shell script to loop though and download all the images from those pages (I needed to find/replace all quotes from the CSV first for this to work)

#!/bin/sh
while IFS=, read -r id link; do 
    echo "The ID is $id, the link is $link";
    mkdir ./$id
    wget -nd -r -H -l 1 -T 3 -t 1 -P ./$id -A jpeg,jpg,png $link
done < links.csv 

3. Python script to loop through and select the biggest images, rename, and output SQL update (used claude.ai for this, so it's better than my code would be)

import os
import shutil

def get_largest_image(folder_path):
    max_size = 0
    largest_image = None
    for filename in os.listdir(folder_path):
        file_path = os.path.join(folder_path, filename)
        if os.path.isfile(file_path):
            size = os.path.getsize(file_path)
            if size > max_size:
                max_size = size
                largest_image = file_path
    return largest_image

def rename_largest_image(folder_path, largest_image):
    folder_name = os.path.basename(folder_path)
    new_name = os.path.join(folder_path, f"{folder_name}{os.path.splitext(largest_image)[1]}")
    os.rename(largest_image, new_name)
    return new_name

def process_folder(folder_path, new_folder_path ):
    largest_image = get_largest_image(folder_path)
    if largest_image:
        new_name = rename_largest_image(folder_path, largest_image)
        folder_name = os.path.basename(folder_path)
        file_name = os.path.basename(new_name)
        sql_statement = f"update links set thumbnail = 'https://your-web-hosting{folder_name}/{file_name}' where id = {folder_name};"
        print(sql_statement)
        # Copy the folder and the renamed image to the new folder path
        new_folder = os.path.join(new_folder_path, folder_name)
        os.makedirs(new_folder, exist_ok=True)
        shutil.copy(new_name, new_folder)

# Example usage
root_folder = "/path/to/folder"
new_folder_path = "/path/to/newfolder"
for folder in os.listdir(root_folder):
    folder_path = os.path.join(root_folder, folder)
    if os.path.isdir(folder_path):
        process_folder(folder_path, new_folder_path )

4. Upload the images to your web server and run the SQL update