Skip to:
Content
Pages
Categories
Search
Top
Bottom

Reply To: Get E-mail addresses of users without Photos?

@shanebp

Moderator

untested:


function no_photos() { 
	global $wpdb;

	$emails = array();
	
	$ids = $wpdb->get_col( "SELECT ID FROM {$wpdb->prefix}users" );

	foreach( $ids as $id ) { 

		$avatar_check = false;
   
		if ( bp_core_fetch_avatar( array( 'item_id' => $id, 'no_grav' => true, 'html'=> false ) ) != bp_core_avatar_default() )
			$avatar_check = true; 

		if( ! $avatar_check ) { 
			$email = $wpdb->get_var( "SELECT user_email FROM {$wpdb->prefix}users WHERE ID = $id" );
			$emails[] = $email;
		}
	}
		
	$emails = implode(",", $emails);
		
	return $emails;
		
}
Skip to toolbar