Á¦°¡ ºËÁö´Â ¸øÇßÁö¸¸ ¸¹ÀÌ ¹Ù»Ú½Å°Í °°´øµ¥
nzeo¿¡ º¸´Ï ¾ø´Â ÆÁ°°Àºµ¥ Á¦°¡ °ü¸®ÇÏ´Â ±³È¸ ÇлýȨ¿¡¼ ÇÊ¿äÇÑ ÆÁÀ̶ó ¾î¶»°Ô ¸¸µé¸é µÉ±î Çؼ¿ä
(
http://sansunghigh.com )
Æ÷ÀÎÆ®·Î ¼øÀ§¸¦ »Ì´Â ÆÁÀº ¸î°¡Áö ÀÖ´øµ¥¿ä
±â°£À» Á¤Çصΰí Æ÷ÀÎÆ® ¼øÀ§¸¦ »Ì´Â ÆÁÀÌ ¾Èº¸¿©¼¿ä
Ȥ½Ã ¸¸µé¾îµÎ½Å°ÍÀÌ ÀÖÀ¸½Å°¡ Çؼ Á˼ÛÇÕ´Ï´Ù.
ÀÌ»óÇÑ Áú¹®°ú ¿äû¸¸ Çؼ¿ä
nzeo¿¡ ÃÖ±Ù¿¡ ¿Ã¶ó¿Â°ÍÀÌ Çϳª ÀÖ±â´Â ÇÏ´øµ¥ Á¦°¡ Çغ¸´Ï ÇÊ´õ Ãß°¡µµ ¾ÈµÇ°í ¿¡·¯°¡ ¹ß»ýÇؼ ¾ÈµÂ´õ¶ó±¸¿ä
½Ã°£ µÇ½Ã¸é ¼³¸íÀ» Á» ÇØÁּŵµ °¨»çÇÒ°Í °°½À´Ï´Ù .
½Ç·Ê µÉ°Í °°Àºµ¥ nzeoÀÇ ÁÖ¼Ò¸¦ ¸µÅ©ÇÏ°í
(
http://www.nzeo.com/bbs/zboard.php?id=cgi_tip&page=3&sn1=&divpage=1&sn=off&ss=on&sc=off&select_arrange=headnum&desc=asc&no=4617 )
Á¦°¡ Àß ¸ð¸£°Ú´Â ºÎºÐÀº ¾Æ·¡¿¡ Ç¥½ÃÇÒ²²¿ä
**¿©±âºÎÅÍ ÆÁ³»¿ëÀÔ´Ï´Ù.**
1. µðºñ ÇÊµå ¸¸µé±â.
´Ù¸¥ ¹æ¹ýµµ ¸¹ÀÌ »ý°¢À» ÇغÃÁö¸¸ ³¯¸¶´Ù µðºñ¿¡ ÀúÀåÇÏ¿© »Ì´Â ÆíÀÌ Á¦ÀÏ ÆíÇÑ ¹æ¹ýÀϰŶó°í »ý°¢ÇÏ¿© µðºñÀÚ¿øÀ» Á¶±Ý ¾²µµ·Ï ÇÕ´Ï´Ù.
<?
$host = "localhost";
$user = "******"; //mysql ID
$password = "******"; //mysql PW
$dbname = "******"; //DataBase Name
$query = "
CREATE TABLE lank (
no int(11) NOT NULL auto_increment,
member_no int(11) NOT NULL default '',
member_id varchar(20) NOT NULL default '',
wp int(20) NOT NULL default '',
cp int(20) NOT NULL default '',
check_date int(13) NOT NULL default '',
PRIMARY KEY (no),
UNIQUE KEY no (no)
) TYPE=MyISAM;";
//µðºñÄ¿³Ø¼Ç
mysql_connect($host,$user,$password);
//Äõ¸®½ÇÇà
$result = mysql_db_query($dbname,$query);
?>
À§ÀÇ ÇÁ·Î±×·¥À» º¹»çÇÏ¿© Á¦·Îº¸µå Æú´õ¿¡ ¿Å±â½ÅÈÄ ½ÇÇàÇÏ¿© ÁÖ½Ã¸é »ý¼ºÀÌ µË´Ï´Ù.
***
Àú´Â db ¾È ¸¸µé¾îÁö´Â°Í °°¾Æ¿ä ½ÇÇàÇϸé Çü¼ºµÇ¾ú´Ù´Â Ç¥½Ã´Â ¾È³ª¿À°í ±×³É blank ȸéÀÌ ³ª¿É´Ï´Ù.
2. ÇÁ·Î±×·¥ º¸±â
<?
/******************************************************************************
* ¿ùº° ±Û¾²±â ÄÚ¸àÆ® ¼øÀ§ Ç¥±âÇϱâ
*
* ÇÁ·Î±×·¡¹Ö : ¹Ú»ó¿¬(yumemiru@zeeps.com)
*
* ȨÆäÀÌÁö :
http://zeeps.com
*
* ÀÌ ÇÁ·Î±×·¥Àº ¿ùº° ±Û¾´¼ö¿Í ÄÚ¸àÆ®¼ö¸¦ Ç¥±âÇϱâ À§ÇØ ¸¸µé¾ú½À´Ï´Ù..
*
* ÀúÀÛ±Ç ¸í½Ã¸¦ »èÁ¦ÇÏ½Ã¸é ¾ÈµË´Ï´Ù.
*
* ¿øÇϽô´ë·Î ¼öÁ¤ÇÏ¿© »ç¿ëÇϽǼö ÀÖÀ¸³ª ¼öÁ¤ÈÄ ¹èÆ÷´Â ÇÏÁö¸¶½Ã±â ¹Ù¶ø´Ï´Ù.
*
*****************************************************************************/
$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); //ƯÁ¤ÇÏ°Ô ÁöÁ¤µÈ ³¯Â¥ÀÇ ½Ã°£À» ÃÊ´ÜÀ§·Î ±¸ÇØÁÝ´Ï´Ù./
$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 from zetyx_member_table where last_write >'$first_day'",$connect);
//$temp2 =mysql_query("select no,name from zetyx_member_table",$connect);
$target_board = "freeboard||q_a||tips||oekaki||to_admin||rk_skin||mycharacter||mycharacter2||iyagi||screenshot||swordman||archer||magican||merchant||thief||acolyte||attendance"; //»ý¼ºÇÑ °Ô½ÃÆÇ ¾ÆÀ̵𸦠¸ðµÎ Àû´Â´Ù
$arry_board = explode("||",$target_board);
$target_borad_name= "ÀÚ°Ô||Áú´ä||ÆÁ||¿À¿¡||Á¤º¸||½ºÅ²||1Â÷||2Â÷||À̾߱â||½º¼¦||°Ë°Ô||±Ã°Ô||¸¶°Ô||»ó°Ô||µµ°Ô||±Ã°Ô||Ãâ¼®";
*** ÀÌ°Í board_nameÀº ¾ÈÀû¾îµµ ¾ÈµÇ³ª¿ä? º¸µåÀ̸§Àº ÀÓÀÇ·Î ÁÖ´Â °ÍÀÌÁö db¿¡ º¸°ü ¾ÈµÇÀݾƿä?
$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];
$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_name,wp,cp,check_date) values ('$mem_no','$mem_name','$write','$comment','$to_day')") or error(mysql_error());
}
// ºÒÇÊ¿äÇÑ µðºñ ÀÚ¿øÀ» »èÁ¦ÇÕ´Ï´Ù.
$result = mysql_query("delete from lank where check_date < '$to_day'");
}
?>
<table border=0 cellspacing=0 cellpadding=0 width=185>
<tr>
<td height=27 bgcolor=445599>
< img src=http://zeeps.com/ver4/images/t.gif border=0 height=5>
< font color=white> < b><?=$month?>¿ùÀÇ ±Û¿Ã¸²ÀÌ(~<?=$month?>¿ù<?=$day?>ÀÏ)
</td>
</tr>
</table>
< img src=http://zeeps.com/ver4/images/t.gif height=2>
<table border=0 width=185 cellspacing=1 cellpadding=8 bgcolor=A9DDDE>
<tr><td valign=top bgcolor=white>< img src=http://zeeps.com/ver4/images/t.gif border=0 height=4>
<?
$lankSql = "select * from lank where check_date = '$to_day' order by wp desc limit 5";
$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_name];
$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/zs.gif' border=0 align=absmiddle>".$mem_name;
}
$write_no=$lank_data[wp];
$comment_no=$lank_data[cp];
echo "$i ˤ $mem_name ($write_no)
";
echo "< img src=http://zeeps.com/ver4/images/t.gif border=0 height=10>
";
$i++;
}
echo "< a href=http://zeeps.com target=_blak>< font color=orange>program by À¯¸Þ¹Ì·ç";
?>
</td></tr>
</table>
**** ¸¶Áö¸·¿¡ Ãâ·ÂµÇ´Â ºÎºÐÀº »ç¿ëÀÚ°¡ ¸¶À½´ë·Î ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
**** ÇÁ·Î±×·¥ÀÇ »ç¿ë¹× ¼öÁ¤Àº ÀÚÀ¯À̳ª ¼öÁ¤¹èÆ÷½Ã¿¡´Â ÇÊÈ÷ Àú¿¡°Ô ¹®ÀÇÈÄ »ç¿ëÇϽñ⠹ٶø´Ï´Ù.
**** ÇÏ´ÜÀÇ ÀúÀÛ±Ç Ç¥±â¸¦ »èÁ¦ÈÄ »ç¿ë½Ã ÀúÀ۱ǹý¿¡ ÀÇÇÑ Ã³¹úÀ» ÇÒ¼öµµ ÀÖ½À´Ï´Ù.
**** À§ÀÇ Ãâ·Â¿¹´Â ±Û¾´¼ö¸¦ Ç¥±âÇϵµ·Ï µÇ¾î ÀÖÀ¸´Ï ¼Õ½±°Ô ¼öÁ¤ÇÒ¼ö ÀÖÀ»°Ì´Ï´Ù.
****ÀÌ°Í ½ÇÇàÇÏ´Ï ±¸¹®ÀÚü¿¡¼ ¿¡·¯°¡ °è¼Ó ³ª´õ¶ó±¸¿ä
¼³¸íÁ» ÇØÁÖ½Ã¸é ¾ÈµÉ±î¿ä?
³¡±îÁö ÀоîÁּż °¨»çÇÕ´Ï´Ù.