Changeset 37628 for trunk/src/wp-includes/ms-load.php

Timestamp:

06/02/2016 09:45:20 PM (10 years ago)

Author:

jeremyfelt

Message:

Multisite: Replace $wpdb->blog queries in get_site_by_path() with get_sites()

Props spacedmonkey, DrewAPicture.
See #35791.

File:

• trunk/src/wp-includes/ms-load.php (modified) (3 diffs)

trunk/src/wp-includes/ms-load.php

@@ -155 +155 @@
  *
  * @since 3.9.0
+ * @since 4.6.0 Converted to use get_sites()
  *
  * @global wpdb $wpdb WordPress database abstraction object.
@@ -164 +165 @@
  */
 function get_site_by_path( $domain, $path, $segments = null ) {
-        global $wpdb;
-
         $path_segments = array_filter( explode( '/', trim( $path, '/' ) ) );
 
@@ -232 +231 @@
         if ( 'www.' === substr( $domain, 0, 4 ) ) {
                 $domains[] = substr( $domain, 4 );
-                $search_domains = "'" . implode( "', '", $wpdb->_escape( $domains ) ) . "'";
-        }
-
-        if ( count( $paths ) > 1 ) {
-                $search_paths = "'" . implode( "', '", $wpdb->_escape( $paths ) ) . "'";
-        }
+        }
+
+        $args = array(
+                'domain__in' => $domains,
+                'path__in' => $paths,
+                'number' => 1,
+        );
 
         if ( count( $domains ) > 1 && count( $paths ) > 1 ) {
-                $site = $wpdb->get_row( "SELECT * FROM $wpdb->blogs WHERE domain IN ($search_domains) AND path IN ($search_paths) ORDER BY CHAR_LENGTH(domain) DESC, CHAR_LENGTH(path) DESC LIMIT 1" );
+                $args['orderby'] = 'domain_length path_length';
+                $args['order'] = 'DESC DESC';
         } elseif ( count( $domains ) > 1 ) {
-                $sql = $wpdb->prepare( "SELECT * FROM $wpdb->blogs WHERE path = %s", $paths[0] );
-                $sql .= " AND domain IN ($search_domains) ORDER BY CHAR_LENGTH(domain) DESC LIMIT 1";
-                $site = $wpdb->get_row( $sql );
+                $args['orderby'] = 'domain_length';
+                $args['order'] = 'DESC';
         } elseif ( count( $paths ) > 1 ) {
-                $sql = $wpdb->prepare( "SELECT * FROM $wpdb->blogs WHERE domain = %s", $domains[0] );
-                $sql .= " AND path IN ($search_paths) ORDER BY CHAR_LENGTH(path) DESC LIMIT 1";
-                $site = $wpdb->get_row( $sql );
-        } else {
-                $site = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $wpdb->blogs WHERE domain = %s AND path = %s", $domains[0], $paths[0] ) );
-        }
+                $args['orderby'] = 'path_length';
+                $args['order'] = 'DESC';
+        }
+
+        $result = get_sites( $args );
+        $site = array_shift( $result );
 
         if ( $site ) {