summaryrefslogtreecommitdiff
path: root/lib/VNDB/DB
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-10-24 15:12:25 +0200
committerYorhel <git@yorhel.nl>2015-10-24 15:12:25 +0200
commit799ae5fd9460448c98423d92b69428fc4be05dd1 (patch)
tree51fe895b9c2fb06438f80140619f00aa506864a6 /lib/VNDB/DB
parentbbe989de364ddc654bfc6385e22f1eaff23faad1 (diff)
DB::Staff: Fix 'aid' filter, used when editing VN staff info
This broken filter would cause all staff info to be deleted from a VN upon edit. Not so nice.
Diffstat (limited to 'lib/VNDB/DB')
-rw-r--r--lib/VNDB/DB/Staff.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm
index fb472c72..c8178aae 100644
--- a/lib/VNDB/DB/Staff.pm
+++ b/lib/VNDB/DB/Staff.pm
@@ -33,7 +33,7 @@ sub dbStaffGet {
my %where = (
!$o{id} ? ( 's.hidden = FALSE' => 1 ) : (),
$o{id} ? ( ref $o{id} ? ('s.id IN(!l)' => [$o{id}]) : ('s.id = ?' => $o{id}) ) : (),
- $o{aid} ? ( ref $o{aid} ? ('sa.id IN(!l)' => [$o{aid}]) : ('sa.id = ?' => $o{aid}) ) : (),
+ $o{aid} ? ( ref $o{aid} ? ('sa.aid IN(!l)' => [$o{aid}]) : ('sa.aid = ?' => $o{aid}) ) : (),
$o{id} || $o{truename} ? ( 's.aid = sa.aid' => 1 ) : (),
defined $o{gender} ? ( 's.gender IN(!l)' => [ ref $o{gender} ? $o{gender} : [$o{gender}] ]) : (),
defined $o{role} ? (