summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/VN.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-05-03 08:40:15 +0200
committerYorhel <git@yorhel.nl>2009-05-03 08:40:15 +0200
commit9909b50b1973d02717c89d4e42b274909d59a0ac (patch)
treed0402ea5fcfc8e67a8640f94195cdfd704c75046 /lib/VNDB/DB/VN.pm
parentd8c2e20531a165064e32d96afa22c81f479184d7 (diff)
Don't show screenshots of hidden VNs on homepage
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r--lib/VNDB/DB/VN.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 1e9fc74f..dcd1d06a 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -274,7 +274,7 @@ sub dbScreenshotRandom {
FROM vn_screenshots vs
JOIN vn v ON v.latest = vs.vid
JOIN vn_rev vr ON vr.id = v.latest
- WHERE vs.nsfw = FALSE
+ WHERE vs.nsfw = FALSE AND v.hidden = FALSE
ORDER BY RANDOM()
LIMIT 4|
);