function db_test()
{
include_once EZSQL_LIB . "/shared/ez_sql_core.php";
include_once EZSQL_LIB . "/mysql/ez_sql_mysql.php";
$db = new ezSQL_mysql(DB_USER, DB_PASSWD, DB_NAME, DB_HOST);
return @$db->quick_connect(DB_USER, DB_PASSWD, DB_NAME, DB_HOST);
}
function phpbb_connect()
{
global $settings, $db, $phpbb_db;
if ($settings['user']) {
$dbname = strpos($settings['db'], '.') > 0 ? substr($settings['db'], 0, strpos($settings['db'], '.')) : $settings['db'];
$db1 = new ezSQL_mysql($settings['user'], $settings['pass'], $dbname, $settings['host']);
$db1->show_errors = true;
$db1->quick_connect($settings['user'], $settings['pass'], $dbname, $settings['host']);
if (count($db1->captured_errors) > 0) {
return null;
}
return $db1;
} else {
return $db;
}
}
function database_setup($h, $settings_file_exists)
{
global $lang;
//already included so Hotaru can't re-include it
if ($h->cage->post->KeyExists('updated')) {
$settings = new \stdClass();
$error = 0;
// Test CSRF
// if (!$h->csrf('check', 'index')) {
// $h->messages[$lang['install_step3_csrf_error']] = 'red';
// $error = 1;
// }
// Test baseurl
$settings->baseurl_name = $h->cage->post->testUri('baseurl');
if (!$settings->baseurl_name) {
$h->messages[$lang['install_step1_baseurl_error']] = 'red';
$error = 1;
}
// Test dbname
$settings->dbuser_name = $h->cage->post->testAlnumLines('dbuser');
if (!$settings->dbuser_name) {
$h->messages[$lang['install_step1_dbuser_error']] = 'red';
$error = 1;
}
// Test dbpassword
$settings->dbpassword_name = $h->cage->post->KeyExists('dbpassword');
if (!$settings->dbpassword_name) {
$h->messages[$lang['install_step1_dbpassword_error']] = 'red';
$error = 1;
}
// Test dbname
$settings->dbname_name = $h->cage->post->testAlnumLines('dbname');
if (!$settings->dbname_name) {
$h->messages[$lang['install_step1_dbname_error']] = 'red';
$error = 1;
}
// Test dbprefix
$settings->dbprefix_name = $h->cage->post->testAlnumLines('dbprefix');
if (!$settings->dbprefix_name) {
$h->messages[$lang['install_step1_dbprefix_error']] = 'red';
$error = 1;
}
// Test dbhost
$settings->dbhost_name = $h->cage->post->testAlpha('dbhost');
if (!$settings->dbhost_name) {
$h->messages[$lang['install_step1_dbhost_error']] = 'red';
$error = 1;
}
} else {
$settings = settingsFile($settings_file_exists);
}
// Show messages
if ($h->cage->post->getAlpha('updated') == 'true') {
if (!$error) {
// Try to write file to disk based on form inputs
$fputs = create_new_settings_file($settings->dbuser_name, $settings->dbpassword_name, $settings->dbname_name, $settings->dbprefix_name, $settings->dbhost_name, $settings->baseurl_name);
// if file written successfully then
if ($fputs) {
$h->messages[$lang['install_step1_update_file_writing_success']] = 'green';
// if yes set warning message var
} else {
$h->messages[$lang['install_step1_update_file_writing_failure']] = 'red';
}
}
@chmod(SETTINGS, 0644);
}
// Check whether database and tables exist on this server
$db = new ezSQL_mysql($settings->dbuser_name, $settings->dbpassword_name, $settings->dbname_name, $settings->dbhost_name);
$db->show_errors = false;
$database_exists = $db->quick_connect($settings->dbuser_name, $settings->dbpassword_name, $settings->dbname_name, $settings->dbhost_name);
$table_exists = $database_exists ? table_exists($db, 'miscdata', $settings->dbprefix_name) : false;
$show_next = $database_exists ? true : false;
if ($settings->dbpassword_name && !$database_exists) {
$h->messages[$lang['install_step1_no_db_exists_failure']] = 'red';
}
// Try to write the /config/settings.php file to disk
//
@chmod(SETTINGS, 0777);
$settings_file_writeable = is_writeable(SETTINGS);
if ($settings_file_writeable) {
// show template
template($h, 'install/database_setup.php', array('settings_file_exists' => $settings_file_exists, 'cage' => $h->cage, 'table_exists' => $table_exists, 'show_next' => $show_next, 'baseurl_name' => $settings->baseurl_name, 'dbuser_name' => $settings->dbuser_name, 'dbpassword_name' => $settings->dbpassword_name, 'dbname_name' => $settings->dbname_name, 'dbprefix_name' => $settings->dbprefix_name, 'dbhost_name' => $settings->dbhost_name));
} else {
@chmod(SETTINGS, 0644);
database_setup_manual($h);
}
}
<?php
require_once "ez_sql_core.php";
require_once "ez_sql_mysql.php";
if (isset($configuration['database'])) {
$db = new ezSQL_mysql();
// auto connect to the db in order to have a valid connection when calling $db->escape() for creating queries
$db->quick_connect($configuration['database']['username'], $configuration['database']['password'], $configuration['database']['name'], $configuration['database']['server']);
}