diff options
| author | Yorhel <git@yorhel.nl> | 2021-08-06 16:34:52 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2021-08-06 16:34:52 +0200 |
| commit | 8039b1cebe3abb30f17ddb3f44ab3323cef08afd (patch) | |
| tree | b19af302bab0a33af6279ecd7eac6d30dee4c9a5 | |
| parent | 04cd6b33965bc8e696ba56febfd9c9a7877fb5eb (diff) | |
Oops, speed adjustment goes the other way around
| -rw-r--r-- | lib/VNWeb/VN/Page.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/VN/Page.pm b/lib/VNWeb/VN/Page.pm index e412d89f..ccc986f0 100644 --- a/lib/VNWeb/VN/Page.pm +++ b/lib/VNWeb/VN/Page.pm @@ -161,7 +161,7 @@ sub infobox_length_ { my $stats = tuwf->dbRowi(' SELECT count(*) as count - , percentile_cont(0.5) WITHIN GROUP (ORDER BY l.length + (l.length/2 * (1-l.speed))) AS median + , percentile_cont(0.5) WITHIN GROUP (ORDER BY l.length + (l.length/2 * (l.speed-1))) AS median FROM vn_length_votes l LEFT JOIN users u ON u.id = l.uid WHERE u.perm_lengthvote IS DISTINCT FROM false AND l.vid =', \$v->{id}); |