From d5a57276eb27e215dd0b1bd5eb67ac26acc9575b Mon Sep 17 00:00:00 2001
From: winter
Date: Tue, 24 Dec 2024 15:32:56 +0000
Subject: more stuff and things

---
 Digitigrade/Timeline/GlobalTimeline.php | 2 +-
 Digitigrade/Timeline/LocalTimeline.php  | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'Digitigrade/Timeline')

diff --git a/Digitigrade/Timeline/GlobalTimeline.php b/Digitigrade/Timeline/GlobalTimeline.php
index b495174..2236ee4 100644
--- a/Digitigrade/Timeline/GlobalTimeline.php
+++ b/Digitigrade/Timeline/GlobalTimeline.php
@@ -9,7 +9,7 @@ class GlobalTimeline extends Timeline {
         $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
+        WHERE note_privacy.scope = 'public' AND note_privacy.indexable = true AND note.deleted = false
         ORDER BY note.created DESC LIMIT ? OFFSET ?
         END);
         $stmt->execute([$limit, $offset]);
diff --git a/Digitigrade/Timeline/LocalTimeline.php b/Digitigrade/Timeline/LocalTimeline.php
index e4594af..69b8634 100644
--- a/Digitigrade/Timeline/LocalTimeline.php
+++ b/Digitigrade/Timeline/LocalTimeline.php
@@ -11,7 +11,7 @@ class LocalTimeline extends Timeline {
         SELECT note.id FROM note
         LEFT JOIN note_privacy ON note_privacy.note_id = note.id
         LEFT JOIN actor ON note.author = actor.id
-        WHERE note_privacy.scope = 'public' AND note_privacy.indexable = true AND actor.is_local = true
+        WHERE note_privacy.scope = 'public' AND note_privacy.indexable = true AND actor.is_local = true AND note.deleted = false
         ORDER BY note.created DESC LIMIT ? OFFSET ?
         END);
         $stmt->execute([$limit, $offset]);
-- 
cgit v1.3