<?php

echo '<div>
	<div class="title">' . $lang['mysqlInstallation'] . '</div>';

// Installing

require_once '../configuration.php';

$con->connect();

$queryMsgAlter1 = "ALTER TABLE " . $dbTables['config'] . "
 ADD `timezone` varchar(255) NOT NULL;";

$queryMsgAlter2 = "ALTER TABLE " . $dbTables['config'] . "
 ADD `reCaptcha` tinyint(1) NOT NULL;";

$queryMsgAlter3 = "ALTER TABLE " . $dbTables['config'] . "
 ADD `reCaptchapubk` varchar(255) NOT NULL;";

$queryMsgAlter4 = "ALTER TABLE " . $dbTables['config'] . "
 ADD `reCaptchaprvk` varchar(255) NOT NULL;";

if ($con->modify($queryMsgAlter1) && $con->modify($queryMsgAlter2) && $con->modify($queryMsgAlter3) && $con->modify($queryMsgAlter4)) {
	$queryMsg = "UPDATE " . $dbTables['config'] . " SET reCaptcha=0";

	if ($con->modify($queryMsg)) {
		echo "<div class=\"msgSuccess\">" . $lang['installationDone'] . "</div>";

		// Remember to delete setup folder !!

		echo "<div class=\"title\">" . $lang['finishing'] . "</div>";

		echo '<div>' . $lang['deleteSetup'] . '<br />' . $lang['yesYouCan'] . ' : <br />
		<a href="../index.php">' . $lang['newGuestbook'] . '</a>
		<br />
		<a href="../admin/">' . $lang['adminCenter'] . '</a>';
	}
	else {
		echo "<div class=\"msgError\">" . $lang['dataError'] . "</div>";
		$con->printError();
		echo '<div id="previous"><a href="index.php?a=install&lang=' . $instLang . '">' . $lang['previous'] . '</a></div>';
	}
}
else {
	echo "<div class=\"msgError\">" . $lang['dataError'] . "</div>";
	$con->printError();
	echo '<div id="previous"><a href="index.php?a=method&lang=' . $instLang . '">' . $lang['previous'] . '</a></div>';
}

$con->close();

?>