📄 upgrade9.php
字号:
<?php
// Upgrade Discuz! Board from 5.5.0 to 6.0.0 Final
error_reporting(E_ERROR | E_WARNING | E_PARSE);
@set_magic_quotes_runtime(0);
@set_time_limit(1000);
define('IN_DISCUZ', TRUE);
define('DISCUZ_ROOT', './');
$version_old = 'Discuz! 5.5.0';
$version_new = 'Discuz! 6.0.0 正式版';
$timestamp = time();
@include(DISCUZ_ROOT."./config.inc.php");
@include(DISCUZ_ROOT."./include/db_mysql.class.php");
header("Content-Type: text/html; charset=$charset");
showheader();
if(empty($dbcharset) && in_array(strtolower($charset), array('gbk', 'big5', 'utf-8'))) {
$dbcharset = str_replace('-', '', $charset);
}
if(PHP_VERSION < '4.1.0') {
$_GET = &$HTTP_GET_VARS;
$_POST = &$HTTP_POST_VARS;
$_COOKIE = &$HTTP_COOKIE_VARS;
$_SERVER = &$HTTP_SERVER_VARS;
$_ENV = &$HTTP_ENV_VARS;
$_FILES = &$HTTP_POST_FILES;
}
$action = ($_POST['action']) ? $_POST['action'] : $_GET['action'];
$step = $_GET['step'];
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$upgrade1 = <<<EOT
REPLACE INTO cdb_settings (variable, value) VALUES ('tagstatus', 1);
REPLACE INTO cdb_settings (variable, value) VALUES ('hottags', 20);
REPLACE INTO cdb_settings (variable, value) VALUES ('viewthreadtags', 100);
UPDATE cdb_settings SET value=value*12 WHERE variable='maxsigrows';
REPLACE INTO cdb_settings (variable, value) VALUES ('mail', 'a:10:{s:8:"mailsend";s:1:"1";s:6:"server";s:13:"smtp.21cn.com";s:4:"port";s:2:"25";s:4:"auth";s:1:"1";s:4:"from";s:26:"Discuz <username@21cn.com>";s:13:"auth_username";s:17:"username@21cn.com";s:13:"auth_password";s:8:"password";s:13:"maildelimiter";s:1:"0";s:12:"mailusername";s:1:"1";s:15:"sendmail_silent";s:1:"1";}');
REPLACE INTO cdb_settings (variable, value) VALUES ('watermarktext', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('watermarkminwidth', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('watermarkminheight', '0');
DELETE FROM cdb_settings WHERE variable='ec_id';
DELETE FROM cdb_settings WHERE variable='ec_securitycode';
DELETE FROM cdb_settings WHERE variable='ec_commision';
REPLACE INTO cdb_settings (variable, value) VALUES ('inviteconfig', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('rewritecompatible', '');
REPLACE INTO cdb_settings (variable, value) values ('userdateformat','Y-n-j\r\nY/n/j\r\nj-n-Y\r\nj/n/Y');
REPLACE INTO cdb_settings (variable, value) VALUES ('regname', 'register.php');
REPLACE INTO cdb_settings (variable, value) VALUES ('reglinkname', '注册');
REPLACE INTO cdb_settings (variable, value) VALUES ('activitytype', '朋友聚会\n出外郊游\n自驾出行\n公益活动\n线上活动');
REPLACE INTO cdb_settings (variable, value) VALUES ('tradeimagewidth', 200);
REPLACE INTO cdb_settings (variable, value) VALUES ('tradeimageheight', 150);
REPLACE INTO cdb_settings (variable, value) VALUES ('customauthorinfo', 'a:1:{i:0;a:9:{s:3:\"uid\";a:1:{s:4:\"menu\";s:1:\"1\";}s:5:\"posts\";a:1:{s:4:\"menu\";s:1:\"1\";}s:6:\"digest\";a:1:{s:4:\"menu\";s:1:\"1\";}s:7:\"credits\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"readperm\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"location\";a:1:{s:4:\"menu\";s:1:\"1\";}s:6:\"oltime\";a:1:{s:4:\"menu\";s:1:\"1\";}s:7:\"regtime\";a:1:{s:4:\"menu\";s:1:\"1\";}s:8:\"lastdate\";a:1:{s:4:\"menu\";s:1:\"1\";}}}');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_credit', 'a:2:{s:18:"maxcreditspermonth";i:6;s:4:"rank";a:15:{i:1;i:4;i:2;i:11;i:3;i:41;i:4;i:91;i:5;i:151;i:6;i:251;i:7;i:501;i:8;i:1001;i:9;i:2001;i:10;i:5001;i:11;i:10001;i:12;i:20001;i:13;i:50001;i:14;i:100001;i:15;i:200001;}}');
REPLACE INTO cdb_settings (variable, value) VALUES ('imagelib', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('imageimpath', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('historyposts', '0 0');
REPLACE INTO cdb_settings (variable, value) VALUES ('zoomstatus', '1');
REPLACE INTO cdb_settings (variable, value) VALUES ('postno', '#');
REPLACE INTO cdb_settings (variable, value) VALUES ('postnocustom', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('maxbiotradesize', '400');
REPLACE INTO cdb_settings (variable, value) VALUES ('tradetypes', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('baidusitemap', '1');
REPLACE INTO cdb_settings (variable, value) VALUES ('baidusitemap_life', '12');
REPLACE INTO cdb_settings (variable, value) VALUES ('google', '');
DELETE FROM cdb_crons WHERE filename='pushthreads_weekly.inc.php';
EOT;
$upgradetable = array(
array('forums', 'ADD', 'allowmediacode', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('forums', 'MODIFY', 'allowpostspecial', "TINYINT(1) NOT NULL DEFAULT '63'"),
array('forums', 'MODIFY', 'allowpostspecial', "SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0'"),
array('forumfields', 'ADD', 'keywords', "TEXT NOT NULL AFTER postattachperm"),
array('forumfields', 'ADD', 'formulaperm', "TEXT NOT NULL"),
array('forumfields', 'ADD', 'modrecommend', "TEXT NOT NULL"),
array('forumfields', 'ADD', 'tradetypes', "TEXT NOT NULL"),
array('forumfields', 'ADD', 'typemodels', "MEDIUMTEXT NOT NULL"),
array('myposts', 'ADD', 'special', "TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'"),
array('mythreads', 'ADD', 'special', "TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'"),
array('threadtypes', 'ADD', 'special', "SMALLINT(6) NOT NULL default '0'"),
array('threadtypes', 'ADD', 'template', "TEXT NOT NULL"),
array('smilies', 'CHANGE', 'displayorder', "displayorder TINYINT( 3 ) NOT NULL DEFAULT '0'"),
array('smilies', 'ADD', 'typeid', "SMALLINT( 6 ) UNSIGNED NOT NULL AFTER id"),
array('usergroups', 'ADD', 'allowpostdebate', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'tradestick', "TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'allowinvite', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'allowmailinvite', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'maxinvitenum', "TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'maxinviteday', "SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'inviteprice', "SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0'"),
array('usergroups', 'ADD', 'allowpostvideo', "TINYINT (1) DEFAULT '0' NOT NULL AFTER allowpostactivity"),
array('usergroups', 'DROP', 'tradetaxtype', ""),
array('usergroups', 'DROP', 'tradetaxs', ""),
array('trades', 'ADD', 'pid', "INT(10) UNSIGNED NOT NULL AFTER tid"),
array('trades', 'ADD', 'typeid', "SMALLINT(6) UNSIGNED NOT NULL AFTER pid"),
array('trades', 'ADD', 'aid', "MEDIUMINT(8) UNSIGNED NOT NULL"),
array('trades', 'ADD', 'displayorder', " TINYINT(1) NOT NULL"),
array('trades', 'ADD', 'costprice', "DECIMAL(8,2) NOT NULL"),
array('trades', 'MODIFY', 'price', "DECIMAL(8,2) NOT NULL"),
array('trades', 'INDEX', '', "DROP PRIMARY KEY"),
array('trades', 'INDEX', '', "ADD PRIMARY KEY (tid, pid)"),
array('trades', 'INDEX', '', "ADD INDEX displayorder (tid, displayorder)"),
array('trades', 'INDEX', '', "ADD INDEX sellertrades (sellerid, tradesum, totalitems)"),
array('trades', 'INDEX', '', "ADD INDEX typeid (typeid)"),
array('tradelog', 'ADD', 'pid', "INT(10) UNSIGNED NOT NULL AFTER tid"),
array('tradelog', 'ADD', 'offline', "TINYINT(1) NOT NULL default '0'"),
array('tradelog', 'ADD', 'buyername', "CHAR(50) NOT NULL"),
array('tradelog', 'ADD', 'buyerzip', "CHAR(10) NOT NULL"),
array('tradelog', 'ADD', 'buyerphone', "CHAR(20) NOT NULL"),
array('tradelog', 'ADD', 'buyermobile', "CHAR(20) NOT NULL"),
array('tradelog', 'ADD', 'transport', "TINYINT(1) NOT NULL default '0'"),
array('tradelog', 'ADD', 'transportfee', "smallint(6) unsigned NOT NULL"),
array('tradelog', 'ADD', 'baseprice', "decimal(8,2) NOT NULL"),
array('tradelog', 'ADD', 'discount', "TINYINT(1) NOT NULL default '0'"),
array('tradelog', 'ADD', 'ratestatus', "TINYINT(1) NOT NULL default '0'"),
array('tradelog', 'MODIFY', 'price', "DECIMAL(8,2) NOT NULL"),
array('tradelog', 'INDEX', '', "DROP INDEX tid"),
array('tradelog', 'INDEX', '', "ADD INDEX tid (tid, pid)"),
array('tradelog', 'INDEX', '', "ADD INDEX pid (pid)"),
array('memberfields', 'ADD', 'buyercredit', "SMALLINT( 6 ) NOT NULL default '0'"),
array('memberfields', 'ADD', 'sellercredit', "SMALLINT( 6 ) NOT NULL default '0'"),
array('profilefields', 'INDEX', '', "ADD INDEX available (available,required,displayorder)"),
array('posts', 'ADD', 'status', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('admingroups', 'ADD', 'allowbanpost', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('members', 'MODIFY', 'extgroupids', "char (20) NOT NULL DEFAULT ''"),
array('members', 'MODIFY', 'email', "char (40) NOT NULL DEFAULT ''"),
array('members', 'MODIFY', 'dateformat', "TINYINT(1) NOT NULL DEFAULT '0'"),
array('members', 'INDEX', '', "ADD INDEX groupid (groupid)"),
array('promotions', 'CHANGE', 'uid', "uid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0'"),
array('relatedthreads', 'ADD', 'type', "ENUM( 'general', 'trade' ) NOT NULL DEFAULT 'general' AFTER tid"),
array('relatedthreads', 'INDEX', '', "DROP PRIMARY KEY , ADD PRIMARY KEY ( tid , type )"),
array('threadtypes', 'ADD', 'modelid', "SMALLINT( 6 ) UNSIGNED NOT NULL DEFAULT '0' DEFAULT '0' AFTER `special`"),
array('threadtypes', 'ADD', 'expiration', "TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER modelid"),
array('tradelog', 'MODIFY', 'orderid', "varchar(32) NOT NULL"),
array('tradelog', 'MODIFY', 'tradeno', "varchar(32) NOT NULL"),
array('tradelog', 'MODIFY', 'subject', "varchar(100) NOT NULL"),
array('tradelog', 'MODIFY', 'locus', "varchar(100) NOT NULL"),
array('tradelog', 'MODIFY', 'seller', "varchar(15) NOT NULL"),
array('tradelog', 'MODIFY', 'selleraccount', "varchar(50) NOT NULL"),
array('tradelog', 'MODIFY', 'buyer', "varchar(15) NOT NULL"),
array('tradelog', 'MODIFY', 'buyercontact', "varchar(50) NOT NULL"),
array('tradelog', 'MODIFY', 'buyermsg', "varchar(200) default NULL"),
array('tradelog', 'MODIFY', 'buyername', "varchar(50) NOT NULL"),
array('tradelog', 'MODIFY', 'buyerzip', " varchar(10) NOT NULL"),
array('tradelog', 'MODIFY', 'buyerphone', "varchar(20) NOT NULL"),
array('tradelog', 'MODIFY', 'buyermobile', "varchar(20) NOT NULL"),
array('tradelog', 'ADD', 'message', "text NOT NULL"),
array('tradelog', 'MODIFY', 'transportfee', "smallint(6) unsigned NOT NULL DEFAULT '0'"),
);
$upgrade3 = <<<EOT
DROP TABLE IF EXISTS cdb_blogcaches;
DROP TABLE IF EXISTS cdb_imagetypes;
CREATE TABLE cdb_imagetypes (
typeid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`type` enum('smiley','icon','avatar') NOT NULL DEFAULT 'smiley',
displayorder tinyint(3) NOT NULL DEFAULT '0',
`directory` char(100) NOT NULL,
PRIMARY KEY (typeid)
) TYPE=MyISAM;
INSERT INTO cdb_imagetypes VALUES ('1','默认表情','smiley','1','default');
UPDATE cdb_smilies SET typeid=1 WHERE type='smiley';
DROP TABLE IF EXISTS cdb_threadtags;
CREATE TABLE cdb_threadtags (
`tagname` char(20) NOT NULL,
`tid` int(10) unsigned NOT NULL,
KEY `tagname` (`tagname`),
KEY `tid` (`tid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_tags;
CREATE TABLE cdb_tags (
`tagname` char(20) NOT NULL,
`closed` tinyint(1) NOT NULL DEFAULT '0',
`total` mediumint(8) unsigned NOT NULL,
PRIMARY KEY (`tagname`),
KEY `total` (`total`),
KEY `closed` (`closed`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_debates;
CREATE TABLE cdb_debates (
tid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
uid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
starttime INT(10) UNSIGNED NOT NULL DEFAULT '0',
endtime INT(10) UNSIGNED NOT NULL DEFAULT '0',
affirmdebaters MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
negadebaters MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
affirmvotes MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
negavotes MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
umpire VARCHAR(15) NOT NULL DEFAULT '',
winner TINYINT(1) NOT NULL DEFAULT '0',
bestdebater VARCHAR(50) NOT NULL DEFAULT '',
affirmpoint TEXT NOT NULL,
negapoint TEXT NOT NULL,
umpirepoint TEXT NOT NULL,
affirmvoterids TEXT NOT NULL,
negavoterids TEXT NOT NULL,
affirmreplies MEDIUMINT(8) UNSIGNED NOT NULL,
negareplies MEDIUMINT(8) UNSIGNED NOT NULL,
PRIMARY KEY (tid),
KEY uid (uid,starttime)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_debateposts;
CREATE TABLE cdb_debateposts (
pid INT(10) UNSIGNED NOT NULL DEFAULT '0',
stand TINYINT(1) NOT NULL DEFAULT '0',
tid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
uid MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
dateline INT(10) UNSIGNED NOT NULL DEFAULT '0',
voters MEDIUMINT(10) UNSIGNED NOT NULL DEFAULT '0',
voterids TEXT NOT NULL ,
PRIMARY KEY (pid),
KEY pid (pid,stand),
KEY tid (tid,uid)
) TYPE=MyISAM;
DROP TABLE IF EXISTS cdb_typeoptions;
CREATE TABLE cdb_typeoptions (
optionid smallint(6) unsigned NOT NULL auto_increment,
classid smallint(6) unsigned NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
title varchar(100) NOT NULL ,
description varchar(255) NOT NULL,
identifier varchar(40) NOT NULL,
`type` varchar(20) NOT NULL,
rules mediumtext NOT NULL,
PRIMARY KEY (optionid),
KEY classid (classid)
) TYPE=MyISAM;
INSERT INTO cdb_typeoptions VALUES (1, 0, 0, '通用类', '', '', '', '');
INSERT INTO cdb_typeoptions VALUES (2, 0, 0, '房产类', '', '', '', '');
INSERT INTO cdb_typeoptions VALUES (3, 0, 0, '交友类', '', '', '', '');
INSERT INTO cdb_typeoptions VALUES (4, 0, 0, '求职招聘类', '', '', '', '');
INSERT INTO cdb_typeoptions VALUES (5, 0, 0, '交易类', '', '', '', '');
INSERT INTO cdb_typeoptions VALUES (6, 0, 0, '互联网类', '', '', '', '');
REPLACE INTO cdb_typeoptions VALUES (7, 1, 0, '姓名', '', 'name', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (9, 1, 0, '年龄', '', 'age', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (10, 1, 0, '地址', '', 'address', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (11, 1, 0, 'QQ', '', 'qq', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (12, 1, 0, '邮箱', '', 'mail', 'email', '');
REPLACE INTO cdb_typeoptions VALUES (13, 1, 0, '电话', '', 'phone', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (14, 5, 0, '培训费用', '', 'teach_pay', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (15, 5, 0, '培训时间', '', 'teach_time', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (20, 2, 0, '楼层', '', 'floor', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (21, 2, 0, '交通状况', '', 'traf', 'textarea', '');
REPLACE INTO cdb_typeoptions VALUES (22, 2, 0, '地图', '', 'images', 'image', '');
REPLACE INTO cdb_typeoptions VALUES (24, 2, 0, '价格', '', 'price', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (26, 5, 0, '培训名称', '', 'teach_name', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (28, 3, 0, '身高', '', 'heighth', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (29, 3, 0, '体重', '', 'weighth', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (33, 1, 0, '照片', '', 'photo', 'image', '');
REPLACE INTO cdb_typeoptions VALUES (35, 5, 0, '服务方式', '', 'service_type', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (36, 5, 0, '服务时间', '', 'service_time', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (37, 5, 0, '服务费用', '', 'service_pay', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (39, 6, 0, '网址', '', 'site_url', 'url', '');
REPLACE INTO cdb_typeoptions VALUES (40, 6, 0, '电子邮件', '', 'site_mail', 'email', '');
REPLACE INTO cdb_typeoptions VALUES (42, 6, 0, '网站名称', '', 'site_name', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (46, 4, 0, '职位', '', 'recr_intend', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (47, 4, 0, '工作地点', '', 'recr_palce', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (49, 4, 0, '有效期至', '', 'recr_end', 'calendar', '');
REPLACE INTO cdb_typeoptions VALUES (51, 4, 0, '公司名称', '', 'recr_com', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (52, 4, 0, '年龄要求', '', 'recr_age', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (54, 4, 0, '专业', '', 'recr_abli', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (55, 5, 0, '始发', '', 'leaves', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (56, 5, 0, '终点', '', 'boundfor', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (57, 6, 0, 'Alexa排名', '', 'site_top', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (58, 5, 0, '车次/航班', '', 'train_no', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (59, 5, 0, '数量', '', 'trade_num', 'number', '');
REPLACE INTO cdb_typeoptions VALUES (60, 5, 0, '价格', '', 'trade_price', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (61, 5, 0, '有效期至', '', 'trade_end', 'calendar', '');
REPLACE INTO cdb_typeoptions VALUES (63, 1, 0, '详细描述', '', 'detail_content', 'textarea', '');
REPLACE INTO cdb_typeoptions VALUES (64, 1, 0, '籍贯', '', 'born_place', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (65, 2, 0, '租金', '', 'money', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (66, 2, 0, '面积', '', 'acreage', 'text', '');
REPLACE INTO cdb_typeoptions VALUES (67, 5, 0, '发车时间', '', 'time', 'calendar', 'N;');
REPLACE INTO cdb_typeoptions VALUES (68, 1, 0, '所在地', '', 'now_place', 'text', '');
ALTER TABLE cdb_typeoptions AUTO_INCREMENT =3000;
DROP TABLE IF EXISTS cdb_typeoptionvars;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -