How can we delete user between two registration dates programatically in wordpress?
Solution:
function get_users_registered_between_date($start='', $end='' ){ global $wpdb; $prefix =$wpdb->prefix; $user_table= $prefix.'users'; if( empty($start) ) $date = date('Y-m-d'); if ( empty($end) ) $end = $start; $start_dt = new DateTime($start. ' 00:00:00'); $s = $start_dt->format('Y-m-d H:i:s'); $end_dt = new DateTime($end.' 23:59:59'); $e = $end_dt->format('Y-m-d H:i:s'); $sql = $wpdb->prepare("SELECT ID FROM $user_table WHERE 1=1 AND CAST(user_registered AS DATE) BETWEEN %s AND %s ORDER BY user_login ASC",$s,$e); $users = $wpdb->get_results($sql); return $users; } $start_date='2015-02-14'; // registration date $end_date='2015-04-17'; // registration date $users= get_users_registered_between_date($start_date, $end_date ); // users list between date '2015-02-14' and '2015-04-17' require_once(ABSPATH.'wp-admin/includes/user.php' ); foreach($users as $usr){ $user_id= $usr->ID; $roles= array(); $user = get_userdata( $user_id ); $capabilities = $user->{$wpdb->prefix . 'capabilities'}; if ( !isset( $wp_roles ) ) $wp_roles = new WP_Roles(); foreach ( $wp_roles->role_names as $role => $name ) : if ( array_key_exists( $role, $capabilities ) ) $roles[]=$role; endforeach; if (!in_array("administrator", $roles)) { if(wp_delete_user($user_id)){ echo 'User deleted'.$user_id; echo '
'; } } }
No comments:
Post a Comment