Changeset 857a06f in Klonkt for src/routes/activitypub.js

Timestamp:

06/30/2026 05:43:39 PM (2 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

7ecbefc

Parents:

b5a09ce2

Message:

feat(video-cover): federate an animated cover as a Video attachment (not the WebP)

buildNote now prefers post.cover_video_url -> the muted loop MP4 ships as an AS2 Video attachment
instead of the animated WebP (unreliable on Mastodon + its iOS apps; the MP4 plays everywhere).
mediaType learns mp4/webm/mov; cover_video_url threaded through every buildNote source
(create/save hooks, Scheduler, outbox + featured + backfill SELECTs).

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

File:

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

src/routes/activitypub.js

@@ -76 +76 @@
   if (!site) return res.status(404).end();
   const posts = db.prepare(
-    `SELECT id, slug, title, content, cover_image_url, nsfw, content_warning, published_at, created_at
+    `SELECT id, slug, title, content, cover_image_url, cover_video_url, nsfw, content_warning, published_at, created_at
      FROM posts WHERE site_id = ? AND status = 'published' AND (fan_only IS NULL OR fan_only = 0)
      ORDER BY COALESCE(published_at, created_at) DESC LIMIT 20`
@@ -108 +108 @@
   // rank 1 last) → Mastodon flips it back to pin-rank ascending on the profile.
   const posts = db.prepare(
-    `SELECT id, slug, title, content, cover_image_url, nsfw, content_warning, published_at, created_at
+    `SELECT id, slug, title, content, cover_image_url, cover_video_url, nsfw, content_warning, published_at, created_at
      FROM posts WHERE site_id = ? AND status = 'published' AND (fan_only IS NULL OR fan_only = 0)
        AND pinned IS NOT NULL AND pinned > 0