//for /mu-plugins/ add_action('network_admin_menu', 'ds_emails_all_add_menu'); function ds_emails_all_add_menu() { add_submenu_page('settings.php', 'Email All', 'Email All', 'manage_network', 'email_all', 'ds_emails_all_page'); } function ds_emails_all_page() { if( is_super_admin() == false ) { wp_die( __('You do not have permission to access this page.') ); } ?>
Following is a list of email addresses that are administrators of one or more blogs on this WPMU installation.
usermeta m INNER JOIN $wpdb->users u on m.user_id=u.id WHERE meta_key like 'wp_%_user_level' and meta_value='10' ORDER BY 1"; //$query = "SELECT DISTINCT user_email FROM $wpdb->users ORDER BY user_email ASC"; //all users $emails = $wpdb->get_results($query); foreach ($emails as $e) { echo "$e->user_email, \n"; } ?>