[tpop3d-discuss] timestamp ?

[Ian Riddler]

Thanks,  that's exactly what I was after !

Ian

----- Original Message ----- 
From: "Wild Karl-Heinz" <kh.wild@wicom.li>
To: "Ian Riddler" <ian@griffler.co.nz>
Cc: <tpop3d-discuss@lists.beasts.org>
Sent: Tuesday, December 09, 2003 9:21 PM
Subject: Re: [tpop3d-discuss] timestamp ?


> 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
>
>