X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FIRC%2FUsermgm.pm;h=e02370dafb57fafc33f3bfa673d75d2bc5a382b5;hb=c83e779f0289c764e54468013e0578978ef242b0;hp=8939b801e9fc2beb29498b4689c154521da7e55d;hpb=3434a018e5752f33d863d7cccd1be8ca9426e777;p=ndwebbie.git diff --git a/ND/IRC/Usermgm.pm b/ND/IRC/Usermgm.pm index 8939b80..e02370d 100644 --- a/ND/IRC/Usermgm.pm +++ b/ND/IRC/Usermgm.pm @@ -96,13 +96,13 @@ sub flag { if (officer()|| ($ND::target eq $ND::scanchan && $flag eq 'S')){ my $f = $ND::DBH->prepare(qq{ -SELECT TRIM(', ' FROM concat(username||', ')) FROM +SELECT TRIM(', ' FROM concat(username||', ')),count(username) FROM (SELECT uid, username FROM users ORDER BY username) u NATURAL JOIN groupmembers gm JOIN groups g ON g.gid = gm.gid WHERE flag = ?; }); - if (my ($users) = $ND::DBH->selectrow_array($f,undef,$flag)){ - $ND::server->command("msg $ND::target Users with flag $ND::B$flag$ND::B: $users"); + if (my ($users,$count) = $ND::DBH->selectrow_array($f,undef,$flag)){ + $ND::server->command("msg $ND::target $ND::B$count$ND::B Users with flag $ND::B$flag$ND::B: $users"); } }else{ $ND::server->command("msg $ND::target Only officers are allowed to check that"); @@ -119,11 +119,13 @@ sub laston { $min = 0 unless defined $min; $f->execute($flag,$min); my $text; + my $i = 0; while (my $user = $f->fetchrow_hashref){ $user->{last} = '?' unless defined $user->{last}; $text .= "$user->{username}($user->{last}) "; + $i++; } - $ND::server->command("msg $ND::target Users(days) with flag $ND::B$flag$ND::B: $text"); + $ND::server->command("msg $ND::target $ND::B$i$ND::B Users(days) with flag $ND::B$flag$ND::B: $text"); }else{ $ND::server->command("msg $ND::target Only officers are allowed to check that"); }