//如果不存在则创建数据库
if (mysql_get_server_info() > '4.1') {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbName}` DEFAULT CHARACTER SET utf8");
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbName}`");
}
if (mysql_errno()) {
alert("无法创建新的数据库或无法连接现有数据库！\n请检查用户权限或数据库名称填写是否正确", 'index.php?Step=2');
}
mysql_close();
//=====================================================================
include_once "./Tpl/step3.html";
ob_flush();
flush();
showmessage("开始安装数据库...");
$db = new dbmysq();
$db->connect($dbHost, $dbUser, $dbPwd, $dbName, 'utf8');
//获取正确的数据
if ($DemoDb == 1 && file_exists($DbDataSql)) {
$dbSqlFile = $DbDataSql;
//含表结构和演示数据
} else {
$dbSqlFile = $DbSql;
//含表结构和系统数据
}
//创建表结构和初始化系统数据
$dbSql = file_get_contents($dbSqlFile);
$sqlList = sql_split($dbSql);
foreach ($sqlList as $query) {
$query = trim($query);
if ($query) {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}` DEFAULT CHARACTER SET " . DBCHARSET);
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}`");
}
if (mysql_errno()) {
message($LAN['database_errno_1044'], mysql_error());
}
mysql_close();
}
if (empty($dbname) || empty($password)) {
message($LAN['dbname_invalid'], $LAN['dbnameempay']);
}
$password = md5($password);
$nowtime = time();
config_edit($postlist);
$db = new dbmysq();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, DBCHARSET);
$sql = file_get_contents($sqlfile);
$sql .= file_get_contents($sqlfile_dbinstall);
if ($demodb) {
$sql .= file_get_contents($sqlfile_demodb);
}
foreach ($func_app as $key => $value) {
if ($value['isdel'] && in_array($value['appcode'], $apptype)) {
$sqlfilepath = admin_ROOT . './install/dbmysql/' . $value['sqlfile'];
$sql .= file_get_contents($sqlfilepath);
}
}
$sql = str_replace("\r\n", "\n", $sql);
$sql = str_replace("\r", "\n", str_replace("`" . ORIG_TABLEPRE, "`" . $tablepre, $sql));
$ret = array();
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}` DEFAULT CHARACTER SET " . DBCHARSET);
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}`");
}
if (mysql_errno()) {
message($LAN['database_errno_1044'], mysql_error());
}
mysql_close();
}
if (empty($dbname) || empty($password)) {
message($LAN['dbname_invalid'], $LAN['dbnameempay']);
}
$password = md5($password);
$nowtime = time();
config_edit($postlist);
$db = new dbmysq();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, DBCHARSET);
$sql = file_get_contents($sqlfile);
if ($demodb) {
$sql .= file_get_contents($sqlfile2);
}
$sql = str_replace("\r\n", "\n", $sql);
$sql = str_replace("\r", "\n", str_replace("`" . ORIG_TABLEPRE, "`" . $tablepre, $sql));
$ret = array();
$num = 0;
foreach (explode(";\n", trim($sql)) as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$ret[$num] .= isset($query[0]) && $query[0] == '#' || isset($query[1]) && isset($query[1]) && $query[0] . $query[1] == '--' ? '' : $query;
}
