/** * @param Account $account * @return string */ function UpdateAccount(&$account) { $sql = ' UPDATE %sawm_accounts SET id_user = %d, def_acct = %d, deleted = %d, email = %s, mail_protocol = %d, mail_inc_host = %s, mail_inc_login = %s, mail_inc_pass = %s, mail_inc_port = %d, mail_out_host = %s, mail_out_login = %s, mail_out_pass = %s, mail_out_port = %d, mail_out_auth = %d, friendly_nm = %s, use_friendly_nm = %d, def_order = %d, getmail_at_login = %d, mail_mode = %d, mails_on_server_days = %d, signature = %s, signature_type = %d, signature_opt = %d, delimiter = %s, personal_namespace = %s WHERE id_acct = %d'; return sprintf($sql, $this->_prefix, $account->IdUser, $account->DefaultAccount, $account->Deleted, $this->_escapeString($account->Email), $account->MailProtocol, $this->_escapeString($account->MailIncHost), $this->_escapeString($account->MailIncLogin), $this->_escapeString(ap_Utils::EncodePassword($account->MailIncPassword)), $account->MailIncPort, $this->_escapeString($account->MailOutHost), $this->_escapeString($account->MailOutLogin), $this->_escapeString(ap_Utils::EncodePassword($account->MailOutPassword)), $account->MailOutPort, $account->MailOutAuthentication, $this->_escapeString($account->FriendlyName), $account->UseFriendlyName, $account->DefaultOrder, $account->GetMailAtLogin, $account->MailMode, $account->MailsOnServerDays, $this->_escapeString($account->Signature), $account->SignatureType, $account->SignatureOptions, $this->_escapeString($account->Delimiter), $this->_escapeString($account->NameSpace), $account->Id); }