Topic: Successful emails per post?

[jschodde]

I need a way to indicate how many times a post was emailed. I found the get_emails_success() function and I can see the sql statement. I think I would create a new function based on this one, and modify the sql statement to search for the current post. Can anyone offer me a little help on how I would set up the sql statement? 

### Function: Get EMail Total Sent Success
if(!function_exists('get_emails_success')) {
   function get_emails_success($echo = true) {
      global $wpdb;
      $totalemails_success = $wpdb->get_var("SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Success', 'wp-email')."'");
      if($echo) {
         echo number_format_i18n($totalemails_success);
      } else {
         return number_format_i18n($totalemails_success);
      }
   }
}

[GaMerZ]

Code: [Select]

SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Success', 'wp-email')."' AND email_postid = 1"Where 1 is your post ID[/code]

[jschodde]

Code: [Select]

SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Success', 'wp-email')."' AND email_postid = 1"Where 1 is your post ID[/code]

Thanks Lester, I got it working. Here is the new function in case someone needs it. Let me know if you see anything wrong with it please:

Code: [Select]

### Function: Get EMail Total Sent Success by Post
if(!function_exists('get_emails_success_by_post')) {
function get_emails_success_by_post($echo = true) {
global $wpdb, $post;
$totalemails_success = $wpdb->get_var("SELECT COUNT(email_id) FROM $wpdb->email WHERE email_status = '".__('Success', 'wp-email')."' AND email_postid=$post->ID");
if($echo) {
echo number_format_i18n($totalemails_success);
} else {
return number_format_i18n($totalemails_success);
}
}
}

Usage:

Code: [Select]

<?php if (function_exists('get_emails_success_by_post')) { get_emails_success_by_post(); } ?><?php _e(' emails','cp'); ?>

This will display: "nnn emails", where nnn is the count.

Thanks,
Jeff

[GaMerZ]

Cool thanks =)