function post_notification_set_next_send()
{
global $wpdb;
$t_emails = $wpdb->prefix . 'post_notification_emails';
//This is not the ideal place, but quite ok.
update_option('post_notification_subscribers', $wpdb->get_var("SELECT COUNT(*) FROM {$t_emails} WHERE gets_mail = 1"));
$d_next = post_notification_mysql2gmdate($wpdb->get_var("SELECT MIN(GREATEST(post_date_gmt, date_saved)) " . post_notification_sql_posts_to_send(true)));
if ($d_next) {
//We do have somthing to send
$nervous = $d_next + get_option('post_notification_nervous');
//There is no other way :-(
$nextsend = get_option('post_notification_lastsend') + get_option('post_notification_pause');
$d_next = max($nextsend, $nervous);
update_option('post_notification_nextsend', $d_next);
} else {
//There are no post with unsent mail.
update_option('post_notification_nextsend', -1);
}
}
function post_notification_send()
{
global $wpdb, $timestart;
if (get_option('post_notification_lock') == 'db') {
if (!$wpdb->get_var("SELECT GET_LOCK('" . $wpdb->prefix . 'post_notification_lock' . "', 0)")) {
return;
}
} else {
$mutex = @fopen(POST_NOTIFICATION_PATH . '_temp/post_notification.lock', 'w');
if (!$mutex || !flock($mutex, LOCK_EX | LOCK_NB, $eWouldBlock) || $eWouldBlock) {
// There is already someone mailing.
@fclose($mutex);
return;
}
}
//Make sure plugins don't think we're a page or something....
$GLOBALS['wp_query']->init_query_flags();
ignore_user_abort(true);
//Let's get this done....
//some general stuff
$t_emails = $wpdb->prefix . 'post_notification_emails';
$t_posts = $wpdb->prefix . 'post_notification_posts';
$t_cats = $wpdb->prefix . 'post_notification_cats';
$posts = $wpdb->get_results("SELECT id, notification_sent " . post_notification_sql_posts_to_send());
if (!$posts) {
//This shouldn't happen, but never mind.
post_notification_set_next_send();
return;
//Nothing to do.
}
//Include user functions, if they exist.
//We don't want an error if the file does not exist.
if (file_exists(POST_NOTIFICATION_PATH . 'userfunctions.php')) {
include_once POST_NOTIFICATION_PATH . 'userfunctions.php';
}
// Mail out mails
$maxsend = get_option('post_notification_maxsend');
$mailssent = -1;
$endtime = ini_get('max_execution_time');
if ($endtime != 0) {
$endtime += floor($timestart) - 5;
//Make shure we will have a least 5 sek left.
}
$time_remain = 1;
foreach ($posts as $post) {
if (get_option('post_notification_debug') == 'yes') {
echo '<hr />Sending post: ' . $post->id . '<br />';
}
//Find the categories
if (get_option('db_version') < 6124) {
$cats = $wpdb->get_results("SELECT category_id FROM " . $wpdb->post2cat . " WHERE post_id = " . $post->id);
} else {
$cats = $wpdb->get_results("SELECT term_id \r\n\t\t\t\t\t\t\t\t\t\tFROM " . $wpdb->term_relationships . " \r\n\t\t\t\t\t\t\t\t\t\tJOIN " . $wpdb->term_taxonomy . " USING (term_taxonomy_id)\r\n\t\t\t\t\t\t\t\t\t\tWHERE taxonomy = 'category' AND object_id = " . $post->id);
}
$cat_ids = array();
foreach ($cats as $cat) {
if (get_option('db_version') < 6124) {
$last_cat = $cat->category_id;
} else {
$last_cat = $cat->term_id;
}
while ($last_cat != 0) {
$cat_ids[] = (string) $last_cat;
if (get_option('db_version') < 6124) {
$last_cat = $wpdb->get_var("SELECT category_parent FROM " . $wpdb->categories . " WHERE cat_ID = {$last_cat}");
} else {
$last_cat = $wpdb->get_var("SELECT parent FROM " . $wpdb->term_taxonomy . " \r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE term_id = {$last_cat} AND taxonomy = 'category'");
}
}
}
$cat_ids[] = (string) $last_cat;
$cat_ids = implode(", ", $cat_ids);
//convert to string
if (get_option('post_notification_debug') == 'yes') {
echo 'The cat-Ids are: ' . $cat_ids . '<br />';
}
// Get the Emailadds
$emails = $wpdb->get_results(" SELECT e.email_addr, e.id, e.act_code" . " FROM {$t_emails} e, {$t_cats} c " . " WHERE c.cat_id IN ({$cat_ids}) AND c.id = e.id AND e.gets_mail = 1 AND e.id >= " . $post->notification_sent . " GROUP BY e.id " . " ORDER BY e.id ASC");
//We need this. Otherwise we can't be shure whether we already have sent mail.
if (get_option('post_notification_debug') == 'yes') {
echo count($emails) . ' Emails were found.<br />';
}
if ($emails) {
//Check wheater ther are any mails to send anything.
//Get Data
$maildata = post_notification_create_email($post->id);
foreach ($emails as $email) {
if (get_option('post_notification_debug') == 'yes') {
echo 'Sending mail to: ' . $email->email_addr . '<br />';
}
if ($endtime != 0) {
//if this is 0 we have as much time as we want.
$time_remain = $endtime - time();
}
if ($maxsend < 1 || $time_remain < 0) {
//Are we allowed to send any more mails?
$mailssent = $email->id;
//Save where we stoped
break;
}
post_notification_sendmail($maildata, $email->email_addr, $email->act_code);
$maxsend--;
}
}
// Update notification_sent to -1 (We're done)
$wpdb->query(" UPDATE {$t_posts} " . " SET " . " notification_sent = " . $mailssent . " WHERE post_id = " . $post->id);
if ($maxsend < 1) {
break;
}
//We dont need to go on, if there's nothing to send.
}
update_option('post_notification_lastsend', time());
post_notification_set_next_send();
if (get_option('post_notification_lock') == 'db') {
$wpdb->query("SELECT RELEASE_LOCK('" . $wpdb->prefix . 'post_notification_lock' . "')");
} else {
flock($mutex, LOCK_UN);
fclose($mutex);
}
}
function post_notification_admin_sub()
{
global $wpdb;
$t_posts = $wpdb->prefix . 'post_notification_posts';
$t_cats = $wpdb->prefix . 'post_notification_cats';
$t_emails = $wpdb->prefix . 'post_notification_emails';
$datestr = get_settings('date_format') . ' ' . get_settings('time_format');
//Run the install
require_once POST_NOTIFICATION_PATH . 'install.php';
post_notification_install();
//Check for problems
$mutex = @fopen(POST_NOTIFICATION_PATH . '_temp/post_notification.lock', 'w');
if ($mutex == false) {
echo '<div class="error">' . __('Couldn\'t create File:', 'post_notification') . ' ' . POST_NOTIFICATION_PATH . '_temp/post_notification.lock<br />' . __('Please assure the the path is writeable.', 'post_notification') . ' ' . __('This is an error!', 'post_notification') . '</div>';
} else {
fclose($mutex);
}
if (!function_exists('iconv')) {
echo '<div class="error">' . __('PHP was compiled without iconv-libs. This might cause severe trouble using UTF-8 with special chars or umlauts.', 'post_notification') . ' ' . __('Most hosters support this, as it is a sensible php-extension.', 'post_notification') . ' ' . '<a href="http://php.net/manual/ref.iconv.php">' . __('More information.', 'post_notification') . '</a></div>';
}
if (!function_exists('mb_detect_encoding')) {
echo '<div class="error">' . __('This version of PHP does not support the function mb_detect_encoding. You might experience some trouble with non-ASCII characters.', 'post_notification') . ' ' . __('Most hosters support this, as it is a sensible php-extension.', 'post_notification') . ' ' . '<a href="http://php.net/manual/ref.mbstring.php">' . __('More information.', 'post_notification') . '</a></div>';
}
if (!function_exists('html_entity_decode')) {
echo '<div class="error">' . __('This version of PHP does not support the function html_entity_decode. Sending out text mails will not be possible.', 'post_notification') . ' ' . __('Please contact your hoster.', 'post_notification') . '</a></div>';
}
if ('' != ($dest = post_notification_installtheme())) {
echo '<div class="error">' . __('Couldn\'t create File:', 'post_notification') . $dest . ' ' . __('Please assure the the path is writeable.', 'post_notification') . ' ' . __('You can also copy the file from the plugin directory manually.', 'post_notification') . '</div>';
}
if (get_option('post_notification_debug') == 'yes') {
echo '<div class="error">' . __('PN is in debugging mode. This should only be on, if something isn\'t working correctly.', 'post_notification') . '</div>';
}
if (get_option('post_notification_uninstall') == 'yes') {
require_once POST_NOTIFICATION_PATH . "install.php";
echo '<div class="error">' . __('It seems like you want to uninstall this Plugin. Please deactivate it or change the setting the options. ', 'post_notification') . '</div>';
} else {
if ($wpdb->get_var("SHOW TABLES LIKE '{$t_cats}'") == NULL) {
echo '<div class="error">' . __('It seems like there is some trouble creating the tables in the DB. If you\'re lucky there should be some errormessages on this page.', 'post_notification') . '</div>';
}
}
if (ini_get('max_execution_time') != 0 && ini_get('max_execution_time') < 15) {
echo '<div class="error">' . __('The maximum executiontime is very low.', 'post_notification') . ' ' . '<a href="http://php.net/manual/ref.info.php#ini.max-execution-time">' . __('More information.', 'post_notification') . '</a></div>';
}
if (get_option('db_version') > 4772 && get_option('db_version') < 6124 && substr(get_option('post_notification_template'), -5) == '.html') {
echo '<div class="error">' . __('There is a bug in WP handling HTML-Mails. Please make sure a mail-plugin is installed.', 'post_notification') . ' <a href="http://wordpress.org/extend/plugins/wordpress-22-mailfix/">Wordpress 2.2 Mailfix</a> </div>';
}
//clean up - just in case.
//Probably there's something with better performance, but as long there are not
// 10 000 emails in the db this shouldn't matter.
/* Not well enaugh tested -> Next version
$wpdb->query(" DELETE $t_cats, t_emails
FROM $t_cats LEFT JOIN t_emails
WHERE email_addr IS NULL ");
*/
//Try to send.
if (get_option('post_notification_debug') == 'yes') {
post_notification_send_check(true);
}
//------------ Some info.....
$nummails = $wpdb->get_var("SELECT COUNT(*) FROM {$t_emails} WHERE gets_mail = 1");
echo '<p>' . __('Number of Subscribers:', 'post_notification') . "<b> {$nummails} </b></p>";
//------------ Some advertising ----
if ($nummails > 500) {
echo '<p><b>' . __('Looks like you are realy using this plugin.', 'post_notification') . '</b> <a href="http://pn.xn--strbe-mva.de/forum.php?req=thread&postid=8">' . __('What about a donation?.', 'post_notification') . '</a></p>';
}
echo '<p>' . __('The time is:', 'post_notification');
echo ' <b>' . post_notification_date_i18n_tz($datestr, time()) . '</b></p>';
//Can use i18n_time as it uses date
echo '<p>' . __('Posts to be notified.', 'post_notification');
$posts = $wpdb->get_results("SELECT id, post_title, post_date_gmt, notification_sent, post_status, date_saved " . post_notification_sql_posts_to_send(true) . " ORDER BY post_date_gmt DESC");
echo '<table>
<tr class="alternate"><th>' . __('Post-ID', 'post_notification') . '</th><th>' . __('Post title', 'post_notification') . '</th><th>' . __('Publish-date', 'post_notification') . '</th><th>' . __('Save-date', 'post_notification') . '</th><th>' . __('Last email-id', 'post_notification') . '</th></tr>';
if (empty($posts)) {
echo '<tr><td colspan="5" class="alternate">' . __('None queued', 'post_notification') . '</td></tr>';
} else {
foreach ($posts as $post) {
echo '<tr class="alternate"><td>' . $post->id . '</td><td>' . $post->post_title . '</td><td>' . post_notification_date_i18n_tz($datestr, post_notification_mysql2gmdate($post->post_date_gmt)) . '</td><td>' . post_notification_date_i18n_tz($datestr, post_notification_mysql2gmdate($post->date_saved)) . '</td><td>' . $post->notification_sent . '</td></tr>';
}
}
echo '</table></p>';
echo '<p>' . __('The next mail will be sent:', 'post_notification') . ' ';
if (get_option('post_notification_nextsend') == '-1') {
_e('None queued', 'post_notification');
} else {
echo post_notification_date_i18n_tz($datestr, get_option('post_notification_nextsend'));
}
echo '</p>';
echo '<p>' . __('The last mail was sent:', 'post_notification') . ' ';
echo post_notification_date_i18n_tz($datestr, get_option('post_notification_lastsend'));
echo '</p>';
echo '<p>' . __('The last post was saved:', 'post_notification') . ' ';
echo post_notification_date_i18n_tz($datestr, get_option('post_notification_lastpost'));
echo '</p>';
}
