try {
echo "Creating SQLITE database.<br>\n";
echo "Successful created database.<br>\n";
$db->exec('CREATE TABLE Options(Name TEXT, Value TEXT)');
echo "Successful created Options TABLE with key -> Name and Value.<br>\n";
$db->exec('CREATE TABLE Admin(Id INTEGER PRIMARY KEY AUTOINCREMENT, Username TEXT, Password TEXT, Key TXT)');
echo "Successful created Admin TABLE with key -> Id, Username, Password and Key.<br>\n";
$db->exec('CREATE TABLE Post(Id INTEGER PRIMARY KEY AUTOINCREMENT, Title TEXT, Value TEXT, Date TEXT, Author TEXT, View REAL)');
echo "Successful created Post TABLE with key -> Id, Title, Value, Date, Author and View.<br>\n";
$db->exec('CREATE TABLE Comment(Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Email TEXT, Value TEXT, PostID INTEGER, Time REAL, Ip TEXT)');
echo "Successful created Comment TABLE with key -> Id, Name, Email, Value, PostID, Time And Ip.<br>\n";
$db->exec("INSERT INTO Options (Name,Value) values ('title','" . $db->escapeString($_POST['web_title']) . "');");
echo "Successful insert WEBSITE TITLE data into Options table<br>\n";
$username = $db->escapeString($_POST['admin_username']);
$password = hash('ripemd320', $_POST['admin_password']);
$db->exec("INSERT INTO Admin (Username, Password, Key) values ('" . $username . "', '" . $password . "', '" . $instance->str_rand(50) . "');");
echo "Successful insert ADMIN data into Admin table<br>\n";
$db->exec("INSERT INTO Post (Id, Title, Value, Date, Author, View) values (1, 'First Post','" . $instance->compress_string('Hello World!') . "', '" . time() . "', '" . $username . "', '1');");
echo "Successful insert first post into your website!<br>\n";
$comment = "(1, '" . $username . "','" . htmlentities($_SERVER['SERVER_ADMIN']) . "', '" . $instance->compress_string("First Comment") . "', '1', '" . time() . "', '" . $_SERVER['REMOTE_ADDR'] . "')";
$db->exec("INSERT INTO Comment (Id, Name, Email, Value, PostID, Time, Ip) values " . $comment . ";");
echo "Successful insert first comment into your website!<br>\n";
// release SQLITE handle to the file
// so we can rename our file without an error
$db->close();
$junk_db_name = "database_" . hash('crc32b', $instance->str_rand(100)) . ".db";
echo "Rename mysqlite.db into " . $junk_db_name . "<br>\n";
if (!rename('./database/mysqlite.db', './database/' . $junk_db_name)) {
throw new Exception("Error when trying to rename database file.<br>\n");
}
echo "Insert junk string data into config.php file..<br>\n";
