Changeset 25838
- Timestamp:
- 10/18/2013 07:47:44 AM (11 years ago)
- Location:
- trunk/src/wp-admin/includes
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/wp-admin/includes/schema.php
r25448 r25838 547 547 // delete obsolete magpie stuff 548 548 $wpdb->query("DELETE FROM $wpdb->options WHERE option_name REGEXP '^rss_[0-9a-f]{32}(_ts)?$'"); 549 // clear transient data 550 $wpdb->query( "DELETE FROM $wpdb->options WHERE option_name LIKE '\_transient\_%' OR option_name LIKE '\_site\_transient\_%'" ); 549 550 // Deletes all expired transients. 551 // The multi-table delete syntax is used to delete the transient record from table a, 552 // and the corresponding transient_timeout record from table b. 553 $time = time(); 554 $wpdb->query("DELETE a, b FROM $wpdb->options a, $wpdb->options b WHERE 555 a.option_name LIKE '\_transient\_%' AND 556 a.option_name NOT LIKE '\_transient\_timeout\_%' AND 557 b.option_name = CONCAT( '_transient_timeout_', SUBSTRING( a.option_name, 12 ) ) 558 AND b.option_value < $time"); 559 560 if ( is_main_site() && is_main_network() ) { 561 $wpdb->query("DELETE a, b FROM $wpdb->options a, $wpdb->options b WHERE 562 a.option_name LIKE '\_site\_transient\_%' AND 563 a.option_name NOT LIKE '\_site\_transient\_timeout\_%' AND 564 b.option_name = CONCAT( '_site_transient_timeout_', SUBSTRING( a.option_name, 17 ) ) 565 AND b.option_value < $time"); 566 } 551 567 } 552 568 -
trunk/src/wp-admin/includes/upgrade.php
r25825 r25838 1230 1230 function upgrade_network() { 1231 1231 global $wp_current_db_version, $wpdb; 1232 1233 // Always 1234 if ( is_main_network() ) { 1235 // Deletes all expired transients. 1236 // The multi-table delete syntax is used to delete the transient record from table a, 1237 // and the corresponding transient_timeout record from table b. 1238 $time = time(); 1239 $wpdb->query("DELETE a, b FROM $wpdb->sitemeta a, $wpdb->sitemeta b WHERE 1240 a.meta_key LIKE '\_site\_transient\_%' AND 1241 a.meta_key NOT LIKE '\_site\_transient\_timeout\_%' AND 1242 b.meta_key = CONCAT( '_site_transient_timeout_', SUBSTRING( a.meta_key, 17 ) ) 1243 AND b.meta_value < $time"); 1244 } 1245 1232 1246 // 2.8 1233 1247 if ( $wp_current_db_version < 11549 ) {
Note: See TracChangeset
for help on using the changeset viewer.