Changeset 2478 for trunk/wp-includes/functions.php

Timestamp:

03/27/2005 08:45:01 PM (20 years ago)

Author:

ryan

Message:

Cacheing cleanup. Introduce get_post() and get_category(). ​http://mosquito.wordpress.org/view.php?id=1157

File:

• trunk/wp-includes/functions.php (modified) (6 diffs)

trunk/wp-includes/functions.php

@@ -539 +539 @@
 }
 
+// Retrieves post data given a post ID or post object. 
+// Handles post caching.
+function &get_post(&$post, $output = OBJECT) {
+    global $post_cache, $wpdb;
+
+    if ( empty($post) ) {
+        if ( isset($GLOBALS['post']) )
+            $post = & $GLOBALS['post'];
+        else
+            $post = null;
+    } elseif (is_object($post) ) {
+        if (! isset($post_cache[$post->ID]))
+            $post_cache[$post->ID] = &$post;
+        $post = & $post_cache[$post->ID];
+    } else {
+        if ( isset($GLOBALS['post']) && ($post == $GLOBALS['post']->ID) )
+            $post = & $GLOBALS['post'];
+        elseif (isset($post_cache[$post]))
+            $post = & $post_cache[$post];
+        else {
+            $query = "SELECT * FROM $wpdb->posts WHERE ID=$post";
+            $post_cache[$post] = & $wpdb->get_row($query);
+            $post = & $post_cache[$post];
+        }
+    }
+
+    if ( $output == OBJECT ) {
+        return $post;
+    } elseif ( $output == ARRAY_A ) {
+        return get_object_vars($post);
+    } elseif ( $output == ARRAY_N ) {
+        return array_values(get_object_vars($post));
+    } else {
+        return $post;
+    }
+}
+
+// Retrieves category data given a category ID or category object. 
+// The category cache is fully populated by the blog header, so we don't
+// have to worry with managing it here.
+function &get_category(&$category, $output = OBJECT) {
+    global $cache_categories;
+    if (is_object($category))
+        $category = & $cache_categories[$category->cat_ID];
+    else
+        $category = & $cache_categories[$category];
+
+    if ( $output == OBJECT ) {
+        return $category;
+    } elseif ( $output == ARRAY_A ) {
+        return get_object_vars($category);
+    } elseif ( $output == ARRAY_N ) {
+        return array_values(get_object_vars($category));
+    } else {
+        return $category;
+    }
+}
+
 function get_catname($cat_ID) {
-    global $cache_catnames, $wpdb;
-    if ( !$cache_catnames ) {
-        $results = $wpdb->get_results("SELECT * FROM $wpdb->categories") or die('Oops, couldn\'t query the db for categories.');
-        foreach ($results as $post) {
-            $cache_catnames[$post->cat_ID] = $post->cat_name;
-        }
-    }
-    $cat_name = $cache_catnames[$cat_ID];
-    return $cat_name;
+    $category = &get_category($cat_ID);
+    return $category->cat_name;
 }
 
@@ -996 +1047 @@
 
 function get_page_uri($page_id) {
-    global $wpdb, $cache_pages;
-
-    $dates = ",UNIX_TIMESTAMP(post_modified) AS time_modified";
-    $dates .= ",UNIX_TIMESTAMP(post_date) AS time_created";
-
-    if (!isset($cache_pages[$page_id])) {
-        $cache_pages[$page_id] = $wpdb->get_row("SELECT ID, post_title, post_name, post_parent $dates FROM $wpdb->posts WHERE ID = '$page_id'");
-    }
-
-    $page = $cache_pages[$page_id];
+    $page = get_post($page_id);
     $uri = urldecode($page->post_name);
 
@@ -1012 +1054 @@
         return $uri;
     }
-
+    
     while ($page->post_parent != 0) {
-        if (isset($cache_pages[$page->post_parent])) {
-            $page = $cache_pages[$page->post_parent];
-        } else {
-            $page = $wpdb->get_row("SELECT ID, post_title, post_name, post_parent $dates FROM $wpdb->posts WHERE ID = '$page->post_parent'");
-            $cache_pages[$page->ID] = $page;
-        }
+        $page = get_post($page->post_parent);
         $uri = urldecode($page->post_name) . "/" . $uri;
     }
@@ -1050 +1087 @@
 }
 
-function query_posts($query) {
+function &query_posts($query) {
     global $wp_query;
     return $wp_query->query($query);
 }
 
-function update_post_caches($posts) {
-    global $category_cache, $comment_count_cache, $post_meta_cache;
+function update_post_cache(&$posts) {
+    global $post_cache;
+
+    if ( !$posts )
+        return;
+
+    for ($i = 0; $i < count($posts); $i++) {
+        $post_cache[$posts[$i]->ID] = &$posts[$i];
+    }
+}
+
+function update_post_category_cache($post_ids) {
+    global $wpdb, $category_cache, $cache_categories;
+
+    if (empty($post_ids))
+        return;
+
+    if (is_array($post_ids))
+        $post_ids = implode(',', $post_ids);
+
+    $dogs = $wpdb->get_results("SELECT DISTINCT
+    post_id, category_id FROM $wpdb->categories, $wpdb->post2cat
+    WHERE category_id = cat_ID AND post_id IN ($post_ids)");
+
+    if ( !empty($dogs) ) {
+        foreach ($dogs as $catt) {
+            $category_cache[$catt->post_id][$catt->category_id] = &$cache_categories[$catt->category_id];
+        }
+    }
+}
+
+function update_post_caches(&$posts) {
+    global $post_cache, $category_cache, $comment_count_cache, $post_meta_cache;
     global $wpdb;
     
@@ -1064 +1132 @@
 
     // Get the categories for all the posts
-    foreach ($posts as $post)
-        $post_id_list[] = $post->ID;
+    for ($i = 0; $i < count($posts); $i++) {
+        $post_id_list[] = $posts[$i]->ID;
+        $post_cache[$posts[$i]->ID] = &$posts[$i];
+    }
+
     $post_id_list = implode(',', $post_id_list);
-
-    $dogs = $wpdb->get_results("SELECT DISTINCT
-    post_id, category_id, cat_name, category_nicename, category_description, category_parent
-    FROM $wpdb->categories, $wpdb->post2cat
-    WHERE category_id = cat_ID AND post_id IN ($post_id_list)");
-    
-    if ( !empty($dogs) ) {
-        foreach ($dogs as $catt) {
-            $category_cache[$catt->post_id][$catt->category_id] = $catt;
-        }
-    }
+    
+    update_post_category_cache($post_id_list);
 
     // Do the same for comment numbers
@@ -1115 +1177 @@
     global $cache_categories, $wpdb;
     $dogs = $wpdb->get_results("SELECT * FROM $wpdb->categories");
-    foreach ($dogs as $catt)
+    foreach ($dogs as $catt) {
+        $catt->category_id = $catt->cat_ID; // Alias.
         $cache_categories[$catt->cat_ID] = $catt;
+    }
 }