Dede Turn to Empire

1. Conversion section

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. Update Column Featerclass field

<?phprequire (' e/class/connect.php '); Introduction of database configuration file and common function file require (' e/class/db_sql.php '); Introduction of database operation file $link = Db_connect (); Connection Mysql$empire = new Mysqlquery (); Declare database operation class $sql = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass");    while ($r = $empire->fetch ($sql)) {$featherclass = ';        if ($r [' Bclassid ']) {$featherclass. = ' | '. $r [' Bclassid '];        $sql 1 = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass where classid = $r [Bclassid]"); if ($r 1 = $empire->fetch ($sql 1)) {if ($r 1[' Bclassid ')} {$featherclass = ' | '. $r 1[' Bclassid '].                $featherclass;                $sql 2 = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass where classid = $r 1[bclassid]"); if ($r 2 = $empire->fetch ($sql 2)) {if ($r 2[' Bclassid ']) {$featherclass = '                        | '. $r 2[' Bclassid '). $featherclass; $sql 3 = $empire->query ("Select ClassiD,bclassid from {$dbtbpre}enewsclass where classid = $r 2[bclassid] "); if ($r 3 = $empire->fetch ($sql 3)) {if ($r 3[' Bclassid ']) {$feath                                Erclass = ' | '. $r 3[' Bclassid '). $featherclass;                                $sql 4 = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass where classid = $r 3[bclassid]");                                        if ($r 4 = $empire->fetch ($sql 4)) {if ($r 4[' Bclassid ']) {                                        $featherclass = ' | ' $r 4[' Bclassid ']. $featherclass;                                        $sql 5 = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass where classid = $r 4[bclassid]"); if ($r 5 = $empire->fetch ($sql 5)) {if ($r 5[' BCL Assid ']) {$featherclass = ' | '. $r 5[' Bclassid '). $featHerclass;                                                $sql 6 = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass where classid = $r 5[bclassid]");                                                    if ($r 6 = $empire->fetch ($sql 6)) { if ($r 6[' Bclassid ') {$featherclass = ' | '. $r 6[' Bclassid ']. $feat                                                    Herclass;                                        }                                                }                                            }                        }                                    }                                }                            }        }}}} $featherclass. = ' | ';            if ($empire->query ("Update {$dbtbpre}enewsclass set featherclass = ' $featherclass ' where classid = $r [ClassID]")) { echo $r [' ClassID ']. ' Update successful &LT;BR> '; }else echo $r [' ClassID ']. '    Update failed ~~~~~~~~~<br> '; }}db_close (); Close MySQL link $empire = null; ?> Action class variable

3. Update column Sonclass field

<?phprequire (' e/class/connect.php ');        Introduction of database configuration file and common function file require (' e/class/db_sql.php ');                Introduction of database Operation file $link=db_connect ();        Connection Mysql$empire=new mysqlquery ();       Declares the database operation class $sql= $empire->query ("select Classid,islast from {$dbtbpre}enewsclass");        while ($r = $empire->fetch ($sql)) {//echo "column ID:". $r [' ClassID ']; if (! $r [' islast ']) {$sql 1= $empire->query ("select Classid,islast from {$dbtbpre}enewsclass where Bclassid = $            R[CLASSID] ");            $sonclass = ";                while ($r 1= $empire->fetch ($sql 1)) {if ($r 1[' islast ') $sonclass = $sonclass. $r 1[' ClassID ']. ' | '; else{$sql 2= $empire->query ("select Classid,islast from {$dbtbpre}enewsclass where Bclassid = $                    R1[CLASSID] ");                        while ($r 2= $empire->fetch ($sql 2)) {if ($r 2[' islast ') $sonclass = $sonclass. $r 2[' ClassID ']. ' | '; else{$sql 3=$Empire->query ("Select Classid,islast from {$dbtbpre}enewsclass where bclassid = $r 2[classid]"); while ($r 3= $empire->fetch ($sql 3)) {if ($r 3[' islast ') $sonclass = $sonclass. $r 3[' class                                Id ']. ' | '; else{$sql 4= $empire->query ("select Classid,islast from {$dbtbpre}enewsclass where BC                                    Lassid = $r 3[classid] "); while ($r 4= $empire->fetch ($sql 4)) {if ($r 4[' islast ') $sonclass = $sonclass. $r 4[' cl                                    Assid ']. ' | ';                }                                }                            }                        }                    } }}//echo "<br>". ' Sub-category '. ' | '. $sonclass. " <br>, if ($sonclass) {$sonclass = ' | '. $sonclass;} else{} if ($empire->query ("Update {$dbtbpre}enewsclass set sonclass = ' $sonclass ' where clasSid = $r [ClassID] ") {echo $r [' ClassID ']. '            Update Success <br> '; } else echo $r [' ClassID ']. '        Update failed ~~~~~~~~~<br> '; } else{//echo '--The ultimate column '.        <br> ";                        }}db_close ();                        Close the MySQL link $empire=null; ?> Action class variable

4. Update the Column Lastclas field (dede each column can be added to the article, the Empire only the ultimate column can be added to the article) (by default, the last level of the original Dede to the ultimate column)

<?phprequire (' e/class/connect.php ');        Introduction of database configuration file and common function file require (' e/class/db_sql.php ');        Introduction of database Operation file $link=db_connect ();                Connection Mysql$empire=new mysqlquery ();        Declares the database operation class    $sql = $empire->query ("select Classid,bclassid from {$dbtbpre}enewsclass");            $end = Array ();    while ($r = $empire->fetch ($sql))            {$sql 1= $empire->query ("select ClassID from {$dbtbpre}enewsclass where Bclassid = $r [ClassID] "); if (! $empire->fetch ($sql 1)) {if ($empire->query ("Update {$dbtbpre}enewsclass set islast=1 where classid = $r [ ClassID])            {               echo $r [' ClassID ']. ' Update Success <br> ';                        } else echo $r [' ClassID ']. ' --------------update failed <br> '; }         } db_close ();                        Close the MySQL link $empire=null;                        ?> Action class variable

5. Converting articles

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 to Ak_ecms_news_data_1 (id,classid,newstext,newstempid) Select Aid,typeid, body,1 from Dede_addonarticle;insert  to Ak_ecms_news_index  (Id,classid,checked,truetime,newstime, Lastdotime)  Select  id,typeid,1,sortrank,pubdate,senddate from Dede_archives;

　　

6. Column All News

Update Ak_enewsclass set showdt=2, listdt=1,nreclass=1,nreinfo=1;

7. Empire Background Update

Imperial Data Dictionary: http://www.phome.net/doc/manual/extend/html/dbdoc/index.html

　

Dede Turn to Empire