bo-blog1.7x 转x-space2.x的简单代码

上一篇 / 下一篇 2007-03-07 04:39:52 / 个人分类：LAMP

写的比较简单

<?
# bo-blog 1.x 转换程序for 平凡的香草
# x-space中已经导入部分日志，来源是由bo-blog1.7升级后的bo-blog2.x
# 但是在 bo-blog 1.7 升级到2.x的过程中，丢了了大量（300）篇日志（无法导入），一直没有补上
# 借从bo-blog转换到x-space的机会，将原来的日志一并导入。这部分代码是专门用来处理1.7升级过程中无法导入的那部分日志的
# 只导入日志，不处理其他内容
# 补充：经过检查，发现bo-blog 1.x 文本版通过 list.php 文件作为索引，之前无法导入的日志，主要是由于list.php不再完整。
# 两种思路，1，修正list的php，导入数据库版本blog，然后再通过程序转换
#           2，直接读类别列表，通过帖子时间检查是否已经导入x-space，如果没有，则直接从文件中读取数据，然后导入x-space
$target_server   = "localhost:/tmp/mysql.sock";
$target_db       = "discuz5_gbk";
$target_db_user = 'root';
$target_db_pw   = '';
$catid           = 32; #你想转入的类别id
$itemtypeid    = 55; # 你想转入的个人分类id
$uid           = 3434324; #转入用户的uid，discuz的uid
$username       = 'xxxx'; #转入用户的用户名
$username       = addslashes($username);
$datadir       = 'ofJ8Ls09';
$listfiles       = array('1.php','2.php','3.php','4.php','5.php','6.php','7.php','8.php','9.php','10.php','11.php','12.php');
$line_array       = array();

$target_link = mysql_connect($target_server,$target_db_user,$target_db_pw);
if($target_link){
   mysql_select_db($target_db);
}else {
   echo "Connect to $target_server:$target_db with $target_db_user ERRor!";
}

if (is_dir($datadir)) {
    if ($dh = opendir($datadir)) {
        /*
       while (($file = readdir($dh)) !== false) {
            echo "filename: $file : filetype: " . filetype("$datadir/$file") . "\n";
        }
        closedir($dh);
        */
    }else {
       echo "opendir error \n";
       exit(1);
    }
    closedir($datadir);
}
foreach ($listfiles as $listfile) {
   echo "\n Listfile : $listfile\n";
   if($list = file("$datadir/$listfile")){
       foreach ($list as $line){
           $line_array = explode('|',$line);
           print_r($line_array[1]);
           print("\n");
           if($content = file_get_contents("$datadir/$line_array[1].art")){
              $content = addslashes(convert_utf82gbk($content));
           }else {
              echo "File_get_contents Error \n";
              exit(1);
           }
           $query_select = "select dateline from {$target_db}.supe_spaceitems where dateline=$line_array[3];";
           if(mysql_query($query_select)){
              $num_rows = mysql_num_rows($result);
              if($num_rows>1){
                  continue;
              }
           }
               print("\n\n");
               $tid       =   0;           // 对应论坛主题 id
               #$username   =   $i['username'];
               #$itemtypeid   =   $i['dirid'];       // 个人分类ID
               $type       =   'blog';
               $subtype   =   '';           // 信息分类型
               $subject   =   addslashes(convert_utf82gbk($line_array[2]));
               $dateline   =   $line_array[3];
               $lastpost   =   0;
               $viewnum   =   $line_array[4];           // 点击次数
               $replynum   =   0;
               $trackbacknum   =   0;       // Trackback 数
               $goodrate   =   0;
               $badrate   =   0;
               $digest       =   0;
               $top       =   0;
               $allowreply   =   1;
               $folder       =   1;
               $haveattach   =   0;
               $grade       =   0;
               $query_insert = "INSERT INTO {$target_db}.supe_spaceitems (`catid`, `uid`, `tid`, `username`, `itemtypeid`, `type`, `subtype`, `subject`, `dateline`, `lastpost`, `viewnum`, `replynum`, `trackbacknum`, `goodrate`, `badrate`, `digest`, `top`, `allowreply`, `folder`, `haveattach`, `grade`) VALUES('$catid', '$uid', '$tid', '$username', '$itemtypeid', '$type', '$subtype', '$subject', '$dateline', '$lastpost', '$viewnum', '$replynum', '$trackbacknum', '$goodrate', '$badrate', '$digest', '$top', '$allowreply', '$folder', '$haveattach', '$grade');";
               print_r ($query_insert);
               echo "\n";
               $includetags = '';
               $message = $content;

                #exit(0);
                if(mysql_query($query_insert,$target_link)){
                    $itemid        = mysql_insert_id($target_link);
                    $hash        = substr(md5($itemid), 8, 16);    // 表单关联
                    $query_update    = "update {$target_db}.supe_spaceitems set hash='$hash' where itemid='$itemid';";
                    print_r($query_update);
                    if(mysql_query($query_update,$target_link)){
                        echo "convert subject:$subject \n\n";
                    }else {
                        echo mysql_error();
                        exit(1);
                    }
                    $query_insert_content = "INSERT INTO {$target_db}.supe_spaceblogs (`itemid`, `message`, `relativetags`, `postip`, `relativeitemids`, `customfieldid`, `customfieldtext`, `includetags`, `mood`, `weather`) VALUES ('$itemid', '$message', '$relativetags', '$postip', '$relativeitemids', '$customfieldid', '$customfieldtext', '$includetags', '$mood', '$weather');";
                    echo "\n $query_insert_content \n";
                    #$query_insert_content = $post['content'];
                    #exit(0);
                    if(mysql_query($query_insert_content,$target_link)){
                        echo "inster into supe_spaceblogs $itemid\n";
                    }else {
                        echo mysql_error();
                        exit(1);
                    }
                }else {
                    echo mysql_error();
                    exit(1);
                }
        }
    }else {
        echo "file() $filelist error\n";
        exit(1);
    }
}

mysql_close();

echo "\n All have convert into x-space \n";

function daddslashes($string) {
    if(!@ini_get('register_globals') || !get_magic_quotes_gpc()) {
        if(is_array($string)) {
            foreach($string as $key => $val) {
                $string[$key] = daddslashes($val);
            }
        } else {
            $string = addslashes($string);
        }
    }
    return $string;
}

function convert_utf82gbk($msg) {
    return iconv('UTF-8','gbk', $msg);
}
?>

关于作者

平凡的香草

bo-blog1.7x 转x-space2.x的简单代码

相关阅读:

关于作者