$SQL .= "`diameter` = '12750', ";
$SQL .= "`field_max` = '163', ";
$SQL .= "`temp_min` = '47', ";
$SQL .= "`temp_max` = '87', ";
$SQL .= "`metal` = '500', ";
$SQL .= "`metal_perhour` = '0', ";
$SQL .= "`metal_max` = '1000000', ";
$SQL .= "`crystal` = '500', ";
$SQL .= "`crystal_perhour` = '0', ";
$SQL .= "`crystal_max` = '1000000', ";
$SQL .= "`deuterium` = '500', ";
$SQL .= "`deuterium_perhour` = '0', ";
$SQL .= "`deuterium_max` = '1000000';";
$SQL .= "INSERT INTO " . STATPOINTS . " (`id_owner`, `id_ally`, `stat_type`, `tech_rank`, `tech_old_rank`, `tech_points`, `tech_count`, `build_rank`, `build_old_rank`, `build_points`, `build_count`, `defs_rank`, `defs_old_rank`, `defs_points`, `defs_count`, `fleet_rank`, `fleet_old_rank`, `fleet_points`, `fleet_count`, `total_rank`, `total_old_rank`, `total_points`, `total_count`) VALUES ('1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
$SQL .= "UPDATE " . CONFIG . " SET `lang` = '" . $LANG->GetUser() . "';";
$db->multi_query($SQL);
ini_set('session.save_path', ROOT_PATH . 'cache/sessions');
ini_set('upload_tmp_dir', ROOT_PATH . 'cache/sessions');
ini_set('session.use_cookies', '1');
ini_set('session.use_only_cookies', '1');
session_set_cookie_params(SESSION_LIFETIME, '/');
session_cache_limiter('nocache');
session_name($dbsettings["secretword"]);
ini_set('session.use_trans_sid', 0);
ini_set('session.auto_start', '0');
ini_set('session.serialize_handler', 'php');
ini_set('session.gc_maxlifetime', SESSION_LIFETIME);
ini_set('session.gc_probability', '1');
ini_set('session.gc_divisor', '1000');
ini_set('session.bug_compat_warn', '0');
ini_set('session.bug_compat_42', '0');
$GLOBALS['database']['host'] = request_var('host', '');
$GLOBALS['database']['port'] = request_var('port', 0);
$GLOBALS['database']['user'] = request_var('user', '', true);
$GLOBALS['database']['userpw'] = request_var('passwort', '', true);
$prefix = request_var('prefix', '', true);
$GLOBALS['database']['databasename'] = request_var('db', '', true);
$connection = new DB_MySQLi(true);
if (mysqli_connect_errno()) {
exit($template->message(sprintf($LNG['step2_db_con_fail'], mysqli_connect_error()), "?mode=ins&page=1&lang=" . $LANG, 3, true));
}
@chmod("../includes/config.php", 0777);
if (!is_writable('../includes/config.php')) {
exit($template->message($LNG['step2_conf_op_fail'], "?mode=ins&page=1&lang=" . $LANG, 3, true));
}
$first = "Verbindung zur Datenbank erfolgreich...";
$connection->multi_query(str_replace("prefix_", $prefix, file_get_contents('install.sql')));
$second = $LNG['step2_db_ok'];
file_put_contents("../includes/config.php", "<?php\n" . "//### Database access ###//\n\n" . "\$database['host'] = '" . $GLOBALS['database']['host'] . "';\n" . "\$database['port'] = '" . $GLOBALS['database']['port'] . "';\n" . "\$database['user'] = '******'database']['user'] . "';\n" . "\$database['userpw'] = '" . $GLOBALS['database']['userpw'] . "';\n" . "\$database['databasename'] = '" . $GLOBALS['database']['databasename'] . "';\n" . "\$database['tableprefix'] = '" . $prefix . "';\n" . "\$dbsettings['secretword'] = '2Moons_" . mt_rand(1000, 9999999999) . "';\n\n" . "//### Do not change beyond here ###//\n" . "?>");
@chmod("../includes/config.php", 0444);
$third = "config.php erfolgreich erstellt...";
$template->assign_vars(array('first' => $first, 'second' => $second, 'third' => $third, 'continue' => $LNG['continue']));
$template->show('install/ins_form_done.tpl');
} elseif ($Page == 3) {
$template->assign_vars(array('step3_create_admin' => $LNG['step3_create_admin'], 'step3_admin_name' => $LNG['step3_admin_name'], 'step3_admin_pass' => $LNG['step3_admin_pass'], 'step3_admin_mail' => $LNG['step3_admin_mail'], 'continue' => $LNG['continue']));
$template->show('install/ins_acc.tpl');
} elseif ($Page == 4) {
$adm_user = $_POST['adm_user'];
$adm_pass = $_POST['adm_pass'];
$adm_email = $_POST['adm_email'];
$md5pass = md5($adm_pass);
if (empty($_POST['adm_user']) && empty($_POST['adm_pas']) && empty($_POST['adm_email'])) {
