summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-07-07 10:31:40 +0200
committerYorhel <git@yorhel.nl>2021-07-07 10:31:42 +0200
commit606391250bb1f5cd1ab3b36298e4d4e376f4f48f (patch)
treed6242964ebf8fc08f4704449b5d1f76c2533523e
parent289860cdc521ca4bd2bc03b4a2d58ec3c9f23543 (diff)
Homepage: Fix deleted VNs from showing up in random screenshots
Looks like I broke this again recently. Fixes https://vndb.org/t2520.578
-rw-r--r--lib/VNWeb/Misc/HomePage.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/VNWeb/Misc/HomePage.pm b/lib/VNWeb/Misc/HomePage.pm
index 12d4034f..64238e1c 100644
--- a/lib/VNWeb/Misc/HomePage.pm
+++ b/lib/VNWeb/Misc/HomePage.pm
@@ -27,6 +27,7 @@ sub screens_ {
FROM (SELECT id, width, height FROM images i TABLESAMPLE SYSTEM (', \$sample, ') WHERE', $where, ' ORDER BY random() LIMIT', \4, ') i(id)
JOIN vn_screenshots vs ON vs.scr = i.id
JOIN vn v ON v.id = vs.id
+ WHERE NOT v.hidden
ORDER BY random()
LIMIT', \4
);