diff options
Diffstat (limited to 'Digitigrade/Timeline')
| -rw-r--r-- | Digitigrade/Timeline/GlobalTimeline.php | 2 | ||||
| -rw-r--r-- | Digitigrade/Timeline/LocalTimeline.php | 2 |
2 files changed, 2 insertions, 2 deletions
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]); |