#!/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
##        - kevin.schottie@endurance.com
#################################################################

use YAML::Syck;

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 PS,"ps ax -o user:@{[length($user)+1]},pid,pcpu,pmem,vsz,rss,tty,stat,start_time,bsdtime,cmd |";
#open MYSQLPROC,"mysqladmin proc --verb |";
if ( -e "/var/cpanel/databases/${user}.yaml" ) {
    my $dbdata = eval { LoadFile("/var/cpanel/databases/${user}.yaml") };
    if ( $@ ) {
        warn "$@\n";
        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\" |";
    } else {
        my @dbusers = keys %{$dbdata->{MYSQL}->{dbusers}};
        push @dbusers, $user;
        open MYSQLPROC, "/usr/bin/mysql -e \"select USER,DB,STATE,TIME,COMMAND,INFO from INFORMATION_SCHEMA.PROCESSLIST WHERE (" . join(' OR', map { " USER = '$_'" } @dbusers ) . ")\\G\" |";    
    }
} else {
    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 $_;
}
