v2->V3重复导入数据的代码(修改自BLT的代码)
v2->V3重复导入数据的代码(修改自BLT的代码)
第一次自己没有导入成功,害的我有看了看sql查询语句,每次导如前,改一下代码中的数值,就可以了.
这个数值取决于你的服务器速度,建议进入phpmyadmin查看,当然,第一次为0,如果第一导800条,那么第二次数值改为800,依次类推.
这个文件只导入数据.
复制内容到剪贴板代码:
<?
require_once(dirname(__FILE__)."/include/config_base.php");
$dsql = new DedeSql(false);
echo "开始导入文章：<br><br>";
$dsql->SetQuery("Select * From dede_art where spec!=-1 and ID>数值");
$dsql->Execute();
$j=0;
//$dsql->SetQuery("delete From #@__archives; ");
//$dsql->ExecuteNoneQuery();
//$dsql->SetQuery("delete From #@__addonarticle; ");
//$dsql->ExecuteNoneQuery();
while($row = $dsql->GetObject())
{
$ID = $row->ID;
$typeid = $row->typeid;
$sendtime = GetMkTime($row->stime);
$click = $row->click;
$redtitle = $row->redtitle;
if($redtitle==1){ $iscommend = 11; $color='red'; }
else{ $iscommend = 0; $color='';}
$title = addslashes($row->title);
$litpic = addslashes($row->picname);
$source = addslashes($row->source);
$writer = addslashes($row->writer);
$body = addslashes($row->body);
$memberID = $row->memberID;
$msg = addslashes($row->msg);
$inQuery = "INSERT INTO #@__archives(
ID,typeid,typeid2,sortrank,iscommend,
ismake,channel,arcrank,click,title,color,writer,source,litpic,
pubdate,senddate,adminID,memberID,description,keywords)
VALUES ('$ID','$typeid','0','$sendtime','$iscommend',
'0','1','0','$click','$title','$color','$writer','$source','',
'$sendtime','$sendtime','1','$memberID','$msg','');";
$dsql->SetQuery($inQuery);
if($dsql->ExecuteNoneQuery($inQuery))
{
$dsql->SetQuery("INSERT INTO #@__addonarticle(aid,typeid,body) Values('$ID','$typeid','$body')");
if(!$dsql->ExecuteNoneQuery()){
$dsql->SetQuery("Delete From #@__archives where ID='$ID'");
$dsql->ExecuteNoneQuery();
}
else{
$j++;
}
}
}
echo "成功导入 $j 篇文章！<br><br>";
$dsql->Close();
?>
完成以后,用这个导入其他数据:
复制内容到剪贴板代码:
<?
require_once(dirname(__FILE__)."/include/config_base.php");
$dsql = new DedeSql(false);
echo "正在导入分类：<br><br>";
$j = 0;
$dsql->SetQuery("Select * From dede_arttype");
$dsql->Execute();
while($row = $dsql->GetObject())
{
$ID = $row->ID;
$reID = $row->reID;
$typename = addslashes($row->typename);
$typedir = addslashes($cfg_arcdir."/".$row->typedir);
$isdefault = $row->isdefault;
$defaultname = addslashes($row->defaultname);
$issend = $row->issend;
$maxpage = $row->maxpage;
$inquery = "
INSERT INTO `#@__arctype`(ID,reID,sortrank,typename,
typedir,isdefault,defaultname,issend,
channeltype,maxpage,ispart,tempindex,templist,
temparticle,tempone,namerule,namerule2,modname,description,keywords)
VALUES ('$ID','$reID','$ID','$typename',
'$typedir','$isdefault','$defaultname','$issend',
'1','$maxpage','0','default/index_{cid}.htm','default/list_{cid}.htm',
'default/article_{cid}.htm','','{Y}/{M}{D}/{aid}.html','list_{page}.html','default','','');
";
$dsql->SetQuery($inquery);
if($dsql->ExecuteNoneQuery())
{
$j++;
}
}
echo "成功导入 $j 个分类！<br><br>";
echo "开始导入评论：<br><br>";
$dsql->SetQuery("Select * From dede_feedback ");
$dsql->Execute();
$j=0;
//ID,artID,userid,username,ip,msg,ischeck,dtime
while($row = $dsql->GetArray())
{
foreach($row as $k=>$v) if(!ereg("[0-9]",$k)) $$k = addslashes($v);
$dtime = GetMkTime($dtime);
$inquery = "
INSERT INTO `#@__feedback`(ID,aid,typeid,username,arctitle,ip,msg,ischeck,dtime)
VALUES('$ID','$artID','0','$username','旧数据导入','$ip','$msg','$ischeck','$dtime');
";
$dsql->SetQuery($inquery);
if($dsql->ExecuteNoneQuery())
{
$j++;
}
}
echo "成功导入 $j 条评论！<br><br>";
echo "开始导入友情链接：<br><br>";
$dsql->SetQuery("Select * From dede_flink ");
$dsql->Execute();
$j=0;
//ID,url,webname,msg,email,logo,dtime,typeid,ischeck
while($row = $dsql->GetArray())
{
foreach($row as $k=>$v) if(!ereg("[0-9]",$k)) $$k = addslashes($v);
$dtime = GetMkTime($dtime);
$inquery = "
INSERT INTO `#@__flink`(ID,sortrank,url,webname,msg,email,logo,dtime,typeid,ischeck)
VALUES ('$ID',sortrank,'$url','$webname','$msg','$email','$logo','$dtime','$typeid','$ischeck');
";
$dsql->SetQuery($inquery);
if($dsql->ExecuteNoneQuery()){
$j++;
}
}
echo "成功导入 $j 个友情链接！<br><br>";
$dsql->Close();
?>
]