Changeset abdcf33 in Klonkt for src/services

Timestamp:

06/27/2026 09:46:03 PM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

d2b7247

Parents:

3746f6a

Message:

chore(cleanup): remove the dead comments_moderation_mode column + handling

Native comments are gone; this column was set but never read. Removed from the site
INSERT (admin-sites create) and UPDATE (save) in lockstep (column + placeholder + value),
from ensurePrimarySite's seed INSERT, the ensureColumn in database.js, and the 3 unused
i18n keys (asite.comment_moderation / moderation_trust / moderation_moderate, x3 langs).
No DROP — the column stays in existing DBs as harmless dead data. require_login_to_comment
is kept (still used by PermissionsService).

Location:

src/services

Files:

• ensurePrimarySite.js (modified) (1 diff)
• i18n.js (modified) (3 diffs)

src/services/ensurePrimarySite.js

@@ -40 +40 @@
       language, palette, accent, profile_photo,
       is_public, robots_index, require_login_to_comment, enable_audio_player,
-      feed_view_default, comments_moderation_mode, is_primary
-    ) VALUES (?, ?, ?, '', '', ?, 'en', 'klonkt', '#e8b04b', NULL, 1, 1, 1, 1, 'grid', 'moderate', 1)
+      feed_view_default, is_primary
+    ) VALUES (?, ?, ?, '', '', ?, 'en', 'klonkt', '#e8b04b', NULL, 1, 1, 1, 1, 'grid', 1)
   `).run(siteId, slug, defaultTitle(), owner.id);
 

src/services/i18n.js

@@ -238 +238 @@
     'asite.robots_index': 'Zoekmachines mogen indexeren (sitemap.xml is verborgen indien uit)',
     'asite.require_login_comment': 'Inloggen vereist om te reageren',
-    'asite.comment_moderation': 'Reactie-moderatie',
-    'asite.moderation_trust': 'Vertrouwen (automatisch goedkeuren)',
-    'asite.moderation_moderate': 'Modereren (eerst in de wachtrij)',
     'asite.enable_audio': 'Audiospeler + embeds inschakelen',
     'asite.links': 'Social / streaming-links',
@@ -1152 +1149 @@
     'asite.robots_index': 'Allow search engines to index (sitemap.xml is hidden when off)',
     'asite.require_login_comment': 'Login required to comment',
-    'asite.comment_moderation': 'Comment moderation',
-    'asite.moderation_trust': 'Trust (approve automatically)',
-    'asite.moderation_moderate': 'Moderate (queue first)',
     'asite.enable_audio': 'Enable audio player + embeds',
     'asite.links': 'Social / streaming links',
@@ -2065 +2059 @@
     'asite.robots_index': 'Suchmaschinen dürfen indexieren (sitemap.xml ist ausgeblendet, wenn aus)',
     'asite.require_login_comment': 'Anmeldung zum Kommentieren erforderlich',
-    'asite.comment_moderation': 'Kommentar-Moderation',
-    'asite.moderation_trust': 'Vertrauen (automatisch freigeben)',
-    'asite.moderation_moderate': 'Moderieren (zuerst in die Warteschlange)',
     'asite.enable_audio': 'Audioplayer + Embeds aktivieren',
     'asite.links': 'Social- / Streaming-Links',