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

[Joaquin Rodriguez Montero]

Sorry I've written before trying +10 alternatives. I found the solution:
might be useful for someone:

global $current_user;
        //get_currentuserinfo();
        $author = $current_user->ID;
        $pre_HTML ="";
        $post_HTML ="";
        global $wpdb;
        $sql = "SELECT DISTINCT ID, post_title, post_password, post_type,
comment_ID, comment_post_ID, comment_author, comment_date_gmt,
comment_approved, post_author,comment_type,comment_author_url,
SUBSTRING(comment_content,1,70) 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 post_type = 'question' AND post_author = $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;



On Thu, Jul 1, 2010 at 4:14 PM, Joaquin Rodriguez Montero <
yojoaquin at gmail.com> wrote:

> 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
>