[tpop3d-discuss] date

Jens Liebchen (ppp-design) jens at ppp-design.de
Fri, 12 Sep 2003 18:11:15 +0200


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

pyton wrote:

Hi,

> I have one question. I would like to save in my mysql database date of
> login. So I  will use auth-mysql-onlogin-query but I don't know how to
> get current date. Shall is some variable???

Something like this may help you (NOW() is what you are looking for):

auth-mysql-onlogin-query: REPLACE a SET a.time=NOW(),
a.user=CONCAT('$(local_part)', '@', '$(domain)')



Cheers,

Jens Liebchen
ppp-design

- --
ppp-design
http://www.ppp-design.de
Public-Key: http://www.ppp-design.de/pgp/ppp-design.asc
Fingerprint: 5B02 0AD7 A176 3A4F CE22  745D 0D78 7B60 B3B5 451A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/YfAjDXh7YLO1RRoRAgmEAJ4sGTB1BfxEI+Mk+bB1jPWH0bhS+ACgoJT7
AGC2yac8Vy0Y7hnGZjKpKVw=
=K9WK
-----END PGP SIGNATURE-----