blogs."
WHERE site_id = '".$wpdb->siteid."' ";
if( $_GET[ 's' ] != '' ) {
$query = "SELECT blog_id, {$wpdb->blogs}.domain, registered, last_updated
FROM ".$wpdb->blogs.", ".$wpdb->site."
WHERE site_id = '".$wpdb->siteid."'
AND ".$wpdb->blogs.".site_id = ".$wpdb->site.".id
AND {$wpdb->blogs}.domain like '%".$_GET[ 's' ]."%'";
}
if( isset( $_GET[ 'sortby' ] ) == false ) {
$_GET[ 'sortby' ] = 'ID';
}
if( $_GET[ 'sortby' ] == 'Registered' ) {
$query .= ' ORDER BY registered ';
} elseif( $_GET[ 'sortby' ] == 'ID' ) {
$query .= ' ORDER BY blog_id ';
} elseif( $_GET[ 'sortby' ] == 'Last Updated' ) {
$query .= ' ORDER BY last_updated ';
} elseif( $_GET[ 'sortby' ] == 'Blog Name' ) {
$query .= ' ORDER BY domain ';
}
if( $_GET[ 'order' ] == 'DESC' ) {
$query .= "DESC";
} else {
$query .= "ASC";
}
$query .= " LIMIT " . intval( $start ) . ", " . intval( $num );
$blog_list = $wpdb->get_results( $query, ARRAY_A );
if( count( $blog_list ) < $num ) {
$next = false;
} else {
$next = true;
}
?>