users}";
if( !empty($_GET['s']) ) {
$search = '%' . trim(addslashes($_GET['s'])) . '%';
$query .= " WHERE user_login LIKE '$search' OR user_email LIKE '$search'";
}
if( !isset($_GET['sortby']) ) {
$_GET['sortby'] = 'id';
}
if( $_GET['sortby'] == 'email' ) {
$query .= ' ORDER BY user_email ';
} elseif( $_GET['sortby'] == 'id' ) {
$query .= ' ORDER BY ID ';
} elseif( $_GET['sortby'] == 'login' ) {
$query .= ' ORDER BY user_login ';
} elseif( $_GET['sortby'] == 'name' ) {
$query .= ' ORDER BY display_name ';
} elseif( $_GET['sortby'] == 'registered' ) {
$query .= ' ORDER BY user_registered ';
}
$query .= ( $_GET['order'] == 'DESC' ) ? 'DESC' : 'ASC';
$query .= " LIMIT " . intval( $start ) . ", " . intval( $num );
$user_list = $wpdb->get_results( $query, ARRAY_A );
$next = ( count( $user_list ) < $num ) ? false : true;
?>
'display name'
$posts_columns = array(
'id' => __('ID'),
'login' => __('Login'),
'email' => __('Email'),
'name' => __('Name'),
'registered' => __('Registered'),
'blogs' => __('Blogs')
);
$posts_columns = apply_filters('manage_posts_columns', $posts_columns);
// you can not edit these at the moment
$posts_columns['control_edit'] = '';
$posts_columns['control_delete'] = '';
?>