dedecms 复制栏目

// 假设源栏目ID为$sourceCatId，目标栏目ID为$targetCatId
$sourceCatId = 1; // 源栏目ID
$targetCatId = 2; // 目标栏目ID

// 调用DedeCMS的复制栏目函数
$success = $dsql->ExecuteNoneQuery("INSERT INTO `dede_arctype` (reid,topid,sortrank,typename,typedir,ismobile,channeltype,relatedlink,infotitle,keyword,description,moresite,siteurl,sitepath,filetype,templist,meta_title,meta_keywords,meta_description,create_to_html,template_list,template_detail,template_edit,template_add,template_file,phpurl_link,ispart,defaultname,namerule2,moresiteflag,sitepathclass,staticurl,staticpath,staticext,needstatic,ishot,click,style,customfield,workflowtype,workflowstate,issystem) SELECT reid,topid,sortrank,typename,typedir,ismobile,channeltype,relatedlink,infotitle,keyword,description,moresite,siteurl,sitepath,filetype,templist,meta_title,meta_keywords,meta_description,create_to_html,template_list,template_detail,template_edit,template_add,template_file,phpurl_link,ispart,defaultname,namerule2,moresiteflag,sitepathclass,staticurl,staticpath,staticext,needstatic,ishot,click,style,customfield,workflowtype,workflowstate,issystem FROM `dede_arctype` WHERE id={$sourceCatId}");

if ($success) {
    // 复制成功，处理相关联的数据表
    $dsql->ExecuteNoneQuery("INSERT INTO `dede_addonarticle` (typeid,redirecturl) SELECT typeid,redirecturl FROM `dede_addonarticle` WHERE typeid={$sourceCatId}");
    // ... 其他相关联的数据表复制操作
    echo "栏目复制成功！";
} else {
    echo "栏目复制失败！";
}