From fd6e9aa672f8d568d954a0b6f03c2c7062977372 Mon Sep 17 00:00:00 2001
From: Jean-Marc Pigeon <jmp@safe.c>
Date: Mon, 15 Sep 2025 19:34:23 -0400
Subject: [PATCH] Trying to shrink resp to one entry within TRATYP

---
 lib/gessql.c   | 3 +++
 www/gesdis.php | 2 ++
 www/gessql.php | 5 +++--
 www/lvlmai.php | 4 ++--
 www/lvlusr.php | 5 +++--
 5 files changed, 13 insertions(+), 6 deletions(-)

diff --git a/lib/gessql.c b/lib/gessql.c
index 853a5ac..fa10da3 100644
--- a/lib/gessql.c
+++ b/lib/gessql.c
@@ -73,6 +73,7 @@ if (act!=(ACTTYP *)0) {
 
     field="code,sessid,smtpfrom,emailfrom,subject,rcptto,numline,info";
     (void) sql_request(sqlptr,del,gid,grcpt);
+    (void) rou_alert(0,"%s JMPDBG DEL sessid=<%s> rcptto=<%s>",OPEP,gid,grcpt);
     if (act->resp!=(char **)0) {
       char **resp;
       int num;
@@ -83,6 +84,8 @@ if (act!=(ACTTYP *)0) {
         char *ginfo;
 
         ginfo=sql_gooddata(sqlptr,*resp);
+        (void) rou_alert(0,"%s JMPDBG sessid=<%s> rcptto=<%s> info=<%s>",
+                            OPEP,gid,grcpt,ginfo);
         (void) sql_request(sqlptr,ins,field,
                                       gcode,gid,
                                       gsfrom,ghfrom,ghsubject,
diff --git a/www/gesdis.php b/www/gesdis.php
index 3932652..3cfdd44 100644
--- a/www/gesdis.php
+++ b/www/gesdis.php
@@ -57,7 +57,9 @@ $STR = <<<EOT
 <Table WIDTH="100%">
 <TR>
 <TD align="left">
+<a href='/lvlmai.php'>
 <IMG src="reg-icons/Wwalczyszyn-Android-Style-Mail.96.png" ALT="mailbox">
+</a>
 </TD>
 <TD align="right">
 $entete
diff --git a/www/gessql.php b/www/gessql.php
index 7f456e9..64e36eb 100644
--- a/www/gessql.php
+++ b/www/gessql.php
@@ -215,12 +215,13 @@ $strlim="";
 $strskip="";
 $select="";
 if ($username!=NULL) 
-  $select="where (smtpfrom like '%$username%') or (rcptto like '%username')";
-$strsel="Select * from actions $select order by creation asc";
+  $select="where (smtpfrom like '%$username%') or (rcptto like '%username%')";
+$strsel="Select * from actions $select order by creation desc";
 if ($limit!=NULL) 
   $strlim="limit $limit";
 if ($skip!=NULL) 
   $strskip="offset $skip";
+rou_alert(0,"$OPEP JMPDBG <$strsel $strlim $strskip>");
 $stmt=$dbsql->Select("$strsel $strlim $strskip");
 return $stmt->fetchAll();
 }
diff --git a/www/lvlmai.php b/www/lvlmai.php
index bb59b87..ecab241 100644
--- a/www/lvlmai.php
+++ b/www/lvlmai.php
@@ -37,8 +37,8 @@ $line="";
 $count=$offset+1;
 foreach($actions as $action) {
   $info=substr($action['info'],3,1);
-  if ($info=="-")
-    continue;
+  //if ($info=="-")
+   // continue;
   $bgcolor="white";
   if ($count & 1 ) {
     $bgcolor="green";
diff --git a/www/lvlusr.php b/www/lvlusr.php
index cd2870f..799378a 100644
--- a/www/lvlusr.php
+++ b/www/lvlusr.php
@@ -15,6 +15,7 @@ function tblheader(string $username,int $numrec,int $offset,int $limit)
 {
 global $userlang;
 
+$debut=$offset+1;
 $email=gettranslate($userlang,"Email");
 
 $STR  = <<<EOT
@@ -44,7 +45,7 @@ $STR  = <<<EOT
 &rarrb;
 </FONT>
 </Button>
-<FONT SIZE=+2>$offset/$numrec</FONT>
+<FONT SIZE=+2>$debut/$numrec</FONT>
 </FORM>
 </TD>
 <TD align=left>
@@ -124,6 +125,7 @@ $emails=sql_getemaillist($dbsql,$username,$limit,$offset);
 $line="";
 $count=$offset;
 foreach($emails as $email) {
+  $count++;
   $bgcolor="white";
   if ($count & 1 ) {
     $bgcolor="green";
@@ -141,7 +143,6 @@ foreach($emails as $email) {
   $line=$line."<TD align=center>$max</TD>\r\n";
   $line=$line."<TD align=center>$lock</TD>\r\n";
   $line=$line."</TR>";
-  $count++;
   }
 sql_close($dbsql);
 
-- 
2.47.3