wppaste
WordPress

upgrade_130()

Since
1.5.0
Source
wp-admin/includes/upgrade.php:1053
Execute changes made in WordPress 1.5.

Compatibility

WordPress
since 1.5.0
PHP
7.4–8.6-dev
  • 6.7.7
  • 6.8.8
  • 6.9.7
  • 7.0.4
  • 7.1.0

Present in every tracked release (6.7.7 to 7.1.0), and compiles on PHP 7.4 through 8.6-dev.

Performance profile

How much work a call to upgrade_130() does, and what it touches: the algorithmic scaling, the Zend instruction count per call across PHP versions, the hooks it hands control to, and the core code that calls it. Measured from the compiled opcodes, not a stopwatch, so every number is identical on any machine running the same PHP version, and every function in core is ranked by cost.

Cost class
Heavy

Reaches the database via ->get_results().

Scaling
Scales with input

The body loops, so the work grows with how much data it finds.

Instructions
79–99

Executed per call on PHP 8.5, depending on the branch taken. The body compiles to 239.

Plugin surface
None

Nothing here hands control to plugin code.

Called by
1

1 place in core call this, so the cost is paid more often than your own code shows.

What it touches

  • optionoption read or writeupdate_option()called directly
  • sqldatabase query->get_results()called directly
  • querycontent queryget_post()one call below upgrade_130()
  • hookthird-party callbacksapply_filters()one call below upgrade_130()
  • serializeserialisationmaybe_unserialize()one call below upgrade_130()
  • cacheobject cachewp_cache_get()one call below upgrade_130()

Further down the call graph this can also reach transient. That is the worst case, several calls deep and usually down an error path, not what a normal call pays.

What one call costs · 2 distinct outcomes

One number would be a lie: the work depends on which branch runs. These are every distinct cost upgrade_130() can have, taken from its control-flow graph on PHP 8.5.

WhenInstructionsCalls it makes
is_array($active_plugins)79–89->get_results(), ->get_results(), ->get_results(), __get_option(), ->query(), ->query(), ->query(), ->query(), ->query(), ->query(), ->get_results(), make_site_theme()
!is_array($active_plugins)89–99->get_results(), ->get_results(), ->get_results(), __get_option(), explode(), update_option(), ->query(), ->query(), ->query(), ->query(), ->query(), ->query(), ->get_results(), make_site_theme()

Across PHP versions

PHPCompiledExecutedBranchesNotes
8.6-dev23979–9915
8.523979–9915
8.423979–99155 fewer instructions than PHP 8.3
8.324479–10115
8.224479–10115
8.124479–10115
7.424479–10115

An instruction is not a fixed amount of time, so a matching count is not necessarily the same speed; what it rules out is a difference in the work itself.

Uses · 5

Used by · 1

  • upgrade_all()Functions to be called in installation and upgrade scripts.

Source code

View on Trac View on GitHub 

function upgrade_130() {	global $wpdb; 	// Remove extraneous backslashes.	$posts = $wpdb->get_results( "SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM $wpdb->posts" );	if ( $posts ) {		foreach ( $posts as $post ) {			$post_content = addslashes( deslash( $post->post_content ) );			$post_title   = addslashes( deslash( $post->post_title ) );			$post_excerpt = addslashes( deslash( $post->post_excerpt ) );			if ( empty( $post->guid ) ) {				$guid = get_permalink( $post->ID );			} else {				$guid = $post->guid;			} 			$wpdb->update( $wpdb->posts, compact( 'post_title', 'post_content', 'post_excerpt', 'guid' ), array( 'ID' => $post->ID ) ); 		}	} 	// Remove extraneous backslashes.	$comments = $wpdb->get_results( "SELECT comment_ID, comment_author, comment_content FROM $wpdb->comments" );	if ( $comments ) {		foreach ( $comments as $comment ) {			$comment_content = deslash( $comment->comment_content );			$comment_author  = deslash( $comment->comment_author ); 			$wpdb->update( $wpdb->comments, compact( 'comment_content', 'comment_author' ), array( 'comment_ID' => $comment->comment_ID ) );		}	} 	// Remove extraneous backslashes.	$links = $wpdb->get_results( "SELECT link_id, link_name, link_description FROM $wpdb->links" );	if ( $links ) {		foreach ( $links as $link ) {			$link_name        = deslash( $link->link_name );			$link_description = deslash( $link->link_description ); 			$wpdb->update( $wpdb->links, compact( 'link_name', 'link_description' ), array( 'link_id' => $link->link_id ) );		}	} 	$active_plugins = __get_option( 'active_plugins' ); 	/*	 * If plugins are not stored in an array, they're stored in the old	 * newline separated format. Convert to new format.	 */	if ( ! is_array( $active_plugins ) ) {		$active_plugins = explode( "\n", trim( $active_plugins ) );		update_option( 'active_plugins', $active_plugins );	} 	// Obsolete tables.	$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optionvalues' );	$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiontypes' );	$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiongroups' );	$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'optiongroup_options' ); 	// Update comments table to use comment_type.	$wpdb->query( "UPDATE $wpdb->comments SET comment_type='trackback', comment_content = REPLACE(comment_content, '<trackback />', '') WHERE comment_content LIKE '<trackback />%'" );	$wpdb->query( "UPDATE $wpdb->comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '<pingback />', '') WHERE comment_content LIKE '<pingback />%'" ); 	// Some versions have multiple duplicate option_name rows with the same values.	$options = $wpdb->get_results( "SELECT option_name, COUNT(option_name) AS dupes FROM `$wpdb->options` GROUP BY option_name" );	foreach ( $options as $option ) {		if ( $option->dupes > 1 ) { // Could this be done in the query?			$limit    = $option->dupes - 1;			$dupe_ids = $wpdb->get_col( $wpdb->prepare( "SELECT option_id FROM $wpdb->options WHERE option_name = %s LIMIT %d", $option->option_name, $limit ) );			if ( $dupe_ids ) {				$dupe_ids = implode( ',', $dupe_ids );				$wpdb->query( "DELETE FROM $wpdb->options WHERE option_id IN ($dupe_ids)" );			}		}	} 	make_site_theme();}

Changelog

Introduced in 1.5.0. Unchanged from 6.7.7 through 7.1.0.

  1. 6.7.7
  2. 6.8.8
  3. 6.9.7
  4. 7.0.4
  5. 7.1.0

Signature, return type and hooks compared across 5 parsed releases.

About this page

Parsed data
Generated from the wordpress-develop 7.1.0 tag, from src/wp-admin/includes/upgrade.php, and regenerated for each WordPress release so it tracks the code rather than a snapshot of it.
Corrections
Something wrong on this page? Report it and it gets fixed in the next regeneration.