This is for people who want the email address control in emerald but do not
want to create billing groups for each domain you host.(dumb)
Also your users will have to login to Vopmail/MailSite as User@Domain /
Password if they leave the domain off it will append the default domain in
MAILSITE/VOPMAIL not emerald!
if exists (select * from sysobjects where id =
object_id('dbo.VerifyMailUser') and sysstat & 0xf = 4)
drop procedure dbo.VerifyMailUser
GO
CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),
@esid integer AS
Select Login, Shell, Email, d.MailDomain, Password, HomeDir