diff options
| author | Yorhel <git@yorhel.nl> | 2015-11-10 02:23:18 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2015-11-10 02:23:18 +0100 |
| commit | 152b3053fb3ff65ad26007d5453d21dc807c7370 (patch) | |
| tree | 413c83d13a2f3f2db83f11da79ca9d081504abd6 /lib/VNDB/DB | |
| parent | 052b78e84b4c7379f107cfaa5f9cede09b8b1b7b (diff) | |
Add language filter to staff browser
Diffstat (limited to 'lib/VNDB/DB')
| -rw-r--r-- | lib/VNDB/DB/Staff.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/VNDB/DB/Staff.pm b/lib/VNDB/DB/Staff.pm index 69f4d6b3..eef01fd3 100644 --- a/lib/VNDB/DB/Staff.pm +++ b/lib/VNDB/DB/Staff.pm @@ -36,6 +36,7 @@ sub dbStaffGet { $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{lang} ? ( 's.lang IN(!l)' => [ ref $o{lang} ? $o{lang} : [$o{lang}] ]) : (), defined $o{role} ? ( '('.join(' OR ', @roles ? ( 'EXISTS(SELECT 1 FROM vn_staff vs JOIN vn v ON v.id = vs.id WHERE vs.aid = sa.aid AND vs.role IN(!l) AND NOT v.hidden)' ) : (), |