Changeset adb6291 in Klonkt for src/routes

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@…>

Location:

src/routes

Files:

• posts.js (modified) (2 diffs)
• tags.js (modified) (2 diffs)
• types.js (modified) (1 diff)
• users.js (modified) (1 diff)

src/routes/posts.js

@@ -998 +998 @@
   const candidates = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, p.cover_image_url, p.published_at, p.tags, p.nsfw, p.content_warning, s.slug AS site_slug
+        SELECT p.id, p.slug, p.title, p.cover_image_url, p.cover_video_url, p.published_at, p.tags, p.nsfw, p.content_warning, s.slug AS site_slug
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published' AND p.id != ?
@@ -1004 +1004 @@
       `).all(post.id)
     : db.prepare(`
-        SELECT id, slug, title, cover_image_url, published_at, tags, nsfw, content_warning
+        SELECT id, slug, title, cover_image_url, cover_video_url, published_at, tags, nsfw, content_warning
         FROM posts
         WHERE site_id = ? AND status = 'published' AND id != ?

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

src/routes/types.js

@@ -21 +21 @@
 
   const 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, p.type, u.username AS author_username
     FROM posts p JOIN users u ON u.id = p.author_id

src/routes/users.js

@@ -27 +27 @@
 
   const posts = db.prepare(`
-    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.published_at
+    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url, p.published_at
     FROM posts p
     WHERE p.author_id = ? AND p.site_id = ? AND p.status = 'published'