Changeset 3076
- Timestamp:
- 11/14/05 10:04:25 (3 years ago)
- Files:
-
- trunk/wp-commentsrss2.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/wp-commentsrss2.php
r2958 r3076 34 34 LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE comment_post_ID = '$id' 35 35 AND $wpdb->comments.comment_approved = '1' AND $wpdb->posts.post_status IN ('publish', 'static', 'object') 36 AND post_date < '".date("Y-m-d H:i:59")."'37 ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') );36 AND post_date_gmt < '" . gmdate("Y-m-d H:i:59") . "' 37 ORDER BY comment_date_gmt DESC LIMIT " . get_settings('posts_per_rss') ); 38 38 } else { // if no post id passed in, we'll just ue the last 10 comments. 39 39 $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, … … 41 41 $wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments 42 42 LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE $wpdb->posts.post_status IN ('publish', 'static', 'object') 43 AND $wpdb->comments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."'44 ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') );43 AND $wpdb->comments.comment_approved = '1' AND post_date_gmt < '" . gmdate("Y-m-d H:i:s") . "' 44 ORDER BY comment_date_gmt DESC LIMIT " . get_settings('posts_per_rss') ); 45 45 } 46 46 // this line is WordPress' motor, do not delete it.
