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

Timestamp:

09/19/2013 01:46:03 AM (11 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 );