summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB/Staff.pm
diff options
context:
space:
mode:
Diffstat (limited to 'lib/VNDB/DB/Staff.pm')
-rw-r--r--lib/VNDB/DB/Staff.pm11
1 files changed, 5 insertions, 6 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index 1b9a10da..4dfe0756 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -126,7 +126,7 @@ sub dbStaffRevisionInsert {
my($self, $o) = @_;
$self->dbExec('DELETE FROM edit_staff_aliases');
- if ($o->{aid}) {
+ if($o->{aid}) {
$self->dbExec(q|
INSERT INTO edit_staff_aliases (id, name, original) VALUES (?, ?, ?)|,
$o->{aid}, $o->{name}, $o->{original});
@@ -139,12 +139,11 @@ sub dbStaffRevisionInsert {
my %staff = map exists($o->{$_}) ? (qq|"$_" = ?|, $o->{$_}) : (),
qw|aid gender lang desc l_wp l_site l_twitter l_anidb|;
$self->dbExec('UPDATE edit_staff !H', \%staff) if %staff;
- for my $alias (@{$o->{aliases}}) {
- if ($alias->[0]) {
- $self->dbExec('INSERT INTO edit_staff_aliases (id, name, original) VALUES (!l)', $alias);
+ for my $a (@{$o->{aliases}}) {
+ if($a->{aid}) {
+ $self->dbExec('INSERT INTO edit_staff_aliases (id, name, original) VALUES (!l)', [ @{$a}{qw|aid name orig|} ]);
} else {
- $self->dbExec('INSERT INTO edit_staff_aliases (name, original) VALUES (?, ?)',
- $alias->[1], $alias->[2]);
+ $self->dbExec('INSERT INTO edit_staff_aliases (name, original) VALUES (?, ?)', $a->{name}, $a->{orig});
}
}
}