1.轉換欄目
insert into ak_enewsclass (classid,bclassid,classname,myorder,classpath,intro,classpagekey) select id,reid,typename,sortrank,typedir,description,keywords from dede_arctype;
update phome_enewsclass set tbname='news', modid='1';
update ak_enewsclass set islist=1,listtempid=1,dtlisttempid=1,newstempid=1,classtype='.html',filetype='.html';
2.更新欄目featerclass字段
<?php
require ('e/class/connect.php'); //引入數據庫配置文件和公共函數文件
require ('e/class/db_sql.php'); //引入數據庫操作文件
$link = db_connect(); //連接MYSQL
$empire = new mysqlquery(); //聲明數據庫操作類
$sql = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass");
while($r = $empire ->fetch($sql))
{
$featherclass = '';
if($r['bclassid']){
$featherclass .= '|' .$r['bclassid'];
$sql1 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r[bclassid]");
if($r1 = $empire ->fetch($sql1)){
if($r1['bclassid']){
$featherclass = '|' .$r1['bclassid'] .$featherclass;
$sql2 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r1[bclassid]");
if($r2 = $empire ->fetch($sql2)){
if($r2['bclassid']){
$featherclass = '|' .$r2['bclassid'] .$featherclass;
$sql3 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r2[bclassid]");
if($r3 = $empire ->fetch($sql3)){
if($r3['bclassid']){
$featherclass = '|' .$r3['bclassid'] .$featherclass;
$sql4 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r3[bclassid]");
if($r4 = $empire ->fetch($sql4)){
if($r4['bclassid']){
$featherclass = '|' .$r4['bclassid'] .$featherclass;
$sql5 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r4[bclassid]");
if($r5 = $empire ->fetch($sql5)){
if($r5['bclassid']){
$featherclass = '|' .$r5['bclassid'] .$featherclass;
$sql6 = $empire ->query("select classid,bclassid from {$dbtbpre}enewsclass where classid = $r5[bclassid]");
if($r6 = $empire ->fetch($sql6)){
if($r6['bclassid']){
$featherclass = '|' .$r6['bclassid'] .$featherclass;
}
}
}
}
}
}
}
}
}
}
}
}
$featherclass .= '|';
if($empire ->query("update {$dbtbpre}enewsclass set featherclass = '$featherclass' where classid = $r[classid]")){
echo $r['classid'] .'更新成功<br>';
}else
echo $r['classid'] .'更新失敗~~~~~~~~~<br>';
}
}
db_close(); //關閉MYSQL鏈接
$empire = null; //注消操作類變量
?>
3.更新欄目sonclass字段
<?php
require('e/class/connect.php'); //引入數據庫配置文件和公共函數文件
require('e/class/db_sql.php'); //引入數據庫操作文件
$link=db_connect(); //連接MYSQL
$empire=new mysqlquery(); //聲明數據庫操作類
$sql=$empire->query("select classid,islast from {$dbtbpre}enewsclass");
while($r=$empire->fetch($sql))
{
//echo"欄目ID：".$r['classid'];
if(!$r['islast']){
$sql1=$empire->query("select classid,islast from {$dbtbpre}enewsclass where bclassid = $r[classid]");
$sonclass = '';
while($r1=$empire->fetch($sql1)){
if($r1['islast']) $sonclass = $sonclass.$r1['classid'].'|';
else{
$sql2=$empire->query("select classid,islast from {$dbtbpre}enewsclass where bclassid = $r1[classid]");
while($r2=$empire->fetch($sql2)){
if($r2['islast']) $sonclass =$sonclass.$r2['classid'].'|';
else{
$sql3=$empire->query("select classid,islast from {$dbtbpre}enewsclass where bclassid = $r2[classid]");
while($r3=$empire->fetch($sql3)){
if($r3['islast']) $sonclass =$sonclass.$r3['classid'].'|';
else{
$sql4=$empire->query("select classid,islast from {$dbtbpre}enewsclass where bclassid = $r3[classid]");
while($r4=$empire->fetch($sql4)){
if($r4['islast']) $sonclass =$sonclass.$r4['classid'].'|';
}
}
}
}
}
}
}
//echo "<br>".'子類欄目'.'|'.$sonclass."<br>";
if($sonclass){
$sonclass = '|'.$sonclass;
}else{
}
if($empire->query("update {$dbtbpre}enewsclass set sonclass = '$sonclass' where classid = $r[classid]")){
echo $r['classid'].'更新成功<br>';
}
else echo $r['classid'].'更新失敗~~~~~~~~~<br>';
}
else{
//echo ' --終極欄目'."<br>";
}
}
db_close(); //關閉MYSQL鏈接
$empire=null; //注消操作類變量
?>
4.更新欄目lastclas字段（dede每個欄目都可添加文章，帝國只有終極欄目才可添加文章）（默認把原dede的最后一級轉為終極欄目）
<?php
require('e/class/connect.php'); //引入數據庫配置文件和公共函數文件
require('e/class/db_sql.php'); //引入數據庫操作文件
$link=db_connect(); //連接MYSQL
$empire=new mysqlquery(); //聲明數據庫操作類
$sql=$empire->query("select classid,bclassid from {$dbtbpre}enewsclass");
$end = array();
while($r=$empire->fetch($sql))
{
$sql1=$empire->query("select classid from {$dbtbpre}enewsclass where bclassid = $r[classid]");
if(!$empire->fetch($sql1)){
if($empire->query("update {$dbtbpre}enewsclass set islast=1 where classid = $r[classid]"))
{
echo $r['classid'].'更新成功<br>';
}else echo $r['classid'].'--------------更新失敗<br>';
}
}
db_close(); //關閉MYSQL鏈接
$empire=null; //注消操作類變量
?>
5.轉換文章
insert into ak_ecms_news (id,classid,truetime,onclick,title,titlepic,filename,newstime,lastdotime,smalltext,keyboard) select id,typeid,sortrank,click,title,litpic,filename,pubdate,senddate,description,keywords from dede_archives;
insert into ak_ecms_news_data_1 (id,classid,newstext,newstempid) select aid,typeid,body,1 from dede_addonarticle;
insert into ak_ecms_news_index (id,classid,checked,truetime,newstime,lastdotime) select id,typeid,1,sortrank,pubdate,senddate from dede_archives;
6.欄目全部動態
update ak_enewsclass set showdt=2 ,listdt=1,nreclass=1,nreinfo=1;
7.帝國后臺更新
|
