<?php
/*
Plugin Name: End of Queue Alert
Plugin URI: http://www.commafruit.co.uk/projects/wordpress-end-of-queue-plugin/
Description: Whenever a new post is made, checks the current queue, and if there’s nothing there (i.e. if you’re at the end of the queue), it emails the admin to let them know.
Author: Ben Parsons
Version: 0.1
Author URI: http://www.commafruit.co.uk/
*/


function eoq($id) {

	global $wpdb;
	
	$tp = $wpdb->prefix;
	
	$count = $wpdb->get_row("SELECT COUNT(*) AS total FROM {$tp}posts WHERE post_date > '" . current_time(mysql) . "'");

    $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'
	");

		$message = "";
		$message .= "A post was just published on '" . get_bloginfo('name') . "'\n\n";
		$message .= "Title: " . $result->post_title . "\n";
        $message .= "Author: " . $result->display_name . "\n";
        $message .= "Link: " . get_permalink($id) . "\n\n";
        
        /* Choose one of the options below: */
        $message .= "Number of posts in the queue: " . $count->total;
        //$message .= "As a result, there are  " . $count->total . " posts remaining.";

		$subject = "Blog: '" . get_bloginfo('name') . "' has run out of content";

		$recipient = get_bloginfo('admin_email');

        if ($count->total < 1) // if there are no more posts in the queue
        {
		    mail($recipient, $subject, $message);
		}


}


add_action('publish_post', 'eoq');

?>