Converted laston, split half the command into lastseen

[NDIRC.git] / Commands / Usermgm.pm

diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm
index 8a87f8e1fae85147459336c9e4bcf654420c6f29..3563b84fc12b7754b6dfb41330adff97ea6ed8cb 100644 (file)
--- a/Commands/Usermgm.pm
+++ b/Commands/Usermgm.pm
@@ -180,4 +180,71 @@ WHERE flag = $1
        $c->reply("<b>$count</b> Users with flag <b>$flag</b>: $users");
 }
 
+sub laston
+       : Help(syntax: .laston flag [days] | lists users and the number of days since they were last seen (irc|forum|claim). If days is specified it will only list users with at least that amount of idle time. Days can also specify forum and claim with irc|forum|claim syntax)
+       : ACL(irc_laston)
+{
+       my ($self,$c,$msg) = @_;
+       my ($flag,$min,$forum,$claim) = $msg =~ /^(\w)(?: (\d+)(?:\|(\d+)\|(\d+))?)?$/
+               or die 'ARGS';
+       $min //= 0;
+
+       my $f = $c->model->prepare(q{
+SELECT username, COALESCE(last::text,'?') AS last
+       ,COALESCE(lastforum::text,'?') AS lastforum
+       ,COALESCE(lastclaim::text,'?') AS lastclaim
+FROM (SELECT username
+               ,date_part('day',now() - laston)::int AS last
+               ,date_part('day',now() -
+                       (SELECT max(time) FROM forum_thread_visits WHERE uid = u.uid)) AS lastforum
+               ,date_part('day',now() -
+                       (SELECT max(timestamp) FROM raid_claims WHERE uid = u.uid)) AS lastclaim
+       FROM users u
+               NATURAL JOIN groupmembers
+               NATURAL JOIN groups
+       WHERE flag = $1
+       ) a
+WHERE COALESCE(last >= $2,TRUE) AND COALESCE(lastforum >= $3,TRUE)
+       AND COALESCE(lastclaim >= $4,TRUE)
+ORDER BY last DESC, lastforum DESC, lastclaim DESC
+               });
+       $f->execute($flag,$min,$forum,$claim);
+
+       my $text;
+       my $i = 0;
+       while (my $user = $f->fetchrow_hashref){
+               $text .= "$user->{username}($user->{last}|$user->{lastforum}|$user->{lastclaim}) ";
+               $i++;
+       }
+       $c->reply("<b>$i</b> Users(days) with flag <b>$flag</b>: $text");
+}
+
+
+sub lastseen
+       : Help(syntax: .lastseen username | Shows the number of days since the user(s) last visited irc, forum and raids)
+       : ACL(irc_lastseen)
+{
+       my ($self,$c,$msg) = @_;
+       my ($username) = $msg =~ /^(\S+)$/ or die 'ARGS';
+
+       my $f = $c->model->prepare(q{
+SELECT username, COALESCE(date_part('day',now() - laston)::text,'?') AS last
+       ,COALESCE(date_part('day',now() - (SELECT max(time)
+               FROM forum_thread_visits WHERE uid = u.uid))::text,'?') AS lastforum
+       ,COALESCE(date_part('day',now() - (SELECT max(timestamp)
+               FROM raid_claims WHERE uid = u.uid))::text,'?') AS lastclaim
+FROM users u
+WHERE username ILIKE $1 ORDER BY lower(username)
+               });
+       $f->execute($username);
+
+       my $text;
+       my $i = 0;
+       while (my $user = $f->fetchrow_hashref){
+               $text .= "$user->{username}($user->{last}|$user->{lastforum}|$user->{lastclaim}) ";
+               $i++;
+       }
+       $c->reply("<b>$i</b> Users(days): $text");
+}
+
 1;