} 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 语句 }