Á¦°¡ Çغ¸·Á°í ÇÏ´Â ÆÁÀÇ ¿ø¹®Àº ?
http://www.nzeo.com/bbs/zboard.php?id=cgi_tip&page=1&sn1=&divpage=1&sn=off&ss=on&sc=off&keyword=·©Å·&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Çü¼ºÀÌ ¾ÈµÇ³×¿ä ¸çÄ¥ ¸î³¯À» ¸Þ´Þ·Á ÀÖ¾ú´Âµ¥
Á¦ ¼öÁØ¿¡¼´Â phpadminÀ¸·Î ¹Ù·Î Á¢¼ÓÇÏ¿©
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;
±¸¹®À» ³Ö¾î º¸¾Æµµ ÀÚ²Ù ¿¡·¯°¡ ³ª¼ ¾ÈµÇ´õ¶ó±¸¿ä Çؼ Å×À̺í Ãß°¡·Î ÀÏÀÏÀÌ ÇÊ´õ¸¦ ¸¸µé¾ú´Âµ¥ ¹®Á¦´Â À§¿¡
UNIQUE KEY no (no) À̺κÐÀÌ ¾ÈµÇµ¥¿ä
UNIQUE KEY (no) ºÎºÐÀº Å° Ãß°¡·Î À̸§À» UNIQUE·Î ÇÏ°í ±â´ÉÀ» unique ÇØÁÖ°í Çʵ带 no·Î ÇØÁÖ¸é ¿¡·¯´Â ¾È³ª´Âµ¥ À§ ±¸¹®¿¡´Â no°¡ ÀÖÀݾƿä ? ÀÌ°Í db¸¦ ¾î¶»°Ô ¸¸µé¾î¾ß ÇÒÁö À§ ±¸¹®¿¡ ¿¡·¯°¡ ÀÖ³ª¿ä?
2. ÇÁ·Î±×·¥ º¸±â
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Â÷||À̾߱â||½º¼¦||°Ë°Ô||±Ã°Ô||¸¶°Ô||»ó°Ô||µµ°Ô||±Ã°Ô||Ãâ¼®";
$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>
**** ¸¶Áö¸·¿¡ Ãâ·ÂµÇ´Â ºÎºÐÀº »ç¿ëÀÚ°¡ ¸¶À½´ë·Î ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
**** ÇÁ·Î±×·¥ÀÇ »ç¿ë¹× ¼öÁ¤Àº ÀÚÀ¯À̳ª ¼öÁ¤¹èÆ÷½Ã¿¡´Â ÇÊÈ÷ Àú¿¡°Ô ¹®ÀÇÈÄ »ç¿ëÇϽñ⠹ٶø´Ï´Ù.
**** ÇÏ´ÜÀÇ ÀúÀÛ±Ç Ç¥±â¸¦ »èÁ¦ÈÄ »ç¿ë½Ã ÀúÀ۱ǹý¿¡ ÀÇÇÑ Ã³¹úÀ» ÇÒ¼öµµ ÀÖ½À´Ï´Ù.
**** À§ÀÇ Ãâ·Â¿¹´Â ±Û¾´¼ö¸¦ Ç¥±âÇϵµ·Ï µÇ¾î ÀÖÀ¸´Ï ¼Õ½±°Ô ¼öÁ¤ÇÒ¼ö ÀÖÀ»°Ì´Ï´Ù.
À§ ±¸¹®À¸·Î ÀÛµ¿½ÃÅ°¸é ¿¡·¯°¡ ³ª°Åµç¿ä
µ¥ÀÌŸ »ý¼ºÀÌ À߸ø µÇ¾î¼ ±×·±°ÇÁö ¸ð¸£°Ú´õ¶ó±¸¿ä
À§¿¡ member_nameÀº member_id·Î °íÃļ ÇØÁÖ¾ú°Åµç¿ä
unique key no (no) ÀÌ·±ºÎºÐ ¶§¹®¿¡ ±×·±°¡¿ä?
¸®µð´Ô// Á¦¹ß ÄÚ¸àÆ® ¸î¸¶µð¸¸ ÇØÁÖ½Ã¸é ¾ÈµÇ³ª¿ä?
Á¦°¡ º¸±â¿¡ ÀÌ°Ç ±×´ÙÁö ¾î·Á¿ï°Í °°Áö´Â ¾ÊÀºµ¥, ¾îµð¸¦ ¼Õ´ë¾ß Á¦´ë·Î µÇ´ÂÁö ¸ð¸£°Ú¾î¿ä
±×¸®°í db »ý¼º¿¡¼µµ unique key no (no) ÀÌ ºÎºÐÀ» Á» °¥ÄÑÁÖ¼¼¿ä
Åõ´úÀÌ php4 Ã¥ÀÚ¸¦ µÚÁ® º¸¾Ò´Âµ¥ sql ±¸¹®À» ÀÚ¼¼ÇÏ°Ô ¼³¸íÀ» ¾ÈÇØµÎ¾î¼ Á¦°¡ ³Ê¹« Èûµå³×¿ä
¹Ù»Ú½Ã´Ù°í ´äÀ» Á̴ּµ¥ Á¦°¡ ½Ç·Ê¸¦ ¹«¸¾²°í ´Ù½Ã Áú¹®À» ¿Ã¸®³×¿ä
ÁøÂ¥ Á˼ÛÇÕ´Ï´Ù.