Proyectos de Subversion Moodle

        // Consulta SQL optimizada para obtener el último modulo visto por el usuario

        // Consulta SQL optimizada para obtener el último modulo visto por el usuario

        $sql  = "SELECT DISTINCT(coursemoduleid) AS coursemoduleid FROM {course_modules_viewed} WHERE ";

        $sql  = "SELECT DISTINCT(coursemoduleid) AS coursemoduleid FROM {course_modules_viewed} WHERE ";

        $sql .= "userid = :userid ORDER BY timecreated DESC LIMIT 1";

        $sql .= "userid = :userid ORDER BY timecreated DESC LIMIT 1";

        $module_viewed = $DB->get_record('course_modules', array('id' => $last_module_viewed->coursemoduleid), '*');

            'fullname' => $module_viewed->course

        ];