Hello,
I am currently 'using amavisd-new with mysql for policy settings, but I
modify from :
# $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';
to :
$sql_select_policy = 'SELECT * FROM accountuser,policy'.
' WHERE (accountuser.policy_id=policy.id) AND
(accountuser.username IN (%k))'.
' ORDER BY accountuser.priority DESC';
in my accountuser table the is not an id field but a username of type
varchar(250), where I put the account of my client email.
Now I want enable "SQL white/black list" but the query is :
$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';
I would like to change the wblist.rid field in varchar(250) the same
that accountuser.username.
How can I say to use accountuser.username rather than users.id in the
match "wblist.rid =?" ?
Thanky You.
Oberdan Albertoni.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
