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' ]."%'";
} elseif( $_GET[ 'blog_id' ] != '' ) {
$query = "SELECT *
FROM $wpdb->blogs
WHERE site_id = '$wpdb->siteid'
AND blog_id = '".intval($_GET[ 'blog_id' ])."'";
} elseif( $_GET[ 'ip_address' ] != '' ) {
$query = "SELECT *
FROM $wpdb->blogs, wp_registration_log
WHERE site_id = '$wpdb->siteid'
AND {$wpdb->blogs}.blog_id = wp_registration_log.blog_id
AND wp_registration_log.IP LIKE ('%".$_GET[ 'ip_address' ]."%')";
}
if( isset( $_GET[ 'sortby' ] ) == false ) {
$_GET[ 'sortby' ] = 'ID';
}
if( $_GET[ 'sortby' ] == 'Registered' ) {
$query .= ' ORDER BY registered ';
} elseif( $_GET[ 'sortby' ] == 'ID' ) {
$query .= ' ORDER BY ' . $wpdb->blogs . '.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";
}
if ( $_GET[ 'ip_address' ] == '' )
$query .= " LIMIT " . intval( $start ) . ", " . intval( $num );
$blog_list = $wpdb->get_results( $query, ARRAY_A );
if( count( $blog_list ) < $num ) {
$next = false;
} else {
$next = true;
}
?>