Changeset 3656

Timestamp:

03/21/2006 10:46:38 PM (19 years ago)

Author:

ryan

Message:

Add meta_key and meta_value options to get_posts() and get_pages(). Props MichaelH. fixes #2563

Location:

trunk/wp-includes

Files:

• functions.php (modified) (3 diffs)
• template-functions-post.php (modified) (3 diffs)

trunk/wp-includes/functions.php

@@ -1452 +1452 @@
     else
         parse_str($args, $r);
-    parse_str($args, $r);
 
     $defaults = array('numberposts' => 5, 'offset' => 0, 'category' => '',
-        'orderby' => 'post_date', 'order' => 'DESC', 'include' => '', 'exclude' => '');
+        'orderby' => 'post_date', 'order' => 'DESC', 'include' => '', 'exclude' => '', 'meta_key' => '', 'meta_value' =>'');
     $r = array_merge($defaults, $r);
     extract($r);
@@ -1461 +1460 @@
     $inclusions = '';
     if ( !empty($include) ) {
-        $offset = 0;    //ignore offset, category, and exclude params if using include
+        $offset = 0;    //ignore offset, category, exclude, meta_key, and meta_value params if using include
         $category = ''; 
         $exclude = '';  
+        $meta_key = '';
+        $meta_value = '';
         $incposts = preg_split('/[\s,]+/',$include);
         $numberposts = count($incposts);  // only the number of posts included
@@ -1493 +1494 @@
         $exclusions .= ')';
 
-    $posts = $wpdb->get_results(
-        "SELECT DISTINCT * FROM $wpdb->posts " .
-        ( empty( $category ) ? "" : ", $wpdb->post2cat " ) .
-        " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions " .
-        ( empty( $category ) ? "" : "AND $wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. " " ) .
-        " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts );
+    $query ="SELECT DISTINCT * FROM $wpdb->posts " ;
+    $query .= ( empty( $category ) ? "" : ", $wpdb->post2cat " ) ; 
+    $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " ) ; 
+    $query .= " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions " ;
+    $query .= ( empty( $category ) ? "" : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") " ) ;
+    $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" ) ;
+    $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts ;
+
+    $posts = $wpdb->get_results($query);
 
     update_post_caches($posts);

trunk/wp-includes/template-functions-post.php

@@ -307 +307 @@
 
     $defaults = array('child_of' => 0, 'sort_order' => 'ASC', 'sort_column' => 'post_title',
-        'hierarchical' => 1, $exclude => '', $include => '');
+                'hierarchical' => 1, 'exclude' => '', 'include' => '', 'meta_key' => '', 'meta_value' => '');
     $r = array_merge($defaults, $r);
     extract($r);
@@ -313 +313 @@
     $inclusions = '';
     if ( !empty($include) ) {
-        $child_of = 0; //ignore child_of and exclude params if using include 
+        $child_of = 0; //ignore child_of, exclude, meta_key, and meta_value params if using include 
         $exclude = '';  
+        $meta_key = '';
+        $meta_value = '';
         $incpages = preg_split('/[\s,]+/',$include);
         if ( count($incpages) ) {
@@ -343 +345 @@
         $exclusions .= ')';
 
-    $pages = $wpdb->get_results("SELECT * " .
-        "FROM $wpdb->posts " .
-        "WHERE post_type = 'page' AND post_status = 'publish' " .
-        "$exclusions $inclusions" .
-        "ORDER BY " . $sort_column . " " . $sort_order);
+    $query = "SELECT * FROM $wpdb->posts " ;
+    $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " ) ; 
+    $query .= " WHERE (post_type = 'page' AND post_status = 'publish') $exclusions $inclusions " ;
+    $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" ) ;
+    $query .= " ORDER BY " . $sort_column . " " . $sort_order ;
+
+    $pages = $wpdb->get_results($query);
 
     if ( empty($pages) )