summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Chars.pm
diff options
context:
space:
mode:
authormorkt <>2014-12-22 11:49:08 +0100
committerYorhel <git@yorhel.nl>2014-12-22 11:49:08 +0100
commit12338003bde24a3a263abe8caca71b1836ecee83 (patch)
tree81cdb33820f949f229e84ab17233420d8cb592b8 /lib/VNDB/DB/Chars.pm
parentdf383d117908160d1a84ce4519edc0c9bcf08c3b (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.pm12
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;