<?php

/*

part-db version 0.1

Copyright (C) 2005 Christoph Lechner

http://www.cl-projects.de/

part-db version 0.2+

Copyright (C) 2009 K. Jacobs and others (see authors.php)

http://code.google.com/p/part-db/

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 the Free Software

Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA

*/

include_once('start_session.php');

$messages = array();

$fatal_error = false; // if a fatal error occurs, only the $messages will be printed, but not the site content

/********************************************************************************

*

* Evaluate $_REQUEST

*

*********************************************************************************/

$db_type = isset($_REQUEST['db_type']) ? (string)$_REQUEST['db_type'] : 'mysql';

$db_charset = isset($_REQUEST['db_charset']) ? (string)$_REQUEST['db_charset'] : 'utf8';

$db_host = isset($_REQUEST['db_host']) ? (string)$_REQUEST['db_host'] : 'localhost';

$db_name = isset($_REQUEST['db_name']) ? (string)$_REQUEST['db_name'] : '';

$db_user = isset($_REQUEST['db_user']) ? (string)$_REQUEST['db_user'] : '';

$db_password = isset($_REQUEST['db_password']) ? trim((string)$_REQUEST['db_password']) : '';

$admin_password = isset($_REQUEST['admin_password']) ? trim((string)$_REQUEST['admin_password']) : '';

$automatic_updates_enabled = isset($_REQUEST['automatic_updates_enabled']);

$action = 'default';

if (isset($_REQUEST["apply_connection_settings"])) {$action = 'apply_connection_settings';}

if (isset($_REQUEST["apply_auto_updates"])) {$action = 'apply_auto_updates';}

if (isset($_REQUEST["make_update"])) {$action = 'make_update';}

if (isset($_REQUEST["make_new_update"])) {$action = 'make_new_update';}

/********************************************************************************

*

* Initialize Objects

*

*********************************************************************************/

$html = new HTML($config['html']['theme'], $config['html']['custom_css'], 'Datenbank');

try

{

$database = new Database();

}

catch (Exception $e)

{

$messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red');

$fatal_error = true;

}

/********************************************************************************

*

* Execute actions

*

*********************************************************************************/

switch ($action)

{

case 'apply_connection_settings':

$config_old = $config;

try

{

if ($config['is_online_demo'])

break;

if ( ! is_admin_password($admin_password))

throw new Exception('Das Administratorpasswort ist falsch!');

$config['db']['type'] = $db_type;

//$config['db']['charset'] = $db_charset; // temporarly deactivated

$config['db']['host'] = $db_host;

$config['db']['name'] = $db_name;

$config['db']['user'] = $db_user;

$config['db']['password'] = $db_password;

save_config();

header('Location: system_database.php'); // Reload the page that we can see if the new settings are stored successfully

}

catch (Exception $e)

{

$config = $config_old; // reload the old config

$messages[] = array('text' => 'Die neuen Werte konnten nicht gespeichert werden!', 'strong' => true, 'color' => 'red');

$messages[] = array('text' => 'Fehlermeldung: '.nl2br($e->getMessage()), 'color' => 'red');

}

break;

case 'apply_auto_updates':

$config_old = $config;

try

{

$config['db']['auto_update'] = $automatic_updates_enabled;

save_config();

//header('Location: system_database.php'); // Reload the page that we can see if the new settings are stored successfully --> does not work correctly?!

}

catch (Exception $e)

{

$config = $config_old; // reload the old config

$messages[] = array('text' => 'Die neuen Werte konnten nicht gespeichert werden!', 'strong' => true, 'color' => 'red');

$messages[] = array('text' => 'Fehlermeldung: '.nl2br($e->getMessage()), 'color' => 'red');

}

break;

case 'make_new_update':

// start the next update attempt from the beginning, not from the step of the last error

$config['db']['update_error']['version'] = -1;

$config['db']['update_error']['next_step'] = 0;

case 'make_update':

try

{

if ( ! is_object($database))

throw new Exception('Es konnte keine Verbindung mit der Datenbank hergestellt werden!');

$database_update_executed = true;

$update_log = $database->update();

foreach ($update_log as $message) {

$messages[] = array('text' => nl2br($message['text']), 'color' => ($message['error'] == true ? 'red' : 'black'));

}

}

catch (Exception $e)

{

$messages[] = array('text' => 'Es trat ein Fehler auf!', 'strong' => true, 'color' => 'red');

$messages[] = array('text' => 'Fehlermeldung: '.nl2br($e->getMessage()), 'color' => 'red');

}

$messages[count($messages)-1]['text'] .= nl2br("\n");

break;

}

