帝国cms分类栏目删除并且从0开始并且批量修改一些栏目

帝国cms分类栏目删除并且从0开始
/***清空phome_enewsclass表并且classid从0开始****/
DELETE FROM phome_enewsclass;
ALTER TABLE phome_enewsclass AUTO_INCREMENT = 1;
/***清空phome_enewsclass_stats表并且classid从0开始****/
DELETE FROM phome_enewsclass_stats;
ALTER TABLE phome_enewsclass_stats AUTO_INCREMENT = 1;
/***清空phome_enewsclassadd表并且classid从0开始****/
DELETE FROM phome_enewsclassadd;
ALTER TABLE phome_enewsclassadd AUTO_INCREMENT = 1;
帝国cms批量添加栏目    
UPDATE phome_enewsclass set classpath=CONCAT('category-',classid) where bclassid=0;
UPDATE phome_enewsclass set classpath=CONCAT('category-',bclassid,'/','category-',classid) where bclassid!=0;
zblog单页面修改为帝国cms栏目网站公告栏目，其中网站公告栏目classid=90 
查询单页面的数据
SELECT * FROM phome_ecms_news WHERE classid=0;
修改classid的值classid=0修改为classid=90
UPDATE phome_ecms_news set classid=90 where classid=0;
UPDATE phome_ecms_news_data_1 set classid=90 where classid=0;
UPDATE phome_ecms_news_index set classid=90 where classid=0;
精品源码终极栏目classid=1内容调整到php源码classid=14中
查询classid=1数据
SELECT * FROM phome_ecms_news WHERE classid=1;
修改classid的值classid=1修改为classid=14
UPDATE phome_ecms_news set classid=14 where classid=1;
UPDATE phome_ecms_news_data_1 set classid=14 where classid=1;
UPDATE phome_ecms_news_index set classid=14 where classid=1;
商业源码修改classid=3为vip源码classid=4
查询classid=3数据
SELECT * FROM phome_ecms_news WHERE classid=3;
修改classid的值classid=3修改为classid=4
UPDATE phome_ecms_news set classid=4 where classid=3;
UPDATE phome_ecms_news_data_1 set classid=4 where classid=3;
UPDATE phome_ecms_news_index set classid=4 where classid=3;
网站模板5修改为海洋cms模板97，数据少好转移
查询classid=5数据
SELECT * FROM phome_ecms_news WHERE classid=5;
修改classid的值classid=5修改为classid=97
UPDATE phome_ecms_news set classid=97 where classid=5;
UPDATE phome_ecms_news_data_1 set classid=97 where classid=5;
UPDATE phome_ecms_news_index set classid=97 where classid=5;
拓展插件11 修改为宝塔插件70 ，数据少好转移
查询classid=11数据
SELECT * FROM phome_ecms_news WHERE classid=11;
修改classid的值classid=11修改为classid=70
UPDATE phome_ecms_news set classid=70 where classid=11;
UPDATE phome_ecms_news_data_1 set classid=70 where classid=11;
UPDATE phome_ecms_news_index set classid=70 where classid=11;
技术学院12  修改为网络营销13 ，数据少好转移
查询classid=12数据
SELECT * FROM phome_ecms_news WHERE classid=12;
修改classid的值classid=12修改为classid=13
UPDATE phome_ecms_news set classid=13 where classid=12;
UPDATE phome_ecms_news_data_1 set classid=13 where classid=12;
UPDATE phome_ecms_news_index set classid=13 where classid=12;
电脑软件工具24  修改为站长工具49 ，数据少好转移
查询classid=24数据
SELECT * FROM phome_ecms_news WHERE classid=24;
修改classid的值classid=24修改为classid=49
UPDATE phome_ecms_news set classid=49 where classid=24;
UPDATE phome_ecms_news_data_1 set classid=49 where classid=24;
UPDATE phome_ecms_news_index set classid=49 where classid=24;
游戏源码34  修改为端游源码77 ，数据少好转移
查询classid=34数据
SELECT * FROM phome_ecms_news WHERE classid=34;
修改classid的值classid=34修改为classid=77
UPDATE phome_ecms_news set classid=77 where classid=34;
UPDATE phome_ecms_news_data_1 set classid=77 where classid=34;
UPDATE phome_ecms_news_index set classid=77 where classid=34;
电影35 修改为lnmp教程44 ，数据少好转移
查询classid=35数据
SELECT * FROM phome_ecms_news WHERE classid=35;
修改classid的值classid=35修改为classid=44
UPDATE phome_ecms_news set classid=44 where classid=35;
UPDATE phome_ecms_news_data_1 set classid=44 where classid=35;
UPDATE phome_ecms_news_index set classid=44 where classid=35;
商业模板40 修改为lnmp教程44 ，数据少好转移
查询classid=40数据
SELECT * FROM phome_ecms_news WHERE classid=40;
修改classid的值classid=40修改为classid=44
UPDATE phome_ecms_news set classid=44 where classid=40;
UPDATE phome_ecms_news_data_1 set classid=44 where classid=40;
UPDATE phome_ecms_news_index set classid=44 where classid=40;
根栏目lnmp教程44 修改为终极栏目站长工具49 ，数据少好转移
查询classid=44数据
SELECT * FROM phome_ecms_news WHERE classid=44;
修改classid的值classid=44修改为classid=49
UPDATE phome_ecms_news set classid=49 where classid=44;
UPDATE phome_ecms_news_data_1 set classid=49 where classid=44;
UPDATE phome_ecms_news_index set classid=49 where classid=44;