summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-02-02 09:41:40 +0100
committerYorhel <git@yorhel.nl>2015-02-02 09:41:40 +0100
commit0d4a5d1c6b0b9dfcb901c56eb586efa20eac0c31 (patch)
treedd17e88ec104c4288c2f9f0e948cfd1f2198ebcd /lib/VNDB/DB
parentc66ed1d451c1aa8cb7f136df296d28d80b1b2bfa (diff)
dbVNHasChar(): Fix bug with hidden/deleted characters
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r--lib/VNDB/DB/VN.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 3c7b9815..f18c6c9a 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -330,7 +330,7 @@ sub dbScreenshotRandom {
sub dbVNHasChar {
my($self, $vid) = @_;
return $self->dbRow(
- 'SELECT 1 AS exists FROM chars c JOIN chars_vns cv ON c.latest = cv.cid WHERE cv.vid = ?', $vid
+ 'SELECT 1 AS exists FROM chars c JOIN chars_vns cv ON c.latest = cv.cid WHERE cv.vid = ? AND NOT c.hidden', $vid
)->{exists};
}