}
include $configfile;
include '../include/class/mysql.class.php';
$DB = new DB_MySQL();
$DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect);
unset($servername, $dbusername, $dbpassword, $usepconnect);
$msg = '';
$quit = FALSE;
$curr_os = PHP_OS;
$curr_php_version = PHP_VERSION;
if ($curr_php_version < '4.0.6') {
$msg .= "<font color=\"#FF0000\">您的PHP版本低于4.0.6, 无法使用 SaBlog-X</font><br />";
$quit = TRUE;
}
$query = $DB->query("SELECT VERSION()");
$curr_mysql_version = $DB->result($query, 0);
if ($curr_mysql_version < '3.23') {
$msg .= "<font color=\"#FF0000\">您的MySQL版本低于3.23, 由于程序没有经过此平台的测试, 建议您换 MySQL4 的数据库服务器.</font><br />";
$quit = TRUE;
}
if (strstr($db_prefix, '.')) {
$msg .= "<font color=\"#FF0000\">您指定的数据表前缀包含点字符，请返回修改.</font><br />";
$quit = TRUE;
}
$DB->select_db($dbname);
if ($DB->geterrdesc()) {
if (mysql_get_server_info() > '4.1') {
$DB->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET utf8");
} else {
$DB->query("CREATE DATABASE {$dbname}");
}
$r2 = $DB->fetch_one_array("SELECT cid FROM {$db_prefix}relationships WHERE mid='{$mid}' LIMIT 1");
if (!$r2) {
$DB->query("INSERT INTO {$db_prefix}relationships (cid,mid) VALUES ('" . $article['articleid'] . "', '{$mid}')");
} else {
if ($article['articleid'] != $r2['cid']) {
$DB->query("INSERT INTO {$db_prefix}relationships (cid,mid) VALUES ('" . $article['articleid'] . "', '{$mid}')");
}
}
}
if ($article['visible']) {
$DB->unbuffered_query("UPDATE {$db_prefix}metas SET count=count+1 WHERE mid='{$mid}' AND type='tag'");
}
}
}
}
$attach_total = $DB->result($DB->query("SELECT COUNT(attachmentid) FROM {$db_prefix}attachments WHERE articleid='" . $article['articleid'] . "'"), 0);
$DB->unbuffered_query("UPDATE {$db_prefix}articles SET attachments='{$attach_total}' WHERE articleid='" . $article['articleid'] . "'");
}
echo '<div class="install_main">';
if ($goon) {
echo '<p class="p2">文章中的数据正在更新 ' . $start . ' 到 ' . $next . ' 项</p><p class="p2"><a href="' . $jumpurl . '">程序将自动跳转.如果没有自动跳转,请点击这里.</a></p>';
echo '<meta HTTP-EQUIV="REFRESH" content="2;URL=' . $jumpurl . '">';
} else {
echo '<p class="p2">成功重建所有文章内的数据</p><p class="p2"><a href="' . $php_self . '?action=three">程序将自动跳转.如果没有自动跳转,请点击这里.</a></p>';
echo '<meta HTTP-EQUIV="REFRESH" content="2;URL=' . $php_self . '?action=three">';
}
echo '</div></body></html>';
exit;
} elseif ($action == 'three') {
$add = <<<EOT
function mysqlconn($configfile)
{
include $configfile;
//包含配置文件，并使用它连接数据库
include 'func_db_mysql.php';
$DB = new DB_MySQL();
$quit = False;
//创建一个新的数据库对象
$DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect, $dbcharset);
unset($servername, $dbusername, $dbpassword, $usepconnect);
//销毁变量
$curr_php_version = PHP_VERSION;
//PHP的版本
if ($curr_php_version < '4.0.6') {
echo "<font color=\"#FF0000\">由于您的PHP版本过低, 无法继续安装 ,请更换版本大于4.0.6的PHP版本。3秒后返回配置页面</font></br>";
echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>";
echo "<meta http-equiv='refresh' content='3; url=setting.php'>";
exit;
}
$query = $DB->query("SELECT VERSION()");
//查询mysql版本信息
$curr_mysql_version = $DB->result($query, 0);
if ($curr_mysql_version < '3.23') {
//mysql版本< 3.23
echo "<font color=\"#FF0000\">您的MySQL版本低于3.23, 无法继续安装 ,建议您换 MySQL4 的数据库服务器。3秒后返回配置页面</font></br>";
echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>";
echo "<meta http-equiv='refresh' content='3; url=setting.php'>";
exit;
}
/**************执行建立数据库***************/
$DB->query("DROP DATABASE IF EXISTS {$dbname}");
if (mysql_get_server_info() > '4.1') {
$DB->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}");
} else {
$DB->query("CREATE DATABASE {$dbname}");
}
$DB->select_db($dbname);
$tablenum = '0';
runquery($sqlfile, $DB, $db_prefix, $tablenum = '0', $dbcharset);
//执行SQL 语句
}
