summaryrefslogtreecommitdiff
path: root/src/server/api/endpoints/notes/featured.ts
diff options
context:
space:
mode:
authorsyuilo <Syuilotan@yahoo.co.jp>2020-02-18 19:05:11 +0900
committersyuilo <Syuilotan@yahoo.co.jp>2020-02-18 19:05:11 +0900
commitd9986b7a2fabffff50068f4114a16d315941591f (patch)
tree7627c97a74a4e175cf8e0357cd380d21ac15b898 /src/server/api/endpoints/notes/featured.ts
parentImprove paging (diff)
downloadsharkey-d9986b7a2fabffff50068f4114a16d315941591f.tar.gz
sharkey-d9986b7a2fabffff50068f4114a16d315941591f.tar.bz2
sharkey-d9986b7a2fabffff50068f4114a16d315941591f.zip
Implement featured note injection
Diffstat (limited to 'src/server/api/endpoints/notes/featured.ts')
-rw-r--r--src/server/api/endpoints/notes/featured.ts1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/server/api/endpoints/notes/featured.ts b/src/server/api/endpoints/notes/featured.ts
index 5fc60eeccf..0dc705de7a 100644
--- a/src/server/api/endpoints/notes/featured.ts
+++ b/src/server/api/endpoints/notes/featured.ts
@@ -46,6 +46,7 @@ export default define(meta, async (ps, user) => {
const query = Notes.createQueryBuilder('note')
.addSelect('note.score')
.where('note.userHost IS NULL')
+ .andWhere(`note.score > 0`)
.andWhere(`note.createdAt > :date`, { date: new Date(Date.now() - day) })
.andWhere(`note.visibility = 'public'`)
.leftJoinAndSelect('note.user', 'user');