if ($_POST['send'] == 'MailChimpAPI') { $result = json_encode(MailChimpRequest($method, json_decode($data, true))); } else { if ($_POST['send'] == 'MailChimpUpdateLists') { MailChimpUpdateLists($con); $result = json_encode(MailChimpSqlResultToArray($con, 'select * from ctcweb9_ctc.mailchimp_lists')); } else { if ($_POST['send'] == 'MailChimpResetSubscription') { MailChimpResetSubscription($con); $result = json_encode($_POST['send']); } else { if ($_POST['send'] == 'MailChimpUpdateListFromDB') { $result = json_encode(MailChimpUpdateListFromDB($con, "054eb834c8")); } else { if ($_POST['send'] == 'SQL') { $result = json_encode(MailChimpSqlResultToArray($con, $data)); } else { if ($_POST['send'] == 'preg_replace') { $result = json_encode(preg_replace($method, $replace, $data)); } } } } } } ?> <html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <style>
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> </style> <script>