# acymailing/11.1.0/back/Classes/UrlClass.php

AcyMailing – An Ultimate Newsletter Plugin and Marketing Automation Solution for WordPress, version 11.1.0. 115 lines.

- Page: https://pluginprobe.com/plugins/acymailing/11.1.0/code/back/Classes/UrlClass.php
- Raw: https://pluginprobe.com/plugins/acymailing/11.1.0/raw/back/Classes/UrlClass.php
- Modified: 2026-08-03T10:18:54+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/acymailing/11.1.0/code/back/Classes/UrlClass.php#L10-L20`.

```php
<?php

namespace AcyMailing\Classes;

use AcyMailing\Core\AcymClass;

class UrlClass extends AcymClass
{
    public function __construct()
    {
        parent::__construct();

        $this->table = 'url';
        $this->pkey = 'id';
    }

    public function save(object $url): ?int
    {
        if (empty($url)) {
            return null;
        }

        foreach ($url as $oneAttribute => $value) {
            if (empty($value)) {
                continue;
            }

            $url->$oneAttribute = acym_stripTags($value);
        }

        return parent::save($url);
    }

    public function getOneUrlById(int $id): ?object
    {
        $url = acym_loadObject('SELECT * FROM #__acym_url WHERE `id` = '.intval($id));

        return empty($url) ? null : $url;
    }

    public function getUrl(string $url, int $mailid, int $userid, string $userkey = ''): string
    {
        if (empty($url) || empty($mailid) || empty($userid)) {
            return '';
        }

        static $allurls;

        $url = str_replace('&amp;', '&', $url);

        if (empty($allurls[$url])) {
            $allurls[$url] = $this->getAdd($url);
        }

        if (empty($allurls[$url]->id)) {
            return $url;
        }

        $trackingUrl = acym_frontendLink('fronturl&task=click&urlid='.$allurls[$url]->id.'&userid='.$userid.'&mailid='.$mailid);

        if (!empty($userkey)) {
            $trackingUrl .= (strpos($trackingUrl, '?') === false ? '?' : '&').'userkey='.urlencode($userkey);
        }

        return $trackingUrl;
    }

    // Used in checkDB to address a bug before the 12/04/19
    public function getDuplicatedUrls(): array
    {
        return acym_loadResultArray(
            'SELECT DISTINCT duplicates.id
            FROM #__acym_url AS duplicates
            JOIN #__acym_url AS original ON duplicates.url = original.url
            JOIN #__acym_url_click AS clickoriginal ON original.id = clickoriginal.url_id
            LEFT JOIN #__acym_url_click AS click ON duplicates.id = click.url_id
            WHERE click.url_id IS NULL
            LIMIT 500'
        );
        /*
        To clean the potential duplicated rows in the #__acym_url table, you can execute this query when no email is being sent:
        DELETE url.*
        FROM #__acym_url AS url
        LEFT JOIN #__acym_url_click AS urlclick ON url.id = urlclick.url_id
        WHERE urlclick.url_id IS NULL

        If an email is currently being sent, exclude its urls from the delete query
         */
    }

    private function getAdd(string $url): ?object
    {
        $currentUrl = $this->getOneByUrl($url);
        if (empty($currentUrl->id)) {
            $currentUrl = new \stdClass();
            $currentUrl->name = $url;
            $currentUrl->url = $url;
            $currentUrl->id = $this->save($currentUrl);

            if (empty($currentUrl->id)) {
                return null;
            }
        }

        return $currentUrl;
    }

    private function getOneByUrl(string $url): ?object
    {
        $url = acym_loadObject('SELECT * FROM #__acym_url WHERE `url` = '.acym_escapeDB($url));

        return empty($url) ? null : $url;
    }
}

```