From 094b1d010253f1a9a114303d823739e513834742 Mon Sep 17 00:00:00 2001
From: winter
Date: Mon, 23 Dec 2024 16:48:58 +0000
Subject: better timeline system

---
 Digitigrade/Timeline/GlobalTimeline.php | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 Digitigrade/Timeline/GlobalTimeline.php

(limited to 'Digitigrade/Timeline')

diff --git a/Digitigrade/Timeline/GlobalTimeline.php b/Digitigrade/Timeline/GlobalTimeline.php
new file mode 100644
index 0000000..b495174
--- /dev/null
+++ b/Digitigrade/Timeline/GlobalTimeline.php
@@ -0,0 +1,18 @@
+<?php
+namespace Digitigrade\Timeline;
+
+use Digitigrade\Db;
+use Digitigrade\Timeline;
+
+class GlobalTimeline extends Timeline {
+    protected function getNoteIds(int $limit, int $offset): array {
+        $db = Db::getInstance()->getPdo();
+        $stmt = $db->prepare(<<<END
+        SELECT note.id FROM note LEFT JOIN note_privacy ON note_privacy.note_id = note.id
+        WHERE note_privacy.scope = 'public' AND note_privacy.indexable = true
+        ORDER BY note.created DESC LIMIT ? OFFSET ?
+        END);
+        $stmt->execute([$limit, $offset]);
+        return $stmt->fetchAll(\PDO::FETCH_COLUMN, 0);
+    }
+}
\ No newline at end of file
-- 
cgit v1.3