diff options
author | Yorhel <git@yorhel.nl> | 2018-10-01 19:21:34 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2018-10-01 19:21:36 +0200 |
commit | 815f9b1496c75026c9e3ea57bac2f5d5348085ba (patch) | |
tree | 8e2453aec78c5e73f747afd5da1814adf96de6c6 /util/sql/func.sql | |
parent | 4e3081f530526601d82fbe792ea4c0f9bc9a9c9a (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.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) |