Changeset 8cdb377 in Klonkt for src/routes/posts.js

Timestamp:

06/19/2026 09:40:04 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

535f955

Parents:

1e2e9e7

Message:

ui(post-nav): show 📌 when the Newer/Older post is pinned

postNeighbors() now also selects pinned; the partial shows a 📌 next to
the label of a pinned neighbour (solo + hub).

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

File:

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

src/routes/posts.js

@@ -401 +401 @@
   const ordered = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, s.slug AS site_slug
+        SELECT p.id, p.slug, p.title, p.pinned, s.slug AS site_slug
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published'
@@ -407 +407 @@
       `).all()
     : db.prepare(`
-        SELECT id, slug, title FROM posts
+        SELECT id, slug, title, pinned FROM posts
         WHERE site_id = ? AND status = 'published'
         ORDER BY (pinned = 0) ASC, pinned ASC, published_at DESC