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.
