function listing()
{
$app = JFactory::getApplication();
global $Itemid;
$config = acymailing_config();
$jsite = JFactory::getApplication('site');
$menus = $jsite->getMenu();
$menu = $menus->getActive();
if (empty($menu) and !empty($Itemid)) {
$menus->setActive($Itemid);
$menu = $menus->getItem($Itemid);
}
if (empty($menu)) {
acymailing_enqueueMessage(JText::_('ACY_NOTALLOWED'));
$app->redirect('index.php');
}
$selectedLists = 'all';
if (is_object($menu)) {
jimport('joomla.html.parameter');
$menuparams = new acyParameter($menu->params);
$this->assign('listsintrotext', $menuparams->get('listsintrotext'));
$this->assign('listsfinaltext', $menuparams->get('listsfinaltext'));
$selectedLists = $menuparams->get('lists', 'all');
$document = JFactory::getDocument();
if ($menuparams->get('menu-meta_description')) {
$document->setDescription($menuparams->get('menu-meta_description'));
}
if ($menuparams->get('menu-meta_keywords')) {
$document->setMetadata('keywords', $menuparams->get('menu-meta_keywords'));
}
if ($menuparams->get('robots')) {
$document->setMetadata('robots', $menuparams->get('robots'));
}
if ($menuparams->get('page_title')) {
acymailing_setPageTitle($menuparams->get('page_title'));
}
}
if (empty($menuparams)) {
$pathway = $app->getPathway();
$pathway->addItem(JText::_('MAILING_LISTS'));
}
$document = JFactory::getDocument();
$link = '&format=feed&limitstart=';
if ($config->get('acyrss_format') == 'rss' || $config->get('acyrss_format') == 'both') {
$attribs = array('type' => 'application/rss+xml', 'title' => 'RSS 2.0');
$document->addHeadLink(JRoute::_($link . '&type=rss'), 'alternate', 'rel', $attribs);
}
if ($config->get('acyrss_format') == 'atom' || $config->get('acyrss_format') == 'both') {
$attribs = array('type' => 'application/atom+xml', 'title' => 'Atom 1.0');
$document->addHeadLink(JRoute::_($link . '&type=atom'), 'alternate', 'rel', $attribs);
}
$listsClass = acymailing_get('class.list');
$allLists = $listsClass->getLists('', $selectedLists);
if (acymailing_level(1)) {
$allLists = $listsClass->onlyCurrentLanguage($allLists);
}
$myItem = empty($Itemid) ? '' : '&Itemid=' . $Itemid;
$this->assignRef('rows', $allLists);
$this->assignRef('item', $myItem);
}
function change($data, $input, $output)
{
$input = strtoupper(trim($input));
$output = strtoupper(trim($output));
$supportedEncodings = array("BIG5", "ISO-8859-1", "ISO-8859-2", "ISO-8859-3", "ISO-8859-4", "ISO-8859-5", "ISO-8859-6", "ISO-8859-7", "ISO-8859-8", "ISO-8859-9", "ISO-8859-10", "ISO-8859-13", "ISO-8859-14", "ISO-8859-15", "ISO-2022-JP", "US-ASCII", "UTF-7", "UTF-8", "UTF-16", "Windows-1251", "Windows-1252", "ARMSCII-8", "ISO-8859-16");
if (!in_array($input, $supportedEncodings)) {
acymailing_enqueueMessage('Encoding not supported: ' . $input, 'error');
} elseif (!in_array($output, $supportedEncodings)) {
acymailing_enqueueMessage('Encoding not supported: ' . $output, 'error');
}
if ($input == $output) {
return $data;
}
if ($input == 'UTF-8' && $output == 'ISO-8859-1') {
$data = str_replace(array('€', '„', '“'), array('EUR', '"', '"'), $data);
}
if (function_exists('iconv')) {
set_error_handler('acymailing_error_handler_encoding');
$encodedData = iconv($input, $output . "//IGNORE", $data);
restore_error_handler();
if (!empty($encodedData) && !acymailing_error_handler_encoding('result')) {
return $encodedData;
}
}
if (function_exists('mb_convert_encoding')) {
return mb_convert_encoding($data, $output, $input);
}
if ($input == 'UTF-8' && $output == 'ISO-8859-1') {
return utf8_decode($data);
}
if ($input == 'ISO-8859-1' && $output == 'UTF-8') {
return utf8_encode($data);
}
return $data;
}
function doimport()
{
if (!$this->isAllowed('subscriber', 'import')) {
return;
}
JRequest::checkToken() or die('Invalid Token');
$function = JRequest::getCmd('importfrom');
$importHelper = acymailing_get('helper.import');
if (!$importHelper->{$function}()) {
return $this->import();
}
$app = JFactory::getApplication();
if ($function == 'textarea' || $function == 'file') {
if (file_exists(ACYMAILING_MEDIA . 'import' . DS . JRequest::getCmd('filename'))) {
$importContent = file_get_contents(ACYMAILING_MEDIA . 'import' . DS . JRequest::getCmd('filename'));
}
if (empty($importContent)) {
acymailing_enqueueMessage(JText::_('ACY_IMPORT_NO_CONTENT'), 'error');
$this->setRedirect(acymailing_completeLink(($app->isSite() ? 'front' : '') . 'data&task=import', false, true));
} else {
JRequest::setVar('hidemainmenu', 1);
JRequest::setVar('layout', 'genericimport');
return parent::display();
}
} else {
$this->setRedirect(acymailing_completeLink($app->isAdmin() ? 'subscriber' : 'frontsubscriber', false, true));
}
}
function remove()
{
if (!$this->isAllowed('statistics', 'delete')) {
return;
}
JRequest::checkToken() or die('Invalid Token');
$cids = JRequest::getVar('cid', array(), '', 'array');
$class = acymailing_get('class.stats');
$num = $class->delete($cids);
acymailing_enqueueMessage(JText::sprintf('SUCC_DELETE_ELEMENTS', $num), 'message');
return $this->listing();
}
function remove()
{
if (!$this->isAllowed($this->aclCat, 'delete')) {
return;
}
JRequest::checkToken() or die('Invalid Token');
$listIds = JRequest::getVar('cid', array(), '', 'array');
$subscriberObject = acymailing_get('class.list');
$num = $subscriberObject->delete($listIds);
acymailing_enqueueMessage(JText::sprintf('SUCC_DELETE_ELEMENTS', $num), 'message');
JRequest::setVar('layout', 'listing');
return parent::display();
}
function cancelNewsletter()
{
if (!$this->isAllowed($this->aclCat, 'delete')) {
return;
}
JRequest::checkToken() || JRequest::checkToken('get') || die('Invalid token');
$mailid = JRequest::getInt('mailid', 0);
if (empty($mailid)) {
acymailing_enqueueMessage('Mail id not found', 'error');
return;
}
$queueClass = acymailing_get('class.queue');
acymailing_enqueueMessage(JText::sprintf('SUCC_DELETE_ELEMENTS', $queueClass->delete(array('a.mailid = ' . $mailid))), 'info');
}
function store()
{
JRequest::checkToken() or die('Invalid Token');
$oldMailid = acymailing_getCID('mailid');
$mailClass = acymailing_get('class.mail');
if ($mailClass->saveForm()) {
$data = JRequest::getVar('data');
$type = @$data['mail']['type'];
if (!empty($type) and in_array($type, array('unsub', 'welcome'))) {
$subject = addslashes($data['mail']['subject']);
$mailid = JRequest::getInt('mailid');
if ($type == 'unsub') {
$js = "var mydrop = window.top.document.getElementById('datalistunsubmailid'); ";
$js .= "var type = 'unsub';";
} else {
//type=welcome
$js = "var mydrop = window.top.document.getElementById('datalistwelmailid'); ";
$js .= "var type = 'welcome';";
}
if (empty($oldMailid)) {
$js .= 'var optn = document.createElement("OPTION");';
$js .= "optn.text = '[{$mailid}] {$subject}'; optn.value = '{$mailid}';";
$js .= 'mydrop.options.add(optn);';
$js .= 'lastid = 0; while(mydrop.options[lastid+1]){lastid = lastid+1;} mydrop.selectedIndex = lastid;';
$js .= 'window.top.changeMessage(type,' . $mailid . ');';
} else {
$js .= "lastid = 0; notfound = true; while(notfound && mydrop.options[lastid]){if(mydrop.options[lastid].value == {$mailid}){mydrop.options[lastid].text = '[{$mailid}] {$subject}';notfound = false;} lastid = lastid+1;}";
}
if (ACYMAILING_J30) {
$js .= 'window.top.jQuery("#datalist' . ($type == 'unsub' ? 'unsub' : 'wel') . 'mailid").trigger("liszt:updated");';
}
$doc = JFactory::getDocument();
$doc->addScriptDeclaration($js);
}
acymailing_enqueueMessage(JText::_('JOOMEXT_SUCC_SAVED'), 'success');
} else {
acymailing_enqueueMessage(JText::_('ERROR_SAVING'), 'error');
}
}
function listing()
{
$app = JFactory::getApplication();
$config = acymailing_config();
if (!class_exists('plgSystemAcymailingClassMail')) {
$warning_msg = JText::_('ACY_WARNINGOVERRIDE_DISABLED_1') . ' <a href="index.php?option=com_acymailing&ctrl=cpanel">' . JText::sprintf('ACY_WARNINGOVERRIDE_DISABLED_2', ' acymailingclassmail (Override Joomla mailing system plugin)') . '</a>';
acymailing_enqueueMessage($warning_msg, 'notice');
}
$pageInfo = new stdClass();
$pageInfo->filter = new stdClass();
$pageInfo->filter->order = new stdClass();
$paramBase = ACYMAILING_COMPONENT . '.' . $this->getName();
$pageInfo->filter->order->value = $app->getUserStateFromRequest($paramBase . ".filter_order", 'filter_order', 'mailid', 'cmd');
$pageInfo->filter->order->dir = $app->getUserStateFromRequest($paramBase . ".filter_order_Dir", 'filter_order_Dir', 'desc', 'word');
if (strtolower($pageInfo->filter->order->dir) !== 'desc') {
$pageInfo->filter->order->dir = 'asc';
}
$db = JFactory::getDBO();
$query = 'SELECT mailid, subject, alias, fromname, published, fromname, fromemail, replyname, replyemail FROM #__acymailing_mail WHERE `type` = ' . $db->Quote($this->type);
if (!empty($pageInfo->filter->order->value)) {
$query .= ' ORDER BY ' . $pageInfo->filter->order->value . ' ' . $pageInfo->filter->order->dir;
}
$db->setQuery($query);
$rows = $db->loadObjectList();
$acyToolbar = acymailing::get('helper.toolbar');
$acyToolbar->custom('preview', JText::_('ACY_PREVIEW'), 'search', true);
$acyToolbar->edit();
$acyToolbar->delete();
$acyToolbar->divider();
$acyToolbar->help($this->doc);
$acyToolbar->setTitle(JText::_($this->nameListing), $this->ctrl);
$acyToolbar->display();
$toggleClass = acymailing_get('helper.toggle');
$this->assignRef('toggleClass', $toggleClass);
$this->assignRef('pageInfo', $pageInfo);
$this->assign('config', $config);
$this->assign('rows', $rows);
}
function installExtensions()
{
$path = ACYMAILING_BACK . 'extensions';
$dirs = JFolder::folders($path);
if (!ACYMAILING_J16) {
if (file_exists(ACYMAILING_BACK . 'config.xml')) {
JFile::delete(ACYMAILING_BACK . 'config.xml');
}
$query = "SELECT CONCAT(`folder`,`element`) FROM #__plugins WHERE `folder` = 'acymailing' OR `element` LIKE '%acy%'";
$query .= " UNION SELECT `module` FROM #__modules WHERE `module` LIKE '%acymailing%'";
$this->db->setQuery($query);
$existingExtensions = acymailing_loadResultArray($this->db);
} else {
$this->db->setQuery("SELECT CONCAT(`folder`,`element`) FROM #__extensions WHERE `folder` = 'acymailing' OR `element` LIKE '%acy%'");
$existingExtensions = acymailing_loadResultArray($this->db);
}
$plugins = array();
$modules = array();
$extensioninfo = array();
//array('name','ordering','required table or published')
$extensioninfo['mod_acymailing'] = array('AcyMailing Module');
$extensioninfo['plg_acymailing_share'] = array('AcyMailing : share on social networks', 20, 1);
$extensioninfo['plg_acymailing_contentplugin'] = array('AcyMailing : trigger Joomla Content plugins', 15, 0);
$extensioninfo['plg_acymailing_managetext'] = array('AcyMailing Manage text', 10, 1);
$extensioninfo['plg_acymailing_tablecontents'] = array('AcyMailing table of contents generator', 5, 1);
$extensioninfo['plg_acymailing_online'] = array('AcyMailing Tag : Website links', 6, 1);
$extensioninfo['plg_acymailing_stats'] = array('AcyMailing : Statistics Plugin', 50, 1);
$extensioninfo['plg_acymailing_tagcbuser'] = array('AcyMailing Tag : CB User information', 4, '#__comprofiler');
$extensioninfo['plg_acymailing_tagcontent'] = array('AcyMailing Tag : content insertion', 11, 1);
$extensioninfo['plg_acymailing_tagmodule'] = array('AcyMailing Tag : Insert a Module', 12, 1);
$extensioninfo['plg_acymailing_tagsubscriber'] = array('AcyMailing Tag : Subscriber information', 2, 1);
$extensioninfo['plg_acymailing_tagsubscription'] = array('AcyMailing Tag : Manage the Subscription', 1, 1);
$extensioninfo['plg_acymailing_tagtime'] = array('AcyMailing Tag : Date / Time', 5, 1);
$extensioninfo['plg_acymailing_taguser'] = array('AcyMailing Tag : Joomla User Information', 3, 1);
$extensioninfo['plg_acymailing_virtuemart'] = array('AcyMailing Tag : VirtueMart integration', 7, '#__vm_product');
$extensioninfo['plg_acymailing_template'] = array('AcyMailing Template Class Replacer', 25, 1);
$extensioninfo['plg_acymailing_urltracker'] = array('AcyMailing : Handle Click tracking part1', 30, 1);
$extensioninfo['plg_system_acymailingurltracker'] = array('AcyMailing : Handle Click tracking part2', 1, 1);
$extensioninfo['plg_system_regacymailing'] = array('AcyMailing : (auto)Subscribe during Joomla registration', 0, 1);
$extensioninfo['plg_system_vmacymailing'] = array('AcyMailing : VirtueMart checkout subscription', 0, 0);
$extensioninfo['plg_editors_acyeditor'] = array('AcyMailing Editor', 5, 1);
$extensioninfo['plg_acymailing_geolocation'] = array('AcyMailing Geolocation : Tag and filter', 10, 1);
$extensioninfo['plg_acymailing_plginboxactions'] = array('AcyMailing : Inbox actions', 35, 1);
$extensioninfo['plg_system_acymailingclassmail'] = array('Override Joomla mailing system', 1, 0);
$extensioninfo['plg_acymailing_calltoaction'] = array('AcyMailing Tag : Call to action', 22, 1);
$listTables = $this->db->getTableList();
$fromVersion = JRequest::getCmd('fromversion');
foreach ($dirs as $oneDir) {
$arguments = explode('_', $oneDir);
if (!isset($extensioninfo[$oneDir])) {
continue;
}
$additionalInfo = new stdClass();
if ($arguments[0] == 'mod') {
$arguments[2] = $oneDir;
}
if (ACYMAILING_J16 && !empty($arguments[2]) && file_exists($path . DS . $oneDir . DS . $arguments[2] . '.xml')) {
$xmlFile = simplexml_load_file($path . DS . $oneDir . DS . $arguments[2] . '.xml');
$additionalInfo->version = (string) $xmlFile->version;
$additionalInfo->author = (string) $xmlFile->author;
$additionalInfo->creationDate = (string) $xmlFile->creationDate;
$extension = $arguments[0] == 'mod' ? $oneDir : $arguments[1] . $arguments[2];
if (in_array($extension, $existingExtensions) && version_compare($fromVersion, '4.8.1', '<')) {
$query = "UPDATE `#__extensions` SET `manifest_cache` = " . $this->db->Quote(json_encode($additionalInfo)) . " WHERE (type = ";
if ($arguments[0] == 'mod') {
$query .= "'module' AND `element` = " . $this->db->Quote($oneDir) . ")";
} else {
$query .= "'plugin' AND folder = " . $this->db->Quote($arguments[1]) . " AND `element` = " . $this->db->Quote($arguments[2]) . ")";
}
$this->db->setQuery($query);
$this->db->query();
}
}
if ($arguments[0] == 'plg') {
$newPlugin = new stdClass();
if (!empty($additionalInfo)) {
$newPlugin->additionalInfo = json_encode($additionalInfo);
}
$newPlugin->name = $oneDir;
if (isset($extensioninfo[$oneDir][0])) {
$newPlugin->name = $extensioninfo[$oneDir][0];
}
$newPlugin->type = 'plugin';
$newPlugin->folder = $arguments[1];
$newPlugin->element = $arguments[2];
$newPlugin->enabled = 1;
if (isset($extensioninfo[$oneDir][2])) {
if (is_numeric($extensioninfo[$oneDir][2])) {
$newPlugin->enabled = $extensioninfo[$oneDir][2];
} elseif (!in_array(str_replace('#__', $this->db->getPrefix(), $extensioninfo[$oneDir][2]), $listTables)) {
$newPlugin->enabled = 0;
}
}
$newPlugin->params = '{}';
$newPlugin->ordering = 0;
if (isset($extensioninfo[$oneDir][1])) {
$newPlugin->ordering = $extensioninfo[$oneDir][1];
}
if (!acymailing_createDir(ACYMAILING_ROOT . 'plugins' . DS . $newPlugin->folder)) {
continue;
}
if (!ACYMAILING_J16) {
$destinationFolder = ACYMAILING_ROOT . 'plugins' . DS . $newPlugin->folder;
} else {
$destinationFolder = ACYMAILING_ROOT . 'plugins' . DS . $newPlugin->folder . DS . $newPlugin->element;
if (!acymailing_createDir($destinationFolder)) {
continue;
}
}
if (!$this->copyFolder($path . DS . $oneDir, $destinationFolder)) {
continue;
}
if (in_array($newPlugin->folder . $newPlugin->element, $existingExtensions)) {
continue;
}
$plugins[] = $newPlugin;
} elseif ($arguments[0] == 'mod') {
$newModule = new stdClass();
if (!empty($additionalInfo)) {
$newModule->additionalInfo = json_encode($additionalInfo);
}
$newModule->name = $oneDir;
if (isset($extensioninfo[$oneDir][0])) {
$newModule->name = $extensioninfo[$oneDir][0];
}
$newModule->type = 'module';
$newModule->folder = '';
$newModule->element = $oneDir;
$newModule->enabled = 1;
$newModule->params = '{}';
$newModule->ordering = 0;
if (isset($extensioninfo[$oneDir][1])) {
$newModule->ordering = $extensioninfo[$oneDir][1];
}
$destinationFolder = ACYMAILING_ROOT . 'modules' . DS . $oneDir;
if (!acymailing_createDir($destinationFolder)) {
continue;
}
if (!$this->copyFolder($path . DS . $oneDir, $destinationFolder)) {
continue;
}
if (in_array($newModule->element, $existingExtensions)) {
continue;
}
$modules[] = $newModule;
} else {
acymailing_enqueueMessage('Could not handle : ' . $oneDir, 'error');
}
}
if (!empty($this->errors)) {
acymailing_enqueueMessage($this->errors, 'error');
}
if (!ACYMAILING_J16) {
$extensions = $plugins;
} else {
$extensions = array_merge($plugins, $modules);
}
$success = array();
if (!empty($extensions)) {
if (!ACYMAILING_J16) {
$queryExtensions = 'INSERT INTO `#__plugins` (`name`,`element`,`folder`,`published`,`ordering`) VALUES ';
} else {
$queryExtensions = 'INSERT INTO `#__extensions` (`name`,`element`,`folder`,`enabled`,`ordering`,`type`,`access`,`manifest_cache`) VALUES ';
}
foreach ($extensions as $oneExt) {
$queryExtensions .= '(' . $this->db->Quote($oneExt->name) . ',' . $this->db->Quote($oneExt->element) . ',' . $this->db->Quote($oneExt->folder) . ',' . $oneExt->enabled . ',' . $oneExt->ordering;
if (ACYMAILING_J16) {
$queryExtensions .= ',' . $this->db->Quote($oneExt->type) . ',1,' . $this->db->Quote(!empty($oneExt->additionalInfo) ? $oneExt->additionalInfo : '');
}
$queryExtensions .= '),';
if ($oneExt->type != 'module') {
$success[] = JText::sprintf('PLUG_INSTALLED', $oneExt->name);
}
}
$queryExtensions = trim($queryExtensions, ',');
$this->db->setQuery($queryExtensions);
$this->db->query();
}
if (!empty($modules)) {
foreach ($modules as $oneModule) {
if (!ACYMAILING_J16) {
$queryModule = 'INSERT INTO `#__modules` (`title`,`position`,`published`,`module`) VALUES ';
$queryModule .= '(' . $this->db->Quote($oneModule->name) . ",'left',0," . $this->db->Quote($oneModule->element) . ")";
} else {
$queryModule = 'INSERT INTO `#__modules` (`title`,`position`,`published`,`module`,`access`,`language`) VALUES ';
$queryModule .= '(' . $this->db->Quote($oneModule->name) . ",'position-7',0," . $this->db->Quote($oneModule->element) . ",1,'*')";
}
$this->db->setQuery($queryModule);
$this->db->query();
$moduleId = $this->db->insertid();
$this->db->setQuery('INSERT IGNORE INTO `#__modules_menu` (`moduleid`,`menuid`) VALUES (' . $moduleId . ',0)');
$this->db->query();
$success[] = JText::sprintf('MODULE_INSTALLED', $oneModule->name);
}
}
if (ACYMAILING_J16) {
$this->db->setQuery("UPDATE `#__extensions` SET `access` = 1 WHERE ( `folder` = 'acymailing' OR `element` LIKE '%acymailing%' ) AND `type` = 'plugin'");
$this->db->query();
}
$this->cleanPluginCache();
if (!empty($success)) {
acymailing_enqueueMessage($success, 'success');
}
}
function managePicts($tag, $result)
{
if (!isset($tag->pict)) {
return $result;
}
$pictureHelper = acymailing_get('helper.acypict');
if ($tag->pict === 'resized') {
$app = JFactory::getApplication();
$pictureHelper->maxHeight = empty($tag->maxheight) ? 150 : $tag->maxheight;
$pictureHelper->maxWidth = empty($tag->maxwidth) ? 150 : $tag->maxwidth;
if ($pictureHelper->available()) {
$result = $pictureHelper->resizePictures($result);
} elseif ($app->isAdmin()) {
acymailing_enqueueMessage($pictureHelper->error, 'notice');
}
} elseif ($tag->pict == '0') {
$result = $pictureHelper->removePictures($result);
}
return $result;
}
function _savelanguage()
{
if (!$this->isAllowed('configuration', 'manage')) {
return;
}
JRequest::checkToken() or die('Invalid Token');
jimport('joomla.filesystem.file');
$code = JRequest::getCmd('code');
JRequest::setVar('code', $code);
$content = JRequest::getVar('content', '', '', 'string', JREQUEST_ALLOWHTML);
if (empty($code) or empty($content)) {
return;
}
$path = JLanguage::getLanguagePath(JPATH_ROOT) . DS . $code . DS . $code . '.com_acymailing.ini';
$result = JFile::write($path, $content);
if ($result) {
acymailing_enqueueMessage(JText::_('JOOMEXT_SUCC_SAVED'), 'success');
$js = "window.top.document.getElementById('image{$code}').className = 'acyicon-edit'";
$doc = JFactory::getDocument();
$doc->addScriptDeclaration($js);
$updateHelper = acymailing_get('helper.update');
$updateHelper->installMenu($code);
} else {
acymailing_enqueueMessage(JText::sprintf('FAIL_SAVE', $path), 'error');
}
$customcontent = JRequest::getVar('customcontent', '', '', 'string', JREQUEST_ALLOWHTML);
$custompath = JLanguage::getLanguagePath(JPATH_ROOT) . DS . $code . DS . $code . '.com_acymailing_custom.ini';
$customresult = JFile::write($custompath, $customcontent);
if (!$customresult) {
acymailing_enqueueMessage(JText::sprintf('FAIL_SAVE', $custompath), 'error');
}
return $result;
}
function updateQuery($query)
{
try {
$this->db->setQuery($query);
$res = $this->db->query();
} catch (Exception $e) {
$res = null;
}
if ($res === null) {
acymailing_enqueueMessage(isset($e) ? $e->getMessage() : substr(strip_tags($this->db->getErrorMsg()), 0, 200) . '...', 'error');
}
}
function abtest()
{
$nbTotalReceivers = JRequest::getInt('nbTotalReceivers');
$mailids = JRequest::getString('mailid');
$mailsArray = explode(',', $mailids);
JArrayHelper::toInteger($mailsArray);
$db = JFactory::getDBO();
$abTesting_prct = JRequest::getInt('abTesting_prct');
$abTesting_delay = JRequest::getInt('abTesting_delay');
$abTesting_action = JRequest::getString('abTesting_action');
if (empty($abTesting_prct)) {
acymailing_display(JText::_('ABTESTING_NEEDVALUE'), 'warning');
$this->abtesting();
return;
}
$newAbTestDetail = array();
$newAbTestDetail['mailids'] = implode(',', $mailsArray);
$newAbTestDetail['prct'] = !empty($abTesting_prct) ? $abTesting_prct : '';
$newAbTestDetail['delay'] = isset($abTesting_delay) && strlen($abTesting_delay) > 0 ? $abTesting_delay : '2';
$newAbTestDetail['action'] = !empty($abTesting_action) ? $abTesting_action : 'manual';
$newAbTestDetail['time'] = time();
$newAbTestDetail['status'] = 'inProgress';
$mailClass = acymailing_get('class.mail');
$nbReceiversTest = $mailClass->ab_test($newAbTestDetail, $mailsArray, $nbTotalReceivers);
acymailing_enqueueMessage(JText::sprintf('ABTESTING_SUCCESSADD', $nbReceiversTest), 'info');
JRequest::setVar('validationStatus', 'abTestAdd');
$this->abtesting();
}
function abtesting()
{
$app = JFactory::getApplication();
$mailids = JRequest::getString('mailid');
$validationStatus = JRequest::getString('validationStatus');
$noMsg = false;
$noBtn = false;
if (!empty($mailids) && strpos($mailids, ',') !== false) {
$db = JFactory::getDBO();
$warningMsg = array();
$mailsArray = explode(',', $mailids);
JArrayHelper::toInteger($mailsArray);
$mailids = implode(',', $mailsArray);
$this->assign('mailid', $mailids);
$query = 'SELECT abtesting FROM #__acymailing_mail WHERE mailid IN (' . implode(',', $mailsArray) . ') AND abtesting IS NOT NULL';
$db->setQuery($query);
$resDetail = acymailing_loadResultArray($db);
if (!empty($resDetail) && count($resDetail) != count($mailsArray)) {
$titlePage = JText::_('ABTESTING');
acymailing_display(JText::_('ABTESTING_MISSINGEMAIL'), 'warning');
$this->assign('missingMail', true);
} else {
$abTestDetail = array();
if (empty($resDetail)) {
$abTestDetail['mailids'] = $mailids;
$abTestDetail['prct'] = 10;
$abTestDetail['delay'] = 2;
$abTestDetail['action'] = 'manual';
} else {
$abTestDetail = unserialize($resDetail[0]);
$savedIds = explode(',', $abTestDetail['mailids']);
sort($savedIds);
sort($mailsArray);
if (!empty($abTestDetail['status']) && in_array($abTestDetail['status'], array('inProgress', 'testSendOver', 'abTestFinalSend')) && $savedIds != $mailsArray) {
$warningMsg[] = JText::_('ABTESTING_TESTEXIST');
$mailsArray = $savedIds;
$mailids = implode(',', $mailsArray);
}
$this->assign('savedValues', true);
if ($abTestDetail['status'] == 'inProgress') {
$warningMsg[] = JText::_('ABTESTING_INPROGRESS');
}
}
if ($validationStatus == 'abTestAdd') {
$noMsg = true;
}
if (!empty($abTestDetail['status']) && $abTestDetail['status'] == 'abTestFinalSend' && !empty($abTestDetail['newMail'])) {
$mailInQueueErrorMsg = JText::_('ABTESTING_FINALMAILINQUEUE');
$mailTocheck = '=' . $abTestDetail['newMail'];
} else {
$mailInQueueErrorMsg = JText::_('ABTESTING_TESTMAILINQUEUE');
$mailTocheck = ' IN (' . implode(',', $mailsArray) . ')';
}
$query = "SELECT COUNT(*) FROM #__acymailing_queue WHERE mailid" . $mailTocheck;
$db->setQuery($query);
$queueCheck = $db->loadResult();
if (!empty($queueCheck) && $validationStatus != 'abTestAdd') {
acymailing_enqueueMessage($mailInQueueErrorMsg, 'error');
$noMsg = true;
}
if (!empty($resDetail) && empty($queueCheck) && in_array($abTestDetail['status'], array('inProgress', 'abTestFinalSend'))) {
if ($abTestDetail['status'] == 'inProgress') {
$abTestDetail['status'] = 'testSendOver';
} else {
$abTestDetail['status'] = 'completed';
}
$query = "UPDATE #__acymailing_mail SET abtesting=" . $db->quote(serialize($abTestDetail)) . " WHERE mailid IN (" . implode(',', $mailsArray) . ")";
$db->setQuery($query);
$db->query();
}
if (!empty($abTestDetail['status']) && $abTestDetail['status'] == 'testSendOver') {
acymailing_enqueueMessage(JText::_('ABTESTING_READYTOSEND'), 'info');
}
if (!empty($abTestDetail['status']) && $abTestDetail['status'] == 'completed') {
acymailing_enqueueMessage(JText::_('ABTESTING_COMPLETE'), 'info');
}
$this->assign('abTestDetail', $abTestDetail);
$nbMails = count($mailsArray);
$titleStr = "A/B/C/D/E/F/G/H/I/J/K/L/M/N/O/P/Q/R/S/T/U/V/W/X/Y/Z";
$titlePage = JText::sprintf('ABTESTING_TITLE', substr($titleStr, 0, min($nbMails, 26) * 2 - 1));
$mailClass = acymailing_get('class.mail');
$mailsDetails = array();
foreach ($mailsArray as $mailid) {
$mailsDetails[] = $mailClass->get($mailid);
}
$this->assign('mailsdetails', $mailsDetails);
$mailerHelper = acymailing_get('helper.mailer');
$mailerHelper->loadedToSend = false;
$mailReceiver = $mailerHelper->load($mailsArray[0]);
$listmailClass = acymailing_get('class.listmail');
$lists = $listmailClass->getReceivers($mailReceiver->mailid, true, false);
$this->assign('lists', $lists);
$this->assign('mailReceiver', $mailReceiver);
$filterClass = acymailing_get('class.filter');
$this->assign('filterClass', $filterClass);
$listids = array();
foreach ($lists as $oneList) {
$listids[] = $oneList->listid;
}
$nbTotalReceivers = $filterClass->countReceivers($listids, $this->mailReceiver->filter, $this->mailReceiver->mailid);
if ($nbTotalReceivers < 50) {
$warningMsg[] = JText::sprintf('ABTESTING_NOTENOUGHUSER', $nbTotalReceivers);
$noBtn = true;
}
$this->assign('nbTotalReceivers', $nbTotalReceivers);
$this->assign('nbTestReceivers', floor($nbTotalReceivers * $abTestDetail['prct'] / 100));
if ($noMsg || $noBtn) {
$noButton = true;
}
$queryStat = 'SELECT mailid, openunique, clickunique, senthtml, senttext, bounceunique FROM #__acymailing_stats WHERE mailid IN (' . $mailids . ')';
$db->setQuery($queryStat);
$resStat = $db->loadObjectList('mailid');
if (!empty($resStat)) {
$this->assign('statMail', $resStat);
$warningMsg[] = JText::_('ABTESTING_STAT_WARNING');
}
if (!empty($warningMsg) && $noMsg == false) {
acymailing_enqueueMessage(implode('<br />', $warningMsg), 'warning');
}
}
} else {
$titlePage = JText::_('ABTESTING');
}
$acyToolbar = acymailing::get('helper.toolbar');
if (empty($noButton)) {
$acyToolbar->custom('test', JText::_('ABTESTING_TEST'), 'test', false, "javascript:if(confirm('" . JText::_('PROCESS_CONFIRMATION', true) . "')){submitbutton('abtest');} return false;");
}
$acyToolbar->setTitle(JText::_('ABTESTING'));
$acyToolbar->topfixed = false;
$acyToolbar->display();
$this->assign('validationStatus', $validationStatus);
$this->assign('titlePage', $titlePage);
$this->assign('app', $app);
if ($app->isAdmin()) {
acymailing_setPageTitle(JText::_('ABTESTING'));
}
}
function export($tempid)
{
if (!extension_loaded('zlib')) {
JError::raiseWarning('SOME_ERROR_CODE', JText::_('WARNINSTALLZLIB'));
return false;
}
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.archive');
$template = $this->get($tempid);
$fileDeb = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';
if (!empty($template->description)) {
$fileDeb .= '
<meta name="description" content="' . str_replace('"', "'", $template->description) . '" />';
}
if (!empty($template->fromname)) {
$fileDeb .= '
<meta name="fromname" content="' . $template->fromname . '" />';
}
if (!empty($template->fromemail)) {
$fileDeb .= '
<meta name="fromemail" content="' . $template->fromemail . '" />';
}
if (!empty($template->replyname)) {
$fileDeb .= '
<meta name="replyname" content="' . $template->replyname . '" />';
}
if (!empty($template->replyemail)) {
$fileDeb .= '
<meta name="replyemail" content="' . $template->replyemail . '" />';
}
$fileDeb .= '
<title>' . $template->name . '</title>';
$css = '
<style type="text/css">
';
$css .= file_get_contents(ACYMAILING_TEMPLATE . DS . 'css' . DS . 'template_' . $tempid . '.css');
$css .= '
</style>';
$indexFile = $fileDeb . $css . '
</head>
<body>
' . $template->body . '
</body>
</html>';
$tmpdir = preg_replace('#[^a-z0-9]#i', '_', strtolower($template->name));
$jpathURL = ACYMAILING_LIVE . 'media/' . ACYMAILING_COMPONENT . '/tmp';
$tmp_url_dest = $jpathURL . DS . $tmpdir;
$jpath = ACYMAILING_MEDIA . 'tmp';
$tmp_dest = JPath::clean($jpath . DS . $tmpdir);
if (!JFolder::exists($jpath)) {
if (!JFolder::create($jpath)) {
acymailing_enqueueMessage('Error creating temp folder in directory: ' . $jpath, 'error');
return false;
}
}
if (!JFolder::create($tmp_dest)) {
acymailing_enqueueMessage('Error creating folder in temp directory: ' . $tmp_dest, 'error');
return false;
}
if (!empty($template->thumb)) {
$thumbPath = JPath::clean(ACYMAILING_ROOT . DS . $template->thumb);
$thumbExt = JFile::getExt($thumbPath);
$resCopyThumb = JFile::copy($thumbPath, $tmp_dest . DS . 'thumbnail.' . $thumbExt);
if (!$resCopyThumb) {
acymailing_enqueueMessage('Error copying the thumb picture', 'warning');
}
}
$resHandleImages = $this->handlepict($indexFile, $tmp_dest);
if (!$resHandleImages) {
JFolder::delete($tmp_dest);
return false;
}
$resCopyIndex = JFile::write($tmp_dest . DS . 'index.html', $indexFile);
if (!$resCopyIndex) {
acymailing_enqueueMessage('Error copying the file index.html to temp directory ' . $tmp_dest, 'error');
return false;
}
$zipFilesArray = array();
$dirs = JFolder::folders($tmp_dest, '.', true, true);
array_push($dirs, $tmp_dest);
foreach ($dirs as $dir) {
$files = JFolder::files($dir, '.', false, true);
foreach ($files as $file) {
$posSlash = strrpos($file, '/');
$posASlash = strrpos($file, '\\');
$pos = $posSlash < $posASlash ? $posASlash : $posSlash;
if (!empty($pos)) {
$file = substr_replace($file, DS, $pos, 1);
}
$data = JFile::read($file);
$zipFilesArray[] = array('name' => str_replace($tmp_dest . DS, '', $file), 'data' => $data);
}
}
$zip = JArchive::getAdapter('zip');
$zip->create($tmp_dest . '.zip', $zipFilesArray);
JFolder::delete($tmp_dest);
return $tmp_url_dest . '.zip';
}
public function sendOne($mailid, $receiverid)
{
$this->clearAll();
if (!isset($this->defaultMail[$mailid])) {
$this->loadedToSend = true;
if (!$this->load($mailid)) {
$this->reportMessage = 'Can not load the e-mail : ' . htmlspecialchars($mailid, ENT_COMPAT, 'UTF-8');
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
$this->errorNumber = 2;
return false;
}
}
if (!isset($this->forceVersion) and $this->checkPublished and empty($this->defaultMail[$mailid]->published)) {
$this->reportMessage = JText::sprintf('SEND_ERROR_PUBLISHED', htmlspecialchars($mailid, ENT_COMPAT, 'UTF-8'));
$this->errorNumber = 3;
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
return false;
}
if (!is_object($receiverid)) {
$receiver = $this->subscriberClass->get($receiverid);
if (empty($receiver->subid) and is_string($receiverid) and $this->autoAddUser) {
if ($this->userHelper->validEmail($receiverid)) {
$newUser = new stdClass();
$newUser->email = $receiverid;
$this->subscriberClass->checkVisitor = false;
$this->subscriberClass->sendConf = false;
$subid = $this->subscriberClass->save($newUser);
$receiver = $this->subscriberClass->get($subid);
}
}
} else {
$receiver = $receiverid;
}
if (empty($receiver->email)) {
$this->reportMessage = JText::sprintf('SEND_ERROR_USER', '<b><i>' . (isset($receiver->subid) ? $receiver->subid : htmlspecialchars($receiverid, ENT_COMPAT, 'UTF-8')) . '</i></b>');
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
$this->errorNumber = 4;
return false;
}
$this->MessageID = "<" . preg_replace("|[^a-z0-9+_]|i", '', base64_encode(rand(0, 9999999)) . "AC" . $receiver->subid . "Y" . $this->defaultMail[$mailid]->mailid . "BA" . base64_encode(time() . rand(0, 99999))) . "@" . $this->serverHostname() . ">";
if (strpos($this->Host, 'mailjet') !== false && !empty($this->defaultMail[$mailid]->alias)) {
$this->addCustomHeader('X-Mailjet-Campaign: ' . $this->defaultMail[$mailid]->alias);
}
if (!isset($this->forceVersion)) {
if ($this->checkConfirmField and empty($receiver->confirmed) and $this->config->get('require_confirmation', 0) and strpos($this->defaultMail[$mailid]->alias, 'confirm') === false) {
$this->reportMessage = JText::sprintf('SEND_ERROR_CONFIRMED', '<b><i>' . htmlspecialchars($receiver->email, ENT_COMPAT, 'UTF-8') . '</i></b>');
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
$this->errorNumber = 5;
return false;
}
if ($this->checkEnabled and empty($receiver->enabled) and strpos($this->defaultMail[$mailid]->alias, 'enable') === false) {
$this->reportMessage = JText::sprintf('SEND_ERROR_APPROVED', '<b><i>' . htmlspecialchars($receiver->email, ENT_COMPAT, 'UTF-8') . '</i></b>');
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
$this->errorNumber = 6;
return false;
}
}
if ($this->checkAccept and empty($receiver->accept)) {
$this->reportMessage = JText::sprintf('SEND_ERROR_ACCEPT', '<b><i>' . htmlspecialchars($receiver->email, ENT_COMPAT, 'UTF-8') . '</i></b>');
if ($this->report) {
acymailing_enqueueMessage($this->reportMessage, 'error');
}
$this->errorNumber = 7;
return false;
}
$addedName = '';
if ($this->config->get('add_names', true)) {
$nameTmp = JText::_('ACY_TO_NAME');
$testTag = preg_match_all('/\\[(.*)\\]/U', $nameTmp, $matches);
if ($testTag != 0) {
foreach ($matches[0] as $i => $oneMatch) {
if (!empty($receiver->{$matches}[1][$i])) {
$nameTmp = str_replace($oneMatch, $receiver->{$matches}[1][$i], $nameTmp);
}
}
}
$addedName = $this->cleanText($nameTmp);
}
$this->addAddress($this->cleanText($receiver->email), $addedName);
if (!isset($this->forceVersion)) {
$this->isHTML($receiver->html && $this->defaultMail[$mailid]->html);
} else {
$this->isHTML((bool) $this->forceVersion);
}
$this->Subject = $this->defaultMail[$mailid]->subject;
if ($this->sendHTML) {
$this->Body = $this->defaultMail[$mailid]->body;
if ($this->config->get('multiple_part', false)) {
$this->AltBody = $this->defaultMail[$mailid]->altbody;
}
} else {
$this->Body = $this->defaultMail[$mailid]->altbody;
}
$this->setFrom($this->defaultMail[$mailid]->fromemail, $this->defaultMail[$mailid]->fromname);
$this->_addReplyTo($this->defaultMail[$mailid]->replyemail, $this->defaultMail[$mailid]->replyname);
if (!empty($this->defaultMail[$mailid]->attachments)) {
if ($this->config->get('embed_files')) {
foreach ($this->defaultMail[$mailid]->attachments as $attachment) {
$this->addAttachment($attachment->filename);
}
} else {
$attachStringHTML = '<br /><fieldset><legend>' . JText::_('ATTACHMENTS') . '</legend><table>';
$attachStringText = "\n" . "\n" . '------- ' . JText::_('ATTACHMENTS') . ' -------';
foreach ($this->defaultMail[$mailid]->attachments as $attachment) {
$attachStringHTML .= '<tr><td><a href="' . $attachment->url . '" target="_blank">' . $attachment->name . '</a></td></tr>';
$attachStringText .= "\n" . '-- ' . $attachment->name . ' ( ' . $attachment->url . ' )';
}
$attachStringHTML .= '</table></fieldset>';
if ($this->sendHTML) {
$this->Body .= $attachStringHTML;
if (!empty($this->AltBody)) {
$this->AltBody .= "\n" . $attachStringText;
}
} else {
$this->Body .= $attachStringText;
}
}
}
if (!empty($this->parameters)) {
$this->generateAllParams();
$keysparams = array_keys($this->parameters);
$this->Subject = str_replace($keysparams, $this->parameters, $this->Subject);
$this->Body = str_replace($keysparams, $this->parameters, $this->Body);
if (!empty($this->AltBody)) {
$this->AltBody = str_replace($keysparams, $this->parameters, $this->AltBody);
}
if (!empty($this->From)) {
str_replace($keysparams, $this->parameters, $this->From);
}
if (!empty($this->FromName)) {
str_replace($keysparams, $this->parameters, $this->FromName);
}
if (!empty($this->ReplyTo)) {
foreach ($this->ReplyTo as $i => $replyto) {
foreach ($replyto as $a => $oneval) {
$this->ReplyTo[$i][$a] = str_replace($keysparams, $this->parameters, $this->ReplyTo[$i][$a]);
}
}
}
}
if (!empty($this->introtext)) {
$this->Body = $this->introtext . $this->Body;
$this->AltBody = $this->textVersion($this->introtext) . $this->AltBody;
}
$this->body =& $this->Body;
$this->altbody =& $this->AltBody;
$this->subject =& $this->Subject;
$this->from =& $this->From;
$this->fromName =& $this->FromName;
$this->replyto =& $this->ReplyTo;
$this->replyname = $this->defaultMail[$mailid]->replyname;
$this->replyemail = $this->defaultMail[$mailid]->replyemail;
$this->mailid = $this->defaultMail[$mailid]->mailid;
$this->key = $this->defaultMail[$mailid]->key;
$this->alias = $this->defaultMail[$mailid]->alias;
$this->type = $this->defaultMail[$mailid]->type;
$this->tempid = $this->defaultMail[$mailid]->tempid;
$this->sentby = $this->defaultMail[$mailid]->sentby;
$this->userid = $this->defaultMail[$mailid]->userid;
$this->filter = $this->defaultMail[$mailid]->filter;
$this->template = @$this->defaultMail[$mailid]->template;
$this->language = @$this->defaultMail[$mailid]->language;
$this->favicon = @$this->defaultMail[$mailid]->favicon;
if (empty($receiver->key) && !empty($receiver->subid)) {
$receiver->key = acymailing_generateKey(14);
$db = JFactory::getDBO();
$db->setQuery('UPDATE ' . acymailing_table('subscriber') . ' SET `key`= ' . $db->Quote($receiver->key) . ' WHERE subid = ' . (int) $receiver->subid . ' LIMIT 1');
$db->query();
}
$this->dispatcher->trigger('acymailing_replaceusertags', array(&$this, &$receiver, true));
if ($this->sendHTML) {
if (!empty($this->AltBody)) {
$this->AltBody = $this->textVersion($this->AltBody, false);
}
} else {
$this->Body = $this->textVersion($this->Body, false);
}
$status = $this->send();
if ($this->trackEmail) {
$helperQueue = acymailing_get('helper.queue');
$statsAdd = array();
$statsAdd[$this->mailid][$status][$this->sendHTML][] = $receiver->subid;
$helperQueue->statsAdd($statsAdd);
$this->trackEmail = false;
}
return $status;
}
function saveastmpl()
{
$tmplClass = acymailing_get('class.template');
$newTmpl = new stdClass();
$formData = JRequest::getVar('data', array(), '', 'array');
if (!empty($formData['mail']['tempid'])) {
$template = $tmplClass->get($formData['mail']['tempid']);
$newTmpl->styles = $template->styles;
$newTmpl->stylesheet = $template->stylesheet;
$newTmpl->category = $template->category;
}
if (!empty($formData['mail']['subject'])) {
$formData['mail']['subject'] = str_replace(chr(226) . chr(128) . chr(168), '', $formData['mail']['subject']);
$newTmpl->subject = strip_tags($formData['mail']['subject']);
$newTmpl->name = strip_tags($formData['mail']['subject']);
}
$newTmpl->body = JRequest::getVar('editor_body', '', '', 'string', JREQUEST_ALLOWRAW);
if (ACYMAILING_J25) {
$newTmpl->body = JComponentHelper::filterText($newTmpl->body);
}
$acypluginsHelper = acymailing_get('helper.acyplugins');
$acypluginsHelper->cleanHtml($newTmpl->body);
if (!empty($formData['mail']['thumb']) && $formData['mail']['thumb'] == 'delete') {
$newTmpl->thumb = null;
} elseif (!empty($formData['mail']['thumb'])) {
$newTmpl->thumb = strip_tags($formData['mail']['thumb']);
} else {
$mailid = acymailing_getCID('mailid');
if (!empty($mailid)) {
$mail = $this->get($mailid);
$newTmpl->thumb = $mail->thumb;
}
}
if (!empty($formData['mail']['altbody'])) {
$newTmpl->altbody = strip_tags($formData['mail']['altbody']);
}
if (!empty($formData['mail']['fromname'])) {
$newTmpl->fromname = strip_tags($formData['mail']['fromname']);
}
if (!empty($formData['mail']['fromemail'])) {
$newTmpl->fromemail = strip_tags($formData['mail']['fromemail']);
}
if (!empty($formData['mail']['replyname'])) {
$newTmpl->replyname = strip_tags($formData['mail']['replyname']);
}
if (!empty($formData['mail']['replyemail'])) {
$newTmpl->replyemail = strip_tags($formData['mail']['replyemail']);
}
if (!empty($formData['mail']['summary'])) {
$newTmpl->description = strip_tags($formData['mail']['summary']);
}
$newTmpl->ordering = 1;
$tempid = $tmplClass->save($newTmpl);
if (!empty($tempid)) {
$formData['mail']['tempid'] = $tempid;
acymailing_enqueueMessage(JText::_('ACY_SAVEASTMPL_VALID'), 'message');
} else {
acymailing_enqueueMessage(JText::_('ERROR_SAVING'), 'error');
}
return true;
}
function complete_abtest()
{
$mailid = JRequest::getInt('mailToSend');
$mailClass = acymailing_get('class.mail');
$newMailid = $mailClass->complete_abtest('manual', $mailid);
$finalMail = $mailClass->get($newMailid);
acymailing_enqueueMessage(JText::sprintf('ABTESTING_FINALSEND', $finalMail->subject), 'info');
JRequest::setVar('validationStatus', 'abTestFinalSend');
$this->abtesting();
}
public function createFolder()
{
JRequest::checkToken() or die('Invalid Token to create folder');
$folderName = str_replace(array('.', '-'), array('', '_'), strtolower(JRequest::getCmd('subFolderName')));
if (empty($folderName)) {
$this->browse();
return false;
}
$directoryPath = JRequest::getString('acy_media_browser_files_path') . '/' . $folderName;
$mediaFolders = acymailing_getFilesFolder('media', true);
$allowed = false;
foreach ($mediaFolders as $oneMedia) {
if (preg_match('#^' . preg_quote($oneMedia) . '[a-z_0-9\\-/]*$#i', $directoryPath)) {
$allowed = true;
break;
}
}
if (!$allowed) {
acymailing_enqueueMessage('You are not allowed to create this folder', 'error');
$this->browse();
return false;
}
$directoryPath = str_replace('/', DS, $directoryPath);
if (JFolder::exists(ACYMAILING_ROOT . $directoryPath)) {
acymailing_enqueueMessage(JText::_('FOLDER_ALREADY_EXISTS'), 'warning');
$this->browse();
return false;
}
if (!JFolder::create(ACYMAILING_ROOT . $directoryPath)) {
acymailing_enqueueMessage(JText::sprintf('WRITABLE_FOLDER', substr(ACYMAILING_ROOT . $directoryPath, 0, strrpos(ACYMAILING_ROOT . $directoryPath, DS)), 'error'));
$this->browse();
return false;
}
JRequest::setVar('selected_folder', JRequest::getString('acy_media_browser_files_path') . '/' . $folderName);
$this->browse();
}
function language()
{
$this->setLayout('default');
$code = JRequest::getCmd('code');
if (empty($code)) {
acymailing_display('Code not specified', 'error');
return;
}
$file = new stdClass();
$file->name = $code;
$path = JLanguage::getLanguagePath(JPATH_ROOT) . DS . $code . DS . $code . '.com_acymailing.ini';
$file->path = $path;
jimport('joomla.filesystem.file');
$showLatest = true;
$loadLatest = false;
if (JFile::exists($path)) {
$file->content = JFile::read($path);
if (empty($file->content)) {
acymailing_display('File not found : ' . $path, 'error');
}
} else {
$loadLatest = true;
acymailing_enqueueMessage(JText::_('LOAD_ENGLISH_1') . '<br />' . JText::_('LOAD_ENGLISH_2') . '<br />' . JText::_('LOAD_ENGLISH_3'), 'info');
$file->content = JFile::read(JLanguage::getLanguagePath(JPATH_ROOT) . DS . 'en-GB' . DS . 'en-GB.com_acymailing.ini');
}
$custompath = JLanguage::getLanguagePath(JPATH_ROOT) . DS . $code . DS . $code . '.com_acymailing_custom.ini';
if (JFile::exists($custompath)) {
$file->customcontent = JFile::read($custompath);
}
if ($loadLatest or JRequest::getCmd('task') == 'latest') {
if (file_exists(JPATH_ROOT . DS . 'language' . DS . $code)) {
$doc = JFactory::getDocument();
$doc->addScript(ACYMAILING_UPDATEURL . 'languageload&code=' . JRequest::getCmd('code'));
} else {
acymailing_enqueueMessage('The specified language "' . htmlspecialchars($code, ENT_COMPAT, 'UTF-8') . '" is not installed on your site', 'warning');
}
$showLatest = false;
} elseif (JRequest::getCmd('task') == 'save') {
$showLatest = false;
}
if (JRequest::getString('tmpl') == 'component') {
$acyToolbar = acymailing::get('helper.toolbar');
$acyToolbar->save();
$acyToolbar->custom('share', JText::_('SHARE'), 'share', false);
$acyToolbar->setTitle(JText::_('ACY_FILE') . ' : ' . $this->escape($file->name));
$acyToolbar->topfixed = false;
$acyToolbar->display();
}
$this->assignRef('showLatest', $showLatest);
$this->assignRef('file', $file);
}
function save()
{
$pkey = $this->pkey;
$cid = JRequest::getVar('cid', array(), 'post', 'array');
$order = JRequest::getVar('order', array(), 'post', 'array');
JArrayHelper::toInteger($cid);
$database = JFactory::getDBO();
$query = 'SELECT `ordering`,`' . $pkey . '` FROM ' . acymailing_table($this->table) . ' WHERE `' . $pkey . '` NOT IN (' . implode(',', $cid) . ') ';
if (!empty($this->groupMap)) {
$query .= ' AND ' . $this->groupMap . ' = ' . $database->Quote($this->groupVal);
}
$query .= ' ORDER BY `ordering` ASC';
$database->setQuery($query);
$results = $database->loadObjectList($pkey);
$oldResults = $results;
asort($order);
$newOrder = array();
while (!empty($order) or !empty($results)) {
$dbElement = reset($results);
if (empty($dbElement->ordering) or !empty($order) and reset($order) <= $dbElement->ordering) {
$newOrder[] = $cid[(int) key($order)];
unset($order[key($order)]);
} else {
$newOrder[] = $dbElement->{$pkey};
unset($results[$dbElement->{$pkey}]);
}
}
$i = 1;
$status = true;
$element = new stdClass();
foreach ($newOrder as $val) {
$element->{$pkey} = $val;
$element->ordering = $i;
if (!isset($oldResults[$val]) or $oldResults[$val]->ordering != $i) {
$status = $database->updateObject(acymailing_table($this->table), $element, $pkey) && $status;
}
$i++;
}
if ($status) {
acymailing_enqueueMessage(JText::_('ACY_NEW_ORDERING_SAVED'), 'message');
} else {
acymailing_enqueueMessage(JText::_('ERROR_ORDERING'), 'error');
}
return $status;
}
function test()
{
if (!$this->isAllowed($this->aclCat, 'manage')) {
return;
}
$this->store();
$tempid = acymailing_getCID('tempid');
$test_selection = JRequest::getVar('test_selection', '', '', 'string');
if (empty($tempid) or empty($test_selection)) {
return;
}
$mailer = acymailing_get('helper.mailer');
$mailer->report = true;
$config = acymailing_config();
$subscriberClass = acymailing_get('class.subscriber');
$userHelper = acymailing_get('helper.user');
JPluginHelper::importPlugin('acymailing');
$dispatcher = JDispatcher::getInstance();
$receivers = array();
if ($test_selection == 'users') {
$receiverEntry = JRequest::getVar('test_emails', '', '', 'string');
if (!empty($receiverEntry)) {
if (substr_count($receiverEntry, '@') > 1) {
$receivers = explode(',', trim(preg_replace('# +#', '', $receiverEntry)));
} else {
$receivers[] = trim($receiverEntry);
}
}
} else {
$gid = JRequest::getInt('test_group', '-1');
if ($gid == -1) {
return false;
}
$db = JFactory::getDBO();
if (!ACYMAILING_J16) {
$db->setQuery('SELECT email FROM ' . acymailing_table('users', false) . ' WHERE gid = ' . intval($gid));
} else {
$db->setQuery('SELECT u.email FROM ' . acymailing_table('users', false) . ' AS u JOIN ' . acymailing_table('user_usergroup_map', false) . ' AS ugm ON u.id = ugm.user_id WHERE ugm.group_id = ' . intval($gid));
}
$receivers = acymailing_loadResultArray($db);
}
if (empty($receivers)) {
acymailing_enqueueMessage(JText::_('NO_SUBSCRIBER'), 'notice');
return $this->edit();
}
$classTemplate = acymailing_get('class.template');
$myTemplate = $classTemplate->get($tempid);
$myTemplate->sendHTML = 1;
$myTemplate->mailid = 0;
$myTemplate->template = $myTemplate;
if (empty($myTemplate->subject)) {
$myTemplate->subject = $myTemplate->name;
}
if (empty($myTemplate->altBody)) {
$myTemplate->altbody = $mailer->textVersion($myTemplate->body);
}
$dispatcher->trigger('acymailing_replacetags', array(&$myTemplate, true));
$myTemplate->body = acymailing_absoluteURL($myTemplate->body);
$result = true;
foreach ($receivers as $receiveremail) {
$copy = $myTemplate;
$mailer->clearAll();
$mailer->setFrom($copy->fromemail, $copy->fromname);
if (!empty($copy->replyemail)) {
$replyToName = $config->get('add_names', true) ? $mailer->cleanText($copy->replyname) : '';
$mailer->AddReplyTo($mailer->cleanText($copy->replyemail), $replyToName);
}
$receiver = $subscriberClass->get($receiveremail);
if (empty($receiver->subid)) {
if ($userHelper->validEmail($receiveremail)) {
$newUser = new stdClass();
$newUser->email = $receiveremail;
$subscriberClass->sendConf = false;
$subid = $subscriberClass->save($newUser);
$receiver = $subscriberClass->get($subid);
}
if (empty($receiver->subid)) {
continue;
}
}
$addedName = $config->get('add_names', true) ? $mailer->cleanText($receiver->name) : '';
$mailer->AddAddress($mailer->cleanText($receiver->email), $addedName);
$dispatcher->trigger('acymailing_replaceusertags', array(&$copy, &$receiver, true));
$mailer->isHTML(true);
$mailer->Body = $copy->body;
$mailer->Subject = $copy->subject;
if ($config->get('multiple_part', false)) {
$mailer->AltBody = $copy->altbody;
}
$mailer->send();
}
return $this->edit();
}
function remove()
{
JRequest::checkToken() or die('Invalid Token');
$app = JFactory::getApplication();
$config = acymailing_config();
$deleteBehaviour = $config->get('frontend_delete_button', 'delete');
$subscriberIds = JRequest::getVar('cid', array(), '', 'array');
if ($app->isAdmin() || $deleteBehaviour == 'delete') {
if (!$this->isAllowed('subscriber', 'delete')) {
return;
}
$subscriberObject = acymailing_get('class.subscriber');
$num = $subscriberObject->delete($subscriberIds);
acymailing_enqueueMessage(JText::sprintf('SUCC_DELETE_ELEMENTS', $num), 'message');
} else {
if (!$this->isAllowed('subscriber', 'manage')) {
return;
}
$listId = JRequest::getInt('filter_lists', 0);
if (empty($listId)) {
acymailing_enqueueMessage('List not found', 'error');
} else {
$listsubClass = acymailing_get('class.listsub');
foreach ($subscriberIds as $subid) {
$listsubClass->removeSubscription($subid, array($listId));
}
$listClass = acymailing_get('class.list');
$list = $listClass->get($listId);
acymailing_enqueueMessage(JText::sprintf('IMPORT_REMOVE', count($subscriberIds), $list->name), 'message');
}
}
JRequest::setVar('layout', 'listing');
return parent::display();
}
function display($tpl = null)
{
JHTML::_('behavior.modal', 'a.modal');
$toggleClass = acymailing_get('helper.toggle');
$config = acymailing_config();
$db = JFactory::getDBO();
$doc = JFactory::getDocument();
$app = JFactory::getApplication();
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.file');
$lg = JFactory::getLanguage();
$language = $lg->getTag();
$styleRemind = 'float:right;margin-right:30px;position:relative;';
$loadLink = '<a onclick="window.document.getElementById(\'acymailing_messages_warning\').style.display = \'none\';return true;" class="modal" rel="{handler: \'iframe\', size:{x:800, y:500}}" href="index.php?option=com_acymailing&tmpl=component&ctrl=file&task=latest&code=' . $language . '">' . JText::_('LOAD_LATEST_LANGUAGE') . '</a>';
if (!file_exists(ACYMAILING_ROOT . 'language' . DS . $language . DS . $language . '.com_acymailing.ini')) {
if ($config->get('errorlanguagemissing', 1)) {
$notremind = '<small style="' . $styleRemind . '">' . $toggleClass->delete('acymailing_messages_warning', 'errorlanguagemissing_0', 'config', false, JText::_('DONT_REMIND')) . '</small>';
acymailing_enqueueMessage(JText::_('MISSING_LANGUAGE') . ' ' . $loadLink . ' ' . $notremind, 'warning');
}
} elseif (version_compare(JText::_('ACY_LANG_VERSION'), $config->get('version'), '<')) {
if ($config->get('errorlanguageupdate', 1)) {
$notremind = '<small style="' . $styleRemind . '">' . $toggleClass->delete('acymailing_messages_warning', 'errorlanguageupdate_0', 'config', false, JText::_('DONT_REMIND')) . '</small>';
acymailing_enqueueMessage(JText::_('UPDATE_LANGUAGE') . ' ' . $loadLink . ' ' . $notremind, 'warning');
}
}
if (ACYMAILING_J30 && $app->getTemplate() == 'hathor') {
if ($config->get('errortemplatenotisis', 1)) {
$message = ' You can change the default Back-end template <a href="index.php?option=com_templates&view=styles">Here</a> or change your personnal default Back-end template by editing your user profile <a href="index.php?option=com_users&view=users">Here</a>, tab "Basic Settings".';
$personalTemplate = JFactory::getUser()->getParam('admin_style');
if (!empty($personalTemplate)) {
$message = ' You can change your personnal default Back-end template by editing your user profile <a href="index.php?option=com_users&view=users">Here</a>, tab "Basic Settings".';
}
$notremind = '<small style="' . $styleRemind . '">' . $toggleClass->delete('acymailing_messages_warning', 'errortemplatenotisis_0', 'config', false, JText::_('DONT_REMIND')) . '</small>';
acymailing_enqueueMessage('You should rather use the isis template in the Back-End which suits more AcyMailing.' . $message . $notremind, 'warning');
}
}
$indexes = array('listsub', 'stats', 'list', 'mail', 'userstats', 'urlclick', 'history', 'template', 'queue', 'subscriber');
$addIndexes = array('We recenty optimized our database...');
foreach ($indexes as $oneTable) {
if ($config->get('optimize_' . $oneTable, 1)) {
continue;
}
$addIndexes[] = 'Please ' . $toggleClass->toggleText('addindex', $oneTable, 'config', 'click here') . ' to add indexes on the ' . $oneTable . ' table';
}
if (count($addIndexes) > 1) {
acymailing_enqueueMessage($addIndexes, 'warning');
}
$acyToolbar = acymailing::get('helper.toolbar');
$acyToolbar->custom('test', JText::_('SEND_TEST'), 'send', false);
$acyToolbar->divider();
$acyToolbar->addButtonOption('apply', JText::_('ACY_APPLY'), 'apply', false);
$acyToolbar->save();
$acyToolbar->cancel();
$acyToolbar->divider();
$acyToolbar->help('config');
$acyToolbar->setTitle(JText::_('ACY_CONFIGURATION'), 'cpanel');
$acyToolbar->display();
$elements = new stdClass();
$elements->add_names = JHTML::_('acyselect.booleanlist', "config[add_names]", '', $config->get('add_names', true));
$elements->embed_images = JHTML::_('acyselect.booleanlist', "config[embed_images]", '', $config->get('embed_images', 0));
$elements->embed_files = JHTML::_('acyselect.booleanlist', "config[embed_files]", '', $config->get('embed_files', 1));
$elements->multiple_part = JHTML::_('acyselect.booleanlist', "config[multiple_part]", '', $config->get('multiple_part', 0));
$mailerMethods = array('elasticemail', 'smtp', 'sendmail');
$js = "function updateMailer(mailermethod){" . "\n";
foreach ($mailerMethods as $oneMethod) {
$js .= " window.document.getElementById('" . $oneMethod . "_config').style.display = 'none'; " . "\n";
}
$js .= "if(window.document.getElementById(mailermethod+'_config')) {window.document.getElementById(mailermethod+'_config').style.display = 'block';} }";
$js .= 'window.addEvent(\'domready\', function(){ updateMailer(\'' . $config->get('mailer_method', 'phpmail') . '\'); });';
$doc->addScriptDeclaration($js);
$encodingval = array();
$encodingval[] = JHTML::_('select.option', 'binary', 'Binary');
$encodingval[] = JHTML::_('select.option', 'quoted-printable', 'Quoted-printable');
$encodingval[] = JHTML::_('select.option', '7bit', '7 Bit');
$encodingval[] = JHTML::_('select.option', '8bit', '8 Bit');
$encodingval[] = JHTML::_('select.option', 'base64', 'Base 64');
$elements->encoding_format = JHTML::_('select.genericlist', $encodingval, "config[encoding_format]", 'size="1" style="width:150px;"', 'value', 'text', $config->get('encoding_format', 'base64'));
$charset = acymailing_get('type.charset');
$elements->charset = $charset->display("config[charset]", $config->get('charset', 'UTF-8'));
$securedVals = array();
$securedVals[] = JHTML::_('select.option', '', '- - -');
$securedVals[] = JHTML::_('select.option', 'ssl', 'SSL');
$securedVals[] = JHTML::_('select.option', 'tls', 'TLS');
$elements->smtp_secured = JHTML::_('select.genericlist', $securedVals, "config[smtp_secured]", 'size="1" style="width:100px;"', 'value', 'text', $config->get('smtp_secured'));
$elements->smtp_auth = JHTML::_('acyselect.booleanlist', "config[smtp_auth]", '', $config->get('smtp_auth', 0));
$elements->smtp_keepalive = JHTML::_('acyselect.booleanlist', "config[smtp_keepalive]", '', $config->get('smtp_keepalive', 1));
$elements->allow_visitor = JHTML::_('acyselect.booleanlist', "config[allow_visitor]", '', $config->get('allow_visitor', 1));
$editorType = acymailing_get('type.editor');
$elements->editor = $editorType->display('config[editor]', $config->get('editor'));
$elements->subscription_message = JHTML::_('acyselect.booleanlist', "config[subscription_message]", '', $config->get('subscription_message', 1));
$elements->confirmation_message = JHTML::_('acyselect.booleanlist', "config[confirmation_message]", '', $config->get('confirmation_message', 1));
$elements->unsubscription_message = JHTML::_('acyselect.booleanlist', "config[unsubscription_message]", '', $config->get('unsubscription_message', 1));
$elements->welcome_message = JHTML::_('acyselect.booleanlist', "config[welcome_message]", '', $config->get('welcome_message', 1));
$elements->unsub_message = JHTML::_('acyselect.booleanlist', "config[unsub_message]", '', $config->get('unsub_message', 1));
$elements->confirm_message = JHTML::_('acyselect.booleanlist', "config[confirm_message]", '', $config->get('confirm_message', 0));
if (acymailing_level(1)) {
$forwardValues = array();
$forwardValues[] = JHTML::_('select.option', 0, JTEXT::_('JOOMEXT_NO'));
$forwardValues[] = JHTML::_('select.option', 1, JTEXT::_('JOOMEXT_YES'));
$forwardValues[] = JHTML::_('select.option', 2, JTEXT::_('JOOMEXT_YES_FORWARD'));
$elements->forward = JHTML::_('acyselect.radiolist', $forwardValues, "config[forward]", '', 'value', 'text', $config->get('forward', 0));
} else {
$elements->forward = acymailing_getUpgradeLink('essential');
}
if (acymailing_level(1)) {
$js = "function updateDKIM(dkimval){\n\t\t\t\t\t\tif(dkimval == 1){document.getElementById('dkim_config').style.display = 'block';}\n\t\t\t\t\t\telse{document.getElementById('dkim_config').style.display = 'none';}\n\t\t\t\t\t\t};";
$doc->addScriptDeclaration($js);
if (function_exists('openssl_sign')) {
$elements->dkim = JHTML::_('acyselect.booleanlist', "config[dkim]", 'onclick="updateDKIM(this.value)"', $config->get('dkim', 0));
} else {
$elements->dkim = '<input type="hidden" name="config[dkim]" value="0" />PHP Extension openssl not enabled';
}
$js = "function updateQueueProcess(newvalue){";
$js .= "if(newvalue == 'onlyauto') {window.document.getElementById('method_auto').style.display = ''; window.document.getElementById('method_manual').style.display = 'none';}";
$js .= "if(newvalue == 'auto') {window.document.getElementById('method_auto').style.display = ''; window.document.getElementById('method_manual').style.display = '';}";
$js .= "if(newvalue == 'manual') {window.document.getElementById('method_auto').style.display = 'none'; window.document.getElementById('method_manual').style.display = '';}";
$js .= '};';
$doc->addScriptDeclaration($js);
$queueType = array();
$queueType[] = JHTML::_('select.option', 'onlyauto', JText::_('AUTO_ONLY'));
$queueType[] = JHTML::_('select.option', 'auto', JText::_('AUTO_MAN'));
$queueType[] = JHTML::_('select.option', 'manual', JText::_('MANUAL_ONLY'));
$elements->queue_type = JHTML::_('acyselect.radiolist', $queueType, "config[queue_type]", 'onclick="updateQueueProcess(this.value);"', 'value', 'text', $config->get('queue_type', 'auto'));
} else {
$elements->dkim = acymailing_getUpgradeLink('essential');
}
$js = 'var selectedHTTPS = ' . ($config->get('ssl_links', 0) == 0 ? 'false;' : 'true;') . '
function confirmHTTPS(element){
var clickedHTTPS = (element == 1);
if(clickedHTTPS == selectedHTTPS) return true;
if(clickedHTTPS){
var cnfrm = confirm(\'' . str_replace("'", "\\'", JText::_('ACY_SSLCHOICE_CONFIRMATION')) . '\');
if(!cnfrm){';
if (ACYMAILING_J30) {
$js .= 'var labels = document.getElementById(\'config_ssl_linksfieldset\').getElementsByTagName(\'label\');
if(labels[0].hasClass(\'btn-success\')){
labels[1].click();
return true;
}else{
labels[0].click();
return true;
}';
} else {
$js .= 'return false;';
}
$js .= '}
}
selectedHTTPS = clickedHTTPS;
return true;
}';
$doc->addScriptDeclaration($js);
$elements->ssl_links = JHTML::_('acyselect.booleanlist', "config[ssl_links]", 'onclick="return confirmHTTPS(this.value);"', $config->get('ssl_links', 0));
$delayTypeManual = acymailing_get('type.delay');
$elements->queue_pause = $delayTypeManual->display('config[queue_pause]', $config->get('queue_pause'), 0);
$delayTypeAuto = acymailing_get('type.delay');
$delayTypeAuto->onChange = "window.document.getElementById('autoFrequencyWarning').style.display='inline';";
$onChangeMsg = '<span style="display:none;color:red;" id="autoFrequencyWarning">' . JText::_('ACY_CRON_CHANGE_FREQUENCY_WARNING') . '</span>';
$elements->cron_frequency = $delayTypeAuto->display('config[cron_frequency]', $config->get('cron_frequency'), 2) . $onChangeMsg;
$js = "function detectTimeout(id){\n\t\t\t\ttry{\n\t\t\t\t\twindow.document.getElementById(id).className = 'onload';\n\t\t\t\t\twindow.document.getElementById(id).innerHTML = '" . str_replace("'", "\\'", JText::_('ACY_CLOSE_TIMEOUT')) . "';\n\n\t\t\t\t\ttry{\n\t\t\t\t\t\tnew Ajax('" . rtrim(JURI::root(), '/') . "/index.php?option=com_acymailing&tmpl=component&ctrl=stats&task=detecttimeout&seckey=" . $config->get('security_key') . "',{ method: 'get', onComplete: function() { document.id(id).innerHTML = 'Done!'; window.document.getElementById(id).className = 'loading'; }}).request();\n\t\t\t\t\t}catch(err){\n\t\t\t\t\t\tnew Request({url:'" . rtrim(JURI::root(), '/') . "/index.php?option=com_acymailing&tmpl=component&ctrl=stats&task=detecttimeout&seckey=" . $config->get('security_key') . "',method: 'get', onComplete: function(response) { document.id(id).innerHTML = 'Done!'; window.document.getElementById(id).className = 'loading'; }}).send();\n\t\t\t\t\t}\n\t\t\t\t}catch(err){alert('Could not load the max execution time value : '+err);}\n\t\t\t\treturn;\n\t\t}";
$maxexecutiontime = $config->get('max_execution_time');
if (empty($maxexecutiontime) && intval($config->get('last_maxexec_check')) < time() - 60) {
$js .= 'window.addEvent(\'domready\', function(){ detectTimeout(\'timeoutcheck\');return; });';
}
$doc = JFactory::getDocument();
$doc->addScriptDeclaration($js);
$cssval = array('css_frontend' => 'component', 'css_module' => 'module', 'css_backend' => 'backend');
foreach ($cssval as $configval => $type) {
$myvals = array();
$myvals[] = JHTML::_('select.option', '', JText::_('ACY_NONE'));
if ($configval == 'css_backend') {
$myvals[] = JHTML::_('select.option', 'backend_custom', JText::_('ACY_CUSTOM'));
$editFileName = $config->get('css_backend', 'default');
} else {
$regex = '^' . $type . '_([-_a-z0-9]*)\\.css$';
$allCSSFiles = JFolder::files(ACYMAILING_MEDIA . 'css', $regex);
$family = '';
foreach ($allCSSFiles as $oneFile) {
preg_match('#' . $regex . '#i', $oneFile, $results);
$fileName = str_replace('default_', '', $results[1]);
$fileNameArray = explode('_', $fileName);
if (count($fileNameArray) == 2) {
if ($fileNameArray[0] != $family) {
if (!empty($family)) {
$myvals[] = JHTML::_('select.option', '</OPTGROUP>');
}
$family = $fileNameArray[0];
$myvals[] = JHTML::_('select.option', '<OPTGROUP>', ucfirst($family));
}
unset($fileNameArray[0]);
$fileName = implode('_', $fileNameArray);
}
$fileName = ucwords(str_replace('_', ' ', $fileName));
$myvals[] = JHTML::_('select.option', $results[1], $fileName);
}
if (!empty($family)) {
$myvals[] = JHTML::_('select.option', '</OPTGROUP>');
}
$editFileName = $type . '_' . $config->get($configval, 'default');
}
$currentVal = $config->get($configval, 'default');
$aStyle = empty($currentVal) ? 'style="display:none"' : '';
$js = 'onchange="updateCSSLink(\'' . $configval . '\',\'' . $type . '\',this.value);"';
$elements->{$configval} = JHTML::_('select.genericlist', $myvals, 'config[' . $configval . ']', 'class="inputbox" size="1" ' . $js, 'value', 'text', $config->get($configval, 'default'), $configval . '_choice');
$linkEdit = 'index.php?option=com_acymailing&tmpl=component&ctrl=file&task=css&var=' . $configval . '&file=' . $editFileName;
$elements->{$configval} .= ' <a id="' . $configval . '_link" ' . $aStyle . ' class="modal" title="' . JText::_('ACY_EDIT', true) . '" href="' . $linkEdit . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><i class="acyicon-edit" style="margin: 5px 5px 0px 5px; display: inline-block;"></i></a>';
}
$js = "function updateCSSLink(myid,type,newval){\n\t\t\tif(newval){document.getElementById(myid+'_link').style.display = '';}else{document.getElementById(myid+'_link').style.display = 'none'}\n\t\t\tif(myid == 'css_backend') filename = newval;\n\t\t\telse filename = type+'_'+newval;\n\t\t\tdocument.getElementById(myid+'_link').href = 'index.php?option=com_acymailing&tmpl=component&ctrl=file&task=css&var='+myid+'&file='+filename;\n\t\t}";
$doc->addScriptDeclaration($js);
$bootstrapFrontValues = array();
$bootstrapFrontValues[] = JHTML::_('select.option', 0, JTEXT::_('JOOMEXT_NO'));
$bootstrapFrontValues[] = JHTML::_('select.option', 1, 'Bootstrap 2');
$bootstrapFrontValues[] = JHTML::_('select.option', 2, 'Bootstrap 3');
$elements->bootstrap_frontend = JHTML::_('acyselect.radiolist', $bootstrapFrontValues, "config[bootstrap_frontend]", '', 'value', 'text', $config->get('bootstrap_frontend', 0));
$elements->colortype = acymailing_get('type.color');
$elements->use_sef = JHTML::_('acyselect.booleanlist', "config[use_sef]", '', $config->get('use_sef', 0));
if (acymailing_level(1)) {
$trackingMode = $config->get('trackingsystem', 'acymailing');
$tracking_system = '<input type="checkbox" name="config[trackingsystem][]" id="trackingsystem[0]" value="acymailing" style="margin-left:10px" ' . (stripos($trackingMode, 'acymailing') !== false ? 'checked="checked"' : '') . '/> <label for="trackingsystem[0]">Acymailing</label>';
$tracking_system .= '<input type="checkbox" name="config[trackingsystem][]" id="trackingsystem[1]" value="google" style="margin-left:10px;" ' . (stripos($trackingMode, 'google') !== false ? 'checked="checked"' : '') . '/> <label for="trackingsystem[1]">Google Analytics</label>';
$tracking_system .= '<input type="hidden" name="config[trackingsystem][]" value="1"/>';
$tracking_system_external_website = JHTML::_('acyselect.booleanlist', "config[trackingsystemexternalwebsite]", ' id="trackingsystemexternalwebsite"', $config->get('trackingsystemexternalwebsite', 1));
} else {
$tracking_system = acymailing_getUpgradeLink('essential');
$tracking_system_external_website = acymailing_getUpgradeLink('essential');
}
$elements->tracking_system = $tracking_system;
$elements->tracking_system_external_website = $tracking_system_external_website;
$indexType = $config->get('indexFollow', '');
$indexFollow = '<div style="float: left;"><input type="checkbox" name="config[indexFollow][]" id="indexFollow[0]" value="noindex" style="margin-left:10px" ' . (stripos($indexType, 'noindex') !== false ? 'checked="checked"' : '') . '/> <label for="indexFollow[0]">noindex</label></div>';
$indexFollow .= '<div style="float: left;"><input type="checkbox" name="config[indexFollow][]" id="indexFollow[1]" value="nofollow" style="margin-left:10px" ' . (stripos($indexType, 'nofollow') !== false ? 'checked="checked"' : '') . '/> <label for="indexFollow[1]">nofollow</label></div>';
$indexFollow .= '<input type="hidden" name="config[indexFollow][]" value="1"/>';
$elements->indexFollow = $indexFollow;
if (acymailing_level(3)) {
$geolocAvailable = true;
$geolocation = '<input type="hidden" name="config[geolocation]" value="0"/>';
$geoloc_api_key = '';
if (!function_exists('curl_init')) {
$geolocAvailable = false;
$geolocation .= 'The AcyMailing geolocation plugin needs the CURL library installed but it seems that it is not available on your server. Please contact your web hosting to set it up.';
}
if (!function_exists('json_decode')) {
if (!$geolocAvailable) {
$geolocation .= '<br />';
}
$geolocAvailable = false;
$geolocation .= 'The AcyMailing geolocation plugin can only work with PHP 5.2 at least. Please ask your web hosting to update your PHP version.';
}
if ($geolocAvailable) {
$geoloc = $config->get('geolocation', '');
$geolocation = '<span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_0" value="creation" style="margin-left:10px" ' . (stripos($geoloc, 'creation') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_0">' . JText::_('ON_USER_CREATE') . '</label></span>';
$geolocation .= ' <span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_1" value="modify" style="margin-left:10px;" ' . (stripos($geoloc, 'modify') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_1">' . JText::_('ON_USER_CHANGE') . '</label></span>';
$geolocation .= ' <span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_2" value="confirm" style="margin-left:10px;" ' . (stripos($geoloc, 'confirm') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_2">' . JText::_('GEOLOC_CONFIRM_SUB') . '</label></span>';
$geolocation .= ' <span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_3" value="clic" style="margin-left:10px;" ' . (stripos($geoloc, 'clic') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_3">' . JText::_('ON_USER_CLICK') . '</label></span>';
$geolocation .= ' <span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_4" value="open" style="margin-left:10px;" ' . (stripos($geoloc, 'open') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_4">' . JText::_('ON_OPEN_NEWS') . '</label></span>';
$geolocation .= ' <span style="white-space:nowrap"><input type="checkbox" name="config[geolocation][]" id="geolocation_5" value="unsubscription" style="margin-left:10px;" ' . (stripos($geoloc, 'unsubscription') !== false ? 'checked="checked"' : '') . '/> <label for="geolocation_5">' . JText::_('GEOLOC_UNSUB') . '</label></span>';
$geolocation .= '<input type="hidden" name="config[geolocation][]" value="1"/>';
$geoloc_api_key = '<input class="inputbox" type="text" id="geoloc_api_key" name="config[geoloc_api_key]" style="width:450px" value="' . $this->escape($config->get('geoloc_api_key', '')) . '">';
}
} else {
$geolocation = acymailing_getUpgradeLink('enterprise');
$geoloc_api_key = false;
}
$elements->geolocation = $geolocation;
$elements->geoloc_api_key = $geoloc_api_key;
if (!ACYMAILING_J16) {
$query = 'SELECT a.name, a.id as itemid, b.title FROM `#__menu` as a JOIN `#__menu_types` as b on a.menutype = b.menutype WHERE a.access = 0 ORDER BY b.title ASC,a.ordering ASC';
} else {
$orderby = ACYMAILING_J30 ? 'a.lft' : 'a.ordering';
$query = 'SELECT a.alias as name, a.id as itemid, b.title FROM `#__menu` as a JOIN `#__menu_types` as b on a.menutype = b.menutype WHERE a.access NOT IN (2, 3) AND a.client_id=0 AND a.parent_id != 0 ORDER BY b.title ASC,' . $orderby . ' ASC';
}
$db->setQuery($query);
$joomMenus = $db->loadObjectList();
$menuvalues = array();
$menuvalues[] = JHTML::_('select.option', '0', JText::_('ACY_NONE'));
$lastGroup = '';
foreach ($joomMenus as $oneMenu) {
if ($oneMenu->title != $lastGroup) {
if (!empty($lastGroup)) {
$menuvalues[] = JHTML::_('select.option', '</OPTGROUP>');
}
$menuvalues[] = JHTML::_('select.option', '<OPTGROUP>', $oneMenu->title);
$lastGroup = $oneMenu->title;
}
$menuvalues[] = JHTML::_('select.option', $oneMenu->itemid, $oneMenu->name);
}
$elements->acymailing_menu = JHTML::_('select.genericlist', $menuvalues, 'config[itemid]', 'size="1"', 'value', 'text', $config->get('itemid'));
$acyrss_format = array();
$acyrss_format[] = JHTML::_('select.option', '', JText::_('ACY_NONE'));
$acyrss_format[] = JHTML::_('select.option', 'rss', 'RSS feed');
$acyrss_format[] = JHTML::_('select.option', 'atom', 'Atom feed');
$acyrss_format[] = JHTML::_('select.option', 'both', JText::_('ACY_ALL'));
$elements->acyrss_format = JHTML::_('select.genericlist', $acyrss_format, "config[acyrss_format]", 'size="1"', 'value', 'text', $config->get('acyrss_format', ''));
$acyrss_order = array();
$acyrss_order[] = JHTML::_('select.option', 'senddate', JText::_('SEND_DATE'));
$acyrss_order[] = JHTML::_('select.option', 'mailid', JText::_('ACY_ID'));
$acyrss_order[] = JHTML::_('select.option', 'subject', JText::_('ACY_TITLE'));
$elements->acyrss_order = JHTML::_('select.genericlist', $acyrss_order, "config[acyrss_order]", 'size="1"', 'value', 'text', $config->get('acyrss_order', 'senddate'));
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=confirmation';
$elements->editConfEmail = '<a class="modal" id="confirmemail" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_CONF_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_created';
$elements->edit_notification_created = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_refuse';
$elements->edit_notification_refuse = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_unsuball';
$elements->edit_notification_unsuball = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_unsub';
$elements->edit_notification_unsub = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_contact';
$elements->edit_notification_contact = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_contact_menu';
$elements->edit_notification_contact_menu = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=notification_confirm';
$elements->edit_notification_confirm = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=email&task=edit&mailid=modif';
$elements->editModifEmail = '<a class="modal" id="modifemail" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('EDIT_NOTIFICATION_MAIL') . '</button></a>';
$link = 'index.php?option=com_acymailing&tmpl=component&ctrl=cpanel&task=checkDB';
$elements->checkDB = '<a class="modal" href="' . $link . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><button class="acymailing_button_grey" onclick="return false">' . JText::_('DATABASE_INTEGRITY') . '</button></a>';
$js = "function addUnsubReason(){\n\t\t\tvar input = document.createElement('input');\n\t\t\tinput.name = 'unsub_reasons[]';\n\t\t\tinput.style.width = '300px';\n\t\t\tinput.style.margin = '3px 0px';\n\t\t\tinput.type = 'text';\n\t\t\tdocument.getElementById('unsub_reasons').appendChild(input);\n\t\t\tvar br = document.createElement('br');\n\t\t\tdocument.getElementById('unsub_reasons').appendChild(br);\n\t\t}\n\t\tfunction displaySurvey(surveyval){\n\t\t\tif(surveyval == 1){\n\t\t\t\tdocument.getElementById('unsub_reasons_area').style.display = 'block';\n\t\t\t}else{\n\t\t\t\tdocument.getElementById('unsub_reasons_area').style.display = 'none';\n\t\t\t}\n\t\t}\n\t\t";
$doc->addScriptDeclaration($js);
$path = JLanguage::getLanguagePath(JPATH_ROOT);
$dirs = JFolder::folders($path);
$languages = array();
foreach ($dirs as $dir) {
if (strlen($dir) != 5 || $dir == "xx-XX") {
continue;
}
$xmlFiles = JFolder::files($path . DS . $dir, '^([-_A-Za-z]*)\\.xml$');
$xmlFile = reset($xmlFiles);
if (empty($xmlFile)) {
$data = array();
} else {
$data = JApplicationHelper::parseXMLLangMetaFile($path . DS . $dir . DS . $xmlFile);
}
$oneLanguage = new stdClass();
$oneLanguage->language = $dir;
$oneLanguage->name = empty($data['name']) ? $dir : $data['name'];
$languageFiles = JFolder::files($path . DS . $dir, '^(.*)\\.com_acymailing\\.ini$');
$languageFile = reset($languageFiles);
if (!empty($languageFile)) {
$linkEdit = 'index.php?option=com_acymailing&tmpl=component&ctrl=file&task=language&code=' . $oneLanguage->language;
$oneLanguage->edit = ' <a class="modal" title="' . JText::_('EDIT_LANGUAGE_FILE', true) . '" href="' . $linkEdit . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><i class="acyicon-edit" id="image' . $oneLanguage->language . '"></i></a>';
} else {
$linkEdit = 'index.php?option=com_acymailing&tmpl=component&ctrl=file&task=language&code=' . $oneLanguage->language;
$oneLanguage->edit = ' <a class="modal" title="' . JText::_('ADD_LANGUAGE_FILE', true) . '" href="' . $linkEdit . '" rel="{handler: \'iframe\', size:{x:800, y:500}}"><i class="acyicon-new" id="image' . $oneLanguage->language . '"></i></a>';
}
$languages[] = $oneLanguage;
}
$js = "function updateConfirmation(newvalue){";
$js .= "if(newvalue == 0) {window.document.getElementById('confirmemail').style.display = 'none'; window.document.getElementById('confirm_redirect').disabled = true;}else{window.document.getElementById('confirmemail').style.display = 'inline'; window.document.getElementById('confirm_redirect').disabled = false;}";
$js .= '}';
$js .= "function updateModification(newvalue){ if(newvalue != 'none') {window.document.getElementById('modifemail').style.display = 'none';}else{window.document.getElementById('modifemail').style.display = 'inline';}} ";
$js .= 'window.addEvent(\'load\', function(){ updateModification(\'' . $config->get('allow_modif', 'data') . '\'); updateConfirmation(' . $config->get('require_confirmation', 0) . '); });';
$doc->addScriptDeclaration($js);
$elements->require_confirmation = JHTML::_('acyselect.booleanlist', "config[require_confirmation]", 'onclick="updateConfirmation(this.value)"', $config->get('require_confirmation', 0));
$allowmodif = array();
$allowmodif[] = JHTML::_('select.option', "none", JText::_('JOOMEXT_NO'));
$allowmodif[] = JHTML::_('select.option', "data", JText::_('ONLY_SUBSCRIPTION'));
$allowmodif[] = JHTML::_('select.option', "all", JText::_('JOOMEXT_YES'));
$elements->allow_modif = JHTML::_('acyselect.radiolist', $allowmodif, "config[allow_modif]", 'size="1" onclick="updateModification(this.value)"', 'value', 'text', $config->get('allow_modif', 'data'));
if (!ACYMAILING_J16) {
$db->setQuery("SELECT name,published,id FROM `#__plugins` WHERE `folder` = 'acymailing' AND `element` NOT LIKE 'plg%' ORDER BY published DESC, ordering ASC");
} else {
$db->setQuery("SELECT name,enabled as published,extension_id as id FROM `#__extensions` WHERE `state` <> -1 AND `folder` = 'acymailing' AND `type`= 'plugin' AND `element` NOT LIKE 'plg%' ORDER BY enabled DESC, ordering ASC");
}
$plugins = $db->loadObjectList();
if (!ACYMAILING_J16) {
$db->setQuery("SELECT name,published,id FROM `#__plugins` WHERE (`folder` != 'acymailing' OR `element` LIKE 'plg%') AND (`name` LIKE '%acymailing%' OR `element` LIKE '%acymailing%') ORDER BY published DESC, ordering ASC");
} else {
$db->setQuery("SELECT name,enabled as published ,extension_id as id FROM `#__extensions` WHERE `state` <> -1 AND (`folder` != 'acymailing' OR `element` LIKE 'plg%') AND `type` = 'plugin' AND (`name` LIKE '%acymailing%' OR `element` LIKE '%acymailing%') ORDER BY enabled DESC, ordering ASC");
}
$integrationplugins = $db->loadObjectList();
if (ACYMAILING_J16) {
$db->setQuery("SELECT COUNT(*) FROM #__extensions WHERE `enabled` = 1 AND `state` = -1 AND `type` = 'plugin' AND (`folder` = 'acymailing' OR `name` LIKE '%acymailing%' OR `element` LIKE '%acymailing%')");
$discoveredPlugins = $db->loadResult();
if (!empty($discoveredPlugins)) {
acymailing_display('Some AcyMailing plugins are placed in the Joomla "Discover" feature and will not work, you should install them through the "Discover" menu in the Extension manager.', 'warning');
}
}
$bounceaction = acymailing_get('type.bounceaction');
$this->assignRef('bounceaction', $bounceaction);
$this->assignRef('config', $config);
$this->assignRef('languages', $languages);
$this->assignRef('elements', $elements);
$this->assignRef('plugins', $plugins);
$this->assignRef('integrationplugins', $integrationplugins);
$tabs = acymailing_get('helper.acytabs');
$tabs->setOptions(array('useCookie' => true));
$this->assignRef('tabs', $tabs);
$this->assignRef('toggleClass', $toggleClass);
if (!ACYMAILING_J16 and !file_exists(rtrim(JPATH_SITE, DS) . DS . 'plugins' . DS . 'acymailing' . DS . 'tagsubscriber.php') or ACYMAILING_J16 and !file_exists(rtrim(JPATH_SITE, DS) . DS . 'plugins' . DS . 'acymailing' . DS . 'tagsubscriber' . DS . 'tagsubscriber.php')) {
acymailing_checkPluginsFolders();
}
return parent::display($tpl);
}
function store()
{
if (!$this->isAllowed('lists', 'filter')) {
return;
}
JRequest::checkToken() or die('Invalid Token');
$class = acymailing_get('class.filter');
$status = $class->saveForm();
if ($status) {
acymailing_enqueueMessage(JText::_('JOOMEXT_SUCC_SAVED'), 'message');
} else {
acymailing_enqueueMessage(JText::_('ERROR_SAVING'), 'error');
if (!empty($class->errors)) {
foreach ($class->errors as $oneError) {
acymailing_enqueueMessage($oneError, 'error');
}
}
}
}
function identify($onlyvalue = false)
{
$subid = JRequest::getInt("subid", 0);
$key = JRequest::getString("key", '');
if (empty($subid) or empty($key)) {
$user = JFactory::getUser();
if (!empty($user->id)) {
$userIdentified = $this->get($user->email);
return $userIdentified;
}
if (!$onlyvalue) {
acymailing_enqueueMessage(JText::_('ASK_LOG'), 'error');
}
return false;
}
$this->database->setQuery('SELECT * FROM ' . acymailing_table('subscriber') . ' WHERE `subid` = ' . $this->database->Quote($subid) . ' AND `key` = ' . $this->database->Quote($key) . ' LIMIT 1');
$userIdentified = $this->database->loadObject();
if (empty($userIdentified)) {
if (!$onlyvalue) {
acymailing_enqueueMessage(JText::_('INVALID_KEY'), 'error');
}
return false;
}
return $userIdentified;
}
function test()
{
if (!$this->isAllowed('configuration', 'manage')) {
return;
}
$this->store();
acymailing_displayErrors();
$config = acymailing_config();
$user = JFactory::getUser();
$mailClass = acymailing_get('helper.mailer');
$addedName = $config->get('add_names', true) ? $mailClass->cleanText($user->name) : '';
$mailClass->AddAddress($user->email, $addedName);
$mailClass->Subject = 'Test e-mail from ' . ACYMAILING_LIVE;
$mailClass->Body = JText::_('TEST_EMAIL');
$mailClass->SMTPDebug = 1;
if (defined('JDEBUG') and JDEBUG) {
$mailClass->SMTPDebug = 2;
}
$result = $mailClass->send();
if (!$result) {
$bounce = $config->get('bounce_email');
if ($config->get('mailer_method') == 'smtp' && $config->get('smtp_secured') == 'ssl' && !function_exists('openssl_sign')) {
acymailing_enqueueMessage('The PHP Extension openssl is not enabled on your server, this extension is required to use an SSL connection, please enable it', 'notice');
} elseif (!empty($bounce) and !in_array($config->get('mailer_method'), array('smtp', 'elasticemail'))) {
acymailing_enqueueMessage(JText::sprintf('ADVICE_BOUNCE', '<b><i>' . $bounce . '</i></b>'), 'notice');
} elseif ($config->get('mailer_method') == 'smtp' and !$config->get('smtp_auth') and strlen($config->get('smtp_password')) > 1) {
acymailing_enqueueMessage(JText::_('ADVICE_SMTP_AUTH'), 'notice');
} elseif ((strpos(ACYMAILING_LIVE, 'localhost') or strpos(ACYMAILING_LIVE, '127.0.0.1')) and in_array($config->get('mailer_method'), array('sendmail', 'qmail', 'mail'))) {
acymailing_enqueueMessage(JText::_('ADVICE_LOCALHOST'), 'notice');
} elseif ($config->get('mailer_method') == 'smtp' and $config->get('smtp_port') and !in_array($config->get('smtp_port'), array(25, 2525, 465, 587))) {
acymailing_enqueueMessage(JText::sprintf('ADVICE_PORT', $config->get('smtp_port')), 'notice');
}
}
return $this->display();
}
private function _publishfollowup(&$mail)
{
$listmailClass = acymailing_get('class.listmail');
$mycampaign = $listmailClass->getCampaign($mail->mailid);
if (empty($mycampaign->listid)) {
return;
}
$db = JFactory::getDBO();
$toggleHelper = acymailing_get('helper.toggle');
$startdate = time() - $mail->senddate;
$db->setQuery('SELECT COUNT(subid) as total FROM `#__acymailing_listsub` as b WHERE b.`status` = 1 AND b.`listid` = ' . intval($mycampaign->listid) . ' AND b.`subdate` > ' . intval($startdate));
$total = $db->loadResult();
$db->setQuery('SELECT COUNT(subid) as total FROM `#__acymailing_listsub` as b WHERE b.`status` = 1 AND b.`listid` = ' . intval($mycampaign->listid));
$totalall = $db->loadResult();
if (empty($total) && empty($totalall)) {
return;
}
$text = JText::_('FOLLOWUP_PUBLISHED_INFORMED');
$text .= '<ul>';
if (!empty($total)) {
$text .= '<li>' . $toggleHelper->toggleText('add', $mail->mailid, 'followup', JText::sprintf('FOLLOWUP_ADDQUEUE_USERS', acymailing_getDate($startdate)) . ' ( ' . JText::sprintf('SELECTED_USERS', $total) . ' )') . '</li>';
}
if (!empty($totalall)) {
$text .= '<li>' . $toggleHelper->toggleText('addall', $mail->mailid, 'followup', JText::_('FOLLOWUP_ADDQUEUE_ALLUSERS') . ' ( ' . JText::sprintf('SELECTED_USERS', $totalall) . ' )') . '</li>';
}
acymailing_enqueueMessage($text, 'notice');
}
function sobipro()
{
$config = acymailing_config();
$db = JFactory::getDBO();
$sobiproImport = JRequest::getVar('config', array(), 'POST', 'array');
$newConfig = new stdClass();
$affectedRows = 0;
$newConfig->sobipro_import = serialize($sobiproImport);
$config->save($newConfig);
foreach ($sobiproImport as $oneImport => $oneValue) {
$query = 'SELECT fid, nid FROM #__sobipro_field WHERE fid="' . $oneValue['sobiEmail'] . '" OR fid="' . $oneValue['sobiName'] . '"';
$db->setQuery($query);
$nidResult = $db->loadObjectList("fid");
if (empty($nidResult[$oneValue['sobiEmail']]) or empty($nidResult[$oneValue['sobiName']])) {
continue;
}
$time = time();
$query = 'INSERT IGNORE INTO ' . acymailing_table('subscriber') . ' (`email`,`name`,`confirmed`,`created`,`enabled`,`accept`,`html`) SELECT b.baseData AS email, a.baseData AS name, 1 as confirmed, ' . $time . ' as created, 1 as enabled, 1 as accept, 1 as html FROM #__sobipro_field_data AS a LEFT JOIN #__sobipro_field_data AS b ON a.sid=b.sid WHERE a.`fid` = ' . $nidResult[$oneValue["sobiName"]]->fid . ' AND b.`fid` = ' . $nidResult[$oneValue["sobiEmail"]]->fid . ' AND b.baseData LIKE "%@%" AND b.baseData IS NOT NULL AND a.baseData IS NOT NULL ORDER by a.sid ';
$db->setQuery($query);
$db->query();
$affectedRows += $db->getAffectedRows();
}
acymailing_enqueueMessage(JText::sprintf('IMPORT_NEW', $affectedRows));
$query = 'SELECT b.subid FROM `#__sobipro_field_data` as a JOIN ' . acymailing_table('subscriber') . ' as b on a.baseData = b.email';
$this->db->setQuery($query);
$this->allSubid = acymailing_loadResultArray($this->db);
$this->_subscribeUsers();
$this->_displaySubscribedResult();
return true;
}
