Draft Notification Plugin for WordPress

thank! it works now. i tried to inform the author /and/ the admin this wat:

$admin = get_bloginfo(‘admin_email’);
$poster = get_the_author_email();

mail($admin, $subject, $message);
mail($poster, $subject, $message);

but i end up with both emails going to the admin – do you see the problem?

PAT

hi, could you make it compatible with vesion wordpress 2.5? it seems the db structure canged and the query is not working anymore..

Great plugin!! Thanks for making it available.

In case anyone else wants to be notified upon “Pending Review” instead of Draft (with the introduction of Pending Review in 2.3), it’s easy to do. Just change the line that says:

if ($result->post_status == “draft”)

to

if ($result->post_status == “pending”)

and it seems to work great.

-Josh

Oops! I just saw the change log that says this now works with Wordpress 2.2. However, has anyone tried this with Wordpress MU?

hi,
I’ve slightly modified your handy plugin. I’ve add an administration menu, where admins can choose, which users will get notifications. Here’s the code:

<?php

function dddn_menu () {
  add_options_page('Notifikation', 'Notifikation', 8, basename(__FILE__), 'dddn_options_page');
}
function dddn_options_page() {
  global $wpdb;

  // get all users
  $tp = $wpdb->prefix;
	$users = $wpdb->get_results("
		SELECT ID, user_login
    FROM {$tp}users    
	");
  if ($_POST['hidden_field']==='Y') { // form processing
    $notify= $_POST['notify'];  
    for ($j=0; $j < count($users); $j++) {
      if ($notify[$j] != get_usermeta($users[$j]->ID,'notify') ) {
        update_usermeta($users[$j]->ID,'notify',$notify[$j]);
        $output.=$users[$j]->user_login."<br />\n";
      }
    }
    if ($output) {
      ?>
      <div class="updated"><h3>Updated users:</h3><p><strong><?php echo $output; ?></strong></p></div>
      <?php
    }
  }
  // form	
  ?>  
  <div class="wrap">
    <h2>Notifikation</h2>
    <p>Sends an email to selected users when a draft is saved.
    </p>
    <form name="form1" method="post" action="<?php echo str_replace( '%7E', '~', $_SERVER['REQUEST_URI']); ?>">
      <input type="hidden" name="hidden_field" value="Y">
      <p><?php 
        $i=0;
        foreach ($users as $user) {  
          if (get_usermeta($user->ID,"notify")) $checked.=" checked=\"checked\" ";
          echo "<input type=\"checkbox\" name=\"notify[$i]\" value=\"1\" id=\"notify[$i]\" $checked>&nbsp;";
          echo "<label for=\"notify[$i]\" >{$user->user_login}</label><br />\n";
          unset($checked);
          $i++;
        }    
      
        ?> 
      </p><hr />
      <p class="submit">
        <input type="submit" name="Submit" value="<?php _e('Update Options') ?>" />
      </p>
    </form>
  </div>
  <?php
} // dddn_options_page

function dddn_process($id) {

	global $wpdb;
	
	$tp = $wpdb->prefix;

	$result = $wpdb->get_row("
		SELECT post_status, post_title, user_login, user_nicename, display_name 
		FROM {$tp}posts, {$tp}users 
		WHERE {$tp}posts.post_author = {$tp}users.ID 
		AND {$tp}posts.ID = '$id'
	");

	if ($result->post_status == "draft") {

		$message = "";
		$message .= "Draft updated on '" . get_bloginfo('name') . "'\n\n";
		$message .= "Title: " . $result->post_title . "\n\n";

	
		// *** Choose one of the following options to show the author's name
	
		$message .= "Author: " . $result->display_name . "\n\n";
		// $message .= "Author: " . $result->user_nicename . "\n\n";
		// $message .= "Author: " . $result->user_login . "\n\n";



		$message .= "Link: " . get_permalink($id);

		$subject = "Draft updated on '" . get_bloginfo('name') . "'";

		// get recipients from db
    $recipients = $wpdb->get_results("
		  SELECT {$tp}users.user_email 
      FROM {$tp}users, {$tp}usermeta
      WHERE {$tp}users.ID={$tp}usermeta.user_id
      AND {$tp}usermeta.meta_key= 'notify' AND {$tp}usermeta.meta_value= '1' 
	  ");
	  // send mails
	  foreach ($recipients as $recipient) {
		  mail($recipient, $subject, $message);
    }
	}

}

if (function_exists('add_action')) {
  add_action('save_post', 'dddn_process');
  add_action('admin_menu', 'dddn_menu');
}
?>