Index: src/routes/admin.js
===================================================================
--- src/routes/admin.js	(revision 2165b6d3d57ceaa8b5d1f70491868482149470cf)
+++ src/routes/admin.js	(revision 7bc636b391c66ac399c33e54f7173a022c6a3cbd)
@@ -6,59 +6,11 @@
 
 import express from 'express';
-import db, { isoSql } from '../config/database.js';
+import db from '../config/database.js';
 import { renderPage } from '../middleware/render.js';
-import { requireAuth } from '../middleware/auth.js';
-import { apEnabled } from '../services/SettingsService.js';
-import { getPrimarySite } from '../middleware/site.js';
+import { requireGod } from '../middleware/auth.js';
 
 const router = express.Router();
 
-// Recent posts from one site, DRAFTS ON TOP, with mode-aware edit/view URLs.
-// Solves the problem that drafts (status != published) were not findable anywhere:
-// the timeline shows only published posts.
-function sitePosts(siteId, siteSlug, limit = 60) {
-  const base = '';
-  return db.prepare(`
-    SELECT slug, title, status, published_at, created_at, updated_at
-    FROM posts WHERE site_id = ?
-    ORDER BY (status != 'published') DESC, ${isoSql('COALESCE(updated_at, published_at, created_at)')} DESC
-    LIMIT ?
-  `).all(siteId, limit).map((p) => ({
-    ...p,
-    isDraft: p.status !== 'published',
-    editUrl: `${base}/posts/${p.slug}/edit`,
-    viewUrl: `${base}/${p.slug}`,
-  }));
-}
-
-router.get('/', requireAuth, (req, res) => {
-  const user = req.session.user;
-
-  // A kijker may view the full (god) admin panel read-only — same as god,
-  // but writing is globally blocked. A regular artist who owns a site gets
-  // a "My Klonkt Hub" dashboard, scoped to their own site. No site -> no admin.
-  if (user.role !== 'god' && user.role !== 'kijker') {
-    const mySite = db.prepare(
-      'SELECT * FROM sites WHERE owner_id = ? ORDER BY created_at ASC LIMIT 1'
-    ).get(user.id);
-    if (!mySite) return res.status(403).send('Geen beheer beschikbaar voor dit account.');
-
-    const mine = {
-      posts: db.prepare("SELECT COUNT(*) AS c FROM posts WHERE site_id = ?").get(mySite.id).c,
-      published: db.prepare("SELECT COUNT(*) AS c FROM posts WHERE site_id = ? AND status = 'published'").get(mySite.id).c,
-    };
-    return renderPage(req, res, 'pages/my-site', {
-      pageTitleKey: 'admin.t_hub',
-      bodyClass: 'on-admin',
-      mySite,
-      mine,
-      posts: sitePosts(mySite.id, mySite.slug),
-    });
-  }
-
-  // THE site: it provides the "Appearance" tile with its edit link and the
-  // posts/drafts list.
-  const primarySite = getPrimarySite();
-
+router.get('/', requireGod, (req, res) => {
   const stats = {
     users: db.prepare('SELECT COUNT(*) AS c FROM users').get().c,
@@ -70,24 +22,25 @@
   };
 
-  // Posts/drafts of the site. Drafts are listed first so they are easy to find.
-  const posts = primarySite ? sitePosts(primarySite.id, primarySite.slug) : [];
+  const sites = db.prepare(`
+    SELECT s.slug, s.title, s.created_at, u.username AS owner_username
+    FROM sites s
+    LEFT JOIN users u ON u.id = s.owner_id
+    ORDER BY s.created_at DESC
+    LIMIT 50
+  `).all();
+
+  const users = db.prepare(`
+    SELECT username, email, role, created_at
+    FROM users
+    ORDER BY created_at DESC
+    LIMIT 50
+  `).all();
 
   renderPage(req, res, 'pages/admin', {
-    pageTitleKey: 'admin.t_admin',
+    pageTitle: 'Admin',
     bodyClass: 'on-admin',
-    circlesOn: apEnabled(),   // federatie aan/uit in de tagline
-    primarySite,
     stats,
-    posts,
-  });
-});
-
-// Handleiding — searchable explanation of all admin features. Visible to anyone
-// who may view the admin panel (logged in); purely static help text, nothing sensitive.
-router.get('/handleiding', requireAuth, (req, res) => {
-  renderPage(req, res, 'pages/admin-help', {
-    pageJs: 'admin-help',
-    pageTitleKey: 'admin.t_manual',
-    bodyClass: 'on-admin',
+    sites,
+    users,
   });
 });