static function remove_sub($list_id, $user_id)
{
$db = JFactory::getDBO();
$sub_id = JoomdleHelperAcymailing::get_sub_id($user_id);
$query = 'DELETE ' . ' FROM #__acymailing_listsub' . ' WHERE listid=' . $db->Quote($list_id) . ' AND subid=' . $db->Quote($sub_id);
$db->setQuery($query);
$db->Query();
return "OK";
}
static function delete_course_mailing_list($course_id, $type)
{
$db = JFactory::getDBO();
$list_id = JoomdleHelperMailinglist::get_course_list_id($course_id, $type);
$query = 'DELETE ' . ' FROM #__joomdle_mailinglists' . ' WHERE course_id=' . $db->Quote($course_id) . ' AND type=' . $db->Quote($type);
$db->setQuery($query);
$db->Query();
//Delete from mailing list component
JoomdleHelperAcymailing::delete_list($list_id);
}
