📄 upgrade11.php
字号:
if(!$total || $total <= $start) {
instmsg("分类信息处理完毕。", "?step=8");
}
$query = $db->query("SELECT DISTINCT(tid), sortid FROM {$tablepre}typeoptionvars LIMIT $start, $limit");
while($sort = $db->fetch_array($query)) {
$tid = $sort['tid'];
$sortid = $sort['sortid'];
$db->query("UPDATE {$tablepre}threads SET sortid='$sortid', typeid='0' WHERE tid='$tid'", 'UNBUFFERED');
}
$end = $start + $limit;
instmsg("分类信息已处理 $start / $total ...", "?step=7&start=$end&total=$total");
} elseif($step == 8) {
echo "<h4>处理分类信息版块数据转换</h4>";
$threadtypes = $threadsorts = array();
$query = $db->query("SELECT fid, threadtypes FROM {$tablepre}forumfields");
while($thread = $db->fetch_array($query)) {
if($thread['threadtypes']) {
$threadtypes[$thread['fid']] = unserialize($thread['threadtypes']);
}
}
if($threadtypes) {
foreach($threadtypes as $fid => $thread) {
if($thread['types']) {
foreach($thread['types'] as $typeid => $name) {
if($sortname = $db->result_first("SELECT name FROM {$tablepre}threadtypes WHERE typeid='$typeid' AND special='1'")) {
$threadsorts[$fid]['types'][$typeid] = $threadsorts[$fid]['flat'][$typeid] = $name;
}
}
}
$threadsorts[$fid]['listable'] = $threadsorts[$fid]['prefix'] = 1;
$threadsorts[$fid]['required'] = $threadsorts[$fid]['selectbox'] = '';
}
}
if($threadsorts) {
foreach($threadsorts as $fid => $data) {
$db->query("UPDATE {$tablepre}forumfields SET threadsorts='".addslashes(serialize($data))."' WHERE fid='$fid'");
}
}
instmsg("分类信息处理完毕。", "?step=9");
instfooter();
} elseif($step == 9) {
echo "<h4>处理论坛风格</h4>";
$db->query("REPLACE INTO {$tablepre}styles VALUES ('1','默认风格','1','1')");
$db->query("DELETE FROM {$tablepre}stylevars WHERE styleid='1'");
$db->query("REPLACE INTO {$tablepre}stylevars (styleid, variable, substitute) VALUES
('1', 'stypeid', '1'),
('1', 'available', ''),
('1', 'boardimg', 'logo.gif'),
('1', 'imgdir', ''),
('1', 'styleimgdir', ''),
('1', 'font', 'Verdana, Helvetica, Arial, sans-serif'),
('1', 'fontsize', '12px'),
('1', 'smfont', 'Verdana, Helvetica, Arial, sans-serif'),
('1', 'smfontsize', '0.83em'),
('1', 'tabletext', '#444'),
('1', 'midtext', '#666'),
('1', 'lighttext', '#999'),
('1', 'link', '#000'),
('1', 'highlightlink', '#09C'),
('1', 'noticetext', '#F60'),
('1', 'msgfontsize', '14px'),
('1', 'msgbigsize', '16px'),
('1', 'bgcolor', '#0D2345 bodybg.gif repeat-x 0 90px'),
('1', 'sidebgcolor', '#FFF sidebg.gif repeat-y 100% 0'),
('1', 'headerborder', '1px'),
('1', 'headerbordercolor', '#00B2E8'),
('1', 'headerbgcolor', '#00A2D2 header.gif repeat-x 0 100%'),
('1', 'headertext', '#97F2FF'),
('1', 'footertext', '#8691A2'),
('1', 'menuborder', '#B0E4EF'),
('1', 'menubgcolor', '#EBF4FD mtabbg.gif repeat-x 0 100%'),
('1', 'menutext', '#666'),
('1', 'menuhover', '#1E4B7E'),
('1', 'menuhovertext', '#C3D3E4'),
('1', 'wrapwidth', '960px'),
('1', 'wrapbg', '#FFF'),
('1', 'wrapborder', '0'),
('1', 'wrapbordercolor', ''),
('1', 'contentwidth', '600px'),
('1', 'contentseparate', '#D3E8F2'),
('1', 'inputborder', '#CCC'),
('1', 'inputborderdarkcolor', '#999'),
('1', 'inputbg', '#FFF'),
('1', 'commonborder', '#E6E7E1'),
('1', 'commonbg', '#F7F7F7'),
('1', 'specialborder', '#E3EDF5'),
('1', 'specialbg', '#EBF2F8'),
('1', 'interleavecolor', '#F5F5F5'),
('1', 'dropmenuborder', '#7FCAE2'),
('1', 'dropmenubgcolor', '#FEFEFE'),
('1', 'floatmaskbgcolor', '#7FCAE2'),
('1', 'floatbgcolor', '#F1F5FA');");
$db->query("UPDATE {$tablepre}settings SET value='1' WHERE variable='styleid'");
$db->query("UPDATE {$tablepre}members SET styleid='0'");
$db->query("UPDATE {$tablepre}styles SET available='0' WHERE styleid<>'$newstyleid'");
$db->query("UPDATE {$tablepre}settings SET value='8' WHERE variable='smcols' AND value<'8'");
$db->query("UPDATE {$tablepre}settings SET value='5' WHERE variable='smrows' AND value<'5'");
instmsg("论坛风格处理完毕。", "?step=10");
instfooter();
} else {
require_once DISCUZ_ROOT.'./uc_client/client.php';
$uc_input = uc_api_input("action=updatecache");
dir_clear('./forumdata/cache');
dir_clear('./forumdata/templates');
dir_clear('./uc_client/data/cache');
@touch($lock_file);
if(!@unlink('upgrade11.php')) {
echo '<br />恭喜您论坛数据升级成功，接下来请您：<ol><li><b>必删除本程序</b>';
} else {
echo '<br />恭喜您论坛数据升级成功，接下来请您：<ol>';
}
if(!defined('UC_CONNECT') || UC_CONNECT != 'mysql') {
if(is_dir(DISCUZ_ROOT.'./forumdata/upgsecques/')) {
echo '<li><b><font color="red">请将目录 : '.DISCUZ_ROOT.'./forumdata/ 下 upgsecques 目录上传至 '.UC_API.'/data/下，之后<a href="'.UC_API.'/upgrade/upgrade2.php?action=upgsecques" target="_blank">点击这里</a><br />或者浏览器直接访问一下地址：'.UC_API.'/upgrade/upgrade2.php?action=upgsecques<br />此操作会将论坛设定的安全提问升级到 UCenter ，如果没有执行此步骤，所有设定了安全提问的会员在登陆的时候均无需输入安全提问即可登陆。</font></b></li>';
}
}
echo '<li><b><font color="red">如果您开启过远程附件那么请参考这个帖子对远程附件进行升级：<a href="http://www.discuz.net/thread-1107842-1-1.html" target="_blank">http://www.discuz.net/thread-1107842-1-1.html</a></font></b>';
echo '<li>使用管理员身份登录论坛，进入后台，更新缓存'.
'<li>进行论坛注册、登录、发贴等常规测试，看看运行是否正常<br /><br />'.
'<b>感谢您选用我们的产品！</b><a href="index.php" target="_blank">您现在可以访问论坛，查看升级情况</a><iframe width="0" height="0" src="index.php"></iframe>';
instfooter();
}
function send_sql_to_uc($sql) {
$url = UC_API.'/accept_sql.php?appid='.UC_APPID.'&uckey='.UC_KEY.'&sql='.urlencode($sql);
return file_get_contents($url);
}
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 "<html><head>".
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=$charset\">".
"<title>$version[old] >> $version[new] 升级向导</title>".
"<style type=\"text/css\">
a {
color: #3A4273;
text-decoration: none
}
a:hover {
color: #3A4273;
text-decoration: underline
}
body, table, td {
color: #3A4273;
font-family: Tahoma, Verdana, Arial;
font-size: 12px;
line-height: 20px;
scrollbar-base-color: #E3E3EA;
scrollbar-arrow-color: #5C5C8D
}
input {
color: #085878;
font-family: Tahoma, Verdana, Arial;
font-size: 12px;
background-color: #3A4273;
color: #FFFFFF;
scrollbar-base-color: #E3E3EA;
scrollbar-arrow-color: #5C5C8D
}
.install {
font-family: Arial, Verdana;
font-size: 20px;
font-weight: bold;
color: #000000
}
.message {
background: #E3E3EA;
padding: 20px;
}
.altbg1 {
background: #E3E3EA;
}
.altbg2 {
background: #EEEEF6;
}
.header td {
color: #FFFFFF;
background-color: #3A4273;
text-align: center;
}
.option td {
text-align: center;
}
.redfont {
color: #FF0000;
}
</style>
<script type=\"text/javascript\">
function redirect(url) {
window.location=url;
}
function $(id) {
return document.getElementById(id);
}
</script>
</head>".
"<body bgcolor=\"#3A4273\" text=\"#000000\"><div id=\"append_parent\"></div>".
"<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\" align=\"center\"><tr><td>".
"<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tr>".
"<td class=\"install\" height=\"30\" valign=\"bottom\"><font color=\"#FF0000\">>></font> $version[old] >> $version[new] 升级向导 ".
"</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr><tr><td colspan=\"2\">";
}
function instfooter() {
global $version;
echo "</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr>".
"<tr><td align=\"center\">".
"<b style=\"font-size: 11px\">Powered by <a href=\"http://discuz.net\" target=\"_blank\">Discuz!".
"</a> Copyright © <a href=\"http://www.comsenz.com\" target=\"_blank\">Comsenz Inc.</a> 2001-2009</b><br /><br />".
"</td></tr></table></td></tr></table>".
"</body></html>";
}
function instmsg($message, $url_forward = '', $postdata = '') {
global $lang, $msglang;
$message = $msglang[$message] ? $msglang[$message] : $message;
if($postdata) {
$message .= "<br /><br /><br /><a href=\"###\" onclick=\"document.getElementById('postform').submit();\">$msglang[redirect_msg]</a>";
echo '<form action="'.$url_forward.'" method="post" id="postform">';
echo $postdata;
echo "<tr><td style=\"padding-top:50px; padding-bottom:100px\"><table width=\"560\" cellspacing=\"1\" bgcolor=\"#000000\" border=\"0\" align=\"center\">".
"<tr bgcolor=\"#3A4273\"><td width=\"20%\" style=\"color: #FFFFFF; padding-left: 10px\">$lang[error_message]</td></tr>".
"<tr align=\"center\" bgcolor=\"#E3E3EA\"><td class=\"message\">$message</td></tr></table></td></tr>";
echo '</form><script>setTimeout("document.getElementById(\'postform\').submit()", 1250);</script>';
instfooter();
} else {
if($url_forward) {
$message .= "<br /><br /><br /><a href=\"$url_forward\">$msglang[redirect_msg]</a>";
$message .= "<script>setTimeout(\"redirect('$url_forward');\", 1250);</script>";
} elseif(strpos($message, $lang['return'])) {
$message .= "<br /><br /><br /><a href=\"javascript:history.go(-1);\" class=\"mediumtxt\">$lang[message_return]</a>";
}
echo "<tr><td style=\"padding-top:50px; padding-bottom:100px\"><table width=\"560\" cellspacing=\"1\" bgcolor=\"#000000\" border=\"0\" align=\"center\">".
"<tr bgcolor=\"#3A4273\"><td width=\"20%\" style=\"color: #FFFFFF; padding-left: 10px\">$lang[error_message]</td></tr>".
"<tr align=\"center\" bgcolor=\"#E3E3EA\"><td class=\"message\">$message</td></tr></table></td></tr>";
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) {
if($directory = dir($dir)) {
while($entry = $directory->read()) {
$filename = $dir.'/'.$entry;
if(is_file($filename)) {
@unlink($filename);
}
}
@touch($dir.'/index.htm');
$directory->close();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -