summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--lib/VNDB/Handler/VNPage.pm3
-rw-r--r--util/sql/func.sql2
2 files changed, 3 insertions, 2 deletions
diff --git a/lib/VNDB/Handler/VNPage.pm b/lib/VNDB/Handler/VNPage.pm
index 82aa9175..565d73ce 100644
--- a/lib/VNDB/Handler/VNPage.pm
+++ b/lib/VNDB/Handler/VNPage.pm
@@ -464,7 +464,8 @@ sub page {
end;
div id => 'vntags';
for (@$t) {
- span class => sprintf 'tagspl%.0f cat_%s %s', $_->{spoiler}, $_->{cat}, $_->{spoiler} > 0 ? 'hidden' : '';
+ my $spoil = $_->{spoiler} > 1.3 ? 2 : $_->{spoiler} > 0.4 ? 1 : 0;
+ span class => sprintf 'tagspl%d cat_%s %s', $spoil, $_->{cat}, $spoil > 0 ? 'hidden' : '';
a href => "/g$_->{id}", style => sprintf('font-size: %dpx', $_->{rating}*3.5+6), $_->{name};
b class => 'grayedout', sprintf ' %.1f', $_->{rating};
end;
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)