public static function deleteSubscriber($subId)
{
$db = JFactory::getDBO();
if (empty($subId)) {
return '';
}
$query = 'DELETE FROM `#__jnews_subscribers` WHERE `id` = ' . $subId;
$db->setQuery($query);
$db->query();
//we also need to delete the subscribers in the listssubscribers table
$query = 'DELETE FROM `#__jnews_listssubscribers` WHERE `subscriber_id` = ' . $subId;
$db->setQuery($query);
$db->query();
$query = 'DELETE FROM `#__jnews_queue` WHERE `subscriber_id` = ' . $subId;
$db->setQuery($query);
$db->query();
$xf = new jNews_Config();
$xf->plus('act_totalsubcribers0', -1);
jNews_ListsSubs::removeSubscription($subId, '');
return true;
}
