diff options
author | Yorhel <git@yorhel.nl> | 2011-01-02 18:58:04 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-01-02 18:58:04 +0100 |
commit | 7886f2d51173102e544794c2f8c1ef2702a74c48 (patch) | |
tree | e7cdaca6e5ace5b497b91ef4b7103481977b5ce5 /lib | |
parent | eda527b4f5c73447b1100055b7e6ac3fa10225ab (diff) |
Bugfix: Don't show NSFW screenshots on homepage with filters
Diffstat (limited to 'lib')
-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 2a7f2477..b506d94d 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -252,7 +252,7 @@ sub dbScreenshotRandom { SELECT vs2.scr FROM vn_screenshots vs2 JOIN vn v2 ON v2.latest = vs2.vid - WHERE v2.id = v.id + WHERE v2.id = v.id AND NOT vs2.nsfw ORDER BY RANDOM() LIMIT 1 )|, @vids).' ORDER BY position', @vids); |