The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

Roger B.A. Klorese a écrit :
> Serge Aumont wrote:
> > http://www.sympa.org/dev-manual/authorization-scenarios#custom_perl_package_conditions 
>
>
> This has promise.
>
> Does the module have any access to the current database records, or 
> does it need to do a full database connect/operations/disconnect 
> sequence to manipulate the posts-per-day counter?
This module just allows to use perl script. You have to implement all 
the treatments you need. Including the database access. However, we 
provide a library for access to the Sympa database (it is used in Sympa) 
which handles low-level functions such as connect, disconnect, send a 
request and so on. It is called SQLSource.pm, you will find it in your 
bin/ directory. You can use it to simplify your code production.
> And is there any way to track the time of last post by a user?
We store this information in the logs_table table. Each time a message 
is successfully sent, we store a new entry in this table. This entry 
contains, amongst other information:
 - the email of the message sender,
 - the value "DoMessage" for the 'action_logs' field. this is the 
specificity of all  entries regarding message sending in this table.
 - an empty value for the 'error_type_logs' field, thus specifying that 
the message sending was successful.

See the description of this table here: 
https://www.sympa.org/internals/index#logs_table

Regards,

--
David Verdin
Comité réseau des universités