Nummer => Groesse in Byte. */ private function candidates() { global $wpdb; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Auswahl der Revisionen; ein Cache wuerde die Vorschau verfaelschen. $found = $wpdb->get_results( $wpdb->prepare( "SELECT ID AS id, post_parent AS parent, post_modified_gmt AS modified, LENGTH( post_content ) AS size FROM {$wpdb->posts} WHERE post_type = %s", 'revision' ) ); $rows = array(); $sizes = array(); foreach ( (array) $found as $row ) { $time = strtotime( $row->modified . ' UTC' ); $rows[] = array( 'id' => (int) $row->id, 'parent' => (int) $row->parent, 'time' => false === $time ? 0 : $time, ); $sizes[ (int) $row->id ] = (int) $row->size; } $settings = Wp360_Database_Cleaner_Settings::get(); $cutoff = time() - $settings['revision_days'] * DAY_IN_SECONDS; $out = array(); foreach ( Wp360_Database_Cleaner_Revision_Retention::select( $rows, $settings['revision_keep'], $cutoff ) as $id ) { $out[ $id ] = $sizes[ $id ]; } return $out; } public function preview() { $candidates = $this->candidates(); return array( 'count' => count( $candidates ), 'bytes' => array_sum( $candidates ), 'note' => '', ); } public function run_batch( $limit ) { // Einmal pro Lauf berechnen: bei vielen Revisionen wuerde jede neue // Berechnung pro Stapel die ganze Liste erneut lesen. if ( null === $this->queue ) { $this->queue = array_keys( $this->candidates() ); } $deleted = 0; foreach ( array_splice( $this->queue, 0, $limit ) as $id ) { if ( wp_delete_post_revision( $id ) ) { ++$deleted; } } return $deleted; } }