From 42960e439a892ee83f4dd4056e4f86ec3bfd40c2 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 14 Oct 2003 17:31:54 +0000
Subject: [PATCH] Function exercise_get_participants() included and working.
 :-)

---
 mod/exercise/lib.php | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)

diff --git a/mod/exercise/lib.php b/mod/exercise/lib.php
index 47c7d5e12d..4b24a49aaa 100644
--- a/mod/exercise/lib.php
+++ b/mod/exercise/lib.php
@@ -546,6 +546,35 @@ function exercise_user_outline($course, $user, $mod, $exercise) {
     return NULL;
 }
 
+/*******************************************************************/
+function exercise_get_participants($exerciseid) {
+//Returns the users with data in one exercise
+//(users with records in exercise_submissions and exercise_assessments, students)
+
+    global $CFG;
+
+    //Get students from exercise_submissions
+    $st_submissions = get_records_sql("SELECT DISTINCT u.*
+                                       FROM {$CFG->prefix}user u,
+                                            {$CFG->prefix}exercise_submissions s
+                                       WHERE s.exerciseid = '$exerciseid' and
+                                             u.id = s.userid");
+    //Get students from exercise_assessments
+    $st_assessments = get_records_sql("SELECT DISTINCT u.*
+                                 FROM {$CFG->prefix}user u,
+                                      {$CFG->prefix}exercise_assessments a
+                                 WHERE a.exerciseid = '$exerciseid' and
+                                       u.id = a.userid");
+
+    //Add st_assessments to st_submissions
+    if ($st_assessments) {
+        foreach ($st_assessments as $st_assessment) {
+            $st_submissions[$st_assessment->id] = $st_assessment;
+        }
+    }
+    //Return st_submissions array (it contains an array of unique users)
+    return ($st_submissions);
+}
 
 //////////////////////////////////////////////////////////////////////////////////////
 
-- 
2.39.5