diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/VNWeb/AdvSearch.pm | 2 | ||||
| -rw-r--r-- | lib/VNWeb/Elm.pm | 1 | ||||
| -rw-r--r-- | lib/VNWeb/Staff/Elm.pm | 2 |
3 files changed, 3 insertions, 2 deletions
diff --git a/lib/VNWeb/AdvSearch.pm b/lib/VNWeb/AdvSearch.pm index 8595518e..8b5343d7 100644 --- a/lib/VNWeb/AdvSearch.pm +++ b/lib/VNWeb/AdvSearch.pm @@ -753,7 +753,7 @@ sub elm_search_query { enrich_merge id => 'SELECT id, name, original, hidden FROM producers WHERE id IN', $o{producers}; $o{staff} = [ map +{id => $_}, grep /^s/, keys %ids ]; - enrich_merge id => 'SELECT s.id, sa.aid, sa.name, sa.original FROM staff s JOIN staff_alias sa ON sa.aid = s.aid WHERE s.id IN', $o{staff}; + enrich_merge id => 'SELECT s.id, s.lang, sa.aid, sa.name, sa.original FROM staff s JOIN staff_alias sa ON sa.aid = s.aid WHERE s.id IN', $o{staff}; $o{tags} = [ map +{id => $_}, grep /^g/, keys %ids ]; enrich_merge id => 'SELECT id, name, searchable, applicable, hidden, locked FROM tags WHERE id IN', $o{tags}; diff --git a/lib/VNWeb/Elm.pm b/lib/VNWeb/Elm.pm index f8696239..f6ee14a2 100644 --- a/lib/VNWeb/Elm.pm +++ b/lib/VNWeb/Elm.pm @@ -115,6 +115,7 @@ our %apis = ( } } ], StaffResult => [ { aoh => { # Response to 'Staff' id => { vndbid => 's' }, + lang => {}, aid => { id => 1 }, name => {}, original => { required => 0, default => '' }, diff --git a/lib/VNWeb/Staff/Elm.pm b/lib/VNWeb/Staff/Elm.pm index 5318f458..c95e84fd 100644 --- a/lib/VNWeb/Staff/Elm.pm +++ b/lib/VNWeb/Staff/Elm.pm @@ -6,7 +6,7 @@ elm_api Staff => undef, { search => {} }, sub { my $q = shift->{search}; elm_StaffResult tuwf->dbPagei({ results => 15, page => 1 }, - 'SELECT s.id, sa.aid, sa.name, sa.original + 'SELECT s.id, s.lang, sa.aid, sa.name, sa.original FROM (', sql_join('UNION ALL', $q =~ /^$RE{sid}$/ ? sql('SELECT 0, aid FROM staff_alias WHERE id =', \"$+{id}") : (), |