public static function addtoNewsLetterSubscriptionList($email = '')
{
global $tableprefix;
if (!empty($email)) {
// Check email address exists in subscribers list
$resCat = DbHelper::execute("SELECT nId FROM " . $tableprefix . "newsletter_subscribers WHERE vEmail ='" . mysql_real_escape_string($email) . "' ");
$data = DbHelper::fetchOne($resCat);
// If alraedy exists return false
if ($data) {
$emailSubscribed = 'exists';
} else {
// Insert Email id to subscriberlist
$resInsert = DbHelper::execute("INSERT INTO " . $tableprefix . "newsletter_subscribers\n (vEmail)VALUES('" . mysql_real_escape_string($email) . "')");
$constantcontactSettings = getconstantcontactSettings();
$_SESSION['constantaction'] = 'Add Email';
$userinfo = array();
$userinfo['emailAddress'] = mysql_real_escape_string($email);
$userinfo['firstName'] = '';
$userinfo['lastName'] = '';
$userinfo['lists'] = array($constantcontactSettings['constantcontactlistId']);
$_SESSION['constantparam']['redirecturl'] = SITE_URL . '/checkout.php';
//header("location:".$constantcontactSettings['verificationURL']);
$emailSubscribed = 'added';
}
return $emailSubscribed;
}
}
$_SESSION['constantparam']['redirecturl'] = SITE_URL . '/index.php';
header("location:" . $constantcontactSettings['verificationURL']);
exit;
}
//header("Location:index.php");
//exit;
}
} else {
// End
if ($wishMessage == 'Product added successfully!') {
header("Location:" . SITE_URL . "/mywishlist.php");
exit;
}
if ($check_news == 'Y') {
$_SESSION['constantaction'] = 'Add Email';
$constantcontactSettings = getconstantcontactSettings();
$userinfo = array();
$userinfo['emailAddress'] = $txtEmail;
$userinfo['firstName'] = $txtFirstName;
$userinfo['lastName'] = $txtLastName;
$userinfo['lists'] = array($constantcontactSettings['constantcontactlistId']);
// print_r($userinfo);exit;
$_SESSION['constantparam']['data'] = $userinfo;
$_SESSION['constantparam']['redirecturl'] = SITE_URL . '/index.php';
header("location:" . $constantcontactSettings['verificationURL']);
exit;
}
//header("Location:index.php");
}
//$message = "Registration successfully completed! Please <a class=links href='login.php'><b>login here</b>.</a>";
/*----------Multicart2.0 Upgradation---------------*/
