CUNY Academic Commons

<?php

global $wpdb;

$user_ids = $wpdb->get_col( "SELECT ID FROM $wpdb->users LIMIT 20" );

$progress = WP_CLI\Utils\make_progress_bar( 'Saving initial email address for existing users', count( $user_ids ) );

foreach ( $user_ids as $user_id ) {

	$progress->tick();

	$user = get_user_by( 'ID', $user_id );

	if ( ! $user ) {

		continue;

	}

	$signup = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->signups} WHERE user_login = %s", $user->user_login ) );

	if ( ! $signup ) {

		WP_CLI::log( "No signup record found for user ID {$user_id} ({$user->user_login}), skipping." );

		continue;

	}

	update_user_meta( $user_id, 'cac_initial_email_address', $signup->user_email );

	WP_CLI::log( "Saved initial email address for user ID {$user_id}: {$signup->user_email}" );

};

$progress->finish();