Index: src/config/database.js
===================================================================
--- src/config/database.js (revision 91094a44a78eaba7694534a039a5d0843f451e10)
+++ src/config/database.js (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -219,4 +219,16 @@
);
`);
+
+ // 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)
+ );
+ `);
}
Index: src/routes/admin-stats.js
===================================================================
--- src/routes/admin-stats.js (revision 91094a44a78eaba7694534a039a5d0843f451e10)
+++ src/routes/admin-stats.js (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -10,4 +10,5 @@
import express from 'express';
+import db from '../config/database.js';
import { renderPage } from '../middleware/render.js';
import { requireGod } from '../middleware/auth.js';
@@ -21,8 +22,18 @@
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,
});
});
Index: src/routes/linkbio.js
===================================================================
--- src/routes/linkbio.js (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
+++ src/routes/linkbio.js (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -0,0 +1,61 @@
+/**
+ * Link-in-bio + klikstats (premium feature #6).
+ *
+ * GET /links -> Linktree-achtige pagina met de profile_links van de site
+ * GET /links/go/:i -> telt de klik (per url) en stuurt door naar de externe URL
+ *
+ * Hergebruikt de bestaande sites.profile_links (JSON [{platform,url}]) + de
+ * PLATFORMS-iconen/labels. Klikken landen in link_clicks (zie /admin/stats).
+ * Open-redirect-veilig: /links/go/:i stuurt ALLEEN door naar een url die in de
+ * eigen profile_links staat. Hub: via /user/:slug/links.
+ */
+
+import express from 'express';
+import db from '../config/database.js';
+import { renderPage } from '../middleware/render.js';
+import { premiumUnlocked } from '../services/PatreonService.js';
+import { PLATFORMS } from '../services/PlatformIcons.js';
+
+const router = express.Router();
+
+function parseLinks(site) {
+ if (!site || !site.profile_links) return [];
+ try { return JSON.parse(site.profile_links) || []; } catch { return []; }
+}
+
+router.get('/links', (req, res, next) => {
+ if (!premiumUnlocked()) return next();
+ const site = res.locals.site;
+ if (!site) return next();
+ const links = parseLinks(site).map((l, i) => {
+ const meta = PLATFORMS[l.platform] || {};
+ return { i, url: l.url, platform: l.platform, label: meta.label || l.platform, svg: meta.svg || '', brand: meta.brand || '' };
+ });
+ renderPage(req, res, 'pages/linkbio', {
+ pageTitle: (site.title || '') + ' — links',
+ bodyClass: 'on-linkbio',
+ lbLinks: links,
+ });
+});
+
+router.get('/links/go/:i', (req, res, next) => {
+ if (!premiumUnlocked()) return next();
+ const site = res.locals.site;
+ if (!site) return next();
+ const links = parseLinks(site);
+ const idx = parseInt(req.params.i, 10);
+ const link = (Number.isInteger(idx) && idx >= 0) ? links[idx] : null;
+ if (!link || !link.url) return next();
+ const url = String(link.url);
+ // Alleen externe http(s)- of mailto-links (geen open redirect / javascript:).
+ if (!/^https?:\/\//i.test(url) && !/^mailto:/i.test(url)) return res.status(400).send('Bad link');
+ try {
+ db.prepare(
+ `INSERT INTO link_clicks (site_id, url, clicks, updated_at) VALUES (?, ?, 1, CURRENT_TIMESTAMP)
+ ON CONFLICT(site_id, url) DO UPDATE SET clicks = clicks + 1, updated_at = CURRENT_TIMESTAMP`
+ ).run(site.id, url);
+ } catch { /* telling mag de redirect nooit breken */ }
+ res.redirect(302, url);
+});
+
+export default router;
Index: src/server.js
===================================================================
--- src/server.js (revision 91094a44a78eaba7694534a039a5d0843f451e10)
+++ src/server.js (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -56,4 +56,5 @@
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,4 +274,5 @@
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);
Index: src/views/pages/admin-stats.ejs
===================================================================
--- src/views/pages/admin-stats.ejs (revision 91094a44a78eaba7694534a039a5d0843f451e10)
+++ src/views/pages/admin-stats.ejs (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -65,4 +65,15 @@
+
+ <% if (typeof linkClicks !== 'undefined' && linkClicks.length) { %>
+
+ <% } %>
Index: src/views/pages/admin.ejs
===================================================================
--- src/views/pages/admin.ejs (revision 91094a44a78eaba7694534a039a5d0843f451e10)
+++ src/views/pages/admin.ejs (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -36,4 +36,5 @@
<% if (tenancy !== 'hub' && primarySite) { %>📰 Perskit<% } %>
<% if (tenancy !== 'hub' && primarySite) { %>⬇ Downloads<% } %>
+ <% if (tenancy !== 'hub' && primarySite) { %>🔗 Link-in-bio<% } %>
<% } %>
🔄 Updates
Index: src/views/pages/linkbio.ejs
===================================================================
--- src/views/pages/linkbio.ejs (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
+++ src/views/pages/linkbio.ejs (revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -0,0 +1,44 @@
+<%
+ var links = (typeof lbLinks !== 'undefined') ? lbLinks : [];
+ var _photo = (site && site.profile_photo) ? site.profile_photo : (typeof siteOwnerAvatar !== 'undefined' ? siteOwnerAvatar : '');
+ var _name = (site && (site.profile_name || site.title)) || '';
+ var _bio = (site && (site.profile_bio || site.tagline)) || '';
+%>
+
+
+ <% if (_photo) { %>
<% } else { %>
♪<% } %>
+
<%= _name %>
+ <% if (_bio) { %>
<%= _bio %>
<% } %>
+
Nog geen links ingesteld.
+ <% } else { %>
+
+ <% } %>
+
+
+
+
+