diff options
| author | morkt <> | 2014-12-28 12:44:24 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2014-12-28 12:44:24 +0100 |
| commit | 30acfccc74971acaf0addd521cf24bbb5221618b (patch) | |
| tree | 1679224554d2e785f7504ba1f570821941985709 /lib/VNDB/DB/Chars.pm | |
| parent | 6399d6d4e21bd4464c7224f821d6ea071ea7a614 (diff) | |
staff: Import cast from other VN + some styling + more improvements
Diffstat (limited to 'lib/VNDB/DB/Chars.pm')
| -rw-r--r-- | lib/VNDB/DB/Chars.pm | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm index a7dfb692..50923941 100644 --- a/lib/VNDB/DB/Chars.pm +++ b/lib/VNDB/DB/Chars.pm @@ -111,12 +111,11 @@ sub dbCharGet { if($o{what} =~ /seiyuu/) { push @{$r{ delete $_->{cid} }{seiyuu}}, $_ for (@{$self->dbAll(q| - SELECT cr.id AS cid, sr.sid, sa.name, sa.original, vs.note, v.id AS vid, vr.title AS vntitle + SELECT cr.id AS cid, s.id AS sid, sa.name, sa.original, vs.note, v.id AS vid, vr.title AS vntitle FROM vn_seiyuu vs JOIN chars_rev cr ON cr.cid = vs.cid JOIN staff_alias sa ON sa.id = vs.aid - JOIN staff_rev sr ON sr.id = sa.rid - JOIN staff s ON sr.id = s.latest + JOIN staff s ON sa.rid = s.latest JOIN vn_rev vr ON vr.id = vs.vid JOIN vn v ON v.latest = vs.vid !W |