summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-07-02 16:42:09 +0200
committerYorhel <git@yorhel.nl>2021-07-02 16:42:15 +0200
commitbd827d994bd834bd6e1095bc15d3310fdbdf0515 (patch)
treeb1b86345871c12310626d9b1dce046cdfb078acd /lib
parent823536f5ef4eaaa629888aa829e07877a4aa44b6 (diff)
Chars::List: Hide VN if thats a spoiler
Fixes https://vndb.org/t2520.575
Diffstat (limited to 'lib')
-rw-r--r--lib/VNWeb/Chars/List.pm2
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'
}, @_;
}