function fs_output_database_table()
{
?>
<table>
<?php
if (!fs_db_valid()) {
?>
<tr>
<td colspan='2'>
<div class="fwrap">
<?php
echo fs_r('Database status') . " : <b style='color:red'>" . fs_get_database_status_message() . "</b>";
?>
<br/>
<?php
$st = fs_get_db_status();
if ($st['status'] == FS_DB_NEED_UPGRADE) {
?>
<div id="database_upgrade_div">
<span class="notice"><?php
fs_e('Click to upgrade');
?>
</span>
<button id="upgrade_db" class="button" onclick="upgradeDatabase()"><?php
fs_e('Upgrade');
?>
</button>
</div>
<?php
}
?>
</div>
</td>
</tr>
<?php
}
?>
</table>
<div id="database_table_config_div">
<table>
<tr>
<td colspan="2">
<div class="fwrap">
<?php
$cfg_source = fs_get_config_source_desc();
$cfg_source_div = "<div id='config_source'><b>{$cfg_source}</b></div>";
echo sprintf(fs_r('Configuration source : %s'), $cfg_source_div);
echo '<div id="switch_to_external_system">';
if (fs_should_show_use_wp_button()) {
?>
<br/>
<?php
fs_e('To use wordpress database, click this button.');
?>
<br/>
<?php
echo '<div class="notice">' . fs_r('FireStats database configuration will be lost.') . '</div>';
?>
<br/>
<button class="button" onclick="useWordpressDB()"><?php
fs_e('Use Wordpress database');
?>
</button>
<?php
}
echo '</div>';
?>
</div> <!-- fwrap -->
</td>
</tr>
<tr>
<td colspan="2">
<div class="fwrap">
<?php
fs_e('To perform one of the following actions:');
?>
<ul>
<li><?php
fs_e('Attach to an existing FireStats installation');
?>
</li>
<li><?php
fs_e('Install FireStats into an existing database');
?>
</li>
<li><?php
fs_e('Create a new database and install FireStats there');
?>
</li>
</ul>
<?php
fs_e('Follow instructions in the help');
?>
</div>
</td>
</tr>
<tr>
<?php
global $fs_config;
?>
<td><?php
fs_e('Database host');
?>
</td>
<td id="holder_database_host">
<input type="text" size="30" name="text_database_host" id="text_database_host" onkeypress="return trapEnter(event,'testDBConnection()')" value="<?php
print $fs_config['DB_HOST'];
?>
"/>
</td>
</tr>
<tr>
<td><?php
fs_e('Database name');
?>
</td>
<td id="holder_database_name">
<input type="text" size="30" name="text_database_name" id="text_database_name" onkeypress="return trapEnter(event,'testDBConnection()')" value="<?php
print $fs_config['DB_NAME'];
?>
"/>
</td>
</tr>
<tr>
<td><?php
fs_e('Database user name');
?>
</td>
<td id="holder_database_user">
<input type="text" size="30" name="text_database_user" id="text_database_user" onkeypress="return trapEnter(event,'testDBConnection()')" value="<?php
print $fs_config['DB_USER'];
?>
"/>
</td>
</tr>
<tr>
<td><?php
fs_e('Database password');
?>
</td>
<td id="holder_database_pass">
<input type="password" size="30" name="text_database_pass" onkeypress="return trapEnter(event,'testDBConnection()')" id="text_database_pass" value="<?php
// don't send password, too risky
?>
"/>
</td>
</tr>
<tr>
<td><?php
fs_e('Tables prefix');
?>
</td>
<td id="holder_database_prefix">
<input type="text" size="30" name="text_database_prefix" id="text_database_prefix" value="<?php
print $fs_config['DB_PREFIX'];
?>
"/>
</td>
</tr>
</table>
<table>
<tr>
<td><button class="button" onclick="testDBConnection()"><?php
fs_e('Test connection');
?>
</button></td>
<td><div id="advanced_feedback"></div></td>
</tr>
</table>
</div>
<div style="display:none" id="install_tables_id" class="fwrap">
<table>
<tr>
<td><?php
fs_e('Click to install and switch to new FireStats tables');
?>
</td>
</tr>
<tr>
<td><button class="button" onclick="installDBTables()"><?php
fs_e('Install tables');
?>
</button></td>
</tr>
</table>
</div>
<div id="use_database_id" style="display:none" class="fwrap">
<table>
<tr>
<td><?php
fs_e('Click to use this FireStats database');
?>
</td>
</tr>
<tr>
<td>
<button class="button" onclick="attachToDatabase()"><?php
fs_e('Use this database');
?>
</button>
</td>
</tr>
</table>
</div>
<div id="create_db_id" style="display:none" class="fwrap">
<table>
<tr>
<td colspan="2">
<?php
echo fs_r('To create a new database, an administrator user should be used in the above fields.') . '<br/>';
echo fs_r('However, For security reason, it is recommended not to use a database administrator user for day to day operations.') . '<br/>';
echo fs_r('Enter new user name and password for FireStats, this user will only have access to the FireStats database') . '<br/>';
echo fs_r('If you will not specify user and password the Admin user and password will be used.') . '<br/>';
?>
</td>
</tr>
</table>
<table>
<tr>
<td><?php
fs_e('FireStats User name');
?>
</td>
<td><input type="text" size="30" id="text_database_firestats_user" value=""/></td>
</tr>
<tr>
<td><?php
fs_e('FireStats password');
?>
</td>
<td><input type="password" size="30" id="text_database_firestats_pass" value=""/></td>
</tr>
</table>
<table>
<tr>
<td><button class="button" onclick="createNewDatabase()"><?php
fs_e('Create database');
?>
</button></td>
<td><div id="new_db_feedback"></div></td>
</tr>
</table>
</div>
<?php
}
function fs_ajax_attach_to_database(&$response)
{
$host = $_POST['host'];
$user = $_POST['user'];
$pass = $_POST['pass'];
$dbname = $_POST['dbname'];
$table_prefix = $_POST['table_prefix'];
$res = fs_save_config_file($host, $user, $pass, $dbname, $table_prefix);
if ($res != '') {
ajax_error($response, fs_r('Error creating config file: ') . $res);
return false;
} else {
$response['db_status'] = 'ok';
fs_sendDBConfig($response);
if (fs_should_show_use_wp_button()) {
$response['styles']['switch_to_external_system']['display'] = 'block';
}
return true;
}
}
