107
112
preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.?$/', $s ) ||
108
113
preg_match( '/^[0-9]{1,3}\.$/', $s ) ) {
110
$sql = $wpdb->prepare( "SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s", $wpdb->esc_like( $s ) . $wild );
115
$sql = $wpdb->prepare( "SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s", $wpdb->esc_like( $s ) . ( ! empty( $wild ) ? '%' : '' ) );
111
116
$reg_blog_ids = $wpdb->get_col( $sql );
113
if ( !$reg_blog_ids )
114
$reg_blog_ids = array( 0 );
118
WHERE site_id = '{$wpdb->siteid}'
119
AND {$wpdb->blogs}.blog_id IN (" . implode( ', ', $reg_blog_ids ) . ")";
118
if ( $reg_blog_ids ) {
119
$args['site__in'] = $reg_blog_ids;
121
} elseif ( is_numeric( $s ) && empty( $wild ) ) {
121
if ( is_numeric($s) && empty( $wild ) ) {
122
$query .= $wpdb->prepare( " AND ( {$wpdb->blogs}.blog_id = %s )", $s );
123
} elseif ( is_subdomain_install() ) {
124
$blog_s = str_replace( '.' . $current_site->domain, '', $s );
125
$blog_s = $wpdb->esc_like( $blog_s ) . $wild . $wpdb->esc_like( '.' . $current_site->domain );
126
$query .= $wpdb->prepare( " AND ( {$wpdb->blogs}.domain LIKE %s ) ", $blog_s );
128
if ( $s != trim('/', $current_site->path) ) {
129
$blog_s = $wpdb->esc_like( $current_site->path . $s ) . $wild . $wpdb->esc_like( '/' );
131
$blog_s = $wpdb->esc_like( $s );
133
$query .= $wpdb->prepare( " AND ( {$wpdb->blogs}.path LIKE %s )", $blog_s );
124
$args['search'] = $s;
126
if ( ! is_subdomain_install() ) {
127
$args['search_columns'] = array( 'path' );
137
131
$order_by = isset( $_REQUEST['orderby'] ) ? $_REQUEST['orderby'] : '';
138
if ( $order_by === 'registered' ) {
139
$query .= ' ORDER BY registered ';
140
} elseif ( $order_by === 'lastupdated' ) {
141
$query .= ' ORDER BY last_updated ';
142
} elseif ( $order_by === 'blogname' ) {
132
if ( 'registered' === $order_by ) {
133
// registered is a valid field name.
134
} elseif ( 'lastupdated' === $order_by ) {
135
$order_by = 'last_updated';
136
} elseif ( 'blogname' === $order_by ) {
143
137
if ( is_subdomain_install() ) {
144
$query .= ' ORDER BY domain ';
138
$order_by = 'domain';
146
$query .= ' ORDER BY path ';
148
} elseif ( $order_by === 'blog_id' ) {
149
$query .= ' ORDER BY blog_id ';
142
} elseif ( 'blog_id' === $order_by ) {
144
} elseif ( ! $order_by ) {
148
$args['orderby'] = $order_by;
151
$args['order'] = ( isset( $_REQUEST['order'] ) && 'DESC' === strtoupper( $_REQUEST['order'] ) ) ? "DESC" : "ASC";
154
if ( wp_is_large_network() ) {
155
$args['no_found_rows'] = true;
154
if ( isset( $order_by ) ) {
155
$order = ( isset( $_REQUEST['order'] ) && 'DESC' === strtoupper( $_REQUEST['order'] ) ) ? "DESC" : "ASC";
159
// Don't do an unbounded count on large networks
160
if ( ! wp_is_large_network() )
161
$total = $wpdb->get_var( str_replace( 'SELECT *', 'SELECT COUNT( blog_id )', $query ) );
163
$query .= " LIMIT " . intval( ( $pagenum - 1 ) * $per_page ) . ", " . intval( $per_page );
164
$this->items = $wpdb->get_results( $query, ARRAY_A );
166
if ( wp_is_large_network() )
167
$total = count($this->items);
157
$args['no_found_rows'] = false;
161
* Filters the arguments for the site query in the sites list table.
165
* @param array $args An array of get_sites() arguments.
167
$args = apply_filters( 'ms_sites_list_table_query_args', $args );
169
$_sites = get_sites( $args );
170
if ( is_array( $_sites ) ) {
171
update_site_cache( $_sites );
173
$this->items = array_slice( $_sites, 0, $per_page );
176
$total_sites = get_sites( array_merge( $args, array(
169
182
$this->set_pagination_args( array(
170
'total_items' => $total,
183
'total_items' => $total_sites,
171
184
'per_page' => $per_page,