last_login plugin with MySQL

[Luigi Rosa]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Gedalya wrote on 18/10/2014 17:36:

> The code looks at shared/$last_login_key, so shared/last-login/username,
> but your map says /shared/last-login/$user, note the leading slash! That's
> probably all it is.


BINGO!

Now that we killed the mosters of this level, let's move to the next level.....


Welcome to the SQL query level!

I was expecting an UPDATE...WHERE but I got this:

INSERT INTO mailbox (lastlogin,username) VALUES ('1413647370','username') ON
DUPLICATE KEY UPDATE lastlogin='1413647370'

This is not very useful if I want a `lastlogin` field of the `mailbox` table
updated on every login.




Ciao,
luigi

- -- 
/
+--[Luigi Rosa]--
\

For every human problem, there is a neat, simple solution;
and it is always wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJUQozoAAoJEO5WT/qgw4yKXd0P/iGtE9bm3U3gUNqoOP8cI0Yi
2xU66Nk64jogcPyRXberWiaeXbytaJj15DAVwbQT08Iv53flOMbkNwn2LyfX2Yqi
DThdCaH60ADTkBsU2NUepglv3mGisuZ/T8euKo6OdDBowZ1t0u8EW1J41DP/4K6M
SWLDPcTkLGgcfJMCEvwP2JeWx6j0RCR2/e/mSe0Fvq9qUNYTbqHiDTLSh6bO/OPp
0vxj0LVb/xWIUlNS0pEbhFlSXaU5yNORyIacg0KMWEPB0d0qwGP6kusxi2l+huF/
VfbebBpj9qns8XJppxKTEpTKW7H3BoiM3vegLl7JNOwSKXa9xiNMhILkxcpgkRBi
idu8w+p7KXWrOWqDQ3giFhFrtMuhYNGryVvetD168426+AVkVM8/Zb7dETajgzH3
75XLlc4fMhyW6aRV5vGDllY6MzyDrEFsO3vtCE7NKZq7WmImnlwKsbm3NbEYFWsn
fEmOM9Hjc/DkRTTiejA31DztczrFd/f/kXXFSuPs25Dco6WVkojofpT4c8xhyS83
OTYBJY1gBfxSHn9zj3auTKYdxhOpzzopRn0uUT1M9iGYfy71ZJuL97dw1gOfkfOL
/RbBQwut9RJJWRYlYhIHKc9cvnB21pO76OLHkPHmslNUBX67q4fS3gUuhMbAroq2
37gmW6grIMIvY6s4XgMJ
=vXUT
-----END PGP SIGNATURE-----