public function testMailboxConnection($server, $port, $service, $ssl, $mailbox, $user, $pass)
{
$ajax = new Ejax();
// sanity check
$filter = JFilterInput::getInstance();
$server = $filter->clean($server, 'string');
$port = $filter->clean($port, 'integer');
$service = $filter->clean($service, 'string');
$ssl = $filter->clean($ssl, 'integer');
$mailbox = $filter->clean($mailbox, 'string');
$server = $filter->clean($server, 'string');
$user = $filter->clean($user, 'username');
$pass = $filter->clean($pass, 'string');
// variable check
if ($server == '' || $port == '' || $mailbox == '' || $user == '' || $pass == '') {
$result = JText::_('COM_EASYBLOG_EMAIL_CREDENTIALS_INCOMPLETE');
} else {
require_once JPATH_ROOT . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'classes' . DIRECTORY_SEPARATOR . 'mailbox.php';
$result = EasyblogMailbox::testConnect($server, $port, $service, $ssl, $mailbox, $user, $pass);
}
$ajax->script("\$('#remote_test_result').html('{$result}');");
return $ajax->send();
}
public function processCommentMailbox()
{
/*
* Check enabled
*/
$config = EasyBlogHelper::getConfig();
$debug = JRequest::getBool('debug', false);
if (!$config->get('main_comment_email')) {
return;
}
$interval = (int) $config->get('main_remotepublishing_mailbox_run_interval');
$nextrun = (int) $config->get('main_remotepublishing_mailbox_next_run');
$nextrun = EasyBlogHelper::getDate($nextrun)->toUnix();
$timenow = EasyBlogHelper::getDate()->toUnix();
if ($nextrun !== 0 && $timenow < $nextrun) {
if (!$debug) {
echo 'time now: ' . EasyBlogHelper::getDate($timenow)->toMySQL() . "<br />\n";
echo 'next email run: ' . EasyBlogHelper::getDate($nextrun)->toMySQL() . "<br />\n";
return;
}
}
$txOffset = EasyBlogDateHelper::getOffSet();
$newnextrun = EasyBlogHelper::getDate('+ ' . $interval . ' minutes', $txOffset)->toUnix();
// use $configTable to avoid variable name conflict
$configTable = EasyBlogHelper::getTable('configs');
$configTable->load('config');
$parameters = new JParameter($configTable->params);
$parameters->set('main_remotepublishing_mailbox_next_run', $newnextrun);
$configTable->params = $parameters->toString('ini');
$configTable->store();
/*
* Connect to mailbox
*/
require_once JPATH_ROOT . DS . 'components' . DS . 'com_easyblog' . DS . 'classes' . DS . 'mailbox.php';
$mailbox = new EasyblogMailbox();
if (!$mailbox->connect()) {
$mailbox->disconnect();
echo 'Comment Mailbox: Could not connect to mailbox.';
return false;
}
$total = 0;
/*
* Get data from mailbox
*/
$total_mails = $mailbox->getMessageCount();
if ($total_mails < 1) {
// No mails in mailbox
$mailbox->disconnect();
echo 'Comment Mailbox: No emails found.';
return false;
}
// Let's get the correct mails
$messages = $mailbox->searchMessages('UNSEEN');
if ($messages) {
$prefix = '/\\[\\#(.*)\\]/is';
$filter = JFilterInput::getInstance();
$db = EasyBlogHelper::db();
foreach ($messages as $messageSequence) {
$info = $mailbox->getMessageInfo($messageSequence);
$from = $info->fromemail;
$senderName = $info->from[0]->personal;
$subject = $filter->clean($info->subject);
// @rule: Detect if this is actually a reply.
preg_match('/\\[\\#(.*)\\]/is', $subject, $matches);
// If the title doesn't match the comment specific title, just continue the block.
if (empty($matches)) {
continue;
}
$query = 'SELECT ' . $db->nameQuote('id') . ' FROM ' . $db->nameQuote('#__users') . ' ' . 'WHERE ' . $db->nameQuote('email') . '=' . $db->Quote($from);
$db->setQuery($query);
$userId = $db->loadResult();
$commentId = $matches[1];
$refComment = EasyBlogHelper::getTable('Comment');
$refComment->load($commentId);
// Get the message contents.
$message = new EasyblogMailboxMessage($mailbox->stream, $messageSequence);
$message->getMessage();
$content = $message->getPlain();
// If guest commenting is not allowed, and user's email does not exist in system, pass this.
if (!$config->get('main_allowguestcomment') && !$userId) {
continue;
}
// Apply akismet filtering
if ($config->get('comment_akismet')) {
$data = array('author' => $senderName, 'email' => $from, 'website' => JURI::root(), 'body' => $content, 'permalink' => EasyBlogRouter::_('index.php?option=com_easyblog&view=entry&id=' . $refComment->post_id));
if (EasyBlogHelper::getHelper('Akismet')->isSpam($data)) {
continue;
}
}
$model = EasyBlogHelper::getModel('Comment');
$comment = EasyBlogHelper::getTable('Comment');
$comment->name = $senderName;
$comment->email = $from;
$comment->comment = $content;
$comment->post_id = $refComment->post_id;
$date = EasyBlogHelper::getDate();
$comment->created = $date->toMySQL();
$comment->modified = $date->toMySQL();
$comment->published = 1;
if ($userId) {
$comment->created_by = $userId;
}
$comment->sent = 0;
$isModerated = false;
// Update publish status if the comment requires moderation
if ($config->get('comment_moderatecomment') == 1 || !$userId && $config->get('comment_moderateguestcomment') == 1) {
$comment->set('published', EBLOG_COMMENT_STATUS_MODERATED);
$isModerated = true;
}
$blog = EasyBlogHelper::getTable('Blog');
$blog->load($comment->post_id);
// If moderation for author is disabled, ensure that the comment is published.
// If the author is the owner of the blog, it should never be moderated.
if (!$config->get('comment_moderateauthorcomment') && $blog->created_by == $userId) {
$comment->set('published', 1);
$isModerated = false;
}
if (!$comment->store()) {
echo 'Error storing comment: ' . $comment->getError();
return;
}
echo '* Added comment for post <strong>' . $blog->title . '</strong><br />';
// @rule: Process notifications
$comment->processEmails($isModerated, $blog);
// Update the sent flag
$comment->updateSent();
$total++;
}
}
/*
* Disconnect from mailbox
*/
$mailbox->disconnect();
/*
* Generate report
*/
echo JText::sprintf('Comment Mailbox: %1s comments fetched from mailbox: ' . $config->get('main_remotepublishing_mailbox_remotesystemname') . '.', $total);
}
