diff options
author | Yorhel <git@yorhel.nl> | 2022-08-03 10:43:44 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2022-08-03 10:43:44 +0200 |
commit | 85b607067d0c0bf998aaa087c4ba77f26d739be1 (patch) | |
tree | 3cbe4d76c371ff39f3f1d9091a6b3b4f76738958 /sql | |
parent | 15fe576238ac08547d890567a8a2dd3fb71d5ace (diff) |
Allow length votes on in-dev VNs + always display uncounted votes
Diffstat (limited to 'sql')
-rw-r--r-- | sql/func.sql | 4 |
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 |