* List Table API: WP_MS_Sites_List_Table class

 * @subpackage Administration

 * @since 3.1.0

 */

/**

 * Core class used to implement displaying sites in a list table for the network admin.

 *

 *

 * @see WP_List_Table

	 * Site status list.

	 *

	 * @since 4.3.0

	 * @var array

	 */

	public $status_list;

	/**

		$this->status_list = array(

			'archived' => array( 'site-archived', __( 'Archived' ) ),

			'spam'     => array( 'site-spammed', _x( 'Spam', 'site' ) ),

			'deleted'  => array( 'site-deleted', __( 'Deleted' ) ),

			'mature'   => array( 'site-mature', __( 'Mature' ) )

		);

	/**

	 *

	 * @return bool

	 */

	/**

	 * Prepares the list of sites for display.

	 *

	 * @since 3.1.0

	 *

	 * @global string $s

	 * @global string $mode

	 * @global wpdb   $wpdb

	 */

		if ( ! empty( $_REQUEST['mode'] ) ) {

			$mode = $_REQUEST['mode'] === 'excerpt' ? 'excerpt' : 'list';

			set_user_setting( 'sites_list_mode', $mode );

		} else {

			$mode = get_user_setting( 'sites_list_mode', 'list' );

		}

			$wild = '*';

		 * the latest sites with no paging in order to avoid expensive count queries.

		$args = array(

			'number'     => intval( $per_page ),

			'offset'     => intval( ( $pagenum - 1 ) * $per_page ),

			'network_id' => get_current_network_id(),

		);

			$sql = $wpdb->prepare( "SELECT blog_id FROM {$wpdb->registration_log} WHERE {$wpdb->registration_log}.IP LIKE %s", $wpdb->esc_like( $s ) . ( ! empty( $wild ) ? '%' : '' ) );

			if ( $reg_blog_ids ) {

				$args['site__in'] = $reg_blog_ids;

			}

		} elseif ( is_numeric( $s ) && empty( $wild ) ) {

			$args['ID'] = $s;

			$args['search'] = $s;

			if ( ! is_subdomain_install() ) {

				$args['search_columns'] = array( 'path' );

		if ( 'registered' === $order_by ) {

			// registered is a valid field name.

		} elseif ( 'lastupdated' === $order_by ) {

			$order_by = 'last_updated';

		} elseif ( 'blogname' === $order_by ) {

			if ( is_subdomain_install() ) {

				$order_by = 'domain';

			} else {

				$order_by = 'path';

			}

		} elseif ( 'blog_id' === $order_by ) {

			$order_by = 'id';

		} elseif ( ! $order_by ) {

			$order_by = false;

		}

		$args['orderby'] = $order_by;

		if ( $order_by ) {

			$args['order'] = ( isset( $_REQUEST['order'] ) && 'DESC' === strtoupper( $_REQUEST['order'] ) ) ? "DESC" : "ASC";

		if ( wp_is_large_network() ) {

			$args['no_found_rows'] = true;

		} else {

			$args['no_found_rows'] = false;

		/**

		 * Filters the arguments for the site query in the sites list table.

		 *

		 * @since 4.6.0

		 *

		 * @param array $args An array of get_sites() arguments.

		 */

		$args = apply_filters( 'ms_sites_list_table_query_args', $args );

		$_sites = get_sites( $args );

		if ( is_array( $_sites ) ) {

			update_site_cache( $_sites );

			$this->items = array_slice( $_sites, 0, $per_page );

		}

		$total_sites = get_sites( array_merge( $args, array(

			'count' => true,

			'offset' => 0,

			'number' => 0,

		) ) );

			'total_items' => $total_sites,

	/**

	 */

	/**

	 *

	 * @return array

	 */

	 * @global string $mode List table view mode.

	 *

		if ( 'top' === $which )

	/**

	 * @return array

	 */

			'blogname'    => __( 'URL' ),

			'users'       => __( 'Users' ),

		if ( has_filter( 'wpmublogsaction' ) ) {

		}

		 * Filters the displayed site columns in Sites list table.

		 * @since MU (3.0.0)

		return apply_filters( 'wpmu_blogs_columns', $sites_columns );

	/**

	 * @return array

	 */

	/**

	 * Handles the checkbox column output.

	 *

	 * @since 4.3.0

	 *

	 * @param array $blog Current site.

	 */

	public function column_cb( $blog ) {

		if ( ! is_main_site( $blog['blog_id'] ) ) :

			$blogname = untrailingslashit( $blog['domain'] . $blog['path'] );

		?>

			<label class="screen-reader-text" for="blog_<?php echo $blog['blog_id']; ?>"><?php

				printf( __( 'Select %s' ), $blogname );

			?></label>

			<input type="checkbox" id="blog_<?php echo $blog['blog_id'] ?>" name="allblogs[]" value="<?php echo esc_attr( $blog['blog_id'] ) ?>" />

		<?php endif;

	}

	/**

	 * Handles the ID column output.

	 *

	 * @since 4.4.0

	 *

	 * @param array $blog Current site.

	 */

	public function column_id( $blog ) {

		echo $blog['blog_id'];

	}

	/**

	 * Handles the site name column output.

	 *

	 * @since 4.3.0

	 *

	 * @global string $mode List table view mode.

	 *

	 * @param array $blog Current site.

	 */

	public function column_blogname( $blog ) {

		$blogname = untrailingslashit( $blog['domain'] . $blog['path'] );

		$blog_states = array();

		reset( $this->status_list );

		foreach ( $this->status_list as $status => $col ) {

			if ( $blog[ $status ] == 1 ) {

				$blog_states[] = $col[1];

			}

		}

		$blog_state = '';

		if ( ! empty( $blog_states ) ) {

			$state_count = count( $blog_states );

			$i = 0;

			$blog_state .= ' — ';

			foreach ( $blog_states as $state ) {

				++$i;

				$sep = ( $i == $state_count ) ? '' : ', ';

				$blog_state .= "<span class='post-state'>$state$sep</span>";

			}

		}

		?>

		<strong>

			<a href="<?php echo esc_url( network_admin_url( 'site-info.php?id=' . $blog['blog_id'] ) ); ?>" class="edit"><?php echo $blogname; ?></a>

			<?php echo $blog_state; ?>

		</strong>

		<?php

		if ( 'list' !== $mode ) {

			switch_to_blog( $blog['blog_id'] );

			echo '<p>';

			printf(

				/* translators: 1: site name, 2: site tagline. */

				__( '%1$s – %2$s' ),

				get_option( 'blogname' ),

				'<em>' . get_option( 'blogdescription ' ) . '</em>'

			);

			echo '</p>';

			restore_current_blog();

		}

	}

	/**

	 * Handles the lastupdated column output.

	 *

	 * @since 4.3.0

	 *

	 * @global string $mode List table view mode.

	 *

	 * @param array $blog Current site.

	 */

	public function column_lastupdated( $blog ) {

		global $mode;

		if ( 'list' === $mode ) {

			$date = __( 'Y/m/d' );

		} else {

			$date = __( 'Y/m/d g:i:s a' );

		}

		echo ( $blog['last_updated'] === '0000-00-00 00:00:00' ) ? __( 'Never' ) : mysql2date( $date, $blog['last_updated'] );

	}

	/**

	 * Handles the registered column output.

	 *

	 * @since 4.3.0

	 *

	 * @global string $mode List table view mode.

	 *

	 * @param array $blog Current site.

	 */

	public function column_registered( $blog ) {

		global $mode;

		if ( 'list' === $mode ) {

		if ( $blog['registered'] === '0000-00-00 00:00:00' ) {

			echo '—';

		} else {

			echo mysql2date( $date, $blog['registered'] );

		}

	}

	/**

	 * Handles the users column output.

	 *

	 * @since 4.3.0

	 *

	 * @param array $blog Current site.

	 */

	public function column_users( $blog ) {

		$user_count = wp_cache_get( $blog['blog_id'] . '_user_count', 'blog-details' );

		if ( ! $user_count ) {

			$blog_users = get_users( array( 'blog_id' => $blog['blog_id'], 'fields' => 'ID' ) );

			$user_count = count( $blog_users );

			unset( $blog_users );

			wp_cache_set( $blog['blog_id'] . '_user_count', $user_count, 'blog-details', 12 * HOUR_IN_SECONDS );

		}

		printf(

			'<a href="%s">%s</a>',