install.php

<?php
/**
 * MASTER LOGIN SYSTEM
 * @author Mihai Ionut Vilcu (ionutvmi@gmail.com)
 * June 2013
 *
 */


include 'lib/mysql.class.php';
include 'lib/options.class.php';
$options = new Options;
$page = new stdClass();

if($_POST) {
  // we first check the settings file
  if(!is_writable('inc/settings.php'))
    chmod('inc/settings.php', 0666);


  // we make the db connection
  $db = new SafeMySQL(array(
  'host'  => $_POST['dbhost'], 
  'user'  => $_POST['dbuser'], 
  'pass'  => $_POST['dbpass'], 
  'db'    => $_POST['dbname']));


  // once that is done we write the details in the settings file
  $host = str_replace("'", "\'", $_POST['dbhost']);
  $user = str_replace("'", "\'", $_POST['dbuser']);
  $pass = str_replace("'", "\'", $_POST['dbpass']);
  $name = str_replace("'", "\'", $_POST['dbname']);
  $prefix = str_replace("'", "\'", $_POST['tbprefix']);

$data =<<<EEE
<?php

// Master Login System
// Mihai Ionut Vilcu (ionutvmi@gmail.com)
// configuration file


// database details
\$set->db_host = '$host'; // database host
\$set->db_user = '$user'; // database user
\$set->db_pass = '$pass'; // database password
\$set->db_name = '$name'; // database name

define('MLS_PREFIX', '$prefix');  

EEE;

  // add the data to the file
  if(!file_put_contents('inc/settings.php', $data))
    $page->error = "There is an error with inc/settings.php make sure it is writable.";



  $sqls[] = "
  CREATE TABLE IF NOT EXISTS `".$prefix."banned` (
  `userid` int(11) NOT NULL,
  `until` int(11) NOT NULL,
  `by` int(11) NOT NULL,
  `reason` varchar(255) NOT NULL,
  UNIQUE KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";


  $sqls[] = "
  CREATE TABLE IF NOT EXISTS `".$prefix."groups` (
  `groupid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  `color` varchar(50) NOT NULL,
  `canban` int(11) NOT NULL,
  `canhideavt` int(11) NOT NULL,
  `canedit` int(11) NOT NULL,
  PRIMARY KEY (`groupid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
";

  $sqls[] = "
  INSERT INTO `".$prefix."groups` (`groupid`, `name`, `type`, `priority`, `color`, `canban`, `canhideavt`, `canedit`) VALUES
(1, 'Guest', 0, 1, '', 0, 0, 0),
(2, 'Member', 1, 1, '#08c', 0, 0, 0),
(3, 'Moderator', 2, 1, 'green', 1, 1, 0),
(4, 'Administrator', 3, 1, '#F0A02D', 1, 1, 1);";

  $sqls[] = "
  CREATE TABLE IF NOT EXISTS `".$prefix."privacy` (
  `userid` int(11) NOT NULL,
  `email` int(11) NOT NULL,
  UNIQUE KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

  $sqls[] = "
  INSERT INTO `".$prefix."privacy` (`userid`, `email`) VALUES (1, 0);";
  $sqls[] = "
  CREATE TABLE IF NOT EXISTS `".$prefix."settings` (
  `site_name` varchar(255) NOT NULL DEFAULT 'Demo Site',
  `url` varchar(300) NOT NULL,
  `admin_email` varchar(255) NOT NULL,
  `max_ban_period` int(11) NOT NULL DEFAULT '10',
  `register` int(11) NOT NULL DEFAULT '1',
  `email_validation` int(11) NOT NULL DEFAULT '0',
  `captcha` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;";

  $sqls[] = $db->parse("
  INSERT INTO `".$prefix."settings` (`site_name`, `url`, `admin_email`, `max_ban_period`, `register`, `email_validation`, `captcha`) VALUES
(?s, ?s, 'nor.reply@gmail.com', 10, 1, 0, 1);", $_POST['sitename'], $_POST['siteurl']);

  $sqls[] = "
  CREATE TABLE IF NOT EXISTS `".$prefix."users` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `key` varchar(50) NOT NULL,
  `validated` varchar(100) NOT NULL,
  `groupid` int(11) NOT NULL DEFAULT '2',
  `lastactive` int(11) NOT NULL,
  `showavt` int(11) NOT NULL DEFAULT '1',
  `banned` int(11) NOT NULL,
  `regtime` int(11) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";

  $sqls[] = "
  INSERT INTO `".$prefix."users` (`userid`, `username`, `display_name`, `password`, `email`, `key`, `validated`, `groupid`, `lastactive`, `showavt`, `banned`, `regtime`) VALUES
(1, 'admin', 'Admin', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 'admin@gmail.com', '', '1', 4, ".time().", 1, 0, ".time().");";



  foreach($sqls as $sql)
    if(!isset($page->error) && (!$db->query("?p",$sql)))
      $page->error = "There was a problem while executing <code>$sql</code>";



  if(!isset($page->error)) {
    $page->success = "The installation was successful ! Thank you for using master loging system and we hope you enjo it ! Have fun ! <br/><br/>
    <a class='btn btn-success' href='./index.php'>Start exploring</a>
    <br/><br/>

    <h3>USER: admin <br/> PASSWORD: 1234</h3>";
  }

}



?><!DOCTYPE html>
<!--[if lt IE 7]>      <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]>         <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]>         <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]-->
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
        <title>Installer</title>
        <meta name="description" content="">
        <meta name="viewport" content="width=device-width">

        <link rel="stylesheet" href="./css/bootstrap.min.css">
        <!-- join the dark side :) -->
        <!-- <link rel="stylesheet" href="./css/darkstrap.min.css">-->
        <style>
            body {
                padding-top: 60px;
                padding-bottom: 40px;
            }
        </style>
        <link rel="stylesheet" href="./css/bootstrap-responsive.min.css">
        <link rel="stylesheet" href="./css/main.css">

        <script src="./js/vendor/modernizr-2.6.2-respond-1.1.0.min.js"></script>
        

    </head>
    <body>
        <!--[if lt IE 7]>
            <p class="chromeframe">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> or <a href="http://www.google.com/chromeframe/?redirect=true">activate Google Chrome Frame</a> to improve your experience.</p>
        <![endif]--> 

        <!-- This code is taken from http://twitter.github.com/bootstrap/examples/hero.html -->

        <div class="navbar navbar-inverse navbar-fixed-top">
            <div class="navbar-inner">
                <div class="container">
                    <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </a>
                    <a class="brand" href="?">MASTER LOGIN SYSTEM INSTALLER</a>
            </div><!--/.nav-collapse -->
        </div>
    </div>
</div>
<div class="container">
        

<?php

if(isset($page->error))
  $options->error($page->error);
else if(isset($page->success)) {
  $options->success($page->success);
  exit;
}

?>

    <div class='span3 hidden-phone'></div>



<form class="form-horizontal well span6" action="?" method="post">
<fieldset>

    <legend>Install form</legend>


    <div class="control-group">
      <label class="control-label" for="sitename">Site Name</label>
      <div class="controls">
        <input id="sitename" name="sitename" type="text" value="Demo Site" class="input-xlarge">
        <p class="help-block">The name of the site will be used in the top left corner.</p>
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="siteurl">Site Url</label>
      <div class="controls">
        <input id="siteurl" name="siteurl" type="text" value="http://<?php echo $_SERVER['SERVER_NAME'] . dirname($_SERVER['REQUEST_URI']);?>" class="input-xlarge">
        <p class="help-block">The url of your site(no end /).</p>
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="dbhost">Database Host</label>
      <div class="controls">
        <input id="dbhost" name="dbhost" type="text" value="localhost" class="input-xlarge">
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="dbuser">Database Username</label>
      <div class="controls">
        <input id="dbuser" name="dbuser" type="text" value="root" class="input-xlarge">
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="dbpass">Database Password</label>
      <div class="controls">
        <input id="dbpass" name="dbpass" type="password" value="" class="input-xlarge">
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="dbname">Database Name</label>
      <div class="controls">
        <input id="dbname" name="dbname" type="text" value="mls" class="input-xlarge">
      </div>
    </div>

    <div class="control-group">
      <label class="control-label" for="tbprefix">Tables Prefix</label>
      <div class="controls">
        <input id="tbprefix" name="tbprefix" type="text" value="mls_" class="input-xlarge">
      </div>
    </div>

    <div class="control-group">
      <div class="controls">
        <input type='submit' value='Install' class='btn btn-success'>
      </div>
    </div>

</fieldset>
</form>







</div> <!-- /container -->
   

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>window.jQuery || document.write('<script src="./js/vendor/jquery-1.9.1.min.js"><\/script>')</script>

<script src="./js/vendor/bootstrap.min.js"></script>

</body>
</html>