/**
* @param string $query
* @return mixed
*/
function Execute($query)
{
$query = ConvertUtils::mainClear($query);
$this->_log->WriteLine('SQL Query: ' . $query);
$ti = getmicrotime();
$this->_resultId = @mssql_query($query, $this->_conectionHandle);
$this->_log->WriteLine('>> Execute TIME - ' . (getmicrotime() - $ti));
if ($this->_resultId === false) {
$this->_setSqlError();
return false;
} else {
return $this->_resultId;
}
}
/**
* @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 string $query
* @return mixed
*/
function Execute($query)
{
$query = ConvertUtils::mainClear($query);
if ($this->_log->Enabled) {
$this->_log->WriteLine('MySQL Query: ' . $query);
}
if (is_resource($this->_conectionHandle)) {
$this->_resultId = @mysql_query($query, $this->_conectionHandle);
} else {
$this->_log->WriteLine('MySQL Error: not connected', LOG_LEVEL_ERROR);
}
if ($this->_resultId) {
return $this->_resultId;
} else {
$this->_setSqlError();
return false;
}
}
/**
* @param string $query
* @return mixed
*/
function Execute($query)
{
$query = ConvertUtils::mainClear($query);
if ($this->_log->Enabled) {
$this->_log->WriteLine('ODBC Query: ' . $query);
/* $ti = getmicrotime(); */
}
if (is_resource($this->_conectionHandle)) {
$this->_resultId = @odbc_exec($this->_conectionHandle, $query);
/*if ($this->_resultId && $this->_log->Enabled)
{
$this->_log->WriteLine(':: time -> '. (getmicrotime() - $ti));
}*/
} else {
$this->_log->WriteLine('ODBC Error: not connected', LOG_LEVEL_ERROR);
}
if ($this->_resultId) {
return $this->_resultId !== false;
} else {
$this->_setSqlError();
return false;
}
}
/**
* @param string $str
* @return string
*/
function ClearUtf8($str)
{
/* for IE6 *
return ConvertUtils::mainClear(ConvertUtils::ClearUtf8Long($str));
/**/
$str = IS_SUPPORT_ICONV ? @iconv('UTF-8', 'UTF-8//IGNORE', $str) : ConvertUtils::ClearUtf8Long($str);
return ConvertUtils::mainClear($str);
}
/**
* @param string $str
* @return string
*/
function ClearUtf8($str)
{
if (function_exists('iconv') && !ConvertUtils::isAscii($str)) {
$str = @iconv('UTF-8', 'UTF-8//IGNORE', $str);
}
return ConvertUtils::mainClear($str);
}
