summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2015-11-10 02:23:18 +0100
committerYorhel <git@yorhel.nl>2015-11-10 02:23:18 +0100
commit152b3053fb3ff65ad26007d5453d21dc807c7370 (patch)
tree413c83d13a2f3f2db83f11da79ca9d081504abd6 /lib
parent052b78e84b4c7379f107cfaa5f9cede09b8b1b7b (diff)
Add language filter to staff browser
Diffstat (limited to 'lib')
-rw-r--r--lib/VNDB/DB/Staff.pm1
-rw-r--r--lib/VNDB/Util/Misc.pm2
2 files changed, 2 insertions, 1 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)' ) : (),
diff --git a/lib/VNDB/Util/Misc.pm b/lib/VNDB/Util/Misc.pm
index 2e707eeb..1ca1ac8f 100644
--- a/lib/VNDB/Util/Misc.pm
+++ b/lib/VNDB/Util/Misc.pm
@@ -14,7 +14,7 @@ my %filfields = (
vn => [qw|length hasani tag_inc tag_exc taginc tagexc tagspoil lang olang plat ul_notblack ul_onwish ul_voted ul_onlist|],
release => [qw|type patch freeware doujin date_before date_after released minage lang olang resolution plat med voiced ani_story ani_ero|],
char => [qw|gender bloodt bust_min bust_max waist_min waist_max hip_min hip_max height_min height_max weight_min weight_max trait_inc trait_exc tagspoil role|],
- staff => [qw|gender role truename|],
+ staff => [qw|gender role truename lang|],
);