[plugin] php script to monitor the number of sent emails

[H2B2]

This script by robidigital (originally from this thread) has been copied here for your convenience:

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>&nbsp;mailings have been sent</p>';

[robidigital]

This one uses a variable to set the message ID you want to track rather than putting it directly into the query string.

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());

//which message? - set the ID of the message you are sending
$msgid = 29;

//mysql_select_db ($dbname)

$query = "select count(*) FROM phplist_usermessage WHERE messageid=$msgid";

$sendcount = mysql_db_query($dbname,$query);

$mycount = mysql_result($sendcount,0);

echo '<p><strong>' . $mycount . '</strong>&nbsp;mailings have been sent</p>';

[H2B2]

Nice improvement on your script robidigital !

Would be nice to have this as a plugin to avoid the need to put database username/password in the script itself.

Anyway, thanks for keeping us up-to-date with your improvements

[CS]

I decided to go ahead and run this through the Pluginator(TM) to make it easier for all to use. I also beefed it up and streamlined it a bit. Just download the zip from here and unzip it to your plugins directory.

It'll show the number sent for all messages with status of either "inprocess" or "suspended" along with their status, id and subject.

[H2B2]

Thanks CS!

I'll give it a try as soon as I can find some spare time.