랭킹페이지 에서 관리자를 제외하고 싶습니다.
본문
미니게임에서 mb_level 8이상의 관리자 회원들을 랭킹을 제외하고 싶은데 어디에 추가해야되나요?
<?php
include'loader.php';
$data= getListQuery('select * from (select g5_member.mb_nick,count(*) AS total,sum(bet_price)*1.9 AS sum,member_no from bet left join g5_member on g5_member.mb_no = bet.member_no where is_win = 1 AND status =1 group by member_no) AS TB order by sum desc limit 0,10');
$len = $data['length'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>미니게임 랭킹</title>
<link rel="stylesheet" type="text/css" href="/css/default-ladder.css?140424" />
<link rel="stylesheet" type="text/css" href="/css/ladder_rank.css?v=140128&140424" />
<script type="text/javascript" src="/js/jquery-1.8.3.min.js"></script>
</head>
<body>
<!-- wrap !-->
<div id="wrap">
<!-- contents !-->
<div id="contents">
<script type="text/javascript">
// 마이페이지 팝업
function popMypage(type){
if(type == 'my_item') var popUrl = g4_path + "/market/itemshop/" + type + ".php";
else var popUrl = g4_path + "/mypage/" + type + ".php";
var popOption = "width=790, height=800, resizable=no, scrollbars=no, status=no;";
window.open(popUrl,"market",popOption);
}
/* 메뉴 마우스 오버 */
$(function(){
$('#pageMenu ul li').mouseenter(function(){
$(this).addClass('over');
}).mouseleave(function(){
$(this).removeClass('over');
});
});
</script><table class="rank_table">
<colgroup>
<col width="55px">
<col width="">
<col width="80px">
<col width="80px">
<col width="80px">
</colgroup>
<thead>
<tr class="hd">
<th><div class="tinn">순위</div></th>
<th><div class="tinn">닉네임</div></th>
<th><div class="tinn">참여회차수</div></th>
<th><div class="tinn">적중률(%)</div></th>
<th><div class="tinn">수익률(%)</div></th>
</tr>
</thead>
<tbody>
<?php
for($iu=0;$iu<$len;$iu++){
$item = $data[$iu];
if($iu<3){
$rankSign = '<img src="/img/rank_trophy_'.($iu+1).'.gif">';
}
else{
$rankSigng= $iu+1;
}
$profitItem = getSum('bet','member_no='.$item['member_no'],'bet_price');
$profitRate = $item['sum']*100/$profitItem['bet_price'];
$gameTotal = getTotal('bet','member_no='.$item['member_no'].' AND status=1');
?>
<tr>
<td class="rank"><div class="tinn"><?=$rankSign?></div></td>
<td class="nick">
<div class="tinn">
<?=$item['mb_nick']?></span> </div>
</td>
<td><div class="tinn"><?=$item['total']?></div></td>
<td><div class="tinn"> <?=round($item['total']*100/$gameTotal,2)?>%</div></td>
<td><div class="tinn"><?=round($profitRate,2)?>%</div></td>
</tr>
<?php
}
?>
</tbody>
</table>
답변 1
쿼리에서 where절을 이렇게 바꿔보세요
where is_win = 1 AND status =1 AND mb_level < 8 group by member_no
감사합니다 !!
답변을 작성하시기 전에 로그인 해주세요.
