echo "正在转换日志 ...";
ob_flush();
flush();
$i = 0;
$insert_value = array();
$arr_fields = array("log_ID" => "id", "log_CateID" => "cateId", "log_Title" => "logTitle", "log_Content" => "logContent", "log_Author" => "author", "log_CommNums" => "commNums", "log_QuoteNums" => "quoteNums", "log_ViewNums" => "viewNums", "log_PostTime" => "postTime", "log_IsShow" => "saveType", "log_tag" => "tags");
$rs->Open("select * from blog_Content", $conn, 1, 1);
while (!$rs->eof) {
foreach ($arr_fields as $key => $value) {
$f = $rs->Fields($key);
$field_value = convert_quote($f->value);
if ($key == "log_PostTime") {
$field_value = pjtime_convert($field_value);
}
if ($key == "log_Content") {
$field_value = convert_ubb($field_value);
}
$insert_value[$i][$value] = $field_value;
}
$i++;
$rs->MoveNext();
}
//print_r($insert_value);
$DMC->query("TRUNCATE TABLE " . $DBPrefix . "logs");
foreach ($insert_value as $value) {
$key = array_keys($value);
$insert_sql = "insert into " . $DBPrefix . "logs(" . implode(",", $key) . ",isComment,isTrackback) values('" . implode("','", $value) . "','1','1')";
$DMC->query($insert_sql);
}
echo " 共转换了<font color=red>" . $i . "</font>条记录<br /><br />";
$rs->Close();
function getrsscontent($content, $advanced = 0, $ubb = 1, $emot = 1)
{
$content = str_replace('[separator]', '', $content);
$content = str_replace('[newpage]', '', $content);
if ($emot == 1) {
$content = preg_replace("/\\[emot\\]([^ ]+?)\\[\\/emot\\]/is", '', $content);
}
if ($ubb == 1) {
include_once "inc/ubb.php";
$content = convert_ubb($content, $advanced, 1);
}
return $content;
}
$rs->Open("select * from blog_Article", $conn, 1, 1);
while (!$rs->eof) {
foreach ($arr_fields as $key => $value) {
$f = $rs->Fields($key);
$field_value = convert_quote($f->value);
if ($key == "log_mode") {
$field_value = $field_value > 1 ? 3 : 1;
}
if ($key == "log_postTime") {
$field_value = lbstime_convert($field_value);
}
if ($key == "log_content0") {
$field_value = convert_ubb($field_value);
$log_content1 = $rs->Fields("log_content1")->value;
if (!empty($log_content1)) {
$field_value .= "<!--more-->" . convert_ubb(convert_quote($log_content1));
}
}
$insert_value[$i][$value] = $field_value;
}
$i++;
$rs->MoveNext();
}
//print_r($insert_value);
$DMC->query("TRUNCATE TABLE " . $DBPrefix . "logs");
foreach ($insert_value as $value) {
$key = array_keys($value);
$insert_sql = "insert into " . $DBPrefix . "logs(" . implode(",", $key) . ",isComment,isTrackback) values('" . implode("','", $value) . "','1','1')";
$DMC->query($insert_sql);
}
echo " 共转换了<font color=red>" . $i . "</font>条记录<br /><br />";
