PHP MailChimpUpdateLists示例

示例#1

文件： mailchimp.inc.php 项目： ctcit/mailchimp

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'");
}

示例#2

文件： reconcilemailchimplists.php 项目： ctcit/mailchimp

<?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";