From b20ee40745dbeb01c4f571a922dd0713dc0c11fe Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Tue, 9 Mar 2004 08:41:57 +0000
Subject: [PATCH] POssible fix for bug 1109

---
 mod/chat/lib.php | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/mod/chat/lib.php b/mod/chat/lib.php
index f1cf182810..5581a4fb78 100644
--- a/mod/chat/lib.php
+++ b/mod/chat/lib.php
@@ -201,12 +201,11 @@ function chat_get_users($chatid, $groupid=0) {
         $groupselect = "";
     }
    
-    return get_records_sql("SELECT u.id, u.firstname, u.lastname, u.picture, c.lastmessageping
+    return get_records_sql("SELECT DISTINCT u.id, u.firstname, u.lastname, u.picture, c.lastmessageping
                               FROM {$CFG->prefix}chat_users c,
                                    {$CFG->prefix}user u
                              WHERE c.chatid = '$chatid'
                                AND u.id = c.userid $groupselect
-                             GROUP BY u.id
                              ORDER BY c.firstping ASC");
 }
 
-- 
2.39.5