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);
// 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 { echo $writeContent; }