1. 请确认已经安装了 UCenter
2. 关闭原有论坛，上传 $version[new] 的全部文件和目录，覆盖服务器上的 $version[old]
3. 上传升级程序到论坛目录中，重新配置好 config.inc.php
4. 运行本程序，直到出现升级完成的提示
5. 如果中途失败，请使用Discuz!工具箱（./utilities/tools.php）里面的数据恢复工具恢复备份，去除错误后重新运行本程序

创建配置文件

用户数据导入到 UCenter

合并用户数据

合并重复用户

导入好友数据

处理短消息数据

新增数据表

调整论坛数据表结构

更新部分数据

1. 必删除本程序'. '
2. 使用管理员身份登录论坛，进入后台，更新缓存'. '
3. 进行论坛注册、登录、发贴等常规测试，看看运行是否正常'. '
4. 如果您觉得论坛升级后没有任何问题可以自行删除 forumdata 目录下的 upgrade.log 文件
   
   '. '感谢您选用我们的产品！您现在可以访问论坛，查看升级情况'; instfooter(); } function insertconfig($s, $find, $replace) { if(preg_match($find, $s)) { $s = preg_replace($find, $replace, $s); } else { // 插入到最后一行 $s .= "\r\n".$replace; } return $s; } function instheader() { global $charset, $version; echo "". "". "". " ". "
   ". "

   ". "". "". " >> $version[old] >> $version[new] 升级向导 ". " "; } function instfooter() { global $version; echo " ". "Powered by Discuz!". "   Copyright © Comsenz Inc. 2001-2009 ". "

   ". ""; } function instmsg($message, $url_forward = '', $postdata = '') { global $lang, $msglang; $message = $msglang[$message] ? $msglang[$message] : $message; if($postdata) { $message .= "
   
   
   $msglang[redirect_msg]"; echo '
   '; echo $postdata; echo "". "". "

   $lang[error_message]

   $message

   "; echo '
   '; instfooter(); } else { if($url_forward) { $message .= "
   
   
   $msglang[redirect_msg]"; $message .= ""; } elseif(strpos($message, $lang['return'])) { $message .= "
   
   
   $lang[message_return]"; } echo "". "". "

   $lang[error_message]

   $message

   "; instfooter(); } exit; } function getgpc($k, $var='G') { switch($var) { case 'G': $var = &$_GET; break; case 'P': $var = &$_POST; break; case 'C': $var = &$_COOKIE; break; case 'R': $var = &$_REQUEST; break; } return isset($var[$k]) ? $var[$k] : NULL; } function dir_clear($dir) { $directory = dir($dir); while($entry = $directory->read()) { $filename = $dir.'/'.$entry; if(is_file($filename)) { @unlink($filename); } } @touch($dir.'/index.htm'); $directory->close(); } function var_to_hidden($k, $v) { return ""; } function getmaxuid() { global $ucdb; $query = $ucdb->query("SHOW TABLE STATUS LIKE '".substr(UC_DBTABLEPRE, strpos(UC_DBTABLEPRE, ".")+1)."members'"); $data = $ucdb->fetch_array($query); if($data["Auto_increment"]) { return $data["Auto_increment"] - 1; } else { return 0; } } function getuidfields() { return array( 'members', 'memberfields', 'access', 'activities', 'activityapplies', 'attachments', 'attachpaymentlog', 'buddys|uid,buddyid', 'creditslog', 'debateposts', 'debates', 'favorites', 'forumrecommend|authorid,moderatorid', 'invites', 'magiclog', 'magicmarket', 'membermagics', 'memberspaces', 'moderators', 'modworks', 'myposts', 'mythreads', 'onlinetime', 'orders', 'paymentlog|uid,authorid', 'pms|msgtoid,msgfromid|pmid', 'posts|authorid|pid', 'promotions', 'ratelog', 'rewardlog|authorid,answererid', 'searchindex|uid', 'spacecaches', 'subscriptions', 'threads|authorid|tid', 'threadsmod', 'tradecomments|raterid,rateeid', 'tradelog|sellerid,buyerid', 'trades|sellerid', 'validating', 'videos', ); } function dfopen($url, $limit = 0, $post = '', $cookie = '', $bysocket = FALSE, $ip = '', $timeout = 15, $block = TRUE) { $return = ''; $matches = parse_url($url); $host = $matches['host']; $path = $matches['path'] ? $matches['path'].'?'.$matches['query'].'#'.$matches['fragment'] : '/'; $port = !empty($matches['port']) ? $matches['port'] : 80; if($post) { $out = "POST $path HTTP/1.0\r\n"; $out .= "Accept: */*\r\n"; //$out .= "Referer: $boardurl\r\n"; $out .= "Accept-Language: zh-cn\r\n"; $out .= "Content-Type: application/x-www-form-urlencoded\r\n"; $out .= "User-Agent: $_SERVER[HTTP_USER_AGENT]\r\n"; $out .= "Host: $host\r\n"; $out .= 'Content-Length: '.strlen($post)."\r\n"; $out .= "Connection: Close\r\n"; $out .= "Cache-Control: no-cache\r\n"; $out .= "Cookie: $cookie\r\n\r\n"; $out .= $post; } else { $out = "GET $path HTTP/1.0\r\n"; $out .= "Accept: */*\r\n"; //$out .= "Referer: $boardurl\r\n"; $out .= "Accept-Language: zh-cn\r\n"; $out .= "User-Agent: $_SERVER[HTTP_USER_AGENT]\r\n"; $out .= "Host: $host\r\n"; $out .= "Connection: Close\r\n"; $out .= "Cookie: $cookie\r\n\r\n"; } $fp = @fsockopen(($ip ? $ip : $host), $port, $errno, $errstr, $timeout); if(!$fp) { return ''; } else { stream_set_blocking($fp, $block); stream_set_timeout($fp, $timeout); @fwrite($fp, $out); $status = stream_get_meta_data($fp); if(!$status['timed_out']) { while (!feof($fp)) { if(($header = @fgets($fp)) && ($header == "\r\n" || $header == "\n")) { break; } } $stop = false; while(!feof($fp) && !$stop) { $data = fread($fp, ($limit == 0 || $limit > 8192 ? 8192 : $limit)); $return .= $data; if($limit) { $limit -= strlen($data); $stop = $limit <= 0; } } } @fclose($fp); return $return; } } function createtable($sql, $dbcharset) { $type = strtoupper(preg_replace("/^\s*CREATE TABLE\s+.+\s+\(.+?\).*(ENGINE|TYPE)\s*=\s*([a-z]+?).*$/isU", "\\2", $sql)); $type = in_array($type, array('MYISAM', 'HEAP')) ? $type : 'MYISAM'; return preg_replace("/^\s*(CREATE TABLE\s+.+\s+\(.+?\)).*$/isU", "\\1", $sql). (mysql_get_server_info() > '4.1' ? " ENGINE=$type DEFAULT CHARSET=$dbcharset" : " TYPE=$type"); } function runquery($query) { global $db, $tablepre, $dbcharset; $query = str_replace("\r", "\n", str_replace(' cdb_', ' '.$tablepre, $query)); $expquery = explode(";\n", $query); foreach($expquery as $sql) { $sql = trim($sql); if($sql == '' || $sql[0] == '#') continue; if(strtoupper(substr($sql, 0, 12)) == 'CREATE TABLE') { $db->query(createtable($sql, $dbcharset)); } else { $db->query($sql); } } } function upgradetable($updatesql) { global $db, $tablepre, $dbcharset; $successed = TRUE; if(is_array($updatesql) && !empty($updatesql[0])) { list($table, $action, $field, $sql) = $updatesql; if(empty($field) && !empty($sql)) { $query = "ALTER TABLE {$tablepre}{$table} "; if($action == 'INDEX') { $successed = $db->query("$query $sql", "SILENT"); } elseif ($action == 'UPDATE') { $successed = $db->query("UPDATE {$tablepre}{$table} SET $sql", 'SILENT'); } } elseif($tableinfo = loadtable($table)) { $fieldexist = isset($tableinfo[$field]) ? 1 : 0; $query = "ALTER TABLE {$tablepre}{$table} "; if($action == 'MODIFY') { $query .= $fieldexist ? "MODIFY $field $sql" : "ADD $field $sql"; $successed = $db->query($query, 'SILENT'); } elseif($action == 'CHANGE') { $field2 = trim(substr($sql, 0, strpos($sql, ' '))); $field2exist = isset($tableinfo[$field2]); if($fieldexist && ($field == $field2 || !$field2exist)) { $query .= "CHANGE $field $sql"; } elseif($fieldexist && $field2exist) { $db->query("ALTER TABLE {$tablepre}{$table} DROP $field2", 'SILENT'); $query .= "CHANGE $field $sql"; } elseif(!$fieldexist && $fieldexist2) { $db->query("ALTER TABLE {$tablepre}{$table} DROP $field2", 'SILENT'); $query .= "ADD $sql"; } elseif(!$fieldexist && !$field2exist) { $query .= "ADD $sql"; } $successed = $db->query($query); } elseif($action == 'ADD') { $query .= $fieldexist ? "CHANGE $field $field $sql" : "ADD $field $sql"; $successed = $db->query($query); } elseif($action == 'DROP') { if($fieldexist) { $successed = $db->query("$query DROP $field", "SILENT"); } $successed = TRUE; } } else { $successed = 'TABLE NOT EXISTS'; } } return $successed; } function loadtable($table, $force = 0) { global $db, $tablepre, $dbcharset; static $tables = array(); if(!isset($tables[$table]) || $force) { if($db->version() > '4.1') { $query = $db->query("SHOW FULL COLUMNS FROM {$tablepre}$table", 'SILENT'); } else { $query = $db->query("SHOW COLUMNS FROM {$tablepre}$table", 'SILENT'); } while($field = @$db->fetch_array($query)) { $tables[$table][$field['Field']] = $field; } } return $tables[$table]; } function upg_adminactions() { global $db, $tablepre; $actionarray = array( 'settings' => 'settings', 'forumsedit' => 'forums', 'forumdetail' => 'forums_edit', 'moderators' => 'forums_moderators', 'forumdelete' => 'forums_delete', 'forumsmerge' => 'forums_merge', 'forumcopy' => 'forums_copy', 'threadtypes' => 'threadtypes', 'members' => 'members', 'forumadd' => 'members_add', 'editgroups' => 'members_editgroups', 'access' => 'members_access', 'editcredits' => 'members_editcredits', 'editmedals' => 'members_editmedals', 'memberprofile' => 'members_profile', 'profilefields' => 'members_profilefields', 'ipban' => 'members_ipban', 'membersmerge' => 'members_merge', 'usergroups' => 'groups_user', 'admingroups' => 'groups_admin', 'ranks' => 'groups_ranks', 'styles' => 'styles', 'templates' => 'templates', 'tpladd' => 'templates_add', 'tpledit' => 'templates_edit', 'modmembers' => 'moderate_members', 'modthreads' => 'moderate_threads', 'modreplies' => 'moderate_replies', 'threads' => 'threads', 'prune' => 'prune', 'recyclebin' => 'recyclebin', 'announcements' => 'announcements', 'forumlinks' => 'misc_forumlinks', 'onlinelist' => 'misc_onlinelist', 'censor' => 'misc_censor', 'discuzcodes' => 'misc_discuzcodes', 'tags' => 'misc_tags', 'smilies' => 'smilies', 'icons' => 'misc_icons', 'attachtypes' => 'misc_attachtypes', 'crons' => 'misc_crons', 'adv' => 'advertisements', 'advadd' => 'advertisements_add', 'advedit' => 'advertisements_edit', 'runquery' => 'database_runquery', 'optimize' => 'database_optimize', 'export' => 'database_export', 'import' => 'database_import', 'updatecache' => 'tools_updatecache', 'fileperms' => 'tools_fileperms', 'relatedtag' => 'tools_relatedtag', 'attachments' => 'attachments', 'counter' => 'counter', 'jswizard' => 'jswizard', 'creditwizard' => 'creditwizard', 'google_config' => 'google_config', 'qihoo_config' => 'qihoo_config', 'qihoo_topics' => 'qihoo_topics', 'alipay' => 'ecommerce_alipay', 'orders' => 'ecommerce_orders', 'medals' => 'medals', 'plugins' => 'plugins', 'pluginsconfig' => 'plugins_config', 'pluginsedit' => 'plugins_edit', 'pluginhooks' => 'plugins_hooks', 'pluginvars' => 'plugins_vars', 'illegallog' => 'logs_illegal', 'ratelog' => 'logs_rate', 'modslog' => 'logs_mods', 'medalslog' => 'logs_medals', 'banlog' => 'logs_ban', 'cplog' => 'logs_cp', 'creditslog' => 'logs_credits', 'errorlog' => 'logs_error' ); $da = array(); $query = $db->query("SELECT * FROM {$tablepre}adminactions"); while($a = $db->fetch_array($query)) { if($a['disabledactions']) { $da = @unserialize($a['disabledactions']); if(is_array($da) && $da) { foreach($da as $k => $v) { if(isset($actionarray[$v])) { $da[$k] = $actionarray[$v]; } else { unset($da[$k]); } } } else { $da = array(); } $db->query("UPDATE {$tablepre}adminactions SET disabledactions='".addslashes(serialize($da))."' WHERE admingid='$a[admingid]'"); } } } function upg_insenz() { global $db, $tablepre; $insenz = $db->result_first("SELECT value FROM {$tablepre}settings WHERE variable='insenz'"); $insenz = $insenz ? unserialize($insenz) : array(); if($insenz) { if($insenz['admin_masks'] && is_array($insenz['admin_masks'])) { $insenz['admin_masks'] = array_keys($insenz['admin_masks']); } if($insenz['member_masks'] && is_array($insenz['member_masks'])) { $insenz['member_masks'] = array_keys($insenz['member_masks']); } $db->query("REPLACE INTO {$tablepre}settings (variable, value) VALUES ('insenz', '".addslashes(serialize($insenz))."')"); } } function upg_js() { global $db, $tablepre; $request_tpl = array( 0 => '

   本版热门主题

   [node]
   • [{author}]{subject}
   [/node]
   ', 1 => '

   今日热门主题

   [node]
   • [{author}]{subject}
   [/node]
   ', 2 => '

   本版最新回复

   [node]
   • {subject} ({replies}/{views})
   [/node]
   ', 3 => '

   活跃用户

   [node]
   • {avatarsmall}

     {member}

   [/node]
   ', ); $request_data = array ( 'default_hotthreads' => array ( 'url' => 'function=threads&sidestatus=1&maxlength=50&fnamelength=0&messagelength=&startrow=0&picpre=&items=10&tag=&tids=&special=0&rewardstatus=&digest=0&stick=0&recommend=0&newwindow=1&threadtype=0&highlight=0&orderby=views&hours=0&jscharset=0&cachelife=900&jstemplate='.rawurlencode($request_tpl[0]), 'parameter' => array ( 'jstemplate' => $request_tpl[0], 'cachelife' => '900', 'sidestatus' => '1', 'startrow' => '0', 'items' => '10', 'maxlength' => '50', 'fnamelength' => '0', 'messagelength' => '', 'picpre' => '', 'tids' => '', 'keyword' => '', 'tag' => '', 'threadtype' => '0', 'highlight' => '0', 'recommend' => '0', 'newwindow' => 1, 'orderby' => 'views', 'hours' => '', 'jscharset' => '0', ), 'comment' => '本版热门主题', 'type' => '0', ), 'default_hotthreads24hrs' => array ( 'url' => 'function=threads&sidestatus=0&maxlength=50&fnamelength=0&messagelength=&startrow=0&picpre=&items=10&tag=&tids=&special=0&rewardstatus=&digest=0&stick=0&recommend=0&newwindow=1&threadtype=0&highlight=0&orderby=hourviews&hours=24&jscharset=0&jstemplate='.rawurlencode($request_tpl[1]), 'parameter' => array ( 'jstemplate' => $request_tpl[1], 'cachelife' => '', 'sidestatus' => '0', 'startrow' => '0', 'items' => '10', 'maxlength' => '50', 'fnamelength' => '0', 'messagelength' => '', 'picpre' => '', 'tids' => '', 'keyword' => '', 'tag' => '', 'threadtype' => '0', 'highlight' => '0', 'recommend' => '0', 'newwindow' => 1, 'orderby' => 'hourviews', 'hours' => '24', 'jscharset' => '0', ), 'comment' => '今日热门主题', 'type' => '0', ), 'default_newreplies' => array ( 'url' => 'function=threads&sidestatus=1&maxlength=50&fnamelength=0&messagelength=&startrow=0&picpre=&items=10&tag=&tids=&special=0&rewardstatus=&digest=0&stick=0&recommend=0&newwindow=1&threadtype=0&highlight=0&orderby=lastpost&hours=0&jscharset=0&cachelife=900&jstemplate='.rawurlencode($request_tpl[2]), 'parameter' => array ( 'jstemplate' => $request_tpl[2], 'cachelife' => '900', 'sidestatus' => '1', 'startrow' => '0', 'items' => '10', 'maxlength' => '50', 'fnamelength' => '0', 'messagelength' => '', 'picpre' => '', 'tids' => '', 'keyword' => '', 'tag' => '', 'threadtype' => '0', 'highlight' => '0', 'recommend' => '0', 'newwindow' => 1, 'orderby' => 'lastpost', 'hours' => '', 'jscharset' => '0', ), 'comment' => '本版最新回复', 'type' => '0', ), 'default_hotmembers' => array ( 'url' => 'function=memberrank&startrow=0&items=9&newwindow=1&extcredit=1&orderby=posts&hours=0&jscharset=0&cachelife=1800&jstemplate='.rawurlencode($request_tpl[3]), 'parameter' => array ( 'jstemplate' => $request_tpl[3], 'cachelife' => '1800', 'startrow' => '0', 'items' => '9', 'newwindow' => 1, 'extcredit' => '1', 'orderby' => 'posts', 'hours' => '', 'jscharset' => '0', ), 'comment' => '活跃用户', 'type' => '2', ), '边栏1' => array ( 'url' => 'function=side&jscharset=&jstemplate=%5Bmodule%5Ddefault_hotthreads%5B%2Fmodule%5D%5Bmodule%5Ddefault_hotmembers%5B%2Fmodule%5D', 'parameter' => array ( 'selectmodule' => array ( 0 => 'default_hotthreads', 1 => 'default_hotmembers', ), 'cachelife' => '', 'jstemplate' => '[module]default_hotthreads[/module][module]default_hotmembers[/module]', ), 'comment' => NULL, 'type' => '-2', ), '边栏2' => array ( 'url' => 'function=side&jscharset=&jstemplate=%5Bmodule%5Ddefault_newreplies%5B%2Fmodule%5D%5Bmodule%5Ddefault_hotthreads24hrs%5B%2Fmodule%5D', 'parameter' => array ( 'selectmodule' => array ( 0 => 'default_newreplies', 1 => 'default_hotthreads24hrs', ), 'cachelife' => '', 'jstemplate' => '[module]default_newreplies[/module][module]default_hotthreads24hrs[/module]', ), 'comment' => NULL, 'type' => '-2', ), ); $query = $db->query("SELECT variable, value FROM {$tablepre}settings WHERE variable like 'jswizard_%'"); while($data = $db->fetch_array($query)) { $variable = substr($data['variable'], 9); $value = unserialize($data['value']); $type = $value['type']; $value = addslashes(serialize($value)); $db->query("INSERT INTO {$tablepre}request (variable, value, type) VALUES ('$variable', '$value', '$type')"); } foreach($request_data as $k => $v) { $variable = $k; $type = $v['type']; $value = addslashes(serialize($v)); $db->query("REPLACE INTO {$tablepre}request (variable, value, type) VALUES ('$variable', '$value', '$type')"); } $query = $db->query("DELETE FROM {$tablepre}settings WHERE variable like 'jswizard_%'"); } ?>