/********************************************************************************

*

* Set all HTML variables

*

*********************************************************************************/

$html->set_variable('is_online_demo', $config['is_online_demo'], 'boolean');

$html->set_loop('db_type_loop', array_to_template_loop($config['db_types'], $config['db']['type']));

$html->set_loop('db_charset_loop', array_to_template_loop($config['db_charsets'], $config['db']['charset']));

$html->set_variable('db_host', $config['db']['host'], 'string');

$html->set_variable('db_name', $config['db']['name'], 'string');

$html->set_variable('db_user', $config['db']['user'], 'string');

$html->set_variable('automatic_updates_enabled', $config['db']['auto_update'], 'boolean');

$html->set_variable('refresh_navigation_frame', (isset($database_update_executed) && $database_update_executed), 'boolean');

if (! $fatal_error)

{

try

{

$current = $database->get_current_version();

$latest = $database->get_latest_version();

$html->set_variable('current_version', $current, 'integer');

$html->set_variable('latest_version', $latest, 'integer');

$html->set_variable('update_required', ($latest > $current), 'boolean');

$html->set_variable('last_update_failed', ($config['db']['update_error']['version'] == $current), 'boolean');

if (($current > 0) && ($current < 13) && ($latest >= 13)) // v12 to v13 was a huge update! show warning!

{

$messages[] = array('text' => 'Achtung!<br><br>'.

'Das Datenbankupdate auf Version 13 ist sehr umfangreich, es finden sehr viele Veränderungen statt.<br>'.

'Es wird dringend empfohlen, vor dem Update eine Sicherung der Datenbank anzulegen, '.

'damit diese im Fehlerfall wiederhergestellt, und so ein Datenverlust verhindert werden kann.<br>'.

'Die Entwickler von Part-DB übernehmen keinerlei Haftung für Schäden, die durch fehlgeschlagene Updates, '.

'Fehler in der Software oder durch andere Ursachen hervorgerufen werden.',

'strong' => true, 'color' => 'red', );

}

elseif (($current > 0) && ($latest > $current)) // normal update...we will show a hint

{

$messages[] = array('text' => 'Hinweis:<br><br>'.

'Es wird dringend empfohlen, vor jedem Datenbankupdate eine Sicherung der Datenbank anzulegen.<br>'.

'Die Entwickler von Part-DB übernehmen keinerlei Haftung für Schäden, die durch fehlgeschlagene Updates, '.

'Fehler in der Software oder durch andere Ursachen hervorgerufen werden.',

'strong' => true, 'color' => 'red', );

}

}

catch (Exception $e)

{

$messages[] = array('text' => nl2br($e->getMessage()), 'strong' => true, 'color' => 'red', );

$fatal_error = true;

}

}

$html->set_variable('hide_status', $fatal_error, 'boolean');

/********************************************************************************

*

* Generate HTML Output

*

*********************************************************************************/

// an empty $reload_link means that the reload-button won't be visible

$reload_link = ($fatal_error || isset($database_update_executed)) ? 'system_database.php' : '';

$html->print_header($messages, $reload_link);

//if (! $fatal_error) // we don't hide the site content if there is an error, because this way we can set the database connection data

$html->print_template('system_database');

$html->print_footer();

?>