$msg = "Invalid Username and Password or Inactive Account. Try again...";
}
} else {
if (isset($_GET['m']) && isset($_GET['id'])) {
$mid = decode($_GET['id']);
if ($mid > 0) {
$sql = "select * from xebura_MEMBERS where MID='" . $mid . "' AND ACCOUNT_STATUS ='1'";
$result = $db->query($sql);
$num = $db->getNumRows($result);
if ($num > 0) {
$row = $db->fetchQueryArray($result);
$aid = $row["AID"];
$mid = $row["MID"];
$Mes_Id = decode($_REQUEST['m']);
if ($Mes_Id > 0) {
$Mes_Id = $db->select_single_value("xebura_MESSAGE", "AF_MESSAGE_ID", " WHERE AF_MESSAGE_ID='" . $Mes_Id . "' and AF_MESSAGE_RECEIVER='" . $mid . "' ");
if ($Mes_Id > 0) {
$_SESSION['Username'] = $row['USERNAME'];
$_SESSION['Password'] = base64_decode($row['PASSWORD']);
$_SESSION['First_Name'] = ucwords($row['FIRSTNAME']) . " " . ucwords($row['LASTNAME']);
$_SESSION['Member_Id'] = $mid;
$_SESSION['Account_Id'] = $aid;
$lastlogin = array('LAST_LOGIN' => date('Y-m-d'), 'LOGIN_TIME' => date('H:i:s'));
$db->update("xebura_MEMBERS", $lastlogin, " where MID='" . $mid . "' ");
include "online.php";
$_SESSION['Nav_Menu'] = "Mail";
$page = 'view_message.php?Mes_Id=' . $_REQUEST['m'];
header("Location:{$page}");
exit;
} else {
$msg = "Invalid Link.Try again..";
// USA
// www.xebura.com
// hello@xebura.com
//============================================================+
// This script unsubscribes ppl....
// it needs a UI
require 'class/dbclass.php';
include_once 'include/config.php';
require 'include/ses.php';
date_default_timezone_set('America/Los_Angeles');
$db = new mysqldb();
$now = date('Y-m-d G:i:s', strtotime("now"));
$ip = $_SERVER['REMOTE_ADDR'];
$eid = $_REQUEST['i'];
$cid = $_REQUEST['s'];
$mid = $db->select_single_value("XEBURA_CAMPAIGN", "XE_CAMPAIGN_MID", "WHERE XE_CAMPAIGN_ID = '" . $cid . "'");
// before we try to unsub the email id, let's check if it is already unsubscribed
$sql = "SELECT * FROM XEBURA_MASTER_LIST WHERE XE_ADDRESS_ID = '" . $eid . "' AND XE_ADDRESS_OPT_STATUS = '2'";
$db->query($sql);
$result = $db->query($sql);
if ($db->getNumRows($result) > 0) {
echo "You are already unsubscribed from this list. If you're still receiving emails from this sender, please contact our consumer relations team at abuse@xebura.com";
} else {
// unsubscribe the email address from the master list
$values = array(XE_ADDRESS_OPT_STATUS => '2');
$db->update("XEBURA_MASTER_LIST", $values, "WHERE XE_ADDRESS_ID = '" . $eid . "'");
//echo "Step 1 - Unsubscribe from Master List - DONE |";
// log the event to the statistics table
$values = array(XE_STAT_CAMPAIGN_ID => $cid, XE_STAT_MID => $mid, XE_STAT_EMAIL_ID => $eid, XE_STAT_TYPE => '4', XE_STAT_IP => $ip, XE_STAT_TIMESTAMP => $now);
$stat = $db->insert("XEBURA_STATISTICS", $values);
echo "You have been unsubscribed from this list successfully and will no longer receive email from this sender.";
$partnermid = $_SESSION['Member_Id'];
$accresult2 = $db->query("Select PARTNER_ID from xebura_MEMBERS where MID='" . $partnermid . "'");
$erows = $db->fetchQueryArray($accresult2);
$partnerid = $erows['PARTNER_ID'];
$smarty->assign("partnerid", $partnerid);
// GET MEMBER INFO FOR TRACKING IN REINVIGORATE ANALYTICS JLR
$sql = $db->query("Select FIRSTNAME,LASTNAME,CONTACT_EMAIL from xebura_MEMBERS where MID='" . $partnermid . "'");
$rows = $db->fetchQueryArray($sql);
$fname = $rows['FIRSTNAME'];
$lname = $rows['LASTNAME'];
$active_member_name = $fname . " " . $lname;
$active_member_email = $rows['CONTACT_EMAIL'];
$smarty->assign("active_member_name", $active_member_name);
$smarty->assign("active_member_email", $active_member_email);
$where_clause = "WHERE MID = '" . $partnermid . "'";
$available_credit = $db->select_single_value("xebura_MEMBERS", "TI_CREDIT_BALANCE", "{$where_clause}");
$smarty->assign('available_credit', $available_credit);
//echo "sublevel: $sublevel2";
//echo "is free: $isfree";
//echo "limit: $limitresults";
//echo "mid: $testingmid";
require_once 'random_quote.php';
function ShortenText($text)
{
// Change to the number of characters you want to display
$chars = 40;
$charslen = strlen($text);
if ($charslen > 40) {
$text = $text . " ";
$text = substr($text, 0, $chars);
$text = substr($text, 0, strrpos($text, ' '));
$decoded = base64_decode($decodedStr);
list($decoded, $letter) = split("\\+", $decoded);
for ($i = 0; $i < count($seed_array); $i++) {
if ($seed_array[$i] == $letter) {
break;
}
}
for ($j = 1; $j <= $i; $j++) {
$decoded = base64_decode($decoded);
}
return $decoded;
}
$fname = "";
$db = new mysqldb();
$cid = decode($_REQUEST['c']);
$html = $db->select_single_value("XEBURA_MESSAGE", "XE_MSG_TEMPLATE_HTML", "WHERE XE_MSG_CAMPAIGN_ID='" . $cid . "'");
$final_html = str_replace('{FNAME}', $fname, $html);
$title = $db->select_single_value("XEBURA_MESSAGE", "XE_MSG_SUBJECT", "WHERE XE_MSG_CAMPAIGN_ID='" . $cid . "'");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php
echo $title;
?>
</title>
</head>
<body>
<?php
echo $final_html;
