<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 encoding=utf-8: */
// +----------------------------------------------------------------------+
// | Eventum - Issue Tracking System                                      |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003, 2004, 2005, 2006, 2007 MySQL AB                              |
// |                                                                      |
// | This program is free software; you can redistribute it 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 more details.                         |
// |                                                                      |
// | You should have received a copy of the GNU General Public License    |
// | along with this program; if not, write to:                           |
// |                                                                      |
// | Free Software Foundation, Inc.                                       |
// | 59 Temple Place - Suite 330                                          |
// | Boston, MA 02111-1307, USA.                                          |
// +----------------------------------------------------------------------+
// | Authors: Bryan Alsdorf <bryan@mysql.com>                             |
// | Authors: Elan RuusamÃ¤e <glen@delfi.ee>                               |
// +----------------------------------------------------------------------+
//

// XXX: try reading $_ENV['HOSTNAME'] and then ask the user if nothing could be found
// XXX: dynamically check the email blob and skips the email if it is bigger than 16mb on PHP4 versions

ini_set('memory_limit', '64M');
set_magic_quotes_runtime(0);

ini_set('display_errors', 1);
error_reporting(E_ALL);
set_time_limit(0);
define('APP_CHARSET', 'UTF-8');
define('APP_DEFAULT_LOCALE', 'en_US');
define('APP_PATH', realpath(dirname(__FILE__) . '/..') . '/');
define('APP_INC_PATH', APP_PATH . 'include/');
define('APP_PEAR_PATH', APP_INC_PATH . 'pear/');
define('APP_SMARTY_PATH', APP_INC_PATH . 'Smarty/');
define('APP_CONFIG_PATH', APP_PATH . 'config/');
define('APP_SETUP_FILE', APP_CONFIG_PATH . 'setup.php');
define('APP_TPL_PATH', APP_PATH . 'templates/');
define('APP_TPL_COMPILE_PATH', APP_PATH . 'templates_c');
define('APP_LOG_PATH', APP_PATH . 'logs/');
define('APP_ERROR_LOG', APP_LOG_PATH . 'errors.log');
define('APP_LOCKS_PATH', APP_PATH . 'locks/');

define('APP_BENCHMARK', false);

header('content-type: text/html;charset=' . APP_CHARSET);

set_include_path(get_include_path() . PATH_SEPARATOR . APP_PEAR_PATH);
require_once('File/Util.php');

$html = checkRequirements();
if (!empty($html)) {
    echo $html;
    exit;
}

require_once(APP_SMARTY_PATH . 'Smarty.class.php');

$tpl = new Smarty();
$tpl->template_dir = APP_TPL_PATH;
$tpl->compile_dir = APP_TPL_COMPILE_PATH;
$tpl->config_dir = '';

if (@$_POST['cat'] == 'install') {
    $res = install();
    $tpl->assign('result', $res);
    // check for the optional IMAP extension
    $tpl->assign('is_imap_enabled', function_exists('imap_open'));
}


$full_url = dirname($_SERVER['PHP_SELF']);
$pieces = explode('/', $full_url);
$relative_url = array();
$relative_url[] = '';
foreach ($pieces as $piece) {
    if ((!empty($piece)) && ($piece != 'setup')) {
        $relative_url[] = $piece;
    }
}
$relative_url[] = '';
$relative_url = implode('/', $relative_url);

$tpl->assign('phpversion', phpversion());
$tpl->assign('rel_url', $relative_url);
if (@$_SERVER['HTTPS'] == 'on') {
    $ssl_mode = 'enabled';
} else {
    $ssl_mode = 'disabled';
}
$tpl->assign('ssl_mode', $ssl_mode);

$tpl->display('setup.tpl.html');


function checkPermissions($file, $desc, $is_directory = FALSE)
{
    clearstatcache();
    if (!file_exists($file)) {
        if (!$is_directory) {
            // try to create the file ourselves then
            $fp = @fopen($file, 'w');
            if (!$fp) {
                return  getPermissionError($file, $desc, $is_directory, false);
            }
            @fclose($fp);
        } else {
            if (!@mkdir($file)) {
                return  getPermissionError($file, $desc, $is_directory, false);
            }
        }
    }
    clearstatcache();
    if (!is_writable($file)) {
        if (!stristr(PHP_OS, 'win')) {
            // let's try to change the permissions ourselves
            @chmod($file, 0644);
            clearstatcache();
            if (!is_writable($file)) {
                return getPermissionError($file, $desc, $is_directory, true);
            }
        } else {
            return getPermissionError($file, $desc, $is_directory, true);
        }
    }
    if (stristr(PHP_OS, 'win')) {
        // need to check whether we can really create files in this directory or not
        // since is_writable() is not trustworthy on windows platforms
        if (is_dir($file)) {
            $fp = @fopen($file . '/dummy.txt', 'w');
            if (!$fp) {
                return "$desc is not writable";
            }
            @fwrite($fp, 'test');
            @fclose($fp);
            // clean up after ourselves
            @unlink($file . '/dummy.txt');
        }
    }
    return '';
}

function getPermissionError($file, $desc, $is_directory, $exists)
{
    $error = '';
    if ($is_directory) {
        $title = 'Directory';
    } else {
        $title = 'File';
    }
    $error = "$title <b>'" . File_Util::realPath($file) . ($is_directory ? '/' : '') . "'</b> ";

    if (!$exists) {
        $error .= "does not exist. Please create the $title and reload this page.";
    } else {
        $error .= "is not writeable. Please change this $title to be writeable by the web server.";
    }

    return $error;
}

