Пример #1
0
    mysql_query('ALTER TABLE ' . SQLLOG . ' ADD imgh SMALLINT(1) NOT NULL AFTER imgw');
    // imgh
    mysql_query('ALTER TABLE ' . SQLLOG . ' ADD imgsize VARCHAR(10) NOT NULL AFTER imgh');
    // imgsize
    mysql_query('ALTER TABLE ' . SQLLOG . ' CHANGE md5 md5chksum VARCHAR(32) NOT NULL');
    // md5chksum
    mysql_query('ALTER TABLE ' . SQLLOG . ' CHANGE w tw SMALLINT(1) NOT NULL');
    // tw
    mysql_query('ALTER TABLE ' . SQLLOG . ' CHANGE h th SMALLINT(1) NOT NULL');
    // th
    mysql_query('ALTER TABLE ' . SQLLOG . ' MODIFY status VARCHAR(255) NOT NULL');
    // status
    mysql_query('UPDATE ' . SQLLOG . ' SET status = "_TS_" WHERE status = "T"');
    // status 旗標改變
    mysql_free_result($result);
    $tmpSQL = 'SELECT no,tim,ext FROM ' . SQLLOG . ' WHERE ext <> "" ORDER BY no';
    if (!($result2 = mysql_query($tmpSQL))) {
        echo "sql失敗814<br>";
    }
    while (list($dno, $dtim, $dext) = mysql_fetch_row($result2)) {
        // 個別跑迴圈
        $s = getImageWH($dtim . $dext);
        // 圖檔寬長
        mysql_query('UPDATE ' . SQLLOG . ' SET imgsize = "' . getImageSizeText($dtim . $dext) . '", imgw = ' . $s[0] . ', imgh = ' . $s[1] . ' WHERE no = ' . $dno);
    }
    mysql_free_result($result2);
    echo 'done.';
} else {
    echo 'It seems already done.';
}
mysql_close($con);
Пример #2
0
}
/* 更改 log 檔結構 */
// OLD: 編號,時間 (ID),名稱,E-Mail,標題,內文,狀態旗標,主機位置,編碼後文章密碼,附加圖檔類型,預覽圖寬,預覽圖長,Unix時間撮記,附加圖檔MD5,
//      0    1         2    3      4    5    6        7        8              9           10       11       12           13
// NEW: 編號,回應目標編號,附加圖檔MD5,類別標籤,Unix時間撮記,附加圖檔類型,圖檔寬,圖檔長,圖檔大小,預覽圖寬,預覽圖長,編碼後文章密碼,時間 (ID),名稱,E-mail,標題,內文,主機位置,狀態旗標,
//      0    1            2           3        4            5            6      7     8        9        10       11             12        13   14     15   16   17       18
header('Content-Type: text/plain; charset=utf-8');
$newLine = array();
// 新資料格式
if (count(explode(',', $logimg[0])) != 15) {
    die('File structure error. maybe it\'s already a PIO structure.');
}
for ($i = 0; $i < $logimg_cnt; $i++) {
    $l = explode(',', $logimg[$i]);
    // 舊資料格式 (用逗號拆開)
    $s = getImageWH($l[12] . $l[9]);
    // 圖檔寬長 (寬, 長)
    $l[6] = str_replace('_THREADSTOP_', '_TS_', $l[6]);
    // 討論串停止旗標自 _THREADSTOP_ 改為 _TS_
    if (!DEL_ZOMBIE || getReplyTargetNo($l[0]) !== false) {
        $newLine[] = implode(',', array($l[0], getReplyTargetNo($l[0]), $l[13], '', $l[12], $l[9], $s[0], $s[1], getImageSizeText($l[12] . $l[9]), (int) $l[10], (int) $l[11], $l[8], $l[1], $l[2], $l[3], $l[4], $l[5], $l[7], $l[6], '')) . "\r\n";
    }
}
$writeContent = implode('', $newLine);
if (SAVE_LOG) {
    rename(LOGFILE, LOGFILE . '.old');
    $fs = fopen(LOGFILE, 'w');
    fwrite($fs, $writeContent);
    fclose($fs);
    die('File save OK. The old file already renamed.');
} else {