From 05bc4dfa069be5273765a68652598d72dbf482fb Mon Sep 17 00:00:00 2001
From: Chocobozzz <me@florianbigard.com>
Date: Thu, 11 Jan 2018 18:35:39 +0100
Subject: Add maximum to actor follow scores
---
server/models/activitypub/actor-follow.ts | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
(limited to 'server/models/activitypub')
diff --git a/server/models/activitypub/actor-follow.ts b/server/models/activitypub/actor-follow.ts
index 78a65a0ff..920c83d88 100644
--- a/server/models/activitypub/actor-follow.ts
+++ b/server/models/activitypub/actor-follow.ts
@@ -307,7 +307,7 @@ export class ActorFollowModel extends Model<ActorFollowModel> {
private static incrementScores (inboxUrls: string[], value: number, t: Sequelize.Transaction) {
const inboxUrlsString = inboxUrls.map(url => `'${url}'`).join(',')
- const query = 'UPDATE "actorFollow" SET "score" = "score" +' + value + ' ' +
+ const query = `UPDATE "actorFollow" SET "score" = LEAST("score" + ${value}, ${ACTOR_FOLLOW_SCORE.MAX}) ` +
'WHERE id IN (' +
'SELECT "actorFollow"."id" FROM "actorFollow" ' +
'INNER JOIN "actor" ON "actor"."id" = "actorFollow"."actorId" ' +
--
cgit v1.2.3