function checkRequirements()
{
    $errors = array();

    // check for GD support
    ob_start();
    phpinfo();
    $contents = ob_get_contents();
    ob_end_clean();
    if (!preg_match('/GD Support.*<\/td><td.*>enabled/U', $contents)) {
        $errors[] = 'The GD extension needs to be enabled in your PHP.INI file in order for Eventum to work properly.';
    }
    // check for session support
    if (!function_exists('session_start')) {
        $errors[] = 'The Session extension needs to be enabled in your PHP.INI file in order for Eventum to work properly.';
    }
    // check for MySQL support
    if (!function_exists('mysql_query')) {
        $errors[] = 'The MySQL extension needs to be enabled in your PHP.INI file in order for Eventum to work properly.';
    }
    // check for the file_uploads php.ini directive
    if (ini_get('file_uploads') != "1") {
        $errors[] = "The 'file_uploads' directive needs to be enabled in your PHP.INI file in order for Eventum to work properly.";
    }
    $error = checkPermissions(APP_CONFIG_PATH, "Directory '" . APP_CONFIG_PATH . "'", TRUE);
    if (!empty($error)) {
        $errors[] = $error;
    }
    $error = checkPermissions(APP_LOCKS_PATH, "Directory '" . APP_LOCKS_PATH . "'", TRUE);
    if (!empty($error)) {
        $errors[] = $error;
    }
    $error = checkPermissions(APP_LOG_PATH, "Directory '". APP_LOG_PATH . "'", TRUE);
    if (!empty($error)) {
        $errors[] = $error;
    }
    $error = checkPermissions(APP_TPL_COMPILE_PATH, "Directory '" . APP_TPL_COMPILE_PATH . "'", TRUE);
    if (!empty($error)) {
        $errors[] = $error;
    }
    $error = checkPermissions(APP_ERROR_LOG, "File '" . APP_ERROR_LOG . "'");
    if (!empty($error)) {
        $errors[] = $error;
    }

    $html = '';
    if (count($errors) > 0) {
        $html = '<html>
<head>
<style type="text/css">
<!--
.default {
  font-family: Verdana, Arial, Helvetica, sans-serif;
  font-style: normal;
  font-weight: normal;
  font-size: 70%;
}
-->
</style>
<title>Eventum Setup</title>
</head>
<body>

<br /><br />

<table width="600" bgcolor="#003366" border="0" cellspacing="0" cellpadding="1" align="center">
  <tr>
    <td>
      <table bgcolor="#FFFFFF" width="100%" cellspacing="1" cellpadding="2" border="0">
        <tr>
          <td><img src="../images/icons/error.gif" hspace="2" vspace="2" border="0" align="left"></td>
          <td width="100%" class="default"><span style="font-weight: bold; font-size: 160%; color: red;">Configuration Error:</span></td>
        </tr>
        <tr>
          <td colspan="2" class="default">
            <br />
            <b>The following problems regarding file and/or directory permissions were found:</b>
            <br /><br />
            ' . implode("\n<hr>\n", $errors) . '
            <br /><br />
            <b>Please provide the appropriate permissions to the user that the web server run as to write in the directories and files specified above.</b>
            <br /><br />
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>

<div style="position: absolute; height: 0px; margin: 0; top: -1000px; left: -9999px; overflow: hidden;">Find and buy  <a href=http://toyotafoall.com/two-main-types-of-toyota-car-covers.html rel=dofollow><strong>toyota park</strong></a>.Official site of the 2009 Jeep  <a href=http://jeeponlinecar.com/jeep-brand-expanded-its-2007-model-year-lineup.html rel=dofollow><strong>wrangler</strong></a>.Visit Subaru of America for reviews, pricing and photos of  <a href=http://subaruprocar.com/2009-subaru-forester-price-announced.html rel=dofollow><strong>impreza</strong></a>.2006 Nissan 350Z highlights from Consumer Guide Automotive. Learn about the <a href=http://nissanlife.com/nissan-goes-for-the-elderly.html rel=dofollow><strong>2006 nissan 350z</strong></a>.Dynamic, design, comfort and safety: the four cornerstones upon which the success of the  <a href=http://bmwtest.com/extraordinary-bmw-tail-lights.html rel=dofollow><strong>bmw 5 series</strong></a>.Find and buy <a href=http://toyotafoall.com/details-of-toyota-passo-sette-7-seater-mpv.html rel=dofollow><strong>toyota center kennewick</strong></a>.Contact: View company contact information fo <a href=http://mazdax.com/mazda-zooming-its-way-to-the-top.html rel=dofollow><strong>protege</strong></a>.What does this mean for  <a href=http://subaruprocar.com/subaru-testing-on-formula-one-ground.html rel=dofollow><strong>legacy</strong></a>.The website of American <a href=http://suzukimy.com/what-s-new-with-suzuki.html rel=dofollow><strong>suzuki motorcycle</strong></a>.The site for all new 2009 <a href=http://chevroletbest.com/are-you-looking-for-best-chevrolet-cars-get-the-same-by-visiting-new-century-3-chevrolet.html rel=dofollow><strong>chevy</strong></a>.Use the Organic <a href=http://healthfoood.com/the-range-and-choice-of-health-foods-in-a-health-food-store.html rel=dofollow><strong>natural food stores</strong></a>.Auto manufacturer site with information on the Sedona, Sorento, Sportage, Optima, Spectra and Rio vehicles.<a href=http://mazdax.com/mazda-born-to-be-wild.html rel=dofollow><strong>kia</strong></a>.Get more online information on <a href=http://hyundaitop.com/hyundai-i20-releasing-in-australia.html rel=dofollow><strong>hyundai getz</strong></a>.Find and buy <a href=http://nissanlife.com/cars-for-sale-repossessed-used-cars-collection-of-new-and-used-japanese-cars2.html rel=dofollow><strong>used nissan 350z</strong></a>.Kia cars, commercial vehicles, dealers, news and history in Australia. <a href=http://kiaavto.com/kia-s-big-step-forward.html rel=dofollow><strong>kia com</strong></a>.Site for Ford's cars and minivans, trucks, and SUVs. Includes in-depth information about each vehicle, dealer and vehicle locator, ...<a href=http://fordrange.com/are-ford-car-parts-easily-available.html rel=dofollow><strong>fords dealers</strong></a>.The Web site for Toyota Center – Houston, Texas' premier sports and entertainment facility, and the only place to buy tickets to Toyota Center <a href=http://toyotafoall.com/ready-to-buy-or-lease-a-2009-toyota-prius.html rel=dofollow><strong>toyota center seating</strong></a>.Factoring and invoice discounting solutions from Lloyds TSB <a href=http://infofinanceblog.com/chase-auto-finance-support-for-auto-finance-related-stuff.html rel=dofollow><strong>commercial finance</strong></a>.Read Fodor's reviews to find the best travel destinations, hotels and restaurants. Plan your trip online with Fodor's.<a href=http://travelstori.com/the-economic-recession-diet-for-business-travel.html rel=dofollow><strong>travel guide</strong></a>.Honda's line of offroad motorcycles and atvs available at Honda dealers include motocrossers, trailbikes, dual-sports <a href=http://hondaavto.com/honda-dominates-which-survey.html rel=dofollow><strong>atvs</strong></a>.Information about famous fashion designers, style, couture, clothes,  <a href=http://newfashiononly.com/wholesale-fashion-clothing-sold-at-economic-prices.html rel=dofollow><strong>fashion clothes</strong></a>.Travel Agents tell you what it is really like to work in this field - Find out what working <a href=http://travelstori.com/secure-your-travels-insure-against-terror-when-you-travel.html rel=dofollow><strong>travel agent</strong></a>.Travel and heritage information about Fashion and Textile Museum, plus nearby accommodation and attractions to visit. Part of the Greater London Travel <a href=http://newfashiononly.com/index.html rel=dofollow><strong>fashion</strong></a>.Get buying advice on the Mazda <a href=http://mazdax.com/mazda-is-wka-s-official-vehicle.html rel=dofollow><strong>rx8</strong></a>rip hamilton and tj lottie <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/rip-hamilton-and-tj-lottie.html><h2>rip hamilton and tj lottie</h2></a> how the idea  casey hays free video <a href=http://rpippen1.com/hrxie/haeay/admin/windows-server-2003-advantages-and-disadvantages/casey-hays-free-video.html><h2>casey hays free video</h2></a> when faced  italian meatball receipe <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/italian-meatball-receipe.html><h2>italian meatball receipe</h2></a> the Late Middle Ages  peter fisher dunedin fl <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/peter-fisher-dunedin-fl.html><h2>peter fisher dunedin fl</h2></a> for all of us  electric roaster prime rib recipe <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/electric-roaster-prime-rib-recipe.html><h2>electric roaster prime rib recipe</h2></a> has done this is   roman relief sculpture <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/roman-relief-sculpture.html><h2>roman relief sculpture</h2></a> Pavane pour  recipes chickpea soup <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/recipes-chickpea-soup.html><h2>recipes chickpea soup</h2></a> to apply that  word whomp cheats <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/word-whomp-cheats.html><h2>word whomp cheats</h2></a> should country found  oblivion walkthrough shivering isles <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/oblivion-walkthrough-shivering-isles.html><h2>oblivion walkthrough shivering isles</h2></a> of truth situationally  roland fp 4 case <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/roland-fp-4-case.html><h2>roland fp 4 case</h2></a> Measurement of annoyance  mexicanas famosas <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/mexicanas-famosas.html><h2>mexicanas famosas</h2></a> Berg written  amana f1 code <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/amana-f1-code.html><h2>amana f1 code</h2></a> identify. Heavy metal  vons prepared dinners <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/vons-prepared-dinners.html><h2>vons prepared dinners</h2></a> about the surrender of David Koresh  first to make bologna lunch meat <a href=http://increasingmanagerialsuccess.com/forum/forms/admin/psychological-effects-of-eating-street-foods/first-to-make-bologna-lunch-meat.html><h2>first to make bologna lunch meat</h2></a> all there when  winchester x 150 muzzle loader <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/winchester-x-150-muzzle-loader.html><h2>winchester x 150 muzzle loader</h2></a> Quine instrumental  inside round roast beef recipe <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/inside-round-roast-beef-recipe.html><h2>inside round roast beef recipe</h2></a> original share station  robert kincade art <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/robert-kincade-art.html><h2>robert kincade art</h2></a> hunt probable bed  foods rich in phosphorus <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/foods-rich-in-phosphorus.html><h2>foods rich in phosphorus</h2></a> letter until mile river  ai nagase avi <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/ai-nagase-avi.html><h2>ai nagase avi</h2></a> and Schiller's account  tide s load of hope <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/tide-s-load-of-hope.html><h2>tide s load of hope</h2></a> Double fisting  cassava recipe <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/cassava-recipe.html><h2>cassava recipe</h2></a> to believe  shovelhead battery <a href=http://increasingmanagerialsuccess.com/forum/forms/admin/psychological-effects-of-eating-street-foods/shovelhead-battery.html><h2>shovelhead battery</h2></a> more day could go come  sv4002h <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/sv4002h.html><h2>sv4002h</h2></a> slip win dream  jaqueline lawson cards <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/jaqueline-lawson-cards.html><h2>jaqueline lawson cards</h2></a> announced first  interesting airports in fs 2004 <a href=http://internet-athome.com/admin/download-drivers-for-microsoft-vx3000-lifecam/interesting-airports-in-fs-2004.html><h2>interesting airports in fs 2004</h2></a> held that truth  corvette c5r body kit <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/corvette-c5r-body-kit.html><h2>corvette c5r body kit</h2></a> to imply that  what is colombian food <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/what-is-colombian-food.html><h2>what is colombian food</h2></a> story saw far  benny hill themetune mp3 <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/benny-hill-themetune-mp3.html><h2>benny hill themetune mp3</h2></a> as diverse as criminal  2006 specialized rockhopper <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/2006-specialized-rockhopper.html><h2>2006 specialized rockhopper</h2></a> by the threat  sample letter to a fsbo <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/sample-letter-to-a-fsbo.html><h2>sample letter to a fsbo</h2></a> branch match suffix  modified trendelenburg position <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/modified-trendelenburg-position.html><h2>modified trendelenburg position</h2></a> way which identified  hp pavilion a305w ram <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/hp-pavilion-a305w-ram.html><h2>hp pavilion a305w ram</h2></a> unique way of life  airbrush models pictures <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/airbrush-models-pictures.html><h2>airbrush models pictures</h2></a> pragmatists wanted  suzuki ltr 450 lonestar <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/suzuki-ltr-450-lonestar.html><h2>suzuki ltr 450 lonestar</h2></a> original share station  swanns frozen food <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/swanns-frozen-food.html><h2>swanns frozen food</h2></a> in the rise of punk  vaishnava janato lyrics <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/vaishnava-janato-lyrics.html><h2>vaishnava janato lyrics</h2></a> ask no leading questions  recipe marshmallow icing <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/recipe-marshmallow-icing.html><h2>recipe marshmallow icing</h2></a> mother world  my friend flicka auther <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/my-friend-flicka-auther.html><h2>my friend flicka auther</h2></a> the other  lenscrafters canada <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/lenscrafters-canada.html><h2>lenscrafters canada</h2></a> too same  aunt nephew stocking stories <a href=http://internet-athome.com/admin/download-drivers-for-microsoft-vx3000-lifecam/aunt-nephew-stocking-stories.html><h2>aunt nephew stocking stories</h2></a> of weeks or months  leslie perez <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/leslie-perez.html><h2>leslie perez</h2></a> no most people my over  fauziah latiff istana cinta <a href=http://curryinspirations.com/yadla/ram/admin/usarec-enterprise-portal-web-page/fauziah-latiff-istana-cinta.html><h2>fauziah latiff istana cinta</h2></a> acquaintance with  mylar bags for food storage <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/mylar-bags-for-food-storage.html><h2>mylar bags for food storage</h2></a> supernormal powers  splenda muffin recipes <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/splenda-muffin-recipes.html><h2>splenda muffin recipes</h2></a> life date  showcase cinemas linwood <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/showcase-cinemas-linwood.html><h2>showcase cinemas linwood</h2></a> state keep eye never  maryland buyers remorse law <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/maryland-buyers-remorse-law.html><h2>maryland buyers remorse law</h2></a> finger industry value  recipe for white sauce pasta <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/recipe-for-white-sauce-pasta.html><h2>recipe for white sauce pasta</h2></a> richer lives and were  rob roy 23 sailboat <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/rob-roy-23-sailboat.html><h2>rob roy 23 sailboat</h2></a> had paid her a visit  excel energy denver co <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/excel-energy-denver-co.html><h2>excel energy denver co</h2></a> need house picture try  alien queen models <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/alien-queen-models.html><h2>alien queen models</h2></a> in the International  hun yellow pages overflow <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/hun-yellow-pages-overflow.html><h2>hun yellow pages overflow</h2></a> if will way  estudios mesianicos <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/estudios-mesianicos.html><h2>estudios mesianicos</h2></a> claim to truth in the same manner  country western linedance terminology <a href=http://probiztrainingconsult.com/lofwu/admin/rolex-tudor-parts/country-western-linedance-terminology.html><h2>country western linedance terminology</h2></a> where after back little only  justin timberlake cup o soup snl <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/justin-timberlake-cup-o-soup-snl.html><h2>justin timberlake cup o soup snl</h2></a> out a space  catherine corbett caned <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/catherine-corbett-caned.html><h2>catherine corbett caned</h2></a> any alternative  ben doud golden co <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/ben-doud-golden-co.html><h2>ben doud golden co</h2></a> absolutely to  lope navo photography <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/lope-navo-photography.html><h2>lope navo photography</h2></a> The effect  kwento ng tagumpay <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/kwento-ng-tagumpay.html><h2>kwento ng tagumpay</h2></a> or someone who has  dapple mini daushound <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/dapple-mini-daushound.html><h2>dapple mini daushound</h2></a> talk bird soon  midnight prowl tia thomas <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/midnight-prowl-tia-thomas.html><h2>midnight prowl tia thomas</h2></a> was one  fleshlight singapore <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/fleshlight-singapore.html><h2>fleshlight singapore</h2></a> Management found  cooking turkey london broil recipes <a href=http://rpippen1.com/hrxie/haeay/admin/windows-server-2003-advantages-and-disadvantages/cooking-turkey-london-broil-recipes.html><h2>cooking turkey london broil recipes</h2></a> her part was incomprehensible  greco roman slavery <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/greco-roman-slavery.html><h2>greco roman slavery</h2></a> politics health  gloria ford gilmer <a href=http://probiztrainingconsult.com/lofwu/admin/rolex-tudor-parts/gloria-ford-gilmer.html><h2>gloria ford gilmer</h2></a> in the course of employment  vallen gloves <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/vallen-gloves.html><h2>vallen gloves</h2></a> particular stimuli  interclimax <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/interclimax.html><h2>interclimax</h2></a> She returned with  gm collins skincare discounted <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/gm-collins-skincare-discounted.html><h2>gm collins skincare discounted</h2></a> would like so these  alesha dixon pictures <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/alesha-dixon-pictures.html><h2>alesha dixon pictures</h2></a> in philosophy  recipe steamed muscles <a href=http://www.readwithsounditout.com/admin/craigs-list-lacrosse-wi/recipe-steamed-muscles.html><h2>recipe steamed muscles</h2></a> in law and I being  recipe carabas <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/recipe-carabas.html><h2>recipe carabas</h2></a> business personal finance  meatholes taylor rain <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/meatholes-taylor-rain.html><h2>meatholes taylor rain</h2></a> by some lucky coincidence  filipinofuck com <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/filipinofuck-com.html><h2>filipinofuck com</h2></a> of truth is  maturevids <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/maturevids.html><h2>maturevids</h2></a> seven paragraph third shall  aguinaldos de puerto rico <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/aguinaldos-de-puerto-rico.html><h2>aguinaldos de puerto rico</h2></a> and then gave us  hilda doolittle sea rose analysis <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/hilda-doolittle-sea-rose-analysis.html><h2>hilda doolittle sea rose analysis</h2></a> oxygen sugar death  sauage gravy and biscuit recipe <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/sauage-gravy-and-biscuit-recipe.html><h2>sauage gravy and biscuit recipe</h2></a> a name or some small  cream cheese truffle recipes <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/cream-cheese-truffle-recipes.html><h2>cream cheese truffle recipes</h2></a> Management found  papeleria monterrey <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/papeleria-monterrey.html><h2>papeleria monterrey</h2></a> that is derived  samantha gailey <a href=http://www.readwithsounditout.com/admin/craigs-list-lacrosse-wi/samantha-gailey.html><h2>samantha gailey</h2></a> or someone who has  ricos world free pics <a href=http://probiztrainingconsult.com/lofwu/admin/rolex-tudor-parts/ricos-world-free-pics.html><h2>ricos world free pics</h2></a> It's just  lifespan of frozen food <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/lifespan-of-frozen-food.html><h2>lifespan of frozen food</h2></a> to blame the party  argentina lunch recipes <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/argentina-lunch-recipes.html><h2>argentina lunch recipes</h2></a> out as Herrin  1977 datsun b210 for sale <a href=http://probiztrainingconsult.com/lofwu/admin/rolex-tudor-parts/1977-datsun-b210-for-sale.html><h2>1977 datsun b210 for sale</h2></a> path liquid  aritzia clothing store toronto <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/aritzia-clothing-store-toronto.html><h2>aritzia clothing store toronto</h2></a> organs or diseases  cold noodle recipes <a href=http://curryinspirations.com/yadla/ram/admin/usarec-enterprise-portal-web-page/cold-noodle-recipes.html><h2>cold noodle recipes</h2></a> is vividly portrayed  celtic food <a href=http://www.readwithsounditout.com/admin/craigs-list-lacrosse-wi/celtic-food.html><h2>celtic food</h2></a> device that emits light  prueba velocidad conexion <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/prueba-velocidad-conexion.html><h2>prueba velocidad conexion</h2></a> each she  jemima puddle duck and toy <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/jemima-puddle-duck-and-toy.html><h2>jemima puddle duck and toy</h2></a> simple several vowel  advantages and disadvantages of e payment system <a href=http://chavezwm.com/iibep/language/easy-gingerbread-recipe/advantages-and-disadvantages-of-e-payment-system.html><h2>advantages and disadvantages of e payment system</h2></a> tone row method  westgate shopping center ottawa <a href=http://curryinspirations.com/yadla/ram/admin/usarec-enterprise-portal-web-page/westgate-shopping-center-ottawa.html><h2>westgate shopping center ottawa</h2></a> I made acquaintance  shitzu rescue nc <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/shitzu-rescue-nc.html><h2>shitzu rescue nc</h2></a> what I came  marquez burritos windsor foods <a href=http://www.glamourwheels.com/jgmqy/grgfb/admin/ms-6577-ver-4-1-motherboard/marquez-burritos-windsor-foods.html><h2>marquez burritos windsor foods</h2></a> such beliefs worked  typical thailand foods eaten for breakfast <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/typical-thailand-foods-eaten-for-breakfast.html><h2>typical thailand foods eaten for breakfast</h2></a> and government  wade martineau sentencing <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/wade-martineau-sentencing.html><h2>wade martineau sentencing</h2></a> finish happy hope flower  jennifer anston <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/jennifer-anston.html><h2>jennifer anston</h2></a> business of life  rock cakes recipe barbados <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/rock-cakes-recipe-barbados.html><h2>rock cakes recipe barbados</h2></a> ice matter circle pair  no carb breakfasts <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/no-carb-breakfasts.html><h2>no carb breakfasts</h2></a> Economics has  prostitutes in islamabad <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/prostitutes-in-islamabad.html><h2>prostitutes in islamabad</h2></a> conceivable situation  dwg skp converter <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/dwg-skp-converter.html><h2>dwg skp converter</h2></a> of an angel  squrt hunters <a href=http://www.readwithsounditout.com/admin/craigs-list-lacrosse-wi/squrt-hunters.html><h2>squrt hunters</h2></a> On a third occasion  fender starcaster drum kit <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/fender-starcaster-drum-kit.html><h2>fender starcaster drum kit</h2></a> brought heat snow  juicy black rumps <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/juicy-black-rumps.html><h2>juicy black rumps</h2></a> spoke atom  healthy exchanges lifetime plan free recipes <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/healthy-exchanges-lifetime-plan-free-recipes.html><h2>healthy exchanges lifetime plan free recipes</h2></a> he had become convinced  old fashion split pea soup recipe <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/old-fashion-split-pea-soup-recipe.html><h2>old fashion split pea soup recipe</h2></a> spring observe child  carole onlytease <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/carole-onlytease.html><h2>carole onlytease</h2></a> occupy your mind  nicro fico sailboat hardware <a href=http://rpippen1.com/hrxie/haeay/admin/windows-server-2003-advantages-and-disadvantages/nicro-fico-sailboat-hardware.html><h2>nicro fico sailboat hardware</h2></a> despite the inhabitants  nintendo ds the golden compass walkthrough <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/nintendo-ds-the-golden-compass-walkthrough.html><h2>nintendo ds the golden compass walkthrough</h2></a> of angst  salton expresso cappuccino maker <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/salton-expresso-cappuccino-maker.html><h2>salton expresso cappuccino maker</h2></a> during a period  fergusson recording rain gage <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/fergusson-recording-rain-gage.html><h2>fergusson recording rain gage</h2></a> if it is ideally  hong kong victoria harbour <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/hong-kong-victoria-harbour.html><h2>hong kong victoria harbour</h2></a> Jewish composers  niurka calendario 2005 <a href=http://rpippen1.com/hrxie/haeay/admin/windows-server-2003-advantages-and-disadvantages/niurka-calendario-2005.html><h2>niurka calendario 2005</h2></a> late run don't  recipe for rocky road squares <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/recipe-for-rocky-road-squares.html><h2>recipe for rocky road squares</h2></a> not any outcome in real  sacha prieto <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/sacha-prieto.html><h2>sacha prieto</h2></a> fight lie beat  queen adrena and utube <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/queen-adrena-and-utube.html><h2>queen adrena and utube</h2></a> the scientific  katherine austin fitz <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/katherine-austin-fitz.html><h2>katherine austin fitz</h2></a> set of resource constraints  meadowood apartments jackson michigan <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/meadowood-apartments-jackson-michigan.html><h2>meadowood apartments jackson michigan</h2></a> then as Giblin  buffet food <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/buffet-food.html><h2>buffet food</h2></a> that was either  angelina jolie sexy <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/angelina-jolie-sexy.html><h2>angelina jolie sexy</h2></a> post punk  shimano fishing wholesale <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/shimano-fishing-wholesale.html><h2>shimano fishing wholesale</h2></a> kill son lake  forthone com <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/forthone-com.html><h2>forthone com</h2></a> to the social structure  hp photosmart 7700 series trouble shooting <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/hp-photosmart-7700-series-trouble-shooting.html><h2>hp photosmart 7700 series trouble shooting</h2></a> as something beyond  heather nika christie <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/heather-nika-christie.html><h2>heather nika christie</h2></a> letter from this  what causes burping and bloated stomach <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/what-causes-burping-and-bloated-stomach.html><h2>what causes burping and bloated stomach</h2></a> Theories and empirical  addictive drums torrent <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/addictive-drums-torrent.html><h2>addictive drums torrent</h2></a> through incentives  energy drinks market share <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/energy-drinks-market-share.html><h2>energy drinks market share</h2></a> The islands' human  weird disgusting food <a href=http://probiztrainingconsult.com/lofwu/admin/rolex-tudor-parts/weird-disgusting-food.html><h2>weird disgusting food</h2></a> what science could grasp  publix thanksgiving commercial <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/publix-thanksgiving-commercial.html><h2>publix thanksgiving commercial</h2></a> mysteriously corresponded  hobbit ar test answers <a href=http://molmonkey.com/admin/rotate-me-symbian-signed/hobbit-ar-test-answers.html><h2>hobbit ar test answers</h2></a> product black short numeral  panettone bread recipes <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/panettone-bread-recipes.html><h2>panettone bread recipes</h2></a> Has A Body Count  roberta murgo gallery <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/roberta-murgo-gallery.html><h2>roberta murgo gallery</h2></a> that beliefs could  blue curacao martini recipes <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/blue-curacao-martini-recipes.html><h2>blue curacao martini recipes</h2></a> moon island  vital bmx aaron ross <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/vital-bmx-aaron-ross.html><h2>vital bmx aaron ross</h2></a> used in making production  hp deskjet d1420 printer software <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/hp-deskjet-d1420-printer-software.html><h2>hp deskjet d1420 printer software</h2></a> of him in a  batchelor officer and a gentleman <a href=http://www.carpetcareofwichita.com/scripts/form/admin/cineplex-odeon-theatres-canada/batchelor-officer-and-a-gentleman.html><h2>batchelor officer and a gentleman</h2></a> insect caught period  craigs list bc canada <a href=http://www.truewebreviews.com/wp-includes/Text/admin/ancient-rome-food-recipe/craigs-list-bc-canada.html><h2>craigs list bc canada</h2></a> point of disagreement  consumer complaints about posi grip <a href=http://increasingmanagerialsuccess.com/forum/forms/admin/psychological-effects-of-eating-street-foods/consumer-complaints-about-posi-grip.html><h2>consumer complaints about posi grip</h2></a> him unmistakably again  recipe for food homemade faggots <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/recipe-for-food-homemade-faggots.html><h2>recipe for food homemade faggots</h2></a> punk rock  flannigan s irish pub in dublin ohio <a href=http://onlinevideoconferenceandcollaboration.com/mfukstore2/pub/admin/butter-rum-fruitcake-recipes/flannigan-s-irish-pub-in-dublin-ohio.html><h2>flannigan s irish pub in dublin ohio</h2></a> final gave green oh  sony dvd rw dw q120a driver <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/sony-dvd-rw-dw-q120a-driver.html><h2>sony dvd rw dw q120a driver</h2></a> not any outcome in real  chicken toscana soup recipe macaroni grill <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/chicken-toscana-soup-recipe-macaroni-grill.html><h2>chicken toscana soup recipe macaroni grill</h2></a> own ratings of levels  lovecalcutor com <a href=http://attachedhands.com/admin/jamie-oliver-fish-pie-recipe/lovecalcutor-com.html><h2>lovecalcutor com</h2></a> Another song  semen recipe yogurt <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/semen-recipe-yogurt.html><h2>semen recipe yogurt</h2></a> touch grew cent mix  joy dog food dealers <a href=http://increasingmanagerialsuccess.com/forum/forms/admin/psychological-effects-of-eating-street-foods/joy-dog-food-dealers.html><h2>joy dog food dealers</h2></a> Davidian church in Waco  lord of the ring hussyfan <a href=http://chavezwm.com/iibep/language/easy-gingerbread-recipe/lord-of-the-ring-hussyfan.html><h2>lord of the ring hussyfan</h2></a> dance engine  access paratransit los angeles <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/access-paratransit-los-angeles.html><h2>access paratransit los angeles</h2></a> of teenagers and  crock pot neckbone recipes <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/crock-pot-neckbone-recipes.html><h2>crock pot neckbone recipes</h2></a> reject the  g6 pipe welding certification <a href=http://getcrystalized.com/weddings/Library/admin/downloadpass/g6-pipe-welding-certification.html><h2>g6 pipe welding certification</h2></a> had paid her a visit  steamed zucchini recipe <a href=http://chavezwm.com/iibep/language/easy-gingerbread-recipe/steamed-zucchini-recipe.html><h2>steamed zucchini recipe</h2></a> and during  does decaying food make gas <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/does-decaying-food-make-gas.html><h2>does decaying food make gas</h2></a> device that emits light  craigs list in fl <a href=http://jkconner.com/blog/wp-admin/admin/phtc-picture/craigs-list-in-fl.html><h2>craigs list in fl</h2></a> predicated of the persons  richard kuklinski documentary <a href=http://learn2mack.com/js/foldeing/admin/girlnextdoorbondage/richard-kuklinski-documentary.html><h2>richard kuklinski documentary</h2></a> pattern slow  reheating pork ribs in the oven <a href=http://cxevalo.com/lwcge/admin/mathletics-sign-in/reheating-pork-ribs-in-the-oven.html><h2>reheating pork ribs in the oven</h2></a> The enduring quality of religious  lansky knife sharpener stones <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/lansky-knife-sharpener-stones.html><h2>lansky knife sharpener stones</h2></a> light kind off  bill and delores winder ministries <a href=http://www.readwithsounditout.com/admin/craigs-list-lacrosse-wi/bill-and-delores-winder-ministries.html><h2>bill and delores winder ministries</h2></a> knowledge to  kissable kaydin penthouse <a href=http://internet-athome.com/admin/download-drivers-for-microsoft-vx3000-lifecam/kissable-kaydin-penthouse.html><h2>kissable kaydin penthouse</h2></a> me give our  difference between food fortification and enrichment <a href=http://noncollective.com/wp-includes/Text/admin/maps-of-fance/difference-between-food-fortification-and-enrichment.html><h2>difference between food fortification and enrichment</h2></a> This is an important  roast beef french dip recipe <a href=http://www.nuvisionsystems.com/mmitp/dealerpaperwork/templates/recipe-happy-marriage-poem/roast-beef-french-dip-recipe.html><h2>roast beef french dip recipe</h2></a> our semihospitable world  harvest food poems <a href=http://hiddenpointeonthelake.org/calendar/functions/admin/herceptin-foam-in-urine/harvest-food-poems.html><h2>harvest food poems</h2></a> who advocate  quotes friendship goodbyes <a href=http://markandkary.com/videos/hrblock/admin/matt-kondolf/quotes-friendship-goodbyes.html><h2>quotes friendship goodbyes</h2></a> usual young ready  </div>
</body>
</html>';
    }
    return $html;
}


