<?php
include('data/config.inc.php');
require_once('install/classes/class.filesystem.php');
$filesystem = new filesystem($config['ftp_server'], $config['ftp_user'], $config['ftp_pw'], $config['ftp_port']);
$filesystem->set_wd($config['ftp_path'], $config['fpath']);
if (isset($_REQUEST['save']) && $_REQUEST['save'] == 1) {
	if (isset($_REQUEST['action']) && is_array($_REQUEST['action'])) {
		$action = $_REQUEST['action'];
	}
	else {
		$action = array();
	}
	require_once('install/classes/database/'.$config['dbsystem'].'.inc.php');
	$db = new DB($config['host'], $config['dbuser'], $config['dbpw'], $config['database'], $config['dbprefix']);
	$db->setPersistence($config['pconnect']);
	$db->connect(false);
	if (!$db->hasConnection()) {
		?>
	<div class="bbody">Could not connect to database! Pleasy try again later or check the database settings!</div>
	<div class="bfoot center"><a class="submit" href="index.php?package=install&amp;step=<?php echo $step-2; ?>">Go back</a> <a class="submit" href="index.php?package=install&amp;step=<?php echo $step; ?>">Refresh</a></div>
		<?php
	}
	else {
		if (!$db->select_db()) {
			?>
	<div class="bbody">Could not find database <em><?php echo $db->database; ?></em>! Pleasy create a new database with this name or choose another database!</div>
	<div class="bfoot center"><a class="submit" href="index.php?package=install&amp;step=<?php echo $step-2; ?>">Go back</a> <a class="submit" href="index.php?step=<?php echo $step; ?>">Refresh</a></div>
			<?php
		}
		else {
			$act = array(
				3 => array(
						'table has been deleted and recreated',
						'tables have been deleted and recreated',
					 ),
				2 => array(
						'table has not been changed',
						'tables have not been changed',
					 ),
				1 => array(
						'table has been cleared',
						'tables have been cleared',
					 ),
				0 => array(
						'table has been recreated',
						'tables have been recreated'
					 )
			);
			$done = array_fill(0, 4, 0);
			foreach ($action as $table => $value) {
				$t = $db->pre.$table;
				$file = 'install/package/'.$package.'/db/'.$table.'.sql';
				if ($value == 0) {
					$sql = implode('', file($file));
					$sql = str_replace('{:=DBPREFIX=:}', $db->pre, $sql);
					$db->multi_query($sql);
				}
				elseif ($value == 1) {
					$db->query("TRUNCATE TABLE `{$t}`");
				}
				elseif ($value == 3) {
					$sql = implode('', file($file));
					$sql = str_replace('{:=DBPREFIX=:}', $db->pre, $sql);
					$drop = "DROP TABLE IF EXISTS `{$t}`;\n";
					$db->multi_query($drop.$sql);
				}
				else {
					$value = 2;
					// Do nothing with tables!
				}
				$done[$value]++;
			}
			if (isset($_REQUEST['sample_d1']) && $_REQUEST['sample_d1'] == 1) {
				$sql = implode('', file('install/package/install/db/sample1.dat'));
				$sql = str_replace('{:=DBPREFIX=:}', $db->pre, $sql);
				$db->multi_query($sql);
				$done[] = 'Sample Data (Forum) have been installed.';
			}
			if (isset($_REQUEST['sample_d2']) && $_REQUEST['sample_d2'] == 1) {
				$sql = implode('', file('install/package/install/db/sample2.dat'));
				$sql = str_replace('{:=DBPREFIX=:}', $db->pre, $sql);
				$db->multi_query($sql);
				$done[] = 'Sample Data (CMS) have been installed.';
			}
			echo '<div class="bfoot">';
			if (array_sum($done) == 0) {
				echo "<strong>No changes applied!</strong>";
			}
			else {
				foreach ($act as $id => $name) {
					if ($done[$id] > 0) {
						$txt = $done[$id] == 1 ? $name[0] : $name[1];
						echo "<strong>{$done[$id]} {$txt}.</strong><br />";
					}
				}
			}
			echo '</div>';
		}
	}
	$db->close();
}
?>
<div class="bbody">
	<input type="hidden" name="save" value="1" />
	<label for="name">User Name:</label>
	<input class="label" id="name" name="name" size="40" />
	<br class="newinput" /><hr class="formsep" />
	<label for="pw">Password:</label>
	<input class="label" type="password" id="pw" name="pw" size="40" />
	<br class="newinput" /><hr class="formsep" />
	<label for="pwx">Confirm Password:</label>
	<input class="label" type="password" id="pwx" name="pwx" size="40" />
	<br class="newinput" /><hr class="formsep" />
	<label for="email">E-mail address:</label>
	<input class="label" type="text" id="email" name="email" size="40" value="<?php echo $config['forenmail']; ?>" />
	<br class="newinput" /><br class="iefix_br" />
</div>
<div class="bfoot center"><input type="submit" value="Continue" /></div>