MailQ Log

mailq-check.php

<?php
$mailq = "Error";
$output = array();
$result = "";

//Connect to DB1
$dbcon = mysql_connect('remote_ip','username','password');
mysql_select_db('dbname',$dbcon);

exec('mailq',$output);
if(!empty($output))
{
	$result = end($output);
	if(strpos($result,"empty")!==FALSE)
	{
		$mailq = 0;
	}
	elseif(strpos($result,"in ")!==FALSE && strpos($result," Requests.")!==FALSE)
	{
		$mailq = intval(substr($result,strpos($result,"in ")+3,strpos($result," Requests.")-1));
		if($mailq===0)
			$mailq = "Error";
	}
}
if(isset($mailq) && is_int($mailq) && $mailq!=="Error" && $mailq>=0)
{
	mysql_query("INSERT INTO dbname.postfix_queue (datetime,mail_queue_size,mail_queue_status) VALUES
	(now(),'".mysql_real_escape_string(intval($mailq),$dbcon)."','Y')",$dbcon);
}
else
{
	mysql_query("INSERT INTO dbname.postfix_queue (datetime,mail_queue_size,mail_queue_status) VALUES
	(now(),0,'N')",$dbcon);
}
?>