diff options
author | Yorhel <git@yorhel.nl> | 2021-07-02 16:42:09 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-07-02 16:42:15 +0200 |
commit | bd827d994bd834bd6e1095bc15d3310fdbdf0515 (patch) | |
tree | b1b86345871c12310626d9b1dce046cdfb078acd /lib/VNWeb/Chars/List.pm | |
parent | 823536f5ef4eaaa629888aa829e07877a4aa44b6 (diff) |
Chars::List: Hide VN if thats a spoiler
Fixes https://vndb.org/t2520.575
Diffstat (limited to 'lib/VNWeb/Chars/List.pm')
-rw-r--r-- | lib/VNWeb/Chars/List.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNWeb/Chars/List.pm b/lib/VNWeb/Chars/List.pm index 462eeedf..e4956ff7 100644 --- a/lib/VNWeb/Chars/List.pm +++ b/lib/VNWeb/Chars/List.pm @@ -74,7 +74,7 @@ sub enrich_listing { SELECT DISTINCT cv.id AS cid, v.id, v.title, v.original FROM chars_vns cv JOIN vn v ON v.id = cv.vid - WHERE NOT v.hidden AND cv.id IN', $_, ' + WHERE NOT v.hidden AND cv.spoil = 0 AND cv.id IN', $_, ' ORDER BY v.title' }, @_; } |