summaryrefslogtreecommitdiff
path: root/util/sql/func.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2018-10-01 19:21:34 +0200
committerYorhel <git@yorhel.nl>2018-10-01 19:21:36 +0200
commit815f9b1496c75026c9e3ea57bac2f5d5348085ba (patch)
tree8e2453aec78c5e73f747afd5da1814adf96de6c6 /util/sql/func.sql
parent4e3081f530526601d82fbe792ea4c0f9bc9a9c9a (diff)
Lower the average vote requirement for tag spoilers a bit
https://vndb.org/t950.512
Diffstat (limited to 'util/sql/func.sql')
-rw-r--r--util/sql/func.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql
index 4d52d1bf..d34049d0 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -151,7 +151,7 @@ BEGIN
SELECT tag, vid, COUNT(uid) AS users, AVG(vote)::real AS rating,
(CASE WHEN COUNT(spoiler) = 0 THEN defaultspoil
WHEN AVG(spoiler) > 1.3 THEN 2
- WHEN AVG(spoiler) > 0.7 THEN 1 ELSE 0
+ WHEN AVG(spoiler) > 0.4 THEN 1 ELSE 0
END)::smallint AS spoiler
FROM (
-- grouped by (tag, vid, uid), so only one user votes on one parent tag per VN entry (also removing meta tags)