<?php

/*

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

 * Copyright (C) 2006-2009 Dan Fuhry

 * Installation package

 * database_mysql.php - Installer database info page, MySQL

 *

 * 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();

if ( isset($_POST['_cont']) )

{

	$allow_go = true;

	// Do we have everything? If so, continue with installation.

	foreach ( array('db_host', 'db_port', 'db_name', 'db_user', 'db_pass') as $field )

	{

		if ( empty($_POST[$field]) )

		{

			$allow_go = false;

		}

	}

	if ( $allow_go )

	{

		require( ENANO_ROOT . '/install/includes/stages/database_post.php' );

		return true;

	}

}

if ( isset($_POST['ajax_test']) )

{

	// Test the database connection

	$return = array(

			'can_install' => false,

			'host_good' => true,

			'creating_user' => false,

			'db_exist' => false,

			'creating_db' => false,

			'creating_db_grant' => false,

			'root_fail' => false,

			'version' => array(

				'version' => 'unknown',

				'good' => 'indeterminate'

			),

			'last_error' => ''

		);

	if ( !isset($_POST['info']) )

		die();

	$info = $_POST['info'];

	// From here on out will be JSON responses

	header('Content-type: application/json');

	try

	{

		$info = @enano_json_decode($info);

	}

	catch ( Zend_Json_Exception $e )

	{

		die(enano_json_encode(array(

				'mode' => 'error',

				'error' => 'Exception in JSON decoder'

			)));

	}

	if ( preg_match('/^:/', $info['db_host']) && !@file_exists(substr($info['db_host'], 1)) )

	{

		$return['host_good'] = false;

		echo enano_json_encode($return);

		exit();

	}

	if ( $info['db_host'] == 'localhost' && !empty($info['db_port']) && $info['db_port'] != 3306 )

		$info['db_host'] = '127.0.0.1';

	$dbhost = ( preg_match('/^:/', $info['db_host']) ) ? $info['db_host'] : "{$info['db_host']}:{$info['db_port']}";

	{

		{

			{

				$return['version'] = array(

					'version' => $version,

					'good' => version_compare($version, '4.0.17', '>=')

				);

				$return['can_install'] = ( $return['version']['good'] ) ? true : false;

			}

			else

			{

				$return['creating_db'] = true;

			}

		}

		{

		}

	}

	else

	{

		{

			$return['last_error'] = mysql_error();

			if ( !empty($info['db_root_user']) && !empty($info['db_root_pass']) )

			{

				$test_root = @mysql_connect($dbhost, $info['db_root_user'], $info['db_root_pass']);

				if ( $test_root )

				{

					// We logged in with root rights, assume that we have appropriate permissions.

					// If not, well, the installation will fail. Tough on the user, but creating

					// test databases/users is too risky.

					{

					}

					$return['version'] = array(

						'version' => $version,

						'good' => version_compare($version, '4.0.17', '>=')

					);

					$return['can_install'] = ( $return['version']['good'] ) ? true : false;

				}

				else

				{

					// Well that helped. Root credentials are bad.

					$return['creating_db'] = true;

					$return['root_fail'] = true;

				}

			}

		}

	}

	if ( isset($test) && @is_resource($test) )

		@mysql_close($test);

	if ( isset($test_root) && @is_resource($test_root) )

		@mysql_close($test_root);

	echo enano_json_encode($return);

	exit();

}

$ui->add_header('<script type="text/javascript" src="includes/js/formutils.js"></script>');

$ui->show_header();

?>

<div style="float: right; padding: 10px 0 10px 10px;">

	<img alt="MySQL logo" src="../images/about-powered-mysql.png" />

</div>

<p><?php echo $lang->get('dbmysql_blurb_needdb'); ?></p>

<p><?php echo $lang->get('dbmysql_blurb_howtomysql'); ?></p>

<?php

if ( @file_exists('/etc/enano-is-virt-appliance') )

{

	echo '<p>

					' . $lang->get('database_vm_login_info', array( 'host' => 'localhost', 'user' => 'enano', 'pass' => 'clurichaun', 'name' => 'enano_www1' )) . '

				</p>';

}

?>

<script type="text/javascript">

	var tested = false;

	function verify(field)

	{

		if ( tested && !field )

			return true;

		tested = false;

		if ( document.getElementById('verify_error').className != '' )

		{

			document.getElementById('verify_error').className = '';

			document.getElementById('verify_error').innerHTML = '';

		}

		var frm = document.forms.database_info;

		// List of fields

		var fields = {

			db_host: frm.db_host,

			db_port: frm.db_port,

			db_name: frm.db_name,

			db_user: frm.db_user,

			db_pass: frm.db_pass,

			table_prefix: frm.table_prefix,

			db_root_user: frm.db_root_user,

			db_root_pass: frm.db_root_pass

		};

		var passed = true;

		// Main validation

		if ( field == fields.db_host || !field )

		{

			var matches = fields.db_host.value.match(/^(([a-z0-9_-]+)((\.([a-z0-9_-]+))*)|:[A-z0-9_:\.\/-]+)$/);

			document.getElementById('s_db_host').src = ( matches ) ? img_neu : img_bad;

			if ( !matches )

				passed = false;

		}

		if ( field == fields.db_port || !field )

		{

			var matches = fields.db_port.value.match(/^[0-9]+$/);

			document.getElementById('s_db_port').src = ( matches ) ? img_neu : img_bad;

			if ( !matches )

				passed = false;

		}

		if ( field == fields.db_name || !field )

		{

			var matches = fields.db_name.value.match(/^[A-z0-9_-]+$/);

			document.getElementById('s_db_name').src = ( matches ) ? img_neu : img_bad;

			if ( !matches )

				passed = false;

		}

		if ( field == fields.db_user || field == fields.db_pass || !field )

		{

			var matches = fields.db_user.value.match(/^[A-z0-9_-]+$/);

			document.getElementById('s_db_auth').src = ( matches ) ? img_neu : img_bad;

			if ( !matches )

				passed = false;

		}

		if ( field == fields.table_prefix || !field )

		{

			var matches = fields.table_prefix.value.match(/^[a-z0-9_]*$/);

			document.getElementById('s_table_prefix').src = ( matches ) ? img_good : img_bad;

			if ( !matches )

				passed = false;

		}

		if ( field == fields.db_root_user || field == fields.db_root_pass || !field )

		{

			var matches = ( ( fields.db_root_user.value.match(/^[A-z0-9_-]+$/) && fields.db_root_pass.value.match(/^.+$/) ) || fields.db_root_user.value == '' );

			document.getElementById('s_db_root').src = ( matches ) ? img_neu : img_bad;

			if ( !matches )

				passed = false;

		}

		return passed;

	}

	function ajaxTestConnection()

	{

		if ( !verify() )

		{

			document.body.scrollTop = 0;

			$('enano-body').effect('shake', {}, 750);

			document.getElementById('verify_error').className = 'error-box-mini';

			document.getElementById('verify_error').innerHTML = $lang.get('meta_msg_err_verification');

			return false;

		}

		install_set_ajax_loading();

		var frm = document.forms.database_info;

		var connection_info = 'info=' + ajaxEscape(toJSONString({

				db_host: frm.db_host.value,

				db_port: frm.db_port.value,

				db_name: frm.db_name.value,

				db_user: frm.db_user.value,

				db_pass: frm.db_pass.value,

				db_root_user: frm.db_root_user.value,

				db_root_pass: frm.db_root_pass.value

			}));

		ajaxPost(scriptPath + '/install/install.php?stage=database', connection_info + '&driver=mysql&ajax_test=on&language=' + enano_lang_code[ENANO_LANG_ID], function(ajax)

			{

				if ( ajax.readyState == 4 && ajax.status == 200 )

				{

					setTimeout('install_unset_ajax_loading();', 750);

					// Process response

					var response = String(ajax.responseText + '');

					if ( response.substr(0, 1) != '{' )

					{

						alert('Received an invalid JSON response from the server.');

						return false;

					}

					response = parseJSON(response);

					if ( response.mode == 'error' )

					{

						return false;

					}

					document.getElementById('e_db_host').innerHTML = '';

					document.getElementById('e_db_name').innerHTML = '';

					document.getElementById('e_db_auth').innerHTML = '';

					document.getElementById('e_db_root').innerHTML = '';

					if ( response.can_install )

					{

						tested = true;

						var statuses = ['s_db_host', 's_db_name', 's_db_auth', 's_table_prefix', 's_db_root', 's_mysql_version'];

						for ( var i in statuses )

						{

							var img = document.getElementById(statuses[i]);

							if ( img )

								img.src = img_good;

						}

						document.getElementById('e_mysql_version').innerHTML = $lang.get('dbmysql_msg_info_mysql_good');

						document.getElementById('verify_error').className = 'info-box-mini';

						document.getElementById('verify_error').innerHTML = $lang.get('dbmysql_msg_test_success');