$encodedStr = $encodedStr . "+" . $seed_array[$num];
$encodedStr = base64_encode($encodedStr);
return $encodedStr;
}
date_default_timezone_set('America/Los_Angeles');
$db = new mysqldb();
// First lets check for any jobs which are a) Schedule for any time NOW or before AND b) Status is PENDING (0)
// Now we need member id of campaign... later we'll need list id... we can probably do this as part of the same query with a join
// while we're at it, let's get the message details?
$now = date('Y-m-d G:i:s', strtotime("now"));
$sql = "SELECT \r\nXJ.XE_JOB_ID AS JID,\r\nXJ.XE_JOB_CAMPAIGN_ID AS CID,\r\nXC.XE_CAMPAIGN_MID AS MID,\r\nXC.XE_CAMPAIGN_LIST_ID AS GID,\r\nXM.XE_MSG_FROM_LABEL AS FROM_LABEL,\r\nXM.XE_MSG_FROM_EMAIL AS FROM_EMAIL,\r\nXM.XE_MSG_SUBJECT AS SUBJECT,\r\nXM.XE_MSG_REPLY_TO AS REPLYTO,\r\nXM.XE_MSG_UNSUBSCRIBE AS UNSUBSCRIBE,\r\nXM.XE_MSG_POSTAL_ADDRESS AS ADDRESS,\r\nXM.XE_MSG_TEMPLATE_TEXT AS MSG_TXT,\r\nXM.XE_MSG_TEMPLATE_HTML AS MSG_HTML\r\nFROM XEBURA_JOBS AS XJ\r\nJOIN XEBURA_CAMPAIGN AS XC ON XJ.XE_JOB_CAMPAIGN_ID = XC.XE_CAMPAIGN_ID\r\nJOIN XEBURA_MESSAGE AS XM ON XJ.XE_JOB_CAMPAIGN_ID = XM.XE_MSG_CAMPAIGN_ID\r\nWHERE XE_JOB_LAUNCH <= '" . $now . "'\r\nAND XE_JOB_STATUS = '0'";
//job status 0 = pending
// now that we've got the campaigns, we need to loop over them..
$db->query($sql);
$result = $db->query($sql);
$total_items = $db->getNumRows($result);
if ($db->getNumRows($result) > 0) {
while (list($jid, $cid, $mid, $gid, $from_label, $from_email, $subject, $replyto, $unsubscribe, $address, $msg_txt, $msg_html) = $db->fetchQueryRow($result)) {
// get the amazon credentials for the campaign creator
$res = $db->query("SELECT\r\nXE_AMZ_ACCESS_KEY AS ACCESS_KEY,\r\nXE_AMZ_SECRET_KEY AS SECRET_KEY\r\nFROM XEBURA_AMAZON_CREDENTIALS\r\nWHERE XE_AMZ_MID = '" . $mid . "'");
$row = $db->fetchQueryArray($res);
$amz_akey = $row['ACCESS_KEY'];
$amz_skey = $row['SECRET_KEY'];
// intialize ses class
$ses = new SimpleEmailService($amz_akey, $amz_skey);
// now for our inner loop, let's find out who we're supposed to send this campaign out to, and loop over them.
// need to add check for sending allowed status on email record to this query later
// remove LIMIT
// update campaign as launched
$values = array(XE_CAMPAIGN_STATUS => '2');
// status 2 = launched
// Beverly Hills, CA 90211
// USA
// www.xebura.com
// hello@xebura.com
//============================================================+
/* If the session exists for a user and it accidently comes to the index page
then first it unsets the message on session. */
if (isset($_SESSION['SHOWMESSAGE'])) {
unset($_SESSION['SHOWMESSAGE']);
}
include "include/unsecure_includes.php";
if (isset($_REQUEST['username']) && trim($_REQUEST['username']) != "") {
$db = new mysqldb();
$sql = "select * from xebura_MEMBERS where USERNAME='******'username']) . "' and PASSWORD='******'password'])) . "' 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"];
/*include "online.php";
$row=$db->fetchQueryArray($result);
$aid=$row["AID"]; echo $aid;
$mid=$row["MID"];echo $mid;
//exit;
if($_POST['username']!="")
{
$users_online_read = fopen("$log_file", "r");
$users_online = fread($users_online_read, filesize("$log_file"));
fclose($users_online_read);
$users_online=explode("\n",$users_online);
$onl = new onlinedb();
}
if (@(!$smarty)) {
$smarty = new Smarty();
}
if (@(!$mailobj)) {
$mailobj = new MyEmail();
}
require_once 'language/smarty_assign.php';
if (!isset($hide_side_menu) || $hide_side_menu == true) {
require_once 'sidemenu_details.php';
}
require_once 'validation.php';
$query = "SELECT LOGIN_STATUS, IS_TEMP_PASSWORD FROM xebura_MEMBERS WHERE MID = '" . $_SESSION['Member_Id'] . "'";
$result = $db->query($query);
if ($db->getNumRows($result) > 0) {
$row = $db->fetchQueryArray($result);
$smarty->assign("first_time_login", $row['LOGIN_STATUS']);
if ($row['IS_TEMP_PASSWORD'] == 1) {
$smarty->assign("temp_pass", 1);
} else {
$smarty->assign("temp_pass", 0);
}
// echo $row['LOGIN_STATUS'].'-->'.$row['IS_TEMP_PASSWORD'];
if ($row['LOGIN_STATUS'] == 0 || $row['IS_TEMP_PASSWORD'] == 1) {
// Do not show menu
$show_user_menu = 0;
$topmenu_opt = array("Home");
$topmenu = array(_DASHBOARD);
} else {
// Show menu
