>


comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE comment_date > date_sub( NOW(), INTERVAL 24 MONTH ) AND user_id='0' AND comment_post_ID ='118' AND comment_author_email != '330601425@qq.com' AND post_password='' AND comment_approved='1' AND comment_type='') AS tempcmt GROUP BY comment_author_email ORDER BY cnt DESC LIMIT 20"; $wall = $wpdb->get_results($query); $maxNum = $wall[0]->cnt; foreach ($wall as $comment){ $width = round(40/($maxNum / $comment->cnt),2); if( $comment->comment_author_url ) $url = $comment->comment_author_url; else $url="#"; $avatar = get_avatar( $comment->comment_author_email, $size = '36'); $tmp = "
  • comment_author_url."\" title=\"".$comment->comment_author_url."\">".$avatar."".$comment->comment_author." +".$comment->cnt."
  • "; $output .= $tmp; } $output = "
      ".$output."
    "; echo $output ; ?>