Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. function ds_emails_all_page()
  2. {
  3. if( is_super_admin() == false ) {
  4. wp_die( __('You do not have permission to access this page.') );
  5. }
  6. ?>
  7. <div class='wrap'>
  8. <h2>Email All</h2>
  9. <p>Following is a list of email addresses that are administrators of one or more blogs on this WPMU installation.</p>
  10. <pre>
  11. <?php
  12. global $wpdb;
  13.  
  14. $query = "SELECT DISTINCT (u.user_email) FROM $wpdb->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";
  15.  
  16. //$query = "SELECT DISTINCT user_email FROM $wpdb->users ORDER BY user_email ASC"; //all users
  17.  
  18. $emails = $wpdb->get_results($query);
  19.  
  20. foreach ($emails as $e) {
  21. echo "$e->user_email, \n";
  22. }
  23. ?>
  24. </pre>
  25. </div>
  26. <?php
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement