数据库('.$dbname.')的字符集统计：
| gbk字段 | big5字段 | utf8字段 | latin1字段 |
|---|
| '.$chars[gbk].' | '.$chars[big5].' | '.$chars[utf8].' | '.$chars[latin1].' |
下列字段可能存在编码设置异常：
';
?>
$num) {
if ($char != $maincharset) {
if(is_array($tableschar[$char])) {
echo '
';
echo '
';
} else {
errorpage('MySQL数据库版本在4.1以下，没有字符集设定，无需检测', '', 0, 0);
}
htmlfooter();
} elseif ($action == 'dz_doctor') {
htmlheader();
echo "";
function http_fopen($host, $path, $port="80") {
global $target_fsockopen;
$conn_host = $target_fsockopen == 1 ? gethostbyname($host) : $host;
$conn_port = $port;
$abs_url = "http://$host:$port$path";
$query="GET $abs_url HTTP/1.0\r\n".
"HOST:$host:$port\r\n".
"User-agent:PHP/class http 0.1\r\n".
"\r\n";
$fp=fsockopen($conn_host, $conn_port);
if(!$fp){
return false;
}
fputs($fp,$query);
$contents = "";
while (!feof($fp)) {
$contents .= fread($fp, 1024);
}
fclose($fp);
$array = split("\n\r", $contents, "2");
return trim($array[1]);
}
$ok_style_s = '[color=RoyalBlue][b]';
$error_style_s = '[color=Red][b]';
$style_e = '[/b][/color]';
$title_style_s = '[b]';
$title_style_e = '[/b]';
function create_checkfile() {
global $dir,$whereis;
if($whereis=='is_dz') {
$fp = @fopen('./forumdata/checkfile.php',w);
$includedir = $dir != './' ? str_replace('forumdata/','./',$dir) : '../';
$content = "";
} elseif($whereis=='is_uch') {
$fp = @fopen('./data/checkfile.php',w);
$includedir = $dir != './' ? str_replace('data/','./',$dir) : '../';
$content = "";
} elseif($whereis=='is_uc') {
$fp = @fopen('./data/checkfile.php',w);
$includedir = $dir != './' ? str_replace('data/','./',$dir) : '../';
$content = "";
} elseif($whereis=='is_ss') {
$fp = @fopen('./data/checkfile.php',w);
$includedir = $dir != './' ? str_replace('data/','./',$dir) : '../';
$content = "";
}
fwrite($fp, $content);
fclose($fp);
}
if($whereis=='is_dz'){
$phpfile_array = array('discuzroot', 'templates', 'cache');
$dir_array = array('论坛根目录', '模板缓存目录(forumdata/templates)', '其它缓存目录(forumdata/cache)');
$doctor_top = count($phpfile_array) - 1;
if(@!include("./config.inc.php")) {
if(@!include("./config.php")) {
cexit("
请先上传config文件以保证您的数据库能正常链接！
");
}
}
}elseif($whereis=='is_uch'){
$phpfile_array = array('homeroot', 'data/tpl_cache','data/temp');
$dir_array = array('家园根目录', '模板缓存目录(data/tpl_cache)','模板缓存目录(data/temp)');
$doctor_top = count($phpfile_array) - 1;
if(@!include("config.inc.php")) {
if(@!include("config.php")) {
cexit("
请先上传config文件以保证您的数据库能正常链接！
");
}
}
}elseif($whereis=='is_uc') {
$phpfile_array = array('ucenterroot', 'data/cache','data/view');
$dir_array = array('UCenter根目录', '模板缓存目录(data/cache)','模板缓存目录(data/view)');
$doctor_top = count($phpfile_array) - 1;
if(@!include("data/config.inc.php")) {
if(@!include("data/config.php")) {
cexit("
请先上传config文件以保证您的数据库能正常链接！
");
}
}
} elseif($whereis=='is_ss') {
$phpfile_array = array('supesiteroot', 'data','cache');
$dir_array = array('门户根目录', '模板缓存目录(cache/tpl)','模板缓存目录(cache/model)');
$doctor_top = count($phpfile_array) - 1;
if(@!include("config.inc.php")) {
if(@!include("config.php")) {
cexit("
请先上传config文件以保证您的数据库能正常链接！
");
}
}
}
if($doctor_step == $doctor_top) {
$carray = $clang = $comment = array();
$doctor_config = $doctor_config_db = '';
if($whereis=='is_dz'){
$configfilename = file_exists('./config.inc.php') ? './config.inc.php' : './config.php';
$fp = @fopen($configfilename, 'r');
$configfile = @fread($fp, @filesize($configfilename));
@fclose($fp);
preg_match_all("/[$]([\w\[\]\']+)\s*\=\s*[\"']?(.*?)[\"']?;/is", $configfile, $cmatch);
foreach($cmatch[1] as $key => $var) {
if(!in_array($var, array('database','adminemail','admincp'))) {
$carray[$var] = $cmatch[2][$key];
}
}
$clang = array(
'dbhost' => '数据库服务器',
'dbuser' => '数据库用户名',
'dbpw' => '数据库密码',
'dbname' => '数据库名',
'pconnect' => '数据库是否持久连接',
'cookiepre' => 'cookie 前缀',
'cookiedomain' => 'cookie 作用域',
'cookiepath' => 'cookie 作用路径',
'tablepre' => '表名前缀',
'dbcharset' => 'MySQL链接字符集',
'charset' => '论坛字符集',
'headercharset' => '强制论坛页面使用默认字符集',
'tplrefresh' => '论坛风格模板自动刷新开关',
'forumfounders' => '论坛创始人uid',
'dbreport' => '是否发送错误报告给管理员',
'errorreport' => '是否屏蔽程序错误信息',
'attackevasive' => '论坛防御级别',
'admincp[\'forcesecques\']' => '管理人员是否必须设置安全提问才能进入系统设置',
'admincp[\'checkip\']' => '后台管理操作是否验证管理员的 IP',
'admincp[\'tpledit\']' => '是否允许在线编辑论坛模板',
'admincp[\'runquery\']' => '是否允许后台运行 SQL 语句',
'admincp[\'dbimport\']' => '是否允许后台恢复论坛数据',
);
$comment = array(
'pconnect' => '非持久连接',
'cookiepre' => '不检测',
'cookiepath' => '不检测',
'charset' => '不检测',
'adminemail' => '不检测',
'admincp' => '非设置项',
);
@mysql_connect($carray['dbhost'], $carray['dbuser'], $carray['dbpw']) or $mysql_errno = mysql_errno();
!$mysql_errno && @mysql_select_db($carray['dbname']) or $mysql_errno = mysql_errno();
$comment_error = "{$error_style_s}出错{$style_e}";
if ($mysql_errno == '2003') {
$comment['dbhost'] = "{$error_style_s}端口设置出错{$style_e}";
} elseif ($mysql_errno == '2005') {
$comment['dbhost'] = $comment_error;
} elseif ($mysql_errno == '1045') {
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
} elseif ($mysql_errno == '1049') {
$comment['dbname'] = $comment_error;
} elseif (!empty($mysql_errno)) {
$comment['dbhost'] = $comment_error;
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
$comment['dbname'] = $comment_error;
}
$comment['pconnect'] = '非持久链接';
$carray['pconnect'] == 1 && $comment['pconnect'] = '持久连接';
if ($carray['cookiedomain'] && substr($carray['cookiedomain'], 0, 1) != '.') {
$comment['cookiedomain'] = "{$error_style_s}请以 . 开头,不然同步登录会出错{$style_e}";
}
(!$mysql_errno && !mysql_num_rows(mysql_query('SHOW TABLES LIKE \''.$carray['tablepre'].'posts\''))) && $comment['tablepre'] = $comment_error;
if (!$comment['tablepre'] && !$mysql_errno && @mysql_get_server_info() > '4.1') {
$tableinfo = loadtable('threads');
$dzdbcharset = substr($tableinfo['subject']['Collation'], 0, strpos($tableinfo['subject']['Collation'], '_'));
if(!$carray['dbcharset'] && in_array(strtolower($carray['charset']), array('gbk', 'big5', 'utf-8'))) {
$ckdbcharset = str_replace('-', '', $carray['charset']);
} else {
$ckdbcharset = $carray['dbcharset'];
}
if ($dzdbcharset != $ckdbcharset && $ckdbcharset != '') {
$carray['dbcharset'] .= $error_style_s.'出错，您的论坛数据库字符集为 '.$dzdbcharset.' ，请将本项设置成 '.$dzdbcharset.$style_e;
}
}
if(!in_array($carray['charset'],array('gbk', 'big5', 'utf-8'))) {
$carray['charset'] .= $error_style_s." 出错，目前字符集只支持'gbk', 'big5', 'utf-8'".$style_e;
}
if ($carray['headercharset'] == 0) {
$comment['headercharset'] = $title_style_s.'未开启'.$title_style_e;
} else {
$comment['headercharset'] = $ok_style_s.'开启'.$style_e;
}
if ($carray['tplrefresh'] == 0) {
$comment['tplrefresh'] = $title_style_s.'关闭'.$title_style_e;
} else {
$comment['tplrefresh'] = $ok_style_s.'开启'.$style_e;
}
if (preg_match('/[^\d,]/i', str_replace(' ', '', $carray['forumfounders']))) {
$comment['forumfounders'] = $error_style_s.'出错：含有非法字符，该项设置只能含有数字和半角逗号 ,'.$style_e;
} elseif(!$comment['tablepre'] && !$mysql_errno) {
if ($carray['forumfounders']) {
$founderarray = explode(',', str_replace(' ', '', $carray['forumfounders']));
$adminids = $notadminids = '';
$notadmin = 0;
foreach($founderarray as $fdkey) {
if (@mysql_result(@mysql_query("SELECT adminid FROM {$carray[tablepre]}members WHERE uid = '$fdkey' LIMIT 1"), 0) == 1) {
$isadmin ++;
$iscomma = $isadmin > 1 ? ',' : '';
$adminids .= $iscomma.$fdkey;
} else {
$notadmin ++;
$notcomma = $notadmin > 1 ? ',' : '';
$notadminids .= $notcomma.$fdkey;
}
}
if (!$isadmin) {
$comment['forumfounders'] = $error_style_s.'出错：创始人中无管理员'.$style_e;
} elseif ($notadmin) {
$comment['forumfounders'] = $error_style_s.'警告：创始人中有非管理员，uid如下：'.$notadminids.$style_e;
}
} else {
$comment['forumfounders'] = $error_style_s.'警告：创始人设置为空，多个管理员将可能有安全问题'.$style_e;
}
}
$comment['dbreport'] = $carray['dbreport'] == 0 ? '不发送错误报告' : '发送错误报告';
$comment['errorreport'] = $carray['errorreport'] == 1 ? '屏蔽程序错误' : '不屏蔽程序错误';
if (preg_match('/[^\d|]/i', str_replace(' ', '', $carray['attackevasive']))) {
$carray['attackevasive'] .= $error_style_s.'出错：含有非法字符,该项设置只能含有数字和半角逗号,'.$style_e;
} else {
if (preg_match('/[8]/i', $carray['attackevasive']) && @mysql_result(@mysql_query("SELECT COUNT(*) FROM {$carray[tablepre]}members")) < 1) {
$carray['attackevasive'] .= $error_style_s.'出错：您设置了回答问题(8)，但未添加验证问题和答案 ,'.$style_e;
}
}
$comment_admincp_error = "否 > {$error_style_s}警告：有安全隐患{$style_e}";
$comment_admincp_ok = "是 > {$error_style_s}警告：有安全隐患{$style_e}";
if ($carray['admincp[\'forcesecques\']'] == 1) {
$comment['admincp[\'forcesecques\']'] = "{$ok_style_s}是{$style_e}";
} else {
$comment['admincp[\'forcesecques\']'] = $comment_admincp_error;
}
if ($carray['admincp[\'checkip\']'] == 0) {
$comment['admincp[\'checkip\']'] = $comment_admincp_error;
} else {
$comment['admincp[\'checkip\']'] = "{$ok_style_s}是{$style_e}";
}
if ($carray['admincp[\'tpledit\']'] == 1) {
$comment['admincp[\'tpledit\']'] = $comment_admincp_ok;
} else {
$comment['admincp[\'tpledit\']'] = "{$title_style_s}否{$title_style_e}";
}
if ($carray['admincp[\'runquery\']'] == 1) {
$comment['admincp[\'runquery\']'] = $comment_admincp_ok;
} else {
$comment['admincp[\'runquery\']'] = "{$title_style_s}否{$title_style_e}";
}
if ($carray['admincp[\'dbimport\']'] == 1) {
$comment['admincp[\'dbimport\']'] = $comment_admincp_ok;
} else {
$comment['admincp[\'dbimport\']'] = "{$title_style_s}否{$title_style_e}";
}
foreach($carray as $key => $keyfield) {
$clang[$key] == '' && $clang[$key] = ' ';
strpos('comma'.$comment[$key], '警告') && $comment[$key] = $comment[$key];
strpos('comma'.$comment[$key], '出错') && $comment[$key] = $comment[$key];
$comment[$key] == '' && $comment[$key] = "{$ok_style_s}正常{$style_e}";
if(in_array($key, array('dbuser', 'dbpw'))) {
$keyfield = '**隐藏**';
}
$keyfield == '' && $keyfield = '空';
if(!in_array($key, array('dbhost','dbuser','dbpw','dbname'))) {
if(in_array($key, array('pconnect', 'headercharset', 'tplrefresh', 'dbreport', 'errorreport', 'admincp[\'forcesecques\']', 'admincp[\'checkip\']', 'admincp[\'tpledit\']', 'admincp[\'runquery\']', 'admincp[\'dbimport\']'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]\n";
} elseif(in_array($key, array('cookiepre', 'cookiepath', 'cookiedomain', 'charset', 'dbcharset', 'attackevasive'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield\n";
} else {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield ---> $comment[$key]\n";
}
} else {
if(strstr($comment[$key], '出错')) {
strstr($doctor_config_db, '正常') && $doctor_config_db = '';
$doctor_config_db .= "{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]";
} else {
if(empty($doctor_config_db)) {
$doctor_config_db ="\n\t{$ok_style_s}数据库正常链接.{$style_e}";
}
}
}
}
}elseif($whereis=='is_uc'){
$configfilename = file_exists('data/config.inc.php') ? 'data/config.inc.php' : 'data/config.php';
$fp = @fopen($configfilename, 'r');
$configfile = @fread($fp, @filesize($configfilename));
@fclose($fp);
preg_match_all("/define\('(UC_[^']*)'\s*,\s*'(.*)?'\)/i", $configfile, $cmatch);
foreach($cmatch[1] as $key => $var) {
if(!in_array($var, array('database','admincp'))) {
$carray[$var] = $cmatch[2][$key];
}
}
$clang = array(
'UC_DBHOST' => '数据库服务器',
'UC_DBUSER' => '数据库用户名',
'UC_DBPW' => '数据库密码',
'UC_DBNAME' => '数据库名',
'pconnect' => '数据库是否持久连接',
'UC_COOKIEDOMAIN' => 'cookie 作用域',
'UC_COOKIEPATH' => 'cookie 作用路径',
'UC_DBTABLEPRE'=>'表名前缀',
'UC_DBCHARSET' => '数据库字符集',
'UC_CHARSET' =>'ucenter字符集',
'UC_DBCONNECT' =>'数据库持久连接',
);
$comment = array(
'UC_COOKIEPATH' => '不检测',
);
@mysql_connect($carray['UC_DBHOST'], $carray['UC_DBUSER'], $carray['UC_DBPW']) or $mysql_errno = mysql_errno();
!$mysql_errno && @mysql_select_db($carray['UC_DBNAME']) or $mysql_errno = mysql_errno();
$comment_error = "{$error_style_s}出错{$style_e}";
if ($mysql_errno == '2003') {
$comment['UC_DBHOST'] = "{$error_style_s}端口设置出错{$style_e}";
} elseif ($mysql_errno == '2005') {
$comment['UC_DBHOST'] = $comment_error;
} elseif ($mysql_errno == '1045') {
$comment['UC_DBUSER'] = $comment_error;
$comment['UC_DBPW'] = $comment_error;
} elseif ($mysql_errno == '1049') {
$comment['UC_DBNAME'] = $comment_error;
} elseif (!empty($mysql_errno)) {
$comment['UC_DBHOST'] = $comment_error;
$comment['UC_DBUSER'] = $comment_error;
$comment['UC_DBPW'] = $comment_error;
$comment['UC_DBNAME'] = $comment_error;
}
$comment['pconnect'] = '非持久链接';
$carray['pconnect'] == 1 && $comment['pconnect'] = '持久连接';
if ($carray['UC_COOKIEDOMAIN'] && substr($carray['UC_COOKIEDOMAIN'], 0, 1) != '.') {
$comment['UC_COOKIEDOMAIN'] = "{$error_style_s}请以 . 开头,不然同步登录会出错{$style_e}";
}
(!$mysql_errno && !mysql_num_rows(mysql_query('SHOW TABLES LIKE \''.$carray['UC_DBTABLEPRE'].'members\''))) && $comment['UC_DBTABLEPRE'] = $comment_error;
if (!$comment['UC_DBTABLEPRE'] && !$mysql_errno && @mysql_get_server_info() > '4.1') {
$tableinfo = loadtable_ucenter('members');
$dzdbcharset = substr($tableinfo['secques']['Collation'], 0, strpos($tableinfo['secques']['Collation'], '_'));
if(!$carray['UC_DBCHARSET'] && in_array(strtolower($carray['UC_DBCHARSET']), array('gbk', 'big5', 'utf-8'))) {
$ckdbcharset = str_replace('-', '', $carray['UC_DBCHARSET']);
} else {
$ckdbcharset = $carray['UC_DBCHARSET'];
}
if ($dzdbcharset != $ckdbcharset && $ckdbcharset != '') {
$carray['UC_DBCHARSET'] .= $error_style_s.'出错，数据库字符集为 '.$dzdbcharset.' ，请将本项设置成 '.$dzdbcharset.$style_e;
}
}
if(!in_array($carray['UC_CHARSET'],array('gbk', 'big5', 'utf-8'))) {
$carray['UC_CHARSET'] .= $error_style_s." 出错，目前字符集只支持'gbk', 'big5', 'utf-8'".$style_e;
}
$comment['UC_DBCONNECT'] = $carray['UC_DBCONNECT']==0?'否':'是'; // 数据库持久连接
$comment['UC_CHARSET'] = $carray['UC_CHARSET']; //ucenter的字符集
$comment['UC_DBCHARSET'] = $carray['UC_DBCHARSET']; //数据库字符集
foreach($carray as $key => $keyfield) {
$clang[$key] == '' && $clang[$key] = ' ';
strpos('comma'.$comment[$key], '警告') && $comment[$key] = $comment[$key];
strpos('comma'.$comment[$key], '出错') && $comment[$key] = $comment[$key];
$comment[$key] == '' && $comment[$key] = "{$ok_style_s}正常{$style_e}";
if(in_array($key, array('UC_DBUSER', 'UC_DBPW'))) {
$keyfield = '**隐藏**';
}
$keyfield == '' && $keyfield = '空';
if(!in_array($key, array('UC_DBHOST','UC_DBUSER','UC_DBPW','UC_DBNAME','UC_MYKEY','UC_SITEID','UC_KEY','UC_FOUNDERSALT','UC_FOUNDERPW'))) {
if(in_array($key, array('UC_DBCHARSET','UC_DBCONNECT','UC_CHARSET','UC_DBTABLEPRE'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]\n";
} elseif(in_array($key, array('UC_COOKIEPATH', 'UC_COOKIEDOMAIN' ))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield\n";
} else {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield ---> $comment[$key]\n";
}
} else {
if(strstr($comment[$key], '出错')) {
strstr($doctor_config_db, '正常') && $doctor_config_db = '';
$doctor_config_db .= "{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]";
} else {
if(empty($doctor_config_db)) {
$doctor_config_db ="\n\t{$ok_style_s}数据库正常连接.{$style_e}";
}
}
}
}
}elseif($whereis=='is_uch'){
$configfilename = file_exists('./config.inc.php') ? './config.inc.php' : './config.php';
$fp = @fopen($configfilename, 'r');
$configfile = @fread($fp, @filesize($configfilename));
@fclose($fp);
preg_match_all("/[$]([\w\[\]\']+)\s*\=\s*[\"']?(.*?)[\"']?;/is", $configfile, $cmatch);
foreach($cmatch[1] as $key => $var) {
if(!in_array($var, array('database','admincp'))) {
$carray[substr($var,5,-2)] = $cmatch[2][$key];
}
}
$clang = array(
'dbhost' => '数据库服务器',
'dbuser' => '数据库用户名',
'dbpw' => '数据库密码',
'dbname' => '数据库名',
'pconnect' => '数据库是否持久连接',
'cookiepre' => 'cookie 前缀',
'cookiedomain' => 'cookie 作用域',
'cookiepath' => 'cookie 作用路径',
'tablepre' => '表名前缀',
'dbcharset' => 'MySQL链接字符集',
'charset' => '家园字符集',
'attachdir' => '附件本地保存位置',
'attachurl' => '附件本地URL地址',
'siteurl' => '站点的访问URL地址',
'tplrefresh' => '是判断模板是否更新的效率等级',
'founder' => '创始人 UID',
'allowedittpl' => '是否允许在线编辑模板',
'gzipcompress' => '启用gzip'
);
$comment = array(
'pconnect' => '非持久连接',
'cookiepre' => '不检测',
'cookiepath' => '不检测',
);
@mysql_connect($carray['dbhost'], $carray['dbuser'], $carray['dbpw']) or $mysql_errno = mysql_errno();
!$mysql_errno && @mysql_select_db($carray['dbname']) or $mysql_errno = mysql_errno();
$comment_error = "{$error_style_s}出错{$style_e}";
if ($mysql_errno == '2003') {
$comment['dbhost'] = "{$error_style_s}端口设置出错{$style_e}";
} elseif ($mysql_errno == '2005') {
$comment['dbhost'] = $comment_error;
} elseif ($mysql_errno == '1045') {
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
} elseif ($mysql_errno == '1049') {
$comment['dbname'] = $comment_error;
} elseif (!empty($mysql_errno)) {
$comment['dbhost'] = $comment_error;
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
$comment['dbname'] = $comment_error;
}
$comment['pconnect'] = '非持久链接';
$carray['pconnect'] == 1 && $comment['pconnect'] = '持久连接';
if ($carray['cookiedomain'] && substr($carray['cookiedomain'], 0, 1) != '.') {
$comment['cookiedomain'] = "{$error_style_s}请以 . 开头,不然同步登录会出错{$style_e}";
}
(!$mysql_errno && !mysql_num_rows(mysql_query('SHOW TABLES LIKE \''.$carray['tablepre'].'space\''))) && $comment['tablepre'] = $comment_error;
if (!$comment['tablepre'] && !$mysql_errno && @mysql_get_server_info() > '4.1') {
$tableinfo = loadtable('thread');
$dzdbcharset = substr($tableinfo['subject']['Collation'], 0, strpos($tableinfo['subject']['Collation'], '_'));
if(!$carray['dbcharset'] && in_array(strtolower($carray['charset']), array('gbk', 'big5', 'utf-8'))) {
$ckdbcharset = str_replace('-', '', $carray['charset']);
} else {
$ckdbcharset = $carray['dbcharset'];
}
if ($dzdbcharset != $ckdbcharset && $ckdbcharset != '') {
$carray['dbcharset'] .= $error_style_s.'出错，您的论坛数据库字符集为 '.$dzdbcharset.' ，请将本项设置成 '.$dzdbcharset.$style_e;
}
}
if(!in_array($carray['charset'],array('gbk', 'big5', 'utf-8'))) {
$carray['charset'] .= $error_style_s." 出错，目前字符集只支持'gbk', 'big5', 'utf-8'".$style_e;
}
$comment['attachdir'] = empty($carray['attachdir'])?'此地址为空':$carray['attachdir'] ;
$comment['attachurl'] = empty($carray['attachurl']) ?'此地址为空':$carray['attachurl'];
$comment['allowedittpl'] = $carray['allowedittpl'] == 1 ?'允许在线编辑模板':'允许在线编辑模板';
$comment['tplrefresh'] = $carray['tplrefresh']==1?'模板更新的效率高':'模板更新的效率低';
$comment['gzipcompress'] = $carray['gzipcompress'] ==0?'启用gzip':'不启用gzip';
foreach($carray as $key => $keyfield) {
$clang[$key] == '' && $clang[$key] = ' ';
strpos('comma'.$comment[$key], '警告') && $comment[$key] = $comment[$key];
strpos('comma'.$comment[$key], '出错') && $comment[$key] = $comment[$key];
$comment[$key] == '' && $comment[$key] = "{$ok_style_s}正常{$style_e}";
if(in_array($key, array('dbuser', 'dbpw'))) {
$keyfield = '**隐藏**';
}
$keyfield == '' && $keyfield = '空';
if(!in_array($key, array('dbhost','dbuser','dbpw','dbname','founder'))) {
if(in_array($key, array('pconnect', 'allowedittpl', 'attachdir', 'attachurl', 'siteurl', 'tplrefresh', 'founder'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]\n";
} elseif(in_array($key, array('cookiepre', 'cookiepath', 'cookiedomain', 'charset', 'dbcharset', 'attackevasive'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield\n";
} else {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield ---> $comment[$key]\n";
}
} else {
if(strstr($comment[$key], '出错')) {
strstr($doctor_config_db, '正常') && $doctor_config_db = '';
$doctor_config_db .= "{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]";
} else {
if(empty($doctor_config_db)) {
$doctor_config_db ="\n\t{$ok_style_s}数据库正常链接.{$style_e}";
}
}
}
}
}elseif($whereis=='is_ss'){
$configfilename = file_exists('./config.inc.php') ? './config.inc.php' : './config.php';
$fp = @fopen($configfilename, 'r');
$configfile = @fread($fp, @filesize($configfilename));
@fclose($fp);
preg_match_all("/[$]([\w\[\]\']+)\s*\=\s*[\"']?(.*?)[\"']?;/is", $configfile, $cmatch);
foreach($cmatch[1] as $key => $var) {
if(!in_array($var, array('database','mailcfg'))) {
$carray[$var] = $cmatch[2][$key];
}
}
$clang = array(
'dbhost' => '数据库服务器',
'dbuser' => '数据库用户名',
'dbpw' => '数据库密码',
'dbname' => '数据库名',
'pconnect' => '数据库是否持久连接',
'cookiepre' => 'cookie 前缀',
'cookiedomain' => 'cookie 作用域',
'cookiepath' => 'cookie 作用路径',
'tablepre' => '表名前缀',
'dbcharset' => 'MySQL链接字符集',
'charset' => '论坛字符集',
'headercharset' => '强制使用默认字符集',
'sendmail_silent' => '屏蔽邮件发送中的全部错误提示',
'uploadimgpernum' => '用户创建图片主题,一次可以上传的图片数目',
'blackgroupids' => '不能自动拥有空间的用户组ID黑名单',
'bbsver' => '论坛版本',
'perspacenum' => '数据库个人空间缓存表分表设置',
'xsdomain' => 'XS免费域名服务器',
'red5_server' =>'RED5服务器',
'socket_server' =>'socket服务器',
'socket_port' => 'socket端口范围',
'cachemode' => '站点缓存存放模式',
'tplrefresh' => '风格模板自动刷新开关',
'cachegrade' => '系统缓存分表等级',
'ucmode' => '用户中心模式',
'siteurl' => 'SupeSite/X-Space程序文件所在目录的URL访问地址',
'bbsurl' => '论坛URL地址',
'bbsattachurl' => '论坛附件目录URL地址'
);
$comment = array(
'pconnect' => '非持久连接',
'cookiepre' => '不检测',
'cookiepath' => '不检测',
'charset' => '不检测',
'adminemail' => '不检测',
);
@mysql_connect($carray['dbhost'], $carray['dbuser'], $carray['dbpw']) or $mysql_errno = mysql_errno();
!$mysql_errno && @mysql_select_db($carray['dbname']) or $mysql_errno = mysql_errno();
$comment_error = "{$error_style_s}出错{$style_e}";
if ($mysql_errno == '2003') {
$comment['dbhost'] = "{$error_style_s}端口设置出错{$style_e}";
} elseif ($mysql_errno == '2005') {
$comment['dbhost'] = $comment_error;
} elseif ($mysql_errno == '1045') {
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
} elseif ($mysql_errno == '1049') {
$comment['dbname'] = $comment_error;
} elseif (!empty($mysql_errno)) {
$comment['dbhost'] = $comment_error;
$comment['dbuser'] = $comment_error;
$comment['dbpw'] = $comment_error;
$comment['dbname'] = $comment_error;
}
$comment['pconnect'] = '非持久链接';
$carray['pconnect'] == 1 && $comment['pconnect'] = '持久连接';
if ($carray['cookiedomain'] && substr($carray['cookiedomain'], 0, 1) != '.') {
$comment['cookiedomain'] = "{$error_style_s}请以 . 开头,不然同步登录会出错{$style_e}";
}
(!$mysql_errno && !mysql_num_rows(mysql_query('SHOW TABLES LIKE \''.$carray['tablepre'].'members\''))) && $comment['tablepre'] = $comment_error;
if (!$comment['tablepre'] && !$mysql_errno && @mysql_get_server_info() > '4.1') {
$tableinfo = loadtable('members');
$dzdbcharset = substr($tableinfo['secques']['Collation'], 0, strpos($tableinfo['secques']['Collation'], '_'));
if(!$carray['dbcharset'] && in_array(strtolower($carray['charset']), array('gbk', 'big5', 'utf-8'))) {
$ckdbcharset = str_replace('-', '', $carray['charset']);
} else {
$ckdbcharset = $carray['dbcharset'];
}
if ($dzdbcharset != $ckdbcharset && $ckdbcharset != '') {
$carray['dbcharset'] .= $error_style_s.'出错，您的论坛数据库字符集为 '.$dzdbcharset.' ，请将本项设置成 '.$dzdbcharset.$style_e;
}
}
if(!in_array($carray['charset'],array('gbk', 'big5', 'utf-8'))) {
$carray['charset'] .= $error_style_s." 出错，目前字符集只支持'gbk', 'big5', 'utf-8'".$style_e;
}
if ($carray['headercharset'] == 0) {
$comment['headercharset'] = $title_style_s.'未开启'.$title_style_e;
} else {
$comment['headercharset'] = $ok_style_s.'开启'.$style_e;
}
if ($carray['tplrefresh'] == 0) {
$comment['tplrefresh'] = $title_style_s.'关闭'.$title_style_e;
} else {
$comment['tplrefresh'] = $ok_style_s.'开启'.$style_e;
}
$comment['siteurl'] = $carray['siteurl']; //SupeSite/X-Space程序文件所在目录的URL访问地址
$comment['bbsurl'] = $carray['bbsurl']; //论坛URL地址
$comment['bbsattachurl'] = empty($carray['bbsattachurl'])?'为空为默认地址':$carray['bbsattachurl'];//论坛附件目录URL地址
$comment['sendmail_silent']= $carray['sendmail_silent']==0?'否':'是';//屏蔽邮件发送中的全部错误提示, 1=是, 0=否
$comment['uploadimgpernum']= $carray['uploadimgpernum']; //用户创建图片主题,一次可以上传的图片数目
$comment['blackgroupids'] = $carray['blackgroupids']; //不能拥有空间的用户组ID黑名单
$comment['bbsver'] = 'Discuz!'.$carray['bbsver']; //论坛版本
$comment['perspacenum'] = $carray['perspacenum']==0?'不启用':$carray['perspacenum']; //数据库个人空间缓存分表设置
$comment['xsdomain'] = $carray['xsdomain']; //xs免费域名服务器
$comment['red5_server'] = $carray['red5_server']; //免费域名服务器
$comment['cachemode'] = $carray['cachemode']; //站点缓存存放模式
$comment['tplrefresh'] = $carray['tplrefresh']==1?'开启':'关闭'; //风格自动刷新开关
$comment['cachegrade'] = $carray['cachegrade']; //系统缓存等级
$comment['ucmode'] = $carray['ucmode']==1?'有用户中心':'没有用户中心'; //用户中心模式
foreach($carray as $key => $keyfield) {
$clang[$key] == '' && $clang[$key] = ' ';
strpos('comma'.$comment[$key], '警告') && $comment[$key] = $comment[$key];
strpos('comma'.$comment[$key], '出错') && $comment[$key] = $comment[$key];
$comment[$key] == '' && $comment[$key] = "{$ok_style_s}正常{$style_e}";
if(in_array($key, array('dbuser', 'dbpw'))) {
$keyfield = '**隐藏**';
}
$keyfield == '' && $keyfield = '空';
if(!in_array($key, array('dbhost','dbuser','dbpw','dbname','dbhost_bbs','dbuser_bbs','dbpw_bbs','dbname_bbs','tablepre_bbs','dbcharset_bbs','dbreport','pconnect_bbs','adminemail',
'mailsend','mailcfg[\'server\']','mailcfg[\'port\']','mailcfg[\'auth\']','mailcfg[\'from\']','mailcfg[\'auth_username\']','mailcfg[\'auth_password\']'))) {
if(in_array($key, array('pconnect', 'headercharset', 'tplrefresh', 'ucmode', 'cachegrade','cachemode','red5_server','perspacenum','bbsver','blackgroupids','uploadimgpernum','sendmail_silent','bbsurl','siteurl','bbsattchurl'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]\n";
} elseif(in_array($key, array('cookiepre', 'cookiepath', 'cookiedomain', 'charset', 'dbcharset'))) {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield\n";
} else {
$doctor_config .= "\n\t{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $keyfield ---> $comment[$key]\n";
}
} else {
if(strstr($comment[$key], '出错')) {
strstr($doctor_config_db, '正常') && $doctor_config_db = '';
$doctor_config_db .= "{$title_style_s}$key{$title_style_e} ---> $clang[$key] ---> $comment[$key]";
} else {
if(empty($doctor_config_db)) {
$doctor_config_db ="\n\t{$ok_style_s}数据库正常链接.{$style_e}";
}
}
}
}
}
$doctor_config = "\n".$doctor_config_db.$doctor_config;
//检测配置文件结束
$msg = '';
$curr_os = PHP_OS;
if(!function_exists('mysql_connect')) {
$curr_mysql = $error_style_s.'不支持'.$style_e;
$msg .= "您的服务器不支持MySql数据库，无法安装论坛程序";
$quit = TRUE;
} else {
if(@mysql_connect($dbhost, $dbuser, $dbpw)) {
$curr_mysql = mysql_get_server_info();
} else {
$curr_mysql = $ok_style_s.'支持'.$style_e;
}
}
if(function_exists('mysql_connect')) {
$authkeylink = @mysql_connect($dbhost, $dbuser, $dbpw);
mysql_select_db($dbname, $authkeylink);
if($whereis=='is_dz'){
$authkeyresult = mysql_result(mysql_query("SELECT `value` FROM {$tablepre}settings WHERE `variable`='authkey'", $authkeylink), 0);
}elseif($whereis=='is_uc'){
$authkeyresult = mysql_result(mysql_query("SELECT `uid` FROM {$tablepre}members WHERE 1", $authkeylink), 0);
}elseif($whereis=='is_uch'){
$authkeyresult = mysql_result(mysql_query("SELECT `uid` FROM {$tablepre}space WHERE 1", $authkeylink), 0);
}elseif($whereis=='is_ss'){
$authkeyresult = mysql_result(mysql_query("SELECT `uid` FROM {$tablepre}members WHERE 1", $authkeylink), 0);
}
if($authkeyresult) {
$authkeyexist = $ok_style_s.'存在'.$style_e;
} else {
$authkeyexist = $error_style_s.'不存在'.$style_e;
}
}
$curr_php_version = PHP_VERSION;
if($curr_php_version < '4.0.6') {
$msg .= "您的 PHP 版本小于 4.0.6, 无法使用 Discuz! / SuperSite。";
}
if(ini_get('allow_url_fopen')) {
$allow_url_fopen = $ok_style_s.'允许'.$style_e;
} else {
$allow_url_fopen = $title_style_s.'不允许'.$title_style_e;
}
$max_execution_time = get_cfg_var('max_execution_time');
$max_execution_time == 0 && $max_execution_time = '不限制';
$memory_limit = get_cfg_var('memory_limit');
$curr_server_software = $_SERVER['SERVER_SOFTWARE'];
if(function_exists('ini_get')) {
if(!@ini_get('short_open_tag')) {
$curr_short_tag = $title_style_s.'不允许'.$title_style_e;
$msg .='请将 php.ini 中的 short_open_tag 设置为 On，否则无法使用论坛。';
} else {
$curr_short_tag = $ok_style_s.'允许'.$style_e;
}
if(@ini_get(file_uploads)) {
$max_size = @ini_get(upload_max_filesize);
$curr_upload_status = '您可以上传附件的最大尺寸: '.$max_size;
} else {
$msg .= "附件上传或相关操作被服务器禁止。";
}
} else {
$msg .= 'php.ini中禁用了ini_get()函数.部分环境参数无法检测.';
}
if(!defined('OPTIMIZER_VERSION')) define('OPTIMIZER_VERSION','没有安装或版本较低');
if(OPTIMIZER_VERSION < 3.0) {
$msg .="您的ZEND版本低于3.0,将无法使用SuperSite.";
}
//临时目录的检查
if(@is_writable(@ini_get('upload_tmp_dir'))){
$tmpwritable = $ok_style_s.'可写'.$style_e;
} elseif(!@ini_get('upload_tmp_dir') & @is_writable($_ENV[TEMP])) {
$tmpwritable = $ok_style_s.'可写'.$style_e;
} else {
$tmpwritable = $title_style_s.'不可写'.$title_style_e;
}
if(@ini_get('safe_mode') == 1) {
$curr_safe_mode = $ok_style_s.'开启'.$style_e;
} else {
$curr_safe_mode = $title_style_s.'关闭'.$title_style_e;
}
if(@diskfreespace('.')) {
$curr_disk_space = intval(diskfreespace('.') / (1024 * 1024)).'M';
} else {
$curr_disk_space = '无法检测';
}
if(function_exists('xml_parser_create')) {
$curr_xml = $ok_style_s.'可用'.$style_e;
} else {
$curr_xml = $title_style_s.'不可用'.$title_style_e;
}
if(function_exists('file')) {
$funcexistfile = $ok_style_s.'存在'.$style_e;
} else {
$funcexistfile = $title_style_s.'不存在'.$title_style_e;
}
if(function_exists('fopen')) {
$funcexistfopen = $ok_style_s.'存在'.$style_e;
} else {
$funcexistfopen = $title_style_s.'不存在'.$title_style_e;
}
if(@ini_get('display_errors')) {
$curr_display_errors = $ok_style_s.'开启'.$style_e;
} else {
$curr_display_errors = $title_style_s.'关闭'.$title_style_e;
}
if(!function_exists('ini_get')) {
$curr_display_errors = $tmpwritable = $curr_safe_mode = $curr_upload_status = $curr_short_tag = '无法检测';
}
if($whereis=='is_dz'){
//目录权限检查
$envlogs = array();
$entryarray = array (
'attachments',
'forumdata',
'forumdata/threadcaches',
'forumdata/logs',
'forumdata/templates',
'forumdata/cache',
'customavatars',
'forumdata/viewcount.log',
'forumdata/dberror.log',
'forumdata/errorlog.php',
'forumdata/ratelog.php',
'forumdata/cplog.php',
'forumdata/modslog.php',
'forumdata/illegallog.php'
);
foreach(array('templates', 'forumdata/logs', 'forumdata/cache', 'forumdata/templates') as $directory) {
getdirentry($directory);
}
}elseif($whereis=='is_uc'){
$envlogs = array();
$entryarray = array (
'data',
'data/cache',
'data/view',
);
foreach(array( 'data/cache','data/view') as $directory) {
getdirentry($directory);
}
}elseif($whereis=='is_uch'){
$envlogs = array();
$entryarray = array (
'attachments',
'data',
'data/logs',
'data/tpl_cache',
'data/temp',
);
foreach(array('data/temp', 'data/tpl_cache') as $directory) {
getdirentry($directory);
}
}elseif($whereis=='is_ss'){
$envlogs = array();
$entryarray = array (
'attachments',
'data',
'cache',
'cache/tpl',
'cache/model'
);
foreach(array('cache/tpl', 'cache/model') as $directory) {
getdirentry($directory);
}
}
$fault = 0;
foreach($entryarray as $entry) {
$fullentry = './'.$entry;
if(!is_dir($fullentry) && !file_exists($fullentry)) {
continue;
} else {
if(!is_writeable($fullentry)) {
$dir_perm .= "\n\t\t".(is_dir($fullentry) ? '目录' : '文件')." ./$entry {$error_style_s}无法写入.{$style_e}";
$msg .= "\n\t\t".(is_dir($fullentry) ? '目录' : '文件')." ./$entry {$error_style_s}无法写入.{$style_e}";
$fault = 1;
}
}
}
$dir_perm .= $fault ? '' : $ok_style_s.'文件及目录属性全部正确'.$style_e;
$gd_check = '';
if(!extension_loaded('gd')) {
$gd_check .= '您的php.ini未开启extension=php_gd2.dll(windows)或者未编译gd库(linux).';
} elseif(!function_exists('gd_info') && phpversion() < '4.3') {
$gd_check .= 'php版本低于4.3.0，不支持高版本的gd库，请升级您的php版本.';
} else {
$ver_info = gd_info();
preg_match('/([0-9\.]+)/', $ver_info['GD Version'], $match);
if($match[0] < '2.0') {
$gd_check .= "\n\t\tgd版本低于2.0,请升级您的gd版本以支持gd的验证码和水印.";
} elseif(!(function_exists('imagecreatefromjpeg') && function_exists('imagejpeg')) ) {
$gd_check .= "\n\t\tgd版本不支持jpeg的验证码和水印.";
} elseif(!(function_exists('imagecreatefromgif') && function_exists('imagegif')) ) {
$gd_check .= "\n\t\tgd版本不支持gif的验证码和水印.";
} elseif(!(function_exists('imagecreatefrompng') && function_exists('imagepng')) ) {
$gd_check .= "\n\t\tgd版本不支持png的验证码和水印.";
} else {
$gd_check .= '正常开启';
}
}
if($gd_check != '正常开启') {
$gd_check = $error_style_s.$gd_check.$style_e;
} else {
$gd_check = $ok_style_s.$gd_check.$style_e;
}
$ming_check = '';
if(extension_loaded('ming')) {
if(substr($curr_os,0,3) == 'WIN') {
$ming_check .= '您的php.ini未开启extension=php_ming.dll，所以无法支持flash验证码';
} else {
$ming_check .= '您未编译ming库，所以无法支持flash验证码';
}
} else {
$ming_check .= '您的系统支持flash验证码，如果还无法使用flash验证码的话，有可能是您的php版本太低';
}
$imagemagick_check = '';
if(!function_exists('exec')) {
$imagemagick_check .='您的php.ini里或者空间商禁止了使用exec函数，无法使用ImageMagick';
} else {
$imagemagick_check .='您现在只需安装好ImageMagick，然后配置好相关参数就可以使用ImageMagick(使用之前请先使用后台的预览功能来检查您的ImageMagick是否安装好)';
}
if($msg == '') {
$msg = "{$ok_style_s}没有发现系统环境问题.{$style_e}";
} else {
$msg = $error_style_s.$msg.$style_e;
}
$doctor_env = "
操作系统--->$curr_os
WEB 引擎 --->$curr_server_software
PHP 版本--->$curr_php_version
MySQL 版本--->$curr_mysql
Zend 版本--->".OPTIMIZER_VERSION."
程序最长运行时间(max_execution_time)--->{$max_execution_time}秒
内存大小(memory_limit)--->$memory_limit
是否允许打开远程文件(allow_url_fopen)--->$allow_url_fopen
是否允许使用短标记(short_open_tag)--->$curr_short_tag
安全模式(safe_mode)--->$curr_safe_mode
错误提示(display_errors)--->$curr_display_errors
XML 解析器--->$curr_xml
authkey 是否存在--->$authkeyexist
系统临时目录--->$tmpwritable
磁盘空间--->$curr_disk_space
附件上传--->$curr_upload_status
函数 file()--->$funcexistfile
函数 fopen()--->$funcexistfopen
目录权限---$dir_perm
GD 库--->$gd_check
ming 库--->$ming_check
ImageMagick --->$imagemagick_check
系统环境错误提示\r\n\t$msg";
}
if(!$doctor_step) {
$doctor_step = '0';
if($whereis=='is_dz'){
@unlink('./forumdata/doctor_cache.cache');
}elseif($whereis=='is_uc'){
@unlink('./data/doctor_cache.cache');
}elseif($whereis=='is_uch'){
@unlink('./data/doctor_cache.cache');
}elseif($whereis=='is_ss'){
@unlink('./cache/doctor_cache.cache');
}
}
//php错误检查
$dberrnomsg = array (
'1008' => '数据库不存在，删除数据库失败',
'1016' => '无法打开数据文件',
'1041' => '系统内存不足',
'1045' => '连接数据库失败，用户名或密码错误',
'1046' => '选择数据库失败，请正确配置数据库名称',
'1044' => '当前用户没有访问数据库的权限',
'1048' => '字段不能为空',
'1049' => '数据库不存在',
'1051' => '数据表不存在',
'1054' => '字段不存在',
'1062' => '字段值重复，入库失败',//不中断
'1064' => '可能原因：1.数据超长或类型不匹配；2.数据库记录重复',//不中断
'1065' => '无效的SQL语句，SQL语句为空',//不中断
'1081' => '不能建立Socket连接',
'1129' => '数据库出现异常，请重启数据库',
'1130' => '连接数据库失败，没有连接数据库的权限',
'1133' => '数据库用户不存在',
'1141' => '当前用户无权访问数据库',
'1142' => '当前用户无权访问数据表',
'1143' => '当前用户无权访问数据表中的字段',
'1146' => '数据表不存在',
'1149' => 'SQL语句语法错误',
'1169' => '字段值重复，更新记录失败',//不中断
'2003' => '请检查数据库服务器端口设置是否正确，默认端口为 3306',
'2005' => '数据库服务器不存在',
'1114' => 'Forum onlines reached the upper limit',
);
$display_errorall = '';
$tempdir = $phpfile_array[$doctor_step];
$dirname = $dir_array[$doctor_step];
$display_error = '';
$mtime = explode(' ', microtime());
$time_start = $mtime[1] + $mtime[0];
if($whereis=='is_dz'){
if(!in_array($tempdir, array('templates', 'cache', 'discuzroot'))) exit('参数错误');
$tempdir == 'discuzroot' ? $dir = './' : $dir = 'forumdata/'.$tempdir.'/';
}elseif($whereis=='is_uch'){
if(!in_array($tempdir, array('data/tpl_cache','homeroot','data/temp'))) exit('参数错误');
$tempdir == 'homeroot' ? $dir = './' : $dir = 'data/'.$tempdir.'/';
}elseif($whereis=='is_uc'){
if(!in_array($tempdir, array('data/view','ucenterroot','data/cache'))) exit('参数错误');
$tempdir == 'ucenterroot' ? $dir = './' : $dir = 'data/'.$tempdir.'/';
}elseif($whereis=='is_ss'){
if(!in_array($tempdir, array('cache','supesiteroot','data'))) exit('参数错误');
$tempdir == 'supesiteroot' ? $dir = './' : $dir = 'cache/'.$tempdir.'/';
}
create_checkfile();
if (is_dir($dir)) {
if ($dh = dir($dir)) {
$PHP_SELF = $_SERVER['PHP_SELF'] ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME'];
$BASESCRIPT = basename($PHP_SELF);
$host = htmlspecialchars($_SERVER['HTTP_HOST']);
$boardurl = preg_replace("/\/+(api|archiver|wap)?\/*$/i", '', substr($PHP_SELF, 0, strrpos($PHP_SELF, '/'))).'/';
while (($file = $dh->read()) !== false) {
if ($file != '.' && $file != '..' && $file != 'index.htm' && $file != 'checkfile.php' && $file != 'tools.php' && !is_dir($file)) {
$extnum = strrpos($file, '.') + 1;
$exts = strtolower(substr($file, $extnum));
if($exts == 'php') {
$content = '';
if($dir == './') {
$content = http_fopen($host, "{$boardurl}{$file}");
} else {
if($whereis=='is_dz'){
$content = http_fopen($host, "{$boardurl}/forumdata/checkfile.php?file=$file");
}else{
$content = http_fopen($host, "{$boardurl}/data/checkfile.php?file=$file");
}
}
$content = str_replace(': Call to undefined function: ','',$content);
$content = str_replace(': Call to undefined function ','',$content);
$out = $out_mysql = array();
if(preg_match_all("/
.+<\/b>:.* on line \d+<\/b>/",$content,$out) || preg_match_all("/Error<\/b>:.+
\nErrno.<\/b>:\s{2}([1-9][0-9]+)/",$content,$out_mysql)) {
$display_error .= "\t{$error_style_s}$file ---错误:{$style_e}";
if (is_array($out[0])) {
foreach ($out[0] as $value) {
$display_error .= "\n\t\t".$value."\n";
}
}
if (is_array($out_mysql[0])) {
foreach ($out_mysql[0] as $key =>$value) {
$display_error .= "\n\t\t{$error_style_s}".$dberrnomsg[$out_mysql[1][$key]].$style_e;
$display_error .= "\n\t\t".str_replace("\n", '', $value);
}
}
}
}
}
}
$dh->close();
} else {
echo "$dir目录不存在或不可读取.";
}
}
if($whereis=='is_dz'){
@unlink('./forumdata/checkfile.php');
if($display_error == '') {
$dot = '缓存文件';
$dir == './' && $dot = 'php文件';
$display_errorall .= "\n---------{$ok_style_s}{$dirname}{$style_e}下没有检测到有错误的$dot.\n";
} else {
$display_errorall .= "\n---------{$error_style_s}{$dirname}{$style_e}\n".$display_error;
}
$fp = @fopen('./forumdata/doctor_cache.cache', 'ab');
@fwrite($fp, $display_errorall);
@fclose($fp);
if($doctor_step < $doctor_top) {
$doctor_step ++;
continue_redirect('dz_doctor', "&doctor_step=$doctor_step");
htmlfooter();
}
$fp = @fopen('./forumdata/doctor_cache.cache','rb');
$display_errorall = @fread($fp, @filesize('./forumdata/doctor_cache.cache'));
@fclose($fp);
@unlink('./forumdata/doctor_cache.cache');
}else{
@unlink('./data/checkfile.php');
if($display_error == '') {
$dot = '缓存文件';
$dir == './' && $dot = 'php文件';
$display_errorall .= "\n---------{$ok_style_s}{$dirname}{$style_e}下没有检测到有错误的$dot.\n";
} else {
$display_errorall .= "\n---------{$error_style_s}{$dirname}{$style_e}\n".$display_error;
}
$fp = @fopen('./data/doctor_cache.cache', 'ab');
@fwrite($fp, $display_errorall);
@fclose($fp);
if($doctor_step < $doctor_top) {
$doctor_step ++;
continue_redirect('dz_doctor', "&doctor_step=$doctor_step");
htmlfooter();
}
$fp = @fopen('./data/doctor_cache.cache','rb');
$display_errorall = @fread($fp, @filesize('./data/doctor_cache.cache'));
@fclose($fp);
@unlink('./data/doctor_cache.cache');
}
?>
论坛医生诊断结果
$display_errorall
";
}else{
echo "论坛医生诊断结果
文件检查正常
";
}
echo "点击查看更详细的诊断结果";
$display_errorall = str_replace('', '', $display_errorall);
$display_errorall = str_replace('', '', $display_errorall);
$display_errorall = str_replace('
', '', $display_errorall);
$records_style = "\n\n==={$title_style_s}配置文件检查{$title_style_e}=================================================$doctor_config\n==={$title_style_s}系统环境检查{$title_style_e}=================================================\n$doctor_env\n==={$title_style_s}文件错误检查{$title_style_e}=================================================\n$display_errorall\n==={$title_style_s}检查完毕{$title_style_e}=====================================================";
$search_style_all = array($error_style_s, $style_e, $ok_style_s, $title_style_s, $title_style_e);
$replace_style_all = array('', '', '', '', '');
$records = str_replace($search_style_all, '', $records_style);
echo "";
htmlfooter();
} elseif ($action == 'dz_filecheck') {//搜索未知文件
if(!file_exists("./config.inc.php") && !file_exists("config.php")) {
htmlheader();
cexit("请先上传config文件以保证您的数据库能正常链接！
");
}
$do = isset($_GET['do']) ? $_GET['do'] : 'advance';
$lang = array(
'filecheck_fullcheck' => '搜索未知文件',
'filecheck_fullcheck_select' => '搜索未知文件 - 选择需要搜索的目录',
'filecheck_fullcheck_selectall' => '[搜索全部目录]',
'filecheck_fullcheck_start' => '开始时间:',
'filecheck_fullcheck_current' => '当前时间:',
'filecheck_fullcheck_end' => '结束时间:',
'filecheck_fullcheck_file' => '当前文件:',
'filecheck_fullcheck_foundfile' => '发现未知文件数: ',
'filecheck_fullcheck_nofound' => '没有发现任何未知文件'
);
if(!$discuzfiles = @file('./admin/discuzfiles.md5')) {
show_tools_message('没有找到文件的MD5值');
}
htmlheader();
if($do == 'advance') {
$dirlist = array();
$starttime = date('Y-m-d H:i:s');
$cachelist = $templatelist = array();
if(empty($checkdir)) {
checkdirs('./');
} elseif($checkdir == 'all') {
echo "\n";
} else {
$checkdir = str_replace('..', '', $checkdir);
$checkdir = $checkdir{0} == '/' ? '.'.$checkdir : $checkdir;
checkdirs($checkdir.'/');
echo "\n";
}
echo '搜索未知文件
| '.(empty($checkdir) ? ''.$lang['filecheck_fullcheck_selectall'].'' : $lang['filecheck_fullcheck'].($checkdir != 'all' ? ' - '.$checkdir : '')).' |
|---|
';
if ($dz_version >= 700){
echo '';}
else {
echo '';
}
if(empty($checkdir)) {
echo '
';
foreach($dirlist as $dir) {
$subcount = count(explode('/', $dir));
echo '- '.str_repeat('-', ($subcount - 2) * 4);
echo ''.basename($dir).'
';
}
echo ' |
';
} else {
echo ''.$lang['filecheck_fullcheck_start'].' '.$starttime.'
|
';
echo "";
}
htmlfooter();
} elseif($do == 'advancenext') {
$nopass = 0;
foreach($discuzfiles as $line) {
$md5files[] = trim(substr($line, 34));
}
$foundfile = checkfullfiles($dir);
echo "";
exit;
}
} elseif ($action == 'dz_mysqlclear') {//数据库清理
ob_implicit_flush();
define('IN_DISCUZ', TRUE);
if(@!include("./config.inc.php")) {
if(@!include("./config.php")) {
htmlheader();
cexit("请先上传config文件以保证您的数据库能正常链接！
");
}
}
require './include/db_'.$database.'.class.php';
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$db->select_db($dbname);
if(!get_cfg_var('register_globals')) {
@extract($_GET, EXTR_SKIP);
}
$rpp = "1000"; //每次处理多少条数据
$totalrows = isset($totalrows) ? $totalrows : 0;
$convertedrows = isset($convertedrows) ? $convertedrows : 0;
$start = isset($start) && $start > 0 ? $start : 0;
$sqlstart = isset($start) && $start > $convertedrows ? $start - $convertedrows : 0;
$end = $start + $rpp - 1;
$stay = isset($stay) ? $stay : 0;
$converted = 0;
$step = isset($step) ? $step : 0;
$info = isset($info) ? $info : '';
$action = array(
'1'=>'冗余回复数据清理',
'2'=>'冗余附件数据清理',
'3'=>'冗余会员数据清理',
'4'=>'冗余板块数据清理',
'5'=>'主题信息清理',
'6'=>'完成数据冗余清理'
);
$steps = count($action);
$actionnow = isset($action[$step]) ? $action[$step] : '结束';
$maxid = isset($maxid) ? $maxid : 0;
$tableid = isset($tableid) ? $tableid : 1;
htmlheader();
if($step==0){
?>
数据库冗余数据清理
清理项目详细信息
alert('提示：在进行此操作前请备份数据库，以免处理过程中出现错误造成数据丢失！！');";
} elseif ($step == '1'){
if($start == 0) {
validid('pid','posts');
}
$query = "SELECT pid, tid FROM {$tablepre}posts WHERE pid >= $start AND pid <= $end";
$posts=$db->query($query);
while ($post = $db->fetch_array($posts)){
$query = $db->query("SELECT tid FROM {$tablepre}threads WHERE tid='".$post['tid']."'");
if ($db->result($query, 0)) {
} else {
$convertedrows ++;
$db->query("DELETE FROM {$tablepre}posts WHERE pid='".$post['pid']."'");
}
$converted = 1;
$totalrows ++;
}
if($converted || $end < $maxid) {
continue_redirect();
} else {
stay_redirect();
}
} elseif ($step == '2'){
if($start == 0) {
validid('aid','attachments');
}
$query = "SELECT aid,pid,attachment FROM {$tablepre}attachments WHERE aid >= $start AND aid <= $end";
$posts=$db->query($query);
while ($post = $db->fetch_array($posts)){
$query = $db->query("SELECT pid FROM {$tablepre}posts WHERE pid='".$post['pid']."'");
if ($db->result($query, 0)) {
} else {
$convertedrows ++;
$db->query("DELETE FROM {$tablepre}attachments WHERE aid='".$post['aid']."'");
$attachmentdir = TOOLS_ROOT.'./attachments/';
@unlink($attachmentdir.$post['attachment']);
}
$converted = 1;
$totalrows ++;
}
if($converted || $end < $maxid) {
continue_redirect();
} else {
stay_redirect();
}
} elseif ($step == '3'){
if($start == 0) {
validid('uid','memberfields');
}
$query = "SELECT uid FROM {$tablepre}memberfields WHERE uid >= $start AND uid <= $end";
$posts=$db->query($query);
while ($post = $db->fetch_array($posts)){
$query = $db->query("SELECT uid FROM {$tablepre}members WHERE uid='".$post['uid']."'");
if ($db->result($query, 0)) {
} else {
$convertedrows ++;
$db->query("DELETE FROM {$tablepre}memberfields WHERE uid='".$post['uid']."'");
}
$converted = 1;
$totalrows ++;
}
if($converted || $end < $maxid) {
continue_redirect();
} else {
stay_redirect();
}
} elseif ($step == '4'){
if($start == 0) {
validid('fid','forumfields');
}
$query = "SELECT fid FROM {$tablepre}forumfields WHERE fid >= $start AND fid <= $end";
$posts=$db->query($query);
while ($post = $db->fetch_array($posts)){
$query = $db->query("SELECT fid FROM {$tablepre}forums WHERE fid='".$post['fid']."'");
if ($db->result($query, 0)) {
} else {
$convertedrows ++;
$db->query("DELETE FROM {$tablepre}forumfields WHERE fid='".$post['fid']."'");
}
$converted = 1;
$totalrows ++;
}
if($converted || $end < $maxid) {
continue_redirect();
} else {
stay_redirect();
}
} elseif ($step == '5'){
if($start == 0) {
validid('tid','threads');
}
$query = "SELECT tid, subject FROM {$tablepre}threads WHERE tid >= $start AND tid <= $end";
$posts=$db->query($query);
while ($threads = $db->fetch_array($posts)){
$query = $db->query("SELECT COUNT(*) FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0'");
$replynum = $db->result($query, 0) - 1;
if ($replynum < 0) {
$db->query("DELETE FROM {$tablepre}threads WHERE tid='".$threads['tid']."'");
} else {
$query = $db->query("SELECT a.aid FROM {$tablepre}posts p, {$tablepre}attachments a WHERE a.tid='".$threads['tid']."' AND a.pid=p.pid AND p.invisible='0' LIMIT 1");
$attachment = $db->num_rows($query) ? 1 : 0;//修复附件
$query = $db->query("SELECT pid, subject, rate FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0' ORDER BY dateline LIMIT 1");
$firstpost = $db->fetch_array($query);
$firstpost['subject'] = trim($firstpost['subject']) ? $firstpost['subject'] : $threads['subject']; //针对某些转换过来的论坛的处理
$firstpost['subject'] = addslashes($firstpost['subject']);
@$firstpost['rate'] = $firstpost['rate'] / abs($firstpost['rate']);//修复发帖
$query = $db->query("SELECT author, dateline FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0' ORDER BY dateline DESC LIMIT 1");
$lastpost = $db->fetch_array($query);//修复最后发帖
$db->query("UPDATE {$tablepre}threads SET subject='".$firstpost['subject']."', replies='$replynum', lastpost='".$lastpost['dateline']."', lastposter='".addslashes($lastpost['author'])."', rate='".$firstpost['rate']."', attachment='$attachment' WHERE tid='".$threads['tid']."'", 'UNBUFFERED');
$db->query("UPDATE {$tablepre}posts SET first='1', subject='".$firstpost['subject']."' WHERE pid='".$firstpost['pid']."'", 'UNBUFFERED');
$db->query("UPDATE {$tablepre}posts SET first='0' WHERE tid='".$threads['tid']."' AND pid<>'".$firstpost['pid']."'", 'UNBUFFERED');
$convertedrows ++;
}
$converted = 1;
$totalrows ++;
}
if($converted || $end < $maxid) {
continue_redirect();
} else {
stay_redirect();
}
} elseif ($step=='6'){
echo '数据库冗余数据清理
| 完成冗余数据清理 |
|---|
所有数据清理操作完毕. 共处理'.$allconvertedrows.'条数据.
|
';
}
htmlfooter();
} elseif ($action == 'dz_replace') {//内容替换
htmlheader();
$rpp = "500"; //每次处理多少条数据
$totalrows = isset($totalrows) ? $totalrows : 0;
$convertedrows = isset($convertedrows) ? $convertedrows : 0;
$convertedtrows = isset($convertedtrows) ? $convertedtrows : 0;
$start = isset($start) && $start > 0 ? $start : 0;
$end = $start + $rpp - 1;
$converted = 0;
$maxid = isset($maxid) ? $maxid : 0;
$threads_mod = isset($threads_mod) ? $threads_mod : 0;
$threads_banned = isset($threads_banned) ? $threads_banned : 0;
$posts_mod = isset($posts_mod) ? $posts_mod : 0;
if($stop == 1) {
echo "帖子内容批量替换
| 暂停替换 |
";
$threads_banned > 0 && print("
".$threads_banned."个主题被放入回收站.
|
");
$threads_mod > 0 && print("
".$threads_mod."个主题被放入审核列表.
|
");
$posts_mod > 0 && print("
".$posts_mod."个回复被放入审核列表.
|
");
echo "
替换了".$convertedrows."条记录
|
";
echo "
继续
|
";
echo "
";
htmlfooter();
}
ob_implicit_flush();
define('IN_DISCUZ', TRUE);
if(@!include("./config.inc.php")) {
if(@!include("./config.php")) {
cexit("请先上传config文件以保证您的数据库能正常链接！
");
}
}
require './include/db_'.$database.'.class.php';
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$db->select_db($dbname);
$selectwords_cache = './forumdata/cache/selectwords_cache.php';
if(isset($replacesubmit) || $start > 0) {
if($maxid ==0) {
validid('pid','posts');
}
if(!file_exists($selectwords_cache) || is_array($selectwords)){
if(count($selectwords) < 1) {
echo "帖子内容批量替换
";
htmlfooter();
} else {
$fp = @fopen($selectwords_cache,w);
$content = "";
if(!@fwrite($fp,$content)) {
echo "写入缓存文件$selectwords_cache 错误,请确认路径是否可写. [返回]";
htmlfooter();
} else {
require_once "$selectwords_cache";
}
@fclose($fp);
}
} else {
require_once "$selectwords_cache";
}
$array_find = $array_replace = $array_findmod = $array_findbanned = array();
$query = $db->query("SELECT find,replacement from {$tablepre}words where id in($selectwords)");//获得现有规则{BANNED}放回收站 {MOD}放进审核列表
while($row = $db->fetch_array($query)) {
$find = preg_quote($row['find'], '/');
$replacement = $row['replacement'];
if($replacement == '{BANNED}') {
$array_findbanned[] = $find;
} elseif($replacement == '{MOD}') {
$array_findmod[] = $find;
} else {
$array_find[] = $find;
$array_replace[] = $replacement;
}
}
$array_find = topattern_array($array_find);
$array_findmod = topattern_array($array_findmod);
$array_findbanned = topattern_array($array_findbanned);
//查询posts表准备替换
$sql = "SELECT pid, tid, first, subject, message from {$tablepre}posts where pid >= $start and pid <= $end";
$query = $db->query($sql);
while($row = $db->fetch_array($query)) {
$pid = $row['pid'];
$tid = $row['tid'];
$subject = $row['subject'];
$message = $row['message'];
$first = $row['first'];
$displayorder = 0;// -2审核 -1回收站
if(count($array_findmod) > 0) {
foreach($array_findmod as $value){
if(preg_match($value,$subject.$message)){
$displayorder = '-2';
break;
}
}
}
if(count($array_findbanned) > 0) {
foreach($array_findbanned as $value){
if(preg_match($value,$subject.$message)){
$displayorder = '-1';
break;
}
}
}
if($displayorder < 0) {
if($displayorder == '-2' && $first == 0) {//如成立就移到审核回复
$posts_mod ++;
$db->query("UPDATE {$tablepre}posts SET invisible = '$displayorder' WHERE pid = $pid");
} else {
if($db->affected_rows($db->query("UPDATE {$tablepre}threads SET displayorder = '$displayorder' WHERE tid = $tid and displayorder >= 0")) > 0) {
$displayorder == '-2' && $threads_mod ++;
$displayorder == '-1' && $threads_banned ++;
}
}
}
$subject = preg_replace($array_find,$array_replace,addslashes($subject));
$message = preg_replace($array_find,$array_replace,addslashes($message));
if($subject != addslashes($row['subject']) || $message != addslashes($row['message'])) {
if($db->query("UPDATE {$tablepre}posts SET subject = '$subject', message = '$message' WHERE pid = $pid")) {
$convertedrows ++;
}
}
$converted = 1;
}
//查询threads表
$sql2 = "SELECT tid,subject from {$tablepre}threads where tid >= $start and tid <= $end";
$query2 = $db->query($sql2);
while($row2 = $db->fetch_array($query2)) {
$tid = $row2['tid'];
$subject = $row2['subject'];
$subject = preg_replace($array_find,$array_replace,addslashes($subject));
if($subject != addslashes($row2['subject'])) {
if($db->query("UPDATE {$tablepre}threads SET subject = '$subject' WHERE tid = $tid")) {
$convertedrows ++;
}
}
$converted = 1;
}
//完成
if($converted || $end < $maxid) {
continue_redirect('dz_replace',"&replacesubmit=1&threads_banned=$threads_banned&threads_mod=$threads_mod&posts_mod=$posts_mod");
} else {
echo "帖子内容批量替换
| 批量替换完毕 |
";
$threads_banned > 0 && print("
".$threads_banned."个主题被放入回收站.
|
");
$threads_mod > 0 && print("
".$threads_mod."个主题被放入审核列表.
|
");
$posts_mod > 0 && print("
".$posts_mod."个回复被放入审核列表.
|
");
echo "
替换了".$convertedrows."条记录
|
";
echo "
";
@unlink($selectwords_cache);
}
} else {
if($db->version > '4.1'){
$serverset = 'character_set_connection=gbk, character_set_results=gbk, character_set_client=binary';
$serverset && $db->query("SET $serverset");
}
$query = $db->query("select * from {$tablepre}words");
$i = 1;
if($db->num_rows($query) < 1) {
echo "帖子内容批量替换
| 提示信息 |
|---|
对不起,现在还没有过滤规则,请进入论坛后台相关设置.
|
";
htmlfooter();
}
?>
注意：
- 本程序会按照论坛现有过滤规则操作所有帖子内容.如需修改请进论坛后台。
- 上表列出了您论坛当前的过滤词语.
更新缓存| 提示信息 |
|---|
| ';
if($clearmsg == '') $clearmsg = '更新缓存完毕.';
echo $clearmsg.' |
';
htmlfooter();
} elseif ($action == 'all_setadmin') {//重置管理员帐号密码，
$sql_findadmin='';
$sql_select='';
$sql_update='';
$sql_rspw='';
$secq='';$rspw='';$username='';$uid='';
all_setadmin_set($tablepre,$whereis);
$info = "";
$info_uc = "";
htmlheader();
?>
找回管理员
无此用户！请检查用户名是否正确。请重新输入 或者重新注册.
';
} else {
if($whereis == 'is_dz') {
$sql_update1 = "UPDATE {$tablepre}members SET adminid='1', groupid='1' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
$sql_update2 = "UPDATE {$tablepre}members SET adminid='1', groupid='1',secques='' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
$sql_update = $_POST['issecques'] ? $sql_update2 : $sql_update1;
}
if($whereis == 'is_ss'){
$sql_update1 = "UPDATE {$tablepre}members SET groupid='1' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
$sql_update = $sql_update1;
}
if(mysql_query($sql_update)&& !$rspw) {
$_POST[loginfield] = $_POST[loginfield] == $username ? '用户名' : 'UID号码';
$info = "已将$_POST[loginfield]为 $_POST[where] 的用户设置成管理员。
";
}
if($rspw) {
if($whereis == 'is_dz') {
if($dz_version < 610){
$psw = md5($_POST['password']);
mysql_query("update {$tablepre}members set password='$psw' where $_POST[loginfield] = '$_POST[where]' limit 1");
}else{
//如果是dz，首先要连接到uc里面然后执行$sql_rspw修改密码
$salt = substr(md5(time()), 0, 6);
$psw = md5(md5($_POST['password']).$salt);
mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);
if($_POST['issecques'] && $dz_version>=700){
$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."',secques='' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
}else{
$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE username = '$_POST[where]' limit 1";
}
mysql_query($sql_rspw);
}
$info .= "已将$_POST[loginfield]为 $_POST[where] 的管理员密码设置为：$_POST[password]
";
} elseif($whereis == 'is_uch') {
$salt = substr(md5(time()), 0, 6);
$psw = md5(md5($_POST['password']).$salt);
mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);
$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
mysql_query($sql_rspw);
$info .="已将$_POST[loginfield]为 $_POST[where] 的管理员密码设置为：$_POST[password]
";
}elseif($whereis == 'is_ss'){
if($ss_version >=70){
$salt = substr(md5(time()), 0, 6);
$psw = md5(md5($_POST['password']).$salt);
mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);
$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";
mysql_query($sql_rspw);
}
$info .= "已将$_POST[loginfield]为 $_POST[where] 的管理员密码设置为：$_POST[password]
";
}
} else {
$info_rspw = "管理员密码请登录UC后台去改。 点击进入UC后台";
}
}
}
errorpage($info,'重置管理员帐号',0,0);
} else {
?>
';
errorpage("成功关闭工具箱！强烈建议您在不需要本程序的时候及时进行删除
",'锁定工具箱');
} else {
errorpage('注意您的目录没有写入权限，我们无法给您提供安全保障，请删除论坛根目录下的tool.php文件！','锁定工具箱');
}
} elseif ($action == 'dz_moveattach') {//移动附件存放方式
//初始化数据库连接帐号
getdbcfg();
define('IN_DISCUZ', TRUE);
require_once TOOLS_ROOT."./config.inc.php";
require_once TOOLS_ROOT."./include/db_mysql.class.php";
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
$dbuser = $dbpw = $dbname = $pconnect = NULL;
htmlheader();
if (!function_exists('mkdir')){
echo "您的服务器不支持mkdir函数，不能够转移附件。
";
}
echo "附件保存方式
";
$atoption = array(
'0' => '标准(全部存入同一目录)',
'1' => '按论坛存入不同目录',
'2' => '按文件类型存入不同目录',
'3' => '按月份存入不同目录',
'4' => '按天存入不同目录',
);
if (!empty($_POST['moveattsubmit']) || $step == 1) {
$rpp = "500"; //每次处理多少条数据
$totalrows = isset($totalrows) ? $totalrows : 0;
$convertedrows = isset($convertedrows) ? $convertedrows : 0;
$start = isset($start) && $start > 0 ? $start : 0;
$end = $start + $rpp - 1;
$converted = 0;
$maxid = isset($maxid) ? $maxid : 0;
$newattachsave = isset($newattachsave) ? $newattachsave : 0;
$step = 1;
if ($start <= 1) {
$db->query("UPDATE {$tablepre}settings SET value = '$newattachsave' WHERE variable = 'attachsave'");
$cattachdir = $db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable = 'attachdir'"), 0);
validid('aid', 'attachments');
}
$attachpath = isset($cattachdir) ? TOOLS_ROOT.$cattachdir : TOOLS_ROOT.'./attachments';
$query = $db->query("SELECT aid, tid, dateline, filename, filetype, attachment, isimage, thumb FROM {$tablepre}attachments WHERE aid >= $start AND aid <= $end");
while ($a = $db->fetch_array($query)) {
$aid = $a['aid'];
$tid = $a['tid'];
$dateline = $a['dateline'];
$filename = $a['filename'];
$filetype = $a['filetype'];
$attachment = $a['attachment'];
$isimage = $a['isimage'];
$thumb = $a['thumb'];
$oldpath = $attachpath.'/'.$attachment;
if (file_exists($oldpath)) {
$realname = substr(strrchr('/'.$attachment, '/'), 1);
if ($newattachsave == 1) {
$fid = $db->result($db->query("SELECT fid FROM {$tablepre}threads WHERE tid = '$tid' LIMIT 1"), 0);
$fid = $fid ? $fid : 0;
} elseif ($newattachsave == 2) {
$extension = strtolower(fileext($filename));
}
if ($newattachsave) {
switch($newattachsave) {
case 1: $attach_subdir = 'forumid_'.$fid; break;
case 2: $attach_subdir = 'ext_'.$extension; break;
case 3: $attach_subdir = 'month_'.gmdate('ym', $dateline); break;
case 4: $attach_subdir = 'day_'.gmdate('ymd', $dateline); break;
}
$attach_dir = $attachpath.'/'.$attach_subdir;
if(!is_dir($attach_dir)) {
mkdir($attach_dir, 0777);
@fclose(fopen($attach_dir.'/index.htm', 'w'));
}
$newattachment = $attach_subdir.'/'.$realname;
} else {
$newattachment = $realname;
}
$newpath = $attachpath.'/'.$newattachment;
$asql1 = "UPDATE {$tablepre}attachments SET attachment = '$newattachment' WHERE aid = '$aid'";
$asql2 = "UPDATE {$tablepre}attachments SET attachment = '$attachment' WHERE aid = '$aid'";
if ($db->query($asql1)) {
if (rename($oldpath, $newpath)) {
if($isimage && $thumb) {
$thumboldpath = $oldpath.'.thumb.jpg';
$thumbnewpath = $newpath.'.thumb.jpg';
rename($thumboldpath, $thumbnewpath);
}
$convertedrows ++;
} else {
$db->query($asql2);
}
}
$totalrows ++;
}
}
if($converted || $end < $maxid) {
continue_redirect('dz_moveattach', '&newattachsave='.$newattachsave.'&cattachdir='.$cattachdir);
} else {
$msg = "$atoption[$newattachsave] 移动附件完毕
共有".$totalrows."个附件数据
移动了".$convertedrows."个附件";
errorpage($msg,'',0,0);
}
} else {
$attachsave = $db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable = 'attachsave' LIMIT 1"), 0);
$checked[$attachsave] = 'checked';
echo "";
specialdiv();
echo "";
}
htmlfooter();
}elseif($action == 'dz_rplastpost'){//修复版块的最后回复
//初始化数据库连接帐号
getdbcfg();
define('IN_DISCUZ', TRUE);
require_once TOOLS_ROOT."./config.inc.php";
require_once TOOLS_ROOT."./include/db_mysql.class.php";
$db = new dbstuff;
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);
$dbuser = $dbpw = $dbname = $pconnect = NULL;
if($db->version > '4.1'){
$serverset = 'character_set_connection=gbk, character_set_results=gbk, character_set_client=binary';
$serverset && $db->query("SET $serverset");
}
$selectfid = $_POST['fid'];
if($selectfid) {
$i = 0;
foreach($selectfid as $fid) {
$sql = "select t.tid, t.subject, p.subject AS psubject, p.dateline, p.author from {$tablepre}threads t, {$tablepre}posts p where t.fid=$fid and p.tid=t.tid and t.displayorder>=0 and p.invisible=0 and p.status=0 order by p.dateline DESC limit 1";
$query = $db->query($sql);
$lastarray = array();
if($lastarray = $db->fetch_array($query)){
$lastarray['subject'] = $lastarray['psubject']?$lastarray['psubject']:$lastarray['subject'];
$lastpoststr = $lastarray['tid']."\t".$lastarray['subject']."\t".$lastarray['dateline']."\t".$lastarray['author'];
$db->query("update {$tablepre}forums set lastpost='$lastpoststr' where fid=$fid");
}
}
htmlheader();
show_tools_message("重置成功", 'tools.php?action=dz_rplastpost');
htmlfooter();
}else {
htmlheader();
?>
修复版块最后回复
操作提示：
- 可以指定需要修复的版块，提交后程序会重新查询出版块的最后回复信息并且修复
";
?>