$_SESSION['SysPrefs'] = new sys_prefs();
- if (!isset($company))
- $company = user_company();
-
$sql = "SELECT name, value FROM ".TB_PREF."sys_prefs";
$result = @db_query($sql); // supress errors before 2.3 db structure upgrade
return $ret;
}
-function get_company_prefs()
+function set_company_pref($pref, $category, $type, $length, $value)
{
return get_company_pref(null);
}
$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";