diff options
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 14 |
1 files changed, 1 insertions, 13 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index 5412ed2a..a057b166 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -8,7 +8,7 @@ use POSIX 'strftime'; use Exporter 'import'; use VNDB::Func 'normalize_query'; -our @EXPORT = qw|dbVNGet dbVNGetRev dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom dbVNImportSeiyuu|; +our @EXPORT = qw|dbVNGet dbVNGetRev dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom|; # Options: id, char, search, length, lang, olang, plat, tag_inc, tag_exc, tagspoil, @@ -350,16 +350,4 @@ sub dbScreenshotRandom { } -# returns seiyuus that voice characters referenced by $cids in VNs other than $vid -sub dbVNImportSeiyuu { - my($self, $vid, $cids) = @_; - return $self->dbAll(q| - SELECT DISTINCT ON(c.id) c.id AS cid, c.name AS c_name, sa.id AS sid, sa.aid, sa.name - FROM vn_seiyuu vs - JOIN chars c ON c.id = vs.cid - JOIN staff_alias sa ON sa.aid = vs.aid - WHERE vs.cid IN(!l) AND vs.id <> ?|, $cids, $vid); -} - - 1; |