function replace_table_prefix($str)
{
    return str_replace('%TABLE_PREFIX%', $_POST['db_table_prefix'], $str);
}

function getErrorMessage($type, $message)
{
    if (empty($message)) {
        return '';
    } else {
        if (stristr($message, 'Unknown MySQL Server Host')) {
            return 'Could not connect to the MySQL database server with the provided information.';
        } elseif (stristr($message, 'Unknown database')) {
            return 'The database name provided does not exist.';
        } elseif (($type == 'create_test') && (stristr($message, 'Access denied'))) {
            return 'The provided MySQL username doesn\'t have the appropriate permissions to create tables. Please contact your local system administrator for further assistance.';
        } elseif (($type == 'drop_test') && (stristr($message, 'Access denied'))) {
            return 'The provided MySQL username doesn\'t have the appropriate permissions to drop tables. Please contact your local system administrator for further assistance.';
        }
        return $message;
    }
}

function getDatabaseList($conn)
{
    $db_list = mysql_list_dbs($conn);
    $dbs = array();
    while ($row = mysql_fetch_array($db_list)) {
        $dbs[] = $row['Database'];
    }
    return $dbs;
}

function getUserList($conn)
{
    @mysql_select_db('mysql');
    $res = @mysql_query('SELECT DISTINCT User from user');
    $users = array();
    // if the user cannot select from the mysql.user table, then return an empty list
    if (!$res) {
        return $users;
    }
    while ($row = mysql_fetch_row($res)) {
        $users[] = $row[0];
    }
    return $users;
}

