diff options
author | Yorhel <git@yorhel.nl> | 2015-01-28 19:22:03 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-01-28 19:22:03 +0100 |
commit | f8b999c3f1842a5ef4836a9f56df7b87d9106466 (patch) | |
tree | 6872b2df80fb36cccde613270b350af1423c230a /lib/VNDB/DB | |
parent | 8e1df87626b97239bf7dc2f00cbbe0ea86100810 (diff) |
Hide spoilerous characters from the VN staff pages by default
To fix an issue mentioned in <https://vndb.org/t6138.15>. Yay for
writing patches on the live site.
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index b3b55598..3c7b9815 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -164,7 +164,8 @@ sub dbVNGet { [ keys %r ] )}); push(@{$r->[$r{ delete $_->{vid} }]{seiyuu}}, $_) for (@{$self->dbAll(q| - SELECT vs.vid, s.id, vs.aid, sa.name, sa.original, sr.gender, sr.lang, cr.cid, cr.name AS cname, vs.note + SELECT vs.vid, s.id, vs.aid, sa.name, sa.original, sr.gender, sr.lang, cr.cid, cr.name AS cname, vs.note, + NOT EXISTS(SELECT 1 FROM chars_vns cv WHERE cv.vid = vr.vid AND cv.cid = cr.id AND cv.spoil = 0) as spoil FROM vn_seiyuu vs JOIN vn_rev vr ON vr.id = vs.vid JOIN staff_alias sa ON vs.aid = sa.id |