if ($password != $confirm_pass) { $errors[] = 'Passwords do not match'; } } if (count($errors) == 0) { $db->sql_query("CREATE TABLE {$db->users} (\n `user_id` int(11) NOT NULL AUTO_INCREMENT,\n `username` varchar(150) NOT NULL,\n `password` varchar(225) NOT NULL,\n `group_id` int(11) NOT NULL,\n PRIMARY KEY (`user_id`),\n UNIQUE KEY `user_id_UNIQUE` (`user_id`)\n )"); if ($db->sql_query($sql_users)) { $user = new User($username, $password); //Checking this flag tells us whether there were any errors such as possible data duplication occured if (!$user->status) { if ($user->username_taken) { $error_user[] = 'Username already exist, please try a different name'; } } else { //Attempt to add the user to the database, carry out finishing tasks like emailing the user (if required) if (!$user->UserAdminAddUser()) { if ($user->sql_failure) { $error_user[] = 'Something went wrong, please try again'; } } } } $db->sql_query("CREATE TABLE {$db->groups} (\n `group_id` int(11) NOT NULL AUTO_INCREMENT,\n `group_name` varchar(225) NOT NULL,\n PRIMARY KEY (`group_id`)\n )"); $db->sql_query("INSERT INTO {$db->groups} (group_id,group_name) VALUES (1,'Administrator'),(2,'Standard User')"); $db->sql_query("CREATE TABLE {$db->sessions} (\n `session_start` int(11) NOT NULL,\n `session_data` text NOT NULL,\n `session_id` varchar(255) NOT NULL,\n PRIMARY KEY (`session_id`)\n )"); $errors = $db->sql_error(); if (!empty($errors['message'])) { $message = '<span style="color: red;">' . $errors['message'] . '</span>'; echo '<div id="errors" class="alert alert-danger">' . $message . '</div>'; } else { echo '<div id="errors" class="alert alert-success"><span style="color: green;">Database Created</span></div>';