comments LEFT JOIN $wpdb->posts ON $wpdb->posts.ID = $wpdb->comments.comment_post_ID "; if (xpress_is_wp_version('<','2.1')){ $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); if ( $comments ) { $output .= '

'; $item_no = 0; foreach ($comments as $comment){ $comment_content = $comment->comment_content; $comment_excerpt = ($disp_length>0 ? xpress_substr($comment_content, 0, $disp_length): $comment->comment_content); $comment_link = get_comment_link($comment->comment_ID); $comment_title = $comment_excerpt; $comment_title_link = "$comment_title"; $post_link = get_permalink($comment->comment_post_ID); $post_title = get_the_title($comment->comment_post_ID); $post_title_link = '' . $post_title . ''; $author_link = $comment->comment_author_url; $author_name = $comment->comment_author; $author_name_link = (( empty( $author_link ) || 'http://' == $author_link ) ? $author_name : "$author_name"); $comment_type = (empty($comment->comment_type) ? 'comment': $comment->comment_type); $post_title_comment_link = '' . $post_title . ''; $from_auther_to_post = sprintf(__('%1$s on %2$s','xpress'), $author_name_link , $post_title_comment_link ); $row_data = array( 'comment_ID' => $comment->comment_ID , 'comment_post_ID' => $comment->comment_post_ID , 'comment_date' => date($date_format,$comment->comment_unix_time) , 'comment_date_time' => date($date_format . ' ' . $time_format,$comment->comment_unix_time) , 'comment_content' => $comment_content , 'comment_excerpt' => $comment_excerpt , 'comment_link' => $comment_link, 'comment_title' => $comment_title , 'comment_title_link' => $comment_title_link , 'post_link' => $post_link, 'post_title' => $post_title, 'post_title_link' => $post_title_link, 'author_link' => $author_link, 'author_name' => $author_name, 'author_name_link' => $author_name_link, 'comment_type' => $comment_type, 'from_auther_to_post' => $from_auther_to_post ); $block['contents']['item'.$item_no] = $row_data; $item_no++; } $block['data_count'] = $item_no; } } return $block ; } ?>