포인트랭킹에서 관리자만 순위에 뜹니다. 정보
포인트랭킹에서 관리자만 순위에 뜹니다.본문
포인트랭킹을 사용중인데 관리자만 노출됩니다~!!
ㅠ____________ㅠ
<?
include_once("./_common.php");
$g4[title] = "포인트 순위";
include_once("$g4[path]/head.sub.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td valign=top colspan=2 class=lh>
<?
echo "</td></tr><tr><td valign=top width=50%>";
$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 10;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 10;
$sql = " select * from $g4[member_table]
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>";
$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]);
}
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
include_once("$g4[path]/tail.sub.php");
?>
ㅠ____________ㅠ
<?
include_once("./_common.php");
$g4[title] = "포인트 순위";
include_once("$g4[path]/head.sub.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td valign=top colspan=2 class=lh>
<?
echo "</td></tr><tr><td valign=top width=50%>";
$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 10;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 10;
$sql = " select * from $g4[member_table]
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>";
$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]);
}
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
include_once("$g4[path]/tail.sub.php");
?>
댓글 전체
for ($i=0; $row=sql_fetch_array($result); $i++)
{
if ($i && $i%$mod==0)
echo "</td><td valign=top>";
$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]);
}
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
include_once("$g4[path]/tail.sub.php");
?>
이 부분을
for ($i=0; $row=sql_fetch_array($result); $i++)
{
if ($i && $i%$mod==0)
echo "</td><td valign=top>";
$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]);
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
}
include_once("$g4[path]/tail.sub.php");
?>
이렇게 수정
{
if ($i && $i%$mod==0)
echo "</td><td valign=top>";
$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]);
}
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
include_once("$g4[path]/tail.sub.php");
?>
이 부분을
for ($i=0; $row=sql_fetch_array($result); $i++)
{
if ($i && $i%$mod==0)
echo "</td><td valign=top>";
$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]);
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0><tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?>
</td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr></table>
</td></tr>
</table>
<?
}
include_once("$g4[path]/tail.sub.php");
?>
이렇게 수정
감사합니다^^ 덕분에 해결됫네요.. 근데 관리자가 아닌 다른 멤버가 노출되니 테이블이 깨지네요 해서..
<?
include_once("./_common.php");
$g4[title] = "포인트 순위";
include_once("$g4[path]/head.sub.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<?
$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 10;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 10;
$sql = " select * from $g4[member_table]
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)
$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]);
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0>
<tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?></td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr>
</table>
<?
}
include_once("$g4[path]/tail.sub.php");
?> 이렇게 했더니..잘되네요^^ ㄳ 합니다.
<?
include_once("./_common.php");
$g4[title] = "포인트 순위";
include_once("$g4[path]/head.sub.php");
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<?
$sql = " select count(*) as cnt from $g4[member_table]";
$row = sql_fetch($sql);
$total_count = $row[cnt];
$rows = 10;
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if ($page == "") { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$mod = 10;
$sql = " select * from $g4[member_table]
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)
$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]);
?>
<table width=98% height=26 cellpadding=0 align=center class=box border=0>
<tr>
<td><?if ($i<=5) echo "<img src=".$g4[path]."/img/rank/".$i."_icon.gif align=absmiddle>";?> <?=$name?></td>
<td align=right><font style=font-size:8pt; color=#777777><?=$point?>점</font></td>
</tr>
</table>
<?
}
include_once("$g4[path]/tail.sub.php");
?> 이렇게 했더니..잘되네요^^ ㄳ 합니다.