diff options
author | Yorhel <git@yorhel.nl> | 2019-09-13 13:46:01 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-09-13 13:46:03 +0200 |
commit | 3f9cf736785d67875e278e3602df8ba5887e06aa (patch) | |
tree | 17ce0ebfc139272203be0d45d9087608646163ad /lib/VNDB/DB/VN.pm | |
parent | 7e33f7fdbdfd28ff4761262525e9bca0b54e3bc4 (diff) |
DB::VN: Return hidden staff & seiyuu in dbGetVN
Otherwise it is impossible to remove them from the VN entry.
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index dd33fef8..b29ee3c6 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -202,7 +202,7 @@ sub _enrich { FROM vn_staff$hist vs JOIN staff_alias sa ON vs.aid = sa.aid JOIN staff s ON s.id = sa.id - WHERE s.hidden = FALSE AND vs.$colname IN(!l) + WHERE vs.$colname IN(!l) ORDER BY vs.role ASC, sa.name ASC", [ keys %r ] )}); @@ -220,7 +220,7 @@ sub _enrich { JOIN staff s ON s.id = sa.id JOIN chars c ON c.id = vs.cid $join - WHERE s.hidden = FALSE AND vs.$colname IN(!l) + WHERE vs.$colname IN(!l) ORDER BY c.name", [ keys %r ] )}); |