upgrade5.php

论坛代码网增加免费空间业务

<?php

// Upgrade Discuz! Board from 3.1.2 to 4.0.0

@set_time_limit(1000);
define('IN_DISCUZ', TRUE);
define('DISCUZ_ROOT', './');

if(@(!include("./config.inc.php")) || @(!include("./include/db_mysql.class.php"))) {
	exit("请先上传所有新版本的程序文件后再运行本升级程序");
}

header("Content-Type: text/html; charset=$charset");

error_reporting(E_ERROR | E_WARNING | E_PARSE);
@set_magic_quotes_runtime(0);

$action = ($_POST['action']) ? $_POST['action'] : $_GET['action'];
$step = $_GET['step'];
$start = $_GET['start'];

$authkey = random(15);

$upgrade1 = <<<EOT
UPDATE cdb_settings SET value=REPLACE(REPLACE(value, ',', '\r\n'), ' ', '') WHERE variable='censoruser';
REPLACE INTO cdb_settings (variable, value) VALUES ('starthreshold', 2);
REPLACE INTO cdb_settings (variable, value) VALUES ('seccodestatus', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('ipregctrl', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('statscachelife', 180);
REPLACE INTO cdb_settings (variable, value) VALUES ('karmaratelimit', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('fullmytopics', 1);
REPLACE INTO cdb_settings (variable, value) VALUES ('rssstatus', 1);
REPLACE INTO cdb_settings (variable, value) VALUES ('visitedforums', 10);
REPLACE INTO cdb_settings (variable, value) VALUES ('seotitle', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('seokeywords', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('seodescription', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('seohead', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('oltimespan', '10');
REPLACE INTO cdb_settings (variable, value) VALUES ('deletereason', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('showemail', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('subforumsindex', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('edittimelimit', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('maintspans', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('threadmaxpages', 1000);
REPLACE INTO cdb_settings (variable, value) VALUES ('membermaxpages', 100);
REPLACE INTO cdb_settings (variable, value) VALUES ('archiverstatus', 1);
REPLACE INTO cdb_settings (variable, value) VALUES ('authkey', '$authkey');
REPLACE INTO cdb_settings (variable, value) VALUES ('regfloodctrl', '30');
REPLACE INTO cdb_settings (variable, value) VALUES ('transsidstatus', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('globalstick', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('dupkarmarate', 0);
REPLACE INTO cdb_settings (variable, value) VALUES ('initcredits', '0,0,0,0,0,0,0,0,0');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_securitycode', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_account', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_ratio', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_mincredits', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_maxcredits', '1000');
REPLACE INTO cdb_settings (variable, value) VALUES ('ec_maxcreditspermonth', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('losslessdel', '365');
REPLACE INTO cdb_settings (variable, value) VALUES ('watermarkstatus', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('watermarktrans', '65');
REPLACE INTO cdb_settings (variable, value) VALUES ('maxsmilies', '3');
REPLACE INTO cdb_settings (variable, value) VALUES ('maxthreadads', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('modreasons', '广告/SPAM
恶意灌水
违规内容
文不对题
重复发帖

我很赞同
精品文章
原创内容');
REPLACE INTO cdb_settings VALUES ('wapstatus', '1');
REPLACE INTO cdb_settings VALUES ('waptpp', '10');
REPLACE INTO cdb_settings VALUES ('wapppp', '5');
REPLACE INTO cdb_settings VALUES ('wapdateformat', 'n/j');
REPLACE INTO cdb_settings VALUES ('wapmps', '500');
REPLACE INTO cdb_settings VALUES ('wapcharset', '2');
REPLACE INTO cdb_settings VALUES ('avatarshowstatus', 1);
REPLACE INTO cdb_settings VALUES ('avatarshowwidth', 135);
REPLACE INTO cdb_settings VALUES ('avatarshowheight', 200);
REPLACE INTO cdb_settings VALUES ('avatarshowpos', 3);
REPLACE INTO cdb_settings VALUES ('avatarshowdefault', 0);
REPLACE INTO cdb_settings VALUES ('avatarshowlink', 1);
REPLACE INTO cdb_settings VALUES ('maxsigrows', 20);
REPLACE INTO cdb_settings VALUES ('bannedmessages', 1);
REPLACE INTO cdb_settings VALUES ('creditsformula', 'extcredits1');
REPLACE INTO cdb_settings VALUES ('ipaccess', '');
REPLACE INTO cdb_settings VALUES ('pvfrequence', '60');
REPLACE INTO cdb_settings VALUES ('adminipaccess', '');
REPLACE INTO cdb_settings VALUES ('stylejump', '0');
REPLACE INTO cdb_settings VALUES ('jsstatus', '0');
REPLACE INTO cdb_settings VALUES ('jscachelife', '1800');
REPLACE INTO cdb_settings VALUES ('jsrefdomains', '');
REPLACE INTO cdb_settings VALUES ('extcredits', '');
REPLACE INTO cdb_settings VALUES ('creditspolicy', '');
REPLACE INTO cdb_settings VALUES ('transfermincredits', '1000');
REPLACE INTO cdb_settings VALUES ('exchangemincredits', '100');
REPLACE INTO cdb_settings VALUES ('creditsformulaexp', '');
REPLACE INTO cdb_settings VALUES ('passport_status', '');
REPLACE INTO cdb_settings VALUES ('passport_key', '');
REPLACE INTO cdb_settings VALUES ('passport_expire', '3600');
REPLACE INTO cdb_settings VALUES ('passport_extcredits', '0');
REPLACE INTO cdb_settings VALUES ('passport_url', '');
REPLACE INTO cdb_settings VALUES ('passport_register_url', '');
REPLACE INTO cdb_settings VALUES ('passport_login_url', '');
REPLACE INTO cdb_settings VALUES ('passport_logout_url', '');
REPLACE INTO cdb_settings VALUES ('creditstrans', '0');
REPLACE INTO cdb_settings VALUES ('creditstax', '0.2');
REPLACE INTO cdb_settings VALUES ('rssttl', '60');
UPDATE cdb_settings SET variable='postbanperiods', value=REPLACE(value, ',', '\r\n') WHERE variable='maintspans';
REPLACE INTO cdb_settings VALUES ('visitbanperiods', '');
REPLACE INTO cdb_settings VALUES ('searchbanperiods', '');
REPLACE INTO cdb_settings VALUES ('postmodperiods', '');
ALTER TABLE cdb_templates DROP charset;
REPLACE INTO cdb_settings (variable, value) VALUES ('qihoostatus', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('searchbox', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('censoremail', '');
REPLACE INTO cdb_settings (variable, value) VALUES ('maxincperthread', '0');
REPLACE INTO cdb_settings (variable, value) VALUES ('maxchargespan', '0');
DELETE FROM cdb_settings WHERE variable='charset';

DROP TABLE IF EXISTS cdb_plugins;
CREATE TABLE cdb_plugins (
  pluginid smallint(6) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  adminid tinyint(1) unsigned NOT NULL default '0',
  name varchar(40) NOT NULL default '',
  identifier varchar(40) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  datatables varchar(255) NOT NULL default '',
  `directory` varchar(100) NOT NULL default '',
  copyright varchar(100) NOT NULL default '',
  modules text NOT NULL,
  PRIMARY KEY  (pluginid),
  UNIQUE KEY identifier (identifier)
) Type=MyISAM;

DROP TABLE IF EXISTS cdb_pluginvars;
CREATE TABLE cdb_pluginvars (
  pluginvarid mediumint(8) unsigned NOT NULL auto_increment,
  pluginid smallint(6) unsigned NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  title varchar(100) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  variable varchar(40) NOT NULL default '',
  `type` varchar(20) NOT NULL default 'text',
  `value` text NOT NULL,
  extra text NOT NULL,
  PRIMARY KEY  (pluginvarid),
  KEY pluginid (pluginid)
) TYPE=MyISAM;

DELETE FROM cdb_settings WHERE variable IN ('dosevasive', 'logincredits', 'version', 'modshortcut');
INSERT INTO cdb_bbcodes (id, available, tag, replacement, example, explanation, params, nest) VALUES ('', 1, 'qq', '<a href="http://wpa.qq.com/msgrd?V=1&amp;Uin={1}&amp;Site=[Discuz!]&amp;Menu=yes" target="_blank"><img src="http://wpa.qq.com/pa?p=1:{1}:1" border="0"></a>', '[qq]688888[/qq]', 'Show online status of specified QQ UIN and chat with him/her simply by clicking the icon', 1, 1);
INSERT INTO cdb_bbcodes (id, available, tag, replacement, example, explanation, params, nest) VALUES ('', 0, 'flash', '<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="550" height="400">\r\n<param name="allowScriptAccess" value="sameDomain">\r\n<param name="movie" value="{1}">\r\n<param name="quality" value="high">\r\n<param name="bgcolor" value="#ffffff">\r\n<embed src="{1}" quality="high" bgcolor="#ffffff" width="550" height="400" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />\r\n</object>', 'Flash Movie', 'Insert flash movie to thread page', 1, 1);
ALTER TABLE cdb_access ADD allowpostattach tinyint(1) NOT NULL;

ALTER TABLE cdb_words CHANGE find find varchar(255) NOT NULL, CHANGE replacement replacement varchar(255) NOT NULL;
ALTER TABLE cdb_stats CHANGE type type char(10) NOT NULL default '', CHANGE var variable char(10) NOT NULL default '';
ALTER TABLE cdb_ranks CHANGE postshigher postshigher MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE cdb_admingroups ADD allowmodpost tinyint(1) NOT NULL default '' AFTER alloweditpoll, CHANGE admingid admingid SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL, ADD allowmoduser TINYINT(1) NOT NULL AFTER allowedituser, ADD allowstickthread tinyint(1) NOT NULL AFTER alloweditpoll, ADD allowrefund tinyint(1) NOT NULL AFTER allowmassprune;
ALTER TABLE cdb_attachtypes CHANGE extension extension char(12) NOT NULL;
UPDATE cdb_stats SET variable='Spiders' WHERE type='os' AND variable='BeOS';
UPDATE cdb_stats SET variable='0' WHERE type='week' AND variable='';
UPDATE cdb_admingroups SET allowmodpost=1;
UPDATE cdb_admingroups SET allowmoduser='1', allowstickthread=4-admingid WHERE admingid IN (1,2,3);
UPDATE cdb_admingroups SET allowrefund=1 WHERE admingid=1 OR admingid=2;

ALTER TABLE cdb_threads CHANGE views views INT(10) UNSIGNED DEFAULT '0' NOT NULL,
	CHANGE replies replies MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
	ADD blog TINYINT(1) NOT NULL AFTER digest,
	ADD moderated TINYINT(1) NOT NULL AFTER attachment,
	ADD rate TINYINT(1) NOT NULL AFTER digest,
	ADD INDEX blog (blog , authorid , dateline),
	ADD readperm tinyint(3) UNSIGNED NOT NULL AFTER iconid,
	ADD price smallint(6) NOT NULL AFTER readperm;
UPDATE cdb_threads SET readperm=100 WHERE creditsrequire>10;
ALTER TABLE cdb_threads DROP creditsrequire, ADD typeid smallint(6) UNSIGNED NOT NULL default '0' AFTER iconid, ADD INDEX typeid (fid, typeid, displayorder, lastpost);

ALTER TABLE cdb_sessions ADD lastolupdate INT(10) UNSIGNED NOT NULL AFTER lastactivity, ADD bloguid MEDIUMINT(8) UNSIGNED NOT NULL, ADD seccode SMALLINT(6) UNSIGNED NOT NULL AFTER lastolupdate, ADD pageviews smallint(6) UNSIGNED NOT NULL AFTER lastolupdate, ADD INDEX (uid), ADD INDEX (bloguid);
ALTER TABLE cdb_usergroups ADD maxsizeperday INT(10) UNSIGNED NOT NULL AFTER maxattachsize, CHANGE maxattachsize maxattachsize MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, ADD radminid TINYINT(3) NOT NULL AFTER groupid, ADD allowhtml TINYINT(1) NOT NULL AFTER allowhidecode, ADD allowdirectpost tinyint(1) NOT NULL AFTER allowpostpoll, ADD reasonpm tinyint(1) NOT NULL AFTER allowviewstats, ADD allowuseblog TINYINT(1) NOT NULL AFTER allowkarma, ADD allowviewpro tinyint(1) NOT NULL AFTER allowsigimgcode, ADD minkarmarate smallint(6) NOT NULL default 0 AFTER reasonpm, CHANGE maxkarmarate maxkarmarate1 smallint(6) NOT NULL default 0, ADD maxkarmarate smallint(6) NOT NULL default 0 AFTER minkarmarate, ADD allowcusbbcode TINYINT(1) NOT NULL AFTER allowhtml, CHANGE allowsetviewperm allowsetreadperm tinyint(1) NOT NULL, ADD readaccess tinyint(3) UNSIGNED NOT NULL default '0' AFTER groupavatar, ADD allownickname tinyint(1) NOT NULL AFTER allowcusbbcode;
UPDATE cdb_usergroups SET allowdirectpost='1', allowuseblog='1', allowcusbbcode='1' WHERE groupid IN ('1', '2', '3');
UPDATE cdb_usergroups SET allowviewpro=1 WHERE groupid IN (1,2,3) OR groupid>8;
UPDATE cdb_usergroups SET maxkarmarate=maxkarmarate1;
UPDATE cdb_usergroups SET minkarmarate=-1*maxkarmarate;
UPDATE cdb_usergroups SET allownickname=1 WHERE groupid IN (1,2,3) OR creditshigher>500;
UPDATE cdb_usergroups SET readaccess=10 WHERE groupid NOT IN (4,5,6,7,8) AND allowview<>0;
UPDATE cdb_usergroups SET readaccess=100+3-groupid WHERE groupid IN (1,2,3);
ALTER TABLE cdb_usergroups DROP maxkarmarate1, DROP allowview;
UPDATE cdb_usergroups SET radminid=groupid WHERE groupid IN (1,2,3);
ALTER TABLE cdb_smilies CHANGE code code VARCHAR(30) NOT NULL, ADD displayorder tinyint(1) NOT NULL AFTER id;
ALTER TABLE cdb_favorites DROP INDEX tid, ADD INDEX uid (uid);
ALTER TABLE cdb_styles DROP INDEX themename;

DROP TABLE IF EXISTS cdb_threadtypes;
CREATE TABLE cdb_threadtypes (
  typeid smallint(6) UNSIGNED NOT NULL auto_increment,
  displayorder tinyint(3) NOT NULL,
  name varchar(255) NOT NULL,
  description varchar(255) NOT NULL default '',
  PRIMARY KEY  (typeid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_medals;
CREATE TABLE cdb_medals (
  medalid smallint(6) UNSIGNED NOT NULL auto_increment,
  name varchar(50) NOT NULL,
  available tinyint(1) NOT NULL,
  image varchar(30) NOT NULL,
  PRIMARY KEY  (medalid)
) TYPE=MyISAM;

INSERT INTO cdb_medals VALUES (1, 'Medal No.1', 0, 'medal1.gif');
INSERT INTO cdb_medals VALUES (2, 'Medal No.2', 0, 'medal2.gif');
INSERT INTO cdb_medals VALUES (3, 'Medal No.3', 0, 'medal3.gif');
INSERT INTO cdb_medals VALUES (4, 'Medal No.4', 0, 'medal4.gif');
INSERT INTO cdb_medals VALUES (5, 'Medal No.5', 0, 'medal5.gif');
INSERT INTO cdb_medals VALUES (6, 'Medal No.6', 0, 'medal6.gif');
INSERT INTO cdb_medals VALUES (7, 'Medal No.7', 0, 'medal7.gif');
INSERT INTO cdb_medals VALUES (8, 'Medal No.8', 0, 'medal8.gif');
INSERT INTO cdb_medals VALUES (9, 'Medal No.9', 0, 'medal9.gif');
INSERT INTO cdb_medals VALUES (10, 'Medal No.10', 0, 'medal10.gif');

DROP TABLE IF EXISTS cdb_adminactions;
CREATE TABLE cdb_adminactions (
  admingid SMALLINT(6) UNSIGNED NOT NULL,
  disabledactions TEXT NOT NULL,
  PRIMARY KEY  (admingid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_advertisements;
CREATE TABLE cdb_advertisements (
  advid mediumint(8) unsigned NOT NULL auto_increment,
  available tinyint(1) NOT NULL default '0',
  `type` varchar(50) NOT NULL default '0',
  displayorder tinyint(3) NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  targets varchar(255) NOT NULL default '',
  parameters text NOT NULL,
  code text NOT NULL,
  starttime int(10) unsigned NOT NULL default '0',
  endtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (advid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_orders;
CREATE TABLE cdb_orders (
  orderid char(32) NOT NULL default '',
  `status` char(3) NOT NULL default '',
  buyer char(50) NOT NULL default '',
  admin char(15) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  amount smallint(6) unsigned NOT NULL default '0',
  price float(7,2) unsigned NOT NULL default '0.00',
  submitdate int(10) unsigned NOT NULL default '0',
  confirmdate int(10) unsigned NOT NULL default '0',
  UNIQUE KEY orderid (orderid),
  KEY submitdate (submitdate),
  KEY uid (uid,submitdate)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_adminsessions;
CREATE TABLE cdb_adminsessions (
  uid mediumint(8) UNSIGNED NOT NULL default '0',
  ip char(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  errorcount tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_blogcaches;
CREATE TABLE cdb_blogcaches (
  uid mediumint(8) unsigned NOT NULL default '0',
  variable char(10) NOT NULL default '',
  value text NOT NULL,
  PRIMARY KEY  (uid,variable)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_karmalog;
DROP TABLE IF EXISTS cdb_ratelog;
CREATE TABLE cdb_ratelog (
  pid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username char(15) NOT NULL default '',
  extcredits tinyint(1) UNSIGNED NOT NULL,
  dateline int(10) unsigned NOT NULL default '0',
  score smallint(6) NOT NULL default '0',
  reason char(20) NOT NULL,
  INDEX (dateline),
  INDEX  (pid, dateline)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_moderators;
CREATE TABLE cdb_moderators (
  uid mediumint(8) UNSIGNED NOT NULL,
  fid smallint(6) UNSIGNED NOT NULL,
  displayorder tinyint(3) NOT NULL default '0',
  inherited tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (uid, fid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_regips;
CREATE TABLE cdb_regips (
  ip char(15) NOT NULL,
  dateline int(10) UNSIGNED NOT NULL default 0,
  count smallint(6) NOT NULL default 0,
  KEY  (ip)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_statvars;
CREATE TABLE cdb_statvars (
  type varchar(20) NOT NULL default '',
  variable varchar(20) NOT NULL default '',
  value mediumtext NOT NULL,
  PRIMARY KEY  (type, variable)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cdb_threadsmod;
CREATE TABLE cdb_threadsmod (
  tid mediumint(8) UNSIGNED NOT NULL,
  uid mediumint(8) UNSIGNED NOT NULL,
  username char(15) NOT NULL,