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/Chars.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/Chars.pm')
-rw-r--r-- | lib/VNDB/DB/Chars.pm | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm index 86b3a859..f387b044 100644 --- a/lib/VNDB/DB/Chars.pm +++ b/lib/VNDB/DB/Chars.pm @@ -5,7 +5,7 @@ use strict; use warnings; use Exporter 'import'; -our @EXPORT = qw|dbCharGet dbCharRevisionInsert dbCharImageId|; +our @EXPORT = qw|dbCharGet dbCharRevisionInsert dbCharImageId dbCharNames|; # options: id rev instance tagspoil trait_inc trait_exc char what results page gender bloodt @@ -138,6 +138,16 @@ sub dbCharImageId { } +sub dbCharNames { + my ($self, @ids) = @_; + return $self->dbAll(q| + SELECT c.id, cr.name + FROM chars c + JOIN chars_rev cr ON cr.id = c.latest + WHERE c.id IN (!l)|, \@ids + ); +} + 1; |