$site, 'key' => $key, ); } return null; } } abstract class Wp360_Database_Cleaner_Task_Transients extends Wp360_Database_Cleaner_Task_Base { /** Nur abgelaufene Transients? */ abstract protected function expired_only(); /** * Auf Multisite liegen Site-Transients im Netzwerk (sitemeta), nicht in der * Optionstabelle dieser Website: dort wird nur der normale Transient bereinigt. * * @return array Paare aus Praefix und Praefix der Ablaufzeile. */ private function kinds() { $kinds = array( array( '_transient_', '_transient_timeout_' ) ); if ( ! is_multisite() ) { $kinds[] = array( '_site_transient_', '_site_transient_timeout_' ); } return $kinds; } /** * Anzahl und Groesse der Eintraege einer Art. Die Abfragen stehen * ausgeschrieben da (kein zusammengesetztes SQL), damit nur Platzhalter und * feste Tabellennamen im Text vorkommen. BINARY: die Namen muessen in genau * dieser Schreibweise beginnen, sonst waere eine Zeile gezaehlt, die sich * nicht loeschen laesst. * * @param string $prefix Praefix des Transients. * @param string $timeout_prefix Praefix der Ablaufzeile. * @return object|null Zeile mit item_count und bytes. */ private function stats( $prefix, $timeout_prefix ) { global $wpdb; $like = $wpdb->esc_like( $prefix ) . '%'; $timeout_like = $wpdb->esc_like( $timeout_prefix ) . '%'; if ( $this->expired_only() ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Zaehlen der Eintraege; ein Cache wuerde die Vorschau verfaelschen. return $wpdb->get_row( $wpdb->prepare( "SELECT COUNT(*) AS item_count, COALESCE( SUM( LENGTH( a.option_value ) ), 0 ) AS bytes FROM {$wpdb->options} a INNER JOIN {$wpdb->options} b ON b.option_name = CONCAT( %s, SUBSTRING( a.option_name, %d ) ) WHERE a.option_name LIKE BINARY %s AND a.option_name NOT LIKE BINARY %s AND b.option_value < %d", $timeout_prefix, strlen( $prefix ) + 1, $like, $timeout_like, time() ) ); } // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Zaehlen der Eintraege; ein Cache wuerde die Vorschau verfaelschen. return $wpdb->get_row( $wpdb->prepare( "SELECT COUNT(*) AS item_count, COALESCE( SUM( LENGTH( a.option_value ) ), 0 ) AS bytes FROM {$wpdb->options} a WHERE a.option_name LIKE BINARY %s AND a.option_name NOT LIKE BINARY %s", $like, $timeout_like ) ); } /** * Namen der naechsten zu loeschenden Eintraege einer Art (dieselbe Auswahl wie stats()). * * @param string $prefix Praefix des Transients. * @param string $timeout_prefix Praefix der Ablaufzeile. * @param int $limit Hoechstzahl. * @return string[] */ private function names( $prefix, $timeout_prefix, $limit ) { global $wpdb; $like = $wpdb->esc_like( $prefix ) . '%'; $timeout_like = $wpdb->esc_like( $timeout_prefix ) . '%'; if ( $this->expired_only() ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Auswahl der zu loeschenden Namen; geloescht wird danach ueber die Kernfunktionen. return (array) $wpdb->get_col( $wpdb->prepare( "SELECT a.option_name FROM {$wpdb->options} a INNER JOIN {$wpdb->options} b ON b.option_name = CONCAT( %s, SUBSTRING( a.option_name, %d ) ) WHERE a.option_name LIKE BINARY %s AND a.option_name NOT LIKE BINARY %s AND b.option_value < %d ORDER BY a.option_name ASC LIMIT %d", $timeout_prefix, strlen( $prefix ) + 1, $like, $timeout_like, time(), $limit ) ); } // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Auswahl der zu loeschenden Namen; geloescht wird danach ueber die Kernfunktionen. return (array) $wpdb->get_col( $wpdb->prepare( "SELECT a.option_name FROM {$wpdb->options} a WHERE a.option_name LIKE BINARY %s AND a.option_name NOT LIKE BINARY %s ORDER BY a.option_name ASC LIMIT %d", $like, $timeout_like, $limit ) ); } public function preview() { if ( wp_using_ext_object_cache() ) { return array( 'count' => 0, 'bytes' => 0, 'note' => 'object_cache', ); } $count = 0; $bytes = 0; foreach ( $this->kinds() as $kind ) { $row = $this->stats( $kind[0], $kind[1] ); if ( $row ) { $count += (int) $row->item_count; $bytes += (int) $row->bytes; } } return array( 'count' => $count, 'bytes' => $bytes, 'note' => '', ); } public function run_batch( $limit ) { if ( wp_using_ext_object_cache() ) { return 0; } $deleted = 0; foreach ( $this->kinds() as $kind ) { $room = $limit - $deleted; if ( $room < 1 ) { break; } foreach ( $this->names( $kind[0], $kind[1], $room ) as $name ) { $parsed = Wp360_Database_Cleaner_Transient_Names::parse( $name ); if ( null === $parsed ) { // Ein Name wie "_transient_" ohne Schluessel: ueber die Kernfunktionen nicht erreichbar. $done = delete_option( $name ); } else { $done = $parsed['site'] ? delete_site_transient( $parsed['key'] ) : delete_transient( $parsed['key'] ); } if ( $done ) { ++$deleted; } } } return $deleted; } } class Wp360_Database_Cleaner_Task_Expired_Transients extends Wp360_Database_Cleaner_Task_Transients { protected function expired_only() { return true; } public function slug() { return 'transients_expired'; } public function label() { return __( 'Expired transients', '360-orbit-database-cleaner' ); } public function description() { return __( 'Transients are temporary cached values. When they expire, WordPress should remove them, but this often does not happen when the scheduled tasks are not running. Only entries that have already expired are removed.', '360-orbit-database-cleaner' ); } } class Wp360_Database_Cleaner_Task_All_Transients extends Wp360_Database_Cleaner_Task_Transients { protected function expired_only() { return false; } public function slug() { return 'transients_all'; } public function label() { return __( 'All transients', '360-orbit-database-cleaner' ); } public function description() { return __( 'Removes every transient, including the ones that are still valid and those that never expire. They are rebuilt automatically when needed, so the first page views afterwards can be a little slower.', '360-orbit-database-cleaner' ); } }