<? include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php"; ?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<?
$tableName = "board_schedule";

	//쓰기
	if($mode == "write"){
                $sch_date = explode("-",$cal_Date);
				$query = "INSERT INTO $tableName(year,month,schedule_date,is_notice,is_secret,subject,sub_content,reg_date) VALUES
												('$sch_date[0]', '$sch_date[1]','$cal_Date','$is_notice','$is_secret','$subject','$sub_content',now())";
				$result = mysql_query($query,$db_con);

					echo ("<script>
                                    //window.alert('입력됐습니다.');
                                    location.href='../schedule.php';
                                </script>");


	//수정
	}else if($mode == "proc"){
                    $sch_date = explode("-",$cal_Date);
					$query = "update $tableName set year='$sch_date[0]',month='$sch_date[1]',schedule_date='$cal_Date',is_notice='$is_notice',is_secret='$is_secret',subject='$subject',sub_content='$sub_content' where no = '$idx'";
					$result = mysql_query($query,$db_con);

					echo ("<script>
													//alert('수정됐습니다.');
													location.href='../schedule.php';
												</script>");



	//삭제
	}else if($mode =="del"){


						$query =  mysql_query("DELETE FROM $tableName where no = '$idx'",$db_con);
						echo ("<script>
													alert('삭제했습니다.');
													location.href='../schedule.php';
												</script>");
	}

?>