/**
* Returns the SQL code used for concatenating strings
*
* @access public
* @param string Input string/column to concatenate
* @return string SQL parameter
*/
function serendipity_db_concat($string)
{
global $serendipity;
$type_of_database = sqlrcon_identify($serendipity['dbConn']);
switch ($type_of_database) {
case 'mysql':
return 'concat(' . $string . ')';
case 'postgresql':
return '(' . str_replace(', ', '||', $string) . ')';
case 'sqlite':
return 'concat(' . $string . ')';
default:
return 'concat(' . $string . ')';
}
}
/**
* Non-persistent database connection
*
* @access protected
* @return resource
* @see parent::initialize();
*/
function db_connect()
{
if (!function_exists('sqlrcon_alloc')) {
log_message('error', 'Driver Db_sqlrelay ' . "\t" . 'Method db_connect ' . PHP_EOL . "\t\t" . 'Module SQL Relay non chargé dans la configuration serveur"' . PHP_EOL . " Connexion data " . PHP_EOL . " username : "******" hostname : " . $this->hostname . PHP_EOL . " database : " . $this->database . PHP_EOL . " dbdriver : " . $this->dbdriver . PHP_EOL . " dbprefix : " . $this->dbprefix . PHP_EOL . " port : " . $this->port);
return false;
}
$sConnect = sqlrcon_alloc($this->hostname, $this->port, '', $this->username, $this->password, 1, 3);
if (sqlrcon_ping($sConnect) !== 1) {
log_message('error', 'Driver Db_sqlrelay ' . "\t" . 'Method db_connect ' . PHP_EOL . "\t\t" . 'Pas de ping serveur"' . PHP_EOL . " Connexion data " . PHP_EOL . " username : "******" hostname : " . $this->hostname . PHP_EOL . " database : " . $this->database . PHP_EOL . " dbdriver : " . $this->dbdriver . PHP_EOL . " dbprefix : " . $this->dbprefix . PHP_EOL . " port : " . $this->port);
return false;
}
if (sqlrcon_identify($sConnect) == 'oracle8') {
$this->setIsOracle(true);
$this->setPrefetchState(true);
} else {
$this->setIsOracle(false);
}
// $curs_id = sqlrcur_alloc($sConnect);
// sqlrcur_prepareQuery($curs_id, "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' ");
// sqlrcur_sendquery($curs_id, "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' ");
// sqlrcur_free($curs_id);
return $sConnect;
}
