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

Dale E. Reed Jr. ( (no email) )
Mon, 10 May 1999 12:51:04 -0700

Jason Powell wrote:
>
> When we extend someone due to CC decline etc, they can not ftp to their
> site. So, if a user is expired, but has an extension - they can not access
> their web site. Is there any way to resolve this problem? I am using
> serv-U 2.5 with Emerald 2.5.263.

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