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";