Navigation

Changeset 3510 for trunk/wp-commentsrss2.php

Timestamp:

02/09/06 10:03:48 (3 years ago)

Author:

ryan

Message:

Allow draft pages. Use post_type for object types. Reserve post_status strictly for status. fixes #1820

Files:

r3314	r3510
33	33	$wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments
34	34	LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE comment_post_ID = '$id'
35		AND $wpdb->comments.comment_approved = '1' AND $wpdb->posts.post_status ~~IN ('publish', 'static', 'object~~')
	35	AND $wpdb->comments.comment_approved = '1' AND $wpdb->posts.post_status = 'publish')
36	36	AND post_date_gmt < '" . gmdate("Y-m-d H:i:59") . "'
37	37	ORDER BY comment_date_gmt DESC LIMIT " . get_settings('posts_per_rss') );
…	…
40	40	comment_author_url, comment_date, comment_date_gmt, comment_content, comment_post_ID,
41	41	$wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments
42		LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE $wpdb->posts.post_status ~~IN ('publish', 'static', 'object')~~
	42	LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE $wpdb->posts.post_status = 'publish'
43	43	AND $wpdb->comments.comment_approved = '1' AND post_date_gmt < '" . gmdate("Y-m-d H:i:s") . "'
44	44	ORDER BY comment_date_gmt DESC LIMIT " . get_settings('posts_per_rss') );