Changeset 262 for trunk/xpressme_integration_kit/wp-content/themes/xpress_default/blocks/recent_comments_block_theme.php

Timestamp:

Jun 8, 2009, 5:55:59 PM (15 years ago)

Author:

toemon

Message:

#137 WordPressME2.0.11への対応(ブロックの対応）

File:

• trunk/xpressme_integration_kit/wp-content/themes/xpress_default/blocks/recent_comments_block_theme.php (modified) (1 diff)

trunk/xpressme_integration_kit/wp-content/themes/xpress_default/blocks/recent_comments_block_theme.php

@@ -46 +46 @@
                 $comment_sql  = "SELECT comment_ID,comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_content, comment_type,UNIX_TIMESTAMP(comment_date) as comment_unix_time ";
                 $comment_sql .= "FROM $wpdb->comments LEFT JOIN $wpdb->posts ON  $wpdb->posts.ID = $wpdb->comments.comment_post_ID ";
-                $comment_sql .= "WHERE comment_approved = '1' AND post_type = 'post'  AND post_status = 'publish' $type_select ";
+                if (xpress_is_wp20()){
+                        $comment_sql .= "WHERE comment_approved = '1' AND post_status = 'publish' $type_select ";
+                } else {
+                        $comment_sql .= "WHERE comment_approved = '1' AND post_type = 'post'  AND post_status = 'publish' $type_select ";
+                }
                 $comment_sql .= "ORDER BY comment_date_gmt DESC LIMIT $disp_count";
-
                 $comments = $wpdb->get_results($comment_sql);