又是s的草稿，留底用，LazyCMS2smf
建立空表
lazy_archives.id as id
lazy_archives.sotid as sortid
lazy_archives.order as order id和order的区别是什么 有11个不同的。
lazy_archives.title as title
lazy_archives.show as show
lazy_archives.date as date
lazy_archives.hits as hits
lazy_archives_model_article.aid ?
lazy_archives_model_article.author as author
lazy_archives_model_article.content as content
(从1开始的）
lazy_archives_model_news.aid order吗
lazy_archives_model_news.author as author
lazy_archives_model_news.content as content
（从854开始的）
lazy_archives_model_soft.aid as
lazy_archives_model_soft.from
lazy_archives_model_soft.author
lazy_archives_model_soft.softsize
lazy_archives_model_soft.softlinks
lazy_archives_model_soft.content
(从882开始的，只有35个）
lazy_archives_sort.sortid 没重复的
lazy_archives_sort.sortid1 这是什么 貌似sortid1是个大类，只用了1 6 10 13四个值
lazy_archives_sort.modelid 只有三行
lazy_archives_sort.sortorder 貌似没用
lazy_archives_sort.sorttname as sortname
lazy_archives_sort
==============
sortid sortname
1 新闻
2 网站公告
3 关卡新闻
4 最新关卡
5 关卡预览
6 文章
7 关卡攻略
8 制作教程
9 玩家文章
10 经典关卡
11 2006经典
12 2007经典
13 下载
14 NGLE相关
15 TRLE相关
16 PLAY相关
24 最新关卡
===================
modelid modelname
1 文章模型
4 软件下载
5 新闻模型
==========================
////////插入文章内容等信息//////////
UPDATE `smf_lazycms`,`lazy_archives_model_article`
(影响了865行，但是`lazy_archives_model_article`表只有864行？）
UPDATE `smf_lazycms`,`lazy_archives_model_news`
(影响了136行，但是`lazy_archives_model_news`表只有135行？）
UPDATE `smf_lazycms`,`lazy_archives_model_soft`
(影响了34行，但是`lazy_archives_model_soft`表有35行？）
############## 正式开始 ##############
///////// 1. 建立空表 smf_lazycms /////////////用于向smf_messages输出数据
DROP TABLE IF EXISTS `smf_lazycms`;
CREATE TABLE `smf_lazycms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sortid` int(11) DEFAULT ‘0’,
`sortid1` int(11) DEFAULT ‘0’,
`sortname` varchar(50) NOT NULL,
`modelid` int(11) DEFAULT ‘0’,
`modelname` varchar(50) NOT NULL,
`order` int(11) DEFAULT ‘0’,
`title` varchar(120) NOT NULL,
`author` varchar(50) DEFAULT NULL,
`id_member` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`content` mediumtext,
`show` tinyint(1) DEFAULT ‘1’,
`date` int(11) NOT NULL,
`hits` int(11) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
//////// 2. 向smf_lazycms插入lazy各表信息 /////////////////
/// 2.1 lazy_archives （文章id，分类id，标题，发布时间等信息）
INSERT INTO `smf_lazycms`
SELECT
a.id, a.sortid, NULL,NULL,NULL,NULL,a.order, a.title,NULL,NULL,NULL,a.show,a.date,a.hits AS hits
FROM `lazy_archives` AS a;
/// 2.2 lazy_archives_sort (sort 名称等）
UPDATE `smf_lazycms`,`lazy_archives_sort`
SET `smf_lazycms`.sortid1 = `lazy_archives_sort`.sortid1,
`smf_lazycms`.sortname = `lazy_archives_sort`.sortname,
`smf_lazycms`.modelid = `lazy_archives_sort`.modelid
WHERE `smf_lazycms`.sortid = `lazy_archives_sort`.sortid;
/// 2.3 lazy_archives_model （model）
UPDATE `smf_lazycms`,`lazy_archives_model`
SET `smf_lazycms`.modelname = `lazy_archives_model`.modelname
WHERE `smf_lazycms`.modelid = `lazy_archives_model`.modelid;
/// 2.4 lazy_archives_model_article （文章）
UPDATE `smf_lazycms`,`lazy_archives_model_article`
SET `smf_lazycms`.author = `lazy_archives_model_article`.author,
`smf_lazycms`.content = `lazy_archives_model_article`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_article`.aid;
/// 2.5 lazy_archives_model_news （新闻）
UPDATE `smf_lazycms`,`lazy_archives_model_news`
SET `smf_lazycms`.author = `lazy_archives_model_news`.author,
`smf_lazycms`.content = `lazy_archives_model_news`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_news`.aid;
/// 2.6 lazy_archives_model_soft （软件）
UPDATE `smf_lazycms`,`lazy_archives_model_soft`
SET `smf_lazycms`.author = `lazy_archives_model_soft`.author,
`smf_lazycms`.content = `lazy_archives_model_soft`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_soft`.aid;
/////////// 3. 将smf_lazycms从max的空间导出，然后导入ply的空间//////
注意编码。
/////////// 4. 整理smf_lazycms中文章id和分类id ////////////////////
// 4.1 先查找lazycms中id重复的值（居然会有重复的，唉）
?????SELECT * `smf_lazycms` ????
?????WHERE id IN (SELECT id FROM `smf_lazycms` GROUP BY id HAVING COUNT(*)>1) ????
?????ORDER BY id ????
SELECT id FROM `smf_lazycms` GROUP BY id HAVING COUNT(id) >1;结果是854
把 其中一个 改成最大的+1(不用语句改）：SELECT MAX( id ) FROM `smf_lazycms`; 1047
SELECT id FROM `smf_lazycms` WHERE id =854;
// 4.2 增大帖子id 主题id
gmly现在帖子数的最大值 SELECT MAX(id_msg) FROM smf_messages
gmly现在主题数的最大值 SELECT MAX(id_topic) FROM smf_topics
搞不清楚lazycms中的order作用，把它改成smf的id_topic吧
UPDATE `smf_lazycms` SET `smf_lazycms`.order = `smf_lazycms`.id + [gmly现在 主题数 的最大值];
UPDATE `smf_lazycms` SET id = id + [gmly现在 帖子数 的最大值];
// 4.3 更改板块分类 用sortid 改还是用 sortid1
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 1;
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 2;
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 3;
…………………参照TC给的id………………
/////////// 5. 向smf_messages输入数据 ////////////////////
！！！！先备份smf_messages ！！！！
！！！！先备份smf_topics ！！！！
id_member用谁的 ？1668是max的 还是用0
INSERT INTO `smf_messages`
SELECT
id,`smf_lazycms`.order,sortid( sortid1 ？),`smf_lazycms`.date,0,id,title,author,"astronomermax@163.com",
0,1,0,"",content,"xx",0,0,`smf_lazycms`.show
FROM `smf_lazycms`;
INSERT INTO `smf_topics`
SELECT
`smf_lazycms`.order, 0, sortid( sortid1 ？),id,id,0,0,0,0,0,0,hits,0 AS locked,0,1
FROM `smf_lazycms`;
完
lazy_archives.id as id
lazy_archives.sotid as sortid
lazy_archives.order as order id和order的区别是什么 有11个不同的。
lazy_archives.title as title
lazy_archives.show as show
lazy_archives.date as date
lazy_archives.hits as hits
lazy_archives_model_article.aid ?
lazy_archives_model_article.author as author
lazy_archives_model_article.content as content
(从1开始的）
lazy_archives_model_news.aid order吗
lazy_archives_model_news.author as author
lazy_archives_model_news.content as content
（从854开始的）
lazy_archives_model_soft.aid as
lazy_archives_model_soft.from
lazy_archives_model_soft.author
lazy_archives_model_soft.softsize
lazy_archives_model_soft.softlinks
lazy_archives_model_soft.content
(从882开始的，只有35个）
lazy_archives_sort.sortid 没重复的
lazy_archives_sort.sortid1 这是什么 貌似sortid1是个大类，只用了1 6 10 13四个值
lazy_archives_sort.modelid 只有三行
lazy_archives_sort.sortorder 貌似没用
lazy_archives_sort.sorttname as sortname
lazy_archives_sort
==============
sortid sortname
1 新闻
2 网站公告
3 关卡新闻
4 最新关卡
5 关卡预览
6 文章
7 关卡攻略
8 制作教程
9 玩家文章
10 经典关卡
11 2006经典
12 2007经典
13 下载
14 NGLE相关
15 TRLE相关
16 PLAY相关
24 最新关卡
===================
modelid modelname
1 文章模型
4 软件下载
5 新闻模型
==========================
////////插入文章内容等信息//////////
UPDATE `smf_lazycms`,`lazy_archives_model_article`
(影响了865行，但是`lazy_archives_model_article`表只有864行？）
UPDATE `smf_lazycms`,`lazy_archives_model_news`
(影响了136行，但是`lazy_archives_model_news`表只有135行？）
UPDATE `smf_lazycms`,`lazy_archives_model_soft`
(影响了34行，但是`lazy_archives_model_soft`表有35行？）
############## 正式开始 ##############
///////// 1. 建立空表 smf_lazycms /////////////用于向smf_messages输出数据
DROP TABLE IF EXISTS `smf_lazycms`;
CREATE TABLE `smf_lazycms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sortid` int(11) DEFAULT ‘0’,
`sortid1` int(11) DEFAULT ‘0’,
`sortname` varchar(50) NOT NULL,
`modelid` int(11) DEFAULT ‘0’,
`modelname` varchar(50) NOT NULL,
`order` int(11) DEFAULT ‘0’,
`title` varchar(120) NOT NULL,
`author` varchar(50) DEFAULT NULL,
`id_member` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`content` mediumtext,
`show` tinyint(1) DEFAULT ‘1’,
`date` int(11) NOT NULL,
`hits` int(11) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
//////// 2. 向smf_lazycms插入lazy各表信息 /////////////////
/// 2.1 lazy_archives （文章id，分类id，标题，发布时间等信息）
INSERT INTO `smf_lazycms`
SELECT
a.id, a.sortid, NULL,NULL,NULL,NULL,a.order, a.title,NULL,NULL,NULL,a.show,a.date,a.hits AS hits
FROM `lazy_archives` AS a;
/// 2.2 lazy_archives_sort (sort 名称等）
UPDATE `smf_lazycms`,`lazy_archives_sort`
SET `smf_lazycms`.sortid1 = `lazy_archives_sort`.sortid1,
`smf_lazycms`.sortname = `lazy_archives_sort`.sortname,
`smf_lazycms`.modelid = `lazy_archives_sort`.modelid
WHERE `smf_lazycms`.sortid = `lazy_archives_sort`.sortid;
/// 2.3 lazy_archives_model （model）
UPDATE `smf_lazycms`,`lazy_archives_model`
SET `smf_lazycms`.modelname = `lazy_archives_model`.modelname
WHERE `smf_lazycms`.modelid = `lazy_archives_model`.modelid;
/// 2.4 lazy_archives_model_article （文章）
UPDATE `smf_lazycms`,`lazy_archives_model_article`
SET `smf_lazycms`.author = `lazy_archives_model_article`.author,
`smf_lazycms`.content = `lazy_archives_model_article`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_article`.aid;
/// 2.5 lazy_archives_model_news （新闻）
UPDATE `smf_lazycms`,`lazy_archives_model_news`
SET `smf_lazycms`.author = `lazy_archives_model_news`.author,
`smf_lazycms`.content = `lazy_archives_model_news`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_news`.aid;
/// 2.6 lazy_archives_model_soft （软件）
UPDATE `smf_lazycms`,`lazy_archives_model_soft`
SET `smf_lazycms`.author = `lazy_archives_model_soft`.author,
`smf_lazycms`.content = `lazy_archives_model_soft`.content
WHERE `smf_lazycms`.id = `lazy_archives_model_soft`.aid;
/////////// 3. 将smf_lazycms从max的空间导出，然后导入ply的空间//////
注意编码。
/////////// 4. 整理smf_lazycms中文章id和分类id ////////////////////
// 4.1 先查找lazycms中id重复的值（居然会有重复的，唉）
?????SELECT * `smf_lazycms` ????
?????WHERE id IN (SELECT id FROM `smf_lazycms` GROUP BY id HAVING COUNT(*)>1) ????
?????ORDER BY id ????
SELECT id FROM `smf_lazycms` GROUP BY id HAVING COUNT(id) >1;结果是854
把 其中一个 改成最大的+1(不用语句改）：SELECT MAX( id ) FROM `smf_lazycms`; 1047
SELECT id FROM `smf_lazycms` WHERE id =854;
// 4.2 增大帖子id 主题id
gmly现在帖子数的最大值 SELECT MAX(id_msg) FROM smf_messages
gmly现在主题数的最大值 SELECT MAX(id_topic) FROM smf_topics
搞不清楚lazycms中的order作用，把它改成smf的id_topic吧
UPDATE `smf_lazycms` SET `smf_lazycms`.order = `smf_lazycms`.id + [gmly现在 主题数 的最大值];
UPDATE `smf_lazycms` SET id = id + [gmly现在 帖子数 的最大值];
// 4.3 更改板块分类 用sortid 改还是用 sortid1
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 1;
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 2;
UPDATE `smf_lazycms` SET sortid( OR sortid1) = ??(gmly中对应id) WHERE sortid( 或 sortid1) = 3;
…………………参照TC给的id………………
/////////// 5. 向smf_messages输入数据 ////////////////////
！！！！先备份smf_messages ！！！！
！！！！先备份smf_topics ！！！！
id_member用谁的 ？1668是max的 还是用0
INSERT INTO `smf_messages`
SELECT
id,`smf_lazycms`.order,sortid( sortid1 ？),`smf_lazycms`.date,0,id,title,author,"astronomermax@163.com",
0,1,0,"",content,"xx",0,0,`smf_lazycms`.show
FROM `smf_lazycms`;
INSERT INTO `smf_topics`
SELECT
`smf_lazycms`.order, 0, sortid( sortid1 ？),id,id,0,0,0,0,0,0,hits,0 AS locked,0,1
FROM `smf_lazycms`;
完
