[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss] timestamp ?
From: |
Wild Karl-Heinz |
Subject: |
Re: [tpop3d-discuss] timestamp ? |
Date: |
Tue, 9 Dec 2003 09:21:22 +0100 |
Hallo Ian,
In message "[tpop3d-discuss] timestamp ?"
on 09.12.2003, Ian Riddler <address@hidden> 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