CUNY Academic Commons

<?php

$field = xprofile_get_field( 2 );

$map = [

	'CUNY Graduate Center ' => 'CUNY Graduate Center',

	'CUNY Graduate School of Journalism' => 'Craig Newmark Graduate School of Journalism',

	'City College' => 'City College of New York',

	'Macaulay Honors College ' => 'Macaulay Honors College',

	'NYC College of Technology' => 'New York City College of Technology',

	'New Community College at CUNY' => 'Guttman Community College',

	'Stella and Charles Guttman Community College' => 'Guttman Community College',

];

global $wpdb, $bp;

foreach ( $map as $old => $new ) {

	$like = '%' . $wpdb->esc_like( $old ) . '%';

	$user_ids = $wpdb->get_col( $wpdb->prepare( "SELECT user_id FROM {$bp->profile->table_name_data} WHERE field_id = 2 and value LIKE %s", $like ) );

	foreach ( $user_ids as $user_id ) {

		$current = xprofile_get_field_data( 2, $user_id );

		if ( is_array( $current ) ) {

			foreach ( $current as &$value ) {

				if ( $old === $value ) {

					$value = $new;

				}

			}

		} else {

			$current = $new;

		}

		xprofile_set_field_data( 2, $user_id, $current );

	}

	// Positions.

	$term = get_term_by( 'name', $old, 'cacap_position_college' );

	if ( $term ) {

		// Don't bother with the ones that are just about trailing spaces.

		if ( trim( $old ) !== $new ) {

			$updated = wp_update_term(

				$term->term_id,

				'cacap_position_college',

				[

					'name' => $new,

				]

			);

		}

	}

}