Changeset adb6291 in Klonkt for src/routes/tags.js

Timestamp:

06/30/2026 06:11:50 PM (2 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

a95dbfd

Parents:

1c33804

Message:

feat(video-cover): render iOS video covers across grid, list, related + listing pages

• post-tile.ejs / post-card.ejs / post.ejs(related): the cover <img> carries data-ios-mp4 when a loop MP4 exists; shell.ejs's iOS swap upgrades it everywhere covers render
• cover_video_url threaded through the explicit listing SELECTs (tags/types/users/related); the home grid + main list already use SELECT p.*

Co-Authored-By: Claude <noreply@…>

File:

• src/routes/tags.js (modified) (2 diffs)

src/routes/tags.js

@@ -22 +22 @@
   try {
     posts = db.prepare(`
-      SELECT DISTINCT p.id, p.slug, p.title, p.excerpt, p.cover_image_url,
+      SELECT DISTINCT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url,
                       p.published_at, u.username AS author_username
       FROM posts p, json_each(p.tags) j
@@ -35 +35 @@
     // Fall back to a LIKE match if json_each isn't available for some reason
     posts = db.prepare(`
-      SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url,
+      SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url,
              p.published_at, u.username AS author_username
       FROM posts p JOIN users u ON u.id = p.author_id