/**
* @param Account $account
* @return string
*/
function UpdateSettings(&$account)
{
$sql = '
UPDATE %sawm_settings SET
msgs_per_page = %d, white_listing = %d, x_spam = %d,
def_skin = %s, def_lang = %s, def_charset_inc = %d,
def_charset_out = %d, def_timezone = %d, def_date_fmt = %s,
hide_folders = %d, mailbox_limit = %d, allow_change_settings = %d,
allow_dhtml_editor = %d, allow_direct_mode = %d, hide_contacts = %d,
db_charset = %d, horiz_resizer = %d, vert_resizer = %d, mark = %d,
reply = %d, contacts_per_page = %d, view_mode = %d
WHERE id_user = %d';
return sprintf($sql, $this->_prefix, $account->MailsPerPage > 0 ? $account->MailsPerPage : 20, $account->WhiteListing, $account->XSpam, $this->_escapeString($account->DefaultSkin), $this->_escapeString($account->DefaultLanguage), ap_Utils::GetCodePageNumber($account->DefaultIncCharset), ap_Utils::GetCodePageNumber($account->DefaultOutCharset), $account->DefaultTimeZone, $this->_escapeString(CDateTime::GetDbDateFormat($account->DefaultDateFormat, $account->DefaultTimeFormat)), $account->HideFolders, $account->MailboxLimit, $account->AllowChangeSettings, $account->AllowDhtmlEditor, $account->AllowDirectMode, $account->HideContacts, ap_Utils::GetCodePageNumber($account->DbCharset), $account->HorizResizer, $account->VertResizer, $account->Mark, $account->Reply, $account->ContactsPerPage > 0 ? $account->ContactsPerPage : 20, $account->ViewMode, $account->IdUser);
}
