Re: Storing Last Login Plugin value in SQL

On 9/14/21 02:12, dovecot@ptld.com wrote:

Anyone have any idea how to get the last-login plugin to update a date/time column in sql?

I use this to throttle updates to once in 900 seconds:

create trigger tg1 before update on mailacct for each row if new.lastlogin < (old.lastlogin + 900) then set new.lastlogin = old.lastlogin; end if;

You can try:

create trigger tg1 before update on mailacct for each row set new.logindate = FROM_UNIXTIME(new.lastlogin);