function translate_loadnamespace($namespace, $language = false)
{
if ($language === false) {
$language = LANGUAGE;
}
$page = translator_page($namespace);
$uri = translator_uri($namespace);
if ($page == $uri) {
$where = "uri = '{$page}'";
} else {
$where = "(uri='{$page}' OR uri='{$uri}')";
}
$sql = "\n\t\tSELECT intext,outtext\n\t\tFROM " . db_prefix("translations") . "\n\t\tWHERE language='{$language}'\n\t\t\tAND {$where}";
/* debug(nl2br(htmlentities($sql, ENT_COMPAT, getsetting("charset", "ISO-8859-1")))); */
if (!getsetting("cachetranslations", 0)) {
$result = db_query($sql);
} else {
$result = db_query_cached($sql, "translations-" . $namespace . "-" . $language, 600);
//store it for 10 Minutes, normally you don't need to refresh this often
}
$out = array();
while ($row = db_fetch_assoc($result)) {
$out[$row['intext']] = $row['outtext'];
}
return $out;
}
function translate_loadnamespace($namespace, $language = false)
{
if ($language === false) {
$language = LANGUAGE;
}
$page = translator_page($namespace);
$uri = translator_uri($namespace);
//new routine
$out = datacache("translations/translations-" . $namespace . "-" . $language, 1200);
if (!is_array($out)) {
if ($page == $uri) {
$where = "uri = '{$page}'";
} else {
$where = "(uri='{$page}' OR uri='{$uri}')";
}
$sql = "\r\n\t\t\tSELECT intext,outtext\r\n\t\t\tFROM " . db_prefix("translations") . "\r\n\t\t\tWHERE language='{$language}'\r\n\t\t\t\tAND {$where}";
/* debug(nl2br(htmlentities($sql, ENT_COMPAT, getsetting("charset", "ISO-8859-1")))); */
$result = db_query($sql);
$out = array();
while ($row = db_fetch_assoc($result)) {
$out[$row['intext']] = $row['outtext'];
}
updatedatacache("translations/translations-" . $namespace . "-" . $language, $out);
}
return $out;
}
