diff options
author | Yorhel <git@yorhel.nl> | 2009-05-03 08:40:15 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-05-03 08:40:15 +0200 |
commit | 9909b50b1973d02717c89d4e42b274909d59a0ac (patch) | |
tree | d0402ea5fcfc8e67a8640f94195cdfd704c75046 /lib/VNDB/DB/VN.pm | |
parent | d8c2e20531a165064e32d96afa22c81f479184d7 (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.pm | 2 |
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| ); |