diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/func.sql | 2 |
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) |