<?php
/* phpMyProfiler
* Copyright (C) 2005-2009 The phpMyProfiler project
*
* 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; 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 the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
*/
define('_PMP_REL_PATH', '..');
$pmp_module = 'install';
require_once('../config.inc.php');
require_once('../include/functions.php');
function showmsg($type, $msg) {
echo '<tr><td width="40">';
if ( $type == "Error" )
echo '<img src="images/messagebox_error.jpg" border="0" alt="" />';
else if ( $type == "Warning" )
echo '<img src="images/messagebox_warning.jpg" border="0" alt="" />';
else if ( $type == "Info" )
echo '<img src="images/messagebox_info.jpg" border="0" alt="" />';
else
echo '<img src="images/messagebox_success.jpg" border="0" alt="" />';
echo '</td><td>' . $msg . '</td></tr>';
}
header('Content-type: text/html; charset=utf-8');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>phpMyProfiler - Installation</title>
<link href="css/install.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div style="text-align: center;" align="center">
<div id="mainover" style="margin-left:auto; margin-right:auto">
<div id="mainpanel">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr style="height: 10px"><td> </td></tr>
<tr style="height: 32px">
<td width="10"> </td>
<td colspan="10">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td><img src="images/install.jpg" border="0" alt="" /><img src="images/logo.jpg" border="0" alt="" /></td>
<td align="right" valign="bottom">Version: <?php echo $pmp_version; ?></td>
<td style="width: 10px"> </td>
</tr>
</table>
</td>
</tr>
<tr style="height: 10px"><td> </td></tr>
<tr style="height: 30px">
<td style="width: 10px"> </td>
<td class="step-off"><?php echo t('Pre-Installation Check'); ?></td> <td style="width: 3px"> </td>
<td class="step-off"><?php echo t('Step 1'); ?></td> <td style="width: 3px"> </td>
<td class="step-on"> <?php echo t('Step 2'); ?></td> <td style="width: 3px"> </td>
<td class="step-off"><?php echo t('Step 3'); ?></td> <td style="width: 3px"> </td>
<td class="step-off"><?php echo t('Finish'); ?></td> <td style="width: 3px"> </td>
<td style="width: 10px"> </td>
</tr>
</table>
</div>
<div class="maintext">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr><td colspan="3" class="mainheader"><?php echo t('Create phpMyProfiler Database'); ?></td></tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td style="width: 20px"> </td>
<td>
<table cellpadding="3" cellspacing="0" border="0" width="100%" class="maintests">
<?php
// Check Connection to Database
if ( !@mysql_connect($pmp_sqlhost, $pmp_sqluser, $pmp_sqlpass) ) {
showmsg('Error', t('Unable to connect to database.'));
$failed = TRUE;
}
else {
showmsg('Success', t('Connection to database established.'));
// Check Database exist
if ( !mysql_select_db($pmp_sqldatabase) ) {
showmsg('Warning', t("Can't select database. Trying to create..."));
if ( !mysql_query("CREATE DATABASE $pmp_sqldatabase DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci") ) {
showmsg('Error', t("Can't create database."));
$failed = TRUE;
}
else {
showmsg('Success', t('Database created.'));
mysql_select_db($pmp_sqldatabase);
}
}
else {
showmsg('Success', t('Connected to existing database.'));
}
// Start creating Tables
if ( !isset($failed) ) {
showmsg('Info', t('Start Creating tables.'));
$query = file("sql/phpmyprofiler.sql");
$query = array_map("trim", $query);
foreach ( $query as $index => $line ) {
if ((strpos($line, "#") === 0) || (substr($line, 0, 2) == '--') || $line == NULL)
unset($query[$index]);
}
$query = array_values($query);
foreach ( explode(';', implode(' ',$query)) as $sql ) {
if ( strlen(trim($sql)) > 0 )
dbexec($sql);
}
showmsg('Success', t('Tables created successfully.'));
showmsg('Info', t('Starting importing data'));
$query = file("sql/phpmyprofiler_data.sql");
$query = array_map("trim", $query);
foreach ( $query as $index => $line ) {
if ( strpos($line, "INSERT") === FALSE )
unset($query[$index]);
}
foreach ( $query as $sql )
dbexec($sql);
showmsg('Success', t('Data imported successfully.'));
showmsg('Success', t('Installation finished'));
}
}
if ( isset($failed) ) {
showmsg('Error', t('Installation halted, check your Configuration.'));
}
?>
</table>
</td>
</tr>
</table>
</div>
<div class="maintext">
<table cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td align="center" style="text-align: center">
<?php
if ( isset($failed)) {
?>
<form action="install1.php" method="post" target="_self" style="display: inline;" accept-charset="utf-8">
<input type="submit" name="submit" class="next" value="<?php echo t('Back'); ?>" />
</form>
<?php
}
else {
?>
<form action="install3.php" method="post" target="_self" style="display: inline;">
<input type="submit" name="submit" class="next" value="<?php echo t('Next'); ?>" />
</form>
<?php
}
?>
</td>
</tr>
</table>
</div>
</div>
</div>
</body>
</html>