public function newsletterUnsubscribe($email = "") { $db = JFactory::getDbo(); $user = JFactory::getUser(); $and = ""; if (DEFAULT_NEWSLETTER != "") { $and .= "AND newsletter_id='" . DEFAULT_NEWSLETTER . "' "; } if ($user->id) { $and .= "AND `user_id` = " . (int) $user->id . " "; $email = $user->email; } if ($and != "") { $query = "DELETE FROM " . $this->_table_prefix . "newsletter_subscription " . "WHERE email = " . $db->quote($email) . " " . $and; $this->_db->setQuery($query); $this->_db->query(); $redshopMail = new redshopMail(); $redshopMail->sendNewsletterCancellationMail($email); } return true; }