Changeset 11878 for trunk/wp-includes/functions.php

Timestamp:

08/25/2009 10:05:15 PM (17 years ago)

Author:

westi

Message:

Move the storage of the metadata for trashed posts into the post meta table rather than storing it in an option. See #4529.

File:

• trunk/wp-includes/functions.php (modified) (2 diffs)

trunk/wp-includes/functions.php

@@ -3347 +3347 @@
  */
 function wp_scheduled_delete() {
+        global $wpdb;
+
+        $delete_timestamp = time() - (60*60*24*EMPTY_TRASH_DAYS);
+        
+        $posts_to_delete = $wpdb->get_results($wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE meta_key = '_wp_trash_meta_time' AND meta_value < '%d'", $delete_timestamp), ARRAY_A);
+        
+        foreach ( (array) $posts_to_delete as $post ) {
+                wp_delete_post($post['post_id']);
+        }
+
+        //Trashed Comments
+        //TODO Come up with a better store for the comment trash meta. 
         $trash_meta = get_option('wp_trash_meta');
         if ( !is_array($trash_meta) )
                 return;
-
-        $delete_timestamp = time() - (60*60*24*EMPTY_TRASH_DAYS);
 
         foreach ( (array) $trash_meta['comments'] as $id => $meta ) {
@@ -3359 +3369 @@
                 }
         }
-        foreach ( (array) $trash_meta['posts'] as $id => $meta ) {
-                if ( $meta['time'] < $delete_timestamp ) {
-                        wp_delete_post($id);
-                        unset($trash_meta['posts'][$id]);
-                }
-        }
 
         update_option('wp_trash_meta', $trash_meta);
 }
+?>