summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-09-03 20:57:05 +0200
committerYorhel <git@yorhel.nl>2020-09-03 20:57:06 +0200
commit818f2aa2cf67526d5d1bd2b34ebf77ce342dc8c4 (patch)
tree4d145ab38bdd0241ea4130b006977ac1e175e428
parentc2f3b3a746abdc4224b30d88c85309b8a62a3c0f (diff)
reviews: Adjust review flagging threshold
So it takes at least 1000 downvotes for a review to get flagged. Turns out auto-moderating using votes isn't going to work out so well, considering okay-ish-but-not-super-awesome reviews are getting downvoted into oblivion at the moment. Votes still ought to work fine for ranking, though.
-rw-r--r--sql/func.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/func.sql b/sql/func.sql
index 59623f3b..f3bb9add 100644
--- a/sql/func.sql
+++ b/sql/func.sql
@@ -190,7 +190,7 @@ BEGIN
, COALESCE(
SUM((CASE WHEN rv.vote THEN 1 ELSE -1 END)*(CASE WHEN rv.overrule THEN 10000 ELSE 1 END))
FILTER(WHERE NOT u.ign_votes AND (r2.id IS NULL OR rv.overrule)),
- 0) < -10
+ 0) < -1000
FROM reviews r
LEFT JOIN reviews_votes rv ON rv.id = r.id
LEFT JOIN users u ON u.id = rv.uid