From 65b5997873c331321f9b0594cd2477ffc1242751 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Wed, 1 Jan 2020 12:05:22 +0100
Subject: API: Fix "get ulist-labels" and "get ulist labels"

Fixes #26
---
 lib/Multi/API.pm | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm
index 120c3341..26ac0e53 100644
--- a/lib/Multi/API.pm
+++ b/lib/Multi/API.pm
@@ -1108,8 +1108,8 @@ my %GET_WISHLIST = (
 
 my %GET_ULIST_LABELS = (
   islist  => 1,
-  sql     => 'SELECT %s FROM ulist_labels ul WHERE (%s) AND NOT ul.private %s',
-  sqluser => 'SELECT %1$s FROM ulist_labels ul WHERE (%2$s) AND (ul.uid = %4$d OR NOT ul.private) %3$s',
+  sql     => 'SELECT %s FROM ulist_labels uv WHERE (%s) AND NOT uv.private %s',
+  sqluser => 'SELECT %1$s FROM ulist_labels uv WHERE (%2$s) AND (uv.uid = %4$d OR NOT uv.private) %3$s',
   select  => 'uid, id, label, private',
   proc    => sub {
     $_[0]{uid}*=1;
@@ -1149,12 +1149,12 @@ my %GET_ULIST = (
   flags   => {
     basic  => {},
     labels => {
-      fetch => [[ ['uid','vid'], 'SELECT uvl.uid, uvl.vid, ul.id, ul.label
+      fetch => [[ ['uid','vn'], 'SELECT uvl.uid, uvl.vid, ul.id, ul.label
                FROM ulist_vns_labels uvl JOIN ulist_labels ul ON ul.uid = uvl.uid AND ul.id = uvl.lbl
               WHERE (uvl.uid,uvl.vid) IN(%s) AND (NOT ul.private OR uvl.uid = %s)',
         sub { my($n, $r) = @_;
           for my $i (@$n) {
-            $i->{labels} = [ grep $i->{uid} == $_->{uid} && $i->{vid} == $_->{vid}, @$r ];
+            $i->{labels} = [ grep $i->{uid} == $_->{uid} && $i->{vn} == $_->{vid}, @$r ];
           }
           for (@$r) {
             $_->{id}*=1;
-- 
cgit v1.2.3