From adfcac8b7f2ec6bca4e7f5089c9ce0b772b6ad52 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Wed, 6 Mar 2019 22:47:09 +0100 Subject: [PATCH] Updated .whois to show discord_id --- Commands/Usermgm.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm index 5866f91..7554fd4 100644 --- a/Commands/Usermgm.pm +++ b/Commands/Usermgm.pm @@ -159,16 +159,16 @@ command whois => { my $f = $dbh->prepare(q{ -SELECT username, pnick, hostmask, array_to_string(array_agg(gid),'') AS flags +SELECT username, pnick, hostmask, discord_id, array_to_string(array_agg(gid),'') AS flags FROM users u LEFT OUTER JOIN (SELECT uid,gid FROM groupmembers ORDER BY uid,gid ) g USING (uid) WHERE username ILIKE ? -GROUP BY username,pnick,hostmask LIMIT 5 +GROUP BY username,pnick,hostmask,discord_id LIMIT 5 }); $f->execute($nick); while (my $user = $f->fetchrow_hashref){ - $c->reply("$user->{username} (/$user->{pnick}) flags: ($user->{flags}) host: $user->{hostmask}"); + $c->reply("$user->{username} ($user->{pnick},$user->{discord_id}) flags: ($user->{flags}) host: $user->{hostmask}"); } if ($f->rows == 0){ $c->reply("No hit, maybe spelling mistake, or add % as wildcard"); -- 2.39.2