http://sansunghigh.com/bbs/month_ranking.php
·Î ¿ùº° ±Û¾´¼øÀ§´Â »Ì¾Ò´Âµ¥¿ä º¸½ÃµíÀÌ °ü¸®ÀÚ°¡ ·©Å·¿¡ ³ª¿À°Åµç¿ä ÀÌ°Å »¬·Á°í Çϴµ¥ ¾îµð¸¦ ¼öÁ¤ÇÏ¸é µÉ±î¿ä?
ÀÌ°Å Çß´Ù´Â °Í¸¸À¸·Îµµ ¾ÆÁÖ ±â»Ûµ¥¿ä °ü¸®ÀÚ°¡ ¼øÀ§¿¡ ³ª¿Í¼ ºÎŹµå¸³´Ï´Ù.
¼Ò½º´Â ¿©±âºÎÅÍ ÀÔ´Ï´Ù.
<?
/******************************************************************************
* ¿ùº° ±Û¾²±â ÄÚ¸àÆ® ¼øÀ§ Ç¥±âÇϱâ
*
* ÇÁ·Î±×·¡¹Ö : ¹Ú»ó¿¬(yumemiru@zeeps.com)
*
* ȨÆäÀÌÁö :
http://zeeps.com
*
* ÀÌ ÇÁ·Î±×·¥Àº ¿ùº° ±Û¾´¼ö¿Í ÄÚ¸àÆ®¼ö¸¦ Ç¥±âÇϱâ À§ÇØ ¸¸µé¾ú½À´Ï´Ù..
*
* ÀúÀÛ±Ç ¸í½Ã¸¦ »èÁ¦ÇÏ½Ã¸é ¾ÈµË´Ï´Ù.
*
* ¿øÇϽô´ë·Î ¼öÁ¤ÇÏ¿© »ç¿ëÇϽǼö ÀÖÀ¸³ª ¼öÁ¤ÈÄ ¹èÆ÷´Â ÇÏÁö¸¶½Ã±â ¹Ù¶ø´Ï´Ù.
*
*****************************************************************************/
include "lib.php";
$connect=dbConn();
$now = time(); // ÇöÀç ½Ã°£À» ÃÊ´ÜÀ§·Î ±¸ÇØÁÝ´Ï´Ù. time()»ç¿ëÇϸé À¯´Ï¹ö¼³½ºÅÛÇÁŸÀÓ ¿©Æ° À̰ɱ¸ÇØÁÝ´Ï´Ù./
$year = date('Y');
$month = date('m');
$day = date('d');
$hour = date('H'); // ÇöÀç ¸î½ÃÀÎÁö ±¸ÇØÁÝ´Ï´Ù. h´Â 12½Ã°£À¸·Î Ç¥±â H´Â 24½Ã°£À¸·Î Ç¥±âÇØÁÝ´Ï´Ù./
$min = date('i'); // ÇöÀç ¸îºÐÀÎÁö ±¸ÇØÁÝ´Ï´Ù./
$sec = date('s'); // ÇöÀç ¸îÃÊÀÎÁö ±¸ÇØÁÝ´Ï´Ù./
$to_day = mktime(0,0,0,$month,$day,$year); file://ƯÁ¤ÇÏ°Ô ÁöÁ¤µÈ ³¯Â¥ÀÇ ½Ã°£À» ÃÊ´ÜÀ§·Î ±¸ÇØÁÝ´Ï´Ù./
$first_day = mktime(0,0,0,$month,1,$year); // ¸Å¿ù 1ÀÏÀ» ±¸ÇÔ./
$end_day = date('t'); // ÀÌ´ÞÀÇ ¸¶Áö¸·³¯.
$lankSql = "select * from lank where check_date = '$to_day' order by wp desc limit 1";
$count_lank = mysql_query($lankSql,$connect);
$count_ok = mysql_num_rows($count_lank);
if($count_ok==0)
{
// Á¦°¡ »ç¿ëÇϴ ȨÆäÀÌÁö¿¡¼´Â ¸¶Áö¸·±Û¾´³¯À» Ç¥±âÇϵµ·Ï ÇÏ¿´À¸¹Ç·Î ÀÌ·± ¹æ½ÄÀ» »ç¿ëÇÕ´Ï´Ù.
$temp2 = mysql_query("select no,name,level from zetyx_member_table where last_write >'$first_day'",$connect);
$temp2 = mysql_query("select no,name,level from zetyx_member_table",$connect);
$target_board = "high_tech_book1||high_tech_search||tech_pray1||tech_3rd||tech_visit1||tech_search1||tech_paper1"; file://»ý¼ºÇÑ °Ô½ÃÆÇ ¾ÆÀ̵𸦠¸ðµÎ Àû´Â´Ù
$arry_board = explode("||",$target_board);
$target_borad_name = ±³»çÃßõµµ¼||±³»ç°ø°úÀÚ·á||±³»çÁߺ¸±âµµ||°í3¾î¸Ó´Ï||Çлý½Å¹æÀÏÁö||ÁÖÀÏ¿¹¹è ÀÚ·á½Ç||¼±âºÎ°øÁö||"; //°Ô½ÃÆÇÀ̸§ ´Ù Àû´Â´Ù ÀÌ°Ç º°·Î ¾ÈÁß¿äÇÑµí ¾ø¾îµµ µÉ°Í °°¾Æ¿ä
$title_name_temp = explode("||",$target_borad_name);
$boardTotal = sizeof($arry_board);
while($mem_data = mysql_fetch_array($temp2)){
$mem_no = $mem_data[no];
$mem_name = $mem_data[name];
$mem_level = $mem_data[level];
$write = 0;
$comment = 0;
for ($k=0;$boardTotal>$k;$k++)
{
$board_name=$arry_board[$k];
$countSql = "select * from zetyx_board_$board_name where ismember='$mem_no' and reg_date>'$first_day'";
$count = mysql_query($countSql,$connect);
$write = $write + mysql_num_rows($count);
$countSql = "select * from zetyx_board_comment_$board_name where ismember='$mem_no' and reg_date>'$first_day'";
$count = mysql_query($countSql,$connect);
$comment = $comment + mysql_num_rows($count);
}
mysql_query("insert into lank (member_no,member_level,member_id,wp,cp,check_date) values ('$mem_no','$mem_level','$mem_name','$write','$comment','$to_day')") or error(mysql_error());
}
// ºÒÇÊ¿äÇÑ µðºñ ÀÚ¿øÀ» »èÁ¦ÇÕ´Ï´Ù.
$result = mysql_query("delete from lank where check_date < '$to_day'");
}
?>
<br>
<br>
<table cellspacing=0 cellpadding=0 width=160 style="border-width:1px; border-color:rgb(68,85,153); border-style:solid;">
<tr>
<td align=center>
<table border=0 cellspacing=0 cellpadding=0 width=99%>
<tr>
<td height=27 align=center bgcolor=445599>
<font color=white><b><?=$month?>¿ùÀÇ ±Û¿Ã¸²ÀÌ<br>(~<?=$month?>¿ù<?=$day?>ÀÏ)</b></font>
</td>
</tr>
</table>
<table border=0 width=99% cellspacing=0 cellpadding=8 bgcolor=A9DDDE>
<tr><td valign=top bgcolor=white>
<?
$lankSql = "select * from lank where check_date = '$to_day' order by wp desc limit 10";
$count_lank = mysql_query($lankSql,$connect);
$i=1;
while($lank_data = mysql_fetch_array($count_lank)){
$mem_no=$lank_data[member_no];
$mem_name=$lank_data[member_id];
$mem_level=$lank_data[member_level];
$private_icon_file=$_zb_path."icon/private_icon/".$mem_no.".gif";
if(@file_exists($private_icon_file)) {
$private_icon_file=$_zb_url."icon/private_icon/".$mem_no.".gif";
$mem_name="<img src='$private_icon_file' border=0 align=absmiddle>".$mem_name;
}
else{
$mem_name="<img src='".$_zb_url."images/level-$mem_level.gif' border=0 align=absmiddle>".$mem_name;
}
$write_no=$lank_data[wp];
$comment_no=$lank_data[cp];
echo "$i ˤ $mem_name ($write_no/$comment_no)<br>
";
$i++;
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>