die();
*/
// for as long as setup is not complete,
// this will evaluate to true
if (!file_exists('config/config.php')) {
require 'config/setup.php';
}
require 'config/config.php';
// sanity check
if (empty($dbhost) || empty($dbname) || !isset($dbuser) || !isset($dbpass) || !isset($dbprefix)) {
require 'error/config.php';
}
require 'dbaccess_mysqli.php';
try {
$dbaccess = new dbaccess_mysqli($dbhost, $dbuser, $dbpass, $dbname, $dbprefix);
} catch (Exception $e) {
require 'error/dbaccess.php';
}
if (!empty($_SESSION['LAST_ACTIVITY']) && time() - $_SESSION['LAST_ACTIVITY'] > 60 * 120) {
require 'login/index.php';
}
// check which page we are in
$page = '';
if ($_SERVER['REQUEST_METHOD'] == 'GET' && isset($_GET['p'])) {
$page = $_GET['p'];
} else {
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['p'])) {
$page = $_POST['p'];
}
}
if (empty($dbhost)) {
$dbhost_err = 'Field required';
}
$dbname = $_POST['dbname'];
if (empty($dbname)) {
$dbname_err = 'Field required';
}
$dbuser = $_POST['dbuser'];
$dbpass = $_POST['dbpass'];
$dbprefix = $_POST['dbprefix'];
if (empty($admin_pass_err) && empty($dbhost_err) && empty($dbname_err) && empty($dbuser_err) && empty($dbpass_err)) {
// TODO
// check if we can create a table and insert values
require 'dbaccess_mysqli.php';
try {
$db = new dbaccess_mysqli($dbhost, $dbuser, $dbpass, $dbname, $dbprefix);
if (!$db->isValid()) {
require 'error/setup.php';
}
// create tables
// check if tables already exist
// happens if setup is run due to corrupted config file
// or if it is incorrectly editted manually
//if (!$db->check_table('user_data'))
$ret = $db->query("CREATE TABLE IF NOT EXISTS {$dbprefix}user_data (\n user_id INT(6) UNSIGNED AUTO_INCREMENT,\n uname VARCHAR(32) NOT NULL,\n fname VARCHAR(30) NOT NULL,\n lname VARCHAR(30) NOT NULL,\n gender CHAR(1) NOT NULL,\n type CHAR(1) NOT NULL,\n pass VARCHAR(255) NOT NULL,\n login VARCHAR(255) NOT NULL,\n PRIMARY KEY (user_id) )");
$ret = $db->get_error();
if ($db->uname_exists("admin")) {
$db->change_password("admin", $admin_pass);
} else {
$ret = $db->add_user("Admin", "neto", "f", "admin", $admin_pass, "t");
}
