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字段  <?phprequire ('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字段  <?phprequire('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的最后一級轉為終極欄目）  <?phprequire('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.帝國后臺更新