水榜之血条

function get_most_active_friends()
{
    $db = Typecho_Db::get();
    $sql = $db->select('COUNT(author) AS cnt','author', 'url', 'mail')
        ->from('table.comments')
        ->where('status = ?', 'approved')
        ->where('type = ?', 'comment')
        ->where('authorId = ?', '0')
        ->where('mail != ?', 'icesword28@qq.com')
        ->group('author')
        ->order('cnt', Typecho_Db::SORT_DESC)
        ->limit('');//这里面填写读取前几位用户
    $result = $db->fetchAll($sql);
    $mostactive = "";
    $option = Typecho_Widget::widget('Widget_Options')->plugin('GravatarCache');
    $maxNum = $result[0]['cnt'];
    foreach ($result as $one)
    {
        $width = round(36 / ($maxNum / $one['cnt']),2);//这里是血条长度的计算公式
        $mostactive .= '<li title="'.$one['author'].'＠'.$one['cnt'].'">
  ';
          $mostactive .= '<div class="imgactive">
    <img class="avatar" src="/usr/cache/avatar/';
        if(file_exists($option->dir.'/'.md5(strtolower($one['mail'])).'.jpg')) { 
            $mostactive .= md5(strtolower($one['mail']));
        } else {
            $mostactive .= 'default';
        }
        $mostactive .= '.jpg" />
  </div>';
          $mostactive .= '
  
  <div class="bgactive">
    <div class="degreeactive" style="width:'.$width.'px">
      
    </div>
  </div>
</li>';
    }
    echo $mostactive;
}

#content .mostactive li{
    border:1px solid #DFDFDF;
    border-radius:2px 2px 2px 2px;
    float:left;
    height:42px;
    list-style:none outside none;
    margin:0 11px 11px 0;
    padding:5px;
    width:36px
}
#content .mostactive .imgactive,#content .mostactive .imgactive img{
    display:block;
    width:36px;
    height:36px
}
#content .mostactive .bgactive{
    background:none repeat scroll 0 0 #DFDFDF;
    height:2px;
    margin-top:5px;
    width:36px
}
#content .mostactive .degreeactive{
    background:none repeat scroll 0 0 #1E5494;
    height:2px;
    width:36px
}