/**
  * @param Folder $folders
  * @param DbStorage $dbStorage
  * @param int $lastIdMsg
  * @return bool
  */
 function _synchronizeFolderWithOpenDbConnection(&$folder, &$dbStorage, $lastIdMsg)
 {
     $result = true;
     if ($folder->SyncType == FOLDERSYNC_DontSync || $folder->SyncType == FOLDERSYNC_DirectMode || $folder->Hide) {
         return true;
     }
     if (!$this->_imapMail->examine_mailbox($folder->FullName)) {
         return false;
     }
     //Get uid, flags and size from imap Server
     $paramsMessages = $this->_imapMail->getParamsMessages();
     $imapFlags = array();
     $imapUids = array();
     $imapSizes = array();
     $dbUids = array();
     $imapUidFlags = array();
     if (!is_array($paramsMessages)) {
         return false;
     }
     foreach ($paramsMessages as $key => $value) {
         $imapFlags[$key] = $value["flag"];
         $imapUids[$key] = $value["uid"];
         $imapSizes[$key] = $value["size"];
         $imapUidFlags[$value["uid"]] = $value["flag"];
         $imapUidSizes[$value["uid"]] = $value["size"];
     }
     $dbUidsIdMsgsFlags =& $dbStorage->SelectIdMsgAndUidByIdMsgDesc($folder);
     foreach ($dbUidsIdMsgsFlags as $value) {
         $dbUidsFlag[$value[1]] = $value[2];
         $dbUids[] = $value[1];
     }
     //Array need added to DB
     $newUids = array_diff($imapUids, $dbUids);
     //Array delete from DB
     $uidsToDelete = array_diff($dbUids, $imapUids);
     //Intersect uids
     $currentUids = array_intersect($imapUids, $dbUids);
     if ($folder->SyncType == FOLDERSYNC_AllHeadersOnly || $folder->SyncType == FOLDERSYNC_AllEntireMessages) {
         //Update messages whith different flags
         foreach ($currentUids as $currentUid) {
             $flagBD = $dbUidsFlag[$currentUid];
             $flagImap = $this->getIntFlags($imapUidFlags[$currentUid]);
             if ($flagBD != $flagImap) {
                 $dbStorage->UpdateMessageFlags(array($currentUid), true, $folder, $flagImap, $this->Account);
             }
         }
     }
     if ($this->DownloadedMessagesHandler != null) {
         if (ConvertUtils::IsLatin($folder->Name)) {
             $foldername = ConvertUtils::ConvertEncoding($folder->Name, CPAGE_UTF7_Imap, $this->Account->GetUserCharset());
         } else {
             $foldername = ConvertUtils::ConvertEncoding($folder->Name, $this->Account->DefaultIncCharset, $this->Account->GetUserCharset());
         }
         ShowDownloadedMessageNumber($foldername, count($newUids));
         ShowDownloadedMessageNumber();
     }
     //Delete from DB
     if (count($uidsToDelete) > 0 && ($folder->SyncType == FOLDERSYNC_AllHeadersOnly || $folder->SyncType == FOLDERSYNC_AllEntireMessages)) {
         //$result &= $dbStorage->DeleteMessages($uidsToDelete, true, $folder);
         $result &= $dbStorage->SetMessagesFlags($uidsToDelete, true, $folder, MESSAGEFLAGS_Deleted, ACTION_Set);
     }
     $result &= $dbStorage->UpdateMailboxSize();
     $maxEnvelopesPerSession = 1;
     //Get size all messages in DB
     $mailBoxesSize = $dbStorage->SelectMailboxesSize();
     $syncCycles = ceil(count($newUids) / $maxEnvelopesPerSession);
     for ($i = 0; $i < $syncCycles; $i++) {
         $mailBoxesSize += $imapSizes[$i + 1];
         if ($this->_settings->EnableMailboxSizeLimit && $this->Account->MailboxLimit < $mailBoxesSize) {
             $result = false;
             setGlobalError(ErrorGetMailLimit);
             break;
         }
         $listPartToDownload = $i != $syncCycles - 1 ? array_slice($newUids, $i * $maxEnvelopesPerSession, $maxEnvelopesPerSession) : array_slice($newUids, $i * $maxEnvelopesPerSession);
         //Synchronize
         if ($folder->SyncType == FOLDERSYNC_NewEntireMessages || $folder->SyncType == FOLDERSYNC_AllEntireMessages) {
             $mailMessageCollection =& $this->LoadMessages($listPartToDownload, true, $folder, $imapUids, $imapUidFlags, $imapUidSizes);
         } elseif ($folder->SyncType == FOLDERSYNC_NewHeadersOnly || $folder->SyncType == FOLDERSYNC_AllHeadersOnly) {
             $mailMessageCollection =& $this->_loadMessageHeaders($listPartToDownload, $imapUids, $imapUidFlags, $imapUidSizes);
         }
         //Write to DB
         if ($mailMessageCollection != null && $mailMessageCollection->Count() > 0) {
             if (!$this->ApplyFilters($mailMessageCollection, $dbStorage, $folder)) {
                 $result = false;
                 break;
             }
         }
     }
     $result &= $dbStorage->UpdateMailboxSize();
     return $result;
 }
 /**
  * @param Folder $folders
  * @param DbStorage $dbStorage
  * @param int $lastIdMsg
  * @return bool
  */
 function _synchronizeFolderWithOpenDbConnection(&$folder, &$dbStorage)
 {
     $log =& CLog::CreateInstance();
     $result = true;
     if ($folder->SyncType == FOLDERSYNC_DontSync || $folder->SyncType == FOLDERSYNC_DirectMode || $folder->Hide) {
         if ($this->UpdateFolderHandler != null && $folder->SyncType == FOLDERSYNC_DirectMode) {
             call_user_func_array($this->UpdateFolderHandler, array($folder->IdDb, $folder->FullName));
         }
         return true;
     }
     $foldername = '';
     if ($this->DownloadedMessagesHandler != null) {
         $foldername = $folder->GetFolderName($this->Account);
         call_user_func_array($this->DownloadedMessagesHandler, array($foldername, 0));
     }
     if (!$this->_imapMail->open_mailbox($folder->FullName, false, true)) {
         return true;
     }
     $_isAllUpdate = $folder->SyncType == FOLDERSYNC_AllHeadersOnly || $folder->SyncType == FOLDERSYNC_AllEntireMessages;
     $_isUidsOnly = $folder->SyncType == FOLDERSYNC_NewHeadersOnly;
     /* get uid, flags and size from IMAP4 Server */
     if ($log->Enabled) {
         $start = getmicrotime();
     }
     $paramsMessages = $this->_imapMail->getParamsMessages();
     if ($log->Enabled) {
         $log->WriteLine('IMAP4: getParamsMessages()=' . (getmicrotime() - $start));
     }
     if (!is_array($paramsMessages)) {
         return false;
     }
     $imapUids = $imapSizes = $imapUidFlags = $imapUidSizes = array();
     $this->_imapArrayForeach($paramsMessages, $imapUids, $imapSizes, $imapUidFlags, $imapUidSizes);
     unset($paramsMessages);
     $dbUidsIdMsgsFlags =& $dbStorage->SelectIdMsgAndUidByIdMsgDesc($folder);
     $dbUids = $dbUidsFlag = array();
     foreach ($dbUidsIdMsgsFlags as $value) {
         $dbUids[] = $value[1];
         $dbUidsFlag[$value[1]] = $value[2];
     }
     unset($dbUidsIdMsgsFlags);
     /* array need added to DB */
     //$newUids = array_diff($imapUids, $dbUids);
     $newUids = array();
     foreach ($imapUids as $_imUid) {
         if (!isset($dbUidsFlag[$_imUid])) {
             $newUids[] = $_imUid;
         }
     }
     if ($this->DownloadedMessagesHandler != null && count($newUids) > 0) {
         call_user_func_array($this->DownloadedMessagesHandler, array($foldername, count($newUids)));
     }
     if ($_isAllUpdate) {
         /* update flags */
         $_flags4Update = array();
         /* intersect uids */
         foreach ($imapUids as $_imUid) {
             if (isset($dbUidsFlag[$_imUid])) {
                 $flagBD = (int) $dbUidsFlag[$_imUid];
                 $flagImap = (int) $this->getIntFlags($imapUidFlags[$_imUid]);
                 /* update messages whith different flags */
                 if ($flagBD != $flagImap) {
                     $_flags4Update[$flagImap][] = $_imUid;
                 }
             }
         }
         if (count($_flags4Update) > 0) {
             foreach ($_flags4Update as $_flag => $_uidArray) {
                 if (is_array($_uidArray)) {
                     $dbStorage->UpdateMessageFlags($_uidArray, true, $folder, $_flag, $this->Account);
                 }
             }
             if ($this->UpdateFolderHandler != null) {
                 call_user_func_array($this->UpdateFolderHandler, array($folder->IdDb, $folder->FullName));
             }
         }
         /* delete from DB */
         //$uidsToDelete = array_diff($dbUids, $imapUids);
         $uidsToDelete = array();
         foreach ($dbUids as $_dbUid) {
             if (!isset($imapUidFlags[$_dbUid])) {
                 //$dbUidsFlag[$_dbUid] = $value[2];
                 $uidsToDelete[] = $_dbUid;
             }
         }
         if (count($uidsToDelete) > 0) {
             if ($this->UpdateFolderHandler != null) {
                 call_user_func_array($this->UpdateFolderHandler, array($folder->IdDb, $folder->FullName));
             }
             // $result &= $dbStorage->SetMessagesFlags($uidsToDelete, true, $folder, MESSAGEFLAGS_Deleted, ACTION_Set);
             $result &= $dbStorage->DeleteMessages($uidsToDelete, true, $folder);
             $result &= $dbStorage->UpdateMailboxSize();
         }
     }
     $maxEnvelopesPerSession = 1;
     /* get size all messages in DB */
     $mailBoxesSize = $dbStorage->SelectMailboxesSize();
     $filters =& $dbStorage->SelectFilters($this->Account->Id, true);
     if ($folder->SyncType == FOLDERSYNC_NewHeadersOnly || $folder->SyncType == FOLDERSYNC_AllHeadersOnly) {
         $syncCycles = ceil(count($newUids) / MAX_ENVELOPES_PER_SESSION);
         for ($q = 0; $q < $syncCycles; $q++) {
             if (!$this->_imapMail->open_mailbox($folder->FullName)) {
                 return true;
             }
             $cyclesNewUids = array_slice($newUids, $q * MAX_ENVELOPES_PER_SESSION, MAX_ENVELOPES_PER_SESSION);
             $mailMessageCollection = null;
             $mailMessageCollection =& $this->LoadMessageHeadersInOneRequest($folder, $cyclesNewUids, true);
             if ($mailMessageCollection) {
                 for ($i = 0, $c = $mailMessageCollection->Count(); $i < $c; $i++) {
                     if ($this->DownloadedMessagesHandler != null && function_exists($this->DownloadedMessagesHandler)) {
                         call_user_func($this->DownloadedMessagesHandler);
                     }
                     $message =& $mailMessageCollection->Get($i);
                     $mailBoxesSize += $message->Size;
                     if ($this->_settings->EnableMailboxSizeLimit && $this->Account->MailboxLimit > 0 && $this->Account->MailboxLimit < $mailBoxesSize) {
                         $result = false;
                         setGlobalError(ErrorGetMailLimit);
                         break 2;
                     }
                     if (!$this->ApplyFilters($message, $dbStorage, $folder, $filters)) {
                         $result = false;
                     }
                 }
             }
         }
     } else {
         $syncCycles = ceil(count($newUids) / $maxEnvelopesPerSession);
         for ($i = 0; $i < $syncCycles; $i++) {
             $mailBoxesSize += $imapSizes[$i + 1];
             if ($this->_settings->EnableMailboxSizeLimit && $this->Account->MailboxLimit > 0 && $this->Account->MailboxLimit < $mailBoxesSize) {
                 $result = false;
                 setGlobalError(ErrorGetMailLimit);
                 break;
             }
             if (!$this->_imapMail->open_mailbox($folder->FullName)) {
                 return true;
             }
             $listPartToDownload = $i != $syncCycles - 1 ? array_slice($newUids, $i * $maxEnvelopesPerSession, $maxEnvelopesPerSession) : array_slice($newUids, $i * $maxEnvelopesPerSession);
             if ($this->DownloadedMessagesHandler != null && function_exists($this->DownloadedMessagesHandler)) {
                 call_user_func($this->DownloadedMessagesHandler);
             }
             $mailMessageCollection = null;
             $mailMessageCollection =& $this->LoadMessages($listPartToDownload, true, $folder, $imapUids, $imapUidFlags, $imapUidSizes);
             if ($mailMessageCollection && $mailMessageCollection->Count() > 0) {
                 $message =& $mailMessageCollection->Get(0);
                 if (!$this->ApplyFilters($message, $dbStorage, $folder, $filters)) {
                     $result = false;
                     break;
                 }
             }
         }
     }
     $result &= $dbStorage->UpdateMailboxSize();
     return $result;
 }