#!/bin/bash

CHRBIN=/usr/sbin/chroot
CHRDIR=/chroot/admin

if [ $# -gt 0 -a "$1" == "all" ] ; then
	limit=1
else
	limit=10
fi

function sqlget() {
	if [ -S $CHRDIR/run/mysqld/mysqld.sock ]; then
		echo "SELECT
				SUM(from_unixtime(date) > DATE_ADD(NOW(), INTERVAL -1 HOUR)) AS lasthour,
				SUM(from_unixtime(date) > DATE_ADD(NOW(), INTERVAL -3 HOUR)) AS last3hour,
				SUM(from_unixtime(date) > DATE_ADD(NOW(), INTERVAL -24 HOUR)) AS lastday,
				SUM(from_unixtime(date) > DATE_ADD(NOW(), INTERVAL -72 HOUR)) AS last3day,
				COUNT(id) AS lastweek,
				id
			FROM mail_count
			WHERE from_unixtime(date) > DATE_ADD(NOW(), INTERVAL -168 HOUR)
			GROUP BY id
			HAVING lastday > $limit
			ORDER BY last3hour DESC;
			" | \
		$CHRBIN $CHRDIR mysql \
		--defaults-file=/etc/mysql/debian.cnf \
		--socket=/run/mysqld/mysqld.sock \
		-ss -n sys_policyd
	fi
}

echo "1hr	3hr	day	3day	week	id"
echo "------------------------------------------------------------------------------------------------------"
sqlget