Re: [Emerald] Serv-U Users expire with extension

Daniel Wood ( dgwood@iwvisp.com )
Sat, 15 May 1999 11:30:53 -0700

I am running Serv-u 2.5, emer_su.dll 4.3.0.1 and I updated my
VerifyFTPUser procedure with the procedure below and Serv-u
still doesn't see the Permanent Extend. It see the Temporary
one but I would like it to work with the Permanent also. What
am I doing wrong?

Thank You
Dan

>You need to update your VerifyFTPUser proc. Here is the correct one
>(the
>last line is the big difference).
>
>CREATE PROCEDURE VerifyFTPUser @username varchar(32) AS
>Select Login, Shell, Password, HomeDir, HomeDirLimit
> From MasterAccounts ma, SubAccounts sa
> Where ma.CustomerID = sa.CustomerID
> AND sa.CustomerID=ma.CustomerID
> AND ma.Active=1 and sa.Active=1
> AND (Login = @username or Shell = @username or Email = @username)
> AND sa.Active<>0 AND ma.Active <> 0
> AND DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate) >=
>GetDate()
>
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>