{
global $SysPrefs, $db_version;
- if (!isset($_SESSION['SysPrefs']->prefs)) { // cached preferences
+ static $cached; // retrieve values from db once a request. Some values can't be cached between requests
+ // to ensure prefs integrity for all usrs (e.g. gl_close_date).
+
+ if (!$cached || !isset($_SESSION['SysPrefs'])) { // cached preferences
$_SESSION['SysPrefs'] = new sys_prefs();
// update current db status for info in log file
$SysPrefs->db_ok = $SysPrefs->prefs['version_id'] == $db_version;
+ $cached = true;
}
$all = $_SESSION['SysPrefs']->prefs;
$tbl = $key;
$key = $stdkey;
}
- $sqls[] = "(SELECT COUNT(*) as cnt FROM ".TB_PREF."$tbl WHERE $key=$id)\n";
+ $sqls[] = "(SELECT COUNT(*) as cnt FROM `".TB_PREF."$tbl` WHERE `$key`=".db_escape($id).")\n";
}
$sql = "SELECT sum(cnt) FROM (". implode(' UNION ', $sqls).") as counts";