Re: proftpd migration issue

Il Fri, 25 Nov 2005 19:43:42 +0100
Mario Caruso <[email protected]> ha scritto:

[cut]
> now all I'm missing is the equivalent of proftpd SQLNamedQuery; I was
> using SQLNamedQuery to populate two fields of mysql table with this syntax :
> 
> SQLNamedQuery updatecount UPDATE "count=count+1 where userid='%u'" USERTABLE
> SQLNamedQuery updatelastlogin UPDATE "tstamp=now() where userid='%u'" USERTABLE
> 
[cut] 

Hello again,
it seems that I found a "workaround" for this issue , since I'm not using limits on
maximum numbers of files from users I've defined MySQLGetQTAFS in the following way: 

MySQLGetQTAFS   UPDATE USERTABLE set tstamp=now() where userid="\L"

this is not exactly what I want because in this way I get the update every time a
user tries to login, not when the user succesfully performs a login; moreover I'm 
concerned of what pureftpd will do with the QTAFS limit, will it just ignore it 
since the command is not returning a valid number ?

thank you

M.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux)

iD8DBQFDis/+9XYbM7TdPPsRAsx5AKCJ/c09HLKVLkRH1aiWIw65wKo26QCgkfGe
g5UNBpqvof2fKM0kSUzICBY=
=XI5s
-----END PGP SIGNATURE-----