포인트 순위를 사용하려는데... > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

포인트 순위를 사용하려는데... 정보

포인트 순위를 사용하려는데...

본문

이상하게 다른 부분은 거의 다 해결이 되었는데요...
 
닉네임 부분에 이모티콘 뜨는 거랑...
 
회원권한에 이름이 안바뀌네요. 레벨 별로 전부 다른 이름이 떠야되는데 전부 "곤충"으로 뜨구요--;
 
이모티콘은 레벨 10짜리.. 그러니까 제 이모티콘은 뜨는데 나머지 이모티콘은 안뜹니다...
 
수정하면서 뭐가 잘못되었었는지... 잘 모르겠습니다.
 
한번 보시고 어디가 잘못되었고 어떻게 고쳐져야되는지 알려주세요.
 
 
--------------------- extend/level_icon.php -------------------------
 
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
//레벨별 아이콘지정
function level_icon($mb_id) {
global $g4, $member, $is_admin;
$sql = "select mb_nick, mb_level, mb_id from $g4[member_table] where mb_id='$mb_id'";
$result = sql_query($sql);
$data = sql_fetch_array($result);
$is_admin = is_admin($mb_id);
$ic_level = $data[mb_level];
$level_img="$g4[path]/level_img";
if($is_admin == 'super') //웹마스터
              {echo "<img src={$level_img}/level10.gif border=0>";}
else if(!$ic_level) //비회원
              {echo "<img src={$level_img}/level0.gif border=0>";}
else if($ic_level == 1) //레벨 1 일때
              {echo "<img src={$level_img}/level1.gif border=0>";}
else if($ic_level == 2) //레벨 2 일때
              {echo "<img src={$level_img}/level2.gif border=0>";}
else if($ic_level == 3) //레벨 3 일때
              {echo "<img src={$level_img}/level3.gif border=0>";}
else if($ic_level == 4) //레벨 4 일때
              {echo "<img src={$level_img}/level4.gif border=0>";}
else if($ic_level == 5) //레벨 5 일때
              {echo "<img src={$level_img}/level5.gif border=0>";}
else if($ic_level == 6) //레벨 6  일때
              {echo "<img src={$level_img}/level6.gif border=0>";}
else if($ic_level == 7) //레벨 7 일때
              {echo "<img src={$level_img}/level7.gif border=0>";}
else if($ic_level == 8) //레벨 8 일때
              {echo "<img src={$level_img}/level8.gif border=0>";}
else if($ic_level == 9) //레벨 9 일때
              {echo "<img src={$level_img}/level9.gif border=0>";}
}
?>
 
------------------ bbs/point_rank.php --------------------
 
<?
include_once("./_common.php");
include_once("./rank.php");
?>
 
------------------ bbs/rank.php ----------------------
 
<?
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] < 2)
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="650" border="0" cellpadding="0" cellspacing="0" >
  <tr>
 <td height="15" colspan="6" align="left" valign="top"></td>
</tr>
  <tr>
    <td height="100" colspan="6" align="left" valign="middle"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="bk123">
  <?
  if ($member[mb_id])
{
?>
        <tr>
          <td height="35" style="padding-left:20px;"><?
$sql = " select sum(mb_point) as sum_point from $g4[member_table]";
$row = sql_fetch($sql);
$sum_point = $row[sum_point];
echo "레벨상황: 현재 <b>".$member[mb_id]."</b>님의 포인트는 <B>".$member[mb_point]."점</B>";
   $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);
  
  $sql2 = " select count(mb_id) as cnt from $g4[member_table]";
    $row2 = sql_fetch($sql2);
  $total_count = $row2[cnt];
    echo " 이고, 랭킹은 전체회원수 <b>".$total_count."</b>명중 <B>".number_format($row[cnt])."등</B> 입니다.<br>";
?></td>
        </tr>
  <? } ?>
    </table></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="17%" background="img/title_bg.gif" height="25"><b><font color="blue">아이디</font></b></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] $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="17%" height="35"><a title="정보보기" onfocus='this.blur()' style="FILTER: blendTrans(duration=0.7); CURSOR: pointer" onclick="window.open('/bbs/profile.php?mb_id=<?=$row[mb_id]?>','www_yiwuauction_com2','width=602,height=521,toolbars=no,resizable=no,scrollbars=no')"><b><?=$row[mb_id]?></b></a></td>
