/** * Forward Tracker * * @return void */ private function forwardTrackingTask() { //get reqest vars $token = Request::getVar('t', ''); //parse mailing token $recipient = Helper::parseMailingToken($token); //if we found an object lets track it if (is_object($recipient) && $recipient->id) { //new mailing recipient action objec $newsletterMailingRecipientAction = new MailingRecipientAction($this->database); //create object holding our vars to store action $action = new stdClass(); $action->mailingid = $recipient->mid; $action->action = 'forward'; $action->action_vars = null; $action->email = $recipient->email; $action->ip = $_SERVER['REMOTE_ADDR']; $action->user_agent = $_SERVER['HTTP_USER_AGENT']; $action->date = \Date::toSql(); //save action $newsletterMailingRecipientAction->save($action); } }
/** * Unsubscribe User Mailing Lists * * @return void */ public function doUnsubscribeTask() { //get request vars $email = urldecode(Request::getVar('e', '')); $token = Request::getVar('t', ''); $reason = Request::getVar('reason', ''); $reason_alt = Request::getVar('reason-alt', ''); //grab the reason explaination if user selected other if ($reason == 'Other') { $reason = $reason_alt; } //parse mailing token $recipient = Helper::parseMailingToken($token); //make sure the token is valid if (!is_object($recipient) || $email != $recipient->email) { App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe'), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_LINK_ISSUE'), 'error'); return; } //get newsletter mailing to get mailing list id mailing was sent to $newsletterMailing = new Mailing($this->database); $mailing = $newsletterMailing->getMailings($recipient->mid); //make sure we have a mailing object if (!is_object($mailing)) { App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe'), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_NO_MAILING'), 'error'); return; } //are we unsubscribing from default list? $sql = ''; if ($mailing->lid == '-1') { if (!User::isGuest()) { $sql = "UPDATE #__xprofiles SET mailPreferenceOption=0 WHERE uidNumber=" . $this->database->quote(User::get('id')); } else { //build return url and redirect url $return = Route::url('index.php?option=com_newsletter&task=unsubscribe&e=' . $email . '&t=' . $token); //inform user and redirect App::redirect(Route::url('index.php?option=com_users&view=login&return=' . base64_encode($return)), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_MUST_LOGIN'), 'warning'); return; } } else { //update the emails status on the mailing list $sql = "UPDATE #__newsletter_mailinglist_emails\n\t\t\t\t\tSET status=" . $this->database->quote('unsubscribed') . "\n\t\t\t\t\tWHERE mid=" . $this->database->quote($mailing->lid) . "\n\t\t\t\t\tAND email=" . $this->database->quote($recipient->email); } //set query and execute $this->database->setQuery($sql); if (!$this->database->query()) { App::redirect(Route::url('index.php?option=com_newsletter&task=unsubscribe&e=' . $email . '&t=' . $token), Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_ERROR'), 'error'); return; } //insert unsubscribe reason $sql = "INSERT INTO #__newsletter_mailinglist_unsubscribes(mid,email,reason)\n\t\t\t\tVALUES(" . $this->database->quote($mailing->lid) . "," . $this->database->quote($recipient->email) . "," . $this->database->quote($reason) . ")"; $this->database->setQuery($sql); $this->database->query(); //inform user of successful unsubscribe Notify::success(Lang::txt('COM_NEWSLETTER_MAILINGLIST_UNSUBSCRIBE_SUCCESS')); if (User::isGuest()) { App::redirect(Route::url('index.php?option=com_newsletter')); return; } App::redirect(Route::url('index.php?option=com_newsletter&task=subscribe')); }