upgrade_160()

Compatibility

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_160() 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

31–49

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

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

• sqldatabase query->get_results()called directly
• querycontent queryget_post()one call below upgrade_160()
• hookthird-party callbacksapply_filters()one call below upgrade_160()

Further down the call graph this can also reach serialize, cache, option and transient. Those are 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_160() can have, taken from its control-flow graph on PHP 8.5.

This body has more branch combinations than are worth enumerating, so the table covers the outcomes found first rather than every one that exists.

Uses · 7

• populate_roles_160()Create the roles for WordPress 2.0
• update_user_meta()Updates user meta field based on user ID.
• wp_slash()Adds slashes to a string or recursively adds slashes to strings within an array.
• get_user_meta()Retrieves user meta field for a user.
• translate_level_to_role()Translate user level to user role name.
• get_post_meta()Retrieves a post meta field for the given post ID.
• update_attached_file()Updates attachment file path based on attachment ID.

Used by · 1

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

Source code

View on Trac ↗View on GitHub ↗

1142function upgrade_160() {1143	global $wpdb, $wp_current_db_version;1144 1145	populate_roles_160();1146 1147	$users = $wpdb->get_results( "SELECT * FROM $wpdb->users" );1148	foreach ( $users as $user ) :1149		if ( ! empty( $user->user_firstname ) ) {1150			update_user_meta( $user->ID, 'first_name', wp_slash( $user->user_firstname ) );1151		}1152		if ( ! empty( $user->user_lastname ) ) {1153			update_user_meta( $user->ID, 'last_name', wp_slash( $user->user_lastname ) );1154		}1155		if ( ! empty( $user->user_nickname ) ) {1156			update_user_meta( $user->ID, 'nickname', wp_slash( $user->user_nickname ) );1157		}1158		if ( ! empty( $user->user_level ) ) {1159			update_user_meta( $user->ID, $wpdb->prefix . 'user_level', $user->user_level );1160		}1161		if ( ! empty( $user->user_icq ) ) {1162			update_user_meta( $user->ID, 'icq', wp_slash( $user->user_icq ) );1163		}1164		if ( ! empty( $user->user_aim ) ) {1165			update_user_meta( $user->ID, 'aim', wp_slash( $user->user_aim ) );1166		}1167		if ( ! empty( $user->user_msn ) ) {1168			update_user_meta( $user->ID, 'msn', wp_slash( $user->user_msn ) );1169		}1170		if ( ! empty( $user->user_yim ) ) {1171			update_user_meta( $user->ID, 'yim', wp_slash( $user->user_icq ) );1172		}1173		if ( ! empty( $user->user_description ) ) {1174			update_user_meta( $user->ID, 'description', wp_slash( $user->user_description ) );1175		}1176 1177		if ( isset( $user->user_idmode ) ) :1178			$idmode = $user->user_idmode;1179			if ( 'nickname' === $idmode ) {1180				$id = $user->user_nickname;1181			}1182			if ( 'login' === $idmode ) {1183				$id = $user->user_login;1184			}1185			if ( 'firstname' === $idmode ) {1186				$id = $user->user_firstname;1187			}1188			if ( 'lastname' === $idmode ) {1189				$id = $user->user_lastname;1190			}1191			if ( 'namefl' === $idmode ) {1192				$id = $user->user_firstname . ' ' . $user->user_lastname;1193			}1194			if ( 'namelf' === $idmode ) {1195				$id = $user->user_lastname . ' ' . $user->user_firstname;1196			}1197			if ( ! $idmode ) {1198				$id = $user->user_nickname;1199			}1200			$wpdb->update( $wpdb->users, array( 'display_name' => $id ), array( 'ID' => $user->ID ) );1201		endif;1202 1203		// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.1204		$caps = get_user_meta( $user->ID, $wpdb->prefix . 'capabilities' );1205		if ( empty( $caps ) || defined( 'RESET_CAPS' ) ) {1206			$level = get_user_meta( $user->ID, $wpdb->prefix . 'user_level', true );1207			$role  = translate_level_to_role( $level );1208			update_user_meta( $user->ID, $wpdb->prefix . 'capabilities', array( $role => true ) );1209		}1210 1211	endforeach;1212	$old_user_fields = array( 'user_firstname', 'user_lastname', 'user_icq', 'user_aim', 'user_msn', 'user_yim', 'user_idmode', 'user_ip', 'user_domain', 'user_browser', 'user_description', 'user_nickname', 'user_level' );1213	$wpdb->hide_errors();1214	foreach ( $old_user_fields as $old ) {1215		$wpdb->query( "ALTER TABLE $wpdb->users DROP $old" );1216	}1217	$wpdb->show_errors();1218 1219	// Populate comment_count field of posts table.1220	$comments = $wpdb->get_results( "SELECT comment_post_ID, COUNT(*) as c FROM $wpdb->comments WHERE comment_approved = '1' GROUP BY comment_post_ID" );1221	if ( is_array( $comments ) ) {

Changelog

Introduced in 2.0.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.