/**
* - JINZORA | Web-based Media Streamer -
*
* Jinzora is a Web-based media streamer, primarily desgined to stream MP3s
* (but can be used for any media file that can stream from HTTP).
* Jinzora can be integrated into a CMS site, run as a standalone application,
* or integrated into any PHP website. It is released under the GNU GPL.
*
* - Resources -
* - Jinzora Author: Ross Carlson <*****@*****.**>
* - Web: http://www.jinzora.org
* - Documentation: http://www.jinzora.org/docs
* - Support: http://www.jinzora.org/forum
* - Downloads: http://www.jinzora.org/downloads
* - License: GNU GPL <http://www.gnu.org/copyleft/gpl.html>
*
* - Contributors -
* Please see http://www.jinzora.org/modules.php?op=modload&name=jz_whois&file=index
*
* - Code Purpose -
* This is the media backend for the database adaptor.
*
* @since 05.10.04
* @author Ben Dodson <*****@*****.**>
*/
function jz_db_connect()
{
global $sql_type, $sql_pw, $sql_socket, $sql_db, $sql_usr;
switch ($sql_type) {
case "DBX_MSSQL":
$sqlt = DBX_MSSQL;
break;
case "DBX_ODBC":
$sqlt = DBX_ODBC;
break;
case "DBX_FBSQL":
$sqlt = DBX_FBSQL;
break;
case "DBX_SYBASECT":
$sqlt = DBX_SYBASECT;
break;
case "DBX_OCI8":
$sqlt = DBX_OCI8;
break;
case "DBX_SQLITE":
$sqlt = DBX_SQLITE;
break;
}
return dbx_connect($sqlt, $sql_socket, $sql_db, $sql_usr, $sql_pw);
}
function da_sql_pconnect($config)
{
if ($config[sql_use_http_credentials] == 'yes') {
global $HTTP_SERVER_VARS;
$SQL_user = $HTTP_SERVER_VARS["PHP_AUTH_USER"];
$SQL_passwd = $HTTP_SERVER_VARS["PHP_AUTH_PW"];
} else {
$SQL_user = $config[sql_username];
$SQL_passwd = $config[sql_password];
}
// FIXME: This function is still Postgres specific. Needs to be configurable.
return @dbx_connect(DBX_PGSQL, "{$server}", "{$config['sql_database']}", "{$SQL_user}", "{$SQL_passwd}", DBX_PERSISTENT);
}
/**
* Get a database connection. This function shouldn't be used by you, as a connection to the database is established automatically.
*
* @param boolean Whether to create a persistant connection
* @param string The database name
* @param string The database host (the server)
* @param string The database connection username
* @param string The database connection password
* @param boolean Whether to on error echo an error and return with a NULL, rather than giving a critical error
* @return ?array A database connection (note for mySQL, it's actually a pair, containing the database name too: because we need to select the name before each query on the connection) (NULL: error)
*/
function db_get_connection($persistent, $db_name, $db_host, $db_user, $db_password, $fail_ok = false)
{
if (!function_exists('dbx_connect')) {
$error = 'dbx not on server (anymore?). Try using the \'mysql\' database driver. To use it, edit the info.php config file.';
if ($fail_ok) {
echo $error;
return NULL;
}
critical_error('PASSON', $error);
}
// Potential cacheing
global $CACHE_DB;
$x = serialize(array($db_name, $db_host));
if (array_key_exists($x, $CACHE_DB)) {
return array($x, $db_name);
}
$db = @dbx_connect('mysql', $db_host, $db_name, $db_user, $db_password, $persistent ? 1 : 0);
if ($db === false || is_null($db)) {
$error = 'Could not connect to database/database-server';
if ($fail_ok) {
echo $error . chr(10);
return NULL;
}
critical_error('PASSON', $error);
//warn_exit(do_lang_tempcode('CONNECT_DB_ERROR')); // purposely not ===false
}
global $LAST_SELECT_DB;
$LAST_SELECT_DB = $db;
global $SITE_INFO;
if (!array_key_exists('database_charset', $SITE_INFO)) {
$SITE_INFO['database_charset'] = strtolower(get_charset()) == 'utf-8' ? 'utf8' : 'latin1';
}
@dbx_query($db, 'SET NAMES "' . addslashes($SITE_INFO['database_charset']) . '"');
@dbx_query($db, 'SET SQL_BIG_SELECTS=1');
if (get_forum_type() == 'ocf') {
@dbx_query($db, 'SET sql_mode=STRICT_ALL_TABLES');
}
return array($db, $db_name);
}
function auth($user, $pass, $args)
{
$r = $db_pw = false;
$dsn = access_query("authanydb", 0);
$col_login = access_query("authanydblogincolumn", 0) or $col_login = "******";
$col_pass = access_query("authanydbpasswordcolumn", 0) or $col_pass = "******";
$desc = parse_url($dsn);
$desc["database"] = strtok($desc["path"], "/");
$table = strtok("/");
$dsn = substr($dsn, 0, strrpos($dsn, "/"));
if (function_exists("newadoconnection") && ($db = NewAdoConnection($desc["scheme"])) && $db->connect($desc["host"], $desc["user"], $desc["pass"], $desc["database"])) {
$user = $db->qstr($user);
$SQL = "SELECT {$col_pass} FROM {$table} WHERE {$col_login}={$user}";
if ($row = $db->GetRow($SQL)) {
$db_pw = $row[0];
}
$db->Close();
} elseif (class_exists("DB")) {
$db = DB::connect($dsn);
$user = $db->quoteString($user);
$SQL = "SELECT {$col_pass} FROM {$table} WHERE {$col_login}='{$user}'";
if ($row = $db->getRow($SQL)) {
$db_pw = $row[0];
}
} elseif (function_exists("dbx_connect") && ($db = dbx_connect($desc["scheme"], $desc["host"], $desc["database"], $desc["user"], $desc["pass"]))) {
$user = dbx_escape_string($db, $user);
$SQL = "SELECT {$col_pass} FROM {$table} WHERE {$col_login}='{$user}'";
if ($result = dbx_query($db, $SQL)) {
$db_pw = $result->data[0][0];
}
dbx_close($db);
} else {
techo("mod_auth_anydb: no database interface used (db auth problem?)", NW_EL_WARNING);
return $r = false;
}
$r = strlen($db_pw) && strlen($pass) && ($db_pw == $pass or $db_pw == crypt($pass, substr($db_pw, 0, 2)) or $db_pw == md5($pass));
return $r;
}
function Cache_Container_dbx($options)
{
if (!is_array($options)) {
return new Cache_Error('No options specified!', __FILE__, __LINE__);
}
$this->setOptions($options, array_merge($this->allowed_options, array('module', 'host', 'db', 'username', 'password', 'cache_table', 'persistent')));
if (!$this->module) {
return new Cache_Error('No module specified!', __FILE__, __LINE__);
}
$this->db = dbx_connect($this->module, $this->host, $this->db, $this->username, $this->password, $this->persistent);
if (dbx_error($this->db)) {
return new Cache_Error('DBx connect failed: ' . dbx_error($this->db), __FILE__, __LINE__);
} else {
//not implemented yet in dbx
//$this->db->setFetchMode(DB_FETCHMODE_ASSOC);
}
}
/**
* DBXStore constructor
*/
function DBXStore($server, $user, $password, $database)
{
// Open a database connection
if (!is_object($this->handle = dbx_connect(DBX_MYSQL, $server, $database, $user, $password))) {
// An error has occurred
die("Could not open connection to MySQL database!\n");
}
}
function anydb_connect($host = "localhost", $user = "", $pw = "", $dbname = "test", $dbtype = "mysql")
{
global $anydb_handle;
class_exists("DB") and $db = DB::connect("{$dbtype}://{$user}:{$pw}@{$host}/{$dbname}") and is_a($db, "db_common") and ($db->setFetchMode(DB_FETCHMODE_ASSOC) or true) or function_exists("newadoconnection") and $db = NewAdoConnection($dbtype) and $db->connect($host, $user, $pw, $dbname) and ($db->setFetchMode(ADODB_FETCH_ASSOC) or true) or $dbtype[0] == "p" and function_exists("pg_connect") and $db = pg_connect("dbname={$dbname} user={$user} password={$pw}") or function_exists("mysql_connect") and $db = mysql_connect($host, $user, $pw) and mysql_query("USE {$dbname}") or function_exists("dbx_connect") and $db = dbx_connect($dbtype, $host, $dbname, $user, $pw) or $db = false;
if ($anydb_handle = $db) {
$charset = EWIKI_DB_UTF8 ? "UTF8" : "ISO-8859-1";
@anydb_query("SET NAMES '{$charset}'");
#-- not all databases support this
}
return $db;
}
