/** * @param WebMailMessage $message * @param Folder $folder * @return bool */ function SaveMessage(&$message, &$folder, $fromFolder = null) { if ($message == null || $folder == null) { return false; } //Get size all messages in DB $mailBoxesSize = $this->DbStorage->SelectMailboxesSize() + $message->GetMailSize(); $this->DbStorage->SelectMailboxesSize(); if ($this->MailStorage->_settings->EnableMailboxSizeLimit && $this->_account->MailboxLimit < $mailBoxesSize) { setGlobalError(ErrorGetMailLimit); return false; } switch ($this->_account->MailProtocol) { case MAILPROTOCOL_POP3: $result = true; if ($this->DbStorage->Connect()) { //if ($message->IdMsg != -1) //{ //$messageIdSet = array($message->IdMsg); //$result &= $this->DbStorage->DeleteMessages($messageIdSet, false, $folder); //} //else //{ $message->IdMsg = $this->DbStorage->SelectLastIdMsg() + 1; //} return $result && $this->DbStorage->SaveMessage($message, $folder); } case MAILPROTOCOL_IMAP4: $result = true; if ($message->IdMsg != -1) { $messageIdUidSet = array(); $messageIdUidSet[$message->IdMsg] = $message->Uid; $nfolder = $fromFolder ? $fromFolder : $folder; $result &= $this->DeleteMessages($messageIdUidSet, $nfolder); } if ($folder->SyncType != FOLDERSYNC_DontSync) { if ($this->MailStorage->Connect()) { $result &= $this->MailStorage->SaveMessage($message, $folder); $GLOBALS[MailDefaultCharset] = $this->_account->GetDefaultIncCharset(); unset($GLOBALS[MailInputCharset]); $GLOBALS[MailOutputCharset] = $this->_account->GetUserCharset(); $result &= $this->MailStorage->SynchronizeFolder($folder); } return $result; } elseif ($this->DbStorage->Connect()) { //if ($message->IdMsg == -1) //{ $message->IdMsg = $this->DbStorage->SelectLastIdMsg() + 1; //} $result &= $this->DbStorage->SaveMessage($message, $folder); return $result; } case MAILPROTOCOL_WMSERVER: $result = true; if ($this->DbStorage->Connect()) { $message->IdMsg = $this->DbStorage->SelectLastIdMsg() + 1; return $result && $this->DbStorage->SaveMessage($message, $folder); } } return false; }
/** * @param WebMailMessage $message * @param Folder $folder * @param bool $downloaded * @param Account $account * @return string */ function SaveMessageHeader(&$message, &$folder, $downloaded, &$account) { //save message header $sql = 'INSERT INTO %sawm_messages (id_msg, id_acct, id_folder_srv, id_folder_db, %s, from_msg, to_msg, cc_msg, bcc_msg, subject, msg_date, attachments, size, downloaded, x_spam, seen, flagged, deleted, replied, grayed, flags, priority, body_text) VALUES (%d, %d, %d, %d, %s, %s, %s, %s, %s, %s, %s, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %s)'; $date =& $message->GetDate(); $from =& new I18nString($message->GetFromAsString(), $account->DbCharset); $to =& new I18nString($message->GetToAsString(), $account->DbCharset); $cc =& new I18nString($message->GetCcAsString(), $account->DbCharset); $bcc =& new I18nString($message->GetBccAsString(), $account->DbCharset); $subject =& new I18nString($message->GetSubject(), $account->DbCharset); $uid = $account->MailProtocol == MAILPROTOCOL_IMAP4 ? (int) $message->Uid : $this->_escapeString($message->Uid); return sprintf($sql, $this->_settings->DbPrefix, $this->_getMsgIdUidFieldName(true, $account->MailProtocol), $message->IdMsg, $account->Id, $folder->IdDb, $folder->IdDb, $uid, $this->_escapeString($from->Truncate(255)), $this->_escapeString($to->Truncate(255)), $this->_escapeString($cc->Truncate(255)), $this->_escapeString($bcc->Truncate(255)), $this->_escapeString($subject->Truncate(255)), $this->_escapeString($date->ToANSI()), $this->Bool2Bool((int) $message->HasAttachments()), (int) $message->GetMailSize(), $this->Bool2Bool((int) $downloaded), $this->Bool2Bool((int) $message->GetXSpamStatus()), (int) (($message->Flags & MESSAGEFLAGS_Seen) == MESSAGEFLAGS_Seen), (int) (($message->Flags & MESSAGEFLAGS_Flagged) == MESSAGEFLAGS_Flagged), (int) (($message->Flags & MESSAGEFLAGS_Deleted) == MESSAGEFLAGS_Deleted), (int) (($message->Flags & MESSAGEFLAGS_Answered) == MESSAGEFLAGS_Answered), (int) (($message->Flags & MESSAGEFLAGS_Grayed) == MESSAGEFLAGS_Grayed), $message->Flags, $message->GetPriorityStatus(), $this->_escapeString(ConvertUtils::mainClear(substr($message->GetPlainLowerCaseBodyText(), 0, 500000)))); }
/** * @param WebMailMessage $message * @param Folder $folder * @param bool $downloaded * @param Account $account * @return string */ function SaveMessageHeader($message, $folder, $downloaded, $account) { /* save message header */ $sql = 'INSERT INTO %sawm_messages (id_msg, id_acct, id_folder_srv, id_folder_db, str_uid, int_uid, from_msg, to_msg, cc_msg, bcc_msg, subject, msg_date, attachments, size, downloaded, x_spam, seen, flagged, rtl, deleted, replied, grayed, flags, priority, body_text, forwarded, charset, sensitivity) VALUES (%d, %d, %d, %d, %s, %d, %s, %s, %s, %s, %s, %s, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %s, 0, -1, %d)'; $date =& $message->GetDate(); $from = new I18nString($message->GetFromAsString(), $account->DbCharset); $to = new I18nString($message->GetToAsString(), $account->DbCharset); $cc = new I18nString($message->GetCcAsString(), $account->DbCharset); $bcc = new I18nString($message->GetBccAsString(), $account->DbCharset); $subject = new I18nString($message->GetSubject(), $account->DbCharset); $str_uid = $int_uid = null; if ($account->MailProtocol == MAILPROTOCOL_IMAP4) { $str_uid = ''; $int_uid = $message->Uid; } else { $str_uid = $message->Uid; $int_uid = 0; } return sprintf($sql, $this->_settings->DbPrefix, $message->IdMsg, $account->Id, $folder->IdDb, $folder->IdDb, $this->_escapeString($str_uid), $int_uid, $this->_escapeString($from->Truncate(255)), $this->_escapeString($to->Truncate(255)), $this->_escapeString($cc->Truncate(255)), $this->_escapeString($bcc->Truncate(255)), $this->_escapeString($subject->Truncate(255)), $this->UpdateDateFormat($date->ToANSI()), (int) $message->HasAttachments(), $message->GetMailSize(), (int) $downloaded, (int) $message->GetXSpamStatus(), ($message->Flags & MESSAGEFLAGS_Seen) == MESSAGEFLAGS_Seen, ($message->Flags & MESSAGEFLAGS_Flagged) == MESSAGEFLAGS_Flagged, 0, ($message->Flags & MESSAGEFLAGS_Deleted) == MESSAGEFLAGS_Deleted, ($message->Flags & MESSAGEFLAGS_Answered) == MESSAGEFLAGS_Answered, ($message->Flags & MESSAGEFLAGS_Grayed) == MESSAGEFLAGS_Grayed, $message->Flags, $message->GetPriorityStatus(), $this->_escapeString(substr($message->GetPlainLowerCaseBodyText(), 0, 500000)), $message->GetSensitivity()); }