/**
* @return string The current value of the internal SQL vairable
*/
function getQuery()
{
return $this->_db->getQuery();
}
$DBserver = $DBPort ? "{$DBhostname}:{$DBPort}" : "{$DBhostname}";
$database = new database($DBserver, $DBuserName, $DBpassword, $DBname, $DBPrefix);
// delete existing mos table if requested
if ($DBDel) {
$database->setQuery("SHOW TABLES FROM `{$DBname}`");
$errors = array();
if ($tables = $database->loadResultArray()) {
foreach ($tables as $table) {
if ($DBPrefix) {
if (strpos($table, $DBPrefix) === 0) {
if ($DBBackup) {
$butable = str_replace($DBPrefix, $BUPrefix, $table);
$database->setQuery("DROP TABLE IF EXISTS `{$butable}`");
$database->query();
if ($database->getErrorNum()) {
$errors[$database->getQuery()] = $database->getErrorMsg();
}
$database->setQuery("RENAME TABLE `{$table}` TO `{$butable}`");
$database->query();
if ($database->getErrorNum()) {
$errors[$database->getQuery()] = $database->getErrorMsg();
}
}
}
} else {
if ($DBBackup) {
$butable = $BUPrefix . $table;
$database->setQuery("DROP TABLE IF EXISTS `{$butable}`");
$database->query();
if ($database->getErrorNum()) {
$errors[$database->getQuery()] = $database->getErrorMsg();
foreach ($tables as $table) {
$database->setQuery("DROP TABLE IF EXISTS `{$table}`");
$database->query();
if ($database->getErrorNum()) {
$errors[$database->getQuery()] = $database->getErrorMsg();
}
}
}
$databasehist->setQuery("SHOW TABLES FROM `{$DBname}`");
$errors = array();
if ($tables = $databasehist->loadResultArray()) {
foreach ($tables as $table) {
$databasehist->setQuery("DROP TABLE IF EXISTS `{$table}`");
$databasehist->query();
if ($databasehist->getErrorNum()) {
$errors[$databasehist->getQuery()] = $databasehist->getErrorMsg();
}
}
}
}
populate_db($DBname, $DBPrefix, 'knomos.sql');
populate_db($DBHistname, $DBPrefix, 'knomos_hist.sql');
if ($DBSample) {
populate_db($DBname, $DBPrefix, 'sample_data.sql');
}
$DBcreated = 1;
}
function db_err($step, $alert)
{
global $DBhostname, $DBuserName, $DBpassword, $DBDel, $DBname;
echo "<form name=\"{$step}\" method=\"post\" action=\"install1.php\">\r\n\t<input type=\"hidden\" name=\"DBhostname\" value=\"{$DBhostname}\">\r\n\t<input type=\"hidden\" name=\"DBuserName\" value=\"{$DBuserName}\">\r\n\t<input type=\"hidden\" name=\"DBpassword\" value=\"{$DBpassword}\">\r\n\t<input type=\"hidden\" name=\"DBDel\" value=\"{$DBDel}\">\r\n\t<input type=\"hidden\" name=\"DBname\" value=\"{$DBname}\">\r\n\t<input type=\"hidden\" name=\"DBHistname\" value=\"{$DBHistname}\">\r\n\t<input type=\"submit\" name=\"back\" value=\"Back to Previous step\" style=\"display:none; \">\r\n\t</form>\n";
