PMPro Sequential Member Number 2

pmpro-sequential-member-number-2.php

/*
	Sequential Member Numbers
	
	* Member numbers are automatically increased from the value set for $starting_member_number after each member registration
	* Existing members already in the system will not receive a membership number
*/
//Generate member_number when a user is registered.
function generate_member_number($user_id, $decrement = false)
{
	$starting_member_number = 100000;
	
	$next_num = $starting_member_number;
	
	$member_number = get_user_meta($user_id, "member_number", true);
	
	//if no member number, create one
	if(empty($member_number))
	{
		global $wpdb;
		
		while(empty($member_number))
		{
			$member_number = $next_num;
			
			$check = $wpdb->get_var("SELECT meta_value FROM $wpdb->usermeta WHERE meta_value = '" . esc_sql($member_number) . "' LIMIT 1");
			
			if($check && !$decrement)
			{
				$member_number = NULL;
				$next_num++;
			}
		}
		
		//save to user meta
		update_user_meta($user_id, "member_number", $member_number);
		
		return $member_number;
	}
}
add_action('user_register', 'generate_member_number');

//Show it on the membership account page.
function pmpromn_pmpro_account_bullets_bottom()
{
	if(is_user_logged_in())
	{
		global $current_user;
		
		//get member number
		$member_number = get_user_meta($current_user->ID, "member_number", true);
		
		//show it
		if(!empty($member_number))
		{
		?>
		<li><strong><?php _e("Member Number", "pmpro");?>:</strong> <?php echo $member_number?></li>
		<?php
		}
	}
}
add_action('pmpro_account_bullets_bottom', 'pmpromn_pmpro_account_bullets_bottom');
add_action('pmpro_invoice_bullets_bottom', 'pmpromn_pmpro_account_bullets_bottom');
//show member_number in confirmation emails
function pmpromn_pmpro_email_filter($email)
{
	global $wpdb;
 	
	//only update admin confirmation emails
	if(strpos($email->template, "checkout") !== false)
	{
		if(!empty($email->data) && !empty($email->data['user_login']))
		{
			$user = get_user_by("login", $email->data['user_login']);			
			if(!empty($user) && !empty($user->ID))
			{
				$member_number = get_user_meta($user->ID, "member_number", true);
				
				if(!empty($member_number))
					$email->body = str_replace("<p>Membership Level", "<p>Member Number:" . $member_number . "</p><p>Membership Level", $email->body);
			}
		}
	}
		
	return $email;
}
add_filter("pmpro_email_filter", "pmpromn_pmpro_email_filter", 30, 2);