作者：FreeDiscuz! Team
日期：2007年2月26日
未经 FreeDiscuz! 允许，本文禁止任何人以任何形式传播和转载，否则一切责任由违反规定者自负！
最新信息：
http://www.freediscuz.net/bbs/viewthread.php?tid=2674
请确保您的论坛是 Discuz! 4.1.0 版本，希望将论坛数据转换至 Discuz! Lite 1.0 RC1 070226。如果您的表前缀不是默认的 cdb_ ，请在执行 SQL 语句前对表前缀进行更改。
请做以下操作前先备份您的数据库，以免升级失败数据损失！！
警告：由于 Discuz! Lite 1.0 RC1 清除了原版的部分功能，通过本转换程序，这部分数据将被彻底清除！！请慎重考虑之后再操作！！
请关闭论坛，给您的论坛数据做全面备份之后，开始以下操作！
若没有进行备份而导致数据损失的，任何未按步骤进行以及人工操作不当因素导致的问题， FreeDiscuz! 不承担任何责任。
第一步
进入论坛后台
系统设置的“数据库升级”，粘贴第一部分SQL语句并执行：
复制内容到剪贴板
代码:
# 水平横排添加
ALTER TABLE cdb_forums ADD `forumcolumns` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
# 置顶选择添加
ALTER TABLE cdb_forums ADD `disableglobalstick` TINYINT(1) NOT NULL DEFAULT '0' AFTER `alloweditrules` ;
# 积分设置添加
INSERT INTO cdb_settings VALUES ('creditstitle', '积分');
INSERT INTO cdb_settings VALUES ('creditsunit', '');
# 提示类型添加
INSERT INTO cdb_settings VALUES ('quickmsg', '0');
# 我的评分添加
ALTER TABLE cdb_ratelog ADD `ratetoid` mediumint(8) unsigned NOT NULL default '0' AFTER `username`;
# 查看隐身会员添加
ALTER TABLE cdb_usergroups ADD `allowviewinvisible` tinyint(1) NOT NULL DEFAULT '0' AFTER `allowinvisible` ;
# 导航栏分类名称添加
INSERT INTO cdb_settings VALUES ('groupnavigation', '1');
# 子版类型调整
UPDATE cdb_forums SET `type` = 'forum' WHERE `type` = 'sub';
# 无限下级修改
ALTER TABLE cdb_forums CHANGE `type` `type` enum('group','forum') NOT NULL default 'forum';
# 权限继承修改
ALTER TABLE cdb_forums DROP `inheritedmod`;
# 帖内评分显示添加
INSERT INTO cdb_settings VALUES ('ratelogrecord', '0');
# ICP备案号添加
INSERT INTO cdb_settings VALUES ('icp', '');
# Discuz! Lite 1.0 RC1 默认风格
DELETE FROM cdb_stylevars WHERE `styleid` = 1;
INSERT INTO cdb_stylevars VALUES('1','1','bgcolor','#DDEAF3');
INSERT INTO cdb_stylevars VALUES('2','1','altbg1','#DDEEF8');
INSERT INTO cdb_stylevars VALUES('3','1','altbg2','#E5F2F9');
INSERT INTO cdb_stylevars VALUES('4','1','link','#0F6489');
INSERT INTO cdb_stylevars VALUES('5','1','bordercolor','#68B9DB');
INSERT INTO cdb_stylevars VALUES('6','1','headercolor','titlebg.gif');
INSERT INTO cdb_stylevars VALUES('7','1','headertext','#07658C');
INSERT INTO cdb_stylevars VALUES('8','1','catcolor','#D4EAF6');
INSERT INTO cdb_stylevars VALUES('9','1','tabletext','#0D5979');
INSERT INTO cdb_stylevars VALUES('10','1','text','#095878');
INSERT INTO cdb_stylevars VALUES('11','1','borderwidth','1');
INSERT INTO cdb_stylevars VALUES('12','1','tablewidth','98%');
INSERT INTO cdb_stylevars VALUES('13','1','tablespace','4');
INSERT INTO cdb_stylevars VALUES('14','1','font','Tahoma, Verdana');
INSERT INTO cdb_stylevars VALUES('15','1','fontsize','9pt');
INSERT INTO cdb_stylevars VALUES('16','1','msgfontsize','9pt');
INSERT INTO cdb_stylevars VALUES('17','1','nobold','0');
INSERT INTO cdb_stylevars VALUES('18','1','boardimg','logo.gif');
INSERT INTO cdb_stylevars VALUES('19','1','imgdir','images/default');
INSERT INTO cdb_stylevars VALUES('20','1','smdir','images/smilies');
INSERT INTO cdb_stylevars VALUES('21','1','cattext','#106C91');
INSERT INTO cdb_stylevars VALUES('22','1','smfontsize','9pt');
INSERT INTO cdb_stylevars VALUES('23','1','smfont','Tahoma, Verdana');
INSERT INTO cdb_stylevars VALUES('24','1','maintablewidth','100%');
INSERT INTO cdb_stylevars VALUES('25','1','maintablecolor','#DDEAF3');
INSERT INTO cdb_stylevars VALUES('26','1','innerborderwidth','1');
INSERT INTO cdb_stylevars VALUES('27','1','innerbordercolor','#A9C9D8');第二步
执行第二部分SQL语句：
复制内容到剪贴板
代码:
# 去掉天下秀
ALTER TABLE cdb_members DROP `avatarshowid`;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowdefault' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowheight' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowlink' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowpos' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowstatus' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'avatarshowwidth' LIMIT 1 ;
# 去掉奇虎搜索
DROP TABLE IF EXISTS cdb_relatedthreads;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_adminemail' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_keywords' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_maxtopics' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_relatedthreads' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_summary' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_searchbox' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_status' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_topics' LIMIT 1 ;
DELETE FROM cdb_settings WHERE `variable` = 'qihoo_validity' LIMIT 1 ;
# 去掉支付宝
ALTER TABLE cdb_memberfields DROP `alipay`;
ALTER TABLE cdb_forums DROP `allowtrade`;
DROP TABLE IF EXISTS cdb_creditslog;
# 清除论坛自带 Blog
DROP TABLE IF EXISTS cdb_blogcaches;
ALTER TABLE cdb_forums DROP `allowblog`;
ALTER TABLE cdb_threads DROP `blog`;
ALTER TABLE cdb_usergroups DROP `allowuseblog`;第三步
执行第三部分SQL语句：
复制内容到剪贴板
代码:
# 原版帖子买卖清除
DROP TABLE IF EXISTS cdb_orders;
DROP TABLE IF EXISTS cdb_paymentlog;
# 新版帖子买卖
ALTER TABLE cdb_forums ADD `allowtosell` tinyint(1) NOT NULL DEFAULT '0' AFTER `allowimgcode`;
ALTER TABLE cdb_usergroups ADD `allowsellpost` tinyint(1) NOT NULL DEFAULT '0' AFTER `allowviewstats` ;
ALTER TABLE cdb_usergroups ADD `allowsellattach` tinyint(1) NOT NULL DEFAULT '0' AFTER `allowsellpost`;
ALTER TABLE cdb_usergroups ADD `sellscope` text NOT NULL AFTER `allowsellattach`;
ALTER TABLE cdb_attachments ADD `sellid` int(10) NOT NULL DEFAULT '0' AFTER `readperm`;
ALTER TABLE cdb_usergroups DROP `maxprice`;
ALTER TABLE cdb_threads DROP `price`;
ALTER TABLE cdb_posts ADD `price` text NOT NULL;第四步
执行第四部分SQL语句
复制内容到剪贴板
代码:
# 在线列表修改
DROP TABLE IF EXISTS cdb_onlinelist;
CREATE TABLE cdb_onlinelist (
id smallint(6) unsigned NOT NULL auto_increment,
title varchar(30) NOT NULL default '',
url varchar(30) NOT NULL default '',
groupids text NOT NULL,
displayorder tinyint(3) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
ALTER TABLE cdb_usergroups ADD `grouporder` tinyint(3) NOT NULL default '0';
ALTER TABLE cdb_sessions ADD `grouporder` tinyint(3) NOT NULL default '0';
INSERT INTO cdb_settings VALUES ('onlineorder', '0');
INSERT INTO cdb_settings VALUES ('onlineascdesc', '0');
INSERT INTO cdb_onlinelist (id, title, url, groupids, displayorder) VALUES ('1', '管理员', 'online_admin.gif', '1', '1');
INSERT INTO cdb_onlinelist (id, title, url, groupids, displayorder) VALUES ('2', '超级版主', 'online_supermod.gif', '2', '2');
INSERT INTO cdb_onlinelist (id, title, url, groupids, displayorder) VALUES ('3', '版主', 'online_moderator.gif', '3', '3');
INSERT INTO cdb_onlinelist (id, title, url, groupids, displayorder) VALUES ('4', '会员', 'online_member.gif', '9 10 11 12 13 14 15', '4');
# 头像签名图片自定义显示
ALTER TABLE `cdb_members` ADD `customshow` TINYINT(1) UNSIGNED NOT NULL DEFAULT '26';
INSERT INTO cdb_settings VALUES ('showsettings', '7');
# 多级自定义管理权限修改
DROP TABLE IF EXISTS cdb_admingroups;
CREATE TABLE cdb_admingroups (
admingid smallint(6) unsigned NOT NULL default '0',
alloweditpost tinyint(1) NOT NULL default '0',
alloweditpoll tinyint(1) NOT NULL default '0',
allowstickthread tinyint(1) NOT NULL default '0',
allowdelpost tinyint(1) NOT NULL default '0',
allowrepair tinyint(1) NOT NULL default '0',
allowviewip tinyint(1) NOT NULL default '0',
allowhighlight tinyint(1) NOT NULL default '0',
allowdigestthread tinyint(1) NOT NULL default '0',
allowclose tinyint(1) NOT NULL default '0',
allowmove tinyint(1) NOT NULL default '0',
allowmerge tinyint(1) NOT NULL default '0',
allowsplit tinyint(1) NOT NULL default '0',
disablepostctrl tinyint(1) NOT NULL default '0',
allowadmincp tinyint(1) NOT NULL default '0',
acpactions text NOT NULL,
PRIMARY KEY (admingid)
) TYPE=MyISAM;
INSERT INTO cdb_admingroups (admingid, alloweditpost, alloweditpoll, allowstickthread, allowdelpost, allowrepair, allowviewip, allowhighlight, allowdigestthread, allowclose, allowmove, allowmerge, allowsplit, disablepostctrl, allowadmincp, acpactions) VALUES (1, 1, 1, 3, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 'a:56:{s:15:"settingsgeneral";i:1;s:16:"settingsregister";i:1;s:14:"settingsstyles";i:1;s:17:"settingsfunctions";i:0;s:16:"settingssecurity";i:0;s:19:"settingspermissions";i:0;s:18:"settingsattachment";i:1;s:11:"settingsseo";i:1;s:12:"settingsmisc";i:1;s:8:"forumadd";i:1;s:10:"forumsedit";i:1;s:11:"forumdelete";i:0;s:11:"forumdetail";i:1;s:10:"moderators";i:1;s:11:"forumsmerge";i:1;s:11:"threadtypes";i:0;s:12:"membergroups";i:1;s:12:"systemgroups";i:1;s:5:"ranks";i:1;s:9:"addmember";i:1;s:7:"members";i:1;s:13:"deletemembers";i:0;s:9:"editgroup";i:1;s:6:"access";i:1;s:13:"memberprofile";i:1;s:16:"memberextcredits";i:0;s:13:"profilefields";i:1;s:5:"ipban";i:1;s:10:"recyclebin";i:1;s:9:"regverify";i:1;s:10:"modthreads";i:1;s:10:"modreplies";i:1;s:11:"discuzcodes";i:1;s:6:"censor";i:1;s:7:"smilies";i:1;s:11:"attachtypes";i:1;s:13:"announcements";i:1;s:12:"medalsstatus";i:1;s:10:"onlinelist";i:1;s:10:"forumlinks";i:1;s:4:"faqs";i:1;s:11:"attachments";i:1;s:7:"threads";i:1;s:5:"prune";i:1;s:7:"pmprune";i:1;s:10:"newsletter";i:1;s:11:"updatecache";i:1;s:7:"counter";i:1;s:9:"fileperms";i:1;s:10:"illegallog";i:1;s:12:"regverifylog";i:1;s:5:"cplog";i:1;s:7:"ratelog";i:1;s:7:"modslog";i:1;s:6:"banlog";i:1;s:7:"plugins";i:1;}');
INSERT INTO cdb_admingroups (admingid, alloweditpost, alloweditpoll, allowstickthread, allowdelpost, allowrepair, allowviewip, allowhighlight, allowdigestthread, allowclose, allowmove, allowmerge, allowsplit, disablepostctrl, allowadmincp, acpactions) VALUES (2, 1, 1, 2, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 'a:13:{s:9:"modmember";i:1;s:7:"banuser";i:1;s:5:"ipban";i:0;s:5:"prune";i:0;s:6:"censor";i:1;s:13:"announcements";i:1;s:9:"regverify";i:0;s:10:"modthreads";i:1;s:10:"modreplies";i:1;s:7:"plugins";i:0;s:7:"ratelog";i:1;s:7:"modslog";i:1;s:6:"banlog";i:1;}');
INSERT INTO cdb_admingroups (admingid, alloweditpost, alloweditpoll, allowstickthread, allowdelpost, allowrepair, allowviewip, allowhighlight, allowdigestthread, allowclose, allowmove, allowmerge, allowsplit, disablepostctrl, allowadmincp, acpactions) VALUES (3, 1, 0, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 'a:13:{s:9:"modmember";i:1;s:7:"banuser";i:1;s:5:"ipban";i:0;s:5:"prune";i:0;s:6:"censor";i:0;s:13:"announcements";i:0;s:9:"regverify";i:0;s:10:"modthreads";i:1;s:10:"modreplies";i:1;s:7:"plugins";i:0;s:7:"ratelog";i:0;s:7:"modslog";i:1;s:6:"banlog";i:1;}');
UPDATE cdb_usergroups SET `radminid` = '0';
# 论坛自带 Blog 相关清除
ALTER TABLE cdb_sessions DROP `bloguid`;
TRUNCATE TABLE cdb_sessions;第五步
上传 Discuz! Lite RC1 070309 标准版所有目录和文件（install目录和install.php除外），用非记事本的编辑程序，打开并配置好 config.inc.php 。
第六步
请使用论坛管理员身份登录论坛，进入后台系统设置，更新缓存，重新设置
管理组管理权限 以及
在线列表 显示。请您修改有关
帖子买卖 的有关设置，调整用户组及论坛版面
Blog文集 的使用权限，修改
论坛版面排序结构 等设置。
如果您有任何问题，欢迎登录 FreeDiscuz! 交流论坛（
www.FreeDiscuz.net）询问或交流。
感谢您选用由 FreeDiscuz! 改进完善的 Discuz! Lite 系列产品，感谢您对 FreeDiscuz! 的支持与厚爱！
