SQL Integration
James Day
James.Day at ontraq.com
Fri Aug 26 17:16:20 CEST 2011
Found the solution I needed after much trial and error. I no longer needed to use "$per_recip_blacklist_sender_lookup_tables"
Instead I am using:
$sql_select_policy = 'SELECT *,users.id FROM users,policy'.' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.
' ORDER BY users.priority DESC';
And
$sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr'.' WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id)'.' AND (mailaddr.email IN (%k))'.' ORDER BY mailaddr.priority DESC';
Which has helped things no end!
Kind Regards,
James Day
(IT Engineer)
Ontraq Limited
Tel: 01245 265100
Fax: 01245 265700
Web: www.ontraq.com<http://www.ontraq.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20110826/25e597f4/attachment.html>
More information about the amavis-users
mailing list