db_err("stepBack2", "MySQL Error: " . mysql_error());
}
if ($DBname == "") {
db_err("stepBack", "The database name provided is empty.");
}
$configArray['DBhostname'] = $DBhostname;
$configArray['DBuserName'] = $DBuserName;
$configArray['DBpassword'] = $DBpassword;
$configArray['DBname'] = $DBname;
$configArray['DBPort'] = $DBPort;
$configArray['DBPrefix'] = $DBPrefix;
$sql = "CREATE DATABASE `{$DBname}`";
$mysql_result = mysql_query($sql);
$test = mysql_errno();
if ($test != 0 && $test != 1007) {
db_err("stepBack", "A database error occurred: " . mysql_error());
}
// db is now new or existing, create the db object connector to do the serious work
$DBserver = $DBPort ? "{$DBhostname}:{$DBPort}" : "{$DBhostname}";
$database = new database($DBserver, $DBuserName, $DBpassword, $DBname, $DBPrefix);
// delete existing mos table if requested
if ($DBDel) {
$database->setQuery("SHOW TABLES FROM `{$DBname}`");
$errors = array();
if ($tables = $database->loadResultArray()) {
foreach ($tables as $table) {
if ($DBPrefix) {
if (strpos($table, $DBPrefix) === 0) {
if ($DBBackup) {
$butable = str_replace($DBPrefix, $BUPrefix, $table);
$database->setQuery("DROP TABLE IF EXISTS `{$butable}`");
db_err("stepBack2", "MySql用户名或密码错误!请返回检查!");
}
if ($DBname == "") {
db_err("stepBack", "数据库名称设置错误!请返回检查!");
}
// Does this code actually do anything???
$configArray['DBhostname'] = $DBhostname;
$configArray['DBuserName'] = $DBuserName;
$configArray['DBpassword'] = $DBpassword;
$configArray['DBname'] = $DBname;
$configArray['DBPrefix'] = $DBPrefix;
$sql = "CREATE DATABASE `{$DBname}`";
$mysql_result = mysql_query($sql);
$test = mysql_errno();
if ($test != 0 && $test != 1007) {
db_err("stepBack", "访问数据库出错: " . mysql_error());
}
// db is now new or existing, create the db object connector to do the serious work
$database = new database($DBhostname, $DBuserName, $DBpassword, $DBname, $DBPrefix);
$database->setQuery("set names 'gb2312'");
// set charset
$database->query();
// kilin did it
// delete existing mos table if requested
if ($DBDel) {
$database->setQuery("SHOW TABLES FROM {$DBname}");
$errors = array();
if ($tables = $database->loadResultArray()) {
foreach ($tables as $table) {
if (strpos($table, $DBPrefix) === 0) {
if ($DBBackup) {
db_err('stepBack2', 'The password and username provided are incorrect.');
}
if ($DBname == '') {
db_err('stepBack', 'The database name provided is empty.');
}
// Does this code actually do anything???
$configArray['DBhostname'] = $DBhostname;
$configArray['DBuserName'] = $DBuserName;
$configArray['DBpassword'] = $DBpassword;
$configArray['DBname'] = $DBname;
$sql = "CREATE DATABASE `{$DBname}`";
$database->setQuery($sql);
$database->query();
$test = $database->getErrorNum();
if ($test != 0 && $test != 1007) {
db_err('stepBack', 'A database error occurred: ' . $database->getErrorMsg());
}
// db is now new or existing, create the db object connector to do the serious work
$database = new database($DBhostname, $DBuserName, $DBpassword, $DBname);
// delete existing mos table if exists
$query = "SHOW TABLES FROM `{$DBname}`";
$database->setQuery($query);
$errors = array();
if ($tables = $database->loadResultArray()) {
foreach ($tables as $table) {
$query = "DROP TABLE IF EXISTS `{$table}`";
$database->setQuery($query);
$database->query();
if ($database->getErrorNum()) {
$errors[$database->getQuery()] = $database->getErrorMsg();
}
$test = $database->getErrorMsg();
if (!$database->_resource) {
db_err('stepBack2', 'A senha ou nome de usuário estão incorretos.');
}
// Does this code actually do anything???
$configArray['DBhostname'] = $DBhostname;
$configArray['DBuserName'] = $DBuserName;
$configArray['DBpassword'] = $DBpassword;
$configArray['DBname'] = $DBname;
$configArray['DBPrefix'] = $DBPrefix;
$sql = "CREATE DATABASE `{$DBname}`";
$database->setQuery($sql);
$database->query();
$test = $database->getErrorNum();
if ($test != 0 && $test != 1007) {
db_err('stepBack', 'Ocorreu um erro com o banco de dados: ' . $database->getErrorMsg());
}
// db is now new or existing, create the db object connector to do the serious work
$database = new database($DBhostname, $DBuserName, $DBpassword, $DBname, $DBPrefix);
// delete existing mos table if requested
if ($DBDel) {
$query = "SHOW TABLES FROM `{$DBname}`";
$database->setQuery($query);
$errors = array();
if ($tables = $database->loadResultArray()) {
foreach ($tables as $table) {
if (strpos($table, $DBPrefix) === 0) {
if ($DBBackup) {
$butable = str_replace($DBPrefix, $BUPrefix, $table);
$query = "DROP TABLE IF EXISTS `{$butable}`";
$database->setQuery($query);
}
$database = new database($DBhostname, $DBuserName, $DBpassword, '', '', false);
$test = $database->getErrorMsg();
if (!$database->_resource) {
db_err('stepBack2', 'Le mot de passe et le nom d\'utilisateur sont incorrects.');
}
$configArray['DBhostname'] = $DBhostname;
$configArray['DBuserName'] = $DBuserName;
$configArray['DBpassword'] = $DBpassword;
$configArray['DBname'] = $DBname;
$sql = "CREATE DATABASE `{$DBname}`";
$database->setQuery($sql);
$database->query();
$test = $database->getErrorNum();
if ($test != 0 && $test != 1007) {
db_err('stepBack', 'Erreur de base de données : ' . $database->getErrorMsg());
}
$database = new database($DBhostname, $DBuserName, $DBpassword, $DBname, $DBPrefix);
populate_db($database);
function db_err($step, $alert)
{
global $DBhostname, $DBuserName, $DBpassword, $DBDel, $DBname;
echo "<form name=\"{$step}\" method=\"post\" action=\"install1.php\">\n\t<input type=\"hidden\" name=\"DBhostname\" value=\"{$DBhostname}\">\n\t<input type=\"hidden\" name=\"DBuserName\" value=\"{$DBuserName}\">\n\t<input type=\"hidden\" name=\"DBpassword\" value=\"{$DBpassword}\">\n\t</form>\n";
echo "<script type=\"text/javascript\">alert(\"{$alert}\"); document.location.href='install1.php';</script>";
exit;
}
function populate_db(&$database, $sqlfile = 'creermonjeu.sql')
{
global $errors;
$mqr = @get_magic_quotes_runtime();
@set_magic_quotes_runtime(0);
