facebook_getcoursesbyenrolment

function facebook_getcoursesbyenrolment($enrolment, $userid){
	global $DB;
	if ($enrolment == "manual" || $enrolment == "self"){
		$sql = "SELECT c.id,
				c.fullname
				FROM {user_enrolments} AS ue
				INNER JOIN {enrol} AS e ON e.id = ue.enrolid
				INNER JOIN {course} AS c ON c.id = e.courseid
				INNER JOIN {course_categories} AS cc ON cc.id = c.category
				WHERE e.enrol =?
				AND ue.userid =?";
		$sqlparams = array($enrolment, $userid);
		$queryexecution = $DB->get_records_sql($sql, $sqlparams);
		$courses = array();
		foreach ($queryexecution as $userscourses){
			$courses[] = $userscourses;
		}
		if (!empty($courses)){
			return $courses;
		}
		else{
			return $userid." no tiene cursos inscritos en modo ".$enrolment;
		}
	}
	else{return $enrolment." no es un metodo de matriculación válido";}
}