Changeset 25488 for trunk/src/wp-includes/ms-functions.php

Timestamp:

09/19/2013 01:46:03 AM (13 years ago)

Author:

SergeyBiryukov

Message:

Introduce 'offset' parameter for wp_get_sites().

props jamescollins.
see #14511.

File:

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

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

@@ -2008 +2008 @@
  *     @type int       'deleted'    Retrieve deleted or non-deleted sites. Default null, for any.
  *     @type int       'limit'      Number of sites to limit the query to. Default 100.
+ *     @type int       'offset'     Exclude the first x sites. Used in combination with the limit parameter. Default 0.
  * }
  *
@@ -2026 +2027 @@
                 'deleted'    => null,
                 'limit'      => 100,
+                'offset'     => 0,
         );
 
@@ -2052 +2054 @@
                 $query .= $wpdb->prepare( "AND deleted = %d ", $args['deleted'] );
 
-        if ( isset( $args['limit'] ) )
-                $query .= $wpdb->prepare( "LIMIT %d ", $args['limit'] );
+        if ( isset( $args['limit'] ) && $args['limit'] ) {
+                if ( isset( $args['offset'] ) && $args['offset'] )
+                        $query .= $wpdb->prepare( "LIMIT %d , %d ", $args['offset'], $args['limit'] );
+                else
+                        $query .= $wpdb->prepare( "LIMIT %d ", $args['limit'] );
+        }
 
         $site_results = $wpdb->get_results( $query, ARRAY_A );