포인트랭킹에서 관리자 제외 정보
포인트랭킹에서 관리자 제외관련링크
http://s8k2.cafe24.com
75회 연결
본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : 링크1
몇시간동안 검색해서 전부 적용해 봤는데 도저히 안되네요 허허...
전체소스 첨부합니다.
두군데서 관리자 랭킹정보를 호출하는거 같습니다.
질답검색 키워드 :포인트랭킹, 랭킹, 관리자 제외.. 기타등등 전부 검색해서 나오는 답변대로
적용해 봤습니다만.. 제대로 적용 못한 부분도 없지 않을거라 생각합니다만 제가 해볼 수 있는건
다 해본거 같습니다. 도저히 안돼요 ㅎ;;
===============================================================================================
<?
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] < 1)
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" align="center" 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; font-weight:bold; font-size:12px; color:#494949;">회원등급안내</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.1 : </b>
<img src="/img/level_/1.gif">[300p미만]
</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.2 : </b>
<img src="/img/level_/2.gif">[300p],
<img src="/img/level_/3.gif">[400p],
<img src="/img/level_/4.gif">[500p],
<img src="/img/level_/5.gif">[600p],
<img src="/img/level_/6.gif">[700p],
<img src="/img/level_/7.gif">[800p],
<img src="/img/level_/8.gif">[1,000p],<br /><br />
<img src="/img/level_/9.gif">[1,200p],
<img src="/img/level_/10.gif">[1,400p],
<img src="/img/level_/11.gif">[1,600p],
<img src="/img/level_/12.gif">[1,800p],
<img src="/img/level_/13.gif">[2,000p],
<img src="/img/level_/14.gif">[2,200p]
</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.3 : </b>
<img src="/img/level_/15.gif">[3,000p],
<img src="/img/level_/16.gif">[4,000p],
<img src="/img/level_/17.gif">[5,000p],
<img src="/img/level_/18.gif">[6,000p],
<img src="/img/level_/19.gif">[8,000p],
<img src="/img/level_/20.gif">[10,000p],
<img src="/img/level_/sp.gif">[20,000p]
</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>포인트:</B> ".$member[mb_point]."점";
$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>랭킹:</b> ".number_format($row[cnt])."위<br>";
?></td><? /*<b>".$total_count."</b> 명중*/ ?>
</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 = $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="Lv.3";
else if ($level = $row[mb_level] == 2)
$level="Lv.2";
else if ($level = $row[mb_level] == 1)
$level="Lv.1";
//else if ($level = $row[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>
오류 주소 : 링크1
몇시간동안 검색해서 전부 적용해 봤는데 도저히 안되네요 허허...
전체소스 첨부합니다.
두군데서 관리자 랭킹정보를 호출하는거 같습니다.
질답검색 키워드 :포인트랭킹, 랭킹, 관리자 제외.. 기타등등 전부 검색해서 나오는 답변대로
적용해 봤습니다만.. 제대로 적용 못한 부분도 없지 않을거라 생각합니다만 제가 해볼 수 있는건
다 해본거 같습니다. 도저히 안돼요 ㅎ;;
===============================================================================================
<?
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] < 1)
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" align="center" 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; font-weight:bold; font-size:12px; color:#494949;">회원등급안내</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.1 : </b>
<img src="/img/level_/1.gif">[300p미만]
</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.2 : </b>
<img src="/img/level_/2.gif">[300p],
<img src="/img/level_/3.gif">[400p],
<img src="/img/level_/4.gif">[500p],
<img src="/img/level_/5.gif">[600p],
<img src="/img/level_/6.gif">[700p],
<img src="/img/level_/7.gif">[800p],
<img src="/img/level_/8.gif">[1,000p],<br /><br />
<img src="/img/level_/9.gif">[1,200p],
<img src="/img/level_/10.gif">[1,400p],
<img src="/img/level_/11.gif">[1,600p],
<img src="/img/level_/12.gif">[1,800p],
<img src="/img/level_/13.gif">[2,000p],
<img src="/img/level_/14.gif">[2,200p]
</td>
</tr><tr>
<td height="35" style="padding-left:20px;"><b>Lv.3 : </b>
<img src="/img/level_/15.gif">[3,000p],
<img src="/img/level_/16.gif">[4,000p],
<img src="/img/level_/17.gif">[5,000p],
<img src="/img/level_/18.gif">[6,000p],
<img src="/img/level_/19.gif">[8,000p],
<img src="/img/level_/20.gif">[10,000p],
<img src="/img/level_/sp.gif">[20,000p]
</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>포인트:</B> ".$member[mb_point]."점";
$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>랭킹:</b> ".number_format($row[cnt])."위<br>";
?></td><? /*<b>".$total_count."</b> 명중*/ ?>
</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 = $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="Lv.3";
else if ($level = $row[mb_level] == 2)
$level="Lv.2";
else if ($level = $row[mb_level] == 1)
$level="Lv.1";
//else if ($level = $row[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>
댓글 전체
음.. 코드를 보기 힘들어요 ㅠㅠ 코드를 [★code] ....[/code] 문 안에 넣어주세요 ★ 빼고 올려주시면되요
http://sir.co.kr/bbs/board.php?bo_table=g4_qa&wr_id=155236&sca=&sfl=&stx=&spt=0&page=1
http://sir.co.kr/bbs/board.php?bo_table=g4_qa&wr_id=155236&sca=&sfl=&stx=&spt=0&page=1
댓글땜에 수정이 안되서 다시 쓸께요...