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