아래는 포인트랭킹소스 입니다.

순위 외에 1등만 따로 빼내고 싶습니다.

(이미지)1등 홍길동 <<<<<<<<< 여기요~~~
1.
2.
3.
.
.
.
이런식으로요. 부탁드립니다^^

<?
include_once("./_common.php");

define("_CO_POINT_RANK_", TRUE);

$html_title = "포인트순위";
$g4[title] = "" . $html_title;

include_once("./_head.php");

echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>

<div style="border:1px solid #ddd; height:34px; background:url(<?=$g4['path']?>/img/title_bg.gif) repeat-x;">
<table width="100%" border="0" cellspacing="1" cellpadding="0" align=center style="font-weight:bold;  color:#505050;">
<tr height="30" align=center>
    <td align="center">포인트 순위</td>
</tr>
</table>
</div>
<div style="height:3px; background:url(<?=$connect_skin_path?>/img/title_shadow.gif) repeat-x; line-height:1px; font-size:1px;"></div>

<table width=70% border="0" cellspacing="0" cellpadding="0" align=center bgcolor="#FFFFFF" style="padding:0 7px 0 7px;">
<tr><td valign=top colspan=2 class=lh>
<?

$sql = " select count(mb_id) as cnt from $g4[member_table]
           where mb_id not in ('admin') and mb_point >= '$member[mb_point]' order by mb_point desc "; // 관리자 아이디는 포인트 순위에서 제외
$row = sql_fetch($sql);
//echo "<br>· 현재 <b>$member[mb_nick]</b> 님의 포인트 순위는 <B>".number_format($row[cnt])."등</B> 입니다.";

$sql = " select sum(mb_point) as sum_point from $g4[member_table]";
$row = sql_fetch($sql);
$sum_point = $row[sum_point];
 
echo "<br>· 현재 <b>".$member[mb_nick]."</b>님의 포인트는 <B>".$member[mb_point]."점</B>";
   $sql = " select count(mb_id) as cnt from $g4[member_table]
              where mb_point >= '$member[mb_point]' order by mb_point desc ";
    $row = sql_fetch($sql);
  
  $sql2 = " select count(mb_id) as cnt from $g4[member_table]";
    $row2 = sql_fetch($sql2);
  $total_count = $row2[cnt]-1;
    echo " 이고, 랭킹은 전체회원수 <b>".$total_count."</b>명중 <B>".number_format($row[cnt]-1)."등</B> 입니다.<br><br>";

//echo "<br>· 전체 포인트 : <B>".number_format($sum_point) . "점</b><br><br>";

echo "</td></tr><tr><td valign=top width=50%>";

$keyword_yi="";
if($_GET[keyword]!="") {
    if($_GET[type]==0)
        $keyword_yi=" and mb_name like '%$_GET[keyword]%' ";
    if($_GET[type]==1)
        $keyword_yi=" and mb_nick like '%$_GET[keyword]%' ";
    if($_GET[type]==2)
        $keyword_yi=" and mb_id='$_GET[keyword]'";
}

$sql = " select * from $g4[member_table] where mb_id <> '$config[cf_admin]' $keyword_yi ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = 50;
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$mod = 25;

$sql = " select * from $g4[member_table] where mb_id <> '$config[cf_admin]' $keyword_yi
          order by mb_point desc, mb_today_login desc
          limit $from_record, $rows "; // 관리자 아이디는 포인트 순위에서 제외
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
    if ($i && $i%$mod==0)
        echo "</td><td valign=top>";

    if($_GET[keyword]!="") {
        $sql = " select * from $g4[member_table] where mb_id <> '$config[cf_admin]' and mb_point >= '$row[mb_point]' order by mb_point desc "; // 관리자 아이디는 포인트 순위에서 제외
        $row2 = sql_fetch($sql);
        $rank = $row2[cnt];
    } else {
        $rank = (($page - 1) * $rows) + $i + 1;
    }
   
    $name = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
    $point = number_format($row[mb_point]);
 //$level = get_member_level($row[mb_id],$row[mb_point]); //레벨 아이콘 표시
    echo "<table width=100% cellpadding=0 cellspacing=0 align=center class=box border=0><tr onMouseOver=this.style.backgroundColor='#F3F3F3' onMouseOut=this.style.backgroundColor=''>";
    echo "<td height=30><nobr>$rank. $name  </nobr></td>";
    echo "<td width=100%>";
    echo "<table width=100% cellpadding=0 align=center border=0><tr><td>";
 exp_bar($row[mb_id],$row[mb_point],1);
    echo "</td></tr></table>";
    echo "</td>";
    echo "<td align=right><font color=777777><nobr>{$point}점</nobr></font></td>";
    echo "</tr></table>";
    echo "<table width=100%><tr><td></td></tr></table>";
}
?>
</td></tr>
</table>

<form id="form1" name="form1" method="get" action="">
<?
$qstr = "type=$_GET[type]&keyword=$_GET[keyword]";
$page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<p><table width=100% cellpadding=0 cellspacing=0><tr><td width=50% align=center>$page</td></tr>";
?>
<td align=center valign="middle">
         <select name="type" id="type">
           <option value="0" <?php if($_GET[type]==0){ echo "selected";}?>>이름</option>
           <option value="1" <?php if($_GET[type]==1){ echo "selected";}?>>닉네임</option>
           <option value="2" <?php if($_GET[type]==2){ echo "selected";}?>>아이디</option>
         </select>
         <input name="keyword" type="text" id="keyword" size="15" value="<?=$_GET[keyword]?>"/>
         <input type=image src="<?=$g4['path']?>/img/search_btn.gif" border=0 align=absmiddle>
</td>
</tr></table>
</form>

<?
include_once("./_tail.php");
?>