[tpop3d-discuss] timestamp ?

[Wild Karl-Heinz]

Hallo Ian,

In message "[tpop3d-discuss] timestamp ?"
   on 09.12.2003, Ian Riddler <ian@griffler.co.nz> writes:

IR> auth-mysql-onlogin-query: update postfix_users set
IR> last_check='$(timestamp)', last_ip = '$(clienthost)' \
IR>                           WHERE email = CONCAT('$(local_part)','@',
IR> '$(domain)')

Maybe it'll be helpfull to use an replace or just an insert into a
table. I use it with mysql and insert into rel_ip with a timestamp.
in an other task i delete the entries older than 20 minutes.

auth-mysql-onlogin-query: \
   INSERT INTO relay_ip ( rei_uname, rei_domain, rei_ip, rei_ts ) \
   VALUES ( '$(local_part)', '$(domain)', '$(clienthost)', CURRENT_TIMESTAMP )


kind regards
Karl-Heinz