Create($crm_db,$crm_user,$crm_host,$crm_pass);
if($code=='SBAR' || $code=='EVENTREG')
{
if($mid)
{
$email = base64_decode($u);
$id = $mid;
echo"
IMPORTANT: If you opt to unsubscribe, you will be removed from all Section email lists.
If you are a member of more than one Section, you will be removed from other Section lists as well.
In addition to not receiving program notices and announcements, you will also not receive other
communications such as legislative alerts, electronic newsletters, etc.
If you still wish to unsubscribe please [click here].";
exit();
}
if($email)
{
$query = "insert into $BLASTER_LIST_UNSUBSCRIBE set
email_message_id = '$id',
email = '".ass(trim($email))."',
brand = '$code' ";
$sql->Insert($query);
echo"
$email has been unsubscribed from the list.
If you did not want to be unsubscribed please click [HERE] to remove yourself from the unsubscribe list.";
exit();
}
if($undo)
{
$query = "delete from $BLASTER_LIST_UNSUBSCRIBE
where email = '".ass(trim($email))."'
and brand = '$code' ";
$sql->Delete($query);
echo"
Your email address was removed from the unsubscribe list.";
exit();
}
exit();
}
if($code=='FFOOD')
{
$email = base64_decode($u);
$id = $mid;
$query = "insert into $BLASTER_LIST_UNSUBSCRIBE set
email_message_id = '$id',
email = '".ass(trim($email))."',
brand = '$code' ";
$sql->Insert($query);
$query = "select cdc_id from $CDC
where email = '".ass($email)."'
and email != ''
and company_name = ''
and brand = '$code' ";
$data = $crm->mydata($query);
for($a=0;$amydata($query);
}
echo"
$email has been unsubscribed from the list.
";
}
if($email)
{
$query = "delete from $BLASTER_LIST_UNSUBSCRIBE
where email = '".ass(trim($email))."'
and brand = '$code' ";
$sql->Delete($query);
echo"
Your email address was removed from the unsubscribe list.";
}
// QUERY_STRING
if($mid)
{
$email = base64_decode($u);
$id = $mid;
$query = "insert into $BLASTER_LIST_UNSUBSCRIBE set
email_message_id = '$id',
email = '".ass(trim($email))."',
brand = '$code' ";
$sql->Insert($query);
echo"
$email has been unsubscribed from the list.
If you did not want to be unsubscribed please click [HERE] to remove yourself from the unsubscribe list.";
}
exit();
?>