邪罗刹的菠萝阁

<?php
$identity="comment_author";
$passwordpost = " AND post_password=''";
$userexclude = " AND user_id='' and comment_author != ''";
$approved = " AND comment_approved='1'";
$shownumber = 15;
$counts = $wpdb->get_results("SELECT COUNT(" . $identity . ") AS cnt, comment_author,
 comment_author_url,comment_author_email 
FROM (SELECT * FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON 
($wpdb->posts.ID=$wpdb->comments.comment_post_ID) WHERE 
MONTH(comment_date)=MONTH(now()) and YEAR(comment_date)=YEAR(now())" .
$userexclude . $passwordpost . $approved . ") AS tempcmt GROUP BY " 
. $identity . " ORDER BY cnt DESC LIMIT " . $shownumber);
?>

<?php /* Please do not remove this line */ global $opt; ?>

<div class="sfbox"><h2>Featured Post</h2><div class="sfpost">
  <?php $my_query = new WP_Query('cat='.$opt['side_feature'].'&showposts='
.$opt['side_feature_num'].'&orderby=rand');
        while ( $my_query->have_posts() ) : $my_query->the_post(); ?>
  <div class="introIMG"><?php echo get_the_image_link
(array('f_img','lead_img'),'thumbnail','/fdefault.gif'); ?></div>
  <?php endwhile; ?>
  </div>
  <div class="clear"></div></div>
	<?php endif; ?>

<!-- Begin -->
<div class="sidebarbox"><h2>Reader Wall</h2><div class="sidebarbox">
<ul class="ffox_most_active">
<?php if ( $counts ) : foreach ($counts as $count) :
echo  '<li>' . '<a rel="nofollow" href="'. $count->comment_author_url 
. '" title="用户：' . $count->comment_author . ' (发表了'. $count->cnt 
. '条评论)"><div class="avatar">' .get_avatar($count->comment_author_email,32)
.'</div><p> '. $count->comment_author .'</p></a></li>';
endforeach; endif;
?>
</ul>
  </div>
  <div class="clear"></div></div>
<!-- End -->

/* ReaderWall */
.sidebarbox .sidebarbox .ffox_most_active li {
padding-left:0; width: 55px; float: left; background: none;
list-style: none; overflow: hidden; border-bottom: none;
}
.sidebarbox .sidebarbox .ffox_most_active img.avatar {
width: 32px; height: 32px; border: solid 1px #d4e7f2;
padding: 1px;
}
.sidebarbox .sidebarbox .ffox_most_active p {
padding-top: 1px; float: left; width: 37px; height: 13px;
line-height: 12px; text-align: center; white-space: nowrap;
overflow: hidden;
}