function MailChimpResetSubscription($con) { MailChimpUpdateLists($con); $lists = SqlResultArray($con, "SELECT listid FROM ctcweb9_ctc.mailchimp_lists where listname = 'Members'"); $listid = $lists[0]["listid"]; SqlExecOrDie($con, "DELETE from ctcweb9_ctc.mailchimp_subscriptions where listid = '{$listid}'"); SqlExecOrDie($con, "INSERT into ctcweb9_ctc.mailchimp_subscriptions(listid,memberid) " . "SELECT '{$listid}', m.id " . "from ctcweb9_ctc.members m " . "join ctcweb9_ctc.memberships ms on ms.id = m.membershipid " . "where ms.statusAdmin='Active' and m.onEmailListBool ='Yes'"); }
<?php define('_VALID_MOS', 1); require_once 'alastair.php'; require_once 'mailchimp.inc.php'; echo gmdate('Y-m-d H:i:s') . " MailChimpResetSubscription\n"; MailChimpResetSubscription($con); echo gmdate('Y-m-d H:i:s') . " MailChimpUpdateLists\n"; MailChimpUpdateLists($con); echo gmdate('Y-m-d H:i:s') . " MailChimpUpdateListsFromDB\n"; MailChimpUpdateListsFromDB($con); echo gmdate('Y-m-d H:i:s') . " reconcilliation complete\n";