From f312c5925fc33db9624fb0293eccb7fdf7861386 Mon Sep 17 00:00:00 2001
From: martinlanghoff <martinlanghoff>
Date: Wed, 19 Sep 2007 07:19:46 +0000
Subject: [PATCH] course/participants: fix sort order when last access is null
---
user/index.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/user/index.php b/user/index.php
index 944560af54..c2104ab6fa 100644
--- a/user/index.php
+++ b/user/index.php
@@ -321,7 +321,7 @@
} else {
$selectrole = " ";
}
- $select = 'SELECT u.id, u.username, u.firstname, u.lastname, u.email, u.city, u.country, u.picture, u.lang, u.timezone, u.emailstop, u.maildisplay, ul.timeaccess AS lastaccess, r.hidden '; // s.lastaccess
+ $select = 'SELECT u.id, u.username, u.firstname, u.lastname, u.email, u.city, u.country, u.picture, u.lang, u.timezone, u.emailstop, u.maildisplay, COALESCE(ul.timeaccess, 0) AS lastaccess, r.hidden '; // s.lastaccess
$select .= $course->enrolperiod?', r.timeend ':'';
$from = "FROM {$CFG->prefix}user u INNER JOIN
--
2.39.5