upgrade_230()

1313function upgrade_230() {1314	global $wp_current_db_version, $wpdb;1315 1316	if ( $wp_current_db_version < 5200 ) {1317		populate_roles_230();1318	}1319 1320	// Convert categories to terms.1321	$tt_ids     = array();1322	$have_tags  = false;1323	$categories = $wpdb->get_results( "SELECT * FROM $wpdb->categories ORDER BY cat_ID" );1324	foreach ( $categories as $category ) {1325		$term_id     = (int) $category->cat_ID;1326		$name        = $category->cat_name;1327		$description = $category->category_description;1328		$slug        = $category->category_nicename;1329		$parent      = $category->category_parent;1330		$term_group  = 0;1331 1332		// Associate terms with the same slug in a term group and make slugs unique.1333		$exists = $wpdb->get_results( $wpdb->prepare( "SELECT term_id, term_group FROM $wpdb->terms WHERE slug = %s", $slug ) );1334		if ( $exists ) {1335			$term_group = $exists[0]->term_group;1336			$id         = $exists[0]->term_id;1337			$num        = 2;1338			do {1339				$alt_slug = $slug . "-$num";1340				++$num;1341				$slug_check = $wpdb->get_var( $wpdb->prepare( "SELECT slug FROM $wpdb->terms WHERE slug = %s", $alt_slug ) );1342			} while ( $slug_check );1343 1344			$slug = $alt_slug;1345 1346			if ( empty( $term_group ) ) {1347				$term_group = $wpdb->get_var( "SELECT MAX(term_group) FROM $wpdb->terms GROUP BY term_group" ) + 1;1348				$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->terms SET term_group = %d WHERE term_id = %d", $term_group, $id ) );1349			}1350		}1351 1352		$wpdb->query(1353			$wpdb->prepare(1354				"INSERT INTO $wpdb->terms (term_id, name, slug, term_group) VALUES1355		(%d, %s, %s, %d)",1356				$term_id,1357				$name,1358				$slug,1359				$term_group1360			)1361		);1362 1363		$count = 0;1364		if ( ! empty( $category->category_count ) ) {1365			$count    = (int) $category->category_count;1366			$taxonomy = 'category';1367			$wpdb->query( $wpdb->prepare( "INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( %d, %s, %s, %d, %d)", $term_id, $taxonomy, $description, $parent, $count ) );1368			$tt_ids[ $term_id ][ $taxonomy ] = (int) $wpdb->insert_id;1369		}1370 1371		if ( ! empty( $category->link_count ) ) {1372			$count    = (int) $category->link_count;1373			$taxonomy = 'link_category';1374			$wpdb->query( $wpdb->prepare( "INSERT INTO $wpdb->term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( %d, %s, %s, %d, %d)", $term_id, $taxonomy, $description, $parent, $count ) );1375			$tt_ids[ $term_id ][ $taxonomy ] = (int) $wpdb->insert_id;1376		}1377 1378		if ( ! empty( $category->tag_count ) ) {1379			$have_tags = true;1380			$count     = (int) $category->tag_count;1381			$taxonomy  = 'post_tag';1382			$wpdb->insert( $wpdb->term_taxonomy, compact( 'term_id', 'taxonomy', 'description', 'parent', 'count' ) );1383			$tt_ids[ $term_id ][ $taxonomy ] = (int) $wpdb->insert_id;1384		}1385 1386		if ( empty( $count ) ) {1387			$count    = 0;1388			$taxonomy = 'category';1389			$wpdb->insert( $wpdb->term_taxonomy, compact( 'term_id', 'taxonomy', 'description', 'parent', 'count' ) );1390			$tt_ids[ $term_id ][ $taxonomy ] = (int) $wpdb->insert_id;1391		}1392	}