{
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;
function set_company_pref($pref, $category, $type, $length, $value)
{
- $sql = "REPLACE `0_sys_prefs` SET `name`=".db_escape($pref).", `category`=".db_escape($category)
- .", `type`=".db_escape($type).", `length`=".db_escape($length).", `value`=".db_escape($value);
+ $sql = "REPLACE ".TB_PREF."sys_prefs SET name=".db_escape($pref).", category=".db_escape($category)
+ .", type=".db_escape($type).", length=".db_escape($length).", value=".db_escape($value);
return db_query($sql, "cannot set company pref");
}
value is name of foreign key field. For numeric keys $stdkey field name is used.
$stdkey - standard name of foreign key.
*/
-function key_in_foreign_table($id, $tables, $stdkey, $escaped=false)
+function key_in_foreign_table($id, $tables, $stdkey)
{
- if (!$escaped)
- $id = db_escape($id);
if (!is_array($tables))
$tables = array($tables);
$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";