diff options
author | Yorhel <git@yorhel.nl> | 2021-03-01 16:41:33 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-03-01 16:41:35 +0100 |
commit | 69cc222c16d23ccedb49581efae1d9a44498b44e (patch) | |
tree | d552822ec4eb728d69f3412d0b9b833793c5035e /lib/Multi/API.pm | |
parent | 1153ccdfb96d56574bec2272dd66cb3d808b7f68 (diff) |
API: Fix bug with VN filter in list commands
https://vndb.org/t12641.14
Diffstat (limited to 'lib/Multi/API.pm')
-rw-r--r-- | lib/Multi/API.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm index 0c1f3ffb..ad40d491 100644 --- a/lib/Multi/API.pm +++ b/lib/Multi/API.pm @@ -1083,8 +1083,8 @@ my $UID_FILTER = [ 'int' => 'uv.uid :op: :value:', {qw|= =|}, process => \&subst # Similarly, a filter for 'vid' my $VN_FILTER = [ - [ 'int' => 'uv.vid :op: :value:', {qw|= = != <> > > < < <= <= >= >=|}, range => [1,1e6] ], - [ inta => 'uv.vid :op:(:value:)', {'=' => 'IN', '!=' => 'NOT IN'}, range => [1,1e6], join => ',' ], + [ 'int' => 'uv.vid :op: :value:', {qw|= = != <> > > < < <= <= >= >=|}, process => \'v' ], + [ inta => 'uv.vid :op:(:value:)', {'=' => 'IN', '!=' => 'NOT IN'}, process => \'v', join => ',' ], ]; my $UV_PUBLIC = 'EXISTS(SELECT 1 FROM ulist_vns_labels uvl JOIN ulist_labels ul ON ul.uid = uvl.uid AND ul.id = uvl.lbl WHERE uvl.uid = uv.uid AND uvl.vid = uv.vid AND NOT ul.private)'; |