Ejemplo n.º 1
0
         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;
Ejemplo n.º 2
0
    $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));