From 4f3bce79bfb5851cef9e7bc655c91bb3093cc401 Mon Sep 17 00:00:00 2001 From: donncha Date: Tue, 12 Jul 2005 11:27:54 +0000 Subject: Initial Import git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@1 7be80a69-a1ef-0310-a953-fb0f7c49ff36 --- wp-inst/wp-commentsrss2.php | 76 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 76 insertions(+) create mode 100644 wp-inst/wp-commentsrss2.php (limited to 'wp-inst/wp-commentsrss2.php') diff --git a/wp-inst/wp-commentsrss2.php b/wp-inst/wp-commentsrss2.php new file mode 100644 index 0000000..906d8b9 --- /dev/null +++ b/wp-inst/wp-commentsrss2.php @@ -0,0 +1,76 @@ +'; +?> + + + + + <?php if (is_single() || is_page()) { echo "Comments on: "; the_title_rss(); } else { bloginfo_rss("name"); echo " Comments"; } ?> + + + + http://wordpress.org/?v= + +get_results("SELECT comment_ID, comment_author, comment_author_email, + comment_author_url, comment_date, comment_date_gmt, comment_content, comment_post_ID, + $wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments + LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE comment_post_ID = '$id' + AND $wpdb->comments.comment_approved = '1' AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static') + AND post_date < '".date("Y-m-d H:i:59")."' + ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') ); + } else { // if no post id passed in, we'll just ue the last 10 comments. + $comments = $wpdb->get_results("SELECT comment_ID, comment_author, comment_author_email, + comment_author_url, comment_date, comment_date_gmt, comment_content, comment_post_ID, + $wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments + LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static') + AND $wpdb->comments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."' + ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') ); + } + // this line is WordPress' motor, do not delete it. + if ($comments) { + foreach ($comments as $comment) { +?> + + by: <?php comment_author_rss() ?> + + + + post_password) && $_COOKIE['wp-postpass'] != $comment->post_password) { + ?> + Protected Comments: Please enter your password to view comments. + ]]> + + + ]]> + + + + + -- cgit