From 14d2617c8f3cd7c88dc01787f67f03ae04e8aa9d Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 5 Aug 2025 15:16:33 +0200
Subject: [session] audit: Use pagination

---
 modules-available/session/page.inc.php | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

(limited to 'modules-available/session/page.inc.php')

diff --git a/modules-available/session/page.inc.php b/modules-available/session/page.inc.php
index d113f523..9ec04dd8 100644
--- a/modules-available/session/page.inc.php
+++ b/modules-available/session/page.inc.php
@@ -117,14 +117,15 @@ class Page_Session extends Page
 			}
 			$username = $row['login'];
 		}
-		$res = Database::queryAll("SELECT u.userid, u.login,
+		$lines = array();
+		$paginate = new Paginate("SELECT u.userid, u.login,
        				a.action, a.dateline, a.ipaddr, a.data, a.module, a.response
 					FROM audit a
 					LEFT JOIN user u USING (userid)
 					$extra
-					ORDER BY dateline DESC
-					LIMIT 500", $args);
-		foreach ($res as &$row) {
+					ORDER BY dateline DESC", 50);
+		$res = $paginate->exec($args);
+		foreach ($res as $row) {
 			$row['dateline_s'] = Util::prettyTime($row['dateline']);
 			if ($row['response'] < 200 || $row['response'] >= 400) {
 				$row['class'] = 'text-danger slx-bold';
@@ -132,8 +133,9 @@ class Page_Session extends Page
 			if ($username !== null) {
 				unset($row['login']);
 			}
+			$lines[] = $row;
 		}
-		Render::addTemplate('audit-list', ['list' => $res, 'user' => $username]);
+		$paginate->render('audit-list', ['list' => $lines, 'user' => $username]);
 	}
 
 }
-- 
cgit v1.2.3-55-g7522