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 | |
parent | 052b78e84b4c7379f107cfaa5f9cede09b8b1b7b (diff) |
Add language filter to staff browser
-rw-r--r-- | data/js/filter.js | 3 | ||||
-rw-r--r-- | data/lang.txt | 12 | ||||
-rw-r--r-- | lib/VNDB/DB/Staff.pm | 1 | ||||
-rw-r--r-- | lib/VNDB/Util/Misc.pm | 2 |
4 files changed, 16 insertions, 2 deletions
diff --git a/data/js/filter.js b/data/js/filter.js index b1c7d581..fae375fc 100644 --- a/data/js/filter.js +++ b/data/js/filter.js @@ -547,7 +547,8 @@ function filStaff() { filFSelect('role', mt('_sbrowse_roles'), roles.length, roles), '', filFSelect('gender', mt('_sbrowse_gender'), gend.length, gend), - ] + ], + [ mt('_sbrowse_language'), filFSelect('lang', mt('_sbrowse_language'), 20, VARS.languages) ], ]; } diff --git a/data/lang.txt b/data/lang.txt index 4cdba075..d0e3b713 100644 --- a/data/lang.txt +++ b/data/lang.txt @@ -5870,6 +5870,18 @@ tr*: uk*: it*: +:_sbrowse_language +en : Language +ru : Языки +cs : Jazyk +hu : Nyelvek +nl : Taal +de : Sprache +es : Idioma +tr : Dili +uk : Мова +it : Lingua + :_staff_credits en : Credits ru*: 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|], ); |