proftpd migration issue

Mario Caruso <[email protected]> Fri, 25 Nov 2005 19:43:42 +0100
Newsgroups gmane.network.pureftpd.user
Message-ID <[email protected]>
Hi everybody,
I'm currently working to try and migrate my company ft pserver from 
proftpd to pureftd, I already setup pureftpd to use mysql and virtual
quotas (so I already made an improvement versus the still valid proftpd),
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

This is used in order to track a user last access and the number of times a user 
has logged in (both were a marketing request) I know that such information can be
retrieved by parsing log files, but having it in the mysql table enables me to get
the information with a simple sql command rather then use some script and hunt 
down tapes for old log files.

thank you

M.
-- 
() ASCII Ribbon Campaign
/\ Against HTML E-Mail
signature.asc (application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.7 (GNU/Linux)

iD8DBQFDh1tj9XYbM7TdPPsRAsrBAJ9bCR3td1WSzfk98KfYIAa4wO33IACfZ+CT
Hz1YZCp5asDwtIdfg3eVuNs=
=yhxh
-----END PGP SIGNATURE-----