fetchColumn(); return is_string($value) ? $value : $default; } function setAppSetting(string $name, string $value): void { query('INSERT INTO app_settings (name, value, updated) VALUES (?,?,?) ON CONFLICT(name) DO UPDATE SET value=excluded.value, updated=excluded.updated', [$name, $value, time()]); } function feedEnabled(): bool { return appSetting(FEED_SETTING, '0') === '1'; } function setFeedEnabled(bool $enabled): array { setAppSetting(FEED_SETTING, $enabled ? '1' : '0'); return feedAdminState(); } function feedAdminState(): array { return [ 'enabled' => feedEnabled(), 'tokens' => (int)query('SELECT COUNT(*) FROM feed_tokens')->fetchColumn(), ]; } function feedUrl(string $token): string { return baseUrl().'/feed.php?token='.rawurlencode($token); } function feedTokenState(string $userId): array { $row = query('SELECT * FROM feed_tokens WHERE user_id=?', [$userId])->fetch(); if (!$row) return ['enabled' => true, 'token' => null]; $token = null; try { $plain = openToken((string)$row['token_cipher']); if (hash_equals($row['token_hash'], hash('sha256', $plain))) $token = $plain; } catch (Throwable $e) { $token = null; } return ['enabled' => true, 'token' => [ 'prefix' => $row['token_prefix'], 'created' => (int)$row['created'], 'url' => $token !== null ? feedUrl($token) : null, ]]; } function createFeedToken(string $userId): array { $token = 'vbf_'.bin2hex(random_bytes(32)); transaction(function () use ($userId, $token): void { query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]); query('INSERT INTO feed_tokens (user_id, token_hash, token_prefix, token_cipher, created) VALUES (?,?,?,?,?)', [ $userId, hash('sha256', $token), substr($token, 0, 12), sealToken($token), time(), ]); }); return feedTokenState($userId); } function revokeFeedToken(string $userId): array { query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]); return feedTokenState($userId); } function feedUserForToken(mixed $token): ?string { if (!is_string($token) || !preg_match('/^vbf_[a-f0-9]{64}$/', $token)) return null; $userId = query('SELECT user_id FROM feed_tokens WHERE token_hash=?', [hash('sha256', $token)])->fetchColumn(); return is_string($userId) ? $userId : null; } function feedToday(): string { return (new DateTimeImmutable('now', new DateTimeZone('Europe/Amsterdam')))->format('Y-m-d'); } /** Dagen tot en met vandaag, nieuwste eerst, met hun verhalen. Leest alleen. */ function feedDays(?string $today = null, int $limit = FEED_LIMIT): array { $today = validDate($today ?? feedToday()); $days = query('SELECT id, date, title, created, updated FROM days WHERE date<=? ORDER BY date DESC LIMIT '.max(1, $limit), [$today])->fetchAll(); $out = []; foreach ($days as $day) { $stories = []; foreach (query('SELECT id, position, title, updated FROM stories WHERE day_id=? ORDER BY position, id', [$day['id']])->fetchAll() as $story) { $stories[] = [ 'title' => $story['title'], 'paragraphs' => array_values(query('SELECT body FROM paragraphs WHERE story_id=? ORDER BY position, id', [$story['id']])->fetchAll(PDO::FETCH_COLUMN)), 'updated' => (int)$story['updated'], ]; } if ($stories === []) continue; $updated = max([(int)$day['updated'], ...array_column($stories, 'updated')]); $out[] = ['date' => $day['date'], 'title' => $day['title'], 'updated' => $updated, 'stories' => $stories]; } return $out; } function feedEsc(string $value): string { return htmlspecialchars($value, ENT_QUOTES | ENT_XML1 | ENT_SUBSTITUTE, 'UTF-8'); } function feedDayHtml(array $day): string { $html = ''; foreach ($day['stories'] as $story) { $html .= '
'.nl2br(htmlspecialchars((string)$paragraph, ENT_QUOTES | ENT_HTML5, 'UTF-8'), false).'
'; } } return $html; } function feedDayLabel(string $date): string { $months = ['januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december']; $d = new DateTimeImmutable($date.' 00:00:00', new DateTimeZone('UTC')); return (int)$d->format('j').' '.$months[(int)$d->format('n') - 1].' '.$d->format('Y'); } function feedXml(string $selfUrl, array $days): string { $base = baseUrl(); $host = parse_url($base, PHP_URL_HOST) ?: 'localhost'; $updated = $days !== [] ? max(array_column($days, 'updated')) : time(); $xml = ''."\n"; $xml .= '