"; include ('header.html'); $group_array = array(); $i = 1; while ($i <= $_SESSION[group_number]) { $group = "group$i"; array_push($group_array, "$_POST[$group]"); $i++; } $i = 1; //test connection to dbase verifing dbase name, server, username and password $connection = @mysql_connect($_SESSION[dbase_server], $_SESSION[dbase_username], $_SESSION[dbase_password]) or die(mysql_error()); $db = @mysql_select_db($_SESSION[dbase_name],$connection) or die(mysql_error()); //create a message to be displayed at the end of the installation if ($db) { echo "Connection to Database $_SESSION[dbase_name] Successful.
"; }else{ echo "

There was an error connecting to the database.

"; echo "

Please go back and check your Database information.

"; exit; } //create a table in that dbase $sql =" CREATE TABLE IF NOT EXISTS $_SESSION[table_name] ( firstname VARCHAR(20), lastname VARCHAR(20), username VARCHAR(20), password VARCHAR(50), group1 VARCHAR(20), group2 VARCHAR(20), group3 VARCHAR(20), pchange VARCHAR(1), email VARCHAR(100), redirect VARCHAR(100), verified VARCHAR(1), last_login DATE )"; $result = @mysql_query($sql,$connection) or die(mysql_error()); if ($result) { echo "Table $_SESSION[table_name] has been created.
"; }else{ echo "

There was an error creating the table.

"; echo "

Please go back and check your information.

"; exit; } //create a table in that dbase $sql_log =" CREATE TABLE IF NOT EXISTS log_login ( username VARCHAR(20), date VARCHAR(20), time VARCHAR(20), ip_addr VARCHAR(20), oper_sys VARCHAR(20), brow VARCHAR(20) ) "; $result_log = @mysql_query($sql_log,$connection) or die(mysql_error()); if ($result_log) { echo "Table log_login has been created.
"; }else{ echo "

There was an error creating the table.

"; echo "

Please go back and check your information.

"; exit; } //create a table in that dbase $sql_ban =" CREATE TABLE IF NOT EXISTS banned ( no_access VARCHAR(30), type VARCHAR(10) ) "; $result_ban = @mysql_query($sql_ban,$connection) or die(mysql_error()); if ($result_ban) { echo "Table banned has been created.
"; }else{ echo "

There was an error creating the table.

"; echo "

Please go back and check your information.

"; exit; } //create a table in that dbase $sql_trash =" CREATE TABLE IF NOT EXISTS trash ( firstname VARCHAR(20), lastname VARCHAR(20), username VARCHAR(20), password VARCHAR(50), group1 VARCHAR(20), group2 VARCHAR(20), group3 VARCHAR(20), pchange VARCHAR(1), email VARCHAR(100), redirect VARCHAR(100), verified VARCHAR(1), last_login DATE, del_date DATE ) "; $result_trash = @mysql_query($sql_trash,$connection) or die(mysql_error()); if ($result_trash) { echo "Table trash has been created.
"; }else{ echo "

There was an error creating the table.

"; echo "

Please go back and check your information.

"; exit; } ?> Login - Redirect Installation
"; include ('create_admin.php'); ?>