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);