Execute($sql);
if ($dbCon->ErrorNo() != 0)
return false;
$retVal = array();
while (list($key, $value) = $recordset->FetchRow()) {
$tmpValue = '';
if (strpos($key,"Filter") > 0) {
$tmpValue = unserialize($value);
} elseif ($key == 'searchEngineLinks') {
$tmpValue = unserialize($value);
}
if(is_array($tmpValue))
$value = $tmpValue;
$retVal[$key] = $value;
}
return $retVal;
}
/**
* update Setting
*
* @param $dbTable
* @param $key
* @param $value
* @return boolean
*/
function updateSetting($dbTable, $key, $value) {
global $dbCon;
if (is_array($value))
$update_value = serialize($value);
else
$update_value = $value;
$sql = "UPDATE ".$dbTable." SET tf_value = '".$update_value."' WHERE tf_key = '".$key."'";
$dbCon->Execute($sql);
if ($dbCon->ErrorNo() != 0)
return false;
return true;
}
/**
* write the db-conf file.
*
* @param $type
* @param $host
* @param $user
* @param $pass
* @param $name
* @param $pcon
* @return boolean
*/
function writeDatabaseConfig($type, $host, $user, $pass, $name, $pcon) {
global $databaseConfWriteOk, $databaseConfWriteError, $databaseConfContent;
$databaseConfContent = '';
$configFile = false;
$configFile = @fopen(_DIR._FILE_DBCONF, "w");
if (!$configFile) {
$databaseConfWriteOk = false;
$databaseConfWriteError = "Cannot open configuration file "._DIR._FILE_DBCONF." for writing. Please check permissions and try again.";
return false;
}
$result = @fwrite($configFile, $databaseConfContent);
@fclose($configFile);
if ($result === false) {
$databaseConfWriteOk = false;
$databaseConfWriteError = "Cannot write content to config-file "._DIR._FILE_DBCONF.". Please check any file locking issues and try again.";
return false;
}
$databaseConfWriteOk = true;
return true;
}
/**
* get a ado-connection to our database.
*
* @param $type
* @param $host
* @param $user
* @param $pass
* @param $name
* @return database-connection or false on error
*/
function getAdoConnection($type, $host, $user, $pass, $name = "") {
require_once('inc/lib/adodb/adodb.inc.php');
// create ado-object
$db = &ADONewConnection($type);
// connect
$result = @ $db->Connect($host, $user, $pass, $name);
// check for error
if ($db->ErrorNo() != 0 || !$result)
return false;
// return db-connection
return $db;
}
/**
* send button
*/
function sendButton($name = "", $value = "") {
send('
');
}
/**
* send head
*/
function sendHead($title = "") {
send('');
send('');
send(''._TITLE.$title.'');
send('');
send('');
send('');
}
/**
* send foot
*/
function sendFoot() {
send('');
send('');
}
/**
* send - sends a string to the client
*/
function send($string = "") {
echo $string;
echo str_pad('', 4096)."\n";
@ob_flush();
@flush();
}
/**
* displaySetupError - displays a setup message
* @param $msg - message to display
* @param $status - boolean, true for 'Ok:', false for 'Error:'
*/
function displaySetupMessage($msg="A problem occurred.", $status=false){
$thisMsg='';
$thisMsg.= ($status ? "Ok" : "Error").': '.$msg.'
';
send($thisMsg);
}
/**
* initQueries - assign SQL to an array for insertion into db
* @param $type - type of SQL data to get. Valid options are: install + upgrade
* @param $version - version for upgrade-queries
* $queries : array of 'type of queries' => 'db type' where type of queries are:
- data - actual data used by tfb
- test - queries to test db credentials provided by user
- create - creation of tables used by tb
*/
function initQueries($type, $version = "") {
global $queries;
$queries = array();
$queryFile = 'inc/install/';
switch ($type) {
case "install":
$queryFile .= 'queries.install.php';
break;
case "upgrade":
switch ($version) {
case '2.1':
$queryFile .= 'queries.upgrade.tf21.php';
break;
case '2.2':
$queryFile .= 'queries.upgrade.tf22.php';
break;
case '2.3':
$queryFile .= 'queries.upgrade.tf23.php';
break;
default:
$queryFile .= 'queries.upgrade.'.$version.'.php';
break;
}
break;
}
if ((@is_file($queryFile)) === true)
require_once($queryFile);
else
die("Fatal Error. queries-file (".$queryFile.") is missing.");
}
?>