기본 소스에서 임원진들을 순위에서 추가 혹은 제외할수 있도록 수정하였습니다.

통합포인트 사용중이신분만 사용하세요~

<?
// 라이브러리 함수 파일 인크루드
        include "lib.php";

// DB 연결
        if(!$connect) $connect=dbConn();

// 멤버정보 구하기
        $member=member_info();

        if(!$member[no]) Error("로그인된 회원만이 사용할수 있습니다","window.close");

// 그룹데이타 읽어오기;;
        $group_data=mysql_fetch_array(mysql_query("select * from $group_table where no='$member[group_no]'"));




        head("bgcolor=white");
?>
<script>
  function reverse() {
   var i, chked=0;
   for(i=0;i<document.list.length;i++)
   {
    if(document.list[i].type=='checkbox')
    {
     if(document.list[i].checked) { document.list[i].checked=false; }
     else { document.list[i].checked=true; }
    }
   }
  }
</script>


<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="15"><img src="./images/memo_topleft.gif" width="15" height="50"></td>
    <td background="images/memo_topbg.gif">
      <img src="./images/t.gif" width="10" height="2"><br>
      <font style=font-size:11pt;font-weight:bold>&nbsp;포인트 순위 - Top 20</font></td>
    <td width="15"><img src="./images/memo_topright.gif" width="156" height="50"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr>
 <td nowrap>&nbsp;&nbsp;&nbsp;<a href=http://www.xpressengine.com/member_memo.php><img src=images/vi_B_inbox.gif border=0></a> <a href=member_memo2.php><img src=images/vi_B_sent.gif border=0></a> <a href=member_memo3.php><img src=images/vi_B_write.gif border=0></a> <a href=rank.php><img src=images/ranking.gif border=0></a></td>
  </tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="15"><img src="./images/memo_listtopleft.gif" width="17" height="17"></td>
    <td background="images/memo_listtop.gif"><img src="./images/t.gif" width="10" height="5"></td>
    <td width="15"><img src="./images/memo_listtopright.gif" width="17" height="17"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="17" background="images/memo_listleftbg.gif"><img src="./images/t.gif" width="17" height="10"></td>
    <td>

                <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr align="center">
                        <td>순위</td>
                        <td>아이디</td>
                        <td>이름</td>
                        <td>포인트</td>
                </tr>
                <tr height=1>
                        <td colspan='6'></td>
                </tr>
<?

// 정렬에 대한 테이블 리드 입니다.
if(!$sort) $sort="point";
if ($sort =="point")
        if($member[group_no]!=0) {               
                $groupqry = "WHERE ((level>=3) && (level<=9)) ";   // 레벨1인 임원진도 순위에 넣으려면 3을 1로 수정해 주세요.
       }
        $query = "select * from zetyx_member_table $groupqry order by point desc limit 0,20"; //여기서 20은 20명을 뜻합니다. 100을 치면 포인트순으로 100명의 회원 순위가 랭킹됩니다.
        

$result = mysql_query ($query, $connect);
echo"

";
// while 밑으로 {부터 }까지의 내용이 모두 나타내어질 때까지 반복됩니다.
$i=0;
while($row=mysql_fetch_array($result))
{
        $i++;
        $row[name]=stripslashes($row[name]);

        $temp_name = get_private_icon($row[no], "2");
        if($temp_name) $row[name]="<img src="./$temp_name" border=0 align=absmiddle>";
        $temp_name = get_private_icon($row[no], "1");
        if($temp_name) $row[name]="<img src="./$temp_name" border=0 align=absmiddle> ".$row[name];
?>
                <tr>
          <td colspan='6' bgcolor="#EBD9D9" align="center"><img src="./images/t.gif" width="10" height="1"></td>
        </tr>
                <tr onMouseOver=this.style.backgroundColor="#FFF5F5" onMouseOut=this.style.backgroundColor="" align="center" height="23">
                        <td><?=$i?></td>
                        <td><a href=http://www.xpressengine.com/javascript:void(window.open('view_info.php?member_no=<?=$row[no]?>','view_info','width=400,height=510,toolbar=no,scrollbars=yes'))><?=$row[user_id]?></a></td>
                        <td><a href=http://www.xpressengine.com/javascript:void(window.open('view_info.php?member_no=<?=$row[no]?>','view_info','width=400,height=510,toolbar=no,scrollbars=yes'))><?=$row[name]?></a></td>
                        <td><?=$row[point]?>점</td>
                </tr>
<?
        }
        // 반복 끝.
        // MySQL 닫기
        if($connect) mysql_close($connect);
?>
      </table>

        </td>
    <td width="17" background="images/memo_listrightbg.gif"><img src="./images/t.gif" width="17" height="10"></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="15"><img src="./images/memo_listbottomleft.gif" width="17" height="17"></td>
    <td background="images/memo_listbottom.gif"><img src="./images/t.gif" width="10" height="5"></td>
    <td width="15"><img src="./images/memo_listbottomright.gif" width="17" height="17"></td>
  </tr>
</table>
</td>
</form>
</tr>
</table>