월간포인트랭크 다시 질문 올려요. 채택완료

</p>

<p><table width="100%">

    <?php

    $rank_nowdate = date("Y-m",time()); // 이번달

    $rank_sql = "select * , count(B.mb_id) as count, sum(B.po_point) as point from {$g5['member_table']} as A

        left join {$g5['point_table']} as B 

        on (A.mb_id = B.mb_id and A.mb_level < 10 and A.mb_point >= 0)

        where date_format(B.po_datetime,'%Y-%m') = '{$rank_nowdate}' 

        group by B.mb_id order by point desc LIMIT 0, 10 

    ";

    $rank_result = sql_query($rank_sql);

    //echo $rank_sql;

    ?>

    <tr>

        <td colspan="3" style="text-align:center; background-color:#39F; font-size:1.2em; font-weight:bold; color:#fff; line-height:30px; padding:3px 0;">

             포인트 순위

            <span style="font-size:0.9em;">(<?php echo substr($rank_nowdate, 0, 4)."년"; ?> <?php echo substr($rank_nowdate,5,2)."월"; ?>)</span>

        </td> 

    </tr>

    <?php

    for ($i=1; $rank_row=sql_fetch_array($rank_result); $i++) 

    { 

        $rank_member = sql_fetch("select mb_id, mb_nick, mb_email, mb_homepage from {$g5['member_table']} where mb_id = '".$row_rank['mb_id']."'"); 

        $rank_sideview = get_sideview($tmp_member['mb_id'], cut_str($tmp_member['mb_nick'], $config['cf_cut_name']), $tmp_member['mb_email'], $tmp_member['mb_homepage']); 

    ?>

    <tr style="border-bottom:1px dotted #CCC;">

        <td style="width:70px; text-align:center; line-height:26px;"><?php echo $i; ?></td>

        <td><?php echo $rank_sideview; ?></td>

        <td style="text-align:right; padding-right:20px;"><?php echo number_format($rank_row['mb_point']); ?></td>

    </tr>

    <?php

    }

    ?>

</table></p>

<p>

</p>

<p><?php</p>

<p>    include_once "./_common.php";</p>

<p>    $sql_common = " </p>

<p>    from {$g5['member_table']} T1  ";</p>

<p>    $sql_search = " where (1)  ";</p>

<p>    if($stx){</p>

<p>        $sql_search .= " and (mb_nick like '%".$stx."%') ";</p>

<p>    }</p>

<p>    if (!$sst) {</p>

<p>        $sst = "mb_point ";</p>

<p>        $sod = "desc";</p>

<p>    }</p>

<p>    $sql_order = " order by {$sst} {$sod} ";</p>

<p>    $sql = " select count(*) as cnt {$sql_common} {$sql_search} {$sql_order} ";</p>

<p>    $row = sql_fetch($sql);</p>

<p>    $total_count = $row['cnt'];</p>

<p>    if($rows < 1) $rows = 5;</p>

<p>    $total_page  = ceil($total_count / $rows);  // 전체 페이지 계산</p>

<p>    if ($page < 1) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)</p>

<p>    $from_record = ($page - 1) * $rows; // 시작 열을 구함</p>

<p>    //$sql = " select * {$sql_common} {$sql_search} {$sql_order} limit {$from_record}, {$rows} ";</p>

<p>    $sql = " select * {$sql_common} {$sql_search} {$sql_order} limit 0, 50 ";</p>

<p>    $result = sql_query($sql);</p>

<p>?></p>

<p> </p>

<p><?php</p>

<p>    if ($member[mb_id]){ </p>

<p>        include_once G5_LIB_PATH."/level_icon.lib.php"; </p>

<p>    ?></p>

<p><?php } ?> </p>

<p><table></p>

<p>    <tr></p>

<p>        <td colspan="3" style="text-align:center; background-color:#39F; font-size:1.2em; font-weight:bold; color:#fff; line-height:30px; padding:3px 0;"></p>

<p>            전체 포인트 TOP 50</p>

<p>        </td> </p>

<p>    </tr></p>

<p>    <tr class="rank_top"></p>

<p>        <td class="rank_top_menu">순위</td></p>

<p>        <td class="rank_top_menu">닉네임</td></p>

<p>        <td class="rank_top_menu">포인트</td></p>

<p>    </tr></p>

<p>    <?php </p>

<p>    $i = 0;</p>

<p>    while($row = sql_fetch_array($result)){ </p>

<p>        $arr = get_level_icon($row['mb_id']); </p>

<p>        if($i == 0){</p>

<p>            $standard = $row['mb_point'];</p>

<p>        }</p>

<p>        $width = $row['mb_point'] / $standard * 100;</p>

<p>        if($width > 100) $width = 100;</p>

<p>        $i++; </p>

<p>        ?></p>

<p>    <tr></p>

<p>        <td><?php echo (($page-1) * $rows) + $i; ?>위</td></p>

<p>        <td><img class="m_level_img" src="<?php echo G5_IMG_URL . "/level/" . "level_" . $arr['level']; ?>.png" /> <?php echo $row['mb_nick']; ?></td></p>

<p>        <td class="point"><span><em style="width:<?php echo sprintf("%.1f", $width); ?>%"><?php echo $row['mb_point']; ?></em></span></td></p>

<p>    </tr></p>

<p>    <?php } ?></p>

<p>    <?php if($i == 0){ ?></p>

<p>    <tr></p>

<p>        <td colspan="4">검색된 데이터가 업습니다.</td></p>

<p>    </tr></p>

<p>    <?php } ?></p>

<p></table></p>

<p>