[Dovecot] Executing SQL update upon login

Odhiambo WASHINGTON odhiambo.raburu at wananchi.com
Tue Oct 10 20:32:03 UTC 2006


* On 10/10/06 19:54 +0300, Timo Sirainen wrote:
| On Tue, 2006-10-10 at 16:44 +0200, Tom Sommer wrote:
| > Would it not be better to add a on_login_query which allowed access to a
| > list of variables, IP address, username, password etc.
| > 
| > on_login_query = UPDATE users SET last_login = NOW(), last_ip = %i WHERE
| > user = %u
| 
| Maybe, since so many people have already asked for this. Patches
| welcome ;)

Code to do this kind of thing is available in tpop3d (another great
POP3 server), only that I don't know no C, and hence how to "borrow" it 
from there ;)




-Wash

http://www.netmeister.org/news/learn2quote.html

DISCLAIMER: See http://www.wananchi.com/bms/terms.php

--
+======================================================================+
    |\      _,,,---,,_     | Odhiambo Washington    <wash at wananchi.com>
Zzz /,`.-'`'    -.  ;-;;,_ | Wananchi Online Ltd.   www.wananchi.com
   |,4-  ) )-,_. ,\ (  `'-'| Tel: +254 20 313985-9  +254 20 313922
  '---''(_/--'  `-'\_)     | GSM: +254 722 743223   +254 733 744121
+======================================================================+

Equal bytes for women.


More information about the dovecot mailing list