소스 분석 가능하신 회원님 부탁드립니다.

소스 분석 가능하신 회원님 부탁드립니다.

QA

소스 분석 가능하신 회원님 부탁드립니다.

본문

안녕하세요.


아래 포인트 랭킹 소스에서 레벨 3부터 랭킹 명단에 포함(랭킹 3미만 미포함) 되도록 변경하고 싶은데 어느 부분이지 모르겠어서 부탁드립니다.


감사합니다.


<?
if (!defined("_GNUBOARD_")) exit;
include_once("./_common.php");
include_once("$g4[path]/head.sub.php");
define("_CO_POINT_RANK_", TRUE);
$html_title = "포인트 랭킹";
$g4[title] = "" . $html_title;
?>
<?
if ($member[mb_level] < 4)
echo "<script>
alert('회원만 조회하실수 있습니다.');
location.href='/bbs/login.php?wr_id=&url=point_rank.php';
</script>";
?>
<style type="text/css">
<!--
.bk123 {
 border: 1px solid #CCCCCC;
}
.bkbk {
 border: 1px solid #999999;
}
-->
</style>
<table width="676" height="37" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="676" height="37" valign="top"><img width="676" height="31" alt="" src="http://yejicenter.org/community/image/point_ranking_title.gif" /></td></tr>
</table>
<table width="650" border="0" align="center" cellpadding="0" cellspacing="0" >
  <tr>
    <td height="20" colspan="6" align="left" valign="middle"></td>
  </tr>
<tr >
<td width="11%"><b><font color="blue">랭킹</font></b></td>
<td width="23%" background="img/title_bg.gif" height="25"><b><font color="blue">닉네임</font></b></td>
<td width="17%" background="img/title_bg.gif"><strong><font color="blue">이름</font></strong></td>
<td width="13%" background="img/title_bg.gif" align="right" height="25"><b><font color="blue">회원유형</font></b></td>
<td width="19%" align="right" background="img/title_bg.gif" ><b><font color="blue">포인트</font></b></td>
</tr>
 <tr>
 <td colspan="6" height="5"></td>
</tr>
 <tr>
 <td colspan="6" height="1" bgcolor="#CCCCCC"></td>
</tr>
 <tr>
 <td colspan="6" height="5"></td>
</tr>
 <?
$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];
 
$rows = 20;
$total_page  = ceil($total_count / $rows); 
if ($page == "") { $page = 1; }
$from_record = ($page - 1) * $rows; 
$mod = 48;
$tbl_col =2 ;
$tbl_col_sep = (int)($mod / $tbl_col) + ($mod % $tbl_col)  ;
if($_GET[keyword]!="")
{
if($_GET[type]==0)
{
$keyword_yi="where mb_nick='$_GET[keyword]'";
}
if($_GET[type]==1)
{
$keyword_yi="where mb_name='$_GET[keyword]'";
}
if($_GET[type]==2)
{
$keyword_yi="where mb_id='$_GET[keyword]'";
}
}
$sql = " select * from $g4[member_table]
         where mb_id not in ('yejicenter', 'qkrtngml34', 'rabbit870') 
$keyword_yi 
          order by mb_point desc, mb_today_login desc 
          limit $from_record, $rows ";
    $sql11 = " select count(*) from $g4[member_table] $keyword_yi 
          order by mb_point desc, mb_today_login desc 
          ";
$result = sql_query($sql);
$result11 = sql_query($sql11);
//echo $rsn11;
$rsn11=mysql_fetch_array($result11);
if($rsn11[0]==0)
{
if($_GET[type]==0)
{
$ty="닉네임";
}
if($_GET[type]==1)
{
$ty="이름";
}
if($_GET[type]==2)
{
$ty="아이디";
}

echo "<tr><td colspan=6 align=center height=150> 검색하신 $ty(<font color=red>$_GET[keyword]</font>) 에 대한 검색결과가 없습니다</td></tr>";
}
for ($i=0; $row=sql_fetch_array($result); $i++) 
{
    $rank = (($page - 1) * $rows) + $i + 1;
    $point = number_format($row[mb_point]);
 $id = $row[mb_id];
   
?>

<tr height="30" >
<td width="11%" height="35" ><?=$rank?></td>
<td height="35"><?= level_icon($row[mb_id])?> <a title="쪽지보내기" onfocus='this.blur()' style="FILTER: blendTrans(duration=0.7); CURSOR: pointer" onclick="window.open('/bbs/memo_form.php?me_recv_mb_id=<?=$row[mb_id]?>','www_yiwuauction_com1','width=602,height=521,toolbars=no,resizable=no,scrollbars=no')"><?=$row[mb_nick]?></a>  </td>
<td height="35">
  <font color="#3399FF"><?=$row[mb_name]?></font></td>
<td width="13%" height="35" align="right">
<? 
if ($level = $row[mb_level] == 10)
$level="운영자";
else if ($level = $row[mb_level] == 4)
$level="직원";
else if ($level = $row[mb_level] == 3)
$level="등록아동";
else if ($level = $row[mb_level] == 2)
$level="등록아동보호자";
else if ($level = $row[mb_level] == 1)
$level="일반인";
?>
<font color=green><?=$level?></font> </td>
<td width="19%" height="35" align="right"><font color="#3399FF"><strong><?=$point?> 점</font></td>
</tr>

<tr>
<td colspan="6" height="1" background="img/dot_line.gif"></td>
</tr>
 <? } ?>
  <tr>
 <td colspan="6" height="30"></td>
</tr>
 <tr>
 <td height="20" colspan="6">
   <table width="651" height="20" border="0" cellpadding="0" cellspacing="0">
     <form id="form1" name="form1" method="get" action=""><tr>
       <td width="423" valign="middle">
    
    <?
    if($_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 align=center>$page</td></tr></table>";
}
?></td>
       <td width="187" align="right" valign="middle">  
    
       <div align="center">
         <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" class="bkbk" id="keyword" size="15" value="<?=$_GET[keyword]?>"/>
       </div>          </td>
       <td width="41" align="right"><input type="image" name="imageField" src="img/btn_post_search.gif" /></td>
     </tr></form>
   </table></td>
</tr>
 <tr>
   <td height="15" colspan="6"></td>
 </tr>
</table>        
 

이 질문에 댓글 쓰기 :

답변 1

현제 페이지에서 보이는 77줄 where 구문에 and mb_level > 3 추가

77줄에 $keyword_yi .= " and mb_level > 3 ";

이렇게 추가하면 될 듯한데요 

답변을 작성하시기 전에 로그인 해주세요.
전체 30
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT