Changeset c6cdce6 in Klonkt for src/config/database.js

Timestamp:

06/28/2026 10:25:40 AM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

0596945

Parents:

37a297d

Message:

feat(news): show boosts from followed accounts in the News feed

An Announce (boost) from an account you follow, of a REMOTE post, was dropped — only Creates
and boosts of YOUR own posts were handled. Now such a boost resolves the boosted note and
stores it in ap_timeline (marked with who boosted it) so it appears in News with a 'X boosted'
label. We only store it for display and NEVER auto-Announce it onward (anti-feedback-loop);
published = now so it surfaces as fresh activity.

• config/database.js — ap_timeline.reblog_name/reblog_handle/reblog_icon
• services/ActivityPubService.js — handleInbox Announce branch stores remote boosts from followed accounts
• views/pages/news.ejs — 'boosted by' label; renamed the page-header div to tl-titlebar to avoid clashing with the card's tl-head class
• services/i18n.js — tl.boosted (nl/en/de)

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -334 +334 @@
   ensureColumn('ap_timeline', 'nsfw', 'INTEGER DEFAULT 0');  // remote sensitive post → blur in the Cirkel
   ensureColumn('ap_timeline', 'cw', 'TEXT');                 // remote content-warning text
+  ensureColumn('ap_timeline', 'reblog_name', 'TEXT');        // a followed account boosted this → "X boosted"
+  ensureColumn('ap_timeline', 'reblog_handle', 'TEXT');      //   the booster's @handle
+  ensureColumn('ap_timeline', 'reblog_icon', 'TEXT');        //   the booster's avatar
 }