MDL-58884 competency: Inaccurate stats proficient competencies in course

diff --git a/competency/classes/user_competency_course.php b/competency/classes/user_competency_course.php
index e0e7d4e..392e1c5 100644 (file)
--- a/competency/classes/user_competency_course.php
+++ b/competency/classes/user_competency_course.php
@@ -243,6 +243,8 @@ class user_competency_course extends persistent {
 
         $sql = 'SELECT COUNT(comp.id)
                   FROM {' . self::TABLE . '} usercoursecomp
+                  JOIN {' . course_competency::TABLE . '} cc
+                    ON usercoursecomp.competencyid = cc.competencyid AND cc.courseid = usercoursecomp.courseid
                   JOIN {' . competency::TABLE . '} comp
                     ON usercoursecomp.competencyid = comp.id
                  WHERE usercoursecomp.courseid = ? AND usercoursecomp.userid = ? AND usercoursecomp.proficiency = ?';