From 584f0a10edc57f3b8734206c8633e99cab5f9c20 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Sun, 10 Nov 2002 10:19:06 +0000
Subject: [PATCH] Starting to speed up this page

---
 admin/user.php | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/admin/user.php b/admin/user.php
index ce30f76e3f..f8bff24fe0 100644
--- a/admin/user.php
+++ b/admin/user.php
@@ -4,11 +4,14 @@
 	require("../user/lib.php");
     require("../lib/countries.php");
 
+    $recordsperpage = 100;
+
     optional_variable($newuser, "");
     optional_variable($delete, "");
     optional_variable($confirm, "");
     optional_variable($sort, "name");
     optional_variable($dir, "ASC");
+    optional_variable($page, 0);
 
     if (! record_exists_sql("SELECT * FROM user_admins")) {   // No admin user yet
         $user->firstname = "Admin";
@@ -144,8 +147,8 @@
             $sort = "firstname";
         }
 
-        if ($users = get_records_sql("SELECT * from user WHERE username <> 'guest' 
-                                      AND deleted <> '1' ORDER BY $sort $dir")) {
+        if ($users = get_records_sql("SELECT id, username, email, firstname, lastname, city, country, lastaccess  from user WHERE username <> 'guest' 
+                                      AND deleted <> '1' ORDER BY $sort $dir LIMIT $page,$recordsperpage")) {
 
             foreach ($users as $key => $user) {
                 $users[$key]->country = $COUNTRIES[$user->country];
-- 
2.39.5