From 63971f8b40bb6c2fe0d9789d42ff9f935221bfad Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Sun, 3 Feb 2008 16:40:34 +0000
Subject: [PATCH] Detect used scales in course outcomes too. MDL-13307 ; merged
 from 19_STABLE

---
 lib/moodlelib.php | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/lib/moodlelib.php b/lib/moodlelib.php
index bfed92f009..201c7327be 100644
--- a/lib/moodlelib.php
+++ b/lib/moodlelib.php
@@ -6813,6 +6813,14 @@ function course_scale_used($courseid, $scaleid) {
 
         // check if any course grade item makes use of the scale
         $return += count_records('grade_items', 'courseid', $courseid, 'scaleid', $scaleid);
+
+        // check if any outcome in the course makes use of the scale
+        $return += count_records_sql("SELECT COUNT(*)
+                                      FROM {$CFG->prefix}grade_outcomes_courses goc,
+                                           {$CFG->prefix}grade_outcomes go
+                                      WHERE go.id = goc.outcomeid
+                                        AND go.scaleid = $scaleid
+                                        AND goc.courseid = $courseid");
     }
     return $return;
 }
-- 
2.39.5