while ($KEY = db_fetch_array($KEY_UPDATE)) { $DEL_QUE = "SELECT BB_PID FROM kimsbod7_" . $table . "_dat "; $DEL_QUE .= "WHERE BB_PID >= {$NKEY} AND BB_PID < " . $KEY[KY_PID] . " ORDER BY BB_PID DESC LIMIT 0,1"; $UKEY = db_fetch_array(db_query($DEL_QUE, $DB_CONNECT)); $NKEY = $KEY[KY_PID]; if ($UKEY[BB_PID]) { db_query("UPDATE kimsbod7_" . $table . "_key SET KY_PID='" . $UKEY[BB_PID] . "' WHERE KY_KEY='" . $KEY[KY_KEY] . "'", $DB_CONNECT); } else { db_query("DELETE FROM kimsbod7_" . $table . "_key WHERE KY_KEY='" . $KEY[KY_KEY] . "'", $DB_CONNECT); } } $CMT_DATA = db_query("SELECT * FROM kimsbod7_" . $table . "_rpl WHERE RP_PARENT='{$uid}'", $DB_CONNECT); while ($CMT = db_fetch_array($CMT_DATA)) { getUpfileDelete($CMT[RP_FILE], $table); } getUpfileDelete($UID_DATA[BB_FILE], $table); db_query("DELETE FROM kimsbod7_" . $table . "_dat WHERE BB_UID='" . $uid . "'", $DB_CONNECT); db_query("DELETE FROM kimsbod7_" . $table . "_rpl WHERE RP_PARENT='" . $uid . "'", $DB_CONNECT); } getClose('총' . ($Multi_Uid_Num - 1) . '개의 데이터가 이동되었습니다.', $new_table); } if ($type == 'copy') { $table = $new_table; if ($MultiUid) { $Multi_Uid_Exp = explode(';', $MultiUid); $Multi_Uid_Num = sizeof($Multi_Uid_Exp); rsort($Multi_Uid_Exp); reset($Multi_Uid_Exp); for ($i = $Multi_Uid_Num - 1; $i >= 0; $i--) { if (!trim($Multi_Uid_Exp[$i])) { continue;
$CA_DATE = $year . $month . $day . '000000'; $QUE = "INSERT INTO kimsmall7_calendar\n\t(CA_SUBJECT,CA_CONTENT,CA_HTML,CA_FILE,CA_DATE)\n\tVALUES\n\t('{$CA_SUBJECT}','{$CA_CONTENT}','{$CA_HTML}','{$CA_FILE}','{$CA_DATE}')"; db_query($QUE, $DB_CONNECT); getLink($THIS_FILE . '?query=view&year=' . $year . '&month=' . $month . '&day=' . $day, '', ''); } if ($action == 'modify') { $CA_CONTENT = addslashes($BB_CONTENT); $CA_HTML = $BB_HTML ? $BB_HTML : 'TEXT'; $CA_FILE = $BB_FILE; $CA_DATE = $year . $month . $day . '000000'; $QUE = "UPDATE kimsmall7_calendar SET\n\tCA_SUBJECT = '{$CA_SUBJECT}',\n\tCA_CONTENT = '{$CA_CONTENT}',\n\tCA_HTML = '{$CA_HTML}',\n\tCA_FILE = '{$CA_FILE}',\n\tCA_DATE = '{$CA_DATE}'\n\tWHERE CA_UID='{$uid}'"; db_query($QUE, $DB_CONNECT); getLink($THIS_FILE . '?query=view&year=' . $year . '&month=' . $month . '&day=' . $day, '', ''); } if ($action == 'cal_del') { getUpfileDelete($files); db_query("DELETE FROM kimsmall7_calendar WHERE CA_UID='" . $uid . "'", $DB_CONNECT); getLink($THIS_FILE . '?year=' . $year . '&month=' . $month . '&day=' . $day, '', ''); } $year = $year ? $year : date("Y"); $month = $month ? $month : date("m"); $day = $day ? $day : date("d"); $query = $query ? $query : 'list'; $sday = date("Ymd", mktime(0, 0, 0, $month, $day - date("w", mktime(0, 0, 0, $month, $day, $year)), $year)); $startDate = $sweek ? $sweek : $sday; if ($sweek) { $year = substr($sweek, 0, 4); $month = substr($sweek, 4, 2); $day = substr($sweek, 6, 2); } $TOT_NUM = db_fetch_array(db_query("SELECT count(*) FROM kimsmall7_calendar", $DB_CONNECT));