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';


$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