← All changes | back/Helpers/Update/Patchv9.php +234 -0 10.10.1 → 11.1.0 View file →

		@@ -1,0 +1,234 @@
	1	+<?php
	2	+
	3	+namespace AcyMailing\Helpers\Update;
	4	+
	5	+use AcyMailing\Classes\ConfigurationClass;
	6	+use AcyMailing\Classes\UrlClickClass;
	7	+
	8	+trait Patchv9
	9	+{
	10	+ private function updateFor920(ConfigurationClass $config): void
	11	+ {
	12	+ if ($this->isPreviousVersionAtLeast('9.2.0')) {
	13	+ return;
	14	+ }
	15	+
	16	+ $socialIcons = json_decode($config->get('social_icons', '{}'), true);
	17	+ if (empty($socialIcons['telegram'])) {
	18	+ $socialIcons['telegram'] = ACYM_IMAGES.'logo/telegram.png';
	19	+
	20	+ $config->saveConfig(['social_icons' => json_encode($socialIcons)]);
	21	+ }
	22	+
	23	+ $this->updateQuery('ALTER TABLE #__acym_mail_stat ADD COLUMN `click_unique` INT NOT NULL DEFAULT 0');
	24	+ $this->updateQuery('ALTER TABLE #__acym_mail_stat ADD COLUMN `click_total` INT NOT NULL DEFAULT 0');
	25	+
	26	+ $urlClickClass = new UrlClickClass();
	27	+ $mailClicks = $urlClickClass->getTotalClicksPerMail();
	28	+ if (!empty($mailClicks)) {
	29	+ foreach ($mailClicks as $mailId => $stats) {
	30	+ $this->updateQuery(
	31	+ 'UPDATE #__acym_mail_stat
	32	+ SET click_unique = '.intval($stats->unique_clicks).', click_total = '.intval($stats->total_clicks).'
	33	+ WHERE mail_id = '.intval($mailId)
	34	+ );
	35	+ }
	36	+ }
	37	+ }
	38	+
	39	+ private function updateFor930(): void
	40	+ {
	41	+ if ($this->isPreviousVersionAtLeast('9.3.0')) {
	42	+ return;
	43	+ }
	44	+
	45	+ $this->updateQuery('ALTER TABLE #__acym_rule ADD COLUMN `description` VARCHAR(250) NULL AFTER `name`');
	46	+ }
	47	+
	48	+ private function updateFor931(): void
	49	+ {
	50	+ if ($this->isPreviousVersionAtLeast('9.3.1')) {
	51	+ return;
	52	+ }
	53	+
	54	+ $maxOrdering = acym_loadResult('SELECT MAX(ordering) FROM #__acym_rule');
	55	+ $this->updateQuery('UPDATE #__acym_rule SET `ordering` = '.intval($maxOrdering + 1).' WHERE `id` = 17');
	56	+ }
	57	+
	58	+ private function updateFor940(ConfigurationClass $config): void
	59	+ {
	60	+ if ($this->isPreviousVersionAtLeast('9.4.0')) {
	61	+ return;
	62	+ }
	63	+
	64	+ $config->saveConfig([
	65	+ 'from_email' => acym_strtolower($config->get('from_email')),
	66	+ 'replyto_email' => acym_strtolower($config->get('replyto_email')),
	67	+ 'bounce_email' => acym_strtolower($config->get('bounce_email')),
	68	+ ]);
	69	+
	70	+ // Make sure that all domains in AcyMailer configuration are in lower cases
	71	+ $acymailerParams = $config->get('acymailer_domains', '[]');
	72	+ $acymailerParams = @json_decode($acymailerParams, true);
	73	+ if (!empty($acymailerParams)) {
	74	+ foreach ($acymailerParams as $domain => $domainParams) {
	75	+ $acymailerParams[$domain]['domain'] = acym_strtolower($domainParams['domain']);
	76	+ if (acym_strtolower($domain) === $domain) {
	77	+ continue;
	78	+ }
	79	+
	80	+ $acymailerParams[acym_strtolower($domain)] = $acymailerParams[$domain];
	81	+ unset($acymailerParams[$domain]);
	82	+ }
	83	+ $config->saveConfig(['acymailer_domains' => json_encode($acymailerParams)]);
	84	+ }
	85	+
	86	+ $this->updateQuery('ALTER TABLE `#__acym_field` DROP COLUMN `access`');
	87	+ }
	88	+
	89	+ private function updateFor961(): void
	90	+ {
	91	+ if ($this->isPreviousVersionAtLeast('9.6.1')) {
	92	+ return;
	93	+ }
	94	+
	95	+ $this->updateQuery('ALTER TABLE `#__acym_mail` ADD INDEX `#__index_acym_mail2` (`type`)');
	96	+ }
	97	+
	98	+ private function updateFor970(): void
	99	+ {
	100	+ if ($this->isPreviousVersionAtLeast('9.7.0')) {
	101	+ return;
	102	+ }
	103	+
	104	+ $this->updateQuery('ALTER TABLE `#__acym_user` ADD INDEX `#__index_acym_user1` (`cms_id`)');
	105	+ $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop` TINYINT(1) NOT NULL DEFAULT 0');
	106	+ $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop_delay` INT NULL');
	107	+ $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop_mail_skip` VARCHAR(255) NULL');
	108	+ }
	109	+
	110	+ private function updateFor980(): void
	111	+ {
	112	+ if ($this->isPreviousVersionAtLeast('9.8.0')) {
	113	+ return;
	114	+ }
	115	+
	116	+ $this->updateQuery('UPDATE #__acym_plugin SET `type` = "CORE" WHERE `type` = "ADDON" AND `folder_name` = "contact"');
	117	+ $this->updateQuery('ALTER TABLE #__acym_mail ADD COLUMN `bounce_email` VARCHAR(100) NULL');
	118	+ }
	119	+
	120	+ private function updateFor990(): void
	121	+ {
	122	+ if ($this->isPreviousVersionAtLeast('9.9.0')) {
	123	+ return;
	124	+ }
	125	+
	126	+ $this->updateQuery(
	127	+ 'UPDATE #__acym_mail
	128	+ SET `body` = REPLACE(`body`, "images/poweredby_", "images/editor/poweredby_")
	129	+ WHERE `body` LIKE "%images/poweredby_%"'
	130	+ );
	131	+
	132	+ $this->updateQuery(
	133	+ 'UPDATE #__acym_mail_archive
	134	+ SET `body` = REPLACE(`body`, "images/poweredby_", "images/editor/poweredby_")
	135	+ WHERE `body` LIKE "%images/poweredby_%"'
	136	+ );
	137	+ }
	138	+
	139	+ private function updateFor9101(): void
	140	+ {
	141	+ if ($this->isPreviousVersionAtLeast('9.10.1')) {
	142	+ return;
	143	+ }
	144	+
	145	+ // On some servers, there is a limit of 767 bytes for the index length, which corresponds to VARCHAR(191)
	146	+ $this->updateQuery('ALTER TABLE #__acym_user DROP INDEX `email_UNIQUE`');
	147	+ $this->updateQuery('ALTER TABLE #__acym_configuration CHANGE `name` `name` VARCHAR(190) NOT NULL');
	148	+
	149	+ $this->updateQuery('ALTER TABLE #__acym_mail_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	150	+ $this->updateQuery('ALTER TABLE #__acym_mailbox_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	151	+ $this->updateQuery('ALTER TABLE #__acym_custom_zone CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	152	+ $this->updateQuery('ALTER TABLE #__acym_mail_override CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	153	+ $this->updateQuery('ALTER TABLE #__acym_followup_has_mail CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	154	+ $this->updateQuery('ALTER TABLE #__acym_followup CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	155	+ $this->updateQuery('ALTER TABLE #__acym_segment CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	156	+ $this->updateQuery('ALTER TABLE #__acym_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	157	+ $this->updateQuery('ALTER TABLE #__acym_plugin CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	158	+ $this->updateQuery('ALTER TABLE #__acym_action CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	159	+ $this->updateQuery('ALTER TABLE #__acym_condition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	160	+ $this->updateQuery('ALTER TABLE #__acym_history CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	161	+ $this->updateQuery('ALTER TABLE #__acym_rule CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	162	+ $this->updateQuery('ALTER TABLE #__acym_user_has_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	163	+ $this->updateQuery('ALTER TABLE #__acym_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	164	+ $this->updateQuery('ALTER TABLE #__acym_url_click CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	165	+ $this->updateQuery('ALTER TABLE #__acym_url CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	166	+ $this->updateQuery('ALTER TABLE #__acym_user_stat CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	167	+ $this->updateQuery('ALTER TABLE #__acym_mail_stat CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	168	+ $this->updateQuery('ALTER TABLE #__acym_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	169	+ $this->updateQuery('ALTER TABLE #__acym_mail_has_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	170	+ $this->updateQuery('ALTER TABLE #__acym_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	171	+ $this->updateQuery('ALTER TABLE #__acym_step CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	172	+ $this->updateQuery('ALTER TABLE #__acym_automation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	173	+ $this->updateQuery('ALTER TABLE #__acym_user_has_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	174	+ $this->updateQuery('ALTER TABLE #__acym_campaign CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	175	+ $this->updateQuery('ALTER TABLE #__acym_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	176	+ $this->updateQuery('ALTER TABLE #__acym_mail CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	177	+ $this->updateQuery('ALTER TABLE #__acym_configuration CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	178	+ $this->updateQuery('ALTER TABLE #__acym_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci');
	179	+
	180	+ $this->updateQuery('TRUNCATE TABLE #__acym_mail_archive');
	181	+ }
	182	+
	183	+ private function updateFor9102(): void
	184	+ {
	185	+ if ($this->isPreviousVersionAtLeast('9.10.2')) {
	186	+ return;
	187	+ }
	188	+
	189	+ $duplicatedUsers = acym_loadObjectList(
	190	+ 'SELECT GROUP_CONCAT(`id` ORDER BY `creation_date` SEPARATOR "-") AS `concatenated_ids`, COUNT(*) AS `nb_duplicates`
	191	+ FROM #__acym_user
	192	+ GROUP BY `email`
	193	+ HAVING `nb_duplicates` > 1'
	194	+ );
	195	+
	196	+ if (!empty($duplicatedUsers)) {
	197	+ $userIdsToDelete = [];
	198	+
	199	+ foreach ($duplicatedUsers as $duplicatedUser) {
	200	+ $ids = explode('-', $duplicatedUser->concatenated_ids);
	201	+ $userIdsToDelete = array_merge($userIdsToDelete, array_slice($ids, 1));
	202	+ }
	203	+
	204	+ acym_arrayToInteger($userIdsToDelete);
	205	+ $idsToDelete = implode(',', $userIdsToDelete);
	206	+
	207	+ $this->updateQuery('DELETE FROM #__acym_user_has_list WHERE user_id IN ('.$idsToDelete.')');
	208	+ $this->updateQuery('DELETE FROM #__acym_queue WHERE user_id IN ('.$idsToDelete.')');
	209	+ $this->updateQuery('DELETE FROM #__acym_user_has_field WHERE user_id IN ('.$idsToDelete.')');
	210	+ $this->updateQuery('DELETE FROM #__acym_history WHERE user_id IN ('.$idsToDelete.')');
	211	+ $this->updateQuery('DELETE FROM #__acym_user_stat WHERE user_id IN ('.$idsToDelete.')');
	212	+ $this->updateQuery('DELETE FROM #__acym_user WHERE id IN ('.$idsToDelete.')');
	213	+ }
	214	+
	215	+ $this->updateQuery('ALTER TABLE #__acym_user ADD UNIQUE INDEX `email_UNIQUE` (`email`(191) ASC)');
	216	+ }
	217	+
	218	+ private function updateFor9110(): void
	219	+ {
	220	+ if ($this->isPreviousVersionAtLeast('9.11.0')) {
	221	+ return;
	222	+ }
	223	+
	224	+ $templateThumbnails = acym_loadResultArray('SELECT `thumbnail` FROM #__acym_mail WHERE `thumbnail` IS NOT NULL');
	225	+ if (!empty($templateThumbnails)) {
	226	+ $generatedThumbnails = acym_getFiles(ACYM_UPLOAD_FOLDER_THUMBNAIL, 'thumbnail_.*');
	227	+ foreach ($generatedThumbnails as $generatedThumbnail) {
	228	+ if (!in_array($generatedThumbnail, $templateThumbnails)) {
	229	+ acym_deleteFile(ACYM_UPLOAD_FOLDER_THUMBNAIL.$generatedThumbnail);
	230	+ }
	231	+ }
	232	+ }
	233	+ }
	234	+}