summaryrefslogtreecommitdiff
path: root/util/sql/func.sql
diff options
context:
space:
mode:
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)