[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.

[indidginus]

This sounds great - thank you for the download! I've unzipped & uploaded to the plugins directory - now when I send a message to my mailing list, how do I activate the plugin to monitor the sending process? Many thanks.

Michael.

[CS2]

Assuming you downloaded my plugin rather than the original script, just click the "message progress" link on the right hand menu.

[indidginus]

Hi CS2, thanks for your reply. I did download your zip file..... I don't see the Message Progress link in my admin page though. I ran a test job & the right hand menu doesn't even display (see attached screenshot). I had to refresh the browser & then the Send Message Queue box displayed to tell me all 7 messages had been sent....

[CS2]

Looks like there is an error in the PHP somewhere that prevents the processing log from displaying. Do you get this on other pages or only when processing the queue? Also, what version of PHPlist are you running?

[indidginus]

Thanks for your reply CS2. I only get that screen when I process the message queue. I'm running 2.10.11. Is there anything I can send you to help get to the bottom of this?

[lauraabc]

your email counter is super!

[RiTz21]

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.

I installed this in my 2.10.19 version - works great - THANK YOU!!

RiTz21