<?php
include ('header.php');
?>
<table width="60%" cellpadding="10" align="center" border="0" class="install">
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
<tr><th colspan="2">Database Settings</th></tr>
<tr><td>Database Host:</td> <td><input type="text" name="dbhost" value=""/></td></tr>
<tr><td>Database Username:</td> <td><input type="text" name="dbuser" value=""/></td></tr>
<tr><td>Database Password:</td> <td><input type="text" name="dbpass" value=""/></td></tr>
<tr><td>Database Name:</td> <td><input type="text" name="dbname" value=""/></td></tr>

<tr><th colspan="2">Blog Settings</th></tr>
<tr><td>No. Posts Per Page(In Blog):</td> <td><input type="text" value="11" name="ppp"/></td></tr>
<tr><td>No. Posts Per Page(In Admin Area):</td> <td><input type="text" value="11" name="appp"/></td></tr>
<tr><td>Show WYSIWYG Editor in Comments:</td> <td><input type="radio" name="wysiwyg" value="0"/> No &nbsp;
<input name="wysiwyg" type="radio" value="1" checked="checked" /> Yes</td></tr>
<tr><td>Show Comment Box In Posts:</td> <td><input type="radio" name="comm" value="0"/> No &nbsp;
<input name="comm" type="radio" value="1" checked="checked" /> Yes</td></tr>

<tr><th colspan="2">Admin Area Settings</th></tr>
<tr><td>Username: <input type="text" value="" name="user"/></td>
<td>Password: <input type="text" value="" name="pass"/></td></tr>
<tr><th colspan="2" style="text-align: center;"><input type="submit" name="submit" value="Install" /></th></tr>
</form>
</table>

<?php
if (isset($_POST['submit'])) {
    $dbhost = $_POST['dbhost'];
    $dbuser = $_POST['dbuser'];
    $dbpass = $_POST['dbpass'];
    $dbname = $_POST['dbname'];
    $username = $_POST['user'];
    $password = $_POST['pass'];
    $dbuser = stripslashes($dbuser);
    $dbpass = stripslashes($dbpass);
    $username = stripslashes($username);
    $password = stripslashes($password);
    $password = md5($password);

    $ppp = $_POST['ppp'];
    $appp = $_POST['appp'];
    $wysiwyg = $_POST['wysiwyg'];
    $comm = $_POST['comm'];

    $config_file = "../include/config.php";
    $open_file = fopen($config_file, "a");
    $contents = '<?php
$dbhost = "'.$dbhost.'"; //Your Database Host
$dbuser = "'.$dbuser.'"; //Your Database Username
$dbpass = "'.$dbpass.'"; //Your Database Password
$dbname = "'.$dbname.'"; //Your Database Name
$dbtable1 = "category"; //Category Table (Please dont edit this)
$dbtable2 = "posts"; //Posts Table (Please dont edit this)
$ppp = '.$ppp.'; //Number of Posts per Page (for Public)
$admin_ppp = '.$appp.'; //Number of Posts to Display in  Admin Edit Area
$wysiwyg_in_comm = '.$wysiwyg.'; //Show WYSIWYG Editor in Comments (0=hide , 1=show)
$show_comm = '.$comm.'; //Show or Hide "Comment box" in Posts (0=hide , 1=show)
?>';
$file = 'install.php';

$write_file = fwrite($open_file, $contents);
    if (!$write_file) {
        echo "<div class='error'><span class='icon'></span> Config File Installing Failed...</div>";
        unlink($config_file);
    } else {
        echo "<div class='success'><span class='icon'></span> Config File Installed...</div>";
    }
include('../include/config.php');
$conn = mysql_connect($dbhost,$dbuser,$dbpass);
// Create database
    if (mysql_query("CREATE DATABASE ".$dbname,$conn)) {
        echo "<div class='success'><span class='icon'></span> Database Created...</div>";
    } else {
        echo "<div class='error'><span class='icon'></span> Error creating database: " . mysql_error()."</div>";
        unlink($config_file);
    }

    // Create table
    mysql_select_db($dbname, $conn);
    $sql1 = "CREATE TABLE admin
    (
    id int(11) NOT NULL AUTO_INCREMENT,
    username varchar(50) NOT NULL,
    password varchar(50) NOT NULL,
    PRIMARY KEY (id)
    )";

    $sql2 = "CREATE TABLE posts
    (
    post_id int(11) NOT NULL AUTO_INCREMENT,
    cat_id int(11) NOT NULL DEFAULT '1',
    post_publish int(11) NOT NULL DEFAULT '1',
    post_title text NOT NULL,
    post_image text NOT NULL,
    post_date varchar(50) NOT NULL,
    post_time varchar(50) NOT NULL,
    post_content longtext NOT NULL,
    attach_name varchar(50) NOT NULL,
    attach_type varchar(50) NOT NULL,
    attach_size varchar(50) NOT NULL,
    attach_link varchar(100) NOT NULL,
    PRIMARY KEY (post_id)
    )";

    $sql3 = "CREATE TABLE comments
    (
    id int(11) NOT NULL AUTO_INCREMENT,
    page text NOT NULL,
    name varchar(50) NOT NULL,
    email varchar(50) NOT NULL,
    comment mediumtext NOT NULL,
    ip varchar(50) NOT NULL DEFAULT '0',
    comment_date varchar(50) NOT NULL,
    comment_time varchar(50) NOT NULL,
    PRIMARY KEY (id)
    )";

    $sql4 = "CREATE TABLE category (
    category_id int(11) NOT NULL AUTO_INCREMENT,
    category_name varchar(50) NOT NULL,
    PRIMARY KEY (category_id)
    )";

    // Execute query
    mysql_query($sql1,$conn);
    mysql_query($sql2,$conn);
    mysql_query($sql3,$conn);
    mysql_query($sql4,$conn);

    $query = "INSERT INTO admin (id, username, password) VALUES (1, '$username', '$password')";

    if (mysql_query($query)) {
        echo "<div class='success'><span class='icon'></span> Blog Installation Finished...</div>";
        echo "<meta http-equiv='Refresh' content='3;url=login.php'/>";
    } else {
        echo "<div class='error'><span class='icon'></span> Error Occured: ".mysql_error()."</div>";
        unlink($config_file);
    }
}
?>
<?php
include ('footer.php');
?>