cmsUserVars = $acymCmsUserVars;
}
public function installBounceRules()
{
$bounceClass = acym_get('class.bounce');
if ($bounceClass->getOrderingNumber() > 0) {
return;
}
$config = acym_config();
$replyTo = $config->get('replyto_email');
$bounce = $config->get('bounce_email');
$from = $config->get('from_email');
$forwardEmail = $replyTo != $bounce ? $replyTo : $from;
if (empty($forwardEmail)) $forwardEmail = acym_currentUserEmail();
$forwardEmail = str_replace('"', '', $forwardEmail);
$query = "INSERT INTO `#__acym_rule` (`id`, `name`, `ordering`, `regex`, `executed_on`, `action_message`, `action_user`, `active`, `increment_stats`, `execute_action_after`) VALUES ";
$query .= "(1, 'ACYM_ACTION_REQUIRED', 1, 'action *requ|verif', '[\"subject\"]', '{\"0\":\"delete_message\",\"1\":\"forward_message\",\"forward_to\":\"".$forwardEmail."\"}', '[]', 1, 0, 0),";
$query .= "(2, 'ACYM_ACKNOWLEDGMENT_RECEIPT_SUBJECT', 2, '(out|away) *(of|from)|vacation|holiday|absen|congés|recept|acknowledg|thank you for', '[\"subject\"]', '[\"delete_message\"]', '[]', 1, 0, 0),";
$query .= "(3, 'ACYM_FEEDBACK_LOOP', 3, 'feedback|staff@hotmail.com|complaints@.{0,15}email-abuse.amazonses.com|complaint about message', '[\"senderInfo\",\"subject\"]', '[\"save_message\",\"delete_message\"]', '[\"unsubscribe_user\"]', 1, 0, 0),";
$query .= "(4, 'ACYM_FEEDBACK_LOOP_BODY', 4, 'Feedback-Type.{1,5}abuse', '[\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"unsubscribe_user\"]', 1, 1, 0),";
$query .= "(5, 'ACYM_MAILBOX_FULL', 5, '((mailbox|mailfolder|storage|quota|space|inbox) *(is)? *(over)? *(exceeded|size|storage|allocation|full|quota|maxi))|status(-code)? *(:|=)? *5.2.2|quota-issue|not *enough.{1,20}space|((over|exceeded|full|exhausted) *(allowed)? *(mail|storage|quota))', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(6, 'ACYM_BLOCKED_GOOGLE_GROUPS', 6, 'message *rejected *by *Google *Groups', '[\"body\"]', '[\"delete_message\"]', '[]', 1, 1, 0),";
$query .= "(7, 'ACYM_MAILBOX_DOESNT_EXIST_1', 7, '(Invalid|no such|unknown|bad|des?activated|inactive|unrouteable) *(mail|destination|recipient|user|address|person)|bad-mailbox|inactive-mailbox|not listed in.{1,20}directory|RecipNotFound|(user|mailbox|address|recipients?|host|account|domain) *(is|has been)? *(error|disabled|failed|unknown|unavailable|not *(found|available)|.{1,30}inactiv)|no *mailbox *here|user does.?n.t have.{0,30}account', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(8, 'ACYM_MESSAGE_BLOCKED_RECIPIENTS', 8, 'blocked *by|block *list|look(ed)? *like *spam|spam-related|spam *detected| CXBL | CDRBL | IPBL | URLBL |(unacceptable|banned|offensive|filtered|blocked|unsolicited) *(content|message|e?-?mail)|service refused|(status(-code)?|554) *(:|=)? *5.7.1|administratively *denied|blacklisted *IP|policy *reasons|rejected.{1,10}spam|junkmail *rejected|throttling *constraints|exceeded.{1,10}max.{1,40}hour|comply with required standards|421 RP-00|550 SC-00|550 DY-00|550 OU-00', '[\"body\"]', '{\"0\":\"delete_message\",\"1\":\"forward_message\",\"forward_to\":\"".$forwardEmail."\"}', '[]', 1, 1, 0),";
$query .= "(9, 'ACYM_MAILBOX_DOESNT_EXIST_2', 9, 'status(-code)? *(:|=)? *5.(1.[1-6]|0.0|4.[0123467])|recipient *address *rejected|does *not *like *recipient', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(10, 'ACYM_DOMAIN_NOT_EXIST', 10, 'No.{1,10}MX *(record|host)|host *does *not *receive *any *mail|bad-domain|connection.{1,10}mail.{1,20}fail|domain.{1,10}not *exist|fail.{1,10}establish *connection', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(11, 'ACYM_TEMPORARY_FAILURES', 11, 'has.*been.*delayed|delayed *mail|message *delayed|message-expired|temporar(il)?y *(failure|unavailable|disable|offline|unable)|deferred|delayed *([0-9]*) *(hour|minut)|possible *mail *loop|too *many *hops|delivery *time *expired|Action: *delayed|status(-code)? *(:|=)? *4.4.6|will continue to be attempted|unable to deliver in.*Status: 4.4.7', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(12, 'ACYM_FAILED_PERM', 12, 'failed *permanently|permanent.{1,20}(failure|error)|not *accepting *(any)? *mail|does *not *exist|no *valid *route|delivery *failure', '[\"subject\",\"body\"]', '[\"save_message\",\"delete_message\"]', '[\"block_user\"]', 1, 1, 0),";
$query .= "(13, 'ACYM_ACKNOWLEDGMENT_RECEIPT_BODY', 13, 'vacances|holiday|vacation|absen|urlaub', '[\"body\"]', '[\"delete_message\"]', '[]', 1, 0, 0),";
$query .= "(14, 'ACYM_FINAL_RULE', 14, '.', '[\"senderInfo\",\"subject\"]', '{\"0\":\"delete_message\",\"1\":\"forward_message\",\"forward_to\":\"".$forwardEmail."\"}', '[]', 1, 1, 0);";
acym_query($query);
$newConfig = new stdClass();
$newConfig->bounceVersion = $this->bounceVersion;
$config->save($newConfig);
}
function addUpdateSite()
{
$config = acym_config();
$newconfig = new stdClass();
$newconfig->website = ACYM_LIVE;
$newconfig->max_execution_time = 0;
$config->save($newconfig);
acym_query('DELETE FROM #__updates WHERE element = "com_acym"');
$update_site_id = acym_loadResult("SELECT update_site_id FROM #__update_sites WHERE location LIKE '%component=acymailing%' AND type LIKE 'extension'");
$object = new stdClass();
$object->name = 'AcyMailing';
$object->type = 'extension';
$object->location = ACYM_UPDATEMEURL.'updatexml&component=acymailing&cms=joomla&level='.$config->get('level').'&version='.$config->get('version');
$object->enabled = 1;
if (empty($update_site_id)) {
$update_site_id = acym_insertObject("#__update_sites", $object);
} else {
$object->update_site_id = $update_site_id;
acym_updateObject("#__update_sites", $object, 'update_site_id');
}
$extension_id = acym_loadResult("SELECT extension_id FROM #__extensions WHERE `element` = 'com_acym' AND type LIKE 'component'");
if (empty($update_site_id) || empty($extension_id)) {
return false;
}
$query = 'INSERT IGNORE INTO #__update_sites_extensions (update_site_id, extension_id) values ('.intval($update_site_id).','.intval($extension_id).')';
acym_query($query);
return true;
}
function installLanguages($output = true)
{
$siteLanguages = acym_getLanguages();
if (!empty($siteLanguages[ACYM_DEFAULT_LANGUAGE])) {
unset($siteLanguages[ACYM_DEFAULT_LANGUAGE]);
}
$installedLanguages = array_keys($siteLanguages);
if (empty($installedLanguages)) {
return;
}
if (!$output) {
$newConfig = new stdClass();
$newConfig->installlang = implode(',', $installedLanguages);
$config = acym_config();
$config->save($newConfig);
return;
}
$js = '
var xhr = new XMLHttpRequest();
xhr.open("GET", "'.acym_prepareAjaxURL('file').'&task=installLanguages&languages='.implode(',', $installedLanguages).'");
xhr.onload = function(){
container = document.getElementById("acym_div");
container.innerHTML = xhr.responseText+container.innerHTML;
};
xhr.send();';
acym_addScript(true, $js);
}
function installBackLanguages($onlyCode = '')
{
if ('WordPress' != 'Joomla') return;
$menuStrings = [
'ACYM_USERS',
'ACYM_CUSTOM_FIELDS',
'ACYM_LISTS',
'ACYM_TEMPLATES',
'ACYM_CAMPAIGNS',
'ACYM_QUEUE',
'ACYM_AUTOMATION',
'ACYM_STATISTICS',
'ACYM_BOUNCE_HANDLING',
'ACYM_CONFIGURATION',
'ACYM_MENU_PROFILE',
'ACYM_MENU_PROFILE_DESC',
'ACYM_MENU_ARCHIVE',
'ACYM_MENU_ARCHIVE_DESC',
];
if (empty($onlyCode)) {
$siteLanguages = array_keys(acym_getLanguages());
} else {
$siteLanguages = [$onlyCode];
}
foreach ($siteLanguages as $code) {
$path = acym_getLanguagePath(ACYM_ROOT, $code).DS.$code.'.com_acym.ini';
if (!file_exists($path)) continue;
$content = file_get_contents($path);
if (empty($content)) continue;
$menuFileContent = 'ACYM="AcyMailing 6"'."\r\n";
$menuFileContent .= 'COM_ACYM="AcyMailing 6"'."\r\n";
$menuFileContent .= 'COM_ACYM_CONFIGURATION="AcyMailing 6"'."\r\n";
foreach ($menuStrings as $oneString) {
preg_match('#[^_]'.$oneString.'="(.*)"#i', $content, $matches);
if (empty($matches[1])) continue;
$menuFileContent .= $oneString.'="'.$matches[1].'"'."\r\n";
}
$menuPath = ACYM_ROOT.'administrator'.DS.'language'.DS.$code.DS.$code.'.com_acym.sys.ini';
if (!acym_writeFile($menuPath, $menuFileContent)) {
acym_enqueueNotification(acym_translation_sprintf('ACYM_FAIL_SAVE_FILE', $menuPath), 'error', 0);
}
}
}
function installFields()
{
$query = "INSERT IGNORE INTO #__acym_field (`id`, `name`, `type`, `value`, `active`, `default_value`, `required`, `ordering`, `option`, `core`, `backend_profile`, `backend_listing`, `backend_filter`, `frontend_form`, `frontend_profile`, `frontend_listing`, `frontend_filter`, `access`, `namekey`) VALUES
(1, 'ACYM_NAME', 'text', NULL, 1, NULL, 0, 1, '{\"editable_user_creation\":\"1\",\"editable_user_modification\":\"1\",\"error_message\":\"\",\"error_message_invalid\":\"\",\"size\":\"\",\"rows\":\"\",\"columns\":\"\",\"format\":\"\",\"custom_text\":\"\",\"css_class\":\"\",\"authorized_content\":{\"0\":\"all\",\"regex\":\"\"}}', 1, 1, 1, 0, 1, 1, 1, 0, 'all', 'acym_name'),
(2, 'ACYM_EMAIL', 'text', NULL, 1, NULL, 1, 2, '{\"editable_user_creation\":\"1\",\"editable_user_modification\":\"1\",\"error_message\":\"\",\"error_message_invalid\":\"\",\"size\":\"\",\"rows\":\"\",\"columns\":\"\",\"format\":\"\",\"custom_text\":\"\",\"css_class\":\"\",\"authorized_content\":{\"0\":\"all\",\"regex\":\"\"}}', 1, 1, 1, 0, 1, 1, 1, 0, 'all', 'acym_name');";
acym_query($query);
}
function installTemplate()
{
$names = ['default_template', 'default_template_2'];
foreach ($names as $name) {
$query = "INSERT INTO `#__acym_mail` (`name`, `creation_date`, `thumbnail`, `drag_editor`, `library`, `type`, `body`, `subject`, `template`, `from_name`, `from_email`, `reply_to_name`, `reply_to_email`, `bcc`, `settings`, `stylesheet`, `attachments`, `creator_id`) VALUES
(".acym_escapeDB(str_replace('_', ' ', $name)).", ".acym_escapeDB(acym_date('now', 'Y-m-d H:i:s', false)).", ".acym_escapeDB(ACYM_IMAGES.'img_template'.DS.$name.'.png').", 1, 1, 'standard', ".acym_escapeDB(str_replace('{acym_media}', ACYM_IMAGES, file_get_contents(ACYM_BACK.'templates'.DS.$name.DS.'content.txt'))).", 'Subject', 1, NULL, NULL, NULL, NULL, NULL, ".acym_escapeDB(file_get_contents(ACYM_BACK.'templates'.DS.$name.DS.'settings.txt')).", '', NULL, 1);";
acym_query($query);
}
acym_deleteFolder(ACYM_BACK.'templates');
}
private function _newAutomationAdmin($title)
{
$automationClass = acym_get('class.automation');
$stepClass = acym_get('class.step');
$conditionClass = acym_get('class.condition');
$mailClass = acym_get('class.mail');
$actionClass = acym_get('class.action');
$adminCreate = new stdClass();
$adminCreate->desc = 'ACYM_ADMIN_USER_CREATE_DESC';
$adminCreate->triggers = '{"user_creation":[""],"type_trigger":"user"}';
$adminCreate->conditions = '{"type_condition":"user"}';
$adminCreate->emailTitle = acym_translation('ACYM_USER_CREATION');
$adminCreate->emailSubject = '{trans:ACYM_USER_CREATION}';
$adminCreate->emailContent = '{trans:ACYM_HELLO} {subtag:name|ucfirst},
{trans:ACYM_NEW_USER_ACYMAILING}:
{trans:ACYM_NAME}: {subtag:name|info:current}
{trans:ACYM_EMAIL}: {subtag:email|info:current}
';
$adminModif = new stdClass();
$adminModif->desc = 'ACYM_ADMIN_USER_MODIFICATION_DESC';
$adminModif->triggers = '{"user_modification":[""],"type_trigger":"user"}';
$adminModif->conditions = '{"type_condition":"user"}';
$adminModif->emailTitle = acym_translation('ACYM_USER_MODIFICATION');
$adminModif->emailSubject = '{trans:ACYM_USER_MODIFICATION}';
$adminModif->emailContent = '{trans:ACYM_HELLO} {subtag:name|ucfirst},
{trans:ACYM_USER_MODIFY_ACYMAILING}:
{trans:ACYM_NAME}: {subtag:name|info:current}
{trans:ACYM_EMAIL}: {subtag:email|info:current}
';
$info = [
'ACYM_ADMIN_USER_CREATE' => $adminCreate,
'ACYM_ADMIN_USER_MODIFICATION' => $adminModif,
];
$newAutomation = new stdClass();
$newAutomation->name = $title;
$newAutomation->description = $info[$title]->desc;
$newAutomation->active = 0;
$newAutomation->admin = 1;
$newAutomation->id = $automationClass->save($newAutomation);
if (empty($newAutomation->id)) return false;
$newStep = new stdClass();
$newStep->name = 'ACYM_ADMIN_USER_CREATE';
$newStep->triggers = $info[$title]->triggers;
$newStep->automation_id = $newAutomation->id;
$newStep->id = $stepClass->save($newStep);
if (empty($newStep->id)) return false;
$newCondition = new stdClass();
$newCondition->step_id = $newStep->id;
$newCondition->conditions = $info[$title]->conditions;
$newCondition->id = $conditionClass->save($newCondition);
if (empty($newCondition->id)) return false;
$mailAutomation = new stdClass();
$mailAutomation->type = 'automation';
$mailAutomation->library = 1;
$mailAutomation->template = 0;
$mailAutomation->drag_editor = 1;
$mailAutomation->creator_id = acym_currentUserId();
$mailAutomation->creation_date = date('Y-m-d H:i:s', time());
$mailAutomation->name = acym_translation($info[$title]->emailTitle);
$mailAutomation->subject = acym_translation($info[$title]->emailSubject);
$mailAutomation->body = $this->getFormatedNotification($info[$title]->emailContent);
$mailAutomation->id = $mailClass->save($mailAutomation);
if (empty($mailAutomation->id)) return false;
$newAction = new stdClass();
$newAction->condition_id = $newCondition->id;
$newAction->actions = '[{"acy_add_queue":{"mail_id":"'.intval($mailAutomation->id).'","time":"{time}"}}]';
$newAction->filters = '{"0":{"1":{"acy_field":{"field":"email","operator":"=","value":"'.acym_currentUserEmail().'"}}},"type_filter":"classic"}';
$newAction->order = 1;
$newAction->id = $actionClass->save($newAction);
if (empty($newAction->id)) return false;
}
function installAdminNotif()
{
$automationClass = acym_get('class.automation');
$automationAdmin = $automationClass->getAutomationsAdmin();
if (empty($automationAdmin['ACYM_ADMIN_USER_CREATE'])) {
$this->_newAutomationAdmin('ACYM_ADMIN_USER_CREATE');
}
if (empty($automationAdmin['ACYM_ADMIN_USER_MODIFICATION'])) {
$this->_newAutomationAdmin('ACYM_ADMIN_USER_MODIFICATION');
}
}
function installList()
{
$listClass = acym_get('class.list');
$listClass->addDefaultList();
}
function installNotifications()
{
$searchSettings = [
'offset' => 0,
'mailsPerPage' => 9000,
'key' => 'name',
];
$mailClass = acym_get('class.mail');
$notifications = $mailClass->getMailsByType('notification', $searchSettings);
$notifications = $notifications['mails'];
$addNotif = [];
if (empty($notifications['acy_report'])) {
$addNotif[] = [
'name' => 'acy_report',
'subject' => 'AcyMailing Cron Report {mainreport}',
'content' => '{report}
{detailreport}
',
];
}
if (empty($notifications['acy_confirm'])) {
$addNotif[] = [
'name' => 'acy_confirm',
'subject' => '{subtag:name|ucfirst}, {trans:ACYM_PLEASE_CONFIRM_SUBSCRIPTION}',
'content' => $this->getFormatedNotification(
'Hello {subtag:name|ucfirst},
{trans:ACYM_CONFIRM_MESSAGE}
{trans:ACYM_CONFIRM_MESSAGE_ACTIVATE}
{confirm}{trans:ACYM_CONFIRM_SUBSCRIPTION}{/confirm}
'
),
];
}
if (!empty($addNotif)) {
foreach ($addNotif as $oneNotif) {
$notif = new stdClass();
$notif->type = 'notification';
$notif->library = 1;
$notif->template = 0;
$notif->drag_editor = 1;
$notif->creator_id = acym_currentUserId();
$notif->creation_date = date('Y-m-d H:i:s', time());
$notif->name = $oneNotif['name'];
$notif->subject = $oneNotif['subject'];
$notif->body = $oneNotif['content'];
$mailClass->save($notif);
}
}
}
private function getFormatedNotification($content)
{
$begining = '';
return $begining.$content.$ending;
}
function installExtensions()
{
$dirs = acym_getFolders(ACYM_BACK.'extensions');
if (empty($dirs)) return;
$extensionsToPublish = [
'acymtriggers',
'jceacym',
];
$existingExtensions = acym_loadResultArray('SELECT `element` FROM #__extensions WHERE `type` = "plugin" AND `folder` = "system" AND `element` IN ("'.implode('", "', $extensionsToPublish).'")');
if (!empty($existingExtensions)) {
$extensionsToPublish = array_diff($extensionsToPublish, $existingExtensions);
}
$installer = JInstaller::getInstance();
foreach ($dirs as $oneExtension) {
$installer->install(ACYM_BACK.'extensions'.DS.$oneExtension);
}
acym_query('UPDATE #__extensions SET `enabled` = 1 WHERE `type` = "plugin" AND `folder` = "system" AND `element` IN ("'.implode('", "', $extensionsToPublish).'")');
acym_deleteFolder(ACYM_BACK.'extensions');
}
}