bo-blog2.x 转x-space2.x的简单代码

上一篇 / 下一篇 2007-03-07 10:49:03 / 个人分类：LAMP

<?
//require_once("global.php");
$target_server   = "localhost:/tmp/mysql.sock";
$target_db       = "discuz5_gbk";
$target_db_user = 'root';
$target_db_pw   = '';
$catid           = 32; #你想转入的类别id
$itemtypeid    = 55; # 你想转入的个人分类id
$uid           = 34223423; #转入用户的uid，discuz的uid
$username       = 'xxxxx'; #转入用户的用户名
$username       = addslashes($username);
$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!";
}

include ("function.php");
echo "bo-blog 2.x(?) to x-space 2.x !";
$posts = GetNewPosts(2,"title, blogid");
if($posts){
        #print_r($posts);
        echo "gbk string";
        foreach ($posts as $post){
                print $post['1'];
                print iconv('UTF-8','gbk',$post['title']);
        }

}else{
        echo "No posts select !";
}

$count = $blog->getbyquery('select count(blogid) from boblog_blogs');
if($count < 1){
   echo " No posts in the bo-blog ";
   exit(0);
}
print_r($count['count(blogid)']);
$count = $count['count(blogid)'];
$posts = GetNewPosts($count,"blogid,title,pubtime,replies,views,tags,content,views,property,category");
if($posts){
        #print_r($posts);
        echo "gbk string";
       mysql_select_db($target_db,$target_link);
       global $catid;
        foreach ($posts as $post){
                daddslashes($post);
                print_r($post);
                print("\n\n");
               $tid       =   0;           // 对应论坛主题 id
               #$username   =   $i['username'];
               #$itemtypeid   =   $i['dirid'];       // 个人分类ID
               $type       =   'blog';
               $subtype   =   '';           // 信息分类型
               $subject   =   addslashes(convert_utf82gbk($post['title']));
               $dateline   =   $post['pubtime'];
               $lastpost   =   0;
               $viewnum   =   $post['views'];           // 点击次数
               $replynum   =   $post['replies'];
               $trackbacknum   =   $post['tbs'];       // 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 = addslashes(convert_utf82gbk($post['tags']));
               $message = addslashes(convert_utf82gbk($post['content']));
               print_r($includetags);
               print_r($message);
               #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(0);
                   }
               }else {
                   echo mysql_error();
                   exit(1);
               }
        }
}else{
        echo "No posts select !";
}

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-blog2.x 转x-space2.x的简单代码

相关阅读:

关于作者