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

		@@ -1,234 +1,0 @@
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		- $newConfig = new \stdClass();
21		- $newConfig->social_icons = json_encode($socialIcons);
22		- $config->save($newConfig);
23		- }
24		-
25		- $this->updateQuery('ALTER TABLE #__acym_mail_stat ADD COLUMN `click_unique` INT NOT NULL DEFAULT 0');
26		- $this->updateQuery('ALTER TABLE #__acym_mail_stat ADD COLUMN `click_total` INT NOT NULL DEFAULT 0');
27		-
28		- $urlClickClass = new UrlClickClass();
29		- $mailClicks = $urlClickClass->getTotalClicksPerMail();
30		- if (!empty($mailClicks)) {
31		- foreach ($mailClicks as $mailId => $stats) {
32		- $this->updateQuery(
33		- 'UPDATE #__acym_mail_stat
34		- SET click_unique = '.intval($stats->unique_clicks).', click_total = '.intval($stats->total_clicks).'
35		- WHERE mail_id = '.intval($mailId)
36		- );
37		- }
38		- }
39		- }
40		-
41		- private function updateFor930(): void
42		- {
43		- if ($this->isPreviousVersionAtLeast('9.3.0')) {
44		- return;
45		- }
46		-
47		- $this->updateQuery('ALTER TABLE #__acym_rule ADD COLUMN `description` VARCHAR(250) NULL AFTER `name`');
48		- }
49		-
50		- private function updateFor931(): void
51		- {
52		- if ($this->isPreviousVersionAtLeast('9.3.1')) {
53		- return;
54		- }
55		-
56		- $maxOrdering = acym_loadResult('SELECT MAX(ordering) FROM #__acym_rule');
57		- $this->updateQuery('UPDATE #__acym_rule SET `ordering` = '.intval($maxOrdering + 1).' WHERE `id` = 17');
58		- }
59		-
60		- private function updateFor940(ConfigurationClass $config): void
61		- {
62		- if ($this->isPreviousVersionAtLeast('9.4.0')) {
63		- return;
64		- }
65		-
66		- $config->save([
67		- 'from_email' => acym_strtolower($config->get('from_email')),
68		- 'replyto_email' => acym_strtolower($config->get('replyto_email')),
69		- 'bounce_email' => acym_strtolower($config->get('bounce_email')),
70		- ]);
71		-
72		- $acymailerParams = $config->get('acymailer_domains', '[]');
73		- $acymailerParams = @json_decode($acymailerParams, true);
74		- if (!empty($acymailerParams)) {
75		- foreach ($acymailerParams as $domain => $domainParams) {
76		- $acymailerParams[$domain]['domain'] = acym_strtolower($domainParams['domain']);
77		- if (acym_strtolower($domain) === $domain) {
78		- continue;
79		- }
80		-
81		- $acymailerParams[acym_strtolower($domain)] = $acymailerParams[$domain];
82		- unset($acymailerParams[$domain]);
83		- }
84		- $config->save(['acymailer_domains' => json_encode($acymailerParams)]);
85		- }
86		-
87		- $this->updateQuery('ALTER TABLE `#__acym_field` DROP COLUMN `access`');
88		- }
89		-
90		- private function updateFor961(): void
91		- {
92		- if ($this->isPreviousVersionAtLeast('9.6.1')) {
93		- return;
94		- }
95		-
96		- $this->updateQuery('ALTER TABLE `#__acym_mail` ADD INDEX `#__index_acym_mail2` (`type`)');
97		- }
98		-
99		- private function updateFor970(): void
100		- {
101		- if ($this->isPreviousVersionAtLeast('9.7.0')) {
102		- return;
103		- }
104		-
105		- $this->updateQuery('ALTER TABLE `#__acym_user` ADD INDEX `#__index_acym_user1` (`cms_id`)');
106		- $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop` TINYINT(1) NOT NULL DEFAULT 0');
107		- $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop_delay` INT NULL');
108		- $this->updateQuery('ALTER TABLE #__acym_followup ADD COLUMN `loop_mail_skip` VARCHAR(255) NULL');
109		- }
110		-
111		- private function updateFor980(): void
112		- {
113		- if ($this->isPreviousVersionAtLeast('9.8.0')) {
114		- return;
115		- }
116		-
117		- $this->updateQuery('UPDATE #__acym_plugin SET `type` = "CORE" WHERE `type` = "ADDON" AND `folder_name` = "contact"');
118		- $this->updateQuery('ALTER TABLE #__acym_mail ADD COLUMN `bounce_email` VARCHAR(100) NULL');
119		- }
120		-
121		- private function updateFor990(): void
122		- {
123		- if ($this->isPreviousVersionAtLeast('9.9.0')) {
124		- return;
125		- }
126		-
127		- $this->updateQuery(
128		- 'UPDATE #__acym_mail
129		- SET `body` = REPLACE(`body`, "images/poweredby_", "images/editor/poweredby_")
130		- WHERE `body` LIKE "%images/poweredby_%"'
131		- );
132		-
133		- $this->updateQuery(
134		- 'UPDATE #__acym_mail_archive
135		- SET `body` = REPLACE(`body`, "images/poweredby_", "images/editor/poweredby_")
136		- WHERE `body` LIKE "%images/poweredby_%"'
137		- );
138		- }
139		-
140		- private function updateFor9101(): void
141		- {
142		- if ($this->isPreviousVersionAtLeast('9.10.1')) {
143		- return;
144		- }
145		-
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		-}