PHP/Curl/MySQL Script for Interspire Email Marketer
$100-200 USD
In Progress
Posted over 11 years ago
$100-200 USD
Paid on delivery
We need a plugin for Interspire Email Marketer that can accomplish Global Unsubscribes. While there is no built in support for this in the GUI, it is possible to ban someone from receiving further emails via the API.
Generally we need a script to do the following:
1 - Receive an email via pipe, search for the unsubscribe link, and parse out the confirmation code.
(e.g. [[login to view URL]][1] in this case [4caa8d761ccdb44e959e271906821758][1] is the confirmation code)
2 - Connect to the DB using the existing MySQL creds present in Interspire Email Marketer's [login to view URL]
3 - Query the email_list_subscribers table for the confirmation code in the confirmcode column, and return the email address associated with it in the emailaddress column.
4 - Post the email address to the API to Ban it .. sort of like this:
if (isset($_POST['email'])) {
if (!defined('IEM_NO_CONTROLLER')) {
define('IEM_NO_CONTROLLER', true);
}
include_once('/path/to/iem/admin/[login to view URL]');
include_once('/path/to/iem/admin/functions/api/[login to view URL]');
$email = trim($_POST['email']);
$api = new Subscribers_API();
$api->AddBannedSubscriber($email, 'g');
}
5 - I think that's it, but you if you get the general idea and can do this it would save me some time.
Thanks!