진하오 님의 포인트 랭크 게시판에 대한 문의
진하오 님의 포인트 게시판
이것을 사용하는데 이상하게 회원 권환이 모두 비회원으로 나오는군요. 현재 회원 가입시 레벨은 2이구 2레벨이 정회원 3은 우수 회원 4는 게시판 관리자, 5는 운영자. 10은 최고 관리자 입니다. 그런데 모두 비회원으로만 나옵니다. 이유가뭘까요
|
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기
댓글 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] < 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;
}
body {
margin-left: 10px;
}
-->
</style>
<br />
<table width="800">
<!--DWLayoutTable-->
<tr><td width="782" height="34" valign="top"><img src="<?=$g4['path']?>/img/title_p.gif" /></td>
<td width="1" > </td></tr>
</tr></table>
<table width="650" border="0" cellpadding="6" 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 " 이고, 랭킹은 전체회원수 <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] == 6)
$level="게시판운영자";
else if ($level = $mb[mb_level] == 5)
$level="VIP회원";
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>