From d9986b7a2fabffff50068f4114a16d315941591f Mon Sep 17 00:00:00 2001 From: syuilo Date: Tue, 18 Feb 2020 19:05:11 +0900 Subject: Implement featured note injection --- src/server/api/endpoints/notes/featured.ts | 1 + 1 file changed, 1 insertion(+) (limited to 'src/server/api/endpoints/notes/featured.ts') 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'); -- cgit v1.2.3-freya