On Wed, Feb 11, 2009 at 09:24:25PM +0100, mouss wrote:
> post...@corwyn.net a ?crit :
> > And a last betterer/simpler way to do it.
> >
> > SELECT
> > if(INSTR(maildir,'+'),concat(left(maildir,instr(maildir,'+')-1),'/Maildir/.',right(maildir,length(maildir)-instr(maildir,'+'))),CONCAT(maildir,'Maildir/'))
> > from mailbox where username ='%s' and active='1'
>
> you are still allowing random folder names.
That's what I thought at first, but now I am not so sure. Perhaps all
this string munging is based on an attribute from the table, not the
input address. It sems that the database does not hold mailbox paths,
and they are always constructed from the user name, with special logic
for user+spam user names. That's OK, provided the OP controls user
names.
--
Viktor.
Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.
To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:majord...@postfix.org?body=unsubscribe%20postfix-users>
If my response solves your problem, the best way to thank me is to not
send an "it worked, thanks" follow-up. If you must respond, please put
"It worked, thanks" in the "Subject" so I can delete these quickly.
