포인트 랭킹에 레벨 아이콘 출력질문 > 그누4 질문답변

그누4 질문답변

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

포인트 랭킹에 레벨 아이콘 출력질문 정보

포인트 랭킹에 레벨 아이콘 출력질문

본문

아래 소스는 포인트 랭킹 소인데요.
닉네임 출력 부분에 레벨아이콘을 출력하려고 합니다.
<?=level_icon($row[mb_id])?>
위의 소스로요. 
 
포인트랭킹소스 시작
----------------------------------------------------------------------------------------------------
<?
include_once("./_common.php");
define("_CO_POINT_RANK_", TRUE);
$html_title = "포인트순위";
$g4[title] = "" . $html_title;
include_once("./_head.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<?
if (!$is_member)
    echo "<script>
          alert('회원만 조회하실수 있습니다.');
    location.href='/bbs/login.php?wr_id=&url=../point_ranking.php';
    </script>";
?>
<table width=710 align=center>
<tr><td valign=top colspan=2 class=lh>
<?
$sql = " select count(mb_id) as cnt from $g4[member_table]
           where mb_id not in ('admin') and mb_point >= '$member[mb_point]' order by mb_point desc "; // 관리자 아이디는 포인트 순위에서 제외
$row = sql_fetch($sql);
echo "<br>· 현재 <b>$member[mb_nick]</b> 님의 포인트 순위는 <B>".number_format($row[cnt])."등</B> 입니다.";
$sql = " select sum(mb_point) as sum_point from $g4[member_table]";
$row = sql_fetch($sql);
$sum_point = $row[sum_point];
echo "<br>· 전체 포인트 : <B>".number_format($sum_point) . "점</b><br><br>";
echo "</td></tr><tr><td valign=top width=50%>";
$keyword_yi="";
if($_GET[keyword]!="") {
    if($_GET[type]==0)
        $keyword_yi=" and mb_nick like '%$_GET[keyword]%' ";
    if($_GET[type]==1)
        $keyword_yi=" and mb_name like '%$_GET[keyword]%' ";
    if($_GET[type]==2)
        $keyword_yi=" and mb_id='$_GET[keyword]'";
}
$sql = " select count(*) as cnt from $g4[member_table]
         where mb_id not in ('admin') $keyword_yi ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 50;
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 25;
$sql = " select * from $g4[member_table]
          where mb_id not in ('admin') $keyword_yi
          order by mb_point desc, mb_today_login desc
          limit $from_record, $rows "; // 관리자 아이디는 포인트 순위에서 제외
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
    if ($i && $i%$mod==0)
        echo "</td><td valign=top>";
    if($_GET[keyword]!="") {
        $sql = " select count(mb_id) as cnt from $g4[member_table]
                   where mb_id not in ('admin') and mb_point >= '$row[mb_point]' order by mb_point desc "; // 관리자 아이디는 포인트 순위에서 제외
        $row2 = sql_fetch($sql);
        $rank = $row2[cnt];
    } else {
        $rank = (($page - 1) * $rows) + $i + 1;
    }
   
    $name = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);
    $point = number_format($row[mb_point]);
    echo "<table width=98% cellpadding=0 align=center class=box border=0><tr>";
    echo "<td height=30>$rank. $name</td>";
    echo "<td align=right><font color=777777>{$point}점</font></td>";
    echo "</tr></table>";
    echo "<table width=100%><tr><td></td></tr></table>";
}
?>
</td></tr>
</table>
<form id="form1" name="form1" method="get" action="">
<?
$qstr = "type=$_GET[type]&keyword=$_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 width=50% align=center>$page</td>";
?>
<td align=left valign="middle">
         <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" id="keyword" size="15" value="<?=$_GET[keyword]?>"/>
         <input type=image src="<?=$g4['path']?>/img/search_btn.gif" border=0 align=absmiddle></td>
</td>
</tr></table><br><br>
</form>

<?
include_once("./_tail.php");
?>
----------------------------------------------------------------------------------------------------
여기까지
 
 
 
위 소스중에 아래 부분에 <?=level_icon($row[mb_id])?> 요걸 넣으려고 합니다.
 
echo "<td height=30>$rank. $name</td>";
 
넣으려고하는 위치는 아래처럼요.
아래소스가 잘못 된건 압니다.
이부분에 넣는다는걸 설명하기위해서 넣은겁니다^^;
 
echo "<td height=30>$rank. <?=level_icon($row[mb_id])?> $name</td>";
 
방법 좀 알려주세요.
 
 
  • 복사

댓글 전체

늘~푸른 자기소개 아이디로 검색 회원게시물 07.09.14 15:16:19
곱슬최씨님 답글 감사합니다.
출력은 되는데요.
<tr><img src='./img/level/009.gif' align=absmiddle alt='원사'><td>랭킹번호 닉네임</td>
이런식으로 테이블을 벗어나버리네요.

근데 함수를 따로 정의해야하나요?

아래소스는 다른 포인트랭킹 인데요.
<?= level_icon($row[mb_id])?>
여기선 위소스로 잘되거던요.
아래소스는 한줄짜리고요.
제가 질문드린소스는 2줄짜리입니다.

<?
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] < 5)
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">
        <tr>
          <td height="35" style="padding-left:20px;">회원권한제도: <img src="/level_img/level5.gif"> 준회원, <img src="/level_img/level6.gif"> 정회원, <img src="/level_img/level7.gif"> 우수회원, <img src="/level_img/level8.gif"> VIP회원, <img src="/level_img/level9.gif"> 운영자, <img src="/level_img/level10.gif"> 웹마스터. </td>
        </tr>
<?
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 "&nbsp;이고,&nbsp;랭킹은 전체회원수 <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>&nbsp;&nbsp;</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 = $row[mb_level] == 10)
$level="웹마스터";
else if ($level = $row[mb_level] == 9)
$level="운영자";
else if ($level = $row[mb_level] == 8)
$level="VIP회원";
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] == 1)
$level="유람객";
else if ($level = $row[mb_level] == 0)
$level="비회원";
?>
<font color=green><?=$level?></font>&nbsp;</td>
<td width="19%" height="35" align="right"><font color="#FF0000"><?=$point?>&nbsp;점</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">&nbsp;</td>
 </tr>
</table>
목록
문의 PC 버전
© SIRSOFT
현재 페이지 제일 처음으로