/**
If no options specified
*/
function fetch_language_langvar_rs($language, $options = NULL)
{
if ($options == OPENDB_LANG_INCLUDE_DEFAULT) {
$query = "SELECT dflt.value AS default_value, slv.value, dflt.varname\n\t\t\tFROM s_language_var dflt\n\t\t\tLEFT JOIN s_language_var slv\n\t\t\tON slv.language = '{$language}' AND slv.varname = dflt.varname\n\t\t\tWHERE dflt.language = '" . fetch_default_language() . "'";
} else {
$query = "SELECT value, varname\n\t\t\tFROM s_language_var\n\t\t\tWHERE language = '{$language}'";
}
$query .= " ORDER BY varname ";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
return $result;
} else {
return FALSE;
}
}
}
}
if (is_exists_language($_OVRD_OPENDB_LANGUAGE)) {
$_OPENDB_LANGUAGE = $_OVRD_OPENDB_LANGUAGE;
} else {
unset($_OPENDB_LANGUAGE);
if (strlen(get_opendb_session_var('user_id')) > 0 && get_opendb_config_var('user_admin', 'user_language_support') !== FALSE) {
$user_language = fetch_user_language(get_opendb_session_var('user_id'));
if (is_exists_language($user_language)) {
$_OPENDB_LANGUAGE = $user_language;
}
}
if (strlen($_OPENDB_LANGUAGE) == 0) {
if (is_exists_language(get_opendb_config_var('site', 'language'))) {
$_OPENDB_LANGUAGE = strtoupper(get_opendb_config_var('site', 'language'));
} else {
$_OPENDB_LANGUAGE = fetch_default_language();
}
}
}
}
}
if ($HTTP_VARS['mode'] == 'job') {
$_OPENDB_THEME = '';
}
if (strlen($_OPENDB_THEME) > 0) {
include_once "./theme/{$_OPENDB_THEME}/theme.php";
}
} else {
die('MySQL extension is not available');
}
function get_opendb_table_lang_var($table, $column, $key1, $key2 = NULL, $key3 = NULL)
{
global $_OPENDB_LANGUAGE;
// todo cache values returned for performance if required.
$langval = fetch_opendb_table_lang_var($_OPENDB_LANGUAGE, $table, $column, $key1, $key2, $key3);
if (strlen($langval) > 0) {
return $langval;
} else {
if (!is_default_language($_OPENDB_LANGUAGE)) {
return fetch_opendb_table_lang_var(fetch_default_language(), $table, $column, $key1, $key2, $key3);
} else {
return FALSE;
}
}
}
