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