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

Timestamp:

07/26/2026 09:52:24 AM (6 weeks ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

42e7616

Parents:

3597763

Message:

Web: custom-emoji ook in messages + threads (Shaer-pariteit)

Na de nieuwsfeed nu ook de andere note-surfaces: messages (msg-item) en
thread-replies (fedi-node) renderen custom-emoji's in de content en in de
auteur-naam. De emoji-tags werden voor replies nog niet bewaard; nu vangt
ap_interactions ze (emoji_json = content-emoji uit o.tag/child.tag,
actor_emoji_json = naam-emoji uit actorInfo) op inbound reply, like/boost en de
thread-crawl, en getNotifications/getInteractions serveren ze mee.

De .emoji-CSS staat nu globaal in shared-styles (was news-only), zodat alle
surfaces 'm delen.

Changed files:
src/config/database.js

• ap_interactions.emoji_json + actor_emoji_json kolommen

src/services/ActivityPubService.js

• INSERT ap_interactions + 3 callers (reply/like-boost/thread) vullen de emoji-kolommen
• emojiJsonOf() helper
• _listI + getNotifications SELECT en getInteractions-node geven emoji mee

src/views/partials/msg-item.ejs

• naam + content via emojiName/emojiHtml

src/views/partials/fedi-node.ejs

• auteur-naam + content via emojiName/emojiHtml

src/views/partials/shared-styles.ejs

• globale img.emoji-regels (inline, geen media-styling)

src/views/pages/news.ejs

• dubbele img.emoji-regels weg (nu globaal)

remarks: 187 tests groen. Visueel geverifieerd via standalone render van msg-item
+ fedi-node. Nieuwe replies vangen emoji direct; oude rijen niet (geen self-heal).
Quote-in-replies en de Cirkel-tegel-titels bewust nog niet meegenomen.

-robo
Co-Authored-By: Claude Opus 4.8 <noreply@…>

File:

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

src/config/database.js

@@ -571 +571 @@
   // context instead. Existing rows default to 'public' (historically almost all were).
   ensureColumn('ap_interactions', 'visibility', "TEXT DEFAULT 'public'");
+  ensureColumn('ap_interactions', 'emoji_json', 'TEXT');        // FEP-9098 custom emojis in a reply's content (messages + thread)
+  ensureColumn('ap_interactions', 'actor_emoji_json', 'TEXT');  // FEP-9098 custom emojis in the reply author's display name
   // Rich replies: the reply's language (BCP47 code) → contentMap on the outgoing Note.
   ensureColumn('ap_outbox', 'language', 'TEXT');