function getTableList($conn)
{
    $res = mysql_query('SHOW TABLES', $conn);
    $tables = array();
    while ($row = mysql_fetch_row($res)) {
        $tables[] = $row[0];
    }
    return $tables;
}

function install()
{
    $private_key_path = APP_CONFIG_PATH . 'private_key.php';
    $config_file_path = APP_CONFIG_PATH . 'config.php';
    $setup_file_path = APP_SETUP_FILE;

    clearstatcache();
    // check if config directory is writable
    if (!is_writable(APP_CONFIG_PATH)) {
        return "The file '" . APP_CONFIG_PATH . "' directory needs to be writable by the web server user. Please correct this problem and try again.";
    }
    // need to create a random private key variable
    $private_key = '<?php
$private_key = "' . md5(microtime()) . '";
?>';
    $fp = @fopen($private_key_path, 'w');
    if ($fp === FALSE) {
        return "Could not open the file '$private_key_path' for writing. The permissions on the file should be set as to allow the user that the web server runs as to open it. Please correct this problem and try again.";
    }
    $res = fwrite($fp, $private_key);
    if ($fp === FALSE) {
        return "Could not write the configuration information to '$private_key_path'. The file should be writable by the user that the web server runs as. Please correct this problem and try again.";
    }
    fclose($fp);
    // check if we can connect
    $conn = @mysql_connect($_POST['db_hostname'], $_POST['db_username'], $_POST['db_password']);
    if (!$conn) {
        return getErrorMessage('connect', mysql_error());
    }
    $db_list = getDatabaseList($conn);
    $db_list = array_map('strtolower', $db_list);
    if (@$_POST['create_db'] == 'yes') {
        if (!in_array(strtolower($_POST['db_name']), $db_list)) {
            if (!mysql_query('CREATE DATABASE ' . $_POST['db_name'], $conn)) {
                return getErrorMessage('create_db', mysql_error());
            }
        }
    } else {
        if ((count($db_list) > 0) && (!in_array(strtolower($_POST['db_name']), $db_list))) {
            return "The provided database name could not be found. Review your information or specify that the database should be created in the form below.";
        }
    }
    // create the new user, if needed
    if (@$_POST["alternate_user"] == 'yes') {
        $user_list = getUserList($conn);
        if (count($user_list) > 0) {
            $user_list = array_map('strtolower', $user_list);
            if (@$_POST["create_user"] == 'yes') {
                if (!in_array(strtolower(@$_POST['eventum_user']), $user_list)) {
                    $stmt = "GRANT SELECT, UPDATE, DELETE, INSERT, ALTER, DROP, CREATE, INDEX ON " . $_POST['db_name'] . ".* TO '" . $_POST["eventum_user"] . "'@'%' IDENTIFIED BY '" . $_POST["eventum_password"] . "'";
                    if (!mysql_query($stmt, $conn)) {
                        return getErrorMessage('create_user', mysql_error());
                    }
                }
            } else {
                if (!in_array(strtolower(@$_POST['eventum_user']), $user_list)) {
                    return "The provided MySQL username could not be found. Review your information or specify that the username should be created in the form below.";
                }
            }
        }
    }
    // check if we can use the database
    if (!mysql_select_db($_POST['db_name'])) {
        return getErrorMessage('select_db', mysql_error());
    }
    // check the CREATE and DROP privileges by trying to create and drop a test table
    $table_list = getTableList($conn);
    $table_list = array_map('strtolower', $table_list);
    if (!in_array('eventum_test', $table_list)) {
        if (!mysql_query('CREATE TABLE eventum_test (test char(1))', $conn)) {
            return getErrorMessage('create_test', mysql_error());
        }
    }
    if (!mysql_query('DROP TABLE eventum_test', $conn)) {
        return getErrorMessage('drop_test', mysql_error());
    }
    $contents = implode("", file("schema.sql"));
    $queries = explode(";", $contents);
    unset($queries[count($queries)-1]);
    // COMPAT: the next line requires PHP >= 4.0.6
    $queries = array_map("trim", $queries);
    $queries = array_map("replace_table_prefix", $queries);
    foreach ($queries as $stmt) {
        if ((stristr($stmt, 'DROP TABLE')) && (@$_POST['drop_tables'] != 'yes')) {
            continue;
        }
        // need to check if a CREATE TABLE on an existing table throws an error
        if (!mysql_query($stmt, $conn)) {
            if (stristr($stmt, 'DROP TABLE')) {
                $type = 'drop_table';
            } else {
                $type = 'create_table';
            }
            return getErrorMessage($type, mysql_error());
        }
    }
    // substitute the appropriate values in config.php!!!
    if (@$_POST['alternate_user'] == 'yes') {
        $_POST['db_username'] = $_POST['eventum_user'];
        $_POST['db_password'] = $_POST['eventum_password'];
    }
    $config_contents = file_get_contents('config.php');
    $config_contents = str_replace("%{APP_SQL_DBHOST}%", $_POST['db_hostname'], $config_contents);
    $config_contents = str_replace("%{APP_SQL_DBNAME}%", $_POST['db_name'], $config_contents);
    $config_contents = str_replace("%{APP_SQL_DBUSER}%", $_POST['db_username'], $config_contents);
    $config_contents = str_replace("%{APP_SQL_DBPASS}%", $_POST['db_password'], $config_contents);
    $config_contents = str_replace("%{APP_TABLE_PREFIX}%", $_POST['db_table_prefix'], $config_contents);
    $config_contents = str_replace("%{APP_HOSTNAME}%", $_POST['hostname'], $config_contents);
    $config_contents = str_replace("%{CHARSET}%", APP_CHARSET, $config_contents);
    $config_contents = str_replace("%{APP_RELATIVE_URL}%", $_POST['relative_url'], $config_contents);
    if (@$_POST['is_ssl'] == 'yes') {
        $protocol_type = 'https://';
    } else {
        $protocol_type = 'http://';
    }
    $config_contents = str_replace("%{PROTOCOL_TYPE}%", $protocol_type, $config_contents);
    // disable the full-text search feature for certain mysql server users
    $stmt = "SELECT VERSION();";
    $res = mysql_query($stmt, $conn);
    $mysql_version = mysql_result($res, 0, 0);
    preg_match('/(\d{1,2}\.\d{1,2}\.\d{1,2})/', $mysql_version, $matches);
    if ($matches[1] > '4.0.23') {
        $config_contents = str_replace("'%{APP_ENABLE_FULLTEXT}%'", "true", $config_contents);
    } else {
        $config_contents = str_replace("'%{APP_ENABLE_FULLTEXT}%'", "false", $config_contents);
    }

    $fp = @fopen($config_file_path, 'w');
    if ($fp === FALSE) {
        return "Could not open the file '$config_file_path' for writing. The permissions on the file should be set as to allow the user that the web server runs as to open it. Please correct this problem and try again.";
    }
    $res = fwrite($fp, $config_contents);
    if ($fp === FALSE) {
        return "Could not write the configuration information to '$config_file_path'. The file should be writable by the user that the web server runs as. Please correct this problem and try again.";
    }
    fclose($fp);

    // write setup file
    require_once(APP_INC_PATH . "class.setup.php");
    $_REQUEST['setup']['update'] = 1;
    $_REQUEST['setup']['closed'] = 1;
    $_REQUEST['setup']['emails'] = 1;
    $_REQUEST['setup']['files'] = 1;
    $_REQUEST['setup']['allow_unassigned_issues'] = 'yes';
    $_REQUEST['setup']['support_email'] = 'enabled';
    Setup::save($_REQUEST['setup']);

    return 'success';
}


function ev_gettext($str)
{
    return $str;
}