ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => Server Optimization, Tweaks => Topic started by: sanj on June 23, 2007, 03:19:47 am

Title: smtp report
Post by: sanj on June 23, 2007, 03:19:47 am

hi,
is there any way a counter can be added to the smtp report that shows the time and the number of emails left and it would be great if it auto updates let's say every 5 minutes.

or is there a quick little script i can use

thanks
sanj

Title: smtp report
Post by: DW on June 23, 2007, 06:31:00 pm

SanJ,

This would take a custom script.  I have plans to ajaxify the 'queue status' header so it can auto update every several seconds without interfering with your browsing/using ListMail.

You can get the queue count with a MySQL query like this, (place script in LMP folder and browse to it):

Code: [Select]

<?php
include('./config.php');
include('./admin.php');
$maxtime=600; // max script run time X secs
$delay=10; // update every X secs

$start=time();
while(!$done){
 list($count)=mysql_fetch_row(mysql_query("select count(*) from lm_sendq"));
 echo date("Y-m-d H:i:s T")." <b>$count</b> messages left<br>";
 flush();
 $diff = time()-$start;
 if($diff>=$maxtime) $done=1; else sleep($delay);
}
echo "Maximum execution time reached.<br>";
?>
Regards