JezK
Edit File: HistoryClass.php
<?php namespace AcyMailing\Classes; use AcyMailing\Core\AcymClass; class HistoryClass extends AcymClass { public function __construct() { parent::__construct(); $this->table = 'history'; } /** * Function insert to insert a line into the history... * User modification, user update, bounces... etc. */ public function insert(int $userId, string $action, array $data = [], int $mailid = 0, $unsubscribe_reason = null): void { $currentUserid = acym_currentUserId(); if (!empty($currentUserid)) { $data[] = acym_translation('EXECUTED_BY').'::'.$currentUserid.' ( '.acym_currentUserName().' )'; } $history = new \stdClass(); $history->user_id = intval($userId); $history->action = acym_stripTags($action); $history->data = implode("\n", $data); $history->unsubscribe_reason = $unsubscribe_reason; //Avoid a memory issue when the data is way too big. if (strlen($history->data) > 100000) { $history->data = substr($history->data, 0, 10000); } static $date = null; if (empty($date)) { $date = time(); } $history->date = ++$date; while ($this->alreadyExists($history->user_id, $history->date)) { $history->date++; } $date = $history->date; $history->mail_id = $mailid; $history->ip = acym_getIP(); if (!empty($_SERVER) && empty($this->config->get('anonymous_stats', 0))) { $source = []; $vars = [ 'HTTP_REFERER', 'HTTP_USER_AGENT', 'HTTP_HOST', 'SERVER_ADDR', 'REMOTE_ADDR', 'REQUEST_URI', 'QUERY_STRING', ]; foreach ($vars as $oneVar) { $remoteIp = acym_getVar('string', $oneVar, '', 'SERVER'); if (!empty($remoteIp)) { $source[] = $oneVar.'::'.acym_stripTags($remoteIp); } } $history->source = implode("\n", $source); } try { acym_insertObject('#__acym_history', $history); } catch (\Exception $e) { } } private function alreadyExists(int $userId, int $time): bool { $result = acym_loadResult('SELECT user_id FROM #__acym_history WHERE user_id = '.intval($userId).' AND date = '.intval($time)); return !empty($result); } /** * Get all history lines for one user order by date descending */ public function getHistoryOfOneById(int $userId): array { return acym_loadObjectList( 'SELECT h.*, m.id, m.subject FROM #__acym_history AS h LEFT JOIN #__acym_mail AS m ON h.mail_id = m.id WHERE h.user_id = '.intval($userId).' ORDER BY h.date DESC' ); } public function getAllUnsubReasons(): array { $query = 'SELECT `action`, `data`, `unsubscribe_reason` FROM #__acym_history WHERE `action` = "unsubscribed" AND `unsubscribe_reason` != ""'; return acym_loadObjectList($query); } public function getAllMainLanguageUnsubReasons(): array { $allUnsubReasons = $this->config->get('unsub_survey', '{}'); return json_decode($allUnsubReasons, true); } public function getUnsubscribeReasonText($index) { $surveyAnswers = json_decode($this->config->get('unsub_survey'), true); if (is_numeric($index)) { $index = $index - 1; $reason = $surveyAnswers[$index] ?? $index; } else { $reason = $index; } return $reason; } }