Changeset 10450 for branches/2.7/wp-includes/comment.php

Timestamp:

01/28/2009 06:45:15 PM (16 years ago)

Author:

ryan

Message:

Include only approved comments when determining page of comment. Props GregMulhauser. fixes #8973 for 2.7

File:

• branches/2.7/wp-includes/comment.php (modified) (1 diff)

branches/2.7/wp-includes/comment.php

@@ -593 +593 @@
 
     // Count comments older than this one
-    $oldercoms = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_parent = 0 AND comment_date_gmt < '%s'" . $comtypewhere, $comment->comment_post_ID, $comment->comment_date_gmt ) );
+    $oldercoms = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_parent = 0 AND comment_approved = '1' AND comment_date_gmt < '%s'" . $comtypewhere, $comment->comment_post_ID, $comment->comment_date_gmt ) );
 
     // No older comments? Then it's page #1.