Don't like ads? PRO users don't see any ads ;-)
Public Pastes

List users that has not activated their account

By: imath on Sep 24th, 2012  |  syntax: PHP  |  size: 0.43 KB  |  hits: 42  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <?php
  2.  
  3. function bp_rc_list_not_activated_users() {
  4.         global $wpdb;
  5.        
  6.         if( is_multisite() ) {
  7.                 return $wpdb->get_results("SELECT user_email, activation_key FROM {$wpdb->signups} WHERE active = 0", OBJECT);
  8.         } else {
  9.                 return $wpdb->get_results("SELECT user_email, meta_value as activation_key, user_id FROM {$wpdb->usermeta} m LEFT JOIN {$wpdb->users} a ON(m.user_id = a.ID)  WHERE meta_key = 'activation_key'", OBJECT);
  10.         }
  11. }
  12.  
  13. ?>
create a new version of this paste RAW Paste Data