婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

主頁 > 網(wǎng)站建設(shè) > 建站知識 > dede織夢轉(zhuǎn)帝國CMS代碼記錄

dede織夢轉(zhuǎn)帝國CMS代碼記錄

POST TIME:2021-05-23 01:31

1.轉(zhuǎn)換欄目
 
 
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'); //引入數(shù)據(jù)庫配置文件和公共函數(shù)文件
require ('e/class/db_sql.php'); //引入數(shù)據(jù)庫操作文件
$link = db_connect(); //連接MYSQL
$empire = new mysqlquery(); //聲明數(shù)據(jù)庫操作類
 
 
$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(); //關(guān)閉MYSQL鏈接
$empire = null; //注消操作類變量
?>
 
 
3.更新欄目sonclass字段
 
 
<?php
require('e/class/connect.php');        //引入數(shù)據(jù)庫配置文件和公共函數(shù)文件
require('e/class/db_sql.php');        //引入數(shù)據(jù)庫操作文件
$link=db_connect();                //連接MYSQL
$empire=new mysqlquery();        //聲明數(shù)據(jù)庫操作類
 
$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();                        //關(guān)閉MYSQL鏈接
$empire=null;                        //注消操作類變量
?>
 
 
4.更新欄目lastclas字段(dede每個欄目都可添加文章,帝國只有終極欄目才可添加文章)(默認(rèn)把原dede的最后一級轉(zhuǎn)為終極欄目)
 
 
<?php
require('e/class/connect.php');        //引入數(shù)據(jù)庫配置文件和公共函數(shù)文件
require('e/class/db_sql.php');        //引入數(shù)據(jù)庫操作文件
$link=db_connect();                //連接MYSQL
$empire=new mysqlquery();        //聲明數(shù)據(jù)庫操作類
 
    $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();                        //關(guān)閉MYSQL鏈接
$empire=null;                        //注消操作類變量
?>
 
5.轉(zhuǎn)換文章
 
 
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.欄目全部動態(tài)
 
 
update ak_enewsclass set showdt=2 ,listdt=1,nreclass=1,nreinfo=1;

7.帝國后臺更新


收縮
  • 微信客服
  • 微信二維碼
  • 電話咨詢

  • 400-1100-266
主站蜘蛛池模板: 闻喜县| 镇远县| 张家川| 晋宁县| 方山县| 根河市| 绍兴县| 新干县| 阳春市| 宜兰县| 兰州市| 武鸣县| 惠水县| 姜堰市| 工布江达县| 大田县| 霍州市| 偃师市| 高碑店市| 卓尼县| 剑河县| 赫章县| 尉氏县| 新闻| 门源| 尤溪县| 龙川县| 临安市| 本溪| 浠水县| 宣化县| 视频| 宁河县| 万年县| 开远市| 玉山县| 苗栗市| 华容县| 黄山市| 肥城市| 枞阳县|