From 799ae5fd9460448c98423d92b69428fc4be05dd1 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Sat, 24 Oct 2015 15:12:25 +0200
Subject: 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.
---
 lib/VNDB/DB/Staff.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib')

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} ? (
-- 
cgit v1.2.3