diff options
author | Yorhel <git@yorhel.nl> | 2021-07-07 10:31:40 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-07-07 10:31:42 +0200 |
commit | 606391250bb1f5cd1ab3b36298e4d4e376f4f48f (patch) | |
tree | d6242964ebf8fc08f4704449b5d1f76c2533523e | |
parent | 289860cdc521ca4bd2bc03b4a2d58ec3c9f23543 (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.pm | 1 |
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 ); |