Changeset 0596945 in Klonkt for src/routes/posts.js

Timestamp:

06/28/2026 10:33:07 AM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

515cf1a

Parents:

c6cdce6

Message:

fix(related): blur NSFW covers in the Related Posts section

The related-posts grid on a post page didn't blur sensitive covers. Now it selects nsfw +
content_warning and renders the same click-to-reveal veil as the feed/grid/Circle cards.

• routes/posts.js — related-posts queries (hub + solo) select nsfw, content_warning
• views/pages/post.ejs — nsfw-media + nsfw-veil on the related cover

File:

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

src/routes/posts.js

@@ -946 +946 @@
   const candidates = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, p.cover_image_url, p.published_at, p.tags, s.slug AS site_slug
+        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
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published' AND p.id != ?
@@ -952 +952 @@
       `).all(post.id)
     : db.prepare(`
-        SELECT id, slug, title, cover_image_url, published_at, tags
+        SELECT id, slug, title, cover_image_url, published_at, tags, nsfw, content_warning
         FROM posts
         WHERE site_id = ? AND status = 'published' AND id != ?