추천인수 랭킹 입니다
이스킨은 현재 사이트개설시부터~현재시까지의 추천인수가 출력되는데요
이것을 최근1주일단위로 출력하고자합니다


<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
echo "<script language=\"javascript\" src=\"$g4[path]/js/sideview.js\"></script>\n";
?>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="<?=$g4[path]?>/service/recommend/img/box01.gif" width="200" height="7" colspan="3"></td>
</tr>
<tr>
<td bgcolor="#d8d8d8" width="1"></td>
<td width="198" align="center">
<table width="180" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2"><img src="<?=$g4[path]?>/service/recommend/img/title.gif" align="absmiddle"></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
<tr>
<td background="<?=$g4[path]?>/service/recommend/img/dot.gif" height="1" colspan="2"></td>
</tr>
<tr>
<td height="5" colspan="2"></td>
</tr>
<?
$sql = " select *, count(*) as cnt from $g4[member_table] where mb_recommend != '' group by mb_recommend order by cnt desc limit 0, 5 ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++)
{
$sql2 = " select * from $g4[member_table] where mb_id = '$row[mb_recommend]' ";
$row2 = sql_fetch($sql2);
$name = get_sideview($row2[mb_id], $row2[mb_nick], $row2[mb_email], $row2[mb_homepage]);
$re_cnt = number_format($row[cnt]);
$id_chk = get_member($row2[mb_id]);
if ($id_chk) {
?>
<tr height="28">
<td><img src="<?=$g4[path]?>/service/recommend/img/rank_<?=$i?>.gif" width="12" height="11" align="absmiddle">&nbsp;<?=$name?></td>
<td align=right><font style=font-size:8pt; color=#777777><?=$re_cnt?>명</font></td>
</tr>
<? }} ?>
</table></td>
<td bgcolor="#d8d8d8" width="1"></td>
</tr>
<tr>
<td background="<?=$g4[path]?>/service/recommend/img/box02.gif" width="200" height="7" colspan="3"></td>
</tr>
</table>