diff options
author | Yorhel <git@yorhel.nl> | 2020-12-29 13:12:33 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-12-29 13:12:35 +0100 |
commit | 16d0e7bac22ae9b39cc12c3249f8ef5c68e3ca71 (patch) | |
tree | 1d430c8e4b87942d846190599f4daa3583febebd | |
parent | 4c36358dc03f8db5a77f453d7efffa818707a055 (diff) |
AdvSearch: Rename producer/developer filters with -id suffix
To differentiate them with potential future subquery filters. Names
aren't part of any long-term API yet, so let's change it while we can.
-rw-r--r-- | lib/VNWeb/AdvSearch.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/lib/VNWeb/AdvSearch.pm b/lib/VNWeb/AdvSearch.pm index 239d35f8..68f13330 100644 --- a/lib/VNWeb/AdvSearch.pm +++ b/lib/VNWeb/AdvSearch.pm @@ -315,7 +315,7 @@ f v => 62 => 'has-anime', { uint => 1, range => [1,1] }, '=' => sub { 'EXI f v => 63 => 'has-screenshot', { uint => 1, range => [1,1] }, '=' => sub { 'EXISTS(SELECT 1 FROM vn_screenshots vs WHERE vs.id = v.id)' }; f v => 64 => 'has-review', { uint => 1, range => [1,1] }, '=' => sub { 'EXISTS(SELECT 1 FROM reviews r WHERE r.vid = v.id AND NOT r.c_flagged)' }; -f v => 6 => 'developer',{ vndbid => 'p' }, +f v => 6 => 'developer-id',{ vndbid => 'p' }, '=' => sub { sql 'v.id IN(SELECT rv.vid FROM releases r JOIN releases_vn rv ON rv.id = r.id JOIN releases_producers rp ON rp.id = r.id WHERE NOT r.hidden AND rp.pid = vndbid_num(', \$_, ') AND rp.developer)' }; @@ -347,8 +347,8 @@ f r => 4 => 'platform', { required => 0, default => undef, enum => \%PLATFORM } sql 'r.id', $neg ? 'NOT' : '', 'IN(SELECT id FROM releases_platforms WHERE platform IN', $val, $all && @$val > 1 ? ('GROUP BY id HAVING COUNT(platform) =', \scalar @$val) : (), ')'; }; -f r => 6 => 'developer',{ vndbid => 'p' }, '=' => sub { sql 'r.id IN(SELECT id FROM releases_producers WHERE developer AND pid = vndbid_num(', \$_, '))' }; -f r => 17 => 'producer', { vndbid => 'p' }, '=' => sub { sql 'r.id IN(SELECT id FROM releases_producers WHERE pid = vndbid_num(', \$_, '))' }; +f r => 6 => 'developer-id',{ vndbid => 'p' }, '=' => sub { sql 'r.id IN(SELECT id FROM releases_producers WHERE developer AND pid = vndbid_num(', \$_, '))' }; +f r => 17 => 'producer-id', { vndbid => 'p' }, '=' => sub { sql 'r.id IN(SELECT id FROM releases_producers WHERE pid = vndbid_num(', \$_, '))' }; f r => 7 => 'released', { fuzzyrdate => 1 }, sql => sub { sql 'r.released', $_[0], \($_ == 1 ? strftime('%Y%m%d', gmtime) : $_) }; f r => 8 => 'resolution', { type => 'array', length => 2, values => { uint => 1, max => 32767 } }, sql => sub { sql 'NOT r.patch AND r.reso_x', $_[0], \$_->[0], 'AND r.reso_y', $_[0], \$_->[1], $_->[0] ? 'AND r.reso_x > 0' : () }; |