WP_MS_Sites_List_Table::prepare_items()

72	public function prepare_items() {73		global $mode, $s, $wpdb;74 75		if ( ! empty( $_REQUEST['mode'] ) ) {76			$mode = 'excerpt' === $_REQUEST['mode'] ? 'excerpt' : 'list';77			set_user_setting( 'sites_list_mode', $mode );78		} else {79			$mode = get_user_setting( 'sites_list_mode', 'list' );80		}81 82		$per_page = $this->get_items_per_page( 'sites_network_per_page' );83 84		$pagenum = $this->get_pagenum();85 86		$s    = isset( $_REQUEST['s'] ) ? wp_unslash( trim( $_REQUEST['s'] ) ) : '';87		$wild = '';88		if ( str_contains( $s, '*' ) ) {89			$wild = '*';90			$s    = trim( $s, '*' );91		}92 93		/*94		 * If the network is large and a search is not being performed, show only95		 * the latest sites with no paging in order to avoid expensive count queries.96		 */97		if ( ! $s && wp_is_large_network() ) {98			if ( ! isset( $_REQUEST['orderby'] ) ) {99				$_GET['orderby']     = '';100				$_REQUEST['orderby'] = '';101			}102			if ( ! isset( $_REQUEST['order'] ) ) {103				$_GET['order']     = 'DESC';104				$_REQUEST['order'] = 'DESC';105			}106		}107 108		$args = array(109			'number'     => (int) $per_page,110			'offset'     => (int) ( ( $pagenum - 1 ) * $per_page ),111			'network_id' => get_current_network_id(),112		);113 114		if ( empty( $s ) ) {115			// Nothing to do.116		} elseif ( preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/', $s )117			|| preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.?$/', $s )118			|| preg_match( '/^[0-9]{1,3}\.[0-9]{1,3}\.?$/', $s )119			|| preg_match( '/^[0-9]{1,3}\.$/', $s )120		) {121			// IPv4 address.122			$reg_blog_ids = $wpdb->get_col(123				$wpdb->prepare(124					"SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s",125					$wpdb->esc_like( $s ) . ( ! empty( $wild ) ? '%' : '' )126				)127			);128 129			if ( $reg_blog_ids ) {130				$args['site__in'] = $reg_blog_ids;131			}132		} elseif ( is_numeric( $s ) && empty( $wild ) ) {133			$args['ID'] = $s;134		} else {135			$args['search'] = $s;136 137			if ( ! is_subdomain_install() ) {138				$args['search_columns'] = array( 'path' );139			}140		}141 142		$order_by = $_REQUEST['orderby'] ?? '';143		if ( 'registered' === $order_by ) {144			// 'registered' is a valid field name.145		} elseif ( 'lastupdated' === $order_by ) {146			$order_by = 'last_updated';147		} elseif ( 'blogname' === $order_by ) {148			if ( is_subdomain_install() ) {149				$order_by = 'domain';150			} else {151				$order_by = 'path';