Navigation

Changeset 2519

Timestamp:

04/07/05 19:17:28 (3 years ago)

Author:

ryan

Message:

Fix comment feed queries for pages. http://mosquito.wordpress.org/view.php?id=1216 Props: mdawaffe

Files:

r2462	r2519
34	34	$wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments
35	35	LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE comment_post_ID = '$id'
36		AND $wpdb->comments.comment_approved = '1' AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = '~~page~~')
	36	AND $wpdb->comments.comment_approved = '1' AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static')
37	37	AND post_date < '".date("Y-m-d H:i:59")."'
38	38	ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') );
…	…
41	41	comment_author_url, comment_date, comment_content, comment_post_ID,
42	42	$wpdb->posts.ID, $wpdb->posts.post_password FROM $wpdb->comments
43		LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE ~~$wpdb->posts.post_status = 'publish'~~
	43	LEFT JOIN $wpdb->posts ON comment_post_id = id WHERE ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'static')
44	44	AND $wpdb->comments.comment_approved = '1' AND post_date < '".date("Y-m-d H:i:s")."'
45	45	ORDER BY comment_date DESC LIMIT " . get_settings('posts_per_rss') );