Draft Notification Plugin for WordPress

HI,

I have to admit that I don’t know anything about scripts, In our blog, there is five administrators (same level). How can ths script be modified to make sure the alert is sent to only one recipient (myself) ?
Thanks in advance for your reply.

P.-S. Sorry for the bad English.

I added some additional code to email all editors (in my case all users with a user-level 7 and above) when there is a post pending. Hope this helps.

<?php
/*
Plugin Name: Draft Notification
Plugin URI: http://www.dagondesign.com/articles/draft-notification-plugin-for-wordpress/
Description: Sends an email to the site admin when a draft is saved.
Author: Dagon Design
Version: 1.21
Author URI: http://www.dagondesign.com
*/


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 == "pending") {

		$message = "";
		$message .= "A draft was 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') . "'";

		$editors = $wpdb->get_results("SELECT user_id FROM {$tp}usermeta WHERE {$tp}usermeta.meta_value >= 7");
		
		$recipient = "";
	
			foreach ($editors as $editor) {			

				$user_info = get_userdata($editor);
				$recipient .= $user_info->user_email . ',';
			}

		mail($recipient, $subject, $message);

	}

}


add_action('save_post', 'dddn_process');

?>

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');
}
?>

I have installed the above plug in; how do I enable it?
Thansk

How could the $recipient line be changed so that one (or more ) static e-mail addresses could be entered? Something like this?

$recipient = echo "jon@mail.com, mary@mail.com";

Unfortunately the author mod didn’t work for me…

Rather than sending automatically upon save (or auto-save), would love to see a checkbox option in the editor to send notification. Also, I agree that it should be possible to customize the destination email (in my case I’d want it to be sent to a mailing list address for editors). And I agree that the link in the email should go to the back-end, not to a public page.

Great plugin, but with the Wordpress 2.1 it gets a little annoying as a message is sent everytime the system does an autosave. I hope there is a way around to having the message delivered ONLY when the save draft is pressed, I wonder how but just an idea

Thank you very much for the plugin.
It is exactly what I needed at http://www.newrss.net

Please feel free to stop by and make a post about it. I’m sure there are others who could benefit from this plugin.

Again, thanks! This is a great plugin.

What a cool idea! This was exactly what I was looking for.

Is there a way to edit the list of recipients? I don’t want the admins to get the emails, but rather a list of editors who will proof and publish the post.

Ok. Forget about this. There was a problem on my server side.
It’s all fixed and it works great now!
Just one little remark: the link we receive in the email can not be valid until the draft hasn’t been published. The page doesn’t exist.
It would make more sense to link to the admin. Something like: /wp-admin/post.php?action=edit&post=$post_id.