From f715976ab278da544e4749692256130bd33127ab Mon Sep 17 00:00:00 2001
From: Jean-Marc Pigeon <jmp@safe.c>
Date: Sun, 7 Sep 2025 14:33:08 -0400
Subject: [PATCH] Able to disply user liste

---
 www/gessql.php | 18 ++++++++++++++++++
 www/lvlusr.php | 33 +++++++++++++++++++++++++++++----
 2 files changed, 47 insertions(+), 4 deletions(-)

diff --git a/www/gessql.php b/www/gessql.php
index 5f98835..daa745f 100644
--- a/www/gessql.php
+++ b/www/gessql.php
@@ -134,4 +134,22 @@ while ($proceed==true) {
 rou_alert(0,"$OPEP, now logname=<$logname>");
 return $logname;
 }
+
+//==============================================================
+//
+//      Function to retreive a some email record
+//
+//==============================================================
+function sql_getemaillist($dbsql,$limit,$skip)
+
+{
+$OPEP="gessql.php:sql_getemaillist";
+
+$strsel="Select * from emails order by email asc";
+$strlim="";
+$strskip="";
+$stmt=$dbsql->Select("$strsel $strlim $strskip");
+return $stmt->fetchAll();
+}
+
 ?>
diff --git a/www/lvlusr.php b/www/lvlusr.php
index b61530b..ef839a4 100644
--- a/www/lvlusr.php
+++ b/www/lvlusr.php
@@ -16,18 +16,43 @@ function body($logname)
 {
 global $isadmin;
 
+$line="";
+$dbsql=sql_connect();
+$emails=sql_getemaillist($dbsql,NULL,NULL);
+foreach($emails as $email) {
+  $name=$email['email'];
+  $last=$email['lastemail'];
+  $max=$email['mxspace'];
+  $lock=$email['locked'];
+  $line=$line."<TR>";
+  $line=$line."<TD>$name</TD>";
+  $line=$line."<TD align=center>$last</TD>";
+  $line=$line."<TD align=center>$max</TD>";
+  $line=$line."<TD align=center>$lock</TD>";
+  $line=$line."</TR>";
+  }
+sql_close($dbsql);
+
 $start=starthtml(NULL);
 $stop=endhtml();
 $top=topper($isadmin,$logname,"lvlusr");
 $footer=footer("lvlusr");
 
+
 $STR  = <<<EOT
 $start
 $top
-<CENTER><FONT SIZE=+2 color=red>
-Within LVLUSR
-</FONT></CENTER>
-<BR>
+<CENTER>
+<table WIDTH="80%" BORDER="1" CellSpacing="0">
+<TR>
+<TH align=center>Email</TH>
+<TH align=center>lastemail</TH>
+<TH align=center>mxspace</TH>
+<TH align=center>locked</TH>
+</TR>
+$line
+</Table>
+</CENTER>
 $footer
 $stop
 EOT;
-- 
2.47.3