<td width="13%" height="35" align="right">
<?
if ($level = $mb[mb_level] == 10)
$level="대왕개미";
else if ($level = $mb[mb_level] == 9)
$level="여왕개미";
else if ($level = $mb[mb_level] == 8)
$level="왕개미";
else if ($level = $mb[mb_level] == 7)
$level="공주개미";
else if ($level = $mb[mb_level] == 6)
$level="귀족개미";
else if ($level = $mb[mb_level] == 5)
$level="병정개미";
else if ($level = $mb[mb_level] == 4)
$level="일개미";
else if ($level = $mb[mb_level] == 3)
$level="아기개미";
else if ($level = $mb[mb_level] == 2)
$level="알";
else if ($level = $mb[mb_level] == 1)
$level="외부개미";
else if ($level = $mb[mb_level] == 0)
$level="곤충";
?>
<font color=green><?=$level?></font> </td>
<td width="19%" height="35" align="right"><font color="#FF0000"><?=$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>
 
---------------- skin/member/basic/profile.skin.php --------------
 
<?
if ($level = $mb[mb_level] == 10)
$level="대왕개미";
else if ($level = $mb[mb_level] == 9)
$level="여왕개미";
else if ($level = $mb[mb_level] == 8)
$level="왕개미";
else if ($level = $mb[mb_level] == 7)
$level="공주개미";
else if ($level = $mb[mb_level] == 6)
$level="귀족개미";
else if ($level = $mb[mb_level] == 5)
$level="병정개미";
else if ($level = $mb[mb_level] == 4)
$level="일개미";
else if ($level = $mb[mb_level] == 3)
$level="아기개미";
else if ($level = $mb[mb_level] == 2)
$level="알";
else if ($level = $mb[mb_level] == 1)
$level="외부개미";
else if ($level = $mb[mb_level] == 0)
$level="곤충";
?>
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
?>
<table width="600" height="50" border="0" cellpadding="0" cellspacing="0">
<tr>
    <td align="center" valign="middle" bgcolor="#EBEBEB">
        <table width="590" height="40" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td width="25" align="center" bgcolor="#FFFFFF" ><img src="<?=$member_skin_path?>/img/icon_01.gif" width="5" height="5"></td>
            <td width="75" align="left" bgcolor="#FFFFFF" ><font color="#666666"><b>자기소개</b></font></td>
            <td width="490" bgcolor="#FFFFFF" ></td>
        </tr>
        </table></td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td align="center" valign="top">
        <table width="540" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td height="20" colspan="3"></td>
        </tr>
        <tr>
            <td width="174" height="149" align="center" valign="middle" background="<?=$member_skin_path?>/img/self_intro_bg.gif">
                <table width="170" height="130" border="0" cellpadding="0" cellspacing="0">
                <tr>
                    <td align="center" valign="middle"><?=$mb_nick?></td>
                </tr>
                </table></td>
            <td width="15" height="149"></td>
            <td width="351" height="149" align="center" valign="middle" background="<?=$member_skin_path?>/img/self_intro_bg_1.gif">
                <table width="300" border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td width="30" height="25" align="center"><img src="<?=$member_skin_path?>/img/arrow_01.gif" width="7" height="5"></td>
                    <td width="270">회원권한 : <?=$level?></td>
                </tr>
                <tr>
                    <td height="1" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <tr>
                    <td width="30" height="25" align="center"><img src="<?=$member_skin_path?>/img/arrow_01.gif" width="7" height="5"></td>
                    <td width="270">포인트 : <?=number_format($mb[mb_point])?> 점</td>
                </tr>
                <tr>
                    <td height="1" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <? if ($mb_homepage) { ?>
                <tr>
                    <td width="30" height="25" align="center"><img src="<?=$member_skin_path?>/img/arrow_01.gif" width="7" height="5"></td>
                    <td width="270">홈페이지 : <a href="<?=$mb_homepage?>" target="<?=$config[cf_link_target]?>"><?=$mb_homepage?></a></td>
                </tr>
                <tr>
                    <td height="1" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <? } ?>
                <tr>
                    <td width="30" height="25" align="center"><img src="<?=$member_skin_path?>/img/arrow_01.gif" width="7" height="5"></td>
                    <td width="270">회원가입일 : <?=($member[mb_level] >= $mb[mb_level]) ?  substr($mb[mb_datetime],0,10) ." (".$mb_reg_after." 일)" : "알 수 없음"; ?></td>
                </tr>
                <tr>
                    <td height="1" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <tr>
                    <td width="30" height="25" align="center"><img src="<?=$member_skin_path?>/img/arrow_01.gif" width="7" height="5"></td>
                    <td width="270">최종접속일 : <?=($member[mb_level] >= $mb[mb_level]) ? $mb[mb_today_login] : "알 수 없음";?></td>
                </tr>
                </table></td>
        </tr>
        <tr>
            <td width="540" height="15" colspan="3" bgcolor="#FFFFFF"></td>
        </tr>
        <tr>
            <td height="15" colspan="3" bgcolor="#FFFFFF"><img src="<?=$member_skin_path?>/img/top_line.gif" width="540" height="15"></td>
        </tr>
        <tr align="center" valign="top">
            <td colspan="3" background="<?=$member_skin_path?>/img/mid_line.gif" bgcolor="#FFFFFF"><table width="500" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                        <td height="30" valign="top"><img src="<?=$member_skin_path?>/img/self_intro_icon_01.gif" width="81" height="24"></td>
                    </tr>
                    <tr>
                        <td height="100" valign="top"><?=$mb_profile?></td>
                    </tr>
                </table></td>
        </tr>
        <tr>
            <td height="15" colspan="3" bgcolor="#FFFFFF"><img src="<?=$member_skin_path?>/img/down_line.gif" width="540" height="15"></td>
        </tr>
        <tr>
            <td height="50" colspan="3" bgcolor="#FFFFFF"></td>
        </tr>
        </table></td>
