X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FUsers.pm;h=117f1bde98a1ca785549c5bf49005db0411db6e2;hb=9519c80241167db071e44cbdd1e1843daad6e305;hp=40e9aaa51f2b2c162d03fa38b0aa9f0de3ea1623;hpb=b8b4989cd6ad0d0a3f45f6a7972293f79aadd087;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Users.pm b/lib/NDWeb/Controller/Users.pm index 40e9aaa..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 @@ -169,7 +169,7 @@ sub postmail : Local { } my %mail = ( - smtp => 'ruin.nu', + smtp => 'localhost', BCC => (join ',',@emails), From => 'NewDawn Command ', 'Content-type' => 'text/plain; charset="UTF-8"',