Changeset 424635

Timestamp:

08/17/2011 05:12:27 AM (14 years ago)

Author:

tott

Message:

Adding functionality to validate scheduled posts jobs

Location:

wp-cron-control/trunk

Files:

• readme.txt (modified) (3 diffs)
• wp-cron-control.php (modified) (5 diffs)

wp-cron-control/trunk/readme.txt

@@ -1 +1 @@
 === WP-Cron Control ===
 Contributors: tott, automattic
-Tags: wp-cron, cron, cron jobs
+Tags: wp-cron, cron, cron jobs, post missed schedule, scheduled posts
 Donate link: http://hitchhackerguide.com
 Tested up to: 3.1.2
@@ -10 +10 @@
 == Description ==
 
-This plugin allows you to take control over the execution of cron jobs. It's mainly useful for sites that either don't get enough comments to ensure a frequent execution of wp-cron or for sites where the execution of cron via regular methods can cause race conditions resulting in multiple execution of wp-cron at the same time.
+This plugin allows you to take control over the execution of cron jobs. It's mainly useful for sites that either don't get enough comments to ensure a frequent execution of wp-cron or for sites where the execution of cron via regular methods can cause race conditions resulting in multiple execution of wp-cron at the same time. It can also help when you run into posts that missed their schedule.
 
 This plugin implements a secret parameter and ensures that cron jobs are only executed when this parameter is existing.
@@ -31 +31 @@
 == ChangeLog ==
 
+= Version 0.3 =
+
+* Added option to enable extra check that would search for missing jobs for scheduled posts and add them if necessary.
+
 = Version 0.2 =
 

wp-cron-control/trunk/wp-cron-control.php

@@ -5 +5 @@
  Description: get control over wp-cron execution.
  Author: Thorsten Ott, Automattic
- Version: 0.2
+ Version: 0.3
  Author URI: http://hitchhackerguide.com
  */
@@ -37 +37 @@
         $this->default_settings = (array) apply_filters( $this->plugin_prefix . 'default_settings', array(
             'enable'                => 1,
+            'enable_scheduled_post_validation' => 0,
             'secret_string'         => md5( __FILE__ . $blog_id ),
         ) );
@@ -43 +44 @@
             'enable'                => array( 'label' => 'Enable ' . $this->plugin_name, 'desc' => 'Enable this plugin and allow requests to wp-cron.php only with the appended secret parameter.', 'type' => 'yesno' ),
             'secret_string'         => array( 'label' => 'Secret string', 'desc' => 'The secret parameter that needs to be appended to wp-cron.php requests.', 'type' => 'text' ),
+            'enable_scheduled_post_validation'  => array( 'label' => 'Enable scheduled post validation', 'desc' => 'In some rare cases it can happen that even when running wp-cron via a scheduled system cron job posts miss their schedule. This feature makes sure that there is a scheduled event for each scheduled post.', 'type' => 'yesno' ),
         ) );
                     
@@ -204 +206 @@
                 
                 set_transient( 'doing_cron', $local_time );
+                
+                if ( 1 == self::instance()->settings['enable_scheduled_post_validation'] ) {
+                    $this->validate_scheduled_posts();
+                }
                 return true;
             }
@@ -217 +223 @@
             define( 'DISABLE_WP_CRON', true );
         return false;
+    }
+    
+    public function validate_scheduled_posts() {
+        global $wpdb;
+        $sql = $wpdb->prepare( "SELECT ID, post_date_gmt FROM $wpdb->posts WHERE post_status = 'future' " );
+        $results = $wpdb->get_results( $sql );
+        $return = true;
+
+        if ( empty( $results ) )
+            return true;
+
+        foreach ( $results as $r ) {
+
+            $gmt_time  = strtotime( $r->post_date_gmt . ' GMT' );
+            $timestamp = wp_next_scheduled( 'publish_future_post', array( (int) $r->ID ) );
+
+            if ( $timestamp === false ) {
+                wp_schedule_single_event( $gmt_time, 'publish_future_post', array( (int) $r->ID ) );
+                $return = false;
+            } else {
+                //update timestamp to adjust for daylights savings change, when necessary
+                if ( $timestamp != $gmt_time ) {
+                    wp_clear_scheduled_hook( 'publish_future_post', array( (int) $r->ID ) );
+                    wp_schedule_single_event( $gmt_time, 'publish_future_post', array( (int) $r->ID ) );
+
+                    $new_date = date( 'Y-m-d H:i:s', $gmt_time );
+                    $sql_u = $wpdb->prepare( "UPDATE $wpdb->posts SET post_date_gmt=%s WHERE ID=%d", $new_date, $r->ID );
+                    $wpdb->query( $sql_u );
+                    $return = false;
+                }
+            }
+        }
+        
+        return $return;
     }
 }