diff options
author | morkt <> | 2014-12-22 11:49:08 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-12-22 11:49:08 +0100 |
commit | 12338003bde24a3a263abe8caca71b1836ecee83 (patch) | |
tree | 81cdb33820f949f229e84ab17233420d8cb592b8 /lib/VNDB/DB/VN.pm | |
parent | df383d117908160d1a84ce4519edc0c9bcf08c3b (diff) |
bbcode: Replace [vcpgi][0-9]+ links with a [url] tag
Patch from https://vndb.org/t5564.13
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index 090f9ecb..ecf49f96 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -7,7 +7,7 @@ use Exporter 'import'; use VNDB::Func 'gtintype', 'normalize_query'; use Encode 'decode_utf8'; -our @EXPORT = qw|dbVNGet dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom dbVNHasChar|; +our @EXPORT = qw|dbVNGet dbVNRevisionInsert dbVNImageId dbScreenshotAdd dbScreenshotGet dbScreenshotRandom dbVNHasChar dbVNTitles|; # Options: id, rev, char, search, length, lang, olang, plat, tag_inc, tag_exc, tagspoil, @@ -290,5 +290,16 @@ sub dbVNHasChar { )->{exists}; } + +sub dbVNTitles { + my ($self, @vids) = @_; + return $self->dbAll(q| + SELECT v.id, vr.title + FROM vn v + JOIN vn_rev vr ON vr.id = v.latest + WHERE v.id IN (!l)|, \@vids + ); +} + 1; |