| 1 |
<?php |
| 2 |
|
| 3 |
namespace AcyMailing\Helpers\Update; |
| 4 |
|
| 5 |
use AcyMailing\Helpers\CronHelper; |
| 6 |
|
| 7 |
trait Configuration |
| 8 |
{ |
| 9 |
public function addPref(): bool |
| 10 |
{ |
| 11 |
$this->level = ucfirst($this->level); |
| 12 |
|
| 13 |
$allPref = acym_getDefaultConfigValues(); |
| 14 |
|
| 15 |
$allPref['level'] = $this->level; |
| 16 |
$allPref['version'] = $this->version; |
| 17 |
|
| 18 |
$allPref['from_name'] = acym_getCMSConfig('fromname'); |
| 19 |
$allPref['from_email'] = acym_getCMSConfig('mailfrom'); |
| 20 |
$allPref['bounce_email'] = acym_getCMSConfig('mailfrom'); |
| 21 |
$cmsMailer = acym_getCMSConfig('mailer', 'phpmail'); |
| 22 |
$allPref['mailer_method'] = $cmsMailer === 'mail' ? 'phpmail' : $cmsMailer; |
| 23 |
$allPref['sendmail_path'] = acym_getCMSConfig('sendmail'); |
| 24 |
$allPref['smtp_port'] = acym_getCMSConfig('smtpport'); |
| 25 |
$allPref['smtp_secured'] = acym_getCMSConfig('smtpsecure'); |
| 26 |
$allPref['smtp_auth'] = acym_getCMSConfig('smtpauth'); |
| 27 |
$allPref['smtp_username'] = acym_getCMSConfig('smtpuser'); |
| 28 |
$allPref['smtp_password'] = acym_getCMSConfig('smtppass'); |
| 29 |
|
| 30 |
$allPref['replyto_name'] = $allPref['from_name']; |
| 31 |
$allPref['replyto_email'] = $allPref['from_email']; |
| 32 |
$allPref['cron_sendto'] = $allPref['from_email']; |
| 33 |
|
| 34 |
$allPref['add_names'] = '1'; |
| 35 |
$allPref['encoding_format'] = '8bit'; |
| 36 |
$allPref['charset'] = 'UTF-8'; |
| 37 |
$allPref['embed_images'] = '0'; |
| 38 |
$allPref['embed_files'] = '0'; |
| 39 |
$allPref['editor'] = 'codemirror'; |
| 40 |
$allPref['multiple_part'] = '1'; |
| 41 |
|
| 42 |
$smtpinfos = explode(':', acym_getCMSConfig('smtphost', '')); |
| 43 |
$allPref['smtp_host'] = $smtpinfos[0]; |
| 44 |
if (isset($smtpinfos[1])) { |
| 45 |
$allPref['smtp_port'] = $smtpinfos[1]; |
| 46 |
} |
| 47 |
if (!in_array($allPref['smtp_secured'], ['tls', 'ssl'])) { |
| 48 |
$allPref['smtp_secured'] = ''; |
| 49 |
} |
| 50 |
|
| 51 |
$allPref['social_icons'] = json_encode( |
| 52 |
[ |
| 53 |
'facebook' => ACYM_IMAGES.'logo/facebook.png', |
| 54 |
'twitter' => ACYM_IMAGES.'logo/twitter.png', |
| 55 |
'x' => ACYM_IMAGES.'logo/x.png', |
| 56 |
'instagram' => ACYM_IMAGES.'logo/instagram.png', |
| 57 |
'linkedin' => ACYM_IMAGES.'logo/linkedin.png', |
| 58 |
'pinterest' => ACYM_IMAGES.'logo/pinterest.png', |
| 59 |
'vimeo' => ACYM_IMAGES.'logo/vimeo.png', |
| 60 |
'wordpress' => ACYM_IMAGES.'logo/wordpress.png', |
| 61 |
'youtube' => ACYM_IMAGES.'logo/youtube.png', |
| 62 |
'telegram' => ACYM_IMAGES.'logo/telegram.png', |
| 63 |
] |
| 64 |
); |
| 65 |
|
| 66 |
$allPref['queue_nbmail'] = '40'; |
| 67 |
$allPref['queue_nbmail_auto'] = '70'; |
| 68 |
$allPref['queue_type'] = 'auto'; |
| 69 |
$allPref['queue_try'] = '3'; |
| 70 |
$allPref['queue_pause'] = '30'; |
| 71 |
$allPref['allow_visitor'] = '1'; |
| 72 |
$allPref['require_confirmation'] = '1'; |
| 73 |
$allPref['priority_newsletter'] = '3'; |
| 74 |
$allPref['allowed_files'] = 'zip,doc,docx,pdf,xls,txt,gzip,rar,jpg,jpeg,gif,xlsx,pps,csv,bmp,ico,odg,odp,ods,odt,png,ppt,swf,xcf,mp3,wma'; |
| 75 |
$allPref['confirm_redirect'] = ''; |
| 76 |
$allPref['subscription_message'] = '1'; |
| 77 |
$allPref['cron_next'] = '1251990901'; |
| 78 |
$allPref['confirmation_message'] = '1'; |
| 79 |
$allPref['welcome_message'] = '1'; |
| 80 |
$allPref['unsub_message'] = '1'; |
| 81 |
$allPref['cron_last'] = '0'; |
| 82 |
$allPref['cron_fromip'] = ''; |
| 83 |
$allPref['cron_report'] = ''; |
| 84 |
$allPref['cron_frequency'] = '900'; |
| 85 |
$allPref['cron_sendreport'] = CronHelper::SEND_REPORT_ONLY_ON_ERROR; |
| 86 |
$allPref['cron_savereport'] = CronHelper::SEND_REPORT_ONLY_ON_ACTION; |
| 87 |
$allPref['direct_queue_statistics'] = 0; |
| 88 |
$allPref['uploadfolder'] = str_replace('\\', '/', ACYM_UPLOAD_FOLDER); |
| 89 |
$allPref['last_import'] = ''; |
| 90 |
$allPref['security_key'] = acym_generateKey(30); |
| 91 |
$allPref['api_key'] = acym_generateKey(30); |
| 92 |
$allPref['cron_security'] = 1; |
| 93 |
$allPref['cron_key'] = acym_generateKey(30); |
| 94 |
$allPref['export_excelsecurity'] = 1; |
| 95 |
$allPref['gdpr_export'] = 0; |
| 96 |
$allPref['gdpr_delete'] = 0; |
| 97 |
$allPref['dont_track_by_default'] = 0; |
| 98 |
$allPref['user_tracking_control'] = 0; |
| 99 |
$allPref['trackingsystem'] = 'acymailing'; |
| 100 |
$allPref['trackingsystemexternalwebsite'] = 1; |
| 101 |
$allPref['generate_name'] = 1; |
| 102 |
$allPref['allow_modif'] = 'data'; |
| 103 |
$allPref['from_as_replyto'] = '1'; |
| 104 |
$allPref['bounceVersion'] = self::BOUNCE_VERSION; |
| 105 |
$allPref['numberThumbnail'] = 2; |
| 106 |
$allPref['daily_hour'] = '12'; |
| 107 |
$allPref['daily_minute'] = '00'; |
| 108 |
$allPref['regacy'] = 1; |
| 109 |
$allPref['regacy_delete'] = 1; |
| 110 |
$allPref['regacy_forceconf'] = 0; |
| 111 |
$allPref['remindme'] = '[]'; |
| 112 |
$allPref['notifications'] = '{}'; |
| 113 |
$allPref['unsubscribe_page'] = 1; |
| 114 |
$allPref['delete_stats_enabled'] = 1; |
| 115 |
$allPref['delete_stats'] = 86400 * 360; |
| 116 |
$allPref['delete_archive_history_after'] = 86400 * 90; |
| 117 |
|
| 118 |
$allPref['install_date'] = time(); |
| 119 |
$allPref['license_key'] = ''; |
| 120 |
$allPref['active_cron'] = 0; |
| 121 |
$allPref['multilingual'] = 0; |
| 122 |
|
| 123 |
$allPref['walk_through'] = '1'; |
| 124 |
$allPref['migration'] = '0'; |
| 125 |
$allPref['installcomplete'] = '0'; |
| 126 |
|
| 127 |
$allPref['Starter'] = ACYM_STARTER; |
| 128 |
$allPref['Essential'] = ACYM_ESSENTIAL; |
| 129 |
$allPref['Enterprise'] = ACYM_ENTERPRISE; |
| 130 |
$allPref['previous_version'] = '11.0.5'; |
| 131 |
|
| 132 |
$allPref['display_built_by'] = acym_level(ACYM_ESSENTIAL) ? 0 : 1; |
| 133 |
$allPref['php_overrides'] = 0; |
| 134 |
|
| 135 |
$query = 'INSERT IGNORE INTO `#__acym_configuration` (`name`,`value`) VALUES '; |
| 136 |
foreach ($allPref as $namekey => $value) { |
| 137 |
$query .= '('.acym_escapeDB($namekey).','.acym_escapeDB($value).'),'; |
| 138 |
} |
| 139 |
$query = rtrim($query, ','); |
| 140 |
|
| 141 |
return $this->updateQuery($query, 'display'); |
| 142 |
} |
| 143 |
|
| 144 |
public function updatePref(): bool |
| 145 |
{ |
| 146 |
try { |
| 147 |
$results = acym_loadObjectList('SELECT `name`, `value` FROM `#__acym_configuration` WHERE `name` IN ("version", "level") LIMIT 2', 'name'); |
| 148 |
} catch (\Exception $e) { |
| 149 |
$results = null; |
| 150 |
} |
| 151 |
|
| 152 |
if ($results === null) { |
| 153 |
acym_display(isset($e) ? $e->getMessage() : substr(acym_stripTags(acym_getDBError()), 0, 200).'...', 'error'); |
| 154 |
|
| 155 |
return false; |
| 156 |
} |
| 157 |
|
| 158 |
if (!empty($results['version'])) { |
| 159 |
$this->firstInstallation = false; |
| 160 |
} |
| 161 |
|
| 162 |
if ($results['version']->value === $this->version && $results['level']->value === $this->level) { |
| 163 |
return true; |
| 164 |
} |
| 165 |
|
| 166 |
$this->isUpdating = true; |
| 167 |
$this->previousVersion = $results['version']->value; |
| 168 |
|
| 169 |
//We update the version properly as it's a new one which is now used. |
| 170 |
$query = 'REPLACE INTO `#__acym_configuration` (`name`,`value`) VALUES ("level",'.acym_escapeDB($this->level).')'; |
| 171 |
$query .= ',("version",'.acym_escapeDB($this->version).')'; |
| 172 |
$query .= ',("installcomplete","0")'; |
| 173 |
$query .= ',("previous_version",'.acym_escapeDB($this->previousVersion).')'; |
| 174 |
|
| 175 |
return $this->updateQuery($query); |
| 176 |
} |
| 177 |
} |
| 178 |
|
