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

Timestamp:

08/25/2009 10:05:15 PM (15 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);
 }
+?>