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 />";