From cf0403002e28c008487cd098aa44ef9a0249acd3 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Tue, 23 May 2006 22:33:01 +0000
Subject: [PATCH] Solving one SQL error in data_get_participants() plus some
 improved readability.

Merged from MOODLE_16_STABLE
---
 mod/data/lib.php | 38 ++++++++++++++++++++++++++++----------
 1 file changed, 28 insertions(+), 10 deletions(-)

diff --git a/mod/data/lib.php b/mod/data/lib.php
index 8f3157ef94..70d17ca991 100755
--- a/mod/data/lib.php
+++ b/mod/data/lib.php
@@ -758,18 +758,31 @@ function data_user_complete($course, $user, $mod, $data) {
  * returns a list of participants of this database                      *
  ************************************************************************/
 function data_get_participants($dataid) {
-//Returns the users with data in one resource
-//(NONE, byt must exists on EVERY mod !!)
+//Returns the users with data in one data
+//(users with records in data_records, data_comments and data_ratings)
     global $CFG;
-    
-    $records = get_records_sql('SELECT DISTINCT u.id, u.id from '.$CFG->prefix.
-                               'user u, '.$CFG->prefix.'data_records r WHERE r.dataid="'.$dataid.'"
-                               AND u.id = r.userid');
-    
-    $comments = get_records_sql('SELECT DISTINCT u.id, u.id from '.$CFG->prefix.
-                                'user u, '.$CFG->prefix.'data_comments c, '.$CFG->prefix.'data_records r'.
-                                ' WHERE r.dataid="'.$dataid.'" AND u.id = c.userid AND r.id = c.recordid');
 
+    $records = get_records_sql("SELECT DISTINCT u.id, u.id
+                                FROM {$CFG->prefix}user u,
+                                     {$CFG->prefix}data_records r
+                                WHERE r.dataid = '$dataid'
+                                  AND u.id = r.userid");
+
+    $comments = get_records_sql("SELECT DISTINCT u.id, u.id
+                                 FROM {$CFG->prefix}user u,
+                                      {$CFG->prefix}data_records r,
+                                      {$CFG->prefix}data_comments c
+                                 WHERE r.dataid = '$dataid'
+                                   AND u.id = r.userid 
+                                   AND r.id = c.recordid");
+
+    $ratings = get_records_sql("SELECT DISTINCT u.id, u.id
+                                FROM {$CFG->prefix}user u,
+                                     {$CFG->prefix}data_records r,
+                                     {$CFG->prefix}data_ratings a
+                                WHERE r.dataid = '$dataid'
+                                  AND u.id = r.userid 
+                                  AND r.id = a.recordid");
     $participants = array();
     
     if ($records){
@@ -782,6 +795,11 @@ function data_get_participants($dataid) {
             $participants[$comment->id] = $comment;
         }
     }
+    if ($ratings){
+        foreach ($ratings as $rating) {
+            $participants[$rating->id] = $rating;
+        }
+    }
                                   
     return $participants;
 }
-- 
2.39.5