Changeset 2af2e69 in Klonkt

Timestamp:

06/25/2026 07:18:05 AM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

f9f3312

Parents:

5085b1d

Message:

fediverse: emit featured collection reversed (Mastodon displays pins last-first)

Mastodon shows a remote actor's featured collection in reverse of the orderedItems
order (pins ordered by processed-time desc). So we now emit pin-rank DESCENDING →
Mastodon flips it back to rank 1 first on the profile.

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

File:

• src/routes/activitypub.js (modified) (1 diff)

src/routes/activitypub.js

@@ -77 +77 @@
   const site = publicSite(req.params.slug);
   if (!site) return res.status(404).end();
+  // NB: Mastodon DISPLAYS the featured collection in REVERSE (pins shown
+  // last-processed-first). So we emit it reversed (lowest pin priority first,
+  // 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, 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
-     ORDER BY pinned ASC, COALESCE(published_at, created_at) DESC LIMIT 20`
+     ORDER BY pinned DESC, COALESCE(published_at, created_at) ASC LIMIT 20`
   ).all(site.id);
   AP.sendAP(res, AP.buildFeatured(baseUrl(req), site, posts));