Changeset 37edecd in Klonkt for src

Timestamp:

06/19/2026 03:46:42 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

1794fac

Parents:

91094a4

Message:

Link-in-bio + click stats (premium feature #6)

Linktree-style page from the existing sites.profile_links (JSON [{platform,url}])
+ PLATFORMS icons. Clicks counted per url.

• DB: link_clicks (site_id, url, clicks), PK (site_id,url).
• routes/linkbio.js (premium-gated): GET /links (page with profile_links as buttons), GET /links/go/:i (counts click per url + 302 redirect). Open-redirect safe: only redirects to a url in the site's own profile_links; http(s)/mailto only.
• view pages/linkbio.ejs (photo/name/bio + brand-coloured buttons with SVG icons).
• admin-stats: link-clicks section (top 50, per url) for the current site.
• admin dashboard: 🔗 Link-in-bio link (premium, non-hub).

node --check passed.

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

Location:

src

Files:

• config/database.js (modified) (1 diff)
• routes/admin-stats.js (modified) (2 diffs)
• routes/linkbio.js (added)
• server.js (modified) (2 diffs)
• views/pages/admin-stats.ejs (modified) (1 diff)
• views/pages/admin.ejs (modified) (1 diff)
• views/pages/linkbio.ejs (added)

src/config/database.js

@@ -219 +219 @@
     );
   `);
+
+  // Link-in-bio klikstatistiek (premium #6). Per (site, url) een teller; de
+  // link-in-bio-pagina linkt via /links/go/:i dat de klik telt en doorstuurt.
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS link_clicks (
+      site_id TEXT NOT NULL,
+      url TEXT NOT NULL,
+      clicks INTEGER DEFAULT 0,
+      updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      PRIMARY KEY (site_id, url)
+    );
+  `);
 }
 

src/routes/admin-stats.js

@@ -10 +10 @@
 
 import express from 'express';
+import db from '../config/database.js';
 import { renderPage } from '../middleware/render.js';
 import { requireGod } from '../middleware/auth.js';
@@ -21 +22 @@
     return res.status(403).send('Statistieken is een premium-functie — koppel Patreon in Beheer → Instellingen.');
   }
+  // Link-in-bio klikken (premium #6) voor de huidige site.
+  let linkClicks = [];
+  if (res.locals.site) {
+    try {
+      linkClicks = db.prepare(
+        'SELECT url, clicks FROM link_clicks WHERE site_id = ? AND clicks > 0 ORDER BY clicks DESC LIMIT 50'
+      ).all(res.locals.site.id);
+    } catch { linkClicks = []; }
+  }
   renderPage(req, res, 'pages/admin-stats', {
     pageTitle: 'Statistieken',
     bodyClass: 'on-admin',
     stats: getStats(14),
+    linkClicks,
   });
 });

src/server.js

@@ -56 +56 @@
 import adminNewsletterRoutes from './routes/admin-newsletter.js';
 import downloadRoutes from './routes/download.js';
+import linkbioRoutes from './routes/linkbio.js';
 
 if (!process.env.SESSION_SECRET) {
@@ -273 +274 @@
 app.use('/', newsletterRoutes); // /nieuwsbrief in/uitschrijven (premium; niet-premium: next())
 app.use('/', downloadRoutes); // /downloads + /download/:id download-voor-email (premium)
+app.use('/', linkbioRoutes); // /links link-in-bio + klikstats (premium)
 app.use('/', postsRoutes);
 

src/views/pages/admin-stats.ejs

@@ -65 +65 @@
     </section>
   </div>
+
+  <% if (typeof linkClicks !== 'undefined' && linkClicks.length) { %>
+    <section class="stats-top" style="margin-top:1.2rem">
+      <h2>🔗 Link-in-bio klikken</h2>
+      <ol>
+        <% linkClicks.forEach(function(l){ %>
+          <li><a href="<%= l.url %>" target="_blank" rel="noopener"><%= l.url.replace(/^https?:\/\//,'').slice(0,48) %></a><span class="stats-count"><%= l.clicks %></span></li>
+        <% }); %>
+      </ol>
+    </section>
+  <% } %>
 </div>
 

src/views/pages/admin.ejs

@@ -36 +36 @@
       <% if (tenancy !== 'hub' && primarySite) { %><a href="/pers" class="btn" target="_blank">📰 Perskit</a><% } %>
       <% if (tenancy !== 'hub' && primarySite) { %><a href="/downloads" class="btn" target="_blank">⬇ Downloads</a><% } %>
+      <% if (tenancy !== 'hub' && primarySite) { %><a href="/links" class="btn" target="_blank">🔗 Link-in-bio</a><% } %>
     <% } %>
     <a href="/admin/updates" class="btn">🔄 Updates</a>