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); }