Well, good thinked,
Actualy i use the userid as the full email address, and i do not use alot of
aliases, in 300 accounts i have only 2, and both for my account.
hum.. i think i won't have any trouble.
If in the future i'll have some other situation i'll think in a solution in
the moment.
Thanks you all.
Jorge
----- Original Message -----
From: "Jesse Norell" <[EMAIL PROTECTED]>
To: "DBMail mailinglist" <[email protected]>
Sent: Tuesday, July 11, 2006 6:38 PM
Subject: Re: [Dbmail] Delete accounts
On Tue, 2006-07-11 at 09:56 +0100, Jorge Bastos wrote:
It means that i just have to check for the owner_idnr before i delete the
record from dbmail_users, save it in a variable, delete the record from
dbmail_users and delete the values from the dbmail_aliases table with the
owner_idnr in the variable, and dbmail-util will take care of the rest!
Did i missed something paul?
Any users that have multiple aliases wouldn't be caught there, though
you may not have any of those. Eg. if userid = "bob" and user_idnr =
123, you could have an alias entry for "[EMAIL PROTECTED]" with a
deliver_to of "123" and another alias entry for "[EMAIL PROTECTED]" with a
deliver_to of "[EMAIL PROTECTED]" (ie. forward bob's mail offsite in
addition to saving it locally). Your proposal would catch the former,
but not the latter.
If you have userid's that are also the same as the email address, you
can probably just delete all dbmail_aliases where the alias is the same
as the userid. eg. if your username is "[EMAIL PROTECTED]" instead of just
"bob" you could "delete from dbmail_aliases where alias =
'[EMAIL PROTECTED]'.
--
Jesse Norell - [EMAIL PROTECTED]
Kentec Communications, Inc.
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
