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