From cc7c0592e43d5ed5dd97a2459ce17f9394aea250 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 22 Sep 2006 09:49:26 +0000
Subject: [PATCH] Fixes for get_users_longtimenosee

---
 lib/datalib.php | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index 8a7d20ee60..e31fb02729 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -337,10 +337,10 @@ function get_users_unconfirmed($cutofftime=2000000000) {
  */
 function get_users_longtimenosee($cutofftime) {
     global $CFG;
-    return get_records_sql("SELECT DISTINCT *
-                              FROM {$CFG->prefix}user
-                             WHERE lastaccess > '0'
-                               AND lastaccess < '$cutofftime' ");
+    return get_records_sql("SELECT userid as id, courseid
+                              FROM {$CFG->prefix}user_lastaccess
+                             WHERE timeaccess > '0'
+                               AND timeaccess < '$cutofftime' ");
 }
 
 /**
-- 
2.39.5