<?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";
$lists = MailChimpRequest("lists/list");
if ($_POST['update'] == 'Update') {
$listids = array();
foreach ($lists['data'] as &$list) {
if ($_POST[$list['id']] == 'on') {
$listids[] = "'" . $list['id'] . "'";
}
}
echo "{$userid} " . join(",", $listids) . "<br>";
$sql = "DELETE from ctcweb9_ctc.mailchimp_subscriptions where memberId = {$userid} and listid not in (" . join(",", $listids) . ")";
echo "<pre>{$sql}</pre>";
echo mysql_query($sql, $con) or die('delete');
$sql = "INSERT into ctcweb9_ctc.mailchimp_subscriptions(listid,memberid)\n\t\t\tSELECT listid,{$userid} \n\t\t\tFROM ctcweb9_ctc.mailchimp_lists\n\t\t\tWHERE listid in (" . join(",", $listids) . ")\n\t\t\tAND listid not in (select listid from ctcweb9_ctc.mailchimp_subscriptions where memberid = {$userid})";
echo "<pre>{$sql}</pre>";
echo mysql_query($sql, $con) or die('insert');
$result = MailChimpUpdateListsFromDB($con);
} else {
$result = array("Waiting");
}
echo json_encode(MailChimpSqlResultToArray($con, "select ml.listname, ms.* \n\t\t\t\t\t\tfrom ctcweb9_ctc.mailchimp_subscriptions ms\n\t\t\t\t\t\tjoin ctcweb9_ctc.mailchimp_lists ml on ml.listid = ms.listid\n\t\t\t\t\t\twhere memberId = {$userid}"));
foreach ($lists['data'] as &$list) {
$memberinfoargs = array("id" => $list['id'], "emails" => array(array("email" => $email)));
$memberinfo = MailChimpRequest("lists/member-info", $memberinfoargs);
$list['is_subscribed'] = sizeof($memberinfo['data']) > 0;
}
?>
<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<style>
