| 1 | <?php |
| 2 | declare(strict_types=1); |
| 3 | |
| 4 | // Atom-feed per lezer. Een beheerder zet de feed aan; daarna maakt elke lezer |
| 5 | // een eigen geheime feed-sleutel. De feed toont dagen, nooit de wiki, en zet |
| 6 | // niets op gelezen. |
| 7 | |
| 8 | const FEED_SETTING = 'feed_enabled'; |
| 9 | const FEED_LIMIT = 60; |
| 10 | |
| 11 | function appSetting(string $name, string $default = ''): string { |
| 12 | $value = query('SELECT value FROM app_settings WHERE name=?', [$name])->fetchColumn(); |
| 13 | return is_string($value) ? $value : $default; |
| 14 | } |
| 15 | |
| 16 | function setAppSetting(string $name, string $value): void { |
| 17 | query('INSERT INTO app_settings (name, value, updated) VALUES (?,?,?) |
| 18 | ON CONFLICT(name) DO UPDATE SET value=excluded.value, updated=excluded.updated', [$name, $value, time()]); |
| 19 | } |
| 20 | |
| 21 | function feedEnabled(): bool { |
| 22 | return appSetting(FEED_SETTING, '0') === '1'; |
| 23 | } |
| 24 | |
| 25 | function setFeedEnabled(bool $enabled): array { |
| 26 | setAppSetting(FEED_SETTING, $enabled ? '1' : '0'); |
| 27 | return feedAdminState(); |
| 28 | } |
| 29 | |
| 30 | function feedAdminState(): array { |
| 31 | return [ |
| 32 | 'enabled' => feedEnabled(), |
| 33 | 'tokens' => (int)query('SELECT COUNT(*) FROM feed_tokens')->fetchColumn(), |
| 34 | ]; |
| 35 | } |
| 36 | |
| 37 | function feedUrl(string $token): string { |
| 38 | return baseUrl().'/feed.php?token='.rawurlencode($token); |
| 39 | } |
| 40 | |
| 41 | function feedTokenState(string $userId): array { |
| 42 | $row = query('SELECT * FROM feed_tokens WHERE user_id=?', [$userId])->fetch(); |
| 43 | if (!$row) return ['enabled' => true, 'token' => null]; |
| 44 | $token = null; |
| 45 | try { |
| 46 | $plain = openToken((string)$row['token_cipher']); |
| 47 | if (hash_equals($row['token_hash'], hash('sha256', $plain))) $token = $plain; |
| 48 | } catch (Throwable $e) { |
| 49 | $token = null; |
| 50 | } |
| 51 | return ['enabled' => true, 'token' => [ |
| 52 | 'prefix' => $row['token_prefix'], |
| 53 | 'created' => (int)$row['created'], |
| 54 | 'url' => $token !== null ? feedUrl($token) : null, |
| 55 | ]]; |
| 56 | } |
| 57 | |
| 58 | function createFeedToken(string $userId): array { |
| 59 | $token = 'vbf_'.bin2hex(random_bytes(32)); |
| 60 | transaction(function () use ($userId, $token): void { |
| 61 | query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]); |
| 62 | query('INSERT INTO feed_tokens (user_id, token_hash, token_prefix, token_cipher, created) VALUES (?,?,?,?,?)', [ |
| 63 | $userId, hash('sha256', $token), substr($token, 0, 12), sealToken($token), time(), |
| 64 | ]); |
| 65 | }); |
| 66 | return feedTokenState($userId); |
| 67 | } |
| 68 | |
| 69 | function revokeFeedToken(string $userId): array { |
| 70 | query('DELETE FROM feed_tokens WHERE user_id=?', [$userId]); |
| 71 | return feedTokenState($userId); |
| 72 | } |
| 73 | |
| 74 | function feedUserForToken(mixed $token): ?string { |
| 75 | if (!is_string($token) || !preg_match('/^vbf_[a-f0-9]{64}$/', $token)) return null; |
| 76 | $userId = query('SELECT user_id FROM feed_tokens WHERE token_hash=?', [hash('sha256', $token)])->fetchColumn(); |
| 77 | return is_string($userId) ? $userId : null; |
| 78 | } |
| 79 | |
| 80 | function feedToday(): string { |
| 81 | return (new DateTimeImmutable('now', new DateTimeZone('Europe/Amsterdam')))->format('Y-m-d'); |
| 82 | } |
| 83 | |
| 84 | /** Dagen tot en met vandaag, nieuwste eerst, met hun verhalen. Leest alleen. */ |
| 85 | function feedDays(?string $today = null, int $limit = FEED_LIMIT): array { |
| 86 | $today = validDate($today ?? feedToday()); |
| 87 | $days = query('SELECT id, date, title, created, updated FROM days WHERE date<=? ORDER BY date DESC LIMIT '.max(1, $limit), [$today])->fetchAll(); |
| 88 | $out = []; |
| 89 | foreach ($days as $day) { |
| 90 | $stories = []; |
| 91 | foreach (query('SELECT id, position, title, updated FROM stories WHERE day_id=? ORDER BY position, id', [$day['id']])->fetchAll() as $story) { |
| 92 | $stories[] = [ |
| 93 | 'title' => $story['title'], |
| 94 | 'paragraphs' => array_values(query('SELECT body FROM paragraphs WHERE story_id=? ORDER BY position, id', [$story['id']])->fetchAll(PDO::FETCH_COLUMN)), |
| 95 | 'updated' => (int)$story['updated'], |
| 96 | ]; |
| 97 | } |
| 98 | if ($stories === []) continue; |
| 99 | $updated = max([(int)$day['updated'], ...array_column($stories, 'updated')]); |
| 100 | $out[] = ['date' => $day['date'], 'title' => $day['title'], 'updated' => $updated, 'stories' => $stories]; |
| 101 | } |
| 102 | return $out; |
| 103 | } |
| 104 | |
| 105 | function feedEsc(string $value): string { |
| 106 | return htmlspecialchars($value, ENT_QUOTES | ENT_XML1 | ENT_SUBSTITUTE, 'UTF-8'); |
| 107 | } |
| 108 | |
| 109 | function feedDayHtml(array $day): string { |
| 110 | $html = ''; |
| 111 | foreach ($day['stories'] as $story) { |
| 112 | $html .= '<h2>'.htmlspecialchars($story['title'], ENT_QUOTES | ENT_HTML5, 'UTF-8').'</h2>'; |
| 113 | foreach ($story['paragraphs'] as $paragraph) { |
| 114 | $html .= '<p>'.nl2br(htmlspecialchars((string)$paragraph, ENT_QUOTES | ENT_HTML5, 'UTF-8'), false).'</p>'; |
| 115 | } |
| 116 | } |
| 117 | return $html; |
| 118 | } |
| 119 | |
| 120 | function feedDayLabel(string $date): string { |
| 121 | $months = ['januari', 'februari', 'maart', 'april', 'mei', 'juni', 'juli', 'augustus', 'september', 'oktober', 'november', 'december']; |
| 122 | $d = new DateTimeImmutable($date.' 00:00:00', new DateTimeZone('UTC')); |
| 123 | return (int)$d->format('j').' '.$months[(int)$d->format('n') - 1].' '.$d->format('Y'); |
| 124 | } |
| 125 | |
| 126 | function feedXml(string $selfUrl, array $days): string { |
| 127 | $base = baseUrl(); |
| 128 | $host = parse_url($base, PHP_URL_HOST) ?: 'localhost'; |
| 129 | $updated = $days !== [] ? max(array_column($days, 'updated')) : time(); |
| 130 | $xml = '<?xml version="1.0" encoding="utf-8"?>'."\n"; |
| 131 | $xml .= '<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="nl">'."\n"; |
| 132 | $xml .= ' <title>Verhalenboek</title>'."\n"; |
| 133 | $xml .= ' <subtitle>Elke dag drie verhalen.</subtitle>'."\n"; |
| 134 | $xml .= ' <id>tag:'.feedEsc($host).',2026:verhaaltjesboek</id>'."\n"; |
| 135 | $xml .= ' <link rel="alternate" type="text/html" href="'.feedEsc($base.'/').'"/>'."\n"; |
| 136 | $xml .= ' <link rel="self" type="application/atom+xml" href="'.feedEsc($selfUrl).'"/>'."\n"; |
| 137 | $xml .= ' <icon>'.feedEsc($base.'/assets/icon-192.png').'</icon>'."\n"; |
| 138 | $xml .= ' <updated>'.gmdate('Y-m-d\TH:i:s\Z', $updated).'</updated>'."\n"; |
| 139 | $xml .= ' <author><name>Verhalenboek</name></author>'."\n"; |
| 140 | foreach ($days as $day) { |
| 141 | $titles = implode(' · ', array_column($day['stories'], 'title')); |
| 142 | $xml .= ' <entry>'."\n"; |
| 143 | $xml .= ' <id>tag:'.feedEsc($host).',2026:verhaaltjesboek/dag/'.feedEsc($day['date']).'</id>'."\n"; |
| 144 | $xml .= ' <title>'.feedEsc(feedDayLabel($day['date']).': '.$day['title']).'</title>'."\n"; |
| 145 | $xml .= ' <link rel="alternate" type="text/html" href="'.feedEsc($base.'/#/dag/'.$day['date']).'"/>'."\n"; |
| 146 | $xml .= ' <published>'.feedEsc($day['date']).'T00:00:00+00:00</published>'."\n"; |
| 147 | $xml .= ' <updated>'.gmdate('Y-m-d\TH:i:s\Z', $day['updated']).'</updated>'."\n"; |
| 148 | $xml .= ' <summary>'.feedEsc($titles).'</summary>'."\n"; |
| 149 | $xml .= ' <content type="html">'.feedEsc(feedDayHtml($day)).'</content>'."\n"; |
| 150 | $xml .= ' </entry>'."\n"; |
| 151 | } |
| 152 | return $xml.'</feed>'."\n"; |
| 153 | } |
projects-timfalken-com verhalenboek