</tr>
<tr>
    <td height="2" align="center" valign="top" bgcolor="#D5D5D5"></td>
</tr>
<tr>
    <td height="2" align="center" valign="top" bgcolor="#E6E6E6"></td>
</tr>
<tr>
    <td height="40" align="center" valign="bottom"><a href="javascript:window.close();"><img src="<?=$member_skin_path?>/img/btn_close.gif" width="48" height="20" border="0"></a></td>
</tr>
</table>
 
--------------------------------------------
 
아마 제 생각으로는 rank.php 부분에서 에러가 나는 거 같은데...
 
도저히 왜 에러가 나는지 모르겠거든요.
 
고수분들의 도움이 있길 간절히 부탁드립니다...
 
연말 잘 마무리 하시길...

댓글 전체

rank.php 파일에서 아래부분을
<?
if ($level = $mb[mb_level] == 10)
$level="대왕개미";
else if ($level = $mb[mb_level] == 9)
$level="여왕개미";
else if ($level = $mb[mb_level] == 8)
$level="왕개미";
else if ($level = $mb[mb_level] == 7)
$level="공주개미";
else if ($level = $mb[mb_level] == 6)
$level="귀족개미";
else if ($level = $mb[mb_level] == 5)
$level="병정개미";
else if ($level = $mb[mb_level] == 4)
$level="일개미";
else if ($level = $mb[mb_level] == 3)
$level="아기개미";
else if ($level = $mb[mb_level] == 2)
$level="알";
else if ($level = $mb[mb_level] == 1)
$level="외부개미";
else if ($level = $mb[mb_level] == 0)
$level="곤충";
?>

다음과 같이 바꾸시면 될껍니다.
즉 mb 대신 row로 바꾸셔야 합니다.
<?
if ($level = $row[mb_level] == 10)
$level="대왕개미";
else if ($level = $row[mb_level] == 9)
$level="여왕개미";
else if ($level = $row[mb_level] == 8)
$level="왕개미";
else if ($level = $row[mb_level] == 7)
$level="공주개미";
else if ($level = $row[mb_level] == 6)
$level="귀족개미";
else if ($level = $row[mb_level] == 5)
$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="외부개미";
else if ($level = $row[mb_level] == 0)
$level="곤충";
?>
전체 66,554 |RSS
그누4 질문답변 내용 검색

회원로그인

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