#!/usr/bin/perl
#################################################################
## User
## Gives the current processes, mysqladmin proc output for a user
##  and whoever is hitting their sites.
##
##  If you see any issues please let me know
##        - sladewig@hostgator.com
#################################################################

my $user = shift;

if ($user !~ /\w{2,15}$/) {
	print "User not in proper format\n";
	exit;
}

open SCOREBOARD,"lynx --dump --width=10000 localhost/whm-server-status | ";
open PS,"ps aux |";
#open MYSQLPROC,"mysqladmin proc --verb |";
open MYSQLPROC, "/usr/bin/mysql -e \"select USER,DB,STATE,TIME,COMMAND,INFO from INFORMATION_SCHEMA.PROCESSLIST WHERE (USER LIKE '" . $user . "_%' OR USER = '$user')\\G\" |";
open USERDOMAINS,"<","/etc/userdomains";

my @scoreboard = grep (/GET|POST/,<SCOREBOARD>);
my @ps = <PS>;
my @mysqlproc = <MYSQLPROC>;
my @userdomains;

while (<USERDOMAINS>) {
	if (!/^\*/) {
		push (@userdomains,$_);
	}
}

foreach (@scoreboard) {
        my @temp = split(' ',$_);
        $_ = $temp[10]."\t".$temp[11]."\t".$temp[13]."\n";
}

close (SCOREBOARD);
close (PS);
close (MYSQLPROC);

my @runningprocesses = grep (/^$user /,@ps);
print "Running Processes:\n";
foreach (@runningprocesses) {
        print $_;
}

print "\nRunning Queries:\n";
foreach (@mysqlproc) {
        print $_;
}
print "\nOpen connections\n";
print `lsof -Pnawi -u $user`;
my @scoreboardforuser;
my @domainsuser = grep (/: $user$/,@userdomains);
push (@domainsuser,"/~$user/");
foreach $domain (@domainsuser) {
	chomp($domain);
        $domain =~ s/(^\s)|(: \w+$)|\*//g;
        $domain = substr($domain,0,38);
        my @seen = grep(/$domain/,@scoreboard);
        push(@scoreboardforuser,@seen);
}
@scoreboardforuser = sort(@scoreboardforuser);
print "\nCurrent Site Requests:\n";
foreach (@scoreboardforuser) {
        print $_;
}
