From 88608019774a10b142c82cd0fa68e9e48b5013cf Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Sun, 29 Jun 2025 19:04:11 -0400 Subject: [PATCH] tables "actions" datbase management seems to be working --- lib/devsql.c | 16 +++++++++++++++- sql/mailleur.sql | 4 ++-- 2 files changed, 17 insertions(+), 3 deletions(-) diff --git a/lib/devsql.c b/lib/devsql.c index 8e2e485..6b7bf75 100644 --- a/lib/devsql.c +++ b/lib/devsql.c @@ -823,7 +823,8 @@ PUBLIC _Bool sql_mngact(SQLPTR *sqlptr,SQLENUM action,ACTTYP *act) { #define OPEP "devsql.c:sql_mngact," -#define DELACT "DELETE * FROM "ACTIONS" WHERE sessid=%s AND rcptto=%s" +#define DELACT "DELETE FROM "ACTIONS" WHERE sessid=%s AND rcptto=%s" +#define INACT "INSERT INTO "ACTIONS" (%s) VALUES(%s,%s,%d,%s)" _Bool isok; @@ -837,12 +838,24 @@ if (act!=(ACTTYP *)0) { if (act->resp==(char **)0) (void) sqlrequest(sqlptr,DELACT,goodid,goodrcpt); else { + char *field; + + field="sessid,rcptto,numline,info"; if (act->resp!=(char **)0) { char **resp; + int num; resp=act->resp; + num=1; while (*resp!=(char *)0) { + char *goodinfo; + + goodinfo=sql_gooddata(sqlptr,*resp); + (void) sqlrequest(sqlptr,INACT,field,goodid,goodrcpt,num,goodinfo); + (void) rou_alert(0,INACT,field,goodid,goodrcpt,num,goodinfo); + goodinfo=rou_freestr(goodinfo); resp++; + num++; } } } @@ -852,6 +865,7 @@ if (act!=(ACTTYP *)0) { } return isok; +#undef INACT #undef DELACT #undef OPEP } diff --git a/sql/mailleur.sql b/sql/mailleur.sql index ed22b2f..5e9791c 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -82,8 +82,8 @@ CREATE TABLE sessions ( GRANT SELECT ON sessions TO mailapache; //table about recipient email information -//summerize all emails recived status according sessions and recipient -CREATE TABLE infos ( +//summerize all emails received actions status according sessions and recipient +CREATE TABLE actions ( creation DBTIMESTAMP //record creation DFLT NOW(), sessid TEXT, //Session id -- 2.47.3