You appear to be a bot. Output may be restricted

Description

Execute changes made in WordPress 2.3.

Usage

upgrade_230();

Parameters

Returns

void

Source

File name: wordpress/wp-admin/includes/upgrade.php
Lines:

  if ( $wp_current_db_version < 4772 ) {
    // Obsolete linkcategories table.
    $wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'linkcategories' );
  }

  // Recalculate all counts.
  $terms = $wpdb->get_results( "SELECT term_taxonomy_id, taxonomy FROM $wpdb->term_taxonomy" );
  foreach ( (array) $terms as $term ) {
    if ( 'post_tag' === $term->taxonomy || 'category' === $term->taxonomy ) {
      $count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status = 'publish' AND post_type = 'post' AND term_taxonomy_id = %d", $term->term_taxonomy_id ) );
    } else {
      $count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d", $term->term_taxonomy_id ) );
    }
    $wpdb->update( $wpdb->term_taxonomy, array( 'count' => $count ), array( 'term_taxonomy_id' => $term->term_taxonomy_id ) );
  }
}
 

 View on GitHub View on Trac