From 291e7e79438bedd654353726bea8a3706243205b Mon Sep 17 00:00:00 2001 From: rinsuki <428rinsuki+git@gmail.com> Date: Fri, 26 Apr 2019 00:52:58 +0900 Subject: おすすめユーザーに自分自身を含まないように (#4803) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Fix #4790 --- src/server/api/endpoints/users/recommendation.ts | 1 + 1 file changed, 1 insertion(+) (limited to 'src/server/api/endpoints/users') diff --git a/src/server/api/endpoints/users/recommendation.ts b/src/server/api/endpoints/users/recommendation.ts index 67b646a35f..5b74d442cb 100644 --- a/src/server/api/endpoints/users/recommendation.ts +++ b/src/server/api/endpoints/users/recommendation.ts @@ -44,6 +44,7 @@ export default define(meta, async (ps, me) => { .where('user.isLocked = FALSE') .where('user.host IS NULL') .where('user.updatedAt >= :date', { date: new Date(Date.now() - ms('7days')) }) + .where('user.id != :meId', { meId: me.id }) .orderBy('user.followersCount', 'DESC'); generateMuteQueryForUsers(query, me); -- cgit v1.2.3-freya From 2b8187f7abcf914248040c2ebe351d15d38fb031 Mon Sep 17 00:00:00 2001 From: syuilo Date: Fri, 26 Apr 2019 00:54:11 +0900 Subject: Fix bug --- src/server/api/endpoints/users/recommendation.ts | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/server/api/endpoints/users') diff --git a/src/server/api/endpoints/users/recommendation.ts b/src/server/api/endpoints/users/recommendation.ts index 5b74d442cb..38b420c332 100644 --- a/src/server/api/endpoints/users/recommendation.ts +++ b/src/server/api/endpoints/users/recommendation.ts @@ -42,9 +42,9 @@ export const meta = { export default define(meta, async (ps, me) => { const query = Users.createQueryBuilder('user') .where('user.isLocked = FALSE') - .where('user.host IS NULL') - .where('user.updatedAt >= :date', { date: new Date(Date.now() - ms('7days')) }) - .where('user.id != :meId', { meId: me.id }) + .andWhere('user.host IS NULL') + .andWhere('user.updatedAt >= :date', { date: new Date(Date.now() - ms('7days')) }) + .andWhere('user.id != :meId', { meId: me.id }) .orderBy('user.followersCount', 'DESC'); generateMuteQueryForUsers(query, me); -- cgit v1.2.3-freya