<?
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.php");
// 회원레벨별 제한
//if($member[mb_level] <= 2) { //2레벨이하는 홈페이지 메인으로 튕겨주기*^^*
//alert("로그인 하시면 포인트 획득과 함께 페이지를 보실 수 있습니다.", $g4[path]);
//}
define("_CO_POINT_RANK_", TRUE);

$html_title = "포인트순위";
$g4[title] = "" . $html_title;
include_once("$g4[path]/_head.php");

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

<a href="<?=$g4['path']?>/sub/point_rank.php"><img src="<?=$g4['path']?>/sub/title/point_rank.jpg"></a>

<table width=90% align=center border=0 cellspacing=0 cellpadding=1>
<tr><td valign=top colspan=2 class=lh bgcolor=cccccc>

<table width=100% bgcolor=ffffff cellspacing=0 cellpadding=19><tr><td valign=absmiddle>
<?
if ($member[mb_id])
{
    $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);
    echo "· 현재 <font color=blue>$member[mb_nick]</font> 회원님의 포인트 순위는 <B><font color=red>".number_format($row[cnt])."등</font></B> 입니다.";
echo "<br>· 번호는 포인트 획득순입니다.";

}

$sql = " select sum(mb_point) as sum_point from $g4[member_table]";
$row = sql_fetch($sql);
$sum_point = $row[sum_point];
echo "<br>· 전체 포인트 : <B>".number_format($sum_point) . "점</b>";
echo "</td></tr></table></td></tr></table>";
echo "<table width=100%><tr><td valign=top width=''>";

$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = 60; // 한페이지에 보일수
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 20;   // 한페이지에서 세로로 몇명? 

######################################################
$detail_search=false;
$stx=trim($stx);
$sfl=trim($sfl);
//echo"검색선택:$sfl     써치말: $stx";
if($sfl =='mb_name' && $stx !='')
{$sql = " select * from $g4[member_table] 
          where mb_name='$stx' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
          $detail_search=true;
}else if($sfl =='mb_id' && $stx !='')
{$sql = " select * from $g4[member_table] 
          where mb_id='$stx' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
          $detail_search=true;
}else if($sfl =='mb_nick' && $stx !='')
{$sql = " select * from $g4[member_table] 
          where mb_nick='$stx' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
          $detail_search=true;
}else if($sfl =='mb_email' && $stx !='' )
{$sql = " select * from $g4[member_table] 
          where mb_email='$stx' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
          $detail_search=true;
}else if($sfl =='mb_tel' && $stx !='')
{$sql = " select * from $g4[member_table] 
          where mb_tel='$stx' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
    $detail_search=true;
}else if($sfl =='mb_hp' && $stx !='')
{$sql = " select * from $g4[member_table] 
          where mb_hp like '%$stx%' and mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc";
          $detail_search=true;
}else if($sfl =='' || $stx ==''){
 $sql = " select * from $g4[member_table]  where mb_id <> '$config[cf_admin]'
          order by mb_point desc, mb_today_login desc limit $from_record, $rows ";
          $detail_search=false;
 }
##########################################2006.02.14 dalsoo##
$result = sql_query($sql);

for ($i=0; $row=sql_fetch_array($result); $i++)
   { 
 //검색결과가 있고//전체검색이 아니면
    if($result && $detail_search==true) { $listcolor='#DEEBF3';} 
 //자신의 아이디면
 else if($row[mb_id]==$member[mb_id]) {$listcolor='#FFE8C0';}
 //이도저도아니면
 else{$listcolor='#f8f8f9';}
    if ($i && $i%$mod==0)
        echo "</td><td width=2 bgcolor=cccccc></td><td valign=top>";
    $rank = (($page - 1) * $rows) + $i + 1;
    //$name = get_sideview($row[mb_id], $row[mb_name], $row[mb_email], $row[mb_homepage]);
 $mb_nick = $row[mb_nick];
    $point = number_format($row[mb_point]);
    echo "<table width=90% cellpadding=0 align=center class=box border=0 bgcolor='$listcolor';><tr>";
    //echo "<td height=30>$rank. $name</td>";
    echo "<td height=25>$rank. <font color=blue>$mb_nick</font></td>";
    echo "<td align=right><font color=777777>{$point}점    </font></td>";
    echo "</tr></table>";    
    echo "<table width=100% align='center'><tr><td></td></tr></table>";
}
?>
</td></tr>
</table>

