Changeset 1185

Timestamp:

04/26/2004 11:54:52 PM (21 years ago)

Author:

saxmatt

Message:

Reducing queries and forward thinking database fields.

Location:

trunk

Files:

• wp-admin/upgrade-functions.php (modified) (1 diff)
• wp-includes/template-functions-comment.php (modified) (1 diff)
• wp-includes/template-functions-general.php (modified) (2 diffs)

trunk/wp-admin/upgrade-functions.php

@@ -804 +804 @@
         delete_option($option);
     endforeach;
-}
+
+    // Forward-thinking
+    $wpdb->query("ALTER TABLE `$tableposts` CHANGE `post_status` `post_status` ENUM( 'publish', 'draft', 'private', 'static' ) DEFAULT 'publish' NOT NULL");
+}
+
+    maybe_add_column($tableposts, 'post_parent', "ALTER TABLE `$tableposts` ADD `post_parent` INT NOT NULL ;");
 
 ?>

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

@@ -31 +31 @@
 
 function comments_number($zero='No Comments', $one='1 Comment', $more='% Comments', $number='') {
-    global $id, $comment, $tablecomments, $wpdb;
-    if ('' == $number) $number = $wpdb->get_var("SELECT COUNT(*) FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1'");
+    global $id, $comment, $tablecomments, $wpdb, $comment_count_cache;
+    if ('' == $comment_count_cache["$id"]) $number = $wpdb->get_var("SELECT COUNT(*) FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1'");
+    else $number = $comment_count_cache["$id"];
     if ($number == 0) {
         $blah = $zero;

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

@@ -93 +93 @@
 function wp_title($sep = '»', $display = true) {
     global $wpdb, $tableposts, $tablecategories;
-    global $year, $monthnum, $day, $cat, $p, $name, $month;
+    global $year, $monthnum, $day, $cat, $p, $name, $month, $posts, $single;
 
     // If there's a category
@@ -123 +123 @@
 
     // If there's a post
-    if (intval($p) || '' != $name) {
-        if (!$p) {
-        if ($year != '') {
-            $year = '' . intval($year);
-            $where .= ' AND YEAR(post_date)=' . $year;
-        }
-        
-        if ($monthnum != '') {
-            $monthnum = '' . intval($monthnum);
-            $where .= ' AND MONTH(post_date)=' . $monthnum;
-        }
-        
-        if ($day != '') {
-            $day = '' . intval($day);
-            $where .= ' AND DAYOFMONTH(post_date)=' . $day;
-        }
-            $p = $wpdb->get_var("SELECT ID FROM $tableposts WHERE post_name = '$name' $where");
-        }
-        $post_data = get_postdata($p);
-        $title = strip_tags(stripslashes($post_data['Title']));
+    if ($single) {
+        $title = strip_tags(stripslashes($posts[0]->post_title));
         $title = apply_filters('single_post_title', $title);
     }