Re: [AMaViS-user] $sql_select_policy help

2007-06-20 Thread ECEG / Daniel Duerr
Thanks for the points, Mark. On Jun 19, 2007, at 5:49 PM, Mark Martinec wrote: > Daniel, > >> Thank you for making this nice addition for me! >> It works perfectly and accomplishes exactly what I needed... > > I'm glad it does. > >> Will I need to continue patching this in or are you committing i

Re: [AMaViS-user] $sql_select_policy help

2007-06-19 Thread Mark Martinec
Daniel, > Thank you for making this nice addition for me! > It works perfectly and accomplishes exactly what I needed... I'm glad it does. > Will I need to continue patching this in or are you committing it > to the main branch? Just checking... Will be in 2.5.2, in few days. > RE: your conce

Re: [AMaViS-user] $sql_select_policy help

2007-06-19 Thread ECEG / Daniel Duerr
Hi Mark, Thank you for making this nice addition for me! It works perfectly and accomplishes exactly what I needed... Will I need to continue patching this in or are you committing it to the main branch? Just checking... RE: your concerns about the SQL pattern issues, I'm assuming I wo

Re: [AMaViS-user] $sql_select_policy help

2007-06-18 Thread Mark Martinec
Clifton, > > $sql_select_policy = > > "SELECT *,users.id FROM users LEFT JOIN policy ON > > users.policy_id=policy.id". " WHERE users.email IN (%k) OR alias.goto > > LIKE concat('%', %a, '%')". " ORDER BY users.priority DESC"; > Without digging into it would *seem* like allowing that would risk >

Re: [AMaViS-user] $sql_select_policy help

2007-06-18 Thread Clifton Royston
On Mon, Jun 18, 2007 at 04:14:20PM +0200, Mark Martinec wrote: > Daniel, > > > I'm tuning up my $sql_select_policy in order to improve functionality > > of amavis on my mail server and I'm struggling with something which > > I'd imagine would be simple. I need to extend this query as follows: > >

Re: [AMaViS-user] $sql_select_policy help

2007-06-18 Thread Mark Martinec
Daniel, > I'm tuning up my $sql_select_policy in order to improve functionality > of amavis on my mail server and I'm struggling with something which > I'd imagine would be simple. I need to extend this query as follows: > > " ... OR alias.goto LIKE ('%RECIPIENT%')" > > where RECIPIENT is the ind

[AMaViS-user] $sql_select_policy help

2007-06-15 Thread ECEG / Daniel Duerr
Hello everyone, I'm tuning up my $sql_select_policy in order to improve functionality of amavis on my mail server and I'm struggling with something which I'd imagine would be simple. I need to extend this query as follows: " ... OR alias.goto LIKE ('%RECIPIENT%')" where RECIPIENT is the ind