[wp-hackers] Get comments from post-types and from current author

Joaquin Rodriguez Montero yojoaquin at gmail.com
Thu Jul 1 19:14:28 UTC 2010


Hi guys!

Quick question if I may. I'm trying to get last 10 comments from a question
post type on one part of the site and I'm trying to get last 10 comments
from that post-type but from posts published by the logged user..

I thought including the following code:

$pre_HTML ="";
$post_HTML ="";
global $wpdb;
$author = get_the_author_ID;
$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID,
comment_post_ID, comment_author, comment_date_gmt, comment_approved,
comment_type,comment_author_url, SUBSTRING(comment_content,1,30) AS
com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON
($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved =
'1' AND comment_type = '' AND post_password = '' AND author_ID = $author
ORDER BY comment_date_gmt DESC LIMIT 10";

$comments = $wpdb->get_results($sql);
$output = $pre_HTML;
$output .= "\n<ul>";
foreach ($comments as $comment) {
    $output .= "\n<li>".strip_tags($comment->comment_author) .":" . "<a
href=\"" . get_permalink($comment->ID)."#comment-" .    $comment->comment_ID
. "\" title=\"on ".$comment->post_title . "\">" .
strip_tags($comment->com_excerpt)."</a></li>";
}
    $output .= "\n</ul>";
    $output .= $post_HTML;
echo $output;

But I can't retrieve a thing.. any idea?

Chocks


More information about the wp-hackers mailing list