<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<title> F2Blog 1.2 To SaBlog-X 1.6 转换程序 </title>
</head>
<body bgcolor="#CCCC99">
<?php
// ========================== 文件说明 ==========================//
// 本文件说明:F2Blog 1.2 To SaBlog-X 1.6 转换程序
// --------------------------------------------------------------//
// 本程序作者:dxx
// --------------------------------------------------------------//
// qq:1738143
// --------------------------------------------------------------//
// 本程序版本:SaBlog-X 1.6
// --------------------------------------------------------------//
// 本程序主页:http://www.sablog.net
// ==============================================================//
@header("content-Type: text/html; charset=UTF-8");
$_server= 'localhost'; //数据库主机名或IP
$_root= 'root'; //数据库用户名
$_pass= ''; //数据库密码
$_dbname = 'sablog'; //数据库名
$_charset='utf8'; //系统默认字符集
$sax_db_prefix = 'sablog_';//sablog数据表前缀
$f2_db_prefix = 'f2blog_';//f2blog数据表前缀
$db = mysql_connect($_server, $_root, $_pass);
if (!$db) {
die('连接失败: ' . mysql_error());
}else if(mysql_select_db($_dbname, $db)) {
mysql_query("set names $_charset", $db);
echo "数据库链接成功!<BR>" . "";
}else{
die('无效数据库: ' . mysql_error());
}
$act=$_GET['act'];
/*
editor 编辑者
author 撰写者
admin 管理员
member 用户
*/
switch($act) {
case 1: //先取用户表
$sql="TRUNCATE TABLE `{$sax_db_prefix}users`";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}members";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
if($row['role']=='admin') {
$sa_groupid = '1';
} elseif ($row['role']=='author' || $row['role']=='editor') {
$sa_groupid = '2';
} else {
$sa_groupid = '3';
}
$sql2="INSERT INTO {$sax_db_prefix}users(userid, username, password, url, logintime, loginip, logincount, groupid)
VALUES({$row['id']}, '{$row['username']}', '{$row['password']}', '{$row['email']}', '{$row['regTime']}', '{$row['lastVisitIP']}', '{$row['lastVisitTime']}', $sa_groupid)";
$result2 = mysql_query($sql2, $db);
if( $result2 ){
echo "用户: ". $row['username'] .": OK! " . "";
} else {
echo "用户: ". $row['username'] .": Error!" . mysql_error() . "";
}
}
echo '<BR><a href="?act=2">下一步:导入类别</a>';
break;
case 2: //类别
$sql="TRUNCATE TABLE `{$sax_db_prefix}categories`";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}categories";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$sql2="INSERT INTO `{$sax_db_prefix}categories`(cid, name, articles) VALUES('{$row['id']}', '{$row['name']}', '{$row['cateCount']}')";
$result2 = mysql_query($sql2, $db);
if($result2){
echo "类别: ". $row['name'] .": OK! " . "";
}else{
echo "类别: ". $row['name'] .": Error!" . mysql_error() . "";
}
}
echo '<BR><a href="?act=3">下一步:文章内容</a>';
break;
case 3: //文章内容
$sql="TRUNCATE TABLE {$sax_db_prefix}articles";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}logs";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$sql_users = "SELECT userid FROM {$sax_db_prefix}users WHERE username = '{$row['author']}'";
$resultuu = mysql_query($sql_users, $db);
while ($row_users = mysql_fetch_array($resultuu, MYSQL_ASSOC)) {
$result_users['userid'] = $row_users['userid'];
}
$row['logTitle']=str_replace("'", "'", $row['logTitle']);
$row['logContent']=str_replace("'", "'", $row['logContent']);
$row['tags']=str_replace(";", ",", $row['tags']);
$description = mb_substr($row['logContent'], 1, 350, 'UTF-8');
$sql2="INSERT INTO {$sax_db_prefix}articles(`articleid`, `cid`, `uid`, `title`, `description`, `content`, `keywords`, `dateline`, `views`, `comments`, `readpassword`, `attachments`)
VALUES('{$row['id']}', '{$row['cateId']}', '{$result_users['userid']}', '{$row['logTitle']}', '{$description}', '{$row['logContent']}','{$row['tags']}', '{$row['postTime']}', '{$row['viewNums']}', '{$row['commNums']}', '{$row['password']}', '' )";
$result2 = mysql_query($sql2, $db);
if($result2 ){
echo "日志: ". $row['logTitle'] .": OK! " . "";
}else{
echo "日志: ". $row['logTitle'] .": Error!" . mysql_error() . "";
echo $sql2; exit;
}
}
echo '<BR><a href="?act=4">下一步:标签tags</a>';
break;
case 4://标签tags
$sql="TRUNCATE TABLE {$sax_db_prefix}tags";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}tags";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$sql2="INSERT INTO {$sax_db_prefix}tags(tagid, tag, usenum, aids)
VALUES('{$row['id']}', '{$row['name']}', '{$row['logNums']}', '1')";
$result2 = mysql_query($sql2, $db);
if( $result2 ){
echo "标签: ". $row['name'] .": OK! " . "";
}else{
echo "标签: ". $row['name'] .": Error!" . mysql_error() . "";
echo $sql2; exit;
}
}
echo '<BR><a href="?act=5">下一步:附件信息</a>';
break;
case 5://附件
$sql="TRUNCATE TABLE {$sax_db_prefix}attachments";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}attachments";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$sql2="INSERT INTO {$sax_db_prefix}attachments(attachmentid, articleid, dateline, filename, filetype, filesize, downloads, filepath, thumb_filepath, thumb_width, thumb_height, isimage)
VALUES('{$row['id']}', '{$row['logId']}', '{$row['postTime']}', '{$row['attTitle']}', '{$row['fileType']}', '{$row['fileSize']}', '{$row['downloads']}', '', '{$row['name']}', '{$row['fileWidth']}', '{$row['fileHeight']}', '1')";
$result2 = mysql_query($sql2, $db);
if( $result2 ){
echo "附件: ". $row['attTitle'] .": OK! " . "";
} else {
echo "附件: ". $row['attTitle'] .": Error!" . mysql_error() . "";
echo $sql2; exit;
}
}
echo '<BR><a href="?act=6">下一步:友情链接</a>';
break;
case 6://友情链接
$sql="TRUNCATE TABLE {$sax_db_prefix}links";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}links";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$sql2="INSERT INTO {$sax_db_prefix}links(linkid, displayorder, name, url, note, visible)
VALUES('{$row['id']}', '{$row['orderNo']}', '{$row['name']}', '{$row['blogUrl']}', '', '1')";
$result2 = mysql_query($sql2, $db);
if( $result2 ){
echo "友情链接: ". $row['name'] .": OK! " . "";
}else{
echo "友情链接: ". $row['name'] .": Error!" . mysql_error() . "";
echo $sql2; exit;
}
}
echo '<BR><a href="?act=7">下一步:评论</a>';
break;
case 7://评论
$sql="TRUNCATE TABLE {$sax_db_prefix}comments";
mysql_query($sql, $db);
$sql="SELECT * FROM {$f2_db_prefix}comments";
$result = mysql_query($sql, $db);
while ($row= mysql_fetch_array($result, MYSQL_ASSOC)) {
$row['content']=str_replace("'", "'", $row['content']);
$row['content']=str_replace("", "\r\n", $row['content']);
$row['content']=str_replace("\r\n\r\n", "\r\n", $row['content']);
$sql2="INSERT INTO {$sax_db_prefix}comments(commentid, articleid, author, url, dateline, content, ipaddress, visible)
VALUES('{$row['id']}', '{$row['logId']}', '{$row['author']}', '{$row['email']}', '{$r
[博客空间]F2Blog 1.2 To SaBlog-X 1.6 转换程序_f2blog.rar
119 浏览量
2024-04-02
01:46:10
上传
评论
收藏 4KB RAR 举报
大黄鸭duck.
- 粉丝: 2540
- 资源: 1万+