################################################ ## ¾Æ·¡ include¿¡´Â ÇÔ¼ö¿Í DBÄ¿³ØÆ® ## ºÎºÐÀÔ´Ï´Ù. À̺κÐÀº °¢ÀÚ ¾Ë¾Æ¼... ^^; ################################################ include ("Á¦°¡ ¸¸µé¾î³õÀº ÇÔ¼ö.. "); include ("Database ¿¬°á..."); ################################################# // result_check µµ ¸¸µç ÇÔ¼öÀÔ´Ï´Ù. // °ø¹éüũ... result_check($code,"Äڵ尪ÀÌ ¾ø³×¿ä"); if ($mode == "edit" || $mode == "editok") { result_check($num,"¹øÈ£°¡ ¾øÀ½"); } else { result_check($year,"³âµµ°¡ ¾øÀ½"); result_check($mon,"¿ù ¾øÀ½"); result_check($day,"ÀÏ ¾øÀ½"); $regdate = "$year-$mon-$day"; } $si = date("H"); if ($si == 24 ) { $si_next = 1; } else { $si_next = $si + 1; } if ($notime == "Y") { $time_s = ""; $time_e = ""; } switch ($mode) { case "add": result_check($title,"Á¦¸ñÀÔ·ÂÀÌ ¾ø³×¿ä"); result_check($contents,"³»¿ëÀÔ·ÂÀÌ ¾ø³×¿ä"); if ($repeat) { result_check($repeatday,"¹Ýº¹È½¼ö¸¦ ±âÀÔÇØ ÁÖ¼¼¿ä"); if (is_int($repeatday)) { result_check("","¼ýÀÚ¸¸ ±âÀÔÇϼ¼¿ä"); } $flag = "Y"; } $connect = db_connect("DB¿ÀÇÂ"); // DB ¿ÀÇ if ($flag == "Y") { for ($i=0; $i < $repeatday; $i++) { $sql_max = "Select max(num) From schedule Where code = '$code'"; $result = mysql_query($sql_max,$connect); result_check($result,"Max ÃßÃâ¿¡·¯ÀÔ´Ï´Ù"); $row = mysql_fetch_array($result); if ($row) { $maxcnt = $row[0] + 1; } else { $maxcnt = 1; } switch ($repeat) { case "day": $k = $i+1; $title_day = "$title (". $k . "/" . "$repeatday)"; $sql_insert = "Insert Into schedule (code,num,regdate,kind,title,contents,important,time_s,time_e) " . " values ('$code',$maxcnt,DATE_ADD('$regdate',INTERVAL $i DAY),'$kind','$title_day','$contents','$important','$time_s','$time_e') "; break; case "week": $cnt = $i * 7; $sql_insert = "Insert Into schedule (code,num,regdate,kind,title,contents,important,time_s,time_e) " . " values ('$code',$maxcnt,DATE_ADD('$regdate',INTERVAL $cnt DAY),'$kind','$title','$contents','$important','$time_s','$time_e') "; break; case "mon": $sql_insert = "Insert Into schedule (code,num,regdate,kind,title,contents,important,time_s,time_e) " . " values ('$code',$maxcnt,DATE_ADD('$regdate',INTERVAL $i MONTH),'$kind','$title','$contents','$important','$time_s','$time_e') "; break; case "year": $sql_insert = "Insert Into schedule (code,num,regdate,kind,title,contents,important,time_s,time_e) " . " values ('$code',$maxcnt,DATE_ADD('$regdate',INTERVAL $i YEAR),'$kind','$title','$contents','$important','$time_s','$time_e') "; break; } $result = mysql_query($sql_insert,$connect); result_check($result,"ÀúÀå ¿¡·¯ÀÔ´Ï´Ù"); } } else { $sql_max = "Select max(num) From schedule Where code = '$code'"; $result = mysql_query($sql_max,$connect); result_check($result,"Max ÃßÃâ¿¡·¯ÀÔ´Ï´Ù"); $row = mysql_fetch_array($result); if ($row) { $maxcnt = $row[0] + 1; } else { $maxcnt = 1; } $sql_insert = "Insert Into schedule (code,num,regdate,kind,title,contents,important,time_s,time_e) " . " values ('$code',$maxcnt,'$regdate','$kind','$title','$contents','$important','$time_s','$time_e') "; $result = mysql_query($sql_insert,$connect); result_check($result,"ÀúÀå ¿¡·¯ÀÔ´Ï´Ù"); } echo ""; exit; break; case "edit": $connect = db_connect("DB¿ÀÇÂ"); // DB ¿ÀÇ $sql = "Select * From schedule Where code = '$code' and num = $num"; $result = mysql_query($sql,$connect); result_check($result,"Max ÃßÃâ¿¡·¯ÀÔ´Ï´Ù"); $row = mysql_fetch_array($result); result_check($row,"Error"); break; case "editok": $connect = db_connect("DB¿ÀÇÂ"); // DB ¿ÀÇ if ($repeat && $repeatday) { if (is_int($repeatday)) { result_check("","¼ýÀÚ¸¸ ±âÀÔÇϼ¼¿ä"); } switch ($repeat) { case "day": $sql = "Update schedule Set regdate = DATE_ADD(regdate,INTERVAL $repeatday DAY), kind = '$kind' , title ='$title' , contents = '$contents' , important = '$important' , " . " time_s = '$time_s' , time_e = '$time_e' Where code ='$code' and num = $num"; break; case "week": $cnt = $i * 7; $sql = "Update schedule Set regdate = DATE_ADD(regdate,INTERVAL $cnt DAY), kind = '$kind' , title ='$title' , contents = '$contents' , important = '$important' , " . " time_s = '$time_s' , time_e = '$time_e' Where code ='$code' and num = $num"; break; case "mon": $sql = "Update schedule Set regdate = DATE_ADD(regdate,INTERVAL $repeatday MON), kind = '$kind' , title ='$title' , contents = '$contents' , important = '$important' , " . " time_s = '$time_s' , time_e = '$time_e' Where code ='$code' and num = $num"; break; case "year": $sql = "Update schedule Set regdate = DATE_ADD(regdate,INTERVAL $repeatday YEAR), kind = '$kind' , title ='$title' , contents = '$contents' , important = '$important' , " . " time_s = '$time_s' , time_e = '$time_e' Where code ='$code' and num = $num"; break; } } else { $sql = "Update schedule Set kind = '$kind' , title ='$title' , contents = '$contents' , important = '$important' , " . " time_s = '$time_s' , time_e = '$time_e' Where code ='$code' and num = $num"; } $result = mysql_query($sql,$connect); result_check($result,"¼öÁ¤ ¿¡·¯ÀÔ´Ï´Ù"); echo ""; exit; break; } ?>