DH runs MM.2 which doesn’t allow sql. I have a membership database in Mysql and monthly (+) send a newsletter via MM. I’ve found a way to:
curl http://list.mypage.com… add or del and email
also
curl http://list.mypage… get a list of all MM members
then in a php script:
array1 = curl … get all mm members
array2 = select email from memberdb
foreach (array1 as x) is x not in array2 del from mm
foreach (array2 as y) is y not in array1 add to mm
and my local DB is in sync with MM
curl -s ‘http://lists.ourgroup.com/roster.cgi/newsletter-bfcommunityclub.org?roster-pw=xxxxxxxx&roster-email=me@ourgroup.com’ | sort", $data);
H=“http://lists.ourgroup.com/admin.cgi/newsletter-ourgroup.com/members”
curl -s “$H/add?subscribees=$2&adminpw=xxxxxxxx”
curl -s “$H/remove?unsubscribees=$2&adminpw=xxxxxxxxx”
$1 is add/del
$2 is the email in question