<?php

/*

 * Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between

 * Version 1.1.1

 * Copyright (C) 2006-2007 Dan Fuhry

 * Installation package

 * database_post.php - Database installation, stage 1

 *

 * This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.

 */

if ( !defined('IN_ENANO_INSTALL') )

  die();

// Start up the DBAL

require( ENANO_ROOT . '/includes/dbal.php' );

require( ENANO_ROOT . '/install/includes/sql_parse.php' );

$dbal = new $driver();

$db_host =& $_POST['db_host'];

$db_user =& $_POST['db_user'];

$db_pass =& $_POST['db_pass'];

$db_name =& $_POST['db_name'];

$db_prefix =& $_POST['table_prefix'];

$result = $dbal->connect(true, $db_host, $db_user, $db_pass, $db_name);

$ui->show_header();

if ( $result )

{

  // We're good, write out a config file

  $ch = @fopen( ENANO_ROOT . '/config.new.php', 'w' );

  if ( !$ch )

  {

    ?>

    <form action="install.php?stage=database" method="post" name="database_info">

      <h3>Configuration file generation failed.</h3>

      <p>Couldn't open the configuration file to write out database settings. Check your file permissions.</p>

      <p>

        <input type="submit" name="_cont" value="Go back" />

      </p>

    </form>

    <?php

    return true;

  }

  $db_host = str_replace("'", "\\'", $db_host);

  $db_user = str_replace("'", "\\'", $db_user);

  $db_pass = str_replace("'", "\\'", $db_pass);

  $db_name = str_replace("'", "\\'", $db_name);

  $db_prefix = str_replace("'", "\\'", $db_prefix);

  if ( !preg_match('/^[a-z0-9_]*$/', $db_prefix) )

  {

    echo '<p>That table prefix isn\'t going to work.</p>';

    return true;

  }

  fwrite($ch, "<?php

// Enano temporary configuration file, will be OVERWRITTEN after installation.

\$dbdriver = '$driver';

\$dbhost = '$db_host';

\$dbname = '$db_name';

\$dbuser = '$db_user';

\$dbpasswd = '$db_pass';

@define('table_prefix', '$db_prefix');

@define('ENANO_INSTALL_HAVE_CONFIG', 1);

");

  fclose($ch);

  // Create the config table

  try

  {

    $sql_parser = new SQL_Parser( ENANO_ROOT . "/install/schemas/{$driver}_stage1.sql" );

  }

  catch ( Exception $e )

  {

    ?>

    <h3>Can't load schema file</h3>

    <p>The SQL schema file couldn't be loaded.</p>

    <?php echo "<pre>$e</pre>"; ?>

    <?php

    return true;

  }

  // Check to see if the config table already exists

  $q = $dbal->sql_query('SELECT config_name, config_value FROM ' . $db_prefix . 'config LIMIT 1;');

  if ( !$q )

  {

    $sql_parser->assign_vars(array(

        'TABLE_PREFIX' => $db_prefix

      ));

    $sql = $sql_parser->parse();

    foreach ( $sql as $q )

    {

      if ( !$dbal->sql_query($q) )

      {

        ?>

        <form action="install.php?stage=database" method="post" name="database_info">

          <input type="hidden" name="language" value="<?php echo $lang_id; ?>" />

          <input type="hidden" name="driver" value="<?php echo $driver; ?>" />

          <h3>Database operation failed</h3>

          <p>The installer couldn't create one of the tables used for installation.</p>

          <p>Error description:

            <?php

            echo $dbal->sql_error();

            ?>

          </p>

          <p>

            <input type="submit" name="_cont" value="Go back" />

          </p>

        </form>

        <?php

        return true;

      }

    }

  }

  else

  {

    $dbal->free_result();

    if ( !$dbal->sql_query('DELETE FROM ' . $db_prefix . 'config WHERE config_name = \'install_aes_key\';') )

    {

      $dbal->_die('install database_post.php trying to remove old AES installer key');

    }

  }

  $dbal->close();

  ?>

  <form action="install.php?stage=website" method="post" name="install_db_post" onsubmit="return verify();">

  <input type="hidden" name="language" value="<?php echo $lang_id; ?>" />

  <?php

  // FIXME: l10n

  ?>

  <h3>Connection successful</h3>

  <p>The database has been contacted and initial tables created successfully. Redirecting...</p>

  <p><input type="submit" name="_cont" value="<?php echo $lang->get('meta_btn_continue'); ?>" />  Click if you're not redirected within 2 seconds</p>

  </form>

  <script type="text/javascript">

    setTimeout(function()

      {

        var frm = document.forms.install_db_post;

        frm.submit();

      }, 200);

  </script>

  <?php

}

else

{

  // FIXME: l10n

  ?>

  <form action="install.php?stage=database" method="post" name="database_info">

    <input type="hidden" name="language" value="<?php echo $lang_id; ?>" />

    <input type="hidden" name="driver" value="<?php echo $driver; ?>" />

    <h3>Database connection failed</h3>

    <p>The installer couldn't connect to the database because something went wrong while the connection attempt was being made. Please press your browser's back button and correct your database information.</p>

    <p>Error description:

      <?php

      echo $dbal->sql_error();

      ?>

    </p>

    <p>

      <input type="submit" name="_cont" value="Go back" />

    </p>

  </form>

  <?php

}