/** 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; } } }