COML', searchctrl='5';
ALTER TABLE cdb_searchindex CHANGE num results INT(10) UNSIGNED DEFAULT '0' NOT NULL;
UPDATE cdb_members SET tpp='0', ppp='0';
ALTER TABLE cdb_u2u CHANGE folder folder enum('inbox', 'outbox') NOT NULL;
ALTER TABLE cdb_posts CHANGE message message mediumtext NOT NULL;
ALTER TABLE cdb_settings CHANGE maxpostsize maxpostsize mediumint(8) UNSIGNED NOT NULL;
CREATE TABLE cdb_karmalog (
username varchar(15) NOT NULL default '',
pid int(10) UNSIGNED NOT NULL default 0,
dateline int(10) UNSIGNED NOT NULL default 0,
score tinyint(3) UNSIGNED NOT NULL default 0
);
ALTER TABLE cdb_settings DROP karmactrl;
ALTER TABLE cdb_usergroups CHANGE maxkarmavote maxkarmarate tinyint(3) UNSIGNED NOT NULL;
ALTER TABLE cdb_usergroups CHANGE maxattachsize maxattachsize int(10) UNSIGNED NOT NULL;
ALTER TABLE cdb_usergroups ADD maxrateperday smallint(6) UNSIGNED NOT NULL AFTER maxkarmarate;
UPDATE cdb_usergroups SET maxrateperday='10';
ALTER TABLE cdb_posts ADD rate smallint(6) NOT NULL, ADD ratetimes tinyint(3) UNSIGNED NOT NULL;
ALTER TABLE cdb_settings CHANGE timeoffset timeoffset1 char(3);
ALTER TABLE cdb_settings ADD timeoffset varchar(5) NOT NULL AFTER attachimgpost;
UPDATE cdb_settings SET timeoffset=timeoffset1;
ALTER TABLE cdb_settings DROP timeoffset1;
ALTER TABLE cdb_settings ADD modshortcut tinyint(1) NOT NULL AFTER fastpost;
ALTER TABLE cdb_settings ADD logincredits tinyint(3) UNSIGNED NOT NULL AFTER smcols;
ALTER TABLE cdb_settings CHANGE postcredits postcredits tinyint(3) UNSIGNED NOT NULL;
ALTER TABLE cdb_settings CHANGE digistcredits digistcredits tinyint(3) UNSIGNED NOT NULL;
ALTER TABLE cdb_settings ADD attachsave tinyint(1) NOT NULL AFTER dotfolders;
ALTER TABLE cdb_settings DROP chcode;
ALTER TABLE cdb_settings ADD maxonlines smallint(6) UNSIGNED NOT NULL AFTER styleid;
UPDATE cdb_settings SET maxonlines='1000';
ALTER TABLE cdb_posts ADD INDEX (dateline);
ALTER TABLE cdb_forums ADD styleid smallint(6) UNSIGNED NOT NULL AFTER moderator;
ALTER TABLE cdb_u2u RENAME cdb_pm;
ALTER TABLE cdb_usergroups CHANGE maxu2unum maxpmnum smallint(6) UNSIGNED NOT NULL;
ALTER TABLE cdb_members CHANGE newu2u newpm tinyint(1) NOT NULL, CHANGE ignoreu2u ignorepm text NOT NULL;
ALTER TABLE cdb_pm CHANGE u2uid pmid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE cdb_members CHANGE credit credit INT(10) DEFAULT '0' NOT NULL;
ALTER TABLE cdb_settings CHANGE digistcredits digestcredits tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE cdb_threads CHANGE digist digest tinyint(1) NOT NULL default '0';
ALTER TABLE cdb_settings CHANGE emailcheck regverify TINYINT(1) DEFAULT '0' NOT NULL;
ALTER TABLE cdb_styles ADD available TINYINT(1) DEFAULT '1' NOT NULL AFTER name;
EOT;
if(!$action) {
echo"本程序用于升级 Discuz! 1.01 到 Discuz! 2.0,请确认之前已经顺利安装 Discuz! 1.01
";
echo"运行本升级程序之前,请确认已经上传 2.0 COML 的全部文件和目录
";
echo"本程序只能从 Discuz! 1.01 升级到 Discuz! 2.0 COML,切勿使用本程序从其他版本升级,否则可能会破坏掉数据库资料.
升级之前务必备份数据库资料,否则可能产生无法恢复的后果!
";
echo"正确的升级方法为:
1. 上传 Discuz! 2.0 版的全部文件和目录,覆盖服务器上的 1.01
2. 上传本程序($PHP_SELF)到 Discuz! 目录中;
3. 运行本程序,直到出现升级完成的提示;
4. 在 Discuz! 系统设置中更新缓存,升级完成.
";
echo"如果您已确认完成上面的步骤,请点这里升级";
} else {
$tables = array('attachments', 'announcements', 'banned', 'caches', 'favorites', 'forumlinks', 'forums', 'members', 'memo',
'news', 'posts', 'searchindex', 'sessions', 'settings', 'styles', 'smilies', 'stats', 'subscriptions', 'templates', 'themes',
'threads', 'u2u', 'usergroups', 'words', 'buddys', 'stylevars');
foreach($tables as $tablename) {
${"table_".$tablename} = $tablepre.$tablename;
}
unset($tablename);
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$db->select_db($dbname);
unset($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
if($step == 1) {
runquery($upgrade1);
echo "第 1 步升级成功,点击这里进入下一步.";
} elseif($step == 2) {
runquery($upgrade2);
$query = $db->query("SELECT $table_styles.styleid FROM $table_settings, $table_styles WHERE $table_styles.name=$table_settings.theme");
$styleid = $db->result($query, 0);
$db->query("UPDATE $table_settings SET styleid='$styleid'");
$db->query("ALTER TABLE $table_settings DROP theme");
$query = $db->query("SELECT * FROM $table_styles");
while($style = $db->fetch_array($query)) {
foreach($style as $key => $val) {
if($key != 'styleid' && $key != 'name' && $key != 'templateid') {
$db->query("INSERT INTO $table_stylevars VALUES ('', $style[styleid], '".addslashes($key)."', '".addslashes($val)."')");
}
}
}
$db->query("ALTER TABLE $table_styles DROP bgcolor, DROP altbg1, DROP altbg2, DROP link, DROP bordercolor, DROP headercolor, DROP headertext, DROP catcolor, DROP tabletext, DROP text, DROP borderwidth, DROP tablewidth, DROP tablespace, DROP font, DROP fontsize, DROP nobold, DROP boardimg, DROP imgdir, DROP smdir, DROP cattext, DROP smfont, DROP smfontsize");
$query = $db->query("SELECT COUNT(*) FROM $table_members");
$db->query("UPDATE $table_settings SET totalmembers='".$db->result($query, 0)."'");
$db->query("ALTER TABLE $table_templates ADD charset varchar(30) NOT NULL AFTER name");
$db->query("UPDATE $table_templates SET charset='gb2312'");
$query = $db->query("SELECT * FROM $table_usergroups WHERE groupid='1' OR groupid='2'");
while($group = $db->fetch_array($query)) {
$sqlquery[] = join("','", $group);
}
foreach($sqlquery as $sql) {
if($sql) {
$sql = preg_replace("/^\'(\d{1})\'/", "''", "'$sql'");
$db->query("INSERT INTO $table_usergroups VALUES ($sql)");
}
}
$db->query("DELETE FROM $table_usergroups WHERE groupid='1' OR groupid='2'");
$db->query("UPDATE $table_usergroups SET groupid='1' WHERE groupid='14'");
$db->query("UPDATE $table_usergroups SET groupid='2' WHERE groupid='16'");
echo "第 2 步升级成功,点击这里进入下一步.";
} elseif($step == 3) {
$many = 3000;
if(!$start) {
$start = 0;
}
$end = $start + $many;
$converted = 0;
echo"正在进行升级第 3 步 如果您的数据很多,则这一步需要时间较长
\n";
echo"现在转换贴子. 本转换可能经历多次跳转, 请不要关闭浏览器.
\n";
echo"现在开始转换 id 从 $start 到 $end 的贴子.
";
$query = $db->query("SELECT pid, message FROM $table_posts WHERE parseurloff='0' LIMIT $start, $many");
while($post = $db->fetch_array($query)) {
$post[message] = trim(addslashes($post[message]));
$post[message1] = trim(parseurl($post[message]));
if($post[message] != $post[message1]) {
$db->query("UPDATE $table_posts SET message='$post[message1]' WHERE pid='$post[pid]'");
}
$converted = 1;
}
if($converted) {
$end ++;
redirect("$PHP_SELF?action=upgrade&step=3&start=$end");
} else {
redirect("$PHP_SELF?action=upgrade&step=4");
}
} elseif($step == 4) {
$query = $db->query("SELECT tid, pollopts FROM $table_threads WHERE pollopts<>''");
while($thread = $db->fetch_array($query)) {
if(strpos($thread['pollopts'], '#|#')) {
$pollarray = array('multiple' => 0, 'max' => 0, 'total' => 0);
$votersorig = explode(' ', substr($thread['pollopts'], strrpos($thread['pollopts'], '#|#') + 2));
foreach($votersorig as $voter) {
$voter = trim($voter);
if($voter) {
$pollarray['voters'][] = $voter;
}
}
foreach(explode('#|#', $thread['pollopts']) as $pollorig) {
$optionorig = explode('||~|~||', addslashes($pollorig));
if(count($optionorig) == 2) {
$pollarray['options'][] = array($optionorig[0], $optionorig[1]);
if($optionorig[1] > $pollarray['max']) {
$pollarray['max'] = $optionorig[1];
}
$pollarray['total'] += $optionorig[1];
}
}
$pollopts = serialize($pollarray);
$db->query("UPDATE $table_threads SET pollopts='$pollopts' WHERE tid='$thread[tid]'");
}
}
echo "恭喜您升级成功,请删除本程序.";
}
}
function runquery($query) {
global $db, $tablepre;
$expquery = explode(";", $query);
foreach($expquery as $sql) {
$sql = trim($sql);
if($sql != "" && $sql[0] != "#") {
$db->query(str_replace("cdb_", $tablepre, $sql));
}
}
}
function redirect($url) {
echo"";
echo"
如果您的浏览器没有自动跳转，请点击这里";
}
// DELETE FROM cdb_stylevars WHERE variable IN ('credittitle', 'creditunit', 'moved', 'sticky', 'digist', 'poll');
?>