포인트랭킹 관리자는 제외하고 싶습니다
본문
어떻게 수정하면 될까요?
<?php
include_once('./_common.php');
$g5[title] = '포인트랭킹';
$sql = " select count(*) as cnt from $g5[member_table]";
$row = sql_fetch($sql);
$total_count = 50;
$rows = 50;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$write_pages = get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['PHP_SELF'].'?&page=');
include_once(G5_PATH.'/_head.php');
?>
<?php echo $rank_number[mb_id] ?>
<table width="100%" cellpadding="0" cellspacing="0" border="0" class="web-array">
<tr><td colspan="4" height="1" bgcolor="#e8e8e8"></td></tr>
<tr class="subj">
<td class="rank">순위</td>
<td class="nick">닉네임</td>
<td class="point">포인트</td>
</tr>
<?php
$sql = " select * from {$g5['member_table']} order by mb_point desc limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$rank_number = (($page - 1) * $rows) + $i + 1;
$row['name'] = get_sideview($row['mb_id'], $row['mb_nick'], $row['mb_email'], $row['mb_homepage']);
$pr = sql_fetch(" select * from g5_pr_db where mb_id = '$row[mb_id]' ");
$chnum = $pr[num] - $rank_number;
if($pr[num] && $pr[num] > $rank_number){
$change = '<span style="font-size:10pt;color:#35a2ff">▲</span>'.$chnum;
}elseif($pr[num] && $pr[num] < $rank_number){
$change = '<span style="font-size:10pt;color:#ff6767">▼</span>'.$chnum;
}elseif($pr[num] && $pr[num] == $rank_number){
$change = '<span style="font-size:10pt;color:#A4A4B4;">─</span>';
}elseif(!$pr[num]){
$change = '<span style="font-size:11pt;font-weight:bold;color:#40a100;">NEW</span>';
}
?>
<tr><td colspan="4" height="1" bgcolor="#e8e8e8"></td></tr>
<tr class="array">
<td class="rank"><?php echo $rank_number ?>위<br><?php echo $change ?></td>
<td class="nick"><span class="rank_level_icon"><?=level_icon($row[mb_id])?></span><?php echo $row['name'] ?></td>
<td class="point"><?php echo $row['mb_point'] ?></td>
</tr>
<?php
}
?>
답변 1
$sql = " select * from {$g5['member_table']} order by mb_point desc limit $from_record, $rows ";
부분을
$sql = " select * from {$g5['member_table']} where mb_level<10 order by mb_point desc limit $from_record, $rows ";
으로 바꾸시면 될듯 합니다.
10이 관리자 니깐요.
답변을 작성하시기 전에 로그인 해주세요.