/**
* @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());
}
