Thumbnails — Video Posters

Build: bin/thumbs.php — Generate Posters

Last of the three CLI scripts. Walks all video rows where has_thumb = 0, generates a thumbnail, flips the flag. Run after metadata (because we need the duration to know where 10% is). Once done, the library page transforms.

1. Create /home/erictey/server/homestream/bin/thumbs.php.
2. Paste:

   #!/usr/bin/env php
   <?php
   declare(strict_types=1);
   
   require __DIR__ . '/../lib/db.php';
   
   $thumb_dir = __DIR__ . '/../storage/thumbs';
   if (!is_dir($thumb_dir)) mkdir($thumb_dir, 0775, true);
   
   $stmt = db()->query("
       SELECT id, path, duration_s
       FROM media
       WHERE type = 'video' AND has_thumb = 0
       ORDER BY id
   ");
   
   $made = 0;
   foreach ($stmt as $row) {
       $id   = (int) $row['id'];
       $path = $row['path'];
       $dur  = (int)($row['duration_s'] ?? 60);
   
       if (!is_file($path)) {
           echo "  skip (missing): $path\n";
           continue;
       }
   
       // 10% mark, but no less than 5 seconds and no more than 600
       $offset_s = max(5, min(600, (int) round($dur * 0.10)));
       $offset_hms = gmdate('H:i:s', $offset_s);
   
       $out = "$thumb_dir/$id.jpg";
   
       $cmd = sprintf(
           'ffmpeg -y -ss %s -i %s -vframes 1 -vf scale=320:-1 -q:v 4 %s 2>/dev/null',
           escapeshellarg($offset_hms),
           escapeshellarg($path),
           escapeshellarg($out)
       );
       shell_exec($cmd);
   
       if (is_file($out) && filesize($out) > 0) {
           db()->prepare("UPDATE media SET has_thumb = 1 WHERE id = ?")->execute([$id]);
           $made++;
           echo "  ✓ id=$id ($offset_hms)\n";
       } else {
           echo "  ✗ failed id=$id\n";
       }
   }
   
   echo "\nGenerated $made thumbnails.\n";

3. chmod +x bin/thumbs.php
4. Run: bin/thumbs.php. You should see each video logged with its offset.
5. Check the storage folder: ls -lh storage/thumbs/. You should see JPGs named by ID.
6. Test one in the browser: http://192.168.0.19/thumbs/1.jpg (sub a real video ID).
7. Now update the library page to show the thumbnails. In public/index.php, inside the foreach that renders each item, replace the simple type label with:

   <span class="type">
     <?php if ($item['type'] === 'video' && $item['has_thumb']): ?>
       <img src="/thumbs/<?= (int)$item['id'] ?>.jpg" style="width:60px;height:auto" alt="">
     <?php else: ?>
       <?= e(strtoupper($item['type'])) ?>
     <?php endif; ?>
   </span>

8. Refresh the library. Videos should now show actual thumbnails. Audio still shows the AUDIO label.

Stretch goals:

• For audio files, extract the embedded album art from ID3 tags (getID3 returns it as a binary blob in $info['comments']['picture'][0]['data']) and save it the same way.
• Generate a poster_url column instead of relying on the ID convention — opens the door to externally-sourced posters (TMDB API for movies).
• Add poster="/thumbs/{id}.jpg" to the <video> tag in play.php so the poster shows before play.
• Write a tiny "regenerate" link next to each item that runs the ffmpeg command with a different offset (in case the auto-pick was a bad frame).

What you flexed: ffmpeg one-liner with proper flags, gmdate for converting seconds to HH:MM:SS, escapeshellarg three times in one command, mkdir with permissions, the Apache Alias pattern repurposed for cached files, and the "flag column + conditional render" trick for showing different UI per row. The library page legitimately looks like a media app now.