From ea5d48ee8d9ccad07e0337216d639ef3192d60ad Mon Sep 17 00:00:00 2001
From: selliott <selliott>
Date: Tue, 9 Mar 2004 21:12:54 +0000
Subject: [PATCH] Modified function get_users_listing to: 1. also return
 confirmed field from user table and 2. include users in dataset who have not
 confirmed (Used to display unconfirmed users in admin/user.php)

---
 lib/datalib.php | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

diff --git a/lib/datalib.php b/lib/datalib.php
index e9a157af7c..339540d2e4 100644
--- a/lib/datalib.php
+++ b/lib/datalib.php
@@ -1404,10 +1404,11 @@ function get_users_listing($sort, $dir="ASC", $page=1, $recordsperpage=20, $sear
         $search = " AND ($fullname $LIKE '%$search%' OR email $LIKE '%$search%') ";
     }
 
-    return get_records_sql("SELECT id, username, email, firstname, lastname, city, country, lastaccess  
+/// warning: will return unconfirmed users
+    return get_records_sql("SELECT id, username, email, firstname, lastname, city, country, lastaccess, confirmed
                               FROM {$CFG->prefix}user 
                              WHERE username <> 'guest' 
-                               AND deleted <> 1 and confirmed = 1 $search
+                               AND deleted <> 1 $search
                           ORDER BY $sort $dir $limit");
 
 }
-- 
2.39.5