Changeset 37edecd in Klonkt for src/routes

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/routes

Files:

• admin-stats.js (modified) (2 diffs)
• linkbio.js (added)

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,
   });
 });