| @@ -24,9 +24,9 @@ | ||
| 24 | 24 | if (empty($value)) { |
| 25 | 25 | continue; |
| 26 | 26 | } |
| 27 | 27 | |
| 28 | - $url->$oneAttribute = strip_tags($value); | |
| 28 | + $url->$oneAttribute = acym_stripTags($value); | |
| 29 | 29 | } |
| 30 | 30 | |
| 31 | 31 | return parent::save($url); |
| 32 | 32 | } |
| @@ -64,8 +64,9 @@ | ||
| 64 | 64 | |
| 65 | 65 | return $trackingUrl; |
| 66 | 66 | } |
| 67 | 67 | |
| 68 | + // Used in checkDB to address a bug before the 12/04/19 | |
| 68 | 69 | public function getDuplicatedUrls(): array |
| 69 | 70 | { |
| 70 | 71 | return acym_loadResultArray( |
| 71 | 72 | 'SELECT DISTINCT duplicates.id |
| @@ -75,8 +76,17 @@ | ||
| 75 | 76 | LEFT JOIN #__acym_url_click AS click ON duplicates.id = click.url_id |
| 76 | 77 | WHERE click.url_id IS NULL |
| 77 | 78 | LIMIT 500' |
| 78 | 79 | ); |
| 80 | + /* | |
| 81 | + To clean the potential duplicated rows in the #__acym_url table, you can execute this query when no email is being sent: | |
| 82 | + DELETE url.* | |
| 83 | + FROM #__acym_url AS url | |
| 84 | + LEFT JOIN #__acym_url_click AS urlclick ON url.id = urlclick.url_id | |
| 85 | + WHERE urlclick.url_id IS NULL | |
| 86 | + | |
| 87 | + If an email is currently being sent, exclude its urls from the delete query | |
| 88 | + */ | |
| 79 | 89 | } |
| 80 | 90 | |
| 81 | 91 | private function getAdd(string $url): ?object |
| 82 | 92 | { |
