CUNY Academic Commons

<?php

global $wpdb;

$updates = $wpdb->get_results( "SELECT * FROM {$wpdb->usermeta} WHERE meta_key = 'bp_latest_update' AND meta_value != ''" );

foreach ( $updates as $update ) {

	$unserialized = maybe_unserialize( $update->meta_value );

	if ( ! is_object( $unserialized ) ) {

		continue;

	}

	$array = (array) $unserialized;

	bp_update_user_meta( $update->user_id, 'bp_latest_update', $array );

}