robidigital, on 05 Jul, 2007 wrote:I created a small php script to check the number of email sent. It does the same thing as the sql query geckoday posted for monitoring. All you have to do is plugin the database settings. Hope this helps.
- Code: Select all
//database settings
$dbname = "XXXX";
$dbhost = "XXXX";
$dbuser = "XXXX";
$dbpass = "XXXX";
$dbh=mysql_connect ($dbhost, $dbuser, $dbpass) or die ('I cannot connect to the database because: ' . mysql_error());
$query = "select count(*) FROM phplist_usermessage WHERE messageid=19";
$sendcount = mysql_db_query($dbname,$query);
$mycount = mysql_result($sendcount,0);
echo '<p><strong>' . $mycount . '</strong> mailings have been sent</p>';