General plugins

Re-engagement: allow timed release and improve completion rates.

 
Picture of Hugo Ribeiro
Re: Re-engagement: allow timed release and improve completion rates.
 

Thank you! 

Well I think I was able to update the query successfully, but as soon as I updated to github version and access reengament activity I got this error: Exception - Call to undefined function mod_reengagement\table\get_viewable_roles()

The emails are sent anyway. Maybe I've updated the plugin badly?..

As for the code, when the time to send emails comes it will check if the course is visible or not.

SELECT cm.id as id, cm.id as cmid, cm.availability, r.id as rid, r.course as courseid,
                                r.duration, r.emaildelay
                          FROM {reengagement} r
                          INNER JOIN {course_modules} cm on cm.instance = r.id
			  JOIN {course} c ON c.id = r.course
                          JOIN {modules} m on m.id = cm.module
                          WHERE m.name = 'reengagement'
			  AND c.visible = 1
                      ORDER BY r.id ASC
What do you think?
 
Average of ratings: -