$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;