<?php
include_once("./_common.php");
?>
<style type="text/css">
.pl_rank2{clear:both;position:relative;margin:0 auto;width:100%; }
.pl_rank2 h2{padding:0 10px;height:28px;line-height:2.4em;background:#6a6e87;color:#fff}
.pl_rank2_ul{padding:3px 0 0}
.pl_rank2_ul ul{float:left;width:100%;margin:0;padding:0;overflow:hidden;list-style:none}
.pl_rank2_ul ul li{position:relative;line-height:18px;margin:5px 0; }
.pl_rank2_ul ul li .rank_bg{display:inline-block;width:17px;height:17px;margin-right:8px;text-align:center;color:#fff;background:#b3b8c0;text-indent:-1px;border-radius:2px}
.pl_rank2_ul ul li .rank_bg1{color:#fff;background:#da0000}
.pl_rank2_ul ul li .rank_bg2{color:#fff;background:#fdb800}
.pl_rank2_ul ul li .rank_bg3{color:#fff;background:#657bc8}
.pl_rank2_ul ul li .rank_point{display:inline-block;position:absolute;top:0;right:2px;font-family:verdana;color:#C02027;font-size:11px;font-weight:bold}
</style>
<div style="width:100%; height:290px; padding:10px; border:3px solid #dddddd; background: #F6F6F6;">
    <div class="pl_rank2">
    인기 픽스터 Best 10 
    <div class="pl_rank2_ul">
    <ul>
    <?php
    // $sql_common = " and mb_id != '{$config[cf_admin]}' "; 최고 관리자만 비노출
    $sql_common = " and mb_level < 9 "; // 9레벨 이하만 노출
    $rank_rows = 10; //출력 수
    $sql = " select * from {$g5[member_table]} where mb_point > '{$row[mb_point]}' {$sql_common} order by mb_point desc, mb_today_login desc limit {$rank_rows} ";
    $result = sql_query($sql);
    for ($i=0; $row=sql_fetch_array($result); $i++) {
        $rank = number_format($i + 1);
        //$name = get_sideview($row['mb_id'], $row['mb_nick'], $row['mb_email'], $row['mb_homepage']);
        $name = $row['mb_nick'];
        $mbid = $row['mb_id'];
        $point = number_format($row['mb_point']);
        if ($rank == 1) {
            $rank_bg = ' rank_bg1';
        } else if ($rank == 2) {
            $rank_bg = ' rank_bg2';
        } else if ($rank == 3) {
            $rank_bg = ' rank_bg3';
        } else {
            $rank_bg = '';
        }
    ?>
    <?php
    //게시물수 뽑기 
 $results = sql_query(" SELECT bo_table FROM $g5[board_table] "); 
  $mbid2 = $row['mb_id'];
  $all_com = 0; 
  $all_art= 0; 
  $i2=0; 
    while ($row13 = sql_fetch_array($results)) { 
    
 $i2++; //테이블수 
    //총게시물 
    //$gul_su="select count(wr_is_comment) as ctt from g5_write_$row13[bo_table] where wr_is_comment='0' "; 
    
    //총코멘트 
    //$co_su="select sum(wr_is_comment) as ctt2 from g5_write_$row13[bo_table] where wr_is_comment='1' ";  
    //회원의 글수
    $gul_su="select count(wr_is_comment) as ctt from g5_write_$row13[bo_table] where wr_is_comment='0' and mb_id = '$mbid2' "; 
    //회원의 코멘트수
    $co_su="select sum(wr_is_comment) as ctt2 from g5_write_$row13[bo_table] where wr_is_comment='1' and mb_id = '$mbid2' "; 
    
    //게시물 
    $article = sql_fetch($gul_su); 
    $article_su=$article[ctt]; 
    $all_art= $all_art +$article_su; 
    
    //코멘트 
    $comm= sql_fetch($co_su); 
    $comm_su=$comm[ctt2]; 
    $all_com = $all_com+$comm_su; 
 } 

?>
        <li><a href="<?php echo G5_BBS_URL ?>/board.php?bo_table=01_04&sca=&frame=&sfl=wr_name%2C1&sop=and&stx=<?php echo $name ?>"><span class="rank_bg<?php echo $rank_bg; ?>"><?php echo $rank; ?></span><?php echo $name; ?><span class="rank_point "><span style="color:#002CDC;"><?=number_format($all_art)?>S</span>  <?php echo $point; ?>P</span></a></li>
    <?php } ?>
    </ul>
    </div>
    </div>
</div>