summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-03-01 16:41:33 +0100
committerYorhel <git@yorhel.nl>2021-03-01 16:41:35 +0100
commit69cc222c16d23ccedb49581efae1d9a44498b44e (patch)
treed552822ec4eb728d69f3412d0b9b833793c5035e
parent1153ccdfb96d56574bec2272dd66cb3d808b7f68 (diff)
API: Fix bug with VN filter in list commands
https://vndb.org/t12641.14
-rw-r--r--lib/Multi/API.pm4
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)';