[AMaViS-user] MySQL changes in amavisd-new from 2.2.0 to 2.3.3

Well, I'm trying to get some modification to work in 2.3.3 so I'm
hoping someone familiar with amavisd-new and MySQL can assist.

MySQL is not one of my strong points and I didn't do the original
patches and the person who did isn't around to assist anymore.

This is what I know....

original 2.2.0:
$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';

modified 2.2.0:
$sql_select_white_black_list =
'SELECT wblist.wb FROM wblist,mailaddr,users'
. ' WHERE (users.id=?)'
. ' AND (wblist.rid=users.amavisd_user_id)'
. ' AND (wblist.sid=mailaddr.id)'
. ' AND (mailaddr.email IN (%k))'
. ' ORDER BY mailaddr.priority DESC';



In 2.3.3 the changes are different as shown from the original 2.2.0
so I guessed at it but it didn't work so I was wondering if someone
could offer some help.

original 2.3.3:
$sql_select_white_black_list =
'SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id'.
' WHERE (wblist.rid=?)'
. ' AND (mailaddr.email IN (%k))'.
' ORDER BY mailaddr.priority DESC';

modified 2.3.3: (guessed)
$sql_select_white_black_list =
'SELECT wblist.wb FROM wblist LEFT JOIN mailaddr ON
wblist.sid=mailaddr.id'.
. ' WHERE (users.id=?)'
. ' AND (wblist.rid=users.amavisd_user_id)'
. ' AND (wblist.sid=mailaddr.id)'
. ' AND (mailaddr.email IN (%k))'
. ' ORDER BY mailaddr.priority DESC';



-- Dale



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=...486&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/