write_config_file($database, $hostname, $username, $password, $db_layer, $db_type, $prefix, $lang, $salt, $timezone); break; /** * Create the database. */ /** * Create the database. */ case "make_database": $databaseName = $_REQUEST['database']; $hostname = $_REQUEST['hostname']; $username = $_REQUEST['username']; $password = $_REQUEST['password']; $server_type = $_REQUEST['db_type']; $db_layer = $_REQUEST['db_layer']; $db_error = false; $result = false; $database = new Kimai_Database_Mysql($result); $database->connect($hostname, null, $username, $password, true, $server_type); $conn = $database->getConnectionHandler(); $query = "CREATE DATABASE `" . $databaseName . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"; $result = $conn->Query($query); if ($result !== false) { echo "1"; // <-- hat geklappt } else { echo "0"; // <-- schief gegangen } break; }
if (isset($_COOKIE['kimai_db']) && $_COOKIE['kimai_db'] == true) { $dbnr = $_COOKIE['kimai_db'] - 1; $kga['server_database'] = $server_ext_database[$dbnr]; if ($server_ext_username[$dbnr] != '') { $kga['server_username'] = $server_ext_username[$dbnr]; } if ($server_ext_password[$dbnr] != '') { $kga['server_password'] = $server_ext_password[$dbnr]; } if ($server_ext_prefix[$dbnr] != '') { $kga['server_prefix'] = $server_ext_prefix[$dbnr]; } } } $database = new Kimai_Database_Mysql($kga); $database->connect($kga['server_hostname'], $kga['server_database'], $kga['server_username'], $kga['server_password'], $kga['utf8'], $kga['server_type']); if (!$database->isConnected()) { die('Kimai could not connect to database. Check your autoconf.php.'); } Kimai_Registry::setDatabase($database); global $translations; $translations = new Translations($kga); if ($kga['language'] != 'en') { $translations->load($kga['language']); } $vars = $database->configuration_get_data(); if (!empty($vars)) { $kga['currency_name'] = $vars['currency_name']; $kga['currency_sign'] = $vars['currency_sign']; $kga['show_sensible_data'] = $vars['show_sensible_data']; $kga['show_update_warn'] = $vars['show_update_warn'];