summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-08-03 10:43:44 +0200
committerYorhel <git@yorhel.nl>2022-08-03 10:43:44 +0200
commit85b607067d0c0bf998aaa087c4ba77f26d739be1 (patch)
tree3cbe4d76c371ff39f3f1d9091a6b3b4f76738958 /sql
parent15fe576238ac08547d890567a8a2dd3fb71d5ace (diff)
Allow length votes on in-dev VNs + always display uncounted votes
Diffstat (limited to 'sql')
-rw-r--r--sql/func.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/func.sql b/sql/func.sql
index 23171e1a..c9559cff 100644
--- a/sql/func.sql
+++ b/sql/func.sql
@@ -135,8 +135,8 @@ $$ LANGUAGE SQL;
-- Updates vn.c_length and vn.c_lengthnum
CREATE OR REPLACE FUNCTION update_vn_length_cache(vndbid) RETURNS void AS $$
WITH s (vid, cnt, len) AS (
- SELECT v.id, count(l.vid) FILTER (WHERE u.id IS NOT NULL AND l.vid IS NOT NULL)
- , percentile_cont(0.5) WITHIN GROUP (ORDER BY l.length + (l.length/4 * (l.speed-1))) FILTER (WHERE u.id IS NOT NULL AND l.vid IS NOT NULL)
+ SELECT v.id, count(l.vid) FILTER (WHERE u.id IS NOT NULL AND l.vid IS NOT NULL AND v.devstatus <> 1)
+ , percentile_cont(0.5) WITHIN GROUP (ORDER BY l.length + (l.length/4 * (l.speed-1))) FILTER (WHERE u.id IS NOT NULL AND l.vid IS NOT NULL AND v.devstatus <> 1)
FROM vn v
LEFT JOIN vn_length_votes l ON l.vid = v.id AND l.speed IS NOT NULL AND NOT l.private
LEFT JOIN users u ON u.id = l.uid AND u.perm_lengthvote