function step4($host, $user, $password, $databasename, $newdatabasename)
{
global $LANG;
//display the form to return to the previous step.
echo "<h3>" . $LANG['install'][24] . "</h3>";
function prev_form($host, $user, $password)
{
global $LANG;
echo "<br><form action='install.php' method='post'>";
echo "<input type='hidden' name='db_host' value='" . $host . "'>";
echo "<input type='hidden' name='db_user' value='" . $user . "'>";
echo " <input type='hidden' name='db_pass' value='" . rawurlencode($password) . "'>";
echo "<input type='hidden' name='update' value='no'>";
echo "<input type='hidden' name='install' value='Etape_2'>";
echo "<p class='submit'><input type='submit' name='submit' class='submit' value='" . $LANG['buttons'][13] . "'></p>";
echo "</form>";
}
//Display the form to go to the next page
function next_form()
{
global $LANG;
echo "<br><form action='install.php' method='post'>";
echo "<input type='hidden' name='install' value='Etape_4'>";
echo "<p class='submit'><input type='submit' name='submit' class='submit' value='" . $LANG['install'][26] . "'></p>";
echo "</form>";
}
//Fill the database
function fill_db()
{
global $LANG, $CFG_GLPI;
include_once GLPI_ROOT . "/inc/dbmysql.class.php";
include_once GLPI_CONFIG_DIR . "/config_db.php";
$DB = new DB();
if (!$DB->runFile(GLPI_ROOT . "/install/mysql/glpi-0.80.1-empty.sql")) {
echo "Errors occurred inserting default database";
}
// update default language
$query = "UPDATE `glpi_configs`\n SET `language` = '" . $_SESSION["glpilanguage"] . "'";
$DB->query($query) or die("4203 " . $LANG['update'][90] . $DB->error());
$query = "UPDATE `glpi_users`\n SET `language` = NULL";
$DB->query($query) or die("4203 " . $LANG['update'][90] . $DB->error());
}
$link = mysql_connect($host, $user, $password);
if (!empty($databasename)) {
// use db already created
$DB_selected = mysql_select_db($databasename, $link);
if (!$DB_selected) {
echo $LANG['install'][41];
echo "<br>" . $LANG['install'][36] . " " . mysql_error();
prev_form($host, $user, $password);
} else {
if (create_conn_file($host, $user, $password, $databasename)) {
fill_db();
echo "<p>" . $LANG['install'][43] . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . $LANG['install'][47] . "</p>";
prev_form($host, $user, $password);
}
}
} else {
if (!empty($newdatabasename)) {
// create new db
// Try to connect
if (mysql_select_db($newdatabasename, $link)) {
echo "<p>" . $LANG['install'][82] . "</p>";
if (create_conn_file($host, $user, $password, $newdatabasename)) {
fill_db();
echo "<p>" . $LANG['install'][43] . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . $LANG['install'][47] . "</p>";
prev_form($host, $user, $password);
}
} else {
// try to create the DB
if (mysql_query("CREATE DATABASE IF NOT EXISTS `" . $newdatabasename . "`")) {
echo "<p>" . $LANG['install'][82] . "</p>";
if (mysql_select_db($newdatabasename, $link) && create_conn_file($host, $user, $password, $newdatabasename)) {
fill_db();
echo "<p>" . $LANG['install'][43] . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . $LANG['install'][47] . "</p>";
prev_form($host, $user, $password);
}
} else {
// can't create database
echo $LANG['install'][48];
echo "<br>" . $LANG['install'][42] . mysql_error();
prev_form($host, $user, $password);
}
}
} else {
// no db selected
echo "<p>" . $LANG['install'][49] . "</p>";
//prev_form();
prev_form($host, $user, $password);
}
}
mysql_close($link);
}
function step4($databasename, $newdatabasename)
{
$host = $_SESSION['db_access']['host'];
$user = $_SESSION['db_access']['user'];
$password = $_SESSION['db_access']['password'];
//display the form to return to the previous step.
echo "<h3>" . __('Initialization of the database') . "</h3>";
function prev_form($host, $user, $password)
{
echo "<br><form action='install.php' method='post'>";
echo "<input type='hidden' name='db_host' value='" . $host . "'>";
echo "<input type='hidden' name='db_user' value='" . $user . "'>";
echo " <input type='hidden' name='db_pass' value='" . rawurlencode($password) . "'>";
echo "<input type='hidden' name='update' value='no'>";
echo "<input type='hidden' name='install' value='Etape_2'>";
echo "<p class='submit'><input type='submit' name='submit' class='submit' value='" . __s('Back') . "'></p>";
Html::closeForm();
}
//Display the form to go to the next page
function next_form()
{
echo "<br><form action='install.php' method='post'>";
echo "<input type='hidden' name='install' value='Etape_4'>";
echo "<p class='submit'><input type='submit' name='submit' class='submit' value='" . __('Continue') . "'></p>";
Html::closeForm();
}
//Fill the database
function fill_db()
{
global $CFG_GLPI, $DB;
//include_once (GLPI_ROOT . "/inc/dbmysql.class.php");
include_once GLPI_CONFIG_DIR . "/config_db.php";
$DB = new DB();
if (!$DB->runFile(GLPI_ROOT . "/install/mysql/glpi-0.85.3-empty.sql")) {
echo "Errors occurred inserting default database";
}
// update default language
Config::setConfigurationValues('core', array('language' => $_SESSION["glpilanguage"]));
$query = "UPDATE `glpi_users`\n SET `language` = NULL";
$DB->queryOrDie($query, "4203");
}
//Check if the port is in url
$hostport = explode(":", $host);
if (count($hostport) < 2) {
$link = new mysqli($hostport[0], $user, $password);
} else {
$link = new mysqli($hostport[0], $user, $password, '', $hostport[1]);
}
$databasename = $link->real_escape_string($databasename);
$newdatabasename = $link->real_escape_string($newdatabasename);
if (!empty($databasename)) {
// use db already created
$DB_selected = $link->select_db($databasename);
if (!$DB_selected) {
_e('Impossible to use the database:');
echo "<br>" . sprintf(__('The server answered: %s'), $link->error);
prev_form($host, $user, $password);
} else {
if (create_conn_file($host, $user, $password, $databasename)) {
fill_db();
echo "<p>" . __('OK - database was initialized') . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . __('Impossible to write the database setup file') . "</p>";
prev_form($host, $user, $password);
}
}
} else {
if (!empty($newdatabasename)) {
// create new db
// Try to connect
if ($link->select_db($newdatabasename)) {
echo "<p>" . __('Database created') . "</p>";
if (create_conn_file($host, $user, $password, $newdatabasename)) {
fill_db();
echo "<p>" . __('OK - database was initialized') . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . __('Impossible to write the database setup file') . "</p>";
prev_form($host, $user, $password);
}
} else {
// try to create the DB
if ($link->query("CREATE DATABASE IF NOT EXISTS `" . $newdatabasename . "`")) {
echo "<p>" . __('Database created') . "</p>";
if ($link->select_db($newdatabasename) && create_conn_file($host, $user, $password, $newdatabasename)) {
fill_db();
echo "<p>" . __('OK - database was initialized') . "</p>";
next_form();
} else {
// can't create config_db file
echo "<p>" . __('Impossible to write the database setup file') . "</p>";
prev_form($host, $user, $password);
}
} else {
// can't create database
echo __('Error in creating database!');
echo "<br>" . sprintf(__('The server answered: %s'), $link->error);
prev_form($host, $user, $password);
}
}
} else {
// no db selected
echo "<p>" . __("You didn't select a database!") . "</p>";
//prev_form();
prev_form($host, $user, $password);
}
}
$link->close();
}
}
// Fill the db with test data
function fill_db()
{
global $db;
$records = $db->query('SELECT id, title, contents FROM posts LIMIT 0, 3')->fetchAll(PDO::FETCH_OBJ);
$sql = "INSERT INTO posts (category_id, title, contents) VALUES (0, '%s', '%s')";
for ($i = 0; $i < 5000; $i++) {
$r = mt_rand(0, 2);
$db->query(sprintf($sql, $records[$r]->title, $records[$r]->contents));
}
}
if (isset($_SERVER['argv'][1]) and $_SERVER['argv'][1] == 'fill') {
echo 'Generating test data.' . PHP_EOL;
for ($i = 0; $i < 10; $i++) {
fill_db();
echo ($i + 1) * 5000 . ' records generated.' . PHP_EOL;
}
exit;
}
Benchmark::start('select records');
$records = $db->query('SELECT id, title, contents FROM posts')->fetchAll(PDO::FETCH_OBJ);
Benchmark::stop('select records');
Benchmark::start('index');
$data = array('title' => 'Craiglist ads', 'records' => $records);
$index = parse('index.tpl', $data);
create('index', $index);
Benchmark::stop('index');
Benchmark::start('pages');
foreach ($records as $page) {
$data = array('page' => $page);