Changeset 558 for trunk/b2-include/b2functions.php

Timestamp:

11/25/2003 12:46:52 AM (22 years ago)

Author:

mikelittle

Message:

Missing querycount

File:

• trunk/b2-include/b2functions.php (modified) (5 diffs)

trunk/b2-include/b2functions.php

@@ -479 +479 @@
 // determine the post ID it represents.
 function url_to_postid($url = '') {
-    global $wpdb, $tableposts, $siteurl;
+    global $wpdb, $querycount, $tableposts, $siteurl;
 
     // Take a link like 'http://example.com/blog/something'
@@ -537 +537 @@
 
     // Run the query to get the post ID:
-    return intval($wpdb->get_var("SELECT ID FROM $tableposts WHERE 1 = 1 " . $where));
+    ++$querycount;
+    return intval($wpdb->get_var("SELECT ID FROM $tableposts WHERE 1 = 1 " . $where));
 }
 
@@ -682 +683 @@
         $default = $postdata["Category"];
     }
+    ++$querycount;
     foreach($results as $post) {
         echo "<option value=\"".$post->cat_ID."\"";
@@ -1440 +1442 @@
  */
 function wp_get_comment_status($comment_id) {
-    global $wpdb, $tablecomments;
+    global $wpdb, $querycount, $tablecomments;
     
     $result = $wpdb->get_var("SELECT comment_approved FROM $tablecomments WHERE comment_ID='$comment_id' LIMIT 1");
+    ++$querycount;
     if ($result == NULL) {
-    return "deleted";
+        return "deleted";
     } else if ($result == "1") {
-    return "approved";
+        return "approved";
     } else if ($result == "0") {
-    return "unapproved";
+        return "unapproved";
     } else {
-    return false;
+        return false;
     }
 }
 
 function wp_notify_postauthor($comment_id, $comment_type) {
-    global $wpdb, $tablecomments, $tableposts, $tableusers;
+    global $wpdb, $querycount, $tablecomments, $tableposts, $tableusers;
     global $querystring_start, $querystring_equal, $querystring_separator;
     global $blogfilename, $blogname, $siteurl;
     
     $comment = $wpdb->get_row("SELECT * FROM $tablecomments WHERE comment_ID='$comment_id' LIMIT 1");
+    ++$querycount;
     $post = $wpdb->get_row("SELECT * FROM $tableposts WHERE ID='$comment->comment_post_ID' LIMIT 1");
+    ++$querycount;
     $user = $wpdb->get_row("SELECT * FROM $tableusers WHERE ID='$post->post_author' LIMIT 1");
+    ++$querycount;
 
     if ('' == $user->user_email) return false; // If there's no email to send the comment to
@@ -1512 +1518 @@
  */
 function wp_notify_moderator($comment_id) {
-    global $wpdb, $tablecomments, $tableposts, $tableusers;
+    global $wpdb, $querycount, $tablecomments, $tableposts, $tableusers;
     global $querystring_start, $querystring_equal, $querystring_separator;
     global $blogfilename, $blogname, $siteurl;
     
     $comment = $wpdb->get_row("SELECT * FROM $tablecomments WHERE comment_ID='$comment_id' LIMIT 1");
+    ++$querycount;
     $post = $wpdb->get_row("SELECT * FROM $tableposts WHERE ID='$comment->comment_post_ID' LIMIT 1");
+    ++$querycount;
     $user = $wpdb->get_row("SELECT * FROM $tableusers WHERE ID='$post->post_author' LIMIT 1");
+    ++$querycount;
 
     $comment_author_domain = gethostbyaddr($comment->comment_author_IP);
     $comments_waiting = $wpdb->get_var("SELECT count(comment_ID) FROM $tablecomments WHERE comment_approved = '0'");
+    ++$querycount;
 
     $notify_message  = "A new comment on the post #$comment->comment_post_ID \"".stripslashes($post->post_title)."\" is waiting for your approval\r\n\r\n";