[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] date
|
From: |
Jens Liebchen (ppp-design) |
|
Subject: |
Re: [tpop3d-discuss] date |
|
Date: |
Fri, 12 Sep 2003 18:11:15 +0200 |
|
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5b) Gecko/20030827 |
-----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-----