upgrade5.php

速度很快的PHP论坛源程序

<?php

// Upgrade Discuz! Board from 3.1.2 to 4.0.0

header("Content-Type: text/html; charset=gb2312");
set_time_limit(1000);
define('IN_DISCUZ', TRUE);
define('DISCUZ_ROOT', './');

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

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

$action = ($HTTP_POST_VARS[action]) ? $HTTP_POST_VARS[action] : $HTTP_GET_VARS[action];
$step = $HTTP_GET_VARS[step];
$start = $HTTP_GET_VARS[start];

$authkey = random(15);

$upgrade1 = <<<EOT
REPLACE INTO cdb_settings VALUES ('seotitle', '');
REPLACE INTO cdb_settings VALUES ('seokeywords', '');
REPLACE INTO cdb_settings VALUES ('seodescription', '');
REPLACE INTO cdb_settings VALUES ('seohead', '');
REPLACE INTO cdb_settings VALUES ('oltimespan', '10');
REPLACE INTO cdb_settings VALUES('deletereason', 0);
REPLACE INTO cdb_settings VALUES('showemail', 0);
REPLACE INTO cdb_settings VALUES('subforumsindex', 0);
REPLACE INTO cdb_settings VALUES('edittimelimit', 0);
REPLACE INTO cdb_settings VALUES('maintspans', '');
REPLACE INTO cdb_settings VALUES('threadmaxpages', 1000);
REPLACE INTO cdb_settings VALUES('membermaxpages', 100);
REPLACE INTO cdb_settings VALUES('archiverstatus', 1);
REPLACE INTO cdb_settings VALUES('authkey', '$authkey');
REPLACE INTO cdb_settings VALUES('regfloodctrl', '30');
REPLACE INTO cdb_settings VALUES('transsidstatus', '0');
REPLACE INTO cdb_settings VALUES('globalstick', '0');
REPLACE INTO cdb_settings VALUES('modreasons', '广告/SPAM
恶意灌水
违规内容
文不对题
重复发帖

我很赞同
精品文章
原创内容');

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&Uin={1}&Site=[Discuz!]&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;
UPDATE cdb_stats SET variable='Spiders' WHERE type='os' AND variable='BeOS';
UPDATE cdb_admingroups SET allowmodpost=1;
UPDATE cdb_admingroups SET allowmoduser='1' WHERE admingid IN (1,2,3);

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);

ALTER TABLE cdb_sessions ADD lastolupdate INT(10) UNSIGNED NOT NULL AFTER lastactivity, ADD bloguid MEDIUMINT(8) UNSIGNED NOT NULL, 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 TINYINT(3) NOT NULL AFTER reasonpm, CHANGE maxkarmarate maxkarmarate1 TINYINT(3) DEFAULT '0' NOT NULL, ADD maxkarmarate TINYINT(3) NOT NULL AFTER minkarmarate, ADD allowcusbbcode TINYINT(1) NOT NULL AFTER allowhtml;
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;
ALTER TABLE cdb_usergroups DROP maxkarmarate1;
UPDATE cdb_usergroups SET radminid=groupid WHERE groupid IN (1,2,3);

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'
);

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)
);

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 '',
  dateline int(10) unsigned NOT NULL default '0',
  score smallint(6) NOT NULL default '0',
  KEY  (pid, dateline)
);

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)
);

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)
);

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

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,
  dateline int(10) UNSIGNED NOT NULL,
  action char(3) NOT NULL,
  PRIMARY KEY (tid)
);

DROP TABLE IF EXISTS cdb_adminnotes;
CREATE TABLE cdb_adminnotes (
  id mediumint(8) unsigned NOT NULL auto_increment,
  admin varchar(15) NOT NULL default '',
  access tinyint(3) NOT NULL default '0',
  adminid tinyint(3) NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  expiration int(10) unsigned NOT NULL default '0',
  message text NOT NULL,
  PRIMARY KEY  (id)
) Type=MyISAM;

DROP TABLE IF EXISTS cdb_onlinetime;
CREATE TABLE cdb_onlinetime (
  uid mediumint(8) unsigned NOT NULL,
  thismonth smallint(6) UNSIGNED NOT NULL default '0',
  total mediumint(8) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (uid)
) Type=MyISAM;

DROP TABLE IF EXISTS cdb_forumfields;
CREATE TABLE cdb_forumfields (
  fid smallint(6) UNSIGNED NOT NULL,
  password varchar(12) NOT NULL,
  icon varchar(255) NOT NULL,
  redirect varchar(255) NOT NULL,
  attachextensions varchar(255) NOT NULL,
  moderators text NOT NULL,
  rules text NOT NULL,
  viewperm text NOT NULL,
  postperm text NOT NULL,
  replyperm text NOT NULL,
  getattachperm text NOT NULL,
  postattachperm text NOT NULL,
  PRIMARY KEY  (fid)
);

