<?php
//这是转换PE到DEDE3.1 或4.0的程序
//读取mdb数据库例程
set_time_limit(0);
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=". realpath("aaa.mdb");
//打开MDB文件
$conn->Open($connstr);
//打开DEDEV3的数据库
echo "打开DEDE的数据库";
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from PE_Class WHERE ClassID>0 ORDER BY ClassID ASC",$conn,1,1);
$conn2 = mysql_connect("localhost","root","1234") or die("MySQL链接错误!");
mysql_select_db("dedetest",$conn2);
mysql_query("SET NAMES GBK",$conn2);
echo "开始转换分类数据......<br />";
$i=0;
while(! $rs->eof) {
$id = $rs->Fields('ClassID')->value; //分类ID
$reid = $rs->Fields('parentid')->value; //分类父ID
$typename = $rs->Fields('ClassName')->value; //分类
$typedir = '{cmspath}/html'.$rs->Fields('ParentDir')->value.$rs->Fields('ClassDir')->value;//分类所存放的目录
if ($rs->Fields('ChannelID')->value == 1) {
$channeltype = 1;
$tempindex = '{style}/index_article.htm';
$templist = '{style}/list_article.htm';
$temparticle = '{style}/article_article.htm';
}
else if ($rs->Fields('ChannelID')->value == 2) {
$channeltype = 3;
$tempindex = '{style}/index_soft.htm';
$templist = '{style}/list_soft.htm';
$temparticle = '{style}/article_soft.htm';
}
else if ($rs->Fields('ChannelID')->value == 3) {
$channeltype = 2;
$tempindex = '{style}/index_image.htm';
$templist = '{style}/list_image.htm';
$temparticle = '{style}/article_image.htm';
} //分类--图片
//以下是分类所用的默认命名规则
$namerule = '{typedir}/{Y}{M}{D}/{aid}.html';
$namerule2 = '{typedir}/list_{tid}_{page}.html';
$modname = 'default';
$isdefault = '-1';
$sql0 = "select ID from dede_arctype where ID='$id'";
$rs0 = mysql_query($sql0,$conn2);
$row = mysql_fetch_array($rs0);
if(intval($row['ID'])==0){
$sql1 = "insert into dede_arctype (ID,reID,typename,typedir,isdefault,tempindex,templist,temparticle,namerule,namerule2,modname,channeltype) values ('$id','$reid','$typename','$typedir','$isdefault','$tempindex','$templist','$temparticle','$namerule','$namerule2','$modname','$channeltype')";
//$sql1 = "insert into dede_arctype (ID,reID,typename,typedir) values ($id,$reid,$typename,$typedir)";
$rs1 = mysql_query($sql1,$conn2);
if(!$rs1){
echo $sql1;
echo "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
}
$rs->MoveNext();
$i++;
}
$rs->close();
echo "分类完成<br /><hr />";
?>
<?php
echo "开始转换软件....<br />";
$rs->Open("select * from PE_Soft WHERE SoftID>0 ORDER BY SoftID ASC",$conn,1,1);
$i=0;
while(! $rs->eof) {
$id = $rs->Fields('SoftID')->value; //ID
$title = addslashes($rs->Fields('SoftName')->value); //标题
$classid = $rs->Fields('ClassID')->value; //所属的分类ID
$keywordstr = substr($rs->Fields('Keyword')->value,0,59);
$keywordstr = str_replace("|"," ",$keywordstr); //关键字
$keyword = trim($keywordstr);
$datestr = $rs->Fields('UpdateTime')->value; //文章创建时间
$datearr = explode("-",$datestr);
$yy = $datearr[0] ;
$mm = $datearr[1] ;
$dd = rand(1,28);
$time=mktime(0,0,0,$mm,$dd,$yy);
$click = $rs->Fields('Hits')->value; //文章点击数
$memberID = $rs->Fields('Editor')->value; //文章的编辑人员
$litpic = $rs->Fields('SoftPicUrl')->value;
$writer = $rs->Fields('Inputer')->value;
$language = $rs->Fields('SoftLanguage')->value;
$softtype = $rs->Fields('SoftType')->value;
$accredit = $rs->Fields('CopyrightType')->value;
$softsize = $rs->Fields('SoftSize')->value;
$os = $rs->Fields('OperatingSystem')->value;
$introduce = addslashes($rs->Fields('SoftIntro')->value);
$softrank = $rs->Fields('Stars')->value;
$softlinks = "";
$softurl = $rs->Fields('DownloadUrl')->value;
$softurl = split ('下载地址[0-9]+\|',$softurl);
foreach ($softurl as $i => $value) {
$softlinks = $softlinks.'{dede:link text=\'本地下载\'}'.$softurl[$i]."{/dede:link}";
}
$softlinks = str_replace("} {","",$softlinks);
$softlinks = str_replace("{dede:link text='本地下载'}{/dede:link}","",$softlinks);
$softlinks = addslashes($softlinks);
$sql0 = "select ID from dede_archives where ID='$id'";
$rs0 = mysql_query($sql0,$conn2);
$row = mysql_fetch_array($rs0);
if(intval($row['ID'])==0){
$sql1 = "insert into dede_archives (ID,typeid,channel,title,description,sortrank,pubdate,senddate,adminID,keywords,click,litpic,writer,ismake)
values ('$id','$classid',3,'$title','$description','$time','$time','$time',1,'$keyword','$click','$itpic','$writer','-1')";
$rs1 = mysql_query($sql1,$conn2);
if(!$rs1){
echo $sql1;
echo "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
$id2 = mysql_insert_id();
echo $id2;
if($id2>0){
$sql2 = "insert into dede_addonsoft (aid ,typeid, filetype,language,softtype,accredit,os,softrank,officialUrl,officialDemo,softsize,softlinks,introduce )
values('$id','$classid','$filetype','$language','$softtype','$accredit','$os','$softrank','$officialUrl','$officialDemo','$softsize','$softlinks','$introduce');";
$rs2 = mysql_query($sql2,$conn2);
if(!$rs2){
echo $sql2;
echo "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
}
}
$rs->MoveNext();
$i++;
}
$rs->close();
echo "软件转换完成<hr />";
?>
<?php
echo "开始转换文章....<br />";
//$rs = new com("ADODB.RecordSet");
$rs->Open("select * from PE_Article WHERE ArticleID>0 ORDER BY ArticleID ASC",$conn,1,1);
$i=0;
while(! $rs->eof) {
$id = $rs->Fields('ArticleID')->value; //文章ID
$title = addslashes($rs->Fields('Title')->value); //文章标题
$title = str_replace(" "," ",$title);
$classid = $rs->Fields('ClassID')->value; //所属的分类ID
$keywordstr = $rs->Fields('Keyword')->value;
$keywordstr = str_replace("|"," ",$keywordstr); //关键字
$keyword = trim($keywordstr);
$datestr = $rs->Fields('UpdateTime')->value; //文章创建时间
$datearr = explode("-",$datestr);
$yy = $datearr[0] ;
$mm = $datearr[1] ;
$dd = rand(1,28);
$time=mktime(0,0,0,$mm,$dd,$yy);
$content =addslashes($rs->Fields('Content')->value); //文章内容
$content = str_replace('[InstallDir_ChannelDir]{$UploadDir}','/UploadFiles',$content);
$click = $rs->Fields('Hits')->value; //文章点击数
$memberID = $rs->Fields('Editor')->value; //文章的编辑人员
$sql0 = "select ID from dede_archives where ID='$id'";
$rs0 = mysql_query($sql0,$conn2);
$row = mysql_fetch_array($rs0);
//写入到DEDE数据库中
if(intval($row['ID'])==0){
$sql1 = "insert into dede_archives (ID,typeid,channel,title,sortrank,pubdate,senddate,adminID,keywords,click)
values ('$id','$classid',1,'$title','$time','$time','$time',1,'$keyword','$click')";
$rs1 = mysql_query($sql1,$conn2);
if(!$rs1){
echo $sql1;
echo "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
$id2 = mysql_insert_id();
if($id2>0){
$sql2 = "insert into dede_addonarticle (aid ,typeid, body ) values('$id','$classid','$content');";
$rs2 = mysql_query($sql2,$conn2);
if(!$rs2){
echo $sql2;
echo "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
}
}
$rs->MoveN
