[Emerald] Help with VerifyMailUser

• Messages sorted by: [ date ][ thread ][ subject ][ author ]
• Previous message: Dale E. Reed Jr.: "Re: [Emerald] calls table updates"
• Next message: Duane Schaub: "[Emerald] OT: WebMail Inteface"

CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS
Select Login, Shell, Email, d.MailDomain,
CASE WHEN (ma.OverLimit > 0 AND ma.OverLimit > ma.Balance) OR DateAdd(Day,
(ma.Extension+ma.OverDue+1), maExpireDate) < GetDate()
THEN RIGHT(CONVERT(VARCHAR(10),RAND()),4) +
RIGHT(CONVERT(VARCHAR(10),RAND()),4)
ELSE sa.Password END AS Password, HomeDir

• Previous message: Dale E. Reed Jr.: "Re: [Emerald] calls table updates"
• Next message: Duane Schaub: "[Emerald] OT: WebMail Inteface"