DROP TABLE IF EXISTS cdb_validating;
CREATE TABLE cdb_validating (
  uid mediumint(8) unsigned NOT NULL,
  submitdate int(10) unsigned NOT NULL,
  moddate int(10) unsigned NOT NULL,
  admin varchar(15) NOT NULL,
  submittimes tinyint(3) unsigned NOT NULL,
  status tinyint(1) NOT NULL,
  message text NOT NULL,
  remark text NOT NULL,
  PRIMARY KEY  (uid),
  KEY  (status)
) Type=MyISAM;
EOT;

$upgrade2 = <<<EOT
DROP TABLE IF EXISTS cdb_memberfields;
CREATE TABLE cdb_memberfields (
  uid mediumint(8) unsigned NOT NULL,
  origgroup VARCHAR(10) NOT NULL,
  site varchar(75) NOT NULL default '',
  icq varchar(12) NOT NULL default '',
  oicq varchar(12) NOT NULL default '',
  yahoo varchar(40) NOT NULL default '',
  msn varchar(40) NOT NULL default '',
  location varchar(30) NOT NULL default '',
  customstatus varchar(30) NOT NULL default '',
  avatar varchar(100) NOT NULL default '',
  avatarwidth tinyint(3) unsigned NOT NULL default '0',
  avatarheight tinyint(3) unsigned NOT NULL default '0',
  bio text NOT NULL,
  signature text NOT NULL,
  sightml text NOT NULL,
  ignorepm text NOT NULL,
  authstr varchar(20) NOT NULL default '',
  \$str_table
  PRIMARY KEY  (uid)
);

ALTER TABLE cdb_pms ADD INDEX (folder);
EOT;

$upgrade4_3 = <<<EOT
ALTER TABLE cdb_posts ADD attachment TINYINT(1) NOT NULL AFTER parseurloff,
	ADD invisible TINYINT(1) NOT NULL AFTER useip,
	ADD htmlon TINYINT(1) NOT NULL AFTER usesig,
	DROP INDEX tid,
	ADD INDEX (invisible),
	ADD INDEX displayorder (tid, invisible, dateline);
EOT;

$upgrade5_3 = <<<EOT
UPDATE cdb_posts SET attachment=1 WHERE aid>0;
ALTER TABLE cdb_attachments ADD INDEX (tid), ADD INDEX(pid), CHANGE downloads downloads MEDIUMINT(8) DEFAULT '0' NOT NULL;
EOT;

$upgrade6_3 = <<<EOT
ALTER TABLE cdb_posts DROP aid;
EOT;

$upgrade4_4 = <<<EOT
ALTER TABLE cdb_posts CHANGE aid attachment TINYINT(1) NOT NULL AFTER parseurloff,
	ADD invisible TINYINT(1) NOT NULL AFTER useip,
	ADD htmlon TINYINT(1) NOT NULL AFTER usesig,
	DROP INDEX tid,
	ADD INDEX (invisible),
	ADD INDEX displayorder (tid, invisible, dateline);
EOT;

$upgrade5_4 = <<<EOT
UPDATE cdb_posts SET attachment=1 WHERE attachment>0;
EOT;

$upgrade6_4 = <<<EOT
ALTER TABLE cdb_attachments ADD INDEX (tid), ADD INDEX(pid), CHANGE downloads downloads MEDIUMINT(8) DEFAULT '0' NOT NULL;
EOT;

$upgrade7 = <<<EOT
ALTER TABLE cdb_members DROP site, DROP icq, DROP oicq, DROP yahoo, DROP msn, DROP location, DROP bio,
	DROP avatar, DROP avatarwidth, DROP avatarheight, DROP customstatus, DROP ignorepm, DROP identifying,
	CHANGE username username char(15) NOT NULL default '',
	CHANGE password password char(32) NOT NULL default '',
	CHANGE secques secques char(8) NOT NULL default '',
	CHANGE regip regip char(15) NOT NULL default '',
	CHANGE lastip lastip char(15) NOT NULL default '',
	CHANGE email email char(60) NOT NULL default '',
	CHANGE dateformat dateformat char(10) NOT NULL default '',
	CHANGE timeformat timeformat tinyint(1) NOT NULL default '0',
	CHANGE signature sigstatus tinyint(1) NOT NULL default 0,
	CHANGE postnum posts MEDIUMINT(8) UNSIGNED NOT NULL default '0',
	CHANGE credit credits int(10) NOT NULL,
	CHANGE extracredit extracredits int(10) NOT NULL,
	CHANGE showemail showemail tinyint(1) NOT NULL default '0',
	CHANGE timeoffset timeoffset CHAR(4) NOT NULL,
	ADD digestposts SMALLINT(6) UNSIGNED NOT NULL AFTER posts,
	ADD groupexpiry INT(10) UNSIGNED NOT NULL AFTER groupid,
	ADD pmsound TINYINT(1) NOT NULL AFTER timeformat,
	DROP INDEX username,