X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FUsers.pm;h=117f1bde98a1ca785549c5bf49005db0411db6e2;hp=4ae8d54450f033fe1dbdd5a6d62d666d93e1339c;hb=27a84187a27390a65531888c0068a11f69f6d2cf;hpb=58051bd156c4626863b843aabf1c51606a2f289c diff --git a/lib/NDWeb/Controller/Users.pm b/lib/NDWeb/Controller/Users.pm index 4ae8d54..117f1bd 100644 --- a/lib/NDWeb/Controller/Users.pm +++ b/lib/NDWeb/Controller/Users.pm @@ -29,7 +29,7 @@ sub index :Path :Args(0) { my $dbh = $c->model; my $query = $dbh->prepare(q{ -SELECT uid,username,pnick,array_to_string(array_agg(g.groupname),', ') AS groups +SELECT uid,username,discord_id,pnick,array_to_string(array_agg(g.groupname),', ') AS groups FROM users u LEFT OUTER JOIN (groupmembers gm NATURAL JOIN groups g) USING (uid) WHERE uid > 0 GROUP BY u.uid,username,pnick