<table height=1 width=100%><tr><td bgcolor=black></td></tr></table>

<table width=100%>
 <?$my_sfl=$sfl;
    if($my_sfl=="") $my_sfl="mb_name";
    //$stx="";
 ?>
 <form name=fsearch method=get style="margin:0px;">
  <input type=hidden name=bo_table value="<?=$bo_table?>">
  <!--input type=hidden name=sca      value="<?=$sca?>"-->
  <table width=90% cellpadding=0 cellspacing=0>                     
     <tr>
     <td width="50%" height="40">
      <?=$listall?> ( 총회원수 : <?=number_format($total_count)?><!--, <font color=orange>차단 : <?=number_format($intercept_count)?></font>, <font color=crimson>탈퇴 : <?=number_format($leave_count)?></font--> )
     </td>
                    <?
                     $sfl_array = array(
      "mb_id" =>"회원아이디",
      "mb_name" =>"이름   ",
      "mb_nick" =>"별명   ",
      "mb_email" =>"E-MAIL   ",
      "mb_tel" =>"전화번호   ",
      "mb_hp" =>"핸드폰번호",
      );reset($sfl_array);
                     //select box에 변화를..예)핸폰검색
                     if($my_sfl=='mb_name') { $goingcolor='#DEEBF3'; $goingTcolor='#000715';}
                      else if($my_sfl=='mb_id'){$goingcolor='#DEEBF3'; $goingTcolor='#000715';}
                      else if($my_sfl=='mb_nick'){$goingcolor='#DEEBF3'; $goingTcolor='#000715';}
                      else if($my_sfl=='mb_email'){$goingcolor='#DEEBF3'; $goingTcolor='#000715';}
                      else if($my_sfl=='mb_tel'){$goingcolor='#DEEBF3'; $goingTcolor='#000715';}
                      else if($my_sfl=='mb_hp'){$goingcolor='#CC0000'; $goingTcolor='#FFFFFF';}
                      else {$goingcolor='#666666';$goingTcolor='#000715';}
                     ?>
                     <td  width="50%" align="right" align='left' style='padding-left:0pt; padding-right:8pt;' style='padding-top:3pt;'>
       <select name="sfl" style="background-color:'<?=$goingcolor?>';
          IME-MODE: inactive; overflow-y:auto; overflow-x:hidden;
          border-width:1 1 1 1; border-color:#F7F7F7;
       border-style:solid; margin:2 0 0 0; color:'<?=$goingTcolor?>'">
        <option value="<?echo"$my_sfl";?>" selected>
        <?echo"$sfl_array[$my_sfl]";?></option>
        <?php
         while (list($key,$value)=each($sfl_array)) {
         echo "<option value='$key'>$value</option>";}
         ?>
        </select> 
        <input
          name=stx maxlength='15' size='15' itemname='검색어' value=""
          style="background-color:'<?=$goingcolor?>';
          IME-MODE: inactive; overflow-y:auto; overflow-x:hidden;
          border-width:1 1 1 1; border-color:#5C605F;
       border-style:solid; margin:0 0 2 0; color:'<?=$goingTcolor?>'">
        <!-- =$member[mb_name]-->
        <input type='image' src="<?=$g4[admin_path]?>/img/btn_search.gif" border='0' align='absmiddle'>
     </td>                     

    
    </tr>
  </table>
 </form>
 <?
  $page = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
  echo "<p><table width=100% cellpadding=0 cellspacing=0><tr><td align=center>$page</td></tr></table><br><br>";
  include_once("$g4[path]/_tail.php");
 ?>

 

 

지금 사용하고 있는 포인트 랭킹인데요.

여기서 7레벨 이상회원은 제외 하려면 어떻게 해야 하나요?