<?php
require('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) {
	include('install/classes/class.phpconfig.php');
	if (isset($_REQUEST['host'])) {
		$config['host'] = $_REQUEST['host'];
	}
	else {
		$config['host'] = 'localhost';
	}
	if (isset($_REQUEST['dbuser'])) {
		$config['dbuser'] = $_REQUEST['dbuser'];
	}
	if (isset($_REQUEST['dbpw'])) {
		$config['dbpw'] = $_REQUEST['dbpw'];
	}
	if (isset($_REQUEST['database'])) {
		$config['database'] = $_REQUEST['database'];
	}
	if (isset($_REQUEST['pconnect']) && isset($_REQUEST['dbsystem']) && $_REQUEST['dbsystem'] == 'mysql') {
		$config['pconnect'] = $_REQUEST['pconnect'];
	}
	else {
		$config['pconnect'] = 0;
	}
	if (isset($_REQUEST['dbprefix'])) {
		$config['dbprefix'] = $_REQUEST['dbprefix'];
	}
	else {
		$config['dbprefix'] = '';
	}
	if (isset($_REQUEST['dbsystem'])) {
		$config['dbsystem'] = GPC_escape($_REQUEST['dbsystem'], GPC_ALNUM);
	}
	else {
		$config['dbsystem'] = 'mysql';
	}
	$c = new manageconfig();
	$c->getdata('data/config.inc.php');
	$c->updateconfig('host',str);
	$c->updateconfig('dbuser',str);
	$c->updateconfig('dbpw',str);
	$c->updateconfig('database',str);
	$c->updateconfig('pconnect',int);
	$c->updateconfig('dbprefix',str);
	$c->updateconfig('dbsystem',str);
	$c->savedata();

	$errlog = 'data/errlog_'.$config['dbsystem'].'.inc.php';
	if (!file_exists($errlog)) {
		$filesystem->file_put_contents($errlog, '', true);
		$filesystem->chmod($errlog, 0666);
	}
?>
<div class="bfoot center">Database Settings saved!</div>
<?php
}
require('data/config.inc.php');
$prefix = preg_replace("/\W+/i", '', $config['dbprefix']);
if ($prefix != $config['dbprefix']) {
	?>
<div class="bbody">The prefix is not valid!</div>
<div class="bfoot center"><a class="submit" href="index.php?package=install&amp;step=<?php echo $step-1; ?>">Go back</a> <a class="submit" href="index.php?package=install&amp;step=<?php echo $step; ?>">Refresh</a></div>
	<?php
}
else {
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-1; ?>">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>! Please 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-1; ?>">Go back</a> <a class="submit" href="index.php?package=install&amp;step=<?php echo $step; ?>">Refresh</a></div>
		<?php
	}
	else {
		?>
<div class="bbody">
	<input type="hidden" name="save" value="1" />
	<table class="tables">
	<tr>
	    <td colspan="4" class="bfoot">Setting up the database is a very time consuming task. It may need several minutes to load the page completely!</td>
	</tr>
	<tr>
		<td width="40%"><strong>Table</strong></td>
		<td width="10%"><strong>Exists</strong></td>
		<td width="10%"><strong>Entries</strong></td>
		<td width="40%"><strong>Action</strong></td>
	</tr>
	<?php
	$path = 'install/package/'.$package.'/db/';
	$tables = $db->list_tables();
	$dh = opendir($path);
	while (($file = readdir($dh)) !== false) {
		$info = pathinfo($path.$file);
		if ($info['extension'] == 'sql') {
			$basename = substr($info['basename'], 0, -(strlen($info['extension']) + ($info['extension'] == '' ? 0 : 1)));;
			$t = $db->pre.$basename;
			unset($counter);
			$select = array();
			if (in_array($t, $tables)) {
				$exists = '<span class="hl_false">Yes</span>';
				$result = $db->query('SELECT COUNT(*) AS c FROM '.$t);
				$counter = $db->fetch_assoc($result);
				$entries = $counter['c'];
				$select[] = '<option value="3" selected="selected">Delete and recreate table</option>';
				$select[] = '<option value="2">Do not change table</option>';
				if ($counter['c'] > 0) {
					$select[] = '<option value="1">Clear table</option>';
				}
			}
			else {
				$exists = '<span class="hl_true">No</span>';
				$entries = '-';
				$select[] = '<option value="0" selected="selected">Create table</option>';
			}
		?>
	<tr>
		<td><?php echo $db->pre; ?><strong><?php echo $basename; ?></strong></td>
		<td class="center"><?php echo $exists; ?></td>
		<td class="textright"><?php echo $entries; ?></td>
		<td>
		<select size="<?php echo count($select); ?>" name="action[<?php echo $basename; ?>]">
<?php echo implode("\n", $select); ?>
		</select>
		</td>
	</tr>
		<?php
		}
	}
	closedir($dh);
	?>
	</table>
</div>
<h3>Install Sample Data</h3>
<div class="bbody">
	<label for="sample_d1">Posts, Votes, Text parser and Forums:</label>
	<input class="label" id="sample_d1" name="sample_d1" type="checkbox" value="1" />
	<br class="newinput" /><hr class="formsep" />
	<label for="sample_d2">Documents and Navigation:</label>
	<input class="label" id="sample_d2" name="sample_d2" type="checkbox" value="1" />
	<br class="newinput" /><br class="iefix_br" />
</div>
<div class="bfoot center"><input type="submit" value="Continue" /></div>
	<?php
	}
}
}
$db->close();
?>