/**
* Checks if DB connection is OK
* @param string $db_mantis_host
* @param string $db_mantis_user
* @param string $db_mantis_pass
* @param string $db_mantis_database
*
* @return NULL if OK, or an error message starting with 'ERROR' .
*/
function checkDBConnection($db_mantis_host = 'localhost', $db_mantis_user = '******', $db_mantis_pass = '', $db_mantis_database = 'bugtracker')
{
SqlWrapper::createInstance($db_mantis_host, $db_mantis_user, $db_mantis_pass, $db_mantis_database);
$query = "SELECT * FROM `mantis_config_table` WHERE config_id = 'database_version' ";
$result = SqlWrapper::getInstance()->sql_query($query);
if (!$result) {
throw new Exception("ERROR: Could not access Mantis database");
}
if (0 == SqlWrapper::getInstance()->sql_num_rows($result)) {
throw new Exception("ERROR: Could not get mantis_config_table.database_version");
}
$row = SqlWrapper::getInstance()->sql_fetch_object($result);
$database_version = $row->value;
return $database_version;
}
