- $sql = "UPDATE ".TB_PREF."company SET
- debtors_act=$debtors_act, pyt_discount_act=$pyt_discount_act,
- creditors_act=$creditors_act, grn_act=$grn_act,
- exchange_diff_act=$exchange_diff_act,
- purch_exchange_diff_act=$purch_exchange_diff_act,
- retained_earnings_act=$retained_earnings_act,
- freight_act=$freight_act,
- default_sales_act=$default_sales_act,
- default_sales_discount_act=$default_sales_discount_act,
- default_prompt_payment_act=$default_prompt_payment_act,
- default_inventory_act=$default_inventory_act,
- default_cogs_act=$default_cogs_act,
- default_adj_act=$default_adj_act,
- default_inv_sales_act=$default_inv_sales_act,
- default_assembly_act=$default_assembly_act,
- payroll_act=$payroll_act,
- allow_negative_stock=$allow_negative_stock,
- po_over_receive=$po_over_receive,
- po_over_charge=$po_over_charge,
- past_due_days=$past_due_days,
- default_credit_limit=$default_credit_limit,
- default_workorder_required=$default_workorder_required,
- default_dim_required=$default_dim_required
- WHERE coy_code=1";
-
- db_query($sql, "The company gl setup could not be updated ");
+ $sql = "UPDATE ".TB_PREF."sys_prefs SET value = ";
+ foreach($params as $name => $value) {
+ if (!db_query($sql. db_escape($value). " WHERE name=".db_escape($name),
+ "The company prefferences could not be updated "))
+ return false;
+ // update cached value
+ $_SESSION['SysPrefs']->prefs[$name] = $value;
+ }
+ return true;